function get_table_headers($table_title, $cbs, $regio, $cbs2, $regio2)
{
$table_title = urldecode($table_title);
if ($cbs) {
$gemeente = get_gemeente($cbs);
$stedelijkheid = get_stedelijkheid_oms($cbs);
}
if ($cbs2) {
$gemeente2 = get_gemeente($cbs2);
}
if ($regio) {
$regionaam = get_ras($regio);
}
if ($regio2) {
$regionaam2 = get_ras($regio2);
}
if ($cbs && !$cbs2 && !$regio2) {
$table_header = "<table class=tablesorter border=0 width=100% cellpadding=4 cellspacing=0><thead><tr VALIGN=top>\n <th width=30% align=left>{$table_title}</th>\n <th width=10% align=right>jaar</th>\n <th width=20% align=right>{$gemeente}</th>\n <th width=20% align=right>{$stedelijkheid}</th>\n <th width=20% align=right>provincie Zuid-Holland</th></tr></thead><tbody>";
}
if ($cbs && ($cbs2 || $regio2)) {
$table_header = "<table class=tablesorter border=0 width=100% cellpadding=4 cellspacing=0><thead><tr VALIGN=top>\n <th width=30% align=left>{$table_title}</th>\n <th width=10% align=right>jaar</th>\n <th width=15% align=right>{$gemeente}</th>\n <th width=15% align=right>{$gemeente2}{$regionaam2}</th>\n <th width=15% align=right>{$stedelijkheid}</th>\n <th width=15% align=right>provincie Zuid-Holland</th></tr></thead><tbody>";
}
if ($regio && !$cbs2 && !$regio2) {
$table_header = "<table class=tablesorter border=0 width=100% cellpadding=4 cellspacing=0><thead><tr VALIGN=top>\n <th width=40% align=left>{$table_title}</th>\n <th width=10% align=right>jaar</th>\n <th width=30% align=right>{$regionaam}</th>\n <th width=30% align=right>provincie Zuid-Holland</th></tr></thead><tbody>";
}
if ($regio && ($cbs2 || $regio2)) {
$table_header = "<table class=tablesorter border=0 width=100% cellpadding=4 cellspacing=0><thead><tr VALIGN=top>\n <th width=30% align=left>{$table_title}</th>\n <th width=10% align=right>jaar</th>\n <th width=20% align=right>{$regionaam}</th>\n <th width=20% align=right>{$gemeente2}{$regionaam2}</th>\n <th width=20% align=right>provincie Zuid-Holland</th></tr></thead><tbody>";
}
return $table_header;
}
$abs = $result[abs];
$bev = $result[bev];
$perc3 = round($abs / $bev * $scale, 1);
}
if ($cbs2) {
$label3 = htmlspecialchars(get_gemeente($cbs2), ENT_QUOTES);
//waarde van gemeente
$q = $dbh->prepare("select perc from {$cache_table} where nr =:nr and cbs_cd =:cbs2");
$q->bindParam(':nr', $nr);
$q->bindParam(':cbs2', $cbs2);
$q->execute();
$result = $q->fetch();
$perc2 = round($result[perc], 1);
}
if ($cbs3) {
$label4 = htmlspecialchars(get_gemeente($cbs3), ENT_QUOTES);
//waarde van gemeente
$q = $dbh->prepare("select perc from {$cache_table} where nr =:nr and cbs_cd =:cbs");
$q->bindParam(':nr', $nr);
$q->bindParam(':cbs', $cbs3);
$q->execute();
$result = $q->fetch();
$perc3 = round($result[perc], 1);
}
if ($pzh2 == true) {
//waarde van provincie
$label3 = 'provincie Zuid-Holland';
$query = "select sum(abs) as abs, sum(bev) as bev from {$cache_table} where nr = {$nr}";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$abs = $row[abs];
?>
<p id="text5">
<a href="gemeenten.php">GEMEENTEN</a>
</p>
<p id="text5">
<a href="medewerkers.php">MEDEWERKERS</a>
</p>
<div id="Content" class="clearfix">
<p id="text6">
<span id="textspan1">Hier kan je gemeenten aanpassen.
<form method="POST" action="">
<table class="no-border">
<thead><tr><td>Gemeente</td><td>aanpassen</td></tr></thead>
<tbody>
<?php
get_gemeente($gemeente_id);
?>
<tr><td></td><td><input type="submit" value="" name="btnSave" class='btnOpslaan'></td></tr>
</tbody>
</table>
</form>
<?php
if (isset($_POST['btnSave'])) {
$txtType = $_POST['txtType'];
$txtNaam = $_POST['txtNaam'];
$txtUrl = $_POST['txtUrl'];
update_gemeente($gemeente_id, $txtType, $txtNaam, $txtUrl);
}
?>
</span>
</p>
function get_table_headers($regio, $cbs, $num_comparisons, $compare, $screen_width, $pijler, $compare_years)
{
if ($cbs || is_numeric($compare[0]) || is_numeric($compare[1])) {
if ($cbs) {
$gemeente = get_gemeente($cbs);
$stedelijkheid = get_stedelijkheid_oms($cbs);
$stedelijkheid = str_replace(' ', '<br>', $stedelijkheid);
$stedelijkheid_oms = $stedelijkheid . 'e';
$stedelijkheid_oms = str_replace(' ', '<br>', $stedelijkheid_oms);
$kenmerk = get_stedelijkheid($cbs);
$num_gemeenten = get_count_gemeenten($kenmerk);
}
}
if ($regio) {
$regio_nm = get_ras($regio);
}
echo "<table class='barometer_table {$pijler}' border=0 width=100% cellpadding=4 cellspacing=0>";
echo "<thead><tr VALIGN=top>";
if ($compare_years == "on") {
$peildatum1 = 'mei 2012';
$peildatum2 = 'mei 2015';
echo "<th align=left colspan=2> </th>";
if ($gemeente) {
echo "<th colspan=10 align=center>{$gemeente}</th>";
} else {
echo "<th colspan=10 align=center>{$regio_nm}</th>";
}
if ($stedelijkheid) {
echo "<th colspan=8 align=center>{$stedelijkheid}</th>";
} else {
echo "<th colspan=8 align=center>provincie Zuid-Holland</th>";
}
echo "</tr>";
echo "<tr valign=top>";
echo "<th align=left colspan=2> </th>";
echo "<th colspan=4 align=center class=cell_variable_text>{$peildatum1}</th>";
echo "<th class=cell_variable_image><a href=# title='De meting van mei 2012 betreft verschillende peildata, de exacte peildatum kunt u zien door in de kolom \r\n relatief de toelichting te bekijken.' class=toelichting_header><img src=images/red.png class=image_toelichting></a></th>";
echo "<th colspan=4 align=center class=cell_variable_text>{$peildatum2}</th>";
echo "<th class=cell_variable_image><a href=# title='De meting van mei 2015 betreft verschillende peildata, de exacte peildatum kunt u zien door in de kolom \r\n relatief de toelichting te bekijken.' class=toelichting_header><img src=images/red.png class=image_toelichting></a></th>";
echo "<th colspan=4 align=center>{$peildatum1}</th>";
echo "<th colspan=4 align=center>{$peildatum2}</th>";
echo "</tr>";
echo "<tr valign=top>";
echo "<th align=left colspan=2> </th>";
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right colspan=2>index</th>";
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right colspan=2>index</th>";
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>index</th>";
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>index</th>";
echo "</tr>";
}
if ($compare_years == "off") {
if ($num_comparisons == 0) {
echo "<th align=left colspan=2> </th>";
echo "<th align=left> </th>";
if ($gemeente) {
echo "<th colspan=6 align=center>{$gemeente}</th>";
} else {
echo "<th colspan=4 align=center>{$regio_nm}</th>";
}
if ($stedelijkheid) {
echo "<th colspan=4 align=center>{$stedelijkheid}</th></tr>";
} else {
echo "<th colspan=4 align=center>provincie Zuid-Holland</th></tr>";
}
echo "<tr><th align=left colspan=2> </th>";
echo "<th align=left>peildatum</th>";
if ($gemeente) {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>rangorde<br>alle<br>gemeenten<br> (n=60)</th>";
echo "<th align=right>rangorde<br>{$stedelijkheid_oms}<br> gemeenten<br> (n={$num_gemeenten})</th>";
echo "<th align=right>index<br> ({$stedelijkheid} <br>=100)</th>";
} else {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>index (provincie=100)</th>";
}
//provincie
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>index</th>";
echo "</tr>";
}
if ($num_comparisons == 1) {
echo "<th align=left colspan=2> </th>";
echo "<th align=left> </th>";
if ($gemeente) {
echo "<th colspan=6 align=center>{$gemeente}</th>";
} else {
echo "<th colspan=4 align=center>{$regio_nm}</th>";
}
if (is_numeric($compare[0])) {
$compare1 = get_gemeente($compare[0]);
}
if (substr($compare[0], 0, 1) == 'R') {
$compare1 = get_ras($compare[0]);
}
if (substr($compare[0], 0, 1) == 'p') {
$compare1 = 'provincie Zuid-Holland';
}
if (is_numeric($compare[0])) {
if ($cbs && get_stedelijkheid($cbs) == get_stedelijkheid($compare[0])) {
echo "<th colspan=6 align=center>{$compare1}</th>";
} else {
echo "<th colspan=4 align=center>{$compare1}</th>";
}
} elseif ($cbs) {
echo "<th colspan=3 align=center>{$compare1}</th>";
} elseif (!$cbs) {
echo "<th colspan=4 align=center>{$compare1}</th>";
}
if ($stedelijkheid) {
echo "<th colspan=4 align=center>{$stedelijkheid}</th></tr>";
} else {
echo "<th colspan=4 align=center>provincie Zuid-Holland</th></tr>";
}
echo "<tr><th align=left colspan=2> </th>";
if ($screen_width < 1050) {
echo "<th align=left>peil-<br>datum</th>";
} else {
echo "<th align=left>peildatum</th>";
}
if ($gemeente) {
if ($screen_width < 1050) {
echo "<th align=right>abs</th>";
echo "<th align=right colspan=2>rel</th>";
echo "<th align=right>rang-<br>orde alle gem. (n=60)</th>";
echo "<th align=right>rang-<br>orde {$stedelijkheid_oms} gem. (n={$num_gemeenten})</th>";
} else {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>rangorde<br>alle<br>gemeenten (n=60)</th>";
echo "<th align=right>rangorde<br>{$stedelijkheid_oms}<br>gemeenten<br>(n={$num_gemeenten})</th>";
}
echo "<th align=right>index ({$stedelijkheid} =100)</th>";
} else {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>index (provincie=100)</th>";
}
if (is_numeric($compare[0])) {
if ($screen_width < 1050) {
echo "<th align=right>abs</th>";
echo "<th align=right colspan=2>rel</th>";
echo "<th align=right>rang-<br>orde alle gem. (n=60)</th>";
if ($cbs && get_stedelijkheid($cbs) == get_stedelijkheid($compare[0])) {
echo "<th align=right>rang-<br>orde {$stedelijkheid_oms} gem. (n={$num_gemeenten})</th>";
echo "<th align=right>index ({$stedelijkheid} =100)</th>";
}
} else {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>rangorde<br>alle<br>gemeenten (n=60)</th>";
if ($cbs && get_stedelijkheid($cbs) == get_stedelijkheid($compare[0])) {
echo "<th align=right>rangorde<br>{$stedelijkheid_oms}<br>gemeenten<br>(n={$num_gemeenten})</th>";
echo "<th align=right>index ({$stedelijkheid}<br>=100)</th>";
}
}
} elseif ($cbs) {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
} elseif (!$cbs) {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>index (provincie=100)</th>";
}
//provincie
if ($screen_width < 1050) {
echo "<th align=right>abs</th>";
echo "<th align=right colspan=2>rel</th>";
} else {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
}
echo "<th align=right>index</th>";
echo "</tr>";
}
if ($num_comparisons == 2) {
echo "<th align=left colspan=2> </th>";
echo "<th align=left> </th>";
echo "<th colspan=4 align=center>{$regio_nm}</th>";
if (is_numeric($compare[0])) {
$compare1 = get_gemeente($compare[0]);
}
if (substr($compare[0], 0, 1) == 'R') {
$compare1 = get_ras($compare[0]);
}
if (is_numeric($compare[1])) {
$compare2 = get_gemeente($compare[1]);
}
if (substr($compare[1], 0, 1) == 'R') {
$compare2 = get_ras($compare[1]);
}
echo "<th colspan=4 align=center>{$compare1}</th>";
echo "<th colspan=4 align=center>{$compare2}</th>";
echo "<th colspan=4 align=center>provincie Zuid-Holland</th></tr>";
echo "<tr><th align=left colspan=2> </th>";
echo "<th align=left>peildatum</th>";
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>index (provincie=100)</th>";
if (is_numeric($compare[0])) {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>rangorde alle gemeenten (n=60)</th>";
} else {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>index (provincie=100)</th>";
}
if (is_numeric($compare[1])) {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>rangorde alle gemeenten (n=60)</th>";
} else {
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>index (provincie=100)</th>";
}
//provincie
echo "<th align=right>absoluut</th>";
echo "<th align=right colspan=2>relatief</th>";
echo "<th align=right>index</th>";
echo "</tr>";
}
}
echo "</thead><tbody>";
}
<?php
include '../scripts/log_in.php';
require_once 'barometer_functions.php';
//elements is string met cbs-code en pijler
$elements = filter_input(INPUT_GET, 'elements', FILTER_SANITIZE_STRING);
$top5_elements = explode(',', $elements);
$top5_gemeente = get_gemeente($top5_elements[0]);
$top5_pijler = $top5_elements[1];
if (!$ranking) {
echo "<h2>5 slechtste scores voor {$top5_gemeente} in de pijler {$top5_pijler}</h2>";
echo "vergelijking met alle gemeenten<br><br>";
echo "<table class='barometer_table' border=0 width=100% cellpadding=4 cellspacing=0>";
echo "<thead><tr VALIGN=top>";
echo "<th width=80%>variabele</th>";
echo "<th width=20% align=right>rangorde alle gemeenten (n=60)</th>";
echo "</tr></thead><tbody>";
$q = $dbh->prepare("select oms, rank from barometer_{$top5_pijler} where cbs_cd =:top5 order by rank DESC limit 5");
$q->bindParam(':top5', $top5_elements[0]);
$q->execute();
$results = $q->fetchAll(PDO::FETCH_ASSOC);
for ($i = 0; count($results) - 1 >= $i; $i++) {
$oms = $results[$i][oms];
$rank = $results[$i][rank];
echo "<tr class=tabelrow>";
echo "<td>{$oms}</td>";
echo "<td align=right>{$rank}</td></tr>";
}
echo "</tbody></table>";
}
if ($ranking) {
