Roomify / bat

src/Store/SqlLiteDBStore.php

Spacing +14 added lines, -14 removed lines

@@ -49,17 +49,17 @@ 
     // Cycle through day results and setup an event array
     foreach ($results[Event::BAT_DAY]->fetchAll() as $data) {
       // Figure out how many days the current month has
-      $temp_date = new \DateTime($data['year'] . "-" . $data['month']);
+      $temp_date = new \DateTime($data['year']."-".$data['month']);
       $days_in_month = (int)$temp_date->format('t');
       for ($i = 1; $i <= $days_in_month; $i++) {
-        $db_events[$data['unit_id']][Event::BAT_DAY][$data['year']][$data['month']]['d' . $i] = $data['d' . $i];
+        $db_events[$data['unit_id']][Event::BAT_DAY][$data['year']][$data['month']]['d'.$i] = $data['d'.$i];
       }
     }
 
     // With the day events taken care off let's cycle through hours
     foreach ($results[Event::BAT_HOUR]->fetchAll() as $data) {
       for ($i = 0; $i <= 23; $i++) {
-        $db_events[$data['unit_id']][Event::BAT_HOUR][$data['year']][$data['month']]['d' . $data['day']]['h' . $i] = $data['h' . $i];
+        $db_events[$data['unit_id']][Event::BAT_HOUR][$data['year']][$data['month']]['d'.$data['day']]['h'.$i] = $data['h'.$i];
       }
     }
 
@@ -67,11 +67,11 @@ 
     foreach ($results[Event::BAT_MINUTE]->fetchAll() as $data) {
       for ($i = 0; $i <= 59; $i++) {
         if ($i <= 9) {
-          $index = 'm0' . $i;
+          $index = 'm0'.$i;
         } else {
-          $index = 'm' . $i;
+          $index = 'm'.$i;
         }
-        $db_events[$data['unit_id']][Event::BAT_MINUTE][$data['year']][$data['month']]['d' . $data['day']]['h' . $data['hour']][$index] = $data[$index];
+        $db_events[$data['unit_id']][Event::BAT_MINUTE][$data['year']][$data['month']]['d'.$data['day']]['h'.$data['hour']][$index] = $data[$index];
       }
     }
 
@@ -110,11 +110,11 @@ 
               $command .= "$day = $value,";
             }
             $command = rtrim($command, ',');
-            $command .= " WHERE unit_id = " . $unit_id . " AND year = $year AND month = $month";
+            $command .= " WHERE unit_id = ".$unit_id." AND year = $year AND month = $month";
             $this->pdo->exec($command);
           }
           else {
-            $this->pdo->exec("INSERT INTO $this->day_table (unit_id, year, month, " . implode(', ', $keys) . ") VALUES (" . $unit_id . ", $year, $month, " . implode(', ', $values) . ")");
+            $this->pdo->exec("INSERT INTO $this->day_table (unit_id, year, month, ".implode(', ', $keys).") VALUES (".$unit_id.", $year, $month, ".implode(', ', $values).")");
           }
         }
       }
@@ -130,12 +130,12 @@ 
                 $keys = array_keys($hours);
                 if (isset($existing_events[$unit_id][EVENT::BAT_HOUR][$year][$month][$day])) {
                   $command = "UPDATE $this->hour_table SET ";
-                  foreach ($hours as $hour => $value){
+                  foreach ($hours as $hour => $value) {
                     $this->itemizeSplitHour($existing_events, $itemized, $value, $unit_id, $year, $month, $day, $hour);
                     $command .= "$hour = $value,";
                   }
                   $command = rtrim($command, ',');
-                  $command .= " WHERE unit_id = " . $unit_id . " AND year = $year AND month = $month AND day = " . substr($day,1);
+                  $command .= " WHERE unit_id = ".$unit_id." AND year = $year AND month = $month AND day = ".substr($day, 1);
                   $this->pdo->exec($command);
                 } else {
                   if (isset($existing_events[$unit_id][EVENT::BAT_DAY][$year][$month][$day])) {
@@ -143,7 +143,7 @@ 
                       $this->itemizeSplitHour($existing_events, $itemized, $value, $unit_id, $year, $month, $day, $hour);
                     }
                   }
-                  $this->pdo->exec("INSERT INTO $this->hour_table (unit_id, year, month, day, " . implode(', ', $keys) . ") VALUES (" . $unit_id . ", $year, $month, " . substr($day, 1) . ", " . implode(', ', $values) . ")");
+                  $this->pdo->exec("INSERT INTO $this->hour_table (unit_id, year, month, day, ".implode(', ', $keys).") VALUES (".$unit_id.", $year, $month, ".substr($day, 1).", ".implode(', ', $values).")");
                 }
               }
             }
@@ -159,14 +159,14 @@ 
                 $keys = array_keys($minutes);
                 if (isset($existing_events[$unit_id][EVENT::BAT_MINUTE][$year][$month][$day][$hour])) {
                   $command = "UPDATE $this->minute_table SET ";
-                  foreach ($minutes as $minute => $value){
+                  foreach ($minutes as $minute => $value) {
                     $command .= "$minute = $value,";
                   }
                   $command = rtrim($command, ',');
-                  $command .= " WHERE unit_id = " . $unit_id . " AND year = $year AND month = $month AND day = " . substr($day,1) . " AND hour = " . substr($hour,1);
+                  $command .= " WHERE unit_id = ".$unit_id." AND year = $year AND month = $month AND day = ".substr($day, 1)." AND hour = ".substr($hour, 1);
                   $this->pdo->exec($command);
                 } else {
-                  $this->pdo->exec("INSERT INTO $this->minute_table (unit_id, year, month, day, hour, " . implode(', ', $keys) . ") VALUES (" . $unit_id . ", $year, $month, " . substr($day, 1) . ", " . substr($hour, 1) . ", " . implode(', ', $values) . ")");
+                  $this->pdo->exec("INSERT INTO $this->minute_table (unit_id, year, month, day, hour, ".implode(', ', $keys).") VALUES (".$unit_id.", $year, $month, ".substr($day, 1).", ".substr($hour, 1).", ".implode(', ', $values).")");
                 }
               }
             }

Braces +1 added lines, -2 removed lines

@@ -112,8 +112,7 @@
             $command = rtrim($command, ',');
             $command .= " WHERE unit_id = " . $unit_id . " AND year = $year AND month = $month";
             $this->pdo->exec($command);
-          }
-          else {
+          } else {
             $this->pdo->exec("INSERT INTO $this->day_table (unit_id, year, month, " . implode(', ', $keys) . ") VALUES (" . $unit_id . ", $year, $month, " . implode(', ', $values) . ")");
           }
         }