@foreach($filteredBookings as $booking) @php $paymentRecord = DB::table('payments')->where('booking_id', $booking->id)->first(); @endphp @endforeach

Stream ID	Customer & Hotel	Room Allocation	Duration Dates	Booking Status	Action Grid
#{{ $booking->booking_number ?? $booking->id }}	{{ $booking->user->full_name ?? 'Guest User' }} {{ $booking->user->phone_number ?? 'N/A' }} {{ $booking->hotel->hotel_name ?? 'Unknown Property' }}	{{ $booking->room->room_type ?? 'Standard Room' }} Qty: {{ $booking->room_qty }} Room(s)	{{ \Carbon\Carbon::parse($booking->check_in_date)->format('d M Y h:i A') }} {{ \Carbon\Carbon::parse($booking->check_out_date)->format('d M Y h:i A') }}	@if($booking->status == 'pending') Pending Approval @elseif($booking->status == 'confirmed') Confirmed @elseif($booking->status == 'checked_in') Stay Active @elseif($booking->status == 'checked_out') Completed @else Cancelled @endif	@if($booking->status == 'pending') @endif @if($booking->status == 'confirmed') @endif @if($booking->status == 'checked_in') @endif

Hotel Name...

₹0.00