{% extends "FactelBundle::Layout.html.twig" %}

{% block css %}
    <!-- DataTables CSS -->
    <link href="{{asset('recursos/bower_components/datatables-plugins/integration/bootstrap/3/dataTables.bootstrap.css')}}" rel="stylesheet">
    <!-- DataTables Responsive CSS -->
    <link href="{{asset('recursos/bower_components/datatables-responsive/css/dataTables.responsive.css')}}" rel="stylesheet">
    <link href="{{asset('garyavendanio/uikit/css/uikit.min.css')}}" rel="stylesheet">
{% endblock %}

{% block panel_title %}
<div class="uk-background-cover text-blue-500 h-44 w-full rounded-2xl uk-grid uk-grid-collapse uk-flex-between uk-flex-middle px-8" style="background-image: url( {{asset('recursos/img/bg-header.png')}} );">
    <div>
        <svg xmlns="http://www.w3.org/2000/svg" class="h-7 w-7" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
            <path stroke-linecap="round" stroke-linejoin="round" d="M12 8c-1.657 0-3 .895-3 2s1.343 2 3 2 3 .895 3 2-1.343 2-3 2m0-8c1.11 0 2.08.402 2.599 1M12 8V7m0 1v8m0 0v1m0-1c-1.11 0-2.08-.402-2.599-1M21 12a9 9 0 11-18 0 9 9 0 0118 0z" />
        </svg>
        <span class="text-xl">Reporte Total</span>
    </div>
    <div class="pull-right"></div>
</div>
{% endblock %}

{% block content %}
    <div>
        <div class="mb-10">
            <form action="{{path('retencion_totalizada_excel')}}" name = "reporte" id = "reporte" method="GET">
                <div class="lg:grid grid-cols-4 gap-4 items-end">
                    <input type="hidden" name="filtro" id="filtro">
                    <div class="form-group">
                        <label class="form-label font-light" for="sel1">Fecha de inicio</label>
                        <input class="form-control border-gray-200" type="text" id="fechaInicial" size="8" name="fechaInicial" onchange="busqueda()"/>
                    </div>
                    <div class="form-group">
                        <label class="form-label font-light" for="sel1">Fecha de fin</label>
                        <input class="form-control border-gray-200" type="text" id="fechaFinal" size="8" name="fechaFinal" onchange="busqueda()"/>
                    </div>
                    
                    <div class="form-group w-48">
                        <a class="uk-button uk-button-primary capitalize flex uk-flex-middle uk-flex-center rounded-full" onclick="enviarFormulario()" type="button" id="enviar">
                            <svg xmlns="http://www.w3.org/2000/svg" class="h-5 w-5 mr-2" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                                <path stroke-linecap="round" stroke-linejoin="round" d="M15 13l-3 3m0 0l-3-3m3 3V8m0 13a9 9 0 110-18 9 9 0 010 18z" />
                            </svg>
                            <span>Descargar Excel</span>
                        </a>
                    </div>
                </div>
            </form>

            <div class="dataTable_wrapper table-responsive">  
                <table class="table table-striped table-bordered table-hover" id="retencion-totalizada-table">
                    <thead>
                        <tr>
                            <th class="font-light text-blue-500">Tipo Retenci&oacute;n</th>
                            <th class="font-light text-blue-500">C&oacute;digo Retenci&oacute;n</th>
                            <th class="font-light text-blue-500">Concepto</th>
                            <th class="font-light text-blue-500">Base Imponible</th>
                            <th class="font-light text-blue-500">Valor Retenido</th>
                        </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
{% endblock %}

{% block javascript %}
    <script src="{{asset('recursos/bower_components/datatables/media/js/jquery.dataTables.min.js')}}"></script>
    <script src="{{asset('recursos/bower_components/datatables-plugins/integration/bootstrap/3/dataTables.bootstrap.min.js')}}"></script>
    <script src="{{asset('recursos/js/script.js')}}"></script>
                        <script>
                            function enviarFormulario() {
                                var fechaInicial = $("#fechaInicial").val();
                                var fechaFinal = $("#fechaFinal").val();
                                var filtro = $('#retencion-totalizada-table_filter input').val();
                                var cadena = "";
                                if (fechaInicial != "" && fechaFinal != "") {
                                    cadena = fechaInicial + "&" + fechaFinal + "&";
                                }

                                cadena = cadena + filtro;
                                $("#filtro").val(cadena);
                                document.reporte.submit();
                            }

                            var oTable = $("#retencion-totalizada-table").dataTable({
                                responsive: true,
                                bAutoWidth: false,
                                sAjaxSource: "{{ path('reporte_retencion_totalizada')}}",
                                bProcessing: true,
                                bServerSide: true,
                                bSort: false,
                                aLengthMenu: [[20, 30, 50], [20, 30, 50]],
                                language: {
                                    sProcessing: "Procesando...",
                                    sLengthMenu: "Mostrar _MENU_",
                                    sZeroRecords: "No se encontraron resultados",
                                    sEmptyTable: "Ningún dato disponible en esta tabla",
                                    sInfo: "Mostrando del _START_ al _END_ de _TOTAL_ registros",
                                    sInfoEmpty: "Mostrando del 0 al 0 de un total de 0 registros",
                                    sInfoFiltered: "(filtrado de un total de _MAX_ registros)",
                                    sInfoPostFix: "",
                                    sSearch: "Buscar:",
                                    sUrl: "",
                                    sInfoThousands: ",",
                                    sLoadingRecords: "Cargando...",
                                    oPaginate: {
                                        sFirst: "Primero",
                                        sLast: "Último",
                                        sNext: "Siguiente",
                                        sPrevious: "Anterior"
                                    },
                                    oAria: {
                                        sSortAscending: ": Activar para ordenar la columna de manera ascendente",
                                        sSortDescending: ": Activar para ordenar la columna de manera descendente"
                                    },
                                },
                            });

                            $('#retencion-totalizada-table_filter input').unbind();
                            $('#retencion-totalizada-table_filter input').bind('keyup', function (e) {
                                if (e.keyCode == 13) {
                                    var fechaInicial = $("#fechaInicial").val();
                                    var fechaFinal = $("#fechaFinal").val();

                                    var cadena = "";
                                    if (fechaInicial != "" && fechaFinal != "") {
                                        cadena = fechaInicial + "&" + fechaFinal + "&";
                                    }

                                    oTable.fnFilter(cadena + $(this).val());
                                }
                            });
                            oTable.on('search.dt', function () {
                                var datos = $('#retencion-totalizada-table_filter input').val().split("&");
                                if (datos.length == 3) {
                                    $('#retencion-totalizada-table_filter input').val(datos[2]);
                                }
                            });

                            function busqueda() {
                                var fechaInicial = $("#fechaInicial").val();
                                var fechaFinal = $("#fechaFinal").val();

                                var cadena = "";
                                if (fechaInicial != "" && fechaFinal != "") {
                                    cadena = fechaInicial + "&" + fechaFinal + "&";
                                    oTable.fnFilter(cadena + $('#retencion-totalizada-table_filter input').val());
                                }
                                if (fechaInicial == "" && fechaFinal == "") {
                                    oTable.fnFilter($('#retencion-totalizada-table_filter input').val());
                                }

                            }
                        </script>
<script src="{{asset('garyavendanio/uikit/js/uikit.min.js')}}"></script>
<script src="{{asset('garyavendanio/uikit/js/uikit-icons.min.js')}}"></script>
{% endblock %}