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

check_admin();

$db = mdb2_open($dsn); // pak het nieuwste basisrooster

header('Content-type: text/plain');
print_r($_GET);

/* 
 * Array
 * (
 *   [blokgroup_id] => 2
 *   [week_id] => 23
 * )
 */
$week = mdb2_single_assoc($db, "SELECT * FROM $roosterdb.weken WHERE week_id = %i", $_GET['week_id']);

if (!is_array($week)) error_system("week id niet gevonden");

$affected = mdb2_exec($db, "UPDATE blokgroups SET timestamp_delete = NOW() WHERE blokgroup_id = %i AND week_id = %i AND timestamp_delete IS NULL", $_GET['blokgroup_id'], $_GET['week_id']);

if (!$affected) error_user('verwijderen niet gelukt', 'blokkade bestaat niet of is al verwijderd', 'admin.php?week_id='.$_GET['week_id']);

/*
if (mdb2_exec($db, "DELETE FROM blokgroups WHERE blokgroup_id = %i AND week_id = %i", $_GET['blokgroup_id'], $_GET['week_id'])) {
	// deze queries worden alleen uitgevoerd als query in de if() affected rows heeft
	mdb2_exec($db, "DELETE FROM entblok WHERE blokgroup_id = %i", $_GET['blokgroup_id']);
	mdb2_exec($db, "DELETE FROM uurblok WHERE blokgroup_id = %i", $_GET['blokgroup_id']);
}
 */

header('Location: '.$location.'admin.php?week_id='.$_GET['week_id']);

?>