@if (count($room_productions) > 0)
@php
$total_perc_lodging_tdy = $total_perc_lodging_mtd = $total_perc_lodging_ytd = 0;
@endphp
@if (count($companies) > 0)
@foreach ($companies as $key_company => $company)
@php
// Percent Lodging
$perc_lodging_tdy = $total_room_prod['lodging_tdy'] > 0 ? ( round( ((@$room_productions[$company_key_position[$company['name']]]['lodging_tdy'] ?? 0) / @$total_room_prod['lodging_tdy'] * 100) , 2) ) : 0;
$perc_lodging_mtd = $total_room_prod['lodging_tdy'] > 0 ? ( round( ((@$room_productions[$company_key_position[$company['name']]]['lodging_mtd'] ?? 0) / @$total_room_prod['lodging_mtd'] * 100) , 2) ) : 0;
$perc_lodging_ytd = $total_room_prod['lodging_tdy'] > 0 ? ( round( ((@$room_productions[$company_key_position[$company['name']]]['lodging_ytd'] ?? 0) / @$total_room_prod['lodging_ytd'] * 100) , 2) ) : 0;
// Total Percent Lodging
$total_perc_lodging_tdy += $perc_lodging_tdy ;
$total_perc_lodging_mtd += $perc_lodging_mtd ;
$total_perc_lodging_ytd += $perc_lodging_ytd ;
@endphp
{{ @$room_productions[$company_key_position[$company['name']]]['name'] ?? $company['name'] }} |
@if (in_array($show_filter_data, [00,22]))
{{ @$room_productions[$company_key_position[$company['name']]]['room_tdy'] ?? 0 }} |
{{ @$room_productions[$company_key_position[$company['name']]]['exComp_room_tdy'] ?? 0 }} |
{{ @$room_productions[$company_key_position[$company['name']]]['pax_tdy'] ?? 0 }} |
{{ @$room_productions[$company_key_position[$company['name']]]['exComp_pax_tdy'] ?? 0 }} |
{{ @ribuanWithComma($room_productions[$company_key_position[$company['name']]]['lodging_tdy'] ?? 0) }} |
{{ decimalWithDot($perc_lodging_tdy, 2) }} |
{{ @ribuanWithComma($room_productions[$company_key_position[$company['name']]]['avr_rm_rate'] ?? 0) }} |
{{ @ribuanWithComma($room_productions[$company_key_position[$company['name']]]['exComp_avr_rm_rate'] ?? 0) }} |
@endif
@if (in_array($show_filter_data, [00,11]))
{{ @$room_productions[$company_key_position[$company['name']]]['room_mtd'] ?? 0 }} |
{{ @$room_productions[$company_key_position[$company['name']]]['exComp_room_mtd'] ?? 0 }} |
{{ @$room_productions[$company_key_position[$company['name']]]['pax_mtd'] ?? 0 }} |
{{ @$room_productions[$company_key_position[$company['name']]]['exComp_pax_mtd'] ?? 0 }} |
{{ @ribuanWithComma($room_productions[$company_key_position[$company['name']]]['lodging_mtd'] ?? 0) }} |
{{ decimalWithDot($perc_lodging_mtd, 2) }} |
{{ @ribuanWithComma($room_productions[$company_key_position[$company['name']]]['avr_rm_rate_mtd'] ?? 0) }} |
{{ @ribuanWithComma($room_productions[$company_key_position[$company['name']]]['exComp_avr_rm_rate_mtd'] ?? 0) }} |
@endif
@if (in_array($show_filter_data, [11,22]))
{{ @$room_productions[$company_key_position[$company['name']]]['room_ytd'] ?? 0 }} |
{{ @$room_productions[$company_key_position[$company['name']]]['exComp_room_ytd'] ?? 0 }} |
{{ @$room_productions[$company_key_position[$company['name']]]['pax_ytd'] ?? 0 }} |
{{ @$room_productions[$company_key_position[$company['name']]]['exComp_pax_ytd'] ?? 0 }} |
{{ @ribuanWithComma($room_productions[$company_key_position[$company['name']]]['lodging_ytd'] ?? 0) }} |
{{ decimalWithDot($perc_lodging_ytd, 2) }} |
{{ @ribuanWithComma($room_productions[$company_key_position[$company['name']]]['avr_rm_rate_ytd'] ?? 0) }} |
{{ @ribuanWithComma($room_productions[$company_key_position[$company['name']]]['exComp_avr_rm_rate_ytd'] ?? 0) }} |
@endif
{{ @$room_productions[$company_key_position[$company['name']]]['sales'] }} |
@endforeach
@else
@foreach($room_productions as $key => $room_prod)
@php
// Percent Lodging
$perc_lodging_tdy = $total_room_prod['lodging_tdy'] > 0 ? ( round( ((@$room_prod['lodging_tdy'] ?? 0) / @$total_room_prod['lodging_tdy'] * 100) , 2) ) : 0;
$perc_lodging_mtd = $total_room_prod['lodging_tdy'] > 0 ? ( round( ((@$room_prod['lodging_mtd'] ?? 0) / @$total_room_prod['lodging_mtd'] * 100) , 2) ) : 0;
$perc_lodging_ytd = $total_room_prod['lodging_tdy'] > 0 ? ( round( ((@$room_prod['lodging_ytd'] ?? 0) / @$total_room_prod['lodging_ytd'] * 100) , 2) ) : 0;
// Total Percent Lodging
$total_perc_lodging_tdy += $perc_lodging_tdy ;
$total_perc_lodging_mtd += $perc_lodging_mtd ;
$total_perc_lodging_ytd += $perc_lodging_ytd ;
@endphp
{{ @$room_prod['name'] }} |
@if (in_array($show_filter_data, [00,22]))
{{ @$room_prod['room_tdy'] ?? 0 }} |
{{ @$room_prod['exComp_room_tdy'] ?? 0 }} |
{{ @$room_prod['pax_tdy'] ?? 0 }} |
{{ @$room_prod['exComp_pax_tdy'] ?? 0 }} |
{{ @ribuanWithComma($room_prod['lodging_tdy'] ?? 0) }} |
{{ decimalWithDot($perc_lodging_tdy, 2) }} |
{{ @ribuanWithComma($room_prod['avr_rm_rate'] ?? 0) }} |
{{ @ribuanWithComma($room_prod['exComp_avr_rm_rate'] ?? 0) }} |
@endif
@if (in_array($show_filter_data, [00,11]))
{{ @$room_prod['room_mtd'] ?? 0 }} |
{{ @$room_prod['exComp_room_mtd'] ?? 0 }} |
{{ @$room_prod['pax_mtd'] ?? 0 }} |
{{ @$room_prod['exComp_pax_mtd'] ?? 0 }} |
{{ @ribuanWithComma($room_prod['lodging_mtd'] ?? 0) }} |
{{ decimalWithDot($perc_lodging_mtd, 2) }} |
{{ @ribuanWithComma($room_prod['avr_rm_rate_mtd'] ?? 0) }} |
{{ @ribuanWithComma($room_prod['exComp_avr_rm_rate_mtd'] ?? 0) }} |
@endif
@if (in_array($show_filter_data, [11,22]))
{{ @$room_prod['room_ytd'] ?? 0 }} |
{{ @$room_prod['exComp_room_ytd'] ?? 0 }} |
{{ @$room_prod['pax_ytd'] ?? 0 }} |
{{ @$room_prod['exComp_pax_ytd'] ?? 0 }} |
{{ @ribuanWithComma($room_prod['lodging_ytd'] ?? 0) }} |
{{ decimalWithDot($perc_lodging_ytd, 2) }} |
{{ @ribuanWithComma($room_prod['avr_rm_rate_ytd'] ?? 0) }} |
{{ @ribuanWithComma($room_prod['exComp_avr_rm_rate_ytd'] ?? 0) }} |
@endif
{{ @$room_prod['sales'] }} |
@endforeach
@endif
@if ( count($total_room_prod) > 0 )
Total |
@if (in_array($show_filter_data, [00,22]))
{{ ribuanWithComma($total_room_prod['room_tdy']) }} |
{{ ribuanWithComma($total_room_prod['exComp_room_tdy']) }} |
{{ ribuanWithComma($total_room_prod['pax_tdy']) }} |
{{ ribuanWithComma($total_room_prod['exComp_pax_tdy']) }} |
{{ ribuanWithComma($total_room_prod['lodging_tdy']) }} |
{{ decimalWithDot(round($total_perc_lodging_tdy), 2) }} |
{{ ribuanWithComma($total_room_prod['avr_rm_rate_tdy']) }} |
{{ ribuanWithComma($total_room_prod['exComp_avr_rm_rate_tdy']) }} |
@endif
@if (in_array($show_filter_data, [00,11]))
{{ ribuanWithComma($total_room_prod['room_mtd']) }} |
{{ ribuanWithComma($total_room_prod['exComp_room_mtd']) }} |
{{ ribuanWithComma($total_room_prod['pax_mtd']) }} |
{{ ribuanWithComma($total_room_prod['exComp_pax_mtd']) }} |
{{ ribuanWithComma($total_room_prod['lodging_mtd']) }} |
{{ decimalWithDot(round($total_perc_lodging_mtd), 2) }} |
{{ ribuanWithComma($total_room_prod['avr_rm_rate_mtd']) }} |
{{ ribuanWithComma($total_room_prod['exComp_avr_rm_rate_mtd']) }} |
@endif
@if (in_array($show_filter_data, [11,22]))
{{ ribuanWithComma($total_room_prod['room_ytd']) }} |
{{ ribuanWithComma($total_room_prod['exComp_room_ytd']) }} |
{{ ribuanWithComma($total_room_prod['pax_ytd']) }} |
{{ ribuanWithComma($total_room_prod['exComp_pax_ytd']) }} |
{{ ribuanWithComma($total_room_prod['lodging_ytd']) }} |
{{ decimalWithDot(round($total_perc_lodging_ytd), 2) }} |
{{ ribuanWithComma($total_room_prod['avr_rm_rate_ytd']) }} |
{{ ribuanWithComma($total_room_prod['exComp_avr_rm_rate_ytd']) }} |
@endif
|
@else
No Data
|
@endif
@else
No Data
|
@endif