public function storeCriteriaIntoDb($p_criteriaData) { // delete criteria under $p_blockId CcBlockcriteriaQuery::create()->findByDbBlockId($this->id)->delete(); //Logging::info($p_criteriaData); //insert modifier rows if (isset($p_criteriaData['criteria'])) { $critKeys = array_keys($p_criteriaData['criteria']); for ($i = 0; $i < count($critKeys); $i++) { foreach ($p_criteriaData['criteria'][$critKeys[$i]] as $d) { $qry = new CcBlockcriteria(); $qry->setDbCriteria($d['sp_criteria_field'])->setDbModifier($d['sp_criteria_modifier'])->setDbValue($d['sp_criteria_value'])->setDbBlockId($this->id); if (isset($d['sp_criteria_extra'])) { $qry->setDbExtra($d['sp_criteria_extra']); } $qry->save(); } } } // insert limit info $qry = new CcBlockcriteria(); $qry->setDbCriteria("limit")->setDbModifier($p_criteriaData['etc']['sp_limit_options'])->setDbValue($p_criteriaData['etc']['sp_limit_value'])->setDbBlockId($this->id)->save(); }
public function storeCriteriaIntoDb($p_criteriaData) { // delete criteria under $p_blockId CcBlockcriteriaQuery::create()->findByDbBlockId($this->id)->delete(); //Logging::info($p_criteriaData); //insert modifier rows if (isset($p_criteriaData['criteria'])) { $critKeys = array_keys($p_criteriaData['criteria']); for ($i = 0; $i < count($critKeys); $i++) { foreach ($p_criteriaData['criteria'][$critKeys[$i]] as $d) { $field = $d['sp_criteria_field']; $value = $d['sp_criteria_value']; if ($field == 'utime' || $field == 'mtime' || $field == 'lptime') { $value = Application_Common_DateHelper::UserTimezoneStringToUTCString($value); } $qry = new CcBlockcriteria(); $qry->setDbCriteria($field)->setDbModifier($d['sp_criteria_modifier'])->setDbValue($value)->setDbBlockId($this->id); if (isset($d['sp_criteria_extra'])) { if ($field == 'utime' || $field == 'mtime' || $field == 'lptime') { $d['sp_criteria_extra'] = Application_Common_DateHelper::UserTimezoneStringToUTCString($d['sp_criteria_extra']); } $qry->setDbExtra($d['sp_criteria_extra']); } $qry->save(); } } } // insert limit info $qry = new CcBlockcriteria(); $qry->setDbCriteria("limit")->setDbModifier($p_criteriaData['etc']['sp_limit_options'])->setDbValue($p_criteriaData['etc']['sp_limit_value'])->setDbBlockId($this->id)->save(); // insert repeate track option $qry = new CcBlockcriteria(); $qry->setDbCriteria("repeat_tracks")->setDbModifier("N/A")->setDbValue($p_criteriaData['etc']['sp_repeat_tracks'])->setDbBlockId($this->id)->save(); }