{{newMessages()}} @php $is_freelancer = auth()->user()->isFreelancer(); $chats = auth()->user()->chats() ->with('lastMessage') ->withCount(['messages as unread_messages_count' => function ($query) { $query->where('is_read', 0)->where('sender_id', '!=', auth()->id()); }]) ->addSelect(['last_message_at' => \App\Models\ChatMessage::select('created_at') ->whereColumn('chat_id', 'chats.id') ->latest() ->limit(1) ]) ->orderByDesc('last_message_at') ->limit(7) ->get(); @endphp