@extends('admin.layout.app')

@section('body')
<div class="card card-page p-3 shadow-sm">
    <h4 class="mb-3">{{ __('admin.fee_reports') }}</h4>
    <p class="text-muted">{{ __('admin.overview_of_fee_collection_outstanding_balances_and_stu') }}</p>

    <!-- Summary Cards -->
    <div class="row g-3 mb-4">
        <div class="col-md-4">
            <div class="card bg-primary text-white">
                <div class="card-body">
                    <h5 class="card-title">{{ __('admin.total_collected') }}</h5>
                    <p class="card-text fs-2">{{ number_format($totalCollected, 2) }} AFN</p>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card bg-warning text-dark">
                <div class="card-body">
                    <h5 class="card-title">{{ __('admin.outstanding_total') }}</h5>
                    <p class="card-text fs-2">{{ number_format($outstandingTotal, 2) }} AFN</p>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card bg-danger text-white">
                <div class="card-body">
                    <h5 class="card-title">{{ __('admin.students_with_outstanding') }}</h5>
                    <p class="card-text fs-2">{{ $studentsWithOutstanding }}</p>
                </div>
            </div>
        </div>
    </div>

    <!-- Detailed Table of Student Fees -->
    <div class="table-responsive">
        <table class="table table-bordered table-hover">
            <thead class="table-light">
                <tr>
                    <th>{{ __('admin.student_2') }}</th>
                    <th>{{ __('admin.semester') }}</th>
                    <th>{{ __('admin.net_fee_afn') }}</th>
                    <th>{{ __('admin.paid_afn') }}</th>
                    <th>{{ __('admin.outstanding_afn') }}</th>
                    <th>{{ __('admin.status') }}</th>
                    <th>{{ __('admin.due_date') }}</th>
                    <th>{{ __('admin.actions') }}</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $studentFees = \App\Models\FeeM\StudentFee::with(['student', 'semester'])->orderBy('id', 'desc')->paginate(20);
                @endphp
                @forelse($studentFees as $sf)
                <tr>
                    <td>{{ $sf->student->name ?? 'N/A' }}<br><small class="text-muted">{{ $sf->student->email ?? '' }}</small></td>
                    <td>{{ $sf->semester->name ?? 'N/A' }}</td>
                    <td>{{ number_format($sf->net_amount, 2) }}</td>
                    <td>{{ number_format($sf->paid_amount, 2) }}</td>
                    <td>{{ number_format($sf->outstanding, 2) }}</td>
                    <td>
                        <span class="badge bg-{{ $sf->status == 'paid' ? 'success' : ($sf->status == 'partial' ? 'warning' : 'danger') }}">
                            {{ ucfirst($sf->status) }}
                        </span>
                    </td>
                    <td>{{ $sf->due_date ? $sf->due_date->format('Y-m-d') : '—' }}</td>
                    <td>
                        <a href="{{ route('fee.payments', $sf->id) }}" class="btn btn-sm btn-primary">{{ __('admin.view_payments') }}</a>
                    </td>
                </tr>
                @empty
                    <tr><td colspan="8" class="text-center">{{ __('admin.no_fee_records_found') }}</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
    <div class="mt-3">
        {{ $studentFees->links('pagination::bootstrap-4') }}
    </div>
</div>
@endsection