@extends('layouts.app')
@section('title', 'Bulk Student Upload')
@section('page-title', 'Bulk Student Upload')

@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 multiple students at once using an Excel template.</p>
        <a href="{{ route('students.index') }}" class="text-sm text-gray-500 hover:text-gray-700"><i class="fas fa-arrow-left mr-1"></i> Back to Students</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: 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>
                Download Template
            </h2>
        </div>
        <div class="p-6">
            <p class="text-sm text-gray-600 mb-4">Download the Excel template, fill in student details, and upload it back. The template includes a class reference sheet and instructions.</p>
            <form method="GET" action="{{ route('admin.bulk.students.template') }}" class="flex flex-wrap items-end gap-4">
                <div>
                    <label class="block text-sm font-medium text-gray-700 mb-1">Pre-fill Class (optional)</label>
                    <select name="class_id" class="border border-gray-300 rounded-lg px-3 py-2.5 text-sm">
                        <option value="">All Classes</option>
                        @foreach($classes as $class)
                            <option value="{{ $class->id }}">{{ $class->full_name }}</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 Template
                </button>
            </form>
        </div>
    </div>

    {{-- Step 2: Upload File --}}
    <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 Template
            </h2>
        </div>
        <div class="p-6">
            <form method="POST" action="{{ route('admin.bulk.students.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">
                        <p class="text-xs text-gray-400 mt-1">Max 5MB, .xlsx or .xls format</p>
                    </div>
                    <div>
                        <label class="block text-sm font-medium text-gray-700 mb-1">Default Class (fallback)</label>
                        <select name="default_class_id" class="w-full border border-gray-300 rounded-lg px-3 py-2.5 text-sm">
                            <option value="">Use Class ID from file</option>
                            @foreach($classes as $class)
                                <option value="{{ $class->id }}">{{ $class->full_name }}</option>
                            @endforeach
                        </select>
                        <p class="text-xs text-gray-400 mt-1">Used when Class ID is empty in a row</p>
                    </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 & Create Students
                </button>
            </form>
        </div>
    </div>

    {{-- Tips --}}
    <div class="bg-stone-50 rounded-xl border border-stone-200 p-5">
        <h3 class="text-sm font-semibold text-stone-700 mb-2"><i class="fas fa-lightbulb mr-1 text-yellow-500"></i> Tips</h3>
        <ul class="text-xs text-stone-600 space-y-1.5">
            <li>• Delete the sample row (row 2) before uploading.</li>
            <li>• Check the "Class Reference" sheet in the template for correct Class IDs.</li>
            <li>• Duplicate emails will be skipped automatically.</li>
            <li>• Link parents by entering their existing email in the "Parent Email" column.</li>
            <li>• Maximum 200 students per upload.</li>
            <li>• Passwords should be at least 8 characters.</li>
        </ul>
    </div>

    {{-- Recently Created --}}
    @if($recentStudents->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-clock mr-2 text-gray-400"></i>Recently Added Students</h3>
        </div>
        <div class="divide-y divide-gray-50">
            @foreach($recentStudents as $s)
            <div class="px-6 py-3 flex items-center justify-between">
                <div>
                    <span class="text-sm font-medium text-gray-800">{{ $s->name }}</span>
                    <span class="text-xs text-gray-400 ml-2">{{ $s->email }}</span>
                </div>
                <span class="text-xs text-gray-400">{{ $s->created_at->diffForHumans() }}</span>
            </div>
            @endforeach
        </div>
    </div>
    @endif
</div>
@endsection