{% extends "admin.html" %}
{% load staticfiles %}

{% load course_extras %}

{% block headtitle %}Reports - {{ block.super }}{% endblock %}

{% block headstyle %}
<link rel="stylesheet" href="{% static 'js/libs/datepicker/css/datepicker.css' %}" />
<link rel="stylesheet" media="print" href="{% static 'css/print.css' %}" />
{% endblock %}

{% block content %}
    {% include "reports/admin/partials/nav.html" %}

    <div class="row noprint">
        <div class="span12">
            <div class="page-header">
                <h1>Learner Report</h1>
            </div>
        </div>
    </div>

    <div class="row filters noprint">
        <div class="span12">
            <form action="" method="post" class="form-inline">{% csrf_token %}
                <div class="pull-left">
                    <input type="text" name="learner" class="input-medium" placeholder="Learner" value="{% if learner %}{{ learner }}{% endif %}"  />
                    <input type="text" name="company" class="input-medium" placeholder="Company" value="{% if company %}{{ company }}{% endif %}" />
                    <select class="input-medium" name="reseller" id="reseller">
                        <option value="">-- Reseller --</option>
                        {% for r in resellers %}
                            <option value="{{ r.id }}" {% if reseller|floatformat == r.id|floatformat %}selected="selected"{% endif %}>{{ r }}</option>
                        {% endfor %}
                    </select>
                    <div class="input-prepend">
                        <span class="add-on"><i class="icon-calendar"></i></span>
                        <input class="input-small" id="from-date" type="text" placeholder="From Date" name="from-date" value="{% if from_date %}{{ from_date }}{% endif %}" />
                    </div>
                    <div class="input-prepend">
                        <span class="add-on"><i class="icon-calendar"></i></span>
                        <input class="input-small" id="to-date" type="text" placeholder="To Date" name="to-date" value="{% if to_date %}{{ to_date }}{% endif %}" />
                    </div>
                    <select class="input-medium" name="course" id="course">
                        <option value="">-- Course --</option>
                        {% for c in courses %}
                            <option value="{{ c.id }}" {% if course|floatformat == c.id|floatformat %}selected="selected"{% endif %}>{{ c }}</option>
                        {% endfor %}
                    </select>
                    <select class="input-medium" name="status" id="status">
                        <option value="">-- Status --</option>
                        <option value="1" {% if status == '1' %}selected="selected"{% endif %}>Not Started</option>
                        <option value="2" {% if status == '2' %}selected="selected"{% endif %}>In Progress</option>
                        <option value="3" {% if status == '3' %}selected="selected"{% endif %}>Failed Exam</option>
                        <option value="4" {% if status == '4' %}selected="selected"{% endif %}>Passed Exam</option>
                    </select>
                </div>
                <div class="clearfix"></div>
                <br />
                <div class="pull-right">
                    <button id="filter" type="submit" class="btn btn-primary">Filter</button>
                    <a href="#" id="print" class="btn">Print</a>
                    <a href="?all=true" class="btn">Show All</a>
                </div>
            </form>
        </div>
    </div>

    {% if learners %}
        <p><strong>Learner Count: {{ learners|length }}</strong></p>
    </div>
        <table class="table table-striped table-bordered" style="margin:3%; width:94%;">
            <thead>
                <tr>
                    <th>Learner ID</th>
                    <th>Quartz Reg No</th>
                    <th>Name</th>
                    <th>Username</th>
                    <th>Email</th>
                    <th>Company</th>
                    <th>DOB</th>
                    <th>Postcode</th>
                    <th>Gender</th>
                    <th>Ethnicity</th>
                    <th style="">Course</th>
                    <th style="">Progress</th>
                    <th style="">Awarding Body</th>
                    <th style="">Learner Reg Num</th>
                    <th style="">Cert Num</th>
                    <th style="">Exam Score</th>
                    <th style="">Exam End Time</th>
                    <th>Date Joined</th>
                    <th>Last Login</th>
                </tr>
            </thead>
            <tbody>
                {% for learner in learners %}
                    {% if learner.get_credits %}
                        {% for credit in learner.get_credits %}
                            {% if course %}
                                {% if credit.course.id|floatformat == course|floatformat %}
                                    <tr>
                                        <td>{{ learner.id|stringformat:"08d" }}</td>
                                        <td>{{ learner.quartz_reg_no }}</td>
                                        <td>{{ learner.user.first_name }} {{ learner.user.last_name }}</td>
                                        <td>{{ learner.user }}</td>
                                        <td>{{ learner.user.email }}</td>
                                        <td>{{ learner.group.company }}</td>
                                        <td>{% if learner.date_of_birth %}{{ learner.date_of_birth }}{% endif %}</td>
                                        <td>{{ learner.postcode }}</td>
                                        <td>{{ learner.get_gender_display }}</td>
                                        <td>{{ learner.get_ethnicity_display }}</td>
                                        <td style="">{{ credit.course }}</td>
                                        <td style="">{{ credit.course|get_complete_percentage:learner }}%</td>
                                        <td style="">{{ credit.awarding_body }}</td>
                                        <td style="">{% if credit.learner_reg_no %}{{ credit.learner_reg_no }}{% endif %}</td>
                                        <td style="">{% if credit.certificate_no %}{{ credit.certificate_no }}{% endif %}</td>
                                        {% with exam_submission=credit.course|get_passed_course:learner %}
                                            <td style="">
                                                {% if exam_submission.score %}
                                                    {{ exam_submission.score }}%
                                                {% endif %}
                                            </td>
                                            <td style="">
                                                {% if exam_submission.end_time %}
                                                    {{ exam_submission.end_time }}
                                                {% endif %}
                                            </td>
                                        {% endwith %}
                                        <td>{{ learner.user.date_joined }}</td>
                                        <td>{% if learner.user.date_joined != learner.user.last_login %}{{ learner.user.last_login }}{% else %}Never logged in{% endif %}</td>
                                    </tr>
                                {% endif %}
                            {% else %}
                                <tr>
                                    <td>{{ learner.id|stringformat:"08d" }}</td>
                                    <td>{{ learner.quartz_reg_no }}</td>
                                    <td>{{ learner.user.first_name }} {{ learner.user.last_name }}</td>
                                    <td>{{ learner.user }}</td>
                                    <td>{{ learner.user.email }}</td>
                                    <td>{{ learner.group.company }}</td>
                                    <td>{% if learner.date_of_birth %}{{ learner.date_of_birth }}{% endif %}</td>
                                    <td>{{ learner.postcode }}</td>
                                    <td>{{ learner.get_gender_display }}</td>
                                    <td>{{ learner.get_ethnicity_display }}</td>
                                    <td style="">{{ credit.course }}</td>
                                    <td style="">{{ credit.course|get_complete_percentage:learner }}%</td>
                                    <td style="">{{ credit.awarding_body }}</td>
                                    <td style="">{% if credit.learner_reg_no %}{{ credit.learner_reg_no }}{% endif %}</td>
                                    <td style="">{% if credit.certificate_no %}{{ credit.certificate_no }}{% endif %}</td>
                                    {% with exam_submission=credit.course|get_passed_course:learner %}
                                        <td style="">
                                            {% if exam_submission.score %}
                                                {{ exam_submission.score }}%
                                            {% endif %}
                                        </td>
                                        <td style="">
                                            {% if exam_submission.end_time %}
                                                {{ exam_submission.end_time }}
                                            {% endif %}
                                        </td>
                                    {% endwith %}
                                    <td>{{learner.user.date_joined}}</td>
                                    <td>{% if learner.user.date_joined != learner.user.last_login %}{{learner.user.last_login}}{% else %}Never logged in{% endif %}</td>
                                </tr>
                            {% endif %}
                        {% endfor %}
                    {% else %}
                    {% endif %}
                {% endfor %}
            </tbody>
        </table>
       <div class="container">
    {% else %}
        {% if search %}
            <p>No learners found.</p>
        {% else %}
            <p>No search performed.</p>
        {% endif %}
    {% endif %}
{% endblock %}

{% block footerscript %}
<script src="{% static 'js/libs/datepicker/js/bootstrap-datepicker.js' %}"></script>
<script>
    $('#from-date').datepicker({
        format: 'yyyy-mm-dd'
    });
    $('#to-date').datepicker({
        format: 'yyyy-mm-dd'
    });
</script>
<script>
    $(document).ready(function(){
        $('#filter').click(function(e) {
            e.preventDefault();
            var course = $('#course').val();
            var status = $('#status').val();
            if(status != '') {
                if(course == '') {
                    alert('Please select a course');
                    return false;
                }
            }
            $(this).closest('form').submit();
        });
        $('#print').click(function(e) {
            e.preventDefault();
            window.print();
        });
    });
</script>
{% endblock %}