{$_SERVER['REQUEST_TIME']} JOIN $kldv.grp USING (grp_id) JOIN $kldv.grp2subj USING (grp_id) JOIN $kldv.ppl2grp2subj ON ppl2grp2subj.grp2subj_id = grp2subj.grp2subj_id AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp2subj.ppl_exit > {$_SERVER['REQUEST_TIME']} WHERE ppl2grp2subj.ppl_id = {$_SESSION['ppl_id']} AND ppl.ppl_id = %i AND subj_id = ( SELECT subj_id FROM $kldv.subj WHERE subj_abbrev = 'mt' ) EOQ , $_GET['ppl_id']); //-- AND grp_name REGEXP '[456]V.mt' if (!$ppl_id) error_system("geen rechten op ppl_id={$_GET['ppl_id']}"); $naam = mdb2_single_val($db, "SELECT CONCAT(ppl_forename, ' ', ppl_prefix, ' ', ppl_surname, ' (', ppl_login, ')') FROM $kldv.ppl WHERE ppl_id = $ppl_id"); /* $aanmeldingen = mdb2_query($db, <<verwijder'), '-') verwijder FROM request JOIN $roosterdb.weken AS van ON van.week_id = first_week_id JOIN $roosterdb.weken AS tm ON tm.week_id = last_week_id JOIN $kldv.subj USING (subj_id) JOIN $kldv.ppl ON ppl.ppl_id = requestor_ppl_id WHERE requestee_ppl_id = $ppl_id AND first_week_id <= $week_id AND last_week_id >= $week_id AND timestamp_delete IS NULL EOQ ); $meldingen = mdb2_query($db, <<= DATE(NOW()), IF (enrollment_id IS NULL, CONCAT('niet aangemeld ',IF(aantal >= capacity, '[vol]', CONCAT('[aanmelden]'))), IF (review_id IS NULL, CONCAT('aangemeld [afmelden]'), CONCAT(status, ': ', text))), IF (enrollment_id IS NULL, 'niet aangemeld', 'aangemeld')) status FROM moments JOIN $roosterdb.weken USING (week_id) LEFT JOIN ( SELECT moment_id, enrollment_id, review_id, status, text FROM enrollments LEFT JOIN reviews USING ( enrollment_id ) WHERE ppl_id = $ppl_id ) AS bla USING (moment_id) LEFT JOIN ( SELECT COUNT(enrollment_id) aantal, moment_id FROM enrollments GROUP BY moment_id ) AS bla2 USING (moment_id) WHERE cDate(year, week, dag) >= DATE(NOW()) OR enrollment_id IS NOT NULL ORDER BY year, week, dag EOQ ); html_start(); ?>

SVB-aanmeldingen van