| <?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(); | |
| ?> | |