@foreach($uniquePeriods as $each) @endforeach @for($j = 0; $j < count($uniquePeriods); $j++) @endfor {{--Grand Total Figures--}} @foreach($uniquePeriods as $period) @php $pax = isset($tableData['pax'][$period]) ? $tableData['pax'][$period] : 0 @endphp @php $revenue = isset($tableData['revenue'][$period]) ? $tableData['revenue'][$period] : 0 @endphp @php $yield = $pax ? $revenue / $pax : 0 @endphp {{--Total Period Figures--}} @endforeach @php $period_total_pax = [] @endphp @php $period_total_revenue = [] @endphp @foreach($uniqueRoute as $i => $route) @php $total_pax = isset($tableData[$route]['pax']['total']) ? $tableData[$route]['pax']['total'] : 0 @endphp @php $total_revenue = isset($tableData[$route]['revenue']['total']) ? $tableData[$route]['revenue']['total'] : 0 @endphp @php $total_yield = $total_pax ? $total_revenue / $total_pax : 0 @endphp {{--Total By POS--}} @foreach($uniquePeriods as $period) @if (isset($tableData[$route]['pax'][$period]) || isset($tableData[$route]['revenue'][$period])) @php $pax = isset($tableData[$route]['pax'][$period]) ? $tableData[$route]['pax'][$period] : 0 @endphp @php $revenue = isset($tableData[$route]['revenue'][$period]) ? $tableData[$route]['revenue'][$period] : 0 @endphp @php $yield = $pax ? $revenue / $pax : 0 @endphp @else @endif @endforeach {{--By Sector --}} @php $sectorCount = 0 @endphp @foreach($tableData[$route] as $sector => $sectorData) @if (!in_array($sector, ["pax", "revenue"])) @php $sectorCount++ @endphp @php $sector_pax = isset($sectorData['pax']['total']) ? $sectorData['pax']['total'] : 0 @endphp @php $sector_revenue = isset($sectorData['revenue']['total']) ? $sectorData['revenue']['total'] : 0 @endphp @php $sector_yield = $sector_pax ? $sector_revenue / $sector_pax : 0 @endphp {{--Total By POS--}} @foreach($uniquePeriods as $period) @if (isset($tableData[$route]['pax'][$period]) || isset($tableData[$route]['revenue'][$period])) @php $pax = isset($sectorData['pax'][$period]) ? $sectorData['pax'][$period] : 0 @endphp @php $revenue = isset($sectorData['revenue'][$period]) ? $sectorData['revenue'][$period] : 0 @endphp @php $yield = $pax ? $revenue / $pax : 0 @endphp @else @endif @endforeach @endif @endforeach @endforeach

No.	{{ isset($report_name) ? $report_name : "Queried Results" }}	Period | Flight Number | Sector
		@lang("content.total")			{{ $each }}
		PAX	@lang("content.revenue")	@lang("content.yield")	PAX	@lang("content.revenue")	@lang("content.yield")
	TOTAL:	{{ number_format($grand_total_pax) }}	{{ number_format($grand_total_revenue) }}	{{ number_format($grand_total_yield) }}	{{ number_format($pax) }}	{{ number_format($revenue) }}	{{ number_format($yield) }}
{{ $i + 1 }}	{{ $route }}	{{ number_format($total_pax) }}	{{ number_format($total_revenue) }}	{{ number_format($total_yield) }}	{{ number_format($pax) }}	{{ number_format($revenue) }}	{{ is_numeric($yield) ? number_format($yield) : $yield }}	0	0	0
	{{ $sectorCount. ") ".$sector }}	{{ number_format($sector_pax) }}	{{ number_format($sector_revenue) }}	{{ number_format($sector_yield) }}	{{ number_format($pax) }}	{{ number_format($revenue) }}	{{ is_numeric($yield) ? number_format($yield) : $yield }}	0	0	0