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

{% block dashboard %}
    <style>
         /* pager wrapper, div */
        .pager {
            padding: 5px;
        }
        /* pager wrapper, in thead/tfoot */
        td.pager {
            background-color: #e6eeee;
        }
        /* pager navigation arrows */
        .pager img {
            vertical-align: middle;
            margin-right: 2px;
        }
        /* pager output text */
        .pager .pagedisplay {
            font-size: 14px;
            padding: 0 5px 0 5px;
            width: 50px;
            text-align: center;
        }

        .double-scroll {
            width: 100%;
            margin-bottom: 40px;
        }

        /*** loading ajax indeterminate progress indicator ***/
        #tablesorterPagerLoading {
            background: rgba(255,255,255,0.8) url(icons/loading.gif) center center no-repeat;
            position: absolute;
            z-index: 1000;
        }

        /*** css used when "updateArrows" option is true ***/
        /* the pager itself gets a disabled class when the number of rows is less than the size */
        .pager.disabled {
            display: none;
        }
        /* hide or fade out pager arrows when the first or last row is visible */
        .pager img.disabled {
            /* visibility: hidden */
            opacity: 0.5;
            filter: alpha(opacity=50);
        }

        .tablesorter-pager select {
            margin: 0;
            padding: 0;
            width: 50px;
        }

        table.tablesorter thead tr th, table.tablesorter tfoot tr th {
            background-color: #aa0001;
            border: 1px solid #FFF;
            font-size: 8pt;
            padding: 4px;
            color: white;
        }

        .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);}
        }
        .table-responsive {
            /*height: 400px !important;*/
            overflow: scroll;
        }
        .btn-claro {
            color: #fff;
            background-color: #aa0001;
            border-color: #e06a70;

        }

        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
        }
        tr {cursor:pointer}
        {%if idproyectos1 == 79%}
            .btn-claro {
                color: #fff;
                background-color: #025266;
                border-color: #025266;
            }
        {%endif%}


        .tablesorter-header-inner,table.tablesorter thead tr th,.tablesorter-filter {
            color: #fff;
            background-color: #aa0001;
            border-color: #aa0001;
        }
        table.tablesorter thead tr th{
            height: 40px;
        }
        .tablesorter-blue .headerSortUp, .tablesorter-blue .tablesorter-headerSortUp, .tablesorter-blue .tablesorter-headerAsc {
            background-color: #aa0001;}
        .tablesorter-blue .headerSortDown, .tablesorter-blue .tablesorter-headerSortDown, .tablesorter-blue .tablesorter-headerDesc {
            background-color: #aa0001;}
        .tablesorter-blue .tablesorter-filter-row td {
            background: #aa0001;border-color: #aa0001;}
        input[type="search"]{
            display: block;
            width: 100%;
            height: 34px;
            padding: 6px 12px;
            font-size: 12px;
            line-height: 1.42857143;
            color: #555;
            background-color: #fff;
            background-image: none;
            border: 1px solid #ccc;
            border-radius: 4px;
            -webkit-box-shadow: inset 0 1px 1px rgba(0,0,0,.075);
            box-shadow: inset 0 1px 1px rgba(0,0,0,.075);
            -webkit-transition: border-color ease-in-out .15s,-webkit-box-shadow ease-in-out .15s;
            -o-transition: border-color ease-in-out .15s,box-shadow ease-in-out .15s;
            transition: border-color ease-in-out .15s,box-shadow ease-in-out .15s;
        }

        </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 src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script src="{{ asset('js/jquery.doubleScroll.js') }}" type="text/javascript"></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 () {
                $("#pais").val();
                $("#region").val("TODOS");
                $('#Filtros_fechaIni').val("");
                $('#Filtros_fechaFin').val("");
                $('#btu_tr').val("TODOS");
                $('#F_C').val("TODOS");
            });

            $("#btnModalMasive").click(function () {
              $(".fileinput-remove-button").trigger("click");
              //$("#btnModalMasive").addClass("fileinput-remove-button");
                $("#modalMasive").modal();
                //var clone = $(".divF").clone(); // guarda el dato
                //$(".divF").remove();
                //$(".divF").append(clone); // Lo restaura*/
                //file-input file-input-ajax-new
            });

            $("#fileExcel").fileinput({

                uploadUrl: "{{path('cargaTemplate',{'idproyectos':idproyectos})}}", // server upload action
                uploadAsync: false,
                minFileCount: 1,
                maxFileCount: 5,
                overwriteInitial: false,
                uploadExtraData: function() {
                    return {
                        idproceso: $("#idproceso").val()
                    };
                },
                showPreview: true,
                previewFileExtSettings: {
                    'doc': function (ext) {
                        return ext.match(/(doc|docx)$/i);
                    },
                    'xls': function (ext) {
                        return ext.match(/(xls|xlsx)$/i);
                    },
                    'ppt': function (ext) {
                        return ext.match(/(ppt|pptx)$/i);
                    }
                }
            });

            $('#fileExcel').on('filebatchuploaderror', function(event, data, previewId, index) {
                var form = data.form, files = data.files, extra = data.extra,
                        response = data.response, reader = data.reader;
                console.log('File batch upload success');
                alert('llego');

            });


            $('#fileExcel').on('filebatchuploadsuccess', function(event, data, previewId, index) {
                var form = data.form, files = data.files, extra = data.extra,
                        response = data.response, reader = data.reader;
               $("#modalMasive").modal('hide');
            });

        {%if idproyectos == 35 or idproyectos == 30 or idproyectos == 32 or idproyectos == 36 or idproyectos == 37 or idproyectos == 57%}
            {%if idproyectos == 35 %} {%set idpais=1%} {%set pais='Guatemala'%}{%endif%}
            {%if idproyectos == 30 %} {%set idpais=2%} {%set pais='Honduras'%}{%endif%}
            {%if idproyectos == 32 %} {%set idpais=4%} {%set pais='Nicaragua'%}{%endif%}
            {%if idproyectos == 36 %} {%set idpais=3%} {%set pais='El Salvador'%}{%endif%}
            {%if idproyectos == 37 %} {%set idpais=5%} {%set pais='Costa Rica'%}{%endif%}
            {%if idproyectos == 57 %} {%set idpais=6%} {%set pais='Panamá'%}{%endif%}

            $("#pais option").remove();
            $("#pais").append('<option value={{idpais}}>{{pais}}</option>');
            //Llenar Combos
            $.isLoading({
                text: "Loading"
            });
            llenarCombos();
        {%endif%}

                /*$("#pais").change(function () {
                    if ($("#pais").val() != "TODOS") {
                        $.isLoading({
                            text: "Loading"
                        });
                        llenarCombos();
                    } else {
                        $("#region option").remove();
                        $("#region").append('<option value="TODOS">REGION</option>');
                    }
                   // $('#generar').trigger('click');
                });*/

                //$('#generar').trigger('click');

            });

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("tabla1");
  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() {
//alarmas
                var pais0 = $("#pais").val();
                if (pais0 = 'TODOS') {
                  var pais = "x.pais";
                }else {
                  var pais = pais0;
                }
                //alert(pais);
                var data = {};
                data['pais'] = pais;
                //data['region'] = "TODOS";//$("#region").val();
                //data['proyecto']= $("#proyecto").val();
                //data['region']   = $("#region").val();
                data['fechaIni'] = $("#Filtros_fechaIni").val();
                data['fechaFin'] = $("#Filtros_fechaFin").val();
                //data['idproyectos'] =  "" + {{idproyectos}};
                var reporte_id = 464;
                data['reporte_id'] =  reporte_id;
                $.getJSON('{{path('reportemshonduras_reporteCor')}}', 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));
                    $.isLoading("hide");
                    var pagerOptions = {
                        // target the pager markup - see the HTML block below
                        container: $(".pager"),
                        // output string - default is '{page}/{totalPages}'; possible variables: {page}, {totalPages}, {startRow}, {endRow} and {totalRows}
                        output: '{filteredRows}',
                        // if true, the table will remain the same height no matter how many records are displayed. The space is made up by an empty
                        // table row set to a height to compensate; default is false
                        fixedHeight: false,
                        // remove rows from the table to speed up the sort of large tables.
                        // setting this to false, only hides the non-visible rows; needed if you plan to add/remove rows with the pager enabled.
                        removeRows: true,
                        // go to page selector - select dropdown that sets the current page
                        cssGoto: '.gotoPage'
                    };
                    // initial sort set using sortList option
                    $(".table1").tablesorter({
                        theme: 'blue',
                        // sort on the first column and second column in ascending order
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            // extra css class applied to the table row containing the filters & the inputs within that row
                            filter_cssFilter: '',
                            // If there are child rows in the table (rows with class name from "cssChildRow" option)
                            // and this option is true and a match is found anywhere in the child row, then it will make that row
                            // visible; default is false
                            filter_childRows: false,
                            // if true, filters are collapsed initially, but can be revealed by hovering over the grey bar immediately
                            // below the header row. Additionally, tabbing through the document will open the filter row when an input gets focus
                            filter_hideFilters: false,
                            // Set this option to false to make the searches case sensitive
                            filter_ignoreCase: true,
                            // jQuery selector string of an element used to reset the filters
                            filter_reset: '.reset',
                            // Use the $.tablesorter.storage utility to save the most recent filters
                            filter_saveFilters: false,
                            filter_columnFilters : true
                        }
                    }).tablesorterPager(pagerOptions);
                    $('.pager').show();
                });
            }


            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, option) {
                var header = Object.keys(monitor[0]);
                var table;
                var idproyectos = {{idproyectos}};

                if (option == 1) {
                    table = '<table id="tabla1" class="table table-bordered table-hover table-striped table-responsive table1">';
                } else{
                    table = '<table id="tabla1" class="table table-bordered table-hover table-striped table-responsive table1">';
                }
                table += "<thead><tr>";

                for (var j = 0; j < header.length; j++) {
                    var strHideFilter = "";
                    if (header[j] == 'ENTREGABLE') {
                         strHideFilter = " sorter-false filter-false "
                    }

                    if (header[j] != 'USER' && header[j] != 'laS' && header[j] != 'loS' && header[j] != 'laR' && header[j] != 'loR' && header[j] != 'fechaR' && header[j] != 'fechaL' && header[j] != 'fechaE' && header[j] != 'ACTIVIDAD1' && header[j] != 'laL' && header[j] != 'loL') {
                        if (option == 1) {
                            table += "<th style='vertical-align:middle; width:300px' class='text-center" + strHideFilter + "'>" + header[j] + "</th>";
                        } else{
                            table += "<th style='vertical-align:middle;' class='text-center" + strHideFilter + "'>" + header[j] + "</th>";
                        }
                    }
                }
                table += "</tr>";
                table += '<tr>';

            //EVITA CAMPOS DE BUSQUEDA SI ES UN DETALLE EN EL MONITOR, 17 ES EL NUMERO DE CAMPOS DEL QUERY PRINCIPAL DEL MONITOR
                /*if(header.length > 2) {
                    var flagnumber = 0;
                    for (var j = 0; j < header.length; j++) {

                        if (header[j] != 'CLASS' && header[j] != 'ENTREGABLE' && header[j] != 'capacidad'
                        && header[j] != 'temperatura' && header[j] != 'ID') {
                            var tmpid = 'id' + flagnumber + 'id';
                            table += "<td style='vertical-align:middle; height: 52px;' class='text-center'>\n\
                                <input  class='form-control' style=font-size:9px type=input id=" + tmpid
                                + " onkeyup=myFunction(" + flagnumber + "," + "id" + flagnumber + "id" + ")></td>";
                            flagnumber += 1;
                        }
                    }
                }*/
                table += "</tr></thead>";

                for (var i = 0; i < monitor.length; i++) {
                    table += "<tr id=" + monitor[i]['ID SITIO'] + " user=" + monitor[i]['USER'] + " mp=" + monitor[i]['ACTIVIDAD1'] + " fecha=" + monitor[i]['FECHA DE EJECUCION'] + " >";
                        for (var j = 0; j < header.length; j++) {
                        var clases = '';

                        if (header[j] == 'LATITUD DEL REPORTE') {
                          var laS = monitor[i]['laS'];
                          var laR = monitor[i]['laR'];
                          //alert(laS);
                          //alert(laR);
                          if (laS != laR) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] == 'LONGITUD DEL REPORTE') {
                          var loS = monitor[i]['loS'];
                          var loR = monitor[i]['loR'];
                          //alert(laS);
                          //alert(laR);
                          if (loS != loR) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] == 'LATITUD HISTORICO') {
                          var laS = monitor[i]['laS'];
                          var laL = monitor[i]['laL'];
                          //alert(laS);
                          //alert(laR);
                          if (laS != laL) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] == 'LONGITUD HISTORICO') {
                          var loS = monitor[i]['loS'];
                          var loL = monitor[i]['loL'];
                          //alert(laS);
                          //alert(laR);
                          if (loS != loL) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] == 'FECHA REPORTE') {
                          var fR = monitor[i]['fechaR'];
                          var fE = monitor[i]['fechaE'];
                          //alert(laS);
                          //alert(laR);
                          if (fR != fE) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] == 'FECHA DE EJECUCION') {
                          var fR = monitor[i]['fechaR'];
                          var fE = monitor[i]['fechaE'];
                          //alert(laS);
                          //alert(laR);
                          if (fE != fR) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] != 'USER' && header[j] != 'laS' && header[j] != 'loS' && header[j] != 'laR' && header[j] != 'loR' && header[j] != 'fechaR' && header[j] != 'fechaL' && header[j] != 'fechaE' && header[j] != 'ACTIVIDAD1' && header[j] != 'laL' && header[j] != 'loL') {
                            if (header[j] == 'FECHA SIG. MEDICION' && monitor[i]['CLASS'] == 1) {
                                clases = 'btn-danger';
                            }
                            table += "<td class=" + clases + ">" + monitor[i][header[j]] + "</td>";
                        }

                        if (header[j] == 'ENTREGABLE'){
                            if (monitor[i]['ENTREGABLE'] != '_') {
                                var un = monitor[i]['ENTREGABLE'];

                               table += "<td class='text-center'><a class='btn btn-link' target='_blank' href=" + un + " ><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></td>";

                            } else
                            {
                                table += "<td class='text-center'><img border=0; src='{{ asset('images/gray_sync.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 createTableDetal(monitor) {
                 var header = Object.keys(monitor[0]);
                    var table = '<table id="tableDetail" 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] != 'USER' && header[j] != 'laS' && header[j] != 'loS' && header[j] != 'laR' && header[j] != 'loR' && header[j] != 'fechaR' && header[j] != 'fechaL' && header[j] != 'fechaE' && header[j] != 'ACTIVIDAD1' && header[j] != 'laL' && header[j] != 'loL')
                            table += "<th style='vertical-align:middle; width:50px' class='text-center'>" + header[j] + "</th>"
                    }
                    table += "</tr>";
                    table += '<tr>';
                    table += "</tr></thead>";

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

                        if (header[j] == 'LATITUD DEL REPORTE') {
                          var laS = monitor[i]['laS'];
                          var laR = monitor[i]['laR'];
                          //alert(laS);
                          //alert(laR);
                          if (laS != laR) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] == 'LONGITUD DEL REPORTE') {
                          var loS = monitor[i]['loS'];
                          var loR = monitor[i]['loR'];
                          //alert(laS);
                          //alert(laR);
                          if (loS != loR) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] == 'LATITUD HISTORICO') {
                          var laS = monitor[i]['laS'];
                          var laL = monitor[i]['laL'];
                          //alert(laS);
                          //alert(laR);
                          if (laS != laL) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] == 'LONGITUD HISTORICO') {
                          var loS = monitor[i]['loS'];
                          var loL = monitor[i]['loL'];
                          //alert(laS);
                          //alert(laR);
                          if (loS != loL) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] == 'FECHA REPORTE') {
                          var fR = monitor[i]['fechaR'];
                          var fE = monitor[i]['fechaE'];
                          //alert(laS);
                          //alert(laR);
                          if (fR != fE) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] == 'FECHA DE EJECUCION') {
                          var fR = monitor[i]['fechaR'];
                          var fE = monitor[i]['fechaE'];
                          //alert(laS);
                          //alert(laR);
                          if (fE != fR) {
                              clases = 'btn-danger';
                          } /*else if (laS == laR) {
                                clases = 'btn-success';
                          }*/
                        }

                        if (header[j] != 'USER' && header[j] != 'laS' && header[j] != 'loS' && header[j] != 'laR' && header[j] != 'loR' && header[j] != 'fechaR' && header[j] != 'fechaL' && header[j] != 'fechaE' && header[j] != 'ACTIVIDAD1' && header[j] != 'laL' && header[j] != 'loL') {
                            if (header[j] == 'FECHA SIG. MEDICION' && monitor[i]['CLASS'] == 1) {
                                clases = 'btn-danger';
                            }
                            table += "<td class=" + clases + ">" + monitor[i][header[j]] + "</td>";
                        }

                        if (header[j] == 'ENTREGABLE'){
                            if (monitor[i]['ENTREGABLE'] != '_') {
                                var un = monitor[i]['ENTREGABLE'];

                               table += "<td class='text-center'><a class='btn btn-link' target='_blank' href=" + un + " ><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></td>";

                            } else
                            {
                                table += "<td class='text-center'><img border=0; src='{{ asset('images/gray_sync.png') }}'; width='20' height='20'></img></a></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);
            }

        $("tbody tr").live("click", function (e) {
            if(e.target.tagName != 'TD'){ return 0;}
            if(e.target.tagName != 'IMG'){
                $('#myModalDetalle .modal-body').empty();
                $('#myModalDetalle').modal();
                $('#myModalDetalle .modal-body').isLoading({
                    text: "Loading",
                    position: "inside"
                });
                var id = $(this).attr("id");
                var user = $(this).attr("user");
                var mp = $(this).attr("mp");
                var fecha = $(this).attr("fecha");
                //alert(mp);
                var reporte_id = 474;

                /*if (mp == 'MP_INFRAESTRUCTURA') {
                  var reporte_id = 465;
                }else if (mp == 'MP_MOTOGENERADOR') {
                  var reporte_id = 466;
                }else if (mp == 'MP_AIRE_ACONDICONADO') {
                  var reporte_id = 467;
                }else if (mp == 'MP_ENERGIA') {
                  var reporte_id = 468;
                }else if (mp == 'MP_RECTIFICADORES') {
                  var reporte_id = 469;
                }else if (mp == 'MP_SISTIERRAS') {
                  var reporte_id = 470;
                }else if (mp == 'MP_CONEXION_PLANTA') {
                  var reporte_id = 471;
                }else if (mp == 'MP_ABASTECIMIENTO') {
                  var reporte_id = 472;
                }else if (mp == 'MP_AUTONOMIA') {
                  var reporte_id = 473;
                }*/

                $.ajax({

                    url: "{{ path('reportemshonduras_reporteDetalleCor') }}",
                    data: {'sitio': id, 'user': user, 'fecha': fecha,  'reporte_id':reporte_id,}
                }).done(function (data) {
                    $('#myModalDetalle .modal-body').empty();
                    var tierra = ''
                    tierra += '<div class="table-responsive">'
                    tierra += createTableDetal(data.bateria);
                    tierra += '</div>'
                    $('#myModalDetalle .modal-body').append(tierra);
                    //$('.double-scroll').doubleScroll();
                    $.isLoading("hide");
                });
            }else
            {
                console.log('hizo click en la columna de los pdf');
            }

            // alert($(this).attr("id"));
        });

            function llenarCombos() {
              $.isLoading("hide");
                /*$("#region option").remove();
                $("#region").append('<option value="TODOS">REGION</option>');
                var data = {};
                data['pais'] = $("#pais").val();
                data['tabla'] = "appenate.mp_aire_acondicionado_template";
                //$.isLoading("hide");
                $.getJSON('{{path('reportemshonduras_llenarRegionMP')}}', data, function (data) {
                    var regions = data.region;

                    for (var i = 0; i < regions.length; i++) {
                        $("#region").append('<option value="' + regions[i]['REGION'] + '">' + regions[i]['REGION'] + '</option>');
                    }

                    $.isLoading("hide");

                });*/
            };

    </script>

    <div class="container-fluid">
        {%if idproyectos1!=79%}
        <div class="row">
            <div class="col-lg-12">
                <img id="logo" class="pull-right" src="{{ asset('images/claro.jpg') }}"  width="220" height="72" >

            </div>
        </div>
        {%endif%}
        <div class="row">


            <div class="col-lg-2 top-uno">
                <label>{{'monitores.pais' | trans}} </label>
                <select class="form-control" id="pais">
                    <option value="TODOS">{{"inbox.all" | trans}}</option>
                    <option value="Costa Rica">Costa Rica</option>
                    <option value="El Salvador">El Salvador</option>
                    <option value="Guatemala">Guatemala</option>
                    <option value="Honduras">Honduras</option>
                    <option value="Nicaragua">Nicaragua</option>
                </select>
            </div>


            <div class="col-lg-2 top-uno">
                <label> {{'monitor.etiqueta.fechaI' | trans}}:</label> </br>
                <input class="form-control" type="text" id="Filtros_fechaIni" value="{{ dateStart }}">
            </div>
            <div class="col-lg-2 top-uno">
                <label> {{'monitor.etiqueta.fechaF' | trans}}: </label>  </br>
                <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></br>
                <select class="form-control" id="region">
                    <option value="TODOS">TODOS</option>
                </select>
            </div>

            <div class="col-lg-2"  style="margin-top: 1%">
                <label>{{'monitores.proyecto' | trans}}: </label></br>
                <select class="form-control" id="proyecto">
                    <option value="TODOS">TODOS</option>
                    <option value="CLARO MAPLE">CLARO MAPLE</option>
                    <option value="CLARO MAYA">CLARO MAYA</option>
                </select>
            </div>-->


            <div class="col-lg-2 top-uno" style="margin-top: 3%">
                <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-2 top-uno">

                <select class="form-control" id="btu_tr" style="visibility: hidden;">
                    <option value="todos">{{"inbox.all" | trans}}</option>
                    <option value="btu">BTU</option>
                    <option value="tr">TR</option>
                </select>
            </div>
            <div class="col-lg-2 top-uno">

                <select class="form-control" id="F_C" style="visibility: hidden;">
                    <option value="todos">{{"inbox.all" | trans}}</option>
                    <option value="f">°F</option>
                    <option value="c">°C</option>
                </select>
            </div>

        </div>

        <div class="row">
            <div class="col-lg-12 text-center top-uno">
                <h1> MONITOR COORDENADAS </h1>
            </div>
        </div>
        <!--<div class="row">
          <div class="btn-group pull-right">
              <button class="btn btn-info" id="btnModalMasive">Cargar Archivo</button>
          </div>
        </div>-->
        <div class="row">
            <div class="pager col-lg-3" style="text-align: left">
                {{"Cantidad" | trans}}: <span id="cantidad" class="pagedisplay"></span>
            </div>
            <div class="col-lg-offset-9 col-md-offset-9">
                <div class="btn-group pull-right">
                    {% if (is_granted('ROLE_ADMIN_CLIENTE') ) %}
                    <button id="btnModalMasive" class="btn btn-default btn-sm"><i class="fa fa-upload"></i> {{'Cargar Archivo' | trans}}</button>
                    {% endif %}
                    <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" style="overflow-x: auto;">
            <div id="primer_reporte" class="col-lg-12"></div>
        </div>
        <div class="row">
            <div id="pager" class="pager col-lg-12" style="display: none">
                <form>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/first.png')}}" class="first"/>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/prev.png')}}" class="prev"/>
                    <span class="pagedisplay"></span>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/next.png')}}" class="next"/>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/last.png')}}" class="last"/>
                    <select class="pagesize" title="Select page size">
                        <option selected="selected" value="3000">3000</option>
                        <option value="2000">2000</option>
                        <option value="1000">1000</option>
                        <option  value="500">500</option>
                        <option  value="100">100</option>
                    </select>
                </form>
            </div>
        </div>
    </div>


    <div class="modal fade" id="modalMasive" tabindex="-1" role="dialog" aria-labelledby="modalMasive">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header btn-primary">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                    <h4 class="modal-title" id="myModalLabel"><B>CARGAR ARCHIVO</B></h4>
                </div>
                <div class="modal-body">
                  <button class="btn btn-warning">
                  <a href="{{ asset('Template_Mp_Ejecutados.xlsx')  }}" download="Template_Mp_Ejecutados.xlsx" style="float: left;" title="Template MP Ejecutados">
                      <img src={{ asset("images/xls.png")}} width="24px"> Descargar Template
                  </a></button>
                    <div class="panel panel-default divFF">
                        <div class="panel-heading">{{'ticket.masive.upload' | trans}}</div>
                        <div id="divF"class="panel-body divF">
                            <input id="fileExcel" type="file" name="file" class="file-loading">
                        </div>

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

<div class="modal fade" id="myModalDetalle" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog modal-lg" role="document" style="width:1600px;">
        <div class="modal-content">
            <div class="modal-header  bg-primary">
              <button class="btn btn-warning">
              <a href="#" onclick="$('#tableDetail').tableExport({type: 'excel', escape: 'false'});">
                  <img src={{ asset("images/xls.png")}} width="24px"> Exportar datos de la tabla
              </a></button>
                <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="row double-scroll" id="tableDetail" style="margin-top: 2%" >
            </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 %}