/**
* 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}");
}
}
