public function execute() { $filter = new Gpf_Db_Filter(); $filter->setFilterId('afftreed'); $filter->setName('default'); $filter->setFilterType('subaffiliatetree'); $filter->setNull(Gpf_Db_Table_Filters::USER_ID); $filter->setPreset('Y'); $filter->save(); $condition = new Gpf_Db_FilterCondition(); $condition->setFieldId('rstatus'); $condition->setFilterId('afftreed'); $condition->setSectionCode('default'); $condition->setCode('rstatus'); $condition->setOperator('IN'); $condition->setValue('A'); $condition->save(); }
private function addFilterCondition(Gpf_Db_Filter $filter, $fieldId, $sectionCode, $code, $operator, $value) { $condition = new Gpf_Db_FilterCondition(); $condition->setFieldId($fieldId); $condition->setFilterId($filter->getId()); $condition->setSectionCode($sectionCode); $condition->setCode($code); $condition->setOperator($operator); $condition->setValue($value); $condition->save(); }
public function loadFilterById($filterId) { $filters = new Gpf_Db_FilterCondition(); $filters->setFilterId($filterId); $collection = $filters->loadCollection(); foreach ($collection as $filterCondition) { if ($filterCondition->get(Gpf_Db_Table_FilterConditions::VALUE) != '') { $this->add(array(Gpf_SqlBuilder_Filter::FILTER_CODE => $filterCondition->get(Gpf_Db_Table_FilterConditions::CODE), Gpf_SqlBuilder_Filter::FILTER_OPERATOR => $filterCondition->get(Gpf_Db_Table_FilterConditions::OPERATOR), Gpf_SqlBuilder_Filter::FILTER_VALUE => $filterCondition->get(Gpf_Db_Table_FilterConditions::VALUE))); } } }
private function saveFilterPresets(Gpf_Rpc_Form $form, $filterId) { $filterConditionsTable = Gpf_Db_Table_FilterConditions::getInstance(); $filterConditionsTable->deleteAll($filterId); $presets = new Gpf_Data_RecordSet(); $presets->loadFromArray($form->getFieldValue("presets")); foreach ($presets as $preset) { $filterCondition = new Gpf_Db_FilterCondition(); $filterCondition->setFilterId($filterId); $filterCondition->fillFromRecord($preset); $filterCondition->save(); } }