エントリーフォーム
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 = "2" $date = "2019-05-17" $reservation_id_excluded = null $displaySQL = false $time = "16:00:00" $time_duration = array( "start" => "13:00:00", "end" => "16:30:00" ) $time_start = "13:00:00" $time_end = "16:30:00" $times = array( "13:00:00", "14:00:00", "15:00:00", "16: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` = '2019-05-17' AND ((CAST('13:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('13:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('14:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('14:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('15:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('15:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('16:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('16:00:00' AS time) BETWEEN `time_start` AND `time_end`)) " $sql_ = " SELECT * FROM `reservations` WHERE `room_id` = 7 AND `reservation_date` = '2019-05-17' AND (`time_start` <= CAST('13:00:00' AS time) AND `time_end` >= CAST('13:00:00' AS time)) OR (`time_start` <= CAST('16:30:00' AS time) AND `time_end` >= CAST('16:30:00' AS time)) " $time_conditions = array( "(CAST('13:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('13:00:00' AS time) BETWEEN `time_start` AND `time_end`)", "(CAST('14:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('14:00:00' AS time) BETWEEN `time_start` AND `time_end`)", "(CAST('15:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('15:00:00' AS time) BETWEEN `time_start` AND `time_end`)", "(CAST('16:00:00' AS time) BETWEEN `time_start` AND `time_end`) OR (CAST('16: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