--- a/charts.php +++ b/charts.php @@ -2,67 +2,79 @@ 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> +<div id="placeholder" style="width:900px;height:500px;"></div> <script id="source"> -window.onload = function() { - $(document).ready(function() { - var d1 = []; - var labels = []; + window.onload = function() { + $(document).ready(function() { + var d1 = []; + var labels = []; <?php try { - $rows = $db->get_view("app", "scoreHas?group=true", null, true)->rows; + $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; + + $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); } - $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]); + ?> + function trackformatter(obj) { + if (labels[Math.floor(obj.x)]) { + return (labels[Math.floor(obj.x)])+"="+obj.y; - } else { - return ""; - } - - }, - labelAngle: 90 + } else { + return ""; + } } - }); - + function tickformatter(val, axis) { + if (labels[Math.floor(val)]) { + return '<p style="margin-top:8em;-webkit-transform:rotate(-90deg);">'+(labels[Math.floor(val)])+"</b>"; + + } else { + return ""; + } + } + Flotr.draw(document.getElementById("placeholder"), [ {data: d1}], { + HtmlText: true, + bars : { + show : true + }, + mouse : { + track : true, + relative : true, + trackFormatter: trackformatter + },yaxis: { + min:0 + }, + xaxis: { + + minorTickFreq: 0.6, + noTicks : 19, + tickFormatter: tickformatter + } + }); -}); -}; + }); + }; + </script> <?php