/** * Constructor * * @param object An optional KConfig object with configuration options */ public function __construct(KConfig $config) { parent::__construct($config); // Set the static states $this->_state->limit = KFactory::get('joomla:application')->getCfg('list_limit'); }
protected function _buildQueryWhere(KDatabaseQuery $query) { if ($this->_state->search) { $query->where('tbl.title', 'LIKE', '%' . $this->_state->search . '%'); } if (is_numeric($this->_state->enabled)) { $query->where('tbl.enabled', '=', $this->_state->enabled); } parent::_buildQueryWhere($query); }
protected function _buildQueryWhere(KDatabaseQuery $query) { if ($this->_state->task) { $query->where('tbl.jedi_task_id', '=', (int) $this->_state->task); } if ($this->_state->member) { $query->where('tbl.jedi_member_id', '=', (int) $this->_state->member); } parent::_buildQueryWhere($query); }
protected function _buildQueryWhere(KDatabaseQuery $query) { parent::_buildQueryWhere($query); if (!$this->_state->isUnique()) { if ($this->_state->parent) { $parent = $this->getTable()->select($this->_state->parent, KDatabase::FETCH_ROW); $query->where('tbl.lft', '>', $parent->lft, 'AND')->where('tbl.rgt', '<', $parent->rgt); } if (!is_null($this->_state->core)) { $query->where('tbl.id', $this->_state->core ? '<=' : '>', 30); } } }
protected function _buildQueryWhere(KDatabaseQuery $query) { $state = $this->_state; if ($state->search) { $query->where('tbl.name', 'LIKE', '%' . $state->search . '%'); } if (is_numeric($state->enabled)) { $query->where('tbl.enabled', '=', $state->enabled); } if (is_numeric($state->jedi_rank_id)) { $query->where('tbl.jedi_rank_id', '=', (int) $state->jedi_rank_id); } parent::_buildQueryWhere($query); }