@forelse($comments as $comment) @php $organization = 'N/A'; $first_name = 'N/A'; $last_name = ''; $stakeholderCategory = ucwords(str_replace("-", " ", $comment->stackholder_category)); if($comment->stackholder_category == 'EXTERNAL'){ $subActivityUsers = DB::table('long_term_project_stakeholder_user') ->where('stakeholder_category', 'EXTERNAL') ->where('id', $comment->stakeholder_id) ->first(); if($subActivityUsers) { $organization = $subActivityUsers->organization ?? 'N/A'; $first_name = $subActivityUsers->name ?? 'N/A'; $last_name = $subActivityUsers->last_name ?? ''; } } elseif($comment->stackholder_category == 'COLLABORATIVE_PARTNER'){ $subActivityUsers = DB::table('long_term_project_stakeholder_user') ->where('stakeholder_category', 'COLLABORATIVE_PARTNER') ->where('id', $comment->stakeholder_id) ->join('collaborative_partners', 'long_term_project_stakeholder_user.collaborative_partner_id', '=', 'collaborative_partners.id') ->select('collaborative_partners.name as organization_name', 'collaborative_partners.name as first_name') ->first(); if($subActivityUsers) { $organization = $subActivityUsers->organization_name ?? 'N/A'; $first_name = $subActivityUsers->first_name ?? 'N/A'; $last_name = ''; // Collaborative partners might not have last_name } } elseif($comment->stackholder_category == 'SYSTEM'){ $subActivityUsers = DB::table('users') ->where('id', $comment->stakeholder_id) ->first(); if($subActivityUsers) { $organization = 'SYSTEM'; $first_name = $subActivityUsers->name ?? 'N/A'; $last_name = $subActivityUsers->last_name ?? ''; } } @endphp

{{ $first_name ?? '' }} {{ $last_name ?? '' }} ({{ $organization }} | {{ ucwords(strtolower(str_replace("-", " ", $stakeholderCategory))) }}) {{ $comment->created_at->format('Y-m-d H:i') }}

@if($comment->documents && $comment->documents->count() > 0)

Attachments

@foreach($comment->documents as $doc)

@endforeach

@endif

@empty

No comments yet

@endforelse