@include('header-facil')

A3 Recapitulation

Filter CG:
@foreach($months as $monthNum => $monthName) @endforeach @php $a3Rows = []; foreach ($users_a3 as $user) { $user_a3s = $a3s->where('user_i2c_id', $user->id); $total = 0; $monthlyCount = []; foreach ($months as $mNum => $mName) { $count = $user_a3s->filter(function ($item) use ($mNum) { if (!$item->created_at) return false; return $item->created_at->format('Y-m') === (string) $mNum; })->count(); $monthlyCount[$mNum] = $count; $total += $count; } $target = $user->target_mar ?: 0; $percentage = $target > 0 ? round(($total / $target) * 100) : 0; $a3Rows[] = [ 'user' => $user, 'monthlyCount' => $monthlyCount, 'total' => $total, 'target' => $target, 'percentage' => $percentage ]; } // Sort descending by percentage usort($a3Rows, function ($a, $b) { return $b['percentage'] <=> $a['percentage']; }); $maxA3Percentage = count($a3Rows) > 0 ? $a3Rows[0]['percentage'] : -1; $minA3Percentage = count($a3Rows) > 0 ? $a3Rows[count($a3Rows) - 1]['percentage'] : -1; @endphp @foreach($a3Rows as $row) @php $user = $row['user']; $monthlyCount = $row['monthlyCount']; $total = $row['total']; $target = $row['target']; $percentage = $row['percentage']; @endphp @foreach($months as $mNum => $mName) @endforeach @endforeach
No Name CG {{ $monthName }} Total Target % Achiev.

{{ $loop->iteration }}

{{ $user->name }}

{{ $user->nik }}

@if($maxA3Percentage > 0 && $percentage === $maxA3Percentage)
👑 Top
@elseif($minA3Percentage !== -1 && $percentage === $minA3Percentage && $percentage !== $maxA3Percentage)
👎 Worst
@endif
@php $cgName = $user->cg; $cgLower = strtolower(trim($cgName ?? '')); if (str_contains($cgLower, 'sirius')) { $badgeStyle = 'background-color: #FEF3C7; color: #A16207; border: 1px solid #F59E0B;'; } elseif (str_contains($cgLower, 'dnawesome') || str_contains($cgLower, 'dna')) { $badgeStyle = 'background-color: #DCFCE7; color: #15803D; border: 1px solid #22C55E;'; } elseif (str_contains($cgLower, 'adminovation')) { $badgeStyle = 'background-color: #FEE2E2; color: #B91C1C; border: 1px solid #EF4444;'; } elseif (str_contains($cgLower, 'falcon')) { $badgeStyle = 'background-color: #DBEAFE; color: #1D4ED8; border: 1px solid #3B82F6;'; } else { $badgeStyle = 'background-color: #F3F4F6; color: #374151; border: 1px solid #9CA3AF;'; } @endphp @if($cgName) {{ $cgName }} @endif

{{ $monthlyCount[$mNum] }}

{{ $total }}

{{ $target }}

{{ $percentage }}%