/** * Timer for year or ordered months * @return string */ protected function getTimerForOrderingInQuery() { if ($this->showsAllYears()) { // Ensure month-wise data return 'MONTH(FROM_UNIXTIME(`time`))'; } return parent::getTimerForOrderingInQuery(); }
/** * Timer for year or ordered months * @param bool $addTableName must be used if query contains joins * @return string */ protected function getTimerForOrderingInQuery($addTableName = false) { $time = $addTableName ? '`' . PREFIX . 'training`.`time`' : '`time`'; if ($this->showsAllYears()) { // Ensure month-wise data return 'MONTH(FROM_UNIXTIME(' . $time . '))'; } return parent::getTimerForOrderingInQuery($addTableName); }