'); } if (isset($_GET['pta_ids']) && is_array($_GET['pta_ids'])) { if (count($_GET['pta_ids']) == 1 && $_GET['pta_ids'][0] === '') { $export_ptas = ''; $in = 'NULL'; $or2 = '1=1'; } else { $in = array(); foreach ($_GET['pta_ids'] as $pta_id) $in[] = mdb2_single_val($db, "SELECT pta_id FROM ptas WHERE pta_id = %i", $pta_id); $export_ptas = '-ptas_'.implode('_', $in); $in = implode(', ', $in); $or2 = '1=0'; } } else { error_user('pta_ids must be set', 'it makes no sense not to set it'); } $ppl_id = 0; if (isset($_GET['ppl_id']) && $_GET['ppl_id']) { $ppl_id = $_GET['ppl_id']; $afkorting = mdb2_single_val($db, << {$herinfo['period_deadline']} JOIN $kldv.ppl2grp AS grp2ppl ON grp2ppl.ppl_id = ppl2grp.ppl_id AND grp2ppl.ppl_enter <= {$herinfo['period_deadline']} AND grp2ppl.ppl_exit > {$herinfo['period_deadline']} JOIN $kldv.grp2subj ON grp2subj.grp_id = grp2ppl.grp_id JOIN $kldv.ppl2grp2subj ON ppl2grp2subj.grp2subj_id = grp2subj.grp2subj_id AND ppl2grp2subj.ppl_enter <= {$herinfo['period_deadline']} AND ppl2grp2subj.ppl_exit > {$herinfo['period_deadline']} JOIN $kldv.ppl ON ppl.ppl_id = ppl2grp2subj.ppl_id WHERE period_id = {$herinfo['period_id']} AND ppl.ppl_id = '%q' ORDER BY ppl_login EOQ , $_GET['ppl_id']); if (!$afkorting) error_user('Docent niet gevonden', 'Geselecteerde docent geeft geen les aan klassen die herkansingen opgeven via deze pagina'); $export_doc = "-${afkorting}"; $or = '1=0'; } else $or = '1=1'; if (!isset($_GET['selectie'])) { if ($or == '1=1') error_user("impossibru!", 'selectie is not set and or=1=1 ?!?!!'); } else if ($_GET['selectie'] == 'ALLEN') { $export_doc = ''; $or = '1=1'; } $rooster_id = get_rooster_id($db, $herinfo['period_id']); if ($rooster_id) { $rooster_info = mdb2_single_assoc($db, "SELECT * FROM rooster_ids WHERE rooster_id = $rooster_id"); } else $rooster_id = 0; $hers = mdb2_query($db, << {$herinfo['period_deadline']} JOIN $kldv.grp2subj ON grp2subj.grp_id = ppl2grp.grp_id AND grp2subj.subj_id = ptas.subj_id JOIN $kldv.ppl2grp2subj ON ppl2grp2subj.grp2subj_id = grp2subj.grp2subj_id AND ppl2grp2subj.ppl_enter <= {$herinfo['period_deadline']} AND ppl2grp2subj.ppl_exit > {$herinfo['period_deadline']} JOIN $kldv.ppl2grp AS ppl2grp2 ON ppl2grp2.ppl_id = ppl.ppl_id AND ppl2grp2.ppl_enter <= {$herinfo['period_deadline']} AND ppl2grp2.ppl_exit > {$herinfo['period_deadline']} JOIN $kldv.grp ON grp.grp_id = ppl2grp.grp_id JOIN $kldv.grp AS grp2 ON grp2.grp_id = ppl2grp2.grp_id JOIN $kldv.ppl AS doc ON ppl2grp2subj.ppl_id = doc.ppl_id JOIN $kldv.subj ON subj.subj_id = ptas.subj_id LEFT JOIN tijdverlengers.current ON current.llnr = ppl.ppl_login LEFT JOIN roosterdetail ON roosterdetail.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']} AND grp2.grp_home = 1 AND (doc.ppl_id = '%q' OR $or) AND (rex.pta_id IN ( $in ) OR $or2) AND stvt != 'BLOKKADE' GROUP BY rex_id ORDER BY onderdeel, lok, doc, is_stamklas, groep, REPLACE(ppl.ppl_surname, '-', ''), REPLACE(ppl.ppl_forename, '-', ''), ppl.ppl_prefix -- ORDER BY onderdeel, lok, doc.ppl_login, is_stamklas, grp.grp_name, ppl.ppl_surname, ppl.ppl_forename, ppl.ppl_prefix EOQ , $ppl_id); if (!($hers->numRows())) { error_user('Geen inschrijvingen gevonden', 'Geen enkele geselecteerde leerling is op dit moment ingeschreven voor en geselecteerde toets'); } $lijst_id = mdb2_single_val($db, "SELECT MAX(lijst_id) FROM tijdverlengers.lijst"); $lijst_time = mdb2_single_val($db, "SELECT t_creat FROM tijdverlengers.lijst WHERE lijst_id = $lijst_id"); $year = mdb2_single_val($db, "SELECT year_long FROM $kldv.years WHERE year_id = %i", $herinfo['year_id']); $header = $herinfo['period_desc'].' '.$year; $a3 = false; $landscape = false; $toetsweek = true; $lege_hokjes = 0; $gewenst_aantal_lijsten = 1; switch ($_GET['submit']) { case 'Spreadsheet': $filename = "export-her-TP{$herinfo['period_num']}$export_doc$export_ptas-". date("YmdHis").'.csv'; mdb2_res_export_excel($hers, $filename); /* in dit geval zijn we klaar */ exit; case 'Frontjes en dubbele lijsten': $gewenst_aantal_lijsten = 2; $frontje = true; $geenlijst = false; break; case 'Lijsten en frontjes': $frontje = true; $geenlijst = false; break; case 'Lijsten': $frontje = false; $geenlijst = false; break; case 'Frontjes': $frontje = true; $geenlijst = true; break; case 'Lijsten (landscape)': $toetsweek = false; $frontje = false; $geenlijst = false; $landscape = true; $lege_hokjes = 26; break; } $row = $hers->fetchRow(MDB2_FETCHMODE_ASSOC); $out = array(); $doc = $row['doc']; $docs = explode(',', $doc); $st = $row['onderdeel']; $date = $row['dag']; $start = $row['start']; $surv = $row['surv']; $lok = $row['lok']; $end = $row['end']; $lok = $row['lok']; $vak = $row['vak']; $groep = $row['groep']; $groeps = array($groep); $home = $row['is_stamklas']; $lln = array(); $first = true; $groepeer = 'LESGROEP'; if (isset($_GET['groepeer']) && $_GET['groepeer'] == 'LOKAAL') $groepeer = 'LOKAAL'; function merge_groups($groups) { sort($groups); $compressed = array(); foreach ($groups as $group) { $number = substr($group, -1); $root = substr($group, 0, -1); if (!isset($groups[$root])) { $groups[$root] = array(); } $compressed[$root][] = $number; } $output = array(); foreach ($compressed as $key => $values) { $output[] = $key.implode(',', $values); } $ret = implode(',', $output); return $ret; } do { if ($st != $row['onderdeel'] || $lok != $row['lok'] || ($groepeer == 'LESGROEP' && $groep != $row['groep'])) { sort($groeps); sort($docs); merge_groups($groeps); $out[] = array( 'doc' => implode(',', $docs), 'groepkaal' => merge_groups($groeps).($home?'/'.$vak:''), //'groepkaal' => implode(',', $groeps).($home?'/'.$vak:''), 'lijst' => $lln, 'st' => $st, 'date' => $date, 'start' => $start, 'end' => $end, 'lok' => $lok, 'surv' => $surv ); $doc = $row['doc']; $docs = explode(',', $doc); $st = $row['onderdeel']; $date = $row['dag']; $start = $row['start']; $end = $row['end']; $vak = $row['vak']; $groep = $row['groep']; $groeps = array($groep); $home = $row['is_stamklas']; $lok = $row['lok']; $surv = $row['surv']; $lln = array(); $lln[$groep.'/'.$doc] = array(); } else if ($groepeer != 'LESGROEP') { if ($doc != $row['doc']) { $doc = $row['doc']; foreach (explode(',', $doc) as $newdoc) { if (!in_array($newdoc, $docs)) $docs[] = $newdoc; } } if ($groep != $row['groep']) { $groep = $row['groep']; $lln[$groep.'/'.$doc] = array(); $home &= $row['is_stamklas']; if (!in_array($row['groep'], $groeps)) $groeps[] = $row['groep']; } } $first = false; $lln[$groep.'/'.$doc][] = array('llnr' => $row['llnr'], 'naam' => $row['naam'], 'text' => $row['bijzonderheden'], 'grp' => $row['stamklas']); } while (($row = $hers->fetchRow(MDB2_FETCHMODE_ASSOC))); sort($docs); sort($groeps); $out[] = array( 'doc' => implode(',', $docs), //'groepkaal' => implode(',', $groeps).($home?'/'.$vak:''), 'groepkaal' => merge_groups($groeps).($home?'/'.$vak:''), //'doc' => $doc, //'groepkaal' => $groep, //.($home?'/'.$vak:''), 'lijst' => $lln, 'st' => $st, 'date' => $date, 'start' => $start, 'end' => $end, 'lok' => $lok, 'surv' => $surv ); ?> Lijsten en frontjes voor <?=$header?> seek(); mdb2_res_table($hers); ?>
Wil je enkelzijdig printen? Kies bijvoorbeeld printer 'followme-zwart-enkelzijdig'.
$grplijst) { ?>

'.$elt['date'].' '.($elt['start']?$elt['start'].'—'.$elt['end'].' ':'').$elt['lok'].'/'.$elt['surv']:'')); ?>

nrnaam/llnr/klastijdverlenging?presenttijd
Gebaseerd op tijdsverlengerslijst versie en herkansingsrooster versie ().

$row['llnr'], 'text' => $row['text']); } } } ?>
TOETS
GROEP/VAK
DOCENT
DATUM
TIJD
TOEGESTANE HULPMIDDELEN EN EVENTUELE OPMERKINGEN
LOKAAL
SURVEILLANT
AANTALLEN
NOOD?
bel toestelnummer
VERR/HERI: 415/436
EILE: 417 (of 06-????????)
MEYR: 420 (of 06-41917541)
ICT helpdesk: 488

Gebaseerd op tijdsverlengerslijst versie en herkansingsrooster versie () .