danielebarchiesi@0
|
1 <?php
|
danielebarchiesi@0
|
2
|
danielebarchiesi@0
|
3 /**
|
danielebarchiesi@0
|
4 * @file
|
danielebarchiesi@0
|
5 * Provides several different handlers for exporting webform results.
|
danielebarchiesi@0
|
6 */
|
danielebarchiesi@0
|
7
|
danielebarchiesi@0
|
8 /**
|
danielebarchiesi@0
|
9 * Implements hook_webform_exporters().
|
danielebarchiesi@0
|
10 *
|
danielebarchiesi@0
|
11 * Defines the exporters this module implements.
|
danielebarchiesi@0
|
12 *
|
danielebarchiesi@0
|
13 * @return
|
danielebarchiesi@0
|
14 * An "array of arrays", keyed by content-types. The 'handler' slot
|
danielebarchiesi@0
|
15 * should point to the PHP class implementing this flag.
|
danielebarchiesi@0
|
16 */
|
danielebarchiesi@0
|
17 function webform_webform_exporters() {
|
danielebarchiesi@0
|
18 return array(
|
danielebarchiesi@0
|
19 'delimited' => array(
|
danielebarchiesi@0
|
20 'title' => t('Delimited text'),
|
danielebarchiesi@0
|
21 'description' => t('A plain text file delimited by commas, tabs, or other characters.'),
|
danielebarchiesi@0
|
22 'handler' => 'webform_exporter_delimited',
|
danielebarchiesi@0
|
23 ),
|
danielebarchiesi@0
|
24 'excel' => array(
|
danielebarchiesi@0
|
25 'title' => t('Microsoft Excel'),
|
danielebarchiesi@0
|
26 'description' => t('A file readable by Microsoft Excel.'),
|
danielebarchiesi@0
|
27 'handler' => 'webform_exporter_excel',
|
danielebarchiesi@0
|
28 ),
|
danielebarchiesi@0
|
29 );
|
danielebarchiesi@0
|
30 }
|
danielebarchiesi@0
|
31
|
danielebarchiesi@0
|
32 /**
|
danielebarchiesi@0
|
33 * Return a list of exporters suitable for display in a select list.
|
danielebarchiesi@0
|
34 */
|
danielebarchiesi@0
|
35 function webform_export_list() {
|
danielebarchiesi@0
|
36 $exporters = webform_export_fetch_definition();
|
danielebarchiesi@0
|
37 $list = array();
|
danielebarchiesi@0
|
38 foreach ($exporters as $name => $exporter) {
|
danielebarchiesi@0
|
39 $list[$name] = $exporter['title'];
|
danielebarchiesi@0
|
40 }
|
danielebarchiesi@0
|
41 return $list;
|
danielebarchiesi@0
|
42 }
|
danielebarchiesi@0
|
43
|
danielebarchiesi@0
|
44 /**
|
danielebarchiesi@0
|
45 * Returns a Webform exporter definition.
|
danielebarchiesi@0
|
46 */
|
danielebarchiesi@0
|
47 function webform_export_fetch_definition($format = NULL) {
|
danielebarchiesi@0
|
48 static $cache;
|
danielebarchiesi@0
|
49 if (!isset($cache)) {
|
danielebarchiesi@0
|
50 $cache = module_invoke_all('webform_exporters');
|
danielebarchiesi@0
|
51 }
|
danielebarchiesi@0
|
52
|
danielebarchiesi@0
|
53 if (isset($format)) {
|
danielebarchiesi@0
|
54 if (isset($cache[$format])) {
|
danielebarchiesi@0
|
55 return $cache[$format];
|
danielebarchiesi@0
|
56 }
|
danielebarchiesi@0
|
57 }
|
danielebarchiesi@0
|
58 else {
|
danielebarchiesi@0
|
59 return $cache;
|
danielebarchiesi@0
|
60 }
|
danielebarchiesi@0
|
61 }
|
danielebarchiesi@0
|
62
|
danielebarchiesi@0
|
63 /**
|
danielebarchiesi@0
|
64 * Instantiates a new Webform handler based on the format.
|
danielebarchiesi@0
|
65 */
|
danielebarchiesi@0
|
66 function webform_export_create_handler($format, $options) {
|
danielebarchiesi@0
|
67 $definition = webform_export_fetch_definition($format);
|
danielebarchiesi@0
|
68 if (isset($definition) && class_exists($definition['handler'])) {
|
danielebarchiesi@0
|
69 $handler = new $definition['handler']($options);
|
danielebarchiesi@0
|
70 }
|
danielebarchiesi@0
|
71 else {
|
danielebarchiesi@0
|
72 // TODO: Create a default broken exporter.
|
danielebarchiesi@0
|
73 $handler = new webform_exporter_broken($options);
|
danielebarchiesi@0
|
74 }
|
danielebarchiesi@0
|
75
|
danielebarchiesi@0
|
76 return $handler;
|
danielebarchiesi@0
|
77 }
|
danielebarchiesi@0
|
78
|
danielebarchiesi@0
|
79 class webform_exporter {
|
danielebarchiesi@0
|
80 function add_row(&$file_handle, $data) {
|
danielebarchiesi@0
|
81 }
|
danielebarchiesi@0
|
82
|
danielebarchiesi@0
|
83 function set_headers($filename) {
|
danielebarchiesi@0
|
84 drupal_add_http_header('Content-Type', 'application/force-download');
|
danielebarchiesi@0
|
85 drupal_add_http_header('Pragma', 'public');
|
danielebarchiesi@0
|
86 drupal_add_http_header('Cache-Control', 'max-age=0');
|
danielebarchiesi@0
|
87 }
|
danielebarchiesi@0
|
88
|
danielebarchiesi@0
|
89 function bof(&$file_handle) {
|
danielebarchiesi@0
|
90 }
|
danielebarchiesi@0
|
91
|
danielebarchiesi@0
|
92 function eof(&$file_handle) {
|
danielebarchiesi@0
|
93 }
|
danielebarchiesi@0
|
94 }
|
danielebarchiesi@0
|
95
|
danielebarchiesi@0
|
96 class webform_exporter_delimited extends webform_exporter {
|
danielebarchiesi@0
|
97 var $delimiter;
|
danielebarchiesi@0
|
98
|
danielebarchiesi@0
|
99 function webform_exporter_delimited($options) {
|
danielebarchiesi@0
|
100 $this->delimiter = isset($options['delimiter']) ? $options['delimiter'] : ',';
|
danielebarchiesi@0
|
101 // Convert tabs.
|
danielebarchiesi@0
|
102 if ($this->delimiter == '\t') {
|
danielebarchiesi@0
|
103 $this->delimiter = "\t";
|
danielebarchiesi@0
|
104 }
|
danielebarchiesi@0
|
105 }
|
danielebarchiesi@0
|
106
|
danielebarchiesi@0
|
107 function bof(&$file_handle) {
|
danielebarchiesi@0
|
108 $output = '';
|
danielebarchiesi@0
|
109
|
danielebarchiesi@0
|
110 // Include at BOM at the beginning of the file for Little Endian.
|
danielebarchiesi@0
|
111 // This makes tab-separated imports work correctly in MS Excel.
|
danielebarchiesi@0
|
112 if (function_exists('mb_convert_encoding') && $this->delimiter == "\t") {
|
danielebarchiesi@0
|
113 $output = chr(255) . chr(254);
|
danielebarchiesi@0
|
114 }
|
danielebarchiesi@0
|
115 @fwrite($file_handle, $output);
|
danielebarchiesi@0
|
116 }
|
danielebarchiesi@0
|
117
|
danielebarchiesi@0
|
118 function add_row(&$file_handle, $data) {
|
danielebarchiesi@0
|
119 foreach ($data as $key => $value) {
|
danielebarchiesi@0
|
120 // Escape inner quotes and wrap all contents in new quotes.
|
danielebarchiesi@0
|
121 $data[$key] = '"' . str_replace('"', '""', $data[$key]) . '"';
|
danielebarchiesi@0
|
122
|
danielebarchiesi@0
|
123 // Remove <script> tags, which mysteriously cause Excel not to import.
|
danielebarchiesi@0
|
124 $data[$key] = preg_replace('!<(/?script.*?)>!', '[$1]', $data[$key]);
|
danielebarchiesi@0
|
125 }
|
danielebarchiesi@0
|
126 $row = implode($this->delimiter, $data) . "\n";
|
danielebarchiesi@0
|
127
|
danielebarchiesi@0
|
128 if (function_exists('mb_convert_encoding')) {
|
danielebarchiesi@0
|
129 $row = mb_convert_encoding($row, 'UTF-16LE', 'UTF-8');
|
danielebarchiesi@0
|
130 }
|
danielebarchiesi@0
|
131
|
danielebarchiesi@0
|
132 @fwrite($file_handle, $row);
|
danielebarchiesi@0
|
133 }
|
danielebarchiesi@0
|
134
|
danielebarchiesi@0
|
135 function set_headers($filename) {
|
danielebarchiesi@0
|
136 parent::set_headers($filename);
|
danielebarchiesi@0
|
137
|
danielebarchiesi@0
|
138 // Convert tabs.
|
danielebarchiesi@0
|
139 if ($this->delimiter == "\t") {
|
danielebarchiesi@0
|
140 $extension = 'tsv';
|
danielebarchiesi@0
|
141 $content_type = 'text/tab-separated-values';
|
danielebarchiesi@0
|
142 }
|
danielebarchiesi@0
|
143 else {
|
danielebarchiesi@0
|
144 $extension = 'csv';
|
danielebarchiesi@0
|
145 $content_type = 'text/csv';
|
danielebarchiesi@0
|
146 }
|
danielebarchiesi@0
|
147
|
danielebarchiesi@0
|
148 drupal_add_http_header('Content-Type', $content_type);
|
danielebarchiesi@0
|
149 drupal_add_http_header('Content-Disposition', "attachment; filename=$filename.$extension");
|
danielebarchiesi@0
|
150 }
|
danielebarchiesi@0
|
151 }
|
danielebarchiesi@0
|
152
|
danielebarchiesi@0
|
153 /**
|
danielebarchiesi@0
|
154 * The Excel exporter currently is just a tab-delimited export.
|
danielebarchiesi@0
|
155 */
|
danielebarchiesi@0
|
156 class webform_exporter_excel extends webform_exporter_delimited {
|
danielebarchiesi@0
|
157 var $delimiter;
|
danielebarchiesi@0
|
158
|
danielebarchiesi@0
|
159 function webform_exporter_excel($options) {
|
danielebarchiesi@0
|
160 $options['delimiter'] = '\t';
|
danielebarchiesi@0
|
161 parent::webform_exporter_delimited($options);
|
danielebarchiesi@0
|
162 }
|
danielebarchiesi@0
|
163
|
danielebarchiesi@0
|
164 function set_headers($filename) {
|
danielebarchiesi@0
|
165 drupal_add_http_header('Content-Type', 'application/x-msexcel');
|
danielebarchiesi@0
|
166 drupal_add_http_header('Content-Disposition', "attachment; filename=$filename.xls");
|
danielebarchiesi@0
|
167 drupal_add_http_header('Pragma', 'public');
|
danielebarchiesi@0
|
168 drupal_add_http_header('Cache-Control', 'max-age=0');
|
danielebarchiesi@0
|
169 }
|
danielebarchiesi@0
|
170 }
|