エントリーフォーム
Notice (8): Undefined offset: 0 [ROOTmaririne-1/controllers/reservations_controller.php, line 1242]Code | Context$attachedRooms = $this->Room->find('all', array('conditions' => array('id' => $room_id), 'fields' => array('attached_rooms')));if (strlen($attachedRooms[0]['Room']['attached_rooms']) > 0) {$room_id = "7" $time_id = "1" $date = "2021-06-12" $reservation_id_excluded = null $displaySQL = false $time = "12:00:00" $time_duration = array( "start" => "09:00:00", "end" => "12:30:00" ) $time_start = "09:00:00" $time_end = "12:30:00" $times = array( "09:00:00", "10:00:00", "11:00:00", "12:00:00" ) $sql = " SELECT * FROM `reservations` AS `r` INNER JOIN `attached_rooms` AS `ar` ON ( `r`.`room_id` = `ar`.`room_id` OR `r`.`room_id` = `ar`.`adjacent_room_id` ) WHERE `r`.`room_id` = 7 AND `r`.`reservation_date` = '2021-06-12' AND ((CAST('09:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('09:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('10:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('10:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('11:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('11:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('12:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('12:00:00' AS time) BETWEEN `time_start` AND `time_end`)) " $sql_ = " SELECT * FROM `reservations` WHERE `room_id` = 7 AND `reservation_date` = '2021-06-12' AND (`time_start` <= CAST('09:00:00' AS time) AND `time_end` >= CAST('09:00:00' AS time)) OR (`time_start` <= CAST('12:30:00' AS time) AND `time_end` >= CAST('12:30:00' AS time)) " $time_conditions = array( "(CAST('09:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('09:00:00' AS time) BETWEEN `time_start` AND `time_end`)", "(CAST('10:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('10:00:00' AS time) BETWEEN `time_start` AND `time_end`)", "(CAST('11:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('11:00:00' AS time) BETWEEN `time_start` AND `time_end`)", "(CAST('12:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('12:00:00' AS time) BETWEEN `time_start` AND `time_end`)" ) $rooms = array( "7" ) $attachedRooms = array()ReservationsController::__isRoomAvailable() - ROOTmaririne-1/controllers/reservations_controller.php, line 1242 ReservationsController::make() - ROOTmaririne-1/controllers/reservations_controller.php, line 1677 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 [main] - ROOTmaririne-1/webroot/index.php, line 90