/**
* @param \DateTime $start_date
* @param \DateTime $end_date
* @param $unit_ids
*
* @return array
*/
public function buildQueries(\DateTime $start_date, \DateTime $end_date, $unit_ids)
{
$queries = array();
$queries[Event::BAT_DAY] = 'SELECT * FROM ' . $this->day_table . ' WHERE ';
$queries[Event::BAT_HOUR] = 'SELECT * FROM ' . $this->hour_table . ' WHERE ';
$queries[Event::BAT_MINUTE] = 'SELECT * FROM ' . $this->minute_table . ' WHERE ';
$hours_query = TRUE;
$minutes_query = TRUE;
// Create a mock event which we will use to determine how to query the database
$mock_event = new Event($start_date, $end_date, 0, -10);
// We don't need a granular event even if we are retrieving granular data - since we don't
// know what the event break-down is going to be we need to get the full range of data from
// days, hours and minutes.
$itemized = $mock_event->itemizeEvent(BAT_DAILY);
$year_count = 0;
$hour_count = 0;
$minute_count = 0;
$query_parameters = '';
foreach ($itemized[BAT_DAY] as $year => $months) {
if ($year_count > 0) {
// We are dealing with multiple years so add an OR
$query_parameters .= ' OR ';
}
$query_parameters .= 'year IN (' . $year . ') ';
$query_parameters .= 'AND month IN (' . implode(",", array_keys($months)) . ') ';
if (count($unit_ids) > 0) {
// Unit ids are defined so add this as a filter
$query_parameters .= 'AND unit_id in (' . implode(",", $unit_ids) . ') ';
}
$year_count++;
}
// Add parameters to each query
$queries[Event::BAT_DAY] .= $query_parameters;
$queries[Event::BAT_HOUR] .= $query_parameters;
$queries[Event::BAT_MINUTE] .= $query_parameters;
// Clean up and add ordering information
$queries[Event::BAT_DAY] .= ' ORDER BY unit_id, year, month';
$queries[Event::BAT_HOUR] .= ' ORDER BY unit_id, year, month, day';
$queries[Event::BAT_MINUTE] .= ' ORDER BY unit_id, year, month, day, hour';
return $queries;
}
