@extends('admin.layout.app')
@section('content')

<div class="container py-4">
    <h2 class="mb-4">Registered Students</h2>
    
    {{-- Filter Option --}}
    <div class="row mb-3">
        <div class="col-12">
            <form action="{{ route('admin.registers.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');
                        $schools = \App\Models\School::where('status', 'active')->orderBy('name')->get();
                    @endphp
                    @foreach($schools as $school)
                        <option value="{{ $school->id }}" {{ $filterSchoolId == $school->id ? 'selected' : '' }}>
                            {{ $school->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'))
                    <a href="{{ route('admin.registers.index') }}" class="btn btn-sm btn-link ms-2 text-danger text-decoration-underline">Reset</a>
                @endif
            </form>
        </div>
    </div>

    <div class="card shadow-sm rounded mb-4">
        <div class="card-body">
            <div class="mb-3">
                <a href="{{ route('admin.register.show') }}" class="btn btn-primary">
                    <i class="bi bi-plus-circle"></i> Add Student
                </a>
            </div>
            <table class="table table-bordered table-striped align-middle">
                <thead class="table-light">
                    <tr>
                        <th>ID</th>
                        <th>Student ID</th>
                        <th>Student Name</th>
                        <th>Parent Name</th>
                        <th>Email</th>
                        <th>Phone</th>
                        <th>School</th>
                        <th>Standard</th>
                        <th>Section</th>
                        <th>Gender</th>
                        <th>Created At</th>
                        <th>Updated At</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($students as $student)
                        <tr>
                            <td>{{ $student->id }}</td>
                            <td>{{ $student->student_id }}</td>
                            <td>{{ $student->student_name }}</td>
                            <td>{{ $student->parent_name }}</td>
                            <td>{{ $student->email }}</td>
                            <td>{{ $student->phone }}</td>
                            <td>{{ $student->school->name ?? $student->school_id }}</td>
                            <td>{{ $student->standard->name ?? $student->standard_id }}</td>
                            <td>{{ $student->section->section_name ?? $student->section_id }}</td>
                            <td>{{ $student->gender }}</td>
                            <td>{{ $student->created_at->format('d-m-Y H:i') }}</td>
                            <td>{{ $student->updated_at->format('d-m-Y H:i') }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="13" class="text-center text-muted">No students found.</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>

@endsection