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 @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 Name	TODAY											MTD											YTD
	RM Avail	RM Occ (Paying Only)	RM Occ	{{'%'}} Occ	{{'%'}} Occ {{'+'}} Comp	ARR	REVPAR	RM Revenue	RGI	MPI	ARI	RM Avail	RM Occ (Paying Only)	RM Occ	{{'%'}} Occ	{{'%'}} Occ {{'+'}} Comp	ARR	REVPAR	RM Revenue	RGI	MPI	ARI	RM 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 }}	{{ ($hotcom->average_room_rate) }}	{{ ($hotcom->revpar) }}	{{ ($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 }}	{{ ($hotcom->average_room_rate_mtd) }}	{{ ($hotcom->revpar_mtd) }}	{{ ($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 }}	{{ ($hotcom->average_room_rate_ytd) }}	{{ ($hotcom->revpar_ytd) }}	{{ ($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'] }}	{{ ($grand_total['average_room_rate']) }}	{{ ($grand_total['revpar']) }}	{{ ($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'] }}	{{ ($grand_total['average_room_rate_mtd']) }}	{{ ($grand_total['revpar_mtd']) }}	{{ ($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'] }}	{{ ($grand_total['average_room_rate_ytd']) }}	{{ ($grand_total['revpar_ytd']) }}	{{ ($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) }}	{{ ($average_room_sales['average_room_rate']) }}	{{ ($average_room_sales['revpar']) }}	{{ ($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) }}	{{ ($average_room_sales['average_room_rate_mtd']) }}	{{ ($average_room_sales['revpar_mtd']) }}	{{ ($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) }}	{{ ($average_room_sales['average_room_rate_ytd']) }}	{{ ($average_room_sales['revpar_ytd']) }}	{{ ($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