{$_SERVER['REQUEST_TIME']} 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 EOQ , $_POST['requestee_ppl_id']); if (!$ppl_id) error_user("geen rechten op ppl_id={$_POST['requestee_ppl_id']}", 'details.php?week='.$_POST['first_week'].'&ppl_id='.$_POST['requestee_ppl_id']); if ($_POST['text'] == '') error_user('Hulpvraag is verplicht', "Vul de hulpvraag in", 'docent_vip.php?week='.$_POST['first_week'].'&requestee_ppl_id='.$_POST['requestee_ppl_id']); if ($_POST['vak'] == '') error_user('Vak is verplicht', "Vul het vak in", 'docent_vip.php?week='.$_POST['first_week'].'&requestee_ppl_id='.$_POST['requestee_ppl_id']); $first_week_id = array_search($_POST['first_week'], $weken); $last_week_id = array_search($_POST['last_week'], $weken); if (!$first_week_id) error_user('Ongeldige startweek', 'Startweek bestaat niet', 'details.php?week='.$_POST['first_week'].'&ppl_id='.$_POST['requestee_ppl_id']); if (!$last_week_id) error_user('Ongeldige eindweek', 'Eindweek bestaat niet', 'details.php?week='.$_POST['first_week'].'&ppl_id='.$_POST['requestee_ppl_id']); if ($last_week_id - $first_week_id < 0) error_user("Onmogelijk", 'Eindweek mag niet voor startweek zijn', 'details.php?week='.$_POST['first_week'].'&ppl_id='.$_POST['requestee_ppl_id']); $subj_id = mdb2_single_val($db, "SELECT subj_id FROM $kldv.subj WHERE subj_abbrev = '%q'", $_POST['vak']); if (!$subj_id) error_user("Onmogelijk", 'Vak niet gevonden', 'details.php?week='.$_POST['first_week'].'&ppl_id='.$_POST['requestee_ppl_id']); $vakken_vakdocent = mdb2_col($db, 0, << {$_SERVER['REQUEST_TIME']} JOIN $kldv.ppl2grp ON ppl2grp.grp_id = grp2subj.grp_id AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp.ppl_exit > {$_SERVER['REQUEST_TIME']} WHERE ppl2grp.ppl_id = $ppl_id AND ppl2grp2subj.ppl_id = {$_SESSION['ppl_id']} AND year_id = $year_id EOQ ); $vakken_ll = mdb2_col($db, 0, << {$_SERVER['REQUEST_TIME']} JOIN $kldv.grp2subj USING (grp_id) JOIN $kldv.subj USING (subj_id) WHERE ppl.ppl_id = %i ORDER BY subj_abbrev EOQ , $ppl_id); if (in_array('mt', $vakken_vakdocent)) { $vakken = $vakken_ll; } else $vakken = $vakken_vakdocent; if (!in_array($_POST['vak'], $vakken)) error_user("Permission denied", "U bent niet gerechtigd om voor deze leerling voor dit van een VIPuur aan te vragen"); header('Content-type: text/plain;charset=UTF-8'); //print_r($_POST); //echo("first_week_id=$first_week_id last_week_id=$last_week_id subj_id=$subj_id\n"); mdb2_exec($db, "INSERT INTO request ( first_week_id, last_week_id, subj_id, requestee_ppl_id, requestor_ppl_id, text ) VALUES ( %i, %i, %i, %i, %i, '%q' )", $first_week_id, $last_week_id, $subj_id, $_POST['requestee_ppl_id'], $_SESSION['ppl_id'], $_POST['text']); header('Location: '.$location.'details.php?week='.$_POST['first_week'].'&ppl_id='.$_POST['requestee_ppl_id']); ?>