@extends('admin.admin_dashboard')
@section('admin')

<style>
    .table-sticky thead th { position: sticky; top: 0; background: #f8f9fa; z-index: 2; }
    @media print { .no-print { display:none !important; } .table { font-size: 12px; } }
</style>

<div class="content-body">
<div class="container-fluid">

    <div class="d-flex justify-content-between align-items-center mb-2 no-print">
        <h4>Tabulation Sheet</h4>
        <div>
           <a href="{{ route('admin.reports.tabulation.pdf', request()->only('exam_id','section_id')) }}" class="btn btn-outline-secondary">PDF</a>

            <a href="{{ route('admin.reports.tabulation.csv', request()->only('exam_id','section_id')) }}" class="btn btn-outline-secondary">CSV</a>
            <button onclick="window.print()" class="btn btn-primary">Print</button>
        </div>
    </div>

    <div class="mb-2">
        <strong>Exam:</strong> {{ $exam->exam_name }}
        | <strong>Session:</strong> {{ $exam->session->name ?? '-' }}
        | <strong>Class:</strong> {{ $exam->class->name ?? '-' }}
        | <strong>Section:</strong> {{ $section->name ?? 'All' }}
    </div>

    <div class="table-responsive">
        <table class="table table-bordered table-striped table-sticky">
            <thead>
                <tr>
                    <th rowspan="2">Roll</th>
                    <th rowspan="2">Student</th>
                    @foreach($subjects as $sub)
                        <th class="text-center" colspan="1">{{ $sub->name }}</th>
                    @endforeach
                    <th rowspan="2">Total</th>
                    <th rowspan="2">GPA</th>
                    <th rowspan="2">Class Pos</th>
                    <th rowspan="2">Sec Pos</th>
                </tr>
                <tr>
                    @foreach($subjects as $sub)
                        <th class="text-center">Mark</th>
                    @endforeach
                </tr>
            </thead>
            <tbody>
                @foreach($rows as $r)
                    <tr>
                        <td>{{ $r->roll }}</td>
                        <td>{{ $r->name }}</td>

                        @foreach($subjects as $sub)
                            @php
                                $col = collect($r->subjects)->firstWhere('subject_id', $sub->id);
                                $disp = $col && $col['is_absent'] ? 'A' : number_format($col['mark'] ?? 0, 2);
                            @endphp
                            <td class="text-end">{{ $disp }}</td>
                        @endforeach

                        <td class="text-end">{{ number_format($r->total, 2) }}</td>
                        <td class="text-center">{{ $r->gpa ?? '-' }}</td>
                        <td class="text-center">{{ $r->position_class ?? '-' }}</td>
                        <td class="text-center">{{ $r->position_section ?? '-' }}</td>
                    </tr>
                @endforeach
            </tbody>
            <tfoot>
                <tr class="fw-bold bg-light">
                    <td colspan="2" class="text-end">Subject Totals</td>
                    @foreach($subjects as $sub)
                        <td class="text-end">{{ number_format($subjectTotals[$sub->id] ?? 0, 2) }}</td>
                    @endforeach
                    <td class="text-end">{{ number_format($grandTotal, 2) }}</td>
                    <td colspan="2"></td>
                </tr>
            </tfoot>
        </table>
    </div>

</div>
</div>
@endsection