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

{% block title %}ASPIR{% endblock %}

{% block logoppal %}
    <a class="navbar-brand" href="{{path('initialPage')}}" style=" margin-top: -10px;">
        <img height="42" src="{{asset('images/ASPIR_Logo.png')}}">
    </a>
{% endblock %}

{% block menuTop %}
{% endblock %}

{% block dashboard %}  
    <style>

        .wrapper{padding-bottom:50px;}
        .header{background:#000000;}.header .container{padding-bottom:20px;}.header .container h1{color:#FFF;line-height:50px;margin-top:30px;margin-bottom:0;}
        .header .container h3{color:#E0E0E0;font-size:16px;margin-top:-5px;}.header .container h3 a{color:#66aacc;}.header .container h3 a:hover{color:#b3d5e6;}
        .top-menu{position:absolute;z-index:9999;}.top-menu .nav-list{background:rgba(255, 255, 255, 0.8);border:1px solid #CCC;margin:20px;position:fixed;right:0;}
        pre,.well{background:#FFFFFF;}
        .syntax-container{background:#FCFCFC;-webkit-border-radius:7px;-webkit-background-clip:padding-box;-moz-border-radius:7px;-moz-background-clip:padding;border-radius:7px;background-clip:padding-box;border:1px solid #e3e3e3;margin-bottom:30px;padding-bottom:20px;}
        .isloading-wrapper.isloading-right{margin-left:10px;}
        .isloading-overlay{position:relative;text-align:center;}.isloading-overlay .isloading-wrapper{background:#FFFFFF;-webkit-border-radius:7px;-webkit-background-clip:padding-box;-moz-border-radius:7px;-moz-background-clip:padding;border-radius:7px;background-clip:padding-box;display:inline-block;margin:0 auto;padding:10px 20px;top:10%;z-index:9000;}

        /*Glyphicon Spinner*/
        .glyphicon-spin {
            -animation: spin .9s infinite linear;
            -webkit-animation: spin2 .9s infinite linear;
        }

        @-webkit-keyframes spin2 {
            from { -webkit-transform: rotate(0deg);}
            to { -webkit-transform: rotate(360deg);}
        }

        @keyframes spin {
            from { transform: scale(1) rotate(0deg);}
            to { transform: scale(1) rotate(360deg);}
        }

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

            padding-left: 5px;
        }
        #chart .panel-body {
            padding: 0px;
        }
        .btn-claro {
            color: #fff;
            /*background-color: #00569C;
            border-color: #3D59CA;*/
            background-color: #428bca;
            border-color: #3071a9;
        }
        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
        }
        .tabla-detalle
        {
                text-transform: uppercase;
                font-size: 9px;
        }
    
        .disabledTab{
            pointer-events: none;
        }
        #menuTop { margin-top: 0px; }

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

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

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

        .hrHide { display: none; }

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

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

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

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

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

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

        .verticalResizer{
            cursor: ns-resize;
        }

        .horizontalResizer{
            cursor: ew-resize;
        }
        .panel .panel-primary {
            min-height: 100px;
            max-height: 400px;
            height: 400px;
            overflow-y: scroll;
            overflow-x: scroll;
        }
        #grafico_SystemFaultFound{
            height: auto;
            width: 1500px;
            max-width: 1500px;
            max-height: 1500px;
            min-height: 900px;
        }
    </style>
    <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>
        Highcharts.wrap(Highcharts.Axis.prototype, 'getPlotLinePath', function(proceed) {
            var path = proceed.apply(this, Array.prototype.slice.call(arguments, 1));
            if (path) {
                path.flat = false;
            }
            return path;
        });
        //VALIDACIONES JQUERY
        $(document).ready(function (){       
            $('#myTabs a:first').tab('show');
            $('.activarButton').hide();
            //inicio validacion de la fecha
            $.fn.dataTable.moment( 'YYYY-MMM' );
            $('#Filtros_fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#Filtros_fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });            
            $('#Filtros_fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });
            //
            $('#fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });            
            $('#fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });
            //
            var f = new Date();
            var mes = (f.getMonth() + 1);
            if (mes < 10)
                mes = '0' + mes;
            var fechaI = f.getFullYear() + '-' + mes + "-01";
            var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();
            $('#fechaIni').val(fechaI);
            $('#fechaFin').val(fechaF);
            //validacion de la fecha
            //funcion para los select dependientes
            $(".get-list").change(function(e) {
                var data_select_refresh = $(this).attr('data');
                var data_act = $(this).attr('data-act');
                var campo_filtrar = $(this).attr('data-campo-filtro');  
                var campo_mostrar = $(this).attr('data-campo-mostrar'); 
                var data = {
                    valor_filtro : $(this).val(),
                    campo_filtrar : campo_filtrar,
                    campo_mostrar : campo_mostrar,
                };
                //console.log(data);
                $("."+data_act+" option").remove();
                $("."+data_act).append('<option value="TODOS">-- All --</option>');
                if ($(this).val()!='TODOS'){                    
                    $.getJSON('{{path('aspir_llenarSelect',{'idproyectos':idproyectos,'idmodule':idmodule})}}', data, function (data){
                        var registros = data.registros;
                        for (var i = 0; i < registros.length; i++){
                            $("#"+data_select_refresh).append('<option value="' + registros[i]['valor'] + '">' + registros[i]['nombre'] + '</option>');
                        }
                    });
                }
            });
            //fin select dependientes
            //accion cuando le dan al boton de generar
            $("#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"
                    });
                    getChart();
                }
                     
               
            });     
            $(document).on("click",'#btnDetalleOtd',function(){ 
                $('#datatable_02 tr').remove(); 
                $('#modalDetalleOtdTitle').text('OTD (On Time Delivery)');  
                $("#modalDetalleOtd").modal('show');
                $("#datatable_02").isLoading('hide');           
                getTableModal('general','');
            });
            $(window).resize(function(){
                //resizeChart();
            });
            $(".click_tab").click(function(){
                resizeChart();
            });
            $('a[data-toggle="tab"]').on( 'shown.bs.tab', function (e) {
                $.fn.dataTable.tables( {visible: true, api: true} ).columns.adjust();
                try{
                    resizeChart();
                }catch(err) {
                    //console.log(err.message);
                }
            });
            $("#excelFtrIssues").click(function() {
                $(this).isLoading();
                setTimeout( function(){
                    $("#excelFtrIssues").isLoading("hide");
                },2000);
            });
            $("#excelAspFtrIssues").click(function() {
                $(this).isLoading();
                setTimeout( function(){
                    $("#excelAspFtrIssues").isLoading("hide");
                },2000);
            });
            $("#excelFtrTotalSiteIssues").click(function() {
                $(this).isLoading();
                setTimeout( function(){
                    $("#excelFtrTotalSiteIssues").isLoading("hide");
                },2000);
            });
            $("#excelRangoTotalSiteIssues").click(function() {
                $(this).isLoading();
                setTimeout( function(){
                    $("#excelRangoTotalSiteIssues").isLoading("hide");
                },2000);
            });
            $(".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);
            });
            $("#DETALLE_DEFECTS").hide();
            $("#DETALLE_ISSUES").hide();
            $("#mostrar_excel_issues_ohs").hide();
            //rangosFecha('hoy');
        });
        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;               
               var dia = f.getDate();
               if (dia < 10) dia = '0' + dia;
               //actualizar
               var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
               var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            //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;
            }
            if (opcion!="rango_fecha"){
                //$(".detalleRango").text('Of '+fechaI+' to '+fechaF);
            }else{
                //$(".detalleRango").text('');
            }
            $('#Filtros_fechaIni').val(fechaI);
            $('#Filtros_fechaFin').val(fechaF);
            if (opcion!='rango_fecha'){
                $("#generar").trigger('click');
            }
        }        
        function ExportExcelFtrIssues() {
          document.forms['formulario_filtros'].action="{{path('aspir_ExcelIssuesUki')}}";
          document.forms['formulario_filtros'].submit();
        }
        function ExportExcelAspFtrIssues() {
          document.forms['formulario_filtros'].action="{{path('aspir_ExcelIssuesAspUki')}}";
          document.forms['formulario_filtros'].submit();
        }    
        function ExportExcelFtrTotalSiteIssues() {
          document.forms['formulario_filtros'].action="{{path('aspir_ExcelIssuesFtrSitesUki')}}";
          document.forms['formulario_filtros'].submit();
        } 
        function ExportExcelRangoTotalSiteIssues() {
          document.forms['formulario_filtros'].action="{{path('aspir_ExcelIssuesRangoSitesUki')}}";
          document.forms['formulario_filtros'].submit();        
        }
        function ExportExcelIssues() {
          document.forms['formulario_filtros'].action="{{path('aspir_ExcelDetalleDefectIssuesUki')}}";
          document.forms['formulario_filtros'].submit();
        }
        function ExportExcelIssuesOhs() {
          document.forms['formulario_filtros'].action="{{path('aspir_ExcelDetalleIssuesOhs')}}";
          document.forms['formulario_filtros'].submit();
        }
        //FUNCIONES DE JAVASCRIP
        var projectList = new Array(4); //Lista de proyectos para cada gráfico
        //la grafica de linea       
        function createChartLinea2(render, categoria, series, title, w,
                               target_line, target_line2, target_line3, inicio, fin, pais, cu, path, rawData)
        {
        var options = {
            chart: {
                spacingBottom: 10, //35
                spacingTop: 40,
                spacingLeft: 40,
                spacingRight: 40,
                height: 450,
                marginBottom: 110, //180
                borderColor: '#428bca',
                borderWidth: 1,
                type: 'line',
                shadow: true,
                zoomType: 'x',
                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
                    ]
                }
            },
            plotOptions:{
                series:{
                    shadow:true,
                    dataLabels: {
                        enabled: true,
                        style: {
                            fontWeight: 'bold'
                        }
                    }
                }
            },
            legend: {
                backgroundColor: 'rgba(66, 139, 202, 0.5)'
            },
            xAxis: {
                categories: [],
                lineWidth: 1,
                lineColor: '#4c4c4c',
                tickColor: '#4c4c4c',
                tickWidth: 1,
                labels: {
                    rotation: 0,
                    style: {
                        fontSize: '9px',
                        color: '#4c4c4c'
                    }
                },
                overflow: 'justify',
                scrollbar: {
                    enabled: true
                }
            },
            yAxis:
                    [
                        {
                            min: 50,
                            max: w,
                            title: {text: ''},
                            lineWidth: 1,
                            lineColor: '#4c4c4c',
                            plotLines: [
                                {
                                    value: 0,
                                    width: 1,
                                    color: '#808080'
                                }
                            ]
                        }
                        ,
                        {
                            title: {text: ''},
                            min: 0,
                            opposite: true
                        }
                        ,
                        {
                            title: {text: ''},
                            min: 0,
                            opposite: true
                        }
                    ]
                ,
                title: {text: title},
                tooltip: {shared: true},
                colors: ["#2a587f", "#434348", "#90ed7d", "#f7a35c", "#8085e9",
                    "#f15c80", "#e4d354", "#2b908f", "#f45b5b", "#91e8e1"],
                credits: {
                    enabled: false
                },
                series: series
            };
            if (target_line != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line[0],
                    color: '#f7e81d', //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: '#2e8201', //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
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e)
                                {
                                    var parametrosUrl = {
                                        'FechaInicio': inicio,
                                        'FechaFin': fin,
                                        'selected_item': categoria[this.x],
                                        'selected_serie': this.series.name
                                    };
                                    if (rawData != null)
                                    {
                                        parametrosUrl['row'] = rawData[this.x];
                                    }

                                    var prefix = (title == null || title == '') ? '' : title + ' - ';
                                    generateModal(path, parametrosUrl, true, prefix, categoria[this.x]); 
                                }
                            }
                        }
                    }
                };
            }
            var num = categoria.length;
            var marginBottom = 70 + ((num-1) * 20);
            var menor = 200.00;
            options.chart.marginBottom = marginBottom;
            for (var k=0; k<rawData.length; k++){
                var hasThisCategory = false;
                var categoryIndex = -1;
                var categoryPath = options.xAxis.categories;
                var valorActual= parseFloat(rawData[k][series[0].name]);
                if (valorActual <= menor){
                    menor = valorActual;
                }
                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;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            if (menor >50) menor= 50;
            options.yAxis[0].min=menor;

            return $('#' + render).highcharts(options);
        }
        //fin grafiaca de linea
        // get serie
        function getDataToObjectSerie(data, header){
            var arrayReturn = new Array();
            var data1 = new Array();

            for (var i = 0; i < data.length; i++){
                data1.push(parseFloat(data[i][header[header.length - 1]]));
            }
            arrayReturn.push({'name': header[header.length - 1], 'data': data1, 'dataLabels': {'enabled': true}});
            return arrayReturn;
        }
        //fin get serie
        //funcion para crear las tablas
        function createTableDT(data, tableRender, dtRender)
        {
            //console.log('pruebaaa',data, tableRender, dtRender);
            var strHeader = "";
            var strFooter="";
            var columns = [];        ;
            var strTable = '<table id="' + tableRender + '" class="display cell-border compact stripe" width="100%">' +
                    '<thead><tr class="header_dt">';
            $('#' + dtRender).empty();
            for (var i=0; i<data.length; i++){
                var fechaGroup = ""
                var title = data[i];
                var t = title.replace(/_/g,' ');
                t = title.replace('#','');
                var visible = title.startsWith('_') ? false : true;
                if (tableRender=='table_IssuesExecuted' && t=='%OHS'){
                    t = t +"<img src='{{ asset('images/down_red.png') }}'>";
                }else if (t=='%FTR' || t=='%FTR ASP' || t=='%OTD' || t=='%QP' || t=='%OHS'){
                    t = t +"<img src='{{ asset('images/up_red.png') }}'>";
                }
                if (t!='workplan_id'){
                    
                    strHeader += '<th class="text-center">' + t + '</th>';
                }  
                //console.log(title);
                if (title=='Total Services Accepted'){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi='ftr_total_service';
                                var table_title = 'FTR Total Services';
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_uki') }}";
                                subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                                    var cliente = $('#cliente').val();//var cliente = 'AT&T';  
                                    var pais = 'MX';    
                                }            
                                else{
                                    var cliente = $('#cliente').val();
                                    var pais = 'United Kingdom';
                                }    
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                }                                               
                                var parametros = {
                                    'postfix': 'uki',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'pais': pais,
                                    'cliente': row.hasOwnProperty('Customer') ? row['Customer'] : cliente,
                                    'proyecto': row.hasOwnProperty('Project') ? row['Project'] : $('#proyecto').val(),
                                    'asp': asp,
                                    'mes': row['Month']
                                };
                                return '<a href="javascript://" ' +
                                        'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';
                            }else{
                                return dato;
                            }                            
                        }
                    });
                }else if (title=='Volume Of Sites with Audits'){//
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi='ftr_total_service';
                                var table_title = 'Volume Of SItes with Audits';
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_uki') }}";
                                subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                                    var cliente = $('#cliente').val();//var cliente = 'AT&T';  
                                    var pais = 'MX';    
                                }            
                                else{
                                    var cliente = $('#cliente').val();
                                    var pais = 'United Kingdom';
                                } 
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                }  
                                var parametros = {
                                    'postfix': 'uki',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'pais': pais,
                                    'cliente': row.hasOwnProperty('Customer') ? row['Customer'] : cliente,
                                    'proyecto': row.hasOwnProperty('Project') ? row['Project'] : $('#proyecto').val(),
                                    'asp': asp,
                                    'mes': row['Month']
                                };
                                return '<a href="javascript://" ' +
                                        'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';
                            }else{
                                return dato;
                            }                            
                        }
                    });
                }
                else if (title=='Sites with Defects raised'){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi='ftr'; 
                                var table_title = 'Sites with Defects raised';
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_uki') }}";
                                subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                                    var cliente = $('#cliente').val();//var cliente = 'AT&T';  
                                    var pais = 'MX';    
                                }            
                                else{
                                    var cliente = $('#cliente').val();
                                    var pais = 'United Kingdom';
                                } 
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                } 
                                var parametros = {
                                    'postfix': 'uki',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),                                    
                                    'pais': pais,
                                    'cliente': row.hasOwnProperty('Customer') ? row['Customer'] : cliente,
                                    'proyecto': row.hasOwnProperty('Project') ? row['Project'] : $('#proyecto').val(),
                                    'asp': asp,
                                    'mes': row['Month']
                                };
                                return '<a href="javascript://" ' +
                                        'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';
                            }else{
                                return dato;
                            }                            
                        }
                    });
                }
                else if (title=='Total Sites'){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                if (tableRender=='table_Range'){
                                    var kpi='ftr_aggregate_total_sites';
                                    var table_title = 'FTR Total Sites';
                                }else if (tableRender=='table_QualityPerformance'){
                                    var kpi='ftr_qp_total_sites';
                                    var table_title = 'QP - Total Sites';
                                }else if (tableRender=='table_OHS'){
                                    var kpi='ftr_ohs_total_sites';
                                    var table_title = 'OHS - Total Sites';
                                }else if (tableRender=='table_ExecutedNotExecuted'){
                                    var kpi='ftr_executenotexecute_total_sites';
                                    var table_title = 'OHS Executed vs Not Executed - Total Sites';
                                }else if (tableRender=='table_IssuesExecuted'){
                                    var kpi='ftr_issuesexecute_total_sites';
                                    var table_title = 'OHS Issues While Executing - Total Sites';
                                }else if (tableRender=='table_QasExecutedNotExecuted'){
                                    var kpi='ftr_Qasexecutenotexecute_total_sites';
                                    var table_title = 'QAS Executed vs Not Executed - Total Sites';
                                }                               
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_uki') }}";
                                //subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                subtitle = (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                                    var cliente = $('#cliente').val();//var cliente = 'AT&T';  
                                    var pais = 'MX';    
                                }            
                                else{
                                    var cliente = $('#cliente').val();
                                    var pais = 'United Kingdom';
                                } 
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                } 
                                var parametros = {
                                    'postfix': 'uki',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),                                    
                                    'pais': pais,
                                    'cliente': row['Customer'],
                                    'proyecto': row['Project'],                                    
                                    'asp': asp,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'mes': row['Month']
                                };
                                return '<a href="javascript://" ' +
                                        'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';
                            }else{
                                return dato;
                            }                            
                        }
                    });
                }else if (title=='Total Services'){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi='otd_total_service';
                                var table_title = 'OTD Total Service';
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_uki') }}";
                                subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                                    var cliente = $('#cliente').val();//var cliente = 'AT&T';  
                                    var pais = 'MX';    
                                }            
                                else{
                                    var cliente = $('#cliente').val();
                                    var pais = 'United Kingdom';
                                } 
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                } 
                                var parametros = {
                                    'postfix': 'uki',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),                                    
                                    'pais': pais,
                                    'cliente': row['Customer'],
                                    'proyecto': row['Project'],                                    
                                    'asp': asp,
                                    'mes': row['Month']
                                };
                                return '<a href="javascript://" ' +
                                        'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';
                            }else{
                                return dato;
                            }                            
                        }
                    });
                }else if (title=='Total Sites With Issues'){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi='issuesexecute_total_sites_with_issues';
                                var table_title = 'OHS Issues While Executing - Total Sites With Issues';
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_uki') }}";
                                subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                                    var cliente = $('#cliente').val();//var cliente = 'AT&T';  
                                    var pais = 'MX';    
                                }            
                                else{
                                    var cliente = $('#cliente').val();
                                    var pais = 'United Kingdom';
                                } 
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                } 
                                var parametros = {
                                    'postfix': 'uki',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),                                    
                                    'pais': pais,
                                    'cliente': row['Customer'],
                                    'proyecto': row['Project'],                                    
                                    'asp': asp,
                                    'mes': row['Month']
                                };
                                return '<a href="javascript://" ' +
                                        'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';
                            }else{
                                return dato;
                            }                            
                        }
                    });
                }
                else if (title.toUpperCase().indexOf(' NOT ')>=0){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi="";
                                var table_title = "";
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_uki') }}";                  
                                if (row.hasOwnProperty('%FTR')){                                   
                                    kpi='ftr';                  
                                    table_title = 'FIRST TIME RIGHT';
                                    subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                    subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                }  else if (row.hasOwnProperty('%QP')){
                                    kpi='qp';
                                    table_title = 'QP - ' + tit.toUpperCase();
                                    subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                    subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                }else if (row.hasOwnProperty('%FTR ASP')){
                                    kpi='ftr_asp';
                                    table_title = 'FTR ASP';
                                    subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                    subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                }else if (row.hasOwnProperty('%OHS')){
                                    kpi='ohs';
                                    table_title = 'OHS - ' + tit.toUpperCase();
                                    subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                    subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                }else if (row.hasOwnProperty('%FTR ASP')){
                                    kpi='ftr_asp';
                                    table_title = 'FTR ASP';
                                    subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                    subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                }else if (row.hasOwnProperty('Total Services Not Delivered<br>On Time')){
                                    kpi='OTD';
                                    table_title = 'OTD';
                                    subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                    subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                }else if (row.hasOwnProperty('%QAS')){
                                    kpi='qas';
                                    table_title = 'QAS - ' + tit.toUpperCase();
                                    subtitle= row.hasOwnProperty('Month') ? row['Month'] : "";
                                    subtitle += (row.hasOwnProperty('Customer') ? " [" + row['Customer'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('Project') ? " [" + row['Project'] + "]" : "") ;
                                    subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                }     
                                if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                                    var cliente = $('#cliente').val();//var cliente = 'AT&T';  
                                    var pais = 'MX';    
                                }            
                                else{
                                    var cliente = $('#cliente').val();
                                    var pais = 'United Kingdom';
                                } 
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                } 
                                var parametros = {
                                    'postfix': 'uki',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),                                    
                                    'pais': pais,
                                    'cliente': row.hasOwnProperty('Customer') ? row['Customer'] : cliente,
                                    'proyecto': row.hasOwnProperty('Project') ? row['Project'] : $('#proyecto').val(),
                                    'region': row.hasOwnProperty('Region') ? row['Region'] :$('#region').val(),
                                    'cu': row.hasOwnProperty('Cluster') ? row['Cluster'] : $('#cluster').val(),
                                    'asp': asp,
                                    'mes': row['Month']
                                };

                                if (type==='display'){
                                    var ord = null;
                                    if (tableRender=='table_FTR'){ // FTR
                                        ord = '[4,"Desc"]';
                                    }else if(tableRender=='table_02'){ //QP
                                        ord = '[0,"Desc"]';
                                    }else if(tableRender=='table_03'){ //OHS
                                        ord = '[5,"Desc"]';
                                    }else if(tableRender=='table_04'){ //ASP Dashboard
                                        ord = '[4,"Desc"]';
                                    }else if(tableRender=='table_01'){ //ASP Dashboard
                                        ord = '[4,"Desc"]';
                                    }
                                    return '<a href="javascript://" ' +
                                            'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';
                                }else{
                                    return dato;
                                }
                            }
                            return dato;
                        }
                    });
                }else if(title == 'Month'){  
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {     
                            fechaGroup = dato;
                            return dato;                 
                        }
                    });
                }else if(title == 'KPIs'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (type==='display'){                               
                                if (row.hasOwnProperty('%OTD')){
                                    if (parseFloat(row['%OTD']) >=0 && parseFloat(row['%OTD']) < 80){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust">';
                                    }else if (parseFloat(row['%OTD']) >=80 && parseFloat(row['%OTD']) < 85){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['%OTD']) >= 85 && parseFloat(row['%OTD']) <= 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }
                                }
                                if (row.hasOwnProperty('%OHS')){   
                                    if (tableRender=='table_IssuesExecuted'){
                                        if (parseFloat(row['%OHS'])>20){
                                           return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                        }else if (parseFloat(row['%OHS']) <=20){
                                           return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                        }
                                    }else{
                                        if (parseFloat(row['%OHS'])>=80){
                                            return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                        }else if (parseFloat(row['%OHS']) <80){
                                            return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                        }
                                    }
                                }
                                if (row.hasOwnProperty('%QAS')){   
                                    if (tableRender=='table_IssuesExecuted'){
                                        if (parseFloat(row['%QAS'])>20){
                                           return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                        }else if (parseFloat(row['%QAS']) <=20){
                                           return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                        }
                                    }else{
                                        if (parseFloat(row['%QAS']) <70){
                                            return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                        }else if (parseFloat(row['%QAS']) >=70 && parseFloat(row['%QAS']) <80){
                                            return '<img src="{{ asset('images/robust.jpg') }}" title="Robust" width="">';
                                        }else if (parseFloat(row['%QAS']) >=80 && parseFloat(row['%QAS']) < 90){
                                            return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                        }else if (parseFloat(row['%QAS']) >=90 && parseFloat(row['%QAS']) <= 100){
                                            return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                        } 
                                    }
                                }
                                if (row.hasOwnProperty('%FTR')){   
                                    if (parseFloat(row['%FTR']) <70){
                                        return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                    }else if (parseFloat(row['%FTR']) >=70 && parseFloat(row['%FTR']) <80){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust" width="">';
                                    }else if (parseFloat(row['%FTR']) >=80 && parseFloat(row['%FTR']) < 90){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['%FTR']) >=90 && parseFloat(row['%FTR']) <= 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }  
                                }
                                if (row.hasOwnProperty('%QP')){
                                    if (parseFloat(row['%QP']) <70){
                                        return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                    }else if (parseFloat(row['%QP']) >=70 && parseFloat(row['%QP']) <80){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust" width="">';
                                    }else if (parseFloat(row['%QP']) >=80 && parseFloat(row['%QP']) < 90){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['%QP']) >=90 && parseFloat(row['%QP']) <= 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }  
                                } 
                                if (row.hasOwnProperty('%FTR ASP')){
                                    if (parseFloat(row['%FTR ASP']) <70){
                                        return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                    }else if (parseFloat(row['%FTR ASP']) >=70 && parseFloat(row['%FTR ASP']) <80){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust" width="">';
                                    }else if (parseFloat(row['%FTR ASP']) >=80 && parseFloat(row['%FTR ASP']) < 90){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['%FTR ASP']) >=90 && parseFloat(row['%FTR ASP']) <= 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }  
                                }                               
                            }else{                               
                                if (row.hasOwnProperty('%OTD')){
                                    if (parseFloat(row['%OTD']) >=0 && parseFloat(row['%OTD']) < 80){
                                        return 'Robust';
                                    }else if (parseFloat(row['%OTD']) >=80 && parseFloat(row['%OTD']) < 85){
                                        return 'Commitment';
                                    }else if (parseFloat(row['%OTD']) >= 85 && parseFloat(row['%OTD']) <= 100){
                                        return 'Stretched';
                                    }
                                }
                                if (row.hasOwnProperty('%OHS')){
                                    if (tableRender=='table_IssuesExecuted'){
                                        if (parseFloat(row['%OHS'])<=20){
                                             return 'Stretched';
                                        }else if (parseFloat(row['%OHS'])>20){
                                            return 'Off Track';
                                        }
                                    }else{
                                        if (parseFloat(row['%OHS'])>=80){
                                             return 'Stretched';
                                        }else if (parseFloat(row['%OHS']) <80){
                                            return 'Off Track';
                                        }
                                    }
                                }  
                                if (row.hasOwnProperty('%QAS')){
                                    if (tableRender=='table_QasExecutedNotExecuted'){
                                        if (parseFloat(row['%QAS'])<=20){
                                             return 'Stretched';
                                        }else if (parseFloat(row['%QAS'])>20){
                                            return 'Off Track';
                                        }
                                    }else{
                                        if (parseFloat(row['%QAS']) <70){
                                            return 'Off Track';
                                        }else if (parseFloat(row['%QAS']) >=70 && parseFloat(row['%QAS']) <80){
                                            return 'Robust" width="';
                                        }else if (parseFloat(row['%QAS']) >=80 && parseFloat(row['%QAS']) < 90){
                                            return 'Commitment';
                                        }else if (parseFloat(row['%QAS']) >=90 && parseFloat(row['%QAS']) <= 100){
                                            return 'Stretched';
                                        } 
                                    }
                                }  
                                if (row.hasOwnProperty('%FTR')){
                                    if (parseFloat(row['%FTR']) <70){
                                        return 'Off Track';
                                    }else if (parseFloat(row['%FTR']) >=70 && parseFloat(row['%FTR']) <80){
                                        return 'Robust';
                                    }else if (parseFloat(row['%FTR']) >=80 && parseFloat(row['%FTR']) < 90){
                                        return 'Commitment';
                                    }else if (parseFloat(row['%FTR']) >=90 && parseFloat(row['%FTR']) <= 100){
                                        return 'Stretched';
                                    } 
                                }  
                                if (row.hasOwnProperty('%QP')){     
                                    if (parseFloat(row['%QP']) <70){
                                        return 'Off Track';
                                    }else if (parseFloat(row['%QP']) >=70 && parseFloat(row['%QP']) <80){
                                        return 'Robust';
                                    }else if (parseFloat(row['%QP']) >=80 && parseFloat(row['%QP']) < 90){
                                        return 'Commitment';
                                    }else if (parseFloat(row['%QP']) >=90 && parseFloat(row['%QP']) <= 100){
                                        return 'Stretched';
                                    } 
                                }
                                if (row.hasOwnProperty('%FTR ASP')){
                                    if (parseFloat(row['%FTR ASP']) <70){
                                        return 'Off Track';
                                    }else if (parseFloat(row['%FTR ASP']) >=70 && parseFloat(row['%FTR ASP']) <80){
                                        return 'Robust';
                                    }else if (parseFloat(row['%FTR ASP']) >=80 && parseFloat(row['%FTR ASP']) < 90){
                                        return 'Commitment';
                                    }else if (parseFloat(row['%FTR ASP']) >=90 && parseFloat(row['%FTR ASP']) <= 100){
                                        return 'Stretched';
                                    } 
                                }
                            }
                        }
                    });
                }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)
        {
            //console.log(render, columnas, data,suffix_export,orderArray);
            var a=[];b=[];
            var Defs = [];
            var ini = (columnas.length) -5;
            var kpi = '';
            if (render=='table_IssuesExecuted'){
                kpi = 'Issues Executed';
            }else if(render=='table_ExecutedNotExecuted'){
                kpi = 'OHS';
            }else if(render=='table_OHS'){
                kpi = 'OHS';
            }else if(render=='table_01'){
                kpi = 'OTD';
            }
            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);
                }
            }
            $("#mostrar_excel_ftr_issues").hide();
            $("#mostrar_excel_asp_ftr_issues").hide();
            $("#mostrar_excel_ftr_total_sites_issues").hide();
            $("#mostrar_excel_rango_total_sites_issues").hide();
            $("#mostrar_excel_issues").hide();
            //console.log(render,suffix_export);
            if (suffix_export=='OHS_Total Sites'){
                 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": true,
                    "processing": true,
                    "language": {
                        // Replace the Processing... text with an AJAX-loader
                        "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                    },
                    "order": [[ 11, "asc" ]],
                    columns: columnas,
                    columnDefs: Defs,
                    lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                    buttons: [
                        {
                            extend:'excel',
                            text: 'Table Excel ' + kpi.replace("_"," "),
                            exportOptions: {
                                columns: b,
                                orthogonal: 'export'
                            },
                            title: 'Mela_Aspir_UKI_' + kpi
                        }
                    ],
                    drawCallback: function() {
                        $('[data-toggle="popover"]').popover();
                    } 
                } );
                $("#mostrar_excel_ftr_issues").hide();
                $("#mostrar_excel_asp_ftr_issues").hide();
                $("#mostrar_excel_ftr_total_sites_issues").hide();
                $("#mostrar_excel_rango_total_sites_issues").hide();
                $("#mostrar_excel_issues").hide();
            }else if (suffix_export=='FIRST_TIMERIGHT'){
                 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": true,
                    "processing": true,
                    "language": {
                        // Replace the Processing... text with an AJAX-loader
                        "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                    },
                    "order": [[ 0, "asc" ]],
                    columns: columnas,
                    columnDefs: Defs,
                    lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                    buttons: [],
                    drawCallback: function() {
                        $('[data-toggle="popover"]').popover();
                    }   
                } );
                $("#mostrar_excel_ftr_issues").show();
                $("#mostrar_excel_asp_ftr_issues").hide();
                $("#mostrar_excel_ftr_total_sites_issues").hide();
                $("#mostrar_excel_rango_total_sites_issues").hide();
                $("#mostrar_excel_issues").hide();
            }else if (suffix_export=='FTR_TotalServices'){
                 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": true,
                    "processing": true,
                    "language": {
                        // Replace the Processing... text with an AJAX-loader
                        "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                    },
                    "order": [[ 0, "asc" ]],
                    columns: columnas,
                    columnDefs: Defs,
                    lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                    buttons: [],
                    drawCallback: function() {
                        $('[data-toggle="popover"]').popover();
                    }   
                } );
                $("#mostrar_excel_ftr_issues").hide();
                $("#mostrar_excel_asp_ftr_issues").hide();
                $("#mostrar_excel_ftr_total_sites_issues").show();
                $("#mostrar_excel_rango_total_sites_issues").hide();
                $("#mostrar_excel_issues").hide();
            }else if (suffix_export=='FTR_TotalSites'){
                 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": true,
                    "processing": true,
                    "language": {
                        // Replace the Processing... text with an AJAX-loader
                        "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                    },
                    "order": [[ 0, "asc" ]],
                    columns: columnas,
                    columnDefs: Defs,
                    lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                    buttons: [],
                    drawCallback: function() {
                        $('[data-toggle="popover"]').popover();
                    }   
                } );
                $("#mostrar_excel_ftr_issues").hide();
                $("#mostrar_excel_asp_ftr_issues").hide();
                $("#mostrar_excel_ftr_total_sites_issues").hide();
                $("#mostrar_excel_rango_total_sites_issues").show();
                $("#mostrar_excel_issues").hide();
            }else if (suffix_export=="FTR_ASP"){
                 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": true,
                    "processing": true,
                    "language": {
                        // Replace the Processing... text with an AJAX-loader
                        "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                    },
                    "order": [[ 0, "asc" ]],
                    columns: columnas,
                    columnDefs: Defs,
                    lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                    buttons: [],
                    drawCallback: function() {
                        $('[data-toggle="popover"]').popover();
                    }   
                } );
                $("#mostrar_excel_ftr_issues").hide();
                $("#mostrar_excel_asp_ftr_issues").show();
                $("#mostrar_excel_ftr_total_sites_issues").hide();
                $("#mostrar_excel_rango_total_sites_issues").hide();
                $("#mostrar_excel_issues").hide();
            }else if (suffix_export=="Defects_Found– Categories"){
                 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": true,
                    "processing": true,
                    "language": {
                        // Replace the Processing... text with an AJAX-loader
                        "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                    },
                    "order": [[ 0, "asc" ]],
                    columns: columnas,
                    columnDefs: Defs,
                    lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                    buttons: [],
                    drawCallback: function() {
                        $('[data-toggle="popover"]').popover();
                    }   
                } );
                $("#mostrar_excel_ftr_issues").hide();
                $("#mostrar_excel_asp_ftr_issues").hide();
                $("#mostrar_excel_ftr_total_sites_issues").hide();
                $("#mostrar_excel_rango_total_sites_issues").hide();
                $("#mostrar_excel_issues").show();
            }else{
                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" ]],
                    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: 'Mela_Uki_Aspir_' + kpi
                        }
                    ],
                    drawCallback: function() {
                        $('[data-toggle="popover"]').popover();
                    } 
                } );
                $("#mostrar_excel_ftr_issues").hide();
                $("#mostrar_excel_asp_ftr_issues").hide();
                $("#mostrar_excel_ftr_total_sites_issues").hide();
                $("#mostrar_excel_rango_total_sites_issues").hide();
                $("#mostrar_excel_issues").hide();
            }
        }     
        //create chart column con linea porcentaje
        function createChartColumn(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, inicio, fin, pais, orderArray, path, rawData,custumerCalls=null)
        {
            //ajustar la serie para la doble axies
            var arrayReturn = new Array();
            var data = new Array();
            if (render=='grafico_IssuesExecuted'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(v.name=="%OHS"){ //porcentaje
                               data.push({"name":"%OHS","data":v.data,yAxis: 0});
                            }else{            
                                data.push({"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }                        
                            
                        });
                    });
                }  
            }
            if (render=='grafico_ExecutedNotExecuted'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(k==0){ //Executed
                               data.push({"color":'#0B4019',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==1){ //Not Executed
                              data.push({"color":'#e55550',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else{
                                data.push({"name":"%OHS Executed","data":v.data,yAxis: 0});
                            }                      
                            
                        });
                    });
                }      
            }   
            if (render=='grafico_QasExecutedNotExecuted'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(k==0){ //Executed
                               data.push({"color":'#0B4019',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==1){ //Not Executed
                              data.push({"color":'#e55550',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else{
                                data.push({"name":"%QAS Executed","data":v.data,yAxis: 0});
                            }                      
                            
                        });
                    });
                }      
            }   
            if (render=='grafico_ExecutedNotExecutedRazones') {
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) { 
                            data.push({"name":v.name,"data":v.data,yAxis: 1,type: 'column'});
                        });
                    });
                }  
            }      
            if (render=='grafico_QualityPerformance'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(k==0){ //Accepted
                               data.push({"color":'#0B4019',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==1){ //Not Accepted
                              data.push({"color":'#e55550',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==2){ //Total sites
                                data.push({"color":'#4fa165',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});
                            }else{
                                data.push({"name":"%QP","data":v.data,yAxis: 0});
                            }
                            
                        });
                    });
                }
            }            
            if (render=='grafico_OHS'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(k==0){ //Accepted
                               data.push({"color":'#0B4019',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==1){ //Not Accepted
                              data.push({"color":'#e55550',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==2){ //Total sites
                                data.push({"color":'#4fa165',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});
                            }else{
                                data.push({"name":"%OHS","data":v.data,yAxis: 0});
                            }
                            
                        });
                    });
                }
            }
            if (render=='grafico_ExecutiveAuditSummary_PassedAndFailed'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(k==0){ //Accepted
                               data.push({"color":'#0B4019',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==1){ //Not Accepted
                              data.push({"color":'#e55550',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==2){ //Total sites
                                data.push({"color":'#4fa165',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});
                            }else{
                                data.push({"name":"%OHS","data":v.data,yAxis: 0});
                            }
                            
                        });
                    });
                }
            }
            if (render=='grafico_ExecutiveAuditSummary_Calls0' || render=='grafico_ExecutiveAuditSummary_Calls1' || render=='grafico_ExecutiveAuditSummary_Calls2'  || render=='grafico_ExecutiveAuditSummary_Calls3'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(k==0){ //Accepted
                               data.push({"color":'#2F83EF',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==1){ //Not Accepted
                              data.push({"color":'#3AEE55',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==2){ //Total sites
                                data.push({"color":'#E5CA1F',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});
                            }else{
                                data.push({"name":"%Score","data":v.data,yAxis: 0});
                            }
                            
                        });
                    });
                }
            }
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            switch (render){
                case 'grafico_IssuesExecuted':
                    table_dt = 'table_IssuesExecuted';
                    dt = 'datatable_IssuesExecuted';
                    posProy = 2;
                    kpi = "IssuesExecuted_DETAIL";
                    break;
                case 'grafico_ExecutedNotExecuted':
                    table_dt = 'table_ExecutedNotExecuted';
                    dt = 'datatable_ExecutedNotExecuted';
                    posProy = 2;
                    kpi = "ExecutedNotExecute_DETAIL";
                    break;
                case 'grafico_ExecutedNotExecutedRazones':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "ExecutedNotExecuteRazones_DETAIL";
                    break;  
                case 'grafico_QualityPerformance':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "QualityPerformance_DETAIL";
                    break; 
                case 'grafico_OHS':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "OHS_DETAIL";
                    break;       
                case 'graficoOnTimeDelivery':
                    table_dt = '';
                    dt = '';
                    kpi = "OTD";
                    break;  
                case 'grafico_ExecutiveAuditSummary_Calls0':
                    table_dt = '';
                    dt = '';
                    posProy = 3;
                    kpi = "ExecutiveAuditSummary_Calls_DETAIL";
                    break; 
                case 'grafico_ExecutiveAuditSummary_Calls1':
                    table_dt = '';
                    dt = '';
                    posProy = 3;
                    kpi = "ExecutiveAuditSummary_Calls_DETAIL";
                    break;     
                case 'grafico_ExecutiveAuditSummary_Calls2':
                    table_dt = '';
                    dt = '';
                    posProy = 3;
                    kpi = "ExecutiveAuditSummary_Calls_DETAIL";
                    break;  
                case 'grafico_ExecutiveAuditSummary_Calls3':
                    table_dt = '';
                    dt = '';
                    posProy = 3;
                    kpi = "ExecutiveAuditSummary_Calls_DETAIL";
                    break;  
                case 'grafico_ExecutiveAuditSummary_PassedAndFailed':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "ExecutiveAuditSummary_PassedAndFailed_DETAIL";
                    break;    
                case 'grafico_QasExecutedNotExecuted':
                    table_dt = 'table_QasExecutedNotExecuted';
                    dt = 'datatable_QasExecutedNotExecuted';
                    posProy = 2;
                    kpi = "QasExecutedNotExecute_DETAIL";
                    break;                           
            }
            var options = {
                chart: {
                    zoomType: 'xy',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: ''
                  },
                  enableMouseTracking : false,
                  xAxis: {
                        categories: [],
                        lineWidth: 1,
                        lineColor: '#4c4c4c',
                        //tickColor: '#4c4c4c',
                        //tickWidth: 1,
                        //minorTickWidth: 1,
                        labels: {
                            groupedOptions: [{ // 1st-level
                                //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                rotation: 0,
                                lineWidth: 1,
                                tickWidth: 1,
                                style: {
                                    fontSize: '10px',
                                    color: '#333333'
                                    //color: '#4c4c4c'
                                }
                            }, // 2nd-level
                                {
                                    //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                    rotation: 0,
                                    lineWidth: 0,
                                    tickWidth: 0,
                                    //align: 'right',
                                    style: {
                                        fontSize: '9px',
                                        color: '#333333'
                                        //color: '#4c4c4c'
                                    }
                                }
                            ],
                            //step: step,
                            lineWidth: 0,
                            tickWidth: 0,
                            rotation: 0,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            },
                            formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                                if(this.value.length > 20){
                                    return this.value.substring(0, 17) + '...';
                                }
                                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: 1000
                        },
                        chartOptions: {
                            legend: {
                                align: 'center',
                                verticalAlign: 'bottom',
                                layout: 'horizontal'
                            },
                            yAxis: {
                                labels: {
                                    align: 'left',
                                    x: 0,
                                    y: -5
                                },
                                title: {
                                    text: null
                                }
                            },
                            subtitle: {
                                text: null
                            },
                            credits: {
                                enabled: false
                            }
                        }
                    }]
                },
                 legend: {
                        backgroundColor: 'rgba(66, 139, 202, 0.5)'
                    },
                  yAxis: [{ // Primary yAxis
                    plotLines: [
                        {
                            value: 0,
                            width: 1,
                            color: '#808080'
                        }
                    ],
                    title: {
                      text: 'Percent (%)',
                      style: {
                        color: Highcharts.getOptions().colors[1]
                      }
                    },
                    min: 0,
                    max: 100,
                    labels: {
                        format: "{value}%"
                    }, 
                  }, { // Secondary yAxis
                    title: {
                      text: 'Count',
                      style: {
                        color: Highcharts.getOptions().colors[0]
                      }
                    },
                    min:0,
                    opposite: true
                  }],
                  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: '#f7e81d', //Verde Grama
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'left',
                        align: 'left',
                        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: 'left',
                        align: 'left',
                        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: '#2e8201', //Amarillo
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'left',
                        align: 'left',
                        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=='%Score' || this.series.name=='%OHS' || this.series.name=='%QP' || this.series.name=='%QAS Executed' || this.series.name=='%OHS Executed'){
                                    return this.point.y + '%';
                                }else{
                                    return this.point.y;
                                }
                            }
                        },
                        point:
                        {
                            events:
                            {
                                
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];
                                        var cliente = row.hasOwnProperty('_cat_Customer') ? row['_cat_Customer'] : $('#cliente').val();
                                        //para los graficos de calls el cliente es el que se envia por parametros a la funcion
                                        if (render=='grafico_ExecutiveAuditSummary_Calls0' || render=='grafico_ExecutiveAuditSummary_Calls1' || render=='grafico_ExecutiveAuditSummary_Calls2' || render=='grafico_ExecutiveAuditSummary_Calls3'){
                                            cliente = custumerCalls;
                                            if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                                                var pais = 'MX';    
                                            }            
                                            else{
                                                var pais = 'United Kingdom';
                                            } 
                                        }else{
                                            if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                                                var pais = 'MX';  
                                            }            
                                            else{
                                                var pais = 'United Kingdom';
                                            }
                                        }    
                                        if($('#asp_user').val()!=''){
                                            var asp = $('#asp_user').val();
                                        }else{
                                           var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                        }                                     
                                        var params = {
                                            'postfix': 'uki',
                                            'kpi': kpi,
                                            'FechaInicio': $('#Filtros_fechaIni').val(),
                                            'FechaFin': $('#Filtros_fechaFin').val(),                                            
                                            'pais': pais,
                                            'FechaInicio': inicio,
                                            'FechaFin': fin,
                                            'selected_item': categoria[this.x],
                                            'selected_serie': this.series.name,
                                            'cliente': cliente,
                                            'proyecto': row.hasOwnProperty('_cat_Project') ? row['_cat_Project'] : $('#proyecto').val(),
                                            'asp': asp,
                                            'mes': row['_cat_Month']
                                        };
                                        var subtitle = row.hasOwnProperty('_cat_Month') ? row['_cat_Month'] : "";
                                        var prefix = (title == null || title == '') ? params.selected_serie : title + ' - ' + params.selected_serie;
                                        if (this.series.name!='%Accepted'){
                                            generateModal(path, params, false, prefix, subtitle, orderArray);
                                        }
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }

            var num = categoria.length;

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


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

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

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

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

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[4]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[4]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            if (menor >50) menor= 50;
            options.yAxis[0].min=menor;
            return $('#' + render).highcharts(options);
        }
        //create chart column
        function createChartColumn1(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, inicio, fin, pais, orderArray, path, rawData)
        {
            //ajustar la serie para la doble axies
            var arrayReturn = new Array();
            var data = new Array();        
            if (series.length>0){
                $.each(series, function(key, value) {
                    $.each(value, function(k, v) { 
                        data.push({"name":v.name,"data":v.data,type: 'column'});
                    });
                });
            }                   
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            switch (render){
                
                case 'grafico_ExecutedNotExecutedRazones':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "ExecutedNotExecuteRazones_DETAIL";
                    break;  
                case 'grafico_ExecutiveAuditSummary_Calls0':
                    table_dt = '';
                    dt = '';
                    posProy = 3;
                    kpi = "ExecutiveAuditSummary_Calls_DETAIL";
                    break;
                case 'grafico_ExecutiveAuditSummary_Calls1':
                    table_dt = '';
                    dt = '';
                    posProy = 3;
                    kpi = "ExecutiveAuditSummary_Calls_DETAIL";
                    break;
                case 'grafico_ExecutiveAuditSummary_Calls2':
                    table_dt = '';
                    dt = '';
                    posProy = 3;
                    kpi = "ExecutiveAuditSummary_Calls_DETAIL";
                    break; 
                case 'grafico_ExecutiveAuditSummary_Calls3':
                    table_dt = '';
                    dt = '';
                    posProy = 3;
                    kpi = "ExecutiveAuditSummary_Calls_DETAIL";
                    break; 
                case 'grafico_ExecutiveAuditSummary_SitesNonConformance':
                    table_dt = '';
                    dt = '';
                    posProy = 3;
                    kpi = "ExecutiveAuditSummary_Sites_DETAIL";
                    break;                   
            }
             var options = {
                chart: {
                    zoomType: 'xy',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: ''
                  },
                  enableMouseTracking : false,
                  xAxis: {
                        categories: [],
                        lineWidth: 1,
                        lineColor: '#4c4c4c',
                        //tickColor: '#4c4c4c',
                        //tickWidth: 1,
                        //minorTickWidth: 1,
                        labels: {
                            groupedOptions: [{ // 1st-level
                                //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                rotation: 0,
                                lineWidth: 1,
                                tickWidth: 1,
                                style: {
                                    fontSize: '10px',
                                    color: '#333333'
                                    //color: '#4c4c4c'
                                }
                            }, // 2nd-level
                                {
                                    //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                    rotation: 0,
                                    lineWidth: 0,
                                    tickWidth: 0,
                                    //align: 'right',
                                    style: {
                                        fontSize: '9px',
                                        color: '#333333'
                                        //color: '#4c4c4c'
                                    }
                                }
                            ],
                            //step: step,
                            lineWidth: 0,
                            tickWidth: 0,
                            rotation: 0,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            },
                            formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                                if(this.value.length > 20){
                                    return this.value.substring(0, 17) + '...';
                                }
                                return this.value;
                            }
                        },
                        overflow: 'justify',
                        scrollbar: {
                            enabled: false
                        }
                  },
                  plotOptions:{
                    column: {
                        pointPadding: 0.2,
                        borderWidth: 0,
                        depth: 40,
                        dataLabels: {
                            enabled: true,
                            crop: false,
                            overflow: 'none'
                        }
                    },
                    series:{
                        shadow:true,
                        dataLabels: {
                            enabled: true,
                            style: {
                                fontWeight: 'bold'
                            }
                        }
                    }
                },
                responsive: {
                    rules: [{
                        condition: {
                            maxWidth: 500
                        },
                        chartOptions: {
                            legend: {
                                align: 'center',
                                verticalAlign: 'bottom',
                                layout: 'horizontal'
                            },
                            yAxis: {
                                labels: {
                                    align: 'left',
                                    x: 0,
                                    y: -5
                                },
                                title: {
                                    text: null
                                }
                            },
                            subtitle: {
                                text: null
                            },
                            credits: {
                                enabled: false
                            }
                        }
                    }]
                },
                 legend: {
                        backgroundColor: 'rgba(66, 139, 202, 0.5)'
                    },
                  yAxis: [{ // Primary yAxis
                    plotLines: [
                        {
                            value: 0,
                            width: 1,
                            color: '#808080'
                        }
                    ],
                    title: {
                      text: 'Count',
                      style: {
                        color: Highcharts.getOptions().colors[1]
                      }
                    }
                  }],
                  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: '#f7e81d', //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: '#2e8201', //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
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];
                                        if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                                            var cliente = $('#cliente').val();//var cliente = 'AT&T';  
                                            var pais = 'MX';    
                                        }            
                                        else{
                                            var cliente = $('#cliente').val();
                                            var pais = 'United Kingdom';
                                        } 
                                        if($('#asp_user').val()!=''){
                                            var asp = $('#asp_user').val();
                                        }else{
                                           var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                        } 
                                        var params = {
                                            'postfix': 'uki',
                                            'kpi': kpi,
                                            'FechaInicio': $('#Filtros_fechaIni').val(),
                                            'FechaFin': $('#Filtros_fechaFin').val(),                                            
                                            'pais': pais,
                                            'FechaInicio': inicio,
                                            'FechaFin': fin,
                                            'selected_item': categoria[this.x],
                                            'selected_serie': this.series.name,
                                            'cliente': row.hasOwnProperty('_cat_Customer') ? row['_cat_Customer'] : cliente,
                                            'proyecto': row.hasOwnProperty('_cat_Project') ? row['_cat_Project'] : $('#proyecto').val(),
                                            'asp': asp,
                                            'mes': row['_cat_Month'],
                                            'status_final': row._cat_FinalStatus?row['_cat_FinalStatus']:'',
                                        };
                                        var subtitle = row.hasOwnProperty('_cat_Month') ? row['_cat_Month'] : "";
                                        var prefix = (title == null || title == '') ? params.selected_serie : title + ' - ' + params.selected_serie;
                                        if (this.series.name!='%Accepted'){
                                            generateModal(path, params, false, prefix, subtitle, orderArray);
                                        }
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }

            var num = categoria.length;

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


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

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

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

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

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[4]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[4]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            if (render!='grafico_ExecutiveAuditSummary_Calls0' || render!='grafico_ExecutiveAuditSummary_Calls1' || render!='grafico_ExecutiveAuditSummary_Calls2' || render!='grafico_ExecutiveAuditSummary_Calls3'){
                if (menor >50) menor= 50;
                options.yAxis[0].min=menor;
            }            
            return $('#' + render).highcharts(options);
        }
        
        //llamado para generar las graficas y las tablas  
        function getChart(){
           
            var inicio = $('#Filtros_fechaIni').val();
            var fin = $('#Filtros_fechaFin').val();
            var pais = $('#pais').val();
            if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                var cliente = $('#cliente').val();//var cliente = 'AT&T';  
                var pais = 'MX';    
            }            
            else{
                var cliente = $('#cliente').val();
                var pais = 'United Kingdom';
            } 
            var proyecto = $('#proyecto').val(); 
            if($('#asp_user').val()!=''){
                var asp = $('#asp_user').val();
            }else{
               var asp = $('#asp').val();
            } 
            var valor = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();
            var parametro_dia = 0;
            if($("#ultimos_7_dias").hasClass('btn-primary')){
                parametro_dia = 1;
            }
            var subtitle_rango_fecha = "From: "+$('#Filtros_fechaIni').val()+" To: "+$('#Filtros_fechaFin').val();
            var parametros = {
                'postfix' : 'uki',
                'pais': pais,
                'FechaInicio': inicio,
                'FechaFin': fin,
                'pais': pais,
                'cliente': cliente,
                'proyecto': proyecto,
                'asp': asp,
                'date': valor,
                'parametro_dia': parametro_dia
            };
            $.getJSON('{{path('aspir_DashboardAspirUki',{'idproyectos':idproyectos,'idmodule':idmodule})}}', parametros, function (data){
                var chart = data;
                //destroyGraphs();               
                // grafica de On Time Delivery
                if (chart.graficoOnTimeDelivery.categories.length > 0){
                    $('.activarButton').show();
                    $("#graficoOnTimeDelivery").empty();
                    var series = getDataToObjectSerie(chart.graficoOnTimeDelivery.data, Object.keys(chart.graficoOnTimeDelivery.data[0]));
                    createChartLinea2('graficoOnTimeDelivery', chart.graficoOnTimeDelivery.categories, series, '',
                            null, [75, 'Rob=75%'], [80,'Com=80%'], [85,'Str=85%'], inicio, fin, null, null, null, chart.graficoOnTimeDelivery.data);
                }else{
                    if ($("#graficoOnTimeDelivery").highcharts()!=undefined){
                        $("#graficoOnTimeDelivery").highcharts().destroy();
                    }                    
                    $("#graficoOnTimeDelivery").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                // Tabla tablaOnTimeDelivery
                if (chart.tablaOnTimeDelivery.length > 0){
                     $("#datatable_01").empty();
                     var col = createTableDT(Object.keys(chart.tablaOnTimeDelivery[0]),'table_01', 'datatable_01');
                     buildDatatablePrin('table_01',col,chart.tablaOnTimeDelivery);
                 }else{
                    $("#datatable_01").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }          
                //para Issues Exeute
                /*if (chart.grafico_IssuesExecuted.categories.length > 0){
                    $("#grafico_IssuesExecuted").empty();                    
                    var series = getDataToObjectSerieAll(chart.grafico_IssuesExecuted.data, Object.keys(chart.grafico_IssuesExecuted.data[0]));
                    createChartColumn('grafico_IssuesExecuted', chart.grafico_IssuesExecuted.categories, series, 'OHS Issues While Executing',
                            null, [90, 'Rob=90%'], [97,'Com=97%'], [97,'Str=97%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_IssuesExecuted.data);
                }else{
                    if ($("#grafico_IssuesExecuted").highcharts()!=undefined){
                        $("#grafico_IssuesExecuted").highcharts().destroy();
                    }                    
                    $("#grafico_IssuesExecuted").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para la tabla issues executed               
                if (chart.table_IssuesExecuted.length > 0){
                    $("#datatable_IssuesExecuted").empty();
                    var col = createTableDT(Object.keys(chart.table_IssuesExecuted[0]),'table_IssuesExecuted', 'datatable_IssuesExecuted');
                    buildDatatablePrin('table_IssuesExecuted',col,chart.table_IssuesExecuted);
                }else{
                    $("#datatable_IssuesExecuted").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                } */ 
                //para el grafico exceuted not execute
                if (chart.grafico_ExecutedNotExecuted.categories.length > 0){
                    $("#grafico_ExecutedNotExecuted").empty();   
                    $("#mostrar_excel_issues_ohs").show();                 
                    var series = getDataToObjectSerieAll(chart.grafico_ExecutedNotExecuted.data, Object.keys(chart.grafico_ExecutedNotExecuted.data[0]));
                    createChartColumn('grafico_ExecutedNotExecuted', chart.grafico_ExecutedNotExecuted.categories, series, 'OHS Executed Vs Not Executed',
                            null, [90, 'Rob=90%'], [97,'Com=97%'], [97,'Str=97%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_ExecutedNotExecuted.data);
                }else{
                    if ($("#grafico_ExecutedNotExecuted").highcharts()!=undefined){
                        $("#grafico_ExecutedNotExecuted").highcharts().destroy();
                    }     
                    $("#mostrar_excel_issues_ohs").hide();               
                    $("#grafico_ExecutedNotExecuted").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para el grafico de ejecutado razones
                /*if (chart.grafico_ExecutedNotExecutedRazones.categories.length > 0){
                    $("#grafico_ExecutedNotExecutedRazones").empty();                    
                    var series = getDataToObjectSerieAll(chart.grafico_ExecutedNotExecutedRazones.data, Object.keys(chart.grafico_ExecutedNotExecutedRazones.data[0]));
                    createChartColumn1('grafico_ExecutedNotExecutedRazones', chart.grafico_ExecutedNotExecutedRazones.categories, series, 'OHS Not Executed Reasons',
                            null, [90, 'Rob=90%'], [97,'Com=97%'], [97,'Str=97%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_ExecutedNotExecutedRazones.data);
                }else{
                    if ($("#grafico_ExecutedNotExecutedRazones").highcharts()!=undefined){
                        $("#grafico_ExecutedNotExecutedRazones").highcharts().destroy();
                    }                    
                    $("#grafico_ExecutedNotExecutedRazones").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }*/
                //para la tabla executed vs not execute               
                if (chart.table_ExecutedNotExecuted.length > 0){
                    $("#datatable_ExecutedNotExecuted").empty();
                    var col = createTableDT(Object.keys(chart.table_ExecutedNotExecuted[0]),'table_ExecutedNotExecuted', 'datatable_ExecutedNotExecuted');
                    buildDatatablePrin('table_ExecutedNotExecuted',col,chart.table_ExecutedNotExecuted);
                }else{
                    $("#datatable_ExecutedNotExecuted").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para el grafico de ftr
                // First Time Right    
                if (chart.grafico_FTR.data.length > 0){
                    projectList[1] = chart.grafico_FTR.lstProy.split(",");
                    $("#grafico_FTR").empty();
                    series = getDataToObjectSerieAll(chart.grafico_FTR.data,Object.keys(chart.grafico_FTR.data[0]));
                    createChartLinea2HotProject('grafico_FTR', chart.grafico_FTR.categories, series, '',
                            null, [70, 'Rob=70%'], [80,'Com=80%'], [90,'Str=90%'], inicio, fin, null,null, null, chart.grafico_FTR.data);
                }else{
                    if ($("#grafico_FTR").highcharts()!=undefined){
                       $("#grafico_FTR").highcharts().destroy();
                    } 
                    $("#grafico_FTR").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }

                // Tabla FTR
                if (chart.table_FTR.length > 0){
                    $("#datatable_FTR").empty();
                    var col = createTableDT(Object.keys(chart.table_FTR[0]),'table_FTR', 'datatable_FTR');
                    buildDatatablePrin('table_FTR',col,chart.table_FTR);
                }else{
                    $("#datatable_FTR").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }  
                //Ftr Asp Dashboard Grafico 
                if (chart.grafico_ASP.categories.length > 0){
                    projectList[3] = chart.grafico_ASP.lstProy.split(",");
                    $("#grafico_ASP").empty();
                    series = getDataToObjectSerieAll(chart.grafico_ASP.data,Object.keys(chart.grafico_ASP.data[0]));
                    createChartLinea2HotProject('grafico_ASP', chart.grafico_ASP.categories, series, '',
                            null, [70, 'Rob=70%'], [80,'Com=80%'], [90,'Str=90%'], inicio, fin, null,null, null, chart.grafico_ASP.data);
                    /*createChartLinea2('grafico_ASP', chart.grafico_ASP.categories, series, '',
                            null, [90, 'Rob=90%'], [97,'Com=97%'], [97,'Str=97%'], inicio, fin, null,null, null, chart.grafico_ASP.data);*/
                }else{
                    if ($("#grafico_ASP").highcharts()!=undefined){
                       $("#grafico_ASP").highcharts().destroy();
                    }                    
                    $("#grafico_ASP").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //Ftr Asp Dashboard Grafico
                if (chart.table_ASP.length > 0){
                    $("#datatable_ASP").empty();
                    col = createTableDT(Object.keys(chart.table_ASP[0]),'table_ASP', 'datatable_ASP');
                    buildDatatablePrin('table_ASP',col,chart.table_ASP,null,null);
                }else{
                    $("#datatable_ASP").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }

                //garfico system fault
                //ANTES
                /*if (chart.grafico_SystemFaultFound.categories.length > 0){
                    $("#grafico_SystemFaultFound").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}";                    
                    series = getDataToObjectSerieAll(chart.grafico_SystemFaultFound.data,Object.keys(chart.grafico_SystemFaultFound.data[0]));
                    createChartBarra2('grafico_SystemFaultFound', chart.grafico_SystemFaultFound.categories, series, 'Defects Found – Categories',
                            null, parametros, inicio, fin,null,[0,"desc"], url, chart.grafico_SystemFaultFound.data);
                    url = null;
                    $("#tabsSystemFaultFound .exportar_excel").attr('data','DETALLE_DEFECTS');
                    $("#DETALLE_DEFECTS").show();
                }else{
                    if ($("#grafico_SystemFaultFound").highcharts()!=undefined){
                       $("#grafico_SystemFaultFound").highcharts().destroy();
                    }                    
                    $("#grafico_SystemFaultFound").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                    $("#tabsSystemFaultFound .exportar_excel").attr('data','NO');
                    $("#DETALLE_DEFECTS").hide();
                }*/
                //NUEVO 
                if (chart.grafico_SystemFaultFound.categories.length > 0){
                    $("#grafico_SystemFaultFound").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}";
                    graficaAsp('grafico_SystemFaultFound',chart.grafico_SystemFaultFound,url,parametros,'Defects Found – Categories');
                }else{
                    if ($("#grafico_SystemFaultFound").highcharts()!=undefined){
                        $("#grafico_SystemFaultFound").highcharts().destroy();
                    } 
                    $("#grafico_SystemFaultFound").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //tabla SystemFaultFound
                if (chart.table_SystemFaultFound.length > 0){  
                    $("#total_sitios").empty();
                    $("#total_sitios").html(chart.table_SystemFaultFound[0]['Count']);
                }else{
                    $("#total_sitios").empty();
                }
                //grafico issues found
                if (chart.grafico_IssuesFound.categories.length > 0){
                    $("#grafico_IssuesFound").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}";
                    series = getDataToObjectSerieAll(chart.grafico_IssuesFound.data,Object.keys(chart.grafico_IssuesFound.data[0]));
                    createChartBarra2('grafico_IssuesFound', chart.grafico_IssuesFound.categories, series, 'Issues Found',
                            null, parametros, inicio, fin, null, [0,"desc"], url, chart.grafico_IssuesFound.data);
                    url = null;
                    $("#tabsSystemFaultFound .exportar_excel").attr('data','DETALLE_ISSUES');
                    $("#DETALLE_ISSUES").show();
                }else{
                    if ($("#grafico_IssuesFound").highcharts()!=undefined){
                       $("#grafico_IssuesFound").highcharts().destroy();
                    }                    
                    $("#grafico_IssuesFound").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                    $("#tabsSystemFaultFound .exportar_excel").attr('data','NO');
                    $("#DETALLE_ISSUES").hide();
                }
                //para la grafica de QP
                if (chart.grafico_QualityPerformance.categories.length > 0){
                    $("#grafico_QualityPerformance").empty();                    
                    var series = getDataToObjectSerieAll(chart.grafico_QualityPerformance.data, Object.keys(chart.grafico_QualityPerformance.data[0]));
                    createChartColumn('grafico_QualityPerformance', chart.grafico_QualityPerformance.categories, series, 'Quality Performance',
                            null, [70, 'Rob=70%'], [80,'Com=80%'], [90,'Str=90%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_QualityPerformance.data);
                }else{
                    if ($("#grafico_QualityPerformance").highcharts()!=undefined){
                       $("#grafico_QualityPerformance").highcharts().destroy();
                    } 
                    $("#grafico_QualityPerformance").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para la tabla de QP
                if (chart.table_QualityPerformance.length > 0){
                    $("#datatable_QualityPerformance").empty();
                    var col = createTableDT(Object.keys(chart.table_QualityPerformance[0]),'table_QualityPerformance', 'datatable_QualityPerformance');
                    buildDatatablePrin('table_QualityPerformance',col,chart.table_QualityPerformance);
                }else{
                    $("#datatable_QualityPerformance").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }

                //range
                //grafica
                if (chart.grafico_Range.data.length > 0){
                    projectList[2] = chart.grafico_Range.lstProy.split(",");
                    $("#grafico_Range").empty();
                    series = getDataToObjectSerieAll(chart.grafico_Range.data,Object.keys(chart.grafico_Range.data[0]));
                    createChartLinea2HotProject('grafico_Range', chart.grafico_Range.categories, series, '',
                            null, [70, 'Rob=70%'], [80,'Com=80%'], [90,'Str=90%'], inicio, fin, null,null, null, chart.grafico_Range.data);
                }else{
                    if ($("#grafico_Range").highcharts()!=undefined){
                       $("#grafico_Range").highcharts().destroy();
                    } 
                    $("#grafico_Range").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }

                if (chart.table_Range.length > 0){
                    $("#datatable_Range").empty();
                    datos = calculateTREND(chart.table_Range, chart.table_RangeAnterior, asp);
                    col = createTableDT(Object.keys(chart.table_Range[0]),'table_Range', 'datatable_Range');
                    buildDatatablePrin('table_Range',col,datos,null,null);
                }else{
                    $("#datatable_Range").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para OHS
                // OHS
                if (chart.grafico_OHS.categories.length > 0){
                    $("#grafico_OHS").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_OHS.data, Object.keys(chart.grafico_OHS.data[0]));
                    createChartColumn('grafico_OHS', chart.grafico_OHS.categories, series, 'OHS',
                            null, null, null, [80,'Str=80%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_OHS.data);
                }else{
                    if ($("#grafico_OHS").highcharts()!=undefined){
                      $("#grafico_OHS").highcharts().destroy();
                    } 
                    $("#grafico_OHS").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }

                if (chart.table_OHS.length > 0){
                    $("#datatable_OHS").empty();
                    var col = createTableDT(Object.keys(chart.table_OHS[0]),'table_OHS', 'datatable_OHS');
                    buildDatatablePrin('table_OHS',col,chart.table_OHS);
                }else{
                    $("#datatable_OHS").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para el grafico de excutive audit summary calls
                //ORIGINAL CALLS
                /*if (chart.grafico_ExecutiveAuditSummary_Calls.categories.length > 0){
                    projectList[3] = chart.grafico_ExecutiveAuditSummary_Calls.lstProy.split(",");
                    $("#grafico_ExecutiveAuditSummary_Calls").empty();                    
                    var series = getDataToObjectSerieAll(chart.grafico_ExecutiveAuditSummary_Calls.data, Object.keys(chart.grafico_ExecutiveAuditSummary_Calls.data[0]));
                    createChartColumn1('grafico_ExecutiveAuditSummary_Calls', chart.grafico_ExecutiveAuditSummary_Calls.categories, series, 'Number of RSA Calls Audit Taken Place per ASP',
                            null, null, null, [80,'Str=80%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_ExecutiveAuditSummary_Calls.data);
                }else{
                    if ($("#grafico_ExecutiveAuditSummary_Calls").highcharts()!=undefined){
                        $("#grafico_ExecutiveAuditSummary_Calls").highcharts().destroy();
                    }                    
                    $("#grafico_ExecutiveAuditSummary_Calls").empty().append('<div class="alert-black alert-warning" role="alert">DATA NOT FOUND  <center><b>NUMBER OF RSA CALLS AUDIT TAKEN PLACE PER ASP</b><center></div>');
                }*/                
                //NUEVA CALLS
                if (chart.grafico_ExecutiveAuditSummary_Calls.length > 0){
                    //la cero
                    if ($("#grafico_ExecutiveAuditSummary_Calls0").highcharts()!=undefined){
                      $("#grafico_ExecutiveAuditSummary_Calls0").highcharts().destroy();
                    } 
                    $("#grafico_ExecutiveAuditSummary_Calls0").empty().append('<div class="alert-black alert-warning" role="alert">DATA NOT FOUND  <center><b>NUMBER OF RSA CALLS AUDIT TAKEN PLACE PER ASP</b><center></span></div>');
                    //la uno
                    if ($("#grafico_ExecutiveAuditSummary_Calls1").highcharts()!=undefined){
                      $("#grafico_ExecutiveAuditSummary_Calls1").highcharts().destroy();
                    } 
                    $("#grafico_ExecutiveAuditSummary_Calls1").empty();
                    //la dos
                    if ($("#grafico_ExecutiveAuditSummary_Calls2").highcharts()!=undefined){
                      $("#grafico_ExecutiveAuditSummary_Calls2").highcharts().destroy();
                    } 
                    $("#grafico_ExecutiveAuditSummary_Calls2").empty();
                    //la tres
                    if ($("#grafico_ExecutiveAuditSummary_Calls3").highcharts()!=undefined){
                      $("#grafico_ExecutiveAuditSummary_Calls3").highcharts().destroy();
                    } 
                    $("#grafico_ExecutiveAuditSummary_Calls3").empty();
                    $.each(chart.grafico_ExecutiveAuditSummary_Calls, function (index, value) {
                        //console.log(index,value);
                        if (value.grafica.data.length>0){
                            $("#grafico_ExecutiveAuditSummary_Calls"+index).empty();
                            var series = getDataToObjectSerieAll(value.grafica.data, Object.keys(value.grafica.data[0]));
                            createChartColumn('grafico_ExecutiveAuditSummary_Calls'+index, value.grafica.categories, series, value.cliente.customer+' - Number of RSA Calls Audit Taken Place per ASP',
                                    null, null, null, [80,'Str=80%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", value.grafica.data,value.cliente.customer);
                        }else{
                            if ($("#grafico_ExecutiveAuditSummary_Calls"+index).highcharts()!=undefined){
                              $("#grafico_ExecutiveAuditSummary_Calls"+index).highcharts().destroy();
                            } 
                            $("#grafico_ExecutiveAuditSummary_Calls"+index).empty().append('<div class="alert-black alert-warning" role="alert">DATA NOT FOUND  <center><b>NUMBER OF RSA CALLS AUDIT TAKEN PLACE PER ASP</b><center></span></div>');
                        }
                    });
                }else{
                    //la cero
                    if ($("#grafico_ExecutiveAuditSummary_Calls0").highcharts()!=undefined){
                      $("#grafico_ExecutiveAuditSummary_Calls0").highcharts().destroy();
                    } 
                    $("#grafico_ExecutiveAuditSummary_Calls0").empty().append('<div class="alert-black alert-warning" role="alert">DATA NOT FOUND  <center><b>NUMBER OF RSA CALLS AUDIT TAKEN PLACE PER ASP</b><center></span></div>');
                    //la uno
                    if ($("#grafico_ExecutiveAuditSummary_Calls1").highcharts()!=undefined){
                      $("#grafico_ExecutiveAuditSummary_Calls1").highcharts().destroy();
                    } 
                    $("#grafico_ExecutiveAuditSummary_Calls1").empty();
                    //la dos
                    if ($("#grafico_ExecutiveAuditSummary_Calls2").highcharts()!=undefined){
                      $("#grafico_ExecutiveAuditSummary_Calls2").highcharts().destroy();
                    } 
                    $("#grafico_ExecutiveAuditSummary_Calls2").empty();
                    //la tres
                    if ($("#grafico_ExecutiveAuditSummary_Calls3").highcharts()!=undefined){
                      $("#grafico_ExecutiveAuditSummary_Calls3").highcharts().destroy();
                    } 
                    $("#grafico_ExecutiveAuditSummary_Calls3").empty();
                }
                if (chart.table_ExecutiveAuditSummary_Calls.length > 0){
                    $("#datatable_ExecutiveAuditSummary_Calls0").empty();
                    $("#datatable_ExecutiveAuditSummary_Calls1").empty();
                    $("#datatable_ExecutiveAuditSummary_Calls2").empty();
                    $("#datatable_ExecutiveAuditSummary_Calls3").empty();
                    $.each(chart.table_ExecutiveAuditSummary_Calls, function (index, value) {
                        if (value.data.length>0){
                            $("#datatable_ExecutiveAuditSummary_Calls"+index).empty();
                            var col = createTableDT(Object.keys(value[0]),'table_ExecutiveAuditSummary_Calls'+index, 'datatable_ExecutiveAuditSummary_Calls'+index);
                            buildDatatablePrin('table_ExecutiveAuditSummary_Calls'+index,col,value);
                        }else{
                            $("#datatable_ExecutiveAuditSummary_Calls"+index).empty().append('<br><div class="alert-black alert-warning" role="alert"> DATA NOT FOUND  <center><b>'+value.cliente.customer+' - ISSUES OR FAILS</b></center></div>');
                        }
                    });
                }else{
                    //la cero
                    $("#datatable_ExecutiveAuditSummary_Calls0").empty().append('<br><div class="alert-black alert-warning" role="alert">DATA NOT FOUND  <center><b>ISSUES OR FAILS</b></center></div>');
                    //la uno
                    $("#datatable_ExecutiveAuditSummary_Calls1").empty();
                    //la dos
                    $("#datatable_ExecutiveAuditSummary_Calls2").empty();
                    //la tres
                    $("#datatable_ExecutiveAuditSummary_Calls3").empty();
                } 
                /*ORIGINAL
                if (chart.table_ExecutiveAuditSummary_Calls.length > 0){
                    $("#datatable_ExecutiveAuditSummary_Calls").empty();
                    var col = createTableDT(Object.keys(chart.table_ExecutiveAuditSummary_Calls[0]),'table_ExecutiveAuditSummary_Calls', 'datatable_ExecutiveAuditSummary_Calls');
                    buildDatatablePrin('table_ExecutiveAuditSummary_Calls',col,chart.table_ExecutiveAuditSummary_Calls);
                }else{
                    $("#datatable_ExecutiveAuditSummary_Calls").empty().append('<br><div class="alert-black alert-warning" role="alert">DATA NOT FOUND  <center><b>ISSUES OR FAILS</b></center></div>');
                }   */ 
                            
                //para el grafico de executive audit summary sites non-conformance
                /*if (chart.grafico_ExecutiveAuditSummary_SitesNonConformance.categories.length > 0){
                    $("#grafico_ExecutiveAuditSummary_SitesNonConformance").empty();                    
                    var series = getDataToObjectSerieAll(chart.grafico_ExecutiveAuditSummary_SitesNonConformance.data, Object.keys(chart.grafico_ExecutiveAuditSummary_SitesNonConformance.data[0]));
                    createChartColumn1('grafico_ExecutiveAuditSummary_SitesNonConformance', chart.grafico_ExecutiveAuditSummary_SitesNonConformance.categories, series, 'Sites With Non-Conformances',
                            null, null, null, [80,'Str=80%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_ExecutiveAuditSummary_SitesNonConformance.data);
                }else{
                    if ($("#grafico_ExecutiveAuditSummary_SitesNonConformance").highcharts()!=undefined){
                       $("#grafico_ExecutiveAuditSummary_SitesNonConformance").highcharts().destroy();
                    } 
                    $("#grafico_ExecutiveAuditSummary_SitesNonConformance").empty().append('<div class="alert-black alert-warning" role="alert">DATA NOT FOUND  <center><b>SITES WITH NON-CONFORMANCES</b></center></div>');
                }*/

                //para la grafica de excutive audit summary passed anad failed
                /*if (chart.grafico_ExecutiveAuditSummary_PassedAndFailed.categories.length > 0){
                    $("#grafico_ExecutiveAuditSummary_PassedAndFailed").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_ExecutiveAuditSummary_PassedAndFailed.data, Object.keys(chart.grafico_ExecutiveAuditSummary_PassedAndFailed.data[0]));
                    createChartColumn('grafico_ExecutiveAuditSummary_PassedAndFailed', chart.grafico_ExecutiveAuditSummary_PassedAndFailed.categories, series, 'Number Of Audits Passed and Failed',
                            null, null, null, [80,'Str=80%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_ExecutiveAuditSummary_PassedAndFailed.data);
                }else{
                    if ($("#grafico_ExecutiveAuditSummary_PassedAndFailed").highcharts()!=undefined){
                      $("#grafico_ExecutiveAuditSummary_PassedAndFailed").highcharts().destroy();
                    } 
                    $("#grafico_ExecutiveAuditSummary_PassedAndFailed").empty().append('<div class="alert-black alert-warning" role="alert">DATA NOT FOUND <span class="margin-top: -10px;"><center><b>NUMBER OF AUDITS PASSED AND FAILED</b></center></span></div>');
                }*/
                //PARA EL GRAFICO DE KPIS
                if (chart.grafico_Kpis.categories.length > 0){
                    $("#grafico_Kpis").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_Kpis','Site Quality: FTR Summary - Volumes',chart.grafico_Kpis.data,chart.grafico_Kpis.categories,url,null,chart.grafico_Kpis.data,[0,"desc"],parametros,'',true,'column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_Kpis").highcharts()!=undefined){
                       $("#grafico_Kpis").highcharts().destroy();
                    }                    
                    $("#grafico_Kpis").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //PARA EL GRAFICO DE KPIS
                if (chart.grafico_KpisPorcentaje.categories.length > 0){
                    $("#grafico_KpisPorcentaje").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_KpisPorcentaje','Site Quality: % FTR and Conditional Pass (SQI < 0.4) – Audited Sites',chart.grafico_KpisPorcentaje.data,chart.grafico_KpisPorcentaje.categories,url,null,chart.grafico_KpisPorcentaje.data,[0,"desc"],parametros,'',true,'column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_KpisPorcentaje").highcharts()!=undefined){
                       $("#grafico_KpisPorcentaje").highcharts().destroy();
                    }                    
                    $("#grafico_KpisPorcentaje").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }     
                //para el grafico Defect Fixed Find  Defects Fixed on Find
                if (chart.grafico_DefectFixedFind.categories.length > 0){
                    $("#grafico_DefectFixedFind").empty();             
                    var series = getDataToObjectSerieAll(chart.grafico_DefectFixedFind.data, Object.keys(chart.grafico_DefectFixedFind.data[0]));
                    createChartColumnPeq('grafico_DefectFixedFind', chart.grafico_DefectFixedFind.categories, series, 'Defects Fixed on Find',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_DefectFixedFind.data,parametros,subtitle_rango_fecha);
                }else{
                    if ($("#grafico_DefectFixedFind").highcharts()!=undefined){
                        $("#grafico_DefectFixedFind").highcharts().destroy();
                    }                    
                    $("#grafico_DefectFixedFind").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }  
                //para el grafico Fixed Find   Sites Fixed on Find
                if (chart.grafico_FixedFind.categories.length > 0){
                    $("#grafico_FixedFind").empty();                    
                    var series = getDataToObjectSerieAll(chart.grafico_FixedFind.data, Object.keys(chart.grafico_FixedFind.data[0]));
                    createChartColumnPeq('grafico_FixedFind', chart.grafico_FixedFind.categories, series, 'Sites Fixed on Find',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_FixedFind.data,parametros,subtitle_rango_fecha);
                }else{
                    if ($("#grafico_FixedFind").highcharts()!=undefined){
                        $("#grafico_FixedFind").highcharts().destroy();
                    }                    
                    $("#grafico_FixedFind").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }   
                //PARA EL GRAFICO DE KPIS PASSIVE
                if (chart.grafico_KpisPassive.categories.length > 0){
                    $("#grafico_KpisPassive").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_KpisPassive','Site Quality: FTR SUMMARY - QAS_PASSIVE',chart.grafico_KpisPassive.data,chart.grafico_KpisPassive.categories,url,null,chart.grafico_KpisPassive.data,[0,"desc"],parametros,'',true,'column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_KpisPassive").highcharts()!=undefined){
                       $("#grafico_KpisPassive").highcharts().destroy();
                    }                    
                    $("#grafico_KpisPassive").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }       
                //PARA EL GRAFICO DE KPIS RIGGER
                if (chart.grafico_KpisRigger.categories.length > 0){
                    $("#grafico_KpisRigger").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_KpisRigger','Site Quality: FTR SUMMARY - QAS_RIGGER',chart.grafico_KpisRigger.data,chart.grafico_KpisRigger.categories,url,null,chart.grafico_KpisRigger.data,[0,"desc"],parametros,'',true,'column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_KpisRigger").highcharts()!=undefined){
                       $("#grafico_KpisRigger").highcharts().destroy();
                    }                    
                    $("#grafico_KpisRigger").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }    
                //PARA EL GRAFICO DE KPIS RIGGER IC
                /*if (chart.grafico_KpisRiggerIc.categories.length > 0){
                    $("#grafico_KpisRiggerIc").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_KpisRiggerIc','KPI SUMMARY - QAS_I/C_RIGGER',chart.grafico_KpisRiggerIc.data,chart.grafico_KpisRiggerIc.categories,url,null,chart.grafico_KpisRiggerIc.data,[0,"desc"],parametros,'',true,'column');
                    url = null;
                }else{
                    if ($("#grafico_KpisRiggerIc").highcharts()!=undefined){
                       $("#grafico_KpisRiggerIc").highcharts().destroy();
                    }                    
                    $("#grafico_KpisRiggerIc").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }*/    
                //PARA EL GRAFICO DE KPIS IC
                if (chart.grafico_KpisIc.categories.length > 0){
                    $("#grafico_KpisIc").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_KpisIc','Site Quality: FTR SUMMARY - QAS_I/C',chart.grafico_KpisIc.data,chart.grafico_KpisIc.categories,url,null,chart.grafico_KpisIc.data,[0,"desc"],parametros,'',true,'column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_KpisIc").highcharts()!=undefined){
                       $("#grafico_KpisIc").highcharts().destroy();
                    }                    
                    $("#grafico_KpisIc").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }  
                //PARA EL GRAFICO DE KPIS DICI
                if (chart.grafico_KpisDici.categories.length > 0){
                    $("#grafico_KpisDici").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_KpisDici','Site Quality: FTR SUMMARY - QAS_DICI',chart.grafico_KpisDici.data,chart.grafico_KpisDici.categories,url,null,chart.grafico_KpisDici.data,[0,"desc"],parametros,'',true,'column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_KpisDici").highcharts()!=undefined){
                       $("#grafico_KpisDici").highcharts().destroy();
                    }                    
                    $("#grafico_KpisDici").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }   
                //PARA EL GRAFICO DE KPIS FULL DICI
                if (chart.grafico_KpisFullDici.categories.length > 0){
                    $("#grafico_KpisFullDici").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_KpisFullDici','Site Quality: FTR SUMMARY - QAS_FULLDICI',chart.grafico_KpisFullDici.data,chart.grafico_KpisFullDici.categories,url,null,chart.grafico_KpisFullDici.data,[0,"desc"],parametros,'',true,'column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_KpisFullDici").highcharts()!=undefined){
                       $("#grafico_KpisFullDici").highcharts().destroy();
                    }                    
                    $("#grafico_KpisIc").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }     
                //PARA EL GRAFICO DE VOLUMEN SITES WITH AUDITS
                if (chart.grafico_VolumenWithAudit.categories.length > 0){
                    $("#grafico_VolumenWithAudit").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_VolumenWithAudit','Site Quality: Volume Of Sites with Audits',chart.grafico_VolumenWithAudit.data,chart.grafico_VolumenWithAudit.categories,url,null,chart.grafico_VolumenWithAudit.data,[0,"desc"],parametros,'','','column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_VolumenWithAudit").highcharts()!=undefined){
                       $("#grafico_VolumenWithAudit").highcharts().destroy();
                    }                    
                    $("#grafico_VolumenWithAudit").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //PARA EL GRAFICO DE VOLUMEN SITES WITH ftr=100
                if (chart.grafico_VolumenSitesFtrTotal.categories.length > 0){
                    $("#grafico_VolumenSitesFtrTotal").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_VolumenSitesFtrTotal','Site Quality: Volume of Sites FTR',chart.grafico_VolumenSitesFtrTotal.data,chart.grafico_VolumenSitesFtrTotal.categories,url,null,chart.grafico_VolumenSitesFtrTotal.data,[0,"desc"],parametros,'','','column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_VolumenSitesFtrTotal").highcharts()!=undefined){
                       $("#grafico_VolumenSitesFtrTotal").highcharts().destroy();
                    }                    
                    $("#grafico_VolumenSitesFtrTotal").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para EL GRAFICO PORCENTAJE SITES WITH FTR=100                
                if (chart.grafico_PorcentSitesFtrTotal.categories.length > 0){
                    $("#grafico_PorcentSitesFtrTotal").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_PorcentSitesFtrTotal','Site Quality: % of FTR Sites',chart.grafico_PorcentSitesFtrTotal.data,chart.grafico_PorcentSitesFtrTotal.categories,url,null,chart.grafico_PorcentSitesFtrTotal.data,[0,"desc"],parametros,'','','column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_PorcentSitesFtrTotal").highcharts()!=undefined){
                       $("#grafico_PorcentSitesFtrTotal").highcharts().destroy();
                    }                    
                    $("#grafico_PorcentSitesFtrTotal").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para SITES WITH DEFECT                
                if (chart.grafico_SitesWithDefects.categories.length > 0){
                    $("#grafico_SitesWithDefects").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_SitesWithDefects','Site Quality: % of Sites Not FTR',chart.grafico_SitesWithDefects.data,chart.grafico_SitesWithDefects.categories,url,null,chart.grafico_SitesWithDefects.data,[0,"desc"],parametros,'','','column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_SitesWithDefects").highcharts()!=undefined){
                       $("#grafico_SitesWithDefects").highcharts().destroy();
                    }                    
                    $("#grafico_SitesWithDefects").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para PORCENT OF SITES WIT DEFECT                
                if (chart.grafico_PorcentSitesWithDefects.categories.length > 0){
                    $("#grafico_PorcentSitesWithDefects").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_PorcentSitesWithDefects','Site Quality: Average Number of defects for sites not FTR',chart.grafico_PorcentSitesWithDefects.data,chart.grafico_PorcentSitesWithDefects.categories,url,null,chart.grafico_PorcentSitesWithDefects.data,[0,"desc"],parametros,'','','column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_PorcentSitesWithDefects").highcharts()!=undefined){
                       $("#grafico_PorcentSitesWithDefects").highcharts().destroy();
                    }                    
                    $("#grafico_PorcentSitesWithDefects").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //sites revisitas
                if (chart.grafico_SitesRevisita.categories.length > 0){
                    $("#grafico_SitesRevisita").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_SitesRevisita','Site Quality: Re-visits',chart.grafico_SitesRevisita.data,chart.grafico_SitesRevisita.categories,url,null,chart.grafico_SitesRevisita.data,[0,"desc"],parametros,'','','column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_SitesRevisita").highcharts()!=undefined){
                       $("#grafico_SitesRevisita").highcharts().destroy();
                    }                    
                    $("#grafico_SitesRevisita").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //porcent sites revisitas
                if (chart.grafico_PorcentSitesRevisita.categories.length > 0){
                    $("#grafico_PorcentSitesRevisita").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_PorcentSitesRevisita','Site Quality: Average days between Re-visits',chart.grafico_PorcentSitesRevisita.data,chart.grafico_PorcentSitesRevisita.categories,url,null,chart.grafico_PorcentSitesRevisita.data,[0,"desc"],parametros,'','','column',subtitle_rango_fecha);
                    url = null;
                }else{
                    if ($("#grafico_PorcentSitesRevisita").highcharts()!=undefined){
                       $("#grafico_PorcentSitesRevisita").highcharts().destroy();
                    }                    
                    $("#grafico_PorcentSitesRevisita").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para Site quality QP
                 if (chart.grafico_KpiQP.categories.length > 0){
                    $("#grafico_KpiQP").empty();
                     url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_KpiQP','Site Quality: Average ASP Quality Performance',chart.grafico_KpiQP.data,chart.grafico_KpiQP.categories,url,null,chart.grafico_KpiQP.data,[0,"desc"],parametros,'','','column',subtitle_rango_fecha);
                    url = null;            
                }else{
                    if ($("#grafico_KpiQP").highcharts()!=undefined){
                       $("#grafico_KpiQP").highcharts().destroy();
                    }                    
                    $("#grafico_KpiQP").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                
                //para sites with qi                
                if (chart.grafico_SitesQI.categories.length > 0){
                    $("#grafico_SitesQI").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    var series = getDataToObjectSerieAll(chart.grafico_SitesQI.data, Object.keys(chart.grafico_SitesQI.data[0]));
                    createChartColumnPeqSinPorcentaje('grafico_SitesQI', chart.grafico_SitesQI.categories, series, 'Site Quality Index - For Customer',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_SitesQI.data,parametros,subtitle_rango_fecha);              
                }else{
                    if ($("#grafico_SitesQI").highcharts()!=undefined){
                       $("#grafico_SitesQI").highcharts().destroy();
                    }                    
                    $("#grafico_SitesQI").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para sites with qi Ericsson               
                if (chart.grafico_SitesQIEricsson.categories.length > 0){
                    $("#grafico_SitesQIEricsson").empty();
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    var series = getDataToObjectSerieAll(chart.grafico_SitesQIEricsson.data, Object.keys(chart.grafico_SitesQIEricsson.data[0]));
                    createChartColumnPeqSinPorcentaje('grafico_SitesQIEricsson', chart.grafico_SitesQIEricsson.categories, series, 'Site Quality Index - For Ericsson',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_SitesQIEricsson.data,parametros,subtitle_rango_fecha);              
                }else{
                    if ($("#grafico_SitesQIEricsson").highcharts()!=undefined){
                       $("#grafico_SitesQIEricsson").highcharts().destroy();
                    }                    
                    $("#grafico_SitesQIEricsson").empty().append('<div class="alert-black alert-warning" style="width: 100%" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                
                //para el grafico kpis exceute vs no execute by rigger / passive
                if (chart.grafico_KpiQasExecutedNotExecuted.categories.length > 0){
                    $("#grafico_KpiQasExecutedNotExecuted").empty();             
                    url = "{{ path('aspir_detalle_tabla_uki') }}"; 
                    charBarras('grafico_KpiQasExecutedNotExecuted','Site Quality: % QAS Executed',chart.grafico_KpiQasExecutedNotExecuted.data,chart.grafico_KpiQasExecutedNotExecuted.categories,url,null,chart.grafico_KpiQasExecutedNotExecuted.data,[0,"desc"],parametros,'','','column',subtitle_rango_fecha);
                    url = null;     
                    /*var series = getDataToObjectSerieAll(chart.grafico_KpiQasExecutedNotExecuted.data, Object.keys(chart.grafico_KpiQasExecutedNotExecuted.data[0]));
                    createChartColumnPeq('grafico_KpiQasExecutedNotExecuted', chart.grafico_KpiQasExecutedNotExecuted.categories, series, 'QAS Execute Vs Not Execute',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_KpiQasExecutedNotExecuted.data,parametros);*/
                }else{
                    if ($("#grafico_KpiQasExecutedNotExecuted").highcharts()!=undefined){
                        $("#grafico_KpiQasExecutedNotExecuted").highcharts().destroy();
                    }                    
                    $("#grafico_KpiQasExecutedNotExecuted").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                } 
                //table kpis                
                if (chart.table_kpis.length > 0){
                    $("#datatable_kpis").empty();
                    //datos = calculateTREND(chart.table_kpis, chart.table_kpisAnterior, asp);

                    col = createTableDT(Object.keys(chart.table_kpis[0]),'table_kpis', 'datatable_kpis');
                    buildDatatablePrin('table_kpis',col,chart.table_kpis,null,null);
                }else{
                    $("#datatable_kpis").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //qas exceuted vs not excuted
                //para el grafico exceuted not executed
                if (chart.grafico_QasExecutedNotExecuted.categories.length > 0){
                    $("#grafico_QasExecutedNotExecuted").empty(); 
                    var series = getDataToObjectSerieAll(chart.grafico_QasExecutedNotExecuted.data, Object.keys(chart.grafico_QasExecutedNotExecuted.data[0]));
                    createChartColumn('grafico_QasExecutedNotExecuted', chart.grafico_QasExecutedNotExecuted.categories, series, '% QAS Executed',
                            null, [70, 'Rob=70%'], [80,'Com=80%'], [90,'Str=90%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_uki') }}", chart.grafico_QasExecutedNotExecuted.data);
                }else{
                    if ($("#grafico_QasExecutedNotExecuted").highcharts()!=undefined){
                        $("#grafico_QasExecutedNotExecuted").highcharts().destroy();
                    }                    
                    $("#grafico_QasExecutedNotExecuted").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //para la tabla qas executed vs not execute               
                if (chart.table_QasExecutedNotExecuted.length > 0){
                    $("#datatable_QasExecutedNotExecuted").empty();
                    var col = createTableDT(Object.keys(chart.table_QasExecutedNotExecuted[0]),'table_QasExecutedNotExecuted', 'datatable_QasExecutedNotExecuted');
                    buildDatatablePrin('table_QasExecutedNotExecuted',col,chart.table_QasExecutedNotExecuted);
                }else{
                    $("#datatable_QasExecutedNotExecuted").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //ocultar graficos dependeneido del cliente
                //console.log('cliente',$("#cliente").val());
                if ($("#cliente").val()=="VODAFONE"){
                    $("#kpiRigger").show();
                    $("#kpiPass").show();
                    $("#kpiIc").show();
                    $("#kpiFull").hide();
                    $("#kpiDici").hide();
                    $("#kpi2").removeClass('col-lg-12');
                    $("#kpi2").addClass('col-lg-6');
                }else if($("#cliente").val()=="BRITISH TELECOM"){
                    $("#kpiRigger").hide();
                    $("#kpiPass").hide();
                    $("#kpiIc").hide();
                    $("#kpiFull").show();
                    $("#kpiDici").show();
                    $("#kpi2").removeClass('col-lg-6');
                    $("#kpi2").addClass('col-lg-12');
                }else{
                    $("#kpiRigger").show();
                    $("#kpiPass").show();
                    $("#kpiIc").show();
                    $("#kpiFull").show();
                    $("#kpiDici").show();
                    $("#kpi2").removeClass('col-lg-12');
                    $("#kpi2").addClass('col-lg-6');
                }
                $.isLoading("hide");
                resizeChart();
            });
        }
         function getDataToObjectSerieAll1(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;
            return data1;
        }
        function graficaAsp(render,data,path,parametros,title){
            //para las graficas asp            
            var series = new Array();
            var categories = new Array();
            var grafico = data.data;          
            if (grafico.length>0){
                var seriesGrafico = getDataToObjectSerieAll1(grafico.sort(), Object.keys(grafico[0]));
                categories = data.categories;
                $.each(seriesGrafico, function(key, value) {
                    $.each(value, function(k, v) {                 
                        series.push({"name":v.name,"data":v.data});
                    });
                });
            }
            var options = {
                chart: {
                    type: 'bar'
                },
                title: {
                    text: title
                },
                xAxis: {
                    categories: categories
                },
                yAxis: {
                    min: 0,
                    title: {
                        text: ''
                    }
                },
                legend: {
                    reversed: true
                },
                credits: {
                    enabled: false
                },
                plotOptions: {
                    series: {
                        stacking: 'normal',
                        pointWidth: 20,
                        pointPadding: 0.1,
                        groupPadding: 0.2,
                        dataLabels: {
                            enabled: true,
                            formatter: function () {
                                if (this.point.y==0){
                                    return '';
                                }else{
                                     return this.point.y;
                                }
                            }
                        },
                        dataSorting: {
                            enabled: true,
                            sortKey: 'y',
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (this != null){
                                        var asp =  this.series.name;
                                        parametros['kpi'] = 'SYSTEM_FAULT_DETAIL_NEW';
                                        parametros['selected_asp'] = asp;
                                        parametros['selected_item'] = this.category.name;
                                        var title_detalle = title;    
                                        var subtitle_detalle = asp; 
                                        var orderArray;
                                        generateModal(path, parametros, false,  title_detalle, subtitle_detalle, orderArray);
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                },
                series: series
            }
            return $('#'+render).highcharts(options);  
        }
        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 openModalDetalle(fechaGroup){  
            $('#datatable_02 tr').remove();
            $('#modalDetalleOtdTitle').text('Services Not Delivered On Time');     
            $("#modalDetalleOtd").modal('show');
            $("#datatable_02").isLoading('hide');           
            getTableModal('detalle',fechaGroup);
        }
        //funcion para crear la tabla de la modal
        function getTableModal(tipo,fechaGroup){
                var inicio = $('#Filtros_fechaIni').val();
                var fin = $('#Filtros_fechaFin').val();
                if ('{{idmodule}}'==366 || '{{idmodule}}'==371){
                    var cliente = $('#cliente').val();//var cliente = 'AT&T';  
                    var pais = 'MX';    
                }            
                else{
                    var cliente = $('#cliente').val();
                    var pais = 'United Kingdom';
                } 
                var proyecto = $('#proyecto').val();            
                if($('#asp_user').val()!=''){
                    var asp = $('#asp_user').val();
                }else{
                   var asp = $('#asp').val();
                } 
                var valor = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();
                var parametros = {
                    'postfix' : 'uki',
                    'FechaInicio': inicio,
                    'FechaFin': fin,
                    'pais': pais,
                    'cliente': cliente,
                    'proyecto': proyecto,
                    'asp': asp,
                    'date': valor,
                    'tipo':tipo,
                    'fechaGroup':fechaGroup
                };
                $.getJSON('{{path('aspir_DashboardAspirModalUki',{'idproyectos':idproyectos})}}', parametros, function (data){
                    var chart = data;                
                    // Tabla tablaDetalleOnTimeDelivery
                    if (chart.tablaDetalleOnTimeDelivery.length > 0){                     
                         $("#datatable_02").empty();
                         var col = createTableDT(Object.keys(chart.tablaDetalleOnTimeDelivery[0]),'table_02', 'datatable_02');
                         buildDatatablePrin('table_02',col,chart.tablaDetalleOnTimeDelivery);
                     }else{
                        $("#datatable_02").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                    }                             
                    $("#datatable_02").isLoading('hide'); 
                });
        }  
        function resizeChart(){
            //try{
                //console.log("prueba resize");
                var panel_width = $('#panel_content').width();
                var offset = 32;
                $('#graficoOnTimeDelivery').width(panel_width-offset);
                $('#grafico_FTR').width(panel_width-offset); 
                $('#grafico_IssuesExecuted').width(panel_width-offset);
                $('#grafico_ExecutedNotExecuted').width(panel_width-offset);
                $('#grafico_ExecutedNotExecutedRazones').width(panel_width-offset);
                //$('#grafico_SystemFaultFound').width(panel_width-offset);
                $('#grafico_IssuesFound').width(panel_width-offset); 
                $('#grafico_QualityPerformance').width(panel_width-offset);
                $('#grafico_Range').width(panel_width-offset); 
                $('#grafico_ASP').width(panel_width-offset);
                $('#grafico_OHS').width(panel_width-offset);    
                $('#grafico_ExecutedNotExecutedRazones').width(panel_width-offset);  
                $('#grafico_ExecutiveAuditSummary_Calls0').width(panel_width-offset);
                $('#grafico_ExecutiveAuditSummary_Calls1').width(panel_width-offset);
                $('#grafico_ExecutiveAuditSummary_Calls2').width(panel_width-offset);  
                $('#grafico_ExecutiveAuditSummary_Calls3').width(panel_width-offset); 
                $('#grafico_QasExecutedNotExecuted').width(panel_width-offset); 
                //$('#grafico_ExecutiveAuditSummary_SitesNonConformance').width(panel_width-offset);
                //$('#grafico_ExecutiveAuditSummary_PassedAndFailed').width(panel_width-offset);

                var panel_width1 = $('.panel-body').width()
                // para 100 $('#grafico_Kpis').width(panel_width-(offset*2));
                $('#grafico_Kpis').width('70%');
                $('#grafico_KpisPorcentaje').width('70%');
                $('#grafico_KpisPassive').width('70%');
                $('#grafico_KpisRigger').width('70%');
                $('#grafico_KpisRiggerIc').width('70%');
                $('#grafico_KpisIc').width('70%');
                $('#grafico_KpisDici').width('70%');
                $('#grafico_KpisFullDici').width('70%');
                $('#grafico_VolumenWithAudit').width('70%');
                $('#grafico_VolumenSitesFtrTotal').width('70%');
                $('#grafico_PorcentSitesFtrTotal').width('70%');
                $('#grafico_SitesWithDefects').width('70%');
                $('#grafico_PorcentSitesWithDefects').width('70%');
                $('#grafico_SitesRevisita').width('70%');
                $('#grafico_PorcentSitesRevisita').width('70%');
                $('#grafico_KpiQP').width('70%');
                $('#grafico_SitesQI').width('70%');
                $('#grafico_SitesQIEricsson').width('70%');
                $('#grafico_FixedFind').width('70%');
                $('#grafico_DefectFixedFind').width('70%');
                $('#grafico_KpiQasExecutedNotExecuted').width('70%');

                
                if ($("#grafico_FTR").highcharts()!=undefined){ 
                    $('#grafico_FTR').highcharts().reflow();  
                }   
                if ($("#grafico_IssuesExecuted").highcharts()!=undefined){         
                    $('#grafico_IssuesExecuted').highcharts().reflow();                 
                }
                if ($("#grafico_ExecutedNotExecuted").highcharts()!=undefined){ 
                    $('#grafico_ExecutedNotExecuted').highcharts().reflow();                   
                }
                if ($("#grafico_ExecutedNotExecutedRazones").highcharts()!=undefined){ 
                    $('#grafico_ExecutedNotExecutedRazones').highcharts().reflow();                                   
                }
                if ($("#grafico_SystemFaultFound").highcharts()!=undefined){ 
                    $('#grafico_SystemFaultFound').highcharts().reflow();
                }   
                if ($("#grafico_IssuesFound").highcharts()!=undefined){                  
                    $('#grafico_IssuesFound').highcharts().reflow(); 
                }   
                if ($("#grafico_QualityPerformance").highcharts()!=undefined){                                              
                    $('#grafico_QualityPerformance').highcharts().reflow();                   
                }
                if ($("#grafico_Range").highcharts()!=undefined){               
                    $('#grafico_Range').highcharts().reflow();
                }
                if ($("#grafico_ASP").highcharts()!=undefined){  
                    $('#grafico_ASP').highcharts().reflow(); 
                }
                if ($("#grafico_OHS").highcharts()!=undefined){ 
                    $('#grafico_OHS').highcharts().reflow();
                }
                if ($("#grafico_ExecutedNotExecutedRazones").highcharts()!=undefined){ 
                    $('#grafico_ExecutedNotExecutedRazones').highcharts().reflow(); 
                }
                if ($("#grafico_ExecutiveAuditSummary_Calls0").highcharts()!=undefined){ 
                    $('#grafico_ExecutiveAuditSummary_Calls0').highcharts().reflow();  
                }
                if ($("#grafico_ExecutiveAuditSummary_Calls1").highcharts()!=undefined){ 
                    $('#grafico_ExecutiveAuditSummary_Calls1').highcharts().reflow();  
                }
                if ($("#grafico_ExecutiveAuditSummary_Calls2").highcharts()!=undefined){ 
                    $('#grafico_ExecutiveAuditSummary_Calls2').highcharts().reflow(); 
                }
                if ($("#grafico_ExecutiveAuditSummary_Calls3").highcharts()!=undefined){ 
                    $('#grafico_ExecutiveAuditSummary_Calls3').highcharts().reflow();  
                }
                //$('#grafico_ExecutiveAuditSummary_SitesNonConformance').highcharts().reflow();
                //$('#grafico_ExecutiveAuditSummary_PassedAndFailed').highcharts().reflow(); 
                if ($("#grafico_Kpis").highcharts()!=undefined){ 
                    $('#grafico_Kpis').highcharts().reflow(); 
                }
                if ($("#grafico_KpisPorcentaje").highcharts()!=undefined){ 
                    $('#grafico_KpisPorcentaje').highcharts().reflow(); 
                }
                if ($("#grafico_KpisPassive").highcharts()!=undefined){ 
                    $('#grafico_KpisPassive').highcharts().reflow(); 
                }
                if ($("#grafico_KpisRigger").highcharts()!=undefined){ 
                    $('#grafico_KpisRigger').highcharts().reflow(); 
                }
                if ($("#grafico_KpisRiggerIc").highcharts()!=undefined){ 
                    $('#grafico_KpisRiggerIc').highcharts().reflow(); 
                }
                if ($("#grafico_KpisIc").highcharts()!=undefined){ 
                    $('#grafico_KpisIc').highcharts().reflow(); 
                }
                if ($("#grafico_KpisDici").highcharts()!=undefined){ 
                    $('#grafico_KpisDici').highcharts().reflow(); 
                }
                if ($("#grafico_KpisFullDici").highcharts()!=undefined){ 
                    $('#grafico_KpisFullDici').highcharts().reflow(); 
                }
                if ($("#grafico_VolumenWithAudit").highcharts()!=undefined){ 
                    $('#grafico_VolumenWithAudit').highcharts().reflow(); 
                }
                if ($("#grafico_VolumenSitesFtrTotal").highcharts()!=undefined){ 
                    $('#grafico_VolumenSitesFtrTotal').highcharts().reflow(); 
                }
                if ($("#grafico_PorcentSitesFtrTotal").highcharts()!=undefined){ 
                    $('#grafico_PorcentSitesFtrTotal').highcharts().reflow(); 
                }
                if ($("#grafico_SitesWithDefects").highcharts()!=undefined){ 
                    $('#grafico_SitesWithDefects').highcharts().reflow(); 
                }
                if ($("#grafico_PorcentSitesWithDefects").highcharts()!=undefined){ 
                    $('#grafico_PorcentSitesWithDefects').highcharts().reflow(); 
                }
                if ($("#grafico_SitesRevisita").highcharts()!=undefined){ 
                    $('#grafico_SitesRevisita').highcharts().reflow(); 
                }
                if ($("#grafico_PorcentSitesRevisita").highcharts()!=undefined){ 
                    $('#grafico_PorcentSitesRevisita').highcharts().reflow(); 
                }
                if ($("#grafico_KpiQP").highcharts()!=undefined){ 
                    $('#grafico_KpiQP').highcharts().reflow(); 
                }
                 if ($("#grafico_SitesQI").highcharts()!=undefined){ 
                    $('#grafico_SitesQI').highcharts().reflow(); 
                }
                if ($("#grafico_SitesQIEricsson").highcharts()!=undefined){ 
                    $('#grafico_SitesQIEricsson').highcharts().reflow(); 
                }
                if ($("#grafico_FixedFind").highcharts()!=undefined){ 
                    $('#grafico_FixedFind').highcharts().reflow(); 
                }
                if ($("#grafico_DefectFixedFind").highcharts()!=undefined){ 
                    $('#grafico_DefectFixedFind').highcharts().reflow(); 
                }
                if ($("#grafico_KpiQasExecutedNotExecuted").highcharts()!=undefined){ 
                    $('#grafico_KpiQasExecutedNotExecuted').highcharts().reflow(); 
                }
                if ($("#graficoOnTimeDelivery").highcharts()!=undefined){                   
                    $('#graficoOnTimeDelivery').highcharts().reflow();  
                }                
                if ($("#grafico_QasExecutedNotExecuted").highcharts()!=undefined){ 
                    $('#grafico_QasExecutedNotExecuted').highcharts().reflow();                   
                }
                //$('#grafico_ExecutedNotExecuted').width((panel_width/2)-offset);
                //$('#grafico_ExecutedNotExecutedRazones').width((panel_width/2)-offset);  
                //redrawDt();
           // }catch(err) {
                //console.log(err.message);
           // }
        }
        function generateModal(ruta, objParams, numerar, title, subtitle, orderArray)
        {        
            //console.log('prueba',objParams);
            if (objParams.kpi=='ftr' || objParams.kpi=='ftr_asp' || objParams.kpi=='ftr_total_service' || objParams.kpi=='ftr_aggregate_total_sites' || objParams.kpi=='System_Fault_DETAIL'){
                $("#mes_seleccionado").val(objParams.mes);
                $("#pais_seleccionado").val(objParams.pais);
                $("#cliente_seleccionado").val(objParams.cliente);
                $("#proyecto_seleccionado").val(objParams.proyecto);
                $("#asp_seleccionado").val(objParams.asp);
                $("#selected_item_seleccionado").val(objParams.selected_item);
            }else{
                $("#mes_seleccionado").val('');
                $("#pais_seleccionado").val('');
                $("#cliente_seleccionado").val('');
                $("#proyecto_seleccionado").val('');
                $("#asp_seleccionado").val('');
                $("#selected_item_seleccionado").val('');
            }        
            $("#mostrar_excel_ftr_issues").hide(); 
            $("#mostrar_excel_asp_ftr_issues").hide();
            $("#mostrar_excel_ftr_total_sites_issues").hide();
            $("#mostrar_excel_rango_total_sites_issues").hide();
            $("#mostrar_excel_issues").hide();    
            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;
                    if (objParams.kpi=="OHS_DETAIL"){
                        var total_ok_ohs = 0;
                        var total_not_ok_ohs = 0;
                        var total_registros = 0;    
                        var total_general_ok = 0;                                      
                        if (data.length>0){
                            $.each(data, function(key, value) {
                                total_ok_ohs+= parseFloat(data[key]['Accepted']);
                                total_not_ok_ohs+= parseFloat(data[key]['Not Accepted']);
                                total_registros++;
                            });
                            total_general_ok = total_ok_ohs;
                            total_general = total_ok_ohs + total_not_ok_ohs;                            
                            porcentaje_ohs = (total_general_ok / total_general) * 100;
                            porcentaje_ohs = porcentaje_ohs.toFixed(2);
                        }                            
                    }                  
                    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=="Total Not Accepted" || title=="Not Ok" || title=="ISSUES ERROR" || title=="SYSTEM FAULT FOUND" || title=="CHECK" || title=="Total Corrected"){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi="";
                                var popup_title = "";                                
                                var strIssuesText = "";
                                var url= "";
                                if (row.hasOwnProperty('_ISSUES')){
                                    kpi='ftr';
                                    popup_title = 'Check';
                                    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>Check</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=="Corrected"){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi="";
                                var popup_title = "";                                
                                var strIssuesText = "";
                                var url= "";
                                if (row.hasOwnProperty('_ISSUES_CORRECTED')){
                                    kpi='ftr';
                                    popup_title = 'Issues';
                                    var issues = row['_ISSUES_CORRECTED'];  
                                    var arrIssues = issues == null ? null : issues.split("<br>");     
                                    if (arrIssues!=null){   
                                        var strIssuesHtml = "<ol>";
                                        if (Array.isArray(arrIssues)){ 
                                            for (var i=0; i<arrIssues.length; i++){
                                                strIssuesHtml += "<li>" + arrIssues[i] + ".</li>";
                                                strIssuesText += i + ". " +  arrIssues[i] + ".\r\n";
                                            }
                                        }else{
                                            strIssuesHtml = issues;
                                        }
                                        strIssuesHtml += "</ol>";
                                    }
                                }                                                                 
                                if (type==='display' && strIssuesText!=''){
                                    return '<a href="javascript://"  data-toggle="popover" data-title="<b>Issues</b>" ' +
                                            'data-container="body" data-placement="left" data-html="true" ' +
                                            'data-trigger="focus" ' +
                                            'data-content="' + strIssuesHtml  + '"' +
                                            '>' + dato + '</a>';
                                }else{
                                    return dato;
                                }
                            }
                            return dato;
                        }
                    });
                }else if (title=="Not Accepted"){
                    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_REJECTED')){
                                    kpi='ftr';
                                    popup_title = 'Issues';
                                    var issues = row['_ISSUES_REJECTED'];  
                                    var arrIssues = issues == null ? null : issues.split("<br>");     
                                    if (arrIssues!=null){   
                                        var strIssuesHtml = "<ol>";
                                        if (Array.isArray(arrIssues)){ 
                                            for (var i=0; i<arrIssues.length; i++){
                                                strIssuesHtml += "<li>" + arrIssues[i] + ".</li>";
                                                strIssuesText += i + ". " +  arrIssues[i] + ".\r\n";
                                            }
                                        }else{
                                            strIssuesHtml = issues;
                                        }
                                        strIssuesHtml += "</ol>";
                                    }
                                }                                                                 
                                if (type==='display' && strIssuesText!=''){
                                    return '<a href="javascript://"  data-toggle="popover" data-title="<b>Issues</b>" ' +
                                            'data-container="body" data-placement="left" data-html="true" ' +
                                            'data-trigger="focus" ' +
                                            'data-content="' + strIssuesHtml  + '"' +
                                            '>' + dato + '</a>';
                                }else{
                                    return dato;
                                }
                            }
                            return dato;
                        }
                    });
                }else if (title=='_ISSUES'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (Array.isArray(dato)){
                                if (dato.length>0){
                                    var strIssuesHtml = "<ol>";
                                    var strIssuesText = "";
                                    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'){
                                        return strIssuesHtml;
                                    }else{
                                        return strIssuesText;
                                    }
                                }
                            }
                            return dato;
                        }
                    });
                }else if (title=='OHS Index Total'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            //console.log( dato, type, row);                            
                            //asignaa valores
                            if (dato == total_registros){
                                return porcentaje_ohs;    
                            }else{
                                return '';
                            }
                            
                        }
                    });
                }else if(title =='URL Checklist'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato){
                                if (dato.includes('http')){
                                   return '<a href="'+dato+'" target="_blank">'+dato+'</a>';
                                }else{
                                    return dato;
                                }     
                            }else{
                                return ' ';
                            }
                        }
                    });
                }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;
        }
        function createChartBarra2Old(render, categoria, series, title, w,
                                   parametros, inicio, fin, pais, orderArray, path, rawData)
        { 
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            //var step = rawData.length >30 ? Math.ceil(rawData.length/30) : 1 ;
            var data = series[0];
            //console.log(render);
            switch (render){
                case 'grafico_SystemFaultFound':
                    posProy = 2;
                    break;
                case 'grafico_IssuesFound': 
                    posProy = 2;
                    break;                    
            }  
            var options = {
                chart: {
                    type: 'bar',
                    marginLeft: 150
                },
                title: {
                    text: title
                },
                subtitle: {
                    text: 'Source: <a href="https://highcharts.uservoice.com/forums/55896-highcharts-javascript-api">UserVoice</a>'
                },
                xAxis: {
                    type: 'category',
                    title: {
                        text: null
                    },
                    min: 0,
                    max: 18,
                    scrollbar: {
                        enabled: false
                    },
                    tickLength: 0
                },
                yAxis: {
                    min: 0,
                    max: 1200,
                    title: {
                        text: 'Votes',
                        align: 'high'
                    }
                },
                plotOptions: {
                    bar: {
                        dataLabels: {
                            enabled: true
                        }
                    }
                },
                legend: {
                    enabled: false
                },
                credits: {
                    enabled: false
                },
                series: [{
                    name: data[0]['name'],
                    data: data[0]['data'],
                }]
            }
            return $('#' + render).highcharts(options);
        }
        function createChartBarra2(render, categoria, series, title, w,
                                   parametros, inicio, fin, pais, orderArray, path, rawData)
         {
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            //var step = rawData.length >30 ? Math.ceil(rawData.length/30) : 1 ;
            var data = series[0];
            //console.log(render);
            switch (render){
                case 'grafico_SystemFaultFound':
                    posProy = 2;
                    break;
                case 'grafico_IssuesFound': 
                    posProy = 2;
                    break;                    
            }  
            //console.log(data[0]['data']);          
            var options = {
                chart: {
                    //spacingBottom: 10, //35
                    spacingTop: 70, //se cambio de 40 a 70 para que no se montara el titulo
                    spacingLeft: 40,
                    spacingRight: 40,
                    height: 1150,
                    marginBottom: 110, //180
                    borderColor: '#428bca',
                    borderWidth: 1,
                    type: 'bar',
                    shadow: true,
                    //zoomType: 'xy',
                    credits: {
                        enabled: false
                    },
                    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
                        ]
                    }
                },   
                exporting: {
                    buttons: {
                        contextButton:{
                            x:-10,
                            y:-30
                        }
                    },
                },             
                credits: {
                    enabled: false
                },
                plotOptions:{
                    bar: {
                        dataLabels: {
                            enabled: true
                        }
                    },
                    series:{
                        shadow:true,
                        dataLabels: {
                            enabled: true,
                            style: {
                                fontWeight: 'bold'
                            }
                        },
                        events: {
                            legendItemClick: function () {
                                var visibility = this.visible;
                                var serie = this.name;

                                if ( $.fn.DataTable.isDataTable( '#' + table_dt ) ) {
                                    var table = $('#' + table_dt).DataTable();
                                    $.fn.dataTable.ext.search.push(
                                            function( settings, searchData, index, rowData, counter ) {

                                                if ( settings.nTable.id !== table_dt ) {
                                                    return true;
                                                }
                                                // Don't display rows if nothing is checked
                                                if (projectList[posProy].length === 0) {
                                                    return false;
                                                }

                                                if (projectList[posProy].includes(searchData[col])) {
                                                    return true;
                                                }
                                                return false;
                                            }
                                    );
                                    var index = projectList[posProy].indexOf( serie );

                                    if (!visibility && index === -1) {
                                        projectList[posProy].push(serie);
                                    } else if (visibility && index > -1) {
                                        projectList[posProy].splice(index, 1);
                                    }

                                    table.draw();
                                }
                            }
                        }
                    }
                },
                legend: {
                    backgroundColor: 'rgba(66, 139, 202, 0.5)'
                },
                xAxis: {
                    categories: [],
                    lineWidth: 1,
                    lineColor: '#4c4c4c',
                    //tickColor: '#4c4c4c',
                    tickWidth: 0,
                    //minorTickWidth: 1,
                    labels: {
                        groupedOptions: [{ // 1st-level
                            //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                            rotation: 0,
                            lineWidth: 0,
                            tickWidth: 0,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            }
                        }, // 2nd-level
                            {
                                //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                rotation: rotation,
                                lineWidth: 0,
                                tickWidth: 0,
                                //align: 'right',
                                style: {
                                    fontSize: '10px',
                                    color: '#333333'
                                    //color: '#4c4c4c'
                                }
                            }
                        ],
                        //step: step,
                        lineWidth: 0,
                        tickWidth: 0,
                        rotation: rotation,
                        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 > 30){
                                return this.value.substring(0, 27) + '...';
                            }
                            return this.value;
                        }
                    },
                    //overflow: 'justify',
                    min: 0,
                    max: data[0]['data'].length - 1,
                    scrollbar: {
                        enabled: false
                    }
                },
                yAxis:{
                    //min: 0,
                    //max: 1000,
                    title: {text: ''},
                    lineWidth: 1,
                    lineColor: '#4c4c4c',
                    plotLines: [
                        {
                            value: 0,
                            width: 1,
                            color: '#808080'
                        }
                    ]
                },
                title: {text: title},
                tooltip: {shared: true},
                //colors: ['#a1c517', '#0082b6', '#b88fef', '#009045', '#db004f'],
                //colors: ['#2f7ed8', '#0d233a', '#8bbc21', '#910000', '#1aadce',
                //  '#492970', '#f28f43', '#77a1e5', '#c42525', '#a6c96a']
                colors: ["#2a587f", "#434348", "#90ed7d", "#f7a35c", "#8085e9",
                    "#f15c80", "#e4d354", "#2b908f", "#f45b5b", "#91e8e1",
                    '#2f7ed8', '#0d233a', '#8bbc21', '#910000', '#1aadce',
                    '#492970', '#f28f43', '#77a1e5', '#c42525', '#a6c96a',
                    '#4572A7', '#AA4643', '#89A54E', '#80699B', '#3D96AE',
                    '#DB843D', '#92A8CD', '#A47D7C', '#B5CA92'],
                series: [{
                    cursor: 'pointer',
                    showInLegend: true,
                    name: data[0]['name'],
                    data: data[0]['data'],
                    borderColor: '#001751',
                    color: {
                        linearGradient: {x1: 0, x2: 0, y1: 0, y2: 1},
                        stops: [
                            [0,   '#0068bf'],
                            //[0.2,   '#34aead'],
                            [0.5, '#0077dc'],
                            //[0.8, '#42e8e6'],
                            [1,   '#3ba5ff']
                        ]
                    },
                    tag: 1,
                    point: {
                        events:{
                            click: function (e){
                                var categoryPath = options.xAxis.categories;
                                if (path != null){
                                    parametros['selected_item'] = categoryPath[this.x];
                                    parametros['selected_serie'] = this.series.name;
                                    if (rawData != null)
                                    {
                                        parametros['row'] = rawData[this.x];
                                    }         
                                    if (render=='grafico_IssuesFound'){
                                        parametros['kpi'] = 'Issues_Found_DETAIL';
                                    }else if (render=='grafico_SystemFaultFound'){
                                        parametros['kpi'] = 'System_Fault_DETAIL';  
                                    }                                                                  
                                    //console.log(render,parametros,'detalle');
                                    var prefix = (title == null || title == '') ? '' : title; //+ ' - ';
                                    //console.log(path, parametros, false, prefix, categoryPath[this.x], orderArray)
                                    generateModal(path, parametros, true, prefix, categoryPath[this.x],orderArray);
                                }
                            }
                        }
                    }
                }]
            };

            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 valorActual= parseFloat(rawData[k][series[0].name]);

                 if (valorActual <= menor){
                 menor = valorActual;
                 }*/

                var lastCat = categoria[categoria.length - 1]['sql_name'];

                if (categoria.length>=1){ //Si hay 2 o mas categorias

                    // I. level of categories
                    if (categoria.length > 1) {
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[0]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });

                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[0]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

                    if (categoria.length >= 3){
                        // II. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

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

                    if (categoria.length >=4){
                        // III. level of categories

                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

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

                    if (categoria.length >=5){
                        // IV. level of categories

                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

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

                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

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


                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;

                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            if (menor >50) menor= 50;
            //options.yAxis[0].min=menor;
            //options.xAxis.min=0;
            //options.xAxis.max= options.xAxis.categories.length>8 ? 8 : options.xAxis.categories.length -1;
            options.yAxis.min=0;
            options.yAxis.max=mayor;

            return $('#' + render).highcharts(options);
        }
        function createChartLinea2HotProject(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, inicio, fin, pais, orderArray, path, rawData)
        {
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 2;
            var col1 = 1;
            var col2 = 3;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            switch (render){
                case 'grafico_FTR':
                    table_dt = 'table_FTR';
                    dt = 'datatable_FTR';
                    posProy = 1;
                    break; 
                case 'grafico_Range':
                    table_dt = 'table_Range';
                    dt = 'datatable_Range';
                    posProy = 2;
                    break;  
                case 'grafico_ASP':
                    table_dt = 'table_ASP';
                    dt = 'datatable_ASP';
                    posProy = 3;
                    break;             
            }
            var options = {
                chart: {
                    spacingBottom: 10, //35
                    spacingTop: 40,
                    spacingLeft: 40,
                    spacingRight: 40,
                    height: 450,
                    marginBottom: 110, //180
                    borderColor: '#428bca',
                    borderWidth: 1,
                    type: 'line',
                    shadow: true,
                    zoomType: 'x',
                    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
                },
                plotOptions:{
                    series:{
                        shadow:true,
                        dataLabels: {
                            enabled: true,
                            style: {
                                fontWeight: 'bold'
                            }
                        },
                        events: {
                            legendItemClick: function () {
                                var visibility = this.visible;
                                var serie = this.name;
                                var index = projectList[posProy].indexOf( serie );
                                if ( $.fn.DataTable.isDataTable( '#' + table_dt ) ) {
                                    var table = $('#' + table_dt).DataTable();
                                    $.fn.dataTable.ext.search.push(
                                            function( settings, searchData, index, rowData, counter ) {
                                                if ( settings.nTable.id !== table_dt ) {
                                                    return true;
                                                }
                                                // Don't display rows if nothing is checked
                                                if (projectList[posProy].length === 0) {
                                                    return false;
                                                }

                                                if (projectList[posProy].includes(searchData[col])) {
                                                    return true;
                                                }
                                                if (projectList[posProy].includes(searchData[col2])) {
                                                    return true;
                                                }
                                                if (projectList[posProy].includes(searchData[col1])) {
                                                    return true;
                                                }
                                                return false;
                                            }
                                    );
                                    if (!visibility && index === -1) {
                                        projectList[posProy].push(serie);
                                    } else if (visibility && index > -1) {
                                        projectList[posProy].splice(index, 1);
                                    }

                                    table.draw();
                                }
                            }
                        }
                    }
                },
                legend: {
                    backgroundColor: 'rgba(66, 139, 202, 0.5)'
                },
                xAxis: {
                    categories: [],
                    lineWidth: 1,
                    lineColor: '#4c4c4c',
                    //tickColor: '#4c4c4c',
                    //tickWidth: 1,
                    //minorTickWidth: 1,
                    labels: {
                        groupedOptions: [{ // 1st-level
                            //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                            rotation: 0,
                            lineWidth: 1,
                            tickWidth: 1,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            }
                        }, // 2nd-level
                            {
                                //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                rotation: rotation,
                                lineWidth: 0,
                                tickWidth: 0,
                                //align: 'right',
                                style: {
                                    fontSize: '9px',
                                    color: '#333333'
                                    //color: '#4c4c4c'
                                }
                            }
                        ],
                        step: step,
                        lineWidth: 0,
                        tickWidth: 0,
                        rotation: rotation,
                        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 > 20){
                                return this.value.substring(0, 17) + '...';
                            }
                            return this.value;
                        }
                    },
                    overflow: 'justify',
                    scrollbar: {
                        enabled: false
                    }
                },
                yAxis:
                        [
                            {
                                min: 50,
                                max: w,
                                title: {text: 'Percent FTR (%)'},
                                lineWidth: 1,
                                lineColor: '#4c4c4c',
                                plotLines: [
                                    {
                                        value: 0,
                                        width: 1,
                                        color: '#808080'
                                    }
                                ]
                            }
                            ,
                            {
                                title: {text: ''},
                                min: 0,
                                opposite: true
                            }
                            ,
                            {
                                title: {text: ''},
                                min: 0,
                                opposite: true
                            }
                        ]
                ,
                title: {text: title},
                tooltip: {shared: true},
                //colors: ['#a1c517', '#0082b6', '#b88fef', '#009045', '#db004f'],
                //colors: ['#2f7ed8', '#0d233a', '#8bbc21', '#910000', '#1aadce',
                //  '#492970', '#f28f43', '#77a1e5', '#c42525', '#a6c96a']
                colors: ["#2a587f", "#434348", "#90ed7d", "#f7a35c", "#8085e9",
                    "#f15c80", "#e4d354", "#2b908f", "#f45b5b", "#91e8e1",
                    '#2f7ed8', '#0d233a', '#8bbc21', '#910000', '#1aadce',
                    '#492970', '#f28f43', '#77a1e5', '#c42525', '#a6c96a',
                    '#4572A7', '#AA4643', '#89A54E', '#80699B', '#3D96AE',
                    '#DB843D', '#92A8CD', '#A47D7C', '#B5CA92'],
                series: series[0]
            };

            if (target_line != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line[0],
                    color: '#f7e81d', //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]
                    }
                };

                /*options.yAxis[0].plotBands[options.yAxis[0].plotBands.length] ={ // Verde Grama
                 from: 84.99,
                 to: 80,
                 color: 'rgba(46, 130, 1, 0.3)',
                 label: {
                 text: 'ROBUST',
                 style: {
                 color: '#606060'
                 }
                 }
                 };*/
            }

            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]
                    }
                };
                /*options.yAxis[0].plotBands[options.yAxis[0].plotBands.length] ={ // Verde Manzana
                 from: 89.99,
                 to: 85,
                 color: 'rgba(124, 242, 60, 0.3)',
                 label: {
                 text: 'COMMITMENT',
                 style: {
                 color: '#606060'
                 }
                 }
                 };*/
            }

            if (target_line3 != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line3[0],
                    color: '#2e8201', //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]
                    }
                };
                /*options.yAxis[0].plotBands[options.yAxis[0].plotBands.length] = { //Amarillo
                    from: 90.00,
                    to: 100,
                    color: 'rgba(247, 232, 29, 0.3)',
                    label: {
                        text: 'STRETCH',
                        style: {
                            color: '#606060'
                        }
                    }
                }*/
            }

            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {
                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e)
                                {
                                    var parametrosUrl = {
                                        'inicio': inicio,
                                        'fin': fin,
                                        /*'pais': pais,
                                         'cu': cu,*/
                                        'selected_item': categoria[this.x],
                                        'selected_serie': this.series.name
                                    };
                                    if (rawData != null)
                                    {
                                        parametrosUrl['row'] = rawData[this.x];
                                    }

                                    var prefix = (title == null || title == '') ? '' : title + ' - ';
                                    generateModal(path, parametrosUrl, true, prefix, categoria[this.x],orderArray); //, this.series.name+'='+ this.y);
                                }
                            }
                        }
                    }
                };
            }

            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 valorActual= parseFloat(rawData[k][series[0].name]);

                if (valorActual <= menor){
                    menor = valorActual;
                }*/

                var lastCat = categoria[categoria.length - 1]['sql_name'];

                if (categoria.length>=1){ //Si hay 2 o mas categorias

                    // I. level of categories
                    if (categoria.length >= 1) {
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[0]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });

                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[0]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

                    if (categoria.length >= 3){
                        // II. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

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

                    if (categoria.length >=4){
                        // III. level of categories

                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

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

                    if (categoria.length >=5){
                        // IV. level of categories

                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

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

                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

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


                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;

                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            if (menor >50) menor= 50;
            options.yAxis[0].min=menor;

            return $('#' + render).highcharts(options);
        }
        function calculateTREND(monitor,monitor1,asp){
            var flag=0;
            var strValue="";
            var nuevo = [];
            //para las asp 
            //console.log(asp)
            if (asp!=""){
                $.each(monitor1, function( index, value ) {               
                    $.each(monitor, function( index1, value1 ) {
                        if (value['CUSTOMER']==value1['CUSTOMER'] && value['PROJECT']==value1['PROJECT']  && value['ASP']==value1['ASP']  && value['Date']==value1['Date'] && parseFloat(value['%FTR'])==parseFloat(value1['%FTR'])){
                                //iguales
                                 monitor[index1]['TREND'] =  "<img src='{{ asset('images/equal.png') }}' alt='equal  title='equal'>" ;                                   
                                //console.log(index1,value1,monitor);

                        }else if (value['CUSTOMER']==value1['CUSTOMER'] && value['PROJECT']==value1['PROJECT']  && value['ASP']==value1['ASP']&& value['Date']==value1['Date'] && parseFloat(value1['%FTR'])>parseFloat(value['%FTR'])){ 
                           //mayor
                            monitor[index1]['TREND'] =  "<img src='{{ asset('images/up.png') }}' alt='up  title='up'>" ;
                                                          

                        }else if (value['CUSTOMER']==value1['CUSTOMER'] && value['PROJECT']==value1['PROJECT']  && value['ASP']==value1['ASP']&& value['Date']==value1['Date'] && parseFloat(value1['%FTR'])<parseFloat(value['%FTR'])){
                                //menor
                                monitor[index1]['TREND'] =  "<img src='{{ asset('images/down_red.png') }}' alt='down  title='down'>" ;                   
                            
                        }
                    });
                });   
            }else{
                 $.each(monitor1, function( index, value ) {               
                    $.each(monitor, function( index1, value1 ) {
                        if (value['CUSTOMER']==value1['CUSTOMER'] && value['PROJECT']==value1['PROJECT']  && value['Date']==value1['Date'] && parseFloat(value['%FTR'])==parseFloat(value1['%FTR'])){
                                //iguales
                                 monitor[index1]['TREND'] =  "<img src='{{ asset('images/equal.png') }}' alt='equal  title='equal'>" ;    
                               
                                //console.log(index1,value1,monitor);

                        }else if (value['CUSTOMER']==value1['CUSTOMER'] && value['PROJECT']==value1['PROJECT']  && value['Date']==value1['Date'] && parseFloat(value1['%FTR'])>parseFloat(value['%FTR'])){ 
                           //mayor
                            monitor[index1]['TREND'] =  "<img src='{{ asset('images/up.png') }}' alt='up  title='up'>" ;
                                                          

                        }else if (value['CUSTOMER']==value1['CUSTOMER'] && value['PROJECT']==value1['PROJECT']  && value['Date']==value1['Date'] && parseFloat(value1['%FTR'])<parseFloat(value['%FTR'])){
                                //menor
                                monitor[index1]['TREND'] =  "<img src='{{ asset('images/down_red.png') }}' alt='down  title='down'>" ;                    
                            
                        }
                    });
                });    
            }
                   
            return monitor;
        }
        function destroyGraphs(){
            try{
                $('#grafico_FTR').highcharts().destroy();                      
                $('#grafico_IssuesExecuted').highcharts().destroy();                 
                $('#grafico_ExecutedNotExecuted').highcharts().destroy();                   
                $('#grafico_ExecutedNotExecutedRazones').highcharts().destroy();                                   
                $('#grafico_SystemFaultFound').highcharts().destroy();                    
                $('#grafico_IssuesFound').highcharts().destroy();                                 
                $('#grafico_QualityPerformance').highcharts().destroy();                                 
                $('#grafico_Range').highcharts().destroy(); 
                $('#grafico_ASP').highcharts().destroy(); 
                $('#grafico_OHS').highcharts().destroy();
                $('#grafico_QasExecutedNotExecuted').highcharts().destroy();

                $('#grafico_Kpis').highcharts().destroy(); 
                $('#grafico_KpisPassive').highcharts().destroy(); 
                $('#grafico_KpisRigger').highcharts().destroy(); 
                $('#grafico_VolumenWithAudit').highcharts().destroy(); 
                $('#grafico_VolumenSitesFtrTotal').highcharts().destroy(); 
                $('#grafico_PorcentSitesFtrTotal').highcharts().destroy(); 
                $('#grafico_SitesWithDefects').highcharts().destroy(); 
                $('#grafico_PorcentSitesWithDefects').highcharts().destroy(); 
                $('#grafico_SitesRevisita').highcharts().destroy(); 
                $('#grafico_PorcentSitesRevisita').highcharts().destroy(); 
                $('#grafico_SitesQI').highcharts().destroy(); 
                $('#grafico_SitesQIEricsson').highcharts().destroy(); 

                $('#graficoOnTimeDelivery').highcharts().destroy();  
            }catch(err){
                //console.log(err.message);
            }
        }  
        function charBarras(render,title,data,categories,path,w,rawData,orderArray,parametros,stacking,showInLegend,type,subtitle){
            var series = []; 
            //console.log(render);
            if (render=='grafico_VolumenWithAudit' || render=='grafico_VolumenSitesFtrTotal' || render=='grafico_PorcentSitesFtrTotal' || render=='grafico_SitesWithDefects' || render=='grafico_PorcentSitesWithDefects' || render=='grafico_SitesRevisita' || render=='grafico_PorcentSitesRevisita' || render=='grafico_KpiQasExecutedNotExecuted'){
                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":'#00A9E5',"name":v.name,"data":v.data});  
                            }else if (k==1){ 
                              series.push({"color":'#93D543',"name":v.name,"data":v.data});  
                            }else if (k==2){ 
                              series.push({"color":'#F7A35C',"name":v.name,"data":v.data});  
                            }else if (k==3){ 
                              series.push({"color":'#06AF8F',"name":v.name,"data":v.data});  
                            }else if (k==4){ 
                              series.push({"color":'#632289',"name":v.name,"data":v.data});  
                            }else if (k==5){ 
                              series.push({"color":'#444444',"name":v.name,"data":v.data});  
                            }
                        });
                    });
                }      
            }else if (render=='grafico_Kpis'){
                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":'#7AB1E7',"name":v.name,"data":v.data});  
                            }else if (k==1){ 
                              series.push({"color":'#434348',"name":v.name,"data":v.data});  
                            }else if (k==2){ 
                              series.push({"color":'#90ED7D',"name":v.name,"data":v.data});  
                            }else if (k==3){ 
                              series.push({"color":'red',"name":v.name,"data":v.data});  
                            }
                        });
                    });
                }      
            }else{
                if (data.length>0){
                    var seriesTotal = getDataToObjectSerieAll(data, Object.keys(data[0]));
                    $.each(seriesTotal, function(key, value) {
                        $.each(value, function(k, v) { 
                            series.push({"name":v.name,"data":v.data});
                            
                        });
                    });
                }
            }   
            
            //console.log('cantidad categorias',categories.length);
            var can_cate = categories.length;
            var height = 320;
            if (can_cate>1 && can_cate<=5){
                height = 320;
            }
            if (can_cate>5 && can_cate<=10){
                height = 320;
            }
            if (can_cate>10 && can_cate<=15){
                height = 350;
            }
            if (can_cate>15 && can_cate<=20){
                height = 400;
            }
            var rotation = 0;
            var options = {
                chart: {
                    borderColor: '#428bca',
                    type: type,                    
                    spacingBottom: 5,
                    spacingTop: 5,
                    spacingLeft: 1,
                    spacingRight: 1,
                    height: height,
                    width: null,
                    credits: {
                        enabled: false
                    },
                    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
                },
                subtitle:{
                    text: subtitle
                },
                legend: {
                    //backgroundColor: 'rgba(66, 139, 202, 0.5)'
                },
                xAxis: {
                    categories: categories,
                    title: {
                        text: null
                    },
                    labels: {
                        groupedOptions: [{ // 1st-level
                            //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                            rotation: 0,
                            lineWidth: 1,
                            tickWidth: 1,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            }
                        }, // 2nd-level
                            {
                                //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                rotation: 0,
                                lineWidth: 0,
                                tickWidth: 0,
                                //align: 'right',
                                style: {
                                    fontSize: '9px',
                                    color: '#333333'
                                    //color: '#4c4c4c'
                                }
                            }
                        ],
                        //step: step,
                        lineWidth: 0,
                        tickWidth: 0,
                        rotation: 0,
                        style: {
                            fontSize: '10px',
                            color: '#333333'
                            //color: '#4c4c4c'
                        },
                        formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                            if(this.value.length > 20){
                                return this.value.substring(0, 17) + '...';
                            }
                            return this.value;
                        }
                    },
                },
                yAxis: {
                    min: 0,
                    title: {
                        text: '',
                        align: 'high'
                    },
                    labels: {
                        overflow: 'justify'
                    }
                },
                tooltip: {
                    valueSuffix: ''
                },
                credits: {
                    enabled: false
                },
                series: series
            };
            // OPCIONAL: El path para la tabla detallada
            if (url != null){
                options['plotOptions'] =
                {
                    series:
                    {
                        dataLabels:
                        {
                            enabled: true,
                            enabled: true,
                            formatter: function () {
                                if (this.series.name=='Average QP'){
                                    if (this.point.y!=undefined){
                                        return this.point.y + '%';
                                    }else{
                                         return this.point.y;
                                    }
                                }else{
                                    return this.point.y;
                                }
                            }
                        },
                        point: {
                            events:{
                                click: function (e){
                                    var categoryPath = options.xAxis.categories;
                                    if (path != null){
                                        var selected_serie = this.series.name;
                                        var row = rawData[this.x];
                                        parametros['ftr'] = '';
                                        parametros['revisita'] = '';
                                        parametros['find'] = '';
                                        parametros['qi_tipo'] = '';
                                        parametros['tipo_performed'] = '';
                                        parametros['qi'] = '';
                                        parametros['selected_item'] = '';
                                        parametros['rejected'] = '';
                                        parametros['qp'] = '';
                                        if ($('#cliente').val()!="TODOS"){
                                            parametros['asp'] = row['_cat_Categoria']; 
                                        }else{
                                            parametros['cliente'] = row['_cat_Categoria']; 
                                        }
                                        if (render=='grafico_Kpis' || render=='grafico_KpisPorcentaje'  || render=='grafico_KpisPassive'  || render=='grafico_KpisRigger'  || render=='grafico_KpisRiggerIc'  || render=='grafico_KpisIc'  || render=='grafico_KpisDici'  || render=='grafico_KpisFullDici'){
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = 'Site Quality: KPI - '+categoryPath[this.x];
                                            var subtitle_detalle = this.series.name
                                            parametros['ftr'] = '';
                                            parametros['revisita'] = '';
                                            parametros['qi'] = '';
                                            parametros['find'] = ''; 
                                            parametros['tipo_performed'] = 2; 
                                            parametros['rejected'] = ''; 
                                            parametros['qp'] = ''; 
                                            if (selected_serie=="% of FTR Sites" || selected_serie=="Volume of Sites FTR" || selected_serie=="% of Sites FTR"){
                                                parametros['ftr'] = 1;
                                            }
                                            if (selected_serie=="% of Sites Not FTR" || selected_serie=='Average Number of defects for sites not FTR'){
                                                parametros['ftr'] = 0;   
                                            }
                                            if (selected_serie=='Re visits' || selected_serie=='Average time between revisits'){
                                                parametros['revisita'] = 1;
                                            }
                                            if (selected_serie=='% of Sites NOT cleared of all defects at Audit'){
                                                parametros['find'] = 'NOT CLEARED'; 
                                            }
                                            if (selected_serie=='% SQI <=0.4'){
                                                parametros['qi'] = 1; 
                                            } 
                                            if (selected_serie=='Volume of Sites Requiring Re-Visit' || selected_serie=='% of Sites with defects requiring a revisit'){
                                                parametros['rejected'] = 1; 
                                            } 
                                            parametros['selected_serie'] = this.series.name;
                                            if (render=='grafico_KpisPassive'){
                                                if (selected_serie=='Volume of Auditable Sites (Commissions)'){
                                                    parametros['tipo_performed'] = 2;
                                                }else if(selected_serie=='Volume Of Sites with Audits'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_PASSIVE';
                                                }else if(selected_serie=='Volume of Sites FTR'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_PASSIVE';
                                                    parametros['ftr'] = 1;
                                                }  
                                            }else if (render=='grafico_KpisRigger'){
                                                if (selected_serie=='Volume of Auditable Sites (Commissions)'){
                                                    parametros['tipo_performed'] = 2;
                                                }else if(selected_serie=='Volume Of Sites with Audits'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_RIGGER';
                                                }else if(selected_serie=='Volume of Sites FTR'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_RIGGER';
                                                    parametros['ftr'] = 1;
                                                }  
                                            }else if (render=='grafico_KpisRiggerIc'){
                                                if (selected_serie=='Volume of Auditable Sites (Commissions)'){
                                                    parametros['tipo_performed'] = 2;
                                                }else if(selected_serie=='Volume Of Sites with Audits'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_I/C_RIGGER';
                                                }else if(selected_serie=='Volume of Sites FTR'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_I/C_RIGGER';
                                                    parametros['ftr'] = 1;
                                                }  
                                            }else if (render=='grafico_KpisIc'){
                                                if (selected_serie=='Volume of Auditable Sites (Commissions)'){
                                                    parametros['tipo_performed'] = 2;
                                                }else if(selected_serie=='Volume Of Sites with Audits'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_I/C';
                                                }else if(selected_serie=='Volume of Sites FTR'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_I/C';
                                                    parametros['ftr'] = 1;
                                                }  
                                            }else if (render=='grafico_KpisDici'){
                                                if (selected_serie=='Volume of Auditable Sites (Commissions)'){
                                                    parametros['tipo_performed'] = 2;
                                                }else if(selected_serie=='Volume Of Sites with Audits'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_DICI';
                                                }else if(selected_serie=='Volume of Sites FTR'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_DICI';
                                                    parametros['ftr'] = 1;
                                                }  
                                            }else if (render=='grafico_KpisFullDici'){
                                                if (selected_serie=='Volume of Auditable Sites (Commissions)'){
                                                    parametros['tipo_performed'] = 2;
                                                }else if(selected_serie=='Volume Of Sites with Audits'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_FULLDICI';
                                                }else if(selected_serie=='Volume of Sites FTR'){
                                                    parametros['tipo_performed'] = 1;
                                                    parametros['selected_serie'] = 'QAS_FULLDICI';
                                                    parametros['ftr'] = 1;
                                                }  
                                            }                                        
                                        }
                                        if (render=='grafico_KpiQP'){
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = 'Site Quality: Average ASP Quality Performance - '+categoryPath[this.x];
                                            var subtitle_detalle = selected_serie;
                                            parametros['ftr'] = '';
                                            parametros['revisita'] = '';
                                            parametros['qi'] = '';
                                            parametros['find'] = ''; 
                                            parametros['qp'] = 1; 
                                            

                                        }
                                        if (render=='grafico_VolumenSitesFtrTotal'){
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = 'Site Quality: Volume of Sites FTR - '+categoryPath[this.x];
                                            var subtitle_detalle = selected_serie;
                                            parametros['ftr'] = 1;
                                            parametros['revisita'] = '';
                                            parametros['qi'] = '';
                                            parametros['find'] = '';      
                                            parametros['qp'] = '';                                        
                                            parametros['selected_serie'] = selected_serie;
                                            if (parametros['selected_serie']=='Volume of Sites FTR'){
                                                parametros['tipo_performed'] = 0;
                                            }else{
                                                parametros['tipo_performed'] = 1;
                                            } 
                                        }
                                        if (render=='grafico_PorcentSitesFtrTotal'){
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = '% of FTR Sites - '+categoryPath[this.x];
                                            var subtitle_detalle = selected_serie;
                                            parametros['ftr'] = 1;
                                            parametros['revisita'] = '';
                                            parametros['qi'] = '';
                                            parametros['find'] = '';
                                            parametros['qp'] = ''; 
                                            parametros['selected_serie'] = selected_serie;
                                            if (parametros['selected_serie']=='% Of Sites FTR'){
                                                parametros['tipo_performed'] = 0;
                                            }else{
                                                parametros['tipo_performed'] = 1;
                                            } 
                                        }                                        
                                        if (render=='grafico_SitesWithDefects'){
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = '% of Sites Not FTR - '+categoryPath[this.x];
                                            var subtitle_detalle = selected_serie;
                                            parametros['ftr'] = 0;
                                            parametros['revisita'] = '';
                                            parametros['qi'] = '';
                                            parametros['find'] = ''; 
                                            parametros['qp'] = ''; 
                                            parametros['selected_serie'] = selected_serie;
                                            if (parametros['selected_serie']=='% Of Sites with Defects raised'){
                                                parametros['tipo_performed'] = 2;
                                            }else{
                                                parametros['tipo_performed'] = 1;
                                            }                                          
                                        }
                                        if (render=='grafico_PorcentSitesWithDefects'){
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = 'Site Quality: Average Number of defects for sites not FTR - '+categoryPath[this.x];
                                            var subtitle_detalle = selected_serie;
                                            parametros['ftr'] = 0;
                                            parametros['revisita'] = '';
                                            parametros['qi'] = '';
                                            parametros['find'] = ''; 
                                            parametros['qp'] = ''; 
                                            parametros['selected_serie'] = selected_serie;
                                            if (parametros['selected_serie']=='Average Number of defects for sites not FTR'){
                                                parametros['tipo_performed'] = 2;
                                            }else{
                                                parametros['tipo_performed'] = 1;
                                            }                                      
                                        }   
                                        if (render=='grafico_SitesRevisita'){
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = 'Site Quality: Re-visits - '+categoryPath[this.x];
                                            var subtitle_detalle = selected_serie;
                                            parametros['ftr'] = '';
                                            parametros['revisita'] = 1;
                                            parametros['qi'] = '';                                            
                                            parametros['qp'] = '';  
                                            parametros['rejected'] = ''; 
                                            parametros['selected_serie'] = selected_serie;
                                            if (parametros['selected_serie']=='Re visits'){
                                                parametros['tipo_performed'] = 2;
                                            }else{
                                                parametros['tipo_performed'] = 1;
                                            }     
                                        }  
                                        if (render=='grafico_PorcentSitesRevisita'){
                                            parametros['kpi'] = "detalle_kpis";
                                            parametros['selected_serie'] = this.series.name;
                                            var title_detalle = 'Site Quality: Average time between Re-visits - '+categoryPath[this.x];
                                            var subtitle_detalle = selected_serie;
                                            parametros['ftr'] = '';
                                            parametros['revisita'] = 1;
                                            parametros['qi'] = '';
                                            parametros['find'] = ''; 
                                            parametros['qp'] = ''; 
                                            parametros['rejected'] = ''; 
                                            parametros['selected_serie'] = selected_serie;
                                            if (parametros['selected_serie']=='Average days between revisits'){
                                                parametros['tipo_performed'] = 2;
                                            }else{
                                                parametros['tipo_performed'] = 1;
                                            } 
                                        } 
                                        if (render=='grafico_KpiQasExecutedNotExecuted'){
                                            var row = rawData[this.x];  
                                            parametros['kpi'] = "detalle_kpis";
                                            parametros['selected_item'] = row._cat_Categoria;
                                            var title_detalle = '% QAS Executed - '+parametros['selected_item'];
                                            var subtitle_detalle = selected_serie;
                                            parametros['ftr'] = '';
                                            parametros['revisita'] = '';
                                            parametros['qi'] = '';
                                            parametros['find'] = '';
                                            parametros['qp'] = ''; 
                                            parametros['selected_serie'] = selected_serie;
                                            if (parametros['selected_serie']=='Commissioned'){
                                                parametros['tipo_performed'] = 2;
                                            }else{
                                                parametros['tipo_performed'] = 1;
                                            }
                                        }                                         

                                        parametros['selected_item'] = categoryPath[this.x];
                                        
                                        if (rawData != null)
                                        {
                                            parametros['row'] = rawData[this.x];
                                        }          
                                        //console.log(path, parametros, false, title_detalle, categoryPath[this.x], orderArray)
                                        generateModal(path, parametros, false, title_detalle, subtitle_detalle,orderArray);
                                    }
                                }
                            }
                        }
                    }
                };
            }
             
            return $('#'+render).highcharts(options);
        }  

        function createChartColumnPeq(render, categoria, series, title, w,
                                   inicio, fin, pais, orderArray, path, rawData,parametros,subtitle)
        {
            //ajustar la serie para la doble axies
            //colors: ['#275f76', '#00A9E5', '#93D543'],   
            var arrayReturn = new Array();
            var data = new Array();           
            if (render=='grafico_DefectFixedFind' || render=='grafico_FixedFind'){
                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){ //limpiado
                              data.push({"color":'#93D543',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==2){ //Not limpiado
                              data.push({"color":'#F44336',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else{
                                data.push({"color":'#1B5B96',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});
                            }                     
                            
                        });
                    });
                }      
            }    
            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 = 320;
            switch (render){ 
                case 'grafico_FixedFind':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "detalle_kpis";
                    break; 
                case 'grafico_DefectFixedFind':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "detalle_kpis";
                    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: subtitle
                  },
                  //enableMouseTracking : false,
                  xAxis: {
                        categories: [],
                        lineWidth: 1,
                        lineColor: '#4c4c4c',
                        labels: {
                            groupedOptions: [{ 
                                rotation: 0,
                                lineWidth: 1,
                                tickWidth: 1,
                                style: {
                                    fontSize: '10px',
                                    color: '#333333'
                                }
                            }, 
                                {                                    
                                    rotation: 0,
                                    lineWidth: 0,
                                    tickWidth: 0,
                                    style: {
                                        fontSize: '9px',
                                        color: '#333333'
                                    }
                                }
                            ],
                            lineWidth: 0,
                            tickWidth: 0,
                            rotation: 0,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            },
                            formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                                if(this.value.length > 20){
                                    return this.value.substring(0, 17) + '...';
                                }
                                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: 1000
                        },
                        chartOptions: {
                            legend: {
                                align: 'center',
                                verticalAlign: 'bottom',
                                layout: 'horizontal'
                            },
                            yAxis: {
                                labels: {
                                    align: 'left',
                                    x: 0,
                                    y: -5
                                },
                                title: {
                                    text: null
                                }
                            },
                            subtitle: {
                                text: null
                            },
                            credits: {
                                enabled: false
                            }
                        }
                    }]
                },
                 legend: {
                        backgroundColor: 'rgba(66, 139, 202, 0.5)'
                    },
                  yAxis: [{ // Primary yAxis
                    plotLines: [
                        {
                            value: 0,
                            width: 1,
                            color: '#808080'
                        }
                    ],
                    title: {
                      text: 'Count',                      
                    }, 
                    min: 0,
                    //tickPositions: [0,5,10,20,30],
                    labels: {
                        format: "{value}"
                    },   
                  }, { // Secondary yAxis
                    title: {
                      text: 'Percent (%)',                      
                    }, 
                    min: 0,
                    tickPositions: [0,25,50,75,100],
                    opposite: true,
                    labels: {
                        format: "{value}%"
                    },                  
                    opposite: true
                  }],
                  tooltip: {
                    shared: false
                  },
                  //colors: ['#93D543','#00A9E5'],    
                  colors: ['#275f76', '#00A9E5', '#93D543'],                  
                  series: data
            };

            // 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=='%'){
                                    if (this.point.y!=undefined){
                                        return this.point.y + '%';
                                    }else{
                                        return 0;
                                    }
                                }else{
                                    return this.point.y;
                                }
                            }
                        },
                        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;    
                                        var row = rawData[this.x];              
                                        parametros['ftr'] = '';
                                        parametros['revisita'] = '';
                                        parametros['find'] = '';
                                        parametros['qi_tipo'] = '';
                                        parametros['tipo_performed'] = '';
                                        parametros['qi'] = '';
                                        parametros['selected_item'] = '';
                                        parametros['rejected'] = '';
                                        parametros['qp'] = '';                         
                                        if (render=='grafico_DefectFixedFind'){
                                            if ($('#cliente').val()!="TODOS"){
                                                parametros['asp'] = row['_cat_Categoria']; 
                                            }else{
                                                parametros['cliente'] = row['_cat_Categoria']; 
                                            }
                                            var selected_serie = this.series.name;            
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = 'Defects Fixed on Find - '+row._cat_Categoria;
                                            var subtitle_detalle = selected_serie;
                                            if (selected_serie=='Defects' || selected_serie=='%'){
                                                parametros['find'] = 'Defects';
                                            }else if(selected_serie=='Cleared'){
                                                parametros['find'] = 'Cleared';
                                            }else if(selected_serie=='Not Cleared'){
                                                parametros['find'] = 'Not Cleared';
                                            }
                                        }  
                                        if (render=='grafico_FixedFind'){
                                            if ($('#cliente').val()!="TODOS"){
                                                parametros['asp'] = row['_cat_Categoria']; 
                                            }else{
                                                parametros['cliente'] = row['_cat_Categoria']; 
                                            }
                                            var selected_serie = this.series.name;
                                            var row = rawData[this.x];  
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = 'Sites Fixed on Find - '+row._cat_Categoria;
                                            var subtitle_detalle = selected_serie;
                                            if (selected_serie=='Sites with Defects' || selected_serie=='%'){
                                                parametros['find'] = 'Defects';
                                            }else if(selected_serie=='Sites Cleared of All Defects'){
                                                parametros['find'] = 'Cleared';
                                            }else if(selected_serie=='Sites not Cleared of All Defects'){
                                                parametros['find'] = 'Not Cleared';
                                            }
                                        }      
                                        //parametros['selected_serie'] = '';
                                        generateModal(path, parametros, false,  title_detalle, subtitle_detalle, orderArray);
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }
            var num = categoria.length;
            var baseMargin = render=='graficoDashAsp' ? 170 : 90;
            var marginBottom = baseMargin + ((num-1) * 20);
            var menor = series[1];
            var mayor = series[2];
            options.chart.marginBottom = marginBottom;


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

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

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

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

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[4]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[4]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            return $('#' + render).highcharts(options);        
        }  
        function createChartColumnPeqSinPorcentaje(render, categoria, series, title, w,
                                   inicio, fin, pais, orderArray, path, rawData,parametros,subtitle)
        { 
            var arrayReturn = new Array();
            var data = new Array();  
            if (render=='grafico_SitesQI'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(k==0){ //Executed
                               data.push({"color":'#1EB24D',"name":v.name,"data":v.data,type: 'column'});  
                            }else if (k==1){ //Not Executed
                              data.push({"color":'#ED1B24',"name":v.name,"data":v.data,type: 'column'});  
                            }else{
                                //data.push({"name":"% QI","data":v.data});
                            }                      
                            
                        });
                    });
                }      
            } 
            if (render=='grafico_SitesQIEricsson'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(k==0){ //Executed
                               data.push({"color":'#1EB24D',"name":v.name,"data":v.data,type: 'column'});  
                            }else if (k==1){ //Not Executed
                              data.push({"color":'#ED1B24',"name":v.name,"data":v.data,type: 'column'});  
                            }else{
                                //data.push({"name":"% QI","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 = 320;                
            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
                  },
                  //enableMouseTracking : false,
                  xAxis: {
                        categories: [],
                        lineWidth: 1,
                        lineColor: '#4c4c4c',
                        labels: {
                            groupedOptions: [{ 
                                rotation: 0,
                                lineWidth: 1,
                                tickWidth: 1,
                                style: {
                                    fontSize: '10px',
                                    color: '#333333'
                                }
                            }, 
                                {                                    
                                    rotation: 0,
                                    lineWidth: 0,
                                    tickWidth: 0,
                                    style: {
                                        fontSize: '9px',
                                        color: '#333333'
                                    }
                                }
                            ],
                            lineWidth: 0,
                            tickWidth: 0,
                            rotation: 0,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            },
                            formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                                if(this.value.length > 20){
                                    return this.value.substring(0, 17) + '...';
                                }
                                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: 1000
                        },
                        chartOptions: {
                            legend: {
                                align: 'center',
                                verticalAlign: 'bottom',
                                layout: 'horizontal'
                            },
                            yAxis: {
                                labels: {
                                    align: 'left',
                                    x: 0,
                                    y: -5
                                },
                                title: {
                                    text: null
                                }
                            },
                            subtitle: {
                                text: null
                            },
                            credits: {
                                enabled: false
                            }
                        }
                    }]
                },
                 legend: {
                        backgroundColor: 'rgba(66, 139, 202, 0.5)'
                    },
                  yAxis: [{ // Primary yAxis
                    plotLines: [
                        {
                            value: 0,
                            width: 1,
                            color: '#808080'
                        }
                    ],
                    title: {
                      text: 'Count',
                      style: {
                        color: Highcharts.getOptions().colors[1]
                      }
                    }
                  }],
                  tooltip: {
                    shared: false
                  },
                  //colors: ['#93D543','#00A9E5'],    
                  colors: ['#275f76', '#00A9E5', '#93D543'],                  
                  series: data
            };

            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {
                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];  
                                        //console.log(row,rawData);
                                        parametros['ftr'] = '';
                                        parametros['revisita'] = '';
                                        parametros['find'] = '';
                                        parametros['qi_tipo'] = '';
                                        parametros['tipo_performed'] = '';
                                        parametros['qi'] = '';
                                        parametros['selected_item'] = '';
                                        parametros['rejected'] = '';
                                        parametros['qp'] = '';
                                        var categoriaDetalle =  row['_cat_Categoria'];
                                        var selected_serie = this.series.name;
                                        var row = rawData[this.x];
                                        if (render=='grafico_SitesQI'){  

                                            if ($('#cliente').val()!="TODOS"){
                                                parametros['asp'] = row['_cat_Categoria']; 
                                            }else{
                                                parametros['cliente'] = row['_cat_Categoria']; 
                                            }              
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = 'Site Quality Index - For Customer - '+row._cat_Categoria;
                                            var subtitle_detalle = selected_serie;
                                            parametros['ftr'] = '';
                                            parametros['revisita'] = '';
                                            parametros['find'] = '';
                                            parametros['qi_tipo'] = 0;//clien                                         
                                            parametros['tipo_performed'] = 2;
                                            if (selected_serie=='SQI <= 0.4'){
                                                parametros['qi'] = 1;
                                            }else if(selected_serie=='SQI > 0.4'){
                                                parametros['qi'] = 0;
                                            }else if(selected_serie=='% SQI'){
                                                $.isLoading("hide");
                                                return false;
                                            }
                                        }   
                                        if (render=='grafico_SitesQIEricsson'){  
                                            if ($('#cliente').val()!="TODOS"){
                                                parametros['asp'] = row['_cat_Categoria']; 
                                            }else{
                                                parametros['cliente'] = row['_cat_Categoria']; 
                                            }       
                                            parametros['kpi'] = "detalle_kpis";
                                            var title_detalle = 'Site Quality Index - For Ericsson - '+row._cat_Categoria;
                                            var subtitle_detalle = selected_serie;
                                            parametros['ftr'] = '';
                                            parametros['revisita'] = '';
                                            parametros['find'] = '';
                                            parametros['qi_tipo'] = 1;//eric   
                                            parametros['tipo_performed'] = 2;
                                            if (selected_serie=='SQI <= 0.4'){
                                                parametros['qi'] = 1;
                                            }else if(selected_serie=='SQI > 0.4'){
                                                parametros['qi'] = 0;
                                            }else if(selected_serie=='% SQI'){
                                                $.isLoading("hide");
                                                return false;
                                            }
                                        }                                                  
                                        parametros['selected_item'] = categoriaDetalle;
                                        generateModal(path, parametros, false,  title_detalle, subtitle_detalle, orderArray);
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }
            var num = categoria.length;
            var baseMargin = render=='graficoDashAsp' ? 170 : 90;
            var marginBottom = baseMargin + ((num-1) * 20);
            var menor = series[1];
            var mayor = series[2];
            options.chart.marginBottom = marginBottom;


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

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

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

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

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[4]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[4]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            return $('#' + render).highcharts(options);        
        }  
        //exportar excel
        function ExportExcelUki(kpi) {
          $("#kpi_exportar_excel").val(kpi);            
          document.forms['formulario_filtros'].action="{{path('aspir_ExcelDetalleUki')}}";
          document.forms['formulario_filtros'].submit();
        }        

    </script>
    <div class="container-fluid">
        <form id="formulario_filtros" onsubmit="return false;">
            <div class="panel panel-primary">
                <div class="panel-heading">
                    <h3 class="panel-title"><a data-toggle="collapse" href="#collapse1">Filters <span class="caret"></span></a></h3>
                </div>
                <div id="collapse1" class="panel-collapse collapse in">
                    <div id="panelFilter" class="panel-body">
                       
                            <input type="hidden" name="mes_seleccionado" id="mes_seleccionado" value="">
                            <input type="hidden" name="pais_seleccionado" id="pais_seleccionado" value="">
                            <input type="hidden" name="cliente_seleccionado" id="cliente_seleccionado" value="">
                            <input type="hidden" name="proyecto_seleccionado" id="proyecto_seleccionado" value="">
                            <input type="hidden" name="asp_seleccionado" id="asp_seleccionado" value="">
                            <input type="hidden" name="selected_item_seleccionado" id="selected_item_seleccionado" value="">
                            <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="">
                            <input type="hidden" name="asp_user" id="asp_user" value="{{ data_user.asp_user }}">
                            <div class="row"> 
                            <input type="hidden" class="form-control" id="kpi_exportar_excel" name="kpi_exportar_excel" value="">
                                <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 id="paisTodos" class="col-md-4 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>{{'monitores.pais' | trans}}: </label>
                                        <select class="form-control get-list" id="pais" name="pais" data='cliente'
                                        data-act='refresh_pais' data-campo-filtro='country' data-campo-mostrar='customer'>
                                            <option value="TODOS">-- All -- </option>
                                            {%for country in countrys %}
                                                <option value="{{country.valor}}">{{country.nombre}}</option>
                                            {%endfor%}
                                        </select>
                                    </div>
                                </div>                       
                                <div id="div_cliente" class="col-md-4 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>{{'monitores.cliente' | trans}}: </label>
                                        <select class="form-control get-list cliente refresh_pais" id="cliente" name="cliente" data='asp' data-campo-filtro='customer' data-campo-mostrar='asp' data-act='refresh_cliente'>
                                            <option value="TODOS">-- All --</option>
                                        </select>
                                    </div>
                                </div>
                                <div id="div_cliente" class="col-md-4 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>{{'ASP' | trans}}: </label>
                                        <select class="form-control get-list  asp refresh_pais refresh_cliente refresh_proyecto" id="asp" name="asp" data='proyecto' data-campo-filtro='asp' data-campo-mostrar='project' data-act='refresh_asp'>
                                            <option value="TODOS">-- All -- </option>                                           
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="row">  
                                <div id="div_proyecto" class="col-md-4 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>{{'monitores.proyecto' | trans}}: </label>
                                        <select class="form-control proyecto refresh_pais refresh_cliente refresh_asp" id="proyecto" name="proyecto">
                                            <option value="TODOS">-- All --</option>
                                        </select>
                                    </div>
                                </div>  
                                <div class="col-md-2 col-sm-6 col-xs-12" id="parametros">
                                    <div class="form-group">
                                        <label for="generar">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</label>
                                        <button class="btn btn-primary form-control" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
                                    </div>
                                </div>
                                <div class="col-md-6 col-sm-6 col-xs-12" id="parametros">
                                    <div class="form-group">
                                        
                                    </div>
                                </div>
                            </div>
                            </div> 
                        </div>                        
                    </div>
                
           
        </form>
