@php
    $staffCache = [];
    $studentCache = [];
    $participantCache = [];
    $schoolAdminId = null;
@endphp
@foreach($messages as $msg)
@php
    $isMe = ($msg->sender_id == $staffId);

    // ============ 1) PARTICIPANTS CACHE ============
 if (!isset($participantCache[$msg->conversation_id])) {
     $participantCache[$msg->conversation_id] = DB::table('school_conversation_participants')
         ->where('conversation_id', $msg->conversation_id)->get();
 }

 // ============ 2) ✅ SCHOOL ADMIN ID via users.user_type (NOT role!) ============
 if ($schoolAdminId === null) {
     $schoolAdminId = (int) (DB::table('users')
         ->where('school_id', session('staff_school_id'))
         ->where('user_type', 'school_admin')
         ->value('id') ?? 0);
 }

 // ============ 3) SENDER ROLE — COLLISION-PROOF ORDER ============
 $senderRole = null;

 // (a) ADMIN FIRST: users.id 4 collides with school_staff.id 4 (JASPREET)
 if (!$isMe && $schoolAdminId && (int) $msg->sender_id === $schoolAdminId) {
     $senderRole = 'school';
 }

 // (b) Participants: STAFF wins, then STUDENT, then SCHOOL last.
 //     (old buggy chats contain a fake 'school' participant user_id=1 which
 //      equals GURLEEN's staff id — so 'school' must be checked LAST here)
 if ($senderRole === null) {
     $roles = [];
     foreach ($participantCache[$msg->conversation_id] as $part) {
         if ((int) $part->user_id === (int) $msg->sender_id) { $roles[] = $part->role; }
     }
     if (in_array('staff', $roles))       { $senderRole = 'staff'; }
     elseif (in_array('student', $roles)) { $senderRole = 'student'; }
     elseif (in_array('school', $roles))  { $senderRole = 'school'; }
 }

 // (c) NOT a participant (Principal / Admin in old chats): staff -> student -> school
 if ($senderRole === null && !$isMe) {
     if (!isset($staffCache[$msg->sender_id])) {
         $staffCache[$msg->sender_id] = DB::table('school_staff')
             ->where('id', $msg->sender_id)
             ->where('school_id', session('staff_school_id'))
             ->first();
     }
     if ($staffCache[$msg->sender_id]) {
         $senderRole = 'staff';
     } else {
         if (!isset($studentCache[$msg->sender_id])) {
             $studentCache[$msg->sender_id] = DB::table('students')
                 ->where('id', $msg->sender_id)
                 ->where('school_id', session('staff_school_id'))
                 ->first();
         }
         $senderRole = $studentCache[$msg->sender_id] ? 'student' : 'school';
     }
 }
 if ($senderRole === null) { $senderRole = 'school'; }

    // ============ 3) SENDER NAME / INITIALS / DESIGNATION ============
    $senderName = null;
    $senderInitials = '';
    $senderDesignation = '';

    if (!$isMe) {
        if ($senderRole == 'student') {
            if (!isset($studentCache[$msg->sender_id])) {
                $studentCache[$msg->sender_id] = DB::table('students')->where('id', $msg->sender_id)->first();
            }
            $senderName = $studentCache[$msg->sender_id]->student_name ?? 'Student';
        } elseif ($senderRole == 'staff') {
            if (!isset($staffCache[$msg->sender_id])) {
                $staffCache[$msg->sender_id] = DB::table('school_staff')->where('id', $msg->sender_id)->first();
            }
            $senderName = $staffCache[$msg->sender_id]->staff_name ?? 'Teacher';
            $senderDesignation = strtoupper(trim($staffCache[$msg->sender_id]->designation ?? ''));
        } else {
            $senderName = 'School Admin';
            $senderDesignation = 'ADMIN';
        }
        foreach (explode(' ', $senderName) as $p) { $senderInitials .= strtoupper(substr($p, 0, 1)); }
    }

    // ✅ PRINCIPAL messages = SCHOOL ADMIN bubble for students & teachers
    $showAsSchool = (!$isMe) && ($senderRole == 'school' || ($senderRole == 'staff' && $senderDesignation === 'PRINCIPAL'));
    $isStudent   = (!$isMe) && $senderRole == 'student';
    $isTeacher   = (!$isMe) && $senderRole == 'staff' && !$showAsSchool;
    $darkBubble  = $isMe || $showAsSchool;
