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