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

{% 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{position: absolute;display: block;top: 50%;left: 50%;}
        .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);}
        }
        .btn-claro {
            color: #fff;
            background-color: #00569C;
            border-color: #3D59CA;
        }
        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
        }
        .table-responsive {
            height: 400px !important;
            overflow: scroll;
        }
        .btn-yellow {
            color: #fff;
            background-color: #000000;
            border-color: #ecea19;
        }
        .table th{
            font-size: 8pt;
        }
        .table td{
            font-size: 8pt;
        }         
    </style>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <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>
        var translation = {

        };

        $(function () {
            $("#generar").click(function(){
                $.isLoading({
                    text:       "Loading"
                });
                    $("#cantidad").html(0);  
                    reporteBateria();
            });

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

                    }
            }); 

            $('#Filtros_fechaFin').datepicker({
                    dateFormat: 'yy-mm-dd',
            });
            
            $("#clear").click(function(){
                $("#region").val("TODOS");      
                $("#criticidad").val("TODOS");      
                $('#Filtros_fechaIni').val("");
                $('#Filtros_fechaFin').val("");  
                $('#porte').val("TODOS");                  
            });
            
            $('#generar').trigger('click');
        });

        function reporteBateria(){

            var data={};
            data['region'] = $("#region").val();
            data['criticidad'] = $("#criticidad").val();      
            data['porte'] = $("#porte").val();  
            data['fechaIni'] = $("#Filtros_fechaIni").val();  
            data['fechaFin'] = $("#Filtros_fechaFin").val();            

            $.getJSON('{{path('reportemsguatemala_reporteMpMedicionBateria')}}', data, function (data) {
                console.log(data);
                var bateria  = data.bateria;

                if(bateria.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;

                }
                $("#cantidad").html(bateria.length);
                $("#primer_reporte").empty().append(createTable(bateria));

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

        function getDetallePrimerReporte(site) {

            var data = { sitio: site },
                ruta = '{{path('reportemsguatemala_reporteDetalleMpMedicionBateria')}}';

                generateModal( ruta, data );
        }

        function getTotal(valor,key,tipo)
        {
            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;
                        }
                        
                    if (tipo==1){
                        total[key[j]] +=  parseFloat(valor[i][header[key[j]]]);
                        if (i == (valor.length-1)) total[key[j]]=parseFloat(total[key[j]]).toPrecision(3);
                    //alert(total[key[j]]);
                    }
                    else
                        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-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]['SITIO ID']+">";
                for (var j = 0; j < header.length; j++) {
                        var clases   = '';
                    if(header[j] != 'CLASS'){

                        if(header[j] == 'VIDA UTIL'  ){
                            
                           var valor = parseInt(monitor[i][header[j]]);
                           if (  valor < 60 ){
                               
                               clases = 'btn-danger';
                           }

                            
                        }
                        table += "<td class="+clases+">" + 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 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);
        }
        
        function generateModal(url, data) {
            
            var $modal     = $('#myModal'),
                $modalBody = $('#myModal .modal-body').empty();
            
            $modal.find('.isloading-wrapper').remove();
            $modalBody.isLoading();
            
            $.getJSON( url, data, function(data) {
                if ( data.length == 0 ) {

                    $modal.modal('hide');
                    $modalBody.isLoading('hide');        
                    return false;
                } 
                
                var monitor = data,
                    header  = Object.keys( data[0] ),
                    table   = '<table id="detailTable" class="table table-hover table-bordered table-condensed"><thead><tr style="background-color: #00569C; color: white;">';
                
                for (var j = 0; j < header.length; j++) {
                    table += "<th class='text-center'>" + header[j].slice(0, -1) + "</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>";
                }

                table += "</table>";
                $modalBody.html(table).isLoading('hide');
                
                $("#detailTable tbody tr:eq(-2)").find("td:eq(1)").attr('colspan', '2');
                $("#detailTable tbody tr:eq(-2)").find("td:eq(3)").attr('colspan', '2');
                $("#detailTable tbody tr:eq(-2)").find("td:eq(5)").attr('colspan', '2');
                $("#detailTable tbody tr:eq(-2)").find("td:eq(7)").attr('colspan', '2');
                $("#detailTable tbody tr:eq(-2)").find("td:eq(2)").remove();
                $("#detailTable tbody tr:eq(-2)").find("td:eq(3)").remove();
                $("#detailTable tbody tr:eq(-2)").find("td:eq(5)").remove();
                $("#detailTable tbody tr:eq(-1)").find("td:eq(1)").attr('colspan', '2');
                $("#detailTable tbody tr:eq(-1)").find("td:eq(3)").attr('colspan', '2');
                $("#detailTable tbody tr:eq(-1)").find("td:eq(5)").attr('colspan', '2');
                $("#detailTable tbody tr:eq(-1)").find("td:eq(7)").attr('colspan', '2');
                $("#detailTable tbody tr:eq(-1)").find("td:eq(2)").remove();
                $("#detailTable tbody tr:eq(-1)").find("td:eq(3)").remove();
                $("#detailTable tbody tr:eq(-1)").find("td:eq(5)").remove();

            });
            
            $modal.modal('show');
        }

    </script>

    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-12">
                    <img id="logo" class="pull-right" src="{{ asset('images/telefonica.png') }}"  width="220" height="72" >

             </div>
        </div>        
        
        <div class="row">
            <div class="col-lg-2"  style="margin-top: 1%">
                <label>{{'monitor.etiqueta.fechaI' | trans}}:</label>  
                <input class="form-control" type="text" id="Filtros_fechaIni" value="{{ dateStart }}">
            </div>
            <div class="col-lg-2"  style="margin-top: 1%">
                <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>  
                <input class="form-control" type="text" id="Filtros_fechaFin" value="{{ dateEnd }}">
            </div>
             <div class="col-lg-2"  style="margin-top: 1%">
                <label>{{'monitor.etiqueta.region' | trans}}: </label>
                 <select class="form-control" id="region">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    <option value="METROPOLITANA">{{'METROPOLITANA' | trans}}</option>
                    <option value="OCCIDENTE">{{'OCCIDENTE' | trans}}</option>
                    <option value="ORIENTE">{{'ORIENTE' | trans}}</option>

                </select>
            </div>
             <div class="col-lg-2"  style="margin-top: 1%">
                <label>{{'ticketDetail.modal.critical' | trans | capitalize}}: </label>                  
                <select class="form-control" id="criticidad">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    <option value="CRITICA">{{'CRITICA' | trans}}</option>
                    <option value="MEDIA">{{'MEDIA' | trans}}</option>
                    <option value="BAJA">{{'BAJA' | trans}}</option>
                </select>
            </div>   
             <div class="col-lg-2"  style="margin-top: 1%">
                <label>{{'Porte' | trans}}: </label>                    
                <select class="form-control" id="porte">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    <option value="Pequeño Porte">{{'Pequeño Porte' | trans}}</option>
                    <option value="Mediano Porte">{{'Mediano Porte' | trans}}</option>
                    <option value="RS Porte">RS {{'Porte' | trans}}</option>
                    <option value="Gran Porte">{{'Gran Porte' | trans}}</option>                    
                </select>
            </div>             
            <div class="col-lg-2" id="parametros" style="margin-top: 1%">
               <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">
                <div class="col-lg-12 text-center"  style="margin-top: 1%">
                    <h1>{{'RECT Y BATERIAS' | trans}}</h1>
                 </div>
        </div>
            
        <div class="row">
            
            <div class="col-lg-3"  style="margin-top: 1%">
                {{'Cantidad' | trans}}: <span id="cantidad"></span>
            </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>
                    
       <div class="row">
            <div  id="primer_reporte" style="overflow-x: scroll; overflow-y: hidden;" >

            </div>
        </div>  
    </div>        
                    

    <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header  bg-primary">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                    <h2 class="modal-title text-center" id="myModalLabel">{{'DETALLE VISITAS' | trans}}</h2>
                </div>
                <div class="modal-body" style="margin-top: 10px; margin-bottom: 10px;">
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">{{'monitorii.close' | trans}}</button>
                </div>

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