{% extends "admin/base_site.html" %}
{% block page_title %}{{ title }}{% endblock %}
{% block content %}
    <div class="container">
        <div class="row">
            <div class="col">
                <h1 class="h3">Manage Students</h1>
            </div>
            <div class="col-auto">
                <a href="{% url 'add_student' %}" class="btn btn-primary">Add New Student</a>
            </div>
        </div>
        <form method="GET">
            <div class="row my-3">
                <div class="col-md-6">
                    <input type="text"
                           name="search"
                           class="form-control"
                           placeholder="Search students by name or email..."
                           value="{{ search_query }}" />
                </div>
                <div class="col-md-3">
                    <button type="submit" class="btn btn-secondary">Search</button>
                </div>
            </div>
        </form>
        <div class="table-responsive">
            <table class="table table-hover">
                <thead>
                    <tr>
                        <th>S.N</th>
                        <th>Full Name</th>
                        <th>Course</th>
                        <th>Academic Year</th>
                        <th>Phone</th>
                        <th>Email</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    {% for student in students %}
                        <tr>
                            <td>{{ forloop.counter }}</td>
                            <td>{{ student.first_name }}</td>
                            <td>{{ student.course.name }}</td>
                            <td>{{ student.academic_year.start_date|date:"Y" }}</td>
                            <td>{{ student.phone }}</td>
                            <td>{{ student.email }}</td>
                            <td>
                                <a href="{% url 'edit_student' student.id %}"
                                   class="btn btn-sm btn-warning">Edit</a>
                                <a href="{% url 'delete_student' student.id %}"
                                   class="btn btn-sm btn-danger">Delete</a>
                            </td>
                        </tr>
                    {% empty %}
                        <tr>
                            <td colspan="7" class="text-center">No students found</td>
                        </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div>
    </div>
{% endblock %}