function rule_data_file_insert($post, $db) { $new_rule_data_file = new Rule(); $new_rule_data_file->setDataFileName($post['rdf_name']); $new_rule_data_file->setRuleFileID($post['rf_filter']); $new_rule_data_file->setDataFileActive($post['validity']); $new_rule_data_file->setFilled(true); $db->addRuleDataFiles($new_rule_data_file); }
public function getAllRuleDataFiles($where = '') { $count_str = "SELECT RDF.DataFileID,COUNT(RD.RuleDataID),\n RDF.DataFileName,RF.RuleFileName,RDF.Deleted from rule_data_files RDF\n LEFT JOIN rule_files RF ON (RF.RuleFileID=RDF.RuleFileID AND RF.Deleted=0)\n LEFT JOIN rule_data RD ON (RD.DataFileID=RDF.DataFileID AND RD.Deleted=0)\n WHERE 1 {$where} GROUP BY RDF.DataFileID"; $result = $this->dbh->query($count_str); if (PEAR::isError($result)) { echo $result->getMessage() . ' - ' . $result->getUserinfo(); exit; } $array = $result->fetchAll(); $result->free(); $rule_dfiles_a = array(); foreach ($array as $rd) { $rule_dfile = new Rule(); $rule_dfile->setDataFileID($rd[0]); $rule_dfile->setRuleDataCount($rd[1]); $rule_dfile->setDataFileName($rd[2]); $rule_dfile->setRuleFileName($rd[3]); $rule_dfile->setDataFileActive($rd[4]); $rule_dfiles_a[] = $rule_dfile; } return $rule_dfiles_a; }