--- a/heuristics/runHeuristics.php +++ b/heuristics/runHeuristics.php @@ -1,10 +1,15 @@ <?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" +// agency table missing JOIN agency ON contractnotice."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") -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->execute(); databaseError($conn->errorInfo()); @@ -27,5 +32,6 @@ foreach CN aggregate CN metrics */ +} ?>