<?
require_once('phplib/phplib.php');

check_admin();

$db = mdb2_open($dsn);

if (!isset($_POST['ppl2grp2subj']) || trim($_POST['ppl2grp2subj']) == '') error_user('Ongeldig', 'Onzinnige input', 'admin.php');

if (!($timestamp = strtotime($_POST['date']))) error_user('Datum ongeldig', 'Onzinnige datum', 'admin.php');

$year_long = get_schoolyear($timestamp);

$exploded = explode('/', $_POST['ppl2grp2subj']);

if (!($ppl_id = mdb2_single_val($db, "SELECT ppl_id FROM ppl WHERE ppl_active IS NOT NULL AND ppl_login = '%q'", $exploded[0])))
	error_user('Docent onbekend', 'Docent '.$exploded[0].' niet gevonden.', 'admin.php');

if (!($grp_id = mdb2_single_val($db, "SELECT grp_id FROM grp WHERE grp_name = '%q'", $exploded[1])))
	error_user('Klas onbekend', 'Klas '.$exploded[1].' niet gevonden.', 'admin.php');

if (!($subj_id = mdb2_single_val($db, "SELECT subj_id FROM subj WHERE subj_abbrev = '%q'", $exploded[2])))
	error_user('Vak onbekend', 'Vak '.$exploded[1].' niet gevonden.', 'admin.php');

if (!($year_id = mdb2_single_val($db, "SELECT year_id FROM years WHERE year_long = '%q'", $year_long))) 
	error_user('Schooljaar te nieuw?', 'Schooljaar '.$year_long.' niet gevonden in database. Vraag de beheerder om het toe te voegen in "years"', 'admin.php');

if (!($grp2subj_id = mdb2_single_val($db, "SELECT grp2subj.grp2subj_id FROM year2grp2subj JOIN grp2subj ON grp2subj.grp2subj_id = year2grp2subj.grp2subj_id WHERE year_id = $year_id AND grp_id = $grp_id AND subj_id = $subj_id")))
	error_user('grp2vak bestaat niet', $exploded[1].' heeft geen '.$exploded[2].' in schooljaar '.$year_long, 'admin.php');

if (!mdb2_single_val($db, "SELECT ppl_id FROM ppl2grp2subj WHERE ppl_id = $ppl_id AND grp2subj_id = $grp2subj_id AND ppl_enter <= $timestamp AND ppl_exit > $timestamp"))
	error_user('Docent geeft geen les', 'Op '.$_POST['date'].' geeft '.$exploded[0].' geen '.$exploded[2].' aan '.$exploded[1]);

// alles is in gereedheid gebracht, we regelen het met een eenvoudige UPDATE

mdb2_exec($db, "UPDATE ppl2grp2subj SET ppl_exit = $timestamp WHERE ppl_id = $ppl_id AND grp2subj_id = $grp2subj_id AND ppl_enter <= $timestamp AND ppl_exit > $timestamp");

header('Location: '.$location.'admin.php');

?>