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

{% endblock %}

{% block stylesheets %}
    <link rel="stylesheet" href="{{ asset('datatables/css/dataTables.bootstrap.min.css')}}">
    <link rel="stylesheet" href="{{ asset('datatables/css/buttons.bootstrap.min.css')}}">
    <style>
        @font-face {font-family: ericsson; src: url({{ asset('fonts/ericsson.ttf') }})}
        table {font-size: 12px}
        #menuTop {margin-top: 0px}
        .cell-danger{background-color: #da5c58}
        .cell-success{background-color: #5cb85c}
        .eri-font {font-family: ericsson}
    </style>
{% endblock %}
{% block dashboard %}
    <style>
        .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:45%;}
        .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);}
        }

        .table-responsive {
            height: 400px !important;
            overflow: scroll;
        }


        .btn-claro {
            color: #fff;
            background-color: #00569C;
            border-color: #3D59CA;
        }
        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
       }

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

       .btn-yellow {
            background-color: #ffff0c;
            color: #000000;
            background-image: -moz-linear-gradient(top, #ecea19, #ecea19);
            background-image: -ms-linear-gradient(top, #ecea19, #ecea19);
            background-image: -webkit-gradient(linear, 0 0, 0 100%, from(#ecea19), to(#ecea19));
            background-image: -webkit-linear-gradient(top, #ecea19, #ecea19);
            background-image: -o-linear-gradient(top, #ecea19, #ecea19);
            background-image: linear-gradient(top, #ecea19, #ecea19);
            background-repeat: repeat-x;
            filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#'78cd51, endColorstr='#'5AAD34, GradientType=0);
            border-color: #ecea19 #ffff0c #ecea19;
            border-color: rgba(0, 0, 0, 0.1) rgba(0, 0, 0, 0.1) rgba(0, 0, 0, 0.25);
            filter: progid:DXImageTransform.Microsoft.gradient(enabled = false);
        }
        .btn-yellow {
            color: #fff;
            background-color: #000000;
            border-color: #ecea19;
        }

        .col-lg-12{
            padding-left: 5px;
        }

        #menuTop { margin-top: 15px; }

        hr { width: 75%; margin: auto; margin-top: 20px; margin-bottom: 20px;}

        ._hr { display: none; }

    </style>

    <div class="container">
        <!--<img id="logo" class="pull-right" src="{{ asset('images/LogoTIGO.png') }}"  width="220" height="72" >-->
        {%if idproyectos == 39 %}
        <img id="logo" class="pull-right" src="{{ asset('images/LogoTIGO.png') }}"  width="220" height="72" />
        {%else%}
        <img id="logo" class="pull-right" src="{{ asset('images/telefonica.png') }}"  width="220" height="72" />
        {%endif%}
        <div class="page-header text-center text-muted">
             <h1 class="eri-font"> {{ 'MP PLANIFICADOS VS EJECUTADOS'|trans }}</h1>
        </div>

        <div class="row">
            <div class="col-lg-2 eri-font" >
                <label>{{'monitores.pais' | trans}} </label>
                <select class="form-control" id="filtro_pais">
                {%   if idproyectos == 75 %}
                    <option value="31">GUATEMALA</option>
                    <option value="38">EL SALVADOR</option>
                {%   elseif idproyectos == 39 %}
                    <option value="39">NICARAGUA</option>
                {% endif %}
                </select>
            </div>



        </div>


        <div class="row">
           <div class="col-lg-2 eri-font top-uno">
                <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>
                <input type="text" class="form-control" id="Filtros_fechaIni" value="{{ dateStart }}">
            </div>
            <div class="col-lg-2 eri-font top-uno">
                <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>
                <input type="text" class="form-control" id="Filtros_fechaFin" value="{{ dateEnd }}">
            </div>
           <!--    <div class="col-lg-2"  style="margin-top: 1%">
                <label>Región: </label>
                <select  id="region">
                    <option value="TODOS">TODOS</option>
                    {#for region in regiones%}
                        <option value="{{region.valor}}">{{region.nombre}}</option>
                    {%endfor#}
                </select>
            </div>
         <div class="col-lg-2"  style="margin-top: 1%">
                 <label>Visita: </label>
                 <select  id="visita">
                    <option value="TODOS">TODOS</option>
                    <option value="1">SIN VISITA</option>
                    <option value="0">CON VISITA</option>
                </select>
            </div> -->
            <br>
            <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>
        </div>


        <div class="row" style="padding-bottom: 1%">
            <div class="col-lg-12 text-center eri-font" id="chart1"></div>
            <div class="col-lg-12 text-center eri-font" id="chart2"></div>
            <div class="col-lg-12 text-center eri-font" id="chart3"></div>
        </div>
       <!-- <div class="col-lg-offset-9"  style="margin-top: 1%">
            <div class="btn-group pull-right">
                <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="$('#primer_reporte').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                </ul>
            </div>
        </div>
        <div class="row" style="margin-bottom: 40px;">
            <div class="col-lg-12" id="primer_reporte" style="margin-top: 1%; font-size: 13px;"></div>
        </div>
        -->
    </div>

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

        var translation = {
        };

        $(function () {

            var $btnGenerar = $("#generar"),
                $btnClear   = $("#clear");

            loading(1);
            reporteBateria();

                $btnGenerar.click(function(){
                    loading(1);
                    reporteBateria();
                });

            $('#Filtros_fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function( selectedDate ) {
                    $('#Filtros_fechaFin').datepicker( "option", "minDate", selectedDate );
                }
            });

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

            $btnClear.click(function(){
                $dateStart.val("");
                $dateEnd.val("");
            });
        });

        function loading(value){

            if ( value === 1 ) { $.isLoading({ text: "Loading" }); } else { $.isLoading("hide"); }

        }

        function reporteBateria(){

            var $dateStart  = $('#Filtros_fechaIni'),
                $dateEnd    = $('#Filtros_fechaFin'),
                data = {};

            data['fechaIni']    = $dateStart.val();
            data['fechaFin']    = $dateEnd.val();
            data['idproyectos'] = {{idproyectos}};
            data['filtro_pais'] = $("#filtro_pais").val();

            $.getJSON('{{path('reportemsmaya_reportePP')}}', data, function (data) {

                var bateria     = data.bateria,
                    daysGraph     = data.daysGraph,
                    mDataGraph  = data.monthGraph,
                    month_porteGraph = data.month_porteGraph;

                if (daysGraph.length>0){
                    var categoria1 = getDataToObject(daysGraph,Object.keys(daysGraph[0]),0,false);
                    var chart1 = getDataToObjectBar(daysGraph,Object.keys(daysGraph[0]));
                }

                if (mDataGraph.length>0){
                    $("#_planed").html(mDataGraph[0]['PROGRAMADOS']);
                    $("#_done").html(mDataGraph[0]['EJECUTADOS']);
                    var categoria2 = getDataToObject(mDataGraph,Object.keys(mDataGraph[0]),0,false);
                    var chart2 = getDataToObjectBar(mDataGraph,Object.keys(mDataGraph[0]));
                }

                if (month_porteGraph.length>0){
                    var categoria3 = getDataToObject(month_porteGraph,Object.keys(month_porteGraph[0]),0,false);
                    var chart3 = getDataToObjectBarPisicina(month_porteGraph,Object.keys(month_porteGraph[0]));
                }


                if (daysGraph.length>0)
                    createChart('chart1',categoria1,chart1,'{{"Preventivos Diarios" | trans}}');
                else {
                    $("#chart1").empty();
                    $("#chart1").append('<div class="alert alert-warning" role="alert">NO EXISTEN MP PROGRAMADOS/EJECUTADOS EN EL RANGO DE FECHA SELECCIONADO</div>');
                }

                if (mDataGraph.length>0)
                    createChart('chart2',categoria2,chart2,'{{"Preventivos Mensual" | trans}}');
                else {
                    $("#chart2").empty();
                    $("#chart2").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                }

                if (month_porteGraph.length>0)
                    createChartPiscina('chart3',categoria3,chart3,'{{"Preventivos Mensual Porte" | trans}}');
                else {
                    $("#chart3").empty();
                    $("#chart3").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                }

              /*  if ( bateria.length == 0 ) {

                    $("#primer_reporte").empty();
                    $("#primer_reporte").append('<div class="alert alert-warning" role="alert">NO EXISTEN MP PROGRAMADOS/EJECUTADOS EN EL RANGO DE FECHA SELECCIONADO</div>');
                    loading(0);
                    return false;

                }else $("#primer_reporte").empty().append(createTable(bateria));          */

                loading(0);
            });
       }

        function createTable(monitor,total,nombreColTotal){

            var header = Object.keys(monitor[0]);
            var table = '<table  class="table table-bordered table-hover table-striped table-responsive"> <thead>' +

                    '<tr class="btn-claro">';

            for (var j = 0; j < header.length; j++) {

                 if(header[j] != 'CLASS'){
                table += "<th style='vertical-align:middle;' class='text-center'>" + header[j] + "</th>"
                }

            }
            table += "</tr></thead>";

            for (var i = 0; i < monitor.length; i++) {
                table += "<tr id="+monitor[i]['ID']+">";
                for (var j = 0; j < header.length; j++) {
                    table += "<td >" + monitor[i][header[j]]  + "</td>";
                }

                table += "</tr>";

                if(typeof total !== "undefined") {

                    if (i == monitor.length - 1) {

                        var headerTotal = Object.keys(total);
                table += '<tr><td>' + nombreColTotal +'</td>';

                        for(var x=0; x<headerTotal.length;x++){
                            table += '<td>';
                                table += total[headerTotal[x]];

                            table += '</td>';

                        }
                        table += '</tr>';
                    }
                }
            }
            table += "</table>";

            return table;
        }

        function color2Table(_table, indice, str, color) {
            /*
             *  Para colorear tablas (Parametros):
             *  1. ID de tabla (selector).
             *  2. Indice a colorear.
             *  3. Valor de búsqueda a colorear.
             *  4. HEX de Color.
             */
            var lenTable    = $("#" + _table + " > tbody tr" ).length,
                $auxTd;

            for ( var i = 0; i < lenTable; i++ ) {

                $auxTd = $("#" + _table + " > tbody > tr:eq(" + i + ") > td:eq(" + indice + ")");

                if ( $auxTd.html() == str ) {

                    $auxTd.attr("bgColor", color);

                }
            }
        }

        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[1]])); //planificados
                data2.push(parseFloat(data[i][header[2]])); //ejecutados
                data3.push(parseFloat(data[i][header[3]])); //productividad
            }

            arrayReturn.push({'name': header[1], 'data': data1,'type':'column','yAxis':1,'dataLabels':{'enabled':true}});
            arrayReturn.push({'name': header[2], 'data': data2,'type':'column','yAxis':1,'dataLabels':{'enabled':true}});
            arrayReturn.push({'name': header[3], 'data': data3,'type':'spline'}) ;

            return arrayReturn;
        }

        function getDataToObjectBarPisicina(data,header)
        {
            var arrayReturn = new Array();
            var programado_GP = new Array();
            var programado_MP = new Array();
            var programado_PP = new Array();
            var ejecutado_GP = new Array();
            var ejecutado_MP = new Array();
            var ejecutado_PP = new Array();

            for(var i = 0; i< data.length; i++){
                programado_GP.push(parseFloat(data[i][header[1]]));
                programado_MP.push(parseFloat(data[i][header[2]]));
                programado_PP.push(parseFloat(data[i][header[3]]));
                ejecutado_GP.push(parseFloat(data[i][header[4]]));
                ejecutado_MP.push(parseFloat(data[i][header[5]]));
                ejecutado_PP.push(parseFloat(data[i][header[6]]));
            }

            arrayReturn.push({'name': 'P GRAN PORTE', 'data': programado_GP,'yAxis':1,'dataLabels':{'enabled':true},'stack':'programado'});
            arrayReturn.push({'name': 'P MEDIANO PORTE', 'data': programado_MP,'yAxis':1,'dataLabels':{'enabled':true},'stack':'programado'});
            arrayReturn.push({'name': 'P PEQUEÑO PORTE', 'data': programado_PP,'yAxis':1,'dataLabels':{'enabled':true},'stack':'programado'});
            arrayReturn.push({'name': 'E GRAN PORTE', 'data': ejecutado_GP,'yAxis':1,'dataLabels':{'enabled':true},'stack':'ejecutado'});
            arrayReturn.push({'name': 'E MEDIANO PORTE', 'data': ejecutado_MP,'yAxis':1,'dataLabels':{'enabled':true},'stack':'ejecutado'});
            arrayReturn.push({'name': 'E PEQUEÑO PORTE', 'data': ejecutado_PP,'yAxis':1,'dataLabels':{'enabled':true},'stack':'ejecutado'});

            return arrayReturn;
        }

        function createChart(render,categoria,data,title){
            var options = {
                chart: {
                    renderTo: render,
                  },
                title: {
                    text: title
                },
                xAxis: {
                    categories: categoria,
                    title: {
                        text: null
                    },
                    labels: {
                        rotation: -45,
                        style: {
                            fontSize: '12px',
                            fontFamily: 'Verdana, sans-serif'
                        }
                    }
                },
                yAxis: [{
                    min: 0,
                    max: 110,
                    title: {
                        text: ''
                    },
                    plotLines: [{
                        value: 0,
                        width: 1,
                        color: '#808080'
                    }]
                  },{
                    title: {
                        text: ''
                    },
                    min:0,
                    opposite: true
                    }, {
                    title: {
                        text: ''
                    },
                    min:0,
                    opposite: true
                    }],
                legend: {
                    reversed: true
                },
                colors: [
                         '#a1c517','#0082b6','#b88fef','#009045','#db004f'
                        ],
                series: data
            };

            return $('#' +render).highcharts(options);
        }

        function createChartPiscina(render,categoria,data,title){
            var options = {
                chart: {
                    renderTo: render,
                    type: 'column'
                },
                title: {
                    text: title
                },
                xAxis: {
                    categories: categoria,
                    title: {
                        text: null
                    },
                    labels: {
                        rotation: -45,
                        style: {
                            fontSize: '12px',
                            fontFamily: 'Verdana, sans-serif'
                        }
                    }
                },
                yAxis: [{
                    min: 0,
                    max: 100,
                    title: {
                        text: ''
                    },
                    plotLines: [{
                        value: 0,
                        width: 1,
                        color: '#808080'
                    }]
                },{
                    title: {
                        text: ''
                    },
                    min:0,
                    opposite: true
                }, {
                    title: {
                        text: ''
                    },
                    min:0,
                    opposite: true
                }],
                legend: {
                    reversed: true
                },
                plotOptions: {
                    series: {
                        cursor: 'pointer',
                        borderWidth: 0,
                        stacking: 'normal',
                        depth: 60,
                        dataLabels: {
                            enabled: true,
                            color: (Highcharts.theme && Highcharts.theme.dataLabelsColor) || 'white'
                        }
                    }
                },
                colors: [
                    '#5e720d', '#84a013', '#a9cd18', '#00374d', '#005b80' , '#0080b3'
                ],
                series: data
            };

            return $('#' +render).highcharts(options);
        }

        function translate(translation,table){

            var translationHeader = Object.keys(translation);

            for ( var i = 0; i < translationHeader.length; i++ ) {

                table = table.replace(translationHeader[i],translation[translationHeader[i]]);

            }

            return table;
        }

        function ISO8601_week_no(dt) {

            var tdt = new Date(dt.valueOf());
            var dayn = (dt.getDay() + 6) % 7;
            tdt.setDate(tdt.getDate() - dayn + 3);
            var firstThursday = tdt.valueOf();
            tdt.setMonth(0, 1);

            if (tdt.getDay() !== 4) {
                tdt.setMonth(0, 1 + ((4 - tdt.getDay()) + 7) % 7);
            }
            return 1 + Math.ceil((firstThursday - tdt) / 604800000);
        }


    </script>
{% endblock %}