1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 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(); ?> |