{% extends '::baseHighstockNew.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);}
        }
        .disabledTab{
            pointer-events: none;
        }
        .table-responsive {
            height: 400px !important;
            overflow: scroll;
            }
             .btn-claro {
            color: #fff;
            background-color: #428bca;
            border-color: #357ebd ;

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

        .header_dt{
            color: #fff;
            background-color: #428bca;
            border-color: #1598d9  !important;
        }

        .tablesorter-header-inner,table.tablesorter thead tr th,.tablesorter-filter {
            color: #fff;
            background-color: #428bca;
            border-color: #1598d9;
        }
        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: #1598d9;}
        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;
        }
        .title{
            background-color: #F7F5F7;
            color: #5288C6;
            height: 30px;
            text-align: center;
            line-height: 30px;
        }
        .text-right{
            text-align: right;
        }
        .text-left{
            text-align: left;
        }
        #grafico_OhsDesviation {
            height: 500px;
            min-width: 1100px;
            max-width: 1200px;
            margin: 0 auto;
        }
        #grafico_TotalDesviation{
            height: 500px;
            width: 400px;
            max-width: 400px;
            margin: 0 auto;
        }
        #grafico_OhsDesviationCriticality{
            height: 1500px;
            width: 1250px;
            max-width: 1250px;
            /*max-height: 1500px;*/
            margin: 0 auto;
        }
        #grafico_OhsPercentageCriticality{
            height: 500px;
            width: 400px;
            max-width: 400px;
            margin: 0 auto;
        }
        /*JSA*/
        #grafico_JsaDesviation {
            height: 500px;
            min-width: 1100px;
            max-width: 1200px;
            margin: 0 auto;
        }
        #grafico_TotalDesviationJsa{
            height: 500px;
            width: 400px;
            max-width: 400px;
            margin: 0 auto;
        }
        #grafico_JsaDesviationChecklist{
            height: 1700px;
            width: 1250px;
            max-width: 1250px;
            max-height: 1700px;
            margin: 0 auto;
        }
        #grafico_HorasJsa{
            height: 450px;
            max-height: 450px;
            width: 1540px;
            max-width: 1540px;
            margin: 0 auto;
        }
        #chart1{
            height: 450px;
            max-height: 450px;
            width: 760px;
            max-width: 760px;
            margin: 0 auto;
        }
        #chart2{
            height: 450px;
            max-height: 450px;
            width: 760px;
            max-width: 760px;
            margin: 0 auto;
        }
    </style>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script src="{{ asset('js/jquery.numeric.js') }}"></script>
    <script src="{{ asset('js/jquery.form.js') }}"></script>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script src="{{ asset('js/jquery.doubleScroll.js') }}"></script>
    <script>
        var translation = {

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

        $(function () {
            // 


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

            $(".click_tab").click(function(){
                resizeChart();
            });

            $(".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(){
              resizeChart();
              //$('#chart1').highcharts().reflow();
              //$('#chart2').highcharts().reflow();
                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(){
                resizeChart();
                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();
                }
            });

            //AUDITORIA
            $(".activar_auditoria").click(function(){
                resizeChart();
                if ($("#total_auditoria").val()>0){
                          $(".pager_auditoria").show();
                          var pagerOptions3 = {
                              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(pagerOptions3);
                    $(".pager").show();
                }else{
                    $(".pager_auditoria").hide();
                }
            });

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

            $("#clear").click(function(){
                $("#pais").val();
                $("#region").val("TODOS");
                $("#evento").val("todos");
                $('#Filtros_fechaIni').val("");
                $('#Filtros_fechaFin').val("");
            });

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

            $("#fileExcel").fileinput({

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

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

            });


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

            ///Check All///
            $('#marcador').click(function(){
              if($(this).prop('checked') == true)
              {
                $('input.get_value').prop('checked',true);
                //update1();
              }
              else
              {
                $('input.get_value').prop('checked',false);
                //update0();
              }
            });

            $(document).ready(function() {
            $(document).on('change', '[name="selected[]"]', function() {

                  var selected = '';
                  $('#formCheck input[type=checkbox]').each(function(){
                      if (this.checked) {
                          selected += $(this).val()+',';
                      }
                  });
                  selected = selected.substring(0, selected.length - 1);
                  var arreglo = selected.split(",");
                  //var arreglo = "Adecuaciones_Civiles_AG8937_1p12c5A3F_HzHgNLrEY2NP0FBhnCRibrs,Adecuaciones_Civiles_AG8937_1AzMgr9lrTIq_QxwunkNC5rzjs35thedS,Adecuaciones_Civiles_DF3885_11KfVScLWaK2mQm_sfe2pqRgpxsAg6xkr,Adecuaciones_Civiles_SO1953_12olLHfZYqihqfOYGACjtgrrlX7PLEpI9";
                  var action = "{{ path('reportemshonduras_descargarJsa') }}";
                  var target = "_blank";
                  var method = "POST";

                  $('#formCheck').attr("action",action);
                  $('#formCheck').attr("target",target);
                  $('#formCheck').attr("method",method);

                  $('#parm').attr("value",arreglo);
              });
            });

            $('.guardar').live('click',function(){
              var id = $(this).attr('id');
              var siteId = $(this).attr('siteId');
              var status = $('#estatus'+ id).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('saveJsa',{'idproyectos':idproyectos}) }}',
                    type: "POST",
                    data: {id: id, status: status, siteId:siteId},
                    success: function(response){}
                  }).done(function (json) {

                      $("#cargar").css('display','none');
                      swal(
                              'Bien !',
                              'Sitio Auditado con Exito',
                              'success'
                      )
                      table.ajax.reload(function ( json ) {
                          $("#cargar").css('display','none');
                      });
                  });
              })

            });

            $(document).ready(function() {
              $('#aprobar').click(function(){

                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','');
                    var selected = '';
                    $('input[name="selected[]"').each(function(){
                        if (this.checked) {
                            selected += $(this).val()+',';
                        }
                    });
                    selected = selected.substring(0, selected.length - 1);
                    var arreglo = selected.split(",");
                    console.log(arreglo);
                    $.ajax({
                        url: '{{ path('aprobarJsa_reporteJsa_Ohs',{'idproyectos':idproyectos}) }}',
                        type: "POST",
                        data: {arreglo: arreglo},
                        success: function(response){
                          reporteBateria();
                        }
                    }).done(function (json) {
                        $("#cargar").css('display','none');
                        swal(
                                'Bien !',
                                'Sitios Auditados con Exito',
                                'success'
                        )
                        table.ajax.reload(function ( json ) {
                            $("#cargar").css('display','none');
                        });
                    });
                });
              });
            });

            $(document).ready(function() {
              $('#rechazar').click(function(){

                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','');
                    var selected = '';
                    $('input[name="selected[]"').each(function(){
                        if (this.checked) {
                            selected += $(this).val()+',';
                        }
                    });
                    selected = selected.substring(0, selected.length - 1);
                    var arreglo = selected.split(",");
                    console.log(arreglo);
                    $.ajax({
                    url: '{{ path('rechazarJsa_reporteJsa_Ohs',{'idproyectos':idproyectos}) }}',
                    type: "POST",
                    data: {arreglo: arreglo},
                    success: function(response){
                      reporteBateria();
                    }
                  }).done(function (json) {

                        $("#cargar").css('display','none');
                        swal(
                                'Bien !',
                                'Sitios Auditados con Exito',
                                'success'
                        )
                        table.ajax.reload(function ( json ) {
                            $("#cargar").css('display','none');
                        });
                    });
                })
              });
            });

            $("#cluster").change(function(){
               if  ($("#cluster").val() != "TODOS"){
                        $.isLoading({
                                text: "Loading"
                        });

                      
                      $("#customer option").remove(); $("#customer").append('<option value="TODOS">All</option>');
                      $("#proyecto option").remove(); $("#proyecto").append('<option value="TODOS">All</option>');
                      //$("#asp option").remove(); $("#asp").append('<option value="TODOS">All</option>');
                      $("#region option").remove(); $("#region").append('<option value="TODOS">All</option>');
                      llenarCombos5(); //Pais
               }else{
                    $("#pais option").remove(); $("#pais").append('<option value="TODOS">All</option>');
               }
            });

            $("#pais").change(function(){
               if  ($("#pais").val() != "TODOS"){
                        $.isLoading({
                                text: "Loading"
                        });

                      llenarCombos6(); // Customer

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

                      llenarCombos4(); // proyecto

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

               }else{
                      $("#region option").remove(); $("#region").append('<option value="TODOS">All</option>');
               }
            });   

            $("#service_type").change(function(){
               if  ($(this).val() != "TODOS"){
                        $.isLoading({
                                text: "Loading"
                        });

                      llenarCombosAsp();
               }else{
                    $("#asp option").remove(); $("#asp").append('<option value="TODOS">All</option>');
               }
            });    
                    
        });

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

           },

           title: {
               text: title
           },

           xAxis: {
                categories: data[0],
                crosshair: true,
                labels: {
                    rotation: -30,
                    style: {
                        fontSize: '10px',
                    },
                    formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                        if(this.value.length > 12){
                            return this.value.substring(0, 12) + '...';
                        }
                        return this.value;
                    }
                },
           },

           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 createArrayToChart(chart,text)
    {
       var header = Object.keys(chart[0]);
       var x = new Array();
       var y = new Array();


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

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

       }

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

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


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

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

               if(i == 0){

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

       }



       return new Array(x,y);

    }

    function reporteBateria(){
        $(".activar_sitios_por_auditar").addClass('active');
        $(".activar_ota_por_validar").removeClass('active');
        $(".activar_auditoria").removeClass('active');
        $(".activar_ota_validadas").removeClass('active');
        $(".activar_dashboard ").removeClass('active');
        $(".activar_dashboardJsa ").removeClass('active');


        $("#sitios_por_auditar").addClass('active');
        $("#otas_por_validar").removeClass('active');
        $("#auditoria").removeClass('active');
        $("#otas_por_validadas").removeClass('active');
        $("#dashboard").removeClass('active');
        $("#dashboardJsa").removeClass('active');
        var cu = "";
        var cu = $("#cluster").val();
        var data = {};
        data['medicion'] = $("#evento").val();
        data['region'] = $("#region").val();
        data['pais'] = $("#pais").val();
        data['customer'] = $("#customer").val();
        data['proyecto'] = $("#proyecto").val();
        data['asp'] = $("#asp").val();
        data['fechaIni'] = $("#Filtros_fechaIni").val();
        data['fechaFin'] = $("#Filtros_fechaFin").val();
        data['trabajos'] = $("#trabajos").val();
        data['cluster'] = cu;
        data['idproyectos'] =  "" + {{idproyectos}};
        data['tipo_reporte'] = $("#tipo_reporte").val();
        data['service_type'] = $("#service_type").val(); 
        data['cobertura'] = $("#cobertura").val();         

        var inicio = $('#Filtros_fechaIni').val();
        var fin = $('#Filtros_fechaFin').val();
        var cluster = $('#cluster').val();  
        var pais = $('#pais').val();      
        var customer = $('#customer').val();         
        var proyecto = $('#proyecto').val(); 
        var asp = $('#asp').val();
        var region = $('#region').val();
        var valor = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();    
        var trabajos = $("#trabajos").val();
        var parametro_dia = 0;
        var detail = $('#detail').val();
        var tipo_reporte = $("#tipo_reporte").val();
        var service_type = $("#service_type").val();
        var cobertura = $("#cobertura").val();
        //var entrada_sitio = $("#entrada_sitio").val();
        $(".muestra_exportar_desviations").hide();
        var parametros = {
            'postfix' : 'lan',
            'pais': pais,
            'FechaInicio': inicio,
            'FechaFin': fin,      
            'cluster': cluster,
            'customer': customer,
            'proyecto': proyecto,
            'asp': asp,
            'region': region,
            'trabajos':trabajos,
            'valor': valor,
            'parametro_dia': parametro_dia,
            'detail': detail,
            'tipo_reporte': tipo_reporte,
            'service_type': service_type,
            'cobertura': cobertura
            //'entrada_sitio': entrada_sitio
        };

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

            var bateria0  = data.bateria0;
            var bateria  = data.bateria;
            var bateria1  = data.bateria1;
            var bateriaAudit = data.bateriaAudit;
            var porcent = data.porcent;
            var chart = data;
            var chartAudit2 = data.chartAudit2;
            var flag = true;           

            $("#total_monitor_sitios").val(bateria0.length);
            $("#total_monitor").val(bateria.length);
            $("#total_monitor_validadas").val(bateria1.length);
            $("#total_auditoria").val(bateriaAudit.length);


            // NUEVAS GRAFICAS
            var path = "{{ path('reportejsa_detalle_desviations_ohs') }}"; 
            if(data.grafico_TotalDesviation.length==undefined){
                if(data.grafico_TotalDesviation.categories.length>0){
                    graficaTotal('grafico_TotalDesviation',data,path,parametros,0,0);
                }else{                    
                    $("#grafico_TotalDesviation").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
            }else{                    
                $("#grafico_TotalDesviation").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
            }

            //GRAFICO DE SITES WITH DESVIATION
            if (data.grafico_OhsDesviation.length==undefined){
                if (data.grafico_OhsDesviation.categories.length>0){
                    $(".muestra_exportar_desviations").show();
                    $("#grafico_OhsDesviation").empty(); 
                    charBarras('grafico_OhsDesviation','Site with deviations in Sites Survey',chart.grafico_OhsDesviation.data,data.grafico_OhsDesviation.categories,path,null,chart.grafico_OhsDesviation.data,[0,"desc"],parametros,'',true,'column','');
                }else{
                    if ($("#grafico_OhsDesviation").highcharts()!=undefined){
                       $("#grafico_OhsDesviation").highcharts().destroy();
                    }                    
                    $("#grafico_OhsDesviation").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
            }else{
                if ($("#grafico_OhsDesviation").highcharts()!=undefined){
                   $("#grafico_OhsDesviation").highcharts().destroy();
                }                    
                $("#grafico_OhsDesviation").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
            }

            //GRAFICO DE CRITICIDAD
            //console.log(data.grafico_OhsDesviationCriticality.length,data.grafico_OhsDesviationCriticality);
            if (data.grafico_OhsDesviationCriticality.length==undefined){
                if (data.grafico_OhsDesviationCriticality.categories.length > 0){
                    $("#grafico_OhsDesviationCriticality").empty(); 
                    charBar('grafico_OhsDesviationCriticality',chart.grafico_OhsDesviationCriticality.data,path,parametros,data.grafico_OhsDesviationCriticality.categories);
                }else{
                    if ($("#grafico_OhsDesviationCriticality").highcharts()!=undefined){
                       $("#grafico_OhsDesviationCriticality").highcharts().destroy();
                    }                    
                    $("#grafico_OhsDesviationCriticality").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
            }else{
                if ($("#grafico_OhsDesviationCriticality").highcharts()!=undefined){
                   $("#grafico_OhsDesviationCriticality").highcharts().destroy();
                }                    
                $("#grafico_OhsDesviationCriticality").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
            }

            //GRAFICO PORCENTAJE DE CRITICIDAD            
            if(data.grafico_OhsPercentageCriticality.length==undefined){
                if(data.grafico_OhsPercentageCriticality.categories.length>0){
                    graficaTotal('grafico_OhsPercentageCriticality',data,path,parametros,0,0);
                }else{                    
                    $("#grafico_OhsPercentageCriticality").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
            }else{                    
                $("#grafico_OhsPercentageCriticality").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
            }
            //NUEVAS GRAFICAS JSA
            // NUEVAS GRAFICAS
            var path = "{{ path('reportejsa_detalle_desviations_jsa') }}"; 
            if(data.grafico_TotalDesviationJsa.length==undefined){
                if(data.grafico_TotalDesviationJsa.categories.length>0){
                    graficaTotal('grafico_TotalDesviationJsa',data,path,parametros,0,0);
                }else{                    
                    $("#grafico_TotalDesviationJsa").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
            }else{                    
                $("#grafico_TotalDesviationJsa").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
            }

            //GRAFICO DE SITES WITH DESVIATION
            if (data.grafico_JsaDesviation.length==undefined){
                if (data.grafico_JsaDesviation.categories.length>0){
                    $(".muestra_exportar_desviations").show();
                    $("#grafico_JsaDesviation").empty(); 
                    charBarras('grafico_JsaDesviation','Site with deviations in Sites Survey',chart.grafico_JsaDesviation.data,data.grafico_JsaDesviation.categories,path,null,chart.grafico_JsaDesviation.data,[0,"desc"],parametros,'',true,'column','');
                }else{
                    if ($("#grafico_JsaDesviation").highcharts()!=undefined){
                       $("#grafico_JsaDesviation").highcharts().destroy();
                    }                    
                    $("#grafico_JsaDesviation").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
            }else{
                if ($("#grafico_JsaDesviation").highcharts()!=undefined){
                   $("#grafico_JsaDesviation").highcharts().destroy();
                }                    
                $("#grafico_JsaDesviation").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
            }

            //GRAFICO DE CHECKLIST
            if (data.grafico_JsaDesviationChecklist.length==undefined){
                if (data.grafico_JsaDesviationChecklist.categories.length > 0){
                    $("#grafico_JsaDesviationChecklist").empty(); 
                    charBar('grafico_JsaDesviationChecklist',chart.grafico_JsaDesviationChecklist.data,path,parametros,data.grafico_JsaDesviationChecklist.categories);
                }else{
                    if ($("#grafico_JsaDesviationChecklist").highcharts()!=undefined){
                       $("#grafico_JsaDesviationChecklist").highcharts().destroy();
                    }                    
                    $("#grafico_JsaDesviationChecklist").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
            }else{
                if ($("#grafico_JsaDesviationChecklist").highcharts()!=undefined){
                   $("#grafico_JsaDesviationChecklist").highcharts().destroy();
                }                    
                $("#grafico_JsaDesviationChecklist").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
            }
            //FIN JSA

            if(bateria1.length == 0){
              $(".pager_otas_validadas").hide();
              $("#reporte_otas_validadas").empty();
              $("#reporte_otas_validadas").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
              $.isLoading("hide");
            }else {
              $("#reporte_otas_validadas").empty().append(createTable(bateria1,'','',3));
              $.isLoading("hide");
            }

            if (chart.grafico_HorasJsa.categories.length > 0){
                $("#mostrar_excel_entrada").show();
                $("#grafico_HorasJsa").empty();                    
                var series = getDataToObjectSerieAll(chart.grafico_HorasJsa.data, Object.keys(chart.grafico_HorasJsa.data[0]));
                createChartColumnPeq('grafico_HorasJsa', chart.grafico_HorasJsa.categories, series, 'Fulfillment',
                        null, inicio, fin, null,null,"{{ path('reportejsa_detalle_dashborads_Jsa_Ohs',{'idproyectos':idproyectos}) }}", chart.grafico_HorasJsa.data,parametros);
            }else{
                if ($("#grafico_HorasJsa").highcharts()!=undefined){
                    $("#grafico_HorasJsa").highcharts().destroy();
                }                    
                $("#grafico_HorasJsa").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                $("#mostrar_excel_entrada").hide();
            }

            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");
               resizeChart();
               //$(".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(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(createTable(bateria,'','',2));
              resizeChart();
               $.isLoading("hide");
            }

            //GRAFICO CHART1
            if (chart.chart1.categories.length > 0){
                $("#chart1").empty();
                var series = getDataToObjectSerieAll1(chart.chart1.data,Object.keys(chart.chart1.data[0]));
                createChartColumnPareto('chart1', chart.chart1.categories, series, 'Approved By Project',
                        null, null, null, null, parametros,null,"{{ path('reportejsa_detalle_dashborads_Jsa_Ohs') }}",  chart.chart1.data,320,'')
            }else{
                if ($("#chart1").highcharts()!=undefined){
                    $("#chart1").highcharts().destroy();
                }
                $("#chart1").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
            }

            //GRAFICO CHART2
            if (chart.chart2.categories){
                $("#chart2").empty();
                var series = getDataToObjectSerieAll(chart.chart2.data,Object.keys(chart.chart2.data[0]));
                createChartColumn('chart2', chart.chart2.categories, series, 'Approval Summary',
                        null, inicio, fin, null,null,"{{ path('reportejsa_detalle_dashborads_Jsa_Ohs') }}", chart.chart2.data,parametros,null,null,null,null,null,null);
            
            }else{
                if ($("#chart2").highcharts()!=undefined){
                    $("#chart2").highcharts().destroy();
                }
                $("#chart2").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
            }
            ///PARA LA NUEVA PESTANA DE AUDITORIAS

            if(bateriaAudit.length == 0){
              $(".pager_auditoria").hide();
              $("#reporte_auditoria").empty();
              $("#reporte_auditoria").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
              $.isLoading("hide");
            }else {
              $("#reporte_auditoria").empty().append(createTable(bateriaAudit,'','',4));
              $.isLoading("hide");
            }

            if (chart.chartAudit1.categories.length > 0){
                $("#chartAudit1").empty();
                var series = getDataToObjectSerieAll1(chart.chartAudit1.data,Object.keys(chart.chartAudit1.data[0]));
                createChartColumnPareto('chartAudit1', chart.chartAudit1.categories, series, 'Approved By Project',
                        null, null, null, null, parametros,null,"{{ path('reportejsa_detalle_dashborads_Jsa_Ohs') }}",  chart.chartAudit1.data,320,'')
            }else{
                if ($("#chartAudit1").highcharts()!=undefined){
                    $("#chartAudit1").highcharts().destroy();
                }
                $("#chartAudit1").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
            }

            //GRAFICA 2 DE AUDIT
            if(chartAudit2.length == 0){
                $("#chartAudit2").empty();
                if ($("#chartAudit2").highcharts()!=undefined){
                   $("#chartAudit2").highcharts().destroy();
                }
                $("#chartAudit2").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                $.isLoading("hide");
                $("#inicio").show();
                flag = false;

            }else {

              if(flag){

                  createColumnChart('chartAudit2','Audit Status',chartAudit2);


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

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

              }

              if ($("#chartAudit2").highcharts()!=undefined){
                    $('#chartAudit2').highcharts().reflow();
              }

            }
            

            $.isLoading("hide");
            resizeChart();
        });
    }

  
    function charBarras(render,title,data,categories,path,w,rawData,orderArray,parametros,stacking,showInLegend,type,subtitle){
        var series = []; 
        if (render=='grafico_OhsDesviation' || render=='grafico_JsaDesviation'){
            if (data.length>0){
                var seriesTotal = getDataToObjectSerieAll(data, Object.keys(data[0]));
                $.each(seriesTotal, function(key, value) {
                    $.each(value, function(k, v) { 
                        if(k==0){ //total
                           series.push({"color":'#4777AF',"name":v.name,"data":v.data});  
                        }else if (k==1){ 
                          series.push({"color":'#FFC824',"name":v.name,"data":v.data});  
                        }else if (k==2){ 
                          series.push({"color":'#55954F',"name":v.name,"data":v.data});  
                        }
                    });
                });
            }      
        }  
        var pro = series.length>0 ? Math.ceil(series[0].data.length) : 0;
        if (pro>0){
            pro = pro -1;
        }
        var max = pro<30 ? pro : 30;       
        //console.log(series,series.length,pro,max);
        var options = {
            chart: {
                borderColor: '#428bca',
                type: 'column', 
                credits: {
                    enabled: false
                },
            },   
            title: {
                text: title
            },
            subtitle:{
                text: subtitle
            },
            scrollbar: {
                 enabled: true
            },
            xAxis: {
                min: 0,
                max: max,                
                categories: categories,
                labels: {
                    rotation: -90,
                    style: {
                        fontSize: '12px',
                    },
                    formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                        if(this.value.length > 12){
                            return this.value.substring(0, 12) + '...';
                        }
                        return this.value;
                    }
                },
            },
            yAxis: {
                min: 0,
                title: {
                    text: 'Values'
                },
            },
            credits: {
                enabled: false
            },
            series: series
        };
        // OPCIONAL: El path para la tabla detallada
        if (path != null){
            options['plotOptions'] =
            {
                series:
                {
                    pointWidth: 6,
                    dataLabels:
                    {
                        enabled: true,
                        formatter: function () {
                            if (this.point.y==0){
                                return '';
                            }else{
                                 return this.point.y;
                            }
                        }
                    },
                    point: {
                        events:{
                            click: function (e){
                                var categoryPath = options.xAxis.categories;
                                var selected_serie = this.series.name;
                                var row = rawData[this.x];
                                parametros['kpi'] = "DETALLE_DESVIATIONS_CREW";
                                var title_detalle = 'Site With Deviations in Site Survey';//+this.series.name;
                                var subtitle_detalle = categoryPath[this.x];
                                parametros['serie'] = this.series.name;
                                parametros['crew_leader'] = categoryPath[this.x];        
                                generateModalNew(path, parametros, false, title_detalle, subtitle_detalle,orderArray);
                            }
                        }
                    }
                }
            };
        };
        return $('#'+render).highcharts(options);
    }  
    function charBar(render,data,path,parametros,categories){

        var series = []; 
        if (render=='grafico_OhsDesviationCriticality'){
            if (data.length>0){
                var seriesTotal = getDataToObjectSerieAll(data, Object.keys(data[0]));
                $.each(seriesTotal, function(key, value) {
                    $.each(value, function(k, v) { 
                        if (v.name=='Critical Deviation'){//ROJO
                            series.push({"name":v.name,"data":v.data,"color":'#FB0000'});
                        }else if (v.name=='Major Deviation'){//AMARILLO
                            series.push({"name":v.name,"data":v.data,"color":'#FFC824'});
                        }else if (v.name=='Minor Deviation'){//VERDE
                            series.push({"name":v.name,"data":v.data,"color":'#55954F'});
                        } 
                    });
                });
            }      
        }else if (render=='grafico_JsaDesviationChecklist'){
            if (data.length>0){
                var seriesTotal = getDataToObjectSerieAll(data, Object.keys(data[0]));
                $.each(seriesTotal, function(key, value) {
                    $.each(value, function(k, v) { 
                        if (v.name=='Deviations'){//ROJO
                            series.push({"name":v.name,"data":v.data,"color":'#FB0000'});
                        }
                    });
                });
            } 
        } 
        var options = {
            chart: {
                type: 'bar'
            },
            title: {
                text: '',
                align: 'left'
            },
            subtitle: {
                text: '',
                align: 'left'
            },
            xAxis: {
                categories: categories,
            },
            yAxis: {
                min: 0,
                title: {
                    text: 'Values',
                },
            },
            plotOptions: {
                bar: {
                    dataLabels:
                    {
                        enabled: true,
                        formatter: function () {
                            if (this.point.y==0){
                                return '';
                            }else{
                                 return this.point.y;
                            }
                        }
                    },
                },
                series:{
                    pointWidth: 6,
                    point: {
                        events:{
                            click: function (e){
                                var categoryPath = options.xAxis.categories;
                                var selected_serie = this.series.name;
                                parametros['kpi'] =render=='grafico_OhsDesviationCriticality'? "DETALLE_DESVIATIONS_BY_CRITICALY" : "DETALLE_DESVIATIONS_BY_CHECKLIST";
                                var title_detalle = render=='grafico_OhsDesviationCriticality'?'Deviations by criticality - '+this.series.name : 'Deviations';
                                var subtitle_detalle = categoryPath[this.x];
                                parametros['serie'] = this.series.name;
                                parametros['question'] = categoryPath[this.x];        
                                generateModalNew(path, parametros, false, title_detalle, subtitle_detalle,'');
                            }
                        }
                    }
                }
            },
            credits: {
                enabled: false
            },
            series: series
        }; 
        return $('#'+render).highcharts(options);
    }  
    function graficaTotal(render,data,path,parametros,totalSemana1,total){         
        var dataTotal = new Array();
        var categoriesWeek1 = new Array();
        if(render=='grafico_TotalDesviation'){
            var granTotal = 0;
            var grafico_TotalDesviation = data.grafico_TotalDesviation;     
            if (grafico_TotalDesviation.data.length>0){
                var seriesGraficoWeek1 = getDataToObjectSerieAll(grafico_TotalDesviation.data, Object.keys(grafico_TotalDesviation.data[0]));
                categoriesWeek1 = grafico_TotalDesviation.categories;
                $.each(seriesGraficoWeek1, function(key, value) {
                    $.each(value, function(k, v) { 
                        //dataTotal[k] = [v.name,v.data[0],v.data[0]]; 
                        if (v.name=="Sites with deviations"){
                            dataTotal[k] = [v.name,v.data[0],'#FFC824',v.data[0]]; 
                        }else if (v.name=="Sites without deviations"){
                            dataTotal[k] = [v.name,v.data[0],'#55954F',v.data[0]];  
                        }
                        granTotal += v.data[0];
                    });
                });
            }  
        }else if(render=='grafico_TotalDesviationJsa'){
            var granTotal = 0;
            var grafico_TotalDesviationJsa = data.grafico_TotalDesviationJsa;     
            if (grafico_TotalDesviationJsa.data.length>0){
                var seriesGraficoWeek1 = getDataToObjectSerieAll(grafico_TotalDesviationJsa.data, Object.keys(grafico_TotalDesviationJsa.data[0]));
                categoriesWeek1 = grafico_TotalDesviationJsa.categories;
                $.each(seriesGraficoWeek1, function(key, value) {
                    $.each(value, function(k, v) { 
                        //dataTotal[k] = [v.name,v.data[0],v.data[0]]; 
                        if (v.name=="Sites with deviations"){
                            dataTotal[k] = [v.name,v.data[0],'#FFC824',v.data[0]]; 
                        }else if (v.name=="Sites without deviations"){
                            dataTotal[k] = [v.name,v.data[0],'#55954F',v.data[0]];  
                        }
                        granTotal += v.data[0];
                    });
                });
            }  
        }else if (render=='grafico_OhsPercentageCriticality'){
            var granTotal = 0;
            var grafico_OhsPercentageCriticality = data.grafico_OhsPercentageCriticality;   
            if (grafico_OhsPercentageCriticality.data.length>0){
                var seriesGraficoWeek1 = getDataToObjectSerieAll(grafico_OhsPercentageCriticality.data, Object.keys(grafico_OhsPercentageCriticality.data[0]));
                categoriesWeek1 = grafico_OhsPercentageCriticality.categories;
                $.each(seriesGraficoWeek1, function(key, value) {
                    $.each(value, function(k, v) { 
                        //dataTotal[k] = [v.name,v.data[0],v.data[0]]; 
                        if (v.name=="100%"){//VERDE
                            dataTotal[k] = [v.name,v.data[0],'#55954F',v.data[0]]; 
                        }else if (v.name=="96% -> 99%"){
                            dataTotal[k] = [v.name,v.data[0],'#FFC824',v.data[0]];  
                        }else if (v.name=="90% -> 95%"){
                            dataTotal[k] = [v.name,v.data[0],'#F95707',v.data[0]]; 
                        }else if (v.name=="< 90%"){//ROJO
                            dataTotal[k] = [v.name,v.data[0],'#FB0000',v.data[0]]; 
                        } 
                        granTotal += v.data[0];
                    });
                });
            }  
        }
        
        var height = 280;
        var width = 300;
        var y = -20;     
        var options = {
            chart: {
                plotBackgroundColor: null,
                plotBorderWidth: null,
                plotShadow: false,
                type: 'pie'
            },
            tooltip: {
                pointFormat: '{series.name}: <b>Values: {point.y} - {point.percentage:.1f}%</b>'
            },
            title: {
                text: granTotal,
                align: 'center',
                verticalAlign: 'middle',
                y: y
            },
            legend: {
                itemStyle: {
                  "color": "#333333",
                  "cursor": "pointer",
                  //"fontSize": "10px",
                  "align": "left",
                  "width": "100%",
                }
            },                   
            credits: {
                enabled: false
            }, 
            plotOptions: {
                pie: {
                    dataLabels: {
                        enabled: true,
                        //distance: -20,
                        style: {
                            //fontWeight: 'bold',
                            color: 'white'
                        }
                    },
                    //startAngle: 260,
                    //endAngle: 260,
                    //center: ['50%', '50%'],
                    //size: '90%'
                }
            },
            series: [{
                size: '70%',
                innerSize: '50%',
                keys: ['name', 'y', 'color','valor'],
                data: dataTotal,
                showInLegend: true
            }],
            colors: (render=='grafico_TotalDesviation' || render=='grafico_TotalDesviationJsa')? ['#FFC824','#55954F'] : ['#55954F','#FFC824','#F95707','#FB0000'],
        }        
        if (path != null){
            options['plotOptions'] =
            {
                series:
                {
                    cursor: 'pointer',
                    dataLabels: {
                        enabled: true,
                        format: '{point.percentage:.1f}',
                        distance: 20,
                        style: {
                        }
                    },
                   // size: '150%',
                    point:
                    {
                        events:
                        {
                            click: function (e){
                                if (this != null){
                                    var selected_serie = this.name;
                                    if (render=='grafico_TotalDesviation'){
                                        parametros['kpi'] = "DETALLE_DESVIATIONS_TOTAL";
                                        var title_detalle = 'Total '+selected_serie;
                                        //+selected_serie;
                                    }else if (render=='grafico_TotalDesviationJsa'){
                                        parametros['kpi'] = "DETALLE_DESVIATIONS_TOTAL";
                                        var title_detalle = 'Total Sites with Deviations';//+selected_serie;
                                    }else if (render=='grafico_OhsPercentageCriticality'){
                                        parametros['kpi'] = "DETALLE_DESVIATIONS_TOTAL_PORCENTAGE";
                                        var title_detalle = 'Total Deviations by criticality - '+selected_serie;
                                    }                                      
                                    parametros['serie'] = selected_serie;     
                                    generateModalNew(path, parametros, false, title_detalle, '','');
                                }else{
                                    alert('Data Not Found');
                                }
                            }
                        }
                    }
                }
            };
        }
        return $('#'+render).highcharts(options);      
    } 

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

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

        ///////////// NEW CHART /////////////////////

        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=='chart2'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {
                            if(k==0){//total
                               data.push({"color":'#00A9E5',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==1){//otas validadas
                              data.push({"color":'#90ED7D',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==2){ //otas por validar
                              data.push({"color":'#FF0000',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==3){ //otas rechazadas
                              data.push({"color":'#E3F705',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            } else if (k==4){ //%validas
                              data.push({"color":'#0C265D',"name":v.name,"data":v.data,yAxis: 1});
                            } else if (k==5){ //%rechazadas
                              data.push({"color":'#F7610F',"name":v.name,"data":v.data,yAxis: 1});
                            }
                        });
                    });
                }
            }
            var subtitle = '';

            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_Checkin_Diario'?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;
                                        parametros['categoria'] = '';
                                        parametros['ofensor'] = '';
                                        var subtitle_detalle = '';
                                        if(render=='chart2'){
                                                t = "DETAIL APPROVAL SUMARY";
                                                parametros['kpi'] = selected_serie=='APPROVED'?
                                                                    "DETALLE_APPROVAL_STATUS":
                                                                    selected_serie=='APPROVED FTR'?
                                                                    "DETALLE_APPROVAL_FTR":
                                                                    "DETALLE_APPROVAL_NOT_FTR";
                                                parametros['categoria'] = selected_serie;
                                        }
                                        var title_detalle = t;
                                        var subtitle_detalle = '';
                                        generateModalNew(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 createChartColumnPareto(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, parametros, orderArray, path, rawData,height,subtitle){
            //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) {
                        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 kpi = "";
            var porcentaje = data[0].data;
            /*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',
                    borderColor: '#428bca',
                    borderWidth: 1,
                    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
                  },
                  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: -25,
                                lineWidth: 1,
                                tickWidth: 1,
                                style: {
                                    fontSize: '10px',
                                    color: '#333333'
                                    //color: '#4c4c4c'
                                }
                            }, // 2nd-level
                                {
                                    //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                    rotation: -25,
                                    lineWidth: 0,
                                    tickWidth: 0,
                                    //align: 'right',
                                    style: {
                                        fontSize: '9px',
                                        color: '#333333'
                                        //color: '#4c4c4c'
                                    }
                                }
                            ],
                            lineWidth: 0,
                            tickWidth: 0,
                            rotation: -25,
                            //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 > 10){
                                    return this.value.substring(0, 10) + '...';
                                }
                                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)'

                },*/

                legend: {
                    layout: 'vertical',
                    align: 'left',
                    verticalAlign: 'top',
                    x: 60,
                    y: 100,
                    floating: true,
                    borderWidth: 1,
                    backgroundColor: '#FFFFFF',
                    shadow: true
                },

                  yAxis: [{ // Primary yAxis
                    plotLines: [
                        {
                            value: 0,
                            width: 1,
                            color: '#808080'
                        }
                    ],
                    title: {
                      text: 'Qty',
                      style: {
                        color: Highcharts.getOptions().colors[1]
                      }
                    },
                    min: 0,
                    //tickPositions: [0,5,10,20,30,50,70,yMax],
                  },{ // Secondary yAxis
                    title: {
                      text: 'Percent (%)'
                    },
                    //max: 100,
                    min: 0,
                    //tickPositions: [0,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){
                                        parametros['selected_serie'] = '';
                                        var row = rawData[this.x];
                                        parametros['categoria'] = '';
                                        parametros['ofensor'] = '';
                                        var categoriaDetalle =  row['_cat_RootCause'];
                                        var selected_serie = this.series.name;
                                        //console.log(series.categorias);
                                        if (render=='chart1' || render=='chart2'){
                                            var t = '';
                                            if(render=='chart1'){
                                                t = "DETAIL APPROVAL BY PROJECT";
                                                parametros['kpi'] = "DETALLE_PARETO";
                                                parametros['categoria'] = row._cat_Proyecto?row._cat_Proyecto:'';
                                               //parametros['categoria'] = selected_serie;
                                            }
                                            //parametros['proyecto'] = row._cat_Proyecto?row._cat_Proyecto:'';
                                            //parametros['week'] = row._cat_Week?row._cat_Week:'';
                                            //parametros['year'] = row._cat_Year?row._cat_Year:'';
                                            var title_detalle = t;
                                            var subtitle_detalle = '';
                                            if (selected_serie=='%'){
                                                $.isLoading("hide");
                                                return false;
                                            }
                                            parametros['ofensor'] = row._cat_offender?row._cat_offender:'';
                                            generateModalNew(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]);
                    }
                }
            }
            return $('#' + render).highcharts(options);
        }

        function createChartColumnPeq(render, categoria, series, title, w,
                                   inicio, fin, pais, orderArray, path, rawData,parametros)
        {
            //ajustar la serie para la doble axies
            //colors: ['#275f76', '#00A9E5', '#55954F'],   
            var arrayReturn = new Array();
            var data = new Array();  
            if (render=='grafico_HorasJsa'){
                if (series.length>0){
                    if(parametros.parametro_dia==0){
                        $.each(series, function(key, value) {
                            $.each(value, function(k, v) {  
                                if(v.name=='<=30 min'){ //VERDE
                                   data.push({"color":'#009775',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                                }else if (v.name=='> 30 min <=60 min'){ //AMARILLO
                                  data.push({"color":'#FFC824',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                                }else if (v.name=='> 60 min <= 120 min'){ //NARANJA
                                  data.push({"color":'#ED7D31',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                                }else if (v.name=='>  120 min'){ //ROJO
                                  data.push({"color":'#FF0000',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                                }else{
                                    data.push({"name":"% Compliance","data":v.data});
                                }                      
                                
                            });
                        });
                    }
                }      
            }
            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;
            switch (render){ 
                case 'grafico_HorasJsa':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "detalle_horas";
                    height = 420;
                    break;   
                case 'grafico_HorasSalida':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "detalle_horas";
                    height = 420;
                    break;                           
            }            
            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: ''
                  },
                  xAxis: {
                    categories: [],
                    crosshair: true,
                },
                yAxis: [{
                    title: {
                        text: 'Percent (%)'
                    },
                    //minPadding: 0,
                    //maxPadding: 0,
                    max: 100,
                    min: 0,
                    labels: {
                        overflow: 'justify',
                        format: "{value}%"
                    },
                }, {
                    title: {
                        text: 'Qty'
                    },
                    //minPadding: 0,
                    //maxPadding: 0,
                    //max: 100,
                    min: 0,
                    opposite: true,
                    labels: {
                        format: "{value}"
                    }
                }],             
                series: data
            };
            //var formato = '{point.y}';
            //if (parametros.parametro_dia==1){
                //var formato = '{point.y:.2f}%';
                var formato = '{point.y:.2f}';
            //}
            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {

                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true,
                            //format: formato
                        },   
                        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];  
                                        //console.log(row,rawData);
                                        var categoriaDetalle =  row['_cat_Categoria'];
                                        var selected_serie = this.series.name;  
                                        if (render=='grafico_HorasJsa'){   
                                            parametros['mes'] = row['_cat_Mes'];  
                                            parametros['kpi'] = "detalle_horas";
                                            parametros['selected_serie'] = selected_serie;
                                            if (row['_cat_Dia_Semana']){
                                                parametros['dia_semana'] = row['_cat_Dia_Semana'];
                                            }else{
                                                parametros['dia_semana'] = '';
                                            }  
                                            if (row._cat_Categoria!=undefined){
                                                var title_detalle = 'Checkin - '+row._cat_Categoria;
                                            }else{
                                                var title_detalle = 'FULFILLMENT';
                                            }                                            
                                            var subtitle_detalle = selected_serie;
                                            if(selected_serie=='%'){
                                                $.isLoading("hide");
                                                return false;
                                            }
                                        }    
                                        if (render=='grafico_HorasSalida'){            
                                            parametros['kpi'] = "detalle_horas_salida";
                                            parametros['selected_serie'] = selected_serie;
                                            if (row['_cat_Dia_Semana']){
                                                parametros['dia_semana'] = row['_cat_Dia_Semana'];
                                            }else{
                                                parametros['dia_semana'] = '';
                                            }  
                                            if (row._cat_Categoria!=undefined){
                                                var title_detalle = 'Checkout - '+row._cat_Categoria;
                                            }else{
                                                var title_detalle = 'Checkout';
                                            }                                            
                                            var subtitle_detalle = selected_serie;
                                            if(selected_serie=='%'){
                                                $.isLoading("hide");
                                                return false;
                                            }
                                        }                                             
                                        parametros['selected_item'] = categoriaDetalle;
                                        //parametros['selected_serie'] = '';
                                        generateModalNew(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 = valor? Object.keys(valor[0]) : 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 abrirLinks(site_id){
            //console.log(site_id);
            var path = "{{ path('reportejsa_detalle_linsk_Jsa_Ohs') }}"
            var parametros = {};
            parametros['site_id'] = site_id;
            generateModalNew(path, parametros, false,  "Deliverables", "", null);
            
        }
        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] = 'ENTREGABLE';
                    };*/
                    var strHideFilter = "";
                    if (header[j] == 'CHECK') {
                         strHideFilter = " sorter-false filter-false "
                    }

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

                        if (option == 1) {
                            table += "<th style='vertical-align:middle; width:300px' class='text-center " + strHideFilter + "'>" + header[j] + "</th>";
                        } else{
                            table += "<th style='vertical-align:middle;' class='text-center " + strHideFilter + "'>" + header[j] + "</th>";
                        }
                    }

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

                }

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

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

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

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

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

                            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] != 'ACCION' && header[j] != 'RowId' && header[j] != 'auditoria'  && header[j] != '% AUDITED MP'  && header[j] != '% AUDITED MC' && header[j] != 'ENTREGABLE' && header[j] != 'STATUS' && header[j] != 'REF' && header[j] != 'AUDIT STATUS' && header[j] != 'ART' && header[j] != 'ATAR')
                            {

                                //  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] == '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] == 'STATUS')
                        {
                            if (option == 1) {
                                table += "<td class='text-center'>"+monitor[i]['STATUS']+"</td>";
                            }else{
                            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'];
                                }                                
                                var site = monitor[i]['SITE ID'];
                                var link_sde = 'NO';
                                if(monitor[i]['REF']=='SDE'){
                                    var link_sde = 'SI';
                                }
                                if (status == '_') {
                                  var status = "NOT AUDITED";
                                  //var status = monitor[i]['STATUS'];
                                }
                                if (link_sde=='NO'){
                                   table += "<td class='text-center'><a class='btn btn-link' target='_blank' href=" + un + " >"+status+"</a></td>";
                                }else{
                                    table += "<td class='text-center'><a class='btn btn-link' href='#' onclick=abrirLinks('"+site+"');>"+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] == 'AUDIT STATUS')
                        {
                                var art = monitor[i]['ART'];
                                var atar = monitor[i]['ATAR'];
                                var otroEntregable = '';
                                if (art != '_'){
                                    otroEntregable = "<br><a class='btn btn-link' target='_blank' href=" + art + " >ART</a>";
                                }
                                if (atar != '_'){
                                    otroEntregable = otroEntregable+"<br><a class='btn btn-link' target='_blank' href=" + atar + " >ATAR</a>";
                                }                                
                                if (monitor[i]['REF'] != '_') {
                                    var un = monitor[i]['REF'];
                                    var status = monitor[i]['AUDIT STATUS'];
                                    var site = monitor[i]['SITE ID'];
                                    var link_sde = 'NO';
                                    if(monitor[i]['REF']=='SDE'){
                                        var link_sde = 'SI';
                                    }
                                    if (status == '_') {
                                      var status = "NOT AUDITED";
                                      //var status = monitor[i]['STATUS'];
                                    }
                                    if (link_sde=='NO'){
                                       table += "<td class='text-center'><a class='btn btn-link' target='_blank' href=" + un + " >"+status+"</a>"+otroEntregable+"</td>";
                                    }else{
                                        table += "<td class='text-center'><a class='btn btn-link' href='#' onclick=abrirLinks('"+site+"');>"+status+"</a></td>";
                                    }
                                }else{
                                       table += "<td class='text-center'><a>"+monitor[i]['AUDIT STATUS']+"</a>"+otroEntregable+"</td>";
                                }
                        }

                        if (header[j] == 'CHECK')
                        {
                            if (monitor[i]['auditoria'] == null) {
                              var un = monitor[i]['RowId'];
                              var site = monitor[i]['SITE ID'];
                              var url = monitor[i]['REF'];
                              var pais = monitor[i]['COUNTRY']; // |"+pais+"
                              table += "<td class='text-center'><input type='checkbox' name='selected[]' class='get_value' value='"+un+"|"+site+"|"+url+"|"+pais+"'></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 resizeChart(){
                var panel_width = $('.tab-content').width();
                var offset = 32;
                //$('#chart1').width((panel_width-offset)/2);
                //$('#chart2').width((panel_width-offset)/2);
                $('#chartAudit1').width((panel_width-offset)/2);
                $('#chartAudit2').width((panel_width-offset)/2);
                //$('#grafico_HorasJsa').width(panel_width-offset);

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

                //if ($("#chart2").highcharts()!=undefined){
                //    $('#chart2').highcharts().reflow();
               // }
                if ($("#chartAudit1").highcharts()!=undefined){
                    $('#chartAudit1').highcharts().reflow();
                }

                if ($("#chartAudit2").highcharts()!=undefined){
                    $('#chartAudit2').highcharts().reflow();
                }
                //if ($("#grafico_HorasJsa").highcharts()!=undefined){
                    //$('#grafico_HorasJsa').highcharts().reflow();
                //}       
            }

        function generateModalNew(ruta, objParams, numerar, title, subtitle, orderArray)
        {   
            var title_ = title!=null ? title.trim() : "";
            var ordArr = orderArray!=null ? orderArray : null;
            $("#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();
            }
            $.getJSON(ruta, objParams, function (data)
            {
                if (data.length > 0){ 
                    var total_general = 0; 
                    var porcentaje_ohs = 0; 
                    var total_registros = 0;                          
                    var col = createTableDTDetail(Object.keys(data[0]),'tableModalDetalle', 'datatableModalDetalle',objParams.kpi,porcentaje_ohs,total_registros);
                    buildDatatablePrin('tableModalDetalle',col,data,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');
        }

        function createTableDTDetail(data, tableRender, dtRender, type, porcentaje_ohs, 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=='CRITICAL'){
                    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 = 'CRITICAL';
                                    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>CRITICAL</b>" ' +
                                            'data-container="body" data-placement="left" data-html="true" ' +
                                            'data-trigger="focus" ' +
                                            'data-content="' + strIssuesHtml  + '"' +
                                            '>' + dato + '</a>';
                                }else{
                                    return dato;
                                }
                            }
                            return dato;
                        }
                    });
                }else if (title=='MAJOR'){
                    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_MAJOR')){
                                    kpi='ftr';
                                    popup_title = 'MAJOR';
                                    var issues = row['_ISSUES_MAJOR'];  
                                    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>MAJOR</b>" ' +
                                            'data-container="body" data-placement="left" data-html="true" ' +
                                            'data-trigger="focus" ' +
                                            'data-content="' + strIssuesHtml  + '"' +
                                            '>' + dato + '</a>';
                                }else{
                                    return dato;
                                }
                            }
                            return dato;
                        }
                    });
                }else if (title=='MINOR'){
                    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_MINOR')){
                                    kpi='ftr';
                                    popup_title = 'MINOR';
                                    var issues = row['_ISSUES_MINOR'];  
                                    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>MINOR</b>" ' +
                                            'data-container="body" data-placement="left" data-html="true" ' +
                                            'data-trigger="focus" ' +
                                            'data-content="' + strIssuesHtml  + '"' +
                                            '>' + dato + '</a>';
                                }else{
                                    return dato;
                                }
                            }
                            return dato;
                        }
                    });
                }else if (title=='ISSUES'){
                    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>MINOR</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_OHS'){
                kpi = 'OHS';
            }else if(render=='table_EMS'){
                kpi = 'EMS';
            }else if(render=='table_OTDR1'){
                kpi = 'OTD';
            }else if(render=='table_HorasATT'){
                kpi = 'CHECKIN';
            }
            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: 'Excel_'+kpi
                    }
                ],
                drawCallback: function() {
                    $('[data-toggle="popover"]').popover();
                } 
            } );
        }


        function translate(translation,table){

            var translationHeader = Object.keys(translation);

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

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


            }

            return table;
        }

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

     function llenarCombos(){
            $("#region option").remove();
            $("#region").append('<option value="TODOS">All</option>');
            var data = {};
            data['pais']=$("#pais").val();
            data['idproyectos'] =  "" + {{idproyectos}};
                //$.isLoading("hide");
            $.getJSON('{{path('reportejsa_llenarRegionJsa_Ohs')}}',data, function (data) {
                    var regions  = data.region;

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

                    $.isLoading("hide");

                });
        };

        function llenarCombos3(){
          $("#service_type option").remove();
          $("#service_type").append('<option value="TODOS">All</option>');
          var data = {};
          data['pais']=$("#pais").val();
          data['proyecto']=$("#proyecto").val();
          data['idproyectos'] =  "" + {{idproyectos}};
              //$.isLoading("hide");
          $.getJSON('{{path('reportejsa_llenarServiceTypeJsa_Ohs')}}',data, function (data) {
                  var service_type  = data.service_type;
                  //console.log(service_type);
                  for (var i = 0; i < service_type.length; i++) {
                      $("#service_type").append('<option value="'+service_type[i]['value']+'">' +service_type[i]['name']+ '</option>');
                  }

                  $.isLoading("hide");

              });
        };

        function llenarCombosAsp(){
          $("#asp option").remove();
          $("#asp").append('<option value="TODOS">All</option>');
          var data = {};
          data['cluster']=$("#cluster").val();
          data['pais']=$("#pais").val();
          data['customer']=$("#customer").val();
          data['proyecto']=$("#proyecto").val();
          data['service_type']=$("#service_type").val();
          data['idproyectos'] =  "" + {{idproyectos}};
              //$.isLoading("hide");
          $.getJSON('{{path('reportejsa_llenarAspJsa_Ohs')}}',data, function (data) {
                  var asp  = data.asp;

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

                  $.isLoading("hide");

              });
        };

        

        function llenarCombos4(){
          var idproyecto = {{idproyectos}};
          //alert(idproyecto);
            $("#proyecto option").remove();
            $("#proyecto").append('<option value="TODOS">All</option>');
            var data = {};
            data['pais']=$("#pais").val();
            data['customer']=$("#customer").val();
            data['idproyectos'] =  "" + {{idproyectos}};
                //$.isLoading("hide");
            $.getJSON('{{path('reportejsa_llenarProyectoJsa_Ohs')}}',data, function (data) {
                var proyects  = data.proyects;

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

                    $.isLoading("hide");
            });
          
        };

        function llenarCombos5(){
            var idproyecto = {{idproyectos}};
            $("#pais option").remove();
            $("#pais").append('<option value="TODOS">All</option>');
            var data = {};
            data['cluster']=$("#cluster").val();
            data['idproyectos'] =  "" + {{idproyectos}};
            //$.isLoading("hide");
            $.getJSON('{{path('reportejsa_llenarPaisJsa_Ohs')}}',data, function (data) {
                var paises = data.paises;
                for (var i = 0; i < paises.length; i++) {
                    $("#pais").append('<option value="'+paises[i]['id']+'">' +paises[i]['nombre']+ '</option>');
                }
                $.isLoading("hide");
            });
        };

        function llenarCombos6(){
          var idproyecto = {{idproyectos}};
          //alert(idproyecto);
            $("#customer option").remove();
            $("#customer").append('<option value="TODOS">All</option>');
            var data = {};
            data['pais']=$("#pais").val();
            data['idproyectos'] =  "" + {{idproyectos}};
                //$.isLoading("hide");
            $.getJSON('{{path('reportejsa_llenarCustomerJsa_Ohs')}}',data, function (data) {
                var customers  = data.customers;

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

                    $.isLoading("hide");
            });
          
        };

        $("#activar_Jsa").click(function(){
            resizeChart();
            $('#chart1').highcharts().reflow();
            $('#chart2').highcharts().reflow();
            $('#grafico_HorasJsa').highcharts().reflow();
        });

        //exportar excel aproved
        function ExportExcelAproved() {
          document.forms['formulario_filtros'].action="{{path('reportejsa_ExcelAprovedJsa_Ohs')}}";
          document.getElementById("formulario_filtros").submit();
        }
        function ExportExcelDesviations() {
          document.forms['formulario_filtros'].action="{{path('reportejsa_ExcelDesviations_Ohs')}}";
          document.getElementById("formulario_filtros").submit();
        }
        function ExportExcelDesviationsJsa() {
          document.forms['formulario_filtros'].action="{{path('reportejsa_ExcelDesviations_Jsa')}}";
          document.getElementById("formulario_filtros").submit();
        }
        function ExportExcelStatus() {
          document.forms['formulario_filtros'].action="{{path('reportejsa_ExcelStatusJsa_Ohs')}}";
          document.getElementById("formulario_filtros").submit();
        }

    </script>
    <form id="formulario_filtros" onsubmit="return false;">
        <div class="container-fluid">
            <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.cluster' | trans}}: </label>
                 <select class="form-control" id="cluster" name="cluster">
                     <option value="TODOS">{{'inbox.all' | trans}}</option>
                     {%for cluster in clusters%}
                         <option value="{{cluster.id}}">{{cluster.nombre}}</option>
                     {%endfor%}
                 </select>
              </div>
              <div class="col-lg-2">
                    <label>{{'monitores.pais' | trans}}: </label>
                    <select class="form-control" id="pais" name="pais">
                        <option value="TODOS">{{'inbox.all' | trans}}</option>
                        {%for pais in paises%}
                              <option value="{{pais.id}}">{{pais.nombre}}</option>
                        {%endfor%}
                    </select>
                </div>
                <div class="col-lg-2">
                    <label>Customer: </label>
                    <select class="form-control" id="customer" name="customer">
                        <option value="TODOS">{{'inbox.all' | trans}}</option>
                    </select>
                </div>
                <div class="col-lg-2">
                   <label>{{'monitores.proyecto' | trans}}: </label>
                   <select class="form-control" id="proyecto" name="proyecto">
                     <option value="TODOS">{{'inbox.all' | trans}}</option>
                   </select>
               </div>
               <div class="col-lg-2">
                   <label>Service Type : </label>
                   <!--<select class="form-control" id="service_type" name="service_type">
                     <option value="TODOS">{{'inbox.all' | trans}}</option>
                   </select>-->
                   <select class="form-control" id="service_type" name="service_type">
                     <option value="TODOS">All</option>
                     <option value="FS">Field Supervisor</option>
                     <option value="CL">Crew Leader</option>
                 </select>
               </div>               
               <div class="col-lg-2">
                  <label>ASP/ARP: </label>
                  <select class="form-control" id="asp" name="asp">
                      <option value="TODOS">{{'inbox.all' | trans}}</option>
                  </select>
               </div>
            </div>
            <br> 
            <div class="row">
                <div class="col-lg-2">
                      <label>{{'monitor.etiqueta.region' | trans}}: </label>
                     <select class="form-control" id="region" name="region">
                         <option value="TODOS">{{'inbox.all' | trans}}</option>
                     </select>
                </div>
                <div class="col-lg-2">
                  <label>{{'monitor.etiqueta.jobsAlturas' | trans}}: </label>
                 <select class="form-control" id="trabajos" name="trabajos">
                     <option value="TODOS">All</option>
                     <option value="YES">SI</option>
                     <option value="NO">NO</option>
                 </select>
                </div>
                <div class="col-lg-2">
                      <label>{{'monitor.etiqueta.coverage' | trans}}: </label>
                     <select class="form-control" id="cobertura" name="cobertura">
                         <option value="TODOS">All</option>
                         <option value="SI">SI</option>
                         <option value="NO">NO</option>
                     </select>
                 </div>
                <div class="col-lg-2">
                 <label>Area: </label>
                 <select class="form-control" id="tipo_reporte" name="tipo_reporte">
                     <option value="TODOS">{{'inbox.all' | trans}}</option>
                     <option value="ATS">IMPLEMENTACION</option>
                     <option value="OHS">INGENIERIA</option>                     
                     <option value="DT">OPTIMIZACION</option>
                 </select>
                </div>
                <div class="col-lg-2" id="parametros" style="vertical-align: bottom">
                    <br>
                   <button class="btn btn-claro" id="generar" style="vertical-align: bottom">{{'ticketDetail.boton.generar' | trans}}</button>
                   <button class="btn btn-claro" id="clear" style="vertical-align: bottom">{{'ticketDetail.boton.limpiar' | trans}}</button>
                </div>
            </div>
             <div class="row">

                    <div class="col-lg-12 text-center"  style="margin-top: 1%">
                        <h1>{{'FULFILLMENT' | 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_auditoria" name="total_auditoria" 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_Jsa">
                    <li idprocesos="155" headerid="1" gruopquery="4" class="active mainTab activar_sitios_por_auditar click_tab">
                        <a data-toggle="tab" href="#sitios_por_auditar"><strong>STATUS</strong></a>
                    </li>

                    <li idprocesos="155" headerid="1" gruopquery="4" class="mainTab activar_ota_por_validar click_tab">
                        <a data-toggle="tab" href="#otas_por_validar"><strong>APPROVED</strong></a>
                    </li>

                    <li idprocesos="155" headerid="1" gruopquery="4" class="mainTab activar_auditoria click_tab">
                        <a data-toggle="tab" href="#auditoria"><strong>AUDITS</strong></a>
                    </li>

                    
                    <li idprocesos="155" headerid="1" gruopquery="4" class="mainTab activar_ota_validadas click_tab">
                        <a data-toggle="tab" href="#otas_por_validadas"><strong>FULFILLMENT</strong></a>
                    </li>

                    <li idprocesos="155" headerid="1" gruopquery="4" class="mainTab activar_dashboard click_tab">
                        <a data-toggle="tab" href="#dashboard"><strong>EHS SS WITH DEVIATIONS</strong></a>
                    </li>

                    <li idprocesos="155" headerid="1" gruopquery="4" class="mainTab activar_dashboardJsa click_tab">
                        <a data-toggle="tab" href="#dashboardJsa"><strong>SELF-ASSESSMENT WITH DEVIATIONS</strong></a>
                    </li>
                </ul>
                <div class="tab-content activar_Jsa" style="margin-top: 20px;width:100%">
                    <div id="sitios_por_auditar" class="tab-pane active">
                        <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 class="btn-group pull-right">
                                    <a class="btn btn-default btn-sm dropdown-toggle" tabindex="0" aria-controls="tableModalDetalle" id="excelStatus" href="javascript:ExportExcelStatus()">
                                    <span class="dt-button export-excel-issus"><i class="fa fa-bars"></i>Export Excel</span>
                                    </a>
                                </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>

                    <div id="otas_por_validar" class="tab-pane">
                        <div class="row">
                            <div class="col-lg-6" id="chart1">
                            </div>
                            <div class="col-lg-6" id="chart2">
                            </div>
                        </div>
                        <br>
                        {% if (is_granted('ROLE_MAPLE_AUDITORIA') ) %}
                            <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="aprobar" style="vertical-align: bottom">Approve</button>
                                   <button class="btn btn-danger" id="rechazar" style="vertical-align: bottom">Reject</button>
                                </div>
                              </div>
                              <br />
                            </div>
                            
                        {% endif %}
                        <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">
                                    <a class="btn btn-default btn-sm dropdown-toggle" tabindex="0" aria-controls="tableModalDetalle" id="excelAproved" href="javascript:ExportExcelAproved()">
                                    <span class="dt-button export-excel-issus"><i class="fa fa-bars"></i>Export Excel</span>
                                    </a>
                                </div>
                              <!--<div class="btn-group pull-right">
                                  <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                                  <ul class="dropdown-menu" role="menu">
                                      <li><a href="#" onclick="$('#reporte_otas_por_validar').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                                  </ul>
                              </div>-->
                          </div>
                        </div>
                        <div class="pager pager_otas_por_validar" style="text-align: left">
                            <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                            <span class="pagedisplay"></span>
                        </div>
                        <div class="row">
                            <div class="col-md-12" id="reporte_otas_por_validar" style="overflow-x: auto;">
                            </div>
                        </div>
                        <!-- <div class="row double-scroll" id="reporte_otas_por_validar">

                        </div>-->
                    </div>    
                    <!-- PESTANA DE AUDITORIA -->

                    <div id="auditoria" class="tab-pane">
                        <div class="row">
                            <div class="col-lg-6" id="chartAudit1" style="width:45.5%">
                            </div>
                            <div class="col-lg-6" id="chartAudit2" style="width:45.5%">
                            </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_auditoria').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                                  </ul>
                              </div>
                          </div>
                        </div>
                        <div class="pager pager_auditoria" style="text-align: left">
                            <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                            <span class="pagedisplay"></span>
                        </div>
                        <div class="row">
                            <div class="col-md-12" id="reporte_auditoria" style="overflow-x: auto;">
                            </div>
                        </div>
                    </div>

                    <!-- FIN PESTANA DE AUDITORIA -->

                    <div id="otas_por_validadas" class="tab-pane">
                        <div class="row">
                            <div id="grafico_HorasJsa" class="col-md-12">
                            </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>
                        <div class="row">
                            <div class="col-md-12" id="reporte_otas_validadas" style="overflow-x: auto;">
                            </div>
                        </div>
                    </div>

                    <!-- DASHBOARD -->
                    <div id="dashboard" class="tab-pane">
                        <div class="row muestra_exportar_desviations">
                          <div class="col-md-12">
                              <div class="btn-group pull-right">
                                    <a class="btn btn-default btn-sm dropdown-toggle" tabindex="0" aria-controls="tableModalDetalle" id="excelDesviations" href="javascript:ExportExcelDesviations()">
                                    <span class="dt-button export-excel-issus"><i class="fa fa-bars"></i>Export Excel</span>
                                    </a>
                                </div>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-md-3"> 
                                <div class="row title" style="margin: 0px 0px 25px 0px;">
                                    Total Sites with Deviations
                                </div>
                                <br/>
                                <div class="row">
                                    <div id="grafico_TotalDesviation"></div>
                                </div> 
                            </div>
                            <div class="col-md-9">  
                                <div class="row title">
                                    Sites with deviations in Site Survey
                                </div>
                                <br/>
                                <div class="row">
                                    <div id="grafico_OhsDesviation"></div>
                                </div>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-md-3"> 
                                <div class="row title" style="margin: 0px 0px 25px 0px;">
                                    OHS INDEX
                                </div>
                                <br/>
                                <div class="row">
                                    <div id="grafico_OhsPercentageCriticality"></div>
                                </div> 
                            </div>
                            <div class="col-md-9">  
                                <div class="row title">
                                    Deviations by criticality
                                </div>
                                <br/>
                                <div class="row">
                                    <div id="grafico_OhsDesviationCriticality" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                            </div>
                        </div>
                        
                    </div>

                    <div id="dashboardJsa" class="tab-pane">
                        <div class="row muestra_exportar_desviationsJsa">
                          <div class="col-md-12">
                              <div class="btn-group pull-right">
                                    <a class="btn btn-default btn-sm dropdown-toggle" tabindex="0" aria-controls="tableModalDetalle" id="excelDesviationsJsa" href="javascript:ExportExcelDesviationsJsa()">
                                    <span class="dt-button export-excel-issus"><i class="fa fa-bars"></i>Export Excel</span>
                                    </a>
                                </div>
                            </div>                        
                        </div>
                        <div class="row">
                            <div class="col-md-3"> 
                                <div class="row title" style="margin: 0px 0px 25px 0px;">
                                    Total Sites with Deviations
                                </div>
                                <br/>
                                <div class="row">
                                    <div id="grafico_TotalDesviationJsa"></div>
                                </div> 
                            </div>
                            <div class="col-md-9">  
                                <div class="row title">
                                    Sites with deviations in Site Survey
                                </div>
                                <br/>
                                <div class="row col-md-12">
                                    <div id="grafico_JsaDesviation"></div>
                                </div>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-md-12">  
                                <div class="row title">
                                    Deviations
                                </div>
                                <br/>
                                <div class="row">
                                    <div id="grafico_JsaDesviationChecklist" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </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>
    </form>
    <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>

    <!-- Modal -->
    <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">
                <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>
{% endblock %}