<?
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('/', $year_long);
$end_timestamp = strtotime('august 1 '.$exploded[1]);

$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[2].' 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 (!($grp2subj_id = mdb2_single_val($db, "SELECT grp2subj_id FROM grp2subj WHERE grp_id = $grp_id AND subj_id = $subj_id"))) {
		//error_user('bestaat niet', 'grp2vak bestaat helemaal niet :(');
		mdb2_exec($db, "INSERT INTO grp2subj ( grp_id, subj_id ) VALUES ( $grp_id, $subj_id )");
		$grp2subj_id = mdb2_single_val($db, $last_insert_id);
	} 
	mdb2_exec($db, "INSERT INTO year2grp2subj ( year_id, grp2subj_id ) VALUES ( $year_id, $grp2subj_id )");
}

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 al les', 'Op '.$_POST['date'].' geeft '.$exploded[0].' al '.$exploded[2].' aan '.$exploded[1]);

mdb2_exec($db, "INSERT INTO ppl2grp2subj ( ppl_id, grp2subj_id, ppl_enter, ppl_exit ) VALUES ( $ppl_id, $grp2subj_id, $timestamp, $end_timestamp )");

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

?>