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

{% block dashboard %}
    <link rel="stylesheet" href="{{ asset('datatables/css/dataTables.bootstrap.min.css')}}">
    <link rel="stylesheet" href="{{ asset('datatables/css/buttons.bootstrap.min.css')}}">
    <link rel="stylesheet" href="{{ asset('datatables/css/select.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}
        
        html,body {
            padding:10px;
            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: 10px;
        }
        .table th{
            font-size: 8pt;
        }
        .table td{
            font-size: 9pt;
        }
        table.tablesorter thead tr th, table.tablesorter tfoot tr th {
            color: #fff;
            background-color: #428bca;
            border: 2px solid #FFF;
            font-size: 8pt;
        }
            .btn-claro {
            color: #fff;
            background-color: #00569C;
            border-color: #3D59CA;
        }
        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
       }
        .btn-yellow {
            color: #fff;
            background-color: #000000;
            border-color: #ecea19;
        }
    
        
    </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 src="{{ asset('datatables/js/datatables.min.js') }}"></script>
    <script>

 $('html').on('click', '.openModal', open)

        /*function open() {

            var $modal = $('#myModal'),
                    $modalBody = $('#myModal .modal-body').empty();

            if ( $(this).text() == 0 ) return false;

            $modalBody.isLoading();
            generateModal( $(this).attr('data-load-remote') );
            $modal.modal('show');
        }*/


        function generateModal(ruta){
            $("#cantidad").html(0);
            $('#myModal .modal-body').empty();
            $.getJSON(ruta,function(data){

                if ( data.length === 0 ) {

                    $('#myModal').modal('hide');
                    $('#myModal .modal-body').isLoading('hide');
                    return false;
                }

                var monitor = data,
                        header = Object.keys( data[0] ),
                        table = '<table class="table table-hover table-condensed 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 class ='text-center'>" +  monitor[i][header[j]] +"</td>";
                    }
                    table += "</tr>";
                }

                table += "</table>";
                $("#cantidad").html(data.length);
                $('#myModal .modal-body').isLoading('hide').html(table);
            });

        }
        $("#cantidad").html(0);
        $('#myModal').on('hidden.bs.modal', function(){
            $('#myModal .modal-body').isLoading('hide');
        });
        
               function getTotal(valor,key)
            {
                var total = new Array();
                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 () {
                          
            window.pollingPeriod = 40000;
            window.progressInterval;

            window.progressInterval = setInterval(getReporte, window.pollingPeriod);
 
            
             $("#generar").click(function(){
                $.isLoading({
                    text:       "Loading"
                });
                  getReporte();
            });
   
              $("#clear").click(function(){ 
                $('#mes_progra').val("");
            });             

            $('#generar').trigger('click');
           
            
            //GRAFICA #6 ESTADO DE BATERIAS EN SITIO
  
            
            function getReporte(){
                
                data = {};
                data['mes'] = $("#mes").val();
            
                  $.getJSON('{{path('grafica_getBaterias')}}',data, function (data) {
                    
                    var datos  = data.datos;
                 
                    if(datos.length === 0){
                        
                        $("#sexta_grafica").empty();
                        $("#sexta_grafica").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                        $.isLoading("hide");
                        return false;
                        }
                        $.isLoading("hide");

                         var region = [];
                         var pequeño_buena = []; 
                         var pequeño_mala = [];
                         var mediano_buena = [];
                         var mediano_mala = [];
                         var gran_buena = [];
                         var gran_mala = [];
                         var total = [];
       
                        for (var i = 0; i < data.datos.length; i++) {
                        region.push(data.datos[i].region);
                        pequeño_buena.push(parseInt(data.datos[i].pequeño_buena));
                        pequeño_mala.push(parseInt(data.datos[i].pequeño_mala));
                        mediano_buena.push(parseInt(data.datos[i].mediano_buena));
                        mediano_mala.push(parseInt(data.datos[i].mediano_mala));
                        gran_buena.push(parseInt(data.datos[i].gran_buena));
                        gran_mala.push(parseInt(data.datos[i].gran_mala));
                        total.push(parseInt(data.datos[i].total));
                        }
                        
                     // Se declara los colores para las series
                    var colors = ['#08088A','#0080FF','#0000FF','#0489B1','#3D59CA','#7cb5ec']; 
                    
                    var sextaGraficaOpt = {
                   
                    chart: {
                        type: 'column', 
                        renderTo: 'sexta_grafica',
                        options3d:{
                            enabled: true,
                            alpha: 10,
                            beta: 10,
                            viewDistance: 85,
                            depth: 40
                          }
                        },
                        title: {
                            text: 'ESTADO DE BATERIAS EN SITIO'
                        },
                        subtitle: {
                            text: 'PWM: Graficas Maya - Guatemala'
                        },
                        xAxis: {
                        categories:region,
                        crosshair: true
                        },
                        yAxis: {
                            min: 0,
                            max: null,
                            allowDecimals: false,
                            title: {
                                text: 'Valores'
                            }
                        },
                        legend: {
                            align: 'right',
                            verticalAlign: 'top',
                            layout: 'vertical',
                            x: -30,
                            y: 25,
                            floating: true,
                            borderWidth: 1,
                            shadow: false
                        },
                        tooltip: {
                            headerFormat: '<span style="font-size:15px">{point.key}</span><table>',
                            pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' +
                                '<td style="padding:0"><b>{point.y:.0f}</b></td></tr>',
                            footerFormat: '</table>',
                            shared: false,
                            useHTML: true
                        },
                        plotOptions: {
                    series: {
                    cursor: 'pointer',
                    borderWidth: 0,
                    dataLabels: {
                        enabled: true,
                    },
                     point: {
                        events: {
                            click: function(e) {  
                               /* console.log(this);
                                var region = e.currentTarget.category;
                                var porte = this.series.name,
                                estado = porte.replace(/estado/, '').trim().replace(/s$/i, '');
                                mes = $("#mes").val(),

                                $('#myModal .modal-body').empty().isLoading();
                                generateModal('{{ path('grafica_reporteDetalleBateriasxRegion')}}?region=' + region + '&porte=' + estado + '&mes=' + mes);
                                $('#myModal').modal('show');*/
                                }
                            }
                        }
                    }
                }, 
                    series: [{ 
                       name: '{{"Pequeño Porte" | trans}} - Bat: Buen Estado',
                       data: pequeño_buena,
                       color: colors[0]
                    },{
                       name: '{{"Pequeño Porte" | trans}} - Bat: Degradadas',
                       data: pequeño_mala,
                       color: colors[1]
                    },{
                       name: '{{"Mediano Porte" | trans}} - Bat: Buen Estado',
                       data: mediano_buena,
                       color: colors[2]
                    },{
                       name: '{{"Mediano Porte" | trans}} - Bat: Degradadas',
                       data: mediano_mala,
                       color: colors[3]
                    },{
                       name: '{{"Gran Porte" | trans}} - Bat: Buen Estado',
                       data: gran_buena,
                       color: colors[4]
                    },{
                       name: '{{"Gran Porte" | trans}} - Bta: Degradadas',
                       data: gran_mala,
                       color: colors[5]
                    }]                  
                       };
                    var chart6 = new Highcharts.Chart(sextaGraficaOpt);

                    });

                }
                        
         });
   
    </script>

    
    <div class="page-header text-center text-muted">
    <!-- <h1 class="eri-font">CAR & CA </h1>  -->
    </div>

    <div class="container-fluid eri-font"> 
     <div class="row">
            <div class="col-lg-2 pull-right">
                <img id="logo" src="{{ asset('images/telefonica.png') }}"  width="300" height="65">
                <p class="text-center" style="font-size: 14pt;font-weight: bold;"></p>
            </div>
           <div class="col-lg-2">
                 <label>{{'monitoriii.month' | trans}}:</label>  
                <select class="form-control" id="mes">
                    <option value="JUNIO">{{'month.june' | trans}}</option>  
                    <option value="MAYO">{{'month.may' | trans}}</option>
                </select>
       </div>
            <div class="col-lg-4" id="parametros"><br>
               <button class="btn btn-claro" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>&nbsp&nbsp
               <button class="btn btn-claro" id="clear">{{'ticketDetail.boton.limpiar' | trans}}</button>
            </div>      
         </div>
     </div><br><br>

    <!--GRAFICA -->       
                <div class="col-lg-12 eri-font"  id="sexta_grafica">
        </div><br><br>
     
 <!-- Modal -->
<div class="modal" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog modal-lg" role="document">
        <div class="modal-content" style=" width:110%;">
            <div class="modal-header ">
                <!--<div class="col-lg-3 eri-font"  style="margin-top: 1%">
                    Cantidad :<span id="cantidad" class="bold"></span>
                 </div>-->
                
            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button><br><br>  
             <div class="btn-group pull-right">
                    <button class="btn btn-claro 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="$('#myModal').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="15px"> XLS</a></li>


                    </ul>
                </div>
            
            <h2 class="modal-title text-center eri-font" id="myModalLabel"><strong>{{ 'monitorii.detail' | trans }}</strong></h2>
            </div>
            <div class="modal-body eri-font top-uno">
              
            </div>
            
            <div class="modal-footer">
            <button type="button" class="btn btn-claro eri-font" data-dismiss="modal">
                {{ 'monitorii.close' | trans }}
                <span class="glyphicon glyphicon-remove"></span>
            </button>
            </div>
        </div>
    </div>
</div>   

  
{% endblock %}