Payment Report

@foreach($students as $student) @php // Program-wise export: each row has program data directly $programDisplay = ($student['program_code'] ?? 'N/A') . ' - ' . ($student['program_name'] ?? 'Unknown'); // Determine status based on payment data $totalFees = $student['total_fees'] ?? 0; $outstanding = $student['outstanding'] ?? 0; if ($totalFees == 0) { $status = 'pending'; } elseif ($outstanding <= 0) { $status='paid' ; } elseif ($outstanding < $totalFees) { $status='partial' ; } else { $status='outstanding' ; } $statusClass=$status==='paid' ? 'status-paid' : ($status==='outstanding' ? 'status-outstanding' : 'status-partial' ); @endphp @endforeach

ID	Admission No	Name	Email	Program(s)	Total Fees	Paid	Discounts	Fines	Outstanding	Status
{{ $student['student_id'] ?? '' }}	{{ $student['admission_no'] ?? '' }}	{{ $student['full_name'] ?? '' }}	{{ $student['email'] ?? '' }}	{{ $programDisplay }}	{{ number_format($student['total_fees'] ?? 0, 2) }}	{{ number_format($student['total_paid'] ?? 0, 2) }}	{{ number_format($student['total_discount'] ?? 0, 2) }}	{{ number_format($student['total_fine'] ?? 0, 2) }}	{{ number_format($student['outstanding'] ?? 0, 2) }}	{{ ucfirst($status) }}