/** * Init all days for beeing displayed */ protected function initDays() { $this->initShortModes(); $this->initEmptyDays(); $WhereNotPrivate = FrontendShared::$IS_SHOWN && !Configuration::Privacy()->showPrivateActivitiesInList() ? 'AND is_public=1' : ''; $AllTrainings = $this->DB->query(' SELECT id, time, `s` as `s_sum_with_distance`, DATE(FROM_UNIXTIME(time)) as `date` ' . $this->Dataset->getQuerySelectForAllDatasets() . ' FROM `' . PREFIX . 'training` WHERE `time` BETWEEN ' . ($this->timestamp_start - 10) . ' AND ' . ($this->timestamp_end - 10) . ' AND accountid = ' . SessionAccountHandler::getId() . ' ' . $WhereNotPrivate . ' ORDER BY `time` ASC ')->fetchAll(); foreach ($AllTrainings as $Training) { $w = Time::diffInDays($Training['time'], $this->timestamp_start); if (in_array($Training['sportid'], $this->sports_short) || in_array($Training['typeid'], $this->types_short)) { $this->days[$w]['shorts'][] = $Training; } else { $this->days[$w]['trainings'][] = $Training; } } }
/** * Search trainings */ private function searchTrainings() { $this->totalNumberOfTrainings = DB::getInstance()->query('SELECT COUNT(*) FROM `' . PREFIX . 'training` ' . $this->getWhere() . $this->getOrder() . ' LIMIT 1')->fetchColumn(); $this->page = (int) Request::param('page'); if (($this->page - 1) * $this->resultsPerPage > $this->totalNumberOfTrainings) { $this->page--; } $this->Trainings = DB::getInstance()->query('SELECT `id`, `time` ' . ($this->multiEditorRequested() ? '' : $this->Dataset->getQuerySelectForAllDatasets()) . ' FROM `' . PREFIX . 'training` ' . $this->getWhere() . $this->getOrder() . $this->getLimit())->fetchAll(); }