Booking Report
Period : {{ $period }}

@if(isset($reportType) && $reportType === 'detail') @elseif(isset($reportType) && $reportType === 'channel') @elseif(isset($reportType) && $reportType === 'country') @elseif(isset($reportType) && $reportType === 'customer_type') @elseif(isset($reportType) && $reportType === 'agent') @elseif(isset($reportType) && $reportType === 'cancelation') @elseif(isset($reportType) && ($reportType === 'avg_booking_size' || $reportType === 'avg_payment')) @elseif(isset($reportType) && $reportType === 'revenue_lost') @elseif(isset($reportType) && $reportType === 'outstanding_balance') @elseif(isset($reportType) && $reportType === 'booking_lead_time') @else @endif @if(isset($reportType) && $reportType === 'detail') @foreach ($data as $item) @endforeach @elseif(isset($reportType) && $reportType === 'channel') @foreach ($data as $item) @endforeach @elseif(isset($reportType) && $reportType === 'country') @foreach ($data as $item) @endforeach @elseif(isset($reportType) && $reportType === 'customer_type') @foreach ($data as $item) @endforeach @elseif(isset($reportType) && $reportType === 'agent') @foreach ($data as $item) @endforeach @elseif(isset($reportType) && $reportType === 'cancelation') @foreach ($data as $item) @endforeach @elseif(isset($reportType) && ($reportType === 'avg_booking_size' || $reportType === 'avg_payment')) @foreach ($data as $item) @endforeach @elseif(isset($reportType) && $reportType === 'revenue_lost') @foreach ($data as $item) @endforeach @elseif(isset($reportType) && $reportType === 'outstanding_balance') @foreach ($data as $item) @endforeach @elseif(isset($reportType) && $reportType === 'booking_lead_time') @foreach ($data as $item) @endforeach @else @php $prevBookingKey = ''; @endphp @foreach ($data as $item) @php $currentBookingKey = $item->booking_date . '|' . $item->no . '|' . $item->status . '|' . $item->agent . '|' . $item->paid . '|' . $item->currency . '|' . $item->deposit; $isNewBooking = $currentBookingKey !== $prevBookingKey; $prevBookingKey = $currentBookingKey; @endphp @endforeach @endif @if(isset($reportType) && $reportType === 'detail') @php $tQty = $data->sum('qty'); $tGross = $data->sum('gross'); $tDisc = $data->sum('disc'); $tNett = $data->sum('nett'); @endphp @elseif(isset($reportType) && $reportType === 'channel') @php $tQty = $data->sum('qty'); $tGross = $data->sum('gross'); $tDisc = $data->sum('disc'); $tNett = $data->sum('nett'); @endphp @elseif(isset($reportType) && $reportType === 'country') @php $tQty = $data->sum('qty'); $tGross = $data->sum('gross'); $tDisc = $data->sum('disc'); $tNett = $data->sum('nett'); @endphp @elseif(isset($reportType) && $reportType === 'customer_type') @php $tTotalSales = $data->sum('total_sales'); $tContribution = $data->sum('contribution'); @endphp @elseif(isset($reportType) && $reportType === 'agent') @php $tComm = $data->sum('comm'); $tNett = $data->sum('nett'); @endphp @elseif(isset($reportType) && $reportType === 'cancelation') @php $tCount = $data->sum('count'); $tPercentage = $data->sum('percentage'); @endphp @elseif(isset($reportType) && ($reportType === 'avg_booking_size' || $reportType === 'avg_payment')) @php $tAverageValue = $data->avg('average_value'); $tTotalRecords = $data->sum('total_records'); @endphp @elseif(isset($reportType) && $reportType === 'revenue_lost') @php $tAmount = $data->sum('amount'); $tBookingCount = $data->sum('booking_count'); @endphp @elseif(isset($reportType) && $reportType === 'outstanding_balance') @php $tNett = $data->sum('nett'); $tPaid = $data->sum('paid'); $tOutstanding = $data->sum('outstanding'); @endphp @elseif(isset($reportType) && $reportType === 'booking_lead_time') @php $tAvgLeadTime = $data->avg('lead_time_days'); $tTotalQty = $data->sum('qty'); $tTotalNett = $data->sum('nett'); @endphp @else @php // For invoice layout, totals: paid (unique invoice), deposit (unique invoice), pax, nett, gross $unique = collect($data)->unique('no'); $tPaid = $unique->sum('paid'); $tDeposit = $unique->sum('deposit'); $tPax = collect($data)->sum('pax'); $tNett = collect($data)->sum('nett'); $tGross = collect($data)->sum('gross'); @endphp @endif

