{{-- --}} COMPETITOR REPORT    
    Report Date
Printed 		: {{ date('d-m-y', strtotime(\Request::get('date_filter') ?? formatDate(getSystemDate())))}}
: {{ date('d-m-y') }}

@php $mtd = false; $ytd = false; if(\Request::get('show_filter') == 'ytd'){ $ytd = true; }else{ $mtd = true; } @endphp @if ($mtd) @endif @if ($ytd) @endif @if ($mtd) {{-- Today --}} @endif {{-- MTD --}} @if ($ytd) {{-- YTD --}} @endif @if (!$hotcoms->isEmpty()) @php // defined variable with value 0 // Hotcom $total_saleable_room = 0; $total_room_sold = 0; $total_room_sold_plus_comp = 0; $total_occupied_room = 0; $total_occupied_plus_comp = 0; $total_average_room_rate = 0; $total_revpar = 0; $total_room_revenue = 0; // Total Room Sales // Today $total_rgi = 0; $total_mpi = 0; $total_ari = 0; // MTD $total_rgi_mtd = 0; $total_mpi_mtd = 0; $total_ari_mtd = 0; // YTD $total_rgi_ytd = 0; $total_mpi_ytd = 0; $total_ari_ytd = 0; // @endphp @foreach($hotcoms as $hotcom) @php // Hotcom // today $rgi = $hotcom->revpar / $grand_total['revpar_for_calculation']; $mpi = $hotcom->occupied_room / $grand_total['occupied_room_for_calculation']; $ari = $hotcom->average_room_rate / $grand_total['average_room_rate_for_calculation']; // mtd $rgi_mtd = $hotcom->revpar_mtd / $grand_total['revpar_for_calculation_mtd']; $mpi_mtd = $hotcom->occupied_room_mtd / $grand_total['occupied_room_for_calculation_mtd']; $ari_mtd = $hotcom->average_room_rate_mtd / $grand_total['average_room_rate_for_calculation_mtd']; // ytd $rgi_ytd = $hotcom->revpar_ytd / $grand_total['revpar_for_calculation_ytd']; $mpi_ytd = $hotcom->occupied_room_ytd / $grand_total['occupied_room_for_calculation_ytd']; $ari_ytd = $hotcom->average_room_rate_ytd / $grand_total['average_room_rate_for_calculation_ytd']; // Total Room Sales // Today $total_rgi += decimalWithDot($rgi, 2); $total_mpi += decimalWithDot($mpi, 2); $total_ari += decimalWithDot($ari, 2); // MTD $total_rgi_mtd += decimalWithDot($rgi_mtd, 2); $total_mpi_mtd += decimalWithDot($mpi_mtd, 2); $total_ari_mtd += decimalWithDot($ari_mtd, 2); // YTD $total_rgi_ytd += decimalWithDot($rgi_ytd, 2); $total_mpi_ytd += decimalWithDot($mpi_ytd, 2); $total_ari_ytd += decimalWithDot($ari_ytd, 2); @endphp @if ($mtd) {{-- today --}} @endif {{-- MTD --}} @if ($ytd) {{-- YTD --}} @endif @php // $jml_room_day += @$segment->room; // $jml_rvnu_day += @$segment->revenue; // $jml_room_mon += @$segment->room_mtd; // $jml_rvnu_mon += @$segment->revenue_mtd; // $jml_room_yer += @$segment->room_ytd; // $jml_rvnu_yer += @$segment->revenue_ytd; // $serv_today += @$segment->service; // $serv_mtd += @$segment->service_mtd; // $serv_ytd += @$segment->service_ytd; // $tax_today += @$segment->tax; // $tax_mtd += @$segment->tax_mtd; // $tax_ytd += @$segment->tax_ytd; @endphp @endforeach {{-- Total Room Sales --}} @if ($mtd) {{-- today --}} @endif {{-- mtd --}} @if ($ytd) {{-- ytd --}} @endif {{-- Average Room Sales --}} @if ($mtd) {{-- today --}} @endif {{-- mtd --}} @if ($ytd) {{-- ytd --}} @endif @else @endif
Hotel NameTODAYMTDYTD
RM Avail RM Occ (Paying Only) RM Occ % Occ % Occ + Comp ARR REVPAR RM Revenue RGI MPI ARIRM Avail RM Occ (Paying Only) RM Occ % Occ % Occ + Comp ARR REVPAR RM Revenue RGI MPI ARIRM Avail RM Occ (Paying Only) RM Occ % Occ % Occ + Comp ARR REVPAR RM Revenue RGI MPI ARI
{{ $hotel_competitor_lists[$hotcom->hotel_competitor_list_id]->hotel_name }}{{ $hotcom->saleable_room }} {{ $hotcom->room_sold }} {{ $hotcom->room_sold_plus_comp }} {{ $hotcom->occupied_room }} {{ $hotcom->occupied_plus_comp }} {{ ribuanDuaAngkaBelakangKoma($hotcom->average_room_rate) }} {{ ribuanDuaAngkaBelakangKoma($hotcom->revpar) }} {{ ribuanDuaAngkaBelakangKoma($hotcom->room_revenue) }} {{ decimalWithDot($rgi, 2) }} {{ decimalWithDot($mpi, 2) }} {{ decimalWithDot($ari, 2) }}{{ $hotcom->saleable_room_mtd }} {{ $hotcom->room_sold_mtd }} {{ $hotcom->room_sold_plus_comp_mtd }} {{ $hotcom->occupied_room_mtd }} {{ $hotcom->occupied_plus_comp_mtd }} {{ ribuanDuaAngkaBelakangKoma($hotcom->average_room_rate_mtd) }} {{ ribuanDuaAngkaBelakangKoma($hotcom->revpar_mtd) }} {{ ribuanDuaAngkaBelakangKoma($hotcom->room_revenue_mtd) }} {{ decimalWithDot($rgi_mtd, 2) }} {{ decimalWithDot($mpi_mtd, 2) }} {{ decimalWithDot($ari_mtd, 2) }}{{ $hotcom->saleable_room_ytd }} {{ $hotcom->room_sold_ytd }} {{ $hotcom->room_sold_plus_comp_ytd }} {{ $hotcom->occupied_room_ytd }} {{ $hotcom->occupied_plus_comp_ytd }} {{ ribuanDuaAngkaBelakangKoma($hotcom->average_room_rate_ytd) }} {{ ribuanDuaAngkaBelakangKoma($hotcom->revpar_ytd) }} {{ ribuanDuaAngkaBelakangKoma($hotcom->room_revenue_ytd) }} {{ decimalWithDot($rgi_ytd, 2) }} {{ decimalWithDot($mpi_ytd, 2) }} {{ decimalWithDot($ari_ytd, 2) }}
TOTAL ROOM SALES{{ $grand_total['saleable_room'] }} {{ $grand_total['room_sold'] }} {{ $grand_total['room_sold_plus_comp'] }} {{ $grand_total['occupied_room'] }} {{ $grand_total['occupied_plus_comp'] }} {{ ribuanDuaAngkaBelakangKoma($grand_total['average_room_rate']) }} {{ ribuanDuaAngkaBelakangKoma($grand_total['revpar']) }} {{ ribuanDuaAngkaBelakangKoma($grand_total['room_revenue']) }} {{ decimalWithDot($total_rgi, 2) }} {{ decimalWithDot($total_mpi, 2) }} {{ decimalWithDot($total_ari, 2) }}{{ $grand_total['saleable_room_mtd'] }} {{ $grand_total['room_sold_mtd'] }} {{ $grand_total['room_sold_plus_comp_mtd'] }} {{ $grand_total['occupied_room_mtd'] }} {{ $grand_total['occupied_plus_comp_mtd'] }} {{ ribuanDuaAngkaBelakangKoma($grand_total['average_room_rate_mtd']) }} {{ ribuanDuaAngkaBelakangKoma($grand_total['revpar_mtd']) }} {{ ribuanDuaAngkaBelakangKoma($grand_total['room_revenue_mtd']) }} {{ decimalWithDot($total_rgi_mtd, 2) }} {{ decimalWithDot($total_mpi_mtd, 2) }} {{ decimalWithDot($total_ari_mtd, 2) }}{{ $grand_total['saleable_room_ytd'] }} {{ $grand_total['room_sold_ytd'] }} {{ $grand_total['room_sold_plus_comp_ytd'] }} {{ $grand_total['occupied_room_ytd'] }} {{ $grand_total['occupied_plus_comp_ytd'] }} {{ ribuanDuaAngkaBelakangKoma($grand_total['average_room_rate_ytd']) }} {{ ribuanDuaAngkaBelakangKoma($grand_total['revpar_ytd']) }} {{ ribuanDuaAngkaBelakangKoma($grand_total['room_revenue_ytd']) }} {{ decimalWithDot($total_rgi_ytd, 2) }} {{ decimalWithDot($total_mpi_ytd, 2) }} {{ decimalWithDot($total_ari_ytd, 2) }}
AVERAGE ROOM SALES{{ decimalWithDot($average_room_sales['saleable_room'], 2) }} {{ decimalWithDot($average_room_sales['room_sold'], 2) }} {{ decimalWithDot($average_room_sales['room_sold_plus_comp'], 2) }} {{ decimalWithDot($average_room_sales['occupied_room'], 2) }} {{ decimalWithDot($average_room_sales['occupied_plus_comp'], 2) }} {{ ribuanDuaAngkaBelakangKoma($average_room_sales['average_room_rate']) }} {{ ribuanDuaAngkaBelakangKoma($average_room_sales['revpar']) }} {{ ribuanDuaAngkaBelakangKoma($average_room_sales['room_revenue']) }} {{ decimalWithDot($total_rgi / $amount_data, 2) }} {{ decimalWithDot($total_mpi / $amount_data, 2) }} {{ decimalWithDot($total_ari / $amount_data, 2) }}{{ decimalWithDot($average_room_sales['saleable_room_mtd'], 2) }} {{ decimalWithDot($average_room_sales['room_sold_mtd'], 2) }} {{ decimalWithDot($average_room_sales['room_sold_plus_comp_mtd'], 2) }} {{ decimalWithDot($average_room_sales['occupied_room_mtd'], 2) }} {{ decimalWithDot($average_room_sales['occupied_plus_comp_mtd'], 2) }} {{ ribuanDuaAngkaBelakangKoma($average_room_sales['average_room_rate_mtd']) }} {{ ribuanDuaAngkaBelakangKoma($average_room_sales['revpar_mtd']) }} {{ ribuanDuaAngkaBelakangKoma($average_room_sales['room_revenue_mtd']) }} {{ decimalWithDot($total_rgi_mtd / $amount_data, 2) }} {{ decimalWithDot($total_mpi_mtd / $amount_data, 2) }} {{ decimalWithDot($total_ari_mtd / $amount_data, 2) }}{{ decimalWithDot($average_room_sales['saleable_room_ytd'], 2) }} {{ decimalWithDot($average_room_sales['room_sold_ytd'], 2) }} {{ decimalWithDot($average_room_sales['room_sold_plus_comp_ytd'], 2) }} {{ decimalWithDot($average_room_sales['occupied_room_ytd'], 2) }} {{ decimalWithDot($average_room_sales['occupied_plus_comp_ytd'], 2) }} {{ ribuanDuaAngkaBelakangKoma($average_room_sales['average_room_rate_ytd']) }} {{ ribuanDuaAngkaBelakangKoma($average_room_sales['revpar_ytd']) }} {{ ribuanDuaAngkaBelakangKoma($average_room_sales['room_revenue_ytd']) }} {{ decimalWithDot($total_rgi_ytd / $amount_data, 2) }} {{ decimalWithDot($total_mpi_ytd / $amount_data, 2) }} {{ decimalWithDot($total_ari_ytd / $amount_data, 2) }}
No Data