<?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');
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;
    }
} 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);
    foreach ($rows as $row) {
        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
            });
        });
    };
</script>
 
<canvas id="springydemo" width="1260" height="680" />
<?php
//include_footer();
?>