@extends('layouts.app')
@section('title', 'Result Sheet')
@section('breadcrumb', 'Grades › Result Sheet')

@section('content')
<div class="d-flex justify-content-between align-items-center mb-4 no-print">
    <div>
        <h4 class="fw-bold mb-0" style="color:#0f3d23;">
            <i class="bi bi-file-earmark-spreadsheet me-2" style="color:#c9a94d;"></i>Result Sheet
        </h4>
        <p class="text-muted mb-0" style="font-size:.85rem;">
            {{ $classArm->full_name }} &bull; {{ $term->name }} &bull; {{ $school->name }}
        </p>
    </div>
    <button onclick="window.print()" class="btn btn-outline-secondary no-print" style="border-radius:8px;">
        <i class="bi bi-printer me-1"></i>Print
    </button>
</div>

{{-- Print Header (only shown in print) --}}
<div class="print-only mb-3 text-center" style="display:none;">
    <h5 class="fw-bold">{{ $school->name }}</h5>
    <p class="mb-0">{{ $classArm->full_name }} — {{ $term->name }}</p>
</div>

@php
    $subjects = $classArm->classSubjects->pluck('subject')->unique('id');
@endphp

<div class="card table-card">
    <div class="table-responsive">
        <table class="table table-bordered table-sm mb-0 align-middle" style="font-size:.78rem;">
            <thead>
                <tr style="background:#0f3d23; color:#fff;">
                    <th style="width:30px;">#</th>
                    <th style="min-width:150px;">Student Name</th>
                    <th>MCSS ID</th>
                    @foreach($subjects as $subject)
                    <th class="text-center">{{ $subject->code }}</th>
                    @endforeach
                    <th class="text-center">Avg</th>
                    <th class="text-center">GPA</th>
                    <th class="text-center">Pos</th>
                </tr>
                {{-- Subject full names as subheader --}}
                <tr style="background:#1a6b3c; color:rgba(255,255,255,.7); font-size:.7rem;">
                    <th colspan="3"></th>
                    @foreach($subjects as $subject)
                    <th class="text-center" style="font-weight:normal;">{{ Str::limit($subject->name, 12) }}</th>
                    @endforeach
                    <th colspan="3"></th>
                </tr>
            </thead>
            <tbody>
                @forelse($enrollments as $i => $enrollment)
                @php
                    $resultsBySubject = $enrollment->termResults->keyBy('subject_id');
                    $validGrades = $enrollment->termResults->whereNotNull('grade_point')->where('is_absent', false);
                    $avgGpa = $validGrades->count() > 0 ? round($validGrades->avg('grade_point'), 2) : null;
                    $avgTotal = $validGrades->count() > 0 ? round($validGrades->avg('total_score'), 1) : null;
                @endphp
                <tr class="{{ $i % 2 === 0 ? '' : 'table-light' }}">
                    <td class="text-muted text-center">{{ $i + 1 }}</td>
                    <td class="fw-semibold">{{ $enrollment->student->full_name }}</td>
                    <td style="font-size:.7rem;">{{ $enrollment->student->mcss_student_id }}</td>
                    @foreach($subjects as $subject)
                    @php $r = $resultsBySubject[$subject->id] ?? null; @endphp
                    <td class="text-center">
                        @if(!$r)
                            <span class="text-muted">—</span>
                        @elseif($r->is_absent)
                            <span class="badge bg-danger" style="font-size:.65rem;">ABS</span>
                        @else
                            <span class="fw-bold" style="color:{{ $r->grade_letter === 'F' ? '#c62828' : '#1a6b3c' }}">
                                {{ $r->grade_letter }}
                            </span>
                            <br><small class="text-muted">{{ $r->total_score }}</small>
                        @endif
                    </td>
                    @endforeach
                    <td class="text-center fw-bold">{{ $avgTotal ?? '—' }}</td>
                    <td class="text-center fw-bold" style="color:#1a6b3c;">{{ $avgGpa ?? '—' }}</td>
                    <td class="text-center">
                        @if($enrollment->position_in_class)
                        <span class="badge bg-warning text-dark">{{ $enrollment->position_in_class }}</span>
                        @else
                        <span class="text-muted">—</span>
                        @endif
                    </td>
                </tr>
                @empty
                <tr><td colspan="20" class="text-center py-4 text-muted">No students enrolled in this class.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
    <div class="card-footer bg-white py-2" style="font-size:.78rem; color:#888;">
        Total Students: {{ $enrollments->count() }} &bull; {{ $term->name }} &bull; Generated: {{ now()->format('M d, Y H:i') }}
    </div>
</div>

@push('styles')
<style>
@media print {
    .no-print { display: none !important; }
    .print-only { display: block !important; }
    #sidebar, #topbar { display: none !important; }
    #main-content { margin: 0 !important; padding: 0 !important; }
    .table { font-size: 7pt !important; }
}
</style>
@endpush
@endsection