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) {