@extends('layouts.app2')

@section('content')
    <div class="bgc-white p-20 bd">
        <h2>Consolidado de RP por Mes</h2>
        <div class="my-3 text-right">
            <a href="{{ url('/reportes/exportar/2020') }}" class="btn btn-primary" id="exportar_datos" download><i class="fas fa-download"></i> Descargar</a>
        </div>
        <div class="form-group row">
            <label for="staticEmail" class="col-sm-2 col-form-label">Seleccione Año</label>
            <div class="col-sm-2">
                <select class="form-control" id="year_select"><option value="2020">2020</option><option value="2021">2021</option></select>
            </div>
        </div>
        <div class="card">
            <div class="table-responsive">
                <table
                    id="table-consolidado_rp"
                    class="table"
                    data-pagination="true"
                    data-url="{{ url('/reportes/loadConsolidadoMes/2020') }}"
                    data-query-params="queryParams"
                    data-show-refresh="true"
                    data-show-footer="false"
                    data-sort-order="desc"
                    data-sort-name="id"
                    data-page-size="50"
                    data-checkbox-header="true"
                >
                    <thead>
                    <tr>
                        <th data-field='titulo'>Estados</th>
                        <th data-field='ene' data-formatter="mesFormatter">ENE</th>
                        <th data-field='feb' data-formatter="mesFormatter">FEB</th>
                        <th data-field='mar' data-formatter="mesFormatter">MZO</th>
                        <th data-field='abr' data-formatter="mesFormatter">ABR</th>
                        <th data-field='may' data-formatter="mesFormatter">MAY</th>
                        <th data-field='jun' data-formatter="mesFormatter">JUN</th>
                        <th data-field='jul' data-formatter="mesFormatter">JUL</th>
                        <th data-field='ago' data-formatter="mesFormatter">AGO</th>
                        <th data-field='sep' data-formatter="mesFormatter">SEP</th>
                        <th data-field='oct' data-formatter="mesFormatter">OCT</th>
                        <th data-field='nov' data-formatter="mesFormatter">NOV</th>
                        <th data-field='dic' data-formatter="mesFormatter">DIC</th>
                        <th data-field='id' data-formatter="sumaFormatter">TOTAL ANUAL</th>
                    </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection

@push('post-scripts')
    <script src="{{ asset('js/autoNumeric-min.js') }}"></script>
    <script src="{{ asset('js/jquery.mask.min.js') }}"></script>
    <script src="{{ asset('js/sweetalert2.js') }}"></script>

    <style>
        .main-content {
            padding: 10px 20px 20px;
            min-height: calc(100vh - 61px);
        }
    </style>
    <script>

        function mesFormatter(value,row)
        {
            let n = 0;
            if(value != null)
                return value

            return n;
        }

        function sumaFormatter(value,row)
        {
            let div_ = 0;

            if(parseInt(row.ene) != 0) div_++;
            if(parseInt(row.feb) != 0) div_++;
            if(parseInt(row.mar) != 0) div_++;
            if(parseInt(row.abr) != 0) div_++;
            if(parseInt(row.may) != 0) div_++;
            if(parseInt(row.jun) != 0) div_++;
            if(parseInt(row.jul) != 0) div_++;
            if(parseInt(row.ago) != 0) div_++;
            if(parseInt(row.sep) != 0) div_++;
            if(parseInt(row.oct) != 0) div_++;
            if(parseInt(row.nov) != 0) div_++;
            if(parseInt(row.dic) != 0) div_++;

            let result = parseInt(row.ene)+parseInt(row.feb)+parseInt(row.mar)+parseInt(row.abr)+parseInt(row.may)+parseInt(row.jun)+parseInt(row.jul)+parseInt(row.ago)
            +parseInt(row.sep)+parseInt(row.oct)+parseInt(row.nov)+parseInt(row.dic);

            if(isNaN(result)) result = 0;

            if(row.titulo == "Promedio (días x RP)"){
                if(isNaN((result/div_).toFixed(1))) return 0;

                return (result/div_).toFixed(1);
            }
            else return result;
        }

        $(function(){
            var $table = $("#table-consolidado_rp");
        });

        $(".autonumber").autoNumeric("init")

        var tabla = $('#table-consolidado_rp').bootstrapTable({
            pagination: true, search: true
        });

        $("select#year_select").change(function(){
            let selected_year = $(this).val();

            let url = "{{ url('/reportes/loadConsolidadoMes/') }}";
            let url_export = "{{ url('/reportes/exportar/') }}";
            url = url+'/'+selected_year;
            url_export = url_export+'/'+selected_year;

            $("#exportar_datos").attr('href',url_export);

            $("#table-consolidado_rp").bootstrapTable('refresh', {url: url});
        });





    </script>
@endpush