--- a/bubbletree.php +++ b/bubbletree.php @@ -1,1 +1,108 @@ +<!DOCTYPE html> +<html xmlns="http://www.w3.org/1999/xhtml"> +<head> + <meta charset="UTF-8"/> + <title>Minimal BubbleTree Demo</title> + <script type="text/javascript" src="http://code.jquery.com/jquery-1.7.2.js"></script> + <script type="text/javascript" src="javascripts/bubbletree/lib/jquery.history.js"></script> + <script type="text/javascript" src="javascripts/bubbletree/lib/raphael.js"></script> + <script type="text/javascript" src="javascripts/bubbletree/lib/vis4.js"></script> + <script type="text/javascript" src="javascripts/bubbletree/lib/Tween.js"></script> + <script type="text/javascript" src="javascripts/bubbletree/build/bubbletree.js"></script> + <link rel="stylesheet" type="text/css" href="javascripts/bubbletree/build/bubbletree.css" /> + <script type="text/javascript" src="javascripts/bubbletree/styles/cofog.js"></script> + + + <script type="text/javascript"> + + $(function() { + <?php +include_once('include/common.inc.php'); + +include("lib/Color.php"); +$color = new Lux_Color(); + +$portfolios = Array(); + +$db = $server->get_db('disclosr-agencies'); +try { + $rows = $db->get_view("app", "byDeptStateName", null, true)->rows; + foreach ($rows as $row) { + $portfolios[trim(str_replace(Array("Department of","Department","the","'","`"),"",$row->key))] = $row->value; + } +} catch (SetteeRestClientException $e) { + setteErrorHandler($e); +} + +$agencies = Array(); +try { + $rows = $db->get_view("app", "byCanonicalName", null, true)->rows; +//print_r($rows); + foreach ($rows as $row) { + $employees = 0; + $portfolioid = 0; + if ($row->value->employees) $employees = $row->value->employees; + if (isset($row->value->statistics->employees)) { +$agencyEmployeesArray = object_to_array($row->value->statistics->employees); + $employees = $agencyEmployeesArray["2010-2011"]["value"]; +} +if (!($employees > 0)) $employees =0; + if (isset($row->value->parentOrg)) $portfolioid = $row->value->parentOrg; + if (isset($row->value->orgType) && $row->value->orgType == "FMA-DepartmentOfState") $portfolioid = $row->id; + $agencies[$portfolioid][$row->value->name] = $employees; + } +} catch (SetteeRestClientException $e) { + setteErrorHandler($e); +} +//print_r($portfolios); +//print_r($agencies); +$i = 0; +foreach ($portfolios as $portfolioName => $portfolioID) { +$i++; +$portfolioColor = $color->hsv2hex(Array($i/10, .7, abs(($i*(1/10))-.5) + .5)); + $subnodes = Array(); + $portfolioEmployees = 0; + foreach ($agencies[$portfolioID] as $agencyName => $agencyEmployees) { + $agencyColor = $color->hsv2hex(Array($i/10, rand(1,10)/10, abs(($i*(1/10))-.5) + .5)); + $subnodes[] = Array( + "label" => str_replace(Array("'","`"),"",$agencyName), + "amount" => $agencyEmployees, + "color" => "#".$agencyColor + ); + $portfolioEmployees += $agencyEmployees; + } + $nodes[] = Array( + "label" => $portfolioName, + "amount" => $portfolioEmployees, + "color" => "#".$portfolioColor, + "children" => $subnodes + ); + $total += $portfolioEmployees; +} +$data = Array( + "label" => "Australian Federal Government", + "amount" => $total, + "color" => "#000000", + "children" => $nodes +); +echo "var data =eval('('+'" . json_encode($data) . "'+')');"; +?> + + new BubbleTree({ + data: data, + container: '.bubbletree' + }); + + + }); + + </script> +</head> +<body> + <div class="bubbletree-wrapper"> + <div class="bubbletree"></div> + </div> +</body> +</html> +