@php $my_id = auth()->user()->id; if (isset($search)) { $my_threads = App\Models\MessageThread::where(function ($query) use ($my_id) { $query->where('contact_one', $my_id)->orWhere('contact_two', $my_id); }) ->where(function ($query) use ($search) { $query->whereHas('user', function ($query) use ($search) { $query->where('name', 'like', "%$search%")->orWhere('email', 'like', "%$search%"); }); }) ->orderBy('updated_at', 'desc')->get(); } else { $my_threads = App\Models\MessageThread::where('contact_one', $my_id)->orWhere('contact_two', $my_id)->orderBy('updated_at', 'desc')->get(); } @endphp @foreach ($my_threads as $thread) @php $last_message = $thread->messages()->orderBy('id', 'desc')->firstOrNew(); $number_of_unread_message = $thread->messages()->where('read', '!=', 1)->count(); @endphp