Graphing of has scores
[disclosr.git] / charts.php
blob:a/charts.php -> blob:b/charts.php
--- 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();
+?>