/** * @service filter write * @param $fields */ public function save(Gpf_Rpc_Params $params) { $form = new Gpf_Rpc_Form($params); $filter = new Gpf_Db_Filter(); $filter->setPrimaryKeyValue($form->getFieldValue("Id")); //TODO: check if filterid belongs to authUser try { $filter->load(); } catch (Gpf_DbEngine_NoRow $e) { $form->setErrorMessage($this->_("Filter does not exist")); return $form; } $form->fill($filter); try { $filter->save(); $this->saveFilterPresets($form, $filter->getPrimaryKeyValue()); } catch (Exception $e) { $form->setErrorMessage($e->getMessage()); return $form; } $form->load($filter); $form->setInfoMessage($this->_("Filter saved")); return $form; }
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(); }