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