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

{% block dashboard %}
    <style>

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

     /*** 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/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 = {

    };

    $(function () {

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

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

      /*$("#export").click(function(){

          $("#formExport").submit();

          return false;

      });*/
      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(){
          /*if($(this).val() == 1){
              $("#chart1").show();
              $("#chart3").hide();
          }else{
              $("#chart1").hide();
              $("#chart3").show();
          }*/
      });
      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();
          }
      });

      $("#proyecto").change(function () {
          if ($("#proyecto").val() != "TODOS") {
              $.isLoading({
                  text: "Loading"
              });
              llenarCombos();
          } else {
              $("#fase option").remove();
              $("#fase").append('<option value="TODOS">All</option>');
          }
      });

      $("#proyecto").change(function(){

        var project = $("#proyecto").val();
        //alert(country);
        $(".listD").remove();
        if (project != 'TODOS') {

          var a = $(".dropdown-menu").append(`<li class="listD">
              <a class="downloadTemplate" href="{{ path("reportemshonduras_DownloadMg")}}"
                 id="downloadTemplate"> <img src={{ asset("images/xls.png")}} width="24px"> XLS
              </a>
          </li>`);

        }else {

          var a = $(".dropdown-menu").append(`<li class="listD"><a href="#" onclick="$('#primer_reporte').tableExport({type: 'excel', escape: 'false'});">
                  <img src={{ asset("images/xls.png")}} width="24px"> XLS
              </a>
          </li>`);

        }

      });

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

        var project = $("#proyecto").val();
        //alert(project);

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

          /*if (project == 'TODOS') {

            var ruta = "{{path('reportemexico_DownloadReporteAtpMx')}}?proyecto=" + data['proyecto'] + "&fase=" + data['fase']
                    + "&fechaIni=" + data['fechaIni'] + "&fechaFin=" + data['fechaFin'] + "";
            $('.downloadTemplate').attr("href",ruta);

          }else*/
          if (project == '5G') {

            var ruta = "{{path('reportemexico_DownloadReporteAtpMx5g')}}?proyecto=" + data['proyecto'] + "&fase=" + data['fase']
                    + "&fechaIni=" + data['fechaIni'] + "&fechaFin=" + data['fechaFin'] + "";
            $('.downloadTemplate').attr("href",ruta);

          }else if (project == 'GIGARED') {

            var ruta = "{{path('reportemexico_DownloadReporteAtpMxGiga')}}?proyecto=" + data['proyecto'] + "&fase=" + data['fase']
                    + "&fechaIni=" + data['fechaIni'] + "&fechaFin=" + data['fechaFin'] + "";
            $('.downloadTemplate').attr("href",ruta);

          }else if (project == 'NEW SITES') {

            var ruta = "{{path('reportemexico_DownloadReporteAtpMxNs')}}?proyecto=" + data['proyecto'] + "&fase=" + data['fase']
                    + "&fechaIni=" + data['fechaIni'] + "&fechaFin=" + data['fechaFin'] + "";
            $('.downloadTemplate').attr("href",ruta);

          }

          /*var ruta = "{{path('reportemexico_DownloadReporteAtpMxGiga')}}?proyecto=" + data['proyecto'] + "&fase=" + data['fase']
                  + "&fechaIni=" + data['fechaIni'] + "&fechaFin=" + data['fechaFin'] + "";
          //window.open(ruta);
          $('.downloadTemplate').attr("href",ruta);*/
          //alert(ruta);
      });


      $(".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);
          }
      });

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

      $(document).ready(function() {
        $('.accion').live('click',function(){
          var siteid = $(this).attr('siteId');
          var sitenumber = $(this).attr('sitenumber');

          var idInput = 'coment'+siteid;
          var text = $('#'+idInput).val();

          swal({
              title: 'Confirmar',
              text: "No podra revertir una vez confirmado",
              type: 'success',
              showCancelButton: true,
              confirmButtonColor: '#3085d6',
              cancelButtonColor: '#d33',
              confirmButtonText: 'Continuar'
          }).then(function () {
              $("#cargar").css('display','');
              $.ajax({
                url: '{{ path('reportemshonduras_saveInfoAtp',{'idproyectos':idproyectos}) }}',
                type: "POST",
                data: {siteid:siteid, sitenumber: sitenumber, text: text},
                success: function(response){
                  //$(".activar_5g").show();
                  reporteBateria();
                }
              }).done(function (json) {

                  $("#cargar").css('display','none');
                  swal(
                          'Bien !',
                          'Información Guardada Correctamente',
                          'success'
                  )
                  table.ajax.reload(function ( json ) {
                      $("#cargar").css('display','none');
                  });
              });
          })

        });
      });

    });



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

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

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

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

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

      }
    }
  }
}

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

                var idproyectos = {{ idproyectos }};
                var idprocesos = $("#proyecto").val();

                var parametros = {
                    'idprocesos': idprocesos,
                    'idproyectos': idproyectos
                };

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

                    var bateria = data.bateria;
                    var bateria1 = data.bateria1;
                    var bateria2 = data.bateria2;
                    var chart = data;
                    //console.log(chart.grafico_Instalacion.categories);
                    if (chart.grafico_Instalacion.categories.length > 0){
                        $("#grafico_Instalacion").empty();
                        var series = getDataToObjectSerieAll(chart.grafico_Instalacion.data, Object.keys(chart.grafico_Instalacion.data[0]));
                        //console.log(series);
                        createChartColumn('grafico_Instalacion', chart.grafico_Instalacion.categories, series, 'ATP ESTATUS DE INSTALACION',
                                null, null, null, null,null,"{{ path('reportAmx_detalleDashboradAtp1Nivel') }}", chart.grafico_Instalacion.data,parametros,null,null,null,null,null,null);
                    }else{
                        if ($("#grafico_Instalacion").highcharts()!=undefined){
                            $("#grafico_Instalacion").highcharts().destroy();
                        }
                        $("#grafico_Instalacion").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                    }

                    if (chart.grafico_Validacion.categories.length > 0){
                        $("#grafico_Validacion").empty();
                        var series = getDataToObjectSerieAll(chart.grafico_Validacion.data, Object.keys(chart.grafico_Validacion.data[0]));
                        createChartColumn('grafico_Validacion', chart.grafico_Validacion.categories, series, 'ATP ESTATUS DE VALIDACION',
                                null, null, null, null,null,"{{ path('reportAmx_detalleDashboradAtp1Nivel') }}", chart.grafico_Validacion.data,parametros,null,null,null,null,null,null);
                    }else{
                        if ($("#grafico_Validacion").highcharts()!=undefined){
                            $("#grafico_Validacion").highcharts().destroy();
                        }
                        $("#grafico_Validacion").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                    }

                    if (chart.bateria3.categories.length > 0){
                        console.log(chart.bateria3)
                        $("#bateria3").empty();                    
                        createCharValidados('bateria3', chart.bateria3);
                    }else{
                        if ($("#bateria3").highcharts()!=undefined){
                            $("#bateria3").highcharts().destroy();
                        }
                        $("#bateria3").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                    }

                    $("#primer_reporte01").empty().append(createTableSimple(bateria1));
                    $("#primer_reporte02").empty().append(createTableSimple(bateria2));

                    if (bateria.length == 0) {

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

                    }

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

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

                for (var i = 0; i < header.length; i++){
                    var dataAux = new Array();
                    if (header[i].indexOf('_cat_') < 0){
                        for (var j=0; j<data.length; j++){
                            var valor = parseFloat(data[j][header[i]]);
                            dataAux.push(valor);
                            if (valor < menor){
                                menor = valor;
                            }
                            if (valor > mayor){
                                mayor = valor;
                            }
                        }
                        arrayReturn.push({'name': header[i], 'data': dataAux, 'dataLabels': {'enabled': true}});
                    }
                }
                data1[0] = arrayReturn;
                data1[1] = menor;
                data1[2] = mayor;
                return data1;
            }
            function createCharValidados(render, data){
                console.log('DATA: ', data)

                // // Data retrieved from: https://www.uefa.com/uefachampionsleague/history/
                    var options = {
                        chart: {
                            type: 'column'
                        },
                        title: {
                            text: 'Validados Por Mes'
                        },
                        xAxis: {
                            categories: data.categories
                        },
                        yAxis: {
                            min: 0,
                            title: {
                                text: 'Validados'
                            }
                        },
                        tooltip: {
                            pointFormat: '<span style="color:{series.color}">{series.name}</span>: <b>{point.y}</b>)<br/>',
                            shared: true
                        },
                        plotOptions: {
                            series: {
                                borderWidth: 0,
                                dataLabels: {
                                    enabled: true,
                                   
                                }
                            }
                        },

                        series: data.series
                    };
                    
                    return $('#' + render).highcharts(options);

            }

            function createChartColumn(render, categoria, series, title, w,
                                       inicio, fin, pais, orderArray, path, rawData,parametros,
                                       target11Value,target11Name,
                                       target12Value,target12Name,
                                       target13Value,target13Name)
            {
                var arrayReturn = new Array();
                var data = new Array();
                if (render=='grafico_Instalacion'){
                    if (series.length>0){
                        $.each(series, function(key, value) {
                            $.each(value, function(k, v) {
                                if(k==0){//REGION 1
                                  data.push({"color":'#00A9E5',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }else if (k==1){//REGION 2
                                  data.push({"color":'#90ED7D',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }else if (k==2){//REGION 3
                                  data.push({"color":'#E3F705',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }else if (k==3){ //REGION 4
                                  data.push({"color":'#FF0000',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }else if (k==4){ //REGION 6
                                  data.push({"color":'#0C265D',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                } else if (k==5){ //REGION 9
                                  data.push({"color":'#F7610F',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                } else if (k==6){ //GRAND TOTAL
                                  data.push({"color":'#996600',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                  //data.push({"color":'#996600',"name":v.name,"data":v.data,yAxis: 1});
                                } /*else if (k==7){ //% TERMINADO
                                  data.push({"color":'#79ff4d',"name":v.name,"data":v.data,yAxis: 1});
                                }*/
                            });
                        });
                    }
                }

                if (render=='grafico_Validacion'){
                    if (series.length>0){
                        $.each(series, function(key, value) {
                            $.each(value, function(k, v) {
                                if(k==0){//REGION 1
                                  data.push({"color":'#00A9E5',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }else if (k==1){//REGION 2
                                  data.push({"color":'#90ED7D',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }else if (k==2){//REGION 3
                                  data.push({"color":'#E3F705',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }else if (k==3){ //REGION 4
                                  data.push({"color":'#FF0000',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }else if (k==4){ //REGION 6
                                  data.push({"color":'#0C265D',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }else if (k==5){ //REGION 9
                                  data.push({"color":'#F7610F',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }else if (k==6){ //GRAND TOTAL
                                  data.push({"color":'#996600',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                                }/*else if (k==7){ //% TERMINADO
                                  data.push({"color":'#79ff4d',"name":v.name,"data":v.data,yAxis: 1});
                                }*/
                            });
                        });
                    }
                }

                var subtitle = '';
                if ($('#asp').val()){
                    if ($('#asp').val().length>0){
                        var array_asp = $('#asp').val();
                        var detalle_asp = $('#asp option').length===array_asp.length?'ALL':$('#asp').val();
                        subtitle+= " <b>ASP:</b> "+detalle_asp;
                    }
                }
                if ($('#region').val()){
                    if ($('#region').val().length>0){
                        var array_region = $('#region').val();
                        var detalle_region = $('#region option').length===array_region.length?'ALL':$('#region').val();
                        subtitle+= " <b>REGION:</b> "+detalle_region;
                    }
                }
                var table_dt = "";
                var dt = "";
                var posProy = 0;
                var col = 4;
                var rotation = 0;
                var step = Math.ceil(rawData.length/50);
                var kpi = "";
                var height = 250;
                var options = {
                    chart: {
                        //height: height,
                        borderColor: '#428bca',
                        borderWidth: 1,
                        zoomType: 'xy',
                        backgroundColor: {
                            linearGradient: [0, 0, 0, 450],
                            stops: [
                                [0, 'rgba(66, 139, 202, 0.3)'], //start
                                [0.5, '#ffffff'], // middle
                                [1, 'rgba(66, 139, 202, 0.2)'] //end
                            ]
                        }
                      },
                      credits: {
                        enabled: false
                      },
                      title: {text: title},
                      subtitle: {
                        text: subtitle
                      },
                      xAxis: {
                        categories: [],
                        crosshair: true,
                        labels: {
                            autoRotation: [-10, -20, -30, -40, -50]
                        }
                    },
                    yAxis: [{
                        title: {
                            text: 'Qty'
                        },
                        min: 0,
                        labels: {
                            overflow: 'justify',
                            style: {
                                fontSize: '9px',
                            },
                        },
                    }, {
                        title: {
                            text: 'Percent (%)'
                        },
                        max: 100,//render=='grafico_SITEEstatusActual'?600:100,
                        min: 0,
                        opposite: true,
                        labels: {
                            format: "{value}%"
                        }
                    }],
                    series: data
                };

                var formato = '{point.y}';
                // OPCIONAL: El path para la tabla detallada
                if (path != null){
                    options['plotOptions'] =
                    {
                        series:
                        {
                            cursor: 'pointer',
                            borderWidth: 0,
                            dataLabels:
                            {
                                enabled: true,
                                formatter: function () {
                                    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 row = rawData[this.x];
                                            var selected_serie = this.series.name;
                                            //console.log(row,rawData,selected_serie);
                                            parametros['categoria'] = '';
                                            parametros['ofensor'] = '';
                                            var subtitle_detalle = '';
                                            if (render=='grafico_Instalacion'){
                                                var t = '';
                                                parametros['categoria'] = '';
                                                //parametros['_cat_Proyecto'] = '';
                                                if(render=='grafico_Instalacion'){
                                                    t = "ATP'S VALIDADOS VS SITES RECHAZADOS";
                                                    subtitle_detalle = "["+selected_serie+"]";
                                                }
                                                parametros['mes'] = row._cat_Month?row._cat_Month:'';
                                                parametros['week'] = row._cat_Week?row._cat_Week:'';
                                                parametros['year'] = row._cat_Year?row._cat_Year:'';
                                                parametros['proyect'] = row._cat_Proyecto?row._cat_Proyecto:'';
                                                var title_detalle = t;

                                                /*if (row._cat_PROJECT){
                                                    if (row._cat_PROJECT!='TOTAL'){
                                                        parametros['_cat_Proyecto'] = row._cat_PROJECT;
                                                    }
                                                }*/
                                                //console.log(selected_serie);
                                                if(render=='grafico_Instalacion'){
                                                    if (selected_serie=='TOTAL'){
                                                        parametros['kpi'] = "DETALLE_ATP_TOTAL";
                                                    }else if (selected_serie=='VALIDADOS FTR'){
                                                        parametros['kpi'] = "DETALLE_ATP_VALIDADOS_FTR";
                                                    }else if (selected_serie=='POR VALIDAR'){
                                                        parametros['kpi'] = "DETALLE_ATP_POR_VALIDAR";
                                                    }else if (selected_serie=='VALIDADOS NO FTR'){
                                                        parametros['kpi'] = "DETALLE_ATP_APROBADO";
                                                    }else if (selected_serie=='RECHAZADO'){
                                                        parametros['kpi'] = "DETALLE_ATP_RECHAZADO";
                                                    }else if (selected_serie=='% VALIDADOS FTR' || selected_serie=='% RECHAZADOS'){
                                                        $.isLoading("hide");
                                                        return false;
                                                    }
                                                }
                                            }
                                            parametros['selected_serie'] = selected_serie;
                                            generateModal(path, parametros, false,  title_detalle, subtitle_detalle, orderArray);
                                        }else{
                                            alert('Data Not Found');
                                        }
                                    }
                                }
                            }
                        }
                    };
                }
                var num = categoria.length;
                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]);
                        }
                    }
                }
                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;
                var idproyectos = {{idproyectos}};

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

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

                    if (header[j] != 'CLASS' && header[j] != 'capacidad' && header[j] != 'ID' && header[j] != 'temperatura' && header[j] != 'CAPACIDAD_X' && header[j] != 'TEMPERATURA_X') {
                        if (option == 1) {
                            table += "<th style='vertical-align:middle; width:300px' class='text-center" + strHideFilter + "'>" + header[j] + "</th>";
                        } else{
                            table += "<th style='vertical-align:middle;' class='text-center" + strHideFilter + "'>" + header[j] + "</th>";
                        }
                    }
                }
                table += "</tr>";
                table += '<tr>';

                table += "</tr></thead>";

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

                        if (header[j] != 'CLASS' && header[j] != 'capacidad' && header[j] != 'temperatura' && header[j] != 'ID' && header[j] != 'ENTREGABLE' && header[j] != 'COMENTARIO' && header[j] != 'ACCION') {
                            if (header[j] == 'FECHA SIG. MEDICION' && monitor[i]['CLASS'] == 1) {
                                clases = 'btn-danger';
                            }
                            table += "<td class=" + clases + ">" + monitor[i][header[j]] + "</td>";
                        }

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

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

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

                        if (header[j] == 'COMENTARIO')
                        {
                          if (monitor[i]['COMENTARIO'] == ' ') {
                            var un = monitor[i]['SITE ID'];
                            var un2 = monitor[i]['SITE NUMBER'];
                            table += "<td class='text-center' style='vertical-align: middle'><textarea rows='4' cols='50' id='coment"+un+"'></textarea></td>"; //id='coment"+un+"_"+un2+"'
                          }else if(monitor[i]['COMENTARIO'] != ' ' || monitor[i]['COMENTARIO'] != null) {
                            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+"'>"+monitor[i]['COMENTARIO']+"</textarea></td>";
                          }
                        }

                        if (header[j] == 'ACCION')
                        {
                          if (monitor[i]['RowId'] != '_' ) {
                              {% if (is_granted('ROLE_AMX_AUDITORIA_SITES') ) %}
                              table += "<td class='text-center' style='vertical-align: middle'>" + '<button type="button"  sitenumber=' + monitor[i]['SITE NUMBER'] + ' 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/redx.png') }}'; width='20' height='20'></img></a></td>";
                          }

                        }

                    }
                        table += "</tr>";

                    if (typeof total !== "undefined") {

                        if (i == monitor.length - 1) {

                            var headerTotal = Object.keys(total);
                            table += '<tr><td>' + nombreColTotal + '</td>';

                            for (var x = 0; x < headerTotal.length; x++) {
                                table += '<td>';
                                table += total[headerTotal[x]];

                                table += '</td>';

                            }
                            table += '</tr>';
                        }
                    }
                }
                table += "</table>";

                return table;
            }

            function createTableSimple(monitor,total,nombreColTotal){
                var header = Object.keys(monitor[0]);
                var table = '<table id="tableSitios"  class="table table-bordered table-hover table-striped table-responsive"> <thead>' +
                        '<tr class="btn-info">';
                for (var j = 0; j < header.length; j++) {
                    table += "<th class='text-center'>" + header[j] + "</th>"
                }
                table += "</tr></thead>";
                for (var i = 0; i < monitor.length; i++) {
                    table += "<tr>";
                    for (var j = 0; j < header.length; j++) {
                        if( typeof monitor[i][header[j]] === 'object'){
                            table += "<td>" + monitor[i][header[j]].date.substring(0,19)  + "</td>";
                        }else{
                            table += "<td>" + monitor[i][header[j]]  + "</td>";
                        }
                    }
                    table += "</tr>";
                    if(typeof total !== "undefined") {
                        if (i == monitor.length - 1) {
                            var headerTotal = Object.keys(total);
                            table += '<tr><td>' + nombreColTotal +'</td>';
                            for(var x=0; x<headerTotal.length;x++){
                                table += '<td>';
                                table += total[headerTotal[x]];
                                table += '</td>';
                            }
                            table += '</tr>';
                        }
                    }
                }
                table += "</table>";
                return table;
            }

            function translate(translation, table) {

                var translationHeader = Object.keys(translation);

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

                    table = table.replace(translationHeader[i], translation[translationHeader[i]]);


                }

                return table;
            }

            function ISO8601_week_no(dt)
            {
                var tdt = new Date(dt.valueOf());
                var dayn = (dt.getDay() + 6) % 7;
                tdt.setDate(tdt.getDate() - dayn + 3);
                var firstThursday = tdt.valueOf();
                tdt.setMonth(0, 1);
                if (tdt.getDay() !== 4)
                {
                    tdt.setMonth(0, 1 + ((4 - tdt.getDay()) + 7) % 7);
                }
                return 1 + Math.ceil((firstThursday - tdt) / 604800000);
            }


            function llenarCombos() {
                //$.isLoading("hide");
                $("#fase option").remove();
                $("#fase").append('<option value="TODOS">All</option>');
                var data = {};
                data['proyecto'] = $("#proyecto").val();
                //$.isLoading("hide");
                $.getJSON('{{path('reportemexico_llenarFaseMx')}}', data, function (data) {
                    var fases = data.fase;

                    for (var i = 0; i < fases.length; i++) {
                        $("#fase").append('<option value="' + fases[i]['id'] + '">' + fases[i]['nombre'] + '</option>');
                    }

                    $.isLoading("hide");

                });
            };

    </script>

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

            </div>
        </div>
        {%endif%}
        <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-lg-2">
                             <label>{{'monitores.proyecto' | trans}}: </label>
                             <select class="form-control" id="proyecto">
                                 <option value="TODOS">{{'inbox.all' | trans}}</option>
                                 {%for project in projects%}
                                        <option value="{{project.id}}">{{project.nombre}}</option>
                                 {%endfor%}
                             </select>
                           </div>
                           <div class="col-lg-2">
                              <label>Fase: </label>
                              <select class="form-control" id="fase">
                                  <option value="TODOS">{{'inbox.all' | trans}}</option>
                                  {%for fase in fases%}
                                         <option value="{{fase.id}}">{{fase.nombre}}</option>
                                  {%endfor%}
                              </select>
                            </div>
                          <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 top-uno">
                <h1>{{"ATP MX" | trans}}</h1>
            </div>
        </div>
        <br>
        <div class="row">
            <div class="col-lg-6" id="grafico_Instalacion" style="display: flex">
            </div>
            <div class="col-lg-6" id="primer_reporte01" style="display: flex">
            </div>
        </div>
        <br>
        <div class="row">
            <div class="col-lg-6" id="grafico_Validacion" style="display: flex">
            </div>
            <div class="col-lg-6" id="primer_reporte02" style="display: flex">
            </div>
        </div>
        <br>
        <div class="row">
            <div class="col-lg-12" id="bateria3" style="display: flex">
            </div>
           
        </div>
        <br>
        <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">
                    <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 class="listD"><a href="#" onclick="$('#primer_reporte').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                    </ul>
                </div>
            </div>
        </div>
        <div class="row" style="overflow-x: auto;">
            <div id="primer_reporte" class="col-lg-12"></div>
        </div>
        <div class="row">
            <div id="pager" class="pager col-lg-12" style="display: none">
                <form>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/first.png')}}" class="first"/>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/prev.png')}}" class="prev"/>
                    <span class="pagedisplay"></span>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/next.png')}}" class="next"/>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/last.png')}}" class="last"/>
                    <select class="pagesize" title="Select page size">
                        <option selected="selected" value="3000">3000</option>
                        <option value="2000">2000</option>
                        <option value="1000">1000</option>
                        <option  value="500">500</option>
                        <option  value="100">100</option>
                    </select>
                </form>
            </div>
        </div>
    </div>


<div class="modal fade" id="myModalDetalle" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog modal-lg" role="document">
        <div class="modal-content">
            <div class="modal-header  bg-primary">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                <h2 class="modal-title text-center" id="myModalLabel">{{'DETALLE VISITAS' | trans}}</h2>
            </div>

            <div class="modal-body">



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

            </div>

        </div>
    </div>
</div>
{% endblock %}
{% 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 %}