--- a/charts.php +++ b/charts.php @@ -1,1 +1,70 @@ +<?php +include_once('include/common.inc.php'); +include_header(); +$db = $server->get_db('disclosr-agencies'); + +?> +<div class="foundation-header"> + <h1><a href="about.php">Charts</a></h1> + <h4 class="subheader">Lorem ipsum.</h4> +</div> +<div id="placeholder" style="width:900px;height:600px;"></div> +<script id="source"> +window.onload = function() { + $(document).ready(function() { + var d1 = []; + var labels = []; + <?php + try { + $rows = $db->get_view("app", "scoreHas?group=true", null, true)->rows; + + /*foreach ($rows as $key => $row) { + echo " d1.push([$key, {$row->value}]);".PHP_EOL; + echo " labels.push('{$row->key}');".PHP_EOL; + }*/ + $dataValues = Array(); + foreach ($rows as $row) { + $dataValues[$row->value] = $row->key; + } + $i = 0; + ksort($dataValues); + foreach($dataValues as $value => $key) { + + echo " d1.push([$i, $value]);".PHP_EOL; + echo " labels.push('$key');".PHP_EOL; + $i++; + } +} catch (SetteeRestClientException $e) { + setteErrorHandler($e); +} +?> + + $.plot($("#placeholder"), [ d1], { + series: { + bars: { show: true, barWidth: 0.6 } + }, + xaxis: { + tickFormatter: function formatter(val, axis) { + if (labels[val]) { + return(labels[val]); + + } else { + return ""; + } + + }, + labelAngle: 90 + } + }); + + + + +}); +}; +</script> + +<?php +include_footer(); +?>