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();
}
}
