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) {

                db_merge($this->hour_table)

                  ->key(array(

                    'unit_id' => $event->unit_id,

                    'year' => $year,

                    'month' => $month,

                    'day' => substr($day, 1)

                  ))

                  ->fields($hours)

                  ->execute();

              }

            }

          }

        }

        //If we have minutes write minutes

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

        //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) {

                db_merge($this->minute_table)

                  ->key(array(

                    'unit_id' => $event->unit_id,

                    'year' => $year,

                    'month' => $month,

                    'day' => substr($day, 1),

                    'hour' => substr($hour, 1)

                  ))

                  ->fields($minutes)

                  ->execute();

              }

            }

          }

        }

      }

    }