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); }
public function getAllRuleFiles($where = '') { $count_str = "SELECT RF.RuleFileID,COUNT(R.RecordID),COUNT(DISTINCT(RDF.DataFileID)),\n RF.RuleFileName,RF.Deleted from rule_files RF\n LEFT JOIN rules R ON (RF.RuleFileID=R.RuleFileID AND R.Deleted=0)\n LEFT JOIN rule_data_files RDF ON (RDF.DataFileID=RF.RuleFileID AND RDF.Deleted=0)\n {$where} GROUP BY RF.RuleFileID"; $result = $this->dbh->query($count_str); if (PEAR::isError($result)) { echo $result->getMessage() . ' - ' . $result->getUserinfo(); exit; } $array = $result->fetchAll(); $result->free(); $rule_files_a = array(); foreach ($array as $rf) { $rule_file = new Rule(); $rule_file->setRuleFileID($rf[0]); $rule_file->setRuleFileRuleCount($rf[1]); $rule_file->setRuleFileRuleDataFileCount($rf[2]); $rule_file->setRuleFileName($rf[3]); $rule_file->setRuleFileActive($rf[4]); $rule_files_a[] = $rule_file; } return $rule_files_a; }