{% extends "AppBundle::layout_backend.html.twig" %}

{% block content %}
    <div class='box views'>
        <div class='panel'>
            <div class='panel-heading cfj-deg-violeta' style="color: #fff;">Importacion de datos</div>
            <div class='panel-body'>
                <div class='box-tools-inner'>
                    <form action="{{ path('app_import_categories') }}" method="post" enctype="multipart/form-data">
                        <div class="form-group col-lg-12 col-md-12 col-xs-12">
                            <label for="tabla">Seleccione el archivo</label>
                            <input type="file" name="excel" id="excel"/>
                        </div>

                        <div class="col-lg-12 col-md-12 col-xs-12">
                            <div class="row">
                                <div class="col-lg-12 col-md-12 col-xs-12">
                                    <button class="cfj-a-rounded"
                                            style="position: absolute; left: 370px; width: fit-content !important; height: fit-content !important; padding: 5px 10px; border-radius: 20px; font-size: 18px; bottom: 15px;"
                                            id="btn-importar"><i class="fa fa-upload"></i> Importar Datos
                                    </button>
                                    <a class="cfj-a-rounded"
                                       href="{{ asset('templates/excel/ModeloImportacionCategorias.xlsx') }}"
                                       target="_blank"
                                       style="position: absolute; right: 240px; width: fit-content !important; height: fit-content !important; padding: 5px 10px; border-radius: 20px; font-size: 18px; bottom: 15px;">
                                        <i class="fa fa-download"></i> Descargar Modelo
                                    </a>
                                </div>
                            </div>
                        </div>

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

            <br><br>

             <table id='tablesorter1' class='table table-hover table-responsive tabla-productos-global-web'>
                <thead>
                <tr class='tr-top-table'>
                    <th class='col-lg-1 col-md-1 col-xs-2'>Fecha de importación</th>
                    <th class='col-lg-1 col-md-1 col-xs-2'>Registros a importar</th>
                    <th class='col-lg-1 col-md-1 col-xs-2'>Registros importados</th>
                    <th class='col-lg-1 col-md-1 col-xs-2'>Registros no importados</th>
                    <th class='col-lg-1 col-md-1 col-xs-2'>Estado</th>
                    </th>
                </tr>
                </thead>
                <tbody>
                    
                    {% for imported in imports %}
                        <tr>
                            <td align="center" class="col-lg-1 col-md-1 col-xs-2">{{ imported.uploadDate | date('Y-m-d H:i:s') }}</td>
                            <td align="center" class="col-lg-1 col-md-1 col-xs-2">{{ imported.totalRegisters }}</td>
                            <td align="center" class="col-lg-1 col-md-1 col-xs-2">{{ imported.totalImported }}</td>
                            <td align="center" class="col-lg-1 col-md-1 col-xs-2">

                                {{ imported.totalFailed }}

                                {% if ((imported.totalImported + imported.totalFailed) == imported.totalRegisters) %}

                                {% if (imported.totalFailed > 0) %}

                                <br>

                                <a href="{{ path('download_imported_errors', {'id': imported.id, 'type': 'categories'}) }}">Descargar archivo de errores</a>

                                {% endif %}

                                {% endif %}

                            </td>
                            <td align="center" class="col-lg-1 col-md-1 col-xs-2">
                                {% if ((imported.totalImported + imported.totalFailed) == imported.totalRegisters) %}
                                <p>Importación <b style="color:green;">finalizada</b></p>

                                {% else %}
                                <p>Importación <b style="color:blue;">en proceso</b></p>

                                {% endif %}

                            </td>
                        </tr>
                    {% endfor %}

                    <!--<td align="center" class='col-lg-1 col-md-1 col-xs-2'>Probando</td>
                    <td align="center" class='col-lg-1 col-md-1 col-xs-2'>23/09/2019</td>
                    <td align="center" class='col-lg-1 col-md-1 col-xs-2'>Procesando...</td>-->
                </tbody>
            </table>

    </div>


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

   

{% endblock %}