--- a/documents/charts.php +++ b/documents/charts.php @@ -1,1 +1,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(); +?> + +