<?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(); |
|
$idtofoirequestssuccessful = 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); |
|
$foirequestssuccessful = 0; |
|
if(isset($row->value->statistics->foiRequests)) { |
|
foreach ($row->value->statistics->foiRequests as $statperiod) { |
|
$statperiod=object_to_array($statperiod); |
|
if (isset($statperiod["Requests for other information granted in full"])) $foirequestssuccessful += $statperiod["Requests for other information granted in full"]; |
|
if (isset($statperiod["Requests for other information granted in part"])) $foirequestssuccessful += $statperiod["Requests for other information granted in part"]; |
|
} |
|
} |
|
$idtofoirequestssuccessful[$row->id] =$foirequestssuccessful; |
} |
} |
$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="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: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 = [], |
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(); |
|
foreach ($rows as $row) { |
|
$dataValues[$row->key] = $row->value; |
|
} |
|
$i = 0; |
|
ksort($dataValues); |
|
foreach ($dataValues as $key => $value) { |
|
$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); |
|
} |
|
?> |
|
|
|
|
$dataValues = Array(); |
options1 = { |
foreach ($rows as $row) { |
xaxis: { |
$dataValues[$row->key] = $row->value; |
mode: 'time', |
} |
labelsAngle: 45 |
$i = 0; |
}, |
ksort($dataValues); |
selection: { |
foreach ($dataValues as $key => $value) { |
mode: 'x' |
$date = date_create_from_format('Y-m-d', $key); |
}, |
if (date_format($date, 'U') != "") { |
HtmlText: false, |
echo " d1.push([".date_format($date, 'U')."000, $value]);" . PHP_EOL; |
title: 'Disclosure Log entries added by Date' |
// echo " emplabels.push('$key');" . PHP_EOL; |
}; |
$i++; |
|
} |
|
} |
|
} catch (SetteeRestClientException $e) { |
|
setteErrorHandler($e); |
|
} |
|
?> |
|
|
|
|
// Draw graph with default options, overwriting with passed options |
|
function drawGraph(opts) { |
|
|
|
// Clone the options, so the 'options' variable always keeps intact. |
options1 = { |
o1 = Flotr._.extend(Flotr._.clone(options1), opts || {}); |
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. |
// Return a new graph. |
o1 = Flotr._.extend(Flotr._.clone(options1), opts || {}); |
return Flotr.draw( |
|
document.getElementById("bydate"), |
|
[ d1 ], |
|
o1 |
|
); |
|
} |
|
|
// Return a new graph. |
graph = drawGraph(); |
return Flotr.draw( |
|
document.getElementById("bydate"), |
|
[ d1 ], |
|
o1 |
|
); |
|
} |
|
|
|
graph = drawGraph(); |
Flotr.EventAdapter.observe(document.getElementById("bydate"), 'flotr:select', function (area) { |
|
// Draw selected area |
Flotr.EventAdapter.observe(document.getElementById("bydate"), 'flotr:select', function(area){ |
graph = drawGraph({ |
// Draw selected area |
xaxis: { min: area.x1, max: area.x2, mode: 'time', labelsAngle: 45 }, |
graph = drawGraph({ |
yaxis: { min: area.y1, max: area.y2 } |
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 () { |
// When graph is clicked, draw the graph with default area. |
graph = drawGraph(); |
Flotr.EventAdapter.observe(document.getElementById("bydate"), 'flotr:click', function () { graph = drawGraph(); }); |
}); |
|
|
}); |
}); |
}; |
}; |
|
|
var d2 = []; |
var d2 = []; |
var agencylabels = []; |
var d3 = []; |
function agencytrackformatter(obj) { |
var agencylabels = []; |
|
function agencytrackformatter(obj) { |
return agencylabels[Math.floor(obj.x)] +" = "+obj.y; |
|
|
|
} |
|
function agencytickformatter(val, axis) { |
|
if (agencylabels[Math.floor(val)]) { |
|
return '<p style="margin-top:8em;-webkit-transform:rotate(-90deg);">'+(agencylabels[Math.floor(val)])+"</b>"; |
|
|
|
} else { |
|
return ""; |
|
} |
|
} |
|
<?php |
|
try { |
|
$rows = $foidocsdb->get_view("app", "byAgencyID?group=true",null, false,false,true)->rows; |
|
|
|
|
return agencylabels[Math.floor(obj.y)] + " = " + obj.x; |
|
|
$dataValues = Array(); |
} |
$i = 0; |
function agencytickformatter(val, axis) { |
foreach ($rows as $row) { |
if (agencylabels[Math.floor(val)]) { |
echo " d2.push([".$i.", $row->value]);" . PHP_EOL; |
return (agencylabels[Math.floor(val)]) ; |
echo " agencylabels.push(['".str_replace("'","",$idtoname[$row->key])."']);" . PHP_EOL; |
|
|
} else { |
$i++; |
return ""; |
} |
} |
} catch (SetteeRestClientException $e) { |
|
setteErrorHandler($e); |
|
} |
} |
?> |
<?php |
// Draw the graph |
try { |
Flotr.draw( |
$rows = $foidocsdb->get_view("app", "byAgencyID?group=true",null, false,false,true)->rows; |
document.getElementById("byagency"), |
function cmp($a, $b) |
[d2], |
{ |
{ |
return $a->value > $b->value; |
bars : { |
} |
show : true, |
usort($rows, "cmp"); |
horizontal : false, |
|
shadowSize : 0, |
$dataValues = Array(); |
barWidth : 0.5 |
$i = 0; |
}, |
foreach ($rows as $row) { |
mouse : { |
echo " d2.push([ $row->value,$i]);" . PHP_EOL; |
track : true, |
echo " d3.push([ ".$idtofoirequestssuccessful[$row->key].",$i]);" . PHP_EOL; |
relative : true, |
echo " agencylabels.push(['".str_replace("'","",$idtoname[$row->key])."']);" . PHP_EOL; |
trackFormatter: agencytrackformatter |
|
}, |
$i++; |
yaxis : { |
} |
min : 0, |
} catch (SetteeRestClientException $e) { |
autoscaleMargin : 1 |
setteErrorHandler($e); |
}, |
} |
xaxis: { |
?> |
minorTickFreq: 1, |
// Draw the graph |
noTicks: agencylabels.length, |
Flotr.draw( |
showMinorLabels: true, |
document.getElementById("byagency"), |
tickFormatter: agencytickformatter |
[d2], |
}, |
{ |
legend: { |
title: "Disclosure Log entries by Agency", |
show: false |
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: true |
|
} |
|
} |
|
); |
</script> |
</script> |
|
|
<?php |
<?php |
include_footer_documents(); |
include_footer_documents(); |
?> |
?> |
|
|
|
|