$label2 = 'provincie Zuid-Holland'; $q = $dbh->prepare("select {$col} AS val_tot from {$table} where indeling = 'tot'"); $q->execute(); $result = $q->fetch(); $perc_tot = $result[val_tot]; unset($cbs2); unset($cbs3); if ($regio2) { $label3 = get_ras($regio2); $query = "select {$col} AS val1 from {$table} where indeling = 'RAS' and indeling_cd = {$regio2}"; $result = mysql_query($query); $row = mysql_fetch_array($result); $perc2 = $row[val1]; } if ($regio3) { $label4 = get_ras($regio3); $query = "select {$col} AS val1 from {$table} where indeling = 'RAS' and indeling_cd = {$regio3}"; $result = mysql_query($query); $row = mysql_fetch_array($result); $perc3 = $row[val1]; } } $xml .= "<set label='{$label1}' value='{$perc}' color='{$color['2']}' />" . "\r\n"; if ($regio2 || $cbs2 || $pzh2) { $xml .= "<set label='{$label3}' value='{$perc2}' color='{$color['3']}' />" . "\r\n"; } if ($regio3 || $cbs3) { $xml .= "<set label='{$label4}' value='{$perc3}' color='{$color['4']}' />" . "\r\n"; } $xml .= "<set label='{$label2}' value='{$perc_tot}' color='{$color['0']}]' />" . "\r\n"; }
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; }
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>"; }