@foreach($comments as $comment) @php $organization = 'N/A'; $first_name = 'N/A'; $last_name = ''; $stakeholderCategory = ucwords(strtolower(str_replace("-", " ", $comment->stackholder_category ?? $comment->stakeholder_category ?? 'N/A'))); // Get stakeholder information based on category if(($comment->stackholder_category ?? $comment->stakeholder_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 ?? ''; $stakeholderCategory = 'External'; } } elseif(($comment->stackholder_category ?? $comment->stakeholder_category) == 'COLLABORATIVE_PARTNERS'){ $subActivityUsers = DB::table('long_term_project_stakeholder_user') ->where('stakeholder_category', 'COLLABORATIVE_PARTNERS') ->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', 'long_term_project_stakeholder_user.name as first_name', 'long_term_project_stakeholder_user.last_name as last_name') ->first(); if($subActivityUsers) { $organization = $subActivityUsers->organization_name ?? 'N/A'; $first_name = $subActivityUsers->first_name ?? 'N/A'; $last_name = $subActivityUsers->last_name ?? 'N/A'; $stakeholderCategory = 'Collaborative Partner'; } } elseif(($comment->stackholder_category ?? $comment->stakeholder_category) == 'SYSTEM'){ // Check if using the relationship // if($comment->LongTermProjectStakeholders && $comment->LongTermProjectStakeholders->SystemUser) { // $first_name = $comment->LongTermProjectStakeholders->SystemUser->name ?? 'N/A'; // $last_name = $comment->LongTermProjectStakeholders->SystemUser->last_name ?? ''; // $organization = 'SYSTEM'; // $stakeholderCategory = 'Internal'; // } else { // Fallback to direct DB query $subActivityUsers = DB::table('users') ->where('id', $comment->created_by) ->first(); if($subActivityUsers) { $organization = 'SYSTEM'; $first_name = $subActivityUsers->name ?? 'N/A'; $last_name = $subActivityUsers->last_name ?? ''; $stakeholderCategory = 'Internal'; // } } } @endphp @endforeach