@extends('layouts.dashboard') @section('css') @endsection @section('sub-header') {{ __('Rooms Sales Projection Input Sheet Information') }} @endsection @section('content')
@csrf {{-- --}} {{-- Start Accomodation & Rooms Revenue Stream Information --}}

{{ __('Accomodation & Rooms Revenue Stream Information') }}

{{-- {{dd($rooms)}} --}} @foreach($rooms??[] as $index=>$room) {{-- Rooms Types --}} @php $order = 1 ; @endphp {{-- Rooms Count TD --}} @php $order = 2 ; @endphp {{-- Available Annual Rooms Nights TD --}} @php $order = 3 ; @endphp {{-- Average Guest Per Room Td --}} @php $order = 4 ; @endphp {{-- Average Daily Rate (ADR) TD --}} @php $order = 5 ; @endphp {{-- Choose Currency Td --}} @php $order = 6 ; @endphp {{-- ADR Estimation Date --}} @php $order = 7 ; @endphp {{-- ADR Escalation Rate % --}} @php $order = 8 ; @endphp {{-- ADR At Operation Date --}} @php $order = 9 ; @endphp {{-- ADR Annual Escalation Rate % --}} @endforeach
{{ __('Rooms Types') }} {{ __('Rooms Count') }} {{ __('Available Annual Rooms Nights') }} {{ __('Average Guest Per Room') }} {{ __('Average Daily Rate (ADR)') }} {{ __('Choose Currency') }} {{ __('ADR Estimation Date') }} {{ __('ADR Escalation Rate %') }} {{ __('ADR At Operation Date') }} {!! __('Annual Escalation Rate %') !!}
{{ $room->getName() }}
{{-- average_daily_rate --}}
{{-- --}}
{{-- --}}
{{-- --}} %
{{-- average_daily_rate_annual_escalation_rate --}} %
{{-- Start Accomodation & Rooms Revenue Stream Information --}} {{-- start of kt-protlet Exhange Rate Forecast % --}}

{{ __('Echange Rate Projection') }}

{{--
--}}
{{ __('Show/Hide') }}
@foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach {{-- --}} @php $currentTotal = []; @endphp @php //$order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @php $order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @php $order = $order +1 ; @endphp @endforeach
{{ __('Item') }} {{ __('Yr-') }}{{$yearIndexWithYear[$year]}} {{__('Total')}}
{{ __('Operating Months Per Year') }} @php @endphp
%
@if($model) {{ __('Echange Rate From ' . $model->getAdditionalCurrencyFormatted() . ' '.__('To') . ' ' . $model->getMainFunctionalCurrencyFormatted() ) }} @endif @php $currentVal = $model->getExchangeRateAtYear($year) ?? 0 ; @endphp
{{-- % --}}
{{-- end of kt-protlet Exhange Rate Forecast % --}} {{-- start of kt-protlet Prjected Occupancy Rate % --}}

{{ __('Targeted Annual Occupancy Rate % Projection') }}

{{ __('Show/Hide') }}
@foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach {{-- --}} {{-- {{dd($salesChannelsNames)}} --}} {{-- <@php $years= 0;$month_number = $salesPlan->start_from;$key=0;@endphp --}} @php $currentTotal = []; @endphp @php //$order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @foreach($rooms as $index=>$room) @php $order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @php $order = $order +1 ; @endphp @endforeach @endforeach
{{ __('Rooms Types') }} {{ __('Yr-') }}{{$yearIndexWithYear[$year]}} {{__('Total')}}
{{ __('Operating Months Per Year') }} @php // $currentVal = $businessSectorsPercentages[$room->getRoomIdentifier()][$year] ?? 0 ; // $currentTotal[$year]=isset($currentTotal[$year]) ? $currentTotal[$year] + $currentVal : $currentVal; @endphp {{-- onkeypress="this.style.width = ((this.value.length + 1) * 8) + 'px';" width-dynamic proba dva--}}
{{-- --}}
{{-- --}} target_nature == 'varying' || old('target_nature') == 'varying') ? '' : 'disabled'}} --}}> %
{{-- <@php $month_number++ ;$key++ @endphp --}}
{{ str_to_upper($room->getName()) }} @php $currentVal = $room->getOccupancyRateForRoomAtYear($year); $currentTotal[$year]=isset($currentTotal[$year]) ? $currentTotal[$year] + $currentVal : $currentVal; @endphp
%
@foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach {{-- --}} @php $currentTotal = []; @endphp @php //$order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @php $order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @php $order = $order +1 ; @endphp @endforeach
{{ __('Rooms Types') }} {{ __('Yr-') }}{{$yearIndexWithYear[$year]}} {{__('Total')}}
{{ __('Operating Months Per Year') }} @php // $currentVal = $businessSectorsPercentages[$room->getRoomIdentifier()][$year] ?? 0 ; // $currentTotal[$year]=isset($currentTotal[$year]) ? $currentTotal[$year] + $currentVal : $currentVal; @endphp
%
{{ __('General Occupancy Rate') }} @php $currentVal = $model->getGeneralOccupancyRateForYear($year) ?? 0 ; $currentTotal[$year]=isset($currentTotal[$year]) ? $currentTotal[$year] + $currentVal : $currentVal; @endphp
%
{{-- end of kt-protlet Prjected Occupancy Rate % --}} {{-- {{ end of Projected Occupancy Rate }} --}} {{-- start of Occupancy Rate Seasonality --}}

