@extends('layouts.app')
@section('title', 'Academic Reports')
@section('content')
<div class="card">
    <h2 style="font-size:17px;color:#0b4f2c;margin-bottom:16px;">Academic Performance Report</h2>
    <form method="GET" style="margin-bottom:16px;">
        <select name="term_id" onchange="this.form.submit()" style="padding:8px;border:1px solid #ddd;border-radius:6px;font-size:13px;">
            <option value="">Select Term</option>
            @foreach($terms as $term)
                <option value="{{ $term->id }}" {{ $selectedTermId == $term->id ? 'selected' : '' }}>{{ $term->name }} — {{ $term->academicSession->name }}</option>
            @endforeach
        </select>
    </form>
    <table style="width:100%;border-collapse:collapse;font-size:13px;">
        <thead><tr style="background:#f4f6f5;text-align:left;"><th style="padding:8px;">Subject</th><th style="padding:8px;">Average</th><th style="padding:8px;">Highest</th><th style="padding:8px;">Lowest</th><th style="padding:8px;">Entries</th></tr></thead>
        <tbody>
            @forelse($bySubject as $row)
                <tr style="border-bottom:1px solid #eee;">
                    <td style="padding:8px;font-weight:bold;">{{ $row->subject->name }}</td>
                    <td style="padding:8px;">{{ round($row->average, 1) }}</td>
                    <td style="padding:8px;">{{ $row->highest }}</td>
                    <td style="padding:8px;">{{ $row->lowest }}</td>
                    <td style="padding:8px;">{{ $row->entries }}</td>
                </tr>
            @empty
                <tr><td colspan="5" style="padding:20px;text-align:center;color:#999;">Select a term to view performance data.</td></tr>
            @endforelse
        </tbody>
    </table>
</div>
@endsection