--- a/graph.php +++ b/graph.php @@ -10,36 +10,47 @@ var nodes = []; 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 + }); }); - }); - }; + }; - +