{% 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: #428bca;
            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);}
        }

        #menuTop {
            margin-top: 10px;
        }
        .fixed-panel {
            min-height: 200px;
            /* max-height: 800px; */
            overflow-y: auto;
        }
        #parametros .panel-body .row{

            padding-left: 5px;
        }
        #chart .panel-body {
            padding: 0px;
        }

        .disabledTab{
            pointer-events: none;
        }
        .table-responsive {
            height: 400px !important;
            overflow: scroll;
            }
             .btn-claro {
            color: #fff;
            background-color: #428bca;
            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: #428bca;
            border-color: #428bca;
        }
        table.tablesorter thead tr th{
            height: 40px;
        }
        .tablesorter-blue .headerSortUp, .tablesorter-blue .tablesorter-headerSortUp, .tablesorter-blue .tablesorter-headerAsc {
            background-color: #428bca;}
        .tablesorter-blue .headerSortDown, .tablesorter-blue .tablesorter-headerSortDown, .tablesorter-blue .tablesorter-headerDesc {
            background-color: #428bca;}
        .tablesorter-blue .tablesorter-filter-row td {
            background: #428bca;border-color: #428bca;}
        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;
        }

        .tabla-detalle
        {
                text-transform: uppercase;
                font-size: 9px;
        }

        .disabledTab{
            pointer-events: none;
        }
        #menuTop { margin-top: 0px; }

        .form-inline .form-group { margin-bottom: 20px; }

        .form-group{ margin-left: 20px; }

        hr.style14 {
            border: 0;
            height: 1px;
            background-image: -webkit-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -moz-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -ms-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -o-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
        }

        .hrHide { display: none; }

        .highcharts-container{width:100% !important;}


        table th{
            {#text-transform: uppercase;#}
            font-weight: bold;
            font-size: 12px;
        }

        table td{
            {#text-transform: uppercase;#}
            font-weight: normal;
            font-size: 12px;
        }

        .commentList {
            padding:0;
            list-style:none;
            max-height:100px;
            overflow:auto;
        }
        .commentList li {
            margin:0;
            margin-top:10px;
        }
        .commentList li > div {
            display:table-cell;
        }
        .commentText p {
            margin:0;
        }
        .sub-text {
            color:#aaa;
            font-family:verdana;
            font-size:11px;
        }
        /********************************************************************/
        .panel.with-nav-tabs .panel-heading{
            padding: 5px 5px 0 5px;
        }
        .panel.with-nav-tabs .nav-tabs{
            border-bottom: none;
        }
        .panel.with-nav-tabs .nav-justified{
            margin-bottom: -1px;
        }
        /*** PANEL PRIMARY ***/
        .with-nav-tabs.panel-primary .nav-tabs > li > a,
        .with-nav-tabs.panel-primary .nav-tabs > li > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > li > a:focus {
            color: #fff;
        }
        .with-nav-tabs.panel-primary .nav-tabs > .open > a,
        .with-nav-tabs.panel-primary .nav-tabs > .open > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > .open > a:focus,
        .with-nav-tabs.panel-primary .nav-tabs > li > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > li > a:focus {
            color: #fff;
            background-color: #3071a9;
            border-color: transparent;
        }
        .with-nav-tabs.panel-primary .nav-tabs > li.active > a,
        .with-nav-tabs.panel-primary .nav-tabs > li.active > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > li.active > a:focus {
            color: #428bca;
            background-color: #fff;
            border-color: #428bca;
            border-bottom-color: transparent;
        }
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu {
            background-color: #428bca;
            border-color: #3071a9;
        }
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > li > a {
            color: #fff;
        }
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > li > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > li > a:focus {
            background-color: #3071a9;
        }
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > .active > a,
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > .active > a:hover,
        .with-nav-tabs.panel-primary .nav-tabs > li.dropdown .dropdown-menu > .active > a:focus {
            background-color: #4a9fe9;
        }
        /********************************************************************/
        input {
            -webkit-appearance: textfield;
            background-color: white;
            color: #1b1b1b;
            font-weight: lighter;
            -webkit-rtl-ordering: logical;
            cursor: text;
            padding: 1px;
            border-width: 1px;
            border-style: solid;
            border-color: #1B1B1B !important;
            border-image: initial;
        }
        .dataTables_length select {
            width: 60px;
        }
        .dataTables_length label {
            font-weight: normal;
        }
        table.dataTable thead th{
            border-bottom: 1px solid #3071a9 !important;
        }
        table.dataTable tfoot th{
            border-top: 1px solid #3071a9 !important;
        }
        .dataTables_scroll{
            border: 1px solid #3071a9 !important;
        }
        div.dt-buttons {
            position: relative !important;
            float: right !important;
            margin-right: -5px !important;
        }
        .header_dt{
            color: #fff;
            background-color: #428bca;
            border-color: #3071a9 !important;
        }
        .highcharts-graph {
            filter: url(#glow);
        }

        .list-group-item {
            position: relative;
            display: block;
            padding: 2px 5px !important;
            margin-bottom: -1px;
            background-color: #fff;
            border: 1px solid #ddd;
        }
        .Resizer {
            padding: 0;
            margin: 0;
            top: 0;
            left: 0;
        }

        .contentWindow{
            position: absolute;
            background-color: #B4E0DE;
        }

        .resizer{
            position: absolute;
            z-index: 100;
            background-color: #4E6160;
        }

        .verticalResizer{
            cursor: ns-resize;
        }

        .horizontalResizer{
            cursor: ew-resize;
        }
        .panel .panel-primary {
            min-height: 100px;
            max-height: 300px;
            height: 300px;
            overflow-y: scroll;
            overflow-x: scroll;
        }
        .nav-link.active {
            font-weight: bold;
        }

        .badge {
            font-size: 85%;
        }

    </style>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script src="{{ asset('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();

          $.fn.dataTable.moment( 'YYYY-MMM' );
          $('#Filtros_fechaIni').datepicker({
              dateFormat: 'yy-mm-dd',
              onClose: function (selectedDate){
                  $("#Filtros_fechaFin").datepicker("option", "minDate", selectedDate);
              }
          });
          $('#Filtros_fechaFin').datepicker({
              dateFormat: 'yy-mm-dd',
          });
          //
          $('#fechaIni').datepicker({
              dateFormat: 'yy-mm-dd',
              onClose: function (selectedDate){
                  $("#fechaFin").datepicker("option", "minDate", selectedDate);
              }
          });
          $('#fechaFin').datepicker({
              dateFormat: 'yy-mm-dd',
          });
          //
          var f = new Date();
          var mes = (f.getMonth() + 1);
          if (mes < 10)
              mes = '0' + mes;
          var fechaI = f.getFullYear() + '-' + mes + "-01";
          var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();
          $('#fechaIni').val(fechaI);
          $('#fechaFin').val(fechaF);
          $(".div_fecha").hide();
          $(".ajuste_fecha").click(function(){
              $('.ajuste_fecha').removeClass('btn-primary');
              $('.ajuste_fecha').addClass('btn-default');
              var id = $(this).attr('id');
              $("#"+id).addClass('btn-primary');
              $(".div_fecha").hide();
              if (id=="rango_fecha"){
                  $(".div_fecha").show();
              }
              rangosFecha(id);
          });

          var intervalTime = null;
          $("#autoload").click(function(){
              var time = parseInt($("#time").val());
              if($(this).prop('checked')){
                  intervalTime  =  window.setInterval(reporteBateria, time);
              }else{
                  clearInterval(intervalTime);
              }
          });
          function intervalReport(fun,time){

          }
          $('.datepicker').datepicker({
              dateFormat: 'yy-mm-dd',
              maxDate: new Date(),
              defaultDate: new Date(),
          }).datepicker("setDate", new Date());
          $("#type").change(function(){

          });
          var starYear = 2020;
          var d = new Date();
          var year = d.getFullYear();
          var month = new Array();
          $(".checklist").live('click', function () {
              window.location.href = $(this).attr('href');
          });
      for(var i=starYear; year >= i;i++ )
      {
          $('#ano').append($("<option/>", {
              value: i,
              text: i
          }));
      }
          var anho_actual = i-1;

          month[0] = "January";
          month[1] = "February";
          month[2] = "March";
          month[3] = "April";
          month[4] = "May";
          month[5] = "June";
          month[6] = "July";
          month[7] = "August";
          month[8] = "September";
          month[9] = "October";
          month[10] = "November";
          month[11] = "December";
          var n = month[d.getMonth()];
          var options = new Array();
          for(var i=0;i<month.length;i++){
              if(i <=  d.getMonth()){
                  $('#mes').append($("<option/>", {
                      value: i + 1,
                      text: month[i]
                  }));

              }
          }

          $("#ano").change(function(){
              var yearSelected = parseInt($(this).val());
              var semana = ISO8601_week_no(new Date());
              console.log(yearSelected + ' - ' + semana);
              $('#mes').empty();
              for(var i=0;i<month.length;i++) {
                  if (yearSelected < year) {
                      $('#mes').append($("<option/>", {
                          value: i + 1,
                          text: month[i]
                      }));
                  }else if(i <=  d.getMonth()){
                      $('#mes').append($("<option/>", {
                          value: i + 1,
                          text: month[i]
                      }));
                  }
              }
              $('#semana').empty();
                  if (yearSelected < year) {
                          var semana = 52;
                      for(var i=semana;i>=1;i--){
                          $('#semana').append($("<option/>", {
                              value: i,
                              text: i
                          }));
                      }
                  }else{
                      for(var i=semana;i>=1;i--){
                          $('#semana').append($("<option/>", {
                              value: i,
                              text: i
                          }));
                      }
                  }
          });
          $('#ano').val(anho_actual);
          $('#ano').trigger("change");

          $("#tipoBusqueda").on('change load',function(){

              $(this).val() == 'mes' ? $("#mes").removeAttr('class','hide'):$("#mes").addClass('hide');
              $(this).val() == 'semana' ? $("#semana").removeAttr('class','hide'):$("#semana").addClass('hide');
              $(this).val() == 'dia' ? $("#dia").removeClass('hide'):$("#dia").addClass('hide');
          });
          $("#generar").click(function (){
              if ($("#rango_fecha").hasClass("btn-primary")){
                  $('#Filtros_fechaIni').val($('#fechaIni').val());
                  $('#Filtros_fechaFin').val($('#fechaFin').val());
              }
              if ($('#Filtros_fechaIni').val()=="" ||  $('#Filtros_fechaFin').val()==""){
                  swal("Error!", "Date Required", "error");
              }else{
                  $.isLoading({
                      text: "Loading"
                  });
                  reporteBateria();
              }
          });


            $(".activar_sitios_por_auditar").click(function(){
              //alert($("#total_monitor").val());
                if ($("#total_monitor_sitios").val()>0){
                    $(".pager_sitios_por_auditar").show();
                            var pagerOptions1 = {
                                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(pagerOptions1);
                    $(".pager").show();
                }else{
                    $(".pager_sitios_por_auditar").hide();
                }
            });
            $(".activar_ota_por_validar").click(function(){
                if ($("#total_monitor").val()>0){
                    $(".pager_otas_por_validar").show();
                            var pagerOptions2 = {
                                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(pagerOptions2);
                    $(".pager").show();
                }else{
                    $(".pager_otas_por_validar").hide();
                }
            });
            $(".activar_ota_validadas").click(function(){

                if ($("#total_monitor_validadas").val()>0){
                          $(".pager_otas_validadas").show();
                          var pagerOptions3 = {
                              container: $(".pager"),
                              output: 'Rows : {endRow}',
                              fixedHeight: false,
                              removeRows: true,
                              cssGoto: '.gotoPage'
                          };
                            $(".table3").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(pagerOptions3);
                    $(".pager").show();
                }else{
                    $(".pager_otas_validadas").hide();
                }
            });

            $(".activar_power").click(function(){
              resizeChart();

                if ($("#total_monitor_power").val()>0){
                          $(".pager_pr_power").show();
                          var pagerOptions4 = {
                              container: $(".pager"),
                              output: 'Rows : {endRow}',
                              fixedHeight: false,
                              removeRows: true,
                              cssGoto: '.gotoPage'
                          };
                            $(".table4").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(pagerOptions4);
                    $(".pager").show();
                }else{
                    $(".pager_pr_power").hide();
                }
            });

            /*$(".activar_summary").click(function(){
                //resizeChart();
                $(".pager").hide();
            });*/

            $(".click_tab").click(function(){
                resizeChart();
                $(".pager").hide();
            });
            $('a[data-toggle="tab"]').on( 'shown.bs.tab', function (e) {
                $.fn.dataTable.tables( {visible: true, api: true} ).columns.adjust();
                try{
                    resizeChart();
                }catch(err) {
                    //console.log(err.message);
                }
            });


            $(document).on("click", ".downloadTemplate", function () {

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

              var ruta = `{{path('reportamx_DownloadPowerSiteAdaption')}}?pais=${ data['pais']}&proyecto=${ data['proyecto']}&region=${ data['region']}&idproyectos=${data['idproyectos']}&fechaIni=${data['fechaIni']}&fechaFin=${data['fechaFin']}`
              //window.open(ruta);
              $('#downloadTemplate').attr("href",ruta);

              //alert(ruta);
            });

            $(document).on("click", ".downloadTemplate2", function () {

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

              var ruta = `{{path('reportamx_DownloadPowerSiteAdaption')}}?pais=${ data['pais']}&proyecto=${ data['proyecto']}&region=${ data['region']}&idproyectos=${data['idproyectos']}&fechaIni=${data['fechaIni']}&fechaFin=${data['fechaFin']}`
              //window.open(ruta);
              $('#downloadTemplate2').attr("href",ruta);

              //alert(ruta);
            });

            function rangosFecha(opcion){
                //para el dia actual
                if (opcion=='hoy'){
                    var f = new Date();
                    var mes = (f.getMonth() + 1);
                    if (mes < 10) mes = '0' + mes;
                    var dia = f.getDate();
                    if (dia < 10) dia = '0' + dia;
                    var fechaI = f.getFullYear() + '-' + mes + "-" + dia;
                    var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
                }
                //para ultimos_7_dias
                if (opcion=='ultimos_7_dias'){
                    var f = new Date();
                    //console.log(f);
                    var mes = (f.getMonth() + 1);
                    if (mes < 10) mes = '0' + mes;
                    //OBTENER EL DIA DE LA SEMANA DE LA FECHA ACTUAL
                    var weekday = f.getDay();
                    //console.log(weekday);
                    //SI ES LUNES
                    if (weekday==1){
                        var nueva_fecha = new Date();
                        var nuevo_mes = (nueva_fecha.getMonth() + 1);
                        if (nuevo_mes < 10) nuevo_mes = '0' + nuevo_mes;
                        var dia_n = nueva_fecha.getDate();
                        if (dia_n < 10) dia_n = '0' + dia_n;
                    }else{
                        if (weekday==2){ //SI ES MARTES
                            cantidad_dias_restar = 1;
                        }
                        if (weekday==3){ //SI ES MIERCOLES
                            cantidad_dias_restar = 2;
                        }
                        if (weekday==4){ //SI ES JUEVES
                            cantidad_dias_restar = 3;
                        }
                        if (weekday==5){ //SI ES VIERNES
                            cantidad_dias_restar = 4;
                        }
                        if (weekday==6){ //SI ES SABADO
                            cantidad_dias_restar = 5;
                        }
                        if (weekday==0){ //SI ES DOMINGO
                            cantidad_dias_restar = 6;
                        }
                        var dias_restar = 1000 * 60 * 60 * 24 * cantidad_dias_restar;
                        var resta = f.getTime() - dias_restar;
                        var nueva_fecha = new Date(resta);
                        var nuevo_mes = (nueva_fecha.getMonth() + 1);
                        if (nuevo_mes < 10) nuevo_mes = '0' + nuevo_mes;
                        var dia_n = nueva_fecha.getDate();
                        if (dia_n < 10) dia_n = '0' + dia_n;
                    }
                    var fechaI = nueva_fecha.getFullYear() + '-' + nuevo_mes + "-" + dia_n;
                    var dia = f.getDate();
                    if (dia < 10) dia = '0' + dia;
                    var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
                }
                //para el mes actual
                if (opcion=='mes_actual'){
                    var f = new Date();
                    var mes = (f.getMonth() + 1);
                    if (mes < 10) mes = '0' + mes;
                    var fechaI = f.getFullYear() + '-' + mes + "-01";
                    var dia = f.getDate();
                    if (dia < 10) dia = '0' + dia;
                    var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
                }
                //para mes_anterior
                if (opcion=='mes_anterior'){
                    //desde
                   const f1=moment().subtract(1, 'months').startOf('month').format('DD-MM-YYYY');
                   //console.log(f1);
                   var fInicial = f1.split('-');
                   //hasta
                   const f2=moment().subtract(1, 'months').endOf('month').format('DD-MM-YYYY');
                   var fFinal = f2.split('-');
                   //actualizar
                   var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
                   var fechaF = fFinal[2] + '-' + fFinal[1] + "-" + fFinal[0];

                }
                //para las 6 meses
                if (opcion=='ultimo_6_meses'){
                    //desde
                   const f1=moment().subtract(5, 'months').startOf('month').format('DD-MM-YYYY');
                   //console.log(f1);
                   var fInicial = f1.split('-');
                   //hasta
                   var f = new Date();
                   var mes = (f.getMonth() + 1);
                   if (mes < 10) mes = '0' + mes;
                   //actualizar
                   var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
                   var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();
                }
                //para las 12 meses
                if (opcion=='ultimo_12_meses'){
                    //desde
                   const f1=moment().subtract(12, 'months').startOf('month').format('DD-MM-YYYY');
                   var fInicial = f1.split('-');
                   //hasta
                   var f = new Date();
                   var mes = (f.getMonth() + 1);
                   if (mes < 10) mes = '0' + mes;
                   //actualizar
                   var dia = f.getDate();
                   if (dia < 10) dia = '0' + dia;
                   var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
                   var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
                }
                $('#Filtros_fechaIni').val(fechaI);
                $('#Filtros_fechaFin').val(fechaF);
                if (opcion!='rango_fecha'){
                    $("#generar").trigger('click');
                }
            }

            {%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();
                   llenarCombos2();
                   llenarCombos3();*/
            {%endif%}

            $("#pais").change(function(){
               if  ($("#pais").val() != "TODOS"){
                        $.isLoading({
                                text: "Loading"
                        });
                      /*llenarCombos();
                      llenarCombos2();
                      llenarCombos3()*/
               }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_sitios_por_auditar").addClass('active');
  $(".activar_ota_por_validar").removeClass('active');
  $(".activar_ota_validadas").removeClass('active');
  $(".activar_power").removeClass('active');
  $(".click_tab").removeClass('active');

  $("#sitios_por_auditar").addClass('active');
  $("#otas_por_validar").removeClass('active');
  $("#otas_por_validadas").removeClass('active');
  $("#pr_power").removeClass('active');
  $("#pr_summary").removeClass('active');
    /*{% if (is_granted('ROLE_AMX_AUDITORIA_SITES') ) %}
    $(".activar_sitios_por_auditar").addClass('active');
    $(".activar_ota_por_validar").removeClass('active');
    $(".activar_ota_validadas").removeClass('active');
    $(".activar_power").removeClass('active');
    $(".click_tab").removeClass('active');

    $("#sitios_por_auditar").addClass('active');
    $("#otas_por_validar").removeClass('active');
    $("#otas_por_validadas").removeClass('active');
    $("#pr_power").removeClass('active');
    $("#pr_summary").removeClass('active');
    {% else %}
    $(".activar_ota_por_validar").addClass('active');
    $(".activar_ota_validadas").removeClass('active');
    $(".activar_power").removeClass('active');
    $(".click_tab").removeClass('active');

    $("#otas_por_validar").addClass('active');
    $("#otas_por_validadas").removeClass('active');
    $("#pr_power").removeClass('active');
    $("#pr_summary").removeClass('active');
    {% endif %}*/
    var parametros = {};
    parametros['medicion'] = $("#evento").val();
    parametros['region'] = $("#region").val();
    parametros['pais'] = $("#pais").val();
    parametros['proyecto'] = $("#proyecto").val();
    parametros['asp'] = $("#asp").val();
    parametros['fechaIni'] = $("#Filtros_fechaIni").val();
    parametros['fechaFin'] = $("#Filtros_fechaFin").val();
    parametros['valor'] = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();
    parametros['idproyectos'] =  "" + {{idproyectos}};

    /*parametros = {};
    var inicio = $('#Filtros_fechaIni').val();
    var fin = $('#Filtros_fechaFin').val();
    var valor = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();
    var detail = $("#detail").val();

    var parametros = {
        'FechaInicio': inicio,
        'FechaFin': fin,
        'date': valor,
        'detail': detail,
        'idproyectos':'{{idproyectos}}',
    };*/

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

        var bateria0  = data.bateria0;
        var bateria  = data.bateria;
        var bateria1  = data.bateria1;
        var chart1 = data.chart1;
        var chart2 = data.chart2;
        var chart3 = data.chart3;
        var flag = true;
        console.log(bateria0);
        console.log(bateria);
        console.log(bateria1);
        $("#total_monitor_sitios").val(bateria0.length);
        $("#total_monitor").val(bateria.length);
        $("#total_monitor_validadas").val(bateria1.length);
        //$("#total_monitor_power").val(bateria2.length);

        if(bateria0.length == 0){
          $(".pager_sitios_por_auditar").hide();
          $("#reporte_sitios_por_auditar").empty();
          $("#reporte_sitios_por_auditar").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
          $.isLoading("hide");
        }else {
          //$("#cantidad").html(bateria.length);
          $("#reporte_sitios_por_auditar").empty().append(createTable(bateria0,'','',1));
           $.isLoading("hide");
           //$(".pager_otas_por_validar").hide();

           var pagerOptions1 = {
               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(pagerOptions1);
          $(".pager").show();
        }

        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(flag){

            createColumnChart('chart1','Deliverables',chart1);
        }

        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;
        }else {
          //$("#cantidad").html(bateria.length);
          $("#reporte_otas_por_validar").empty().append(createTable2(bateria,'','',2));
          //resizeChart();
           $.isLoading("hide");
           /*{% if (is_granted('ROLE_AMX_AUDITORIA_SITES') ) %}

           {% else %}
            var pagerOptions2 = {
                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(pagerOptions2);
           $(".pager").show();
           {% endif %}*/
        }

        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('chart2','Deliverables',chart2);
        }

        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;
        }else {
          //$("#cantidad").html(bateria.length);
          $("#reporte_otas_validadas").empty().append(createTable(bateria1,'','',3));
          //resizeChart();
           $.isLoading("hide");

        }

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

        }
        if(flag){

            createColumnChart('chart3','Deliverables',chart3);
        }

    });
}



        function generateModal(ruta, objParams, numerar, title, subtitle, orderArray)
         {
             var title_ = title!=null ? title.trim() : "";
             var ordArr = orderArray!=null ? orderArray : null;
             //$('#tbodyModalDetalle').empty();
             $("#datatableModalDetalle").empty().isLoading();
             $('#myModal .punto-grafica').empty().hide();
             $('#myModal .modal_detalle_titulo').empty();
             if (title != null)
             {
                 $('#myModal .modal_detalle_titulo').html(title);
                 title_ = title_.replace(' ','_');
                 title_ = title_.replace('-','');
                 title_ = title_.replace(' ','');
             }
             else
             {
                 $('#myModal .modal_detalle_titulo').html('{{'monitorii.detail' | trans }}');
                 title = '{{'monitorii.detail' | trans }}';
                 title_ = title_.replace(' ','_');
                 title_ = title_.replace('-','');
                 title_ = title_.replace(' ','');
             }
             if (subtitle != null)
             {
                 $('#myModal .punto-grafica').html(subtitle).show();
             }
             console.log(ruta, objParams);
             //$.getJSON('{{path('reportamx_detalleGraficas')}}', data, function (data)
             $.getJSON(ruta, objParams, function (data)
             {
               var bateria  = data.bateria;
                 if (bateria.length > 0){
                     var total_general = 0;
                     var porcentaje_ohs = 0;
                     var total_registros = 0;
                     var col = createTableDTDetail(Object.keys(bateria[0]),'tableModalDetalle', 'datatableModalDetalle',title_,total_registros);
                     buildDatatablePrin('tableModalDetalle',col,bateria,title_,ordArr);
                     $('[data-toggle="popover"]').popover('destroy');
                     $('[data-toggle="popover"]').popover({
                         template: '<div class="popover" role="tooltip" style="width: 800px;"><div class="arrow"></div><h3 class="popover-title"></h3><div class="popover-content"><div class="data-content"></div></div></div>'
                     }).on("show.bs.popover", function () { $(this).data("bs.popover").tip().css("max-width", "600px"); });
                 }else{
                     $("#datatableModalDetalle").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                 }
                 $("#datatableModalDetalle").isLoading('hide');
             });

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

         $('#myModal').on('hidden.bs.modal', function (){
             $('#myModal .tabla-datos').isLoading('hide');
         });

         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(parseInt(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);

             var segundaGraficaOpt = {
                 chart: {
                     type: 'column',
                     renderTo: renderTo,

                 },

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

         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 createTableDTDetail(data, tableRender, dtRender, type, total_registros){
            var strHeader = "";
            var strFooter="";
            var columns = [];
            var col_issues = 8;
            var strType = (type == null ? "" : type);
            var strTable = '<table id="' + tableRender + '" class="display cell-border compact stripe" width="100%">' +
                    '<thead><tr class="header_dt">';
            $('#' + dtRender).empty();
            //console.log('strType',strType);
            switch(strType.toLocaleUpperCase()){
                case 'QP':
                case 'QP_DETAIL':
                    col_issues = 8;
                    break;
                case 'OHS':
                case 'OHS_DETAIL':
                    col_issues = 9;
                    break;
                case 'FTR':
                    col_issues = 8;
                    break;
                case 'FTR_ASP':
                    col_issues = 8;
                    break;
            }
            for (var i=0; i<data.length; i++){
                var title = data[i];
                var t = title.replace(/_/g,' ');
                t = title.replace('#','');
                var visible = title.startsWith('_') ? false : true;
                strHeader += '<th class="text-center">' + t + '</th>';
                if (title=="USAGE BY MODULE" || title=="Not Ok" || title=="ISSUES ERROR" || title=="SYSTEM FAULT FOUND" || title=="Total Corrected"){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi="";
                                var popup_title = "";
                                var strIssuesText = "";
                                var url= "";
                                if (row.hasOwnProperty('_ISSUES')){
                                    kpi='ftr';
                                    popup_title = 'Issues';
                                    var issues = row['_ISSUES'];
                                    var arrIssues = issues == null ? null : issues.split("<br>");
                                    if (arrIssues!=null){
                                        var strIssuesHtml = "<ol>";
                                        if (Array.isArray(arrIssues)){
                                            for (var i=0; i<arrIssues.length; i++){
                                                strIssuesHtml += "<li>" + arrIssues[i] + ".</li>";
                                                strIssuesText += i + ". " +  arrIssues[i] + ".\r\n";
                                            }
                                        }else{
                                            strIssuesHtml = issues;
                                        }
                                        strIssuesHtml += "</ol>";
                                    }
                                }
                                if (type==='display' && strIssuesText!=''){
                                    return '<a href="javascript://"  data-toggle="popover" data-title="<b>Issues</b>" ' +
                                            'data-container="body" data-placement="left" data-html="true" ' +
                                            'data-trigger="focus" ' +
                                            'data-content="' + strIssuesHtml  + '"' +
                                            '>' + dato + '</a>';
                                }else{
                                    return dato;
                                }
                            }
                            return dato;
                        }
                    });
                }else{
                    columns.push({data: data[i], title: t, visible:visible});
                }
            }
            strTable += strHeader + '</tr></thead><tbody id="tbody_' + tableRender + '"></tbody>' + strFooter + '</table>';
            $('#' + dtRender).empty();
            $('#' + dtRender).html(strTable);
            $('#' + tableRender + ' thead tr').clone(true).appendTo( '#' + tableRender + ' thead' );
            $('#' + tableRender + ' thead tr:eq(1) th').each( function (i) {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%; margin: 0px; padding: 0px;"/>' );
                $( 'input', this ).on( 'keyup change', function () {
                    if ( $.fn.DataTable.isDataTable( '#' + tableRender ) ) {
                        var table = $('#' + tableRender).DataTable();
                        if ( table.column(i).search() !== this.value ) {
                            table
                                    .column(i)
                                    .search( this.value )
                                    .draw();
                        }
                    }
                } );
            } );
            return columns;
         }

         //configuracion de los datatable
         function buildDatatablePrin(render, columnas, data,suffix_export,orderArray)
         {
             var a=[];b=[];
             var Defs = [];
             var ini = (columnas.length) -5;
             var kpi = '';
             if (render=='table_IssuesExecuted'){
                 kpi = 'Issues Executed';
             }else if(render=='table_ExecutedNotExecuted'){
                 kpi = 'Reasons Not Executed';
             }

             for (var i=0; i<=(columnas.length - 1); i++){
                 a.push(i);
             }
             Defs.push({ targets: a, className: 'dt-body-center' });
             for (var i=0; i<=(columnas.length - 1); i++){
                 if (columnas[i].visible){
                     b.push(i);
                 }
             }
             table = $('#'+render).DataTable( {
                 dom: '<"row" <"col-md-12 text-right"B>> <"row" <"col-md-6 "l> <"col-md-6"f>>rtip',
                 scrollY: '60vh',
                 scrollX: true,
                 scrollCollapse: true,
                 orderCellsTop: true,
                 data:data,
                 "deferRender": false,
                 "processing": true,
                 "language": {
                     "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                 },
                 //"order": [[ 0, "asc" ]],
                 "ordering": false,
                 columns: columnas,
                 columnDefs: Defs,
                 lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                 buttons: [
                     {
                         extend:'excel',
                         text: 'Table Excel ' + kpi,
                         exportOptions: {
                             columns: b,
                             orthogonal: 'export'
                         },
                         title: 'Usage' + kpi
                     }
                 ],
                 drawCallback: function() {
                     $('[data-toggle="popover"]').popover();
                 }
             } );
         }

  function getDataToObjectSerieAll(data, header){
            var arrayReturn = new Array();
            var data1 = new Array();
            var menor = 1000;
            var mayor = -1;
            var total = 0;
            var valorA=0;
            var dataAux = new Array()

            for (var i = 0; i < header.length; i++){
                var dataAux = new Array();
                var dataAux1 = new Array();
                valorA=0;
                total = 0;
                if (header[i].indexOf('_cat_') < 0){
                    for (var j=0; j<data.length; j++){

                        var valor = parseFloat(data[j][header[i]]);
                        valorA+= valor;
                        total+=valor;
                        dataAux.push(valor);
                        dataAux1.push(valorA);
                        console.log(valorA);
                        if (valor < menor){
                            menor = valor;
                        }
                        if (valor > mayor){
                            mayor = valor;
                        }

                    }

                    for (var k=0; k<dataAux1.length; k++){
                        dataAux1[k]=Math.round(parseFloat((dataAux1[k]/total)*100));
                    }

                    if(header[i]!="pareto") arrayReturn.push({'name': header[i], 'data': dataAux, 'dataLabels': {'enabled': true}});
                    arrayReturn.push({'name': 'pareto1', 'data': dataAux1, 'dataLabels': {'enabled': true}});
                }
            }
            data1[0] = arrayReturn;
            data1[1] = menor;
            data1[2] = mayor;
            return data1;
        }

  function createChartColumn(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, parametros, orderArray, path, rawData,height){
            //ajustar la serie para la doble axies
            var arrayReturn = new Array();
            var data = new Array();
            if (series.length>0){
                $.each(series, function(key, value) {
                    $.each(value, function(k, v) {
                        //data.push({"name":v.name,"data":v.data,type: 'column'});

                            if(k==0){
                               data.push({"name":v.name,"data":v.data,type: 'column'});
                            }else{
                                data.push({"name":"%","data":v.data,yAxis: 1});
                            }
                    });
                });
            }
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            switch (render){
                case 'grafico_Causas':
                        rotation = -45;
                        break;
                case 'grafico_CausasR':
                        rotation = -45;
                        break;
            }
            console.log(data);
            var porcentaje = data[0].data;
            //console.log("Hola");
            //console.log(porcentaje);
            if (porcentaje!="" && porcentaje!=undefined){
                var yMax = porcentaje.reduce(function(a, b) {
                    return Math.max(a, b);
                });
                if (yMax==0){
                    yMax=35;
                }
            }else{
                var yMax=35;
            }
            console.log(yMax);
            //var height = 320;
             var options = {
                chart: {
                    //height: height,
                    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
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: ''
                  },
                  enableMouseTracking : false,
                  xAxis: {
                        categories: [],
                        lineWidth: 1,
                        lineColor: '#4c4c4c',
                        //tickColor: '#4c4c4c',
                        //tickWidth: 1,
                        //minorTickWidth: 1,
                        crosshair: true,
                        labels: {
                            groupedOptions: [{ // 1st-level
                                autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                //rotation: -30,
                                lineWidth: 1,
                                tickWidth: 1,
                                style: {
                                    fontSize: '10px',
                                    color: '#333333'
                                    //color: '#4c4c4c'
                                }
                            }, // 2nd-level
                                {
                                    autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                    //rotation: 0,
                                    lineWidth: 0,
                                    tickWidth: 0,
                                    //align: 'right',
                                    style: {
                                        fontSize: '9px',
                                        color: '#333333'
                                        //color: '#4c4c4c'
                                    }
                                }
                            ],
                            //step: step,
                            lineWidth: 0,
                            tickWidth: 0,
                            rotation: 0,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            },
                            formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                                if(this.value.length > 15){
                                    return this.value.substring(0, 15) + '...';
                                }
                                return this.value;
                            }
                        },
                        overflow: 'justify',
                        scrollbar: {
                            enabled: false
                        }
                  },
                  plotOptions:{
                    column: {
                        pointPadding: 0.2,
                        borderWidth: 0,
                        depth: 40,
                        dataLabels: {
                            enabled: true,
                            crop: false,
                            overflow: 'none'
                        }
                    },
                    series:{
                        shadow:true,
                        dataLabels: {
                            enabled: true,
                            style: {
                                fontWeight: 'bold'
                            }
                        }
                    }
                },
                responsive: {
                    rules: [{
                        condition: {
                            maxWidth: 500
                        },
                        chartOptions: {
                            legend: {
                                align: 'center',
                                verticalAlign: 'bottom',
                                layout: 'horizontal'
                            },
                            yAxis: {
                                labels: {
                                    align: 'left',
                                    x: 0,
                                    y: -5
                                },
                                title: {
                                    text: null
                                }
                            },
                            subtitle: {
                                text: null
                            },
                            credits: {
                                enabled: false
                            }
                        }
                    }]
                },
                legend: {
                    backgroundColor: 'rgba(66, 139, 202, 0.5)'

                },

                  yAxis: [{ // Primary yAxis
                    plotLines: [
                        {
                            value: 0,
                            width: 1,
                            color: '#808080'
                        }
                    ],
                    title: {
                      text: 'Qty',
                      style: {
                        color: Highcharts.getOptions().colors[1]
                      }
                    },
                    min: 0,
                    //tickPositions: [0,1,2,5,10,20,30,yMax],
                    tickPositioner: function () {
                        var positions = [],
                            tick = Math.floor(this.dataMin),
                            increment = Math.ceil((this.dataMax - this.dataMin) / 6);

                        if (this.dataMax !== null && this.dataMin !== null) {
                            for (tick; tick - increment <= this.dataMax; tick += increment) {
                                positions.push(tick);
                            }
                        }
                        return positions;
                    }
                  },{ // Secondary yAxis
                    title: {
                      text: 'Percent (%)'
                    },
                    //max: 100,
                    min: 0,
                    tickPositions: [0,10,20,30,40,50,60,70,80,90,100],
                    opposite: true,
                    labels: {
                        format: "{value}%"
                    },
                  }],
                  tooltip: {
                    shared: false
                  },
                  colors: ['#275f76', '#e55550', '#4fa165', '#910000', '#1aadce',
                            '#492970', '#f28f43', '#77a1e5', '#c42525', '#a6c96a'],
                  series: data
            };

            if (target_line != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line[0],
                    color: '#2e8201', //Verde Grama
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: -10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line[1]
                    }
                };
            }

            if (target_line2 != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line2[0],
                    color: '#7cf23c', //Verde Manzana
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: -10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line2[1]
                    }
                };

            }

            if (target_line3 != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line3[0],
                    color: '#f7e81d', //Amarillo
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: 10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line3[1]
                    }
                };
            }

            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {
                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true,
                            formatter: function () {
                                if (this.series.name=='%OTD'){
                                    return this.point.y.toFixed(2) + '%';
                                }else{
                                    if (this.point.y!=0){
                                        return this.point.y;
                                    }
                                }
                            }
                        },
                        legend: {
                            layout: 'vertical',
                            align: 'right',
                            verticalAlign: 'top',
                            x: -40,
                            y: 80,
                            floating: true,
                            borderWidth: 1,
                            backgroundColor: '#FFFFFF',
                            shadow: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){

                                    if (rawData != null){
                                        //var rowy = rawData[this.y];
                                        //var row = rawData[this.x];
                                        //var category = e.point.category;
                                        //console.log(rowy);
                                        //console.log(rowx);
                                        //console.log(category);
                                        //alert(category);
                                        if (render=='grafico_CausasR' || render=='grafico_ReportesR' || render=='grafico_OfensoresR' || render=='grafico_MayorprecioR'){
                                            var t ='';
                                            var st='';
                                            var row = rawData[this.x];
                                            if (render=='grafico_CausasR'){
                                                //categoriaDetalle = row['_cat_forma'];
                                                parametros['where1'] = row['_cat_forma'];
                                                parametros['where2'] = row['_cat_user'];
                                                //console.log(row['_cat_forma']);
                                                //console.log(row['_cat_user']);
                                                t = 'Detail Causes';
                                                st=st.concat(row['_cat_forma'],"-",row['_cat_user']);
                                                parametros['kpi']='DETALLE_CAUSAS';
                                            }else if (render=='grafico_OfensoresR'){
                                                //categoriaDetalle =   row['_cat_Offender'];
                                                parametros['where1'] = row['_cat_forma'];
                                                parametros['where2'] = row['_cat_razon'];
                                                t = 'Detail Offender';
                                                st=st.concat(row['_cat_forma'],"-",row['_cat_razon']);
                                                 parametros['kpi']='DETALLE_OFENSORES';
                                            }else if (render=='grafico_ReportesR'){
                                                //categoriaDetalle =   row['_cat_ASP'];
                                                parametros['where1'] = row['_cat_forma'];
                                                parametros['where2'] = row['_cat_user'];
                                                t = 'Detail reports';
                                                st=st.concat(row['_cat_forma'],"-",row['_cat_user']);
                                                 parametros['kpi']='DETALLE_REPORTES';
                                            }else if (render=='grafico_MayorprecioR'){
                                                //categoriaDetalle =   row['_cat_ASP'];
                                                parametros['where1'] = row['_cat_forma'];
                                                parametros['where2'] = row['_cat_ASP'];
                                                t = 'Detail Asp';
                                                st=st.concat(row['_cat_forma'],"-",row['_cat_ASP']);
                                                 parametros['kpi']='DETALLE_MP';
                                            }

                                            var title_detalle = t;
                                            var subtitle_detalle = st; //"prueba"; //selected_serie;

                                        }
                                        generateModal(path, parametros, false,  title_detalle, subtitle_detalle, orderArray);
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }

            var num = categoria.length;

            var baseMargin = render=='graficoDashAsp' ? 170 : 90;
            var marginBottom = baseMargin + ((num-1) * 20);
            var menor = series[1];
            var mayor = series[2];
            options.chart.marginBottom = marginBottom;


            for (var k=0; k<rawData.length; k++){
                var hasThisCategory = false;
                var categoryIndex = -1;
                var categoryPath = options.xAxis.categories;
                var lastCat = categoria[categoria.length - 1]['sql_name'];
                if (categoria.length>=1){ //Si hay 2 o mas categorias
                    // I. level of categories
                    if (categoria.length >= 1) {
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[0]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[0]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

                    if (categoria.length >= 3){
                        // II. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[1]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[1]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

                    if (categoria.length >=4){
                        // III. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[2]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[2]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

                    if (categoria.length >=5){
                        // IV. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[3]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[3]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    if (categoria.length >=6){
                        // V. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[4]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[4]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            if (render!='graficoCFIssues'){
                if (menor >50) menor= 50;
                options.yAxis[0].min=menor;
            }
            return $('#' + render).highcharts(options);
        }

        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 if (option == 2){
                    table = '<table  id="tabla2" class="table table-bordered table-hover table-striped table2">';
                }else if (option == 3){
                    table = '<table  id="tabla3" class="table table-bordered table-hover table-striped table3">';
                }else if (option == 4){
                    table = '<table  id="tabla4" class="table table-bordered table-hover table-striped table4">';
                }
                table += "<thead><tr>";
                for (var j = 0; j < header.length; j++) {
                    if (header[j] == 'URL') {
                        header[j] = 'DELIVERABLE';
                    };
                    var strHideFilter = "";
                    if (header[j] == 'CHECK') {
                         strHideFilter = " sorter-false filter-false "
                    }

                    if (header[j] != 'CLASS' && header[j] != 'ID' && header[j] != 'DatoF' && header[j] != 'auditoria' && header[j] != 'RowId' && header[j] != 'form_id' && header[j] != 'Table') {

                        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] != 'DELIVERABLE' && 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]['SITE ID']+" table="+monitor[i]['Table']+">";
                    for (var j = 0; j < header.length + 1; j++) {
                        var clases = '';

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

                            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] != 'CHECK' && header[j] != 'ACTION' && header[j] != 'HISTORICAL' && header[j] != 'RowId' && header[j] != 'form_id'  && header[j] != 'Table' && header[j] != 'auditoria' && header[j] != 'DELIVERABLE' && header[j] != 'CUSTOMER STATUS' && header[j] != 'CUSTOMER COMMENTS' && header[j] != 'RESPONSABLE')
                            {

                                //  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] == 'DELIVERABLE')
                        {
                            if (monitor[i]['DELIVERABLE'] != '_') {
                                var un = monitor[i]['DELIVERABLE'];

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

                        if (header[j] == 'CUSTOMER STATUS')
                        {
                          if (monitor[i]['RowId'] != '_' ) {
                            var un = monitor[i]['RowId'];
                            var un2 = monitor[i]['SITE ID'];

                            if (monitor[i]['CUSTOMER STATUS'] != null ||  monitor[i]['CUSTOMER STATUS'] != ' ') {
                              var un3 = monitor[i]['CUSTOMER STATUS'];
                              table += "<td class='text-center' style='vertical-align: middle'><select id='status"+un+"_"+un2+"' class='form-control' name='select'><option value='"+un3+"'>"+un3+"</option>{% for statusP in statusP %}<option value='{{ statusP.id }}'>{{ statusP.nombre }}</option>{% endfor %}</select></td>";

                            }else {
                              table += "<td class='text-center' style='vertical-align: middle'><select id='status"+un+"_"+un2+"' class='form-control' name='select'>{% for statusP in statusP %}<option value='{{ statusP.id }}'>{{ statusP.nombre }}</option>{% endfor %}</select></td>";
                            }

                            //table += "<td class='text-center' style='vertical-align: middle'><select id='status"+un+"_"+un2+"' class='form-control' name='select'>{% for statusP in statusP %}<option value='{{ statusP.id }}'>{{ statusP.nombre }}</option>{% endfor %}</select></td>";

                            /*if (monitor[i]['CUSTOMER STATUS'] == ' ' || monitor[i]['CUSTOMER STATUS'] == 'COMPLETADO') {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              table += "<td class='text-center' style='vertical-align: middle'><select id='status"+un+"_"+un2+"' class='form-control' name='select'><option value='COMPLETADO'>COMPLETADO</option><option value='PENDIENTE'>PENDIENTE</option></select></td>";
                            }else if(monitor[i]['CUSTOMER STATUS'] == 'PENDIENTE') {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              table += "<td class='text-center' style='vertical-align: middle'><select id='status"+un+"_"+un2+"' class='form-control' name='select'><option value='PENDIENTE'>PENDIENTE</option><option value='COMPLETADO'>COMPLETADO</option></select></td>";
                              //table += "<td class='text-center'><a>"+monitor[i]['CUSTOMER STATUS']+"</a></td>";
                            }else {
                              table += "<td class='text-center'><a>N/A</a></td>";
                            }*/
                          }else {
                            table += "<td class='text-center'><a>N/A</a></td>";
                          }
                        }

                        if (header[j] == 'CUSTOMER COMMENTS')
                        {
                          if (monitor[i]['RowId'] != '_' ) {
                            if (monitor[i]['CUSTOMER COMMENTS'] == ' ') {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              table += "<td class='text-center' style='vertical-align: middle'><textarea rows='4' cols='50' id='coment"+un+"_"+un2+"'></textarea></td>";
                            }else if(monitor[i]['CUSTOMER COMMENTS'] != ' ' || monitor[i]['CUSTOMER COMMENTS'] != null) {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              //table += "<td class='text-center'><a>"+monitor[i]['CUSTOMER COMMENTS']+"</a></td>";
                              table += "<td class='text-center' style='vertical-align: middle'><textarea rows='4' cols='50' id='coment"+un+"_"+un2+"'>"+monitor[i]['CUSTOMER COMMENTS']+"</textarea></td>";
                            }
                          }else {
                            table += "<td class='text-center'><a>N/A</a></td>";
                          }
                        }

                        if (header[j] == 'RESPONSABLE')
                        {
                          if (monitor[i]['RowId'] != '_' ) {
                            if (monitor[i]['RESPONSABLE'] == ' ') {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              table += "<td class='text-center' style='vertical-align: middle'><input id='resp"+un+"_"+un2+"' type='text'></td>";
                            }else if(monitor[i]['RESPONSABLE'] != ' ' || monitor[i]['RESPONSABLE'] != null) {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              //table += "<td class='text-center'><a>"+monitor[i]['RESPONSABLE']+"</a></td>";
                              table += "<td class='text-center' style='vertical-align: middle'><input id='resp"+un+"_"+un2+"' type='text' value="+monitor[i]['RESPONSABLE']+"></td>";
                            }
                          }else {
                            table += "<td class='text-center'><a>N/A</a></td>";
                          }
                        }

                        if (header[j] == 'ACTION')
                        {
                          if (monitor[i]['RowId'] != '_' ) {
                            //if (monitor[i]['CUSTOMER STATUS'] == ' ' && monitor[i]['CUSTOMER COMMENTS'] == ' ') {
                              //site=' + monitor[i]['SITE ID'] + '
                              {% if (is_granted('ROLE_AMX_AUDITORIA_SITES') ) %}
                              table += "<td class='text-center' style='vertical-align: middle'>" + '<button type="button" table ='+monitor[i]['Table']+' id=' + monitor[i]['RowId'] + ' formid=' + monitor[i]['form_id'] + ' siteId=' + monitor[i]['SITE ID'] + ' class="btn btn-default btn-lg glyphicon glyphicon-floppy-disk accion"></button>' + "</td>";
                              {% else %}
                              table += "<td class='text-center'><a>N/A</a></td>";
                              {% endif %}
                            //}else {
                              //table += "<td class='text-center' style='vertical-align: middle'><a><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></td>";
                            //}
                          }else {
                            table += "<td class='text-center' style='vertical-align: middle'><a><img border=0; src='{{ asset('images/redx.png') }}'; width='20' height='20'></img></a></td>";
                          }

                        }

                        if (header[j] == 'HISTORICAL')
                        {
                          if (monitor[i]['RowId'] != '_' ) {
                            table += "<td class='text-center' style='vertical-align: middle'>" + '<button type="button" table ='+monitor[i]['Table']+' id=' + monitor[i]['SITE ID'] + ' class="btn btn-default btn-lg glyphicon glyphicon-list historico"></button>' + "</td>";
                          }else {
                            table += "<td class='text-center' style='vertical-align: middle'><a><img border=0; src='{{ asset('images/redx.png') }}'; width='20' height='20'></img></a></td>";
                          }
                        }


                        /*if (header[j] == 'STATUS')
                        {
                            if (monitor[i]['REF'] != '_') {
                                var un = monitor[i]['REF'];
                                var status = monitor[i]['STATUS'];

                                if (status == '_') {
                                  var status = "NOT AUDITED";
                                  //var status = monitor[i]['STATUS'];
                                }

                               table += "<td class='text-center'><a class='btn btn-link' target='_blank' href=" + un + " >"+status+"</a></td>";

                            }else   table += "<td class='text-center'><a>"+monitor[i]['STATUS']+"</a></td>";
                            //table += "<td class='text-center'><img border=0; src='{{ asset('images/gray_sync.png') }}'; width='20' height='20'></img></a></td>";
                        }*/

                        if (header[j] == 'CHECK')
                        {
                            if (monitor[i]['auditoria'] == null) {
                              var un = monitor[i]['RowId'];
                              var site = monitor[i]['SITE ID'];
                              //var pais = monitor[i]['PAIS']; // |"+pais+"
                              table += "<td class='text-center'><input type='checkbox' name='selected[]' class='get_value' value="+un+"|"+site+"></td>";

                           }else {
                             if (monitor[i]['STATUS'] == 'APPROVED') {
                               table += "<td class='text-center'><a><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></td>";
                             }else if(monitor[i]['STATUS'] == 'REJECTED') {
                               table += "<td class='text-center'><a><img border=0; src='{{ asset('images/redx.png') }}'; width='20' height='20'></img></a></td>";
                             }

                           }

                        }

                        /*if (header[j] == 'ACCION')
                        {
                            if (monitor[i]['auditoria'] == null) {
                              var un = monitor[i]['RowId'];
                              table += "<td class='text-center' style='vertical-align:middle;'>" + '<button type="button" id='+monitor[i]['RowId']+' siteId='+monitor[i]['ID SITIO']+' class="btn btn-primary guardar">GUARDAR</button>' + "</td>";
                              //table += "<td class='text-center' style='vertical-align:middle;'>" + '<button type="button" id='+monitor[i]['RowId']+' class="glyphicon glyphicon-floppy-disk guardar"></button>' + "</td>";
                              //table += "<td class='text-center'><a class='btn guardar'><img border=0; src='{{ asset('images/edit.png') }}'; width='20' height='20'></img></a></td>";
                           }else {
                             if (monitor[i]['ESTATUS'] == 'Aprobado') {
                               table += "<td class='text-center'><a><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></td>";
                             }else if(monitor[i]['ESTATUS'] == 'Rechazado') {
                               table += "<td class='text-center'><a><img border=0; src='{{ asset('images/redx.png') }}'; width='20' height='20'></img></a></td>";
                             }
                             //table += "<td class='text-center'><a><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></td>";
                           }

                        }*/

                        if (header[j] == '% AUDITED MP')
                        {
                          var total = parseInt(monitor[i]['AUDIT MP']);
                          var porcent = parseFloat(monitor[i]['% AUDITED MP']).toFixed(2);
                          var total2 = parseInt(monitor[i]['AMOUNT AUDITED MP']).toFixed(2);

                          console.log(total);
                          console.log(porcent);

                          if ( total >  total2 ) {
                              clases = 'btn-danger';
                          }else{
                                clases = 'btn-success';
                          }

                          var rf = porcent+"%";

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

                        if (header[j] == '% AUDITED MC')
                        {
                          var total = parseInt(monitor[i]['AUDIT MC']);
                          var porcent = parseFloat(monitor[i]['% AUDITED MC']).toFixed(2);
                          var total2 = parseInt(monitor[i]['AMOUNT AUDITED MC']);

                          if ( total >  total2 ) {
                              clases = 'btn-danger';
                          }else{
                                clases = 'btn-success';
                          }

                          var rf = porcent+"%";

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

                    }
                    table += "</tr>";

                }
                table += "</table>";

                return table;
            }

            function createTable2(monitor, total, nombreColTotal, option) {
                var header = Object.keys(monitor[0]);
                var table;

                if (option == 2) {
                    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] = 'DELIVERABLE';
                    };
                    var strHideFilter = "";
                    if (header[j] == 'CHECK') {
                         strHideFilter = " sorter-false filter-false "
                    }

                    if (header[j] != 'CLASS' && header[j] != 'ID' && header[j] != 'DatoF' && header[j] != 'auditoria' && header[j] != 'RowId' && header[j] != 'form_id' && header[j] != 'Table') {

                        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></thead>";

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

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

                            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] != 'CHECK' && header[j] != 'ACTION' && header[j] != 'HISTORICAL' && header[j] != 'RowId' && header[j] != 'form_id'  && header[j] != 'Table' && header[j] != 'auditoria' && header[j] != 'DELIVERABLE' && header[j] != 'CUSTOMER STATUS' && header[j] != 'CUSTOMER COMMENTS' && header[j] != 'DATE POWER EXPANSION COMPLETED')
                            {

                                //  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] == 'DELIVERABLE')
                        {
                            if (monitor[i]['DELIVERABLE'] != '_') {
                                var un = monitor[i]['DELIVERABLE'];

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

                        if (header[j] == 'CUSTOMER STATUS')
                        {
                          if (monitor[i]['RowId'] != '_' ) {

                            var un = monitor[i]['RowId'];
                            var un2 = monitor[i]['SITE ID'];

                            if (monitor[i]['CUSTOMER STATUS'] != null ||  monitor[i]['CUSTOMER STATUS'] != ' ') {
                              var un3 = monitor[i]['CUSTOMER STATUS'];
                              table += "<td class='text-center' style='vertical-align: middle'><select id='2status"+un+"_"+un2+"' class='form-control' name='select'><option value='"+un3+"'>"+un3+"</option>{% for statusA in statusA %}<option value='{{ statusA.id }}'>{{ statusA.nombre }}</option>{% endfor %}</select></td>";

                            }else {
                              table += "<td class='text-center' style='vertical-align: middle'><select id='2status"+un+"_"+un2+"' class='form-control' name='select'>{% for statusA in statusA %}<option value='{{ statusA.id }}'>{{ statusA.nombre }}</option>{% endfor %}</select></td>";
                            }

                            /*if (monitor[i]['CUSTOMER STATUS'] == ' ' || monitor[i]['CUSTOMER STATUS'] == 'COMPLETADO') {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              table += "<td class='text-center' style='vertical-align: middle'><select id='status"+un+"_"+un2+"' class='form-control' name='select'><option value='COMPLETADO'>COMPLETADO</option><option value='PENDIENTE'>PENDIENTE</option></select></td>";
                            }else if(monitor[i]['CUSTOMER STATUS'] == 'PENDIENTE') {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              table += "<td class='text-center' style='vertical-align: middle'><select id='status"+un+"_"+un2+"' class='form-control' name='select'><option value='PENDIENTE'>PENDIENTE</option><option value='COMPLETADO'>COMPLETADO</option></select></td>";
                              //table += "<td class='text-center'><a>"+monitor[i]['CUSTOMER STATUS']+"</a></td>";
                            }else {
                              table += "<td class='text-center'><a>N/A</a></td>";
                            }*/
                          }else {
                            table += "<td class='text-center'><a>N/A</a></td>";
                          }
                        }

                        if (header[j] == 'CUSTOMER COMMENTS')
                        {
                          if (monitor[i]['RowId'] != '_' ) {
                            if (monitor[i]['CUSTOMER COMMENTS'] == ' ') {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              table += "<td class='text-center' style='vertical-align: middle'><textarea rows='4' cols='50' id='2coment"+un+"_"+un2+"'></textarea></td>";
                            }else if(monitor[i]['CUSTOMER COMMENTS'] != ' ' || monitor[i]['CUSTOMER COMMENTS'] != null) {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              //table += "<td class='text-center'><a>"+monitor[i]['CUSTOMER COMMENTS']+"</a></td>";
                              table += "<td class='text-center' style='vertical-align: middle'><textarea rows='4' cols='50' id='2coment"+un+"_"+un2+"'>"+monitor[i]['CUSTOMER COMMENTS']+"</textarea></td>";
                            }
                          }else {
                            table += "<td class='text-center'><a>N/A</a></td>";
                          }
                        }

                        if (header[j] == 'DATE POWER EXPANSION COMPLETED')
                        {
                          if (monitor[i]['RowId'] != '_' ) {
                            if (monitor[i]['DATE POWER EXPANSION COMPLETED'] == ' ') {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              table += "<td class='text-center' style='vertical-align: middle'><input id='2resp"+un+"_"+un2+"' type='text'></td>";
                            }else if(monitor[i]['DATE POWER EXPANSION COMPLETED'] != ' ' || monitor[i]['DATE POWER EXPANSION COMPLETED'] != null) {
                              var un = monitor[i]['RowId'];
                              var un2 = monitor[i]['SITE ID'];
                              //table += "<td class='text-center'><a>"+monitor[i]['RESPONSABLE']+"</a></td>";
                              table += "<td class='text-center' style='vertical-align: middle'><input id='2resp"+un+"_"+un2+"' type='text' value="+monitor[i]['DATE POWER EXPANSION COMPLETED']+"></td>";
                            }
                          }else {
                            table += "<td class='text-center'><a>N/A</a></td>";
                          }
                        }

                        if (header[j] == 'ACTION')
                        {
                          if (monitor[i]['RowId'] != '_' ) {
                            //if (monitor[i]['CUSTOMER STATUS'] == ' ' && monitor[i]['CUSTOMER COMMENTS'] == ' ') {
                              //site=' + monitor[i]['SITE ID'] + '
                              {% if (is_granted('ROLE_AMX_AUDITORIA_SITES') ) %}
                              table += "<td class='text-center' style='vertical-align: middle'>" + '<button type="button" table ='+monitor[i]['Table']+' id=' + monitor[i]['RowId'] + ' formid=' + monitor[i]['form_id'] + ' siteId=' + monitor[i]['SITE ID'] + ' class="btn btn-default btn-lg glyphicon glyphicon-floppy-disk accion"></button>' + "</td>";
                              {% else %}
                              table += "<td class='text-center'><a>N/A</a></td>";
                              {% endif %}
                            //}else {
                              //table += "<td class='text-center' style='vertical-align: middle'><a><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></td>";
                            //}
                          }else {
                            table += "<td class='text-center' style='vertical-align: middle'><a><img border=0; src='{{ asset('images/redx.png') }}'; width='20' height='20'></img></a></td>";
                          }

                        }

                        if (header[j] == 'HISTORICAL')
                        {
                          if (monitor[i]['RowId'] != '_' ) {
                            table += "<td class='text-center' style='vertical-align: middle'>" + '<button type="button" table ='+monitor[i]['Table']+' id=' + monitor[i]['SITE ID'] + ' class="btn btn-default btn-lg glyphicon glyphicon-list historico"></button>' + "</td>";
                          }else {
                            table += "<td class='text-center' style='vertical-align: middle'><a><img border=0; src='{{ asset('images/redx.png') }}'; width='20' height='20'></img></a></td>";
                          }
                        }


                        if (header[j] == 'CHECK')
                        {
                            if (monitor[i]['auditoria'] == null) {
                              var un = monitor[i]['RowId'];
                              var site = monitor[i]['SITE ID'];
                              //var pais = monitor[i]['PAIS']; // |"+pais+"
                              table += "<td class='text-center'><input type='checkbox' name='selected[]' class='get_value' value="+un+"|"+site+"></td>";

                           }else {
                             if (monitor[i]['STATUS'] == 'APPROVED') {
                               table += "<td class='text-center'><a><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></td>";
                             }else if(monitor[i]['STATUS'] == 'REJECTED') {
                               table += "<td class='text-center'><a><img border=0; src='{{ asset('images/redx.png') }}'; width='20' height='20'></img></a></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='null'>";
                        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] != 'DELIVERABLE') {
                            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] == 'DELIVERABLE'){
                            if (monitor[i]['DELIVERABLE'] != '_') {
                                var un = monitor[i]['DELIVERABLE'];

                               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 resizeChart(){

          var panel_width = $('.tab-content').width();
          var offset = 32;
          console.log(panel_width-offset);

          //$('#chart1').width(panel_width-offset);
          if ($("#chart1").highcharts()!=undefined){
              $('#chart1').highcharts().reflow();
          }

          //$('#chart2').width(panel_width-offset);
          if ($("#chart2").highcharts()!=undefined){
              $('#chart2').highcharts().reflow();
          }

          //$('#chart3').width(panel_width-offset);
          if ($("#chart3").highcharts()!=undefined){
              $('#chart3').highcharts().reflow();
          }

        }


    </script>

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

             </div>
        </div>
        <br>
        <div class="panel panel-primary">
          <div class="panel-heading">
              <h3 class="panel-title"><a data-toggle="collapse" href="#collapse1">Filters <span class="caret"></span></a></h3>
          </div>
          <div id="collapse1" class="panel-collapse collapse in">
              <div id="panelFilter" class="panel-body">
                  <div class="row">
                      <input type="hidden" class="form-control" id="Filtros_fechaIni" name="Filtros_fechaIni" value="">
                      <input type="hidden" class="form-control" id="Filtros_fechaFin" name="Filtros_fechaFin" value="">
                      <div class="row">
                          <div class="col-md-7 col-sm-6 col-xs-12">
                              <div class="form-group">
                                  <label>Date Filter: <span class="detalleRango"></span> </label><br>
                                  <button type="button" class="btn btn-default ajuste_fecha" id="hoy">Today</button>
                                  <button type="button" class="btn btn-default ajuste_fecha" id="ultimos_7_dias">Week</button>
                                  <button type="button" class="btn btn-default ajuste_fecha" id="mes_actual">This Month</button>
                                  <button type="button" class="btn btn-default ajuste_fecha" id="mes_anterior">Last Month</button>
                                  <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_6_meses">Last 6 Months</button>
                                  <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_12_meses">Last 12 Months</button>
                                  <button type="button" class="btn btn-default ajuste_fecha" id="rango_fecha">Custom Range</button>
                              </div>
                          </div>
                          <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                              <div class="form-group">
                                 <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>
                                  <input type="text" class="form-control" id="fechaIni" name="fechaIni" value="">
                              </div>
                          </div>
                          <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                              <div class="form-group">
                                  <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>
                                  <input type="text" class="form-control" id="fechaFin" name="fechaFin" value="">
                              </div>
                          </div>
                      </div>
                      <div class="row">
                          <div class="col-md-3 col-sm- col-xs-12">
                                  <label for="generar">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</label>
                                  <button class="btn btn-primary form-control" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
                              </div>
                          </div>
                          <div class="col-md-6 col-sm-6 col-xs-12"></div>
                      </div>
                  </div>
              </div>
          </div>
         <div class="row">

                <div class="col-lg-12 text-center"  style="margin-top: 1%">
                    <h1>{{'DELIVERABLES OPERATE MX' | trans}}</h1>
                 </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_sitios" name="total_monitor_sitios" value="0">
    <input type="hidden" id="total_monitor" name="total_monitor" value="0">
    <input type="hidden" id="total_monitor_validadas" name="total_monitor_validadas" value="0">
    <input type="hidden" id="total_monitor_power" name="total_monitor_power" 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">
              <!-- {% if (is_granted('ROLE_AMX_AUDITORIA_SITES') ) %}
                <li idprocesos="155" headerid="1" gruopquery="4" class="active mainTab activar_sitios_por_auditar">
                    <a data-toggle="tab" href="#sitios_por_auditar"><strong>CONSOLIDATED SITE ADAPTATIONS</strong></a>
                </li>
              {% endif %}
              {% if (is_granted('ROLE_AMX_AUDITORIA_SITES') ) %}
                <li idprocesos="155" headerid="1" gruopquery="4" class="mainTab activar_ota_por_validar">
                    <a data-toggle="tab" href="#otas_por_validar"><strong>CONSOLIDATED POWER</strong></a>
                </li>
              {% else %}
                <li idprocesos="155" headerid="1" gruopquery="4" class="active mainTab activar_ota_por_validar">
                    <a data-toggle="tab" href="#otas_por_validar"><strong>CONSOLIDATED POWER</strong></a>
                </li>
              {% endif %}-->
                <li idprocesos="155" headerid="1" gruopquery="4" class="active mainTab activar_sitios_por_auditar">
                    <a data-toggle="tab" href="#sitios_por_auditar"><strong>FIELD FORMS</strong></a>
                </li>
                <li idprocesos="155" headerid="1" gruopquery="4" class="mainTab activar_ota_por_validar">
                    <a data-toggle="tab" href="#otas_por_validar"><strong>MINILINK FORMS</strong></a>
                </li>
                <li idprocesos="155" headerid="1" gruopquery="4" class="mainTab activar_ota_validadas">
                    <a data-toggle="tab" href="#otas_por_validadas"><strong>POWER AND COOLING FORMS</strong></a>
                </li>
                <!--<li idprocesos="155" headerid="1" gruopquery="4" class="mainTab activar_power">
                    <a data-toggle="tab" href="#pr_power"><strong>AUDIT POWER</strong></a>
                </li>
                <li idprocesos="155" headerid="1" gruopquery="4" class="mainTab click_tab">
                    <a data-toggle="tab" href="#pr_summary"><strong>SUMMARY</strong></a>
                </li>-->
            </ul>
            <div class="tab-content activar_5g" style="margin-top: 20px;width:100%">
              <div id="sitios_por_auditar" class="tab-pane active">
                <div class="row">
                    <div class="col-lg-12" id="chart1" style="display: flex">
                    </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_sitios_por_auditar').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                            </ul>
                        </div>
                    </div>
                    <div class="pager pager_sitios_por_auditar" style="text-align: left">
                        <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                        <span class="pagedisplay"></span>
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-12" id="reporte_sitios_por_auditar" style="overflow-x: auto;">
                    </div>
                  </div>
                  <!-- <div class="row double-scroll" id="reporte_sitios_por_auditar">

                  </div>-->
              </div>
                  <div id="otas_por_validar" class="tab-pane">
                    <div class="row">
                        <div class="col-lg-12" id="chart2" style="display: flex">
                        </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 row double-scroll" 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-12" id="chart3" style="display: flex">
                      </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_validadas').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>
                    <form id="formCheckA">
                      <div class="row">
                          <div class="col-md-12" id="reporte_otas_validadas" style="overflow-x: auto;">
                          </div>
                      </div>
                    </form>
                    <!-- <div class="row double-scroll" id="reporte_otas_por_validar">

                    </div>-->
                </div>
                <div id="pr_power" class="tab-pane">
                    <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_power').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                              </ul>
                          </div>
                      </div>
                    </div>
                    <div class="pager pager_pr_power" style="text-align: left">
                        <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                        <span class="pagedisplay"></span>
                    </div>
                    {% if (is_granted('ROLE_AMX_AUDITORIA_SITES') ) %}
                    <div class="panel panel-info">
                      <div class="panel-heading">Mass Audit</div>
                      <div class="row">
                        <!--<div class="col-lg-2 pull-right">
                          <label>CHECK ALL</label>
                            <input type="checkbox" id="marcador"/>
                        </div>-->
                        <br />
                        <br />
                        <div class="col-lg-2 pull-right" style="vertical-align: bottom">
                           <button class="btn btn-success" id="aprobarP" style="vertical-align: bottom">Approve</button>
                           <button class="btn btn-danger" id="rechazarP" style="vertical-align: bottom">Reject</button>
                        </div>
                      </div>
                      <br />
                    </div>
                    {% endif %}
                    <div class="row">
                      <form id="formCheckP">
                        <div class="col-md-12" id="reporte_power" style="overflow-x: auto;">
                        </div>
                      </form>
                    </div>
                    <!-- <div class="row double-scroll" id="reporte_otas_por_validar">

                    </div>-->
                </div>
                <div id="pr_summary" class="tab-pane">
                    <div class="row">
                        <div class="col-lg-6" style="display:true" id="kpi1" style="width: 100%; min-width: 320px;">
                            <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                <div class="panel-heading">ENGINEERS WITH MOST CHANGES MADE</div>
                                <div class="panel-body fixed-panel" id="grafico_CausasR" style="width:45.5%;height: 400px !important;">

                                </div>
                            </div>
                        </div>
                        <div class="col-lg-6" style="display:true" id="kpi2" style="width: 100%; min-width: 320px;">
                            <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                <div class="panel-heading">DETECTED DEVIATIONS</div>
                                <div class="panel-body fixed-panel" id="grafico_OfensoresR" style="width:45.5%;height: 400px !important;">

                                </div>
                            </div>

                        </div>
                    </div>
                    <div class="row">
                        <div class="col-lg-6" style="display:true" id="kpi3" style="width: 100%; min-width: 320px;">
                            <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                <div class="panel-heading">BEST CONTRIBUTORS</div>
                                <div class="panel-body fixed-panel" id="grafico_MayorprecioR" style="width:45.5%;height: 400px !important;">
                                </div>
                            </div>
                        </div>

                        <div class="col-lg-6" style="display:true" id="kpi4" style="width: 100%; min-width: 320px;">
                            <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                <div class="panel-heading">LOAD OF INFORMATION BY ENGINEERS</div>
                                <div class="panel-body fixed-panel" id="grafico_ReportesR" style="width:45.5%;height: 400px !important;">

                                </div>
                            </div>

                        </div>
                    </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>

    <div class="modal fade" id="modalAccion" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <form name="save" action="{{ path('rechazarPowerSiteAdaption',{'idproyectos':idproyectos}) }}">
                    <input id="arregloAccion" type="hidden" name="arreglo">
                    <input id="tableAccion" type="hidden" name="table">
                    <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">Reject</h2>
                    </div>
                    <div class="modal-body">
                        <!--<div class="pull-right">
                            <button class="btn btn-success clone" element="primeraFila" target="materialesContainer"><i class="fa fa-lg fa-plus"></i></button>
                        </div>-->
                        <div id="materialesContainer">
                            <div class="row" id="primeraFila" style="margin-top:8px">
                                <div class="col-lg-4">
                                    <label>REASON</label>
                                    <select required  class="reason form-control" name="reason">
                                      <option value="DIFERENCIA EN CANTIDADES">DIFERENCIA EN CANTIDADES</option>
                                      <option value="INFORMACION INCOMPLETA">INFORMACION INCOMPLETA</option>
                                      <option value="DESVIACION 3">DESVIACION 3</option>
                                    </select>
                                </div>
                                <!-- <div class="col-lg-6">
                                    <label>Comentario</label>
                                    <textarea required class="comentario form-control" name="comentario"></textarea>
                                </div>-->
                            </div><!-- fila 1 -->
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button id="saveAccion" type="submit" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                        <button type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                    </div>
                </form>
            </div>
        </div>
    </div>

    <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content" style="width: 1200px;margin: 0px 0px 0px -140px;">
                <div class="modal-header">
                    <h2 class="modal-title text-center" id="myModalLabel"><strong>{# {'monitorii.detail' | trans } #}<span class="modal_detalle_titulo"></span></strong></h2>
                    <div class="punto-grafica text-center"></div>
                </div>
                <div class="modal-body">
                    <div class="tabla-datos">

                    </div>

                    <div id="datatableModalDetalle" class="col-sm-12" {#style="overflow-x: scroll"#}>
                        <table id="tableModalDetalle" class="display nowrap" width="100%">
                            <tbody id="tbodyModalDetalle">
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-claro" data-dismiss="modal">
                        {{'monitorii.close' | trans}}
                        <span class="glyphicon glyphicon-remove"></span>
                    </button>
                </div>
            </div>
        </div>
    </div>

{% endblock %}
{% block javascripts %}
    <link rel="stylesheet" href="{{ asset('css/jquery.dataTables.min.css')}}">
    <link rel="stylesheet" href="{{ asset('css/buttons.dataTables.min.css')}}">
    <link rel="stylesheet" href="{{ asset('datatables/css/select.bootstrap.min.css')}}">
    <script src="{{ asset('js/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('js/buttons.flash.min.js') }}"></script>
    <script src="{{ asset('js/jszip.min.js') }}"></script>
    <script src="{{ asset('js/pdfmake.min.js') }}"></script>
    <script src="{{ asset('js/vfs_fonts.js') }}"></script>
    <script src="{{ asset('js/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('js/buttons.print.min.js') }}"></script>
    <script src="{{ asset('datatables/js/dataTables.select.min.js') }}"></script>
    <script src="{{ asset('datatables/moment.min.js') }}"></script>
    <script src="{{ asset('datatables/js/datetime-moment.js') }}"></script>
    <script src="{{ asset('js/grouped-categories.js') }}"></script>
    <script type="text/javascript" src="{{ asset('bootstrap-multiselect/js/bootstrap-multiselect.js') }}"></script>
    <script src="{{ asset('highcharts5/code/modules/data.src.js') }}"></script>
{% endblock %}