<?php |
<?php |
include('template.inc.php'); |
include('template.inc.php'); |
include_header_documents(""); |
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"></h4> |
</div> |
</div> |
<div id="employees" style="width:1000px;height:900px;"></div> |
<div id="bydate" style="width:1000px;height:300px;"></div> |
|
<div id="byagency" style="width:1000px;height:1400px;"></div> |
<script id="source"> |
<script id="source"> |
window.onload = function() { |
window.onload = function () { |
$(document).ready(function() { |
$(document).ready(function () { |
var |
var |
d1 = [], |
d1 = [], |
start = new Date("2009/01/01 01:00").getTime(), |
options1, |
options, |
o1; |
graph, |
|
i, x, o; |
|
|
|
<?php |
<?php |
try { |
try { |
$rows = $foidocsdb->get_view("app", "byDate?group=true", null, 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->value] = $row->key; |
$dataValues[$row->key] = $row->value; |
} |
} |
$i = 0; |
$i = 0; |
ksort($dataValues); |
ksort($dataValues); |
foreach ($dataValues as $value => $key) { |
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 = { |
options = { |
xaxis: { |
xaxis : { |
mode: 'time', |
mode : 'time', |
labelsAngle: 45 |
labelsAngle : 45 |
}, |
}, |
selection: { |
selection : { |
mode: 'x' |
mode : 'x' |
}, |
}, |
HtmlText: false, |
HtmlText : false, |
title: 'Disclosure Log entries added by Date' |
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 |
o = Flotr._.extend(Flotr._.clone(options), 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("employees"), |
|
[ d1 ], |
|
o |
|
); |
|
} |
|
|
|
graph = drawGraph(); |
// Return a new graph. |
|
return Flotr.draw( |
Flotr.EventAdapter.observe(container, '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(container, '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 agencylabels = []; |
|
function agencytrackformatter(obj) { |
|
|
|
return agencylabels[Math.floor(obj.y)] + " = " + obj.x; |
|
|
|
} |
|
function agencytickformatter(val, axis) { |
|
if (agencylabels[Math.floor(val)]) { |
|
return (agencylabels[Math.floor(val)]) ; |
|
|
|
} else { |
|
return ""; |
|
} |
|
} |
|
<?php |
|
try { |
|
$rows = $foidocsdb->get_view("app", "byAgencyID?group=true",null, false,false,true)->rows; |
|
function cmp($a, $b) |
|
{ |
|
return $a->value > $b->value; |
|
} |
|
usort($rows, "cmp"); |
|
|
|
$dataValues = Array(); |
|
$i = 0; |
|
foreach ($rows as $row) { |
|
echo " d2.push([ $row->value,$i]);" . PHP_EOL; |
|
echo " agencylabels.push(['".str_replace("'","",$idtoname[$row->key])."']);" . PHP_EOL; |
|
|
|
$i++; |
|
} |
|
} catch (SetteeRestClientException $e) { |
|
setteErrorHandler($e); |
|
} |
|
?> |
|
// Draw the graph |
|
Flotr.draw( |
|
document.getElementById("byagency"), |
|
[d2], |
|
{ |
|
title: "Disclosure Log entries by Agency", |
|
bars: { |
|
show: true, |
|
horizontal: true, |
|
shadowSize: 0, |
|
barWidth: 0.5 |
|
}, |
|
mouse: { |
|
track: true, |
|
relative: true, |
|
trackFormatter: agencytrackformatter |
|
}, |
|
yaxis: { |
|
minorTickFreq: 1, |
|
noTicks: agencylabels.length, |
|
showMinorLabels: true, |
|
tickFormatter: agencytickformatter |
|
}, |
|
xaxis: { |
|
min: 0, |
|
autoscaleMargin: 1 |
|
}, |
|
legend: { |
|
show: false |
|
} |
|
} |
|
); |
</script> |
</script> |
|
|
<?php |
<?php |
include_footer_documents(); |
include_footer_documents(); |
?> |
?> |
|
|
|
|