{% extends "admin/base_site.html" %}
{% load i18n l10n jet_tags static %}
{% block title %}{{ title }} | {{ site_title|default:settings.SITE_HEADER }}{% 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 Ubicaciones</h1>
        </div>


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

            <h5>Formato de ejemplo</h5>
            <table>
                <thead>
                    <tr>
                        <th>tipo_ubicacion</th>
                        <th>nombre</th>
                        <th>codigo</th>
                        <th>ubicacion_padre_codigo</th>
                        <th>empresa_id</th>
                        <th>orden</th>
                        <th>lector</th>
                        <th>centro</th>
                        <th>fecha_fin</th>
                    </tr>
                </thead>
                <tbody>
                <tr>
                    <td>..</td>
                    <td>..</td>
                    <td>..</td>
                    <td>..</td>
                    <td>..</td>
                    <td>..</td>
                    <td>..</td>
                    <td>..</td>
                    <td>..</td>
                </tr>
                </tbody>
            </table>
                <p></p>
                <hr>
                <p> Total de registros: {{ total }}</p>
                <p> Total de registros importados: {{ correctos }}</p>
                <p> Total de registros actualizados: {{ actualizados }}</p>
                {% for row in excel_data %}
                    {% for cell in row %}
                        {{ cell }}&nbsp;&nbsp;
                    {% endfor %}
                    <br>
                {% endfor %}
            </div>
        </div>
    </div>
{% endblock %}