protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if (!$state->isUnique()) { if ($state->search) { $query->where('tbl.title LIKE :search')->bind(array('search' => '%' . $state->search . '%')); } if ($state->table) { $query->where('tbl.table = :table')->bind(array('table' => $state->table)); } if ($state->row) { $query->where('tbl.row = :row')->bind(array('row' => $state->row)); } if ($state->slug) { $query->where('tbl.slug = :slug')->bind(array('slug' => $state->slug)); } if ($state->iso_code) { $query->where('tbl.iso_code = :iso_code')->bind(array('iso_code' => $state->iso_code)); } if (!is_null($state->status)) { $query->where('tbl.status = :status')->bind(array('status' => $state->status)); } if (!is_null($state->deleted)) { $query->where('tbl.deleted = :deleted')->bind(array('deleted' => (int) $state->deleted)); } } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if (is_numeric($state->published)) { $query->where('tbl.published = :published')->bind(array('published' => (int) $state->published)); } if ($state->search) { $query->where('(tbl.title LIKE :search)')->bind(array('search' => '%' . $state->search . '%')); } if ($state->searchword) { $query->where('(tbl.title LIKE :search OR tbl.introtext LIKE :search OR tbl.fulltext LIKE :search)')->bind(array('search' => '%' . $state->searchword . '%')); } if (is_numeric($state->category) || $state->category) { if (is_numeric($state->category)) { $query->where('tbl.categories_category_id IN :categories_category_id'); if ($state->category_recurse === true) { $query->where('categories.parent_id IN :categories_category_id', 'OR'); } $query->bind(array('categories_category_id' => (array) $state->category)); } else { $query->where('tbl.categories_category_id IS NULL'); } } if ($state->created_by) { $query->where('tbl.created_by = :created_by')->bind(array('created_by' => $state->created_by)); } if ($this->getTable()->isRevisable() && $state->trashed) { $query->bind(array('deleted' => 1)); } if (is_numeric($state->access)) { $query->where('tbl.access <= :access')->bind(array('access' => $state->access)); } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($state->search) { $query->where('tbl.title LIKE %:search%')->bind(array('search' => $state->search)); } if ($state->table) { $query->where('tbl.table ' . (is_array($state->table) ? 'IN' : '=') . ' :table')->bind(array('table' => $state->table)); } if (is_numeric($state->parent)) { $query->where('tbl.parent_id ' . (is_array($state->parent) ? 'IN' : '=') . ' :parent')->bind(array('parent' => $state->parent)); } if (is_numeric($state->category)) { $query->where('tbl.parent_id ' . (is_array($state->category) ? 'IN' : '=') . ' :parent')->bind(array('parent' => $state->category)); } if (is_bool($state->published)) { $query->where('tbl.published = :published'); if ($state->table) { //@TODO : com_articles doesn't have a published column need to fix this //$query->where('content.published = :published'); } $query->bind(array('published' => (int) $state->published)); } if (is_bool($state->access)) { $query->where('tbl.access <= :access')->bind(array('access' => (int) $state->access)); } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($state->application) { $query->where('tbl.application = :application')->bind(array('application' => $state->application)); } if ($state->package && !($state->distinct && !empty($state->column))) { $query->where('tbl.package = :package')->bind(array('package' => $state->package)); } if ($state->name) { $query->where('tbl.name = :name')->bind(array('name' => $state->name)); } if ($state->action) { $query->where('tbl.action ' . (is_array($state->action) ? 'IN' : '=') . ' :action')->bind(array('action' => $state->action)); } if ($state->start_date && $state->start_date != '0000-00-00') { // TODO: Sync this code with Date and DatabaseQuery changes. $start_date = $this->getObject('lib:date', array('date' => $this->getState()->start_date)); $days_back = clone $start_date; $start = $start_date->addDays(1)->addSeconds(-1)->getDate(); $query->where('tbl.created_on', '<', $start); $query->where('tbl.created_on', '>', $days_back->addDays(-(int) $this->getState()->days_back)->getDate()); } if ($state->user) { $query->where('tbl.created_by = :created_by')->bind(array('created_by' => $state->user)); } if ($state->ip) { $query->where('tbl.ip ' . (in_array($state->ip) ? 'IN' : '=') . ' :ip')->bind(array('ip' => $state->ip)); } // TODO: Implement a better way to exclude information based on package/name $query->where('tbl.name != :name')->bind(array('name' => 'session')); }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($state->home) { $query->where('tbl.home = :home')->bind(array('home' => (int) $state->home)); } if ($state->menu) { $query->where('tbl.pages_menu_id = :menu_id')->bind(array('menu_id' => $state->menu)); } if (is_bool($state->published)) { $query->where('tbl.published = :published')->bind(array('published' => (int) $state->published)); } if (is_numeric($state->access)) { $query->where('tbl.access <= :access')->bind(array('access' => $state->access)); } if (is_bool($state->hidden)) { $query->where('tbl.hidden = :hidden')->bind(array('hidden' => (int) $state->hidden)); } //if(is_numeric($state->trashed)) { // $query->where('tbl.trashed','=', $state->trashed); //} if (is_numeric($state->group_id)) { $query->where('tbl.group_id', '=', $state->group_id); } if ($state->search) { $query->where('tbl.title LIKE :search')->bind(array('search' => '%' . $state->search . '%')); } if ($state->application) { $query->where('menus.application = :application')->bind(array('application' => $state->application)); } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if (!$state->isUnique()) { if ($state->search) { $query->where('tbl.title LIKE :search')->bind(array('search' => '%' . $state->search . '%')); } if ($state->position) { $query->where('tbl.position = :position')->bind(array('position' => $state->position)); } if (is_bool($state->published)) { $query->where('tbl.published = :published')->bind(array('published' => (int) $state->published)); } if ($state->application) { $query->where('tbl.application = :application')->bind(array('application' => $state->application)); } if ($state->extension) { $query->where('tbl.extensions_extension_id = :extension')->bind(array('extension' => $state->extension)); } if (is_numeric($state->access)) { $query->where('tbl.access <= :access')->bind(array('access' => $state->access)); } if (is_numeric($state->page)) { $query->where('module_menu.pages_page_id IN :page')->bind(array('page' => array($state->page, 0))); } } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($state->search) { $query->where('tbl.title LIKE :search')->bind(array('search' => '%' . $state->search . '%')); } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($state->active) { $query->where('content.products_count > :active')->bind(array('active' => '0')); } }
/** * Builds a WHERE clause for the query. * * @param Library\DatabaseQuerySelect A query object. * @return void */ protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($state->application) { $query->where('application IN :application')->bind(array('application' => (array) $state->application)); } if ($state->email) { $query->where('tbl.email IN :email')->bind(array('email' => (array) $state->email)); } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($user_id = $state->user_id) { $query->where('tbl.users_user_id = :user_id')->bind(array('user_id' => $user_id)); } if ($group_id = $state->group_id) { $query->where('tbl.users_group_id = :group_id')->bind(array('group_id' => $group_id)); } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); if (!$this->getState()->isUnique()) { if ($this->getState()->table) { $query->where('tbl.table = :table')->bind(array('table' => $this->getState()->table)); } if ($this->getState()->row) { $query->where('tbl.row = :row')->bind(array('row' => $this->getState()->row)); } } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if (!$state->isUnique()) { if ($state->search) { $query->where('tbl.title LIKE :search')->bind(array('search' => '%' . $state->search . '%')); } if ($state->application) { $query->where('tbl.application = :application')->bind(array('application' => $state->application)); } } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if (!$state->isUnique()) { if (!is_null($state->enabled)) { $query->where('tbl.enabled = :enabled')->bind(array('enabled' => (int) $state->enabled)); } if ($state->extension) { $query->where('tbl.extensions_extension_id IN :extension')->bind(array('extension' => (array) $state->extension)); } } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($state->search) { $query->where('tbl.name LIKE :search')->bind(array('search' => '%' . $state->search . '%')); } if ($state->name) { $query->where('tbl.name = :name')->bind(array('name' => $state->name)); } if (is_bool($state->enabled)) { $query->where('tbl.enabled = :enabled')->bind(array('enabled' => (int) $state->enabled)); } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if (!$state->isUnique()) { if (!is_null($state->primary)) { $query->where('tbl.primary = :primary')->bind(array('primary' => (int) $state->primary)); } if (!is_null($state->enabled)) { $query->where('tbl.enabled = :enabled')->bind(array('enabled' => (int) $state->enabled)); } if ($state->application) { $query->where('tbl.application = :application')->bind(array('application' => $state->application)); } } }
/** * Build where part of query * * When getting a revision X > 1, we need to get all revisions from 1 to X, and combine the data from these into * one row. * * @param Library\DatabaseQuerySelect $query */ protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($state->revision > 1) { $state->revision = range(1, $state->revision); } if ($state->status) { $query->where('tbl.status', '=', $state->status); } if ($state->row) { $query->where('tbl.row', 'IN', array($state->row)); } if ($state->table && !$state->isUnique()) { $query->where('tbl.table', '=', $state->table); } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if (is_bool($state->published)) { $query->where('tbl.published = :published')->bind(array('published' => (int) $state->published)); } if ($state->category) { $query->where('tbl.categories_category_id = :category')->bind(array('category' => (int) $state->category)); } if ($state->search) { $query->where('tbl.name LIKE :search')->bind(array('search' => '%' . $state->search . '%')); } if (is_numeric($state->access)) { $query->where('tbl.access <= :access')->bind(array('access' => $state->access)); } }
/** * Builds a WHERE clause for the query. * * @param Library\DatabaseQuerySelect A query object. * @return void */ protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($state->group) { $query->where('group.users_group_id = :group_id')->bind(array('group_id' => $state->group)); } if ($state->role) { $query->where('tbl.users_role_id ' . ($state->group_tree ? '>=' : '=') . ' :role_id')->bind(array('role_id' => $state->role)); } if (is_bool($state->enabled)) { $query->where('tbl.enabled = :enabled')->bind(array('enabled' => $state->enabled)); } if ($state->loggedin === false) { $query->where('loggedin IS NULL'); } if (is_bool($state->visited)) { $query->where('last_visited_on ' . ($state->visited ? '!=' : '=') . ' :last_visited_on')->bind(array('last_visited_on', '0000-00-00 00:00:00')); } if ($state->search) { $query->where('tbl.name LIKE :search')->bind(array('search' => '%' . $state->search . '%')); } }
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query) { parent::_buildQueryWhere($query); $state = $this->getState(); if ($state->products_brand_id) { $query->where('tbl.products_brand_id = :products_brand_id')->bind(array('products_brand_id' => $state->products_brand_id)); } if ($state->products_condition_id) { $query->where('tbl.products_condition_id = :products_condition_id')->bind(array('products_condition_id' => $state->products_condition_id)); } if ($state->products_category_id) { $query->where('category.products_category_id = :products_category_id')->bind(array('products_category_id' => $state->products_category_id)); } if ($state->products_group_id) { $query->where('tbl.products_group_id = :products_group_id')->bind(array('products_group_id' => $state->products_group_id)); } if ($state->published) { $query->where('tbl.published = :published')->bind(array('published' => $state->published)); } if ($state->featured) { $query->where('tbl.featured = :featured')->bind(array('featured' => $state->featured)); } }