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

{% endblock %}

{% block dashboard %}
    <style>
        .double-scroll {
            width: 100%;
            margin-bottom: 40px;
        }
        /* pager wrapper, div */
        .pager {
            padding-left: 0;
             margin: 0;
            text-align: left;
            list-style: none;
        }
        /* pager wrapper, in thead/tfoot */
        td.pager {
            background-color: #e6eeee;
        }
        /* pager navigation arrows */
        .pager img {
            vertical-align: middle;
            margin-right: 2px;
        }
        /* pager output text */
        .pager .pagedisplay {
            font-size: 14px;
            font-weight: bold;
            padding: 0 5px 0 5px;
            width: 50px;
            text-align: center;
        }

        /*** loading ajax indeterminate progress indicator ***/
        #tablesorterPagerLoading {
            background: rgba(255,255,255,0.8) url(icons/loading.gif) center center no-repeat;
            position: absolute;
            z-index: 1000;
        }

        /*** css used when "updateArrows" option is true ***/
        /* the pager itself gets a disabled class when the number of rows is less than the size */
        .pager.disabled {
            display: none;
        }
        /* hide or fade out pager arrows when the first or last row is visible */
        .pager img.disabled {
            /* visibility: hidden */
            opacity: 0.5;
            filter: alpha(opacity=50);
        }

        .tablesorter-pager select {
            margin: 0;
            padding: 0;
            width: 50px;
        }

        .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: 30px;
        }
            body {
                /*margin-top: 80px;*/
            }
        h1{
            font-size: 36px;
        }
        .tablesorter-header-inner,table.tablesorter thead tr th,.tablesorter-filter {
            color: #fff;
            background-color: #082a99;
            border-color: #2643a5;

        }
        table.tablesorter thead tr th{

            height: 40px;
        }

        .tablesorter-blue .headerSortUp, .tablesorter-blue .tablesorter-headerSortUp, .tablesorter-blue .tablesorter-headerAsc {
            background-color: #082a99;}
        .tablesorter-blue .headerSortDown, .tablesorter-blue .tablesorter-headerSortDown, .tablesorter-blue .tablesorter-headerDesc {
            background-color: #082a99;}


        .tablesorter-blue .tablesorter-filter-row td {
            background: #2643a5;}

        input[type="search"]{
            display: block;
            width: 100%;
            height: 34px;
            padding: 6px 12px;
            font-size: 14px;
            line-height: 1.42857143;
            color: #555;
            background-color: #fff;
            background-image: none;
            border: 1px solid #ccc;
            border-radius: 4px;
            -webkit-box-shadow: inset 0 1px 1px rgba(0,0,0,.075);
            box-shadow: inset 0 1px 1px rgba(0,0,0,.075);
            -webkit-transition: border-color ease-in-out .15s,-webkit-box-shadow ease-in-out .15s;
            -o-transition: border-color ease-in-out .15s,box-shadow ease-in-out .15s;
            transition: border-color ease-in-out .15s,box-shadow ease-in-out .15s;
        }


        .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);
        }
        .container {
            width: 100%;
            height: 400px;
        }
        .chart {
          width: 80%;
        }
    </style>
    <link  href="{{ asset('bootstrap-multiselect/css/bootstrap-multiselect.css') }}" rel="stylesheet" type="text/css" />
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script src="{{asset('js/jquery.doubleScroll.js')}}" type="text/javascript"></script>
    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script>
        $(function () {
            $("#asp").multiselect({
                includeSelectAllOption: true,
                buttonTextAlignment: 'left',
                buttonWidth: '200px'
            });
            $("#region").multiselect({
                includeSelectAllOption: true,
                buttonTextAlignment: 'left',
                buttonWidth: '200px'
            });
            $("#proyecto").multiselect({
                includeSelectAllOption: true,
                buttonTextAlignment: 'left',
                buttonWidth: '200px'
            });
            $.fn.dataTable.moment( 'YYYY-MMM' );
            $('#Filtros_fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#Filtros_fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });
            $('#Filtros_fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });
            //
            $('#fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });
            $('#fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });
            //
            var f = new Date();
            var mes = (f.getMonth() + 1);
            if (mes < 10)
                mes = '0' + mes;
            var fechaI = f.getFullYear() + '-' + mes + "-01";
            var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();
            $('#fechaIni').val(fechaI);
            $('#fechaFin').val(fechaF);
            $(".div_fecha").hide();
            $(".ajuste_fecha").click(function(){
                $('.ajuste_fecha').removeClass('btn-primary');
                $('.ajuste_fecha').addClass('btn-default');
                var id = $(this).attr('id');
                $("#"+id).addClass('btn-primary');
                $(".div_fecha").hide();
                if (id=="rango_fecha"){
                    $(".div_fecha").show();
                }
                rangosFecha(id);
            });

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

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

                return false;

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

            }
            $('.datepicker').datepicker({
                dateFormat: 'yy-mm-dd',
                maxDate: new Date(),
                defaultDate: new Date(),
            }).datepicker("setDate", new Date());
            $("#type").change(function(){
                if($(this).val() == 1){
                    $("#chart1").show();
                    $("#chart3").hide();
                }else{
                    $("#chart1").hide();
                    $("#chart3").show();
                }
            });
            var starYear = 2020;
            var d = new Date();
            var year = d.getFullYear();
            var month = new Array();
            $(".checklist").live('click', function () {
                window.location.href = $(this).attr('href');
            });
        for(var i=starYear; year >= i;i++ )
        {
            $('#ano').append($("<option/>", {
                value: i,
                text: i
            }));
        }
            var anho_actual = i-1;

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

                }
            }

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

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

                $(this).val() == 'mes' ? $("#mes").removeAttr('class','hide'):$("#mes").addClass('hide');
                $(this).val() == 'semana' ? $("#semana").removeAttr('class','hide'):$("#semana").addClass('hide');
                $(this).val() == 'dia' ? $("#dia").removeClass('hide'):$("#dia").addClass('hide');
            });
            $("#generar").click(function (){
                if ($("#rango_fecha").hasClass("btn-primary")){
                    $('#Filtros_fechaIni').val($('#fechaIni').val());
                    $('#Filtros_fechaFin').val($('#fechaFin').val());
                }
                if ($('#Filtros_fechaIni').val()=="" ||  $('#Filtros_fechaFin').val()==""){
                    swal("Error!", "Date Required", "error");
                }else{
                    $.isLoading({
                        text: "Loading"
                    });
                    getReporte();
                    resizeChart();
                }
            });
            $(".tab_summary").click(function(){
                resizeChart();
                resizeChart();
                if ($("#total_summary").val()>0){
                    $(".pager_summary").show();
                    var pagerOptions1 = {
                        container: $(".pager"),
                        output: 'Rows : {endRow}',
                        fixedHeight: false,
                        removeRows: true,
                        cssGoto: '.gotoPage'
                    };
                    $(".table1").tablesorter({
                        theme: 'blue',
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            filter_cssFilter: '',
                            filter_childRows: false,
                            filter_hideFilters: false,
                            filter_ignoreCase: true,
                            filter_reset: '.reset',
                            filter_saveFilters: true
                        }
                    }).tablesorterPager(pagerOptions1);
                    $(".pager").show();
                }else{
                    $(".pager_summary").hide();
                }
            });
            $(".tab_time").click(function(){
                resizeChart();
                if ($("#total_time").val()>0){
                    $(".pager_time").show();
                    var pagerOptions1 = {
                        container: $(".pager"),
                        output: 'Rows : {endRow}',
                        fixedHeight: false,
                        removeRows: true,
                        cssGoto: '.gotoPage'
                    };
                    $(".table2").tablesorter({
                        theme: 'blue',
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            filter_cssFilter: '',
                            filter_childRows: false,
                            filter_hideFilters: false,
                            filter_ignoreCase: true,
                            filter_reset: '.reset',
                            filter_saveFilters: true
                        }
                    }).tablesorterPager(pagerOptions1);
                    $(".pager").show();
                }else{
                    $(".pager_time").hide();
                }
            });
        });

        function getReporte(){
            var proyectoId = '{{idproyectos}}';
            if (proyectoId==11){
                $("#idReporte").val('949');
            }else{
                $("#idReporte").val('636');
            }
            parametros = {};
            var inicio = $('#Filtros_fechaIni').val();
            var fin = $('#Filtros_fechaFin').val();
            var asp = $('#asp').val();
            var proyecto = $('#proyecto').val();
            var region = $('#region').val();
            var valor = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();
            var detail = $("#detail").val();
            if (proyectoId==250) {
                var customer ="MILLICOM";
                var country = "HONDURAS";
                $("#idReporte").val('814');
            }else if (proyectoId==251) {
                var customer ="MILLICOM";
                var country = "PARAGUAY";
                $("#idReporte").val('815');
            }else if (proyectoId==230) {
                var customer ="AMX";
                var country = "PUERTO RICO";
                $("#idReporte").val('816');
            }else if (proyectoId==241) {
                var customer ="AMX";
                var country = "EL SALVADOR";
                $("#idReporte").val('916');
            }else if (proyectoId==236) {
                var customer ="AMX";
                var country = "NICARAGUA";
                $("#idReporte").val('915');
            }else if (proyectoId==60) {
              var customer ="AT&T";
            }else if (proyectoId==11) {
              var customer ="TELCEL";
            }
            var parametros = {
                'FechaInicio': inicio,
                'FechaFin': fin,
                'idReporte': $("#idReporte").val(),
                'date': valor,
                'detail': detail,
                'idproyectos':'{{idproyectos}}',
                'customer': customer,
                'country': country,
                'asp': asp,
                'region': region,
                'proyecto': proyecto
            };
            
            $.getJSON('{{ path('reportemexico_getReportSirEstatus') }}',parametros,function(data){
                var monitor = data.monitor;
                var chart = data;

                if (chart.grafico_SITEEstatusActual.categories.length > 0){
                    $("#grafico_SITEEstatusActual").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_SITEEstatusActual.data, Object.keys(chart.grafico_SITEEstatusActual.data[0]));
                    createChartColumn('grafico_SITEEstatusActual', chart.grafico_SITEEstatusActual.categories, series, 'SITE SURVEY VALIDADOS VS RECHAZADOS - ACTUAL',
                            null, inicio, fin, null,null,"{{ path('reportemexico_detalle_dashborad_site') }}", chart.grafico_SITEEstatusActual.data,parametros,null,null,null,null,null,null);
                }else{
                    if ($("#grafico_SITEEstatusActual").highcharts()!=undefined){
                        $("#grafico_SITEEstatusActual").highcharts().destroy();
                    }
                    $("#grafico_SITEEstatusActual").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }

                //GRAFICO grafico_OTAEstatus
                if (chart.grafico_SITEEstatus.categories.length > 0){
                    $("#grafico_SITEEstatus").empty();
                    var series = getDataToObjectSerieAll(chart.grafico_SITEEstatus.data, Object.keys(chart.grafico_SITEEstatus.data[0]));
                    createChartColumn('grafico_SITEEstatus', chart.grafico_SITEEstatus.categories, series, 'SITE SURVEY VALIDADOS VS RECHAZADOS',
                            null, inicio, fin, null,null,"{{ path('reportemexico_detalle_dashborad_site') }}", chart.grafico_SITEEstatus.data,parametros,null,null,null,null,null,null);
                }else{
                    if ($("#grafico_SITEEstatus").highcharts()!=undefined){
                        $("#grafico_SITEEstatus").highcharts().destroy();
                    }
                    $("#grafico_SITEEstatus").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }

                //GRAFICO OTAS VALIDADAS
               if (chart.grafico_SITEValidados.categories.length > 0){
                   $("#grafico_SITEValidados").empty();
                   var series = getDataToObjectSerieAll1(chart.grafico_SITEValidados.data,Object.keys(chart.grafico_SITEValidados.data[0]));
                   createChartColumnPareto('grafico_SITEValidados', chart.grafico_SITEValidados.categories, series, 'PARETO CHART - ASP SITE SURVEY VALIDADOS',
                          null, null, null, null, parametros,null,"{{ path('reportemexico_detalle_dashborad_site') }}",  chart.grafico_SITEValidados.data,320,'')
               }else{
                   if ($("#grafico_SITEValidados").highcharts()!=undefined){
                       $("#grafico_SITEValidados").highcharts().destroy();
                   }
                   $("#grafico_SITEValidados").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
               }

               //GRAFICO OTAS RECHAZADAS
               if (chart.grafico_SITERechazados.categories.length > 0){
                   $("#grafico_SITERechazados").empty();
                   var series = getDataToObjectSerieAll1(chart.grafico_SITERechazados.data,Object.keys(chart.grafico_SITERechazados.data[0]));
                   createChartColumnPareto('grafico_SITERechazados', chart.grafico_SITERechazados.categories, series, 'PARETO CHART - ASP SITE SURVEY RECHAZADOS',
                          null, null, null, null, parametros,null,"{{ path('reportemexico_detalle_dashborad_site') }}",  chart.grafico_SITERechazados.data,320,'')
               }else{
                   if ($("#grafico_SITERechazados").highcharts()!=undefined){
                       $("#grafico_SITERechazados").highcharts().destroy();
                   }
                   $("#grafico_SITERechazados").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
               }

                $("#total_summary").val(monitor.length);

                if(monitor.length == 0){
                    $("#reporte1").empty();
                    $("#chart1").empty();
                    $("#chart2").empty();
                    $("#reporte1").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                    $.isLoading("hide");
                    $("#inicio").show();
                    return false;
                }else{
                    var objectType = {"9":1,"10":2,"11":3,"12":4,"13":5,"14":6};
                    $("#reporte1").empty().append(createTable(monitor,undefined,undefined,objectType,'table1'));
                    $('.double-scroll').doubleScroll();
                    var pagerOptions = {
                        container: $(".pager"),
                        output: 'Rows : {endRow}',
                        fixedHeight: false,
                        removeRows: true,
                        cssGoto: '.gotoPage'
                    };
                    // initial sort set using sortList option
                    $(".table1").tablesorter({
                        theme: 'blue',
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            filter_cssFilter: '',
                            filter_childRows: false,
                            filter_hideFilters: false,
                            filter_ignoreCase: true,
                            filter_reset: '.reset',
                            filter_saveFilters: true
                        }
                    }).tablesorterPager(pagerOptions);
                    $(".pager").show();
                    $("#inicio").show();
                    $("#autoload").attr('disabled',false);
                }

                resizeChart();
                $.isLoading('hide');
            }).fail(function(){
            $.isLoading('hide');
            });
            resizeChart();
        }

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

        function createChartColumnPareto(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, parametros, orderArray, path, rawData,height,subtitle){
            //ajustar la serie para la doble axies
            var arrayReturn = new Array();
            var data = new Array();
            if (series.length>0){
                $.each(series, function(key, value) {
                    $.each(value, function(k, v) {
                        if(k==0){
                           data.push({"name":v.name,"data":v.data,type: 'column'});
                        }else{
                            data.push({"name":"%","data":v.data,yAxis: 1});
                        }
                    });
                });
            }
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var kpi = "";
            var porcentaje = data[0].data;
            if (porcentaje!="" && porcentaje!=undefined){
                var yMax = porcentaje.reduce(function(a, b) {
                    return Math.max(a, b);
                });
                if (yMax==0){
                    yMax=35;
                }
            }else{
                var yMax=35;
            }
            //console.log(yMax);
            //var height = 320;
             var options = {
                chart: {
                    //height: height,
                    zoomType: 'xy',
                    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'
                                    }
                                }
                            ],
                            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){
                                        parametros['selected_serie'] = '';
                                        var row = rawData[this.x];
                                        parametros['categoria'] = '';
                                        parametros['ofensor'] = '';
                                        var categoriaDetalle =  row['_cat_RootCause'];
                                        var selected_serie = this.series.name;
                                        if (render=='grafico_OTARechazadasCausasTop' || render=='grafico_SITEValidados' || render=='grafico_SITERechazados'){
                                            var t = '';
                                            if(render=='grafico_SITEValidados'){
                                                t = "Pareto Chart - ASP Site Validados";
                                                parametros['kpi'] = "DETALLE_SITE_VALIDADAS_FTR_ASP";
                                            }
                                            if(render=='grafico_SITERechazados'){
                                                t = "Pareto Chart - ASP Site Rechazados";
                                                parametros['kpi'] = "DETALLE_SITE_RECHAZADOS_FTR_ASP";
                                            }
                                            if(render=='grafico_OTARechazadasCausasTop'){
                                                t = "Pareto Chart - OTAS RECHAZADAS TOP 10 DE CAUSAS";
                                                parametros['kpi'] = "DETALLE_OTA_RECHAZADAS_CAUSAS";
                                            }
                                            parametros['mes'] = row._cat_Month?row._cat_Month:'';
                                            parametros['week'] = row._cat_Week?row._cat_Week:'';
                                            parametros['year'] = row._cat_Year?row._cat_Year:'';
                                            var title_detalle = t;
                                            var subtitle_detalle = '';
                                            if (row._cat_ASP){
                                                if (row._cat_ASP!='TOTAL'){
                                                    parametros['asp_categoria'] = row._cat_ASP;
                                                }else{
                                                   parametros['asp_categoria'] = '';
                                                }
                                            }else{
                                                parametros['asp_categoria'] = '';
                                            }
                                            if (selected_serie=='%'){
                                                $.isLoading("hide");
                                                return false;
                                            }
                                            parametros['categoria'] = row._cat_RootCause?row._cat_RootCause:'';
                                            parametros['ofensor'] = row._cat_offender?row._cat_offender:'';
                                            generateModal(path, parametros, false,  title_detalle, subtitle_detalle, orderArray);
                                        }
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }

            var num = categoria.length;

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


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

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

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

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

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[4]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[4]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            return $('#' + render).highcharts(options);
        }
        function createChartColumn(render, categoria, series, title, w,
                                   inicio, fin, pais, orderArray, path, rawData,parametros,
                                   target11Value,target11Name,
                                   target12Value,target12Name,
                                   target13Value,target13Name)
        {
            var arrayReturn = new Array();
            var data = new Array();
            if (render=='grafico_SITEEstatusActual'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {
                            if(k==0){//total
                               data.push({"color":'#00A9E5',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==1){//otas validadas
                              data.push({"color":'#90ED7D',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==2){ //otas por validar
                              data.push({"color":'#FF0000',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==3){ //otas rechazadas
                              data.push({"color":'#E3F705',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            } else if (k==4){ //%validas
                              data.push({"color":'#0C265D',"name":v.name,"data":v.data,yAxis: 1});
                            } else if (k==5){ //%rechazadas
                              data.push({"color":'#F7610F',"name":v.name,"data":v.data,yAxis: 1});
                            }
                        });
                    });
                }
            }
            if (render=='grafico_SITEEstatus'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {
                            if(k==0){//TOTAL
                               data.push({"color":'#0C265D',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if(k==1){//VALIDADOS FTR
                               data.push({"color":'#00A9E5',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==2){//APROBADO
                              data.push({"color":'#90ED7D',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==3){ //RECHAZADO
                              data.push({"color":'#FF0000',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==4){ //POR REVISAR
                              data.push({"color":'#E3F705',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==5){ //VALIDADOS FTR
                              data.push({"color":'#0C265D',"name":v.name,"data":v.data,yAxis: 1});
                            } else if (k==6){ //% RECHAZADO
                              data.push({"color":'#F7610F',"name":v.name,"data":v.data,yAxis: 1});
                            }
                        });
                    });
                }
            }
            if (render=='grafico_OTARechazadasOfensores'){
                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":'#FF0000',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }
                        });
                    });
                }
            }
            if (render=='grafico_OTARechazadasCausas'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {
                            data.push({"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                        });
                    });
                }
            }
            var subtitle = '';
            if ($('#asp').val()){
                if ($('#asp').val().length>0){
                    var array_asp = $('#asp').val();
                    var detalle_asp = $('#asp option').length===array_asp.length?'ALL':$('#asp').val();
                    subtitle+= " <b>ASP:</b> "+detalle_asp;
                }
            }
            if ($('#region').val()){
                if ($('#region').val().length>0){
                    var array_region = $('#region').val();
                    var detalle_region = $('#region option').length===array_region.length?'ALL':$('#region').val();
                    subtitle+= " <b>REGION:</b> "+detalle_region;
                }
            }
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            var height = 250;
            var options = {
                chart: {
                    //height: height,
                    borderColor: '#428bca',
                    borderWidth: 1,
                    zoomType: 'xy',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: subtitle
                  },
                  xAxis: {
                    categories: [],
                    crosshair: true,
                    labels: {
                        autoRotation: [-10, -20, -30, -40, -50]
                    }
                },
                yAxis: [{
                    title: {
                        text: 'Qty'
                    },
                    min: 0,
                    labels: {
                        overflow: 'justify',
                        style: {
                            fontSize: '9px',
                        },
                    },
                }, {
                    title: {
                        text: 'Percent (%)'
                    },
                    max: 100,//render=='grafico_SITEEstatusActual'?600:100,
                    min: 0,
                    opposite: true,
                    labels: {
                        format: "{value}%"
                    }
                }],
                series: data
            };

            var formato = '{point.y}';
            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {
                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true,
                            formatter: function () {
                                return this.point.y;
                            }
                        },
                        legend: {
                            layout: 'vertical',
                            align: 'right',
                            verticalAlign: 'top',
                            x: -40,
                            y: 80,
                            floating: true,
                            borderWidth: 1,
                            backgroundColor: '#FFFFFF',
                            shadow: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];
                                        var selected_serie = this.series.name;
                                        //console.log(row,rawData,selected_serie);
                                        parametros['categoria'] = '';
                                        parametros['ofensor'] = '';
                                        var subtitle_detalle = '';
                                        if (render=='grafico_SITEEstatusActual' || render=='grafico_OTARechazadasOfensores' || render=='grafico_OTARechazadasCausas' || render=='grafico_SITEEstatus'){
                                            var t = '';
                                            parametros['categoria'] = '';
                                            parametros['asp_categoria'] = '';
                                            if(render=='grafico_SITEEstatus'){
                                                t = "SITES VALIDADOS VS SITES RECHAZADOS ";
                                                subtitle_detalle = "["+selected_serie+"]";
                                            }
                                            if(render=='grafico_SITEEstatusActual'){
                                                t = "SITES VALIDADOS VS SITES RECHAZADOS - ACTUAL ";
                                                subtitle_detalle = "["+selected_serie+"]";
                                            }
                                            if(render=='grafico_OTARechazadasOfensores'){
                                                t = "SITES RECHAZADOS OFENSORES ";
                                            }
                                            if(render=='grafico_OTARechazadasCausas'){
                                                t = "SITES RECHAZADOS CAUSAS";
                                                parametros['kpi'] = "DETALLE_OTA_RECHAZADAS_CAUSAS";
                                                parametros['categoria'] = selected_serie;
                                            }
                                            parametros['mes'] = row._cat_Month?row._cat_Month:'';
                                            parametros['week'] = row._cat_Week?row._cat_Week:'';
                                            parametros['year'] = row._cat_Year?row._cat_Year:'';
                                            var title_detalle = t;

                                            if (row._cat_ASP){
                                                if (row._cat_ASP!='TOTAL'){
                                                    parametros['asp_categoria'] = row._cat_ASP;
                                                }
                                            }
                                            //console.log(selected_serie);
                                            if(render=='grafico_SITEEstatus'){
                                                if (selected_serie=='TOTAL'){
                                                    parametros['kpi'] = "DETALLE_SITE_TOTAL";
                                                }else if (selected_serie=='VALIDADOS FTR'){
                                                    parametros['kpi'] = "DETALLE_SITE_VALIDADAS_FTR";
                                                }else if (selected_serie=='POR REVISAR'){
                                                    parametros['kpi'] = "DETALLE_SITE_POR_REVISAR";
                                                }else if (selected_serie=='APROBADO'){
                                                    parametros['kpi'] = "DETALLE_SITE_APROBADO";
                                                }else if (selected_serie=='RECHAZADO'){
                                                    parametros['kpi'] = "DETALLE_SITE_RECHAZADO";
                                                }else if (selected_serie=='% VALIDADOS FTR' || selected_serie=='% RECHAZADOS'){
                                                    $.isLoading("hide");
                                                    return false;
                                                }
                                            }
                                            if(render=='grafico_SITEEstatusActual'){
                                                if (selected_serie=='TOTAL'){
                                                    parametros['kpi'] = "DETALLE_SITE_TOTAL_ACTUAL";
                                                }else if (selected_serie=='APROBADO'){
                                                    parametros['kpi'] = "DETALLE_SITE_APROBADO_ACTUAL";
                                                }else if (selected_serie=='RECHAZADO'){
                                                    parametros['kpi'] = "DETALLE_SITE_RECHAZADO_ACTUAL";
                                                }else if (selected_serie=='POR REVISAR'){
                                                    parametros['kpi'] = "DETALLE_SITE_POR_REVISAR_ACTUAL";
                                                }else if (selected_serie=='% VALIDADOS' || selected_serie=='% RECHAZADOS'){
                                                    $.isLoading("hide");
                                                    return false;
                                                }
                                            }
                                            if(render=='grafico_OTARechazadasOfensores'){
                                                if (selected_serie=='CALIDAD'){
                                                    parametros['kpi'] = "DETALLE_OTA_RECHAZADAS_OFENSORES_CALIDAD";
                                                }else if (selected_serie=='CAMBIO'){
                                                    parametros['kpi'] = "DETALLE_OTA_RECHAZADAS_OFENSORES_CAMBIO";
                                                }
                                            }
                                        }
                                        parametros['selected_serie'] = selected_serie;
                                        generateModal(path, parametros, false,  title_detalle, subtitle_detalle, orderArray);
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }
            var num = categoria.length;
            for (var k=0; k<rawData.length; k++){
                var hasThisCategory = false;
                var categoryIndex = -1;
                var categoryPath = options.xAxis.categories;
                var lastCat = categoria[categoria.length - 1]['sql_name'];
                if (categoria.length>=1){ //Si hay 2 o mas categorias
                    // I. level of categories
                    if (categoria.length >= 1) {
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[0]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[0]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

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

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

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

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[4]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[4]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            return $('#' + render).highcharts(options);
        }
        function 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 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 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"){
                    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'];
                                    //console.log(issues);
                                    if (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://" ' +
                                     'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';*/
                                    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{
                    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 generateModal(ruta, objParams, numerar, title, subtitle, orderArray)
        {
            //console.log(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');
        });

        ////////////////////////////////////////////

        function createChartColumnUser(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=='chartMdrAspOta'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {
                            if(v.name=='QTY MDR'){
                               data.push({"color":'#275f76',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (v.name=='QTY DELTA'){
                              data.push({"color":'#93D543',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (v.name=='%'){ //%
                              data.push({"color":'#F7610F',"name":v.name,"data":v.data,yAxis: 1});
                            }
                        });
                    });
                }
            }
            var subtitle = '';
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            var height = 250;
            var options = {
                chart: {
                    //height: height,
                    borderColor: '#428bca',
                    borderWidth: 1,
                    zoomType: 'xy',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: subtitle
                  },
                  xAxis: {
                    categories: [],
                    crosshair: true,
                    labels: {
                        rotation: 30,
                        formatter: function () {
                            if(this.value.length > 15){
                                return this.value.substring(0, 15) + '...';
                            }
                            return this.value;
                        }
                    },
                },
                yAxis: [{
                    title: {
                        text: 'Qty'
                    },
                    min: 0,
                    labels: {
                        overflow: 'justify',
                        style: {
                            fontSize: '9px',
                        },
                    },
                }, {
                    title: {
                        text: 'Percent (%)'
                    },
                    max: 100,//render=='grafico_SITEEstatusActual'?600:100,
                    min: 0,
                    opposite: true,
                    labels: {
                        format: "{value}%"
                    }
                }],
                series: data
            };

            var formato = '{point.y}';
            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {
                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true,
                            formatter: function () {
                                return this.point.y;
                            }
                        },
                        legend: {
                            layout: 'vertical',
                            align: 'right',
                            verticalAlign: 'top',
                            x: -40,
                            y: 80,
                            floating: true,
                            borderWidth: 1,
                            backgroundColor: '#FFFFFF',
                            shadow: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];
                                        var selected_serie = this.series.name;
                                        //console.log(row,rawData,selected_serie);
                                        parametros['categoria'] = '';
                                        parametros['ofensor'] = '';
                                        var subtitle_detalle = '';
                                        if (render=='chartMdrAspOta'){
                                            var t = '';
                                            parametros['categoria'] = '';
                                            parametros['asp_categoria'] = '';
                                            if(render=='chartMdrAspOta'){
                                                t = "Responsible for Engineering and MDR";
                                                parametros['kpi'] = "DETALLE_MDR_ASP";
                                            }
                                            var title_detalle = t;
                                            var subtitle_detalle = "["+selected_serie+"]";
                                            parametros['mes'] = row._cat_Month?row._cat_Month:'';
                                            parametros['week'] = row._cat_Week?row._cat_Week:'';
                                            parametros['year'] = row._cat_Year?row._cat_Year:'';
                                            var title_detalle = t;

                                            if (row._cat_ASP){
                                                if (row._cat_ASP!='TOTAL'){
                                                    parametros['asp_categoria'] = row._cat_ASP;
                                                }
                                            }
                                            //console.log(selected_serie);
                                            if(render=='chartMdrAspOta'){
                                                if (selected_serie=='QYT MDR'){
                                                    parametros['mrd'] = 1;
                                                }else if (selected_serie=='QYT DELTA'){
                                                    parametros['delta'] = 1;
                                                }else if (selected_serie=='%'){
                                                    $.isLoading("hide");
                                                    return false;
                                                }
                                            }
                                        }
                                        parametros['selected_serie'] = selected_serie;
                                        parametros['usuario'] = row._cat_User?row._cat_User:'';
                                        generateModalNewChart(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 createChartColumnVs(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();
            var subtitle = '';
            if (render=='chartInicadosVsAfectados'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {
                            if (v.name=='INITIATED'){
                              data.push({"color":'#93D543',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if(v.name=='AFFECTED'){
                               data.push({"color":'#275f76',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }
                        });
                    });
                }
            }
            if (render=='chartAprobacion' || render=='chartAprobacionPromedio'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {
                            if (k==0){
                              data.push({"name":'RSC',"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==2){
                                data.push({"name":'ING',"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==4){
                                data.push({"name":'CPM',"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==6){
                                data.push({"name":'SUPPLY',"data":v.data,yAxis: 0,type: 'column'});
                            }
                        });
                    });
                }
            }
            if (render=='chartMDRAprobacion'){
                console.log(series);
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {
                            if (k==0){
                                data.push({"name":'Approved =< 1 Day',"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==2){
                                data.push({"name":'Approved > 1 Day < 2 Days',"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==4){
                                data.push({"name":'Approved > 2 Days < 3 Days',"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==6){
                                data.push({"name":'Approved > 3 Days < 4 Days',"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==8){
                                data.push({"name":'Approved > 4 Days',"data":v.data,yAxis: 0,type: 'column'});
                            }
                        });
                    });
                }
            }

            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            var height = 250;
            //var width= $("#"+render).width();
            var options = {
                chart: {
                    //width: 1366,
                    //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: {
                        rotation: 30,
                        formatter: function () {
                            if(this.value.length > 15){
                                return this.value.substring(0, 15) + '...';
                            }
                            return this.value;
                        }
                    },
                },
                yAxis: [{
                    title: {
                        text: 'Qty'
                    },
                    //max: 100,
                    //min: 0,
                    labels: {
                        overflow: 'justify'
                    },
                }],
                series: data,



                colors: render=='chartMDRAprobacion'?['#267E00', '#56C61A', '#E3F705', '#EC7617', '#D71414',
                                '#492970', '#f28f43', '#77a1e5', '#c42525', '#a6c96a']:render=='chartAprobacionPromedio'?['#1A2754', '#20346D', '#2E4882',
                                '#3B5E92', '#f28f43', '#77a1e5', '#c42525', '#a6c96a']:
                                ['#4fa165', '#910000', '#1aadce',
                                '#492970', '#f28f43', '#77a1e5', '#c42525', '#a6c96a'],
            };

            var formato = '{point.y}';
            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {
                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true,
                            formatter: function () {
                                return this.point.y;
                            }
                        },
                        legend: {
                            layout: 'vertical',
                            align: 'right',
                            verticalAlign: 'top',
                            x: -40,
                            y: 80,
                            floating: true,
                            borderWidth: 1,
                            backgroundColor: '#FFFFFF',
                            shadow: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];
                                        var selected_serie = this.series.name;
                                        if (render=='chartInicadosVsAfectados'){
                                            var t = '';
                                            t = "Sites Initiated Vs. Affected";
                                            var title_detalle = t;
                                            parametros['kpi'] = 'DETALLE_INICIADOS_VS_AFECTADOS';
                                        }
                                        if (render=='chartAprobacion' || render=='chartAprobacionPromedio'){
                                            var t = '';
                                            t = render=='chartAprobacion'?"Approval":"Average approval time per level";
                                            var title_detalle = t;
                                            parametros['kpi'] = 'DETALLE_APROBACION';
                                        }
                                        if (render=='chartMDRAprobacion'){
                                            var t = '';
                                            t = "MDR Approval";
                                            var title_detalle = t;
                                            parametros['kpi'] = 'DETALLE_MDR_APROBACION';
                                        }
                                        var subtitle_detalle = "["+selected_serie+"]";

                                        if (row._cat_ASP){
                                            if (row._cat_ASP!='TOTAL'){
                                                parametros['asp_categoria'] = row._cat_ASP;
                                            }else{
                                               parametros['asp_categoria'] = '';
                                            }
                                        }else{
                                            parametros['asp_categoria'] = '';
                                        }
                                        parametros['selected_serie'] = selected_serie;
                                        parametros['month'] = row._cat_Month?row._cat_Month:'';
                                        parametros['week'] = row._cat_Week?row._cat_Week:'';
                                        parametros['year'] = row._cat_Year?row._cat_Year:'';
                                        generateModalNewChart(path, parametros, subtitle_detalle,  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 createArrayToChart(chart,text)
        {
            var header = Object.keys(chart[0]);
            var x = new Array();
            var y = new Array();

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

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

                y.push({name:"",data:[]});
            }
            for(var i=0;i<chart.length;i++){

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

        function createArrayToPieChart(chart)
        {
            if(chart.length == 0) return false;
            var auxArray = new Array();
            var header = Object.keys(chart[0]);
            for(var i=0;i<chart.length;i++){



                    auxArray.push({'name':chart[i][header[0]],y:parseFloat(chart[i][header[1]])});



            }

            return auxArray;
        }
        function createColumnChart(renderTo,title,chart)
        {
            var data = createArrayToChart(chart);

            var segundaGraficaOpt = {
                chart: {
                    type: 'column',
                    renderTo: renderTo,
                },
                title: {
                    text: title
                },
                xAxis: {
                    categories: data[0],
                    crosshair: true
                },
                yAxis: {
                    title: {
                        text: ''
                    },
                    plotLines:[]
                },
                tooltip: {
                    headerFormat: '<span style="font-size:10px">{point.key}</span><table>',
                    pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' +
                    '<td style="padding:0"><b>{point.y:.0f} SS</b></td></tr>',
                    footerFormat: '</table>',
                    shared: true,
                    useHTML: true
                },
                plotOptions: {
                    column: {
                        pointPadding: 0.2,
                        borderWidth: 0,
                        depth: 40,
                        dataLabels: {
                            enabled: true
                        }
                    }
                },
                series: data[1]
            };
            new Highcharts.Chart(segundaGraficaOpt)
        }
        function createPieChart(renderTo,title,chart)
        {
            var data = createArrayToPieChart(chart);
            console.log(data);
                var pie = {
                    chart: {
                        plotBackgroundColor: null,
                        plotBorderWidth: null,
                        plotShadow: false,
                        type: 'pie',
                        renderTo: renderTo
                    },
                    title: {
                        text: title
                    },
                    tooltip: {
                        pointFormat: '{series.name}: <b>{point.y:.0f}</b>'
                    },
                    plotOptions: {
                        pie: {
                            allowPointSelect: true,
                            cursor: 'pointer',
                            dataLabels: {
                                enabled: true,
                                format: '<b>{point.name}</b>: {point.percentage:.1f} %',
                                style: {
                                    color: (Highcharts.theme && Highcharts.theme.contrastTextColor) || 'black'
                                }
                            },
                            showInLegend: true
                        }
                    },
                    series: [{
                        name: 'Sites',
                        colorByPoint: true,
                        data: data
                    }]
                };
            new Highcharts.Chart(pie);
        }

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

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

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

                          }

                          for (var k=0; k<dataAux1.length; k++){
                            //console.log("dataAux1[k]:",dataAux1[k]);
                            //console.log("total:",total);
                              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;
                  //console.log("data1:",data1);
                  return data1;
              }*/

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

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

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

                    }

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

                    if(header[i]!="pareto") arrayReturn.push({'name': header[i], 'data': dataAux, 'dataLabels': {'enabled': true}});
                    arrayReturn.push({'name': 'pareto1', 'data': dataAux1, 'dataLabels': {'enabled': true}});
                }
            }
            data1[0] = arrayReturn;
            data1[1] = menor;
            data1[2] = mayor;
            return data1;
        }
        /*function createChartColumnPareto(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, parametros, orderArray, path, rawData,height,subtitle){
            //ajustar la serie para la doble axies
            var arrayReturn = new Array();
            var data = new Array();
            if (series.length>0){
                $.each(series, function(key, value) {
                    $.each(value, function(k, v) {
                        if(k==0){
                           data.push({"name":v.name,"data":v.data,type: 'column'});
                        }else{
                            data.push({"name":"%","data":v.data,yAxis: 1});
                        }
                    });
                });
            }
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var kpi = "";
            var porcentaje = data[0].data;
            if (porcentaje!="" && porcentaje!=undefined){
                var yMax = porcentaje.reduce(function(a, b) {
                    return Math.max(a, b);
                });
                if (yMax==0){
                    yMax=35;
                }
            }else{
                var yMax=35;
            }
            //console.log(yMax);
            //var height = 320;
             var options = {
                chart: {
                    //height: height,
                    borderColor: '#428bca',
                    borderWidth: 1,
                    zoomType: 'xy',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: subtitle
                  },
                  enableMouseTracking : false,
                  xAxis: {
                        categories: [],
                        lineWidth: 1,
                        lineColor: '#4c4c4c',
                        //tickColor: '#4c4c4c',
                        //tickWidth: 1,
                        //minorTickWidth: 1,
                        crosshair: true,
                        labels: {
                            rotation: 30,
                            formatter: function () {
                                if(this.value.length > 15){
                                    return this.value.substring(0, 15) + '...';
                                }
                                return this.value;
                            }
                        },
                        overflow: 'justify',
                        scrollbar: {
                            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 () {
                                return this.point.y;
                            }
                        },
                        legend: {
                            layout: 'vertical',
                            align: 'right',
                            verticalAlign: 'top',
                            x: -40,
                            y: 80,
                            floating: true,
                            borderWidth: 1,
                            backgroundColor: '#FFFFFF',
                            shadow: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){

                                    if (rawData != null){
                                        parametros['selected_serie'] = '';
                                        var row = rawData[this.x];
                                        parametros['categoria'] = '';
                                        parametros['ofensor'] = '';
                                        var categoriaDetalle =  row['_cat_RootCause'];
                                        var selected_serie = this.series.name;
                                        if (render=='chartMdrAspOta'){
                                            var t = '';
                                            if(render=='chartMdrAspOta'){
                                                t = "Responsible for Engineering and MDR";
                                                parametros['kpi'] = "DETALLE_MDR_ASP";
                                            }
                                            var title_detalle = t;
                                            var subtitle_detalle = '';
                                            if (row._cat_ASP){
                                                if (row._cat_ASP!='TOTAL'){
                                                    parametros['asp_categoria'] = row._cat_ASP;
                                                }else{
                                                   parametros['asp_categoria'] = '';
                                                }
                                            }else{
                                                parametros['asp_categoria'] = '';
                                            }
                                            parametros['month'] = row._cat_Month?row._cat_Month:'';
                                            parametros['week'] = row._cat_Week?row._cat_Week:'';
                                            parametros['year'] = row._cat_Year?row._cat_Year:'';
                                            parametros['usuario'] = row._cat_User?row._cat_User:'';
                                            generateModalNewChart(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 createChartColumn(render, categoria, series, title, w,
                                         target_line, target_line2, target_line3, parametros, orderArray, path, rawData,height){
                  //ajustar la serie para la doble axies
                  console.log(render);
                  var arrayReturn = new Array();
                  var data = new Array();
                  if (series.length>0){
                      $.each(series, function(key, value) {
                          $.each(value, function(k, v) {
                              //data.push({"name":v.name,"data":v.data,type: 'column'});
                                  if(k==0){
                                     data.push({"name":v.name,"data":v.data,type: 'column'});
                                  }else{
                                      data.push({"name":"%","data":v.data,yAxis: 1});
                                  }
                          });
                      });
                  }
                  //console.log("data:",data);
                  var table_dt = "";
                  var dt = "";
                  var posProy = 0;
                  var col = 4;
                  var rotation = 0;
                  var step = Math.ceil(rawData.length/50);
                  var kpi = "";
                  switch (render){
                      case 'grafico_Causas':
                              rotation = -45;
                              break;
                      case 'grafico_CausasR':
                              rotation = -45;
                              break;
                  }
                  console.log(data);
                  var porcentaje = data[0].data;
                  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: {
                          //width: render=='chartParetoMdrAprobacion'?1366:670,
                          //height: height,
                          zoomType: 'xy',
                          borderWidth: 1,
                          backgroundColor: {
                            linearGradient: [0, 0, 0, 450],
                            stops: [
                                [0, 'rgba(66, 139, 202, 0.3)'], //start
                                [0.5, '#ffffff'], // middle
                                [1, 'rgba(66, 139, 202, 0.2)'] //end
                            ]
                            }
                        },
                        credits: {
                          enabled: false
                        },
                        title: {text: title},
                        subtitle: {
                          text: ''
                        },
                        enableMouseTracking : false,
                        xAxis: {
                              categories: [],
                              lineWidth: 1,
                              lineColor: '#4c4c4c',
                              //tickColor: '#4c4c4c',
                              //tickWidth: 1,
                              //minorTickWidth: 1,
                              crosshair: true,
                              labels: {
                                  groupedOptions: [{ // 1st-level
                                      autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                      //rotation: -30,
                                      lineWidth: 1,
                                      tickWidth: 1,
                                      style: {
                                          fontSize: '10px',
                                          color: '#333333'
                                          //color: '#4c4c4c'
                                      }
                                  }, // 2nd-level
                                      {
                                          autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                          //rotation: 0,
                                          lineWidth: 0,
                                          tickWidth: 0,
                                          //align: 'right',
                                          style: {
                                              fontSize: '9px',
                                              color: '#333333'
                                              //color: '#4c4c4c'
                                          }
                                      }
                                  ],
                                  //step: step,
                                  lineWidth: 0,
                                  tickWidth: 0,
                                  rotation: 0,
                                  style: {
                                      fontSize: '10px',
                                      color: '#333333'
                                      //color: '#4c4c4c'
                                  },
                                  formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                                      if(this.value.length > 15){
                                          return this.value.substring(0, 15) + '...';
                                      }
                                      return this.value;
                                  }
                              },
                              overflow: 'justify',
                              scrollbar: {
                                  enabled: false
                              }
                        },
                        plotOptions:{
                          column: {
                              pointPadding: 0.2,
                              borderWidth: 0,
                              depth: 40,
                              dataLabels: {
                                  enabled: true,
                                  crop: false,
                                  overflow: 'none'
                              }
                          },
                          series:{
                              shadow:true,
                              dataLabels: {
                                  enabled: true,
                                  style: {
                                      fontWeight: 'bold'
                                  }
                              }
                          }
                      },
                      responsive: {
                          rules: [{
                              condition: {
                                  maxWidth: 500
                              },
                              chartOptions: {
                                  legend: {
                                      align: 'center',
                                      verticalAlign: 'bottom',
                                      layout: 'horizontal'
                                  },
                                  yAxis: {
                                      labels: {
                                          align: 'left',
                                          x: 0,
                                          y: -5
                                      },
                                      title: {
                                          text: null
                                      }
                                  },
                                  subtitle: {
                                      text: null
                                  },
                                  credits: {
                                      enabled: false
                                  }
                              }
                          }]
                      },
                      legend: {
                          backgroundColor: 'rgba(66, 139, 202, 0.5)'

                      },

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

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

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

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

                  }

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

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

                                          if (rawData != null){
                                              var row = rawData[this.x];
                                              //var selected_serie = this.series.name;
                                              console.log(row,this);
                                              if (render=='chart1' || render=='chart2' || render=='chartParetoMdrAprobacion'){
                                                if (render=='chart1'){
                                                  categoriaDetalle =   row['_cat_reason'];
                                                  t = 'Detail Causes';
                                                  parametros['kpi']='DETALLE_CHAR1';
                                                  var selected_serie = row._cat_reason;
                                                }else if (render=='chart2'){
                                                  categoriaDetalle =   row['_cat_offender'];
                                                  t = 'Detail Offender';
                                                  parametros['kpi']='DETALLE_CHAR2';
                                                  var selected_serie = row._cat_offender;
                                                }else if(render=='chartParetoMdrAprobacion'){
                                                    categoriaDetalle =   row['_cat_Offender'];
                                                    t = 'Detail Pareto MDR Offender';
                                                    parametros['kpi']='DETALLE_PARETO_MDR_APROBACION';
                                                    var selected_serie = row._cat_Offender;
                                                }
                                                var title_detalle = t;
                                                var subtitle_detalle = "["+selected_serie+"]";
                                                parametros['selected_serie'] = selected_serie;
                                                generateModalNewChart(path, parametros, subtitle_detalle,  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;
                              //console.log("categorias:",categoryPath);
                          }

                          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 createTable(monitor,total,nombreColTotal,type,table){
            var header = Object.keys(monitor[0]);
            var headerType = Object.keys(type);
            var table = '<table  class="table table-bordered table-hover table-striped table-responsive '+table+'" id="tableSitios"> <thead>' +
                    '<tr class="btn-info">';
            for (var j = 0; j < header.length; j++) {
                if( j != 0 && header[j] != 'idticket'){
                    table += "<th class='text-center'>" + header[j] + "</th>"
                }
            }
            table += "</tr></thead>";
            for (var i = 0; i < monitor.length; i++) {
                table += "<tr id='"+ monitor[i][header['idticket']] +"'>";

                for (var j = 0; j < header.length; j++) {
                    var clases   = '';

                        if( $.inArray(j,headerType))
                        {
                            var typeString = 'id="' + type[j] + '"';
                        }

                      if(header[j] == 'ESTADO'){
                          var estado = monitor[i][['ESTADO']];

                          if(estado == 'Aprobado'){
                              clases = 'btn-success';
                          }else if(estado == 'Rechazado'){
                              clases = 'btn-danger';
                          }else if(estado == 'Pendiente por Revision'){
                              clases = 'btn-warning';
                          }/*else{
                              clases = 'btn-warning';
                          }*/
                      }


                    if( j != 0 && header[j] != 'idticket' && header[j] != 'SDE') {
                        table += "<td class='"+clases+"'>" + monitor[i][header[j]] + "</td>";
                    }

                    if (header[j] == 'SDE')
                    {
                        if (monitor[i]['SDE'] != null) {
                            var un = "'" + monitor[i]['SDE'] + "'";
                            table += "<td class='text-center' ><a class='btn btn-link' target='_blank' href="+ un +">SI</a></td>";
                            //table += "<td ><a class='btn btn-link' target='_blank' href="+ un +"><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></td>";

                        } else
                        {
                          table += "<td class='text-center'>NO</td>";
                            //table += "<td ><img border=0; src='{{ asset('images/gray_sync.png') }}'; width='20' height='20'></img></td>";
                        }
                    }
                }
                table += "</tr>";
                if(typeof total !== "undefined") {
                    if (i == monitor.length - 1) {
                        var headerTotal = Object.keys(total);
                        table += '<tr><td>' + nombreColTotal +'</td>';
                        for(var x=0; x<headerTotal.length;x++){
                            table += '<td>';
                            table += total[headerTotal[x]];
                            table += '</td>';
                        }
                        table += '</tr>';
                    }
                }
            }
            table += "</table>";
            return table;
        }

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

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

        function resizeChart(){

                var panel_width = $('.tab-content').width();
                var offset = 22;
                $('#chartAprobacionPromedio').width(panel_width-offset);
                $('#chartMDRAprobacion').width(panel_width-offset);
                $('#chartParetoMdrAprobacion').width(panel_width-offset);
                //$('#chart1').width(panel_width-offset);
                if ($("#chartMDRAprobacion").highcharts()!=undefined){
                    $('#chartMDRAprobacion').highcharts().reflow();
                }
                if ($("#chartAprobacionPromedio").highcharts()!=undefined){
                    $('#chartAprobacionPromedio').highcharts().reflow();
                }
                if ($("#chartParetoMdrAprobacion").highcharts()!=undefined){
                    $('#chartParetoMdrAprobacion').highcharts().reflow();
                }

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

                //$('#chart2').width(panel_width-offset);

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

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

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

        function getTotal(valor,key,tipo)
        {
            var total = new Array();
            var header = Object.keys(valor[0]);
            for(var i = 0; i< valor.length;i++){
                for(var j = 0; j< key.length;j++){
                    if(typeof total[key[j]] === "undefined"){
                        total[key[j]] = 0;
                    }
                    if (tipo==1){
                        total[key[j]] +=  parseFloat(valor[i][header[key[j]]]);
                        if (i == (valor.length-1)) total[key[j]]=parseFloat(total[key[j]]).toPrecision(3);
                        //alert(total[key[j]]);
                    }
                    else
                        total[key[j]] +=  parseInt(valor[i][header[key[j]]]);
                }
            }
            return total;
        }
        function generateModalNewChart(ruta, objParams, numerar, title, subtitle, orderArray)
        {
            //console.log(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');
        }
        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 generateModal(categoria,numerar, title, subtitle, orderArray)
        {
          if (subtitle != '%') {

            //var name = categoria.name;
            var title_ = name!=null ? title.trim() : "";
            var ordArr = orderArray!=null ? orderArray : null;
            $("#datatableModalDetalle").empty().isLoading();
            $('#myModal .punto-grafica').empty().hide();
            $('#myModal .modal_detalle_titulo').empty();
            if (name != null)
            {
                $('#myModal .modal_detalle_titulo').html(name);
                title_ = title_.replace(' ','_');
                title_ = title_.replace('-','');
                title_ = title_.replace(' ','');
            }
            else
            {
                $('#myModal .modal_detalle_titulo').html('{{'monitorii.detail' | trans }}');
                name = '{{'monitorii.detail' | trans }}';
                title_ = title_.replace(' ','_');
                title_ = title_.replace('-','');
                title_ = title_.replace(' ','');
            }
            if (subtitle != null)
            {
                $('#myModal .punto-grafica').html(subtitle).show();
            }

            var proyecto = '{{idproyectos}}';
            if (proyecto==11){
                $("#idReporte").val('949');
            }else{
                $("#idReporte").val('636');
            }
            data = {};
            var tipo  = $("#tipoBusqueda").val();
            switch (tipo){
                case 'semana':
                    data = {'semana': $("#semana").val()}
                    break;
                case 'mes':
                    data = {'mes' : $("#mes").val()}
                    break;
                case 'dia':
                    data = {'dia' : $("#dia").val()}
                    break;
            }
            data['ano'] = $("#ano").val();
            data['idproyectos'] = '{{idproyectos}}';
            if (data['idproyectos']==250) {
                data['customer']="MILLICOM";
                data['pais']="HONDURAS";
                $("#idReporte").val('814');
            }else if (data['idproyectos']==251) {
                data['customer']="MILLICOM";
                data['pais']="PARAGUAY";
                $("#idReporte").val('815');
            }else if (data['idproyectos']==230) {
                data['customer']="AMX";
                data['pais']="PUERTO RICO";
                $("#idReporte").val('816');
            }else if (data['idproyectos']==60) {
              data['customer']="AT&T";
            }else if (data['idproyectos']==11) {
              data['customer']="TELCEL";
            }

            //alert(subtitle);

            if (subtitle == 'Reason') {
              data['categoria'] = categoria.name;
              $.getJSON('{{path('reportemexicoatt_getReportInventorySdeDetalle')}}',data, function (data)
              {
                var bateria  = data.bateria;

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

            }else if (subtitle == 'Offender') {
              data['categoria'] = categoria.name;
              $.getJSON('{{path('reportemexicoatt_getReportInventorySdeDetalle2')}}',data, function (data)
              {
                var bateria  = data.bateria;

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

            }

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

          }
        }*/

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

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

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

    </script>

    <div class="container-fluid">
        <input type="hidden" id="total_summary" name="total_summary">
        <input type="hidden" id="total_time" name="total_time">
        <div class="row">
            <div class="col-lg-2" id="parametros">
            </div>
            <div class="col-lg-2" id="parametros">
            </div>
            <div class="col-lg-2 " id="parametros" >
            </div>
            <div class="col-lg-3" id="parametros" >
            </div>

        </div>
        <div class="panel panel-primary">
                <div class="panel-heading">
                    <h3 class="panel-title"><a data-toggle="collapse" href="#collapse1">Filters <span class="caret"></span></a></h3>
                </div>
                <div id="collapse1" class="panel-collapse collapse in">
                    <div id="panelFilter" class="panel-body">
                        <div class="row">
                            <input type="hidden" class="form-control" id="Filtros_fechaIni" name="Filtros_fechaIni" value="">
                            <input type="hidden" class="form-control" id="Filtros_fechaFin" name="Filtros_fechaFin" value="">
                            <div class="row">
                                <div class="col-md-7 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>Date Filter: <span class="detalleRango"></span> </label><br>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="hoy">Today</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimos_7_dias">Week</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="mes_actual">This Month</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="mes_anterior">Last Month</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_6_meses">Last 6 Months</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_12_meses">Last 12 Months</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="rango_fecha">Custom Range</button>
                                    </div>
                                </div>
                                <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                                    <div class="form-group">
                                       <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>
                                        <input type="text" class="form-control" id="fechaIni" name="fechaIni" value="">
                                    </div>
                                </div>
                                <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                                    <div class="form-group">
                                        <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>
                                        <input type="text" class="form-control" id="fechaFin" name="fechaFin" value="">
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="row">
                                <div class="col-lg-2">
                                    <div class="form-group">
                                        <label>{{'PROJECT' | trans}}: </label><br>
                                        <select class="form-control" id="proyecto" name="proyecto" style="width: 100%;">  
                                                <option value="">All</option>
                                                <option value="161">GIGARED</option>
                                                <option value="155">5G</option>
                                        </select>
                                    </div>
                               </div>

                             <div class="col-lg-2">
                                    <div class="form-group">
                                        <label>{{'REGION' | trans}}: </label><br>
                                        <select class="form-control" id="region" name="region" style="width: 100%;">
                                            <option value="">All</option>
                                            {%for region in regiones %}
                                                <option value="{{region.region}}">{{region.region}}</option>
                                            {%endfor%}
                                        </select>
                                    </div>
                             </div>

                            <div class="col-lg-2">
                                    <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 class="col-lg-6">
                            </div>
                    </div>
                </div>
        </div>
        </div>
        <div class="row">
            {% if identity is not empty %}

                <div class="pull-right" style="">

                    <div class="col-lg-12">
                        <img id="logo" src="{{ asset( identity.pathLogo ) }}"  width="350" height="65">
                        <p class="text-center" style="font-size: 14pt;font-weight: bold;">{{ identity.alias }}</p>
                    </div>
                </div>

            {% endif %}

        </div>
        <row>
            <div class="col-lg-12 col-md-12">
                <h1 class="text-center text-primary"><i class="fa fa-file-text-o"></i>Site Survey</h1>
            </div>
        </row>

        <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="tabsOtasEstatus" class="click_tab active" data-filtro="div_fechaIni div_fechaFin div_asp"><a data-toggle="tab" href="#_tabsOtasEstatus" class="exportar_excel" data="NO">SITE SURVEY VALIDADOS VS RECHAZADOS</a></li>

                            <!-- <li role="presentation" id="tabsOtasRechazadas" class="click_tab" data-filtro="div_fechaIni div_fechaFin div_asp"><a data-toggle="tab" href="#_tabsOtasRechazadas" class="exportar_excel" data="NO">OTAS RECHAZADAS</a></li>-->
                        </ul>
                    </div>
                    <div class="panel-body">
                        <div class="tab-content">

                            <!-- OTAS ESTATUS -->
                            <div id="_tabsOtasEstatus" class="tab-pane fade active in">
                                <div class="row">
                                    <div id="grafico_SITEEstatusActual" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row" style="margin-top: 30px;">
                                    <div id="grafico_SITEEstatus" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row" style="margin-top: 30px;">
                                    <div id="grafico_SITEValidados" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row" style="margin-top: 30px;">
                                    <div id="grafico_SITERechazados" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                            </div>
                            <!-- OTAS RECHAZADAS -->
                            <div id="_tabsOtasRechazadas" class="tab-pane fade">
                                <div class="row">
                                    <div id="grafico_OTARechazadasOfensores" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row" style="margin-top: 30px;">
                                    <div id="grafico_OTARechazadasCausas" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row" style="margin-top: 30px;">
                                    <div id="grafico_OTARechazadasCausasTop" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

    <div id="inicio">
       <!-- <ul class="nav nav-pills nav-justified">
            <li class="active tab_summary"><a data-toggle="tab" href="#_summary"><strong>Summary</strong></a></li>
            <li class="tab_time"><a data-toggle="tab" href="#_detail"><strong>Lead Time</strong></a></li>
        </ul>-->

        <div class="row">
            <div class="btn-group pull-right" role="group" aria-label="..." style="margin-right: 50px">
                <!--<a href="#" onclick="$('#tableSitios').tableExport({type: 'excel', escape: 'false',fileName: 'Distribuidores',ignoreRow: [1]});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a>-->
                <form id="formExport"  action="{{ path('exportReporte',{'idproyectos':idproyectos}) }}" method="POST">
                    <input type="hidden" id="idReporte" name="idReporte" value="949">
                </form>
                <a id="export" href="{{ path('exportReporte',{'idproyectos':idproyectos}) }}?idReporte=949" > <img src={{ asset("images/xls.png")}} width="24px"> XLS</a>

            </div>

        </div>
        <div class="pager pager_summary">
                    <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                    <span class="pagedisplay"></span>
                </div>
                <div class="row double-scroll" id="reporte1">


                </div>

        <div id="pager" class="pager" style="display: none;text-align: center; ">
            <form>
                <img src="{{asset('tablesorter-master/addons/pager/icons/first.png')}}" class="first"/>
                <img src="{{asset('tablesorter-master/addons/pager/icons/prev.png')}}" class="prev"/>

                <img src="{{asset('tablesorter-master/addons/pager/icons/next.png')}}" class="next"/>
                <img src="{{asset('tablesorter-master/addons/pager/icons/last.png')}}" class="last"/>
                <span class="pagedisplay"></span>
                <select class="pagesize" title="Select page size">
                    <option selected="selected" value="1000">1000</option>
                    <option  value="500">500</option>
                    <option  value="100">100</option>

                </select>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="modalDetail" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header  bg-primary">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                    <h2 class="modal-title text-center" id="myModalLabel"> {{'monitorii.detail' | trans}}</h2>
                </div>
                <div class="modal-body">
                </div>
                <div class="modal-footer">
                    <button id="savePlan" type="button" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                    <button type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                </div>
            </div>
        </div>
    </div>

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

                <div class="modal-body">


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

                </div>

            </div>
        </div>
    </div>

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

                    </div>
                    <div id="datatableModalDetalle" class="col-sm-12" {#style="overflow-x: scroll"#}>
                        <table id="tableModalDetalle" class="display nowrap" width="100%">
                            <tbody id="tbodyModalDetalle">
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-claro" data-dismiss="modal">
                        {{'monitorii.close' | trans}}
                        <span class="glyphicon glyphicon-remove"></span>
                    </button>
                </div>
            </div>
        </div>
    </div>
{% endblock %}
{% block javascripts %}
    <link rel="stylesheet" href="{{ asset('css/jquery.dataTables.min.css')}}">
    <link rel="stylesheet" href="{{ asset('css/buttons.dataTables.min.css')}}">
    <link rel="stylesheet" href="{{ asset('datatables/css/select.bootstrap.min.css')}}">
    <script src="{{ asset('js/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('js/buttons.flash.min.js') }}"></script>
    <script src="{{ asset('js/jszip.min.js') }}"></script>
    <script src="{{ asset('js/pdfmake.min.js') }}"></script>
    <script src="{{ asset('js/vfs_fonts.js') }}"></script>
    <script src="{{ asset('js/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('js/buttons.print.min.js') }}"></script>
    <script src="{{ asset('datatables/js/dataTables.select.min.js') }}"></script>
    <script src="{{ asset('datatables/moment.min.js') }}"></script>
    <script src="{{ asset('datatables/js/datetime-moment.js') }}"></script>
    <script src="{{ asset('js/grouped-categories.js') }}"></script>
    <script type="text/javascript" src="{{ asset('bootstrap-multiselect/js/bootstrap-multiselect.js') }}"></script>
{% endblock %}