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

check_personeel();

error_user("Inschrijving gesloten", "De inschrijving voor de workshops is gesloten", "ws_index.php");

$db = mdb2_open($dsn);

mdb2_exec($db, "DELETE FROM ws_enlistments WHERE ppl_id = {$_SESSION['ppl_id']} AND ws_event_id = 1");

$rounds = mdb2_single_val($db, "SELECT ws_event_rounds FROM ws_event WHERE ws_event_id = 1");

$info = array();

for ($i = 1; $i <= $rounds; $i++) {
	if (!$_POST["round$i"]) continue;
	if (in_array($_POST["round$i"], $info)) error_user("Dubbele opgave", "Je mag je niet twee maal voor dezelfde workshop opgeven.", 'ws_index.php');
	mdb2_exec($db, "INSERT INTO ws_enlistments ( ws_event_id, ws_workshop_id, ppl_id, ws_round ) VALUES ( 1, %i, {$_SESSION['ppl_id']}, $i )", $_POST["round$i"]);
	$full = mdb2_single_val($db, "SELECT CASE WHEN COUNT(ppl_id) > ws_workshop_capacity THEN 1 ELSE 0 END FROM ws_enlistments JOIN ws_workshops ON ws_workshops.ws_workshop_id = ws_enlistments.ws_workshop_id WHERE ws_round = $i AND ws_enlistments.ws_workshop_id = %i GROUP BY ws_workshop_capacity", $_POST["round$i"]);
	if ($full) {
		mdb2_exec($db, "DELETE FROM ws_enlistments WHERE ppl_id = {$_SESSION['ppl_id']} AND ws_event_id = 1");
		error_user("Workshop volgeboekt", "Workshop \"".mdb2_single_val($db, "SELECT ws_workshop_title FROM ws_workshops WHERE ws_workshop_id = %i", $_POST["round$i"])."\" is vol; je kan niet worden ingeschreven", "ws_index.php");
	}
	$info[$i] = $_POST["round$i"];
}

// succes

$_SESSION['notice'][0] = "Opgeslagen";
$_SESSION['notice'][1] = "Je inschrijving is opgeslagen.";

header("Location: ws_index.php");
?>