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

check_admin();

$db = mdb2_open($dsn);

if (!isset($_POST['ppl2grp']) || trim($_POST['ppl2grp']) == '') 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['ppl2grp']);

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('Leerling onbekend', 'Leerling '.$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('Groep onbekend', 'Klas '.$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 (mdb2_single_val($db, "SELECT ppl_id FROM ppl2grp WHERE ppl_id = $ppl_id AND grp_id = $grp_id AND ppl_enter <= $timestamp AND ppl_exit > $timestamp"))
	error_user('Leerling zit al in groep', 'Op '.$_POST['date'].' zit '.$exploded[0].' al in '.$exploded[1]);

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

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

?>