| <? | <?php |
| if agency | include_once("heuristics.inc.php"); |
| if supplier | $query = "SELECT *, agency.abn as agencyABN, IF(supplierABN != '',supplierABN,supplierName) as supplierID |
| if CN | 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 */ | |
| ?> | ?> |