array('rel' => 'llsj'), 'leerjaar' => array('rel' => 'llsj'), 'opleiding' => array('rel' => 'llsj'), 'examenjaar' => array( 'rel' => 'llsj', 'magnegeer' => true), 'profiel' => array('rel' => 'pakket') ); get_stuff($stuff); $sgj = get_sgj($stuff); $bril = array('select' => array (), 'concat' => array (), 'sum' => array(), 'join' => array (), 'group_by' => array ()); if (!isset($_GET['cenisentl'])) { bril_add_vakken($bril, 'g_en', 'entl,cen'); } //if (isset($_GET['f_opleiding']) && in_array('G', $_GET['f_opleiding'])) // bril_add_vakken($bril, 'ktc', 'lakc,grkc'); $bril_type = get_bril_type(); //$bril_type = 'Alg'; //if (isset($_GET['bril'])) $bril_type = $_GET['bril']; //if (!isset($brillen[$bril_type])) fatal("impossible value for bril {$_GET['bril']}"); bril_add($bril, $brillen[$bril_type]); $bril_concat = implode(", '_', ", $bril['concat']); $bril_select = implode(', ', $bril['select']); $bril_group_by = implode(', ', $bril['group_by']); $bril_sum = implode(' + ', $bril['sum']).' aantal'; $bril_join = implode("\n", $bril['join']); $vakken = mdb2_all_assoc_rekey($db, "SELECT eq_weergave, 0 FROM eq JOIN eq_type USING (eq_type_id) WHERE eq_type = 'vak'"); foreach ($vakken as $vak => $tmp) { $bril2 = array('select' => array (), 'concat' => array (), 'sum' => array(), 'join' => array (), 'group_by' => array ()); bril_add_tel($bril2, $vak); $bril2_select = implode(', ', $bril2['select']); $bril2_join = implode("\n", $bril2['join']); $vakken[$vak] = mdb2_single_val($db, <<', COUNT(llsj_id), '') llj, CONCAT('', COUNT(DISTINCT leerlingnummer), '') ll{$sgj['select']}, $bril_select, $bril_sum FROM llsj JOIN ( SELECT llsj_id, eq_weergave AS leerlingnummer FROM llsj2eq JOIN eq USING (eq_id) JOIN eq_type USING (eq_type_id) WHERE eq_type = 'leerlingnummer' ) AS leerlingnummer USING (llsj_id) JOIN ( SELECT llsj_id, pakket_id FROM llsj2eq JOIN eq USING (eq_id) JOIN eq_type USING (eq_type_id) JOIN pakket2eq USING (eq_id) WHERE eq_type = 'pakket' ) AS pakket USING (llsj_id) {$sgj['join']} $bril_join GROUP BY $bril_group_by{$sgj['group_by']} ORDER BY COUNT(llsj_id) DESC EOQ ); html_start(); ?>
equivalent vak cen=entl'); show_bril_checkboxen($bril_type); ?>

Analyse van pakketkeuze door de bril van

Aantal verschillende profielen (op basis van de ingestelde filters): {$assoc['same']}.\n"); mdb2_res_table($res); ?>[export excel][link naar deze pagina]'; $row2 = ''; $row3 = ''; foreach ($vakken as $vak => $count) { if ($count == 0) continue; $row1 .= ''.$vak.''; $row2 .= ''.$count.''; $row3 .= ''.round(($count/$assoc['llj'])*100).'%'; } $row1 .= ''; $row2 .= ''; $row3 .= ''; echo(''.$row1.$row2.$row3.'
'); ?>