@endphp
<div class="flex {{ $isMe ? 'justify-end' : 'justify-start' }}">
    <div class="flex items-end gap-2 {{ $isMe ? 'flex-row-reverse' : 'flex-row' }} max-w-[85%]">
        <!-- Avatar -->
        <div class="w-8 h-8 rounded-full overflow-hidden flex-shrink-0 border border-slate-300 flex items-center justify-center
            {{ $isMe ? 'bg-amber-100' : ($showAsSchool ? 'bg-indigo-600' : ($isStudent ? 'bg-emerald-100' : 'bg-amber-100')) }}">
            @if($isMe)
                <span class="text-amber-600 font-bold text-[10px]">ME</span>
            @elseif($showAsSchool)
                <i class="fa-solid fa-school text-white text-xs"></i>
            @else
                <span class="{{ $isStudent ? 'text-emerald-600' : 'text-amber-600' }} font-bold text-[10px]">{{ $senderInitials ?: 'U' }}</span>
            @endif
        </div>
        <!-- Bubble -->
        <div class="max-w-full min-w-0">
            @if(!$isMe)
                <p class="text-[9px] font-bold uppercase tracking-wider mb-0.5 ml-1 {{ $showAsSchool ? 'text-indigo-500' : ($isStudent ? 'text-emerald-600' : 'text-amber-600') }}">
                    {{ $showAsSchool ? 'School Admin' : $senderName }}@if($isTeacher) · Teacher @endif
                </p>
            @endif
            <div class="p-3 rounded-2xl text-sm leading-relaxed break-words
                {{ $isMe ? 'rounded-br-none bg-amber-500 text-white shadow-md' : ($showAsSchool ? 'rounded-bl-none bg-indigo-600 text-white shadow-md' : ($isStudent ? 'rounded-bl-none bg-white border border-slate-200 shadow-sm text-slate-700' : 'rounded-bl-none bg-amber-50 border border-amber-200 shadow-sm text-slate-700')) }}">
                @if(Str::startsWith($msg->message, 'http'))
                    @php
                        $fileUrl = $msg->message;
                        $fileName = basename($fileUrl);
                        $fileExt = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
                        $isImage = in_array($fileExt, ['jpg', 'jpeg', 'png', 'gif', 'webp']);
                        $isPdf = $fileExt === 'pdf';
                        $isWord = in_array($fileExt, ['doc', 'docx']);
                        $isExcel = in_array($fileExt, ['xls', 'xlsx']);
                    @endphp
                    @if($isImage)
                        <a href="{{ $fileUrl }}" target="_blank" class="block mb-1">
                            <img src="{{ $fileUrl }}" class="max-w-full h-auto rounded-lg {{ $darkBubble ? 'border border-white/20' : 'border border-slate-200' }}" loading="lazy">
                        </a>
                    @else
                        <a href="{{ $fileUrl }}" target="_blank" class="flex items-center gap-3 p-2 rounded-lg {{ $darkBubble ? 'bg-white/10 hover:bg-white/20' : 'bg-slate-100 hover:bg-slate-200' }} transition-all">
                            <div class="w-10 h-10 rounded-lg flex items-center justify-center {{ $isPdf ? 'bg-red-100 text-red-600' : ($isWord ? 'bg-blue-100 text-blue-600' : ($isExcel ? 'bg-green-100 text-green-600' : 'bg-slate-200 text-slate-600')) }}">
                                <i class="fa-solid {{ $isPdf ? 'fa-file-pdf' : ($isWord ? 'fa-file-word' : ($isExcel ? 'fa-file-excel' : 'fa-file')) }} text-lg"></i>
                            </div>
                            <div class="flex-1 min-w-0">
                                <p class="text-xs font-semibold truncate {{ $darkBubble ? 'text-white' : 'text-slate-700' }}">{{ $fileName }}</p>
                                <p class="text-[10px] {{ $darkBubble ? 'text-white/70' : 'text-slate-400' }}">Click to download</p>
                            </div>
                            <i class="fa-solid fa-download text-xs {{ $darkBubble ? 'text-white/70' : 'text-slate-400' }}"></i>
                        </a>
                    @endif
                @else
                    {{ $msg->message }}
                @endif
                <span class="block text-[9px] {{ $isMe ? 'text-amber-100' : ($showAsSchool ? 'text-indigo-200' : 'text-slate-400') }} mt-1 text-right">
                    {{ \Carbon\Carbon::parse($msg->created_at)->format('h:i A') }}
                </span>
            </div>
        </div>
    </div>
</div>
@endforeach