@extends('layouts.app')
@section('title', 'Bulk Marks Entry')
@section('page-title', 'Bulk Marks Entry')

@section('content')
<div class="max-w-4xl mx-auto space-y-6">

    <div class="flex items-center justify-between">
        <p class="text-sm text-gray-500">Upload marks for an entire class using an Excel template.</p>
        <a href="{{ route('academics.exams.index') }}" class="text-sm text-gray-500 hover:text-gray-700"><i class="fas fa-arrow-left mr-1"></i> Back to Exams</a>
    </div>

    {{-- Messages --}}
    @if(session('success'))
    <div class="bg-green-50 border border-green-200 text-green-700 px-4 py-3 rounded-xl text-sm">
        <i class="fas fa-check-circle mr-1"></i> {{ session('success') }}
    </div>
    @endif
    @if(session('error'))
    <div class="bg-red-50 border border-red-200 text-red-700 px-4 py-3 rounded-xl text-sm">
        <i class="fas fa-exclamation-circle mr-1"></i> {{ session('error') }}
    </div>
    @endif
    @if(session('upload_errors'))
    <div class="bg-yellow-50 border border-yellow-200 text-yellow-800 px-4 py-3 rounded-xl text-sm">
        <p class="font-semibold mb-1"><i class="fas fa-exclamation-triangle mr-1"></i> Some rows had issues:</p>
        <ul class="list-disc list-inside space-y-0.5 text-xs">
            @foreach(session('upload_errors') as $err)
                <li>{{ $err }}</li>
            @endforeach
        </ul>
    </div>
    @endif

    {{-- Step 1: Select Exam & Download Template --}}
    <div class="bg-white rounded-xl shadow-sm ring-1 ring-gray-200/60 overflow-hidden">
        <div class="px-6 py-4 border-b border-gray-100 bg-gray-50/50">
            <h2 class="font-semibold text-gray-800">
                <span class="inline-flex items-center justify-center w-6 h-6 rounded-full bg-primary-700 text-white text-xs font-bold mr-2">1</span>
                Select Exam & Download Template
            </h2>
        </div>
        <div class="p-6">
            @if($exams->count())
            <form method="GET" action="{{ route('admin.bulk.marks.template') }}" class="space-y-4">
                <div>
                    <label class="block text-sm font-medium text-gray-700 mb-1">Select Exam <span class="text-red-400">*</span></label>
                    <select name="exam_id" required class="w-full border border-gray-300 rounded-lg px-3 py-2.5 text-sm focus:ring-primary-500 focus:border-primary-500">
                        <option value="">Choose an exam...</option>
                        @foreach($exams as $exam)
                            <option value="{{ $exam->id }}">
                                {{ $exam->name }} — {{ $exam->subject?->name ?? 'No Subject' }} ({{ $exam->class_?->full_name ?? 'No Class' }}) [Max: {{ $exam->total_marks }}]
                            </option>
                        @endforeach
                    </select>
                </div>
                <button type="submit" class="inline-flex items-center gap-2 bg-gray-800 text-white px-5 py-2.5 rounded-lg text-sm font-medium hover:bg-gray-900 transition">
                    <i class="fas fa-download"></i> Download Marks Template
                </button>
            </form>
            @else
            <div class="text-center py-8">
                <i class="fas fa-graduation-cap text-4xl text-gray-300 mb-3 block"></i>
                <p class="text-gray-500">No exams found. Create an exam first before uploading marks.</p>
                <a href="{{ route('academics.exams.create') }}" class="inline-flex items-center gap-2 mt-3 text-primary-600 hover:text-primary-800 text-sm font-medium">
                    <i class="fas fa-plus"></i> Create Exam
                </a>
            </div>
            @endif
        </div>
    </div>

    {{-- Step 2: Upload Marks --}}
    <div class="bg-white rounded-xl shadow-sm ring-1 ring-gray-200/60 overflow-hidden">
        <div class="px-6 py-4 border-b border-gray-100 bg-gray-50/50">
            <h2 class="font-semibold text-gray-800">
                <span class="inline-flex items-center justify-center w-6 h-6 rounded-full bg-primary-700 text-white text-xs font-bold mr-2">2</span>
                Upload Filled Marks Sheet
            </h2>
        </div>
        <div class="p-6">
            <form method="POST" action="{{ route('admin.bulk.marks.upload') }}" enctype="multipart/form-data" class="space-y-4">
                @csrf
                <div class="grid grid-cols-1 md:grid-cols-2 gap-4">
                    <div>
                        <label class="block text-sm font-medium text-gray-700 mb-1">Excel File <span class="text-red-400">*</span></label>
                        <input type="file" name="file" accept=".xlsx,.xls" required
                               class="w-full border border-gray-300 rounded-lg px-3 py-2 text-sm file:mr-3 file:py-1 file:px-3 file:rounded-lg file:border-0 file:bg-primary-50 file:text-primary-700 file:font-medium file:text-sm hover:file:bg-primary-100">
                    </div>
                    <div>
                        <label class="block text-sm font-medium text-gray-700 mb-1">Exam <span class="text-red-400">*</span></label>
                        <select name="exam_id" required class="w-full border border-gray-300 rounded-lg px-3 py-2.5 text-sm">
                            <option value="">Select exam...</option>
                            @foreach($exams as $exam)
                                <option value="{{ $exam->id }}">
                                    {{ $exam->name }} — {{ $exam->subject?->name ?? '' }} ({{ $exam->class_?->full_name ?? '' }})
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <button type="submit" class="inline-flex items-center gap-2 bg-primary-700 text-white px-6 py-2.5 rounded-lg text-sm font-semibold hover:bg-primary-800 transition shadow-sm">
                    <i class="fas fa-upload"></i> Upload & Save Marks
                </button>
            </form>
        </div>
    </div>

    {{-- How It Works --}}
    <div class="bg-stone-50 rounded-xl border border-stone-200 p-5">
        <h3 class="text-sm font-semibold text-stone-700 mb-3"><i class="fas fa-info-circle mr-1 text-primary-600"></i> How It Works</h3>
        <div class="grid grid-cols-1 md:grid-cols-3 gap-4">
            <div class="text-center">
                <div class="w-10 h-10 bg-primary-100 rounded-full flex items-center justify-center mx-auto mb-2">
                    <i class="fas fa-download text-primary-700"></i>
                </div>
                <p class="text-xs text-stone-600"><strong>Download</strong> — Template pre-filled with student names for the selected exam</p>
            </div>
            <div class="text-center">
                <div class="w-10 h-10 bg-primary-100 rounded-full flex items-center justify-center mx-auto mb-2">
                    <i class="fas fa-pen text-primary-700"></i>
                </div>
                <p class="text-xs text-stone-600"><strong>Fill In</strong> — Enter marks in the "Marks Obtained" column. Mark absent students with "yes"</p>
            </div>
            <div class="text-center">
                <div class="w-10 h-10 bg-primary-100 rounded-full flex items-center justify-center mx-auto mb-2">
                    <i class="fas fa-upload text-primary-700"></i>
                </div>
                <p class="text-xs text-stone-600"><strong>Upload</strong> — Grades are auto-calculated. Existing marks will be updated with audit trail</p>
            </div>
        </div>
    </div>

    {{-- Recent Exams Quick Stats --}}
    @if($exams->count())
    <div class="bg-white rounded-xl shadow-sm ring-1 ring-gray-200/60 overflow-hidden">
        <div class="px-6 py-4 border-b border-gray-100 bg-gray-50/50">
            <h3 class="font-semibold text-gray-800"><i class="fas fa-chart-bar mr-2 text-gray-400"></i>Recent Exams</h3>
        </div>
        <div class="overflow-x-auto">
            <table class="w-full">
                <thead class="bg-gray-50 border-b border-gray-100">
                    <tr>
                        <th class="px-4 py-3 text-left text-xs font-semibold text-gray-600 uppercase">Exam</th>
                        <th class="px-4 py-3 text-left text-xs font-semibold text-gray-600 uppercase">Subject</th>
                        <th class="px-4 py-3 text-left text-xs font-semibold text-gray-600 uppercase">Class</th>
                        <th class="px-4 py-3 text-center text-xs font-semibold text-gray-600 uppercase">Max Marks</th>
                        <th class="px-4 py-3 text-center text-xs font-semibold text-gray-600 uppercase">Entries</th>
                        <th class="px-4 py-3 text-left text-xs font-semibold text-gray-600 uppercase">Date</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-gray-50">
                    @foreach($exams->take(10) as $exam)
                    <tr class="hover:bg-gray-50">
                        <td class="px-4 py-3 text-sm font-medium text-gray-800">{{ $exam->name }}</td>
                        <td class="px-4 py-3 text-sm text-gray-600">{{ $exam->subject?->name ?? '—' }}</td>
                        <td class="px-4 py-3 text-sm text-gray-600">{{ $exam->class_?->full_name ?? '—' }}</td>
                        <td class="px-4 py-3 text-center text-sm text-gray-700">{{ $exam->total_marks }}</td>
                        <td class="px-4 py-3 text-center">
                            <span class="inline-flex items-center px-2 py-0.5 rounded-full text-xs font-medium bg-blue-50 text-blue-700">
                                {{ $exam->marks->count() }}
                            </span>
                        </td>
                        <td class="px-4 py-3 text-xs text-gray-500">{{ $exam->exam_date?->format('d M Y') }}</td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
    @endif
</div>
@endsection