@extends('layouts.app')

@section('title', 'Exam Analysis')

@section('content')
    <div class="flex flex-col gap-6">
        <div class="flex items-end justify-between gap-3">
            <div>
                <h1 class="text-lg font-semibold">Exam Analysis</h1>
                <p class="text-xs text-muted-foreground">Weighted aggregation, grades and class ranking</p>
            </div>
            <a href="{{ route('academics.exam-analysis.csv', ['form' => $form, 'level' => $level, 'stream' => $stream, 'exams' => $selectedExams]) }}"
               class="rounded-lg border border-border bg-card px-3 py-2 text-sm font-medium hover:bg-accent">Export CSV</a>
        </div>

        @include('partials.flashes')

        <div class="flex flex-wrap items-end gap-3 rounded-xl border border-border bg-card p-3">
            <form method="get" action="{{ route('academics.exam-analysis') }}" class="flex flex-wrap items-end gap-3">
                <div class="flex flex-col gap-1.5">
                    <label class="text-xs text-muted-foreground">Form</label>
                    <select name="form" class="h-9 rounded-lg border border-input bg-transparent px-3 text-sm outline-none focus-visible:border-ring">
                        @foreach (\App\Support\Academics::FORMS as $f)
                            <option value="{{ $f }}" @selected($form === $f)>{{ $f }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="flex flex-col gap-1.5">
                    <label class="text-xs text-muted-foreground">Level</label>
                    <select name="level" class="h-9 rounded-lg border border-input bg-transparent px-3 text-sm outline-none focus-visible:border-ring">
                        @foreach (['all' => 'Whole class', 'stream' => 'Single stream'] as $val => $label)
                            <option value="{{ $val }}" @selected($level === $val)>{{ $label }}</option>
                        @endforeach
                    </select>
                </div>
                @if ($level === 'stream')
                    <div class="flex flex-col gap-1.5">
                        <label class="text-xs text-muted-foreground">Stream</label>
                        <select name="stream" class="h-9 rounded-lg border border-input bg-transparent px-3 text-sm outline-none focus-visible:border-ring">
                            @foreach (\App\Support\Academics::STREAMS as $st)
                                <option value="{{ $st }}" @selected($stream === $st)>{{ $st }}</option>
                            @endforeach
                        </select>
                    </div>
                @endif
                <div class="flex flex-col gap-1.5">
                    <label class="text-xs text-muted-foreground">Exams</label>
                    <select name="exams[]" multiple size="4" class="h-24 min-w-40 rounded-lg border border-input bg-transparent px-3 text-sm outline-none focus-visible:border-ring">
                        @foreach ($allExams as $ex)
                            <option value="{{ $ex->name }}" @selected(in_array($ex->name, $selectedExams, true))>{{ $ex->name }}</option>
                        @endforeach
                    </select>
                </div>
                <button class="h-9 rounded-lg bg-primary px-3 text-sm font-medium text-primary-foreground hover:bg-primary/90">Analyse</button>
                <input name="q" value="{{ $q }}" placeholder="Search student…" class="h-9 min-w-48 rounded-lg border border-input bg-transparent px-3 text-sm outline-none focus-visible:border-ring">
            </form>
        </div>

        <div class="grid grid-cols-1 gap-3 sm:grid-cols-2 lg:grid-cols-4">
            <div class="rounded-xl border border-border bg-card p-4">
                <span class="text-xs text-muted-foreground">Students</span>
                <span class="mt-1 block text-2xl font-semibold tabular-nums">{{ $studentsCount }}</span>
            </div>
            <div class="rounded-xl border border-border bg-card p-4">
                <span class="text-xs text-muted-foreground">Class Mean</span>
                <span class="mt-1 block text-2xl font-semibold tabular-nums">{{ $summary['classMean'] }}%</span>
            </div>
            <div class="rounded-xl border border-border bg-card p-4">
                <span class="text-xs text-muted-foreground">Top Grade</span>
                <span class="mt-1 block text-2xl font-semibold text-emerald-600">{{ $summary['topGrade'] }}</span>
            </div>
            <div class="rounded-xl border border-border bg-card p-4">
                <span class="text-xs text-muted-foreground">Exams included</span>
                <span class="mt-1 block text-2xl font-semibold tabular-nums">{{ count($selectedExams) }}</span>
            </div>
        </div>

        <div class="grid gap-6 lg:grid-cols-3">
            <div class="rounded-xl border border-border bg-card lg:col-span-2">
                <div class="overflow-x-auto">
                    <table class="w-full text-sm">
                        <thead>
                            <tr class="border-b text-left text-xs uppercase text-muted-foreground">
                                <th class="px-3 py-2 font-medium">#</th>
                                <th class="px-3 py-2 font-medium">Student</th>
                                @foreach ($subjects as $sub)
                                    <th class="px-3 py-2 text-right font-medium" title="{{ $sub }}">{{ \Illuminate\Support\Str::of($sub)->limit(5, '…') }}</th>
                                @endforeach
                                <th class="px-3 py-2 text-right font-medium">Total</th>
                                <th class="px-3 py-2 text-right font-medium">Avg</th>
                                <th class="px-3 py-2 text-center font-medium">Grade</th>
                                <th class="px-3 py-2 text-right font-medium">Pos</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse ($results as $i => $r)
                                <tr class="border-b last:border-0">
                                    <td class="px-3 py-2 text-muted-foreground">{{ $i + 1 }}</td>
                                    <td class="px-3 py-2">
                                        <span class="block font-medium">{{ $r['student']->full_name }}</span>
                                        <span class="font-mono text-[11px] text-muted-foreground">{{ $r['student']->admission_no }}</span>
                                    </td>
                                    @foreach ($subjects as $sub)
                                        <td class="px-3 py-2 text-right tabular-nums">{{ $r['subjectMarks'][$sub] }}</td>
                                    @endforeach
                                    <td class="px-3 py-2 text-right font-semibold tabular-nums">{{ $r['total'] }}</td>
                                    <td class="px-3 py-2 text-right tabular-nums">{{ $r['avg'] }}</td>
                                    <td class="px-3 py-2 text-center">
                                        <span class="rounded-full bg-primary/10 px-2 py-0.5 text-[10px] font-semibold text-primary">{{ $r['overallGrade']['grade'] }}</span>
                                    </td>
                                    <td class="px-3 py-2 text-right tabular-nums">{{ $r['overallPos'] }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="10" class="px-3 py-10 text-center text-sm text-muted-foreground">No students matched.</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>

            <div class="flex flex-col gap-6">
                <div class="rounded-xl border border-border bg-card p-4">
                    <h2 class="text-sm font-semibold">Subject Means</h2>
                    <div class="mt-3 flex flex-col gap-2.5">
                        @foreach ($summary['meanBySubject'] as $sub => $mean)
                            <div class="flex items-center gap-2">
                                <span class="w-32 truncate text-xs text-muted-foreground">{{ $sub }}</span>
                                <div class="h-2 flex-1 overflow-hidden rounded-full bg-accent">
                                    <div class="h-full rounded-full bg-primary" style="width: {{ $mean }}%"></div>
                                </div>
                                <span class="w-10 text-right text-xs tabular-nums">{{ $mean }}</span>
                            </div>
                        @endforeach
                    </div>
                </div>

                <div class="rounded-xl border border-border bg-card p-4">
                    <h2 class="text-sm font-semibold">Grade Distribution</h2>
                    <div class="mt-3 flex flex-col gap-1.5">
                        @foreach ($summary['gradeDistribution'] as $g)
                            <div class="flex items-center justify-between text-sm">
                                <span class="flex items-center gap-2">
                                    <span class="rounded bg-primary/10 px-1.5 py-0.5 text-xs font-semibold text-primary">{{ $g['grade'] }}</span>
                                    <span class="text-xs text-muted-foreground">{{ $g['count'] }} students</span>
                                </span>
                                <span class="tabular-nums">{{ $g['count'] }}</span>
                            </div>
                        @endforeach
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection