{% include "header.html"  %}
{% load static %}

    <!-- main page  -->
    <div class="mdk-header-layout__content">

        <div class="mdk-drawer-layout js-mdk-drawer-layout" data-push data-responsive-width="992px">
            <div class="mdk-drawer-layout__content page">

                <div class="container page__heading-container">
                    <div class="page__heading">
                       
                    </div>

                    <div class="row mb-3">
                        <div class="col-6">
                            <h1 class="heading">Potential Sales Report</h1>
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb mb-0">
                                    <li class="breadcrumb-item"><a href="#">Home</a></li>
            
                                    <li class="breadcrumb-item active" aria-current="page">Potential Sales Report</li>
                                </ol>
                            </nav>
                        </div>
                        <div class="col-6">
                            <div class="d-flex justify-content-end">
                                <button type="button" class="add-btn" >export excel</button>
                            </div>
                        </div>
                    </div>
                    <div class="row">
                        <form method="GET">
                            <div class="row mb-3">

                                <div class="col-lg-10">
                                    <div class="row g-3">

                                        <!-- Exam Category -->
                                        <div class="col-md-3">
                                            <label class="form-label fw-semibold">Exam Category</label>
                                            <select name="exam_category" class="form-control">
                                                <option value="">All Exam Category</option>
                                                {% for exam in exam_categories %}
                                                    <option value="{{ exam.id }}"
                                                        {% if request.GET.exam_category == exam.id|stringformat:"s" %}selected{% endif %}>
                                                        {{ exam.exam_category_name }}
                                                    </option>
                                                {% endfor %}
                                            </select>
                                        </div>

                                        <!-- Course -->
                                        <div class="col-md-3">
                                            <label class="form-label fw-semibold">Course</label>
                                            <select name="course" class="form-control">
                                                <option value="">All Courses</option>
                                                {% for course in courses %}
                                                    <option value="{{ course.id }}"
                                                        {% if request.GET.course == course.id|stringformat:"s" %}selected{% endif %}>
                                                        {{ course.course_name }}
                                                    </option>
                                                {% endfor %}
                                            </select>
                                        </div>

                                       
                                            <div class="col-md-3">
                                                <label class="form-label fw-semibold">Activity Type</label>
                                                <select name="activity_type" class="form-control">
                                                    <option value="">All Activities</option>
                                                    {% for value, label in activity_types %}
                                                        <option value="{{ value }}"
                                                            {% if request.GET.activity_type == value %}selected{% endif %}>
                                                            {{ label }}
                                                        </option>
                                                    {% endfor %}
                                                </select>
                                            </div>

                                       

                                        <!-- From Date -->
                                        <div class="col-md-3">
                                            <label class="form-label fw-semibold">From Date</label>
                                            <input type="date"
                                                name="from_date"
                                                value="{{ request.GET.from_date }}"
                                                class="form-control">
                                        </div>

                                        <!-- To Date -->
                                        <div class="col-md-3">
                                            <label class="form-label fw-semibold">To Date</label>
                                            <input type="date"
                                                name="to_date"
                                                value="{{ request.GET.to_date }}"
                                                class="form-control">
                                        </div>

                                        <!-- Search -->
                                        <div class="col-md-6">
                                            <label class="form-label fw-semibold">Search</label>
                                            <input type="text"
                                                name="search"
                                                value="{{ request.GET.search }}"
                                                placeholder="Search by Name, Email or Mobile"
                                                class="form-control">
                                        </div>

                                    </div>
                                </div>

                                <!-- Buttons -->
                                <div class="col-lg-2 d-flex align-items-end">
                                    <div class="w-100 d-flex gap-2">
                                        <button type="submit" class="btn btn-primary w-50">Filter</button>
                                        <a href="{% url 'sales_reports' %}" class="btn btn-secondary w-50">Reset</a>
                                    </div>
                                </div>

                            </div>
                        </form>
                    </div>
                </div>

                <div class="container page__container exam-module">
                    <div class="card card-body">
                        <div class="row no-gutters">

                            <div class="col-lg-12 card-body">

                                <div class="table-responsive border-bottom" data-toggle="lists"
                                    data-lists-values='["js-lists-values-employee-name"]'>

                                  

                                    <table class="table mb-0 thead-border-top-0 text-center">
                                        <thead class="table-heading text-center">
                                            <tr>
                                                <th>Sr.No.</th>
                                                <th>Student Name</th>
                                                <th>Email</th>
                                                <th>Mobile No</th>
                                                <th>Exam Category</th>
                                                <th>Recent Activity Date</th>
                                                <th>Activity Type</th>
                                                <th>Registration Date</th>
                                            </tr>
                                        </thead>
                                        </thead>

                                        <tbody>
                                            {% for student in students %}
                                            <tr>
                                                <td>{{ students.start_index|add:forloop.counter0 }}</td>

                                                <td>{{ student.first_name }} {{ student.last_name }}</td>
                                                <td>{{ student.email }}</td>
                                                <td>{{ student.mobile }}</td>

                                                <td>
                                                    {% if student.exam_category %}
                                                        {{ student.exam_category.exam_category_name }}
                                                    {% else %}
                                                        -
                                                    {% endif %}
                                                </td>

                                                <!-- Recent Activity Date -->
                                                <td>
                                                    {% if student.latest_activity_date %}
                                                        {{ student.latest_activity_date|date:"d/m/Y" }}
                                                    {% else %}
                                                        -
                                                    {% endif %}
                                                </td>

                                                <!-- Activity Type -->
                                                <td>
                                                    {{ student.latest_activity_label|default:"-" }}
                                                </td>

                                                <td>{{ student.created_at|date:"d/m/Y" }}</td>
                                            </tr>

                                            {% empty %}
                                            <tr>
                                                <td colspan="8">No Potential Sales Found</td>
                                            </tr>
                                            {% endfor %}
                                        </tbody>
                                    </table>

                                </div>
                               
                            </div>

                            <div class="col-lg-12 p-0">
                                <ul class="pagination m-0">

                                    {% if students.has_previous %}
                                    <li class="page-item">
                                        <a class="page-link"
                                        href="?page={{ students.previous_page_number }}&{{ request.GET.urlencode }}">
                                            <span aria-hidden="true" class="material-icons">chevron_left</span>
                                            <span>Prev</span>
                                        </a>
                                    </li>
                                    {% endif %}

                                    <li class="page-item active">
                                        <span class="page-link">
                                            {{ students.number }}
                                        </span>
                                    </li>

                                    {% if students.has_next %}
                                    <li class="page-item">
                                        <a class="page-link"
                                        href="?page={{ students.next_page_number }}&{{ request.GET.urlencode }}">
                                            <span>Next</span>
                                            <span aria-hidden="true" class="material-icons">chevron_right</span>
                                        </a>
                                    </li>
                                    {% endif %}

                                </ul>
                            </div>
                        </div>
                      
                    </div>

                    
                   

               
                </div>
             
            </div>

            
            <!-- // END drawer-layout__content -->

            <!-- drawer -->
          {% include "sidebar.html"%}
            <!-- // END drawer -->
        </div>
        <!-- // END drawer-layout -->

    </div>
    <!-- // END header-layout__content -->

</div>a

<!-- // END header-layout -->

{% include "footer.html" %}