annotate sites/all/modules/webform/includes/webform.export.inc @ 11:b0ee71395280

deleted .DS_Store files
author danieleb <danielebarchiesi@me.com>
date Mon, 28 Oct 2013 16:12:13 +0000
parents ff03f76ab3fe
children
rev   line source
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 }