{{ __('Maximum Monthly Occupancy Rate % Projection') }}

{{ __('Show/Hide') }}
{{-- {{ start flat seasonlity }} --}}
@foreach($months = getMonthsForSelect() as $monthName=>$monthNameFormattedArray) @endforeach {{-- --}} @php $currentColTotal = []; @endphp @php $order = 1 ; @endphp @foreach($months as $monthName=>$monthNameFormattedArray) @if($monthName =='december') {{-- add total td --}} {{-- --}} @endif @php $order = $order +1 ; @endphp @endforeach
{{ __('Seasonality Type') }} {{$monthNameFormattedArray['title']}} {{ __('Total') }}
{{ __('General Seasonality') }} @php $currentVal = 100 ; $currentColTotal[$monthName]=isset($currentTotal[$monthName]) ? $currentTotal[$monthName] + $currentVal : $currentVal; @endphp
%
%
{{-- {{ end flat seasonlity }} --}} {{-- start monthly-seasonality --}}
@foreach($months = getMonthsForSelect() as $monthName=>$monthNameFormattedArray) @endforeach {{-- --}} @php $currentColTotal = []; @endphp @php $order = 1 ; @endphp @foreach($months as $monthName=>$monthNameFormattedArray) {{-- @dd('d') --}} @if($monthName =='december') {{-- add total td --}} {{-- --}} @endif @php $order = $order +1 ; @endphp @endforeach
{{ __('Seasonality Type') }} {{$monthNameFormattedArray['title']}} {{ __('Total') }}
{{ __('General Seasonality') }} @php $currentVal = $model->getGeneralSeasonalityAtDateOrQuarter($monthName) ?? 0 ; $currentColTotal[$monthName]=isset($currentTotal[$monthName]) ? $currentTotal[$monthName] + $currentVal : $currentVal; @endphp
%
%
{{-- end monthly-seasonality --}} {{-- Start quarterly-seasonality --}}
@foreach(quartersNames() as $qName=>$qNameFormatted) @endforeach @php $currentColTotal = []; @endphp @php $order = 1 ; @endphp @foreach(quartersNames() as $qName=>$qNameFormatted) @if($qName =='quarter-four') {{-- add total td --}} @endif @php $order = $order +1 ; @endphp @endforeach
{{ __('Seasonality Type') }} {{ $qNameFormatted }}{{ __('Total') }}
{{ __('General Seasonality') }} @php $currentVal = $generalSeasonality[$qName] ?? 0 ; $currentColTotal[$qName]=isset($currentTotal[$qName]) ? $currentTotal[$qName] + $currentVal : $currentVal; @endphp
{{-- --}} %
{{-- --}} %
{{-- end of quarterly-seasonality --}} {{-- start per room flat-seasonality --}}
@foreach($months = getMonthsForSelect() as $monthName=>$monthNameFormattedArray) @endforeach {{-- --}} @php $currentColTotal = []; @endphp @foreach($rooms as $index=>$room) @php $order = 1 ; @endphp @foreach($months as $monthName=>$monthNameFormattedArray) @if($monthName =='december') {{-- add total td --}} @endif @php $order = $order +1 ; @endphp @endforeach @endforeach
{{ __('Seasonality Type') }} {{$monthNameFormattedArray['title']}} {{ __('Total') }}
{{ $room->getName() }} @php $currentVal = 1 ; $currentColTotal[$monthName]=isset($currentTotal[$monthName]) ? $currentTotal[$monthName] + $currentVal : $currentVal; @endphp
{{-- --}} %
{{-- end per room flat seasonality --}} {{-- start per room monthly-seasonality --}}
@foreach($months = getMonthsForSelect() as $monthName=>$monthNameFormattedArray) @endforeach {{-- --}} @php $currentColTotal = []; @endphp @foreach($rooms as $index=>$room) @php $order = 1 ; @endphp @foreach($months as $monthName=>$monthNameFormattedArray) @if($monthName =='december') {{-- add total td --}} {{-- --}} @endif @php $order = $order +1 ; @endphp @endforeach @endforeach
{{ __('Seasonality Type') }} {{$monthNameFormattedArray['title']}} {{ __('Total') }}
{{ $room->getName() }} @php $currentVal = $room->getPerRoomSeasonalityForMonthOrQuarter($monthName) ; $currentColTotal[$monthName]=isset($currentTotal[$monthName]) ? $currentTotal[$monthName] + $currentVal : $currentVal; @endphp
{{-- --}} %
%
{{-- end per room monthly seasonality --}} {{-- start per room quarterly seasonality --}}
@foreach(quartersNames() as $qName=>$qNameFormatted) @endforeach {{-- --}} @php $currentColTotal = []; @endphp @foreach($rooms as $index=>$room) @php $order = 1 ; @endphp @foreach(quartersNames() as $qName=>$qNameFormatted) @if($qName =='quarter-four') {{-- add total td --}} {{-- --}} @endif @php $order = $order +1 ; @endphp @endforeach @endforeach
{{ __('Seasonality Type') }} {{ $qNameFormatted }}{{ __('Total') }}
{{ $room->getName() }} @php $currentVal = $room->getPerRoomSeasonalityForMonthOrQuarter($qName) ; $currentColTotal[$qName]=isset($currentTotal[$qName]) ? $currentTotal[$qName] + $currentVal : $currentVal; @endphp
%
%
{{-- end per room quarterly seasonality --}}
{{-- {{ end of Occupancy Rate Seasonality }} --}} @if(count($salesChannels))

