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

{% endblock %}

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

        /*** 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);}
        }
        .disabledTab{
            pointer-events: none;
        }
        .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;
            }
            .table th{
                font-size: 10pt;
            }
            .table td{
                font-size: 9pt;
            }

            .double-scroll {
                width: 100%;
            }
            #parametros .panel-body .row{

                padding-left: 5px;
            }

        .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') }}"></script>
    <script>
        var translation = {

        };
        $(document).ready(function() {
            $('.double-scroll').doubleScroll();
            $('#primer_reporte').doubleScroll({resetOnWindowResize: true});
        });

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

            /*$(".activar_ota_por_validar").click(function(){
            //$(document).on('click','.activar_ota_por_validar',function(){
              //$(".pager_otas_por_validar").html(bateria.length);
              alert("Monitor1");
              alert($("#total_monitor").val());
            });

            $(".activar_ota_validadas").click(function(){
            //$(document).on('click','.activar_ota_validadas',function(){
              //$(".pager_otas_validadas").html(bateria1.length);
              alert("Monitor2");
              alert($("#total_monitor_validadas").val());
            });*/

            $(".activar_ota_por_validar").click(function(){
              //alert($("#total_monitor").val());
                if ($("#total_monitor").val()>0){
                    $(".pager_otas_por_validar").show();
                            var pagerOptions1 = {
                                container: $(".pager"),
                                output: 'Rows : {endRow}',
                                fixedHeight: false,
                                removeRows: true,
                                cssGoto: '.gotoPage'
                            };
                            $(".table2").tablesorter({
                                theme: 'blue',
                                widgets: ["zebra", "filter"],
                                widgetOptions: {
                                    filter_cssFilter: '',
                                    filter_childRows: false,
                                    filter_hideFilters: false,
                                    filter_ignoreCase: true,
                                    filter_reset: '.reset',
                                    filter_saveFilters: true
                                }
                  }).tablesorterPager(pagerOptions1);
                    $(".pager").show();
                }else{
                    $(".pager_otas_por_validar").hide();
                }
            });
            $(".activar_ota_validadas").click(function(){
                resizeChart();
                if ($("#total_monitor_validadas").val()>0){
                          $(".pager_otas_validadas").show();
                          var pagerOptions2 = {
                              container: $(".pager"),
                              output: 'Rows : {endRow}',
                              fixedHeight: false,
                              removeRows: true,
                              cssGoto: '.gotoPage'
                          };
                            $(".table1").tablesorter({
                                theme: 'blue',
                                widgets: ["zebra", "filter"],
                                widgetOptions: {
                                    filter_cssFilter: '',
                                    filter_childRows: false,
                                    filter_hideFilters: false,
                                    filter_ignoreCase: true,
                                    filter_reset: '.reset',
                                    filter_saveFilters: true
                                }
                    }).tablesorterPager(pagerOptions2);
                    $(".pager").show();
                }else{
                    $(".pager_otas_validadas").hide();
                }
            });

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

            $("#btnModalMasive").click(function () {
              $(".fileinput-remove-button").trigger("click");
                $("#modalMasive").modal();
            });

            $("#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='Panama'%}{%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">TODOS</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(){
    $(".activar_ota_por_validar").addClass('active');
    $(".activar_ota_validadas").removeClass('active');

    $("#otas_por_validar").addClass('active');
    $("#otas_por_validadas").removeClass('active');
    otas_por_validadas
    var data = {};
    data['medicion'] = $("#evento").val();
    data['region'] = $("#region").val();
    data['pais'] = $("#pais").val();
    data['fechaIni'] = $("#Filtros_fechaIni").val();
    data['fechaFin'] = $("#Filtros_fechaFin").val();
    data['idproyectos'] =  "" + {{idproyectos}};

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

        var bateria  = data.bateria;
        var bateria1  = data.bateria1;
        var porcent = data.porcent;
        var chart0 = data.chart0;
        var chart1 = data.chart1;
        var chart2 = data.chart2;
        var flag = true;

        $("#total_monitor").val(bateria.length);
        $("#total_monitor_validadas").val(bateria1.length);
        /*var rows = bateria.length;
        var rows1 = bateria1.length;
        alert(rows)
        alert(rows1);*/

        if(bateria.length == 0){
          $(".pager_otas_validadas").hide();
          $("#reporte_otas_por_validar").empty();
          $("#reporte_otas_por_validar").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
          $.isLoading("hide");
          //return false;

          if(chart1.length == 0){
              $("#chart1").empty();
              $("#chart1").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
              $.isLoading("hide");
              $("#inicio").show();
              flag = false;

          }if(chart2.length == 0){
              $("#chart2").empty();
              $("#chart2").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
              $.isLoading("hide");
              $("#inicio").show();
              flag = false;

          }

        }else {

          if(flag){

              createColumnChart('chart1','Tipo de Auditorías por País',chart1);


              var total = getTotal(chart1,[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18],2);
              total.shift();
              var header = Object.keys(chart1[0]);
              var AuxArray = new Array();
              for(var i=1;i<header.length;i++){

                  AuxArray.push({'estado':header[i],'Sitios': total[i-1]})
              }

          }

          if(flag){

              createColumnChart2('chart2','First Time Right',chart2);


              var total = getTotal(chart1,[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18],2);
              total.shift();
              var header = Object.keys(chart2[0]);
              var AuxArray = new Array();
              for(var i=1;i<header.length;i++){

                  AuxArray.push({'estado':header[i],'Sitios': total[i-1]})
              }

          }


          //$("#cantidad").html(bateria.length);
          $("#reporte_otas_por_validar").empty().append(createTable(bateria,'','',2));
           $.isLoading("hide");
           //$(".pager_otas_por_validar").hide();

           var pagerOptions1 = {
               container: $(".pager"),
               output: 'Rows : {endRow}',
               fixedHeight: false,
               removeRows: true,
               cssGoto: '.gotoPage'
           };
          $(".table2").tablesorter({
              theme: 'blue',
              widgets: ["zebra", "filter"],
              widgetOptions: {
                  filter_cssFilter: '',
                  filter_childRows: false,
                  filter_hideFilters: false,
                  filter_ignoreCase: true,
                  filter_reset: '.reset',
                  filter_saveFilters: true
              }
          }).tablesorterPager(pagerOptions1);
          $(".pager").show();
        }


        if(bateria1.length == 0){

          $("#reporte_otas_validadas").empty();
          $("#reporte_otas_validadas").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
          $.isLoading("hide");
          //return false;

          if(chart1.length == 0){
              $("#chart3").empty();
              if ($("#chart3").highcharts()!=undefined){ 
                    $('#chart3').highcharts().reflow();  
              } 
              $("#chart3").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
              resizeChart();
              $.isLoading("hide");
              $("#inicio").show();
              flag = false;

          }

        }else {

          if(flag){

              createColumnChart3('chart3','Auditorías por Supervisor',chart0,porcent);
              

              var total = getTotal(chart0,[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18],2);
              total.shift();
              var header = Object.keys(chart0[0]);
              var AuxArray = new Array();
              for(var i=1;i<header.length;i++){

                  AuxArray.push({'estado':header[i],'Sitios': total[i-1]})
              }

          }

          //$("#cantidad").html(bateria.length);
          $("#reporte_otas_validadas").empty().append(createTable(bateria1,'','',1));
          resizeChart();
          
           $.isLoading("hide");

           
        }

    });
}

            /*function reporteBateria(){

                var data = {};
                data['medicion'] = $("#evento").val();
                data['region'] = $("#region").val();
                data['pais'] = $("#pais").val();
                data['fechaIni'] = $("#Filtros_fechaIni").val();
                data['fechaFin'] = $("#Filtros_fechaFin").val();
                data['idproyectos'] =  "" + {#{idproyectos}#};

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

                    var bateria  = data.bateria;
                    var chart1 = data.chart1;
                    var chart2 = data.chart2;
                    var flag = true;

                    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;

                    }if(chart1.length == 0){
                        $("#chart1").empty();
                        $("#chart1").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                        $.isLoading("hide");
                        $("#inicio").show();
                        flag = false;

                    }if(chart2.length == 0){
                        $("#chart2").empty();
                        $("#chart2").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                        $.isLoading("hide");
                        $("#inicio").show();
                        flag = false;

                    }

                    if(flag){

                        createColumnChart('chart1','Tipo de Auditorías por País',chart1);


                        var total = getTotal(chart1,[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18],2);
                        total.shift();
                        var header = Object.keys(chart1[0]);
                        var AuxArray = new Array();
                        for(var i=1;i<header.length;i++){

                            AuxArray.push({'estado':header[i],'Sitios': total[i-1]})
                        }

                        //createColumnChart('chart2','Implementation Deliverables',AuxArray);
                    }

                    if(flag){

                        //var series = getDataToObjectSerieAll(chart.grafico_HorasATT.data, Object.keys(chart.grafico_HorasATT.data[0]));
                        //var series = getDataToObjectSerieAll(data.chart2, Object.keys(data.chart2[0]));

                        createColumnChart2('chart2','First Time Right',chart2);


                        var total = getTotal(chart1,[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18],2);
                        total.shift();
                        var header = Object.keys(chart2[0]);
                        var AuxArray = new Array();
                        for(var i=1;i<header.length;i++){

                            AuxArray.push({'estado':header[i],'Sitios': total[i-1]})
                        }

                        //createColumnChart('chart2','Implementation Deliverables',AuxArray);
                    }


                    $("#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: true
                        }
                    }).tablesorterPager(pagerOptions);

                });
       }*/

       function createArrayToChart(chart,text)
       {
           var header = Object.keys(chart[0]);
           var x = new Array();
           var y = new Array();


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

                x.push(chart[i][header[0]]);

           }

           for(var j= 1;j<header.length;j++){

               y.push({name:"",data:[]});
           }


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

               for(var j= 1;j<header.length;j++){

                   if(i == 0){

                       y[j-1].name = header[j];
                   }
                  y[j-1].data.push(parseFloat(chart[i][header[j]]));
               }

           }



           return new Array(x,y);

       }

       function createArrayToPieChart(chart)
       {
           if(chart.length == 0) return false;
           var auxArray = new Array();
           var header = Object.keys(chart[0]);
           for(var i=0;i<chart.length;i++){



                   auxArray.push({'name':chart[i][header[0]],y:parseFloat(chart[i][header[1]])});



           }

           return auxArray;
       }

       function createColumnChart(renderTo,title,chart)
       {
           var data = createArrayToChart(chart);
           Highcharts.setOptions({
              colors: ["#2a587f", "#434348", "#90ed7d", "#f7a35c"],
          });
           var segundaGraficaOpt = {
               chart: {
                   type: 'column',
                   renderTo: renderTo,
                   borderColor: '#428bca',
                   borderWidth: 1,
                   zoomType: 'xy',
                   backgroundColor: {
                       linearGradient: [0, 0, 0, 450],
                       stops: [
                           [0, 'rgba(66, 139, 202, 0.3)'], //start
                           [0.5, '#ffffff'], // middle
                           [1, 'rgba(66, 139, 202, 0.2)'] //end
                       ]
                   }

               },

               title: {
                   text: title
               },

               xAxis: {
                   categories: data[0],
                   crosshair: true
               },

               yAxis: {

                   title: {
                       text: ''
                   },
                   plotLines:[]
               },

               tooltip: {
                   headerFormat: '<span style="font-size:10px">{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: true,
                   useHTML: true
               },

               plotOptions: {
                   column: {
                       pointPadding: 0.2,

                       borderWidth: 0,
                       depth: 40,
                       dataLabels: {
                           enabled: true,
                           crop: false,
                           overflow: 'none'
                       }
                   }
               },

               series: data[1]
           };

           new Highcharts.Chart(segundaGraficaOpt)
       }
               function createColumnChart2(renderTo,title,chart)
               {
                   var data = createArrayToChart(chart);
                   Highcharts.setOptions({
                      colors: ['#33a0ff', '#f1360a'],
                  });

                   var segundaGraficaOpt = {
                       chart: {
                           type: 'column',
                           renderTo: renderTo,
                           borderColor: '#428bca',
                           borderWidth: 1,
                           zoomType: 'xy',
                           backgroundColor: {
                               linearGradient: [0, 0, 0, 450],
                               stops: [
                                   [0, 'rgba(66, 139, 202, 0.3)'], //start
                                   [0.5, '#ffffff'], // middle
                                   [1, 'rgba(66, 139, 202, 0.2)'] //end
                               ]
                           }

                       },

                       title: {
                           text: title
                       },

                       xAxis: {
                           categories: data[0],
                           crosshair: true
                       },

                       yAxis: {

                           title: {
                               text: ''
                           },
                           plotLines:[]
                       },

                       tooltip: {
                           headerFormat: '<span style="font-size:10px">{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: true,
                           useHTML: true
                       },

                       plotOptions: {
                           column: {
                              cursor: 'pointer',
                              //series: data[1],
                              events:
                              {
                                click: function(e) {
                                  var asp = e.point.category;
                                  var estatus = this.name;
                                  //console.log(e.point.series.name);
                                  //console.log(e.point.category);
                                  //alert(asp);
                                  //alert(estatus);
                                  generateModal(asp,estatus);
                                }
                              },
                               pointPadding: 0.2,
                               borderWidth: 0,
                               depth: 40,
                               dataLabels: {
                                   enabled: true,
                                   crop: false,
                                   overflow: 'none'
                               }
                           }
                       },

                       series: data[1]
                   };
                    //console.log("data[1]",data[1],"data",data);
                   new Highcharts.Chart(segundaGraficaOpt)
               }

               function createColumnChart3(renderTo,title,chart,porcent)
                {
                    var data = createArrayToChart(chart);
                    var data1 = createArrayToChart(porcent);
                    var series = data[1];
                    //var series = chart[1];
                    Highcharts.setOptions({
                       colors: ['#33a0ff', '#5bb75b', "#2a587f"],
                   });

                   //console.log("SERIES",series);
                   //console.log("CHART",chart);

                   var arrayReturn = new Array();
                   var data0 = new Array();

                   if (series.length>0){
                       $.each(series, function(key, value) {
                         var countg = 0;
                         var xAxis = "";
                         var name = "";
                         var type = "";
                           $.each(value, function(k, v) {
                             countg++;
                               if(countg == 1){ //porcentaje
                                 if (v ==  "auditados") {
                                    xAxis = 0;
                                    name = '% AUDITADOS';
                                    type = 'spline';
                                 }else{
                                    xAxis = 1;
                                    name = v;
                                    type =  'column'
                               } //data0.push({"name":k.name,"data":v.data,yAxis: 0,type: 'column'});
                               }
                               if (countg == 2) {
                                 data0.push({"name":name,"data":v,yAxis: xAxis, type: type});
                               }
                           });
                       });
                       console.log("dataF",data0);
                   }

                    var segundaGraficaOpt = {
                        chart: {
                            type: 'column',
                            renderTo: renderTo,
                            borderColor: '#428bca',
                            borderWidth: 1,
                            zoomType: 'xy',
                            backgroundColor: {
                                linearGradient: [0, 0, 0, 450],
                                stops: [
                                    [0, 'rgba(66, 139, 202, 0.3)'], //start
                                    [0.5, '#ffffff'], // middle
                                    [1, 'rgba(66, 139, 202, 0.2)'] //end
                                ]
                            }

                        },
                        title: {
                            text: title
                        },

                        xAxis: {
                            categories: data[0],
                            crosshair: true
                        },


                        yAxis: [{
                            title: {
                                text: 'Quantity'
                            },
                            minPadding: 0,
                            maxPadding: 0,
                            //max: 100,
                            //min: 0,
                            labels: {
                                overflow: 'justify'
                            },
                        }, {
                            title: {
                                text: 'Percent (%)'
                            },
                            tickPositions: [0,20,40,60,80,100],
                            /*min: 0,
                            max: 100,*/
                            opposite: true,
                            labels: {
                                format: "{value}%"
                            }
                        }],

                        tooltip: {
                            headerFormat: '<span style="font-size:10px">{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: true,
                            useHTML: true
                        },

                        plotOptions: {
                            column: {
                                pointPadding: 0.2,

                                borderWidth: 0,
                                depth: 40,
                                dataLabels: {
                                    enabled: true,
                                    crop: false,
                                    overflow: 'none'
                                }
                            },
                            series:{
                                shadow:true,
                                dataLabels: {
                                  formatter: function () {
                                      if (this.series.name=='% AUDITADOS'){
                                          return this.point.y.toFixed(2) + '%';
                                      }else{
                                          return this.point.y;
                                      }
                                  },
                                    enabled: true,
                                    style: {
                                        fontWeight: 'bold'
                                    }
                                }
                            }
                        },

                        //series: data[1]
                        series: data0
                    };

                    //console.log("DATA0",data0);
                    //console.log("DATA",data[1]);
                    //console.log("DATA1",data1);
                    new Highcharts.Chart(segundaGraficaOpt)
                }

               function createPieChart(renderTo,title,chart)
               {
                   var data = createArrayToPieChart(chart);
                   //console.log(data);
                       var pie = {
                           chart: {
                               plotBackgroundColor: null,
                               plotBorderWidth: null,
                               plotShadow: false,
                               type: 'pie',
                               renderTo: renderTo
                           },
                           title: {
                               text: title
                           },
                           tooltip: {
                               pointFormat: '{series.name}: <b>{point.y:.0f}</b>'
                           },
                           plotOptions: {
                               pie: {
                                   allowPointSelect: true,
                                   cursor: 'pointer',
                                   dataLabels: {
                                       enabled: true,
                                       format: '<b>{point.name}</b>: {point.percentage:.1f} %',
                                       style: {
                                           color: (Highcharts.theme && Highcharts.theme.contrastTextColor) || 'black'
                                       }

                                   },
                                   showInLegend: true
                               }
                           },
                           series: [{
                               name: 'Sites',
                               colorByPoint: true,
                               data: data
                           }]
                       };
                   new Highcharts.Chart(pie);
               }


       /*$(".openModalDetail").live('click',function(){

         var id = $(this).attr("id");
         var datof = $(this).data('datof');
         //var datoff = datof.replace(" ","");
         //alert(datoff);


         $("#myModalDetalle1 .modal-body").empty();

                $("#myModalDetalle1").modal();
                var data = {'sitio':id,
                            'datof':datof}
                $.getJSON('{#{ path('reportemshonduras_DetalleConexionPlanta') }#}',data,function(data){
                $("#myModalDetalle1 .modal-body").html(createTable(data.monitor));
                 $("#myModalDetalle1").modal();

                });
           });*/

        function generateModal(asp,estatus){
          //alert(pais);
          if (estatus == 'NO FTR') {

            $('#myModalDetalle .modal-body').empty();
            $('#myModalDetalle').modal();
            $('#myModalDetalle .modal-body').isLoading({
                text: "Loading",
                position: "inside"
            });

            var fechaIni = $("#Filtros_fechaIni").val();
            var fechaFin = $("#Filtros_fechaFin").val();
            var pais =  $("#pais").val();
            $.ajax({

                url: "{{ path('reportemshonduras_reporteDetalleMapleAuditoria') }}",
                data: {'fechaIni': fechaIni, 'fechaFin': fechaFin, 'pais': pais, 'asp': asp,}
            }).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");
            });

          }

        }

        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;

                if (option == 1) {
                    table = '<table  id="tabla1" class="table table-bordered table-hover table-striped table1" style="text-align:left">';
                } else{
                    table = '<table  id="tabla2" class="table table-bordered table-hover table-striped table2">';
                }
                table += "<thead><tr>";
                for (var j = 0; j < header.length; j++) {
                    if (header[j] == 'URL') {
                        header[j] = 'ENTREGABLE';
                    };
                    var strHideFilter = "";
                    if (header[j] == 'ENTREGABLE') {
                         strHideFilter = " sorter-false filter-false "
                    }

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

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

                    /* if(j == header.length-1)
                     {
                     table += "<th style='vertical-align:middle;' class='text-center'>FICHA</th>";
                     }*/

                }

            table += "</tr></thead>";
            //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] !== 'ID' && header[j] != 'ENTREGABLE' && header[j] != 'DatoF') {
                        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']+">";
                    for (var j = 0; j < header.length + 1; j++) {
                        var clases = '';

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

                            if (header[j] == 'CALIFICACIÓN')
                            {
                                if (monitor[i]['CALIFICACIÓN'] < 98) {
                                    clases = 'btn-danger';
                                } else if (monitor[i]['CALIFICACIÓN'] >= 98) {
                                      clases = 'btn-success';
                                }

                            }

                            if (header[j] != 'FICHA' && header[j] != 'ENTREGABLE' && header[j] != 'ESTATUS' && header[j] != 'AUDITAR' && header[j] != 'AUDITAR SUP' && header[j] != 'AUDITAR RSC' && header[j] != '% AUDITADOS' && header[j] != '% DE AUDITADOS RSC' && header[j] != '% DE AUDITADOS SUP')
                            {

                                //  table += "<td class="+clases+">VER</td>";
                                if (j == header.length)
                                {
                                    //clases = 'btn-info';
                                    // table += "<th value=ver class="+clases+">VER</th>";

                                } else
                                {
                                    table += "<td   class=" + clases + ">" + monitor[i][header[j]] + "</td>";
                                }
                            }


                        }

                        if (header[j] == 'ESTATUS'){
                            if (monitor[i]['ESTATUS'] == 'Planta Conectada'){
                                 table += "<td class='text-center'>" + '<button type="button" id=' + monitor[i]['ID'] + ' data-datof=' + monitor[i]['DatoF'] + ' class="btn btn-default openModalDetail">Planta Conectada</button>' + "</td>";
                            }else{
                                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>";
                        }

                        if (header[j] == 'AUDITAR')
                        {
                            if (monitor[i]['AUDITAR'] == ' ') {
                              var t = monitor[i]['BOLSA MP'];
                              if (monitor[i]['REGION'] == 'ORIENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                var r = t*0.27;
                                var result = Math.round(r);
                                //Number.parseFloat(r);
                              }else if (monitor[i]['REGION'] == 'OCCIDENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                var r = t*0.50;
                                var result = Math.round(r);
                                //Number.parseFloat(r);
                              }else if (monitor[i]['REGION'] == 'CENTRAL') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                var r = t*0.27;
                                var result = Math.round(r);
                                //Number.parseFloat(r);
                              }else if (monitor[i]['REGION'] == 'METROPOLITANA') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                var r = t*0.27;
                                var result = Math.round(r);
                                //Number.parseFloat(r);
                              }

                               table += "<td   class=" + clases + ">" + result + "</td>";

                            }else   table += "<td   class=" + clases + ">" + monitor[i][header[j]] + "</td>";
                        }

                        if (header[j] == 'AUDITAR RSC')
                        {
                            if (monitor[i]['AUDITAR SUP'] == ' ') {
                              var t = monitor[i]['BOLSA MP'];
                              if (monitor[i]['REGION'] == 'ORIENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                /*var r = t*0.27;
                                var r1 = Math.round(r);*/
                                var r2 = t * .15;
                                var result2 =  Math.round(r2);
                                //Number.parseFloat(r);
                              }else if (monitor[i]['REGION'] == 'OCCIDENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                /*var r = t*0.50;
                                var r1 = Math.round(r);*/
                                var r2 = t * .23;
                                var result2 =  Math.round(r2);
                                //Number.parseFloat(r);
                              }else if (monitor[i]['REGION'] == 'CENTRAL') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                /*var r = t*0.27;
                                var r1 = Math.round(r);*/
                                var r2 = t * .18;
                                var result2 =  Math.round(r2);
                                //Number.parseFloat(r);
                              }else if (monitor[i]['REGION'] == 'METROPOLITANA') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                /*var r = t*0.27;
                                var r1 = Math.round(r);*/
                                var r2 = t * .12;
                                var result2 =  Math.round(r2);
                                //Number.parseFloat(r);
                              }

                               table += "<td   class=" + clases + ">" + result2 + "</td>";

                            }else   table += "<td   class=" + clases + ">" + monitor[i][header[j]] + "</td>";
                        }

                        if (header[j] == 'AUDITAR SUP')
                        {
                            if (monitor[i]['AUDITAR SUP'] == ' ') {
                              var t = monitor[i]['BOLSA MP'];
                              if (monitor[i]['REGION'] == 'ORIENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                /*var r = t*0.27;
                                var r1 = Math.round(r);*/
                                var r2 = t * .12;
                                var result1 =  Math.round(r2);
                                //Number.parseFloat(r);
                              }else if (monitor[i]['REGION'] == 'OCCIDENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                /*var r = t*0.50;
                                var r1 = Math.round(r);*/
                                var r2 = t * .27;
                                var result1 =  Math.round(r2);
                                //Number.parseFloat(r);
                              }else if (monitor[i]['REGION'] == 'CENTRAL') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                /*var r = t*0.27;
                                var r1 = Math.round(r);*/
                                var r2 = t * .09;
                                var result1 =  Math.round(r2);
                                //Number.parseFloat(r);
                              }else if (monitor[i]['REGION'] == 'METROPOLITANA') {
                                var t = monitor[i]['BOLSA MP'];
                                parseInt(t);
                                /*var r = t*0.27;
                                var r1 = Math.round(r);*/
                                var r2 = t * .15;
                                var result1 =  Math.round(r2);
                                //Number.parseFloat(r);
                              }

                               table += "<td   class=" + clases + ">" + result1 + "</td>";

                            }else   table += "<td   class=" + clases + ">" + monitor[i][header[j]] + "</td>";
                        }

                        if (header[j] == '% AUDITADOS')
                        {
                            if (monitor[i]['% AUDITADOS'] == ' ') {
                              var t = monitor[i]['BOLSA MP'];
                              if (monitor[i]['REGION'] == 'ORIENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var ar =  parseInt(monitor[i]['AUDITADOS RSC']);
                                  var as =  parseInt(monitor[i]['AUDITADOS SUP']);
                                  var re = (ar+as)/t*100;
                                  //var result3 =  Math.round(re);
                                  var result3 = parseFloat(re).toFixed(2);
                                  //alert(result3);
                                  var rf = result3+"%";
                                  if (result3 < 27) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }else if (monitor[i]['REGION'] == 'OCCIDENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var ar =  parseInt(monitor[i]['AUDITADOS RSC']);
                                  var as =  parseInt(monitor[i]['AUDITADOS SUP']);
                                  var re = (ar+as)/t*100;
                                  //alert(result3);
                                  //var result3 =  Math.round(re);
                                  var result3 = parseFloat(re).toFixed(2);
                                  var rf = result3+"%";
                                  if (result3 < 50) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }else if (monitor[i]['REGION'] == 'CENTRAL') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var ar =  parseInt(monitor[i]['AUDITADOS RSC']);
                                  var as =  parseInt(monitor[i]['AUDITADOS SUP']);
                                  var re = (ar+as)/t*100;
                                  var result3 = parseFloat(re).toFixed(2);
                                  //var result3 =  Math.round(re);
                                  //alert(re);
                                  var rf = result3+"%";
                                  if (result3 < 27) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }else if (monitor[i]['REGION'] == 'METROPOLITANA') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var ar =  parseInt(monitor[i]['AUDITADOS RSC']);
                                  var as =  parseInt(monitor[i]['AUDITADOS SUP']);
                                  var re = (ar+as)/t*100;
                                  var result3 = parseFloat(re).toFixed(2);
                                  //var result3 =  Math.round(re);
                                  //alert(result3);
                                  var rf = result3+"%";
                                  if (result3 < 27) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }

                               table += "<td   class=" + clases + ">" + rf + "</td>";

                            }else   table += "<td   class=" + clases + ">" + monitor[i][header[j]] + "</td>";
                        }

                        if (header[j] == '% DE AUDITADOS RSC')
                        {
                            if (monitor[i]['% DE AUDITADOS RSC'] == ' ') {
                              var t = monitor[i]['BOLSA MP'];
                              if (monitor[i]['REGION'] == 'ORIENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var ar =  parseInt(monitor[i]['AUDITADOS RSC']);
                                  var auditar_rsc = parseInt(t *.15).toFixed(2);
                                  var result0 = ar/t;
                                  var result1 =  parseFloat((result0)*100).toFixed(2);
                                  //alert(auditar_rsc);
                                  //alert(result1);
                                  /*var auditar_rsc = t * .15;
                                  var result0 =  Math.round(auditar_rsc);
                                  var result1 =  parseFloat((ar/result0)*15).toFixed(2);*/
                                  var rf = result1+"%";
                                  if (result1 < auditar_rsc) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }else if (monitor[i]['REGION'] == 'OCCIDENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var ar =  parseInt(monitor[i]['AUDITADOS RSC']);
                                  var auditar_rsc = parseInt(t * .23).toFixed(2);
                                  var result0 = ar/t;
                                  var result1 =  parseFloat((result0)*100).toFixed(2);
                                  /*var auditar_rsc = t * .23;
                                  var result0 =  Math.round(auditar_rsc);
                                  var result1 =  parseFloat((ar/result0)*23).toFixed(2);*/
                                  var rf = result1+"%";
                                  if (result1 < auditar_rsc) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }else if (monitor[i]['REGION'] == 'CENTRAL') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var ar =  parseInt(monitor[i]['AUDITADOS RSC']);
                                  var auditar_rsc = parseInt(t * .18).toFixed(2);
                                  var result0 = ar/t;
                                  var result1 =  parseFloat((result0)*100).toFixed(2);
                                  /*var auditar_rsc = t * .18;
                                  var result0 =  Math.round(auditar_rsc);
                                  var result1 =  parseFloat((ar/result0)*18).toFixed(2);*/
                                  var rf = result1+"%";
                                  if (result1 < auditar_rsc) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }else if (monitor[i]['REGION'] == 'METROPOLITANA') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var ar =  parseInt(monitor[i]['AUDITADOS RSC']);
                                  var auditar_rsc = parseInt(t * .12).toFixed(2);
                                  var result0 = ar/t;
                                  var result1 =  parseFloat((result0)*100).toFixed(2);
                                  /*var auditar_rsc = t * .12;
                                  var result0 =  Math.round(auditar_rsc);
                                  var result1 =  parseFloat((ar/result0)*12).toFixed(2);*/
                                  var rf = result1+"%";
                                  if (result1 < auditar_rsc) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }

                               table += "<td   class=" + clases + ">" + rf + "</td>";

                            }else   table += "<td   class=" + clases + ">" + monitor[i][header[j]] + "</td>";
                        }

                        if (header[j] == '% DE AUDITADOS SUP')
                        {
                            if (monitor[i]['% DE AUDITADOS SUP'] == ' ') {
                              var t = monitor[i]['BOLSA MP'];
                              if (monitor[i]['REGION'] == 'ORIENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var as =  parseInt(monitor[i]['AUDITADOS SUP']);
                                  var auditar_sup = parseInt(t *.12).toFixed(2);
                                  var result0 = as/t;
                                  var result1 =  parseFloat((result0)*100).toFixed(2);
                                  /*var auditar_sup = t * .12;
                                  var result0 =  Math.round(auditar_sup);
                                  var result1 =  parseFloat((as/result0)*12).toFixed(2);*/
                                  var rf = result1+"%";
                                  if (result1 < auditar_sup) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }else if (monitor[i]['REGION'] == 'OCCIDENTE') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var as =  parseInt(monitor[i]['AUDITADOS SUP']);
                                  var auditar_sup = parseInt(t *.27).toFixed(2);
                                  var result0 = as/t;
                                  var result1 =  parseFloat((result0)*100).toFixed(2);
                                  /*var auditar_sup = t * .27;
                                  var result0 =  Math.round(auditar_sup);
                                  var result1 =  parseFloat((as/result0)*27).toFixed(2);*/
                                  var rf = result1+"%";
                                  if (result1 < auditar_sup) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }else if (monitor[i]['REGION'] == 'CENTRAL') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var as =  parseInt(monitor[i]['AUDITADOS SUP']);
                                  var auditar_sup = parseInt(t *.09).toFixed(2);
                                  var result0 = as/t;
                                  var result1 =  parseFloat((result0)*100).toFixed(2);
                                  /*var auditar_sup = t *.09;
                                  var result0 =  Math.round(auditar_sup);
                                  var result1 =  parseFloat((as/result0)*9).toFixed(2);*/
                                  //alert(result0);
                                  //alert(result1);
                                  var rf = result1+"%";
                                  if (result1 < auditar_sup) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }else if (monitor[i]['REGION'] == 'METROPOLITANA') {
                                var t = monitor[i]['BOLSA MP'];
                                if (t == 0) {
                                  var rf = "_";
                                }else {
                                  var as =  parseInt(monitor[i]['AUDITADOS SUP']);
                                  var auditar_sup = parseInt(t *.15).toFixed(2);
                                  var result0 = as/t;
                                  var result1 =  parseFloat((result0)*100).toFixed(2);
                                  /*var auditar_sup = t * .15;
                                  var result0 =  Math.round(auditar_sup);
                                  var result1 =  parseFloat((as/result0)*15).toFixed(2);*/
                                  var rf = result1+"%";
                                  if (result1 < auditar_sup) {
                                      clases = 'btn-danger';
                                  }else{
                                        clases = 'btn-success';
                                  }
                                }
                              }

                               table += "<td   class=" + clases + ">" + rf + "</td>";

                            }else   table += "<td   class=" + clases + ">" + monitor[i][header[j]] + "</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')
                            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] == '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') {
                            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);
        }

     function llenarCombos(){
            $("#region option").remove();
            $("#region").append('<option value="TODOS">REGION</option>');
            var data = {};
            data['pais']=$("#pais").val();
            data['tabla'] = "appenate.mp_conexion_planta";
                //$.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");

                });
        };
        function resizeChart(){
            try{
                var panel_width = $('.tab-content').width();
                var offset = 32;
                console.log(panel_width-offset);
                $('#chart3').width(panel_width-offset);

                if ($("#chart3").highcharts()!=undefined){ 
                    $('#chart3').highcharts().reflow();  
                } 
                //redrawDt();
            }catch(err) {
                //console.log(err.message);
            }
        }
   
        $("#activar_5g").click(function(){
            resizeChart();
        });
    </script>

    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-12">
                {%if idproyectos!= 57%}
                    <img id="logo" class="pull-right" src="{{ asset('images/claro.jpg') }}"  width="220" height="72" >
                {%else%}
                    <img id="logo" class="pull-right" src="{{ asset('images/liberty.png') }}"  width="220" height="72" >
                {%endif%}    
             </div>
        </div>
        <div class="row">
             <div class="col-lg-2">
                <label>{{'monitores.pais' | trans}}: </label>
                <select class="form-control" id="pais">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    {%if (idproyectos!= 57)%}
                        {%for pais in paises%}
                            {%if (pais.eval_proyecto_id!= 6) %}
                                <option value="{{pais.eval_proyecto_id}}">{{pais.nombre}}</option>
                            {%endif%}
                        {%endfor%}
                    {%else%}
                        <option value="6">Panamá</option>
                    {%endif%}                        
                </select>
            </div>
            <div class="col-lg-2">
                <label> {{'monitor.etiqueta.fechaI' | trans}}:</label>
                <input class="form-control" type="text" id="Filtros_fechaIni" value="{{ dateStart }}">
            </div>
            <div class="col-lg-2">
                <label> {{'monitor.etiqueta.fechaF' | trans}}: </label>
                <input class="form-control" type="text" id="Filtros_fechaFin" value="{{ dateEnd }}">
            </div>
            <div class="col-lg-2">
                 <label>{{'monitor.etiqueta.region' | trans}}: </label>
                <select class="form-control" id="region">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                </select>
            </div>
             <!-- <div class="col-lg-2" id="parametros">
                 <label>{{'Estatus' | trans}}: </label>
                 <select class="form-control" id="evento">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    <option value="No_conexi_n_salida_en_Falso">{{'Salida en falso, No conectada' | trans}}</option>
                    <option value="Conexion_por_Falta_de_Energia_Comercial">{{'Planta Conectada' | trans}}</option>
                </select>
            </div>-->
            <div class="col-lg-2" id="parametros" style="vertical-align: bottom">
                <br>
               <button class="btn btn-claro" id="generar" style="vertical-align: bottom">{{'ticketDetail.boton.generar' | trans}}</button>
               <button class="btn btn-claro" id="clear" style="vertical-align: bottom">{{'ticketDetail.boton.limpiar' | trans}}</button>
            </div>

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

                <div class="col-lg-12 text-center"  style="margin-top: 1%">
                    <h1>{{'MAPLE QUALITY AUDITS' | trans}}</h1>
                 </div>

        </div>
        <!--<div class="row">
            <div class="col-lg-6" id="chart1">
            </div>
            <div class="col-lg-6" id="chart2">
            </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 %}
                </div>
            </div>
            <!--<div class="col-lg-offset-9" >
                <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>
        <br />
        <!--<div class="row">
            <div class="col-md-12" id="primer_reporte" style="overflow-x: auto;">
            </div>
        </div>-->
        <!--<div class="row" style="overflow-x: scroll; transform: rotateX(180deg);">
            <div class="double-scroll top-uno" id="primer_reporte" style="transform: rotateX(180deg);"></div>

        </div>-->


    </div>    
    <input type="hidden" id="total_monitor" name="total_monitor" value="0">
    <input type="hidden" id="total_monitor_validadas" name="total_monitor_validadas" value="0">
    <div class="row panel_content" style="margin: 10px 0 0 10px !important;">
        <div id="panel_content" class="col-lg-12">
            <ul class="nav nav-pills nav-justified activar_5g">
                <li idprocesos="155" headerid="1" gruopquery="4" class="active mainTab activar_ota_por_validar">
                    <a data-toggle="tab" href="#otas_por_validar"><strong>AUDITORIAS</strong></a>
                </li>
                <li idprocesos="155" headerid="1" gruopquery="4" class="mainTab activar_ota_validadas">
                    <a data-toggle="tab" href="#otas_por_validadas"><strong>EJECUTADOS</strong></a>
                </li>
            </ul>
            <div class="tab-content activar_5g" style="margin-top: 20px;width:100%">
                <div id="otas_por_validar" class="tab-pane active">
                    <div class="row">
                        <div class="col-lg-6" id="chart1">
                        </div>
                        <div class="col-lg-6" id="chart2">
                        </div>
                    </div>
                    <div class="row" style="margin: 30px 0 0 0px !important;">
                      <div class="col-lg-offset-9 col-md-offset-9">
                          <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="$('#reporte_otas_por_validar').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                              </ul>
                          </div>
                      </div>
                    </div>
                    <div class="pager pager_otas_por_validar" style="text-align: left">
                        <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                        <span class="pagedisplay"></span>
                    </div>
                    <div class="row">
                        <div class="col-md-12" id="reporte_otas_por_validar" style="overflow-x: auto;">
                        </div>
                    </div>
                    <!-- <div class="row double-scroll" id="reporte_otas_por_validar">

                    </div>-->
                </div>
                <div id="otas_por_validadas" class="tab-pane">
                    <div class="row">
                        <div class="col-lg-10" id="chart3">
                        </div>
                        <div class="col-lg-2">
                        </div>
                    </div>
                    <div class="row" style="margin: 30px 0 0 0px !important;">
                      <div class="col-lg-offset-9 col-md-offset-9">
                          <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="$('#reporte_otas_por_validar').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                              </ul>
                          </div>
                      </div>
                    </div>
                    <div class="pager pager_otas_validadas" style="text-align: left">
                        <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                        <span class="pagedisplay"></span>
                    </div>
                    <div class="row">
                        <div class="col-md-12" id="reporte_otas_validadas" style="overflow-x: auto;">
                        </div>
                    </div>
                    <!-- <div class="row double-scroll" id="reporte_otas_por_validar">

                    </div>-->
                </div>
            </div>
            <div class="row">
                <div id="pager" class="pager" 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="1000">1000</option>
                            <option  value="500">500</option>
                            <option  value="100">100</option>
                        </select>
                    </form>
                </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:1500px;">
            <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' | trans}}</h2>
                </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 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="myModalDetalle1" 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 FOTOGRAFIA' | trans}}</h2>
                </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 %}