{{ $hotel->nama }} ({{ $hotel->city }}) Date : {{date('d-m-Y')}}
{{ $hotel->alamat }} Period : {{ $period }}
Tel {{ $hotel->telp }}
{{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- @foreach(config('custom.revenue_groups') as $key => $revenue_group) @endforeach --}} @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(); $total_occ += $occ[$day]; if ($idx > 1) { $average_occ[$idx] = $total_occ / $idx; } else { $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] = $jumlah_ooo; $room_avail = count($kamars) - $stock_globals[$day] - $ooo_per_day[$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 {{-- --}} {{-- --}} {{-- --}}
DATE LAST NIGHT EXPECT ARRIVE EXPECT DEPART ROOM OCCAVERAGE LODGINGROOM REVENUEAVERAGE ROOMREVROOMRATEOCC (%)REVPARAVRG OCC (%) # OF ROOM AVAIL{{ $revenue_group }}
# ROOM # PAX # ROOM # PAX # ROOM # PAX # ROOM # PAX # LODGING
{{ 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] }} {{ $lodging[$day] }}{{ ribuanWithComma($average_lodging[$day]) }} {{ ribuanWithComma($room_revenue[$day]) }} {{ ribuanWithComma($average_room_revenue[$day]) }} {{ ribuanWithComma($room_rate[$day]) }}{{ $occ[$day] }}{{ ribuanWithComma($revpar[$day]) }}{{ decimalWithDot($average_occ[$idx], 2) }} {{ $room_avail }}{{ ribuanWithComma($breakfast[$day]) }} {{ ribuanWithComma($lunch[$day]) }} {{ ribuanWithComma($dinner[$day]) }} {{ ribuanWithComma($other[$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}} {{ $total_lodging }}{{ ribuanWithComma($total_occ_room !== 0 ? $total_lodging / $total_occ_room : 0) }} {{ ribuanWithComma($total_room_revenue) }} {{ ribuanWithComma($total_occ_room !== 0 ? $total_room_revenue / $total_occ_room : 0) }} {{ ribuanWithComma($total_room_rate) }}{{decimalWithDot($average_occ[$idx], 2)}}{{ ribuanWithComma($total_revpar) }}{{decimalWithDot($average_occ[$idx], 2)}} {{$total_room_avail}}{{ ribuanWithComma($total_breakfast) }} {{ ribuanWithComma($total_lunch) }} {{ ribuanWithComma($total_dinner) }} {{ ribuanWithComma($total_other) }}