@foreach($data as $index => $item) @php $categoryBlocks = []; foreach ($item['categories'] as $catName => $courses) { $categoryBlocks[] = [ 'name' => $catName, 'courses' => $courses, ]; } $totalRowsForInst = 0; foreach ($categoryBlocks as $cat) { $totalRowsForInst += 1; // 1 row for category title $totalRowsForInst += count($cat['courses']); // 1 row per course $totalRowsForInst += 1; // 1 row for category subtotal } $firstRow = true; $sno = $index + 1; @endphp @foreach($categoryBlocks as $cat) @php $catFees = array_sum(array_map(fn($c) => (float)str_replace(',', '', $c['fees']), $cat['courses'])); $catStudents = array_sum(array_column($cat['courses'], 'student')); @endphp {{-- Category Header Row --}} @if($firstRow) @endif @if($firstRow) @php $firstRow = false; @endphp @endif {{-- Course rows --}} @foreach($cat['courses'] as $cIdx => $c) @endforeach {{-- Category Subtotal Row --}} @endforeach @endforeach

S.No	Name of the institution	Contract Period	Name of the course	No of students enrolled
{{ $sno }}	{{ $item['name'] }} @if(!empty($item['industrial_type'])) ({{ $item['industrial_type'] }}) @endif @if(!empty($item['is_new_tieup'])) ✨ New Tieup · {{ $item['new_tieup_text'] }} @endif @if(!empty($item['is_renewal'])) 🔄 Renewal · {{ $item['renewal_text'] }} @endif	{{ $item['contract_period'] }}	{{ $cat['name'] }}	{{ $item['no_of_student_enrolled'] }}
{{ $cIdx + 1 }} {{ $c['course'] }} {{ $c['fees'] }} {{ $c['student'] }} {{ $c['pass'] }} {{ $c['abs'] }} {{ $c['ra'] }}
Total: {{ number_format($catFees, 2) }} {{ $catStudents }}
Total:			Total Fees: ₹ {{ number_format($total_amount_sum, 2) }}	{{ $total_students_sum }}