@extends('admin.layout.app')
@section('content')
<div class="app-content">
    <div class="container-fluid">
        <div class="row mb-3">
            <div class="col-12 d-flex flex-wrap justify-content-between align-items-center">
                <h2 class="mb-0 fw-bold">Sections</h2>
                <div class="d-flex flex-wrap gap-2 ms-auto">
                    <a href="{{ route('admin.sections.create') }}" class="btn btn-primary">
                        <i class="bi bi-plus-circle me-1"></i>
                        {{ $sections->isEmpty() ? 'Add New' : 'Add Another' }}
                    </a>
                    {{-- Bulk Import Button triggers Modal --}}
                    <button type="button" class="btn btn-success" data-bs-toggle="modal" data-bs-target="#bulkImportModal">
                        <i class="bi bi-upload me-1"></i>
                        Bulk Import
                    </button>
                </div>
            </div>
        </div>
        
        {{-- Section Filters --}}
        <div class="row mb-3">
            <div class="col-12">
                <form action="{{ route('admin.sections.index') }}" method="GET" class="d-flex flex-wrap align-items-center gap-2">
                    <label for="school_filter" class="form-label mb-0 me-2 fw-semibold">Filter by School:</label>
                    <select name="school_id" id="school_filter" class="form-select form-select-sm w-auto">
                        <option value="">All Schools</option>
                        @php
                            $filterSchoolId = request('school_id');
                        @endphp
                        @foreach(\App\Models\School::orderBy('name')->get() as $school)
                            <option value="{{ $school->id }}" {{ $filterSchoolId == $school->id ? 'selected' : '' }}>
                                {{ $school->name }}
                            </option>
                        @endforeach
                    </select>

                    <label for="standard_filter" class="form-label mb-0 ms-3 me-2 fw-semibold">Filter by Standard:</label>
                    <select name="standard_id" id="standard_filter" class="form-select form-select-sm w-auto">
                        <option value="">All Standards</option>
                        @php
                            $filterStandardId = request('standard_id');
                        @endphp
                        @foreach(\App\Models\Standard::orderBy('id', 'asc')->get() as $standard)
                            <option value="{{ $standard->id }}" {{ $filterStandardId == $standard->id ? 'selected' : '' }}>
                                {{ $standard->name }}
                            </option>
                        @endforeach
                    </select>

                    <button type="submit" class="btn btn-sm btn-outline-primary ms-2">
                        <i class="bi bi-search"></i> Filter
                    </button>
                    @if(request('school_id') || request('standard_id'))
                        <a href="{{ route('admin.sections.index') }}" class="btn btn-sm btn-link ms-2 text-danger text-decoration-underline">Reset</a>
                    @endif
                </form>
            </div>
        </div>

        @if (session('success'))
            <div class="alert alert-success">
                {{ session('success') }}
            </div>
        @endif
        @if (session('error'))
            <div class="alert alert-danger m-2">
                {!! session('error') !!}
            </div>
        @endif

        {{-- Bulk Import Modal --}}
        <div class="modal fade" id="bulkImportModal" tabindex="-1" aria-labelledby="bulkImportModalLabel" aria-hidden="true">
            <div class="modal-dialog">
                <form action="{{ route('admin.sections.bulk-import') }}" method="POST" enctype="multipart/form-data" class="modal-content">
                    @csrf
                    <div class="modal-header">
                        <h5 class="modal-title" id="bulkImportModalLabel">Bulk Import Sections</h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                    </div>
                    <div class="modal-body">
                        <div class="mb-3">
                            <label for="section_file" class="form-label">Choose CSV File</label>
                            <input type="file" class="form-control" id="section_file" name="section_file" accept=".csv,.txt" required>
                            <div class="form-text">CSV columns: <code>school,standard,section_name,status</code>.<br>Status should be <b>active</b> or <b>inactive</b>.</div>
                        </div>
                        <div class="mb-3">
                            <label for="default_status" class="form-label">Default Status</label>
                            <select name="default_status" id="default_status" class="form-select" required>
                                <option value="active" selected>Active</option>
                                <option value="inactive">Inactive</option>
                            </select>
                        </div>
                        <div class="alert alert-info py-2 px-3 small mb-0">
                            <i class="bi bi-info-circle me-1"></i>
                            <strong>Heads up:</strong> School and Standard are matched by their names. Sections will be created or updated.<br>
                            <a href="{{ asset('samples/section-bulk-import-sample.csv') }}" target="_blank">Download sample file</a>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="submit" class="btn btn-success">
                            <i class="bi bi-upload me-1"></i> Upload & Import
                        </button>
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    </div>
                </form>
            </div>
        </div>
        {{-- End Bulk Import Modal --}}

        <div class="row">
            <div class="col-12">
                <div class="card shadow-sm border-0">
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered align-middle text-center mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th scope="col" style="width:5%;">#</th>
                                        <th scope="col" style="width:25%;">School Name</th>
                                        <th scope="col" style="width:25%;">Standard</th>
                                        <th scope="col" style="width:25%;">Section Name</th>
                                        <th scope="col" style="width:20%;">Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse ($sections as $key => $section)
                                        <tr class="text-center">
                                            <td>{{ $key + 1 }}</td>
                                            <td>{{ $section->school->name ?? '-' }}</td>
                                            <td>{{ $section->standard->name ?? '-' }}</td>
                                            <td>{{ $section->section_name ?? '-' }}</td>
                                            <td>
                                                <a href="{{ route('admin.sections.edit', $section->id) }}" class="btn btn-sm btn-outline-primary me-1" title="Edit">
                                                    <i class="bi bi-pencil"></i>
                                                </a>
                                                <form action="{{ route('admin.sections.destroy', $section->id) }}" method="POST" class="d-inline" onsubmit="return confirm('Are you sure you want to delete this item?');">
                                                    @csrf
                                                    @method('DELETE')
                                                    <button class="btn btn-sm btn-outline-danger" type="submit" title="Delete">
                                                        <i class="bi bi-trash"></i>
                                                    </button>
                                                </form>
                                            </td>
                                        </tr>
                                    @empty
                                        <tr class="text-center">
                                            <td colspan="5" class="text-muted py-4">
                                                <i class="bi bi-info-circle"></i> No sections found.
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                        @if(method_exists($sections, 'links'))
                            <div class="d-flex justify-content-end mt-3">
                                {{ $sections->links('pagination::bootstrap-4') }}
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection