{% extends '::baseHighstock4.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: 400px;
            height: 400px;
            overflow-y: scroll;
            overflow-x: scroll;
        }

        /* ===================== 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>
    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script src="{{ asset('js/jquery.numeric.js') }}"></script>
    <script src="{{ asset('js/jquery.form.js') }}"></script>    
    <script src="{{ asset('js/jquery.isloading.js') }}" type="text/javascript"></script>
    <script>
        //VALIDACIONES JQUERY
        $(document).ready(function (){
            $("#ver_actualizar_ot").hide();
            $("#ver_actualizar_planificacion").hide();
            var starYear = 2021;
            var d = new Date();
            var year = d.getFullYear();
            var month = new Array();
            for(var i=starYear; year >= i;i++ )
            {
                $('#anio').append($("<option/>", {
                    value: i,
                    text: i
                }));
            }    
            var fechaAct = new Date();    
            var mesAct=fechaAct.getMonth()+ 1;
            if (mesAct==12){
                $('#anio').append($("<option/>", {
                    value: year+1,
                    text: year+1
                }));
            }
            month[0] = "ENERO";
            month[1] = "FEBRERO";
            month[2] = "MARZO";
            month[3] = "ABRIL";
            month[4] = "MAYO";
            month[5] = "JUNIO";
            month[6] = "JULIO";
            month[7] = "AGOSTO";
            month[8] = "SEPTIEMBRE";
            month[9] = "OCTUBRE";
            month[10] = "NOVIEMBRE";
            month[11] = "DICIEMBRE";        
            //change anio
            $("#anio").change(function(){
                var yearSelected = parseInt($(this).val());
                $('#mes').empty();        
                var options = new Array();
                if ($(this).val()!=""){
                    if (year==yearSelected){
                        for(var i=0;i<month.length;i++){
                            if(i <=  d.getMonth()+1){
                                $('#mes').append($("<option/>", {
                                    value: i + 1,
                                    text: month[i]
                                }));

                            }
                        } 
                        $("#mes").val(d.getMonth()+1);
                    }else{
                        for(var i=0;i<=11;i++){                            
                            $('#mes').append($("<option/>", {
                                value: i + 1,
                                text: month[i]
                            }));
                        }
                        
                    }
                } 
            });  
            $('#myTabs a:first').tab('show');
            $('.activarButton').hide();
            //accion cuando le dan al boton de generar
            $("#generar").click(function (){
                var anio = $('#anio').val();
                var mes = $('#mes').val();
                if (anio==""){
                    swal("Error!", "Debe seleccionar el año", "error");
                    return false;
                }else if (mes==""){
                    swal("Error!", "Debe seleccionar el mes", "error");
                    return false;
                }else{ 
                    $.isLoading({
                         text: "Loading"
                    });
                    getChart();
                }
            });
            //UPLOAD    
            $("#upload").click(function (){
                $("#file").val('');
                $(".file-area").removeClass('file-dummy');                
                //poner los meses disponibles para agregar la planificacion
                var fecha = new Date();
                $('#mesPlanifica').empty();    
                var mesActual=fecha.getMonth()+ 1;
                var mesSiguiente=fecha.getMonth() + 2;
                if (mesSiguiente==13){
                    mesSiguiente = 1;
                }
                $('#mesPlanifica').append($("<option/>", {
                    value: (mesActual),
                    text: month[mesActual-1]
                })); 
                $('#mesPlanifica').append($("<option/>", {
                    value: (mesSiguiente),
                    text: month[mesSiguiente-1]
                }));
                $('#modalfileUpload').modal('show');
            });
            //subir planificacion
            $("#saveFile").click(function () {
                if ($("#filePlanificacion").val()==""){
                    swal("Error!", "El archivo es requerido", "error");
                    return false;
                }else if ($("#mesPlanifica").val()==""){
                    swal("Error!", "El mes es requerido", "error");
                    return false;
                }else{    
                    $.isLoading({
                        text: "Loading"
                    });         
                    $("#saveFile").attr("disabled", true);
                    var formData = new FormData(document.getElementById("form-uploadg")); 
                    var url = "{{ (path('reportColombia_uploadDataPreventivos', {'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!", "Sitios cargados correctamente!"+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_modificarPlanificacionSitio', {'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 () {  
                $.isLoading({
                    text: "Loading"
                });              
                $("#saveEliminar").attr("disabled", true);
                var formData = new FormData(document.getElementById("form-eliminar")); 
                var url = "{{ (path('reportColombia_eliminarPlanificacionSitio', {'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");
                       }
                    } 
                });                
            });
            //actualizar ot
            //UPLOAD    
            $("#ver_actualizar_ot").click(function (){
                $("#fileOt").val('');
                $(".file-area").removeClass('file-dummy'); 
                $('#modalfileUploadOt').modal('show');
            });
            //subir planificacion
            $("#saveFileOt").click(function () {
                if ($("#fileOt").val()==""){
                    swal("Error!", "El archivo es requerido", "error");
                    return false;
                }else{    
                    $.isLoading({
                        text: "Loading"
                    });         
                    $("#saveFileOt").attr("disabled", true);
                    var formData = new FormData(document.getElementById("form-uploadg-ot")); 
                    var url = "{{ (path('reportColombia_uploadActOt', {'idproyectos': '{{idproyectos}}','idmodule': '{{idmodule}}'})) }}";
                    $.ajax({ 
                        url: url,
                        type: 'post',
                        data: formData,
                        contentType: false,
                        processData: false,            
                        success: function(data){
                           $.isLoading("hide");
                           $("#saveFileOt").attr("disabled", false);    
                           if (data.result=='Ok'){            
                                $('#modalfileUploadOt').modal('hide');
                                swal("Información!", "Datos Actualizados correctamente!", "success");
                                getChart();
                           }else if (data.result=="Not Ok" || data.result=="Not file"){
                                swal("Error!", "Error Upload", "error");
                           }
                        } 
                    });
                }
            }); 
            //actualizar planificacion
            //UPLOAD planificacion   
            $("#ver_actualizar_planificacion").click(function (){
                $("#fileActPlanificacion").val('');
                $(".file-area").removeClass('file-dummy'); 
                $('#modalfileUploadPlanificacion').modal('show');
            });
            //subir planificacion
            $("#saveFilePlanificacion").click(function () {
                console.log("prueba");
                if ($("#fileActPlanificacion").val()==""){
                    swal("Error!", "El archivo es requerido", "error");
                    return false;
                }else{    
                    $.isLoading({
                        text: "Loading"
                    });         
                    $("#saveFilePlanificacion").attr("disabled", true);
                    var formData = new FormData(document.getElementById("form-uploadg-planificacion")); 
                    var url = "{{ (path('reportColombia_uploadActPlanificacion', {'idproyectos': '{{idproyectos}}','idmodule': '{{idmodule}}'})) }}";
                    $.ajax({ 
                        url: url,
                        type: 'post',
                        data: formData,
                        contentType: false,
                        processData: false,            
                        success: function(data){
                           $.isLoading("hide");
                           $("#saveFilePlanificacion").attr("disabled", false);    
                           if (data.result=='Ok'){            
                                $('#modalfileUploadPlanificacion').modal('hide');
                                swal("Información!", "Planificacion Actualizada correctamente!", "success");
                                getChart();
                           }else if (data.result=="Not Ok" || data.result=="Not file"){
                                swal("Error!", "Error Upload", "error");
                           }
                        } 
                    });
                }
            }); 
        });
        //FUNCIONES DE JAVASCRIP
        function getChart(){           
            var anio = $('#anio').val();
            var mes = $('#mes').val();            
            var parametros = {
                'anio': anio,
                'mes': mes,
            };
            $.getJSON('{{path('reportColombia_cargarPreventivos',{'idproyectos':idproyectos,'idmodule':idmodule})}}', parametros, function (data){
                var chart = data;                              
                // Tabla Planificacion Sugerida
                if (chart.table_MonitorEntregable.length > 0){
                     $("#datatable_MonitorEntregable").empty();
                     var col = createTableDT(Object.keys(chart.table_MonitorEntregable[0]),'table_MonitorEntregable', 'datatable_MonitorEntregable');
                     buildDatatablePrin('table_MonitorEntregable',col,chart.table_MonitorEntregable);
                }else{
                    $("#datatable_MonitorEntregable").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                } 
                // Tabla Planificacion
                if (chart.table_Planificacion.length > 0){
                     $("#ver_actualizar_ot").show();
                     var fecha = new Date();
                     var mesActual=fecha.getMonth()+ 1;
                     if (mesActual==$("#mes").val()){
                        $("#ver_actualizar_planificacion").show();
                     }else{
                        $("#ver_actualizar_planificacion").hide();
                     }
                     $("#datatable_Planificacion").empty();
                     var col = createTableDT(Object.keys(chart.table_Planificacion[0]),'table_Planificacion', 'datatable_Planificacion');
                     buildDatatablePrin('table_Planificacion',col,chart.table_Planificacion);
                }else{
                    $("#ver_actualizar_ot").hide();
                    $("#ver_actualizar_planificacion").hide();
                    $("#datatable_Planificacion").empty().append('<div class="alert-black alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }                         
                // Tabla Planificacion Sugerida
                if (chart.table_PlanificacionSugerida.length > 0){
                     $("#datatable_PlanificacionSugerida").empty();
                     var col = createTableDT(Object.keys(chart.table_PlanificacionSugerida[0]),'table_PlanificacionSugerida', 'datatable_PlanificacionSugerida');
                     buildDatatablePrin('table_PlanificacionSugerida',col,chart.table_PlanificacionSugerida);
                }else{
                    $("#datatable_PlanificacionSugerida").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);
                }
            }     
           /* if (render=='table_MonitorEntregable' || render=='table_PlanificacionSugerida'){
                table = $('#'+render).DataTable( {
                    responsive: true,
                    dom: '<"row" <"col-md-12 text-right"B>> <"row" <"col-md-6 "l> <"col-md-6"f>>rtip',
                    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();
                    //}
                } );
            }else{ */     
                table = $('#'+render).DataTable( {
                    responsive: true,
                    dom: '<"row" <"col-md-12 text-right"B>> <"row" <"col-md-6 "l> <"col-md-6"f>>rtip',
                    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;
                strHeader += '<th class="text-center">' + t + '</th>';
                columns.push({data: data[i], title: t, visible:visible});
            }
            strTable += strHeader + '</tr></thead><tbody id="tbody_' + tableRender + '"></tbody>' + strFooter + '</table>';
            $('#' + dtRender).empty();
            $('#' + dtRender).html(strTable);
            $('#' + tableRender + ' thead tr').clone(true).appendTo( '#' + tableRender + ' thead' );
            $('#' + tableRender + ' thead tr:eq(1) th').each( function (i) {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%; margin: 0px; padding: 0px;"/>' );
                $( 'input', this ).on( 'keyup change', function () {
                    if ( $.fn.DataTable.isDataTable( '#' + tableRender ) ) {
                        var table = $('#' + tableRender).DataTable();
                        if ( table.column(i).search() !== this.value ) {
                            table
                                    .column(i)
                                    .search( this.value )
                                    .draw();
                        }
                    }
                } );
            } );
            return columns;
        }   
        function modificar(id){
            $("#idModificar").val(id);
            $.isLoading({
                 text: "Loading"
            });
            var parametros = {
                'id': id,
            };
            $.getJSON('{{path('reportColombia_detallePlanificacion',{'idproyectos':idproyectos,'idmodule':idmodule})}}', parametros, function (data){
                if (data){
                    $("#ot").val(data.buscar_planificacion.ot);
                    $("#rf").val(data.buscar_planificacion.rf);
                    $("#tx").val(data.buscar_planificacion.tx);
                    $("#ex").val(data.buscar_planificacion.ex);
                    $("#baterias").val(data.buscar_planificacion.baterias);
                    $("#locativos").val(data.buscar_planificacion.locativos);
                    $("#cx").val(data.buscar_planificacion.cx);
                    $("#ba").val(data.buscar_planificacion.ba);
                    $("#hallazgos").val(data.buscar_planificacion.hallazgos);
                    $("#anexos").val(data.buscar_planificacion.anexos);
                    $("#inventario").val(data.buscar_planificacion.inventario);   
                    $("#cambio_insumos").val(data.buscar_planificacion.cambio_insumos);
                    $("#matenimientos_aa").val(data.buscar_planificacion.matenimientos_aa);
                    $("#agua_baterias").val(data.buscar_planificacion.agua_baterias);
                    $("#obsevacion_especifica").val(data.buscar_planificacion.obsevacion_especifica);
                    $("#mp_tierras").val(data.buscar_planificacion.mp_tierras);
                    $("#mp_ups").val(data.buscar_planificacion.mp_ups);
                    $("#mp_plantas").val(data.buscar_planificacion.mp_plantas);
                    $("#mp_baterias").val(data.buscar_planificacion.mp_baterias);
                    $("#mp_aav").val(data.buscar_planificacion.mp_aav);
                    $("#mp_aac").val(data.buscar_planificacion.mp_aac);
                    $("#mp_inventario").val(data.buscar_planificacion.mp_inventario);
                    $("#mp_tableros").val(data.buscar_planificacion.mp_tableros);
                    $("#mp_tanques").val(data.buscar_planificacion.mp_tanques);
                    $("#mp_transfer").val(data.buscar_planificacion.mp_transfer);
                    $("#mp_rectificadores").val(data.buscar_planificacion.mp_rectificadores);
                    $("#mp_solares").val(data.buscar_planificacion.mp_solares);
                    $("#mp_subestacion").val(data.buscar_planificacion.mp_subestacion);
                    $("#anexos_energia").val(data.buscar_planificacion.anexos_energia);
                    $("#mp_equipos_olts").val(data.buscar_planificacion.mp_equipos_olts);
                    $("#trabajo_alturas").val(data.buscar_planificacion.trabajo_alturas);
                    $('#modalModificar').modal('show');
                }
                $.isLoading("hide");
            }); 
            
        }
        function eliminar(id,idticket){
            $("#idEliminar").val(id);
            $("#idticketEliminar").val(idticket);
            $.isLoading({
                 text: "Loading"
            });
            var parametros = {
                'id': id,
            };
            var month = new Array();    
            month[0] = "ENERO";
            month[1] = "FEBRERO";
            month[2] = "MARZO";
            month[3] = "ABRIL";
            month[4] = "MAYO";
            month[5] = "JUNIO";
            month[6] = "JULIO";
            month[7] = "AGOSTO";
            month[8] = "SEPTIEMBRE";
            month[9] = "OCTUBRE";
            month[10] = "NOVIEMBRE";
            month[11] = "DICIEMBRE";    
            $.getJSON('{{path('reportColombia_proximaPlanificacion',{'idproyectos':idproyectos,'idmodule':idmodule})}}', parametros, function (data){
                if (data){
                    $('#mesProximoMantenimiento').find('option').remove();
                    if (data.proxima_planificacion.mesProximo!=data.proxima_planificacion.mesActual){
                        $('#mesProximoMantenimiento').append($("<option/>", {
                            value: (data.proxima_planificacion.mesActual),
                            text: month[data.proxima_planificacion.mesActual-1]
                        }));
                    }
                    if (data.proxima_planificacion.mesProximo!=null){
                        $('#mesProximoMantenimiento').append($("<option/>", {
                            value: (data.proxima_planificacion.mesProximo),
                            text: month[data.proxima_planificacion.mesProximo-1]
                        }));
                    }
                    $('#modalEliminar').modal('show');
                }
                $.isLoading("hide");
            }); 
        }
        function ExportExcelOt() {
          document.forms['formulario_filtros'].action="{{path('reportColombia_ExportExcelOt')}}";
          document.forms['formulario_filtros'].submit();
        }
        function ExportExcelPlanificacion() {
          document.forms['formulario_filtros'].action="{{path('reportColombia_ExportExcelPlanificacion')}}";
          document.forms['formulario_filtros'].submit();
        }
    </script>
    <div class="container-fluid">
        <form id="formulario_filtros" onsubmit="return false;">
            <div class="panel panel-primary">
                <div class="panel-heading">
                    <h3 class="panel-title"><a data-toggle="collapse" href="#collapse1">Filtros<span class="caret"></span></a></h3>
                </div>
                <div id="collapse1" class="panel-collapse collapse in">
                    <div id="panelFilter" class="panel-body">
                            <div class="row"> 
                                <div class="col-md-4 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <select class="form-control" id="anio" name="anio">
                                            <option value="">Seleccione Año</option>

                                        </select>
                                    </div>
                                </div> 
                                <div class="col-md-4 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <select class="form-control" id="mes" name="mes">
                                            <option value=""></option>

                                        </select>
                                    </div>
                                </div>    
                                <div  class="col-md-4 col-sm-8 col-xs-12">
                                    <div class="form-group">                                        
                                        <button class="btn btn-primary form-control" id="generar">Generar</button>
                                    </div>
                                </div> 
                            </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">Subir Planificación</button>
                                    </div>  
                                </div> 
                            </div>                                    
                        </div>                                                
                    </div>
                </div>            
        </form>

        <div class="row">
            <div class="col-md-12 text-center">
                <h1 class="text-center text-primary">
                    <i class="fa fa-file-text-o"></i> <strong>MONITOR PREVENTIVOS</strong>
                </h1>
            </div>
        </div> 
        <div class="row">
            <div id="panel_content" class="col-lg-12">
                <div class="panel with-nav-tabs panel-primary">
                    <div class="panel-heading">
                        <ul class="nav nav-tabs" id="myTabs">
                                <!--PLANIFICACION-->
                                <li role="presentation" id="tabsPlanificacion" class="click_tab"><a data-toggle="tab" href="#_tabsPlanificacion"><strong>Planificación</strong></a></li>  
                                
                                <!--PLANIFICACION SUGERIDA -->
                                <li role="presentation" id="tabsPlanificacionSugerida" class="click_tab"><a data-toggle="tab" href="#_tabsPlanificacionSugerida"><strong>Planificación Sugerida</strong></a></li>   

                                <!--MONITOR DE ENTREGABLES-->
                                <li role="presentation" id="tabsMonitorEntregable" class="click_tab"><a data-toggle="tab" href="#_tabsMonitorEntregable"><strong>Monitor Entregable</strong></a></li> 
                                 
                        </ul>
                    </div>
                    <div class="panel-body">
                        <div class="tab-content">     
                            <!--PLANIFICACION-->
                            <div id="_tabsPlanificacion" class="tab-pane fade">
                                <div class="row">
                                    <div class="col-md-8 col-sm-8 col-xs-12">
                                    </div>
                                    <div class="col-md-4 col-sm-8 col-xs-12" id="ver_actualizar_ot">
                                        <div class="form-group text-rigth">
                                            <button class="btn btn-primary form-control" id="upload">Actualizar Datos Generales</button>
                                        </div>  
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-8 col-sm-8 col-xs-12">
                                    </div>
                                    <div class="col-md-4 col-sm-8 col-xs-12" id="ver_actualizar_planificacion">
                                        <div class="form-group text-rigth">
                                            <button class="btn btn-primary form-control" id="upload_planificacion">Actualizar Planificación</button>
                                        </div>  
                                    </div>
                                </div> 
                                <div class="row">
                                    <div id="datatable_Planificacion" class="col-sm-12">
                                        <table id="table_Planificacion" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_Planificacion"></tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <!--PLANIFICACION SUGERIDA-->
                            <div id="_tabsPlanificacionSugerida" class="tab-pane fade">
                                <div class="row">
                                    <div id="datatable_PlanificacionSugerida" class="col-sm-12">
                                        <table id="table_PlanificacionSugerida" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_PlanificacionSugerida"></tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <!--MONITOR DE ENTREGABLES-->
                            <div id="_tabsMonitorEntregable" class="tab-pane fade">
                                <div class="row">
                                    <div id="datatable_MonitorEntregable" class="col-sm-12">
                                        <table id="table_MonitorEntregable" class="display nowrap" width="100%">
                                            <thead>
                                            <tr></tr>
                                            </thead>
                                            <tbody id="tbody_MonitorEntregable"></tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <!-- Modal -->
     <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h2 class="modal-title text-center" id="myModalLabel"><strong>{# {'monitorii.detail' | trans } #}<span class="modal_detalle_titulo"></span></strong></h2>
                    <div class="punto-grafica text-center"></div>
                </div>
                <div class="modal-body">
                    <div class="tabla-datos">

                    </div>                    
                    <div id="datatableModalDetalle" class="col-sm-12" {#style="overflow-x: scroll"#}>
                        <table id="tableModalDetalle" class="display nowrap" width="100%">
                            <tbody id="tbodyModalDetalle">
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-claro" data-dismiss="modal">
                        {{'monitorii.close' | trans}}
                        <span class="glyphicon glyphicon-remove"></span>
                    </button>
                </div>
            </div>
        </div>
     </div>
    <!--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"> Subir Planificación</h2>
                 </div>
                 <button class="btn btn-warning">
                   <a href="{{ asset('Plantillas/TemplatePreventivo.xlsx')}}" download="TemplatePreventivo.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>Mes</label>
                                <select class="form-control" id="mesPlanifica"  name="mesPlanifica">
                                    <option value=""></option>
                                </select>
                             </div>
                         </div>
                         <div class="row">
                             <div class="col-lg-12"  style="margin-top: 1%">
                                 <div class="file-area">
                                     <input type="file" id="filePlanificacion" 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 Planificación</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-6"  style="margin-top: 1%">
                                <label>OT</label>
                                <input class="form-control" type="text" name="ot" id="ot" maxlength="255">
                             </div>
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP EQUIPOS RF</label>
                                <select class="form-control" id="rf" name="rf">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>
                        </div>
                        <div class="row">
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP EQUIPOS TX</label>
                                <select class="form-control" id="tx" name="tx">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP EQUIPOS DE ENERGIA</label>
                                <select class="form-control" id="ex" name="ex">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>
                        </div>
                        <div class="row">
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP BATERIAS</label>
                                <select class="form-control" id="baterias" name="baterias">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP LOCATIVOS</label>
                                <select class="form-control" id="locativos" name="locativos">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>  
                        </div>
                        <div class="row">                           
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP EQUIPOS CX</label>
                                <select class="form-control" id="cx" name="cx">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>                                                          
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>BA (MP EQUIPOS DX-BA E IP)</label>
                                <select class="form-control" id="ba" name="ba">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div> 
                        </div>
                        <div class="row">
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>HALLAZGOS TEM</label>
                                <select class="form-control" id="hallazgos" name="hallazgos">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>ANEXOS</label>
                                <select class="form-control" id="anexos" name="anexos">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>
                        </div>
                        <div class="row">
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP TIERRAS</label>
                                <select class="form-control" id="mp_tierras" name="mp_tierras">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP UPS</label>
                                <select class="form-control" id="mp_ups" name="mp_ups">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>
                        </div>
                        <div class="row">
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP PLANTAS</label>
                                <select class="form-control" id="mp_plantas" name="mp_plantas">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div> 
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP AAV</label>
                                <select class="form-control" id="mp_aav" name="mp_aav">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                            </div>                                         
                        </div>
                        <div class="row">  
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP AAC</label>
                                <select class="form-control" id="mp_aac" name="mp_aac">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                            </div> 
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP INVENTARIO</label>
                                <select class="form-control" id="mp_inventario" name="mp_inventario">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                            </div> 
                        </div>
                        <div class="row">             
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP TABLEROS</label>
                                <select class="form-control" id="mp_tableros" name="mp_tableros">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                            </div> 
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP TANQUES</label>
                                <select class="form-control" id="mp_tanques" name="mp_tanques">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                            </div>                            
                        </div>
                        <div class="row">   
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP TRANSFER</label>
                                <select class="form-control" id="mp_transfer" name="mp_transfer">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                            </div>  
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP RECTIFICADORES</label>
                                <select class="form-control" id="mp_rectificadores" name="mp_rectificadores">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                            </div>                          
                        </div>
                        <div class="row">                   
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP SOLARES</label>
                                <select class="form-control" id="mp_solares" name="mp_solares">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                            </div>   
                            <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP SUBESTACION</label>
                                <select class="form-control" id="mp_subestacion" name="mp_subestacion">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                            </div> 
                        </div>
                        <div class="row">    
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>CAMBIO DE INSUMOS</label>
                                <select class="form-control" id="cambio_insumos" name="cambio_insumos">
                                    <option value=""></option>
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>    
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MANTENIMIENTO AA</label>
                                <select class="form-control" id="matenimientos_aa" name="matenimientos_aa">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>                                                
                        </div>
                        <div class="row">
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>AGUA PARA BATERÍAS</label>
                                <select class="form-control" id="agua_baterias" name="agua_baterias">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>  
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>ANEXOS ENERGIA</label>
                                <select class="form-control" id="anexos_energia" name="anexos_energia">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>                      
                        </div>
                        <div class="row">
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>MP EQUIPOS OLTs</label>
                                <select class="form-control" id="mp_equipos_olts" name="mp_equipos_olts">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>  
                             <div class="col-lg-6"  style="margin-top: 1%">
                                <label>TRABAJO EN ALTURAS</label>
                                <select class="form-control" id="trabajo_alturas" name="trabajo_alturas">
                                    <option value="SI">SI</option>
                                    <option value="NO">NO</option>
                                </select>
                             </div>                      
                        </div>
                        
                        <div class="row"> 
                             <div class="col-lg-12"  style="margin-top: 1%">
                                <label>OBSERVACION ESPECIFICA</label>
                                <textarea class="form-control" id="obsevacion_especifica" name="obsevacion_especifica">
                                </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="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="myModalLabel"> Eliminar Planificación</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="idticketEliminar" id="idticketEliminar" value="">
                         <div class="row">
                            <div class="col-lg-12"  style="margin-top: 1%">
                                <label>MOTIVO</label>
                                <textarea class="form-control" id="motivoElimnar" name="motivoElimnar"></textarea>
                            </div>
                            <div class="col-lg-12"  style="margin-top: 1%">
                                <label>MES PROXIMO MANTENIMIENTO</label>
                                <select class="form-control" id="mesProximoMantenimiento" name="mesProximoMantenimiento">
                                </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="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>
    <!--MODAL UPLOAD -->
     <div class="modal fade" id="modalfileUploadOt" 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"> Actualizar OT</h2>
                 </div>
                 <button class="btn btn-warning">
                   <a href="javascript:ExportExcelOt()" style="float: left;" title="Template">
                       <img src="{{ asset('images/xls.png') }}" width="24px">Descargar template
                   </a>
                </button>
                 <form id="form-uploadg-ot" name="form-uploadg-ot" method="post"  enctype="multipart/form-data">
                     <div class="modal-body">                        
                         <div class="row">
                             <div class="col-lg-12"  style="margin-top: 1%">
                                 <div class="file-area">
                                     <input type="file" id="fileOt" 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="saveFileOt" 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 PLANIFICACION -->
     <div class="modal fade" id="modalfileUploadPlanificacion" 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"> Actualizar Planificacion</h2>
                 </div>
                 <button class="btn btn-warning">
                   <a href="javascript:ExportExcelPlanificacion()" style="float: left;" title="Template">
                       <img src="{{ asset('images/xls.png') }}" width="24px">Descargar template
                   </a>
                </button>
                 <form id="form-uploadg-planificacion" name="form-uploadg-planificacion" method="post"  enctype="multipart/form-data">
                     <div class="modal-body">                        
                         <div class="row">
                             <div class="col-lg-12"  style="margin-top: 1%">
                                 <div class="file-area">
                                     <input type="file" id="fileActPlanificacion" 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="saveFilePlanificacion" 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>
    <script src="{{ asset('js/grouped-categories.js') }}"></script>
{% endblock %}