Better graph, include social media in schema for agencies
[disclosr.git] / graph.php
blob:a/graph.php -> blob:b/graph.php
--- a/graph.php
+++ b/graph.php
@@ -10,36 +10,47 @@
     var nodes = [];
 <?php
 $db = $server->get_db('disclosr-agencies');
-
+echo "nodes[\"fedg\"] = graph.newNode({label: \"Federal Government - Commonwealth of Australia\"});" . PHP_EOL;
 try {
     $rows = $db->get_view("app", "byCanonicalName", null, true)->rows;
     //print_r($rows);
     foreach ($rows as $row) {
-        echo "nodes[\"{$row->value}\"] = graph.newNode({label: \"{$row->key}\"});".PHP_EOL;
+        echo "nodes[\"{$row->value}\"] = graph.newNode({label: \"{$row->key}\"});" . PHP_EOL;
     }
 } catch (SetteeRestClientException $e) {
     setteErrorHandler($e);
 }
+
+try {
+    $rows = $db->get_view("app", "byDeptStateName", null, true)->rows;
+    //print_r($rows);
+    foreach ($rows as $row) {
+        echo "graph.newEdge(nodes[\"fedg\"], nodes['{$row->value}'], {color: '#00A0B0'});" . PHP_EOL;
+    }
+} catch (SetteeRestClientException $e) {
+    setteErrorHandler($e);
+}
+
 try {
     $rows = $db->get_view("app", "parentOrgs", null, true)->rows;
- //   print_r($rows);
+    //   print_r($rows);
     foreach ($rows as $row) {
-        echo "graph.newEdge(nodes[\"{$row->key}\"], nodes['{$row->value}'], {color: '#00A0B0'});".PHP_EOL;
+        echo "graph.newEdge(nodes[\"{$row->key}\"], nodes['{$row->value}'], {color: '#FFA0B0'});" . PHP_EOL;
     }
 } catch (SetteeRestClientException $e) {
     setteErrorHandler($e);
 }
 ?>
-     window.onload = function() {
-                $(document).ready(function() {
-        var springy = $('#springydemo').springy({
-            graph: graph
+    window.onload = function() {
+        $(document).ready(function() {
+            var springy = $('#springydemo').springy({
+                graph: graph
+            });
         });
-                });
-     };
+    };
 </script>
 
-<canvas id="springydemo" width="960" height="480" />
+<canvas id="springydemo" width="1260" height="680" />
 <?php
 //include_footer();
 ?>