{{ __('Code') }}	{{ __('Name') }}	{{ __('Price') }}	{{ __('Qty') }}	{{ __('Gross') }}	{{ __('Discount') }}	{{ __('Nett') }}
{{ __('Channel') }}	{{ __('Qty') }}	{{ __('Gross') }}	{{ __('Discount') }}	{{ __('Nett') }}
{{ __('Country') }}	{{ __('Qty') }}	{{ __('Gross') }}	{{ __('Discount') }}	{{ __('Nett') }}
{{ __('Customer Type') }}	{{ __('Total Sales') }}	{{ __('Contribution') }}
{{ __('Agent') }}	{{ __('Commission') }}	{{ __('Nett') }}
{{ __('Status Type') }}	{{ __('Count') }}	{{ __('Percentage') }}
{{ __('Metric Type') }}	{{ __('Average Value') }}	{{ __('Total Records') }}
{{ __('Revenue Type') }}	{{ __('Amount') }}	{{ __('Booking Count') }}
{{ __('Invoice No') }}	{{ __('Booking Date') }}	{{ __('Agent') }}	{{ __('Member') }}	{{ __('Nett') }}	{{ __('Paid') }}	{{ __('Outstanding') }}
{{ __('Invoice No') }}	{{ __('Booking Date') }}	{{ __('Detail Date') }}	{{ __('Agent') }}	{{ __('Member') }}	{{ __('Package Name') }}	{{ __('Lead Time (Days)') }}	{{ __('Qty') }}	{{ __('Nett') }}
{{ __('Booking Date') }}	{{ __('Booking No') }}	{{ __('Status') }}	{{ __('Agent') }}	{{ __('Payment Method') }}	{{ __('Currency') }}	{{ __('Paid') }}	{{ __('Deposit') }}	{{ __('Lesson Date') }}	{{ __('Lesson Time') }}	{{ __('Package Code') }}	{{ __('Package Name') }}	{{ __('Pax') }}	{{ __('Nett') }}	{{ __('Gross') }}
{{ $item->code }}	{{ $item->name }}	{{ number_format($item->price, 0) }}	{{ $item->qty }}	{{ number_format($item->gross, 0) }}	{{ number_format($item->disc, 0) }}	{{ number_format($item->nett, 0) }}
{{ $item->channel }}	{{ $item->qty }}	{{ number_format($item->gross, 0) }}	{{ number_format($item->disc, 0) }}	{{ number_format($item->nett, 0) }}
{{ $item->country }}	{{ $item->qty }}	{{ number_format($item->gross, 0) }}	{{ number_format($item->disc, 0) }}	{{ number_format($item->nett, 0) }}
{{ $item->member_type }}	{{ number_format($item->total_sales, 0) }}	{{ number_format($item->contribution, 2) }}%
{{ $item->agent }}	{{ number_format($item->comm, 0) }}	{{ number_format($item->nett, 0) }}
{{ $item->status_type }}	{{ number_format($item->count, 0) }}	{{ number_format($item->percentage, 2) }}%
{{ $item->metric_type }}	@if($reportType === 'avg_booking_size') {{ number_format($item->average_value, 0) }} pax @else {{ number_format($item->average_value, 0) }} @endif	{{ number_format($item->total_records, 0) }}
{{ $item->revenue_type }}	{{ number_format($item->amount, 0) }}	{{ number_format($item->booking_count, 0) }}
{{ $item->no }}	{{ \Carbon\Carbon::parse($item->date)->format('d M Y') }}	{{ $item->agent }}	{{ $item->member }}	{{ number_format($item->nett, 0) }}	{{ number_format($item->paid, 0) }}	{{ number_format($item->outstanding, 0) }}
{{ $item->invoice_no }}	{{ \Carbon\Carbon::parse($item->booking_date)->format('d M Y') }}	{{ \Carbon\Carbon::parse($item->detail_date)->format('d M Y') }}	{{ $item->agent }}	{{ $item->member }}	{{ $item->package_name }}	{{ $item->lead_time_days }} days	{{ number_format($item->qty, 0) }}	{{ number_format($item->nett, 0) }}
@if($isNewBooking) {{ \Carbon\Carbon::parse($item->booking_date)->format('d/m/Y') }} @endif	@if($isNewBooking) {{ $item->no }} @endif	@if($isNewBooking) {{ $item->status }} @endif	@if($isNewBooking) {{ $item->agent }} @endif	@if($isNewBooking) {{ $item->payment }} @endif	@if($isNewBooking) {{ $item->currency }} @endif	@if($isNewBooking) {{ number_format($item->paid, 0) }} @endif	@if($isNewBooking) {{ number_format($item->deposit, 0) }} @endif	{{ \Carbon\Carbon::parse($item->lesson_date)->format('d/m/Y') }}	{{ $item->lesson_time }}	{{ $item->code }}	{{ $item->name }}	{{ $item->pax }}	{{ number_format($item->nett, 0) }}	{{ number_format($item->gross, 0) }}
Total			{{ number_format($tQty, 0) }}	{{ number_format($tGross, 0) }}	{{ number_format($tDisc, 0) }}	{{ number_format($tNett, 0) }}
Total	{{ number_format($tQty, 0) }}	{{ number_format($tGross, 0) }}	{{ number_format($tDisc, 0) }}	{{ number_format($tNett, 0) }}
Total	{{ number_format($tQty, 0) }}	{{ number_format($tGross, 0) }}	{{ number_format($tDisc, 0) }}	{{ number_format($tNett, 0) }}
Total	{{ number_format($tTotalSales, 0) }}	{{ number_format($tContribution, 2) }}%
Total	{{ number_format($tComm, 0) }}	{{ number_format($tNett, 0) }}
Total	{{ number_format($tCount, 0) }}	{{ number_format($tPercentage, 2) }}%
Total	@if($reportType === 'avg_booking_size') {{ number_format($tAverageValue, 0) }} pax @else {{ number_format($tAverageValue, 0) }} @endif	{{ number_format($tTotalRecords, 0) }}
Total	{{ number_format($tAmount, 0) }}	{{ number_format($tBookingCount, 0) }}
Total Outstanding Balance				{{ number_format($tNett, 0) }}	{{ number_format($tPaid, 0) }}	{{ number_format($tOutstanding, 0) }}
Total Lead Time Analysis						{{ number_format($tAvgLeadTime, 1) }} days avg	{{ number_format($tTotalQty, 0) }}	{{ number_format($tTotalNett, 0) }}
Total						{{ number_format($tPaid, 0) }}	{{ number_format($tDeposit, 0) }}					{{ number_format($tPax, 0) }}	{{ number_format($tNett, 0) }}	{{ number_format($tGross, 0) }}