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