{% 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{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: #ecea19;
            border-color: #ecea19;
        }
        .table th{
            font-size: 8pt;
        }
        .table td{
            font-size: 8pt;
        }        
        
        tr {cursor:pointer}
   .btn-orange {
    color: #fff;
    background-color: rgb(255, 165, 0) !important;
    border-color: #ecea19;
}
    </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();

            });
            
            
            $('#filtro_pais').change(function () {
                $('#region').empty();
                var nuevo_pais = $('#filtro_pais').val();
                cambiar_regiones_maya(nuevo_pais);
            });
            
            
            
            
            

           $('#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");      
                $('#Filtros_fechaIni').val("");
                $('#Filtros_fechaFin').val("");  
            });             

            $('#generar').trigger('click');
            
            
            
            
            
            
            
            function cambiar_regiones_maya(n_pais) {
            switch (n_pais){
                case '1':
                    $('#region').append($("<option></option>").attr("value",'TODOS').text('TODOS'));
                    $('#region').append($("<option></option>").attr("value",'METROPOLITANA').text('METROPOLITANA'));
                    $('#region').append($("<option></option>").attr("value",'ORIENTE').text('ORIENTE'));
                    $('#region').append($("<option></option>").attr("value",'OCCIDENTE').text('OCCIDENTE'));
                    break;
                case '3':
                    $('#region').append($("<option></option>").attr("value",'TODOS').text('TODOS'));
                    $('#region').append($("<option></option>").attr("value",'CENTRAL').text('CENTRAL'));
                    $('#region').append($("<option></option>").attr("value",'ORIENTE').text('ORIENTE'));
                    $('#region').append($("<option></option>").attr("value",'OCCIDENTE').text('OCCIDENTE'));
                    break;
                
                case '75':
                    $('#region').append($("<option></option>").attr("value",'TODOS').text('TODOS'));
            }
        }
        
        
        
        
        

        });
        
        
           function myFunction(index , idelment) {
            // Declare variables
            var input, filter, table, tr, td, i, tmpstr;

            input = document.getElementById('id'+index+'id');
            //   index =index-1;
            filter = input.value.toUpperCase();
            table = document.getElementById("tab1");
            tr = table.getElementsByTagName("tr");

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

                td = tr[i].getElementsByTagName("td")[index];

                if (td) {
                    tmpstr = td.innerHTML.toUpperCase();
                    if (tmpstr.search(filter) > -1) {
                        tr[i].style.display = "";
                    } else {
                        if(i>1)
                        {
                            tr[i].style.display = "none";
                        }

                    }
                }
            }
        }


        function reporteBateria(){

            data = {};

                data['region'] = $("#region").val();
                data['fechaIni'] = $("#Filtros_fechaIni").val();  
                data['fechaFin'] = $("#Filtros_fechaFin").val();    
                
               // alert($("#filtro_pais").val());
                
                     data['pais'] = $("#filtro_pais").val();
                
                
                                  
            $.getJSON('{{path('reportemsmaya_reporteEquiposAltCapMayaGT')}}',data, function (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, true));
                    //$("#primer_reporte" ).slider();
                    $.isLoading("hide");
                });
       }


        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;
        }

        $("tr").live("click",function(e){
        var id = $(this).attr("id");
        var row = $(this).parent().children().index($(this));
        columnTh = $("airconditioners th:contains('ID SITIO')");
        var idsitio = document.getElementById("tab1").rows[row+1].cells[1].innerHTML;
        if(id!= null){
             if(e.target.tagName != 'TD'){ return 0;}
             $('#myModalDetalle .modal-body').empty();
             $('#myModalDetalle').modal();
             $('#myModalDetalle .modal-body').isLoading({
                text:       "Loading",
                position:   "inside"
                });

                 $.ajax({

                url : "{{ path('reportemsmaya_reporteDetalleEquiposAltaCapGT') }}",
                data : {'id': id}


            }).done(function(data){

                $('#myModalDetalle .modal-body').empty();
                var tierra = ''
                tierra += '<div class="table-responsive">'
                 tierra += createTable(data.bateria,false);
                 tierra += '</div>'
                $('#myModalDetalle .modal-body').append(tierra);

                $('#myModalDetalle .modal-header').children('h2').remove();
                var titulo = '<h2 class="modal-title text-center eri-font" id="myModalLabel">HIGH CAPACITY EQUIPMENT-'+idsitio+' </h2>'
                $('#myModalDetalle .modal-header').append(titulo);
                 $.isLoading("hide");
            });

               // alert($(this).attr("id"));
               }});
        
        function createTable(monitor,buscador){
            var is_URL_drive;
            var header = Object.keys(monitor[0]);
            var table = '<table  id="tab1" 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] != 'ID'){
                table += "<th style='vertical-align:middle;' class='text-center' width='16%'>" + header[j] + "</th>"
            }
        }
            table += "</tr></thead>";
            
            var flagnumber =0;
            for (var j = 0; j < header.length; j++) {




                if(header[j] != 'CLASS' && header[j] != 'ALARMAS'   && header[j] !== 'ID' 
                ){

                    var tmpid = 'id'+flagnumber+'id';
                    if(buscador)
                        {
                            table += "<td style='vertical-align:middle;' class='text-center'>\n\
                            <input  class='form-control' style=font-size:9px type=input id="+tmpid+" onkeyup=myFunction("+flagnumber+","+"id"+flagnumber+"id"+")></td>"
                        }else
                        {
                            
                        }

                    flagnumber +=1;
                }
            }
            

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

                    if((monitor[i][header[j]]) == null){
                        monitor[i][header[j]] = '-';
                    }

                    if (monitor[i]['EQUIPO']!='nada' && header[j] != 'ENTREGABLES')
                        
                        if(header[j] != 'ID' && header[j] != 'ENTREGABLES')
                    {
                        if(j==6 || j ==7)
                        {
                           if( monitor[i][header[j]]<=60)
                           {
                               clase="btn-success";
                           }
                           if( monitor[i][header[j]]>60&&monitor[i][header[j]]<=70)
                           {
                                 clase="btn-yellow";
                           }
                           if( monitor[i][header[j]]>70&&monitor[i][header[j]]<=80)
                           {
                                 clase="btn-orange";
                           }
                            if( monitor[i][header[j]]>80&&monitor[i][header[j]]<=90)
                           {
                                 clase="btn-alert";
                           }
                           if( monitor[i][header[j]]>90&&100)
                           {
                                 clase="btn-danger";
                           }
                         
                             table += "<td width='50' style='vertical-align:middle;' class='"+clase+"'>" + monitor[i][header[j]]  + " </td>"; 
                        }
                        else
                        {
                        table += "<td width='50' style='vertical-align:middle;'>" + monitor[i][header[j]]  + "</td>"; 
                        }
                     }


                    if (header[j] == 'ENTREGABLES'){

                        is_URL_drive = monitor[i][header[j]].search("drive.google.com");

                        if (monitor[i]['ENTREGABLES'] == '-'){

                            table += "<td WIDTH='50' style='vertical-align:middle;' ><img border=0; src='{{ asset('images/gray_sync.png') }}'; width='20' height='20'></img></td>";

                        }
                        else if(is_URL_drive > -1){


                            table += "<td WIDTH='50' style='vertical-align:middle;' ><a class='btn btn-link' target='_blank' href=" + monitor[i]['ENTREGABLES'] + "><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></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);
  }

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

    <div class="container">
        <div class="row" id="row_1">
            
            
            {% if pais == 75 %}
            <div class="col-lg-2 eri-font top-uno">
                <label>{{ 'monitores.pais' | trans }}:</label>
                <select class="form-control" id="filtro_pais">
                    <option value="75">{{'inbox.all' | trans}}</option> 
                    <option value = '1'>Guatemala</option>
                    <option value = '3'>El Salvador</option>
                    
                </select>
            </div>
            {% endif %}
            
            
             {% if pais == 1 %}
            <div class="col-lg-2 eri-font top-uno">
                <label>{{ 'monitores.pais' | trans }}:</label>
                <select class="form-control" id="filtro_pais">
                  
                    <option value = '1'>Guatemala</option>
                   
                    
                </select>
            </div>
            {% endif %}
            
             {% if pais ==3 %}
            <div class="col-lg-2 eri-font top-uno">
                <label>{{ 'monitores.pais' | trans }}:</label>
                <select class="form-control" id="filtro_pais">
                   
                    
                    <option value = '3'>El Salvador</option>
                    
                </select>
            </div>
            {% endif %}

            <img id="logo" class="pull-right" src="{{ asset('images/telefonica.png') }}"  width="100" height="62" >

        </div>

        <div class="row" id="row_2">

            <div class="col-lg-2 eri-font top-uno">
                <label>{{'monitor.etiqueta.region' | trans}}: </label>
                <select class="form-control" id="region">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    {%for region in regiones%}
                        <option value={{region.region}}>{{region.region}}</option>
                    {%endfor%}
                </select>

            </div>

            <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-3 top-uno" id="parametros" style="padding-top: 2%">
               <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" id="row_3">
                <div class="col-lg-12 text-center eri-font top-uno">
                    <h1>{{'EQUIPOS ALTA CAPACIDAD' | trans | upper}}</h1>
                 </div>

        </div>

        <div class="row" id="row_4" style="padding-bottom: 1%">
         <div class="col-lg-3 eri-font top-uno">
                {{'Cantidad' | trans}}: <span id="cantidad" class="bold eri-font"></span>
             </div>
             <div class="col-lg-offset-9 top-uno">
                    <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" id="row_5" style="overflow-x: scroll; transform: rotateX(180deg);">

            <div class="col-lg-12 top-uno" id="primer_reporte" style="transform: rotateX(180deg);"></div>

        </div>
               
        </div>

  <!-- Modal -->
    <div class="modal fade" id="myModalDetalle" 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>
                </div>

                <div class="modal-body">



                   </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">{{'monitorii.close' | trans}}</button>

                </div>

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