/** * check if customer choose seats or not before they click check out button * @param $item * @param $item_id */ static function seatsEmpty($item, $item_id) { $ErrorMessage = "<b style='color:red'>At least one sit should be selected</b>"; $filmBooking = new FilmBookingModel(); $sql = "SELECT DISTINCT(rooms.Room_Name), rooms.Room_ID,DATE_FORMAT(Run_Time, '%H:%i') AS 'RunTime'\n FROM films JOIN running_films\n ON films.Film_Id = running_films.Film_Id\n JOIN rooms\n ON running_films.Room_ID = rooms.Room_ID\n JOIN cinemas\n ON cinemas.Cinema_ID = rooms.Cinema_ID\n WHERE running_films.Film_Id=:Film_Id AND cinemas.Cinema_ID=:Cinema_ID\n AND rooms.Room_ID=:Room_Id\n ORDER BY DATE_FORMAT(Run_Time, '%H:%i')"; $TimeInfos = $filmBooking->getBookingDetail($para = ["Film_Id" => $item->FilmId, "Cinema_ID" => $item->Cinema_ID, "Room_Id" => $item->Room_ID], $sql); $sql = "SELECT Seat_Name, available\n From seats WHERE Room_ID=:Room_ID AND Run_Time=:Run_Time"; $SeatsInfos = $filmBooking->getBookingDetail($para = ["Room_ID" => $item->Room_ID, "Run_Time" => $item->Run_Time], $sql); $filmInfo = $filmBooking->getFilmById($item->FilmId); $SeatsInfos = json_encode($SeatsInfos); require_once "./View/Booking.php"; }
/** * * after fill out the booking form redirect to booking page */ public function toBookingPage() { //echo "this is toBookingPage"; $validation = new Validation(); //var_dump($_POST); $error = $validation->emptyValidation($_POST); if ($error === true) { $filmInfo = explode('| ', $_POST['filmInfo']); //var_dump($filmInfo); $item = new stdClass(); $item->Film_Name = $filmInfo[0]; $item->FilmId = $_POST['movie']; $item->Cinema_ID = $_POST['Cinema']; $item->Cinema = $filmInfo[1]; $item->Room_ID = $_POST['Room']; $item->Room = $filmInfo[2]; $item->showDate = $filmInfo[3]; $item->showTime = $filmInfo[4]; $item->Run_Time = $filmInfo[5]; //$item->Room_ID = $_POST[''] // var_dump($item); $filmBooking = new FilmBookingModel(); $sql = "SELECT DISTINCT(rooms.Room_Name), rooms.Room_ID,DATE_FORMAT(Run_Time, '%H:%i') AS 'RunTime', Run_Time\n FROM films JOIN running_films\n ON films.Film_Id = running_films.Film_Id\n JOIN rooms\n ON running_films.Room_ID = rooms.Room_ID\n JOIN cinemas\n ON cinemas.Cinema_ID = rooms.Cinema_ID\n WHERE running_films.Film_Id=:Film_Id AND cinemas.Cinema_ID=:Cinema_ID\n AND rooms.Room_ID=:Room_Id\n ORDER BY DATE_FORMAT(Run_Time, '%H:%i')"; $TimeInfos = $filmBooking->getBookingDetail($para = ["Film_Id" => $item->FilmId, "Cinema_ID" => $item->Cinema_ID, "Room_Id" => $item->Room_ID], $sql); $seatsLoadArray = self::checkSeats($TimeInfos); $sql = "SELECT Seat_Name, available\n From seats WHERE Room_ID=:Room_ID AND Run_Time=:Run_Time"; $SeatsInfos = $filmBooking->getBookingDetail($para = ["Room_ID" => $item->Room_ID, "Run_Time" => $item->Run_Time], $sql); $filmInfo = $filmBooking->getFilmById($item->FilmId); $SeatsInfos = json_encode($SeatsInfos); //var_dump($TimeInfos); require_once "./View/Booking.php"; } else { //echo "In else"; header("Location: ./index.php?route=HomePageController/index&error={$error}"); } }