@extends('admin.layout.app')
@section('body')
<div class="card card-page p-3 shadow-sm">
    <h4>{{ __('admin.student_report') }}</h4>
    <form method="GET" class="row g-2 mb-3">
        <div class="col-md-4">
            <input type="text" name="search" class="form-control" placeholder="{{ __('admin.search_by_name_or_email') }}" value="{{ request('search') }}">
        </div>
        <div class="col-md-2">
            <button class="btn btn-primary">{{ __('admin.filter') }}</button>
            <a href="{{ route('reports.students.export.pdf', request()->query()) }}" class="btn btn-secondary">{{ __('admin.export_pdf') }}</a>
        </div>
    </form>
    <div class="table-responsive">
        <table class="table table-bordered">
            <thead>
                <tr><th>{{ __('admin.id') }}</th><th>{{ __('admin.name') }}</th><th>{{ __('admin.email') }}</th><th>{{ __('admin.phone') }}</th><th>{{ __('admin.total_fees') }}</th><th>{{ __('admin.outstanding') }}</th><th>{{ __('admin.cgpa') }}</th></tr>
            </thead>
            <tbody>
                @foreach($students as $s)
                <tr>
                    <td>{{ $s->id }}</td>
                    <td>{{ $s->name }}</td>
                    <td>{{ $s->email }}</td>
                    <td>{{ $s->phone }}</td>
                    <td>{{ number_format($s->studentFees->sum('net_amount'), 2) }}</td>
                    <td>{{ number_format($s->studentFees->sum('outstanding'), 2) }}</td>
                    <td>{{ number_format(\App\Services\GpaCalculator::calculateCgpa($s->id), 2) }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
    {{ $students->links('pagination::bootstrap-4') }}
</div>
@endsection