danielebarchiesi@0
|
1 <?php
|
danielebarchiesi@0
|
2
|
danielebarchiesi@0
|
3 /**
|
danielebarchiesi@0
|
4 * @file
|
danielebarchiesi@0
|
5 * Webform module time component.
|
danielebarchiesi@0
|
6 */
|
danielebarchiesi@0
|
7
|
danielebarchiesi@0
|
8 // Time depends on functions provided by date.
|
danielebarchiesi@0
|
9 webform_component_include('date');
|
danielebarchiesi@0
|
10
|
danielebarchiesi@0
|
11 /**
|
danielebarchiesi@0
|
12 * Implements _webform_defaults_component().
|
danielebarchiesi@0
|
13 */
|
danielebarchiesi@0
|
14 function _webform_defaults_time() {
|
danielebarchiesi@0
|
15 return array(
|
danielebarchiesi@0
|
16 'name' => '',
|
danielebarchiesi@0
|
17 'form_key' => NULL,
|
danielebarchiesi@0
|
18 'pid' => 0,
|
danielebarchiesi@0
|
19 'weight' => 0,
|
danielebarchiesi@0
|
20 'value' => '',
|
danielebarchiesi@0
|
21 'mandatory' => 0,
|
danielebarchiesi@0
|
22 'extra' => array(
|
danielebarchiesi@0
|
23 'timezone' => 'user',
|
danielebarchiesi@0
|
24 'hourformat' => '12-hour',
|
danielebarchiesi@0
|
25 'minuteincrements' => 1,
|
danielebarchiesi@0
|
26 'title_display' => 0,
|
danielebarchiesi@0
|
27 'description' => '',
|
danielebarchiesi@0
|
28 'private' => FALSE,
|
danielebarchiesi@0
|
29 ),
|
danielebarchiesi@0
|
30 );
|
danielebarchiesi@0
|
31 }
|
danielebarchiesi@0
|
32
|
danielebarchiesi@0
|
33 /**
|
danielebarchiesi@0
|
34 * Implements _webform_theme_component().
|
danielebarchiesi@0
|
35 */
|
danielebarchiesi@0
|
36 function _webform_theme_time() {
|
danielebarchiesi@0
|
37 return array(
|
danielebarchiesi@0
|
38 'webform_time' => array(
|
danielebarchiesi@0
|
39 'render element' => 'element',
|
danielebarchiesi@0
|
40 'file' => 'components/time.inc',
|
danielebarchiesi@0
|
41 ),
|
danielebarchiesi@0
|
42 'webform_display_time' => array(
|
danielebarchiesi@0
|
43 'render element' => 'element',
|
danielebarchiesi@0
|
44 'file' => 'components/time.inc',
|
danielebarchiesi@0
|
45 ),
|
danielebarchiesi@0
|
46 );
|
danielebarchiesi@0
|
47 }
|
danielebarchiesi@0
|
48
|
danielebarchiesi@0
|
49 /**
|
danielebarchiesi@0
|
50 * Implements _webform_edit_component().
|
danielebarchiesi@0
|
51 */
|
danielebarchiesi@0
|
52 function _webform_edit_time($component) {
|
danielebarchiesi@0
|
53 $form = array();
|
danielebarchiesi@0
|
54 $form['value'] = array(
|
danielebarchiesi@0
|
55 '#type' => 'textfield',
|
danielebarchiesi@0
|
56 '#title' => t('Default value'),
|
danielebarchiesi@0
|
57 '#default_value' => $component['value'],
|
danielebarchiesi@0
|
58 '#description' => t('The default value of the field.') . '<br />' . t('Accepts a time in any <a href="http://www.gnu.org/software/tar/manual/html_chapter/Date-input-formats.html">GNU Date Input Format</a>. Strings such as now, +2 hours, and 10:30pm are all valid.'),
|
danielebarchiesi@0
|
59 '#size' => 60,
|
danielebarchiesi@0
|
60 '#maxlength' => 127,
|
danielebarchiesi@0
|
61 '#weight' => 0,
|
danielebarchiesi@0
|
62 );
|
danielebarchiesi@0
|
63 $form['extra']['timezone'] = array(
|
danielebarchiesi@0
|
64 '#type' => 'radios',
|
danielebarchiesi@0
|
65 '#title' => t('Default value timezone'),
|
danielebarchiesi@0
|
66 '#default_value' => $component['extra']['timezone'],
|
danielebarchiesi@0
|
67 '#description' => t('If using relative dates for a default value (e.g. "now") base the current time on this timezone.'),
|
danielebarchiesi@0
|
68 '#options' => array('user' => t('User timezone'), 'site' => t('Website timezone')),
|
danielebarchiesi@0
|
69 '#weight' => 2,
|
danielebarchiesi@0
|
70 '#access' => variable_get('configurable_timezones', 1),
|
danielebarchiesi@0
|
71 );
|
danielebarchiesi@0
|
72 $form['display']['hourformat'] = array(
|
danielebarchiesi@0
|
73 '#type' => 'radios',
|
danielebarchiesi@0
|
74 '#title' => t('Time format'),
|
danielebarchiesi@0
|
75 '#default_value' => $component['extra']['hourformat'],
|
danielebarchiesi@0
|
76 '#options' => array('12-hour' => t('12-hour (am/pm)'), '24-hour' => t('24-hour')),
|
danielebarchiesi@0
|
77 '#weight' => 2,
|
danielebarchiesi@0
|
78 '#parents' => array('extra', 'hourformat'),
|
danielebarchiesi@0
|
79 );
|
danielebarchiesi@0
|
80 $form['display']['minuteincrements'] = array(
|
danielebarchiesi@0
|
81 '#type' => 'select',
|
danielebarchiesi@0
|
82 '#title' => t('Minute increments'),
|
danielebarchiesi@0
|
83 '#default_value' => $component['extra']['minuteincrements'],
|
danielebarchiesi@0
|
84 '#options' => array(
|
danielebarchiesi@0
|
85 1 => t('1 minute'),
|
danielebarchiesi@0
|
86 5 => t('5 minute'),
|
danielebarchiesi@0
|
87 10 => t('10 minute'),
|
danielebarchiesi@0
|
88 15 => t('15 minute'),
|
danielebarchiesi@0
|
89 30 => t('30 minute'),
|
danielebarchiesi@0
|
90 ),
|
danielebarchiesi@0
|
91 '#weight' => 3,
|
danielebarchiesi@0
|
92 '#parents' => array('extra', 'minuteincrements'),
|
danielebarchiesi@0
|
93 );
|
danielebarchiesi@0
|
94 return $form;
|
danielebarchiesi@0
|
95 }
|
danielebarchiesi@0
|
96
|
danielebarchiesi@0
|
97 /**
|
danielebarchiesi@0
|
98 * Implements _webform_render_component().
|
danielebarchiesi@0
|
99 */
|
danielebarchiesi@0
|
100 function _webform_render_time($component, $value = NULL, $filter = TRUE) {
|
danielebarchiesi@0
|
101 $node = isset($component['nid']) ? node_load($component['nid']) : NULL;
|
danielebarchiesi@0
|
102
|
danielebarchiesi@0
|
103 $element = array(
|
danielebarchiesi@0
|
104 '#type' => 'webform_time',
|
danielebarchiesi@0
|
105 '#title' => $filter ? _webform_filter_xss($component['name']) : $component['name'],
|
danielebarchiesi@0
|
106 '#title_display' => $component['extra']['title_display'] ? $component['extra']['title_display'] : 'before',
|
danielebarchiesi@0
|
107 '#required' => $component['mandatory'],
|
danielebarchiesi@0
|
108 '#weight' => $component['weight'],
|
danielebarchiesi@0
|
109 '#description' => $filter ? _webform_filter_descriptions($component['extra']['description'], $node) : $component['extra']['description'],
|
danielebarchiesi@0
|
110 '#element_validate' => array('webform_validate_time'),
|
danielebarchiesi@0
|
111 '#hourformat' => $component['extra']['hourformat'],
|
danielebarchiesi@0
|
112 '#minuteincrements' => $component['extra']['minuteincrements'],
|
danielebarchiesi@0
|
113 '#default_value' => $filter ? _webform_filter_values($component['value'], $node, NULL, NULL, FALSE) : $component['value'],
|
danielebarchiesi@0
|
114 '#timezone' => $component['extra']['timezone'],
|
danielebarchiesi@0
|
115 '#process' => array('webform_expand_time'),
|
danielebarchiesi@0
|
116 '#theme' => 'webform_time',
|
danielebarchiesi@0
|
117 '#theme_wrappers' => array('webform_element'),
|
danielebarchiesi@0
|
118 '#translatable' => array('title', 'description'),
|
danielebarchiesi@0
|
119 );
|
danielebarchiesi@0
|
120
|
danielebarchiesi@0
|
121 // Set the value from Webform if available.
|
danielebarchiesi@0
|
122 if (!empty($value[0])) {
|
danielebarchiesi@0
|
123 $element['#default_value'] = $value[0];
|
danielebarchiesi@0
|
124 }
|
danielebarchiesi@0
|
125
|
danielebarchiesi@0
|
126 return $element;
|
danielebarchiesi@0
|
127 }
|
danielebarchiesi@0
|
128
|
danielebarchiesi@0
|
129 /**
|
danielebarchiesi@0
|
130 * Form API #process function for Webform time fields.
|
danielebarchiesi@0
|
131 */
|
danielebarchiesi@0
|
132 function webform_expand_time($element) {
|
danielebarchiesi@0
|
133 // Expand the default value from a string into an array.
|
danielebarchiesi@0
|
134 if (!empty($element['#default_value'])) {
|
danielebarchiesi@0
|
135 // Adjust the time based on the user or site timezone.
|
danielebarchiesi@0
|
136 if (variable_get('configurable_timezones', 1) && $element['#timezone'] == 'user') {
|
danielebarchiesi@0
|
137 $timezone_name = isset($GLOBALS['user']->timezone) ? $GLOBALS['user']->timezone : 'UTC';
|
danielebarchiesi@0
|
138 }
|
danielebarchiesi@0
|
139 else {
|
danielebarchiesi@0
|
140 $timezone_name = variable_get('date_default_timezone', 'UTC');
|
danielebarchiesi@0
|
141 }
|
danielebarchiesi@0
|
142
|
danielebarchiesi@0
|
143 $default_values = webform_date_array(webform_strtodate('c', $element['#default_value'], $timezone_name), 'time');
|
danielebarchiesi@0
|
144 }
|
danielebarchiesi@0
|
145 else {
|
danielebarchiesi@0
|
146 $default_values = array(
|
danielebarchiesi@0
|
147 'hour' => '',
|
danielebarchiesi@0
|
148 'minute' => '',
|
danielebarchiesi@0
|
149 'second' => '',
|
danielebarchiesi@0
|
150 );
|
danielebarchiesi@0
|
151 }
|
danielebarchiesi@0
|
152
|
danielebarchiesi@0
|
153 $first_hour = 0;
|
danielebarchiesi@0
|
154 $last_hour = 23;
|
danielebarchiesi@0
|
155 if ($element['#hourformat'] == '12-hour') {
|
danielebarchiesi@0
|
156 $first_hour = 1;
|
danielebarchiesi@0
|
157 $last_hour = 12;
|
danielebarchiesi@0
|
158 $default_values = webform_time_convert($default_values, '12-hour');
|
danielebarchiesi@0
|
159 $default_values['ampm'] = $default_values['ampm'] ? $default_values['ampm'] : 'am';
|
danielebarchiesi@0
|
160 }
|
danielebarchiesi@0
|
161
|
danielebarchiesi@0
|
162 // Generate the choices for drop-down selects.
|
danielebarchiesi@0
|
163 $hours[''] = t('hour');
|
danielebarchiesi@0
|
164 $minutes[''] = t('minute');
|
danielebarchiesi@0
|
165 for ($i = $first_hour; $i <= $last_hour; $i++) {
|
danielebarchiesi@0
|
166 $hours[$i] = $i;
|
danielebarchiesi@0
|
167 }
|
danielebarchiesi@0
|
168 for ($i = 0; $i <= 59; $i += $element['#minuteincrements']) {
|
danielebarchiesi@0
|
169 $minutes[$i] = $i < 10 ? "0$i" : $i;
|
danielebarchiesi@0
|
170 }
|
danielebarchiesi@0
|
171 $ampms = array('am' => t('am'), 'pm' => t('pm'));
|
danielebarchiesi@0
|
172
|
danielebarchiesi@0
|
173 // Adjust the default for minutes if needed, rounding up to the closest value.
|
danielebarchiesi@0
|
174 if (!isset($minutes[$default_values['minute']])) {
|
danielebarchiesi@0
|
175 foreach ($minutes as $minute => $padded_minute) {
|
danielebarchiesi@0
|
176 if ($minute > $default_values['minute']) {
|
danielebarchiesi@0
|
177 $default_values['minute'] = $minute;
|
danielebarchiesi@0
|
178 break;
|
danielebarchiesi@0
|
179 }
|
danielebarchiesi@0
|
180 }
|
danielebarchiesi@0
|
181 }
|
danielebarchiesi@0
|
182
|
danielebarchiesi@0
|
183 // If the above loop didn't set a value, it's because rounding up would go to
|
danielebarchiesi@0
|
184 // the next hour. This gets quite a bit more complicated, since we need to
|
danielebarchiesi@0
|
185 // deal with looping around on hours, as well as flipping am/pm.
|
danielebarchiesi@0
|
186 if (!isset($minutes[$default_values['minute']])) {
|
danielebarchiesi@0
|
187 $default_values['minute'] = 0;
|
danielebarchiesi@0
|
188 $default_values['hour']++;
|
danielebarchiesi@0
|
189 // If the hour rolls over also, set hour to the first hour in the list.
|
danielebarchiesi@0
|
190 if (!isset($hours[$default_values['hour']])) {
|
danielebarchiesi@0
|
191 $default_values['hour'] = $element['#hourformat'] == '12-hour' ? 1 : 0;
|
danielebarchiesi@0
|
192 }
|
danielebarchiesi@0
|
193 // If the hour has been incremented to 12:00 in 12-hour format, flip am/pm.
|
danielebarchiesi@0
|
194 // Note that technically midnight and noon are neither am or pm, but common
|
danielebarchiesi@0
|
195 // convention (and US standard) is to represent 12:00am as midnight.
|
danielebarchiesi@0
|
196 // See http://en.wikipedia.org/wiki/Midnight#Start_and_end_of_day.
|
danielebarchiesi@0
|
197 if ($element['#hourformat'] == '12-hour' && $default_values['hour'] == 12) {
|
danielebarchiesi@0
|
198 $default_values['ampm'] = $default_values['ampm'] == 'am' ? 'pm' : 'am';
|
danielebarchiesi@0
|
199 }
|
danielebarchiesi@0
|
200 }
|
danielebarchiesi@0
|
201
|
danielebarchiesi@0
|
202 $element['hour'] = array(
|
danielebarchiesi@0
|
203 '#prefix' => '',
|
danielebarchiesi@0
|
204 '#type' => 'select',
|
danielebarchiesi@0
|
205 '#default_value' => $default_values['hour'],
|
danielebarchiesi@0
|
206 '#options' => $hours,
|
danielebarchiesi@0
|
207 );
|
danielebarchiesi@0
|
208 $element['minute'] = array(
|
danielebarchiesi@0
|
209 '#prefix' => ':',
|
danielebarchiesi@0
|
210 '#type' => 'select',
|
danielebarchiesi@0
|
211 '#default_value' => $default_values['minute'],
|
danielebarchiesi@0
|
212 '#options' => $minutes,
|
danielebarchiesi@0
|
213 );
|
danielebarchiesi@0
|
214 if (strcmp($element['#hourformat'], '12-hour') == 0) {
|
danielebarchiesi@0
|
215 $element['ampm'] = array(
|
danielebarchiesi@0
|
216 '#type' => 'radios',
|
danielebarchiesi@0
|
217 '#default_value' => $default_values['ampm'],
|
danielebarchiesi@0
|
218 '#options' => $ampms,
|
danielebarchiesi@0
|
219 );
|
danielebarchiesi@0
|
220 }
|
danielebarchiesi@0
|
221
|
danielebarchiesi@0
|
222 // Set the overall default value.
|
danielebarchiesi@0
|
223 if ($default_values['hour'] !== '') {
|
danielebarchiesi@0
|
224 $element['#default_value'] = webform_date_string($default_values);
|
danielebarchiesi@0
|
225 }
|
danielebarchiesi@0
|
226
|
danielebarchiesi@0
|
227 return $element;
|
danielebarchiesi@0
|
228 }
|
danielebarchiesi@0
|
229
|
danielebarchiesi@0
|
230 /**
|
danielebarchiesi@0
|
231 * Theme a webform time element.
|
danielebarchiesi@0
|
232 */
|
danielebarchiesi@0
|
233 function theme_webform_time($variables) {
|
danielebarchiesi@0
|
234 $element = $variables['element'];
|
danielebarchiesi@0
|
235
|
danielebarchiesi@0
|
236 $element['hour']['#attributes']['class'] = array('hour');
|
danielebarchiesi@0
|
237 $element['minute']['#attributes']['class'] = array('minute');
|
danielebarchiesi@0
|
238
|
danielebarchiesi@0
|
239 // Add error classes to all items within the element.
|
danielebarchiesi@0
|
240 if (form_get_error($element)) {
|
danielebarchiesi@0
|
241 $element['hour']['#attributes']['class'][] = 'error';
|
danielebarchiesi@0
|
242 $element['minute']['#attributes']['class'][] = 'error';
|
danielebarchiesi@0
|
243 }
|
danielebarchiesi@0
|
244
|
danielebarchiesi@0
|
245 $output = '<div class="webform-container-inline">' . drupal_render($element['hour']) . drupal_render($element['minute']) . drupal_render($element['ampm']) . '</div>';
|
danielebarchiesi@0
|
246
|
danielebarchiesi@0
|
247 return $output;
|
danielebarchiesi@0
|
248 }
|
danielebarchiesi@0
|
249
|
danielebarchiesi@0
|
250 function webform_validate_time($element, $form_state) {
|
danielebarchiesi@0
|
251 $form_key = $element['#webform_component']['form_key'];
|
danielebarchiesi@0
|
252 $name = $element['#webform_component']['name'];
|
danielebarchiesi@0
|
253
|
danielebarchiesi@0
|
254 // Check if the user filled the required fields.
|
danielebarchiesi@0
|
255 foreach ($element['#hourformat'] == '12-hour' ? array('hour', 'minute', 'ampm') : array('hour', 'minute') as $field_type) {
|
danielebarchiesi@0
|
256 if ($element[$field_type]['#value'] === '' && $element['#required']) {
|
danielebarchiesi@0
|
257 form_error($element, t('%field field is required.', array('%field' => $name)));
|
danielebarchiesi@0
|
258 return;
|
danielebarchiesi@0
|
259 }
|
danielebarchiesi@0
|
260 }
|
danielebarchiesi@0
|
261
|
danielebarchiesi@0
|
262 // Check for a valid time.
|
danielebarchiesi@0
|
263 if ($element['hour']['#value'] !== '' || $element['minute']['#value'] !== '') {
|
danielebarchiesi@0
|
264 if (!is_numeric($element['hour']['#value']) || !is_numeric($element['minute']['#value']) || (isset($element['ampm']) && $element['ampm']['#value'] === '')) {
|
danielebarchiesi@0
|
265 form_error($element, t('Entered %name is not a valid time.', array('%name' => $name)));
|
danielebarchiesi@0
|
266 return;
|
danielebarchiesi@0
|
267 }
|
danielebarchiesi@0
|
268 }
|
danielebarchiesi@0
|
269 }
|
danielebarchiesi@0
|
270
|
danielebarchiesi@0
|
271 /**
|
danielebarchiesi@0
|
272 * Implements _webform_submit_component().
|
danielebarchiesi@0
|
273 */
|
danielebarchiesi@0
|
274 function _webform_submit_time($component, $value) {
|
danielebarchiesi@0
|
275 // Convert to 24-hour time before string conversion.
|
danielebarchiesi@0
|
276 if ($component['extra']['hourformat'] == '12-hour') {
|
danielebarchiesi@0
|
277 $value = webform_time_convert($value, '24-hour');
|
danielebarchiesi@0
|
278 }
|
danielebarchiesi@0
|
279
|
danielebarchiesi@0
|
280 // Convert the value into a ISO 8601 string.
|
danielebarchiesi@0
|
281 return $value['hour'] !== '' ? webform_date_string($value, 'time') : '';
|
danielebarchiesi@0
|
282 }
|
danielebarchiesi@0
|
283
|
danielebarchiesi@0
|
284 /**
|
danielebarchiesi@0
|
285 * Implements _webform_display_component().
|
danielebarchiesi@0
|
286 */
|
danielebarchiesi@0
|
287 function _webform_display_time($component, $value, $format = 'html') {
|
danielebarchiesi@0
|
288 $value = webform_date_array(isset($value[0]) ? $value[0] : '', 'time');
|
danielebarchiesi@0
|
289 if ($component['extra']['hourformat'] == '12-hour') {
|
danielebarchiesi@0
|
290 $value = webform_time_convert($value, '12-hour');
|
danielebarchiesi@0
|
291 }
|
danielebarchiesi@0
|
292
|
danielebarchiesi@0
|
293 return array(
|
danielebarchiesi@0
|
294 '#title' => $component['name'],
|
danielebarchiesi@0
|
295 '#weight' => $component['weight'],
|
danielebarchiesi@0
|
296 '#theme' => 'webform_display_time',
|
danielebarchiesi@0
|
297 '#theme_wrappers' => $format == 'html' ? array('webform_element') : array('webform_element_text'),
|
danielebarchiesi@0
|
298 '#format' => $format,
|
danielebarchiesi@0
|
299 '#hourformat' => $component['extra']['hourformat'],
|
danielebarchiesi@0
|
300 '#value' => $value,
|
danielebarchiesi@0
|
301 '#translatable' => array('title'),
|
danielebarchiesi@0
|
302 );
|
danielebarchiesi@0
|
303 }
|
danielebarchiesi@0
|
304
|
danielebarchiesi@0
|
305 /**
|
danielebarchiesi@0
|
306 * Format the output of data for this component.
|
danielebarchiesi@0
|
307 */
|
danielebarchiesi@0
|
308 function theme_webform_display_time($variables) {
|
danielebarchiesi@0
|
309 $element = $variables['element'];
|
danielebarchiesi@0
|
310 $output = ' ';
|
danielebarchiesi@0
|
311 if (isset($element['#value']['hour']) && $element['#value']['hour'] !== '' && isset($element['#value']['minute']) && $element['#value']['minute'] !== '') {
|
danielebarchiesi@0
|
312 if ($element['#hourformat'] == '24-hour') {
|
danielebarchiesi@0
|
313 $output = sprintf('%02d', $element['#value']['hour']) . ':' . sprintf('%02d', $element['#value']['minute']);
|
danielebarchiesi@0
|
314 }
|
danielebarchiesi@0
|
315 else {
|
danielebarchiesi@0
|
316 $output = $element['#value']['hour'] . ':' . sprintf('%02d', $element['#value']['minute']) . ' ' . $element['#value']['ampm'];
|
danielebarchiesi@0
|
317 }
|
danielebarchiesi@0
|
318 }
|
danielebarchiesi@0
|
319 return $output;
|
danielebarchiesi@0
|
320 }
|
danielebarchiesi@0
|
321
|
danielebarchiesi@0
|
322 /**
|
danielebarchiesi@0
|
323 * Implements _webform_analysis_component().
|
danielebarchiesi@0
|
324 */
|
danielebarchiesi@0
|
325 function _webform_analysis_time($component, $sids = array()) {
|
danielebarchiesi@0
|
326 $query = db_select('webform_submitted_data', 'wsd', array('fetch' => PDO::FETCH_ASSOC))
|
danielebarchiesi@0
|
327 ->fields('wsd', array('no', 'data'))
|
danielebarchiesi@0
|
328 ->condition('nid', $component['nid'])
|
danielebarchiesi@0
|
329 ->condition('cid', $component['cid'])
|
danielebarchiesi@0
|
330 ->orderBy('sid');
|
danielebarchiesi@0
|
331
|
danielebarchiesi@0
|
332 if (count($sids)) {
|
danielebarchiesi@0
|
333 $query->condition('sid', $sids, 'IN');
|
danielebarchiesi@0
|
334 }
|
danielebarchiesi@0
|
335
|
danielebarchiesi@0
|
336 $result = $query->execute();
|
danielebarchiesi@0
|
337
|
danielebarchiesi@0
|
338 $times = array();
|
danielebarchiesi@0
|
339 $submissions = 0;
|
danielebarchiesi@0
|
340 foreach ($result as $row) {
|
danielebarchiesi@0
|
341 $submissions++;
|
danielebarchiesi@0
|
342 if ($row['data']) {
|
danielebarchiesi@0
|
343 $times[] = webform_date_array($row['data']);
|
danielebarchiesi@0
|
344 }
|
danielebarchiesi@0
|
345 }
|
danielebarchiesi@0
|
346
|
danielebarchiesi@0
|
347 // Display stats.
|
danielebarchiesi@0
|
348 $nonblanks = count($times);
|
danielebarchiesi@0
|
349 $rows[0] = array(t('Left Blank'), ($submissions - $nonblanks));
|
danielebarchiesi@0
|
350 $rows[1] = array(t('User entered value'), $nonblanks);
|
danielebarchiesi@0
|
351 return $rows;
|
danielebarchiesi@0
|
352 }
|
danielebarchiesi@0
|
353
|
danielebarchiesi@0
|
354 /**
|
danielebarchiesi@0
|
355 * Implements _webform_table_component().
|
danielebarchiesi@0
|
356 */
|
danielebarchiesi@0
|
357 function _webform_table_time($component, $value) {
|
danielebarchiesi@0
|
358 if ($value[0]) {
|
danielebarchiesi@0
|
359 $time = webform_date_array($value[0], 'time');
|
danielebarchiesi@0
|
360 if ($component['extra']['hourformat'] == '24-hour') {
|
danielebarchiesi@0
|
361 return sprintf('%02d', $time['hour']) . ':' . sprintf('%02d', $time['minute']);
|
danielebarchiesi@0
|
362 }
|
danielebarchiesi@0
|
363 else {
|
danielebarchiesi@0
|
364 $time = webform_time_convert($time, '12-hour');
|
danielebarchiesi@0
|
365 return $time['hour'] . ':' . sprintf('%02d', $time['minute']) . ' ' . $time['ampm'];
|
danielebarchiesi@0
|
366 }
|
danielebarchiesi@0
|
367 }
|
danielebarchiesi@0
|
368 else {
|
danielebarchiesi@0
|
369 return '';
|
danielebarchiesi@0
|
370 }
|
danielebarchiesi@0
|
371 }
|
danielebarchiesi@0
|
372
|
danielebarchiesi@0
|
373 /**
|
danielebarchiesi@0
|
374 * Implements _webform_csv_headers_component().
|
danielebarchiesi@0
|
375 */
|
danielebarchiesi@0
|
376 function _webform_csv_headers_time($component, $export_options) {
|
danielebarchiesi@0
|
377 $header = array();
|
danielebarchiesi@0
|
378 $header[0] = '';
|
danielebarchiesi@0
|
379 $header[1] = '';
|
danielebarchiesi@0
|
380 $header[2] = $component['name'];
|
danielebarchiesi@0
|
381 return $header;
|
danielebarchiesi@0
|
382 }
|
danielebarchiesi@0
|
383
|
danielebarchiesi@0
|
384 /**
|
danielebarchiesi@0
|
385 * Implements _webform_csv_data_component().
|
danielebarchiesi@0
|
386 */
|
danielebarchiesi@0
|
387 function _webform_csv_data_time($component, $export_options, $value) {
|
danielebarchiesi@0
|
388 if ($value[0]) {
|
danielebarchiesi@0
|
389 $time = webform_date_array($value[0], 'time');
|
danielebarchiesi@0
|
390 if ($component['extra']['hourformat'] == '24-hour') {
|
danielebarchiesi@0
|
391 return sprintf('%02d', $time['hour']) . ':' . sprintf('%02d', $time['minute']);
|
danielebarchiesi@0
|
392 }
|
danielebarchiesi@0
|
393 else {
|
danielebarchiesi@0
|
394 $time = webform_time_convert($time, '12-hour');
|
danielebarchiesi@0
|
395 return $time['hour'] . ':' . sprintf('%02d', $time['minute']) . ' ' . $time['ampm'];
|
danielebarchiesi@0
|
396 }
|
danielebarchiesi@0
|
397 }
|
danielebarchiesi@0
|
398 else {
|
danielebarchiesi@0
|
399 return '';
|
danielebarchiesi@0
|
400 }
|
danielebarchiesi@0
|
401 }
|
danielebarchiesi@0
|
402
|
danielebarchiesi@0
|
403 /**
|
danielebarchiesi@0
|
404 * Convert a time between a 24-hour and a 12-hour value.
|
danielebarchiesi@0
|
405 *
|
danielebarchiesi@0
|
406 * @param $array
|
danielebarchiesi@0
|
407 * An array of hour, minute, second, and optionally ampm.
|
danielebarchiesi@0
|
408 * @param $format
|
danielebarchiesi@0
|
409 * Either 12-hour or 24-hour.
|
danielebarchiesi@0
|
410 * @return
|
danielebarchiesi@0
|
411 * An array with hour, minute, second, and ampm (if using "12-hour").
|
danielebarchiesi@0
|
412 */
|
danielebarchiesi@0
|
413 function webform_time_convert($array, $format) {
|
danielebarchiesi@0
|
414 if ($array['hour'] !== '') {
|
danielebarchiesi@0
|
415 if ($format == '12-hour') {
|
danielebarchiesi@0
|
416 $array['ampm'] = ($array['hour'] >= 12 && $array['hour'] < 24) ? 'pm' : 'am';
|
danielebarchiesi@0
|
417 $array['hour'] = ($array['hour'] > 12 || $array['hour'] == 0) ? abs($array['hour'] - 12) : (int) $array['hour'];
|
danielebarchiesi@0
|
418 }
|
danielebarchiesi@0
|
419 elseif ($format == '24-hour' && isset($array['ampm'])) {
|
danielebarchiesi@0
|
420 $array['hour'] = ($array['hour'] < 12 && $array['ampm'] == 'pm') ? $array['hour'] + 12 : (int) $array['hour'];
|
danielebarchiesi@0
|
421 $array['hour'] = ($array['hour'] == 12 && $array['ampm'] == 'am') ? 0 : $array['hour'];
|
danielebarchiesi@0
|
422 }
|
danielebarchiesi@0
|
423 }
|
danielebarchiesi@0
|
424
|
danielebarchiesi@0
|
425 if ($format == '12-hour' && !isset($array['ampm'])) {
|
danielebarchiesi@0
|
426 $array['ampm'] = '';
|
danielebarchiesi@0
|
427 }
|
danielebarchiesi@0
|
428 elseif ($format == '24-hour' && isset($array['ampm'])) {
|
danielebarchiesi@0
|
429 unset($array['ampm']);
|
danielebarchiesi@0
|
430 }
|
danielebarchiesi@0
|
431
|
danielebarchiesi@0
|
432 return $array;
|
danielebarchiesi@0
|
433 }
|