{{--

	MONTHLY ROOM OCCUPANCY FORECAST
		Period Printed	: {{ $period }} : {{ date('d-m-y') }}

--}}

MONTHLY ROOM OCCUPANCY FORECAST Report Printed on: {{date('d-m-Y')}} Printed By : {{\Auth::user()->nama}}

Periode : {{ $period }}

@if (request()->is('reporting/monthly-room-occupancy-forecast-pdf')) @endif @if (request()->is('reporting/monthly-room-occupancy-forecast-pdf')) @foreach(config('custom.revenue_groups') as $key => $revenue_group) @endforeach @endif @if (request()->is('reporting/monthly-room-occupancy-forecast-view')) {{-- --}} {{-- --}} @endif @if (request()->is('reporting/monthly-room-occupancy-forecast-view')) {{-- --}} @endif @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 @if (request()->is('reporting/monthly-room-occupancy-forecast-pdf')) @endif @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 @if (request()->is('reporting/monthly-room-occupancy-forecast-view')) {{-- --}} {{-- --}} @endif @if (request()->is('reporting/monthly-room-occupancy-forecast-pdf')) @endif @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 @if (request()->is('reporting/monthly-room-occupancy-forecast-pdf')) @endif @if (request()->is('reporting/monthly-room-occupancy-forecast-view')) {{-- --}} {{-- --}} @endif @if (request()->is('reporting/monthly-room-occupancy-forecast-pdf')) @endif

DATE	LAST NIGHT		EXPECT ARRIVE		EXPECT DEPART		ROOM OCC	AVERAGE LODGING	ROOM REVENUE	AVERAGE ROOMREV	ROOMRATE	OCC (%)	REVPAR	AVRG OCC (%)	# OF ROOM AVAIL	{{ $revenue_group }}	OVERB.	TENT.	ALLOT	O-O-O	GLOBAL RESERVE
	# ROOM	# PAX	# ROOM	# PAX	# ROOM	# PAX	# ROOM														# PAX	# LODGING	# 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]) }}	{{ 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 }}				{{$ooo_per_day[$day]}}			{{ 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}}	{{ ribuanWithComma($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}}				{{$total_ooo}}			{{ ribuanWithComma($total_breakfast) }}	{{ ribuanWithComma($total_lunch) }}	{{ ribuanWithComma($total_dinner) }}	{{ ribuanWithComma($total_other) }}