1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | <?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 */ } ?> |