/**
* init booking page
*/
public function index()
{
//echo "this is index method in booking controller";
$getFilmInfo = new FilmBookingModel();
if (isset($_POST['filmId'])) {
//
$filmId = $_POST['filmId'];
$sql = "SELECT DISTINCT(rooms.Room_Name)\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;";
$RoomInfos = $getFilmInfo->getBookingInfo($filmId, $sql);
require_once "./View/Booking.php";
} else {
require_once "./View/Error404.php";
}
}
/**
* click submit button
* after choosing film redirect to Booking page
* @param $filmId
*/
public function postToBooking($filmId)
{
//get film
if (empty($filmId)) {
header("Location: ./index.php");
}
$getFilmInfo = new FilmBookingModel();
$sql = "SELECT *\n FROM films JOIN running_films\n ON films.Film_Id=running_films.Film_Id\n WHERE films.Film_Id=:Film_Id";
$param = ['Film_Id' => $filmId];
$film = $getFilmInfo->getBookingDetail($param, $sql);
if (empty($film)) {
header("Location: ./index.php");
}
$changeRate = new TopRateModel();
$filmInfo = $getFilmInfo->getFilmById($filmId);
$changeRate->clickNumber($filmInfo[0]->film_description);
$sql = "SELECT DISTINCT(cinemas.Cinema_ID),cinemas.Cinema_Name\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;";
$CinemaInfos = $getFilmInfo->getBookingInfo($filmId, $sql);
// var_dump($filmInfo);
require_once "./View/Booking.php";
}
