{{ $hotel->nama }} ({{ $hotel->city }}) Date : {{date('d-m-Y')}}
{{ $hotel->alamat }} Period : {{ $period }}
Tel {{ $hotel->telp }}
@php // defined variable $idx = 0; $total_occ = 0; $total_last_night_room = 0; $total_last_night_pax = 0; $total_expect_arrive_room = 0; $total_expect_arrive_pax = 0; $total_expect_depart_room = 0; $total_expect_depart_pax = 0; $total_occ_room = 0; $total_revpar = 0; $total_occ_pax = 0; $total_lodging = 0; $total_room_revenue = 0; $total_room_rate = 0; $total_room_avail = 0; $total_ooo = 0; $total_breakfast = 0; $total_lunch = 0; $total_dinner = 0; $total_other = 0; @endphp @foreach ($dates as $month => $date) @foreach ($date as $day) @if ($day == $diff_one_day) @continue @endif @php $idx++; @endphp @php $ooo_per_day = array(); $average_occ[$idx] = $occ[$day]; @endphp @php $jumlah_ooo = 0; @endphp @foreach($ooo_global_schedule as $key => $ooo) @if($day <= $key) @php $jumlah_ooo += array_sum($ooo) @endphp @endif @endforeach @php $ooo_per_day[$day] = @$room_ooo_new[$day]; $room_avail = @$room_avail_new[$day]; @endphp @php $total_last_night_room += $last_night[$day]; $total_last_night_pax += $last_night_pax[$day]; $total_expect_arrive_room += $expected_arrival[$day]; $total_expect_arrive_pax += $expected_arrival_pax[$day]; $total_expect_depart_room += $expected_departure[$day]; $total_expect_depart_pax += $expected_departure_pax[$day]; $total_occ_room += $in_house[$day]; $total_revpar += $revpar[$day]; $total_occ_pax += $in_house_pax[$day]; $total_lodging += $lodging[$day]; $total_room_revenue += $room_revenue[$day]; $total_room_rate += $room_rate[$day]; $total_room_avail += $room_avail; $total_ooo += $ooo_per_day[$day]; $total_breakfast += $breakfast[$day]; $total_lunch += $lunch[$day]; $total_dinner += $dinner[$day]; $total_other += $other[$day]; @endphp @endforeach @endforeach @php $total_occ_kolom = ($total_occ_room / ($total_room_avail) * 100); @endphp
DATE LAST NIGHT EXPECT ARRIVE EXPECT DEPART ROOM OCC LODGING OCC (%) REVPAR ROOM AVAILABILITY O-O-O Gross Revenue
# ROOM # PAX # ROOM # PAX # ROOM # PAX # ROOM # PAX
{{ formatDate($day) }} {{ $last_night[$day] }} {{ $last_night_pax[$day] }} {{ $expected_arrival[$day] }} {{ $expected_arrival_pax[$day] }} {{ $expected_departure[$day] }} {{ $expected_departure_pax[$day] }} {{ $in_house[$day] }} {{ $in_house_pax[$day] }} {{ ribuanWithComma(@$lodging[$day]) }} {{ $occ[$day] }} {{ ribuanWithComma($revpar[$day]) }}{{ $room_avail }} {{$ooo_per_day[$day]}} {{ribuanWithComma($room_revenue[$day])}}
Total {{ $total_last_night_room }} {{$total_last_night_pax}} {{ $total_expect_arrive_room }} {{$total_expect_arrive_pax}} {{ $total_expect_depart_room }} {{$total_expect_depart_pax}} {{ $total_occ_room }} {{$total_occ_pax}} {{ ribuanWithComma($total_lodging) }} {{decimalWithDot(@$total_occ_kolom, 2)}} {{ ribuanWithComma($total_revpar) }} {{$total_room_avail}} {{$total_ooo}} {{ribuanWithComma($total_room_revenue)}}