{$_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 WHERE ppl.ppl_id = {$_SESSION['ppl_id']} AND lln.ppl_id = %i ORDER BY lln.ppl_surname, lln.ppl_forename, lln.ppl_prefix EOQ , $_GET['ppl_id']); if (!$ppl_id && !$_SESSION['admin']) error_user("Geen toegang", "Je geeft geen les aan deze leerling, de gegevens zijn niet toegankelijk"); $naam = mdb2_single_val($db, "SELECT $concat_begin ppl_forename $concat_cont ' ' $concat_cont ppl_prefix $concat_cont ' ' $concat_cont ppl_surname $concat_cont ' (' $concat_cont ppl_login $concat_cont ')' $concat_end FROM $kldv.ppl WHERE ppl_id = %i", $_GET['ppl_id']); $signalen_uitgebreid = array(); while ($row = $types->fetchRow(MDB2_FETCHMODE_ASSOC)) { $signalen_uitgebreid[$row['signal_type_id']] = array(); $signalen_uitgebreid[$row['signal_type_id']]['desc'] = $row['signal_type_description']; $signalen_uitgebreid[$row['signal_type_id']]['res'] = mdb2_query($db, <<' $concat_cont '' $concat_cont signal_description $concat_end omschrijving, $concat_begin '' $concat_end zelf, $ifnull(bla.conc, 'niets ingevuld') collegas , $ifnull(bla2.total, '-') totaal FROM signals JOIN signal2grp ON signal2grp.signal_id = signals.signal_id AND year_id = $year_id JOIN grp2grp ON grp2grp.grp1_id = signal2grp.grp_id AND grp2grp.year_id = signal2grp.year_id JOIN ppl2grp ON ppl2grp.grp_id = grp2grp.grp0_id AND ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl_exit > {$_SERVER['REQUEST_TIME']} AND ppl_id = %i LEFT JOIN signal2ppl ON signalee_ppl_id = %i AND signaler_ppl_id = {$_SESSION['ppl_id']} AND signal2ppl.signal_id = signals.signal_id AND signal2ppl.year_id = signal2grp.year_id LEFT JOIN ( SELECT signal_id, $group_concat($concat_begin ppl_login $concat_cont ':' $concat_cont CAST(signal_severity $as_varchar) $concat_end) conc FROM signal2ppl JOIN ppl ON ppl.ppl_id = signal2ppl.signaler_ppl_id WHERE signaler_ppl_id != {$_SESSION['ppl_id']} AND signalee_ppl_id = %i AND signal2ppl.year_id = $year_id GROUP BY signal_id ) AS bla ON bla.signal_id = signals.signal_id LEFT JOIN ( SELECT signal_id, SUM(signal_severity) total FROM signal2ppl WHERE signalee_ppl_id = %i AND signal2ppl.year_id = $year_id GROUP BY signal_id ) AS bla2 ON bla2.signal_id = signals.signal_id WHERE signal_type_id = {$row['signal_type_id']} ORDER BY signals.signal_id EOQ , $_GET['ppl_id'] , $_GET['ppl_id'] , $_GET['ppl_id'] , $_GET['ppl_id'] ); } /* $signalen= mdb2_query($db, <<' $concat_cont '' $concat_cont signal_description $concat_end omschrijving, $concat_begin '' $concat_end zelf, $ifnull(bla.conc, 'niets ingevuld') collegas , $ifnull(bla2.total, '-') totaal FROM signals JOIN signal2grp ON signal2grp.signal_id = signals.signal_id AND year_id = $year_id JOIN grp2grp ON grp2grp.grp1_id = signal2grp.grp_id AND grp2grp.year_id = signal2grp.year_id JOIN ppl2grp ON ppl2grp.grp_id = grp2grp.grp0_id AND ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl_exit > {$_SERVER['REQUEST_TIME']} AND ppl_id = %i LEFT JOIN signal2ppl ON signalee_ppl_id = %i AND signaler_ppl_id = {$_SESSION['ppl_id']} AND signal2ppl.signal_id = signals.signal_id AND signal2ppl.year_id = signal2grp.year_id LEFT JOIN ( SELECT signal_id, $group_concat($concat_begin ppl_login $concat_cont ':' $concat_cont CAST(signal_severity $as_varchar) $concat_end) conc FROM signal2ppl JOIN ppl ON ppl.ppl_id = signal2ppl.signaler_ppl_id WHERE signaler_ppl_id != {$_SESSION['ppl_id']} AND signalee_ppl_id = %i AND signal2ppl.year_id = $year_id GROUP BY signal_id ) AS bla ON bla.signal_id = signals.signal_id LEFT JOIN ( SELECT signal_id, SUM(signal_severity) total FROM signal2ppl WHERE signalee_ppl_id = %i AND signal2ppl.year_id = $year_id GROUP BY signal_id ) AS bla2 ON bla2.signal_id = signals.signal_id ORDER BY signals.signal_id EOQ , $_GET['ppl_id'] , $_GET['ppl_id'] , $_GET['ppl_id'] , $_GET['ppl_id'] ); */ html_start(); echo("

Signaleringen betreffende $naam

"); ?>

Schaalverdeling: 0 = nooit, 1 = soms, 2 = vaak, 3 = altijd

$data) { ?>

ppl_id=$ppl_id"); html_end(); ?>