@include('header_nuevo_generico')
<style>
    .col {
        font-size: 11px;
    }
</style>

<div class="containerbig col-md-10" style="margin-top:7%;margin-left:5%;margin-bottom:5%">
    <div class="col-md-10 h3 text-center">Reporte de Balances - Ratios</div>
    <div class="p-2 bg-light">
        <form name="form_reporte" id="form_reporte" method="post" class="form-signin">
            {{ csrf_field() }}
            <div class="row">
                <!--div class="col-md-3 col-md-offset-1"-->
                <div class="col-md-1">
                    <label for="indice">Ratio</label>
                    <select name="indice" id="indice" class="form-control campos">
                        <option value="ind_utilfin" selected>Rantabilidad</option>
                        <option value="ind_solvencia_pat">Solvencia Patrimonial</option>
                    </select>
                </div>


                <div class="col-md-1">
                    <label for="anio">5 años desde:</label>
                    <select name="anio" id="anio" class="form-control campos">
                        @for ($i = $anio1; $i <= $anio; $i++)
                            <option value="{{$i}}" @if($i == $anio2) selected @endif>{{$i}}</option>
                        @endfor
                    </select>
                </div>

                <div class="col-md-1">
                    <label for="pais">País:</label>
                    <select name="pais" id="pais" class="form-control campos">
                        <option value="0">TODOS</option>
                        <option value="AR">Argentina</option>
                    </select>
                </div>

                <div class="col-md-2">
                    <label for="sector">Sectores</label>
                    <select name="sector" id="sector" class="form-control campos">
                        <option value="0">TODOS o Seleccione...</option>
                        @foreach ($sectores as $sec)
                            <option value="{{$sec->cod_ramo}}">{{$sec->cod_ramo}} - {{$sec->descripcion}}</option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-3">
                    <label for="cliente">Cliente</label>
                    <select name="cliente" id="cliente" class="form-control campos">
                        <option value="0">TODOS o Seleccione...</option>
                        @foreach ($clientes as $cli)
                            <option value="{{$cli->cliente}}">{{$cli->nombre_cliente}} (Cod. {{$cli->cli_codigo}})</option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-2">
                    <div class="col-md-12 producto d-none campos">
                        <label for="producto">Contrapartes del servicio:</label>
                        <select name="producto" id="producto" class="form-control">
                            <option value="0">TODOS o Seleccione...</option>
                            @foreach ($productos as $sec)
                                <option value="{{$sec->producto}}"> {{$sec->nombre}}</option>
                            @endforeach
                        </select>
                    </div>
                </div>

                <div class="col-md-2 text-right" style="padding-bottom: 0px;">
                    <label><br><br></label>
                    <button type="submit" class="btn btn-primary">Generar Reporte</button>
                </div>

            </div>
        </form>
    </div>
    <div class="col-md-12 text-center p-2 bg-light">
        <img id="loading" src="/images/loading.gif" class="d-none" width="50px">
        <div class="col-md-12 text-center" id="tabla_reporte">
        </div>
    </div>
</div>


<script src="{{ URL::asset('js/datatable-excel/jquery-3.3.1.js') }}" type="text/javascript"></script>

<script src="{{ URL::asset('js/datatable-excel/jquery.dataTables.min.js') }}" type="text/javascript"></script>
<script src="{{ URL::asset('js/datatable-excel/dataTables.buttons.min.js') }}" type="text/javascript"></script>
<script src="{{ URL::asset('js/datatable-excel/jszip.min.js') }}" type="text/javascript"></script>
<script src="{{ URL::asset('js/datatable-excel/buttons.html5.min.js') }}" type="text/javascript"></script>
<script src="{{ URL::asset('js/datatable-excel/buttons.print.min.js') }}" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
    function createDatatableReporte(tabla) {
        if ($(tabla).length == 0) { return; }
        $(tabla).DataTable({
            "pagingType": "full_numbers",
            "dom": "Blf<t>ip",
            "ordering": true,
            "order": [[0, "asc"]],
            "info": true,
            //buttons: [ { extend: 'excel', className: 'btn btn-primary btn-fidelitas' } ],
            buttons: [
                {
                    extend: 'excel',
                    text: 'Exportar a excel',
                    title: 'Reporte Balances',
                    //messageTop: 'Totales de Consultas',
                    exportOptions: {
                        columns: ':visible'
                    },
                    className: 'btn btn-primary btn-fidelitas'
                }],
            "lengthMenu": [[100, 50, 25, -1], [100, 50, 25, "Todos"]],
            "language": {
                "lengthMenu": "Mostrar _MENU_ registros por página",
                "zeroRecords": "No se encontraron  resultados para ésa búsqueda",
                //"info": "Mostrando página _PAGE_ de _PAGES_",
                //"info": "Total de Registros: _MAX_",
                "info": "<b>Total:</b> _TOTAL_ registros",
                "infoEmpty": "No hay registros disponibles",
                "infoFiltered": "(filtered from _MAX_ total records)",
                "sSearch": "Buscar",
                "oPaginate": {
                    "sFirst": "Primera",
                    "sPrevious": "Anterior",
                    "sNext": "Siguiente",
                    "sLast": "Última"
                },
            }
        });
    }

    $(document).on('change', "#cliente", function (e) {
        e.preventDefault();
        if ($('#cliente').val() == 0) {
            $(".producto").addClass('d-none');
        }
        else {
            $(".producto").removeClass('d-none');
        }
    });


    $(document).on('change', ".campos", function (e) {
        e.preventDefault();
        $('#tabla_reporte').html('');
    });

    $(document).on('submit', "#form_reporte", function (e) {
        e.preventDefault();
        $('#tabla_reporte').html('');
        $.ajax({
            method: "POST",
            url: "/balances-reportes/reportes",
            data: $('#form_reporte').serialize(),
            beforeSend: function () {
                $('#loading').removeClass('d-none').show();
            },
            success: function (data) {
                $('#loading').addClass('d-none');
                $('#tabla_reporte').html(data);
                createDatatableReporte('#tabla_registros');
            },
            error: function (err) {
                mensaje('Error en la Busqueda');
            }
        });
    });
</script>