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