| <?php | <?php |
| include_once ("../lib/common.inc.php"); | include_once ("../lib/common.inc.php"); |
| $heuristics = Array(); | $heuristics = Array(); |
| //each heuristic adds self to description array | //each heuristic adds self to description array |
| include ("dateHeuristics.php"); | include ("dateHeuristics.php"); |
| include ("historyHeuristics.php"); | include ("historyHeuristics.php"); |
| //include ("metadataHeuristics.php"); | //include ("metadataHeuristics.php"); |
| //include ("valueHeuristics.php"); | //include ("valueHeuristics.php"); |
| function runHeuristic($heuristicName, $cn) | function runHeuristic($heuristicName, $cn) |
| { | { |
| global $conn; | |
| // check if already ran | // check if already ran |
| $query = "select count(*) from heuristic_results where heuristic_name = '$heuristicName' and CNID = '{$cn['CNID']}'"; | $query = "select count(*) from heuristic_results where heuristic_name = '$heuristicName' and \"CNID\" = '{$cn['CNID']}'"; |
| $result = $conn->query($query); | $result = $conn->query($query); |
| databaseError($conn->errorInfo()); | |
| $r = $result->fetch(PDO::FETCH_BOTH); | $r = $result->fetch(PDO::FETCH_BOTH); |
| if ($r[0] == 0) { | if ($r[0] == 0) { |
| // if not, run now | // if not, run now |
| $hresults = call_user_func($heuristicName, $cn); | $hresults = call_user_func($heuristicName, $cn); |
| if (!isset($hresults["heuristic_value"]) || !isset($hresults["raw_value"]) || !isset($hresults["mean"]) || !isset($hresults["stddev"])) { | if (!isset($hresults["heuristic_value"]) || !isset($hresults["raw_value"]) || !isset($hresults["mean"]) || !isset($hresults["stddev"])) { |
| print_r($hresults); | print_r($hresults); |
| die("Missing field in heurtistic $heuristicName result"); | die("Missing field in heurtistic $heuristicName result"); |
| } | } |
| $query = "insert into heuristic_results values('$heuristicName', | $query = "insert into heuristic_results values('$heuristicName', |
| '{$hresults["heuristic_value"]}', | '{$hresults["heuristic_value"]}', |
| '{$hresults["raw_value"]}', | '{$hresults["raw_value"]}', |
| '{$hresults["mean"]}', | '{$hresults["mean"]}', |
| '{$hresults["stddev"]}', | '{$hresults["stddev"]}', |
| '{$cn["CNID"]}', | '{$cn["CNID"]}', |
| NOW(), | NOW(), |
| '{$cn["publishDate"]}', | '{$cn["publishDate"]}', |
| '{$cn["agencyABN"]}', | '{$cn["agencyABN"]}', |
| '{$cn["supplierID"]}' | '{$cn["supplierID"]}' |
| )"; | )"; |
| // save value and cn data via sql | // save value and cn data via sql |
| $result = $conn->query($query); | $result = $conn->query($query); |
| $errors = $conn->errorInfo(); | $errors = $conn->errorInfo(); |
| if ($errors[2] == "") echo "Saved $heuristicName for {$cn["CNID"]} <br>\n"; | if ($errors[2] == "") echo "Saved $heuristicName for {$cn["CNID"]} <br>\n"; |
| elseif (strpos($errors[2] , "Duplicate entry") === false) echo $hresults . " failed insert.<br>" . print_r($errors,true) . " <br> $query <br><br>\n"; | elseif (strpos($errors[2] , "Duplicate entry") === false) echo $hresults . " failed insert.<br>" . print_r($errors,true) . " <br> $query <br><br>\n"; |
| } | } |
| } | } |
| ?> | ?> |