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

{% endblock %}

{% block dashboard %}
    <style>
        table th{
        {#text-transform: uppercase;#}
            font-weight: bold;
            font-size: 12px;
        }

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

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

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

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

        table.tablesorter thead tr th, table.tablesorter tfoot tr th {
            background-color: #428bca;
            border: 1px solid #FFF;
            font-size: 8pt;
            padding: 4px;
            color: white;
        }


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

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

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

        @keyframes spin {
            from { transform: scale(1) rotate(0deg);}
            to { transform: scale(1) rotate(360deg);}
        }
        .disabledTab{
            pointer-events: none;
        }
        .table-responsive {
            height: 400px !important;
            overflow: scroll;
            }
             .btn-claro {
            color: #fff;
            background-color: #428bca;
            border-color: #357ebd ;

            }
            .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
            }
            .table th{
                font-size: 10pt;
            }
            .table td{
                font-size: 9pt;
            }

            .double-scroll {
                width: 100%;
            }
            #parametros .panel-body .row{

                padding-left: 5px;
            }

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

        .tablesorter-header-inner,table.tablesorter thead tr th,.tablesorter-filter {
            color: #fff;
            background-color: #428bca;
            border-color: #1598d9;
        }
        table.tablesorter thead tr th{
            height: 40px;
        }
        .tablesorter-blue .headerSortUp, .tablesorter-blue .tablesorter-headerSortUp, .tablesorter-blue .tablesorter-headerAsc {
            background-color: #428bca;}
        .tablesorter-blue .headerSortDown, .tablesorter-blue .tablesorter-headerSortDown, .tablesorter-blue .tablesorter-headerDesc {
            background-color: #428bca;}
        .tablesorter-blue .tablesorter-filter-row td {
            background: #428bca;border-color: #1598d9;}
        input[type="search"]{
            display: block;
            width: 100%;
            height: 34px;
            padding: 6px 12px;
            font-size: 12px;
            line-height: 1.42857143;
            color: #555;
            background-color: #fff;
            background-image: none;
            border: 1px solid #ccc;
            border-radius: 4px;
            -webkit-box-shadow: inset 0 1px 1px rgba(0,0,0,.075);
            box-shadow: inset 0 1px 1px rgba(0,0,0,.075);
            -webkit-transition: border-color ease-in-out .15s,-webkit-box-shadow ease-in-out .15s;
            -o-transition: border-color ease-in-out .15s,box-shadow ease-in-out .15s;
            transition: border-color ease-in-out .15s,box-shadow ease-in-out .15s;
        }
        .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.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;
        }
        /* Dropdown Button */
        .dropbtn {
          /*background-color: #428bca;*/
          /*color: white;*/
          padding: 10px;
          font-size: 16px;
          border: none;
        }

        /* The container <div> - needed to position the dropdown content */
        .dropdown {
          position: relative;
          display: inline-block;
        }

        /* Dropdown Content (Hidden by Default) */
        .dropdown-content {
          display: none;
          position: absolute;
          /*background-color: #f1f1f1;*/
          min-width: 160px;
          box-shadow: 0px 8px 16px 0px rgba(0,0,0,0.2);
          z-index: 1;
        }

        /* Links inside the dropdown */
        .dropdown-content a {
          /*color: black;*/
          padding: 12px 16px;
          text-decoration: none;
          display: block;
        }

        /* Change color of dropdown links on hover 
        .dropdown-content a:hover {background-color: #ddd;}*/

        /* Show the dropdown menu on hover 
        .dropdown:hover .dropdown-content {display: block;}*/

        /* Change the background color of the dropdown button when the dropdown content is shown 
        .dropdown:hover .dropbtn {background-color: #1598d9;}*/

    </style>

    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script src="{{ asset('js/jquery.numeric.js') }}"></script>
    <script src="{{ asset('js/jquery.form.js') }}"></script>    
    <script type="text/javascript" src="{{ asset('js/jquery.inputmask.js') }}"></script>
    <script type="text/javascript" src="{{ asset('js/jquery.inputmask.numeric.extensions.min.js') }}"></script>
    <script src="{{ asset('js/jquery.isloading.js') }}" type="text/javascript"></script>
    <script>
        $(document).ready(function() {  
            $('#myTabs a:first').tab('show');
            $(".activar_auditoria").show();
             $("#generar").click(function(){  
                $.isLoading({
                    text: "Loading"
                });              
               getReporte();
            });            
            $(".click_tab").click(function(){
                resizeChart();
            });

            $("#auditoria_sitios").click(function(){
                $(".pager ").show(); 
                resizeChart();         
                if ($("#total_monitor").val()>0){
                    $(".pager_auditoria_sitios").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_auditoria_sitios").hide();
                }
            });

            //AUDITORIA
            $(".activar_dashboard").click(function(){               
                $(".pager ").hide();
                resizeChart();
            });
            $(".activar_dashboard").click(function(){               
                $(".pager ").hide();
                resizeChart();
            });

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

                }
            });

            $('#Filtros_fechaFin').datepicker({
                    dateFormat: 'yy-mm-dd',
            });   
            resizeChart();  
            $(".get-list").change(function(e) {
                var data_select_refresh = $(this).attr('data');
                var data_act = $(this).attr('data-act');
                var campo_filtrar = $(this).attr('data-campo-filtro');  
                var campo_mostrar = $(this).attr('data-campo-mostrar'); 
                var data = {
                    valor_filtro : $(this).val(),
                    campo_filtrar : campo_filtrar,
                    campo_mostrar : campo_mostrar,
                };
                //console.log(data);
                $("."+data_act+" option").remove();
                $("."+data_act).append('<option value="TODOS">-- All --</option>');
                if ($(this).val()!='TODOS'){                    
                    $.getJSON('{{path('reporteonboarding_llenarSelect')}}', data, function (data){
                        var registros = data.registros;
                        for (var i = 0; i < registros.length; i++){
                            $("#"+data_select_refresh).append('<option value="' + registros[i]['valor'] + '">' + registros[i]['nombre'] + '</option>');
                        }
                    });
                }
            });            
        });

        function getReporte(){
            $("#_dashboard").removeClass('in'); 
            $("#_dashboard").removeClass('active'); 
            $("#dashboard").removeClass('active');  
            $("#auditoria_sitios").addClass('active');       
            $("#_auditoria_sitios").addClass('active');
            $("#_auditoria_sitios").addClass('in');              
            
            var parametros = {};
            parametros['cu'] = $("#cu").val();
            parametros['pais'] = $("#pais").val();
            //parametros['region'] = $("#region").val();
            //parametros['proyecto'] = $("#proyecto").val();
            //parametros['cliente'] = $("#cliente").val();
            parametros['asp'] = $("#asp").val();
            parametros['fechaIni'] = $("#Filtros_fechaIni").val();
            parametros['fechaFin'] = $("#Filtros_fechaFin").val();           
            var inicio = $('#Filtros_fechaIni').val();
            var fin = $('#Filtros_fechaFin').val();
            $.getJSON('{{path('reporteonboarding_GenerarMonitor')}}',parametros, function (data) {
                ////////////////////////
                //GRAFICO1
                if (data.grafico1.categories.length > 0){
                    $("#grafico1").empty();
                    var series = getDataToObjectSerieAll(data.grafico1.data, Object.keys(data.grafico1.data[0]));
                    createChartColumnTargetPorcenteProduc('grafico1', data.grafico1.categories, series, '  ',
                            null, inicio, fin, null,null,"{{ path('reporteonboarding_detalle_onboarding') }}", data.grafico1.data,parametros,null,null,null,null,null,null); 
                }else{
                    if ($("#grafico1").highcharts()!=undefined){
                        $("#grafico1").highcharts().destroy();
                    }                    
                    $("#grafico1").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                } 
                //TABLA GRAFICA1
                if(data.table_grafico1.length == 0){
                  $(".pager_sitios_po").hide();
                  $("#datatable_grafico1").empty();
                  $("#datatable_grafico1").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                }else {
                  $("#datatable_grafico1").empty().append(createTable(data.table_grafico1,'','',3));
                  var pagerOptions3 = {
                       container: $(".pager"),
                       output: 'Rows : {endRow}',
                       fixedHeight: false,
                       removeRows: true,
                       cssGoto: '.gotoPage'
                   };
                  $(".table3").tablesorter({
                      theme: 'blue',
                      widgets: ["zebra", "filter"],
                      widgetOptions: {
                          filter_cssFilter: '',
                          filter_childRows: false,
                          filter_hideFilters: false,
                          filter_ignoreCase: true,
                          filter_reset: '.reset',
                          filter_saveFilters: true
                      }
                  }).tablesorterPager(pagerOptions3);
                  $(".pager").show();
                }          
                ///////////////////////
                var monitor_onboarding  = data.monitor_onboarding;
                $("#total_monitor_onboarding_po").val(monitor_onboarding.length);
                if(monitor_onboarding.length == 0){
                  $(".pager_auditoria_sitios").hide();
                  $("#reporte_auditoria_sitios").empty();
                  $("#reporte_auditoria_sitios").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');                  
                  
                }else {
                  $("#reporte_auditoria_sitios").empty().append(createTable(monitor_onboarding,'','',1));
                }
                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();
                $("#auditoria_sitios").trigger('click');
                resizeChart();
                $.isLoading("hide");  
            });                      
            
        }
        function createChartColumnTargetPorcenteProduc(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=='grafico1'){
                if (series.length>0){
                    $.each(series, function(key, value) {
                        $.each(value, function(k, v) {  
                            if (k==0){ //1ER AZUL
                                data.push({"color":'#0070C0',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }else if (k==1){ //NARANJA
                                data.push({"color":'#F7AC08',"name":v.name,"data":v.data,yAxis: 0,type: 'column'}); 
                            }else if (k==2){ //2DO AZUL
                                data.push({"color":'#002060',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});  
                            }else if (k==3){ //TERCER AZUL
                                data.push({"color":'#00B0F0',"name":v.name,"data":v.data,yAxis: 0,type: 'column'});
                            }                  
                        });
                    });
                }      
            }   
            var subtitle = '';                     
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            var height = 250;          
            var options = {
                chart: {
                    //height: height,
                    borderColor: '#428bca',
                    borderWidth: 1,
                    zoomType: 'xy',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: subtitle
                  },
                  xAxis: {
                    categories: [],
                    crosshair: true,
                    labels: {
                        autoRotation: [-10, -20, -30, -40, -50]
                    }
                },
                yAxis: [{
                    title: {
                        text: 'Qty',
                    },
                    labels: {
                        overflow: 'justify'
                    },
                }, ],             
                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 '<span style="color: #000;font-size: 12px;">' + this.point.y + '</span>';
                            }
                        },   
                        legend: {
                            layout: 'vertical',
                            align: 'right',
                            verticalAlign: 'top',
                            x: -40,
                            y: 80,
                            floating: true,
                            borderWidth: 1,
                            backgroundColor: '#FFFFFF',
                            shadow: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];  
                                        //console.log(row,rawData);
                                        var categoriaDetalle =  row['_cat_Tipo'];
                                        var selected_serie = this.series.name;
                                        if (render=='grafico1'){
                                            var t = '  '; 
                                            parametros['kpi'] = "grafico1_DETAIL";        
                                            parametros['selected_serie'] = selected_serie;
                                            parametros['selected_item'] = categoriaDetalle;
                                            var title_detalle = t + '<br>['+ categoriaDetalle+'] ['+ selected_serie+']';
                                            var subtitle_detalle = '';
                                        }     
                                        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 generateModal(ruta, objParams, numerar, title, subtitle, orderArray)
        { 
                    
            var title_ = title!=null ? title.trim() : "";
            var ordArr = orderArray!=null ? orderArray : null;
            $("#datatableModalDetalle").empty().isLoading();
            $('#myModal .punto-grafica').empty().hide();
            $('#myModal .modal_detalle_titulo').empty();

            if (title != null)
            {
                $('#myModal .modal_detalle_titulo').html(title);
                //title_ = title.trim();
                title_ = title_.replace(' ','_');
                title_ = title_.replace('-','');
                title_ = title_.replace(' ','');
            }
            else
            {
                $('#myModal .modal_detalle_titulo').html('{{'monitorii.detail' | trans }}');
                title = '{{'monitorii.detail' | trans }}';
                //title_ = title.trim();
                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 col = createTableDTDetail(Object.keys(data[0]),'tableModalDetalle', 'datatableModalDetalle',objParams.kpi,porcentaje_ohs,0);
                    buildDatatablePrin('tableModalDetalle',col,data,title_,ordArr,objParams);
                    $('[data-toggle="popover"]').popover('destroy');
                    $('[data-toggle="popover"]').popover({
                        template: '<div class="popover" role="tooltip" style="width: 800px;"><div class="arrow"></div><h3 class="popover-title"></h3><div class="popover-content"><div class="data-content"></div></div></div>'
                    }).on("show.bs.popover", function () { $(this).data("bs.popover").tip().css("max-width", "600px"); });
                }else{
                    $("#datatableModalDetalle").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                $("#datatableModalDetalle").isLoading('hide');
            });

            $('#myModal').modal('show');
        }
        function createTableDTDetail(data, tableRender, dtRender, type, porcentaje_ohs, total_registros){
            var strHeader = "";
            var strFooter="";
            var columns = [];
            var col_issues = 8;
            var strType = (type == null ? "" : type);
            var strTable = '<table id="' + tableRender + '" class="display cell-border compact stripe" width="100%">' +
                    '<thead><tr class="header_dt">';
            $('#' + dtRender).empty();
            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>';
                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 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 createTable(monitor, total, nombreColTotal, option) {
            var header = Object.keys(monitor[0]);
            var table;
            table = '<table  id="tabla1" class="table table-bordered table-hover table-striped table'+option+'" style="text-align:left">';
            table += "<thead><tr>";
            for (var j = 0; j < header.length; j++) {
                if (header[j]!='form_id'){
                    var strHideFilter = '';
                    table += "<th style='vertical-align:middle;' class='text-center " + strHideFilter + "'>" + header[j] + "</th>";
                }
            }
            table += "</tr></thead>";   

            for (var i = 0; i < monitor.length; i++) {
                table += "<tr id="+monitor[i]['form_id']+">";
                var form_id = monitor[i]['form_id'];
                var asp = monitor[i]['ASP'];
                var semana = monitor[i]['WEEK'];
                var year = monitor[i]['YEAR'];
                var pais = monitor[i]['COUNTRY'];
                for (var j = 0; j < header.length; j++) {
                    if (header[j]!='form_id'){
                        var strHideFilter = '';
                        table += "<td style='"+strHideFilter+"' >" + monitor[i][header[j]] + "</td>"; 
                    }  
                }
                table += "</tr>";
            }
            table += "</table>";
            
            return table;
        }
        Highcharts.wrap(Highcharts.Axis.prototype, 'getPlotLinePath', function(proceed) {
            var path = proceed.apply(this, Array.prototype.slice.call(arguments, 1));
            if (path) {
                path.flat = false;
            }
            return path;
        });
        var projectList = new Array(4); //Lista de proyectos para cada gráfico
        function createTableDT(data, tableRender, dtRender){
            var strHeader = "";
            var strFooter="";
            var columns = [];
            var strTable = '<table id="' + tableRender + '" class="display cell-border compact stripe" width="100%">' +
                    '<thead><tr class="header_dt">';
            $('#' + dtRender).empty();
            for (var i=0; i<data.length; i++){
                var title = data[i];
                var t = title.replace(/_/g,' ');
                t = title.replace('#','');
                var visible = title.startsWith('_') ? false : true;
                strHeader += '<th style="vertical-align:middle;" class="text-center">' + t + '</th>';
                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 verDetalle(semana,year,asp,pais){
            console.log(semana,year,asp,pais);
            var path = "{{ path('reporteonboarding_detalle_onboarding') }}";
            var parametros = {};
            parametros['cu'] = $("#cu").val();
            parametros['fechaIni'] = $("#Filtros_fechaIni").val();
            parametros['fechaFin'] = $("#Filtros_fechaFin").val();  
            parametros['kpi'] = "table_DETAIL";        
            parametros['semana'] = semana;
            parametros['year'] = year;
            parametros['asp'] = asp;
            parametros['pais'] = pais;
            var title_detalle = 'DETAIL '+pais+' - '+ asp;
            var subtitle_detalle = '';     
            generateModal(path, parametros, false,  title_detalle, subtitle_detalle, null)

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

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


            switch(strType.toLocaleUpperCase()){
                case 'QP':
                case 'QP_DETAIL':
                    col_issues = 8;
                    break;
                case 'OHS':
                case 'OHS_DETAIL':
                    col_issues = 9;
                    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;

                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"){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi="";
                                var popup_title = "";
                                var strIssuesHtml = "<ol>";
                                var strIssuesText = "";
                                var url= "";
                                if (row.hasOwnProperty('_ISSUES')){
                                    kpi='ftr';
                                    popup_title = 'Issues';
                                    var issues = row['_ISSUES'];     
                                    var arrIssues = issues.split("<br>");                               
                                    if (Array.isArray(arrIssues)){                                        
                                        for (var i=0; i<arrIssues.length; i++){
                                            strIssuesHtml += "<li>" + arrIssues[i] + ".</li>";
                                            strIssuesText += i + ". " +  arrIssues[i] + ".\r\n";
                                        }
                                    }else{
                                        strIssuesHtml = issues;
                                    }
                                    strIssuesHtml += "</ol>";
                                }
                                if (type==='display'){
                                    /*return '<a href="javascript://" ' +
                                     '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 if (title=='OHS Index Total'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            //console.log( dato, type, row);                            
                            //asignaa valores
                            if (dato == total_registros){
                                return porcentaje_ohs;    
                            }else{
                                return '';
                            }
                            
                        }
                    });
                }else{
                    columns.push({data: data[i], title: t, visible:visible});
                }
            }
            strTable += strHeader + '</tr></thead><tbody id="tbody_' + tableRender + '"></tbody>' + strFooter + '</table>';
            $('#' + dtRender).empty();
            $('#' + dtRender).html(strTable);
            $('#' + tableRender + ' thead tr').clone(true).appendTo( '#' + tableRender + ' thead' );
            $('#' + tableRender + ' thead tr:eq(1) th').each( function (i) {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%; margin: 0px; padding: 0px;"/>' );
                $( 'input', this ).on( 'keyup change', function () {
                    if ( $.fn.DataTable.isDataTable( '#' + tableRender ) ) {
                        var table = $('#' + tableRender).DataTable();
                        if ( table.column(i).search() !== this.value ) {
                            table
                                    .column(i)
                                    .search( this.value )
                                    .draw();
                        }
                    }
                } );
            } );

            return columns;
        }

        function resizeChart(){

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

            $('#grafico1').width(panel_width-offset); 

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

    </script>
    
    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-4">
                 <label>CU: </label>
                 <select class="form-control get-list" id="cu" name="cu" data='pais' data-campo-filtro='region' data-campo-mostrar='pais' data-act='refresh_cu'>
                     <<option value="TODOS">-- All -- </option>
                     {%for cu in cus%}
                        <option value="{{cu.valor}}">{{cu.nombre}}</option>
                     {%endfor%}
                 </select>
            </div>
            <div class="col-lg-4">
                 <label>COUNTRY: </label>
                 <select class="form-control get-list refresh_cu" id="pais" name="pais" data='asp' data-campo-filtro='pais' data-campo-mostrar='asp' data-act='refresh_pais'>
                     <<option value="TODOS">-- All -- </option>
                 </select>
            </div>
            <div class="col-lg-4">
                <label>ASP: </label>
                <select class="form-control refresh_cu refresh_pais" id="asp" name="asp">
                    <<option value="TODOS">-- All -- </option>
                </select>
            </div> 
        </div>
        
        <!--<br/>
        <div class="row">        
            <div class="col-lg-4">
                <label>REGION: </label>
                <select class="form-control get-list refresh_cu refresh_pais" id="region" name="region" data='cliente' data-campo-filtro='region' data-campo-mostrar='cliente'  data-act='refresh_region'>
                    <<option value="TODOS">-- All -- </option>                    
                </select>
            </div>
            <div class="col-lg-4">
                <label>CUSTOMER: </label>
                <select class="form-control get-list refresh_cu refresh_pais refresh_region" id="cliente" name="cliente" data='proyecto' data-campo-filtro='cliente' data-campo-mostrar='proyecto' data-act='refresh_cliente'>
                    <<option value="TODOS">-- All -- </option>                   
                </select>
            </div>
            <div class="col-lg-4">
                <label>PROJECT: </label>
                <select class="form-control get-list refresh_cu refresh_pais refresh_region refresh_cliente" id="proyecto" name="proyecto" data='asp' data-campo-filtro='proyecto' data-campo-mostrar='asp'data-act='refresh_proyecto'>
                    <<option value="TODOS">-- All -- </option>                   
                </select>
            </div>
             
        </div>-->
        <br/>
        <div class="row">
          <div class="col-lg-4">
              <label> {{'monitor.etiqueta.fechaI' | trans}}:</label>
              <input class="form-control" type="text" id="Filtros_fechaIni" value="{{ dateStart }}" name="Filtros_fechaIni">
          </div>
          <div class="col-lg-4">
              <label> {{'monitor.etiqueta.fechaF' | trans}}: </label>
              <input class="form-control" type="text" id="Filtros_fechaFin" value="{{ dateEnd }}" name="Filtros_fechaFin">
          </div>
          <div class="col-lg-4" id="parametros" style="vertical-align: bottom">
                <br>
               <button class="btn btn-claro" id="generar" style="vertical-align: bottom">{{'ticketDetail.boton.generar' | trans}}</button>
          </div>
        </div>
        <div class="row">
            <div class="col-lg-12 text-center"  style="margin-top: 1%">
                <h1>{{'New ASP Onboarding form' | trans}}</h1>
             </div>
        </div>
      <form id="formulario_filtros" onsubmit="return false;">
        <input type="hidden" id="total_monitor" name="total_monitor" value="0">
        <!--new-->
         <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 class='activar_auditoria' role="presentation" id="auditoria_sitios" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_auditoria_sitios" data="NO"><strong>AUDIT</strong></a></li>

                            <li class='activar_dashboard click_tab' role="presentation" id="dashboard" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_dashboard"><strong>DASHBOARD</strong></a></li>
                        </ul>
                    </div>
                    <div class="panel-body">
                        <div class="tab-content">

                            <div id="_auditoria_sitios" class="tab-pane fade active">
                                <div class="row" style="margin: 30px 0 0 0px !important;">
                                  <div class="col-lg-offset-9 col-md-offset-9">
                                      <div class="btn-group pull-right">
                                          <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                                          <ul class="dropdown-menu" role="menu">
                                              <li><a href="#" onclick="$('#reporte_auditoria_sitios').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                                          </ul>
                                      </div>
                                  </div>
                                  
                                  <div class="pager pager_auditoria_sitios" style="text-align: left">
                                      <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                                      <span class="pagedisplay"></span>
                                  </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-12" id="reporte_auditoria_sitios" style="overflow-x: auto;">
                                    </div>
                                </div>
                                
                            </div>

                            <div id="_dashboard" class="tab-pane fade">
                                <div class="row">
                                    <div id="grafico1" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <br>
                                <div class="row">
                                    <div class="col-lg-offset-9 col-md-offset-9">
                                      <div class="btn-group pull-right">
                                          <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                                          <ul class="dropdown-menu" role="menu">
                                              <li><a href="#" onclick="$('#datatable_grafico1').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                                          </ul>
                                      </div>
                                    </div>
                                    <div class="col-md-12" id="datatable_grafico1" style="overflow-x: auto;">
                                    </div>
                                    <div class="pager pager_grafica1" style="text-align: left">
                                      <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                                      <span class="pagedisplay"></span>
                                    </div>
                                </div>
                                <br>                               
                            </div>

                        <div class="row">
                            <div id="pager" class="pager" style="display: none">
                                <form>
                                    <img src="{{asset('tablesorter-master/addons/pager/icons/first.png')}}" class="first"/>
                                    <img src="{{asset('tablesorter-master/addons/pager/icons/prev.png')}}" class="prev"/>
                                    <span class="pagedisplay"></span>
                                    <img src="{{asset('tablesorter-master/addons/pager/icons/next.png')}}" class="next"/>
                                    <img src="{{asset('tablesorter-master/addons/pager/icons/last.png')}}" class="last"/>
                                    <select class="pagesize" title="Select page size">
                                        <option selected="selected" value="1000">1000</option>
                                        <option  value="500">500</option>
                                        <option  value="100">100</option>
                                    </select>
                                </form>
                            </div>
                        </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!--fin-->
      </form>
    </div>
    
    <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content" style="width: 1200px;margin: 0px 0px 0px -140px;">
                <div class="modal-header">
                    <h2 class="modal-title text-center" id="myModalLabel"><strong>{# {'monitorii.detail' | trans } #}<span class="modal_detalle_titulo"></span></strong></h2>
                    <div class="punto-grafica text-center"></div>
                </div>
                <div class="modal-body">
                    <div 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-1.12.4.js') }}"></script-->
    <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 src="{{ asset('highcharts5/code/modules/data.src.js') }}"></script>
    {#<script src="{{ asset('js/TableEdit/jquery.tabledit.min.js') }}"></script>#}
{% endblock %}