@extends('admin.layout.app')
@section('body')
<div class="card card-page p-3 shadow-sm">
    <h4>{{ __('admin.transcript_report') }}</h4>
    <form method="GET" class="row g-2 mb-3">
        <div class="col-md-3">
            <select name="student_id" class="form-select">
                <option value="">{{ __('admin.select_student') }}</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-2">
            <button class="btn btn-primary">{{ __('admin.filter') }}</button>
            @if(request('student_id'))
                <a href="{{ route('reports.transcripts.export.pdf', request()->query()) }}" class="btn btn-secondary">{{ __('admin.export_pdf') }}</a>
            @endif
        </div>
    </form>
    @if($selectedStudent)
        <div class="mt-3">
            <h5>{{ $selectedStudent->name }} – Cumulative CGPA: {{ number_format($cgpa, 2) }}</h5>
            <div class="table-responsive">
                <table class="table table-bordered">
                    <thead><tr><th>{{ __('admin.semester') }}</th><th>{{ __('admin.gpa') }}</th><th>{{ __('admin.status') }}</th><th>{{ __('admin.result_date') }}</th></tr></thead>
                    <tbody>
                        @foreach($semesterResults as $res)
                        <tr>
                            <td>{{ $res->semester->name }}</td>
                            <td>{{ $res->gpa }}</td>
                            <td>{{ ucfirst($res->status) }}</td>
                            <td>{{ $res->result_date }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    @endif
</div>
@endsection