Esempio n. 1
0
 /**
  * @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);
     }
 }
Esempio n. 2
0
 /**
  * @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 . '%');
     }
 }