@@ -19,7 +19,7 @@ |
||
19 | 19 | * |
20 | 20 | * @param $calendar_response |
21 | 21 | */ |
22 | - public function applyConstraint(CalendarResponse &$calendar_response); |
|
22 | + public function applyConstraint(CalendarResponse & $calendar_response); |
|
23 | 23 | |
24 | 24 | /** |
25 | 25 | * @param $start_date |
@@ -111,7 +111,7 @@ |
||
111 | 111 | /** |
112 | 112 | * {@inheritdoc} |
113 | 113 | */ |
114 | - public function applyConstraint(CalendarResponse &$calendar_response) { |
|
114 | + public function applyConstraint(CalendarResponse & $calendar_response) { |
|
115 | 115 | $this->calendar_response = $calendar_response; |
116 | 116 | } |
117 | 117 |
@@ -111,7 +111,7 @@ |
||
111 | 111 | /** |
112 | 112 | * {@inheritdoc} |
113 | 113 | */ |
114 | - public function applyConstraint(CalendarResponse &$calendar_response) { |
|
114 | + public function applyConstraint(CalendarResponse & $calendar_response) { |
|
115 | 115 | $this->calendar_response = $calendar_response; |
116 | 116 | } |
117 | 117 |
@@ -111,7 +111,7 @@ |
||
111 | 111 | /** |
112 | 112 | * {@inheritdoc} |
113 | 113 | */ |
114 | - public function applyConstraint(CalendarResponse &$calendar_response) { |
|
114 | + public function applyConstraint(CalendarResponse & $calendar_response) { |
|
115 | 115 | $this->calendar_response = $calendar_response; |
116 | 116 | } |
117 | 117 |
@@ -129,8 +129,7 @@ discard block |
||
129 | 129 | // Unit is in a state that is within the set of valid states so add to result set |
130 | 130 | $units[$unit] = $unit; |
131 | 131 | $response->addMatch($keyed_units[$unit], CalendarResponse::VALID_STATE); |
132 | - } |
|
133 | - else { |
|
132 | + } else { |
|
134 | 133 | $response->addMiss($keyed_units[$unit], CalendarResponse::INVALID_STATE); |
135 | 134 | } |
136 | 135 | |
@@ -224,8 +223,7 @@ discard block |
||
224 | 223 | foreach ($days as $day => $value) { |
225 | 224 | $result[$year][$month][$day] = ((int)$db_events[$unit][Event::BAT_DAY][$year][$month][$day] == 0 ? $keyed_units[$unit]->getDefaultValue() : (int)$db_events[$unit][Event::BAT_DAY][$year][$month][$day]); |
226 | 225 | } |
227 | - } |
|
228 | - else { |
|
226 | + } else { |
|
229 | 227 | foreach ($days as $day => $value) { |
230 | 228 | $result[$year][$month][$day] = $keyed_units[$unit]->getDefaultValue(); |
231 | 229 | } |
@@ -256,8 +254,7 @@ discard block |
||
256 | 254 | foreach ($hours as $hour => $value) { |
257 | 255 | if (isset($db_events[$unit][Event::BAT_HOUR][$year][$month][$day][$hour])) { |
258 | 256 | $result[$year][$month][$day][$hour] = ((int) $db_events[$unit][Event::BAT_HOUR][$year][$month][$day][$hour] == 0 ? $keyed_units[$unit]->getDefaultValue() : (int) $db_events[$unit][Event::BAT_HOUR][$year][$month][$day][$hour]); |
259 | - } |
|
260 | - else { |
|
257 | + } else { |
|
261 | 258 | // If nothing from db - then revert to the defaults |
262 | 259 | $result[$year][$month][$day][$hour] = (int) $keyed_units[$unit]->getDefaultValue(); |
263 | 260 | } |
@@ -305,8 +302,7 @@ discard block |
||
305 | 302 | foreach ($minutes as $minute => $value) { |
306 | 303 | if (isset($db_events[$unit][Event::BAT_MINUTE][$year][$month][$day][$hour][$minute])) { |
307 | 304 | $result[$year][$month][$day][$hour][$minute] = ((int) $db_events[$unit][Event::BAT_MINUTE][$year][$month][$day][$hour][$minute] == 0 ? $keyed_units[$unit]->getDefaultValue() : (int) $db_events[$unit][Event::BAT_MINUTE][$year][$month][$day][$hour][$minute]); |
308 | - } |
|
309 | - else { |
|
305 | + } else { |
|
310 | 306 | // If nothing from db - then revert to the defaults |
311 | 307 | $result[$year][$month][$day][$hour][$minute] = (int) $keyed_units[$unit]->getDefaultValue(); |
312 | 308 | } |
@@ -381,8 +377,7 @@ discard block |
||
381 | 377 | if ($current_value === $minute_value) { |
382 | 378 | // We are still in minutes and going through so add a minute |
383 | 379 | $end_event->add(new \DateInterval('PT1M')); |
384 | - } |
|
385 | - elseif (($current_value != $minute_value) && ($current_value !== NULL)) { |
|
380 | + } elseif (($current_value != $minute_value) && ($current_value !== NULL)) { |
|
386 | 381 | // Value just switched - let us wrap up with current event and start a new one |
387 | 382 | $normalized_events[$unit_id][] = new Event($start_event, $end_event, $this->getUnit($unit_id), $current_value); |
388 | 383 | $start_event = clone($end_event->add(new \DateInterval('PT1M'))); |
@@ -396,12 +391,10 @@ discard block |
||
396 | 391 | } |
397 | 392 | $current_value = $minute_value; |
398 | 393 | } |
399 | - } |
|
400 | - elseif ($current_value === $hour_value) { |
|
394 | + } elseif ($current_value === $hour_value) { |
|
401 | 395 | // We are in hours and can add something |
402 | 396 | $end_event->add(new \DateInterval('PT1H')); |
403 | - } |
|
404 | - elseif (($current_value != $hour_value) && ($current_value !== NULL)) { |
|
397 | + } elseif (($current_value != $hour_value) && ($current_value !== NULL)) { |
|
405 | 398 | // Value just switched - let us wrap up with current event and start a new one |
406 | 399 | $normalized_events[$unit_id][] = new Event($start_event, $end_event, $this->getUnit($unit_id), $current_value); |
407 | 400 | // Start event becomes the end event with a minute added |
@@ -418,12 +411,10 @@ discard block |
||
418 | 411 | $current_value = $hour_value; |
419 | 412 | } |
420 | 413 | } |
421 | - } |
|
422 | - elseif ($current_value === $value) { |
|
414 | + } elseif ($current_value === $value) { |
|
423 | 415 | // We are adding a whole day so the end event gets moved to the end of the day we are adding |
424 | 416 | $end_event = new \DateTime($year . '-' . $month . '-' . substr($day, 1) . ' ' . '23:59'); |
425 | - } |
|
426 | - elseif (($current_value !== $value) && ($current_value !== NULL)) { |
|
417 | + } elseif (($current_value !== $value) && ($current_value !== NULL)) { |
|
427 | 418 | // Value just switched - let us wrap up with current event and start a new one |
428 | 419 | $normalized_events[$unit_id][] = new Event($start_event, $end_event, $this->getUnit($unit_id), $current_value); |
429 | 420 | // Start event becomes the end event with a minute added |
@@ -458,8 +449,7 @@ discard block |
||
458 | 449 | if ($event->endsLater($end_date)) { |
459 | 450 | $event->setEndDate($end_date); |
460 | 451 | } |
461 | - } |
|
462 | - else { |
|
452 | + } else { |
|
463 | 453 | // Event completely not in range so unset it |
464 | 454 | unset($normalized_events[$unit_id][$key]); |
465 | 455 | } |
@@ -490,8 +480,7 @@ discard block |
||
490 | 480 | $e++; |
491 | 481 | $flipped[$e][$value][$datum] = $datum; |
492 | 482 | $old_value = $value; |
493 | - } |
|
494 | - else { |
|
483 | + } else { |
|
495 | 484 | $flipped[$e][$value][$datum] = $datum; |
496 | 485 | } |
497 | 486 | } |
@@ -125,7 +125,7 @@ discard block |
||
125 | 125 | $current_states = array_keys($unit_states); |
126 | 126 | // Compare the current states with the set of valid states |
127 | 127 | $remaining_states = array_diff($current_states, $valid_states); |
128 | - if (count($remaining_states) == 0 ) { |
|
128 | + if (count($remaining_states) == 0) { |
|
129 | 129 | // Unit is in a state that is within the set of valid states so add to result set |
130 | 130 | $units[$unit] = $unit; |
131 | 131 | $response->addMatch($keyed_units[$unit], CalendarResponse::VALID_STATE); |
@@ -164,7 +164,7 @@ discard block |
||
164 | 164 | // Create a mock itemized event for the period in question - since event data is either |
165 | 165 | // in the database or the default value we first create a mock event and then fill it in |
166 | 166 | // accordingly |
167 | - $mock_event = new Event($start_date, $end_date, new Unit(0,0), $this->default_value); |
|
167 | + $mock_event = new Event($start_date, $end_date, new Unit(0, 0), $this->default_value); |
|
168 | 168 | $itemized = $mock_event->itemize(new EventItemizer($mock_event, $granularity)); |
169 | 169 | |
170 | 170 | // Cycle through each unit retrieved and provide it with a fully configured itemized mock event |
@@ -255,11 +255,11 @@ discard block |
||
255 | 255 | foreach ($days as $day => $hours) { |
256 | 256 | foreach ($hours as $hour => $value) { |
257 | 257 | if (isset($db_events[$unit][Event::BAT_HOUR][$year][$month][$day][$hour])) { |
258 | - $result[$year][$month][$day][$hour] = ((int) $db_events[$unit][Event::BAT_HOUR][$year][$month][$day][$hour] == 0 ? $keyed_units[$unit]->getDefaultValue() : (int) $db_events[$unit][Event::BAT_HOUR][$year][$month][$day][$hour]); |
|
258 | + $result[$year][$month][$day][$hour] = ((int)$db_events[$unit][Event::BAT_HOUR][$year][$month][$day][$hour] == 0 ? $keyed_units[$unit]->getDefaultValue() : (int)$db_events[$unit][Event::BAT_HOUR][$year][$month][$day][$hour]); |
|
259 | 259 | } |
260 | 260 | else { |
261 | 261 | // If nothing from db - then revert to the defaults |
262 | - $result[$year][$month][$day][$hour] = (int) $keyed_units[$unit]->getDefaultValue(); |
|
262 | + $result[$year][$month][$day][$hour] = (int)$keyed_units[$unit]->getDefaultValue(); |
|
263 | 263 | } |
264 | 264 | } |
265 | 265 | } |
@@ -273,7 +273,7 @@ discard block |
||
273 | 273 | foreach ($months as $month => $days) { |
274 | 274 | foreach ($days as $day => $hours) { |
275 | 275 | foreach ($hours as $hour => $value) { |
276 | - $result[$year][$month][$day][$hour] = ((int) $value == 0 ? $keyed_units[$unit]->getDefaultValue() : (int) $value); |
|
276 | + $result[$year][$month][$day][$hour] = ((int)$value == 0 ? $keyed_units[$unit]->getDefaultValue() : (int)$value); |
|
277 | 277 | } |
278 | 278 | ksort($result[$year][$month][$day], SORT_NATURAL); |
279 | 279 | } |
@@ -304,11 +304,11 @@ discard block |
||
304 | 304 | foreach ($hours as $hour => $minutes) { |
305 | 305 | foreach ($minutes as $minute => $value) { |
306 | 306 | if (isset($db_events[$unit][Event::BAT_MINUTE][$year][$month][$day][$hour][$minute])) { |
307 | - $result[$year][$month][$day][$hour][$minute] = ((int) $db_events[$unit][Event::BAT_MINUTE][$year][$month][$day][$hour][$minute] == 0 ? $keyed_units[$unit]->getDefaultValue() : (int) $db_events[$unit][Event::BAT_MINUTE][$year][$month][$day][$hour][$minute]); |
|
307 | + $result[$year][$month][$day][$hour][$minute] = ((int)$db_events[$unit][Event::BAT_MINUTE][$year][$month][$day][$hour][$minute] == 0 ? $keyed_units[$unit]->getDefaultValue() : (int)$db_events[$unit][Event::BAT_MINUTE][$year][$month][$day][$hour][$minute]); |
|
308 | 308 | } |
309 | 309 | else { |
310 | 310 | // If nothing from db - then revert to the defaults |
311 | - $result[$year][$month][$day][$hour][$minute] = (int) $keyed_units[$unit]->getDefaultValue(); |
|
311 | + $result[$year][$month][$day][$hour][$minute] = (int)$keyed_units[$unit]->getDefaultValue(); |
|
312 | 312 | } |
313 | 313 | } |
314 | 314 | } |
@@ -324,7 +324,7 @@ discard block |
||
324 | 324 | foreach ($days as $day => $hours) { |
325 | 325 | foreach ($hours as $hour => $minutes) { |
326 | 326 | foreach ($minutes as $minute => $value) { |
327 | - $result[$year][$month][$day][$hour][$minute] = ((int) $value == 0 ? $keyed_units[$unit]->getDefaultValue() : (int) $value); |
|
327 | + $result[$year][$month][$day][$hour][$minute] = ((int)$value == 0 ? $keyed_units[$unit]->getDefaultValue() : (int)$value); |
|
328 | 328 | } |
329 | 329 | ksort($result[$year][$month][$day][$hour], SORT_NATURAL); |
330 | 330 | } |
@@ -386,12 +386,12 @@ discard block |
||
386 | 386 | // Value just switched - let us wrap up with current event and start a new one |
387 | 387 | $normalized_events[$unit_id][] = new Event($start_event, $end_event, $this->getUnit($unit_id), $current_value); |
388 | 388 | $start_event = clone($end_event->add(new \DateInterval('PT1M'))); |
389 | - $end_event = new \DateTime($year . '-' . $month . '-' . substr($day, 1) . ' ' . substr($hour, 1) . ':' . substr($minute,1)); |
|
389 | + $end_event = new \DateTime($year . '-' . $month . '-' . substr($day, 1) . ' ' . substr($hour, 1) . ':' . substr($minute, 1)); |
|
390 | 390 | $current_value = $minute_value; |
391 | 391 | } |
392 | 392 | if ($current_value === NULL) { |
393 | 393 | // We are down to minutes and haven't created and event yet - do one now |
394 | - $start_event = new \DateTime($year . '-' . $month . '-' . substr($day, 1) . ' ' . substr($hour, 1) . ':' . substr($minute,1)); |
|
394 | + $start_event = new \DateTime($year . '-' . $month . '-' . substr($day, 1) . ' ' . substr($hour, 1) . ':' . substr($minute, 1)); |
|
395 | 395 | $end_event = clone($start_event); |
396 | 396 | } |
397 | 397 | $current_value = $minute_value; |
@@ -534,7 +534,7 @@ discard block |
||
534 | 534 | * @return Unit |
535 | 535 | */ |
536 | 536 | protected function getUnit($unit_id) { |
537 | - $keyed = $this->keyUnitsById(); |
|
537 | + $keyed = $this->keyUnitsById(); |
|
538 | 538 | return $keyed[$unit_id]; |
539 | 539 | } |
540 | 540 |
@@ -27,7 +27,7 @@ discard block |
||
27 | 27 | */ |
28 | 28 | public function getEventData(\DateTime $start_date, \DateTime $end_date, $unit_ids) { |
29 | 29 | |
30 | - $queries = $this->buildQueries($start_date, $end_date, $unit_ids); |
|
30 | + $queries = $this->buildQueries($start_date, $end_date, $unit_ids); |
|
31 | 31 | |
32 | 32 | $results = array(); |
33 | 33 | // Run each query and store results |
@@ -38,30 +38,30 @@ discard block |
||
38 | 38 | $db_events = array(); |
39 | 39 | |
40 | 40 | // Cycle through day results and setup an event array |
41 | - while( $data = $results[Event::BAT_DAY]->fetchAssoc()) { |
|
41 | + while ($data = $results[Event::BAT_DAY]->fetchAssoc()) { |
|
42 | 42 | // Figure out how many days the current month has |
43 | 43 | $temp_date = new \DateTime($data['year'] . "-" . $data['month']); |
44 | 44 | $days_in_month = (int)$temp_date->format('t'); |
45 | - for ($i = 1; $i<=$days_in_month; $i++) { |
|
46 | - $db_events[$data['unit_id']][Event::BAT_DAY][$data['year']][$data['month']]['d' . $i] = $data['d'.$i]; |
|
45 | + for ($i = 1; $i <= $days_in_month; $i++) { |
|
46 | + $db_events[$data['unit_id']][Event::BAT_DAY][$data['year']][$data['month']]['d' . $i] = $data['d' . $i]; |
|
47 | 47 | } |
48 | 48 | } |
49 | 49 | |
50 | 50 | // With the day events taken care off let's cycle through hours |
51 | - while( $data = $results[Event::BAT_HOUR]->fetchAssoc()) { |
|
52 | - for ($i = 0; $i<=23; $i++) { |
|
53 | - $db_events[$data['unit_id']][Event::BAT_HOUR][$data['year']][$data['month']]['d' . $data['day']]['h'. $i] = $data['h'.$i]; |
|
51 | + while ($data = $results[Event::BAT_HOUR]->fetchAssoc()) { |
|
52 | + for ($i = 0; $i <= 23; $i++) { |
|
53 | + $db_events[$data['unit_id']][Event::BAT_HOUR][$data['year']][$data['month']]['d' . $data['day']]['h' . $i] = $data['h' . $i]; |
|
54 | 54 | } |
55 | 55 | } |
56 | 56 | |
57 | 57 | // With the hour events taken care off let's cycle through minutes |
58 | - while( $data = $results[Event::BAT_MINUTE]->fetchAssoc()) { |
|
59 | - for ($i = 0; $i<=59; $i++) { |
|
58 | + while ($data = $results[Event::BAT_MINUTE]->fetchAssoc()) { |
|
59 | + for ($i = 0; $i <= 59; $i++) { |
|
60 | 60 | if ($i <= 9) { |
61 | - $index = 'm0'.$i; |
|
61 | + $index = 'm0' . $i; |
|
62 | 62 | } |
63 | 63 | else { |
64 | - $index = 'm'.$i; |
|
64 | + $index = 'm' . $i; |
|
65 | 65 | } |
66 | 66 | $db_events[$data['unit_id']][Event::BAT_MINUTE][$data['year']][$data['month']]['d' . $data['day']]['h' . $data['hour']][$index] = $data[$index]; |
67 | 67 | } |
@@ -106,7 +106,7 @@ |
||
106 | 106 | $query_parameters .= 'AND month IN (' . implode(",", array_keys($months)) . ') '; |
107 | 107 | if (count($unit_ids) > 0) { |
108 | 108 | // Unit ids are defined so add this as a filter |
109 | - $query_parameters .= 'AND unit_id in (' . implode("," , $unit_ids) . ') '; |
|
109 | + $query_parameters .= 'AND unit_id in (' . implode(",", $unit_ids) . ') '; |
|
110 | 110 | } |
111 | 111 | $year_count++; |
112 | 112 | } |
@@ -16,27 +16,27 @@ |
||
16 | 16 | */ |
17 | 17 | class EventInterval { |
18 | 18 | |
19 | - /** |
|
20 | - * Return the number of times a duration fits into the start and end date taking into account |
|
21 | - * BAT's consideration that the end time for a BAT event includes that last minute. |
|
22 | - * |
|
23 | - * @param \DateTime $start_date |
|
24 | - * @param \DateTime $end_date |
|
25 | - * @param \DateInterval $duration |
|
26 | - * |
|
27 | - * @return float |
|
28 | - */ |
|
29 | - public static function divide(\DateTime $start_date, \DateTime $end_date, \DateInterval $duration) { |
|
30 | - // Clone so that we don't change the original object. We are not using ImmutableDateTime to support PHP5.4 |
|
31 | - $temp_end_date = clone($end_date); |
|
32 | - |
|
33 | - // Add a minute to deal with the fact that BAT considers the last minute included |
|
34 | - $temp_end_date->add(new \DateInterval('PT1M')); |
|
35 | - |
|
36 | - // Convert everything to seconds and calculate exactly how many times the duration fits in our event length |
|
37 | - $duration_seconds = $duration->d * 86400 + $duration->h * 3600 + $duration->i * 60 + $duration->s; |
|
38 | - |
|
39 | - return ($temp_end_date->getTimestamp() - $start_date->getTimestamp()) / $duration_seconds; |
|
40 | - } |
|
19 | + /** |
|
20 | + * Return the number of times a duration fits into the start and end date taking into account |
|
21 | + * BAT's consideration that the end time for a BAT event includes that last minute. |
|
22 | + * |
|
23 | + * @param \DateTime $start_date |
|
24 | + * @param \DateTime $end_date |
|
25 | + * @param \DateInterval $duration |
|
26 | + * |
|
27 | + * @return float |
|
28 | + */ |
|
29 | + public static function divide(\DateTime $start_date, \DateTime $end_date, \DateInterval $duration) { |
|
30 | + // Clone so that we don't change the original object. We are not using ImmutableDateTime to support PHP5.4 |
|
31 | + $temp_end_date = clone($end_date); |
|
32 | + |
|
33 | + // Add a minute to deal with the fact that BAT considers the last minute included |
|
34 | + $temp_end_date->add(new \DateInterval('PT1M')); |
|
35 | + |
|
36 | + // Convert everything to seconds and calculate exactly how many times the duration fits in our event length |
|
37 | + $duration_seconds = $duration->d * 86400 + $duration->h * 3600 + $duration->i * 60 + $duration->s; |
|
38 | + |
|
39 | + return ($temp_end_date->getTimestamp() - $start_date->getTimestamp()) / $duration_seconds; |
|
40 | + } |
|
41 | 41 | |
42 | 42 | } |
@@ -50,14 +50,14 @@ discard block |
||
50 | 50 | // Figure out how many days the current month has |
51 | 51 | $temp_date = new \DateTime($data['year'] . "-" . $data['month']); |
52 | 52 | $days_in_month = (int)$temp_date->format('t'); |
53 | - for ($i = 1; $i<=$days_in_month; $i++) { |
|
53 | + for ($i = 1; $i <= $days_in_month; $i++) { |
|
54 | 54 | $db_events[$data['unit_id']][Event::BAT_DAY][$data['year']][$data['month']]['d' . $i] = $data['d' . $i]; |
55 | 55 | } |
56 | 56 | } |
57 | 57 | |
58 | 58 | // With the day events taken care off let's cycle through hours |
59 | 59 | foreach ($results[Event::BAT_HOUR]->fetchAll() as $data) { |
60 | - for ($i = 0; $i<=23; $i++) { |
|
60 | + for ($i = 0; $i <= 23; $i++) { |
|
61 | 61 | $db_events[$data['unit_id']][Event::BAT_HOUR][$data['year']][$data['month']]['d' . $data['day']]['h' . $i] = $data['h' . $i]; |
62 | 62 | } |
63 | 63 | } |
@@ -126,11 +126,11 @@ discard block |
||
126 | 126 | $keys = array_keys($hours); |
127 | 127 | if (isset($existing_events[$event->getUnitId()][EVENT::BAT_HOUR][$year][$month][$day])) { |
128 | 128 | $command = "UPDATE $this->hour_table SET "; |
129 | - foreach ($hours as $hour => $value){ |
|
129 | + foreach ($hours as $hour => $value) { |
|
130 | 130 | $command .= "$hour = $value,"; |
131 | 131 | } |
132 | 132 | $command = rtrim($command, ','); |
133 | - $command .= " WHERE unit_id = " . $event->getUnitId() . " AND year = $year AND month = $month AND day = " . substr($day,1); |
|
133 | + $command .= " WHERE unit_id = " . $event->getUnitId() . " AND year = $year AND month = $month AND day = " . substr($day, 1); |
|
134 | 134 | $this->pdo->exec($command); |
135 | 135 | } else { |
136 | 136 | $this->pdo->exec("INSERT INTO $this->hour_table (unit_id, year, month, day, " . implode(', ', $keys) . ") VALUES (" . $event->getUnitId() . ", $year, $month, " . substr($day, 1) . ", " . implode(', ', $values) . ")"); |
@@ -149,11 +149,11 @@ discard block |
||
149 | 149 | $keys = array_keys($minutes); |
150 | 150 | if (isset($existing_events[$event->getUnitId()][EVENT::BAT_MINUTE][$year][$month][$day][$hour])) { |
151 | 151 | $command = "UPDATE $this->minute_table SET "; |
152 | - foreach ($minutes as $minute => $value){ |
|
152 | + foreach ($minutes as $minute => $value) { |
|
153 | 153 | $command .= "$minute = $value,"; |
154 | 154 | } |
155 | 155 | $command = rtrim($command, ','); |
156 | - $command .= " WHERE unit_id = " . $event->getUnitId() . " AND year = $year AND month = $month AND day = " . substr($day,1) . " AND hour = " . substr($hour,1); |
|
156 | + $command .= " WHERE unit_id = " . $event->getUnitId() . " AND year = $year AND month = $month AND day = " . substr($day, 1) . " AND hour = " . substr($hour, 1); |
|
157 | 157 | $this->pdo->exec($command); |
158 | 158 | } else { |
159 | 159 | $this->pdo->exec("INSERT INTO $this->minute_table (unit_id, year, month, day, hour, " . implode(', ', $keys) . ") VALUES (" . $event->getUnitId() . ", $year, $month, " . substr($day, 1) . ", " . substr($hour, 1) . ", " . implode(', ', $values) . ")"); |
@@ -108,8 +108,7 @@ |
||
108 | 108 | $command = rtrim($command, ','); |
109 | 109 | $command .= " WHERE unit_id = " . $event->getUnitId() . " AND year = $year AND month = $month"; |
110 | 110 | $this->pdo->exec($command); |
111 | - } |
|
112 | - else { |
|
111 | + } else { |
|
113 | 112 | $this->pdo->exec("INSERT INTO $this->day_table (unit_id, year, month, " . implode(', ', $keys) . ") VALUES (" . $event->getUnitId() . ", $year, $month, " . implode(', ', $values) . ")"); |
114 | 113 | } |
115 | 114 | } |