' $concat_cont grp.grp_name $concat_cont '' $concat_end link, grp.grp_name FROM $kldv.ppl2grp2subj #JOIN $kldv.grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id #JOIN $kldv.grp ON grp.grp_id = grp2subj.grp_id #JOIN $kldv.ppl2grp ON ppl2grp.grp_id = grp.grp_id #AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} #AND ppl2grp.ppl_exit >{$_SERVER['REQUEST_TIME']} #JOIN $kldv.ppl2grp AS grp2ppl ON grp2ppl.ppl_id = ppl2grp.ppl_id #AND grp2ppl.ppl_enter <= {$_SERVER['REQUEST_TIME']} #AND grp2ppl.ppl_exit >{$_SERVER['REQUEST_TIME']} #JOIN $kldv.grp AS stamklassen ON stamklassen.grp_id = grp2ppl.grp_id AND stamklassen.grp_home = 1 #JOIN $kldv.grp2grp ON grp2grp.grp0_id = stamklassen.grp_id #JOIN ( # SELECT grp_id FROM signal2grp # GROUP BY grp_id #) bla2 ON bla2.grp_id = grp2grp.grp1_id #WHERE ppl2grp2subj.ppl_id = {$_SESSION['ppl_id']} #AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} #AND ppl2grp2subj.ppl_exit > {$_SERVER['REQUEST_TIME']} #ORDER BY grp_name #EOQ #); #$leerlingen = mdb2_query($db, <<' $concat_cont lln.ppl_login $concat_cont '' $concat_end nr, #lln.ppl_forename voornaam, lln.ppl_prefix tussenv, lln.ppl_surname achternaam, #-- $concat_begin ' (' $concat_cont grp.grp_name $concat_cont ')' #CASE WHEN grp.grp_id = stamklassen.grp_id THEN $concat_begin ' (' $concat_cont grp.grp_name $concat_cont ')' ELSE #$concat_begin ' (' $concat_cont grp.grp_name $concat_cont '/' $concat_cont stamklassen.grp_name $concat_cont ')' END #$concat_end klas, $ifnull(bla.score, '-') FROM $kldv.ppl #JOIN $kldv.ppl2grp2subj ON ppl2grp2subj.ppl_id = ppl.ppl_id #AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} #AND ppl2grp2subj.ppl_exit > {$_SERVER['REQUEST_TIME']} #JOIN $kldv.grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id #JOIN $kldv.grp ON grp.grp_id = grp2subj.grp_id #JOIN $kldv.subj ON subj.subj_id = grp2subj.subj_id #JOIN $kldv.ppl2grp ON ppl2grp.grp_id = grp.grp_id #AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} #AND ppl2grp.ppl_exit >{$_SERVER['REQUEST_TIME']} #JOIN $kldv.ppl AS lln ON lln.ppl_id = ppl2grp.ppl_id #JOIN $kldv.ppl2grp AS grp2ppl ON grp2ppl.ppl_id = lln.ppl_id #AND grp2ppl.ppl_enter <= {$_SERVER['REQUEST_TIME']} #AND grp2ppl.ppl_exit >{$_SERVER['REQUEST_TIME']} #JOIN $kldv.grp AS stamklassen ON stamklassen.grp_id = grp2ppl.grp_id AND stamklassen.grp_home = 1 #JOIN $kldv.grp2grp ON grp2grp.grp0_id = stamklassen.grp_id #JOIN ( # SELECT grp_id FROM signal2grp # GROUP BY grp_id #) bla2 ON bla2.grp_id = grp2grp.grp1_id #LEFT JOIN ( # SELECT signalee_ppl_id, SUM(signal_severity) score FROM signal2ppl # GROUP BY signalee_ppl_id #) bla ON bla.signalee_ppl_id = lln.ppl_id #WHERE ppl.ppl_id = {$_SESSION['ppl_id']} #AND grp.grp_name LIKE '%q' #ORDER BY lln.ppl_surname, lln.ppl_forename, lln.ppl_prefix #EOQ #, $_GET['klas']); $schoolyear = get_schoolyear($_SERVER['REQUEST_TIME']); $year_id = mdb2_single_val($db, "SELECT year_id FROM $kldv.years WHERE year_long = '%q'", $schoolyear); if (!$year_id) error_user('Schooljaar onbekend', 'Schooljaar '.$schoolyear.' is nog niet bekend in '.$kldv.'.years, vraag een beheerder', 'admin.php'); $meetings = mdb2_query($db, <<

Effectieve leerlingbespreking

Elke bespreking is in 1 van drie fasen.

MENTOR (mentor selecteert vragen)
VAKDOCENT (vakdocent beantwoordt vragen)
UITSLAG (uitslag is zichtbaar)

Alle leerlingbesprekingen van dit schooljaar:

fetchRow(MDB2_FETCHMODE_ASSOC))) { echo("Dit schooljaar zijn er geen leerlingsbesprekingen gepland."); } else { echo('

'.$row['eff_meeting_description']."\n"); if ($_SERVER['REQUEST_TIME'] < $row['eff_meeting_mentor_deadline']) echo('MENTOR (tot '.date('Y-m-d H:i:s', $row['eff_meeting_mentor_deadline'] - 1).')'); else if ($_SERVER['REQUEST_TIME'] < $row['eff_meeting_teacher_deadline']) echo('VAKDOCENT (tot '.date('Y-m-d H:i:s', $row['eff_meeting_teacher_deadline'] - 1).')'); else echo('UITSLAG'); echo('

'); } ?>