本文整理匯總了PHP中Dataset::getQuerySelectForAllDatasets方法的典型用法代碼示例。如果您正苦於以下問題：PHP Dataset::getQuerySelectForAllDatasets方法的具體用法？PHP Dataset::getQuerySelectForAllDatasets怎麽用？PHP Dataset::getQuerySelectForAllDatasets使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Dataset的用法示例。
在下文中一共展示了Dataset::getQuerySelectForAllDatasets方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: initDays
/**
* 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;
}
}
}示例2: searchTrainings
/**
* 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();
}