public function applyDateRange(array $dateRange)
{
$used = DateRangeParameter::getMonthsUsed($dateRange);
$months = array('', 'JAN', 'FEB', 'MAR', 'APR', 'MAY', 'JUN', 'JUL', 'AUG', 'SEP', 'OCT', 'NOV', 'DEC');
$this->month_fields = "";
for ($m = 1; $m <= 12; ++$m) {
if (isset($used[$m])) {
$this->month_fields .= "sum(IF(month={$m},IFNULL(overrideUsageCount,usageCount),null)) `{$months[$m]}`,";
}
}
}
public function applyDateRange(array $dateRange)
{
$used = DateRangeParameter::getMonthsUsed($dateRange);
$months = array('', 'JAN', 'FEB', 'MAR', 'APR', 'MAY', 'JUN', 'JUL', 'AUG', 'SEP', 'OCT', 'NOV', 'DEC');
$this->month_fields = "";
$this->month_fields_override = "";
$this->month_fields_outlier = "";
for ($m = 1; $m <= 12; ++$m) {
if (isset($used[$m])) {
$this->month_fields .= "MAX(IF(month={$m},usageCount,null)) `{$months[$m]}`,";
$this->month_fields_override .= "MAX(IF(month={$m},overrideUsageCount,null)) {$months[$m]}_OVERRIDE,";
$this->month_fields_outlier .= "MAX(IF(month={$m},outlierID,null)) {$months[$m]}_OUTLIER,";
}
}
}
