@php $statusCounts = collect($finalCount) ->flatMap(function ($item) { return $item['children'] ?? []; }) ->groupBy('appln_status_name') ->map(function ($items) { return $items->sum('appln_status_count'); }); $totalApplications = collect($finalCount)->sum('parent_appln_count'); @endphp @php $statusCards = [ [ 'title' => 'Total Applications', 'status' => null, 'icon' => 'fa-solid fa-file-lines', 'bg' => 'stats-primary', 'footer_icon' => 'fa-solid fa-layer-group', 'footer' => 'All Applications', 'count' => $totalApplications, ], [ 'title' => 'Pending for Scrutiny', 'status' => 'Pending For Scrutiny', 'icon' => 'fa-solid fa-clock', 'bg' => 'stats-warning', 'footer_icon' => 'fa-solid fa-hourglass-half', 'footer' => 'Awaiting Scrutiny', ], [ 'title' => 'Reverted for Correction', 'status' => 'Reverted For Correction', 'icon' => 'fa-solid fa-rotate-left', 'bg' => 'stats-danger', 'footer_icon' => 'fa-solid fa-rotate-left', 'footer' => 'Correction Required', ], [ 'title' => 'Scrutiny Completed', 'status' => 'Scrutiny Completed', 'icon' => 'fa-solid fa-circle-check', 'bg' => 'stats-success', 'footer_icon' => 'fa-solid fa-check', 'footer' => 'Scrutiny Completed', ], [ 'title' => 'Pending for LOI Issuance', 'status' => 'Pending For LOI Issuance', 'icon' => 'fa-solid fa-clock', 'bg' => 'stats-warning', 'footer_icon' => 'fa-solid fa-hourglass-half', 'footer' => 'Awaiting LOI', ], [ 'title' => 'LOI Issued', 'status' => 'LOI Issued', 'icon' => 'fa-solid fa-file-circle-check', 'bg' => 'stats-success', 'footer_icon' => 'fa-solid fa-check', 'footer' => 'LOI Successfully Issued', ], [ 'title' => 'Pending for LOI Compliance/Scrutiny', 'status' => 'Pending For LOI Compliance/Scrutiny', 'icon' => 'fa-solid fa-clock', 'bg' => 'stats-warning', 'footer_icon' => 'fa-solid fa-hourglass-half', 'footer' => 'Awaiting Compliance', ], [ 'title' => 'LOI Reverted for Correction', 'status' => 'LOI Reverted For Correction', 'icon' => 'fa-solid fa-rotate-left', 'bg' => 'stats-danger', 'footer_icon' => 'fa-solid fa-rotate-left', 'footer' => 'Correction Required', ], [ 'title' => 'LOI Compliance/Scrutiny Completed', 'status' => 'LOI Compliance/Scrutiny Completed', 'icon' => 'fa-solid fa-circle-check', 'bg' => 'stats-success', 'footer_icon' => 'fa-solid fa-check', 'footer' => 'Compliance Completed', ], [ 'title' => 'Pending for Authorisation Issuance', 'status' => 'Pending For Authorisation Issuance', 'icon' => 'fa-solid fa-clock', 'bg' => 'stats-warning', 'footer_icon' => 'fa-solid fa-hourglass-half', 'footer' => 'Awaiting Authorisation', ], [ 'title' => 'Authorisation Issued', 'status' => 'Authorisation Issued', 'icon' => 'fa-solid fa-circle-check', 'bg' => 'stats-success', 'footer_icon' => 'fa-solid fa-certificate', 'footer' => 'Successfully Approved', ], [ 'title' => 'Rejected Applications', 'status' => 'Rejected Applications', 'icon' => 'fa-solid fa-circle-xmark', 'bg' => 'stats-danger', 'footer_icon' => 'fa-solid fa-ban', 'footer' => 'Rejected Applications', ], ]; @endphp
@foreach($statusCards as $card) @php $count = $card['status'] === null ? $card['count'] : ($statusCounts[$card['status']] ?? 0); @endphp
{{ $card['title'] }}

{{ $count }}

{{-- {{ $card['footer'] }} --}}
@endforeach
@if (auth()->user()->user_nature === 'D') @endif
Application Details by Category of Authorisation
@foreach ($statuses as $status) @endforeach @foreach ($finalCount as $service) @php $serviceStatuses = collect($service['children']) ->keyBy('appln_status_name'); @endphp @foreach ($statuses as $status) @endforeach @endforeach @foreach ($statuses as $status) @php $statusTotal = collect($finalCount)->sum(function ($service) use ($status) { return collect($service['children']) ->where('appln_status_name', $status) ->sum('appln_status_count'); }); @endphp @endforeach
CATEGORY OF
AUTHORISATION
TOTAL
APPLICATIONS
{{ strtoupper($status) }}
{{ $service['display_name'] }} {{ $service['parent_appln_count'] ?? 0 }} {{ $serviceStatuses[$status]['appln_status_count'] ?? 0 }}
Total {{ collect($finalCount)->sum('parent_appln_count') }} {{ $statusTotal }}