--- a/heuristics/runHeuristics.php +++ b/heuristics/runHeuristics.php @@ -1,6 +1,36 @@ -<? -if agency -if supplier -if CN +<?php +if (php_sapi_name() != "cli") { + +include_once ("../lib/common.inc.php"); +auth(); +include_once("heuristics.inc.php"); + +$query = 'SELECT *, agency.abn as "agencyABN", case when "supplierABN" != 0 then "supplierABN"::text else "supplierName" end as "supplierID" +FROM contractnotice JOIN agency ON contractnotice."agencyName"=agency."agencyName" +WHERE DATE("importDate") = (select * from (SELECT DATE("importDate") +FROM contractnotice ORDER BY "importDate" DESC limit 1) alias) limit 10'; + $query = $conn->prepare($query); + $query->execute(); + databaseError($conn->errorInfo()); +foreach ($query->fetchAll() as $cn) { + //get each new CN from latest update + foreach ($heuristics as $heuristic => $description) { + // run all heuristics + runHeuristic($heuristic, $cn); + } + flush(); +} +/*foreach agency + +aggregate agency metrics + +foreach supplier + +aggreate supplier metrics + +foreach CN + +aggregate CN metrics */ +} ?>