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

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

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

{% block dashboard %}
    <style>

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

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

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

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

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

            padding-left: 5px;
        }
        #chart .panel-body {
            padding: 0px;
        }
        .btn-claro {
            color: #fff;
            /*background-color: #00569C;
            border-color: #3D59CA;*/
            background-color: #428bca;
            border-color: #3071a9;
        }
        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
        }
        .tabla-detalle
        {
            text-transform: uppercase;
            font-size: 9px;
        }
    </style>
    <style>
        .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;}

        /*/!* bootstrap hack: fix content width inside hidden tabs *!/
        .tab-content > .tab-pane,
        .pill-content > .pill-pane {
            display: block;     /!* undo display:none          *!/
            height: 0;          /!* height:0 is also invisible *!/
            overflow-y: hidden; /!* no-overflow                *!/
        }
        .tab-content > .active,
        .pill-content > .active {
            height: auto;       /!* let the content decide it  *!/
        } /!* bootstrap hack end *!/*/

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

    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script src="{{ asset('js/jquery.numeric.js') }}"></script>
    <script src="{{ asset('js/jquery.form.js') }}"></script>
    <script src="{{ asset('js/jquery.isloading.js') }}" type="text/javascript"></script>
    {#<script src="{{ asset('js/resizable.min.js') }}" type="text/javascript"></script>#}

    <script>

        function createTableDT(data, tableRender, dtRender){
            var strHeader = "";
            var strFooter="";
            var columns = [];
            var strTable = '<table id="' + tableRender + '" class="display cell-border compact stripe" width="100%">' +
                    '<thead><tr class="header_dt">';
            $('#' + dtRender).empty();
            for (var i=0; i<data.length; i++){
                var title = data[i];
                var t = title.replace(/_/g,' ');
                t = title.replace('#','');

                var visible = title.startsWith('_') ? false : true;
                strHeader += '<th class="text-center">' + t + '</th>';
                if (title.indexOf(' not ')>=0){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi="";
                                var subtitle = "";
                                if (row.hasOwnProperty('%FTR')){
                                    kpi='ftr';
                                    subtitle = 'FIRST TIME RIGHT';
                                }  else if (row.hasOwnProperty('%OTD')){
                                    kpi='otd';
                                    subtitle = 'ON TIME DELIVERY';
                                }
                                var parametros = {
                                    'postfix': 'norway',
                                    'kpi': kpi,
                                    'cliente': row.hasOwnProperty('Customer') ? row['Customer'] : $('#cliente').val(),
                                    'proyecto': row.hasOwnProperty('Project') ? row['Project'] : $('#proyecto').val(),
                                    'region': row.hasOwnProperty('Region') ? row['Region'] :$('#region').val(),
                                    'cu': row.hasOwnProperty('Cluster') ? row['Cluster'] : $('#cluster').val(),
                                    'asp': row.hasOwnProperty('Asp') ? row['Asp'] : $('#asp').val(),
                                    'mes': row['Month']
                                };
                                if (type==='display'){
                                    return '<a href="javascript://" ' +
                                            'onClick=\'generateModal("{{ path('aspir_detalle_tabla_norway') }}",' + JSON.stringify(parametros) + ',true,"' + subtitle +  '","' + row['Month'] +  '")\'">' + dato + '</a>';
                                }else{
                                    return dato;
                                }
                            }
                            return dato;
                        }
                    });
                }else if(title == 'KPIs'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (type==='display'){
                                if (row.hasOwnProperty('%FTR')){
                                    if (parseFloat(row['%FTR']) >=0 && parseFloat(row['%FTR']) < 80){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust" width="">';
                                    }else if (parseFloat(row['%FTR']) >=80 && parseFloat(row['%FTR']) < 85){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['%FTR']) >= 85 && parseFloat(row['%FTR']) <= 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }
                                }
                                if (row.hasOwnProperty('%OTD')){
                                    if (parseFloat(row['%OTD']) >=0 && parseFloat(row['%OTD']) < 80){
                                        return '<img src="{{ asset('images/robust.jpg') }}" title="Robust">';
                                    }else if (parseFloat(row['%OTD']) >=80 && parseFloat(row['%OTD']) < 85){
                                        return '<img src="{{ asset('images/commitment.jpg') }}" title="Commitment">';
                                    }else if (parseFloat(row['%OTD']) >= 85 && parseFloat(row['%OTD']) <= 100){
                                        return '<img src="{{ asset('images/strech.jpg') }}" title="Stretched">';
                                    }
                                }
                            }else{
                                if (row.hasOwnProperty('%FTR')){
                                    if (parseFloat(row['%FTR']) >=0 && parseFloat(row['%FTR']) < 80){
                                        return 'Robust';
                                    }else if (parseFloat(row['%FTR']) >=80 && parseFloat(row['%FTR']) < 85){
                                        return 'Commitment';
                                    }else if (parseFloat(row['%FTR']) >= 85 && parseFloat(row['%FTR']) <= 100){
                                        return 'Stretched';
                                    }
                                }
                                if (row.hasOwnProperty('%OTD')){
                                    if (parseFloat(row['%OTD']) >=0 && parseFloat(row['%OTD']) < 80){
                                        return 'Robust';
                                    }else if (parseFloat(row['%OTD']) >=80 && parseFloat(row['%OTD']) < 85){
                                        return 'Commitment';
                                    }else if (parseFloat(row['%OTD']) >= 85 && parseFloat(row['%OTD']) <= 100){
                                        return 'Stretched';
                                    }
                                }
                            }
                        }
                    });
                }else{
                    columns.push({data: data[i], title: t, visible:visible});
                }
            }
            strTable += strHeader + '</tr></thead><tbody id="tbody_' + tableRender + '"></tbody>' + strFooter + '</table>';
            $('#' + dtRender).empty();
            $('#' + dtRender).html(strTable);
            $('#' + tableRender + ' thead tr').clone(true).appendTo( '#' + tableRender + ' thead' );
            $('#' + tableRender + ' thead tr:eq(1) th').each( function (i) {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%; margin: 0px; padding: 0px;"/>' );
                $( 'input', this ).on( 'keyup change', function () {
                    if ( $.fn.DataTable.isDataTable( '#' + tableRender ) ) {
                        var table = $('#' + tableRender).DataTable();
                        if ( table.column(i).search() !== this.value ) {
                            table
                                    .column(i)
                                    .search( this.value )
                                    .draw();
                        }
                    }
                } );
            } );
            return columns;
        }

        function buildDatatablePrin(render, columnas, data){
            var a=[];b=[];
            var Defs = [];
            var ini = (columnas.length) -5;
            var kpi = "";
            if (render=='table_01'){
                kpi = 'OTD';
            }else if(render=='table_02'){
                kpi = 'FTR';
            }
            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,
                /*columnDefs: [
                 //{ targets: [1], className: 'dt-body-left dt-nowrap' },
                 { targets: [4], className: 'dt-body-center' },
                 { targets: [5,6,7,8,9,10,11,12,13,14,15,16,17,18], className: 'dt-body-center dt-nowrap' }],*/
                lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                buttons: [
                    {
                        extend:'excel',
                        text: 'Table Excel ' + kpi,
                        exportOptions: {
                            columns: b,
                            orthogonal: 'export'
                        },
                        title: 'Mela_Norway_Aspir_' + kpi
                    }
                ]
            } );
        }

        function buildDatatable(columnas){
            table = $('#example').DataTable( {
                dom: '<"row" <"col-md-12 text-right"B>> <"row" <"col-md-6 "l> <"col-md-6"f>>rtip',
                scrollY: '50vh',
                scrollX: true,
                scrollCollapse: false,
                scroller: true,
                orderCellsTop: true,
                "ajax": {
                    "url": "{{ path('aspir_AspirShowHotProjectData') }}",
                    "type": "POST",
                    data:  function( d ) {
                        d.idproyectos = {{ idproyectos }},
                                d.pais        = $("#pais").val(),
                                d.fechaIni    = $("#fechaIni").val(),
                                d.fechaFin    = $("#fechaFin").val()
                    }
                },
                "deferRender": true,
                "processing": true,
                "language": {
                    // Replace the Processing... text with an AJAX-loader
                    "processing": "<div class='table-loading' style='z-index: 5000'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                },
                columns: columnas,
                columnDefs: [
                    { targets: [0,1,2], className: 'dt-body-left dt-nowrap' },
                    { targets: [5,6,7,8,9,10], className: 'dt-body-center' },
                    { targets: [11], className: 'dt-body-center dt-nowrap' },
                    {
                        "targets": -1,
                        "data": null,
                        "searchable": false,
                        "orderable": false,
                        "className": 'dt-body-center',
                        "render": function ( data, type, row ) {
                            //return htmlSql;
                            return '<div class="btn-group"> ' +
                                    '<a href="javascript:showModalAddHotProject(1,' + row['id'] + ');" class="btn btn-info edit" data-toggle="tooltip" ' +
                                    'data-title="Edit" title="Edit">'+
                                    '<span class="glyphicon glyphicon-pencil" aria-hidden="true"></span></a>' +
                                    '<a href="javascript:showModalAddHotProject(2,' + row['id'] + ');" class="btn btn-danger delete" data-toggle="tooltip" ' +
                                    'data-title="Delete" title="Delete" data-container="body">'+
                                    '<span class="glyphicon glyphicon-trash" aria-hidden="true"></span></a>' +
                                    '</div>';
                        }
                    },
                    { "width": "90px", "targets": -1 }
                ],
                lengthMenu: [[10, 25, 50, 100, 250, 500], [10, 25, 50, 100, 250, 500]],
                buttons: [
                    {
                        text: '<span class="glyphicon glyphicon-plus"></span> Add Hot Project',
                        action: function ( e, dt, node, config ) {
                            showModalAddHotProject(0,0);
                        },
                        className: ''
                    },
                    {
                        extend:'excel',
                        text: 'Excel',
                        exportOptions: {
                            columns: [1,2,3,4]
                        },
                        title: 'info_hot_projects'
                    }
                ]
            } );
        }

        $(document).ready(function (){
            $.fn.dataTable.moment( 'YYYY-MMM' );
            /*$.isLoading({
             text: "Loading"
             });
             */

            $('a[data-toggle="tab"]').on( 'shown.bs.tab', function (e) {
                $.fn.dataTable.tables( {visible: true, api: true} ).columns.adjust();
                try{

                    resizeChart();
                    /*$('#chart1').highcharts().reflow();
                     $('#chart2').highcharts().reflow();
                     $('#chart3').highcharts().reflow();*/
                }catch(err) {
                    //console.log(err.message);
                }
            } );

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

            $('#Filtros_fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });

            var f = new Date();
            var mes = (f.getMonth() + 1);

            if (mes < 10)
                mes = '0' + mes;
            var fechaI = f.getFullYear() + '-' + mes + "-01";
            var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();

            $('#Filtros_fechaIni').val(fechaI);
            $('#Filtros_fechaFin').val(fechaF);

            //Habilitar o Deshabilitar filtros
            // En cada pestana se definen los filtros a utilizarse de forma automatica por el ID del Filtro: ver <li> de pestanas para ejemplos
            /*$("#myTabs li").click(function(){
             var cu=$("#cluster").val();
             resizeChart();
             });*/

            $("#generar").click(function (){
                $.isLoading({
                    text: "Loading"
                });
                getChart();
            });

            $('#btnSaveContinue').on("click", function () {
                if (dataValidation()){
                    saveDataHotProject();
                    resetAddRecordDialog(0, 1);
                }
            });

            $('#btnSaveExit').on("click", function () {
                if (dataValidation()){
                    saveDataHotProject();
                    resetAddRecordDialog(0, 1);
                    var dialog = $('#modalAddRecord');
                    dialog.modal('hide');
                }
            });

            $('#btnSaveEdit').on("click", function () {
                if (dataValidation()) {
                    saveDataHotProject();
                    resetAddRecordDialog(0, 1);
                    var dialog = $('#modalAddRecord');
                    dialog.modal('hide');
                }
            });
        });

        function resizeChart(){
            try{
                var panel_width = $('#panel_content').width();
                var offset = 32;

                $('#graficoOnTimeDelivery').width(panel_width-offset);
                $('#graficoFirstTimeRight').width(panel_width-offset);

                $('#graficoOnTimeDelivery').highcharts().reflow();
                $('#graficoFirstTimeRight').highcharts().reflow();

                redrawDt();
            }catch(err) {
                //console.log(err.message);
            }
        }
        function redrawDt(){

            if ( $.fn.DataTable.isDataTable( '#table_01' ) ) {
                var table = $('#table_01').DataTable();
                table.draw(false);
            }
            if ( $.fn.DataTable.isDataTable( '#table_02' ) ) {
                var table = $('#table_02').DataTable();
                table.draw(false);
            }
        }

        $(window).resize(function(){
            resizeChart();

        });

        $(document).on("change",'.cmbFilterNorway',function(){
            fillCombo($(this).attr('id'),$(this).attr('next'));
        });

        function fillCombo(idCmb, idNext){
            if ($("#" + idCmb).val() != "TODOS"){
                var data = {};
                data['element'] = idCmb;
                data['postfix'] = 'norway';
                data['inicio'] = $("#Filtros_fechaIni").val();
                data['fin'] = $("#Filtros_fechaFin").val();
                data['cliente'] = $("#cliente").val();
                data['proyecto'] = $("#proyecto").val();
                data['region'] = $("#region").val();
                data['cluster'] = $("#cluster").val();

                $.getJSON('{{path('aspir_fillFilterDataAspir')}}', data, function (data){
                    var options = data.optionsList;
                    initCombo(idNext);

                    for (var i = 0; i < options.length; i++){
                        $("#" + idNext + "").append('<option value="' + options[i]['valor'] + '">' + options[i]['nombre'] + '</option>');
                    }
                });
            }else{
                initCombo(idNext);
            }
        }

        function initCombo(idCmb){
            switch (idCmb){
                case 'proyecto':
                    $("#proyecto,#region,#cluster,#asp").each(function(){
                        $(this).empty().append('<option value="TODOS">-- All --</option>');
                    });
                    break;
                case 'region':
                    $("#region,#cluster,#asp").each(function(){
                        $(this).empty().append('<option value="TODOS">-- All --</option>');
                    });
                    break;
                case 'cluster':
                    $("#cluster,#asp").each(function(){
                        $(this).empty().append('<option value="TODOS">-- All --</option>');
                    });
                    break;
            }
        }

        function getChart(){
            var inicio = $('#Filtros_fechaIni').val();
            var fin = $('#Filtros_fechaFin').val();
            var cliente = $('#cliente').val();
            var proyecto = $('#proyecto').val();
            var region = $('#region').val();
            var cu = $('#cluster').val();
            var asp = $('#asp').val();
            var valor = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();

            var parametros = {
                'postfix' : 'norway',
                'FechaInicio': inicio,
                'FechaFin': fin,
                'cliente': cliente,
                'proyecto': proyecto,
                'region': region,
                'cu': cu,
                'asp': asp,
                'date': valor
            };

            $.getJSON('{{path('aspir_DashboardAspir2',{'idproyectos':idproyectos})}}', parametros, function (data){
                var chart = data;

                // On Time Delivery
                if (chart.graficoOnTimeDelivery.categories.length > 0){
                    $("#graficoOnTimeDelivery").empty();
                    var series = getDataToObjectSerie(chart.graficoOnTimeDelivery.data, Object.keys(chart.graficoOnTimeDelivery.data[0]));
                    createChartLinea2('graficoOnTimeDelivery', chart.graficoOnTimeDelivery.categories, series, '',
                            null, [75, 'Rob=75%'], [80,'Com=80%'], [85,'Str=85%'], inicio, fin, null, null, null, chart.graficoOnTimeDelivery.data);
                }else{
                    $("#graficoOnTimeDelivery").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }

                 // Tabla tablaOnTimeDelivery
                 if (chart.tablaOnTimeDelivery.length > 0){
                     $("#datatable_01").empty();
                     var col = createTableDT(Object.keys(chart.tablaOnTimeDelivery[0]),'table_01', 'datatable_01');
                     buildDatatablePrin('table_01',col,chart.tablaOnTimeDelivery);
                 }else{
                    $("#datatable_01").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                 }

                // First Time Right
                if (chart.graficoFirstTimeRight.categories.length > 0){
                    $("#graficoFirstTimeRight").empty();
                    var series = getDataToObjectSerie(chart.graficoFirstTimeRight.data, Object.keys(chart.graficoFirstTimeRight.data[0]));
                    createChartLinea2('graficoFirstTimeRight', chart.graficoFirstTimeRight.categories, series, '',
                            null, [75, 'Rob=75%'], [80,'Com=80%'], [85,'Str=85%'], inicio, fin, null, null, null, chart.graficoFirstTimeRight.data);
                }else{
                    $("#graficoFirstTimeRight").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }

                // Tabla tablaFirstTimeRight
                if (chart.tablaFirstTimeRight.length > 0){
                    $("#datatable_02").empty();
                    var col = createTableDT(Object.keys(chart.tablaFirstTimeRight[0]),'table_02', 'datatable_02');
                    buildDatatablePrin('table_02',col,chart.tablaFirstTimeRight);
                }else{
                    $("#datatable_02").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                $.isLoading("hide");
            });
        }

        function getDataToObject(data, header, key, int){
            var arrayReturn = new Array();
            for (var i = 0; i < data.length; i++){
                var valor = data[i][header[key]];

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

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

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

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

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

        function getDataToObjectLinea2(data, header){
            var arrayReturn = new Array();
            var data1 = new Array();//EECA
            var data2 = new Array();//FBAT
            var data3 = new Array();//IB
            var data4 = new Array();//LAN
            var data5 = new Array();//LAS
            var data6 = new Array();//NOCE
            var data7 = new Array();//SEM
            var data8 = new Array();//UKI
            var data9 = new Array();//WE
            for (var i = 0; i < data.length; i++)
            {
                data1.push(parseFloat(data[i][header[1]]));
                data2.push(parseFloat(data[i][header[2]]));
                data3.push(parseFloat(data[i][header[3]]));
                data4.push(parseFloat(data[i][header[4]]));
                data5.push(parseFloat(data[i][header[5]]));
                data6.push(parseFloat(data[i][header[6]]));
                data7.push(parseFloat(data[i][header[7]]));
                data8.push(parseFloat(data[i][header[8]]));
                data9.push(parseFloat(data[i][header[9]]));
            }

            arrayReturn.push({'name': header[1], 'data': data1, 'dataLabels': {'enabled': true}});
            arrayReturn.push({'name': header[2], 'data': data2, 'dataLabels':{'enabled':true}});
            arrayReturn.push({'name': header[3], 'data': data3, 'dataLabels':{'enabled':true}});
            arrayReturn.push({'name': header[4], 'data': data4, 'dataLabels':{'enabled':true}});
            arrayReturn.push({'name': header[5], 'data': data5, 'dataLabels':{'enabled':true}});
            arrayReturn.push({'name': header[6], 'data': data6, 'dataLabels':{'enabled':true}});
            arrayReturn.push({'name': header[7], 'data': data7, 'dataLabels':{'enabled':true}});
            arrayReturn.push({'name': header[8], 'data': data8, 'dataLabels':{'enabled':true}});
            arrayReturn.push({'name': header[9], 'data': data9, 'dataLabels':{'enabled':true}});

            return arrayReturn;
        }

        function createChart(render, categoria, data, wd, title, inicio, fin, pais, cu, path, rawData){
            var options = {
                chart: {
                    renderTo: render,
                    type: 'bar',
                    spacingBottom: 5,
                    spacingTop: 10,
                    spacingLeft: 1,
                    spacingRight: 1,
                    height: wd
                },
                title: {
                    text: ''
                },
                subtitle: {
                    text: ''
                },
                xAxis: {
                    categories: categoria,
                    title: {
                        text: null
                    },
                    labels: {

                        style: {
                            fontSize: '9px'
                        }
                    }
                },
                yAxis: {
                    min: 0,
                    title: {
                        text: '',
                        align: 'high'
                    },
                    labels: {

                        overflow: 'justify',
                        formatter: function ()
                        {
                            return this.value;
                        }
                    }
                },
                tooltip: {
                    enabled: false
                },
                plotOptions: {
                    bar: {
                        dataLabels: {
                            enabled: true
                        }
                    },
                    series: {

                        dataLabels: {

                            enable: true,
                            format: '{y}'
                        }
                    }
                },
                legend: {
                    layout: 'horizontal',
                    align: 'center',
                    verticalAlign: 'buttom',
                    floating: true,
                    x: 0,
                    y: 10
                },
                credits: {
                    enabled: false
                },
                series: [{
                    showInLegend: false,
                    name: data['name'],
                    data: data['data'],
                    color: {
                        linearGradient: {x1: 0, x2: 0, y1: 0, y2: 1},
                        stops: [
                            [0, '#398235'],
                            [0.5, '#8ab66b'],
                            [1, '#c9de96']
                        ]
                    },

                    tag: 1

                }]
            };

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

                                if (rawData != null)
                                {
                                    parametrosUrl['row'] = rawData[this.x];
                                }

                                var prefix = (title == null || title == '') ? '' : title + ' - ';

                                generateModal(path, parametrosUrl, true, prefix, categoria[this.x]); //, this.series.name+'='+ this.y);
                            }
                        }
                    }
                };
                options['plotOptions']['series']['dataLabels'] = tmp_datalabel;
            }

            return $('#' + render).highcharts(options);
        }

        function createChartDetalle(render, categoria, data, wd, title, inicio, fin, pais, cu, path, rawData)
        {
            var options = {
                chart: {
                    renderTo: render,
                    type: 'bar',
                    spacingBottom: 5,
                    spacingTop: 10,
                    spacingLeft: 1,
                    spacingRight: 1,
                    height: wd
                },
                title: {
                    text: title
                },
                subtitle: {
                    text: ''
                },
                xAxis: {
                    categories: categoria,
                    title: {
                        text: null
                    },
                    labels: {

                        style: {
                            fontSize: '9px'
                        }
                    }
                },
                yAxis: {
                    min: 0,
                    title: {
                        text: title,
                        align: 'high'
                    },
                    labels: {

                        overflow: 'justify',
                        formatter: function ()
                        {
                            return this.value;
                        }
                    }
                },
                tooltip: {
                    enabled: false
                },
                legend: {
                    layout: 'horizontal',
                    align: 'center',
                    verticalAlign: 'buttom',
                    floating: true,
                    x: 0,
                    y: 10
                },
                credits: {
                    enabled: false
                },
                series:
                        [
                            {
                                showInLegend: false,
                                name: data['name'],
                                data: data['data'],
                                color:
                                {
                                    linearGradient: {x1: 0, x2: 0, y1: 0, y2: 1},
                                    stops: [
                                        [0, '#398235'],
                                        [0.5, '#8ab66b'],
                                        [1, '#c9de96']
                                    ]
                                },
                                tag: 1
                            }
                        ]
            };

            if (path != null)
            {
                options['plotOptions'] = {
                    series: {
                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels: {
                            enabled: true
                        },
                        point: {
                            events: {
                                click: function (e)
                                {
                                    var parametrosUrl = {
                                        'inicio': inicio,
                                        'fin': fin,
                                        'pais': pais,
                                        'issue': categoria[this.x],
                                        'cu': cu,
                                        'selected_item': categoria[this.x],
                                        'selected_serie': this.series.name
                                    };

                                    if (rawData != null)
                                    {
                                        parametrosUrl['row'] = rawData[this.x];
                                    }

                                    var prefix = (title == null || title == '') ? '' : title + ' - ';

                                    generateModal(path, parametrosUrl, true, prefix, categoria[this.x]); //, this.series.name+'='+ this.y);
                                }
                            }
                        }
                    }
                };
            }

            return $('#' + render).highcharts(options);
        }

        function _parse(str, arguments){
            var args = [].slice.call(arguments, 1);
            var i = 0;

            return str.replace(/%s/g, function ()
            {
                return args[i++];
            });
        }

        function createChartLinea(render, categoria, data, title, w,
                                  target_line, target_line2, target_line3, inicio, fin, pais, cu, path, rawData){
            var options = {
                chart: {
                    spacingBottom: 15,
                    spacingTop: 40,
                    spacingLeft: 40,
                    spacingRight: 40,
                    height: 450,
                    marginBottom: 130,
                    borderColor: '#428bca',
                    borderWidth: 1,
                    type: 'line',
                    shadow: true,
                    zoomType: 'x',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                },
                plotOptions:{
                    series:{
                        shadow:true,
                        dataLabels: {
                            enabled: true,
                            style: {
                                fontWeight: 'bold'
                            }
                        }
                    }
                },
                legend: {
                    backgroundColor: 'rgba(66, 139, 202, 0.5)'
                },
                xAxis: {
                    categories: categoria,
                    lineWidth: 1,
                    lineColor: '#4c4c4c',
                    tickColor: '#4c4c4c',
                    tickWidth: 1,
                    labels: {
                        rotation: -30,
                        style: {
                            fontSize: '9px',
                            color: '#4c4c4c'
                        }
                    },
                    overflow: 'justify',
                    scrollbar: {
                        enabled: true
                    }
                },
                yAxis:
                        [
                            {
                                min: 50,
                                max: w,
                                title: {text: ''},
                                lineWidth: 1,
                                lineColor: '#4c4c4c',
                                plotLines: [
                                    {
                                        value: 0,
                                        width: 1,
                                        color: '#808080'
                                    }
                                ]
                            }
                            ,
                            {
                                title: {text: ''},
                                min: 0,
                                opposite: true
                            }
                            ,
                            {
                                title: {text: ''},
                                min: 0,
                                opposite: true
                            }
                        ]
                ,
                title: {text: title},
                tooltip: {shared: true},
                //colors: ['#a1c517', '#0082b6', '#b88fef', '#009045', '#db004f'],
                colors: ["#7cb5ec", "#434348", "#90ed7d", "#f7a35c", "#8085e9",
                    "#f15c80", "#e4d354", "#2b908f", "#f45b5b", "#91e8e1"],
                series: data
            };

            if (target_line != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line[0],
                    color: '#f7e81d', //Verde Grama
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: 10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line[1]
                    }
                };
                /*options.yAxis[0].plotBands[options.yAxis[0].plotBands.length] ={ // Verde Grama
                 from: 84.99,
                 to: 80,
                 color: 'rgba(46, 130, 1, 0.3)',
                 label: {
                 text: 'ROBUST',
                 style: {
                 color: '#606060'
                 }
                 }
                 };*/
            }

            if (target_line2 != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line2[0],
                    color: '#7cf23c', //Verde Manzana
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: 10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line2[1]
                    }
                };
                /*options.yAxis[0].plotBands[options.yAxis[0].plotBands.length] ={ // Verde Manzana
                 from: 89.99,
                 to: 85,
                 color: 'rgba(124, 242, 60, 0.3)',
                 label: {
                 text: 'COMMITMENT',
                 style: {
                 color: '#606060'
                 }
                 }
                 };*/
            }

            if (target_line3 != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] =	{
                    value: target_line3[0],
                    color: '#2e8201', //Amarillo
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: 10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line3[1]
                    }
                };
                /*options.yAxis[0].plotBands[options.yAxis[0].plotBands.length] ={ //Amarillo
                 from: 90.00,
                 to: 100,
                 color: 'rgba(247, 232, 29, 0.3)',
                 label: {
                 text: 'STRETCH',
                 style: {
                 color: '#606060'
                 }
                 }
                 }*/
            }

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

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

            return $('#' + render).highcharts(options);
        }

        function createChartLinea2(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, inicio, fin, pais, cu, path, rawData){
            var options = {
                chart: {
                    spacingBottom: 10, //35
                    spacingTop: 40,
                    spacingLeft: 40,
                    spacingRight: 40,
                    height: 450,
                    marginBottom: 110, //180
                    borderColor: '#428bca',
                    borderWidth: 1,
                    type: 'line',
                    shadow: true,
                    zoomType: 'x',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                },
                plotOptions:{
                    series:{
                        shadow:true,
                        dataLabels: {
                            enabled: true,
                            style: {
                                fontWeight: 'bold'
                            }
                        }
                    }
                },
                legend: {
                    backgroundColor: 'rgba(66, 139, 202, 0.5)'
                },
                xAxis: {
                    categories: [],
                    lineWidth: 1,
                    lineColor: '#4c4c4c',
                    tickColor: '#4c4c4c',
                    tickWidth: 1,
                    labels: {
                        rotation: 0,
                        style: {
                            fontSize: '9px',
                            color: '#4c4c4c'
                        }
                    },
                    overflow: 'justify',
                    scrollbar: {
                        enabled: true
                    }
                },
                yAxis:
                        [
                            {
                                min: 50,
                                max: w,
                                title: {text: ''},
                                lineWidth: 1,
                                lineColor: '#4c4c4c',
                                plotLines: [
                                    {
                                        value: 0,
                                        width: 1,
                                        color: '#808080'
                                    }
                                ]
                            }
                            ,
                            {
                                title: {text: ''},
                                min: 0,
                                opposite: true
                            }
                            ,
                            {
                                title: {text: ''},
                                min: 0,
                                opposite: true
                            }
                        ]
                ,
                title: {text: title},
                tooltip: {shared: true},
                //colors: ['#a1c517', '#0082b6', '#b88fef', '#009045', '#db004f'],
                colors: ["#2a587f", "#434348", "#90ed7d", "#f7a35c", "#8085e9",
                    "#f15c80", "#e4d354", "#2b908f", "#f45b5b", "#91e8e1"],
                series: series
            };

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

            if (target_line2 != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line2[0],
                    color: '#7cf23c', //Verde Manzana
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: 10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line2[1]
                    }
                };
                /*options.yAxis[0].plotBands[options.yAxis[0].plotBands.length] ={ // Verde Manzana
                 from: 89.99,
                 to: 85,
                 color: 'rgba(124, 242, 60, 0.3)',
                 label: {
                 text: 'COMMITMENT',
                 style: {
                 color: '#606060'
                 }
                 }
                 };*/
            }

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

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

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

            var num = categoria.length;
            var marginBottom = 70 + ((num-1) * 20);
            var menor = 200.00;
            options.chart.marginBottom = marginBottom;

            for (var k=0; k<rawData.length; k++){
                var hasThisCategory = false;
                var categoryIndex = -1;
                var categoryPath = options.xAxis.categories;
                var valorActual= parseFloat(rawData[k][series[0].name]);


                /*for (var n=0; n<categoria.length; n++){
                    var catName = categoria[n]['sql_name'];
                    // I NIVEL DE CATEGORIAS
                    if (n=0){
                        console.log(rawData[n][catName]);
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][catName]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][catName],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;

                    }else if (n>0 && n < categoria.length-1){ // // II NIVEL DE CATEGORIAS
                        console.log(rawData[n][catName]);
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][1]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][1],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }else{
                        console.log(rawData[n][catName]);
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category === rawData[k][catName]) {
                                hasThisCategory = true;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push(rawData[k][catName]);
                        }
                    }


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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

            return $('#' + render).highcharts(options);
        }

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

        function getStrImgKPI(kpi,arrParams){

        }

        function createTable(monitor, monitor1, total, nombreColTotal){
            var header = Object.keys(monitor[0]);
            var table = '<table  class="table table-bordered table-hover table-striped table-responsive table-condensed">' +
                        '<thead><tr class="bg-primary">';

            for (var j = 0; j < header.length; j++){
                table += "<th style='vertical-align:middle;' class='text-center'>" + header[j] + "</th>"
            }
            table += "</tr></thead>";

            for (var i = 0; i < monitor.length; i++){
                table += '<tr id=' + monitor[i][header[0]] + ' class="cursor" style="vertical-align:middle;">';

                // se convierten en texto a traves de JSON.stringify()
                var parametros = {'mes': monitor[i][header[0]], 'proyecto': monitor[i][header[1]], 'pais': $("#pais").val(), 'cluster': $("#cluster").val(), 'cu': $("#cluster").val()};
                //var parametrosOnTimeDelivery = {'mes': monitor[i][header[0]], 'proyecto': monitor[i][header[1]], 'pais': $("#pais1").val(), 'cluster': $("#cluster1").val()};

                for (var j = 0; j < header.length; j++){
                    if (header[j] == "KPIs"){
                        if (header[j-1] == "%FTR" || header[j-1] == "%OTD"){
                            if (parseFloat(monitor[i][header[5]]) >=0 && parseFloat(monitor[i][header[5]]) < 80){
                                table += '<td style="vertical-align:middle;"><img src="{{ asset('images/robust.jpg') }}" title="Robust"></td>';
                            }else if (parseFloat(monitor[i][header[5]]) >=80 && parseFloat(monitor[i][header[5]]) < 85){
                                table += '<td style="vertical-align:middle;"><img src="{{ asset('images/commitment.jpg') }}" title="Commitment"></td>';
                            }else if (parseFloat(monitor[i][header[5]]) >= 85 && parseFloat(monitor[i][header[5]]) <= 100){
                                table += '<td style="vertical-align:middle;"><img src="{{ asset('images/strech.jpg') }}" title="Stretched"></td>';
                            }
                        }
                        /*else if (header[4] == "%FTR"  || header[4] == "%OTD"){
                            if (parseFloat(monitor[i][header[4]]) >=0 && parseFloat(monitor[i][header[4]]) < 80){
                                table += '<td style="vertical-align:middle;"><img src="{{ asset('images/robust.jpg') }}" title="Robust"></td>';
                            }else if (parseFloat(monitor[i][header[4]]) >=80 && parseFloat(monitor[i][header[4]]) < 85){
                                table += '<td style="vertical-align:middle;"><img src="{{ asset('images/commitment.jpg') }}" title="Commitment"></td>';
                            }else if (parseFloat(monitor[i][header[4]]) >= 85 && parseFloat(monitor[i][header[4]]) <= 100){
                                table += '<td style="vertical-align:middle;"><img src="{{ asset('images/strech.jpg') }}" title="Stretched"></td>';
                            }
                        }else if (header[6] == "%FTR"  || header[6] == "%OTD"){
                            if (parseFloat(monitor[i][header[6]]) >=0 && parseFloat(monitor[i][header[6]]) < 80){
                                table += '<td style="vertical-align:middle;"><img src="{{ asset('images/robust.jpg') }}" title="Robust"></td>';
                            }else if (parseFloat(monitor[i][header[6]]) >=80 && parseFloat(monitor[i][header[6]]) < 85){
                                table += '<td style="vertical-align:middle;"><img src="{{ asset('images/commitment.jpg') }}" title="Commitment"></td>';
                            }else if (parseFloat(monitor[i][header[6]]) >= 85 && parseFloat(monitor[i][header[6]]) <= 100){
                                table += '<td style="vertical-align:middle;"><img src="{{ asset('images/strech.jpg') }}" title="Stretched"></td>';
                            }
                        }*/
                    }else if (header[j] == "Total services not accepted <br> 1st time right"){
                        if (parseInt(monitor[i][header[j]]) > 0){
                            var cu="";
                            if ($('#cluster').val()=="TODOS") cu=monitor[i][header[1]]; else cu=$('#cluster').val();
                            var parametros = {
                                'postfix': 'norway',
                                'cliente': $('#cliente').val(),
                                'proyecto': $('#proyecto').val(),
                                'region': $('#region').val(),
                                'cu': cu,
                                'asp': $('#asp').val(),
                                'mes': monitor[i][header[0]]
                            };
                            //var parametros = {'mes': monitor[i][header[0]], 'pais': $("#pais").val(), 'cu': $("#cluster").val()};
                            table += '<td style="vertical-align:middle;"> ' +
                                    '<button type="button" class="btn btn-link btn-xs" ' +
                                    'onclick=\'generateModal("{{ path('aspir_detalle_tablaFirstTimeRight') }}",' + JSON.stringify(parametros) + ',true,"First Time Right","' + monitor[i][header[0]] + '")\'>' + monitor[i][header[j]] + '</button></td>';
                        }else
                            table += "<td style='vertical-align:middle;'>" + monitor[i][header[j]] + "</td>";

                    }else if (header[j] == "Total services not delivered<br>On Time"){
                        if (parseInt(monitor[i][header[j]]) > 0){
                            var cu="";
                            if ($('#cluster').val()=="TODOS") cu=monitor[i][header[1]]; else cu=$('#cluster').val();
                            var parametros = {
                                'postfix': 'norway',
                                'pais': $('#pais').val(),
                                'cu': cu,
                                'cliente': $('#cliente').val(),
                                'proyecto': $('#proyecto').val(),
                                'asp': $('#asp').val(),
                                'mes': monitor[i][header[0]]
                            };

                            //var parametros = {'mes': monitor[i][header[0]], 'pais': $("#pais").val(), 'cu': $("#cluster").val()};
                            table += '<td style="vertical-align:middle;"> ' +
                                    '<button type="button" class="btn btn-link btn-xs" ' +
                                    'onclick=\'generateModal("{{ path('aspir_detalle_tablaOnTimeDelivery') }}",' + JSON.stringify(parametros) + ',true,"On Time Delivery","' + monitor[i][header[0]] + '")\'>' + monitor[i][header[j]] + '</button></td>';
                        }else
                            table += "<td style='vertical-align:middle;'>" + monitor[i][header[j]] + "</td>";

                    }else if (header[j] == "ASP"){
                        if (parseInt(monitor[i][header[6]]) > 0){
                            var pais=""; var cu="";var cliente="";var proyecto="";
                            if ($('#cluster').val()=="TODOS") cu=monitor[i][header[0]]; else cu=$('#cluster').val();
                            if ($('#pais').val()=="TODOS") pais=monitor[i][header[1]]; else pais=$('#pais').val();
                            if ($('#cliente').val()=="TODOS") cliente=monitor[i][header[2]]; else cliente=$('#cliente').val();
                            if ($('#proyecto').val()=="TODOS") proyecto=monitor[i][header[3]]; else proyecto=$('#proyecto').val();
                            var parametros = {
                                'postfix': 'norway',
                                'pais': pais,
                                'cu': cu,
                                'cliente': cliente,
                                'proyecto': proyecto,
                                'asp': monitor[i][header[4]],
                                'mes': monitor[i][header[5]]
                            };
                            //var parametros = {'mes': monitor[i][header[0]], 'pais': $("#pais").val(), 'cu': $("#cluster").val()};
                            table += '<td style="vertical-align:middle;"> <button type="button" class="btn btn-link btn-xs" onclick=\'generateModal("{{ path('aspir_detalle_tablaDashASP') }}",' + JSON.stringify(parametros) + ',true,"ASP Dashboard","' + monitor[i][header[4]] + '")\'>' + monitor[i][header[j]] + '</button></td>';
                        }else
                            table += "<td style='vertical-align:middle;'>" + monitor[i][header[j]] + "</td>";

                    }else if (header[j] == "TREND"){
                        var flag=0;
                        if (monitor1.length>0){
                            var headerMonitor1 = Object.keys(monitor1[0]);

                            for (var k = 0; k < monitor1.length; k++){
                                if((monitor[i][header[0]]==monitor1[k][headerMonitor1[0]]) &&
                                        (monitor[i][header[1]]==monitor1[k][headerMonitor1[1]]) &&
                                        (monitor[i][header[2]]==monitor1[k][headerMonitor1[2]]) &&
                                        (monitor[i][header[3]]==monitor1[k][headerMonitor1[3]]) ){
                                    flag=1;
                                    if (parseFloat(monitor[i][header[5]]) > parseFloat(monitor1[k][headerMonitor1[5]]) ){
                                        table += '<td style="vertical-align:middle;"><img src="{{ asset('images/up.png') }}" alt="up"></td>';
                                    }else{
                                        if (parseFloat(monitor[i][header[5]]) < parseFloat(monitor1[k][headerMonitor1[5]]) ){
                                            table += '<td style="vertical-align:middle;"><img src="{{ asset('images/down_red.png') }}" alt="down"></td>';
                                        }else{
                                            if (parseFloat(monitor[i][header[5]]) == parseFloat(monitor1[k][headerMonitor1[5]]) ){
                                                table += '<td style="vertical-align:middle;"><img src="{{ asset('images/equal.png') }}" alt="equal"></td>';
                                            }else table += "<td style='vertical-align:middle;'> - </td>";
                                        }
                                    }
                                }
                            }
                        }
                        if (flag == 0) table += "<td style='vertical-align:middle;'> - </td>";

                    }else	table += "<td style='vertical-align:middle;'>" + monitor[i][header[j]] + "</td>";
                }//Fin del For j
                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>';
                    }
                }
            }//Fin del For i
            table += "</table>";
            return table;
        }

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

        // este metodo ya no es esta usando en las tablas de datos, por ejemplo workmanship
        function open(){
            $('#myModal');
            $('#myModal .tabla-datos').empty();
            $('#myModal .punto-grafica').empty();

            if ($(this).text() == 0)
                return false;

            generateModal($(this).attr('data-load-remote'));
        }

        /**
         *

         * @param String ruta
         * @param Object objParams
         * @returns {undefined}		 */
        function generateModal(ruta, objParams, numerar, title, subtitle)
        {
            $('#myModal .tabla-datos').empty().isLoading();
            $('#myModal .punto-grafica').empty().hide();
            $('#myModal .modal_detalle_titulo').empty();

            if (title != null)
            {
                $('#myModal .modal_detalle_titulo').html(title);
            }
            else
            {
                $('#myModal .modal_detalle_titulo').html('{{'monitorii.detail' | trans }}');
            }

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

            $.getJSON(ruta, objParams, function (data)
            {

                if (data.length == 0)
                {

                    $('#myModal').modal('hide');
                    $('#myModal .tabla-datos').isLoading('hide');
                    return false;
                }

                var monitor = data,
                        header = Object.keys(data[0]),
                        table = '<table class="tabla-detalle table table-hover table-condensed table-responsive"><thead><tr class="bg-primary">';

                if (numerar == true)
                {
                    table += "<th class='text-center'>#</th>";
                }
                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>";
                    if (numerar == true)
                    {
                        table += "<td>" + (i + 1) + "</td>";
                    }
                    for (var j = 0; j < header.length; j++)
                    {

                        // Se verifica si el valor a imprimir es null para evitar el toString de null como 'NULL'
                        table += "<td>" + (monitor[i][header[j]] == null ? '&nbsp;' : monitor[i][header[j]]) + "</td>";
                    }
                    table += "</tr>";
                }

                table += "</table>";
                $('#myModal .tabla-datos').isLoading('hide').html(table);
            });

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

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

    </script>

    <div class="container-fluid">
        <form id="formulario_filtros" onsubmit="return false;">
            <div class="panel panel-primary">
                <div class="panel-heading">
                    <h3 class="panel-title"><a data-toggle="collapse" href="#collapse1">Filters <span class="caret"></span></a></h3>
                </div>
                <div id="collapse1" class="panel-collapse collapse in">
                    <div id="panelFilter" class="panel-body">
                        <div class="row">
                            <div class="col-md-3 col-sm-6 col-xs-12" id='div_fechaIni'>
                                <div class="form-group">
                                    <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>
                                    <input type="text" class="form-control" id="Filtros_fechaIni" name="Filtros_fechaIni" value="">
                                </div>
                            </div>
                            <div class="col-md-3  col-sm-6 col-xs-12" id='div_fechaFin'>
                                <div class="form-group">
                                    <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>
                                    <input type="text" class="form-control" id="Filtros_fechaFin" name="Filtros_fechaFin" value="">
                                </div>
                            </div>
                            <div id="div_cliente" class="col-md-3 col-sm-6 col-xs-12">
                                <div class="form-group">
                                    <label>{{'monitores.cliente' | trans}}: </label>
                                    <select class="form-control cmbFilterNorway" id="cliente" name="cliente" next="proyecto">
                                        <option value="TODOS">-- All --</option>
                                        {%for customer in customers%}
                                            <option value="{{customer.valor}}">{{customer.nombre}}</option>
                                        {%endfor%}
                                    </select>
                                </div>
                            </div>
                            <div id="div_proyecto" class="col-md-3 col-sm-6 col-xs-12">
                                <div class="form-group">
                                    <label>{{'monitores.proyecto' | trans}}: </label>
                                    <select class="form-control cmbFilterNorway" id="proyecto" name="proyecto" next="region">
                                        <option value="TODOS">-- All --</option>
                                    </select>
                                </div>
                            </div>
                        </div>
                        <div class="row">
                            <div id="div_region" class="col-md-3 col-sm-6 col-xs-12">
                                <div class="form-group">
                                    <label>{{'monitores.region' | trans}}: </label>
                                    <select class="form-control cmbFilterNorway" id="region" name="region" next="cluster">
                                        <option value="TODOS">-- All --</option>
                                    </select>
                                </div>
                            </div>
                            <div id="div_cluster" class="col-md-3 col-sm-6 col-xs-12">
                                <div class="form-group">
                                    <label>Cluster: </label>
                                    <select class="form-control cmbFilterNorway" id="cluster" name="cluster" next="asp">
                                        <option value="TODOS">-- All --</option>
                                    </select>
                                </div>
                            </div>
                            <div id="div_asp" class="col-md-3 col-sm-6 col-xs-12">
                                <div class="form-group">
                                    <label>{{'ASP' | trans}}: </label>
                                    <select class="form-control" id="asp" name="asp">
                                        <option value="TODOS">-- All --</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3 col-sm-6 col-xs-12" id="parametros">
                                <div class="form-group">
                                    <label for="generar">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</label>
                                    <button class="btn btn-primary form-control" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </form>

        <div class="row">
            <div class="col-md-12 text-center">
                <h1 class="text-center text-primary">
                    <i class="fa fa-file-text-o"></i> <strong>MELA ASP MANAGEMENT INTEGRATED REPORTING</strong>
                </h1>
            </div>
        </div>

        <div class="row">
            <div id="panel_content" class="col-lg-12">
                <div class="panel with-nav-tabs panel-primary">
                    <div class="panel-heading">
                        <ul class="nav nav-tabs" id="myTabs">
                            <li role="presentation" id="tabsOnTimeDelivery" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_region clusterTodos div_asp"><a data-toggle="tab" href="#_tabOnTimeDelivery"><strong>OTD</strong> (On Time Delivery)</a></li>
                            <li role="presentation" id="tabsFirstTimeRight" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_region clusterTodos div_asp"><a data-toggle="tab" href="#_tabFirstTimeRight"><strong>FTR</strong> (First Time Right)</a></li>
                            {#<li role="presentation" id="tabsOhsFtr" data-filtro="div_fechaIni div_fechaFin paisTodos clusterTodos div_proyecto div_cliente div_asp"><a data-toggle="tab" href="#_tabsDashAsp"><strong>OHS FTR</strong></a></li>#}
                        </ul>
                    </div>
                    <div class="panel-body">
                        <div class="tab-content">
                            <div id="_tabOnTimeDelivery" class="tab-pane fade">
                                <div class="row">
                                    <div id="graficoOnTimeDelivery" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row">
                                    <div id="datatable_01" class="col-sm-12">
                                        <table id="table_01" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_01"></tbody>
                                        </table>
                                    </div>
                                </div>
                                {#<div class="row">
                                    <div id="tablaOnTimeDelivery" class="col-md-12">
                                    </div>
                                </div>#}
                            </div>

                            <div id="_tabFirstTimeRight" class="tab-pane fade">
                                <div class="row">
                                    <div id="graficoFirstTimeRight" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                {#<div class="row">
                                    <div id="tablaFirstTimeRight" class="col-md-12">
                                    </div>
                                </div>#}
                                <div class="row">
                                    <div id="datatable_02" class="col-sm-12">
                                        <table id="table_02" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_02"></tbody>
                                        </table>
                                    </div>
                                </div>
                                {#<div class="col-lg-2">
                                </div>#}
                            </div>

                            {#<div id="_tabsOhsFtr" class="tab-pane fade">
                                <div class="row">
                                    <div id="graficoDashAsp" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <div class="row">
                                    <div id="tablaDashAsp" class="col-md-12">
                                    </div>
                                </div>
                                &#123;&#35;<div class="col-lg-2"></div>&#35;&#125;
                            </div>#}
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <script>
        $(function(){
                    // muestro el grafico seleccionado por default: el primero
                    $('#myTabs a:first').tab('show');

                    // inicializo los filtros mostrados por default: el primero
                    //on_tab_selected($('#myTabs li:first'));
                    //on_cliente_change();
                }
        );
    </script>

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

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

    <div class="modal fade" id="modalHotProject" tabindex="-1" role="dialog" aria-labelledby="HotProject">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header btn-claro">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <h2 class="modal-title text-center" id="modalHotProjectTitle">
                        <strong>Hot Projects</strong>
                    </h2>
                </div>
                <div class="modal-body">
                    <div class="row">
                        <div id="datatable" class="col-sm-12" {#style="overflow-x: scroll"#}>
                            <table id="example" class="display nowrap" width="100%">
                                <tbody id="tbody">
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-claro" data-dismiss="modal">
                        {{'monitorii.close' | trans}}
                        <span class="glyphicon glyphicon-remove"></span>
                    </button>
                </div>
            </div>
        </div>
    </div>


{% 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 %}