1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
<?php
require_once 'Horde/Data/csv.php';
/**
* Horde_Data implementation for Outlook comma-separated data (CSV).
*
* $Horde: framework/Data/Data/outlookcsv.php,v 1.3.10.3 2005/10/18 11:01:04 jan Exp $
*
* @package Horde_Data
*/
class Horde_Data_outlookcsv extends Horde_Data_csv {
/**
* Builds a CSV file from a given data structure and returns it as a
* string.
*
* @param array $data A two-dimensional array containing the data
* set.
* @param boolean $header If true, the rows of $data are associative
* arrays with field names as their keys.
*
* @return string The CSV data.
*/
function exportData($data, $header = false, $export_mapping = array())
{
if (!is_array($data) || count($data) == 0) {
return '';
}
$export = '';
$eol = "\r\n";
$head = array_keys(current($data));
if ($header) {
foreach ($head as $key) {
if (!empty($key)) {
if (isset($export_mapping[$key])) {
$key = $export_mapping[$key];
}
$export .= '"' . $key . '"';
}
$export .= ',';
}
$export = substr($export, 0, -1) . $eol;
}
foreach ($data as $row) {
foreach ($head as $key) {
$cell = $row[$key];
if (!empty($cell) || $cell === 0) {
$cell = preg_replace("/\"/", "\"\"", $cell);
$export .= '"' . $cell . '"';
}
$export .= ',';
}
$export = substr($export, 0, -1) . $eol;
}
return $export;
}
}
|
