{% extends '::base.html.twig' %}
{% block dashboard %}
    <style>
        .double-scroll {
            width: 100%;
            margin-bottom: 40px;
        }

        /* pager wrapper, div */
        .pager {
            padding-left: 0;
            margin: 0;
            text-align: left;
            list-style: none;
        }

        /* pager wrapper, in thead/tfoot */
        td.pager {
            background-color: #e6eeee;
        }

        /* pager navigation arrows */
        .pager img {
            vertical-align: middle;
            margin-right: 2px;
        }

        /* pager output text */
        .pager .pagedisplay {
            font-size: 14px;
            font-weight: bold;
            padding: 0 5px 0 5px;
            width: 50px;
            text-align: center;
        }

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

        /*** css used when "updateArrows" option is true ***/
        /* the pager itself gets a disabled class when the number of rows is less than the size */
        .pager.disabled {
            display: none;
        }

        /* hide or fade out pager arrows when the first or last row is visible */
        .pager img.disabled {
            /* visibility: hidden */
            opacity: 0.5;
            filter: alpha(opacity=50);
        }

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

        .wrapper {
            padding-bottom: 50px;
        }

        .header {
            background: #000000;
        }

        .header .container {
            padding-bottom: 20px;
        }

        .header .container h1 {
            color: #FFF;
            line-height: 50px;
            margin-top: 30px;
            margin-bottom: 0;
        }

        .header .container h3 {
            color: #E0E0E0;
            font-size: 16px;
            margin-top: -5px;
        }

        .header .container h3 a {
            color: #66aacc;
        }

        .header .container h3 a:hover {
            color: #b3d5e6;
        }

        .top-menu {
            position: absolute;
            z-index: 9999;
        }

        .top-menu .nav-list {
            background: rgba(255, 255, 255, 0.8);
            border: 1px solid #CCC;
            margin: 20px;
            position: fixed;
            right: 0;
        }

        pre, .well {
            background: #FFFFFF;
        }

        .syntax-container {
            background: #FCFCFC;
            -webkit-border-radius: 7px;
            -webkit-background-clip: padding-box;
            -moz-border-radius: 7px;
            -moz-background-clip: padding;
            border-radius: 7px;
            background-clip: padding-box;
            border: 1px solid #e3e3e3;
            margin-bottom: 30px;
            padding-bottom: 20px;
        }

        .isloading-wrapper.isloading-right {
            margin-left: 10px;
        }

        .isloading-overlay {
            position: relative;
            text-align: center;
        }

        .isloading-overlay .isloading-wrapper {
            background: #FFFFFF;
            -webkit-border-radius: 7px;
            -webkit-background-clip: padding-box;
            -moz-border-radius: 7px;
            -moz-background-clip: padding;
            border-radius: 7px;
            background-clip: padding-box;
            display: inline-block;
            margin: 0 auto;
            padding: 10px 20px;
            top: 10%;
            z-index: 9000;
        }

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

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

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

        #menuTop {
            margin-top: 30px;
        }

        body {
             /*margin-top: 80px;*/
        }

        h1 {
            font-size: 36px;
        }

    
        /*color de cabecera de tabla*/
        .tablesorter-header-inner, table.tablesorter thead tr th, .tablesorter-filter {
            color: #fff;
            background-color: #307aba;
            border-color: #dedede;
            font-weight: normal;
        }

        table.tablesorter thead tr th {

            height: 40px;
        }

        .tablesorter-blue .headerSortUp, .tablesorter-blue .tablesorter-headerSortUp, .tablesorter-blue .tablesorter-headerAsc {
            background-color: #307aba;
        }

        .tablesorter-blue .headerSortDown, .tablesorter-blue .tablesorter-headerSortDown, .tablesorter-blue .tablesorter-headerDesc {
            background-color: #307aba;
        }

        .tablesorter-blue .tablesorter-filter-row td {
            background: #307aba;
        }

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

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

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

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

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

        .verticalResizer{
            cursor: ns-resize;
        }

        .horizontalResizer{
            cursor: ew-resize;
        }
        .panel .panel-primary {
            min-height: 100px;
            max-height: 300px;
            height: 300px;
            overflow-y: scroll;
            overflow-x: scroll;
        }
        .nav-link.active {
            font-weight: bold;
        }

        .badge {
            font-size: 85%;
        }

        .gradiente {
          height: 100px;
          background-color: #428BCA; /* For browsers that do not support gradients */
          background-image: linear-gradient(0deg, #428BCA, #031A48);
        }

    </style>
    <script src="{{ asset('js/jquery.form.js') }}"></script>
    <script src="{{ asset('js/jquery.isloading.js') }}" type="text/javascript"></script>
    <script src="{{ asset('js/jquery.doubleScroll.js') }}" type="text/javascript"></script>
    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script type="text/javascript" src="{{ asset('js/multiselect.min.js') }}"></script>
    <script type="text/javascript" src="{{ asset('js/jquery.confirm.js') }}"></script> 
    <script type="text/javascript" src="{{ asset('js/jquery.inputmask.js') }}"></script> 
    <script type="text/javascript" src="{{ asset('js/jquery.inputmask.numeric.extensions.min.js') }}"></script>
    <script type="text/javascript" src="{{ asset('js/jquery.confirm.js') }}"></script>   
    <script>

        $(function(){     
            cargar();
            $('.desactivar_masivo').hide();
            $(".inactivar").live('click',function(){
                console.log("prueba");
                if($(this).is(":checked")){
                    $('.desactivar_masivo').show();
                }else{
                    $('.desactivar_masivo').hide();
                    $(".inactivar").each(function(){
                        if($(this).is(":checked")){
                            $('.desactivar_masivo').show();
                        }
                    });
                }
            });
            $(".procesar_desactivar_masivo").live('click',function(){
                $.confirm({
                    title:"Remove Confirmation",
                    text:"Are you sure to delete the records?",
                    confirm: function(button) {
                        var capacity_desactivar = [];
                        $("input[name='capacity[]']:checked").each(function(){
                            capacity_desactivar.push(this.value);
                        });
                        $.ajax({
                            type: "POST",
                            url: "{{path('aspir_DeletedMasivo',{'idproyectos':idproyectos})}}",
                            data: {
                                capacitys: capacity_desactivar
                            },
                            success: function(data){
                                if (data=='Ok'){
                                    swal("Information!", "Deleted Successfully", "success");
                                    cargar();
                                }else{
                                    swal("Error!", "Could not Deleted", "error");
                                }
                            }
                        });
                    },
                    cancel: function(button) {
                        return false;
                    },
                    confirmButton: "Yes, I'm sure",
                    cancelButton: "No"
                });
            });
            $(".delete").live('click',function(){
                $.confirm({
                    title:"Remove Confirmation",
                    text:"Are you sure to delete the records?",
                    confirm: function(button) {
                        var id = $("#idDelete").val();
                        var data = { id : id }; 
                        $.getJSON("{{path('aspir_deleteCapacity')}}", data, function (data){
                            swal("Information!", "Deleted Successfully", "success");
                            cargar();
                        });
                    },
                    cancel: function(button) {
                        return false;
                    },
                    confirmButton: "Yes, I'm sure",
                    cancelButton: "No"
                });
            });
            //////////LISTAR         
            $("#asp").multiselect(); 
            //dependendientes
            $(".get-list").change(function(e) {
                var data_select_refresh = $(this).attr('data');
                var data_act = $(this).attr('data-act');
                var campo_filtrar = $(this).attr('data-campo-filtro');  
                var campo_mostrar = $(this).attr('data-campo-mostrar'); 
                var country = $("#pais").val();
                var customer = $("#cliente").val(); 
                var data = {
                    valor_filtro : $(this).val(),
                    campo_filtrar : campo_filtrar,
                    campo_mostrar : campo_mostrar,
                    country: country,
                    customer: customer
                };
                //console.log(data_act,data_select_refresh);
                $("."+data_act+" option").remove();
                if (data_select_refresh!="asp"){
                    $("."+data_act).append('<option value="TODOS">-- All --</option>');
                }
                if ($(this).val()!='TODOS'){                    
                    $.getJSON('{{path('aspir_llenarSelectCapacity',{'idproyectos':idproyectos,'idmodule':idmodule})}}', data, function (data){
                        var registros = data.registros;
                        for (var i = 0; i < registros.length; i++){
                            $("#"+data_select_refresh).append('<option value="' + registros[i]['valor'] + '">' + registros[i]['nombre'] + '</option>');
                        }
                    });
                }
            });               
            //crear
            $('form[name="formCreate"]').ajaxForm({
                beforeSubmit: function (formData, jqForm, options) {
                    $.isLoading({
                        text: "Creating..."
                    });                   
                },
                error: function (error) {
                    $.isLoading('hide');
                },
                success: function (data) {
                    if (data.respuesta=='Not Ok'){
                        $.isLoading('hide');
                        swal("Error!", data.msj, "error"); 
                    }else{
                        $.isLoading('hide');
                        swal("The capacity was added!", "Ok!", "success");
                        cargar();  
                        //$("#createCapacity").modal('hide');   
                    }          
                }
            });
            $("#crear").click(function(){    
                $('.detalle-semanas').empty();            
                $(".crear_capacity").val('');
                $("#createCapacity").modal();
            });  
            //editar
            $('form[name="formUpdate"]').ajaxForm({
                beforeSubmit: function (formData, jqForm, options) {
                    $.isLoading({
                        text: "Editing..."
                    });                    
                },
                error: function (error) {
                    $.isLoading('hide');
                },
                success: function (data) {
                    if (data.respuesta=='Not Ok'){
                        $.isLoading('hide');
                        swal("Error!", data.msj, "error"); 
                    }else{
                        $.isLoading('hide');
                        swal("The capacity was edited!", "Ok!", "success");
                        cargar();  
                        //$("#updateCapacity").modal('hide');   
                    }           
                }
            });   
            $('.semanal').inputmask("decimal", { min: -1, allowMinus: true });
            //valores del mes
            var d = new Date();
            var month = new Array();
            month[0] = "January";
            month[1] = "February";
            month[2] = "March";
            month[3] = "April";
            month[4] = "May";
            month[5] = "June";
            month[6] = "July";
            month[7] = "August";
            month[8] = "September";
            month[9] = "October";
            month[10] = "November";
            month[11] = "December";
            var n = month[d.getMonth()];
            var options = new Array();
            for(var i=0;i<month.length;i++){
                if(i >=  d.getMonth()){
                    $('#month').append($("<option/>", {
                        value: i + 1,
                        text: month[i]
                    }));
                }
            }   
            $("#month").change(function(){
                var month = $(this).val();
                var data = { month : month }; 
                $.isLoading({text: "Loading..."});
                $('.detalle-semanas').empty();
                $.getJSON("{{path('aspir_detalleSemanasMes',{'idproyectos':idproyectos,'idmodule':idmodule})}}", data, function (data){
                    if (data.semanas){  
                        $.each(data.semanas, function(key, value) {
                            $('.detalle-semanas').append('<label>Week: '+value.semana+'</label>'+
                            '<input type="text" required class="form-control crear_capacity" name="semanal[]">'+
                            '<input type="hidden" required class="form-control crear_capacity" name="week[]" value="'+value.semana+'"></br>'); 
                        });
                        setTimeout(function() { 
                            $('input[name="semanal[]"]').addClass('semanal');
                            $('.semanal').inputmask("decimal", { min: -1, allowMinus: true });
                        }, 1500); 
                    }
                });                
                $.isLoading('hide');  
            })   
        });
        function cargar(){
            var data = {};           
            $.isLoading({text: "Loading..."});
            $.getJSON('{{ path('aspir_showTableCapacity') }}',data,function(data){                 
                //
                $(".table1").remove();
                $(".pager").hide();
                $("#tableContainer").empty();
                //
                var capacidades = data.capacidades;
                //INACTIVOS
                if(capacidades.length == 0){
                    $("#reporte").empty();
                    $("#reporte").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                    $.isLoading("hide");
                    return false;
                }else{                                      
                    var objectType = {"9":1,"10":2,"11":3,"12":4,"13":5,"14":6};
                    $("#reporte").empty().append(createTable(capacidades,undefined,undefined,objectType,'table1'));
                    $('.double-scroll').doubleScroll();
                    var pagerOptions2 = {
                        container: $(".pager"),
                        output: 'Rows  : {endRow}',
                        fixedHeight: false,
                        removeRows: true,
                        cssGoto: '.gotoPage'
                    };                   
                    $(".table1").tablesorter({
                        theme: 'blue',
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            filter_cssFilter: '',
                            filter_childRows: false,
                            filter_hideFilters: false,
                            filter_ignoreCase: true,
                            filter_reset: '.reset',
                            filter_saveFilters: true
                        }
                    }).tablesorterPager(pagerOptions2);
                    $('.pager').show();
                }
                $.isLoading('hide');
            }).fail(function(){
                $.isLoading('hide');
            }); 
        }

        function edit(id){
            $("#idCapacity").val(id);            
            var data = { id : id }; 
            $.getJSON("{{path('aspir_detalleEditarCapacity',{'idproyectos':idproyectos,'idmodule':idmodule})}}", data, function (data){
                if (data.detail){    
                        $("#cuEdit").val(data.detail.cu);
                        $("#countryEdit").val(data.detail.country);
                        $("#customerEdit").val(data.detail.customer);
                        $("#projectEdit").val(data.detail.project);
                        $("#aspEdit").val(data.detail.asp);
                }
            }); 
            $("#updateCapacity").modal();        
        }

        function editDetalle(id){
            $("#idCapacity").val(id);            
            /*var data = { id : id }; 
            $.getJSON("{{path('aspir_detalleEditarCapacity',{'idproyectos':idproyectos,'idmodule':idmodule})}}", data, function (data){
                if (data.detail_mes){            
                    //$(".detalle-editar-capacidad").empty();                    
                    //$(".detalle-editar-capacidad").append('<div class="menu_head">');
                    $(".detalle-editar-capacidad-lista").empty();        
                    $(".detalle-editar-capacidad-lista").append('<label>MONTH-WEEK</label><select id="data-semana-mes" name="weeks-cargar[]" multiple="multiple" style="width: 100%;height:200px" required>');
                    $.each(data.detail_mes, function(key, value) {
                        $("#cuEdit").val(value.cu);
                        $("#countryEdit").val(value.country);
                        $("#customerEdit").val(value.customer);
                        $("#projectEdit").val(value.project);
                        $("#aspEdit").val(value.asp);
                        $(".detalle-editar-capacidad").append('<label>'+value.mes+'</label><br>');
                        var semanas = value.weeks.split(",");
                        var cantidad_week = value.cantidad_week.split(",");
                        $.each(semanas,function(key1, value1){
                            $("#data-semana-mes").append('<option value='+value.fecha+'-'+value1+'>'+value.mes+'-'+value1+'</option>');
                            /*$(".detalle-editar-capacidad").append('<label>Week '+value1+':</label>'+
                            '<input type="text" required class="form-control" name="semanal[]" value="'+cantidad_week[key1]+'">'+
                            '<input type="hidden" required class="form-control" name="week[]" value="'+value1+'">'+
                            '<input type="hidden" required class="form-control" name="fecha[]" value="'+value.fecha+'"></br>')*/
                        /*});                        
                    });
                    //$(".detalle-editar-capacidad").append('</div>');       
                    $("#data-semana-mes").append('</select>');             
                    /*setTimeout(function() { 
                        $('input[name="semanal[]"]').addClass('semanal');
                        $('.semanal').inputmask("decimal", { min: -1, allowMinus: true });
                    }, 1500);*/                    
                    /*$("#updateCapacity").modal();
                }
            }); */
            $("#updateCapacity").modal();
            //cargar();        
        }

        function borrar(id){       
            $("#idDelete").val(id);
        }

        function detail(id){
            var data = { id : id }; 
            $.isLoading({text: "Loading..."});
            $.getJSON("{{path('aspir_detalleCapacity',{'idproyectos':idproyectos,'idmodule':idmodule})}}", data, function (data){
                console.log(data.detail.length);
                if (data.detail.length>0){            
                    $("#datatable_detalle").empty();
                    var col = createTableDTDetail(Object.keys(data.detail[0]),'table_detalle', 'datatable_detalle');
                    buildDatatablePrin('table_detalle',col,data.detail);
                    $('[data-toggle="popover"]').popover('destroy');
                    $('[data-toggle="popover"]').popover({
                        template: '<div class="popover" role="tooltip" style="width: 800px;"><div class="arrow"></div><h3 class="popover-title"></h3><div class="popover-content"><div class="data-content"></div></div></div>'
                    }).on("show.bs.popover", function () { $(this).data("bs.popover").tip().css("max-width", "600px"); });
                    
                    $.isLoading('hide'); 
                }else{
                    $.isLoading('hide'); 
                }
            });
            $("#detalleCapacity").modal();          
        }

        function createTable(monitor,total,nombreColTotal,type,idTable){
            var header = Object.keys(monitor[0]);
            var headerType = Object.keys(type);
            var table = '<table  class="table table-bordered table-hover table-striped table-responsive '+idTable+'"> <thead>' +
                        '<tr class="btn-info">';

            for (var j = 0; j < header.length; j++) {
                table += '<th class=\'text-center\'>' + header[j] + '</th>';
                
            }

            table += '</tr></thead>';

            for (var i = 0; i < monitor.length; i++) {
                table += '<tr class=\'text-center\' id=\'' + monitor[i][header[0]] + '\'>';

                for (var j = 0; j < header.length; j++) {
                    var clases = '';                    
                    table += "<td "+clases+">" + monitor[i][header[j]]  + "</td>";   
                }

                table += '</tr>';
                if (typeof total !== 'undefined') {
                    if (i == monitor.length - 1) {
                        var headerTotal = Object.keys(total);
                        table += '<tr><td>' + nombreColTotal + '</td>';
                        for (var x = 0; x < headerTotal.length; x++) {
                            table += '<td>';
                            table += total[headerTotal[x]];
                            table += '</td>';
                        }
                        table += '</tr>';
                    }
                }
            }
            table += '</table>';
            return table;
        } 
        function createTableDTDetail(data, tableRender, dtRender){
            var strHeader = "";
            var strFooter="";
            var columns = [];
            var strType = "";
            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 visible = title.startsWith('_') ? false : true;                
                strHeader += '<th class="text-center">' + title + '</th>';                
                columns.push({data: data[i], title: title, visible:visible});
            }
            strTable += strHeader + '</tr></thead><tbody id="tbody_' + tableRender + '"></tbody>' + strFooter + '</table>';
            $('#' + dtRender).empty();
            $('#' + dtRender).html(strTable);
            $('#' + tableRender + ' thead tr').clone(true).appendTo( '#' + tableRender + ' thead' );
            $('#' + tableRender + ' thead tr:eq(1) th').each( function (i) {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%; margin: 0px; padding: 0px;"/>' );
                $( 'input', this ).on( 'keyup change', function () {
                    if ( $.fn.DataTable.isDataTable( '#' + tableRender ) ) {
                        var table = $('#' + tableRender).DataTable();
                        if ( table.column(i).search() !== this.value ) {
                            table
                                    .column(i)
                                    .search( this.value )
                                    .draw();
                        }
                    }
                } );
            } );

            return columns;
        }
        function buildDatatablePrin(render, columnas, data,suffix_export,orderArray)
        {
            var a=[];b=[];
            var Defs = [];
            var ini = (columnas.length) -5;
            var kpi = '';
            for (var i=0; i<=(columnas.length - 1); i++){
                a.push(i);
            }
            Defs.push({ targets: a, className: 'dt-body-center' });
            for (var i=0; i<=(columnas.length - 1); i++){
                if (columnas[i].visible){
                    b.push(i);
                }
            }           
            table = $('#'+render).DataTable( {
                dom: '<"row" <"col-md-12 text-right"B>> <"row" <"col-md-6 "l> <"col-md-6"f>>rtip',
                scrollY: '60vh',
                scrollX: true,
                scrollCollapse: true,
                orderCellsTop: true,
                data:data,
                "deferRender": false,
                "processing": true,
                "language": {
                    "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                },
                //"order": [[ 0, "asc" ]],
                "ordering": true,
                columns: columnas,
                columnDefs: Defs,
                lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                buttons: [
                    {
                        extend:'excel',
                        text: 'Table Excel ',
                        exportOptions: {
                            columns: b,
                            orthogonal: 'export'
                        },
                        title: 'Capacity'
                    }
                ],
                drawCallback: function() {
                    $('[data-toggle="popover"]').popover();
                } 
            } );
        } 
    </script>
    <div class ="container-fluid" id="info">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 text-center m-b-2" >
                <h1>Capacity ASP</h1>
            </div>
        </div>    
        <div class="row muestra_crear_usuario">
            <div class="col-md-10"></div>
            <div class="col-md-2">
            {% if is_granted('ROLE_ADD_CAPACITY') %} 
                 <button type="button" id="crear" class="btn btn-success" style="width: 100%">Add Capacity</button>
            {% endif %}
            </div>
        </div>

        <input type="hidden" id="idDelete">
        <br>
        {% if is_granted('ROLE_EDIT_CAPACITY') %} 
            <div class="row desactivar_masivo text-right">
                <div class="col-md-12">
                    <button type="button" class="btn btn-info col-md-offset-6 procesar_desactivar_masivo">Delete</button>
                </div>
            </div>
        {% endif %}
        <div class="row">
            <div id="reporte" class="col-lg-12"></div>
        </div>
        <div class="row">
            <div id="pager" class="pager tablesorter-pager" style="display: none;text-align: center">
                <form>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/first.png')}}" class="first"/>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/prev.png')}}" class="prev"/>
                    <span class="pagedisplay"></span>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/next.png')}}" class="next"/>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/last.png')}}" class="last"/>
                    <select class="pagesize" title="Select page size">
                        <option selected="selected" value="1000">1000</option>
                        <option  value="500">500</option>
                        <option  value="100">100</option>
                    </select>
                </form>
            </div>
        </div>
    </div>
    <!-- Modal Create Capacity -->
    <div class="modal fade" id="createCapacity" role="dialog">
        <div class="modal-dialog">
          <form id="formCreateUser" name="formCreate" action="{{ path('aspir_crearCapacity',{'idproyectos':idproyectos,'idmodule':idmodule}) }}" method="POST"> 
          <!-- Modal content-->
            <div class="modal-content">
                <div class="modal-header bg-primary">
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                    <h4 class="modal-title">Create Capacity</h4>
                </div>              
                <div class="modal-body">
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-6">
                            <label>CU</label>
                            <select required class="form-control crear_capacity get-list" 
                            id="cu" name="cu" data='pais'
                            data-act='refresh_cu' data-campo-filtro='cu' data-campo-mostrar='country'>
                                <option value="TODOS">-- All -- </option>
                                {%for cu in cus%}
                                    <option value="{{cu.valor}}">{{cu.nombre}}</option>
                                {%endfor%}
                            </select>
                        </div>
                        <div class="col-md-6">
                            <label>Country</label>
                            <select required class="form-control crear_capacity get-list pais refresh_cu" id="pais" name="country" data='cliente' data-campo-filtro='country' data-campo-mostrar='customer' data-act='refresh_pais'>
                                <option value="TODOS">-- All --</option>
                            </select>
                        </div>
                    </div>
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-6">
                            <label>Customer</label>
                            <select required class="form-control crear_capacity get-list cliente refresh_cu refresh_pais" id="cliente" name="customer" data='proyecto' data-campo-filtro='customer' data-campo-mostrar='project' data-act='refresh_cliente'>
                                <option value="TODOS">-- All --</option>
                            </select>
                        </div>
                        <div class="col-md-6">
                            <label>Project</label>
                            <select required class="form-control crear_capacity get-list cliente refresh_cu refresh_pais refresh_cliente" id="proyecto" name="project" data='asp' data-campo-filtro='project' data-campo-mostrar='asp' data-act='refresh_proyecto'>
                                <option value="TODOS">-- All --</option>
                            </select>
                        </div>
                    </div> 
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-12">
                            <label>ASP</label>
                            <select required class="form-control crear_capacity refresh_pais refresh_cu refresh_cliente refresh_proyecto" id="asp" name="asp[]" multiple="multiple" style="width: 100%;">
                            </select>
                        </div>
                    </div>  
                    <!--<div class="row" style="margin-top:8px">
                        <div  class="col-md-8">                                           
                           <label>Month: </label>
                           <select id="month" name="month" class="form-control crear_capacity">
                                <option value=""></option>
                           </select>
                        </div> 
                    </div> 
                    <div class="row muestra-semanas" style="margin-top:8px">
                        <div class="col-md-8 detalle-semanas">

                        </div>
                    </div>  -->
                    <div class="row" style="margin-top:8px">
                        <div  class="col-md-8">                                           
                           <label>Month: </label>
                            <select class="form-control crear_capacity" required  id="agregat-data-semana-mes" name="agregar_weeks_cargar[]" multiple="multiple" style="width: 100%;height: 200px;">
                                {%for semana in lista_semanas%}
                                    <option value="{{semana.semanas}}">{{semana.mes_semanas}}</option>
                                {%endfor%}
                            </select>
                        </div>
                    </div>
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-6">
                            <label>CAPACITY</label>
                            <input type="text" required class="form-control semanal crear_capacity" name="agregar_capacidad_semanal" id="agregar_capacidad_semanal">
                        </div>
                    </div> 
                </div>
                <div class="modal-footer">
                    <button type="submit" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                </div>    
            </div>
          </form>  
        </div>
    </div>

    <!-- Modal Editar Capacity -->
    <div class="modal fade" id="updateCapacity" role="dialog">
        <div class="modal-dialog">
          <form id="formCreateUser" name="formUpdate" action="{{ path('aspir_editarCapacity',{'idproyectos':idproyectos,'idmodule':idmodule}) }}" method="POST"> 
          <!-- Modal content-->
            <div class="modal-content">
                <div class="modal-header bg-primary">
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                    <h4 class="modal-title">Edit Capacity</h4>
                </div>              
                <div class="modal-body">
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-6">
                            <label>CU</label>
                            <input type="hidden" required  class="form-control" id="idCapacity" name="id">
                            <input type="text" required readonly class="form-control" id="cuEdit" name="cu">
                        </div>
                        <div class="col-md-6">
                            <label>Country</label>
                            <input type="text" required class="form-control" id="countryEdit" name="country" readonly>
                        </div>
                    </div>
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-6">
                            <label>Customer</label>
                            <input type="text" required class="form-control" id="customerEdit" name="customer" readonly>
                        </div>
                        <div class="col-md-6">
                            <label>Project</label>
                            <input type="text" required class="form-control" id="projectEdit" name="project" readonly>
                        </div>
                    </div>   
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-12">
                            <label>ASP</label>
                            <input type="text" required class="form-control" id="aspEdit" name="asp" readonly>
                        </div>
                    </div>  
                    <!--<div class="row" style="margin-top:8px">                        
                        <div class="col-md-12 detalle-editar-capacidad-lista">
                            
                        </div>
                        <div class="col-md-8 detalle-editar-capacidad">
                            
                        </div>
                    </div>  
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-6">
                            <label>CAPACITY</label>
                            <input type="text" required class="form-control semanal" name="capacidad_semanal" id="capacidad_semanal">
                        </div>
                    </div> --> 
                    <div class="row" style="margin-top:8px">
                        <div  class="col-md-8">                                           
                           <label>Month: </label>
                            <select class="form-control crear_capacity" required  id="editar-data-semana-mes" name="editar_weeks_cargar[]" multiple="multiple" style="width: 100%;height: 200px;">
                                {%for semana in lista_semanas%}
                                    <option value="{{semana.semanas}}">{{semana.mes_semanas}}</option>
                                {%endfor%}
                            </select>
                        </div>
                    </div>
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-6">
                            <label>CAPACITY</label>
                            <input type="text" required class="form-control semanal crear_capacity" name="editar_capacidad_semanal" id="editar_capacidad_semanal">
                        </div>
                    </div>                     
                </div>
                <div class="modal-footer">
                    <button type="submit" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                </div>    
            </div>
          </form>  
        </div>
    </div>

    <!-- Modal Detalle Capacity -->
    <div class="modal fade" id="detalleCapacity" role="dialog">
        <div class="modal-dialog modal-lg">
          <!-- Modal content-->
            <div class="modal-content" style="width: 1200px;margin: 0px 0px 0px -140px;">
                <div class="modal-header bg-primary">
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                    <h4 class="modal-title">Detail Capacity</h4>
                </div>              
                <div class="modal-body">
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-12">
                            <div id="datatable_detalle" class="col-sm-12">
                                <table id="table_detalle" class="display nowrap" width="100%">
                                    <thead>
                                    <tr></tr>
                                    </thead>
                                    <tbody id="tbody_detalle"></tbody>
                                </table>
                            </div>
                        </div>                        
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                </div>    
            </div>
          </form>  
        </div>
    </div>
  
</div>
{% endblock %}
{% block javascripts %}
    <link rel="stylesheet" href="{{ asset('css/jquery.dataTables.min.css')}}">
    <link rel="stylesheet" href="{{ asset('css/buttons.dataTables.min.css')}}">
    <link rel="stylesheet" href="{{ asset('datatables/css/select.bootstrap.min.css')}}">
    <script src="{{ asset('js/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('js/buttons.flash.min.js') }}"></script>
    <script src="{{ asset('js/jszip.min.js') }}"></script>
    <script src="{{ asset('js/pdfmake.min.js') }}"></script>
    <script src="{{ asset('js/vfs_fonts.js') }}"></script>
    <script src="{{ asset('js/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('js/buttons.print.min.js') }}"></script>
    <script src="{{ asset('datatables/js/dataTables.select.min.js') }}"></script>
    <script src="{{ asset('datatables/moment.min.js') }}"></script>
    <script src="{{ asset('datatables/js/datetime-moment.js') }}"></script>
    <script src="{{ asset('js/grouped-categories.js') }}"></script>        
{% endblock %}