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