{{ __('Add Reservation Channels Revenues Share & Discount Rates %') }}

{{--
--}}
{{ __('Show/Hide') }}
{{-- Start of Sales Channel Revenue Share Percentage Table --}}

{{__('Reservation Channel Revenue Share Percentage')}}

@foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @php $currentTotal = []; @endphp @foreach($salesChannels as $index=>$salesChannel) @php $salesChannelName = $salesChannel->getName(); @endphp @php $order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @php $order = $order +1 ; @endphp @endforeach @endforeach @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @php $order = $order+ 1 ; @endphp @endforeach
{{-- End of Sales Channel Revenue Share Percentage Table --}} {{-- Start Sales Channel Discount Rates % Table --}}

{{__('Reservation Channel Discount / Commission')}}

@foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @foreach($salesChannels as $index=>$salesChannel) @php $salesChannelName = $salesChannel->getName(); @endphp @php $order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @php $order = $order +1 ; @endphp @endforeach @endforeach @php $order =1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @php $order = $order+ 1 ; @endphp @endforeach
{{ __('Reservation Channel') }} {{ __('Yr-') }}{{$yearIndexWithYear[$year]}}
{{ str_to_upper($salesChannelName) }}
%
{{ __('Weighted Average Total') }}
%
{{-- End Of Sales Channel Discount Rates % Table --}}
@endif @include('admin.hospitality-sector.collection-policy',[ 'collectionPolicyFirstLabel'=>__('Collection Terms Per Reservation Channel'), 'firstHeader'=>__('Reservation Channels'), 'collectionPolicyItems'=>$salesChannels, 'modelName'=>'room', 'isGeneralCollectionPolicy'=>$model->isRoomGeneralCollection(), 'isCollectionTermPerItem'=>$model->isRoomCollectionTermPerSalesChannel(), 'onlyGeneralExpense'=>!count($salesChannels) ])
@endsection @section('js') @endsection