' $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 ')' $concat_end ELSE $concat_begin ' (' $concat_cont grp.grp_name $concat_cont '/' $concat_cont stamklassen.grp_name $concat_cont ')' $concat_end END klas, $ifnull(bla.score, '-') 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 WHERE year_id = $year_id 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']); html_start(); ?>

Signaleren leerling gedrag tbv leerlingbespreking. (pilot in team B)

Klassen/lesgroepen: .

Leerlingen: