{% 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);}
        }
        .col-lg-12{

            padding-left: 5px;
        }
        .table th{
            font-size: 8pt;
        }
        .table td{
            font-size: 8pt;
        }
        .table>thead>tr>th, .table>tbody>tr>th, .table>tfoot>tr>th, .table>thead>tr>td, .table>tbody>tr>td, .table>tfoot>tr>td {
            padding: 4px;
            line-height: 1.42857143;
            vertical-align: top;
            border-top: 1px solid #ddd;
        }
        hr {
            width: 95%;
            margin:1%;
        }
    </style>
    <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>



        $(function () {

            window.pollingPeriod = 200000;
            window.progressInterval;

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

            getReporte();

        function getReporte(){

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

                var detalle = data.detalle;
                var capture = data.captureDetalle;
                var captureResumen = data.captureResumen;
                var header = Object.keys(captureResumen[0]);
                console.log(header);
                var serie =[];
                var plan = [];
                var data = [];
                for(var i = 0; i < captureResumen.length; i++) {
                    var data = [];
                    for (var j = 1; j < header.length; j++) {
                            if(captureResumen[i]['STATUS'] == 'PLAN'){

                                if(header[j] != 'TOTAL'){
                                    plan.push(parseInt(captureResumen[i][header[j]]));
                                }


                            }else{
                               ///;
                                if(header[j] != 'TOTAL'){
                                    //serie[i-1]['data'][j-1] = parseInt(captureResumen[i][header[j]]);
                                    data.push(parseInt(captureResumen[i][header[j]]));


                                    if((header.length -2) == j){


                                        serie[i-1] = {'name' : captureResumen[i]['STATUS'],type: 'column',data:data}

                                    }
                                }
                            }

                    }
                }


                serie.push({
                    type: 'spline',
                    name: 'PLAN',
                    data: plan,
                    marker: {
                        lineWidth: 2,
                        lineColor: Highcharts.getOptions().colors[3],
                        fillColor: 'white'
                    }
                })

                $("#captureResumen table").remove();
                $("#captureResumen").append(createTable(captureResumen,getTotal(captureResumen,[1,2,3,4,5,6,7]),'TOTAL'));
                $("#capture table").remove();
                $("#capture").append(createTable(capture,undefined,''));
                $("#detalle table").remove();
                $("#detalle").append(createTable(detalle,undefined,''));


                $('#grafica').highcharts({
                    title: {
                        text: 'REGION PLAN'
                    },
                    xAxis: {
                        categories: ['Region 1', 'Region 2', 'Region 3', 'Region 4', 'Region 6','Region 9']
                    },
                    labels: {
                        items: [{
                            html: '',
                            style: {
                                left: '50px',
                                top: '18px',
                                color: (Highcharts.theme && Highcharts.theme.textColor) || 'black'
                            }
                        }]
                    },
                    plotOptions: {
                        column: {
                            stacking: 'normal',
                            depth: 40,
                            dataLabels: {
                                enabled: true
                            }
                        }
                    },
                    series: serie
                });

            });

        }

        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="bg-primary">';

            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-offset-10">
                    <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 class="row">


            <div class="col-lg-8 col-lg-offset-2" id="captureResumen">



            </div>



        </div>

        <div class="row">


            <div class="col-lg-8 col-lg-offset-2" id="grafica">



            </div>



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


            <div class="col-lg-6" id="capture">
                <h1>SITIOS PLAN DIA</h1>


            </div>
            <div class="col-lg-6" id="detalle">
                <h1>AVANCES SITIOS PLAN</h1>


            </div>


        </div>

    </div>
{% endblock %}