{$_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 results ON results.ppl_id = lln.ppl_id WHERE ppl.ppl_id = {$_SESSION['ppl_id']} AND result_id = $result_id ORDER BY lln.ppl_surname, lln.ppl_forename, lln.ppl_prefix EOQ ); 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 JOIN results ON results.ppl_id = ppl.ppl_id WHERE result_id = %i", $_GET['result_id']); $toets = mdb2_single_assoc($db, <<' $concat_cont CAST(resultcomment $as_varchar(1024)) $concat_cont '' $concat_end comment, CASE WHEN agreement = 2 THEN 'score hoger dan ik zou verwachten' WHEN agreement = 1 THEN 'score zoals ik zou verwachten' WHEN agreement = 0 THEN 'score lager dan ik zou verwachten' END oordeel, CASE WHEN resultcomment.ppl_id = {$_SESSION['ppl_id']} THEN $concat_begin 'wijzig' $concat_end ELSE '-' END wijzig FROM resultcomment JOIN $kldv.ppl ON ppl.ppl_id = resultcomment.ppl_id WHERE result_id = $result_id EOQ ); // maak overzicht gemaakte toetsen html_start(); echo("

$naam: {$toets['toets']} {$toets['niveau']} ".(($toets['timestamp'])?date("Y-m-d", $toets['timestamp']):'datum onbekend')."

"); mdb2_res_table($tabelinfo); if ($toets['testtype_desc']) { ?>

Uitleg van de scores Opmerkingen van docenten over deze toets"); mdb2_res_table($comments); if ($ppl_id) { ?>voeg commentaar toe