/**
*
* check how many seats left;
* @param $TimeInfos
* @return array
*
*/
static function checkSeats($TimeInfos)
{
$filmBooking = new FilmBookingModel();
$seatsLoadArray = [];
foreach ($TimeInfos as $timeInfo) {
$sql = "SELECT Seat_Name, available\n From seats WHERE Room_ID=:Room_ID AND Run_Time=:Run_Time";
$i = 0;
$SeatsInfos = $filmBooking->getBookingDetail($para = ["Room_ID" => $timeInfo->Room_ID, "Run_Time" => $timeInfo->Run_Time], $sql);
foreach ($SeatsInfos as $seat) {
if ($seat->available == 'Y') {
$i++;
}
}
if ($i == 0) {
$seatsLoadArray[$timeInfo->RunTime] = "sold-out";
}
if ($i > 0 && $i < 3) {
$seatsLoadArray[$timeInfo->RunTime] = "filling";
}
if ($i >= 3) {
$seatsLoadArray[$timeInfo->RunTime] = "available";
}
}
return $seatsLoadArray;
}
/**
*
* check how many seats left
* @param $roomId
* @param $showTime
* @return string
*
*/
static function seatsLoadingRate($roomId, $showTime)
{
//var_dump($roomId);
//var_dump($showTime);
$seatsOccupied = 0;
$getFilmInfo = new FilmBookingModel();
$sql = "SELECT Seat_Name, available\n From seats WHERE Room_ID=:Room_ID AND Run_Time=:Run_Time";
$RoomInfos = $getFilmInfo->getBookingDetail($para = ["Room_ID" => $roomId, "Run_Time" => $showTime], $sql);
//var_dump($RoomInfos);
foreach ($RoomInfos as $seat) {
if ($seat->available == "N") {
$seatsOccupied++;
}
}
// echo $seatsOccupied;
if ($seatsOccupied > 6 && $seatsOccupied != 10) {
return "filling";
}
if ($seatsOccupied == 10) {
return "sold-out";
} else {
return "available";
}
}
