1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
<!doctype html>
<html lang="nb">
<head>
<meta charset="utf-8" />
<title>Hvor mange dokumenter er journalført i hver etat og hvor mange er unntatt innsyn?</title>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/highcharts/2.2.2/highcharts.js"></script>
<!-- <script src="https://code.highcharts.com/modules/exporting.js"></script>-->
<script src="https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.3.3/underscore-min.js"></script>
<script>
$(function()
{
var chart;
var query_url = "https://api.scraperwiki.com/api/1.0/datastore/sqlite?format=jsondict&name=postliste-oep&query=select%20Agency%2C%22Grounds%20for%20exemption%20document%22%20as%20ex%2C%20count(*)%20as%20num%20from%20%60swdata%60%20group%20by%20Agency%2Cex%20";
function get_chart_opts(agencies, series) {
return {
chart: { renderTo: 'container', type: 'bar' },
title: { text: 'Hvor mange dokumenter er journalført i hver etat og hvor mange er unntatt innsyn?' },
xAxis: { categories: agencies },
yAxis: {
min: 0,
title: { text: "Antall journalførte dokumenter" },
},
legend: {
backgroundColor: '#FFFFFF',
reversed: true
},
tooltip: {
formatter: function() {
return ''+ this.series.name + ': '+ this.y + ' ('+parseInt(this.percentage) + '%)';
}
},
plotOptions: {
series: {
stacking: 'percent'
}
},
series: series
};
}
function populate_chart(data) {
// TODO: Very naive iteration today. Should be optimized
var agencies = _.uniq( _.pluck(data, 'Agency') );
var totals = {};
var not_exemption = {};
var series = [];
// traverse and find data
_.each(data, function(entry) {
var agency_name = entry['Agency'];
if (agency_name) {
if (! totals[agency_name]) {
totals[agency_name] = 0;
}
totals[agency_name] += entry['num'];
if ("" == entry['ex']) {
not_exemption[agency_name] = entry['num'];
}
}
});
// make series
series.push({ name: 'Ingen merknader',
data: _.map(agencies, function(agency) {
return not_exemption[agency];
})
});
series.push({ name: 'Unntatt innsyn',
data: _.map(agencies, function(agency) {
return totals[agency] - not_exemption[agency];
})
});
chart = new Highcharts.Chart(get_chart_opts(agencies, series));
};
$(document).ready(function() {
$.ajax({ url: query_url, dataType: 'json', success: function(data){ populate_chart(data); } });
});
}
);
</script>
</head>
<body>
<div id="container" style="height: 2000px;width: 100%;margin: 0 auto"></div>
<p>Alle dokumenter som har oppgitt en grunn for å unnlate offentligjøring vil telles som "Unnatt innsyn".</p>
</body>
</html>
|
