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 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 | <?php include('template.inc.php'); include_header_documents(""); include_once('../include/common.inc.php'); $agenciesdb = $server->get_db('disclosr-agencies'); $idtoname = Array(); foreach ($agenciesdb->get_view("app", "byCanonicalName")->rows as $row) { $idtoname[$row->id] = trim($row->value->name); } $foidocsdb = $server->get_db('disclosr-foidocuments'); ?> <div class="foundation-header"> <h1><a href="about.php">Charts</a></h1> <h4 class="subheader">Lorem ipsum.</h4> </div> <div id="employees" style="width:1000px;height:900px;"></div> <script id="source"> window.onload = function() { $(document).ready(function() { var d1 = [], start = new Date("2009/01/01 01:00").getTime(), options, graph, i, x, o; <?php try { $rows = $foidocsdb->get_view("app", "byDate?group=true", null, true)->rows; $dataValues = Array(); foreach ($rows as $row) { $dataValues[$row->value] = $row->key; } $i = 0; ksort($dataValues); foreach ($dataValues as $value => $key) { $date = date_create_from_format('Y-m-d', $key); if (date_format($date, 'U') != "") { echo " d1.push([".date_format($date, 'U')."000, $value]);" . PHP_EOL; // echo " emplabels.push('$key');" . PHP_EOL; $i++; } } } catch (SetteeRestClientException $e) { setteErrorHandler($e); } ?> options = { xaxis : { mode : 'time', labelsAngle : 45 }, selection : { mode : 'x' }, HtmlText : false, title : 'Time' }; // Draw graph with default options, overwriting with passed options function drawGraph (opts) { // Clone the options, so the 'options' variable always keeps intact. o = Flotr._.extend(Flotr._.clone(options), opts || {}); // Return a new graph. return Flotr.draw( document.getElementById("employees"), [ d1 ], o ); } graph = drawGraph(); Flotr.EventAdapter.observe(container, 'flotr:select', function(area){ // Draw selected area graph = drawGraph({ xaxis : { min : area.x1, max : area.x2, mode : 'time', labelsAngle : 45 }, yaxis : { min : area.y1, max : area.y2 } }); }); // When graph is clicked, draw the graph with default area. Flotr.EventAdapter.observe(container, 'flotr:click', function () { graph = drawGraph(); }); }); }; </script> <?php include_footer_documents(); ?> |