{% extends '::base.html.twig' %}
{% block menuTop %}

{% endblock %}

{% block dashboard %}
    <style>
         #tab_filter { float: right; }
        .wrapper{padding-bottom:50px;}
        .header{background:#000000;}.header .container{padding-bottom:20px;}.header .container h1{color:#FFF;line-height:50px;margin-top:30px;margin-bottom:0;}
        .header .container h3{color:#E0E0E0;font-size:16px;margin-top:-5px;}.header .container h3 a{color:#66aacc;}.header .container h3 a:hover{color:#b3d5e6;}
        .top-menu{position:absolute;z-index:9999;}.top-menu .nav-list{background:rgba(255, 255, 255, 0.8);border:1px solid #CCC;margin:20px;position:fixed;right:0;}
        pre,.well{background:#FFFFFF;}
        .syntax-container{background:#FCFCFC;-webkit-border-radius:7px;-webkit-background-clip:padding-box;-moz-border-radius:7px;-moz-background-clip:padding;border-radius:7px;background-clip:padding-box;border:1px solid #e3e3e3;margin-bottom:30px;padding-bottom:20px;}
        .isloading-wrapper.isloading-right{margin-left:10px;}
        .isloading-overlay{position:relative;text-align:center;}.isloading-overlay .isloading-wrapper{background:#FFFFFF;-webkit-border-radius:7px;-webkit-background-clip:padding-box;-moz-border-radius:7px;-moz-background-clip:padding;border-radius:7px;background-clip:padding-box;display:inline-block;margin:0 auto;padding:10px 20px;top:10%;z-index:9000;}

        /*Glyphicon Spinner*/
        .glyphicon-spin {
            -animation: spin .9s infinite linear;
            -webkit-animation: spin2 .9s infinite linear;
        }

        @-webkit-keyframes spin2 {
            from { -webkit-transform: rotate(0deg);}
            to { -webkit-transform: rotate(360deg);}
        }

        @keyframes spin {
            from { transform: scale(1) rotate(0deg);}
            to { transform: scale(1) rotate(360deg);}
        }

        #menuTop {
            margin-top: 10px;
        }
        .fixed-panel {
            min-height: 100px;
            max-height: 200px;
            overflow-y: scroll;
        }
        #parametros .panel-body .row{

            padding-left: 5px;
        }
        #chart .panel-body {
             padding: 0px;
        }
         .btn-claro {
            color: #fff;
            background-color: #aa0001;
            border-color: #e06a70;

            }
            .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;

            }
            .table th{
                font-size: 9pt;
            }
            .table td{
                font-size: 8pt;
            }        

    </style>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>





    <script>
        
function truncateToDecimals(num, dec = 2) {
  const calcDec = Math.pow(10, dec);
  return Math.trunc(num * calcDec) / calcDec;
}
        /*[34, 29, 36, 29, 33, 22, 31, 22, 30, 34, 28, 42, 34, 39, 43, 28, 26, 19, 24, 42, 28, 43, 38, 32, 47]*/
        $(function () {
            $.isLoading({
                text:       "Loading"
            });
            $("#clear").click(function () {
                $('#Filtros_fechaIni').val("");
                $('#Filtros_fechaFin').val("");
            });           
            $('#Filtros_fechaIni').datepicker({
                    dateFormat: 'yy-mm-dd',
                    onClose: function( selectedDate ) {
                             $( "#Filtros_fechaFin" ).datepicker( "option", "minDate", selectedDate );

                    }
            }); 

            $('#Filtros_fechaFin').datepicker({
                    dateFormat: 'yy-mm-dd',
            });  

            var f = new Date();
            var mes = (f.getMonth() + 1);
            
            if (mes < 10) mes = '0'+mes;
            var fechaI= f.getFullYear() +'-'+mes + "-01";
            var fechaF= f.getFullYear() +'-'+mes + "-"+f.getDate();            
            if ( ((new Date(fechaF) - new Date(fechaI)) / (24 * 3600 * 1000)) < 7 )
            {
                 var unixIni = ( new Date(fechaI).getTime() );
                 unixIni = unixIni - ( 3600 * 24 * 7 * 1000);
                 
                 var fmi = new Date(unixIni);
                 mes = (fmi.getMonth() + 1);
                 if (mes < 10) mes = '0'+mes;
                 fechaI= fmi.getFullYear() +'-'+mes + "-"+fmi.getDate();  
            }
            if ({{idproyectos}} != 34) {
                $('#pais').val({{idproyectos}});
                $('#pais').prop('disabled', true);
            }
            
            $('#Filtros_fechaIni').val(fechaI);
            $('#Filtros_fechaFin').val(fechaF);
            
            getChart($('#Filtros_fechaIni').val(),$('#Filtros_fechaFin').val(),$('#pais').val());

             $("#generar").click(function(){
                $.isLoading({
                    text:       "Loading"
                });
                
                getChart($('#Filtros_fechaIni').val(),$('#Filtros_fechaFin').val(),$('#pais').val());
            });

        });

        function getChart(inicio, fin, pais){

            $.getJSON('{{path('sgp_DashboardMPM',{'idproyectos':idproyectos})}}',{'FechaInicio':inicio,'FechaFin':fin,'pais':pais}, function (data) {
                var chart = data;
                var data3 = chart.graficoTabla;
                
                $.getJSON('{{path('sgp_DashboardMPM_2',{'idproyectos':idproyectos})}}',{'FechaInicio':inicio,'FechaFin':fin,'pais':pais}, function (data) 
                {
                    generateTable(data3);
                    var chart = data;
                    if (chart.grafico1.length>0)
                    {
                        var at = 0;
                        for (i in chart.grafico1)
                        {
                            at = at + parseInt(chart.grafico1[i]['CANTIDAD']);
                        }
                        if (at > 0) { var chartTipoPie = getDataToObjectPie(chart.grafico1,Object.keys(chart.grafico1[0])); }
                       // else  { $("#chart8").empty(); $("#chart8").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');}
                    }
                     //Produccion y productividad
                    if (chart.grafico4.length>0){
                        var categoria1 = getDataToObject(chart.grafico4,Object.keys(chart.grafico4[0]),0,false);
                        var chart1 = getDataToObjectLinea(chart.grafico4,Object.keys(chart.grafico4[0]));
                    }
                     //if (chart.grafico4.length>0) createChart('chart4',categoria1,chart4,180); else { $("#chart4").empty(); $("#chart4").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');}

                     if (chart.grafico4.length>0) 
                     {  createChartLinea('chart1',categoria1,chart1); }
                     else { $("#chart1").empty (); $("#chart1").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');}



                   if (chart.grafico1.length>0 && at > 0) createChartPie('chart8',chartTipoPie); 
                    else { $("#chart8").empty(); $("#chart8").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');}                 

                    $.isLoading("hide");
                });
            });
        }
        
        function getDataToObject(data,header ,key,int)
        {
            var arrayReturn = new Array();
            for(var i = 0; i< data.length; i++){

                var valor = data[i][header[key]];

                if(int){
                    valor = parseInt(data[i][header[key]]);
                }

                arrayReturn.push(valor);
            }

            return arrayReturn;
        }
        
        function getDataToObjectBar(data,header)
        {
            var arrayReturn = new Array();
            var data1 = new Array();
            var data2 = new Array();    
            var data3 = new Array();              
            for(var i = 0; i< data.length; i++){
                data1.push(parseFloat(data[i][header[2]]));
                data2.push(parseFloat(data[i][header[3]]));
                data3.push(parseFloat(data[i][header[4]]));                
            }

            arrayReturn.push({'name': header[2], 'data': data1});    
            arrayReturn.push({'name': header[3], 'data': data2});
            arrayReturn.push({'name': header[4], 'data': data3}) ;           

            return arrayReturn;
        }
        
        function getDataToObjectPie(data,header)
        {
            var arrayReturn = new Array();
            for(var i = 0; i< data.length; i++){
                arrayReturn.push({'name': data[i][header[0]], 'y': parseInt(data[i][header[1]])})
            }
            return arrayReturn;
        }
        
        function getDataToObjectLinea(data,header)
        {
            var arrayReturn = new Array();
            var data1 = new Array();
            var data2 = new Array();    
            var data3 = new Array();
            var data4 = new Array();
            for(var i = 0; i< data.length; i++){
                data1.push(parseFloat(data[i][header[1]]));
                data2.push(parseFloat(data[i][header[2]]));
                data3.push(parseFloat(data[i][header[3]]));  
                data4.push(parseFloat(data[i][header[4]]));  
            }

            arrayReturn.push({'name': header[2], 'data': data2,'dataLabels':{'enabled':true}});    
            arrayReturn.push({'name': header[1], 'data': data1,'yAxis':1,'dataLabels':{'enabled':true}});
            arrayReturn.push({'name': header[3], 'data': data3,'yAxis':1}) ;           
            arrayReturn.push({'name': header[4], 'data': data4,'yAxis':1}) ;
            return arrayReturn;
        }   
        
        function createChart(render,categoria,data,wd){
            var options = {
                chart: {
                    renderTo: render,
                    type: 'bar',
                    spacingBottom: 5,
                    spacingTop: 10,
                    spacingLeft: 1,
                    spacingRight: 1,
                    height: wd,
                    width: 700
                },
                title: {
                    text: ''
                },
                subtitle: {
                    text: ''
                },
                xAxis: {
                    categories: categoria,
                    title: {
                        text: null
                    },
                    labels:{

                        style: {
                            fontSize:'9px'
                        }
                    }
                },
                yAxis: {
                    min: 0,
                    title: {
                        text: '',
                        align: 'high'
                    },
                    labels: {

                        overflow: 'justify',
                        formatter: function() {
                            return this.value;
                        }
                    }
                },
                tooltip: {
                        enabled: false
                },
                plotOptions: {
                    bar: {
                        dataLabels: {
                            enabled: true
                        }
                    },
                    series : {

                        dataLabels : {

                            enable : true,
                            format : '{y}'
                        },
                        events: {
                            click: function (event) {
                                //event.point.series[0].data = [[35]];
                            }
                        }
                    }
                },
                legend: {
                    layout: 'horizontal',
                    align: 'center',
                    verticalAlign: 'buttom',
                    floating: true,
                    x: 0,
                    y: 10
                },
                credits: {
                    enabled: false
                },
                series: [ {
                    showInLegend: false,
                    name: 'KPI %',
                    data: data,
                    color: {
                        linearGradient: { x1: 0, x2: 0, y1: 0, y2: 1 },
                        stops: [
                            [0, '#398235'],
                            [0.5, '#8ab66b'],
                            [1, '#c9de96']
                        ]
                    },

                    tag : 1

                }]
            };

            return $('#' +render).highcharts(options);
        }
        
        function createChartBar(render,categoria,data,wd){
            var options = {
                chart: {
                    renderTo: render,
                    type: 'bar',
                    spacingBottom: 5,
                    spacingTop: 10,
                    spacingLeft: 1,
                    spacingRight: 1,
                    height: wd,
                    width: 500
                },
                title: {
                    text: ''
                },
                xAxis: {
                    categories: categoria,
                    title: {
                        text: null
                    },
                    labels:{

                        style: {
                            fontSize:'9px'
                        }
                    }
                },
                yAxis: {
                    min: 0,
                    title: {
                        text: '',
                        align: 'high'
                    },
                    labels: {

                        overflow: 'justify',
                        formatter: function() {
                            return this.value;
                        }
                    }
                },
                legend: {
                    reversed: true
                },
                plotOptions: {
                    series: {
                        stacking: 'normal'
                    }
                },
                colors: [
                         '#a1c517','#0082b6','#b88fef','#009045','#db004f'
                        ],
                series: data
            };

            return $('#' +render).highcharts(options);
        }        
        
        function createChartPie(render,data){
            var options = {
                chart: {
                    renderTo: render,
                    type: 'pie',
                    height: 200,
                    width: 500,                    
                    options3d: {
                        enabled: true,
                        alpha: 45,
                        beta: 0
                    }
                },
                title: {
                    text: ''
                },
                colors: [
                         '#a1c517','#0082b6','#b88fef','#009045','#db004f'
                        ],
                tooltip: {
                    pointFormat: '{series.name}: <b>{point.percentage:.1f}%</b>'
                },
                plotOptions: {
                    pie: {
                        allowPointSelect: true,
                        cursor: 'pointer',
                        depth: 35,
                        dataLabels: {
                            enabled: true,
                            format: '<b>{point.name}</b>: {point.y}',
                            style: {
                                color: (Highcharts.theme && Highcharts.theme.contrastTextColor) || 'black'
                            }
                        }
                    }
                },               
                series: [{
                    data: data
                }]
           };

            return $('#' +render).highcharts(options);
        }
        
        function createChartLinea(render,categoria, data){
            if (typeof (data[1]) !== 'undefined') {
            var maxHeight = 0;
               for (a in data) {
                  for (i in data[a].data)
                  { if (data[a].data[i] > maxHeight) maxHeight = data[a].data[i]; }
               }
           }
           // if (maxHeight > 200) maxHeight = 200; 
            var options = {
                chart: {
                    renderTo: render,
                    height: ({{ barheight }} - 70),
                    width: 800
            
            
                },
                xAxis: {
                   categories:  categoria
                },
                yAxis: [{
                    min: 0,
                    max: maxHeight,
                    title: {
                        text: ''
                    },
                    plotLines: [{
                        value: 0,
                        width: 1,
                        color: '#808080'
                    }]
                  },{
                    title: {
                        text: ''
                    },
                    min:0,
                    opposite: true
                    }, {
                    title: {
                        text: ''
                    },
                    min:0,
                    opposite: true
                    }],
                title: {
                    text: ''
                },
                 tooltip: {
                    shared: true
                },
                colors: [
                         '#a1c517','#0082b6','#b88fef','#009045','#db004f'
                        ],
                series: 
                
                [
                { type: 'column', name: data[1].name, data: data[1].data},//programados
                 { type: 'column', name: data[0].name, data: data[0].data},//programados
                  {type: 'column', name: data[2].name, data: data[2].data},//programados
                  {type: 'column', name: data[3].name, data: data[3].data}//programados
                ]
           };
            return $('#' +render).highcharts(options);
        }
    </script>
       {%if idproyectos == 41 %}
        <style>
        .btn-claro {
            color: #fff;
            background-color: #00569C;
            border-color: #3D59CA;
        }
        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
       }            
        </style>
        {%endif%}
 
    <div class="container-fluid">
        
              <div class="row">
                 <!--<div class="col-lg-2"  style="margin-top: 1%">
                    <label>Pais: </label>                 
                    <select  id="pais">
                        <option value="TODOS">TODOS</option>
                        <option value="37">Costa Rica</option>
                        <option value="36">El Salvador</option>
                       <option value="35">Guatemala</option>                    
                        <option value="30">Honduras</option>
                        <option value="32">Nicaragua</option> 
                        <option value="57">Panamá</option>
                    </select>
                </div> -->             
                <div class="col-lg-2 top-uno">
                    <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>  
                    <input class="form-control" type="text" id="Filtros_fechaIni" value="">
                </div>
                <div class="col-lg-2 top-uno">
                    <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>  
                    <input class="form-control" type="text" id="Filtros_fechaFin" value="">
                </div>
                <div class="col-lg-2 top-uno" id="parametros">
                    <button class="btn btn-claro" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
                    <button class="btn btn-claro" id="clear">{{'ticketDetail.boton.limpiar' | trans}}</button> 
                </div>             
              {%if idproyectos != 41 %}
                <div class="col-lg-6">
                    <img id="logo" class="pull-right" src="{{ asset('images/claro.jpg') }}"  width="220" height="72" >

                 </div>  
              {%endif%}           
           </div>
        
         <div class="row">
                <div class="col-lg-12 text-center top-uno">
                    <h1>{{'DASHBOARD GENERAL MP SGP' | trans}}</h1>
                 </div>
         </div>
            <div class="row">    
                <div class="col-lg-2"></div>
               <div class="col-lg-8" style="height: {{ barheight }}px;">
                  <div class="panel panel-primary" style="height: {{ barheight }}px;">
                      <div class="panel-heading">{{'Mantenimientos Preventivos'| trans}}</div>
                      <div class="panel-body" id="chart1" style="height: {{ barheight }}px; overflow-x: auto; height: 380px;">

                      </div>
                  </div>
              </div>    
            <div class="col-lg-2"></div>                      
            </div> <!-- end row5-->          
                    <div class="row">
                            <div class="btn-group pull-right" style="margin-top: 20px;">
                                <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                                <ul class="dropdown-menu" role="menu">
                                     <li><a href="#" onclick="$('#auditTable').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                                </ul>
                            </div>
                    </div><br/>
                    <div id="auditTable" style="margin-top: 40px;"></div>
                    <div id="tab"></div>            
        </div>

     <!-- end container-->
     
    <script src="{{ asset('datatables/moment.min.js') }}"></script>
    <script src="{{ asset('datatables/js/datatables.min.js') }}"></script>
    <script src="{{ asset('datatables/js/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('datatables/js/dataTables.bootstrap.min.js') }}"></script>
    <script src="{{ asset('datatables/js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('datatables/js/buttons.bootstrap.min.js') }}"></script>
    <script src="{{ asset('datatables/js/buttons.flash.min.js') }}"></script>
    <script src="{{ asset('datatables/js/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('datatables/js/buttons.colVis.min.js') }}"></script>
    <script src="{{ asset('datatables/js/jszip.min.js') }}"></script>
    <script src="{{ asset('datatables/js/datetime-moment.js') }}"></script>
    <script>
         function generateTable(data){
            var table = '<table id="tab" class="table table-striped table-bordered table-hover responsive table-condensed nowrap" width="100%">';
            table += '<thead><tr class="btn-claro">';
            table += '<th style="vertical-align:middle; width: 50px; " class="text-center">{{"monitores.pais" | trans}}</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">%Ejecutado</th><th style="vertical-align:middle; width: 50px;" class="text-center">%Cargado</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">%Aceptado</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">%Pend.Validar</th>';
            //table += '<th style="vertical-align:middle; width: 50px;" class="text-center">PAIS</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">Planificado</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">Programado en SGP</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">Ejecutado</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">Aceptado</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">Cargado</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">Rechazado</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">Incumplimiento SLA</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">Pendiente Validar</th>';
            table += '<th style="vertical-align:middle; width: 50px;" class="text-center">Folios Pendientes por Cliente</th>';
            table += '</tr></thead><tbody>';
            var total_programados_en_sgp = 0, total_reportes_ejecutados = 0, total_reportes_aceptados = 0;
            var total_reportes_cargados = 0, total_reportes_rechazados = 0, total_pendientes_por_validar = 0;
            var  total_planificados = 0, total_pendientes_claro = 0, total_incumplimiento_sla = 0;
            for (var i in data) { 
                table += '<tr>';
                table += '<td>' + data[i].PAIS + '</td>';
                table += '<td>'+ data[i].PORCENTAJE_EJECUTADO +'</td>';
                table += '<td>' + data[i].PORCENTAJE_CARGADO + '</td>';
                table += '<td>' + data[i].PORCENTAJE_ACEPTADO + '</td>';
                table += '<td>' + data[i].PORCENTAJE_PENDI_VAL + '</td>';
               // table += '<td>' + data[i].PAIS + '</td>';
                table += '<td>' + data[i].REPORTES_PLANIFICADOS + '</td>';
                total_planificados += parseInt(data[i].REPORTES_PLANIFICADOS); 
                table += '<td>' + data[i].PROGRAMADOS_EN_SGP + '</td>';
                total_programados_en_sgp += parseInt(data[i].PROGRAMADOS_EN_SGP);
                table += '<td>' + data[i].REPORTES_EJECUTADOS + '</td>';
                total_reportes_ejecutados += parseInt(data[i].REPORTES_EJECUTADOS);
                table += '<td>' + data[i].REPORTES_ACEPTADOS + '</td>';
                total_reportes_aceptados += parseInt(data[i].REPORTES_ACEPTADOS);
                table += '<td>' + data[i].REPORTES_CARGADOS + '</td>';
                total_reportes_cargados += parseInt(data[i].REPORTES_CARGADOS);
                table += '<td>'+ data[i].REPORTES_RECHAZADOS +'</td>';
                total_reportes_rechazados += parseInt(data[i].REPORTES_RECHAZADOS);
                table += '<td>'+ data[i].INCUMPLIMIENTO_SLA +'</td>';
                total_incumplimiento_sla += parseInt(data[i].INCUMPLIMIENTO_SLA);
                table += '<td>' + data[i].PENDIENTES_POR_VALIDAR + '</td>';
                total_pendientes_por_validar += parseInt(data[i].PENDIENTES_POR_VALIDAR);
                table += '<td>'+ data[i].PENDIENTES_CLARO +'</td>';
                total_pendientes_claro += parseInt(data[i].PENDIENTES_CLARO);
                table += '</tr>';
            }                   
           
            table += '<tr>';
               table += '<td></td>';
               
               table += '<td>'+ truncateToDecimals((total_reportes_ejecutados / total_planificados) * 100).toFixed(2) +'</td>';
                
                table += '<td>'+ truncateToDecimals((total_reportes_cargados / total_planificados) * 100).toFixed(2) +'</td>';
                table += '<td>'+ truncateToDecimals((total_reportes_aceptados / total_planificados) * 100).toFixed(2) +'</td>';
                table += '<td>'+ truncateToDecimals((total_pendientes_por_validar / total_planificados) * 100).toFixed(2) +'</td>';
               // table += '<td></td>';
                table += '<td>' + total_planificados + '</td>';
                table += '<td>' + total_programados_en_sgp + '</td>';
                table += '<td>' + total_reportes_ejecutados + '</td>';
                table += '<td>' + total_reportes_aceptados + '</td>';
                table += '<td>' + total_reportes_cargados + '</td>';
                table += '<td>'+ total_reportes_rechazados +'</td>';
                 table += '<td>'+ total_incumplimiento_sla +'</td>'; 
                table += '<td>' + total_pendientes_por_validar + '</td>';
                table += '<td>'+ total_pendientes_claro +'</td>';
                table += '</tr>';           
           
            table += '</tbody></table><br />';
            
            $("#auditTable").empty().append(table);
          
        }
        </script>
{% endblock %}