Changeset View
Changeset View
Standalone View
Standalone View
branches/5.2.x/core/kernel/db/dblist.php
Show First 20 Lines • Show All 754 Lines • ▼ Show 20 Line(s) | |||||
* @return string | * @return string | ||||
* @access private | * @access private | ||||
*/ | */ | ||||
private function GetWhereClause($for_counting=false,$system_filters_only=false) | private function GetWhereClause($for_counting=false,$system_filters_only=false) | ||||
{ | { | ||||
$where = $this->Application->makeClass('kMultipleFilter'); | $where = $this->Application->makeClass('kMultipleFilter'); | ||||
/* @var $where kMultipleFilter */ | /* @var $where kMultipleFilter */ | ||||
if ( $for_counting ) { | $where->addFilter( | ||||
$where->addFilter('system_where', $this->extractCalculatedFields($this->WhereFilter[self::FLT_SYSTEM]->getSQL()) ); | 'system_where', | ||||
} | $this->extractCalculatedFields($this->WhereFilter[self::FLT_SYSTEM]->getSQL()) | ||||
else { | ); | ||||
$where->addFilter('system_where', $this->WhereFilter[self::FLT_SYSTEM] ); | |||||
} | |||||
if (!$system_filters_only) { | if (!$system_filters_only) { | ||||
$where->addFilter('view_where', $this->WhereFilter[self::FLT_VIEW] ); | $where->addFilter('view_where', $this->WhereFilter[self::FLT_VIEW] ); | ||||
$search_w = $this->WhereFilter[self::FLT_SEARCH]->getSQL(); | $search_w = $this->WhereFilter[self::FLT_SEARCH]->getSQL(); | ||||
if ($search_w || $for_counting) { // move search_having to search_where in case search_where isset or we are counting | if ($search_w || $for_counting) { // move search_having to search_where in case search_where isset or we are counting | ||||
$search_h = $this->extractCalculatedFields( $this->HavingFilter[self::FLT_SEARCH]->getSQL() ); | $search_h = $this->extractCalculatedFields( $this->HavingFilter[self::FLT_SEARCH]->getSQL() ); | ||||
$search_w = ($search_w && $search_h) ? $search_w.' OR '.$search_h : $search_w.$search_h; | $search_w = ($search_w && $search_h) ? $search_w.' OR '.$search_h : $search_w.$search_h; | ||||
▲ Show 20 Lines • Show All 1004 Lines • Show Last 20 Lines |