if ($gPreferences['dates_show_rooms'] == 1) {
if ($_POST['dat_room_id'] > 0) {
$sql = 'SELECT COUNT(dat_id) AS is_reserved
FROM ' . TBL_DATES . '
WHERE dat_begin <= \'' . $endDateTime->getDateTimeString() . '\'
AND dat_end >= \'' . $startDateTime->getDateTimeString() . '\'
AND dat_room_id = ' . $_POST['dat_room_id'] . '
AND dat_id <> ' . $getDateId;
$result = $gDb->query($sql);
$row = $gDb->fetch_object($result);
if ($row->is_reserved) {
$gMessage->show($gL10n->get('DAT_ROOM_RESERVED'));
}
$date->setValue('dat_room_id', $_POST['dat_room_id']);
$room = new TableRooms($gDb);
$room->readDataById($_POST['dat_room_id']);
$number = intval($room->getValue('room_capacity')) + intval($room->getValue('room_overhang'));
$date->setValue('dat_max_members', $number);
if ($_POST['dat_max_members'] < $number && $_POST['dat_max_members'] > 0) {
$date->setValue('dat_max_members', $_POST['dat_max_members']);
}
// Raumname für Benachrichtigung
$raum = $room->getValue('room_name');
}
}
// write all POST parameters into the date object
foreach ($_POST as $key => $value) {
if (strpos($key, 'dat_') === 0) {
$date->setValue($key, $value);
}
}
// nur berechtigte User duerfen die Profilfelder bearbeiten
if (!$gCurrentUser->isWebmaster()) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
// set headline of the script
if ($getRoomId > 0) {
$headline = $gL10n->get('SYS_EDIT_VAR', $getHeadline);
} else {
$headline = $gL10n->get('SYS_CREATE_VAR', $getHeadline);
}
// add current url to navigation stack
$gNavigation->addUrl(CURRENT_URL, $headline);
// Create room object
$room = new TableRooms($gDb);
if ($getRoomId > 0) {
$room->readDataById($getRoomId);
}
if (isset($_SESSION['rooms_request'])) {
// durch fehlerhafte Eingabe ist der User zu diesem Formular zurueckgekehrt
// nun die vorher eingegebenen Inhalte ins Objekt schreiben
$room->setArray($_SESSION['rooms_request']);
unset($_SESSION['rooms_request']);
}
// create html page object
$page = new HtmlPage($headline);
// add back link to module menu
$roomsMenu = $page->getMenu();
$roomsMenu->addItem('menu_item_back', $gNavigation->getPreviousUrl(), $gL10n->get('SYS_BACK'), 'back.png');
// show form
$form = new HtmlForm('rooms_edit_form', $g_root_path . '/adm_program/modules/rooms/rooms_function.php?room_id=' . $getRoomId . '&mode=1', $page);
$form->openGroupBox('gb_name_properties', $gL10n->get('SYS_NAME') . ' & ' . $gL10n->get('SYS_PROPERTIES'));
