@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
  • {{ $thread->user->name }}

    {{ ellipsis($last_message->message, 160) }}

    @if ($last_message->created_at)
    @if($number_of_unread_message > 0) {{$number_of_unread_message}} @endif

    {{ timeAgo($last_message->created_at) }}

    @endif
  • @endforeach