/**
* 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();
}
