Add hierarchical graph
[disclosr.git] / graph.php
blob:a/graph.php -> blob:b/graph.php
--- a/graph.php
+++ b/graph.php
@@ -1,1 +1,47 @@
+<?php
+include_once('include/common.inc.php');
+//include_header();
+?>
+<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
+<script src="lib/springy/springy.js"></script>
+<script src="lib/springy/springyui.js"></script>
+<script>
+    var graph = new Graph();
+    var nodes = [];
+<?php
+$db = $server->get_db('disclosr-agencies');
 
+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;
+    }
+} catch (SetteeRestClientException $e) {
+    setteErrorHandler($e);
+}
+try {
+    $rows = $db->get_view("app", "parentOrgs", null, true)->rows;
+ //   print_r($rows);
+    foreach ($rows as $row) {
+        echo "graph.newEdge(nodes[\"{$row->key}\"], nodes['{$row->value}'], {color: '#00A0B0'});".PHP_EOL;
+    }
+} catch (SetteeRestClientException $e) {
+    setteErrorHandler($e);
+}
+?>
+     window.onload = function() {
+                $(document).ready(function() {
+        var springy = $('#springydemo').springy({
+            graph: graph
+        });
+                });
+     };
+</script>
+
+<canvas id="springydemo" width="960" height="480" />
+<?php
+//include_footer();
+?>
+
+