Room Usage and Turnover Report
Report Printed on: {{date('l, F d, Y')}} 		{{($periode)}}
@if (count($groupings) > 0) @php $total_all_perc_revenue_tdy = $total_all_perc_revenue_mtd = $total_all_perc_revenue_ytd = 0; $total_all_pax_tdy = $total_all_pax_mtd = $total_all_pax_ytd = 0; $total_all_qty_tdy = $total_all_qty_mtd = $total_all_qty_ytd = 0; @endphp @foreach ( $groupings as $akey => $grouping) @php $total_perc_revenue_tdy = $total_perc_revenue_mtd = $total_perc_revenue_ytd = 0; $total_pax_tdy = $total_pax_mtd = $total_pax_ytd = 0; $total_qty_tdy = $total_qty_mtd = $total_qty_ytd = 0; @endphp @foreach($grouping as $key => $room) @php // Percent Revenue $perc_revenue_tdy = $total_room_all['revenue_tdy'] > 0 ? ( round( ((@$room['revenue_tdy'] ?? 0) / @$total_room_all['revenue_tdy'] * 100) , 2) ) : 0; $perc_revenue_mtd = $total_room_all['revenue_mtd'] > 0 ? ( round( ((@$room['revenue_mtd'] ?? 0) / @$total_room_all['revenue_mtd'] * 100) , 2) ) : 0; $perc_revenue_ytd = $total_room_all['revenue_ytd'] > 0 ? ( round( ((@$room['revenue_ytd'] ?? 0) / @$total_room_all['revenue_ytd'] * 100) , 2) ) : 0; // Total Percent Revenue $total_perc_revenue_tdy += $perc_revenue_tdy ?? 0 ; $total_perc_revenue_mtd += $perc_revenue_mtd ?? 0 ; $total_perc_revenue_ytd += $perc_revenue_ytd ?? 0 ; // Total Percent Revenue $total_pax_tdy += $room['pax_tdy'] ?? 0 ; $total_pax_mtd += $room['pax_mtd'] ?? 0 ; $total_pax_ytd += $room['pax_ytd'] ?? 0 ; // Total Percent Revenue $total_qty_tdy += $room['qty_tdy'] ?? 0 ; $total_qty_mtd += $room['qty_mtd'] ?? 0 ; $total_qty_ytd += $room['qty_ytd'] ?? 0 ; @endphp @endforeach @if ($filter_by == 2) @endif @php // TOTAL ALL // Total Percent Revenue $total_all_perc_revenue_tdy += $total_perc_revenue_tdy; $total_all_perc_revenue_mtd += $total_perc_revenue_mtd; $total_all_perc_revenue_ytd += $total_perc_revenue_ytd; // Total Percent Revenue $total_all_pax_tdy += $total_pax_tdy ; $total_all_pax_mtd += $total_pax_mtd ; $total_all_pax_ytd += $total_pax_ytd ; // Total Percent Revenue $total_all_qty_tdy += $total_qty_tdy ; $total_all_qty_mtd += $total_qty_mtd ; $total_all_qty_ytd += $total_qty_ytd ; @endphp @endforeach @else @endif
RmNo RmType #Rm Pax Room-Revenue (%) MTD#Rm Person Room-Revenue (%) {{$filter_type_display == 1 ? 'FTD' : 'YTD'}}#Rm Person Room-Revenue (%)
{{$room['rmno']}} {{$room['rmtype']}} {{ @$room['qty_tdy'] ?? 0 }} {{ @$room['pax_tdy'] ?? 0 }} {{ ribuanWithComma(@$room['revenue_tdy']) ?? 0 }} {{ (($perc_revenue_tdy)) ?? 0.00 }} {{ @$room['qty_mtd'] ?? 0 }} {{ @$room['pax_mtd'] ?? 0 }} {{ ribuanWithComma(@$room['revenue_mtd']) ?? 0 }} {{ (($perc_revenue_mtd)) ?? 0.00 }} {{ @$room['qty_ytd'] ?? 0 }} {{ @$room['pax_ytd'] ?? 0 }} {{ ribuanWithComma(@$room['revenue_ytd']) ?? 0 }} {{ (($perc_revenue_ytd)) ?? 0.00 }}
Total {{ $total_qty_tdy }} {{ $total_pax_tdy }} {{ ribuanWithComma($total_room['revenue_tdy'][$akey]) }} {{ (($total_perc_revenue_tdy)) }} {{ $total_qty_mtd }} {{ $total_pax_mtd }} {{ ribuanWithComma($total_room['revenue_mtd'][$akey]) }} {{ (($total_perc_revenue_mtd)) }} {{ $total_qty_ytd }} {{ $total_pax_ytd }} {{ ribuanWithComma($total_room['revenue_ytd'][$akey]) }} {{ (($total_perc_revenue_ytd)) }}
 
TOTAL {{ ribuanWithComma($total_all_qty_tdy) }} {{ ribuanWithComma($total_all_pax_tdy) }} {{ ribuanWithComma($total_room_all['revenue_tdy']) }} {{ decimalWithDot(round($total_all_perc_revenue_tdy), 2) }} {{ ribuanWithComma($total_all_qty_mtd) }} {{ ribuanWithComma($total_all_pax_mtd) }} {{ ribuanWithComma($total_room_all['revenue_mtd']) }} {{ decimalWithDot(round($total_all_perc_revenue_mtd), 2) }} {{ ribuanWithComma($total_all_qty_ytd) }} {{ ribuanWithComma($total_all_pax_ytd) }} {{ ribuanWithComma($total_room_all['revenue_ytd']) }} {{ decimalWithDot(round($total_all_perc_revenue_ytd), 2) }}

No Data