<?
include('phplib/phplib.php');
include('common.php');

check_personeel();

$db = mdb2_open($dsn);

if ($_POST['submit'] == 'Annuleren') {
	header('Location: '.$location.'?rol=vipdocent&week_id'.$_POST['week_id']);
	exit;
}

$res = mdb2_all_assoc_rekey($db, <<<EOQ
SELECT DISTINCT subj.subj_id, subj_abbrev, IF(vipvak.subj_id IS NOT NULL, 1, 0) selected FROM $kldv.year2grp2subj
JOIN $kldv.grp2subj USING (grp2subj_id)
JOIN $kldv.subj USING (subj_id)
LEFT JOIN vipvak ON ppl_id = {$_SESSION['ppl_id']} AND vipvak.subj_id = subj.subj_id AND timestamp_delete IS NULL
WHERE year_id = $year_id AND subj_abbrev != 'mt'
ORDER BY subj_abbrev
EOQ
);

header('Content-type: text/plain;charset=UTF-8');

print_r($_POST);
foreach ($res as $key => $value) {
	echo("considering $key {$value['subj_abbrev']}: ");

	if ($value['selected'] == 1 && !in_array($value['subj_abbrev'], $_POST['vipvak'])) {
		echo("verwijder\n");
		mdb2_exec($db, "UPDATE vipvak SET timestamp_delete = NOW() WHERE ppl_id = {$_SESSION['ppl_id']} AND subj_id = $key");
	} else if ($value['selected'] == 0 && in_array($value['subj_abbrev'], $_POST['vipvak'])) {
		echo("voeg toe\n");
		mdb2_exec($db, "INSERT INTO vipvak ( ppl_id, subj_id ) VALUES ( {$_SESSION['ppl_id']}, $key )");
	} else {
		echo("doe niks\n");
	}
}

header('Location: '.$location.'?rol=vipdocent&week'.$_POST['week']);

?>