unspsc update
[contractdashboard.git] / heuristics / runHeuristics.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
<?php
if (php_sapi_name() != "cli") {
    
include_once ("../lib/common.inc.php");
auth();
include_once("heuristics.inc.php");
 
// 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 100';
    $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
                runHeuristic($heuristic, $cn);
        }
        flush();
}
/*foreach agency
 
aggregate agency metrics
 
foreach supplier
 
aggreate supplier metrics
 
foreach CN
 
aggregate CN metrics */
}
?>