@extends('layouts.dashboard') @section('css') @endsection @section('sub-header') {{ __('Meeting Spaces Sales Projection Input Sheet') }} @endsection @section('content')
@csrf {{-- Start Choose F&B Sales Projection Method --}}

{{ __('Choose Meeting Spaces Sales Projection Method') }}

{{ __('Show/Hide') }}
{{-- Meetings Types --}} @php $order = 1 ; @endphp {{-- Meetings Count TD --}} @php $order = $order +1 ; @endphp @foreach(count($meetings) ? $meetings : generateTotalMeetingInstance($model) as $index=>$meeting) {{-- Meetings Types --}} @php $order = 2 ; @endphp {{-- Meetings Count TD --}} @php $order = $order +1 ; @endphp @endforeach
{{ __('Meeting Spaces Facility') }} {{ __('Select Projection Method') }}
{{ __('Same Method For All Meeting Spaces Facilities') }}
{{ $meeting->getName() }}
{{-- End of Choose F&B Sales Projection Method --}} {{-- --}} @php $currentSectionName = guest_count_charges_per_guest_occupancy_rate_method ; @endphp {{-- start of Guest Count x Charges Per Guest x Occupancy Rate Method --}}

{{ __('Guest Count x Charges Per Guest x Occupancy Rate Method') }}

{{ __('Show/Hide') }}
@foreach($itemsInEachSection[$currentSectionName]??[] as $index=>$meeting) {{-- Meetings Types --}} @php $order = 1 ; @endphp {{-- Meetings Count TD --}} {{-- Daily Cover Count Per Facility --}} {{-- Total Guest Capacity --}} {{-- Cover Value --}} {{-- Choose Currency Td --}} {{-- Estimation Date --}} {{-- Cover Value Escalation Rate % --}} {{-- Cover Value At Operation Date --}} {{-- Cover Value Annual Escalation Rate % --}} @php $order = $order +1 ; @endphp @endforeach
{{ __('Meeting Spaces Facility') }} {{ __('Meeting Spaces Facility Count') }} {{ __('Guest Capacity') }} {{ __('Total Guest Capacity') }} {{ __('Charges Value Per Guest') }} {{ __('Choose Currency') }} {{ __('Estimation Date') }} {{ __('Charges Value Escalation Rate %') }} {{ __('Charges Value At Operation Date') }} {{ __('Charges Value Annual Escalation Rate %') }}
{{ $meeting->getName() }}
{{-- --}}
{{-- --}}
{{-- --}} %
{{-- --}}
{{-- average_daily_rate_annual_escalation_rate --}} %
{{-- --}}
@foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @php $currentTotal = []; @endphp @php @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @foreach($itemsInEachSection[$currentSectionName]??[] as $index=>$meeting) @php $order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @php $order = $order +1 ; @endphp @endforeach @endforeach
{{ __('Facility Types') }} {{ __('Input') }} {{ __('Yr-') }}{{$yearIndexWithYear[$year]}}
{{ __('Total Days Count') }} @php @endphp
%
{{ str_to_upper($meeting->getName()) }} {{ __('Occupency %') }} @php $currentVal = $meeting->getGuestFacilityOccupancyRateAtYear($year); $currentTotal[$year]=isset($currentTotal[$year]) ? $currentTotal[$year] + $currentVal : $currentVal; @endphp
%
{{-- end of Guest Count x Charges Per Guest x Occupancy Rate Method --}} {{-- start of Occupancy Rate Seasonality --}}