</div>
        <div class="row">
            <div class="col-md-12 text-center">
                <h1 class="text-center text-primary">
                    <i class="fa fa-file-text-o"></i> <strong>MELA ASP MANAGEMENT INTEGRATED REPORTING</strong>
                </h1>
            </div>
        </div> 
        <div class="row">
            <div id="panel_content" class="col-lg-12">
                <div class="panel with-nav-tabs panel-primary">
                    <div class="panel-heading">
                        <ul class="nav nav-tabs" id="myTabs">
                                <!--OTD ON TIME DELIVERY -->
                                <li role="presentation" id="tabsOtd" class="click_tab" data-filtro="div_fechaIni div_fechaFin paisTodos clusterTodos div_proyecto div_cliente div_asp"><a data-toggle="tab" href="#_tabsOtd"><strong>OTD (On Time Delivery)</strong></a></li>   

                                <!--First Time Right -->
                                <li role="presentation" id="tabsFTR" class="click_tab"  data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsFTR"><strong>FTR</strong> (First Time Right)</a></li>

                                <!--First Summary -->
                                <li role="presentation" id="tabsFTRSummary" class="click_tab"  data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsFTRSummary">
                                        <strong>Site Quality UKI Summary</strong>
                                </a></li>

                                <!--First Ranking -->
                                <li role="presentation" id="tabsRange" class="click_tab"  data-filtro="div_fechaIni div_fechaFin paisTodos clusterTodos div_proyecto div_cliente div_asp"><a data-toggle="tab" href="#_tabsRange"><strong>FTR</strong> Aggregated</a></li>

                                <!--ASP FTR Dashboard-->
                                <li role="presentation" id="tabsASP" class="click_tab"  data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsASP"><strong>ASP FTR</strong> Dashboard</a></li> 

                                <!--System Fault Found-->
                                <li role="presentation" id="tabsSystemFaultFound" class="click_tab"  data-filtro="div_fechaIni div_fechaFin paisTodos clusterTodos div_proyecto div_cliente div_asp" class="reloadGrafica exportar_excel" data="DETALLE_DEFECTS"><a data-toggle="tab" href="#_tabsSystemFaultFound"><strong>Defects Found – Categories</strong></a></li>

                                <!--Issues Found-->
                                <li role="presentation" id="tabsIssuesFound" class="click_tab"  data-filtro="div_fechaIni div_fechaFin paisTodos clusterTodos div_proyecto div_cliente div_asp" class="reloadGrafica"><a data-toggle="tab" href="#_tabsIssuesFound"><strong>Issues Found</strong></a></li>  

                                <!--Quality Performance-->
                                <li role="presentation" id="tabsQualityPerformance" class="click_tab"  data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsQualityPerformance"><strong>QP</strong> (Quality Performance)</a></li>

                                <!--QAS Executed Vs Not Executed -->
                                <li role="presentation" id="tabsQasExecutedNotExecuted" class="click_tab"  data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsQasExecutedNotExecuted"><strong>QAS Executed Vs Not Executed</strong></a></li> 

                                <!--OHS-->
                                <li role="presentation" id="tabsOHS" class="click_tab"  data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsOHS"><strong>OHS</strong></a></li>

                                <!--OHS Executed Vs Not Executed -->
                                <li role="presentation" id="tabsExecutedNotExecuted" class="click_tab"  data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsExecutedNotExecuted"><strong>OHS Executed Vs Not Executed</strong></a></li>  

                                <!--OHS Issues While Executing 
                                <li role="presentation" id="tabsIssuesExecuted" class="click_tab"  data-filtro="div_fechaIni div_fechaFin paisTodos clusterTodos div_proyecto div_cliente div_asp" class="reloadGrafica"><a data-toggle="tab" href="#_tabsIssuesExecuted"><strong>OHS Issues While Executing</strong></a></li>-->

                                <!--OHS Not Executed Reasons
                                 <li role="presentation" id="tabsNotExecutedReasons" class="click_tab"  data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsNotExecutedReasons"><strong>OHS Not Executed Reasons </strong></a></li>--> 

                                <!--OHS  Executive Audit Summary -->
                                 <li role="presentation" id="tabsExecutiveAuditSummary" class="click_tab"  data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsExecutiveAuditSummary"><strong>OHS Executive Audit Summary</strong></a></li> 
                                                                
                        </ul>
                    </div>
                    <div class="panel-body">
                        <div class="tab-content">
                                <div id="_tabsOtd" class="tab-pane fade">                    
                                    <div class="row" id="chartcontainer_FirstTimeRightHotProject">
                                        <div id="graficoOnTimeDelivery" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_01" class="col-sm-12">
                                            <table id="table_01" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_01"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                                <!--FTR-->
                                <div id="_tabsFTR" class="tab-pane fade"> 
                                    <div class="row" id="chartcontainer_FTR">
                                        <div id="grafico_FTR" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_FTR" class="col-sm-12">
                                            <table id="table_FTR" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_FTR"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div> 
                                <!--FTR Summary -->
                                <div id="_tabsFTRSummary" class="tab-pane fade"> 

                                    <div class="row">
                                        <div class="col-lg-6" style="display:true" id="kpi1" style="width: 100%; min-width: 320px;">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">FTR</div>
                                                  <div class="panel-body" id="grafico_Kpis" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>  
                                        <div class="col-lg-6" style="display:true" id="kpi01" style="width: 100%; min-width: 320px;">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">% FTR</div>
                                                  <div class="panel-body" id="grafico_KpisPorcentaje" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>                                  
                                    </div>
                                    <div class="row">  
                                        <div class="col-lg-6" style="display:true">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Sites Fixed on Find</div>
                                                  <div class="panel-body" id="grafico_FixedFind" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>
                                        <div class="col-lg-6" style="display:true">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Defects Fixed on Find</div>
                                                  <div class="panel-body" id="grafico_DefectFixedFind" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>
                                    </div>       
                                    <div class="row">   
                                        <div class="col-lg-12" style="display:true" id="kpi92">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Site Quality Average ASP Quality Performance</div>
                                                  <div class="panel-body" id="grafico_KpiQP" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>                                     
                                        
                                         
                                    </div>                             
                                    <div class="row">
                                        <div class="col-lg-6" style="display:true" id="kpi91">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Site Quality Index - For Customer</div>
                                                  <div class="panel-body" id="grafico_SitesQI" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>
                                        <div class="col-lg-6" style="display:true" id="kpi9">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Site Quality Index - For Ericsson</div>
                                                  <div class="panel-body" id="grafico_SitesQIEricsson" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div> 
                                            
                                                                   
                                    </div>
                                    <div class="row"> 
                                        <div class="col-lg-6" style="display:true" id="kpiIc" style="width: 100%; min-width: 320px;">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">FTR IC</div>
                                                  <div class="panel-body" id="grafico_KpisIc" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div> 
                                        <div class="col-lg-6" style="display:true" id="kpiRigger" style="width: 100%; min-width: 320px;">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">FTR Rigger</div>
                                                  <div class="panel-body" id="grafico_KpisRigger" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>
                                                                      
                                    </div>
                                    <div class="row"> 
                                        <div class="col-lg-6" style="display:true" id="kpiPass" style="width: 100%; min-width: 320px;">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">FTR Passive</div>
                                                  <div class="panel-body" id="grafico_KpisPassive" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>   
                                        <div class="col-lg-6" style="display:true" id="kpi2">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">% QAS Executed</div>
                                                  <div class="panel-body" id="grafico_KpiQasExecutedNotExecuted" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>    
                                        
                                                                
                                    </div>
                                     <div class="row"> 
                                        <div class="col-lg-6" style="display:true" id="kpiDici" style="width: 100%; min-width: 320px;">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">FTR DICI</div>
                                                  <div class="panel-body" id="grafico_KpisDici" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>   
                                        <div class="col-lg-6" style="display:true" id="kpiFull" style="width: 100%; min-width: 320px;">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">FTR FULL_DICI</div>
                                                  <div class="panel-body" id="grafico_KpisFullDici" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>                                  
                                    </div>
                                    <div class="row">  
                                        <div class="col-lg-6" style="display:true" id="kpi21">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Volume Of Sites with Audits</div>
                                                  <div class="panel-body" id="grafico_VolumenWithAudit" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>      
                                        <div class="col-lg-6" style="display:true" id="kpi3">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Volume of Sites FTR</div>
                                                  <div class="panel-body" id="grafico_VolumenSitesFtrTotal" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>               
                                                                                 
                                    </div>
                                    <div class="row">    
                                        <div class="col-lg-6" style="display:true" id="kpi4">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">% of FTR Sites</div>
                                                  <div class="panel-body" id="grafico_PorcentSitesFtrTotal" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>   
                                        <div class="col-lg-6" style="display:true" id="kpi5">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Sites with Defects raised</div>
                                                  <div class="panel-body" id="grafico_SitesWithDefects" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>               
                                                               
                                    </div>
                                    <div class="row">  
                                        <div class="col-lg-6" style="display:true" id="kpi6">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Average Number of defects for sites not FTR</div>
                                                  <div class="panel-body" id="grafico_PorcentSitesWithDefects" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div> 
                                        <div class="col-lg-6" style="display:true" id="kpi7">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Site Quality: Re-visits</div>
                                                  <div class="panel-body" id="grafico_SitesRevisita" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>
                                    </div>
                                    <div class="row">                                       
                                        <div class="col-lg-6" style="display:true" id="kpi8">
                                              <div class="panel panel-primary" >
                                                  <div class="panel-heading">Site Quality: Average days between Re-visits</div>
                                                  <div class="panel-body" id="grafico_PorcentSitesRevisita" style="width:45.5%">

                                                  </div>
                                              </div>
                                        </div>
                                        <div class="col-lg-6" style="display:true" id="kpi8">
                                              
                                        </div>
                                    </div>

                                    <!--<div class="row">
                                        
                                        <div class="col-lg-6" style="display:true" id="kpi11">
                                        </div>
                                    </div>-->
                                    <div class="row">
                                        <div id="datatable_kpis" class="col-sm-12">
                                            <table id="table_kpis" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_kpis"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                                <!--FTR Ranking-->
                                <div id="_tabsRange" class="tab-pane fade">
                                    <div class="row" id="chartcontainer_Range">
                                        <div id="grafico_Range" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_Range" class="col-sm-12">
                                            <table id="table_Range" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_Range"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                                <!--FTR ASP Dashboadr-->
                                <div id="_tabsASP" class="tab-pane fade">
                                    <div class="row">
                                        <div id="grafico_ASP" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_ASP" class="col-sm-12">
                                            <table id="table_ASP" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_ASP"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                                <!--System fault-->
                                <div id="_tabsSystemFaultFound" class="tab-pane fade">
                                    <div class="col-md-12 text-right" id="DETALLE_DEFECTS">
                                        <div class="dt-buttons">
                                            <a class="dt-button" tabindex="0" aria-controls="tableModalDetalle" id="excel" href="javascript:ExportExcelUki('DETALLE_DEFECTS')">
                                            <span class="dt-button export-excel-issus">Table Excel</span>
                                            </a>
                                        </div>
                                    </div>
                                    <div class="row" style="margin: 10px 0 40px 0px;">
                                        <div id="table_SystemFaultFound" class="col-sm-12">
                                            <table class="display cell-border compact stripe dataTable no-footer" style="width: 50%">
                                                <tr style="background-color: #3071a9;color: #fff;">
                                                    <th class="text-center">Category</th>
                                                    <th class="text-center">Issue</th>
                                                    <th class="text-center">Count</th>
                                                </tr>
                                                <tr>
                                                    <td>Failed</td>
                                                    <td>Listed in Graph</td>
                                                    <td class="text-center" id="total_sitios"></td>
                                                </tr>
                                            </table>
                                        </div>
                                    </div> 
                                    <div class="row" id="chartcontainer_SystemFaultFound">
                                        <div id="grafico_SystemFaultFound" class="col-md-12">
                                        </div>
                                    </div>                     
                                </div>
                                <!--Issues-->
                                <div id="_tabsIssuesFound" class="tab-pane fade">
                                    <div class="col-md-12 text-right" id="DETALLE_ISSUES">
                                        <div class="dt-buttons">
                                            <a class="dt-button" tabindex="0" aria-controls="tableModalDetalle" id="excel" href="javascript:ExportExcelUki('DETALLE_ISSUES')">
                                            <span class="dt-button export-excel-issus">Table Excel</span>
                                            </a>
                                        </div>
                                    </div>
                                    <div class="row" id="chartcontainer_IssuesFound">
                                        <div id="grafico_IssuesFound" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>                                
                                </div> 
                                <!--QP-->    
                                <div id="_tabsQualityPerformance" class="tab-pane fade">
                                    <div class="row">
                                        <div id="grafico_QualityPerformance" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_QualityPerformance" class="col-sm-12">
                                            <table id="table_QualityPerformance" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_QualityPerformance"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div> 
                                <!--QAS Executed Vs Not Executed -->
                                <div id="_tabsQasExecutedNotExecuted" class="tab-pane fade">  
                                    <div class="row" id="chartcontainer_QasExecutedNotExecuted">
                                        <div id="grafico_QasExecutedNotExecuted" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_QasExecutedNotExecuted" class="col-sm-12">
                                            <table id="table_QasExecutedNotExecuted" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_QasExecutedNotExecuted"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>                                     
                                <!--OHS-->    
                                <div id="_tabsOHS" class="tab-pane fade">
                                    <div class="row">
                                        <div id="grafico_OHS" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_OHS" class="col-sm-12">
                                            <table id="table_OHS" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_OHS"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>    
                                <!--Executed Vs Not Executed -->
                                <div id="_tabsExecutedNotExecuted" class="tab-pane fade">  
                                    <div class="col-md-12 text-right" id="mostrar_excel_issues_ohs">
                                        <div class="dt-buttons">
                                            <a class="dt-button" tabindex="0" aria-controls="tableModalDetalle" id="excelIssuesOhs" href="javascript:ExportExcelIssuesOhs()">
                                            <span class="dt-button export-excel-issus">Excel OHS Reasons Not Executed</span>
                                            </a>
                                        </div>
                                    </div>
                                    <div class="row" id="chartcontainer_ExecutedNotExecuted">
                                        <div id="grafico_ExecutedNotExecuted" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_ExecutedNotExecuted" class="col-sm-12">
                                            <table id="table_ExecutedNotExecuted" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_ExecutedNotExecuted"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>      
                                 <!--ISSUES EXECUTED 
                                <div id="_tabsIssuesExecuted" class="tab-pane fade"> 
                                    <div class="row" id="chartcontainer_IssuesExecuted">
                                        <div id="grafico_IssuesExecuted" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_IssuesExecuted" class="col-sm-12">
                                            <table id="table_IssuesExecuted" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_tableIssuesExecuted"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>-->                            
                                <!--Executed Not Executed Razones                            
                                <div id="_tabsNotExecutedReasons" class="tab-pane fade">  
                                    <div class="row" id="chartcontainer_NotExecutedReasons">
                                        <div id="grafico_ExecutedNotExecutedRazones" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>                                
                                </div>--> 
                                <!--Executive Audit Summary-->                            
                                <div id="_tabsExecutiveAuditSummary" class="tab-pane fade">
                                    <!--Number of RSA Calls Audit Taken Place per ASP-->
                                    <div class="row">
                                        <div id="grafico_ExecutiveAuditSummary_Calls0" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_ExecutiveAuditSummary_Calls0" class="col-sm-12">
                                            <table id="table_ExecutiveAuditSummary_Calls0" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_ExecutiveAuditSummary_Calls0"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                    <!--Number of RSA Calls Audit Taken Place per ASP-->
                                    <div class="row">
                                        <div id="grafico_ExecutiveAuditSummary_Calls1" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_ExecutiveAuditSummary_Calls1" class="col-sm-12">
                                            <table id="table_ExecutiveAuditSummary_Calls1" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_ExecutiveAuditSummary_Calls1"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                    <!--Number of RSA Calls Audit Taken Place per ASP-->
                                    <div class="row">
                                        <div id="grafico_ExecutiveAuditSummary_Calls2" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_ExecutiveAuditSummary_Calls2" class="col-sm-12">
                                            <table id="table_ExecutiveAuditSummary_Calls2" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_ExecutiveAuditSummary_Calls2"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                    <!--Number of RSA Calls Audit Taken Place per ASP-->
                                    <div class="row">
                                        <div id="grafico_ExecutiveAuditSummary_Calls3" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>
                                    <div class="row">
                                        <div id="datatable_ExecutiveAuditSummary_Calls3" class="col-sm-12">
                                            <table id="table_ExecutiveAuditSummary_Calls3" class="display nowrap" width="100%">
                                                <thead>
                                                <tr></tr>
                                                </thead>
                                                <tbody id="tbody_ExecutiveAuditSummary_Calls3"></tbody>
                                            </table>
                                        </div>
                                    </div>
                                    <!--Number of audits passed and failed-->  
                                    <div class="row" style="margin-top: 40px;">
                                        <div id="grafico_ExecutiveAuditSummary_PassedAndFailed" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div> 
                                    <!--Sites Non-Conformance-->
                                    <div class="row" style="margin-top: 40px;">
                                        <div id="grafico_ExecutiveAuditSummary_SitesNonConformance" class="col-md-12" style="width: 100%; min-width: 320px;">
                                        </div>
                                    </div>                                
                                </div>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-md-12" id="parametros">
                            <label class="control-label">Last Update:</label> <label class="control-label">OTD:</label> {{data_carga.date_carga_otd}} <label class="control-label">QAS:</label> {{data_carga.date_carga_qas}} <label class="control-label">OHS:</label> {{data_carga.date_carga_ohs}} 
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>    
    <!-- Modal -->
    <div class="modal fade" id="modalDetalleOtd" tabindex="-1" role="dialog" aria-labelledby="DetalleOtd">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header btn-claro">
                    <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="modalDetalleOtdTitle">
                        <strong>OTD (On Time Delivery)</strong>
                    </h2>
                </div>
                <div class="modal-body">
                    <div class="row">
                        <div id="datatable_02" class="col-sm-12">
                            <table id="table_02" class="display nowrap" width="100%">
                                <thead>
                                <tr></tr>
                                </thead>
                                <tbody id="tbody_02"></tbody>
                            </table>
                        </div>
                    </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>

     <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 class="col-md-12 text-right" id="mostrar_excel_ftr_issues">
                        <div class="dt-buttons">
                            <a class="dt-button" tabindex="0" aria-controls="tableModalDetalle" id="excelFtrIssues" href="javascript:ExportExcelFtrIssues()">
                            <span class="dt-button export-excel-issus">Table Excel FIRST TIMERIGHT</span>
                            </a>
                        </div>
                    </div>
                    <div class="col-md-12 text-right" id="mostrar_excel_ftr_total_sites_issues">
                        <div class="dt-buttons">
                            <a class="dt-button" tabindex="0" aria-controls="tableModalDetalle" id="excelFtrTotalSiteIssues" href="javascript:ExportExcelFtrTotalSiteIssues()">
                            <span class="dt-button export-excel-issus">Table Excel FTR TOTAL SITES</span>
                            </a>
                        </div>
                     </div> 
                      <div class="col-md-12 text-right" id="mostrar_excel_rango_total_sites_issues">
                        <div class="dt-buttons">
                            <a class="dt-button" tabindex="0" aria-controls="tableModalDetalle" id="excelRangoTotalSiteIssues" href="javascript:ExportExcelRangoTotalSiteIssues()">
                            <span class="dt-button export-excel-issus">Table Excel TOTAL SITES</span>
                            </a>
                        </div>
                     </div>                    
                     <div class="col-md-12 text-right" id="mostrar_excel_asp_ftr_issues">
                        <div class="dt-buttons">
                            <a class="dt-button" tabindex="0" aria-controls="tableModalDetalle" id="excelAspFtrIssues" href="javascript:ExportExcelAspFtrIssues()">
                            <span class="dt-button export-excel-issus">Table Excel ASP FTR</span>
                            </a>
                        </div>
                    </div>
                    <div class="col-md-12 text-right" id="mostrar_excel_issues">
                        <div class="dt-buttons">
                            <a class="dt-button" tabindex="0" aria-controls="tableModalDetalle" id="excelIssues" href="javascript:ExportExcelIssues()">
                            <span class="dt-button export-excel-issus">Table Excel</span>
                            </a>
                        </div>
                    </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>

{% endblock %}