| <?php | <?php |
| include('template.inc.php'); | include('template.inc.php'); |
| include_header_documents("Charts"); | include_header_documents("Charts"); |
| include_once('../include/common.inc.php'); | include_once('../include/common.inc.php'); |
| $agenciesdb = $server->get_db('disclosr-agencies'); | $agenciesdb = $server->get_db('disclosr-agencies'); |
| $idtoname = Array(); | $idtoname = Array(); |
| foreach ($agenciesdb->get_view("app", "byCanonicalName")->rows as $row) { | foreach ($agenciesdb->get_view("app", "byCanonicalName")->rows as $row) { |
| $idtoname[$row->id] = trim($row->value->name); | $idtoname[$row->id] = trim($row->value->name); |
| } | } |
| $foidocsdb = $server->get_db('disclosr-foidocuments'); | $foidocsdb = $server->get_db('disclosr-foidocuments'); |
| ?> | ?> |
| <div class="foundation-header"> | <div class="foundation-header"> |
| <h1><a href="about.php">Charts</a></h1> | <h1><a href="about.php">Charts</a></h1> |
| <h4 class="subheader">Lorem ipsum.</h4> | <h4 class="subheader">Lorem ipsum.</h4> |
| </div> | </div> |
| <div id="bydate" style="width:1000px;height:300px;"></div> | <div id="bydate" style="width:1000px;height:300px;"></div> |
| <div id="byagency" style="width:1200px;height:300px;"></div> | <div id="byagency" style="width:1200px;height:300px;"></div> |
| <script id="source"> | <script id="source"> |
| window.onload = function() { | window.onload = function () { |
| $(document).ready(function() { | $(document).ready(function () { |
| var | var |
| d1 = [], | d1 = [], |
| options1, | options1, |
| o1; | o1; |
| <?php | <?php |
| try { | try { |
| $rows = $foidocsdb->get_view("app", "byDateMonthYear?group=true",null, false,false,true)->rows; | $rows = $foidocsdb->get_view("app", "byDateMonthYear?group=true",null, false,false,true)->rows; |
| $dataValues = Array(); | $dataValues = Array(); |
| foreach ($rows as $row) { | foreach ($rows as $row) { |
| $dataValues[$row->key] = $row->value; | $dataValues[$row->key] = $row->value; |
| } | } |
| $i = 0; | $i = 0; |
| ksort($dataValues); | ksort($dataValues); |
| foreach ($dataValues as $key => $value) { | foreach ($dataValues as $key => $value) { |
| $date = date_create_from_format('Y-m-d', $key); | $date = date_create_from_format('Y-m-d', $key); |
| if (date_format($date, 'U') != "") { | if (date_format($date, 'U') != "") { |
| echo " d1.push([".date_format($date, 'U')."000, $value]);" . PHP_EOL; | echo " d1.push([".date_format($date, 'U')."000, $value]);" . PHP_EOL; |
| // echo " emplabels.push('$key');" . PHP_EOL; | // echo " emplabels.push('$key');" . PHP_EOL; |
| $i++; | $i++; |
| } | } |
| } | } |
| } catch (SetteeRestClientException $e) { | } catch (SetteeRestClientException $e) { |
| setteErrorHandler($e); | setteErrorHandler($e); |
| } | } |
| ?> | ?> |
| options1 = { | |
| options1 = { | xaxis: { |
| xaxis : { | mode: 'time', |
| mode : 'time', | labelsAngle: 45 |
| labelsAngle : 45 | }, |
| }, | selection: { |
| selection : { | mode: 'x' |
| mode : 'x' | }, |
| }, | HtmlText: false, |
| HtmlText : false, | title: 'Time' |
| title : 'Time' | }; |
| }; | |
| // Draw graph with default options, overwriting with passed options | |
| function drawGraph (opts) { | |
| // Clone the options, so the 'options' variable always keeps intact. | // Draw graph with default options, overwriting with passed options |
| o1 = Flotr._.extend(Flotr._.clone(options1), opts || {}); | function drawGraph(opts) { |
| // Return a new graph. | // Clone the options, so the 'options' variable always keeps intact. |
| return Flotr.draw( | o1 = Flotr._.extend(Flotr._.clone(options1), opts || {}); |
| document.getElementById("bydate"), | |
| [ d1 ], | |
| o1 | |
| ); | |
| } | |
| graph = drawGraph(); | // Return a new graph. |
| return Flotr.draw( | |
| Flotr.EventAdapter.observe(document.getElementById("bydate"), 'flotr:select', function(area){ | document.getElementById("bydate"), |
| // Draw selected area | [ d1 ], |
| graph = drawGraph({ | o1 |
| xaxis : { min : area.x1, max : area.x2, mode : 'time', labelsAngle : 45 }, | ); |
| yaxis : { min : area.y1, max : area.y2 } | } |
| }); | |
| }); | graph = drawGraph(); |
| // When graph is clicked, draw the graph with default area. | Flotr.EventAdapter.observe(document.getElementById("bydate"), 'flotr:select', function (area) { |
| Flotr.EventAdapter.observe(document.getElementById("bydate"), 'flotr:click', function () { graph = drawGraph(); }); | // 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(document.getElementById("bydate"), 'flotr:click', function () { | |
| graph = drawGraph(); | |
| }); | |
| }); | }); |
| }; | }; |
| var d2 = []; | var d2 = []; |
| var agencylabels = []; | var agencylabels = []; |
| function agencytrackformatter(obj) { | function agencytrackformatter(obj) { |
| return agencylabels[Math.floor(obj.x)] +" = "+obj.y; | return agencylabels[Math.floor(obj.x)] + " = " + obj.y; |
| } | } |
| function agencytickformatter(val, axis) { | function agencytickformatter(val, axis) { |
| if (agencylabels[Math.floor(val)]) { | if (agencylabels[Math.floor(val)]) { |
| return '<p style="margin-top:8em;-webkit-transform:rotate(-90deg);">'+(agencylabels[Math.floor(val)])+"</b>"; | return '<p style="margin-top:8em;-webkit-transform:rotate(-90deg);">' + (agencylabels[Math.floor(val)]) + "</b>"; |
| } else { | } else { |
| return ""; | return ""; |
| } | } |
| } | } |
| <?php | <?php |
| try { | try { |
| $rows = $foidocsdb->get_view("app", "byAgencyID?group=true",null, false,false,true)->rows; | $rows = $foidocsdb->get_view("app", "byAgencyID?group=true",null, false,false,true)->rows; |
| $dataValues = Array(); | $dataValues = Array(); |
| $i = 0; | $i = 0; |
| foreach ($rows as $row) { | foreach ($rows as $row) { |
| echo " d2.push([".$i.", $row->value]);" . PHP_EOL; | echo " d2.push([".$i.", $row->value]);" . PHP_EOL; |
| echo " agencylabels.push(['".str_replace("'","",$idtoname[$row->key])."']);" . PHP_EOL; | echo " agencylabels.push(['".str_replace("'","",$idtoname[$row->key])."']);" . PHP_EOL; |
| $i++; | $i++; |
| } | |
| } catch (SetteeRestClientException $e) { | |
| setteErrorHandler($e); | |
| } | } |
| } catch (SetteeRestClientException $e) { | ?> |
| setteErrorHandler($e); | // Draw the graph |
| } | Flotr.draw( |
| ?> | document.getElementById("byagency"), |
| // Draw the graph | [d2], |
| Flotr.draw( | { |
| document.getElementById("byagency"), | bars: { |
| [d2], | show: true, |
| { | horizontal: false, |
| bars : { | shadowSize: 0, |
| show : true, | barWidth: 0.5 |
| horizontal : false, | }, |
| shadowSize : 0, | mouse: { |
| barWidth : 0.5 | track: true, |
| }, | relative: true, |
| mouse : { | trackFormatter: agencytrackformatter |
| track : true, | }, |
| relative : true, | yaxis: { |
| trackFormatter: agencytrackformatter | min: 0, |
| }, | autoscaleMargin: 1 |
| yaxis : { | }, |
| min : 0, | xaxis: { |
| autoscaleMargin : 1 | minorTickFreq: 1, |
| }, | noTicks: agencylabels.length, |
| xaxis: { | showMinorLabels: true, |
| minorTickFreq: 1, | tickFormatter: agencytickformatter |
| noTicks: agencylabels.length, | }, |
| showMinorLabels: true, | legend: { |
| tickFormatter: agencytickformatter | show: false |
| }, | } |
| legend: { | } |
| show: false | ); |
| } | |
| } | |
| ); | |
| </script> | </script> |
| <?php | <?php |
| include_footer_documents(); | include_footer_documents(); |
| ?> | ?> |