| <?php | <?php |
| if (php_sapi_name() != "cli") { | |
| include_once ("../lib/common.inc.php"); | |
| auth(); | |
| include_once("heuristics.inc.php"); | include_once("heuristics.inc.php"); |
| $query = "SELECT *, agency.abn as agencyABN, IF(supplierABN != '',supplierABN,supplierName) as supplierID | |
| FROM contractnotice JOIN agency ON contractnotice.agencyName=agency.agencyName"; | |
| $query = "SELECT *, agency.abn as agencyABN, IF(supplierABN != '',supplierABN,supplierName) 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" |
| WHERE DATE(importDate) = (select * from (SELECT DATE(importDate) | FROM contractnotice |
| FROM contractnotice ORDER BY importDate DESC limit 1) alias)"; | WHERE DATE("importDate") = (select * from (SELECT DATE("importDate") |
| 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 */ |
| } | |
| ?> | ?> |