<?php |
<?php |
include_once("heuristics.inc.php"); |
include_once("heuristics.inc.php"); |
$query = "SELECT *, agency.abn as agencyABN, IF(supplierABN != '',supplierABN,supplierName) as supplierID |
$query = "SELECT *, agency.abn as agencyABN, IF(supplierABN != '',supplierABN,supplierName) as supplierID |
FROM contractnotice JOIN agency ON contractnotice.agencyName=agency.agencyName"; |
FROM contractnotice JOIN agency ON contractnotice.agencyName=agency.agencyName"; |
|
|
$query = "SELECT *, agency.abn as agencyABN, IF(supplierABN != '',supplierABN,supplierName) as supplierID |
$query = "SELECT *, agency.abn as agencyABN, IF(supplierABN != '',supplierABN,supplierName) as supplierID |
FROM contractnotice JOIN agency ON contractnotice.agencyName=agency.agencyName |
FROM contractnotice JOIN agency ON contractnotice.agencyName=agency.agencyName |
WHERE DATE(importDate) = (select * from (SELECT DATE(importDate) |
WHERE DATE(importDate) = (select * from (SELECT DATE(importDate) |
FROM contractnotice ORDER BY importDate DESC limit 1) alias)"; |
FROM contractnotice ORDER BY importDate DESC limit 1) alias)"; |
$result = mysql_query($lastimportquery); |
$result = mysql_query($query); |
if (!$result) echo mysql_error().$query; |
if (!$result) echo mysql_error().$query; |
while ($cn = mysql_fetch_array($result, MYSQL_BOTH)) { |
while ($cn = mysql_fetch_array($result, MYSQL_BOTH)) { |
//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 */ |
?> |
?> |
|
|