--- a/heuristics/runHeuristics.php +++ b/heuristics/runHeuristics.php @@ -1,15 +1,14 @@ <?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 -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)"; -$result = mysql_query($query); -if (!$result) echo mysql_error().$query; -while ($cn = mysql_fetch_array($result, MYSQL_BOTH)) { +$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