{% extends "admin/base_site.html" %}
{% load i18n l10n jet_tags static %}
{% block title %}{{ title }} | {{ site_title|default:settings.SITE_HEADER }}{% endblock %}
{% block branding %}
    <h1 id="site-name"><a href="{% url 'admin:index' %}">{{ site_header|default:settings.SITE_HEADER }}</a></h1>
{% endblock %}

{% block content %}


    <div class="container-fluid">

        <!-- Page Heading -->
        <div class="d-sm-flex align-items-center justify-content-between mb-4">
            <h1 class="h3 mb-0 text-gray-800">Importación de Programaciones de Transporte</h1>
        </div>


        <div class="row">
            <div class="col-xl-8 col-lg-7">
                <form action="/dashboard/cargarRoutePlanning/" method="post" enctype="multipart/form-data">
                    {% csrf_token %}
                    <input type="file"
                           title="Upload excel file"
                           name="excel_file"
                           style="border: 1px solid black; padding: 5px;"
                           required="required">
                    <p>
                        <input type="submit"
                               value="Cargar archivo"
                               style="cursor: pointer;">
                </form>

                <p> Total de registros importados correctamente: {{ resumen }}</p>

                <hr>
                {% if excel_data %}
                    <div>
                        <b>Errores de importación:</b>
                        <table>
                            <tr>
                                <td>Linea</td>
                                <td>Matricula</td>
                                <td>Error</td>
                            </tr>
                            {% for row in excel_data %}
                                <tr>
                                    <td>
                                        {{ row.linea }}
                                    </td>
                                    <td>
                                        {{ row.placa }}
                                    </td>
                                    <td>
                                        {{ row.desc }}
                                    </td>
                                </tr>
                            {% endfor %}

                        </table>
                    </div>
                {% endif %}
            </div>
        </div>
    </div>



{% endblock %}