@php
$hotelId = auth()->user()->hotel_id;
$monthRevenue = \App\Models\Payment::where('hotel_id',$hotelId)->whereMonth('created_at',now()->month)->whereYear('created_at',now()->year)->sum('amount');
$monthBookings = \App\Models\Booking::where('hotel_id',$hotelId)->whereMonth('created_at',now()->month)->whereYear('created_at',now()->year)->count();
$monthGuests = \App\Models\Guest::where('hotel_id',$hotelId)->whereMonth('created_at',now()->month)->whereYear('created_at',now()->year)->count();
@endphp
Revenue₦{{ number_format($monthRevenue, 0) }}
Bookings{{ $monthBookings }}
New Guests{{ $monthGuests }}