@extends('layouts.admin')

@section('title', 'Bulk Student Import')
@section('page-title', 'Bulk Student Import')

@section('content')
<div class="row mb-4">
    <div class="col-12">
        <a href="{{ route('admin.students.index') }}" class="text-decoration-none text-secondary">
            <i class="bi bi-arrow-left"></i> Back to Student List
        </a>
    </div>
</div>

<div class="row">
    <!-- Form Box -->
    <div class="col-lg-6 mb-4">
        <div class="admin-card h-100">
            <h5 class="mb-4 fw-bold">Upload Student Data (CSV)</h5>
            
            @if(session('import_fail'))
                <div class="alert alert-danger rounded-3 shadow-sm mb-4" role="alert">
                    <h6 class="fw-bold"><i class="bi bi-exclamation-octagon-fill me-2"></i> {{ session('import_fail') }}</h6>
                    <p class="mb-0 small mt-2">Please fix the validation errors shown below and upload the corrected CSV. No rows were saved.</p>
                    <a href="{{ route('admin.import.errors') }}" class="btn btn-sm btn-danger mt-3 fw-bold rounded-2 px-3">
                        <i class="bi bi-download me-1"></i> Download Error Report (CSV)
                    </a>
                </div>
            @endif

            <form action="{{ route('admin.import.handle') }}" method="POST" enctype="multipart/form-data">
                @csrf
                <div class="mb-4 p-4 rounded-3 text-center border border-2 border-dashed bg-light">
                    <i class="bi bi-file-earmark-spreadsheet text-success fs-1 mb-3 d-block"></i>
                    <label class="form-label fw-bold d-block">Choose CSV File</label>
                    <input type="file" name="csv_file" class="form-control rounded-3" accept=".csv" required>
                    <small class="text-muted d-block mt-2">Only .csv files are supported. Max file size: 2MB.</small>
                </div>

                <button type="submit" class="btn btn-primary rounded-3 w-100 py-2.5">
                    <i class="bi bi-upload me-1"></i> Start Validation & Import
                </button>
            </form>
        </div>
    </div>

    <!-- Instructions Box -->
    <div class="col-lg-6 mb-4">
        <div class="admin-card h-100 bg-white">
            <h5 class="mb-3 fw-bold text-dark"><i class="bi bi-info-circle text-primary"></i> CSV Structure Guidelines</h5>
            <p class="text-muted small">Your CSV file must have precisely the following 5 columns in the exact header row order. Do not include spaces or special characters in the column headers.</p>
            
            <div class="table-responsive mb-3">
                <table class="table table-bordered table-sm small text-center mb-0">
                    <thead class="table-light font-monospace" style="font-size: 0.8rem;">
                        <tr>
                            <th>roll_number</th>
                            <th>name</th>
                            <th>class_name</th>
                            <th>section_name</th>
                            <th>branch_name</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td class="text-muted">ROLL101</td>
                            <td class="text-muted">Jerry Smith</td>
                            <td class="text-muted">Nursery</td>
                            <td class="text-muted">Section A</td>
                            <td class="text-muted">Main Campus</td>
                        </tr>
                        <tr>
                            <td class="text-muted">ROLL102</td>
                            <td class="text-muted">Emma Watson</td>
                            <td class="text-muted">Class 1</td>
                            <td class="text-muted">Section B</td>
                            <td class="text-muted">West Branch</td>
                        </tr>
                    </tbody>
                </table>
            </div>

            <h6 class="fw-bold mt-4 mb-2 small text-uppercase text-secondary">Active Database Reference Values:</h6>
            <div class="row">
                <div class="col-6 mb-3">
                    <span class="d-block fw-semibold small text-primary">Allowed Classes:</span>
                    <small class="text-muted">Nursery, LKG, UKG, Class 1, Class 2, Class 3, Class 4, Class 5, Class 6, Class 7, Class 8</small>
                </div>
                <div class="col-6 mb-3">
                    <span class="d-block fw-semibold small text-primary">Allowed Sections:</span>
                    <small class="text-muted">Section A, Section B, Section C</small>
                </div>
                <div class="col-12">
                    <span class="d-block fw-semibold small text-primary">Allowed Branches:</span>
                    <small class="text-muted">Main Campus, West Branch</small>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Errors Display List -->
@if(session('errors_list'))
    <div class="row">
        <div class="col-12">
            <div class="admin-card">
                <div class="d-flex justify-content-between align-items-center mb-3">
                    <h5 class="mb-0 fw-bold text-danger"><i class="bi bi-x-circle-fill"></i> Validation Errors Details</h5>
                    <span class="badge bg-danger px-3 py-2 fs-6 rounded-pill">{{ count(session('errors_list')) }} Errors Found</span>
                </div>
                <div class="table-responsive">
                    <table class="table table-bordered table-sm small align-middle mb-0">
                        <thead class="table-danger text-danger">
                            <tr>
                                <th>Row</th>
                                <th>Roll Number</th>
                                <th>Name</th>
                                <th>Class</th>
                                <th>Section</th>
                                <th>Branch</th>
                                <th>Error Reason</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach(session('errors_list') as $err)
                                <tr>
                                    <td class="fw-bold">#{{ $err['row'] }}</td>
                                    <td class="font-monospace text-secondary">{{ $err['roll_number'] ?: 'N/A' }}</td>
                                    <td>{{ $err['name'] ?: 'N/A' }}</td>
                                    <td class="text-secondary">{{ $err['class_name'] ?: 'N/A' }}</td>
                                    <td class="text-secondary">{{ $err['section_name'] ?: 'N/A' }}</td>
                                    <td class="text-secondary">{{ $err['branch_name'] ?: 'N/A' }}</td>
                                    <td class="text-danger fw-semibold"><i class="bi bi-x-circle"></i> {{ $err['errors'] }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endif
@endsection