@extends('layouts.acorn.acorn_admin_app') @section('header_styles') @endsection @section('content') @php use Illuminate\Support\Facades\DB; @endphp
@php $completed_sub_activities_weight_project_wise = $longTermProjectDetailsById->LongTermProjectSubActivities ->where('state', 'COMPLETED') ->sum('sub_activity_weight'); $total_sub_activities_weight_project_wise = $longTermProjectDetailsById->LongTermProjectSubActivities ->where('state', '!=', 'DELETED') ->sum('sub_activity_weight'); $weight_percentage_project_wise = $total_sub_activities_weight_project_wise > 0 ? ($completed_sub_activities_weight_project_wise / $total_sub_activities_weight_project_wise) * 100 : 0; $circumference = 311.018; $strokeDashoffset = $circumference - (($weight_percentage_project_wise / 100) * $circumference); if ($weight_percentage_project_wise >= 75) { $color = '#28a745'; } elseif ($weight_percentage_project_wise >= 50) { $color = '#ffc107'; } elseif ($weight_percentage_project_wise >= 25) { $color = '#fd7e14'; } else { $color = '#dc3545'; } @endphp
{{ number_format($weight_percentage_project_wise, 2) }}%

{{ $title }}

@if($longTermProjectDetailsById->state == 'PENDING') Pending @elseif($longTermProjectDetailsById->state == 'IN_PROGRESS') Inprogress @elseif($longTermProjectDetailsById->state == 'COMPLETED') Completed @endif

{{ $longTermProjectDetailsById->description ?? '' }}

@if($longTermProjectDetailsById->state == 'PENDING')
@endif

Stats

Activities
{{ count($longTermProjectDetailsById->LongTermProjectActivities?->where('state', 'COMPLETED') ?? []) }} / {{ count($longTermProjectDetailsById->LongTermProjectActivities?->where('state', '!=', 'DELETED') ?? []) }}
Sub Activities
{{ count($longTermProjectDetailsById->LongTermProjectSubActivities?->where('state', 'COMPLETED') ?? []) }} / {{ count($longTermProjectDetailsById->LongTermProjectSubActivities?->where('state', '!=', 'DELETED') ?? []) }}
Cost
@php $completedCost = $longTermProjectDetailsById->LongTermProjectSubActivities ->where('state', 'COMPLETED') ->sum('cost') ?? 0; @endphp {{ number_format($completedCost ?? 0, 2) }}
Budget
{{ number_format($longTermProjectDetailsById->budget ?? 0, 2) }}
@if($longTermProjectDetailsById->state != 'PENDING')

Activities

@if(!empty($longTermProjectDetailsById->LongTermProjectActivities)) @foreach($longTermProjectDetailsById->LongTermProjectActivities as $LongTermProjectActivity)
@php $completed_sub_activities_weight = $longTermProjectDetailsById->LongTermProjectSubActivities ->where('long_term_project_activity_id', $LongTermProjectActivity->id) ->where('state', 'COMPLETED') ->sum('sub_activity_weight'); $total_sub_activities_weight = $longTermProjectDetailsById->LongTermProjectSubActivities ->where('long_term_project_activity_id', $LongTermProjectActivity->id) ->where('state', '!=', 'DELETED') ->sum('sub_activity_weight'); // Calculate percentage $percentage = $total_sub_activities_weight > 0 ? ($completed_sub_activities_weight / $total_sub_activities_weight) * 100 : 0; $circumference = 155.508; // 2 * π * r where r = 49.5 (but semi-circle uses half) // Actually for semi-circle: arc length = π * r = 3.14159 * 49.5 ≈ 155.508 $strokeDashoffset = $circumference - (($percentage / 100) * $circumference); @endphp
{{ $completed_sub_activities_weight }}/{{ $total_sub_activities_weight }}

{{ $LongTermProjectActivity->activity_name }}

