{% extends "dj_tracker/base.html" %}

{% block title %}Trackings{% endblock %}

{% block body %}
    <h1 class="h1">Trackings</h1>
    <div class="container mx-0 mt-4 p-0">
        <div class="row gy-5 pb-4">
            <div class="col-12">
                <div class="card">
                    <h4 class="card-header">Requests</h4>
                    <div class="card-body p-0">
                        <div class="row gx-5">
                            <div class="col">
                                <h5 class="h5 ms-3 my-3">Latest</h5>
                                <div class="list-group list-group-flush">
                                    {% for request in latest %}
                                        <a href="{{ request.get_absolute_url }}"
                                           class="list-group-item list-group-item-action d-flex justify-content-between align-items-center">
                                            <div class="">{{ request.path }}</div>
                                        </a>
                                    {% empty %}
                                        <p>No trackings yet.</p>
                                    {% endfor %}
                                </div>
                            </div>
                            <div class="col">
                                <h5 class="h5 ms-3 my-3">Most frequent</h5>
                                <div class="list-group list-group-flush">
                                    {% for request in most_tracked %}
                                        <a href="{{ request.get_absolute_url }}"
                                           class="list-group-item list-group-item-action d-flex justify-content-between align-items-center">
                                            <div class="">{{ request.path }}</div>
                                            <span class="badge bg-primary rounded-pill">{{ request.num_trackings }}</span>
                                        </a>
                                    {% empty %}
                                        <p>No trackings yet.</p>
                                    {% endfor %}
                                </div>
                            </div>
                        </div>
                        <div class="d-flex justify-content-center">
                            <a href="{% url 'requests' %}" class="btn btn-primary my-4">See all requests</a>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-6">
                <div class="card">
                    <h4 class="card-header">Queries</h4>
                    <div class="card-body">
                        <div class="row">
                            <h5 class="card-title">Most frequent</h5>
                            <table class="table">
                                <thead>
                                  <tr>
                                    <th scope="col">#</th>
                                    <th scope="col">Repeated</th>
                                  </tr>
                                </thead>
                                <tbody>
                                    {% for query in most_repeated_queries %}
                                        <tr>
                                            <td><a href="{{ query.get_absolute_url }}">{{ query.pk }}</a></td>
                                            <td>{{ query.num_trackings }}</td>
                                        </tr>
                                    {% endfor %}
                                </tbody>
                            </table>
                        </div>
                        <div class="row">
                            <h5 class="card-title">Largest query groups</h5>
                            <table class="table">
                                <thead>
                                  <tr>
                                    <th scope="col">#</th>
                                    <th scope="col">Num queries</th>
                                  </tr>
                                </thead>
                                <tbody>
                                    {% for query_group in largest_query_groups %}
                                        <tr>
                                            <td><a href="{{ query_group.get_absolute_url }}">{{ query_group.pk }}</a></td>
                                            <td>{{ query_group.num_queries }}</td>
                                        </tr>
                                    {% endfor %}
                                </tbody>
                            </table>
                        </div>
                        <div class="row">
                            <h5 class="card-title">Slowest</h5>
                            <table class="table">
                                <thead>
                                  <tr>
                                    <th scope="col">#</th>
                                    <th scope="col">Average duration (in ms)</th>
                                  </tr>
                                </thead>
                                <tbody>
                                    {% for query in slowest %}
                                        <tr>
                                            <td><a href="{{ query.get_absolute_url }}">{{ query.pk }}</a></td>
                                            <td>{{ query.average_duration_in_ms }}</td>
                                        </tr>
                                    {% endfor %}
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-6">
                <div class="card">
                    <h4 class="card-header">Fields</h4>
                    <div class="card-body">
                        <h5 class="card-title">Most accessed</h5>
                        <table class="table">
                            <thead>
                              <tr>
                                <th scope="col">#</th>
                                <th scope="col">Get</th>
                                <th scope="col">Set</th>
                              </tr>
                            </thead>
                            <tbody>
                                {% for field in most_accessed_fields %}
                                    <tr>
                                        <td>{{ field }}</td>
                                        <td>{{ field.get_count }}</td>
                                        <td>{{ field.set_count }}</td>
                                    </tr>
                                {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
{% endblock %}