where('status_booking', 'Dikonfirmasi') ->get(); // Buat array untuk simpan sisa hari per booking $daysLeftPerBooking = []; foreach ($confirmedBookings as $booking) { if ($booking->tanggal_checkout) { $daysLeftPerBooking[$booking->id_booking] = now()->diffInDays(Carbon::parse($booking->tanggal_checkout), false); } else { $daysLeftPerBooking[$booking->id_booking] = null; } } // Ambil booking pending + relasi transaction, user, room $pendingBookings = Booking::with(['transaction', 'user', 'room']) ->where('status_booking', 'pending') ->get(); return view('admin.dashboard', compact( 'totalUsers', 'totalRooms', 'totalBookings', 'pendingBookings', 'confirmedBookings', 'daysLeftPerBooking' )); } }