@extends('layouts.app')

@section('title', 'Spreadsheet')

@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">Spreadsheet</h1>
                <p class="text-xs text-muted-foreground">Full mark sheet with grades across all exams</p>
            </div>
            <a href="{{ route('academics.spreadsheet.csv', ['form' => $form, 'level' => $level, 'stream' => $stream]) }}"
               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.spreadsheet') }}" 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
                <button class="h-9 rounded-lg bg-primary px-3 text-sm font-medium text-primary-foreground hover:bg-primary/90">Generate</button>
            </form>
        </div>

        @php
    $classMean = count($means) ? round(array_sum(array_column($means, 'mean')) / count($means) * 10) / 10 : 0;
@endphp
        <div class="rounded-xl border border-border bg-card">
            <div class="flex flex-wrap items-center gap-4 border-b border-border px-3 py-2 text-xs text-muted-foreground">
                <span>Class mean: <strong class="text-foreground">{{ $classMean }}%</strong></span>
                <span>Students: <strong class="text-foreground">{{ count($results) }}</strong></span>
                <span class="ml-auto">{{ count($allExams) }} exams · all weighted</span>
            </div>
            <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">Student</th>
                            @foreach ($subjects as $sub)
                                <th class="px-3 py-2 text-center font-medium" colspan="2" title="{{ $sub }}">{{ \Illuminate\Support\Str::of($sub)->limit(6, '…') }}</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>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse ($results as $r)
                            <tr class="border-b last:border-0">
                                <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-2 py-2 text-right tabular-nums text-muted-foreground">{{ $r['subjectMarks'][$sub] }}</td>
                                    <td class="px-2 py-2 text-center text-xs font-medium text-primary">{{ $r['subjectGrades'][$sub]['grade'] }}</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>
                            </tr>
                        @empty
                            <tr><td colspan="20" class="px-3 py-10 text-center text-sm text-muted-foreground">No data.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection