/** * @param filterType * @service filter read */ public function getFilterNames(Gpf_Rpc_Params $params) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('f.userid', '=', Gpf_Session::getAuthUser()->getUserId(), 'OR'); $condition->add('f.userid', '=', null, 'OR'); $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->add('f.filterid', 'id'); $selectBuilder->select->add('f.name', 'name'); $selectBuilder->from->add(Gpf_Db_Table_Filters::getName(), 'f'); $selectBuilder->where->add('f.filtertype', '=', $params->get('filterType')); $selectBuilder->where->addCondition($condition); $selectBuilder->orderBy->add('f.name'); $response = new Gpf_Data_RecordSet(); $response->load($selectBuilder); return $response; }
function init() { $this->setTable(Gpf_Db_Table_Filters::getInstance()); parent::init(); }
public function loadDefaultFilterCollection($filterType) { if ($filterType == '') { return; } $filterId = Gpf_Db_Table_Filters::getInstance()->getDefaultFilterId($filterType); if ($filterId == '') { return; } $this->loadFilterById($filterId); }
protected function getFiltersRecordset() { $filters = Gpf_Db_Table_Filters::getInstance(); return $filters->getFilters('subaffiliatetree'); }