Duration: {{ \Carbon\Carbon::parse($LongTermProjectActivity->start_date)->format('Y M d') }} - {{ \Carbon\Carbon::parse($LongTermProjectActivity->end_date)->format('Y M d') }} | Weight: {{ $LongTermProjectActivity->activity_weight }}

{{ $LongTermProjectActivity->activity_description }}

Sub Activities
@if(!empty($LongTermProjectActivity->LongTermProjectSubActivities)) @foreach($LongTermProjectActivity->LongTermProjectSubActivities as $subActivity)

{{ $subActivity->sub_activity_weight ?? $subActivity->weight }}

{{ $subActivity->state ?? ucwords(strtolower(str_replace('_', ' ', $subActivity->state))) }}

{{ $subActivity->sub_activity_name ?? $subActivity->name }}
Duration: {{ \Carbon\Carbon::parse($subActivity->start_date)->format('Y M d') }} - {{ \Carbon\Carbon::parse($subActivity->end_date)->format('Y M d') }}

{{ $subActivity->sub_activity_description ?? $subActivity->description }}

@if($subActivity->state == 'PENDING') @endif @if($subActivity->state == 'IN_PROGRESS' || $subActivity->state == 'COMPLETED') @endif
@php $subActivityComments = $longTermProjectDetailsById->LongTermProjectComments ->where('long_term_project_sub_activity_id', $subActivity->id) ->sortByDesc('created_at'); @endphp
Comments for: {{ $subActivity->sub_activity_name ?? $subActivity->name }}
@if($subActivityComments->count() > 0)
@foreach($subActivityComments as $comment)
@php $organization = 'N/A'; $first_name = 'N/A'; $last_name = 'N/A'; if($comment->stackholder_category == 'EXTERNAL'){ $subActivityUsers = DB::table('long_term_project_stakeholder_user') ->where('stakeholder_category', 'EXTERNAL') ->where('stakeholder_id', $comment->stakeholder_id) ->first(); $organization = $subActivityUsers->organization; $first_name = $subActivityUsers->name; $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('stakeholder_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(); $organization = $subActivityUsers->organization_name; $first_name = $subActivityUsers->first_name; $last_name = $subActivityUsers->last_name; } elseif($comment->stackholder_category == 'SYSTEM'){ $subActivityUsers = DB::table('users') ->where('id', $comment->stakeholder_id) ->first(); $organization = 'SYSTEM'; $first_name = $subActivityUsers->name; $last_name = $subActivityUsers->last_name; } @endphp {{ $first_name ?? '' }} {{ $last_name ?? '' }} ({{ $organization }}) {{ \Carbon\Carbon::parse($comment->created_at)->format('M d, Y h:i A') }}

{{ $comment->comments }}

@endforeach
@else
No comments found for this sub-activity.
@endif
Attachement for: {{ $subActivity->sub_activity_name ?? $subActivity->name }}
@php $subactivityAttachements = $longTermProjectDetailsById->LongTermProjectAttachements ->where('long_term_project_sub_activity_id', $subActivity->id) ->sortByDesc('created_at'); @endphp @if($subactivityAttachements->count() > 0)
@foreach($subactivityAttachements as $attachement)
{{ $attachement->file_name }}
@endforeach
@else
No attachements found for this sub-activity.
@endif @if($longTermProjectDetailsById->LongTermProjectStakeholders->isNotEmpty() && $longTermProjectDetailsById->LongTermProjectStakeholders->first()->user_id == $auth_user_id) @if(in_array($subActivity->state, ['IN_PROGRESS', 'COMPLETED']))
Add Update
@csrf
@php $actualCost = DB::table('long_term_project_sub_activities') ->where('id', $subActivity->id) ->value('cost'); @endphp
You can select multiple files. Allowed: PDF, DOC, DOCX, JPG, PNG
@endif @endif
@endforeach @else
No sub-activities found for this activity.
@endif
@endforeach @else

{{ $longTermProjectDetailsById->title }} : Activities not found

@endif
@endif
@endsection