| <?php | |
| include_once("./lib/common.inc.php"); | |
| // TODO | |
| // color suppliers based on value? static list of high value suppliers? | |
| // TODO sigma | |
| // link on contracts site? | |
| // allow higher zoom levels | |
| // describe methodology and yellow/red color meaning, creative commons attribution | |
| $used_node_ids = Array(); | |
| $included_panel_ids = Array(); | |
| $used_edge_ids = Array(); | |
| function add_node($id, $label, $parent = "", $panel = false) | |
| { | |
| global $used_node_ids; | |
| if (!in_array($id, $used_node_ids)) { | |
| echo "<node id='" . urlencode($id) . "' label=\"" . str_replace('"','',str_replace("&", "and", $label)) . "\" " . ($parent != "" ? "pid='$parent'><viz:size value='" . rand(1, 50) . "'/>" : "><viz:size value='2'/>") | |
| . "<viz:color b='" . ($panel ? 0 : 0) . "' g='" . ($panel ? 0 : 255) . "' r='" . ($panel ? 255 : 255) . "'/>"; | |
| echo "</node>" . PHP_EOL; | |
| $used_node_ids[] = $id; | |
| } | |
| } | |
| function add_edge($from, $to, $weight = '1.0') | |
| { | |
| global $used_edge_ids, $included_panel_ids; | |
| $id = urlencode($from . '-' . $to); | |
| if (!in_array($id, $used_edge_ids)) { | |
| echo "<edge id='" . $id . "' source='" . urlencode($from) . "' target='" . urlencode($to) . "' weight='" . $weight . "'>" . PHP_EOL; | |
| if ($weight != 0.1) { | |
| echo "<viz:color b='192' g='192' r='192'/>"; | |
| } else { | |
| echo "<viz:color b='0' g='0' r='255'/>"; | |
| } | |
| echo "</edge>" . PHP_EOL; | |
| $used_edge_ids[] = $id; | |
| } | |
| } | |
| $edges = Array(); | |
| header('Content-Type: application/gexf+xml'); | |
| echo '<?xml version="1.0" encoding="UTF-8"?> | |
| <gexf xmlns="http://www.gexf.net/1.2draft" xmlns:viz="http://www.gexf.net/1.2draft/viz" version="1.2"> | |
| <meta lastmodifieddate="2009-03-20"> | |
| <creator>Gexf.net</creator> | |
| <description>A hello world! file</description> | |
| </meta> | |
| <graph mode="static" defaultedgetype="directed"> | |
| <nodes>' . PHP_EOL; | |
| $query = ' | |
| SELECT "supplierABN", min("supplierName") AS "supplierName", contractnotice."SONID", count(*), sum(value) AS value | |
| FROM contractnotice | |
| WHERE "childCN" IS NULL | |
| AND extract(year from "publishDate") = \'2016\' | |
| AND "supplierABN" in (select distinct "supplierABN" from contractnotice where (left("categoryUNSPSC"::text,2) = \'43\' or left("categoryUNSPSC"::text,2) = \'80\') ) | |
| AND contractnotice."SONID" != \'\' AND contractnotice."SONID" IS NOT NULL GROUP BY "supplierABN", contractnotice."SONID"'; | |
| $query = $conn->prepare($query); | |
| $query->execute(); | |
| databaseError($conn->errorInfo()); | |
| foreach ($query->fetchAll() as $row) { | |
| add_node($row['supplierABN'], $row['supplierName'], "",false); | |
| $included_panel_ids[] = $row['SONID']; | |
| $edges[] = array("head" => $row['SONID'], "tail" => $row['supplierABN'], "weight" => $row['count']); | |
| } | |
| $query = 'SELECT "SONID", title FROM standingoffers'; | |
| $query = $conn->prepare($query); | |
| $query->execute(); | |
| foreach ($query->fetchAll() as $row) { | |
| // if (in_array($row['SONID'], $included_panel_ids)){ | |
| add_node($row['SONID'], $row['title'], "", true); | |
| // } | |
| } | |
| $query = 'select "SONID", abn,name from standingoffer_suppliers'; | |
| $query = $conn->prepare($query); | |
| $query->execute(); | |
| databaseError($conn->errorInfo()); | |
| foreach ($query->fetchAll() as $row) { | |
| add_node($row['abn'], $row['name']); | |
| $edges[] = array("head"=>$row['SONID'], "tail"=>$row['abn'], "weight"=> 0.1); | |
| } | |
| echo '</nodes> | |
| <edges>' . PHP_EOL; | |
| foreach ($edges as $edge) { | |
| add_edge($edge['head'], $edge['tail']); | |
| } | |
| echo ' </edges> | |
| </graph> | |
| </gexf>' . PHP_EOL; | |
| ?> | |