Exemplo n.º 1
0
function rule_insert($post, $db)
{
    $new_rule = new Rule();
    $new_rule->setRuleID($post['rule_id']);
    $new_rule->setRuleParrentRuleID($post['rule_pid']);
    $new_rule->setRuleFileID($post['rf_filter']);
    $new_rule->setRuleInformation($post['rule_msg']);
    $new_rule->setRule($post['rule']);
    $new_rule->setRuleFileActive($post['validity']);
    $new_rule->setFilled(true);
    $db->addRule($new_rule);
}
Exemplo n.º 2
0
 public function getAllRules($where = '', $wlimit = '')
 {
     $count_str = "SELECT R.RecordID,R.RuleID,R.ParrentRuleID,R.Information,\n                  R.Rule,R.DefaultValue,R.Deleted,\n                  RF.RuleFileName,RDF.DataFileName,R.RuleFileID from rules R\n                  LEFT JOIN rule_files RF ON (RF.RuleFileID=R.RuleFileID)\n                  LEFT JOIN rule_data_files RDF ON (RDF.DataFileID=RF.RuleFileID)\n                  WHERE 1 {$where} ORDER BY R.RecordID DESC {$wlimit}";
     $result = $this->dbh->query($count_str);
     if (PEAR::isError($result)) {
         echo $result->getMessage() . ' - ' . $result->getUserinfo();
         exit;
     }
     $array = $result->fetchAll();
     $result->free();
     $rules_a = array();
     foreach ($array as $r) {
         $rule = new Rule();
         $rule->setRuleRecordID($r[0]);
         $rule->setRuleID($r[1]);
         $rule->setRuleParrentRuleID($r[2]);
         $rule->setRuleInformation($r[3]);
         $rule->setRule($r[4]);
         $rule->setRuleShort(substr($r[4], 0, 55));
         $rule->setRuleDefaultValue($r[5]);
         $rule->setRuleFileName($r[7]);
         $rule->setRuleFileID($r[9]);
         $rule->setDataFileName($r[8]);
         $rule->setRuleActive($r[6]);
         $rules_a[] = $rule;
     }
     return $rules_a;
 }