@extends('admin.layout.app')

@section('body')
<div class="card card-page p-3 shadow-sm">
    <h4>{{ __('admin.scholarship_assignment_report') }}</h4>
    <p>{{ __('admin.view_all_scholarships_assigned_to_students_filters_help') }}</p>

    <!-- Filter Form -->
    <form method="GET" class="row g-3 mb-4">
        <div class="col-md-3">
            <label class="form-label">{{ __('admin.student_2') }}</label>
            <select name="student_id" class="form-select">
                <option value="">{{ __('admin.all_students') }}</option>
                @foreach($students as $s)
                    <option value="{{ $s->id }}" {{ request('student_id') == $s->id ? 'selected' : '' }}>
                        {{ $s->name }} ({{ $s->email }})
                    </option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3">
            <label class="form-label">{{ __('admin.scholarship') }}</label>
            <select name="scholarship_id" class="form-select">
                <option value="">{{ __('admin.all_scholarships') }}</option>
                @foreach($scholarships as $sch)
                    <option value="{{ $sch->id }}" {{ request('scholarship_id') == $sch->id ? 'selected' : '' }}>
                        {{ $sch->name }}
                    </option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3">
            <label class="form-label">{{ __('admin.semester') }}</label>
            <select name="semester_id" class="form-select">
                <option value="">{{ __('admin.all_semesters') }}</option>
                @foreach($semesters as $sem)
                    <option value="{{ $sem->id }}" {{ request('semester_id') == $sem->id ? 'selected' : '' }}>
                        {{ $sem->name }}
                    </option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3 d-flex align-items-end">
            <button type="submit" class="btn btn-primary w-100 me-2">{{ __('admin.filter') }}</button>
            <a href="{{ route('fee.scholarships.assignments-report') }}" class="btn btn-secondary w-100">{{ __('admin.reset') }}</a>
        </div>
    </form>

    <div class="table-responsive">
        <table class="table table-bordered table-hover">
            <thead class="table-light">
                <tr>
                    <th>{{ __('admin.id') }}</th>
                    <th>{{ __('admin.student_2') }}</th>
                    <th>{{ __('admin.scholarship') }}</th>
                    <th>{{ __('admin.type_2') }}</th>
                    <th>{{ __('admin.amount') }}</th>
                    <th>{{ __('admin.semester') }}</th>
                    <th>{{ __('admin.approved_by') }}</th>
                    <th>{{ __('admin.approved_at') }}</th>
                    <th>{{ __('admin.remarks') }}</th>
                </tr>
            </thead>
            <tbody>
                @forelse($assignments as $a)
                <tr>
                    <td>{{ $a->id }}</td>
                    <td>{{ $a->student->name ?? 'N/A' }}<br><small class="text-muted">{{ $a->student->email ?? '' }}</small></td>
                    <td>{{ $a->scholarship->name ?? 'N/A' }}</td>
                    <td>{{ ucfirst($a->scholarship->type ?? '') }}</td>
                    <td>
                        @if($a->scholarship->type == 'percentage')
                            {{ $a->scholarship->amount }}%
                        @else
                            {{ number_format($a->scholarship->amount, 2) }} AFN
                        @endif
                    </td>
                    <td>{{ $a->semester->name ?? 'All Semesters' }}</td>
                    <td>{{ $a->approver->name ?? 'System' }}</td>
                    <td>{{ $a->approved_at ? $a->approved_at->format('Y-m-d H:i') : '—' }}</td>
                    <td>{{ $a->remarks ?? '—' }}</td>
                </tr>
                @empty
                    <tr><td colspan="9" class="text-center">{{ __('admin.no_scholarship_assignments_found') }}</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>

    <div class="mt-3">
        {{ $assignments->appends(request()->query())->links('pagination::bootstrap-4') }}
    </div>
</div>
@endsection