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

{% endblock %}


{% block dashboard %}
    <style>
        html,body {
            padding:0;
            margin:0;
            height:100%;
        }




    table td{
        font-size: 10px;
    }
        .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);}
        }
    </style>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script>
        window.pollingPeriod = 400000;
        window.progressInterval;

        window.progressInterval = setInterval(getReporte, window.pollingPeriod);

        $.isLoading({
            text:       "Loading"


        });
        $(function () {

            var d = new Date();
            var month = new Array();
            month[0] = "ENERO";
            month[1] = "FEBRERO";
            month[2] = "MARZO";
            month[3] = "ABRIL";
            month[4] = "MAYO";
            month[5] = "JUNIO";
            month[6] = "JULIO";
            month[7] = "AGOSTO";
            month[8] = "SEPTIEMBRE";
            month[9] = "OCTUBRE";
            month[10] = "NOVIEMBRE";
            month[11] = "DICIEMBRE";
            var n = month[d.getMonth()];
            var options = new Array();
            for(var i=0;i<month.length;i++){

                if(i <=  d.getMonth()){

                    options.push( );

                    $('#mes').append($("<option/>", {
                        value: i + 1,
                        text: month[i]
                    }));

                }
            }


            $("#tipoBusqueda").change(function(){

                $(this).val() == 'mes' ? $("#mes").removeAttr('class','hide'):$("#mes").addClass('hide');
            });



            getReporte();

            $("#generar").click(function(){
                $.isLoading({
                    text:       "Loading"


                });
                        getReporte();

            });

        });

        function getReporte(){
            var statusGeneral = [{"STATUS GENERAL": "SITIOS INSTALADOS", "SUPERVISION REMOTA": 0, "SUPERVISION CAMPO": 0},
                {"STATUS GENERAL": "SITIOS EN PROCESO", "SUPERVISION REMOTA": 0, "SUPERVISION CAMPO": 0},
                {"STATUS GENERAL": "SITIOS SUSPENDIDOS", "SUPERVISION REMOTA": 0, "SUPERVISION CAMPO": 0}]
                data = {};
                var tipo  = $("#tipoBusqueda").val();

                switch (tipo){
                    case 'semana':
                        break;
                    case 'mes':
                            data = {'mes' : $("#mes").val()}
                        break;
                    case 'ano':
                        data = {'ano' : 'now'}
                        break;
                }
            $.getJSON('{{path('reportemexico_reporteGeneral')}}',data, function (data) {
                var monitor = data.monitor;
                var status = data.status;
                var documentacion = data.documentacion;
                var leadTime = data.leadtimeMonth;
                if(monitor.length == 0){

                    $("#primer_reporte").empty();
                    $("#primer_reporte").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                    $.isLoading("hide");
                    return false;
                }

                var graficaAux = new Array();
                var graficaAux2 = new Array();
                for(var i =0; i<status.length;i++){

                    if(status[i]['STATUS GENERAL'] == 'SITIOS INSTALADOS'){
                        statusGeneral[0]["SUPERVISION CAMPO"] = parseInt(status[i]["SUPERVISION CAMPO"]);
                        statusGeneral[0]["SUPERVISION REMOTA"] = parseInt(status[i]["SUPERVISION REMOTA"]);

                    }

                    if(status[i]['STATUS GENERAL'] == 'SITIOS EN PROCESO') {
                        statusGeneral[1]["SUPERVISION CAMPO"] = parseInt(status[i]["SUPERVISION CAMPO"]);
                        statusGeneral[1]["SUPERVISION REMOTA"] = parseInt(status[i]["SUPERVISION REMOTA"]);

                    }
                    if(status[i]['STATUS GENERAL' ]== 'SITIOS SUSPENDIDOS'){
                        statusGeneral[2]["SUPERVISION CAMPO"] = parseInt(status[i]["SUPERVISION CAMPO"]);
                        statusGeneral[2]["SUPERVISION REMOTA"] = parseInt(status[i]["SUPERVISION REMOTA"]);

                    }
                }

                var total2 = getTotal(status,[1,2]);
                var total1 = getTotal(monitor,[1]);
                graficaAux[0] = statusGeneral[0]["SUPERVISION CAMPO"];
                graficaAux[1] = statusGeneral[1]["SUPERVISION CAMPO"];
                graficaAux[2] = statusGeneral[2]["SUPERVISION CAMPO"];
                graficaAux[3] = total2[2];
                graficaAux2[0] = statusGeneral[0]["SUPERVISION REMOTA"];
                graficaAux2[1] = statusGeneral[1]["SUPERVISION REMOTA"];
                graficaAux2[2] = statusGeneral[2]["SUPERVISION REMOTA"];
                graficaAux2[3] = total2[1];
                var categories = new Array();
                var ltsr = new Array();
                var ltsc = new Array();
                for(var k = 0; k<leadTime.length; k++){

                    categories.push(leadTime[k]['MONTH']);
                    ltsr.push(parseFloat(leadTime[k]['LT SR'],2));
                    ltsc.push(parseFloat(leadTime[k]['LT SC'],2));
                }


                var primeraGraficaOpt = {
                    chart: {
                        type: 'pie',
                        renderTo: 'primera_grafica',
                        options3d: {
                            enabled: true,
                            alpha: 45,
                            beta: 0
                        }
                    },
                    title: {
                        text: '% DE ACTIVIDADES TRABAJADAS'
                    },
                    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.percentage:.1f} %',
                                style: {
                                    color: (Highcharts.theme && Highcharts.theme.contrastTextColor) || 'black'
                                }

                            }

                        }
                    },
                    series: [{
                        type: 'pie',
                        name: 'Browser share',
                        data: [



                        ]
                    }]
                };
                var segundaGraficaOpt = {
                    chart: {
                        type: 'column',
                        renderTo: 'segunda_grafica',
                        options3d: {
                            enabled: true,
                            alpha: 15,
                            beta: 15,
                            viewDistance: 25,
                            depth: 40
                        }
                    },

                    title: {
                        text: 'ESTATUS ACTUAL RSC'
                    },

                    xAxis: {
                        categories: ['SITIOS INSTALADOS','SITIOS EN PROCESO','SITIOS SUSPENDIDOS','ACUMULADO DE SITIOS']
                    },

                    yAxis: {
                        allowDecimals: false,
                        min: 0,
                        title: {
                            text: 'Number of Sites'
                        }
                    },

                    tooltip: {
                        headerFormat: '<b>{point.key}</b><br>',
                        pointFormat: '<span style="color:{series.color}">\u25CF</span> {series.name}: {point.y} / {point.stackTotal}'
                    },

                    plotOptions: {
                        column: {
                            stacking: 'normal',
                            depth: 40,
                            dataLabels: {
                                enabled: true
                            }
                        }
                    },

                    series: [{
                        name: 'SITE CSR',
                        data: graficaAux2,

                    }, {
                        name: 'SITE SUP. CAMPO',
                        data: graficaAux,
                        color: '#FE0909'
                    }]
                };
                var cuartaGraficaOpt ={
                    chart: {
                        type: 'line',
                        renderTo: 'cuarta_grafica'
                    },
                    title: {
                        text: 'LEAD TIME'
                    },

                    xAxis: {
                        categories: categories
                    },
                    yAxis: {
                        min: 4,
                        max: 10,
                        title: {
                            text: 'LEADTIME'
                        },
                        plotLines:[{
                            value:5,
                            color :'#90ed7d',
                            dashStyle:'ShortDot',
                            width:5,
                            zIndex:4,
                            label:{text:'LEADTIME (5)'}
                        }]
                    },
                    plotOptions: {
                        line: {
                            dataLabels: {
                                enabled: true
                            },
                            enableMouseTracking: false
                        }
                    },
                    series: [{
                        name: 'LT SR',
                        data: ltsr
                    }, {
                        name: 'LT SC',
                        data: ltsc,
                        color: '#FE0909'
                    }]
                };

                var chart = new Highcharts.Chart(primeraGraficaOpt);
                chart.series[0].setData([{
                    name: 'SUPERVISION REMOTA',
                    y: parseInt(monitor[1]['SITES']),
                    sliced: true,
                    selected: true
                },
                    {
                        name: 'SUPERVISION CAMPO',
                        y: parseInt(monitor[0]['SITES']),
                        sliced: true,
                        selected: true,
                        color: '#FE0909'
                    }]);


                var chart2 = new Highcharts.Chart(segundaGraficaOpt);
                var chart4  = new Highcharts.Chart(cuartaGraficaOpt);
               // var chart5  = new Highcharts.Chart(quintaGraficaOpt);

                $("#primer_reporte").empty();
                $("#primer_reporte").append(createTable(monitor,total1,'TOTAL'));
                $("#segundo_reporte").empty();
                $("#segundo_reporte").append(createTable(statusGeneral,total2,'TOTAL'));
                $("#cuarto_reporte").empty();
                $("#cuarto_reporte").append(createTable(leadTime));
                if(documentacion.length != 0){
                    var total5 = getTotal(documentacion,[1,2]);
                    var quintaGraficaOpt = {
                        chart: {
                            type: 'column',
                            renderTo: 'quinta_grafica',
                            options3d: {
                                enabled: true,
                                alpha: 15,
                                beta: 15,
                                viewDistance: 25,
                                depth: 40
                            }
                        },

                        title: {
                            text: 'DOCUMENTACION'

                        },

                        xAxis: {
                            categories: ['SITIOS DOCUMENTACION COMPLETA','SITIOS DOCUMENTACION INCOMPLETA','SITIOS TERMINADOS']
                        },

                        yAxis: {
                            allowDecimals: false,
                            min: 0,
                            title: {
                                text: 'Documentacion'
                            }
                        },

                        tooltip: {
                            headerFormat: '<b>{point.key}</b><br>',
                            pointFormat: '<span style="color:{series.color}">\u25CF</span> {series.name}: {point.y} / {point.stackTotal}'
                        },

                        plotOptions: {
                            column: {
                                stacking: 'normal',
                                depth: 40,
                                dataLabels: {
                                    enabled: true
                                }
                            }
                        },

                        series: [{
                            name: 'CSR',
                            data: [parseInt(documentacion[0]['CSR']),parseInt(documentacion[1]['CSR']),parseInt(total5[1])],

                        }, {
                            name: 'SUP.CAMPO',
                            data: [parseInt(documentacion[0]['SUP.CAMPO']),parseInt(documentacion[1]['SUP.CAMPO']),parseInt(total5[2])],
                            color: '#FE0909'
                        }]
                    };
                    var chart5  = new Highcharts.Chart(quintaGraficaOpt);
                    $("#quinto_reporte").empty();
                    $("#quinto_reporte").append(createTable(documentacion,total5,'SITIOS TERMINADOS'));
                }




                $.isLoading("hide");
            });

        }

        function getTotal(valor,key)
        {
            var total = new Array();
            /*total[1] = 0;
            total[2] = 0;*/
            var header = Object.keys(valor[0]);


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

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

                        if(typeof total[key[j]] === "undefined"){

                            total[key[j]] = 0;
                        }

                        total[key[j]] +=  parseInt(valor[i][header[key[j]]]);

                    }


                }
            return total;
        }

        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-info">';

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


                table += "<th class='text-center'>" + header[j] + "</th>"



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

            for (var i = 0; i < monitor.length; i++) {
                table += "<tr>";
                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;
        }





    </script>

    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-4" id="parametros" style="margin-top: 1%">

                <select class="form-control" id="tipoBusqueda">
                    <option value="semana">{{'monitor.week' | trans}}</option>
                    <option value="mes">{{'monitoriii.month' | trans}}</option>
                    <option value="ano">{{'monitoriii.year' | trans}}</option>

                </select>
            </div>
            <div class="col-lg-4" id="parametros" style="margin-top: 1%">
                <select class="hide" id="mes">



                </select>
            </div>

            <div class="col-lg-4" id="parametros" style="margin-top: 1%">
                <div class="col-lg-4">
               <button class="btn btn-primary" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
                    </div>
                <div class="col-lg-8">
                    <img id="logo" src="{{ asset('images/telcel.png')  }}"  width="300" height="65">
                    <p class="text-center" style="font-size: 14pt;font-weight: bold;">ONE RAN</p>
                </div>
            </div>


        </div>
        <div class="row">


            <div class="col-lg-6">

                <div class="col-lg-8" id="primera_grafica">

                </div>
                <div class="col-lg-4" id="primer_reporte">

                </div>
            </div>
            <div class="col-lg-6">

                <div class="col-lg-6" id="segunda_grafica">

                </div>
                <div class="col-lg-6" id="segundo_reporte">

                </div>

            </div>

        </div>
        <div class="row">
            <div class="col-lg-6">

                <div class="col-lg-8" id="cuarta_grafica">

                </div>
                <div class="col-lg-4" id="cuarto_reporte">

                </div>
            </div>
            <div class="col-lg-6">

                <div class="col-lg-7" id="quinta_grafica">

                </div>
                <div class="col-lg-5" id="quinto_reporte">

                </div>


            </div>
        </div>
    </div>
{% endblock %}