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>"; }
$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) { $text = get_stedelijkheid_oms($top5_elements[0]); $text = $text . 'e'; $kenmerk = get_stedelijkheid($top5_elements[0]); $num_gemeenten = get_count_gemeenten($kenmerk); echo "<h2>5 slechtste scores voor {$top5_gemeente} in de pijler {$top5_pijler}</h2>"; echo "vergelijking met {$text} 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 {$text} gemeenten (n={$num_gemeenten})</th>"; echo "</tr></thead><tbody>"; $q = $dbh->prepare("select oms, rank_own from barometer_{$top5_pijler} where cbs_cd =:top5 order by rank_own 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_own]; echo "<tr class=tabelrow>";