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

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

{% block menuTop %}
{% endblock %}

{% block dashboard %} 
    <style>

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

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

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

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

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

            padding-left: 5px;
        }
        #chart .panel-body {
            padding: 0px;
        }
        .btn-claro {
            color: #fff;
            /*background-color: #00569C;
            border-color: #3D59CA;*/
            background-color: #428bca;
            border-color: #3071a9;
        }
        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
        }
        .tabla-detalle
        {
                text-transform: uppercase;
                font-size: 9px;
        }
    
        .disabledTab{
            pointer-events: none;
        }
        #menuTop { margin-top: 0px; }

        .form-inline .form-group { margin-bottom: 20px; }

        .form-group{ margin-left: 20px; }

        hr.style14 { 
            border: 0; 
            height: 1px; 
            background-image: -webkit-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -moz-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -ms-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -o-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0); 
        }

        .hrHide { display: none; }

        .highcharts-container{width:100% !important;}

      
        table th{
            {#text-transform: uppercase;#}
            font-weight: bold;
            font-size: 12px;
        }
        
        table td{
            {#text-transform: uppercase;#}
            font-weight: normal;
            font-size: 12px;
        }        

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

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

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

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

        .verticalResizer{
            cursor: ns-resize;
        }

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

        .badge {
            font-size: 85%;
        }

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

        /* ===================== FILE INPUT ===================== */
        .file-area {
            width: 100%;
            position: relative;
            border: 1px dashed #ccc;
        }

        .file-area input[type=file] {
            position: absolute;
            width: 100%;
            height: 100%;
            top: 0;
            left: 0;
            right: 0;
            bottom: 0;
            opacity: 0;
            cursor: pointer;
        }

        .file-area .file-dummy {
            width: 100%;
            padding: 30px;
            background: rgba(255, 255, 255, 0.2);
            border: 2px dashed rgba(255, 255, 255, 0.2);
            text-align: center;
            transition: background 0.3s ease-in-out;
        }

        .file-area .file-dummy .success {
            display: none;
        }

        .file-area:hover .file-dummy {
            background: rgba(255, 255, 255, 0.1);
        }

        .file-area input[type=file]:focus + .file-dummy {
            outline: 2px solid rgba(255, 255, 255, 0.5);
            outline: -webkit-focus-ring-color auto 5px;
        }

        .file-area input[type=file]:valid + .file-dummy {
            border-color: rgba(0, 255, 0, 0.4);
            background-color: rgba(0, 255, 0, 0.3);
        }

        .file-area input[type=file]:valid + .file-dummy .success {
            display: inline-block;
        }

        .file-area input[type=file]:valid + .file-dummy .default {
            display: none;
        }
    </style>
    <link  href="{{ asset('bootstrap-multiselect/css/bootstrap-multiselect.css') }}" rel="stylesheet" type="text/css" />
    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script src="{{ asset('js/jquery.numeric.js') }}"></script>
    <script src="{{ asset('js/jquery.form.js') }}"></script>    
    <script src="{{ asset('js/jquery.isloading.js') }}" type="text/javascript"></script>

    <link rel="stylesheet" href="{{ asset('js/jquery.isloading.js') }}">
    <script>
        //VALIDACIONES JQUERY
        $(document).ready(function (){       
            //cargar sitios 
            getChart();    
            //UPLOAD    
            $("#upload").click(function (){
                $("#file").val('');
                $(".file-area").removeClass('file-dummy');  
                $('#modalfileUpload').modal('show');
            });
            //subir planificacion
            $("#saveFile").click(function () {
                if ($("#file").val()==""){
                    swal("Error!", "El archivo es requerido", "error");
                    return false;
                }/*else if ($("#mes").val()==""){
                    swal("Error!", "El mes es requerido", "error");
                    return false;
                }else if ($("#frecuencia").val()==""){
                    swal("Error!", "La frecuencia es requerida", "error");
                    return false;
                }*/else{    
                    //$.isLoading({
                      //  text: "Loading"
                    //});         
                    //$("#saveFile").attr("disabled", true);
                    var formData = new FormData(document.getElementById("form-uploadg")); 
                    var url = "{{ (path('reportColombia_uploadSitiosPreventivos', {'idproyectos': '{{idproyectos}}','idmodule': '{{idmodule}}'})) }}";
                    $.ajax({ 
                        url: url,
                        type: 'post',
                        data: formData,
                        contentType: false,
                        processData: false,            
                        success: function(data){
                           //$.isLoading("hide");
                           //$("#saveFile").attr("disabled", false);    
                           if (data.result=='Ok'){            
                                $('#modalfileUpload').modal('hide');
                                swal("Información!", data.msj, "success");
                                location.reload();
                           }else if (data.result=="Ok duplicate"){
                                $('#modalfileUpload').modal('hide');
                                swal("Información!", data.msj, "success");
                           }else if (data.result=="Duplicate"){     
                                $('#modalfileUpload').modal('hide');                       
                                swal("Error!", data.msj, "error");
                           }else if (data.result=="Not Ok" || data.result=="Not file"){
                                swal("Error!", "Error Upload", "error");
                           }
                        } 
                    });
                }
            }); 
            //modificar
            $("#saveModificar").click(function () {  
                $.isLoading({
                    text: "Loading"
                });              
                $("#saveModificar").attr("disabled", true);
                var formData = new FormData(document.getElementById("form-modificar")); 
                var url = "{{ (path('reportColombia_modificarSitioPreventivo', {'idproyectos': '{{idproyectos}}','idmodule': '{{idmodule}}'})) }}";
                $.ajax({ 
                    url: url,
                    type: 'post',
                    data: formData,
                    contentType: false,
                    processData: false,            
                    success: function(data){
                       $.isLoading("hide");
                       $("#saveModificar").attr("disabled", false);   
                       if (data.result=='Ok'){            
                            $('#modalModificar').modal('hide');
                            swal("Información!", "Sitio modificado correctamente!", "success");
                            getChart();
                       }else if (data.result=="Not Ok"){
                            swal("Error!", "Error modificando el sitio", "error");
                       }
                    } 
                });                
            }); 
            //eliminar
            $("#saveEliminar").click(function () {  
                 if ($("#motivoEliminar").val()==""){
                    swal("Error!", "El motivo es requerido", "error");
                    return false;
                }else{ 
                    $.isLoading({
                        text: "Loading"
                    });              
                    $("#saveEliminar").attr("disabled", true);
                    var formData = new FormData(document.getElementById("form-eliminar")); 
                    var url = "{{ (path('reportColombia_eliminarSitioPreventivo', {'idproyectos': '{{idproyectos}}','idmodule': '{{idmodule}}'})) }}";
                    $.ajax({ 
                        url: url,
                        type: 'post',
                        data: formData,
                        contentType: false,
                        processData: false,            
                        success: function(data){
                           $.isLoading("hide");
                           $("#saveEliminar").attr("disabled", false);   
                           if (data.result=='Ok'){            
                                $('#modalEliminar').modal('hide');
                                swal("Información!", "Sitio eliminado correctamente!", "success");
                                getChart();
                           }else if (data.result=="Not Ok"){
                                swal("Error!", "Error eliminando el sitio", "error");
                           }
                        } 
                    });   
                }             
            });             
        });
        //FUNCIONES DE JAVASCRIP
        function getChart(){    
            $.isLoading({
                text: "Loading"
            });
            //console.log('funcion getChart'); 
            var parametros = {
            };
            $.getJSON('{{path('reportColombia_listadoSitios',{'idproyectos':idproyectos,'idmodule':idmodule})}}', parametros, function (data){
                var chart = data;                            
                
                // Tabla Listado de Sitios
                if (chart.table_ListadoSitios.length > 0){
                     $("#datatable_ListadoSitios").empty();
                     var col = createTableDT(Object.keys(chart.table_ListadoSitios[0]),'table_ListadoSitios', 'datatable_ListadoSitios');
                     buildDatatablePrin('table_ListadoSitios',col,chart.table_ListadoSitios);
                }else{
                    $("#datatable_ListadoSitios").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                $.isLoading("hide");
            });            
        } 
        function generateModal(ruta, objParams, numerar, title, subtitle, orderArray)
        {        
          
            var title_ = title!=null ? title.trim() : "";
            var ordArr = orderArray!=null ? orderArray : null;
            $("#datatableModalDetalle").empty().isLoading();
            $('#myModal .punto-grafica').empty().hide();
            $('#myModal .modal_detalle_titulo').empty();
            if (title != null)
            {
                $('#myModal .modal_detalle_titulo').html(title);
                title_ = title_.replace(' ','_');
                title_ = title_.replace('-','');
                title_ = title_.replace(' ','');
            }
            else
            {
                $('#myModal .modal_detalle_titulo').html('{{'monitorii.detail' | trans }}');
                title = '{{'monitorii.detail' | trans }}';
                title_ = title_.replace(' ','_');
                title_ = title_.replace('-','');
                title_ = title_.replace(' ','');
            }
            if (subtitle != null)
            {
                $('#myModal .punto-grafica').html(subtitle).show();
            }
            $.getJSON(ruta, objParams, function (data)
            {
                if (data.length > 0){ 
                    var total_general = 0; 
                    var porcentaje_ohs = 0; 
                    var total_registros = 0;                          
                    var col = createTableDTDetail(Object.keys(data[0]),'tableModalDetalle', 'datatableModalDetalle',objParams.kpi,porcentaje_ohs,total_registros);
                    buildDatatablePrin('tableModalDetalle',col,data,title_,ordArr);
                    $('[data-toggle="popover"]').popover('destroy');
                    $('[data-toggle="popover"]').popover({
                        template: '<div class="popover" role="tooltip" style="width: 800px;"><div class="arrow"></div><h3 class="popover-title"></h3><div class="popover-content"><div class="data-content"></div></div></div>'
                    }).on("show.bs.popover", function () { $(this).data("bs.popover").tip().css("max-width", "600px"); });
                }else{
                    $("#datatableModalDetalle").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                $("#datatableModalDetalle").isLoading('hide');
            });

            $('#myModal').modal('show');
        }
        function createTableDTDetail(data, tableRender, dtRender, type, porcentaje_ohs, total_registros){
            var strHeader = "";
            var strFooter="";
            var columns = [];
            var col_issues = 8;
            var strType = (type == null ? "" : type);
            var strTable = '<table id="' + tableRender + '" class="display cell-border compact stripe" width="100%">' +
                    '<thead><tr class="header_dt">';
            $('#' + dtRender).empty();                               
            for (var i=0; i<data.length; i++){
                var title = data[i];
                var t = title.replace(/_/g,' ');
                t = title.replace('#','');
                var visible = title.startsWith('_') ? false : true;
                strHeader += '<th class="text-center">' + t + '</th>';               
                columns.push({data: data[i], title: t, visible:visible});
            }
            strTable += strHeader + '</tr></thead><tbody id="tbody_' + tableRender + '"></tbody>' + strFooter + '</table>';
            $('#' + dtRender).empty();
            $('#' + dtRender).html(strTable);
            $('#' + tableRender + ' thead tr').clone(true).appendTo( '#' + tableRender + ' thead' );
            $('#' + tableRender + ' thead tr:eq(1) th').each( function (i) {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%; margin: 0px; padding: 0px;"/>' );
                $( 'input', this ).on( 'keyup change', function () {
                    if ( $.fn.DataTable.isDataTable( '#' + tableRender ) ) {
                        var table = $('#' + tableRender).DataTable();
                        if ( table.column(i).search() !== this.value ) {
                            table
                                    .column(i)
                                    .search( this.value )
                                    .draw();
                        }
                    }
                } );
            } );
            return columns;
        }
        //configuracion de los datatable
        function buildDatatablePrin(render, columnas, data,suffix_export,orderArray)
        {
            var a=[];b=[];
            var Defs = [];
            var ini = (columnas.length) -5;
            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" ]],
                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: 'Excel'
                    }
                ],
                drawCallback: function() {
                    $('[data-toggle="popover"]').popover();
                } 
            } );
        }   
        //funcion para crear las tablas
        function createTableDT(data, tableRender, dtRender)
        {
            //console.log(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();
            var ticket = "";
            for (var i=0; i<data.length; i++){
                var fechaGroup = ""
                var title = data[i];
                var t = title.replace(/_/g,' ');
                t = title.replace('#','');
                var visible = title.startsWith('_') ? false : true;
                if (t!='workplan_id'){
                    
                    strHeader += '<th class="text-center">' + t + '</th>';
                }  
                if (title=='WITHIN TARGET'){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){                                
                                var kpi='total_qi';
                                var table_title = 'Within Target';                               
                                var subtitle = "";
                                var url= "{{ path('aspir_detalle_tabla_rusia') }}";
                                subtitle= row.hasOwnProperty('MONTH') ? row['MONTH'] : "";
                                subtitle += (row.hasOwnProperty('COUNTRY') ? " [" + row['COUNTRY'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('CUSTOMER') ? " [" + row['CUSTOMER'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('PROJECT') ? " [" + row['PROJECT'] + "]" : "") ;
                                subtitle += (row.hasOwnProperty('ASP') ? " [" + row['ASP'] + "]" : "") ;
                                var ord = null;
                                //parametros fitro
                                var pais_filter = $('#pais').val();
                                var proyecto_filter = $('#proyecto').val();  
                                 
                                var region_filter = $('#region').val();
                                var macroregion_filter = $('#macroregion').val();
                                if($('#asp_user').val()!=''){
                                    var asp_filter = $('#asp_user').val();
                                }else{
                                   var asp_filter = $('#asp').val();   
                                }   
                                if($('#asp_user').val()!=''){
                                    var asp = $('#asp_user').val();
                                }else{
                                   var asp = row.hasOwnProperty('ASP') ? row['ASP'] : $('#asp').val();   
                                }    
                                if($('#cliente_user').val()!=''){
                                    var cliente = $('#cliente_user').val(); 
                                    var cliente_filter = $('#cliente_user').val(); 
                                }else{
                                   var cliente = row.hasOwnProperty('CUSTOMER') ? row['CUSTOMER'] : $('#cliente').val(); 
                                   var cliente_filter = $('#cliente').val(); 
                                }                          
                                var parametros = {
                                    'postfix': 'rusia',
                                    'kpi': kpi,
                                    'FechaInicio': $('#Filtros_fechaIni').val(),
                                    'FechaFin': $('#Filtros_fechaFin').val(),
                                    'pais': row.hasOwnProperty('COUNTRY') ? row['COUNTRY'] : $('#pais').val(),
                                    'cliente': cliente,
                                    'proyecto': row.hasOwnProperty('PROJECT') ? row['PROJECT'] : $('#proyecto').val(),
                                    'asp': asp,
                                    'macroregion': row.hasOwnProperty('MACROREGION') ? row['MACROREGION'] : $('#macroregion').val(),
                                    'region': row.hasOwnProperty('REGION') ? row['REGION'] : $('#region').val(),
                                    'mes': row['MONTH'],
                                    'pais_filter': pais_filter,
                                    'proyecto_filter': proyecto_filter,
                                    'cliente_filter': cliente_filter,
                                    'region_filter': region_filter,
                                    'macroregion_filter': macroregion_filter,
                                    'asp_filter': asp_filter,
                                };
                                return '<a href="javascript://" ' +
                                        'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';
                            }else{
                                return dato;
                            }                            
                        }
                    });
                }else if(title == 'Month'){  
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {     
                            fechaGroup = dato;
                            return dato;                 
                        }
                    });
                }else{
                    columns.push({data: data[i], title: t, visible:visible});
                }
            }
            strTable += strHeader + '</tr></thead><tbody id="tbody_' + tableRender + '"></tbody>' + strFooter + '</table>';
            $('#' + dtRender).empty();
            $('#' + dtRender).html(strTable);
            $('#' + tableRender + ' thead tr').clone(true).appendTo( '#' + tableRender + ' thead' );
            $('#' + tableRender + ' thead tr:eq(1) th').each( function (i) {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%; margin: 0px; padding: 0px;"/>' );
                $( 'input', this ).on( 'keyup change', function () {
                    if ( $.fn.DataTable.isDataTable( '#' + tableRender ) ) {
                        var table = $('#' + tableRender).DataTable();
                        if ( table.column(i).search() !== this.value ) {
                            table
                                    .column(i)
                                    .search( this.value )
                                    .draw();
                        }
                    }
                } );
            } );
            return columns;
        }   
        function modificar(id){
            $("#idModificar").val(id);
            var parametros = {
                'id': id,
            };
            $.getJSON('{{path('reportColombia_detalleSitioPlanificacion',{'idproyectos':idproyectos,'idmodule':idmodule})}}', parametros, function (data){
                if (data){
                    $("#mes").val(data.buscar_planificacion.mes);
                    $("#frecuencia").val(data.buscar_planificacion.frecuencia_preventivos);
                    $('#modalModificar').modal('show');
                }
            });             
        }
        function eliminar(id,isActive){
            $("#motivoEliminar").val('');
            $("#idEliminar").val(id);
            $("#isActive").val(isActive);
            if (isActive==0){
                $("#myModalLabelEliminar").text('DESACTIVAR');
            }else{
                $("#myModalLabelEliminar").text('ACTIVAR');
            }
            $('#modalEliminar').modal('show');            
        }
    </script>
    <div class="container-fluid">        

        <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>LISTADO DE SITIOS PREVENTIVOS</strong>
                </h1>
            </div>
        </div> 
        <form id="formulario_filtros" onsubmit="return false;">
            <div>
                <div id="collapse1">
                    <div>                              
                            <div class="row"> 
                                <div class="col-md-4 col-sm-6 col-xs-12">
                                </div> 
                                <div  class="col-md-4 col-sm-8 col-xs-12">
                                </div>   
                                <div  class="col-md-4 col-sm-8 col-xs-12">
                                    <div class="form-group">
                                        <button class="btn btn-primary form-control" id="upload">Cargar Frecuencia</button>
                                    </div>  
                                </div> 
                            </div>                                    
                        </div>                                                
                    </div>
                </div>            
        </form>
        <div class="row">
            <div id="datatable_ListadoSitios" class="col-sm-12">
                <table id="table_ListadoSitios" class="display nowrap" width="100%">
                    <thead>
                    <tr></tr>
                    </thead>
                    <tbody id="tbody_ListadoSitios"></tbody>
                </table>
            </div>
        </div>
    </div>    

    <!--MODAL UPLOAD -->
     <div class="modal fade" id="modalfileUpload" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
         <div class="modal-dialog" role="document">
             <div class="modal-content">
                 <div class="modal-header  bg-primary">
                     <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                     <h2 class="modal-title text-center" id="myModalLabel"> Cargar Frecuencia</h2>
                 </div>
                 <button class="btn btn-warning">
                   <a href="{{ asset('Plantillas/TemplateSitiosFrecuencia.xlsx')}}" download="TemplateSitiosFrecuencia.xlsx" style="float: left;" title="Template">
                       <img src="{{ asset('images/xls.png') }}" width="24px">Descargar template
                   </a>
                </button>
                 <form id="form-uploadg" name="form-uploadg" method="post"  enctype="multipart/form-data">
                     <div class="modal-body">
                        <!--<div class="row">
                             <div class="col-lg-12"  style="margin-top: 1%">
                                <label>FRECUENCIA</label>
                                <select class="form-control" id="frecuencia" name="frecuencia">
                                    <option value=""></option>
                                    <option value="Mensual">Mensual</option>
                                    <option value="Trimestral">Trimestral</option>
                                    <option value="Cuatrimestral">Cuatrimestral</option>
                                    <option value="Semestral">Semestral</option>
                                    <option value="Anual">Anual</option>
                                </select>
                             </div>
                             <div class="col-lg-12"  style="margin-top: 1%">
                                <label>MES INICIO</label>
                                <select class="form-control" id="mes" name="mes">
                                    <option value=""></option>
                                    <option value="1">ENERO</option>
                                    <option value="2">FEBRERO</option>
                                    <option value="3">MARZO</option>
                                    <option value="4">ABRIL</option>
                                    <option value="5">MAYO</option>
                                    <option value="6">JUNIO</option>
                                    <option value="7">JULIO</option>
                                    <option value="8">AGOSTO</option>
                                    <option value="9">SEPTIEMBRE</option>
                                    <option value="10">OCTUBRE</option>
                                    <option value="11">NOVIEMBRE</option>
                                    <option value="12">DICIEMBRE</option>
                                </select>
                             </div> 
                         </div>-->
                         <div class="row">
                             <div class="col-lg-12"  style="margin-top: 1%">
                                 <div class="file-area">
                                     <input type="file" id="file" name="file" required="required" />
                                     <div class="file-dummy">
                                         <span class="success">Archivo seleccionado correctamente.</span>
                                         <span class="default">Seleccione un archivo.</span>
                                     </div>
                                 </div>
                             </div>
                         </div>
                     </div>
                     <div class="modal-footer">
                         <div class="alert alert-success col-lg-8 text-center" style="display:none;" id="response-incidencias"></div>
                         <button id="saveFile" type="button" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                         <button id="closemodal" type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                     </div>
                 </form>

             </div>
         </div>
     </div>
    <!--MODAL MODIFICAR -->
     <div class="modal fade" id="modalModificar" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
         <div class="modal-dialog" role="document">
             <div class="modal-content">
                 <div class="modal-header  bg-primary">
                     <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                     <h2 class="modal-title text-center" id="myModalLabel"> Modificar</h2>
                 </div>                 
                 <form id="form-modificar" name="form-modificar" method="post">
                     <div class="modal-body">
                        <input type="hidden" name="idModificar" id="idModificar" value="">
                         <div class="row">
                             <div class="col-lg-12"  style="margin-top: 1%">
                                <label>FRECUENCIA</label>
                                <select class="form-control" id="frecuencia" name="frecuencia">
                                    <option value="Mensual">Mensual</option>
                                    <option value="Trimestral">Trimestral</option>
                                    <option value="Cuatrimestral">Cuatrimestral</option>
                                    <option value="Semestral">Semestral</option>
                                    <option value="Anual">Anual</option>
                                </select>
                             </div>
                             <div class="col-lg-12"  style="margin-top: 1%">
                                <label>MES INICIO</label>
                                <select class="form-control" id="mes" name="mes">
                                    <option value="1">ENERO</option>
                                    <option value="2">FEBRERO</option>
                                    <option value="3">MARZO</option>
                                    <option value="4">ABRIL</option>
                                    <option value="5">MAYO</option>
                                    <option value="6">JUNIO</option>
                                    <option value="7">JULIO</option>
                                    <option value="8">AGOSTO</option>
                                    <option value="9">SEPTIEMBRE</option>
                                    <option value="10">OCTUBRE</option>
                                    <option value="11">NOVIEMBRE</option>
                                    <option value="12">DICIEMBRE</option>
                                </select>
                             </div> 
                         </div>
                     </div>
                     <div class="modal-footer">
                         <div class="alert alert-success col-lg-8 text-center" style="display:none;" id="response-incidencias"></div>
                         <button id="saveModificar" type="button" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                         <button id="closemodal" type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                     </div>
                 </form>

             </div>
         </div>
     </div>
    <!--MODAL ELIMINAR -->
     <div class="modal fade" id="modalEliminar" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
         <div class="modal-dialog" role="document">
             <div class="modal-content">
                 <div class="modal-header  bg-primary">
                     <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                     <h2 class="modal-title text-center" id="myModalLabelEliminar"> Eliminar</h2>
                 </div>                 
                 <form id="form-eliminar" name="form-eliminar" method="post">
                     <div class="modal-body">
                        <input type="hidden" name="idEliminar" id="idEliminar" value="">
                        <input type="hidden" name="isActive" id="isActive" value="">
                         <div class="row">
                             <div class="col-lg-12"  style="margin-top: 1%">
                                <label>MOTIVO</label>
                                <textarea class="form-control" id="motivoEliminar" name="motivoEliminar"></textarea>
                            </div>
                         </div>
                     </div>
                     <div class="modal-footer">
                         <div class="alert alert-success col-lg-8 text-center" style="display:none;" id="response-incidencias"></div>
                         <button id="saveEliminar" type="button" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                         <button id="closemodal" type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                     </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>
{% endblock %}