{$herinfo['period_deadline']} JOIN ( SELECT period_id, ppl2grp.ppl_id, PTA(pta_id) herinfo, grp.grp_id, pta_id FROM rex JOIN $kldv.ppl2grp ON ppl2grp.ppl_id = rex.ppl_id AND ppl2grp.ppl_enter <= {$herinfo['period_deadline']} AND ppl2grp.ppl_exit > {$herinfo['period_deadline']} JOIN $kldv.grp ON grp.grp_id = ppl2grp.grp_id JOIN $kldv.subj ON subj.subj_id = rex.subj_id JOIN $kldv.grp2subj ON grp2subj.subj_id = rex.subj_id AND grp2subj.grp_id = grp.grp_id WHERE period_id = {$herinfo['period_id']} ) AS bla ON bla.ppl_id = ppl2grp.ppl_id JOIN roosterdetail ON rooster_id = $rooster_id AND roosterdetail.pta_id = bla.pta_id AND roosterdetail.grp_id = bla.grp_id JOIN $kldv.ppl ON ppl.ppl_id = ppl2grp.ppl_id JOIN $kldv.ppl2grp AS ppl2stamklas ON ppl2stamklas.ppl_id = ppl.ppl_id AND ppl2stamklas.ppl_enter <= {$herinfo['period_deadline']} AND ppl2stamklas.ppl_exit > {$herinfo['period_deadline']} JOIN $kldv.grp AS stamklas ON stamklas.grp_id = ppl2stamklas.grp_id AND stamklas.grp_home = 1 WHERE grp.grp_name LIKE '%q' ORDER BY ppl_surname, ppl_forename, ppl_prefix EOQ , $_GET['klas']); $moments = mdb2_all_assoc_rekey($db, << $info) { $select .= <<LOK?') AS CHAR CHARSET utf8)), NULL), '-') `$info` EOS; //$select .= ", IFNULL(GROUP_CONCAT(IF(moment_id = $moment_id, CONCAT(info, '/', UPPER(lok)), NULL)), '-') `$info`"; $outer_select .= ", `$info`"; } $hers = mdb2_query($db, << {$herinfo['period_deadline']} JOIN ( SELECT period_id, ppl2grp.ppl_id, GROUP_CONCAT(CONCAT(CAST(PTA(rex.pta_id) AS CHAR CHARSET utf8), ' ', IFNULL(CONCAT(CASE WHEN DATE_FORMAT(lessdetail.date, '%%w') = 0 THEN 'zondag' WHEN DATE_FORMAT(lessdetail.date, '%%w') = 1 THEN 'maandag' WHEN DATE_FORMAT(lessdetail.date, '%%w') = 2 THEN 'dinsdag' WHEN DATE_FORMAT(lessdetail.date, '%%w') = 3 THEN 'woensdag' WHEN DATE_FORMAT(lessdetail.date, '%%w') = 4 THEN 'donderdag' WHEN DATE_FORMAT(lessdetail.date, '%%w') = 5 THEN 'vrijdag' WHEN DATE_FORMAT(lessdetail.date, '%%w') = 6 THEN 'zaterdag' END, ' ', DATE_FORMAT(lessdetail.date, '%%e'), ' ', CASE WHEN DATE_FORMAT(lessdetail.date, '%%c') = 1 THEN 'januari' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 2 THEN 'februari' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 3 THEN 'maart' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 4 THEN 'april' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 5 THEN 'mei' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 6 THEN 'juni' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 7 THEN 'juli' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 8 THEN 'augustus' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 9 THEN 'september' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 10 THEN 'oktober' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 11 THEN 'november' WHEN DATE_FORMAT(lessdetail.date, '%%c') = 12 THEN 'december' END , ' ', TIME_FORMAT(lessdetail.time_start, '%%H:%%i'), '-', TIME_FORMAT(lessdetail.time_end, '%%H:%%i'), '/', IFNULL(UPPER(roosterdetail.lok), 'LOK?'), '/', IFNULL(UPPER(roosterdetail.surv), 'DOC?')), 'niet ingeroosterd')) ORDER BY lessdetail.date, lessdetail.time_start SEPARATOR '
') info FROM rex JOIN $kldv.ppl2grp ON ppl2grp.ppl_id = rex.ppl_id AND ppl2grp.ppl_enter <= {$herinfo['period_deadline']} AND ppl2grp.ppl_exit > {$herinfo['period_deadline']} JOIN $kldv.grp ON grp.grp_id = ppl2grp.grp_id JOIN $kldv.subj ON subj.subj_id = rex.subj_id JOIN $kldv.grp2subj ON grp2subj.subj_id = rex.subj_id AND grp2subj.grp_id = grp.grp_id JOIN $kldv.year2grp2subj ON grp2subj.grp2subj_id = year2grp2subj.grp2subj_id AND year_id = {$herinfo['year_id']} AND grp2subj_enter <= {$herinfo['period_deadline']} AND grp2subj_exit > {$herinfo['period_deadline'] LEFT JOIN roosterdetail ON rooster_id = $rooster_id AND roosterdetail.pta_id = rex.pta_id AND roosterdetail.grp_id = grp.grp_id LEFT JOIN ( SELECT rooster_id, pta_id, date, time_start, time_end FROM roosterdetail WHERE rooster_id = $rooster_id GROUP BY pta_id ) AS lessdetail ON lessdetail.pta_id = rex.pta_id WHERE period_id = {$herinfo['period_id']} GROUP BY ppl_id ) AS bla ON bla.ppl_id = ppl2grp.ppl_id JOIN $kldv.ppl ON ppl.ppl_id = ppl2grp.ppl_id JOIN $kldv.ppl2grp AS ppl2stamklas ON ppl2stamklas.ppl_id = ppl.ppl_id AND ppl2stamklas.ppl_enter <= {$herinfo['period_deadline']} AND ppl2stamklas.ppl_exit > {$herinfo['period_deadline']} JOIN $kldv.grp AS stamklas ON stamklas.grp_id = ppl2stamklas.grp_id AND stamklas.grp_home = 1 WHERE grp.grp_name LIKE '%q' ORDER BY ppl_surname, ppl_forename, ppl_prefix EOQ , $_GET['klas']); $klas = $_GET['klas']; if (!($row = $hers->fetchRow(MDB2_FETCHMODE_ORDERED))) { if ($afkorting && $klas) $msg = htmlenc($afkorting).' heeft op dit moment geen herkansers uit klas '.htmlenc($klas).'.'; else if ($afkorting) $msg = htmlenc($afkorting). ' heeft op dit moment geen herkansers.'; else if ($klas) $msg = 'Geen enkele leerling uit '.htmlenc($klas).' heeft op dit moment een herkansing opgegeven.'; else $msg = 'Geen enkele leerling heeft op dit moment een herkansing opgegeven.'; error_user('Geen herkansingen gevonden', $msg); } $hers->seek(); html_start(); ?> terug

Leerlingroosters voor klas(sen)

Per leerling