/** * @param KDatabaseQuery $query */ protected function _buildQueryWhere(KDatabaseQuery $query) { $state = $this->_state; parent::_buildQueryWhere($query); if (is_numeric($state->cck_fieldset_id)) { $query->where('tbl.cck_fieldset_id', '=', $state->cck_fieldset_id); } if ($state->type) { $query->where('tbl.type', '=', $state->type); } if (is_numeric($state->enabled)) { $query->where('tbl.enabled', '=', $state->enabled); } }
/** * @param KDatabaseQuery $query */ protected function _buildQueryWhere(KDatabaseQuery $query) { $state = $this->_state; parent::_buildQueryWhere($query); if (is_numeric($state->taxonomy_taxonomy_id)) { $query->where('taxonomy_taxonomy_id', '=', $state->taxonomy_taxonomy_id); } if (is_numeric($state->enabled)) { $query->where('tbl.enabled', '=', $state->enabled); } if ($state->search) { $query->where('tbl.title', 'LIKE', '%' . $state->search . '%'); } }