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>";
