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'));