{% extends '::baseHighcharts.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: 300px;
            height: 300px;
            overflow-y: scroll;
            overflow-x: scroll;
        }
        .nav-link.active {
            font-weight: bold;
        }

        .badge {
            font-size: 85%;
        }

        .gradiente {
          height: 100px;
          background-color: #428BCA; /* For browsers that do not support gradients */
          background-image: linear-gradient(0deg, #428BCA, #031A48);
        }
    </style>
    <link  href="{{ asset('bootstrap-multiselect/css/bootstrap-multiselect.css') }}" rel="stylesheet" type="text/css" />
    <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>

    <link rel="stylesheet" href="{{ asset('js/jquery.isloading.js') }}">

    <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;
        });
        function createTableDT(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 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=='SERVICES REQUESTED BY ERICSSON' || (title=='TOTAL SERVICES' && tableRender!="table_01")){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){   
                                //console.log(tableRender);                             
                                var kpi='DETALLE_ASP_PROD';
                                var table_title = '';  
                                var tipo_otd ='';
                                var otd = '';
                                var serie_detail = '';
                                if (tableRender=="table_AspProdu1"){
                                    otd = 1;
                                    var table_title = 'SERVICES REQUESTED BY ERICSSON';
                                    var kpi='DETALLE_ASP_PROD'; 
                                    tipo_otd = 'otd_relevamiento';
                                }else if (tableRender=="table_AspProdu2"){
                                    otd = 1;
                                    var table_title = 'SERVICES REQUESTED BY ERICSSON';
                                    kpi='DETALLE_ASP_PROD'; 
                                    tipo_otd = 'otd_instalacion';
                                }else if (tableRender=="table_OHS"){
                                    var table_title = 'TOTAL SERVICES';
                                    kpi='OHS_DETAIL'; 
                                    serie_detail = 'TOTAL SERVICES';
                                }else if (tableRender=="table_EHS"){
                                    var table_title = 'TOTAL SERVICES';
                                    kpi='EHS_DETAIL'; 
                                    serie_detail = 'TOTAL SERVICES';
                                }else if (tableRender=="table_QualityPerformance"){
                                    var table_title = 'TOTAL SERVICES';
                                    kpi='QP_DETAIL'; 
                                    serie_detail = 'TOTAL SERVICES';
                                }else if (tableRender=="table_FTR" && title=='TOTAL SERVICES FTR'){
                                    var table_title = 'TOTAL SERVICES FTR';
                                    kpi='FTR'; 
                                    serie_detail = 'TOTAL SERVICES FTR';
                                }else if (tableRender=="table_01" && title=='TOTAL SERVICES'){
                                    var table_title = 'TOTAL SERVICES';
                                    kpi='FTR'; 
                                    serie_detail = 'TOTAL SERVICES';
                                }else if (tableRender=="table_OTDRelevamiento"){
                                    otd = 2;
                                    var table_title = 'TOTAL SERVICES';
                                    kpi='DETALLE_OTD_RELEVAMIENTO_INSTALACION'; 
                                    tipo_otd = 'otd_relevamiento';
                                }else if (tableRender=="table_OTDInstalacion"){
                                    otd = 2;
                                    var table_title = 'TOTAL SERVICES';
                                    kpi='DETALLE_OTD_RELEVAMIENTO_INSTALACION'; 
                                    tipo_otd = 'otd_instalacion';
                                }
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_las') }}";
                                subtitle= row.hasOwnProperty('MONTH') ? row['MONTH'] : "";
                                subtitle += (row.hasOwnProperty('COUNTRY') ? " [" + row['COUNTRY'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('CUSTOMER') ? " [" + row['CUSTOMER'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('PROJECT') ? " [" + row['PROJECT'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                //parametros fitro
                                var pais_filter = $('#pais').val();
                                var proyecto_filter = $('#proyecto').val();  
                                var cliente_filter = $('#cliente').val(); 
                                var responsable = $('#responsable').val();  
                                if($('#asp_user').val()!=''){
                                    var asp_filter = $('#asp_user').val();
                                }else{
                                   var asp_filter = $('#asp').val();   
                                }     
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();   
                                }                                       
                                var parametros = {
                                    'postfix': 'las',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'pais': row.hasOwnProperty('COUNTRY') ? row['COUNTRY'] : $('#pais').val(),
                                    'cliente': row.hasOwnProperty('CUSTOMER') ? row['CUSTOMER'] : $('#cliente').val(),
                                    'proyecto': row.hasOwnProperty('PROJECT') ? row['PROJECT'] : $('#proyecto').val(),
                                    'asp': asp,
                                    'mes': row['MONTH'],
                                    'pais_filter': pais_filter,
                                    'proyecto_filter': proyecto_filter,
                                    'cliente_filter': cliente_filter,
                                    'asp_filter': asp_filter,
                                    'tipo_otd': tipo_otd,
                                    'selected_serie': serie_detail,
                                    'responsable': responsable,
                                    'otd': otd,
                                    'detail': $('#detail').val(),
                                };
                                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' && tableRender=="table_01"){
                    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 = 'TOTAL SERVICES';
                                var serie_detail = 'TOTAL SERVICES';                                
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_las') }}";
                                subtitle= row.hasOwnProperty('MONTH') ? row['MONTH'] : "";
                                subtitle += (row.hasOwnProperty('COUNTRY') ? " [" + row['COUNTRY'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('CUSTOMER') ? " [" + row['CUSTOMER'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('PROJECT') ? " [" + row['PROJECT'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                //parametros fitro
                                var pais_filter = $('#pais').val();
                                var proyecto_filter = $('#proyecto').val();  
                                var cliente_filter = $('#cliente').val();  
                                if($('#asp_user').val()!=''){
                                    var asp_filter = $('#asp_user').val();
                                }else{
                                   var asp_filter = $('#asp').val();   
                                }     
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();   
                                }                                       
                                var parametros = {
                                    'postfix': 'las',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'pais': row.hasOwnProperty('COUNTRY') ? row['COUNTRY'] : $('#pais').val(),
                                    'cliente': row.hasOwnProperty('CUSTOMER') ? row['CUSTOMER'] : $('#cliente').val(),
                                    'proyecto': row.hasOwnProperty('PROJECT') ? row['PROJECT'] : $('#proyecto').val(),
                                    'asp': asp,
                                    'mes': row['MONTH'],
                                    'pais_filter': pais_filter,
                                    'proyecto_filter': proyecto_filter,
                                    'cliente_filter': cliente_filter,
                                    'asp_filter': asp_filter,
                                    'selected_serie': serie_detail,
                                    'detail': $('#detail').val(),
                                };
                                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 FTR'){
                    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 = 'TOTAL SERVICES FTR';
                                var serie_detail = 'TOTAL SERVICES FTR';                                
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_las') }}";
                                subtitle= row.hasOwnProperty('MONTH') ? row['MONTH'] : "";
                                subtitle += (row.hasOwnProperty('COUNTRY') ? " [" + row['COUNTRY'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('CUSTOMER') ? " [" + row['CUSTOMER'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('PROJECT') ? " [" + row['PROJECT'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                //parametros fitro
                                var pais_filter = $('#pais').val();
                                var proyecto_filter = $('#proyecto').val();  
                                var cliente_filter = $('#cliente').val();  
                                if($('#asp_user').val()!=''){
                                    var asp_filter = $('#asp_user').val();
                                }else{
                                   var asp_filter = $('#asp').val();   
                                }     
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();   
                                }                                       
                                var parametros = {
                                    'postfix': 'las',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'pais': row.hasOwnProperty('COUNTRY') ? row['COUNTRY'] : $('#pais').val(),
                                    'cliente': row.hasOwnProperty('CUSTOMER') ? row['CUSTOMER'] : $('#cliente').val(),
                                    'proyecto': row.hasOwnProperty('PROJECT') ? row['PROJECT'] : $('#proyecto').val(),
                                    'asp': asp,
                                    'mes': row['MONTH'],
                                    'pais_filter': pais_filter,
                                    'proyecto_filter': proyecto_filter,
                                    'cliente_filter': cliente_filter,
                                    'asp_filter': asp_filter,
                                    'selected_serie': serie_detail,
                                    'detail': $('#detail').val(),
                                };
                                return '<a href="javascript://" ' +
                                        'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';
                            }else{
                                return dato;
                            }                            
                        }
                    });
                }else  if (title=='TOTAL COMMITMENT SERVICES'){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){                                
                                var kpi='QP_DETAIL';
                                var table_title = 'TOTAL COMMITMENT SERVICES';
                                var serie_detail = 'TOTAL COMMITMENT SERVICES';                                
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_las') }}";
                                subtitle= row.hasOwnProperty('MONTH') ? row['MONTH'] : "";
                                subtitle += (row.hasOwnProperty('COUNTRY') ? " [" + row['COUNTRY'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('CUSTOMER') ? " [" + row['CUSTOMER'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('PROJECT') ? " [" + row['PROJECT'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                //parametros fitro
                                var pais_filter = $('#pais').val();
                                var proyecto_filter = $('#proyecto').val();  
                                var cliente_filter = $('#cliente').val();  
                                if($('#asp_user').val()!=''){
                                    var asp_filter = $('#asp_user').val();
                                }else{
                                   var asp_filter = $('#asp').val();   
                                }     
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();   
                                }                                       
                                var parametros = {
                                    'postfix': 'las',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'pais': row.hasOwnProperty('COUNTRY') ? row['COUNTRY'] : $('#pais').val(),
                                    'cliente': row.hasOwnProperty('CUSTOMER') ? row['CUSTOMER'] : $('#cliente').val(),
                                    'proyecto': row.hasOwnProperty('PROJECT') ? row['PROJECT'] : $('#proyecto').val(),
                                    'asp': asp,
                                    'mes': row['MONTH'],
                                    'pais_filter': pais_filter,
                                    'proyecto_filter': proyecto_filter,
                                    'cliente_filter': cliente_filter,
                                    'asp_filter': asp_filter,
                                    'selected_serie': serie_detail,
                                    'detail': $('#detail').val(),
                                };
                                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 NO BREACHES'){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){          
                                if (tableRender=="table_OHS"){
                                    var kpi='OHS_DETAIL'; 
                                }else if (tableRender=="table_EHS"){
                                    var kpi='EHS_DETAIL'; 
                                }
                                var table_title = 'TOTAL SERVICES NO BREACHES';
                                var serie_detail = 'TOTAL SERVICES NO BREACHES';                                
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_las') }}";
                                subtitle= row.hasOwnProperty('MONTH') ? row['MONTH'] : "";
                                subtitle += (row.hasOwnProperty('COUNTRY') ? " [" + row['COUNTRY'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('CUSTOMER') ? " [" + row['CUSTOMER'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('PROJECT') ? " [" + row['PROJECT'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                //parametros fitro
                                var pais_filter = $('#pais').val();
                                var proyecto_filter = $('#proyecto').val();  
                                var cliente_filter = $('#cliente').val();  
                                if($('#asp_user').val()!=''){
                                    var asp_filter = $('#asp_user').val();
                                }else{
                                   var asp_filter = $('#asp').val();   
                                }     
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();   
                                }                                       
                                var parametros = {
                                    'postfix': 'las',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'pais': row.hasOwnProperty('COUNTRY') ? row['COUNTRY'] : $('#pais').val(),
                                    'cliente': row.hasOwnProperty('CUSTOMER') ? row['CUSTOMER'] : $('#cliente').val(),
                                    'proyecto': row.hasOwnProperty('PROJECT') ? row['PROJECT'] : $('#proyecto').val(),
                                    'asp': asp,
                                    'mes': row['MONTH'],
                                    'pais_filter': pais_filter,
                                    'proyecto_filter': proyecto_filter,
                                    'cliente_filter': cliente_filter,
                                    'asp_filter': asp_filter,
                                    'selected_serie': serie_detail,
                                    'detail': $('#detail').val(),
                                };
                                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 && title!='TOTAL SERVICES NOT OTD' && title!='SERVICES NOT DELIVERY ON TIME BY SUPPLIER' && title!='TOTAL NOT ACCEPTED'){
                    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_las') }}";                                
                                if (row.hasOwnProperty('%FTR')){
                                    kpi='NOT_FTR';
                                    table_title = 'SERVICE NOT 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('%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('%EHS')){
                                    kpi='ehs';
                                    table_title = 'EHS - ' + 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('%QP')){
                                    kpi='QP_DETAIL_NOT_ACCEPTED';
                                    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'] + "]" : "") ;
                                }    
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                }  
                                //parametros fitro
                                var pais_filter = $('#pais').val();
                                var proyecto_filter = $('#proyecto').val();  
                                var cliente_filter = $('#cliente').val(); 
                                var region_filter = $('#region').val();
                                var macroregion_filter = $('#macroregion').val();
                                if($('#asp_user').val()!=''){
                                    var asp_filter = $('#asp_user').val();
                                }else{
                                   var asp_filter = $('#asp').val();   
                                }    
                                //console.log('table',asp);           
                                var parametros = {
                                    'postfix': 'las',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'cliente': row.hasOwnProperty('CUSTOMER') ? row['CUSTOMER'] : $('#cliente').val(),
                                    'proyecto': row.hasOwnProperty('PROJECT') ? row['PROJECT'] : $('#proyecto').val(),
                                    'pais': row.hasOwnProperty('COUNTRY') ? row['COUNTRY'] : $('#pais').val(),
                                    'asp': asp,
                                    'mes': row['MONTH'],
                                    'pais_filter': pais_filter,
                                    'proyecto_filter': proyecto_filter,
                                    'cliente_filter': cliente_filter,
                                    'asp_filter': asp_filter,
                                    'detail': $('#detail').val(),
                                };
                                //console.log(parametros);
                                if (type==='display'){
                                    var ord = null;
                                    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 == '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']) < 75){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust">';
                                    }else if (parseFloat(row['%OTD']) >=75 && 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('%QP')){
                                    if (parseFloat(row['%QP'])>=0 && 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('%OHS')){
                                    if (parseFloat(row['%OHS'])<89.01){
                                        return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                    }else if (parseFloat(row['%OHS']) >=89.01 && parseFloat(row['%OHS']) <94.51){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust" width="">';
                                    }else if (parseFloat(row['%OHS']) >=94.51 && parseFloat(row['%OHS']) <100){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['%OHS']) == 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }
                                } 
                                if (row.hasOwnProperty('%EHS')){
                                    if (parseFloat(row['%EHS'])<89.01){
                                        return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                    }else if (parseFloat(row['%EHS']) >=89.01 && parseFloat(row['%EHS']) <94.51){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust" width="">';
                                    }else if (parseFloat(row['%EHS']) >=94.51 && parseFloat(row['%EHS']) <100){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['%EHS']) == 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }
                                }                      
                            }else{                               
                                if (row.hasOwnProperty('%OTD')){
                                    if (parseFloat(row['%OTD']) >=0 && parseFloat(row['%OTD']) < 75){
                                        return 'Robust';
                                    }else if (parseFloat(row['%OTD']) >=75 && parseFloat(row['%OTD']) < 85){
                                        return 'Commitment';
                                    }else if (parseFloat(row['%OTD']) >= 85 && parseFloat(row['%OTD']) <= 100){
                                        return 'Stretched';
                                    }
                                }  
                                if (row.hasOwnProperty('%QP')){
                                    if (parseFloat(row['%QP'])>=0 && 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('%OHS')){
                                   if (parseFloat(row['%OHS'])<89.01){
                                        return 'Off Track';
                                    }else if (parseFloat(row['%OHS']) >=89.01 && parseFloat(row['%OHS']) <94.51){
                                        return 'Robust';
                                    }else if (parseFloat(row['%OHS']) >=94.51 && parseFloat(row['%OHS']) <100){
                                        return 'Commitment';
                                    }else if (parseFloat(row['%OHS']) == 100){
                                        return 'Stretched';
                                    }
                                }
                                if (row.hasOwnProperty('%EHS')){
                                   if (parseFloat(row['%EHS'])<89.01){
                                        return 'Off Track';
                                    }else if (parseFloat(row['%EHS']) >=89.01 && parseFloat(row['%EHS']) <94.51){
                                        return 'Robust';
                                    }else if (parseFloat(row['%EHS']) >=94.51 && parseFloat(row['%EHS']) <100){
                                        return 'Commitment';
                                    }else if (parseFloat(row['%EHS']) == 100){
                                        return 'Stretched';
                                    }
                                }              
                            }
                        }
                    });
                }else if(title == 'KPIs FTR'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (type==='display'){  
                                if (row.hasOwnProperty('%FTR')){
                                    if (parseFloat(row['%FTR']) >=0 && parseFloat(row['%FTR']) < 85){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust">';
                                    }else if (parseFloat(row['%FTR']) >=85 && 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">';
                                    }
                                }                   
                            }else{    
                                if (row.hasOwnProperty('%FTR')){
                                    if (parseFloat(row['%FTR']) >=0 && parseFloat(row['%FTR']) < 85){
                                        return 'Robust';
                                    }else if (parseFloat(row['%FTR']) >=85 && parseFloat(row['%FTR']) <90){
                                        return 'Commitment';
                                    }else if (parseFloat(row['%FTR']) >=90 && parseFloat(row['%FTR']) <= 100){
                                        return 'Stretched';
                                    }
                                }              
                            }
                        }
                    });
                }else if(title == 'KPIs Average FTR'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (type==='display'){  
                                if (row.hasOwnProperty('AVERAGE FTR')){
                                    if (parseFloat(row['AVERAGE FTR']) >=0 && parseFloat(row['AVERAGE FTR']) < 85){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust">';
                                    }else if (parseFloat(row['AVERAGE FTR']) >=85 && parseFloat(row['AVERAGE FTR']) <90){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['AVERAGE FTR']) >=90 && parseFloat(row['AVERAGE FTR']) <= 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }
                                }                 
                            }else{    
                                if (row.hasOwnProperty('AVERAGE FTR')){
                                    if (parseFloat(row['AVERAGE FTR']) >=0 && parseFloat(row['AVERAGE FTR']) < 85){
                                        return 'Robust';
                                    }else if (parseFloat(row['AVERAGE FTR']) >=85 && parseFloat(row['AVERAGE FTR']) <90){
                                        return 'Commitment';
                                    }else if (parseFloat(row['AVERAGE FTR']) >=90 && parseFloat(row['AVERAGE FTR']) <= 100){
                                        return 'Stretched';
                                    }
                                }             
                            }
                        }
                    });
                }else if(title == 'KPIs QP'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (type==='display'){  
                                if (row.hasOwnProperty('%QP')){
                                    if (parseFloat(row['%QP'])>=0 && 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">';
                                    }
                                }                  
                            }else{    
                                if (row.hasOwnProperty('%QP')){
                                    if (parseFloat(row['%QP'])>=0 && 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';
                                    }
                                }              
                            }
                        }
                    });
                }else if(title == 'KPIs Average QP'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (type==='display'){  
                                if (row.hasOwnProperty('AVERAGE QP')){
                                    if (parseFloat(row['AVERAGE QP'])>=0 && parseFloat(row['AVERAGE QP'])<=70){
                                        return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                    }else if (parseFloat(row['AVERAGE QP']) >70 && parseFloat(row['AVERAGE QP']) <80){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust" width="">';
                                    }else if (parseFloat(row['AVERAGE QP']) >=80 && parseFloat(row['AVERAGE QP']) <=90){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['AVERAGE QP']) >90 && parseFloat(row['AVERAGE QP']) <= 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }
                                }                  
                            }else{    
                                if (row.hasOwnProperty('AVERAGE QP')){
                                    if (parseFloat(row['AVERAGE QP'])>=0 && parseFloat(row['AVERAGE QP'])<=70){
                                        return 'Off Track';
                                    }else if (parseFloat(row['AVERAGE QP']) >70 && parseFloat(row['AVERAGE QP']) <80){
                                        return 'Robust';
                                    }else if (parseFloat(row['AVERAGE QP']) >=80 && parseFloat(row['AVERAGE QP']) <=90){
                                        return 'Commitment';
                                    }else if (parseFloat(row['AVERAGE QP']) >90 && parseFloat(row['AVERAGE QP']) <= 100){
                                        return 'Stretched';
                                    }
                                }              
                            }
                        }
                    });
                }else if(title == 'KPIs Average OHS Index'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (type==='display'){  
                                if (row.hasOwnProperty('Average OHS Index')){
                                    if (parseFloat(row['Average OHS Index'])<89.01){
                                        return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                    }else if (parseFloat(row['Average OHS Index']) >=89.01 && parseFloat(row['Average OHS Index']) <94.51){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust" width="">';
                                    }else if (parseFloat(row['Average OHS Index']) >=94.51 && parseFloat(row['Average OHS Index']) <100){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['Average OHS Index']) == 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }
                                }                 
                            }else{    
                                if (row.hasOwnProperty('Average OHS Index')){
                                   if (parseFloat(row['Average OHS Index'])<89.01){
                                        return 'Off Track';
                                    }else if (parseFloat(row['Average OHS Index']) >=89.01 && parseFloat(row['Average OHS Index']) <94.51){
                                        return 'Robust';
                                    }else if (parseFloat(row['Average OHS Index']) >=94.51 && parseFloat(row['Average OHS Index']) <100){
                                        return 'Commitment';
                                    }else if (parseFloat(row['Average OHS Index']) == 100){
                                        return 'Stretched';
                                    }
                                }               
                            }
                        }
                    });
                }else if(title == 'KPIs Average EHS Index'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (type==='display'){  
                                if (row.hasOwnProperty('Average EHS Index')){
                                    if (parseFloat(row['Average EHS Index'])<89.01){
                                        return '<img src="{{ asset('images/off_track.jpg') }}" title="Off Track">';
                                    }else if (parseFloat(row['Average EHS Index']) >=89.01 && parseFloat(row['Average EHS Index']) <94.51){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust" width="">';
                                    }else if (parseFloat(row['Average EHS Index']) >=94.51 && parseFloat(row['Average EHS Index']) <100){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['Average EHS Index']) == 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }
                                }                 
                            }else{    
                                if (row.hasOwnProperty('Average EHS Index')){
                                   if (parseFloat(row['Average EHS Index'])<89.01){
                                        return 'Off Track';
                                    }else if (parseFloat(row['Average EHS Index']) >=89.01 && parseFloat(row['Average EHS Index']) <94.51){
                                        return 'Robust';
                                    }else if (parseFloat(row['Average EHS Index']) >=94.51 && parseFloat(row['Average EHS Index']) <100){
                                        return 'Commitment';
                                    }else if (parseFloat(row['Average EHS Index']) == 100){
                                        return 'Stretched';
                                    }
                                }               
                            }
                        }
                    });
                }else if (title=='TREND'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (type==='display'){
                                return dato;
                            }else if (type==='export'){
                                if (row['TREND'].indexOf('"up"')>-1){
                                    return 'UP'
                                }else if (row['TREND'].indexOf('"down"')>-1){
                                    return 'DOWN'
                                }else if (row['TREND'].indexOf('"equal"')>-1){
                                    return 'EQUAL'
                                }else return ' - '
                            }else{
                                return dato;
                            }
                        }
                    });
                }else if (title=='TOTAL SERVICES NOT OTD' || title=='SERVICES NOT DELIVERY ON TIME BY SUPPLIER'  || title=='TOTAL NOT ACCEPTED'  || title=='TOTAL NO COMMITMENT SERVICES' || title=='TOTAL SERVICES WITH BREACHES'){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var tipo_otd = '';   
                                var otd = 0;  
                                var serie_detail = '';           
                                if (tableRender=="table_OTDSS"){
                                    var kpi='DETALLE_OTD_SS';
                                    var table_title = 'Total Services Not OTD'; 
                                }else if (tableRender=="table_OTDIM"){
                                    var kpi='DETALLE_OTD_IM';
                                    var table_title = 'Total Services Not OTD'; 
                                }else if (tableRender=="table_OTDIS"){
                                    var kpi='DETALLE_OTD_IS';
                                    var table_title = 'Total Services Not OTD';
                                }else if (tableRender=="table_OTDRelevamiento" || tableRender=="table_OTDInstalacion"){
                                    var kpi='DETALLE_OTD_RELEVAMIENTO_INSTALACION';
                                    var table_title = 'Total Services Not OTD';
                                    if (tableRender=="table_OTDRelevamiento"){
                                        tipo_otd = 'otd_relevamiento';
                                    }else if (tableRender=="table_OTDInstalacion"){
                                        tipo_otd = 'otd_instalacion';    
                                    }                                     
                                }else if (tableRender=="table_AspProdu1"){
                                    otd = 3;
                                    var table_title = 'SERVICES NOT DELIVERY ON TIME BY SUPPLIER';
                                    var kpi='DETALLE_ASP_PROD'; 
                                    tipo_otd = 'otd_relevamiento';
                                }else if (tableRender=="table_AspProdu2"){
                                    otd = 3;
                                    var table_title = 'SERVICES NOT DELIVERY ON TIME BY SUPPLIER';
                                    kpi='DETALLE_ASP_PROD'; 
                                    tipo_otd = 'otd_instalacion';
                                }else if (tableRender=="table_OHS"){
                                    var table_title = 'TOTAL SERVICES WITH BREACHES';
                                    kpi='OHS_DETAIL'; 
                                    serie_detail = 'TOTAL SERVICES WITH BREACHES';
                                }else if (tableRender=="table_EHS"){
                                    var table_title = 'TOTAL SERVICES WITH BREACHES';
                                    kpi='EHS_DETAIL'; 
                                    serie_detail = 'TOTAL SERVICES WITH BREACHES';
                                }else if (tableRender=="table_QualityPerformance"){
                                    var table_title = 'TOTAL COMMITMENT SERVICES';
                                    kpi='QP_DETAIL'; 
                                    serie_detail = 'TOTAL COMMITMENT SERVICES';
                                }
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_las') }}";
                                subtitle= row.hasOwnProperty('MONTH') ? row['MONTH'] : "";
                                subtitle += (row.hasOwnProperty('COUNTRY') ? " [" + row['COUNTRY'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('CUSTOMER') ? " [" + row['CUSTOMER'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('PROJECT') ? " [" + row['PROJECT'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();
                                }  
                                //parametros fitro
                                var pais_filter = $('#pais').val();
                                var proyecto_filter = $('#proyecto').val();  
                                var cliente_filter = $('#cliente').val(); 
                                var region_filter = $('#region').val();
                                var macroregion_filter = $('#macroregion').val();
                                if($('#asp_user').val()!=''){
                                    var asp_filter = $('#asp_user').val();
                                }else{
                                   var asp_filter = $('#asp').val();   
                                }    
                                //console.log('table',asp);           
                                var parametros = {
                                    'postfix': 'las',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'cliente': row.hasOwnProperty('CUSTOMER') ? row['CUSTOMER'] : $('#cliente').val(),
                                    'proyecto': row.hasOwnProperty('PROJECT') ? row['PROJECT'] : $('#proyecto').val(),
                                    'pais': row.hasOwnProperty('COUNTRY') ? row['COUNTRY'] : $('#pais').val(),
                                    'asp': asp,
                                    'mes': row['MONTH'],
                                    'otd': otd,
                                    'tipo': 1,
                                    'pais_filter': pais_filter,
                                    'proyecto_filter': proyecto_filter,
                                    'cliente_filter': cliente_filter,
                                    'asp_filter': asp_filter,
                                    'tipo_otd': tipo_otd,
                                    'selected_serie': serie_detail,
                                    'detail': $('#detail').val(),
                                };
                                return '<a href="javascript://" ' +
                                        'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';
                            }else{
                                return dato;
                            }                            
                        }
                    });
                }else if (title=='fecha_ocultar'){
                    columns.push({data: data[i], title: t, visible:false});
                }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 buildDatatablePrin(render, columnas, data,suffix_export,orderArray){
            //console.log(suffix_export,render);
            var a=[];b=[];
            var Defs = [];
            var order = [];
            var ini = (columnas.length) -5;
            var kpi = "";
            for (var i=0; i<=(columnas.length - 1); i++){
                a.push(i);
            }
            Defs.push({ targets: a, className: 'dt-body-center' });
            for (var i=0; i<=(columnas.length - 1); i++){
                if (columnas[i].visible){
                    b.push(i);
                }
            }
            table = $('#'+render).DataTable( {
                dom: '<"row" <"col-md-12 text-right"B>> <"row" <"col-md-6 "l> <"col-md-6"f>>rtip',
                scrollY: '60vh',
                scrollX: true,
                scrollCollapse: true,
                orderCellsTop: true,
                data:data,
                "deferRender": false,
                "processing": true,
                "language": {
                    // 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" ]],
                //"ordering": false,
                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_Las_' + kpi
                    }
                ]
            } );
            
        }

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

            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;

                if (t=='DESCRPTION'){
                    strHeader += '<th class="text-center" style="width: 350px;">' + t + '</th>';
                }else{
                    strHeader += '<th class="text-center">' + t + '</th>';
                }
                
                //console.log(title);
                if (title=="Total Not Accepted" || title=="Not Ok" || title=="SYSTEM FAULT FOUND" || title=="ISSUES ERROR"){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi="";
                                var popup_title = "";
                                var strIssuesHtml = "<ol>";
                                var strIssuesText = "";
                                var url= "";
                                if (row.hasOwnProperty('_ISSUES')){
                                    kpi='ftr';
                                    popup_title = 'Issues';
                                    var issues = row['_ISSUES'];     
                                    var arrIssues = issues.split("<br>");                               
                                    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 '<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 (row.hasOwnProperty('_ISSUES')){
                                        var issues = row['_ISSUES'];
                                        var arrIssues = issues.split("<br>");
                                        if (Array.isArray(arrIssues)){
                                            for (var i=0; i<arrIssues.length; i++){
                                                strIssuesHtml += "<li>" + arrIssues[i] + ".</li>";
                                                strIssuesText += i + ". " +  arrIssues[i] + ".\r\n";
                                            }
                                        }
                                        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{
                    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;
        }

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

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

            $('#Filtros_fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#Filtros_fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });

            $('#Filtros_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);
            //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 div = $(this).attr('data-div-siguiente'); 
                var pais = $("#pais").val(); 
                var data = {
                    valor_filtro : $(this).val(),
                    campo_filtrar : campo_filtrar,
                    campo_mostrar : campo_mostrar,
                    pais: pais,
                };
                $("."+data_act+" option").remove();                
                $("."+data_act).multiselect("destroy");
                $("."+data_act).multiselect({
                    includeSelectAllOption: true, 
                    buttonTextAlignment: 'left',
                    buttonWidth: '200px'
                });

                $("."+data_select_refresh+" option").remove();                
                $("."+data_select_refresh).multiselect("destroy");
                $("."+data_select_refresh).multiselect({
                    includeSelectAllOption: true, 
                    buttonTextAlignment: 'left',
                    buttonWidth: '200px'
                });
                if ($(this).val()){
                    //console.log('longitud',$(this).val().length);
                    if ($(this).val().length>0){     //               
                        $.getJSON('{{path('aspir_llenarSelectLas',{'idproyectos':idproyectos,'idmodule':idmodule})}}', data, function (data){
                            var registros = data.registros;
                            $("."+data_select_refresh+" option").remove();                
                            //$("."+data_select_refresh).multiselect("destroy");
                            for (var i = 0; i < registros.length; i++){
                                $("#"+data_select_refresh).append('<option value="' + registros[i]['valor'] + '">' + registros[i]['nombre'] + '</option>');
                            }
                            $("#"+data_select_refresh).attr('multiple',true);
                            $("#"+data_select_refresh).multiselect("destroy");
                            $("#"+data_select_refresh).multiselect({
                                includeSelectAllOption: true, 
                                buttonTextAlignment: 'left',
                                buttonWidth: '200px'
                            });
                            $('#'+div+' .multiselect-container>li[class="active"]>a>label>input').first().trigger('click'); 
                        });
                    }
               }
            });
            //
            $("#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();
                }
            }); 
            $(window).resize(function(){
                resizeChart();
            });       

        });
        function getDataToObjectSerieAll1(data, header){
            var arrayReturn = new Array();
            var data1 = new Array();
            var menor = 1000;
            var mayor = -1;
            var total = 0;
            var valorA=0;
            var dataAux = new Array()
            
            for (var i = 0; i < header.length; i++){
                var dataAux = new Array();
                var dataAux1 = new Array();
                valorA=0;
                total = 0;
                if (header[i].indexOf('_cat_') < 0){
                    for (var j=0; j<data.length; j++){
                        
                        var valor = parseFloat(data[j][header[i]]);
                        valorA+= valor; 
                        total+=valor;
                        dataAux.push(valor);
                        dataAux1.push(valorA); 
                        //console.log(valorA);
                        if (valor < menor){
                            menor = valor;
                        }
                        if (valor > mayor){
                            mayor = valor;
                        }
                        
                    }

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

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

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

            var panel_width = $('#panel_content').width();
            var offset = 32;

            $('#grafico_OTDSS').width(panel_width-offset);
            $('#grafico_OTDIM').width(panel_width-offset);
            $('#grafico_OTDIS').width(panel_width-offset);
            $('#graficoFirstTimeRight').width(panel_width-offset);
            $('#graficoQualityPerformance').width(panel_width-offset);          
            $('#grafico_OTDRelevamiento').width(panel_width-offset);
            $('#grafico_OTDInstalacion').width(panel_width-offset);           
            $('#grafico_AspProdu1').width(panel_width-offset);
            $('#grafico_AspProdu2').width(panel_width-offset);
            $('#grafico_RootCauseRelevamiento').width('70%');
            $('#grafico_RootOffensorRelevamiento').width('70%');
            $('#grafico_RootCauseInstalacion').width('70%');
            $('#grafico_RootOffensorInstalacion').width('70%');
            $('#grafico_OHS').width(panel_width-offset); 
            $('#grafico_EHS').width(panel_width-offset); 
           
            if ($("#grafico_OTDSS").highcharts()!=undefined){ 
                $('#grafico_OTDSS').highcharts().reflow();  
            }
            if ($("#grafico_OTDIM").highcharts()!=undefined){ 
                $('#grafico_OTDIM').highcharts().reflow();  
            }
            if ($("#grafico_OTDIS").highcharts()!=undefined){ 
                $('#grafico_OTDIS').highcharts().reflow();  
            }
            if ($("#graficoFirstTimeRight").highcharts()!=undefined){ 
                $('#graficoFirstTimeRight').highcharts().reflow();  
            }            
            if ($("#graficoQualityPerformance").highcharts()!=undefined){ 
                $('#graficoQualityPerformance').highcharts().reflow();  
            }
            if ($("#grafico_OTDRelevamiento").highcharts()!=undefined){ 
                $('#grafico_OTDRelevamiento').highcharts().reflow();  
            }
            if ($("#grafico_OTDInstalacion").highcharts()!=undefined){ 
                $('#grafico_OTDInstalacion').highcharts().reflow();  
            }            
            if ($("#grafico_AspProdu1").highcharts()!=undefined){ 
                $('#grafico_AspProdu1').highcharts().reflow();  
            }  
            if ($("#grafico_AspProdu2").highcharts()!=undefined){ 
                $('#grafico_AspProdu2').highcharts().reflow();  
            }
            if ($("#grafico_RootCauseRelevamiento").highcharts()!=undefined){ 
                $('#grafico_RootCauseRelevamiento').highcharts().reflow();  
            } 
            if ($("#grafico_RootOffensorRelevamiento").highcharts()!=undefined){ 
                $('#grafico_RootOffensorRelevamiento').highcharts().reflow();  
            }   
            if ($("#grafico_RootCauseInstalacion").highcharts()!=undefined){ 
                $('#grafico_RootCauseInstalacion').highcharts().reflow();  
            } 
            if ($("#grafico_RootOffensorInstalacion").highcharts()!=undefined){ 
                $('#grafico_RootOffensorInstalacion').highcharts().reflow();  
            } 
            if ($("#grafico_OHS").highcharts()!=undefined){ 
                $('#grafico_OHS').highcharts().reflow();
            }
            if ($("#grafico_EHS").highcharts()!=undefined){ 
                $('#grafico_EHS').highcharts().reflow();
            }
        }
        function destroyGraphs(){
            try{
                $('#grafico_OTDEDI').highcharts().destroy();
                $('#grafico_OTDDFI').highcharts().destroy(); 
                $('#grafico_CT').highcharts().destroy();             
            }catch(err){
                //console.log(err.message);
            }
        }
        function getChart(){
            var inicio = $('#Filtros_fechaIni').val();
            var fin = $('#Filtros_fechaFin').val();
            var cliente = $('#cliente').val();
            var proyecto = $('#proyecto').val();
            var region = $('#region').val();
            var cu = $('#cluster').val();
            //var pais = $("#pais").val();
            if($('#asp_user').val()!=''){
                var asp = $('#asp_user').val();
            }else{
                var asp = $('#asp').val();
            }  
            if($('#country_user').val()!=''){
                var pais = $('#country_user').val();
            }else{
                var pais = $('#pais').val();
            }            
            var valor = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();
            var detail = $("#detail").val();
            var responsable = $("#responsable").val();
            var parametros = {
                'postfix' : 'las',
                'FechaInicio': inicio,
                'FechaFin': fin,
                'pais': pais,
                'cliente': cliente,
                'proyecto': proyecto,
                'region': region,
                'cu': cu,
                'asp': asp,
                'date': valor,
                'detail': detail,
                'responsable': responsable
            };
            $.getJSON('{{path('aspir_DashboardAspirLas',{'idproyectos':idproyectos})}}', parametros, function (data){
                var chart = data;
                //PARA OTD
                //GRAFICO OTD SS
                /*if (chart.grafico_OTDSS.categories.length > 0){
                    $("#grafico_OTDSS").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_OTDSS.data, Object.keys(chart.grafico_OTDSS.data[0]));
                    createChartColumnTargetPorcente('grafico_OTDSS', chart.grafico_OTDSS.categories, series, 'OTD SITE SURVEY',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_las') }}", chart.grafico_OTDSS.data,parametros,75,'Rob=75%',80,'Com=80%',85,'Str=85%');
                }else{
                    if ($("#grafico_OTDSS").highcharts()!=undefined){
                        $("#grafico_OTDSS").highcharts().destroy();
                    }                    
                    $("#grafico_OTDSS").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                // Tabla table_OTDSS
                if (chart.table_OTDSS.length > 0){
                     $("#datatable_OTDSS").empty();
                     var col = createTableDT(Object.keys(chart.table_OTDSS[0]),'table_OTDSS', 'datatable_OTDSS');
                     buildDatatablePrin('table_OTDSS',col,chart.table_OTDSS);
                 }else{
                    $("#datatable_OTDSS").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }  
                //GRAFICO OTD IM
                if (chart.grafico_OTDIM.categories.length > 0){
                    $("#grafico_OTDIM").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_OTDIM.data, Object.keys(chart.grafico_OTDIM.data[0]));
                    createChartColumnTargetPorcente('grafico_OTDIM', chart.grafico_OTDIM.categories, series, 'OTD INSTALLATION MODERNIZATION',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_las') }}", chart.grafico_OTDIM.data,parametros,75,'Rob=75%',80,'Com=80%',85,'Str=85%');
                }else{
                    if ($("#grafico_OTDIM").highcharts()!=undefined){
                        $("#grafico_OTDIM").highcharts().destroy();
                    }                    
                    $("#grafico_OTDIM").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                // Tabla table_OTDEDI
                if (chart.table_OTDIM.length > 0){
                     $("#datatable_OTDIM").empty();
                     var col = createTableDT(Object.keys(chart.table_OTDIM[0]),'table_OTDIM', 'datatable_OTDIM');
                     buildDatatablePrin('table_OTDIM',col,chart.table_OTDIM);
                 }else{
                    $("#datatable_OTDIM").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }  
                //GRAFICO OTD IS
                if (chart.grafico_OTDIS.categories.length > 0){
                    $("#grafico_OTDIS").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_OTDIS.data, Object.keys(chart.grafico_OTDIS.data[0]));
                    createChartColumnTargetPorcente('grafico_OTDIS', chart.grafico_OTDIS.categories, series, 'OTD INSTALLATION SWAP',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_las') }}", chart.grafico_OTDIS.data,parametros,75,'Rob=75%',80,'Com=80%',85,'Str=85%');
                }else{
                    if ($("#grafico_OTDIS").highcharts()!=undefined){
                        $("#grafico_OTDIS").highcharts().destroy();
                    }                    
                    $("#grafico_OTDIS").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                // Tabla table_OTD IS
                if (chart.table_OTDIS.length > 0){
                     $("#datatable_OTDIS").empty();
                     var col = createTableDT(Object.keys(chart.table_OTDIS[0]),'table_OTDIS', 'datatable_OTDIS');
                     buildDatatablePrin('table_OTDIS',col,chart.table_OTDIS);
                 }else{
                    $("#datatable_OTDIS").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }*/
                //FTR
                if (chart.graficoFirstTimeRight.categories.length > 0){
                    $("#graficoFirstTimeRight").empty();
                    //var series = getDataToObjectSerie(chart.graficoFirstTimeRight.data, Object.keys(chart.graficoFirstTimeRight.data[0]));
                    var series = getDataToObjectSerieAll(chart.graficoFirstTimeRight.data, Object.keys(chart.graficoFirstTimeRight.data[0]));
                    createChartLinea2('graficoFirstTimeRight', chart.graficoFirstTimeRight.categories, series, 'First Time Right (FTR)',
                            null, [80, 'Rob=80%'], [85,'Com=85%'], [90,'Str=90%'], inicio, fin, null, null, null, chart.graficoFirstTimeRight.data);
                }else{
                    if ($("#graficoFirstTimeRight").highcharts()!=undefined){
                        $("#graficoFirstTimeRight").highcharts().destroy();
                    } 
                    $("#graficoFirstTimeRight").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                // Tabla tablaFirstTimeRight
                if (chart.tablaFirstTimeRight.length > 0){
                    $("#datatable_02").empty();
                    var col = createTableDT(Object.keys(chart.tablaFirstTimeRight[0]),'table_01', 'datatable_01');
                    buildDatatablePrin('table_01',col,chart.tablaFirstTimeRight);
                }else{
                    $("#datatable_01").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //QP
                if (chart.graficoQualityPerformance.categories.length > 0){
                    $("#graficoQualityPerformance").empty();                    
                    var series = getDataToObjectSerieAll(chart.graficoQualityPerformance.data, Object.keys(chart.graficoQualityPerformance.data[0]));
                    createChartColumn('graficoQualityPerformance', chart.graficoQualityPerformance.categories, series, 'Quality Performance',
                            null, [70, 'Rob=70%'], [80,'Com=80%'], [90,'Str=90%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_las') }}", chart.graficoQualityPerformance.data);
                }else{
                    if ($("#graficoQualityPerformance").highcharts()!=undefined){
                        $("#graficoQualityPerformance").highcharts().destroy();
                    } 
                    $("#graficoQualityPerformance").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                if (chart.tableQualityPerformance.length > 0){
                    $("#datatable_QualityPerformance").empty();
                    var col = createTableDT(Object.keys(chart.tableQualityPerformance[0]),'table_QualityPerformance', 'datatable_QualityPerformance');
                    buildDatatablePrin('table_QualityPerformance',col,chart.tableQualityPerformance);
                }else{
                    $("#datatable_QualityPerformance").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //////////
                //GRAFICO OTD RELEVAMIENTO
                if (chart.grafico_OTDRelevamiento.categories.length > 0){
                    $("#grafico_OTDRelevamiento").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_OTDRelevamiento.data, Object.keys(chart.grafico_OTDRelevamiento.data[0]));
                    createChartColumnTargetPorcente('grafico_OTDRelevamiento', chart.grafico_OTDRelevamiento.categories, series, 'OTD Site Survey',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_las') }}", chart.grafico_OTDRelevamiento.data,parametros,75,'Rob=75%',80,'Com=80%',85,'Str=85%');
                }else{
                    if ($("#grafico_OTDRelevamiento").highcharts()!=undefined){
                        $("#grafico_OTDRelevamiento").highcharts().destroy();
                    }                    
                    $("#grafico_OTDRelevamiento").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                // Tabla table_ RELEVAMIENTO
                if (chart.table_OTDRelevamiento.length > 0){
                     $("#datatable_OTDRelevamiento").empty();
                     var col = createTableDT(Object.keys(chart.table_OTDRelevamiento[0]),'table_OTDRelevamiento', 'datatable_OTDRelevamiento');
                     buildDatatablePrin('table_OTDRelevamiento',col,chart.table_OTDRelevamiento);
                 }else{
                    $("#datatable_OTDRelevamiento").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                } 
                //GRAFICO OTD INSTALACION
                if (chart.grafico_OTDInstalacion.categories.length > 0){
                    $("#grafico_OTDInstalacion").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_OTDInstalacion.data, Object.keys(chart.grafico_OTDInstalacion.data[0]));
                    createChartColumnTargetPorcente('grafico_OTDInstalacion', chart.grafico_OTDInstalacion.categories, series, 'OTD INSTALLATION',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_las') }}", chart.grafico_OTDInstalacion.data,parametros,75,'Rob=75%',80,'Com=80%',85,'Str=85%');
                }else{
                    if ($("#grafico_OTDInstalacion").highcharts()!=undefined){
                        $("#grafico_OTDInstalacion").highcharts().destroy();
                    }                    
                    $("#grafico_OTDInstalacion").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                // Tabla table_ INSTALACION
                if (chart.table_OTDInstalacion.length > 0){
                     $("#datatable_OTDInstalacion").empty();
                     var col = createTableDT(Object.keys(chart.table_OTDInstalacion[0]),'table_OTDInstalacion', 'datatable_OTDInstalacion');
                     buildDatatablePrin('table_OTDInstalacion',col,chart.table_OTDInstalacion);
                 }else{
                    $("#datatable_OTDInstalacion").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                ///////
                //ASP PRODU 1
                //GRAFICO
                /*if (chart.grafico_AspProdu1.categories.length > 0){
                    $("#grafico_AspProdu1").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_AspProdu1.data, Object.keys(chart.grafico_AspProdu1.data[0]));
                    createChartColumnTargetPorcente('grafico_AspProdu1', chart.grafico_AspProdu1.categories, series, 'ASP Productivity OTD Site Survey',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_las') }}", chart.grafico_AspProdu1.data,parametros,66,'Rob=66%',80,'Com=80%',85,'Str=85%'); 
                }else{
                    if ($("#grafico_AspProdu1").highcharts()!=undefined){
                        $("#grafico_AspProdu1").highcharts().destroy();
                    }                    
                    $("#grafico_AspProdu1").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                // Tabla 
                if (chart.table_AspProdu1.length > 0){
                     $("#datatable_AspProdu1").empty();
                     var col = createTableDT(Object.keys(chart.table_AspProdu1[0]),'table_AspProdu1', 'datatable_AspProdu1');
                     buildDatatablePrin('table_AspProdu1',col,chart.table_AspProdu1);
                 }else{
                    $("#datatable_AspProdu1").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                } 
                // ASP PRODU 2
                //GRAFICO 
                if (chart.grafico_AspProdu2.categories.length > 0){
                    $("#grafico_AspProdu2").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_AspProdu2.data, Object.keys(chart.grafico_AspProdu2.data[0]));
                    createChartColumnTargetPorcente('grafico_AspProdu2', chart.grafico_AspProdu2.categories, series, 'ASP Productivity OTD Installation',
                            null, inicio, fin, null,null,"{{ path('aspir_detalle_tabla_las') }}", chart.grafico_AspProdu2.data,parametros,66,'Rob=66%',80,'Com=80%',85,'Str=85%'); 
                }else{
                    if ($("#grafico_AspProdu2").highcharts()!=undefined){
                        $("#grafico_AspProdu2").highcharts().destroy();
                    }                    
                    $("#grafico_AspProdu2").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                // Tabla
                if (chart.table_AspProdu2.length > 0){
                     $("#datatable_AspProdu2").empty();
                     var col = createTableDT(Object.keys(chart.table_AspProdu2[0]),'table_AspProdu2', 'datatable_AspProdu2');
                     buildDatatablePrin('table_AspProdu2',col,chart.table_AspProdu2);
                 }else{
                    $("#datatable_AspProdu2").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }  
                //GRAFICO Pareto Root Cause
                if (chart.grafico_RootCauseRelevamiento.categories.length > 0){
                    $("#grafico_RootCauseRelevamiento").empty();
                    var series = getDataToObjectSerieAll1(chart.grafico_RootCauseRelevamiento.data,Object.keys(chart.grafico_RootCauseRelevamiento.data[0]));
                    createChartColumnRootCause('grafico_RootCauseRelevamiento', chart.grafico_RootCauseRelevamiento.categories, series, 'Pareto Chart - Most Common Root Cause',
                           null, null, null, null, parametros,null,"{{ path('aspir_detalle_tabla_las') }}",  chart.grafico_RootCauseRelevamiento.data,320,'Site Survey')
                }else{
                    if ($("#grafico_RootCauseRelevamiento").highcharts()!=undefined){
                        $("#grafico_RootCauseRelevamiento").highcharts().destroy();
                    }                    
                    $("#grafico_RootCauseRelevamiento").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }  
                //GRAFICO OFFENSOR
                 if (chart.grafico_RootOffensorRelevamiento.categories.length > 0){
                    $("#grafico_RootOffensorRelevamiento").empty();
                    var series = getDataToObjectSerieAll1(chart.grafico_RootOffensorRelevamiento.data,Object.keys(chart.grafico_RootOffensorRelevamiento.data[0]));
                    createChartColumnRootCause('grafico_RootOffensorRelevamiento', chart.grafico_RootOffensorRelevamiento.categories, series, 'Pareto Chart - Worst Offenders',
                           null, null, null, null, parametros,null,"{{ path('aspir_detalle_tabla_las') }}",  chart.grafico_RootOffensorRelevamiento.data,320,'Site Survey')
                }else{
                    if ($("#grafico_RootOffensorRelevamiento").highcharts()!=undefined){
                        $("#grafico_RootOffensorRelevamiento").highcharts().destroy();
                    }                    
                    $("#grafico_RootOffensorRelevamiento").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //Site Survey  
                //GRAFICO Pareto Root Cause
                if (chart.grafico_RootCauseInstalacion.categories.length > 0){
                    $("#grafico_RootCauseInstalacion").empty();
                    var series = getDataToObjectSerieAll1(chart.grafico_RootCauseInstalacion.data,Object.keys(chart.grafico_RootCauseInstalacion.data[0]));
                    createChartColumnRootCause('grafico_RootCauseInstalacion', chart.grafico_RootCauseInstalacion.categories, series, 'Pareto Chart - Most Common Root Cause',
                           null, null, null, null, parametros,null,"{{ path('aspir_detalle_tabla_las') }}",  chart.grafico_RootCauseInstalacion.data,320,'Installation')
                }else{
                    if ($("#grafico_RootCauseInstalacion").highcharts()!=undefined){
                        $("#grafico_RootCauseInstalacion").highcharts().destroy();
                    }                    
                    $("#grafico_RootCauseInstalacion").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }  
                //GRAFICO OFFENSOR
                 if (chart.grafico_RootOffensorInstalacion.categories.length > 0){
                    $("#grafico_RootOffensorInstalacion").empty();
                    var series = getDataToObjectSerieAll1(chart.grafico_RootOffensorInstalacion.data,Object.keys(chart.grafico_RootOffensorInstalacion.data[0]));
                    createChartColumnRootCause('grafico_RootOffensorInstalacion', chart.grafico_RootOffensorInstalacion.categories, series, 'Pareto Chart - Worst Offenders',
                           null, null, null, null, parametros,null,"{{ path('aspir_detalle_tabla_las') }}",  chart.grafico_RootOffensorInstalacion.data,320,'Installation')
                }else{
                    if ($("#grafico_RootOffensorInstalacion").highcharts()!=undefined){
                        $("#grafico_RootOffensorInstalacion").highcharts().destroy();
                    }                    
                    $("#grafico_RootOffensorInstalacion").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                } */
                // 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, [89, 'Rob=89%'], [94,'Com=94%'], [100,'Str=100%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_las') }}", 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>');
                }
                // EHS
                if (chart.grafico_EHS.categories.length > 0){
                    $("#grafico_EHS").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_EHS.data, Object.keys(chart.grafico_EHS.data[0]));
                    createChartColumn('grafico_EHS', chart.grafico_EHS.categories, series, 'EHS',
                            null, [89, 'Rob=89%'], [94,'Com=94%'], [100,'Str=100%'], inicio, fin, null,null,"{{ path('aspir_detalle_tabla_las') }}", chart.grafico_EHS.data);
                }else{
                    if ($("#grafico_EHS").highcharts()!=undefined){
                      $("#grafico_EHS").highcharts().destroy();
                    } 
                    $("#grafico_EHS").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                if (chart.table_EHS.length > 0){
                    $("#datatable_EHS").empty();
                    var col = createTableDT(Object.keys(chart.table_EHS[0]),'table_EHS', 'datatable_EHS');
                    buildDatatablePrin('table_EHS',col,chart.table_EHS);
                }else{
                    $("#datatable_EHS").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                $.isLoading("hide");
                resizeChart();
            });
        }
        function createChartColumnRootCause(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, parametros, orderArray, path, rawData,height,subtitle){
            //ajustar la serie para la doble axies
            var arrayReturn = new Array();
            var data = new Array();           
            if (series.length>0){
                $.each(series, function(key, value) {
                    $.each(value, function(k, v) {                         
                        if(k==0){ 
                           data.push({"name":v.name,"data":v.data,type: 'column'});
                        }else{
                            data.push({"name":"%","data":v.data,yAxis: 1});
                        }                        
                    });
                });
            }                   
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            switch (render){
                case 'grafico_RootCause':
                        rotation = -45;
                        break;                                    
            }
            //console.log(data);
            var porcentaje = data[0].data;
            if (porcentaje!="" && porcentaje!=undefined){
                var yMax = porcentaje.reduce(function(a, b) {
                    return Math.max(a, b);
                });
                if (yMax==0){
                    yMax=35;
                }   
            }else{
                var yMax=35;
            } 
            //console.log(yMax);   
            //var height = 320;
             var options = {
                chart: {
                    //height: height,
                    zoomType: 'xy',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: subtitle
                  },
                  enableMouseTracking : false,
                  xAxis: {
                        categories: [],
                        lineWidth: 1,
                        lineColor: '#4c4c4c',
                        //tickColor: '#4c4c4c',
                        //tickWidth: 1,
                        //minorTickWidth: 1,
                        crosshair: true,
                        labels: {
                            groupedOptions: [{ // 1st-level
                                autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                //rotation: -30,
                                lineWidth: 1,
                                tickWidth: 1,
                                style: {
                                    fontSize: '10px',
                                    color: '#333333'
                                    //color: '#4c4c4c'
                                }
                            }, // 2nd-level
                                {
                                    autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                    //rotation: 0,
                                    lineWidth: 0,
                                    tickWidth: 0,
                                    //align: 'right',
                                    style: {
                                        fontSize: '9px',
                                        color: '#333333'
                                        //color: '#4c4c4c'
                                    }
                                }
                            ],
                            //step: step,
                            lineWidth: 0,
                            tickWidth: 0,
                            rotation: 0,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            },
                            formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                                if(this.value.length > 15){
                                    return this.value.substring(0, 15) + '...';
                                }
                                return this.value;
                            }
                        },
                        overflow: 'justify',
                        scrollbar: {
                            enabled: false
                        }
                  },
                  plotOptions:{
                    column: {
                        pointPadding: 0.2,
                        borderWidth: 0,
                        depth: 40,
                        dataLabels: {
                            enabled: true,
                            crop: false,
                            overflow: 'none'
                        }
                    },
                    series:{
                        shadow:true,
                        dataLabels: {
                            enabled: true,
                            style: {
                                fontWeight: 'bold'
                            }
                        }
                    }
                },
                responsive: {
                    rules: [{
                        condition: {
                            maxWidth: 500
                        },
                        chartOptions: {
                            legend: {
                                align: 'center',
                                verticalAlign: 'bottom',
                                layout: 'horizontal'
                            },
                            yAxis: {
                                labels: {
                                    align: 'left',
                                    x: 0,
                                    y: -5
                                },
                                title: {
                                    text: null
                                }
                            },
                            subtitle: {
                                text: null
                            },
                            credits: {
                                enabled: false
                            }
                        }
                    }]
                },
                legend: {
                    backgroundColor: 'rgba(66, 139, 202, 0.5)'

                },

                  yAxis: [{ // Primary yAxis
                    plotLines: [
                        {
                            value: 0,
                            width: 1,
                            color: '#808080'
                        }
                    ],
                    title: {
                      text: 'Qty',
                      style: {
                        color: Highcharts.getOptions().colors[1]
                      }
                    },
                    min: 0,
                    tickPositions: [0,5,10,20,30,50,70,yMax],
                  },{ // Secondary yAxis
                    title: {
                      text: 'Percent (%)'
                    },
                    //max: 100,
                    min: 0,
                    tickPositions: [0,30,40,50,60,70,80,90,100],
                    opposite: true,
                    labels: {
                        format: "{value}%"
                    },
                  }],
                  tooltip: {
                    shared: false
                  },
                  colors: ['#275f76', '#e55550', '#4fa165', '#910000', '#1aadce',
                            '#492970', '#f28f43', '#77a1e5', '#c42525', '#a6c96a'],                  
                  series: data
            };            

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

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

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

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

                                    if (rawData != null){
                                        var row = rawData[this.x];  
                                        var categoriaDetalle =  row['_cat_RootCause'];
                                        var selected_serie = this.series.name;  
                                        if (render=='grafico_RootCauseRelevamiento' || render=='grafico_RootOffensorRelevamiento' || render=='grafico_RootCauseInstalacion' || render=='grafico_RootOffensorInstalacion'){              
                                            var t ='';
                                            parametros['mes']='';
                                            if (render=='grafico_RootCauseRelevamiento'){
                                                categoriaDetalle = row['_cat_RootCause'];        
                                                t = 'Pareto Chart - Most Common Root Cause (Relevamiento)';
                                                parametros['kpi']='DETALLE_CAUSE';
                                                parametros['selected_serie']=categoriaDetalle;
                                                parametros['tipo_otd']='otd_relevamiento';
                                            } 
                                            if (render=='grafico_RootOffensorRelevamiento'){
                                                categoriaDetalle = row['_cat_Offender'];        
                                                t = 'Pareto Chart - Worst Offenders (Relevamiento)';
                                                parametros['kpi']='DETALLE_OFFENDER';
                                                parametros['selected_serie']=categoriaDetalle;
                                                parametros['tipo_otd']='otd_relevamiento';
                                            } 
                                            //SS 
                                            if (render=='grafico_RootCauseInstalacion'){
                                                categoriaDetalle = row['_cat_RootCause'];        
                                                t = 'Pareto Chart - Most Common Root Cause (INSTALLATION)';
                                                parametros['kpi']='DETALLE_CAUSE';
                                                parametros['selected_serie']=categoriaDetalle;
                                                parametros['tipo_otd']='otd_instalacion';
                                            } 
                                            if (render=='grafico_RootOffensorInstalacion'){
                                                categoriaDetalle = row['_cat_Offender'];        
                                                t = 'Pareto Chart - Worst Offenders (INSTALLATION)';
                                                parametros['kpi']='DETALLE_OFFENDER';
                                                parametros['selected_serie']=categoriaDetalle;
                                                parametros['tipo_otd']='otd_instalacion';
                                            }                                           
                                            var title_detalle = t;
                                            var subtitle_detalle = categoriaDetalle;
                                            
                                        }     
                                        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]);
                    }
                }
            }
            if (render!='graficoCFIssues'){
                if (menor >50) menor= 50;
                options.yAxis[0].min=menor;
            } 
            return $('#' + render).highcharts(options);
        }
        function createChartColumn(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 (render=='grafico_OHS' || render=='grafico_EHS'){
                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":'#4fa165',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==2){ //Total sites
                                data.push({"color":'#e55550',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});
                            }/*else if (k==3){ //Total defetcs
                                data.push({"color":'#93D543',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});
                            }*/else{
                                data.push({"name":"%OHS","data":v.data,yAxis: 0});
                            }
                            
                        });
                    });
                }
            }else if(render=='graficoQualityPerformance'){
                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":'#4fa165',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==2){ //Total sites
                                data.push({"color":'#e55550',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});
                            }else if (k==3){ //Total average
                                data.push({"name":"AVERAGE QP","color":"#1B9D2C","data":v.data,yAxis: 0});
                            }else{
                                data.push({"name":"%QP","color":"#2A587F","data":v.data,yAxis: 0});
                            }
                            
                        });
                    });
                }
            }else{
                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":'#4fa165',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});  
                            }else if (k==2){ //Total sites
                                data.push({"color":'#e55550',"name":v.name,"data":v.data,yAxis: 1,type: 'column'});
                            }else{
                                data.push({"name":"%Accepted","data":v.data,yAxis: 0});
                            }
                            
                        });
                    });
                }    
            }
            //console.log('data',data,'render');
            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 'graficoQualityPerformance':
                    table_dt = 'table_02';
                    dt = 'datatable_02';
                    posProy = 3;
                    kpi = 'QP_DETAIL'
                    break; 
                 case 'grafico_OHS':
                    table_dt = 'table_OHS';
                    dt = 'datatable_OHS';
                    posProy = 3;
                    kpi = 'OHS_DETAIL'
                    break;
                case 'grafico_EHS':
                    table_dt = 'table_EHS';
                    dt = 'datatable_EHS';
                    posProy = 3;
                    kpi = 'EHS_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
                        ]
                    }
                  },
                  title: {text: title},
                  subtitle: {
                    text: ''
                  },
                  credits: {
                    enabled: false
                  },
                  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'
                            }
                        }
                    }
                },
                 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]
                      }
                    },
                    labels: {
                        format: "{value}%"
                    },
                    min: 0, 
                    max: 100,                  
                  }, { // 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', //amarillo
                    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', //verde grama
                    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=='%Accepted'){
                                    return this.point.y.toFixed(2) + '%';
                                }else{
                                    if (this.point.y!=0){
                                        return this.point.y;
                                    }
                                }
                            }
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];
                                        if($('#asp_user').val()!=''){
                                            var asp = $('#asp_user').val();
                                        }else{
                                           var asp = row._cat_ASP ? row['_cat_ASP'] : $('#asp').val();
                                        }    
                                        if($('#country_user').val()!=''){
                                            var pais = $('#country_user').val();
                                        }else{
                                           var pais = $('#pais').val();
                                        } 
                                        var params = {
                                            'postfix': 'las',
                                            'kpi': kpi,
                                            'FechaInicio': inicio,
                                            'FechaFin': fin,
                                            'selected_item': categoria[this.x],
                                            'selected_serie': this.series.name,
                                            'cliente': row.hasOwnProperty('_cat_Customer') ? row['_cat_Customer'] : $('#cliente').val(),
                                            'proyecto': row.hasOwnProperty('_cat_Project') ? row['_cat_Project'] : $('#proyecto').val(),
                                            'region': row.hasOwnProperty('_cat_Region') ? row['_cat_Region'] :$('#region').val(),
                                            'pais': pais,
                                            'asp': asp,
                                            'mes': row['_cat_Month'],
                                            'detail': $("#detail").val()
                                        };
                                        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 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) {
                        lastCat = lastCat.replace(/ /g, "");
                        var nombre =rawData[k][lastCat];
                        if (rawData[k][lastCat]=='ERGATIKAT'){
                            nombre = 'ERGATIK...';                           
                        }
                        categoryPath.push({
                            name: nombre.replace(/ /g, ""),
                            //categories: []
                        });
                    }
                }
            }
            //if (menor >50) menor= 50;
            //options.yAxis[0].min=menor;

            return $('#' + render).highcharts(options);
        }
        function createChartLinea2(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, inicio, fin, pais, cu, path, rawData)
        {
            var data = new Array();
            //console.log(series);
            if (series.length>0){
                $.each(series, function(key, value) {
                    $.each(value, function(k, v) { 
                    //console.log(k,v); 
                        if(v.name=='AVERAGE FTR'){ 
                           data.push({"color":'#1B9D2C',"name":v.name,"data":v.data});  
                        }else if (v.name=='%FTR'){ 
                          data.push({"color":'#2A587F',"name":v.name,"data":v.data});  
                        }
                    });
                });
            }            
            //console.log(data);
            var options = {
                chart: {
                    marginTop: 80,
            
                    //spacingBottom: 10, //35
                    //spacingTop: 40,
                    //spacingLeft: 40,
                    spacingRight: 40,
                    height: 450,
                    marginBottom: 50, //180
                    borderColor: '#428bca',
                    borderWidth: 1,
                    type: 'line',
                    shadow: true,
                    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
                        ]
                    }
                },                
                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
                    }
                },
                credits: {
                    enabled: false
                },
                yAxis:
                [
                    {
                        min: 0,
                        max: 100,
                        title: {text: 'Percent (%)'},
                        lineWidth: 1,
                        lineColor: '#4c4c4c',
                        plotLines: [
                            {
                                value: 0,
                                width: 1,
                                color: '#808080'
                            }
                        ]
                    }
                ]
                ,
                title: {text: title},
                tooltip: {shared: true},
                //colors: ['#a1c517', '#0082b6', '#b88fef', '#009045', '#db004f'],
                colors: ["#2a587f", "#434348", "#90ed7d", "#f7a35c", "#8085e9",
                    "#f15c80", "#e4d354", "#2b908f", "#f45b5b", "#91e8e1"],
                //series: series
                series: data              
            };

            if (target_line != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line[0],
                    color: '#f7e81d', //amarillo
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: 10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_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', //verde grama
                    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 = {
                                        '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]); //, this.series.name+'='+ this.y);
                                }
                            }
                        }
                    }
                };
            }

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

            return $('#' + render).highcharts(options);
        }
        function createChartColumnTargetPorcente(render, categoria, series, title, w,
                                   inicio, fin, pais, orderArray, path, rawData,parametros,
                                   target11Value,target11Name,
                                   target12Value,target12Name,
                                   target13Value,target13Name)
        {
            var arrayReturn = new Array();
            var data = new Array();
                 
            if (render=='grafico_OTDSS' || render=='grafico_OTDIM' || render=='grafico_OTDIS'  || render=='grafico_OTDRelevamiento'  || render=='grafico_OTDInstalacion'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(k==0){ 
                               data.push({"color":'#00A9E5',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});  
                            }else if (k==1){ 
                              data.push({"color":'#93D543',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});  
                            }else if (k==2){ 
                              data.push({"color":'#F44336',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});  
                            }else{
                                data.push({"name":"%OTD","data":v.data,yAxis: 1});
                            }                      
                            
                        });
                    });
                }      
            }    
            if (render=='grafico_AspProdu1' || render=='grafico_AspProdu2'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if(k==0){ 
                                data.push({"color":'#E3F705',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});  
                            }else if (k==1){ 
                                data.push({"color":'#00A9E5',"name":v.name,"data":v.data,yAxis: 0,type: 'column'}); 
                            }else if (k==2){ 
                                data.push({"color":'#93D543',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});                               
                            }else if (k==3){ 
                                data.push({"color":'#F44336',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});  
                            }else{
                              data.push({"name":"%OTD","data":v.data,yAxis: 1});
                            }                      
                        });
                    });
                }      
            }         
            var subtitle = '';
            if ($('#pais').val()){
                if ($('#pais').val().length>0){
                    var array_cliente = $('#pais').val();
                    var detalle_cliente = $('#pais option').length===array_cliente.length?'ALL':$('#pais').val();
                    subtitle+= " <b>COUNTRY:</b> "+detalle_cliente;
                }
            }
            if ($('#cliente').val()){
                if ($('#cliente').val().length>0){
                    var array_cliente = $('#cliente').val();
                    var detalle_cliente = $('#cliente option').length===array_cliente.length?'ALL':$('#cliente').val();
                    subtitle+= " <b>CUSTOMER:</b> "+detalle_cliente;
                }
            }
            if ($('#proyecto').val()){
                if ($('#proyecto').val().length>0){                    
                    var array_proyecto = $('#proyecto').val();
                    var detalle_proyecto = $('#proyecto option').length===array_proyecto.length?'ALL':$('#proyecto').val();
                    subtitle+= " <b>PROJECT:</b> "+detalle_proyecto;
                }
            }             
            if ($('#asp').val()){
                if ($('#asp').val().length>0){
                    var array_asp = $('#asp').val();
                    var detalle_asp = $('#asp option').length===array_asp.length?'ALL':$('#asp').val();
                    subtitle+= " <b>ASP:</b> "+detalle_asp;
                }
            }                      
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            var height = 250;          
            var options = {
                chart: {
                    //height: height,
                    borderColor: '#428bca',
                    borderWidth: 1,
                    zoomType: 'xy',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: subtitle
                  },
                  xAxis: {
                    categories: [],
                    crosshair: true,
                    labels: {
                        autoRotation: [-10, -20, -30, -40, -50]
                    }
                },
                yAxis: [{
                    title: {
                        text: 'Qty'
                    },
                    //max: 100,
                    //min: 0,
                    labels: {
                        overflow: 'justify'
                    },
                }, {
                    title: {
                        text: 'Percent (%)'
                    },
                    max: 100,
                    min: 0,
                    opposite: true,
                    labels: {
                        format: "{value}%"
                    },
                    plotLines:[{
                        value:target11Value,
                        color: '#f7e81d', //amarillo
                        dashStyle: 'ShortDot',
                        width: 3,
                        zIndex: 4,
                        label:{
                            text: target11Name,
                            align: 'right',
                        }
                    },{
                        value:target12Value,
                        color: '#7cf23c', //verde manzana
                        dashStyle: 'ShortDot',
                        width: 3,
                        zIndex: 4,
                        label:{
                            text: target12Name,
                            align: 'right',
                        }
                    },{
                        value:target13Value,
                        color: '#2e8201', //verde grama
                        dashStyle: 'ShortDot',
                        width: 3,
                        zIndex: 4,
                        label:{
                            text: target13Name,
                            align: 'right',
                        }
                    }]
                }],             
                series: data
            };
             
            var formato = '{point.y}';
            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {
                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true,
                            formatter: function () {
                                if (this.series.name=='%FTR' || this.series.name=='% Critical Defects'){
                                    return this.point.y + '%';
                                }else if (this.series.name=='%OTD'){
                                    return this.point.y.toFixed(2) + '%';
                                }else{
                                    return this.point.y;
                                }
                            }
                        },   
                        legend: {
                            layout: 'vertical',
                            align: 'right',
                            verticalAlign: 'top',
                            x: -40,
                            y: 80,
                            floating: true,
                            borderWidth: 1,
                            backgroundColor: '#FFFFFF',
                            shadow: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];
                                        var categoriaDetalle =  row['_cat_Categoria'];
                                        var selected_serie = this.series.name;   
                                        parametros['tipo_otd'] = '';     
                                        if (render=='grafico_OTDSS' || render=='grafico_OTDIM' || render=='grafico_OTDIS' || render=="grafico_OTDRelevamiento" || render=="grafico_OTDInstalacion"|| render=='grafico_AspProdu1' || render=='grafico_AspProdu2'){              
                                            var t ='';
                                            if (render=='grafico_OTDSS'){
                                                t = 'OTD Site Survey';
                                                parametros['kpi']='DETALLE_OTD_SS';
                                            }else if (render=='grafico_OTDIM'){
                                                t = 'OTD Installation Swap';
                                                parametros['kpi']='DETALLE_OTD_IM';
                                            }else if (render=='grafico_OTDIS'){
                                                t = 'OTD Installation Swap';
                                                parametros['kpi']='DETALLE_OTD_IS';
                                            }else if (render=="grafico_OTDRelevamiento"){
                                                parametros['kpi']='DETALLE_OTD_RELEVAMIENTO_INSTALACION';
                                                t = 'OTD Relevamiento';
                                                parametros['tipo_otd'] = 'otd_relevamiento';
                                            }else if (render=="grafico_OTDInstalacion"){
                                                parametros['kpi']='DETALLE_OTD_RELEVAMIENTO_INSTALACION';
                                                t = 'OTD INSTALLATION';
                                                parametros['tipo_otd'] = 'otd_instalacion';    
                                            }else if(render=='grafico_AspProdu1'){
                                                t = "ASP Productivity OTD Relevamiento";   
                                                parametros['kpi'] = "DETALLE_ASP_PROD";
                                                parametros['tipo_otd'] = 'otd_relevamiento';
                                            } else if(render=='grafico_AspProdu2'){
                                                t = "ASP Productivity OTD INSTALLATION";   
                                                parametros['kpi'] = "DETALLE_ASP_PROD";
                                                parametros['tipo_otd'] = 'otd_instalacion';  
                                            }     
                                            parametros['mes'] = row._cat_Month;
                                            var title_detalle = t;
                                            var subtitle_detalle = "["+row._cat_Month+"]";
                                            //console.log(row);                                       
                                            if (row._cat_PROJECT){
                                                if (row._cat_PROJECT!='TOTAL'){
                                                    parametros['proyecto'] = row._cat_PROJECT;
                                                }else{
                                                    parametros['proyecto'] = $("#proyecto").val();
                                                }
                                                if (row._cat_PROJECT!=''){
                                                    subtitle_detalle+="["+row._cat_PROJECT+"]";
                                                }
                                            }else{
                                                parametros['proyecto'] = $("#proyecto").val();
                                            }  
                                            if (row._cat_ASP){
                                                if (row._cat_ASP!='TOTAL'){
                                                    parametros['asp'] = row._cat_ASP;
                                                }else{
                                                    parametros['asp'] = $("#asp").val();
                                                }
                                                if (row._cat_ASP!=''){
                                                    subtitle_detalle+="["+row._cat_ASP+"]";
                                                }
                                            }else{
                                                parametros['asp'] = $("#asp").val();
                                            }   
                                            if (selected_serie=='Total Services'){
                                                parametros['otd'] = 2;
                                            }else if (selected_serie=='Total Services OTD'){
                                                parametros['otd'] = 1;
                                            }else if(selected_serie=='Total Services Not OTD'){
                                                parametros['otd'] = 0;
                                            }else if(selected_serie=='%OTD'){
                                                $.isLoading("hide");
                                                return false;
                                            }
                                            //ASP PRODU
                                            if (selected_serie=='Services Requested by Ericsson'){
                                                parametros['otd'] = 1;
                                            }else if (selected_serie=='Services Delivery by Supplier'){
                                                parametros['otd'] = 2;
                                            }else if (selected_serie=='Services Not Delivery on Time by Supplier'){
                                                parametros['otd'] = 3;
                                            }else if(selected_serie=='%OTD' || selected_serie=='Capacity Committed by Supplier'){
                                                $.isLoading("hide");
                                                return false;
                                            }
                                            parametros['tipo'] = 0;
                                        }     
                                        parametros['selected_item'] = categoriaDetalle;
                                        generateModal(path, parametros, false,  title_detalle, subtitle_detalle, orderArray);
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }
            var num = categoria.length;
            for (var k=0; k<rawData.length; k++){
                var hasThisCategory = false;
                var categoryIndex = -1;
                var categoryPath = options.xAxis.categories;
                var lastCat = categoria[categoria.length - 1]['sql_name'];
                if (categoria.length>=1){ //Si hay 2 o mas categorias
                    // I. level of categories
                    if (categoria.length >= 1) {
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[0]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[0]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

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

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

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

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[4]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[4]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            return $('#' + render).highcharts(options);        
        }
        function getDataToObject(data, header, key, int){
            var arrayReturn = new Array();
            for (var i = 0; i < data.length; i++){
                var valor = data[i][header[key]];

                if (int){
                    valor = parseFloat(data[i][header[key]]);
                }
                arrayReturn.push(valor);
            }
            return arrayReturn;
        }

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

        function getDataToObjectLinea(data, header){
            var arrayReturn = new Array();
            var data1 = new Array();

            for (var i = 0; i < data.length; i++){
                data1.push(parseFloat(data[i][header[1]]));
            }
            arrayReturn.push({'name': header[1], 'data': data1, 'dataLabels': {'enabled': true}});
            return arrayReturn;
        }

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

            for(var i=0;i<chart.length;i++){
                x.push(chart[i][header[0]]);
            }

            for(var j= 1;j<header.length;j++){
                y.push({name:"",data:[]});
            }

            for(var i=0;i<chart.length;i++){
                for(var j= 1;j<header.length;j++){
                    if(i == 0){
                        y[j-1].name = header[j];
                    }
                    y[j-1].data.push(parseInt(chart[i][header[j]]));
                }
            }
            return new Array(x,y);
        }

        function 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 getParams(type){
            var obj={};
            switch (type){
                case 'ftr':
                    obj={
                        'robust':{'low': 0, 'high':80},
                        'commitment':{'low': 80, 'high':85},
                        'strech':{'low': 85, 'high':100}
                    }
                    break;
                case 'otd':
                    obj={
                        'robust':{'low': 0, 'high':75},
                        'commitment':{'low': 80, 'high':85},
                        'streched':{'low': 85, 'high':100}
                    }
                    break;
            }
        }       

        $('html').on('click', '.openModal', open);               

        function generateModal(ruta, objParams, numerar, title, subtitle, orderArray)
        {               
            var title_ = title!=null ? title.trim() : "";
            var ordArr = orderArray!=null ? orderArray : null;
            $("#datatableModalDetalle").empty().isLoading();
            $('#myModal .punto-grafica').empty().hide();
            $('#myModal .modal_detalle_titulo').empty();

            if (title != null)
            {
                $('#myModal .modal_detalle_titulo').html(title);
                //title_ = title.trim();
                title_ = title_.replace(' ','_');
                title_ = title_.replace('-','');
                title_ = title_.replace(' ','');
            }
            else
            {
                $('#myModal .modal_detalle_titulo').html('{{'monitorii.detail' | trans }}');
                title = '{{'monitorii.detail' | trans }}';
                title_ = title_.replace(' ','_');
                title_ = title_.replace('-','');
                title_ = title_.replace(' ','');
            }

            if (subtitle != null)
            {
                $('#myModal .punto-grafica').html(subtitle).show();
            }

            $.getJSON(ruta, objParams, function (data)
            {
                if (data.length > 0){
                    var total_general = 0; 
                    var porcentaje_ohs = 0; 
                    var total_registros = 0;                 
                    var col = createTableDTDetail(Object.keys(data[0]),'tableModalDetalle', 'datatableModalDetalle',objParams.kpi,porcentaje_ohs,total_registros);
                    buildDatatablePrin('tableModalDetalle',col,data,title_,ordArr);
                    $('[data-toggle="popover"]').popover('destroy');
                    $('[data-toggle="popover"]').popover({
                        template: '<div class="popover" role="tooltip" style="width: 800px;"><div class="arrow"></div><h3 class="popover-title"></h3><div class="popover-content"><div class="data-content"></div></div></div>'
                    }).on("show.bs.popover", function () { $(this).data("bs.popover").tip().css("max-width", "600px"); });
                }else{
                    $("#datatableModalDetalle").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                $("#datatableModalDetalle").isLoading('hide');
            });

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

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

    </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">
                        <div class="row">
                            <input type="hidden" name="mes_seleccionado" id="mes_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" 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 }}">
                            <input type="hidden" name="country_user" id="country_user" value="{{ data_user.country_user }}">
                            <div class="row"> 
                                <div class="col-md-7 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>Date Filter: <span class="detalleRango"></span> </label><br>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="hoy">Today</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimos_7_dias">Week</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="mes_actual">This Month</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="mes_anterior">Last Month</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_6_meses">Last 6 Months</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_12_meses">Last 12 Months</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="rango_fecha">Custom Range</button>
                                    </div>
                                </div> 
                                <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                                    <div class="form-group">                                            
                                       <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>
                                        <input type="text" class="form-control" id="fechaIni" name="fechaIni" value="">
                                    </div> 
                                </div>   
                                <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                                    <div class="form-group">                                            
                                        <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>
                                        <input type="text" class="form-control" id="fechaFin" name="fechaFin" value="">
                                    </div> 
                                </div> 
                            </div>
                            <div class="row">                                 
                                <div id="div_pasi" class="col-md-2 col-sm-6 col-xs-12">
                                    <div id="div_pais" class="form-group input-group">
                                        <label>{{'monitores.pais' | trans}}: </label><br>
                                        <select class="form-control get-list" id="pais" name="pais" data='cliente'
                                        data-act='refresh_pais' data-campo-filtro='country' data-campo-mostrar='customer' multiple="multiple" style="width: 100%;" data-div-siguiente="div_cliente" tabindex="-1">
                                            {%for country in countrys %}
                                                <option value="{{country.valor}}">{{country.nombre}}</option>
                                            {%endfor%}
                                        </select>
                                    </div>
                                </div>                    
                                <div id="div_cliente" class="col-md-2 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>{{'monitores.cliente' | trans}}: </label><br>
                                        <select class="form-control get-list cliente refresh_pais" id="cliente" name="cliente" data='proyecto' data-campo-filtro='customer' data-campo-mostrar='project' data-act='refresh_cliente' style="width: 100%;"data-div-siguiente="div_proyecto">
                                        </select>
                                    </div>
                                </div>
                                <div id="div_proyecto" class="col-md-2 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>{{'monitores.proyecto' | trans}}: </label><br>
                                        <select class="form-control get-list proyecto refresh_pais refresh_cliente" id="proyecto" name="proyecto" data='asp' data-campo-filtro='project' data-campo-mostrar='asp' data-act='refresh_proyecto' style="width: 100%;" data-div-siguiente="div_asp">
                                        </select>
                                    </div>
                                </div>                                  
                                <div id="div_asp" class="col-md-2 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>ASP: </label><br>
                                        <select class="form-control refresh_pais refresh_cliente refresh_proyecto" id="asp" name="asp" style="width: 100%;">
                                        </select>
                                    </div>
                                </div>
                                <div class="col-md-2 col-sm-6 col-xs-12" id="parametros">
                                    <div class="form-group">
                                        <label>{{'Responsible'}}: </label><br>
                                        <select class="form-control" id="responsable" name="responsable" multiple="multiple" style="width: 100%;">
                                                {%for responsible in responsibles %}
                                                    <option value="{{responsible.responsible}}">{{responsible.responsible}}</option>
                                                {%endfor%}
                                        </select>
                                    </div>
                                </div>  
                            </div>
                          
                            <div class="row">                             
                                <div class="col-md-3 col-sm-6 col-xs-12" id="parametros">
                                    <div class="form-group">
                                        <label>{{'Granularity Filter'}}: </label><br>
                                        <select class="form-control detail" id="detail" name="detail" style="width: 100%;">
                                                <option value="month">MONTH</option>
                                                <option value="project">PROJECT</option>
                                                <option value="asp">ASP</option>
                                                <option value="vendor">CONSOLIDATED VENDOR</option>
                                                <option value="asp_month">ASP-MONTH</option>
                                        </select>
                                    </div>
                                </div> 
                                <div class="col-md-3 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>                
            </div>
        </form>
        <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">  
                            
                            <li role="presentation" id="tabsFirstTimeRight" class="click_tab active" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabFirstTimeRight" class="exportar_excel" data="NO"><strong>FTR</strong> (First Time Right)</a></li> 

                            <li role="presentation" id="tabsQualityPerformance" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabQualityPerformance" class="exportar_excel" data="NO"><strong>QP</strong> (Quality Performance)</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> 

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

                            <!-OTD RELEVAMIENTO-->
                            <li role="presentation" id="tabsOTDRelevamiento" class="click_tab" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsOTDRelevamiento">OTD <strong>Site Survey</strong></a></li> 

                            <!-OTD INSTALACIÓN-->
                            <li role="presentation" id="tabsOTDInstalacion" class="click_tab" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_tabsOTDInstalacion">OTD <strong>Installation</strong></a></li> 

                            <!--ASP Productivity OTD 1
                                <li role="presentation" id="tabsAspProdu1" class="click_tab"><a data-toggle="tab" href="#_tabsAspProdu1"><strong>ASP Productivity OTD Site Survey</strong></a></li>-->

                            <!--ASP Productivity OTD 2
                                <li role="presentation" id="tabsAspProdu2" class="click_tab"><a data-toggle="tab" href="#_tabsAspProdu2"><strong>ASP Productivity OTD Installation</strong></a></li>--> 

                                <!--Pareto Root Cause
                                <li role="presentation" id="tabsRootCause" class="click_tab"><a data-toggle="tab" href="#_tabsRootCause"><strong>Pareto Chart</strong></a></li>-->   
                        </ul>
                    </div>
                    <div class="panel-body">
                        <div class="tab-content">
                                                     
                            <!-- FTR-->
                            <div id="_tabFirstTimeRight" class="tab-pane fade active in">
                                <div class="row">
                                    <div id="graficoFirstTimeRight" 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>
                            <!--QP-->
                            <div id="_tabQualityPerformance" class="tab-pane fade">
                                <div class="row">
                                    <div id="graficoQualityPerformance" 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>
                            <!--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>  
                            <!--EHS-->    
                            <div id="_tabsEHS" class="tab-pane fade">
                                <div class="row">
                                    <div id="grafico_EHS" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row">
                                    <div id="datatable_EHS" class="col-sm-12">
                                        <table id="table_EHS" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_EHS"></tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>  
                            <!-- OTD RELEVAMIENTO-->
                            <div id="_tabsOTDRelevamiento" class="tab-pane fade">
                                <div class="row">
                                    <div id="grafico_OTDRelevamiento" class="col-md-12"  style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row">
                                    <div id="datatable_OTDRelevamiento" class="col-sm-12">
                                        <table id="table_OTDRelevamiento" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_OTDRelevamiento"></tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <!-- OTD INSTALACION-->
                            <div id="_tabsOTDInstalacion" class="tab-pane fade">
                                <div class="row">
                                    <div id="grafico_OTDInstalacion" class="col-md-12"  style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row">
                                    <div id="datatable_OTDInstalacion" class="col-sm-12">
                                        <table id="table_OTDInstalacion" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_OTDInstalacion"></tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>     

                            <!-- ASP PRODU 1
                            <div id="_tabsAspProdu1" class="tab-pane fade"> 
                                <div class="row" id="chartcontainer_AspProdu1">
                                    <div id="grafico_AspProdu1" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row">
                                    <div id="datatable_AspProdu1" class="col-sm-12">
                                        <table id="table_AspProdu1" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_AspProdu1"></tbody>
                                        </table>
                                    </div>
                                </div>
                            </div> -->

                            <!-- ASP PRODU 2 -->
                            <div id="_tabsAspProdu2" class="tab-pane fade"> 
                                <div class="row" id="chartcontainer_AspProdu2">
                                    <div id="grafico_AspProdu2" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row">
                                    <div id="datatable_AspProdu2" class="col-sm-12">
                                        <table id="table_AspProdu2" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_AspProdu2"></tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>

                            <!-- Pareto Root Cause -->
                            <div id="_tabsRootCause" class="tab-pane fade"> 
                                <div class="row" id="chartcontainer_RootCause">
                                    <div class="col-lg-6" style="display:true" id="kpi1" style="width: 100%; min-width: 320px;">
                                        <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                            <div class="panel-heading">Pareto Chart - Most Common Root Cause (Relevamiento)</div>
                                            <div class="panel-body fixed-panel" id="grafico_RootCauseRelevamiento" style="width:50%;height: 400px !important;">

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-lg-6" style="display:true" id="kpi2" style="width: 100%; min-width: 320px;">
                                        <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                            <div class="panel-heading">Pareto Chart - Worst Offenders (Relevamiento)</div>
                                            <div class="panel-body fixed-panel" id="grafico_RootOffensorRelevamiento" style="width:50%;height: 400px !important;">

                                            </div>
                                        </div>
                                    </div>
                                </div>   
                                <div class="row" id="chartcontainer_RootCause1">
                                    <div class="col-lg-6" style="display:true" id="kpi3" style="width: 100%; min-width: 320px;">
                                        <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                            <div class="panel-heading">Pareto Chart - Most Common Root Cause (Instalación)</div>
                                            <div class="panel-body fixed-panel" id="grafico_RootCauseInstalacion" style="width:50%;height: 400px !important;">

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-lg-6" style="display:true" id="kpi4" style="width: 100%; min-width: 320px;">
                                        <div class="panel panel-primary" style="height: 450px !important;max-height: 450px !important;">
                                            <div class="panel-heading">Pareto Chart - Worst Offenders (Instalación)</div>
                                            <div class="panel-body fixed-panel" id="grafico_RootOffensorInstalacion" style="width:50%;height: 400px !important;">

                                            </div>
                                        </div>
                                    </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">FTR & QP:</label> {{data_carga.date_carga_qas_ohs}} 
                        </div>
                    </div>
                </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" style="width: 1200px;margin: 0px 0px 0px -140px;">
                <div class="modal-header">
                    <h2 class="modal-title text-center" id="myModalLabel"><strong>{# {'monitorii.detail' | trans } #}<span class="modal_detalle_titulo"></span></strong></h2>
                    <div class="punto-grafica text-center"></div>
                </div>
                <div class="modal-body">
                    <div class="tabla-datos">

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

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