require_once('phplib/phplib.php'); require_once('common.php'); check_admin(); $db = mdb2_open($dsn); // pak het nieuwste basisrooster $week = mdb2_single_assoc($db, "SELECT * FROM $roosterdb.weken WHERE week_id = %i", $_GET['week_id']); if (isset($_GET['blokgroup_id'])) { $blokgroup_id = mdb2_single_val($db, 'SELECT blokgroup_id FROM blokgroups WHERE blokgroup_id = %i', $_GET['blokgroup_id']); if (!$blokgroup_id) error_fatal("blokgroup_id={$_GET['blokgroup_id']} is niet bekend"); $soort = mdb2_single_val($db, "SELECT soort FROM blokgroups WHERE blokgroup_id = $blokgroup_id"); $reden = mdb2_single_val($db, "SELECT text_roostermaker FROM blokgroups WHERE blokgroup_id = $blokgroup_id"); $uurblok = mdb2_all_assoc_rekey($db, "SELECT CONCAT(dag, '-', uur), blokgroup_id FROM uurblok WHERE blokgroup_id = $blokgroup_id"); $entblok = mdb2_all_assoc_rekey($db, "SELECT entity_name, blokgroup_id FROM entblok JOIN $roosterdb.entities USING (entity_id) WHERE blokgroup_id = $blokgroup_id"); } else { $blokgroup_id = NULL; $reden = ''; $uurblok = array (); $entblok = array (); } $checkbox_lokaal = ''; foreach ($computerlokalen_names as $name) { $checkbox_lokaal .= ''.htmlenc($name)."\n"; } $monday = getthismonday($week); html_start('', "Blok"); ?>