@php $i = 1; $totalAmount = 0; $totalCommission = 0; @endphp @foreach($bookings as $booking) @php $totalAmount += $booking->total_price; $totalCommission += $booking->admin_price; @endphp @endforeach

#	Booking ID	Reference	Customer	Check-In	Check-Out	Total Amount	Commission	Status	Booked By
{{ $i++ }}	{{ $booking->booking_id }}	{{ $booking->booking_reference }}	{{ $booking->holder_name }}	{{ date('d-M-Y', strtotime($booking->checkin)) }}	{{ date('d-M-Y', strtotime($booking->checkout)) }}	{{ number_format($booking->total_price, 2) }}	{{ number_format($booking->admin_price, 2) }}	@if($booking->status == 'Confirmed') Confirmed @elseif($booking->status == 'Pending') Pending @elseif($booking->status == 'Cancelled') Cancelled @else {{ ucfirst($booking->status) }} @endif	@if($booking->agency_id == 1) Admin @elseif($booking->agency_id == 2) Agent @else Employee @endif
Summary Totals:						{{ number_format($totalAmount, 2) }}	{{ number_format($totalCommission, 2) }}