{{ __('Occupancy Rate % Seasonality 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 = 1/12 ; $currentColTotal[$monthNameFormattedArray['value']]=isset($currentTotal[$monthNameFormattedArray['value']]) ? $currentTotal[$monthNameFormattedArray['value']] + $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->getGuestGeneralSeasonalityAtDateOrQuarter($monthNameFormattedArray['value']) ?? 0 ; $currentColTotal[$monthNameFormattedArray['value']]=isset($currentTotal[$monthNameFormattedArray['value']]) ? $currentTotal[$monthNameFormattedArray['value']] + $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 = $generalGuestSeasonality[$qName] ?? 0 ; $currentColTotal[$qName]=isset($currentTotal[$qName]) ? $currentTotal[$qName] + $currentVal : $currentVal; @endphp
{{-- --}} %
{{-- % --}}
{{-- --}}
{{-- end of quarterly-seasonality --}} {{-- start per meeting flat-seasonality --}}
@foreach($months = getMonthsForSelect() as $monthName=>$monthNameFormattedArray) @endforeach @php $currentColTotal = []; @endphp @foreach($meetings as $index=>$meeting) @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') }}
{{ $meeting->getName() }} @php $currentVal = 1/12 ; $currentColTotal[$monthNameFormattedArray['value']]=isset($currentTotal[$monthNameFormattedArray['value']]) ? $currentTotal[$monthNameFormattedArray['value']] + $currentVal : $currentVal; @endphp
{{-- --}} %
%
{{-- --}}
{{-- end per meeting flat seasonality --}} {{-- start per meeting monthly-seasonality --}}
@foreach($months = getMonthsForSelect() as $monthName=>$monthNameFormattedArray) @endforeach @php $currentColTotal = []; @endphp @foreach($itemsInEachSection[$currentSectionName]??[] as $index=>$meeting) @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') }}
{{ $meeting->getName() }} @php $currentVal = $meeting->getGuestPerMeetingSeasonalityForMonthOrQuarter($monthNameFormattedArray['value']) ; $currentColTotal[$monthNameFormattedArray['value']]=isset($currentTotal[$monthNameFormattedArray['value']]) ? $currentTotal[$monthNameFormattedArray['value']] + $currentVal : $currentVal; @endphp
{{-- --}} %
%
{{-- end per meeting monthly seasonality --}} {{-- start per meeting quarterly seasonality --}}
@foreach(quartersNames() as $qName=>$qNameFormatted) @endforeach @php $currentColTotal = []; @endphp @foreach($itemsInEachSection[$currentSectionName]??[] as $index=>$meeting) @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') }}
{{ $meeting->getName() }} @php $currentVal = $meeting->getGuestPerMeetingSeasonalityForMonthOrQuarter($qName) ; $currentColTotal[$qName]=isset($currentTotal[$qName]) ? $currentTotal[$qName] + $currentVal : $currentVal; @endphp
%
%
{{-- --}}
{{-- end per meeting quarterly seasonality --}}
{{-- {{ end of Occupancy Rate Seasonality }} --}} @php $currentSectionName = facility_count_daily_rent_occupancy_rate_method ; @endphp {{-- start of Facility Count x Daily Rent x Occupancy Rate Method --}}

{{ __('Facility Count x Daily Rent x Occupancy Rate Method') }}

{{ __('Show/Hide') }}
@foreach($itemsInEachSection[$currentSectionName]??[] as $index=>$meeting) {{-- Meetings Types --}} @php $order = 1 ; @endphp {{-- Meetings Count TD --}} {{-- Daily Cover Count Per Facility --}} {{-- Total Guest Capacity --}} {{-- Cover Value --}} {{-- Choose Currency Td --}} {{-- Estimation Date --}} {{-- Cover Value Escalation Rate % --}} {{-- Cover Value At Operation Date --}} {{-- Cover Value Annual Escalation Rate % --}} @php $order = $order +1 ; @endphp @endforeach
{{ __('Meeting Sapces Facility') }} {{ __('Meeting Sapces Facility Count') }} {{ __('Guest Capacity') }} {{ __('Total Guest Capacity') }} {{ __('Daily Rent Per Facility') }} {{ __('Choose Currency') }} {{ __('Estimation Date') }} {{ __('Daily Rent Escalation Rate %') }} {{ __('Daily Rent At Operation Date') }} {{ __('Daily Rent Annual Escalation Rate %') }}
{{ $meeting->getName() }}
{{-- --}}
{{-- --}}
{{-- --}} %
{{-- --}}
{{-- average_daily_rate_annual_escalation_rate --}} %
{{-- --}}
@foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @php $currentTotal = []; @endphp @php @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @foreach($itemsInEachSection[$currentSectionName]??[] as $index=>$meeting) @php $order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @php $order = $order +1 ; @endphp @endforeach @endforeach
{{ __('Facility Types') }} {{ __('Input') }} {{ __('Yr-') }}{{$yearIndexWithYear[$year]}}
{{ __('Total Days Count') }} @php @endphp
%
{{ str_to_upper($meeting->getName()) }} {{ __('Occupancy Rate %') }} @php $currentVal = $meeting->getGuestFacilityOccupancyRateAtYear($year); $currentTotal[$year]=isset($currentTotal[$year]) ? $currentTotal[$year] + $currentVal : $currentVal; @endphp
%
{{-- end of Facility Count x Daily Rent x Occupancy Rate Method --}} {{-- start of Occupancy Rate Seasonality --}}

{{ __('Occupancy Rate % Seasonality 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 = 1/12 ; $currentColTotal[$monthNameFormattedArray['value']]=isset($currentTotal[$monthNameFormattedArray['value']]) ? $currentTotal[$monthNameFormattedArray['value']] + $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->getRentGeneralSeasonalityAtDateOrQuarter($monthNameFormattedArray['value']) ?? 0 ; $currentColTotal[$monthNameFormattedArray['value']]=isset($currentTotal[$monthNameFormattedArray['value']]) ? $currentTotal[$monthNameFormattedArray['value']] + $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 = $generalRentSeasonality[$qName] ?? 0 ; $currentColTotal[$qName]=isset($currentTotal[$qName]) ? $currentTotal[$qName] + $currentVal : $currentVal; @endphp
{{-- --}} %
%
{{-- end of quarterly-seasonality --}} {{-- start per meeting flat-seasonality --}}
@foreach($months = getMonthsForSelect() as $monthName=>$monthNameFormattedArray) @endforeach @php $currentColTotal = []; @endphp @foreach($itemsInEachSection[$currentSectionName]??[] as $index=>$meeting) @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') }}
{{ $meeting->getName() }} @php $currentVal = 1/12 ; $currentColTotal[$monthNameFormattedArray['value']]=isset($currentTotal[$monthNameFormattedArray['value']]) ? $currentTotal[$monthNameFormattedArray['value']] + $currentVal : $currentVal; @endphp
{{-- --}} %
{{-- --}} %
{{-- end per meeting flat seasonality --}} {{-- start per meeting monthly-seasonality --}}
@foreach($months = getMonthsForSelect() as $monthName=>$monthNameFormattedArray) @endforeach @php $currentColTotal = []; @endphp @foreach($itemsInEachSection[$currentSectionName]??[] as $index=>$meeting) @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') }}
{{ $meeting->getName() }} @php $currentVal = $meeting->getRentPerMeetingSeasonalityForMonthOrQuarter($monthNameFormattedArray['value']) ; $currentColTotal[$monthNameFormattedArray['value']]=isset($currentTotal[$monthNameFormattedArray['value']]) ? $currentTotal[$monthNameFormattedArray['value']] + $currentVal : $currentVal; @endphp
{{-- --}} %
%
{{-- end per meeting monthly seasonality --}} {{-- start per meeting quarterly seasonality --}}
@foreach(quartersNames() as $qName=>$qNameFormatted) @endforeach @php $currentColTotal = []; @endphp @foreach($itemsInEachSection[$currentSectionName]??[] as $index=>$meeting) @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') }}
{{ $meeting->getName() }} @php $currentVal = $meeting->getRentPerMeetingSeasonalityForMonthOrQuarter($qName) ; $currentColTotal[$qName]=isset($currentTotal[$qName]) ? $currentTotal[$qName] + $currentVal : $currentVal; @endphp
%
{{-- end per meeting quarterly seasonality --}}
{{-- {{ end of Occupancy Rate Seasonality }} --}} @php $currentSectionName = percentage_from_f_b_revenue ; @endphp {{-- start of Percenatge % From F & b Revenues --}}

{{ __('Percenatge % From F&B Revenues') }}

{{ __('Show/Hide') }}
@foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @php $currentTotal = []; @endphp @php @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @endforeach @foreach($itemsInEachSection[$currentSectionName]??[] as $index=>$meeting) @php $order = 1 ; @endphp @foreach($yearsWithItsMonths as $year=>$monthsForThisYearArray) @php $order = $order +1 ; @endphp @endforeach @endforeach
{{ __('Facility Types') }} {{ __('Input') }} {{ __('Yr-') }}{{$yearIndexWithYear[$year]}}
{{ __('Total F&B Revenues') }} @php @endphp
%
{{ str_to_upper($meeting->getName()) }} {{ __('% From F&B Revenues') }} @php $currentVal = $meeting->getPercentageFromRevenue($year); $currentTotal[$year]=isset($currentTotal[$year]) ? $currentTotal[$year] + $currentVal : $currentVal; @endphp
%
{{-- end of Percenatge % From F & b Revenues --}} @include('admin.hospitality-sector.collection-policy',[ 'collectionPolicyFirstLabel'=>__('Collection Terms Per Facility'), 'firstHeader'=>__('Facility Name'), 'collectionPolicyItems'=>$meetings, 'modelName'=>'meeting', 'isGeneralCollectionPolicy'=>$model->isMeetingGeneralCollection(), 'isCollectionTermPerItem'=>$model->isMeetingCollectionTermPerSalesChannel(), 'onlyGeneralExpense'=>isTotal($meetings) ])
@endsection @section('js') @endsection