Roomify / bat

      if ($granularity == Event::BAT_HOURLY) {

        // Write Hours

        foreach ($itemized[Event::BAT_HOUR] as $year => $months) {

          foreach ($months as $month => $days) {

            foreach ($days as $day => $hours) {

              // Count required as we may receive empty hours for granular events that start and end on midnight

              if (count($hours) > 0) {

                $values = array_values($hours);

                $keys = array_keys($hours);

                $this->pdo->exec("INSERT OR REPLACE INTO $this->hour_table (unit_id, year, month, day, " . implode(', ', $keys) . ") VALUES (" . $event->getUnitId() . ", $year, $month, " . substr($day, 1) . ", " . implode(', ', $values) . ")");

              }

            }

          }

        }

        // If we have minutes write minutes

        // If we have minutes write minutes

        foreach ($itemized[Event::BAT_MINUTE] as $year => $months) {

          foreach ($months as $month => $days) {

            foreach ($days as $day => $hours) {

              foreach ($hours as $hour => $minutes) {

                $values = array_values($minutes);

                $keys = array_keys($minutes);

                $this->pdo->exec("INSERT OR REPLACE 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) . ")");

              }

            }

          }

        }

      }