--- a/heuristics/runHeuristics.php +++ b/heuristics/runHeuristics.php @@ -1,6 +1,32 @@ -<? -if agency -if supplier -if CN +<?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)) { + //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 */ ?>