{% extends '::base.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>

       .double-scroll {
            width: 100%;
            margin-bottom: 40px;
        }

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

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

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

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

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

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

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

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

        .wrapper {
            padding-bottom: 50px;
        }

        .header {
            background: #000000;
        }

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

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

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

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

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

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

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

        pre, .well {
            background: #FFFFFF;
        }

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

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

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

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

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

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

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

        #menuTop {
            margin-top: 30px;
        }

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

        h1 {
            font-size: 18px;
        }

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

        table.tablesorter thead tr th {

            height: 40px;
        }

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

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

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

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

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

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

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

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

        .verticalResizer{
            cursor: ns-resize;
        }

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

        .badge {
            font-size: 85%;
        }

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

        .text-primary {
            color: #428bca;
        }

        .tooltip {
          position: relative;
          display: inline-block;
          border-bottom: 1px dotted black;
        }
        .tooltip:hover {
           cursor: pointer;
        }
        .close {
          color: red;
        }
        .close:hover {
          cursor: pointer;
        }
        .tooltip .tooltiptext {
          display: none;
          width: 120px;
          background-color: black;
          color: #fff;
          text-align: center;
          border-radius: 6px;
          padding: 5px 0;

          /* Position the tooltip */
          position: absolute;
          z-index: 1;
        }

        .block {
          display: block !important;
        }
    </style>
    <script src="{{ asset('js/jquery.form.js') }}"></script>
    <script src="{{ asset('js/jquery.isloading.js') }}" type="text/javascript"></script>
    <script src="{{ asset('js/jquery.doubleScroll.js') }}" type="text/javascript"></script>
    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script type="text/javascript" src="{{ asset('js/multiselect.min.js') }}"></script>
    <script type="text/javascript" src="{{ asset('js/jquery.confirm.js') }}"></script> 
    <script type="text/javascript" src="{{ asset('js/jquery.inputmask.js') }}"></script> 
    <script type="text/javascript" src="{{ asset('js/jquery.inputmask.numeric.extensions.min.js') }}"></script>
    <script type="text/javascript" src="{{ asset('js/jquery.confirm.js') }}"></script> 
    <script type="text/javascript" src="{{ asset('js/jquery.table2excel.js') }}"></script>   
    <script>
        Highcharts.wrap(Highcharts.Axis.prototype, 'getPlotLinePath', function(proceed) {
            var path = proceed.apply(this, Array.prototype.slice.call(arguments, 1));
            if (path) {
                path.flat = false;
            }
            return path;
        });
        //VALIDACIONES JQUERY
        $(document).ready(function (){  
            $('body').on('click', function (e) {
                //did not click a popover toggle or popover
                if ($(e.target).data('toggle') !== 'popover'
                    && $(e.target).parents('.popover.in').length === 0) { 
                    $('[data-toggle="popover"]').popover('hide');
                }
            });
            $('[data-toggle="popover"]').live( "click", function() { 
                $(this).popover({
                    html: true,
                    trigger: 'manual',
                    placement: 'left',
                    content: function () {
                        var $buttons = $('#popover').html();
                        return $buttons;
                    }
                }).popover('toggle');  
            });
            $('[data-toggle="popover"]').popover();
            $('#myTabs a:first').tab('show');
            $('.activarButton').hide();
            
            //inicio validacion de la fecha
            $.fn.dataTable.moment( 'YYYY-MMM' );
            $('#Filtros_fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#Filtros_fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });            
            $('#Filtros_fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });
            //
            $('#fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });            
            $('#fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });
            //
            var f = new Date();
            var mes = (f.getMonth() + 1);
            if (mes < 10)
                mes = '0' + mes;
            var fechaI = f.getFullYear() + '-' + mes + "-01";
            var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();
            $('#fechaIni').val(fechaI);
            $('#fechaFin').val(fechaF);
            //accion cuando le dan al boton de generar
            $("#generar").click(function (){
                 if ($("#rango_fecha").hasClass("btn-primary")){
                    $('#Filtros_fechaIni').val($('#fechaIni').val());
                    $('#Filtros_fechaFin').val($('#fechaFin').val());  
                }
                if ($('#Filtros_fechaIni').val()=="" ||  $('#Filtros_fechaFin').val()==""){
                    swal("Error!", "Date Required", "error");
                }else{
                    $.isLoading({
                        text: "Loading"
                    });
                    getChart();
                }
            });            
            $(".div_fecha").hide();
            $(".ajuste_fecha").click(function(){
                $('.ajuste_fecha').removeClass('btn-primary');
                $('.ajuste_fecha').addClass('btn-default');
                var id = $(this).attr('id');
                $("#"+id).addClass('btn-primary');
                $(".div_fecha").hide();
                if (id=="rango_fecha"){
                    $(".div_fecha").show();
                }
                rangosFecha(id);
            });
            //rangosFecha('hoy');
            $("#exportToExcel").click(function(e){ 
                $("#table_detalle").find("tr td a.comment").replaceWith(function(){ 
                    return $.text([this]);
                });               
                $("#table_detalle").table2excel({
                    exclude: ".noExl",
                    name: "Sheet1",
                    filename: "detail.xls",
                    fileext: ".xls",
                    exclude_img: true,
                    exclude_links: true,
                    exclude_inputs: true,
                    preserveColors: true
                });
            });
        });
       
        function rangosFecha(opcion){
            //para el dia actual
            if (opcion=='hoy'){
                var f = new Date();
                var mes = (f.getMonth() + 1);
                if (mes < 10) mes = '0' + mes;
                var dia = f.getDate();
                if (dia < 10) dia = '0' + dia;
                var fechaI = f.getFullYear() + '-' + mes + "-" + dia;
                var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            //para ultimos_7_dias
            if (opcion=='ultimos_7_dias'){
                var f = new Date();
                //console.log(f);
                var mes = (f.getMonth() + 1);
                if (mes < 10) mes = '0' + mes;
                //OBTENER EL DIA DE LA SEMANA DE LA FECHA ACTUAL
                var weekday = f.getDay();
                //console.log(weekday);
                //SI ES LUNES
                if (weekday==1){
                    var nueva_fecha = new Date();
                    var nuevo_mes = (nueva_fecha.getMonth() + 1);
                    if (nuevo_mes < 10) nuevo_mes = '0' + nuevo_mes;
                    var dia_n = nueva_fecha.getDate();
                    if (dia_n < 10) dia_n = '0' + dia_n;
                }else{
                    if (weekday==2){ //SI ES MARTES
                        cantidad_dias_restar = 1;
                    }
                    if (weekday==3){ //SI ES MIERCOLES
                        cantidad_dias_restar = 2;
                    }
                    if (weekday==4){ //SI ES JUEVES
                        cantidad_dias_restar = 3;
                    }
                    if (weekday==5){ //SI ES VIERNES
                        cantidad_dias_restar = 4;
                    }
                    if (weekday==6){ //SI ES SABADO
                        cantidad_dias_restar = 5;
                    }
                    if (weekday==0){ //SI ES DOMINGO
                        cantidad_dias_restar = 6;
                    }
                    var dias_restar = 1000 * 60 * 60 * 24 * cantidad_dias_restar;
                    var resta = f.getTime() - dias_restar;
                    var nueva_fecha = new Date(resta);
                    var nuevo_mes = (nueva_fecha.getMonth() + 1);
                    if (nuevo_mes < 10) nuevo_mes = '0' + nuevo_mes;
                    var dia_n = nueva_fecha.getDate();
                    if (dia_n < 10) dia_n = '0' + dia_n;
                }                
                var fechaI = nueva_fecha.getFullYear() + '-' + nuevo_mes + "-" + dia_n;
                var dia = f.getDate();
                if (dia < 10) dia = '0' + dia;
                var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            //para el mes actual
            if (opcion=='mes_actual'){
                var f = new Date();
                var mes = (f.getMonth() + 1);
                if (mes < 10) mes = '0' + mes;
                var fechaI = f.getFullYear() + '-' + mes + "-01";
                var dia = new Date(f.getFullYear(), f.getMonth() + 1, 0);
                //var dia = f.getDate();
                if (dia < 10) dia = '0' + dia;
                var fechaF = f.getFullYear() + '-' + mes + "-" + dia.getDate();
            }
            //para mes_anterior
            if (opcion=='mes_anterior'){
                //desde
               const f1=moment().subtract(1, 'months').startOf('month').format('DD-MM-YYYY');
               //console.log(f1);
               var fInicial = f1.split('-');
               //hasta
               const f2=moment().subtract(1, 'months').endOf('month').format('DD-MM-YYYY');
               var fFinal = f2.split('-');
               //actualizar
               var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
               var fechaF = fFinal[2] + '-' + fFinal[1] + "-" + fFinal[0];

            }
            //para las 6 meses
            if (opcion=='ultimo_6_meses'){
                //desde
               const f1=moment().subtract(5, 'months').startOf('month').format('DD-MM-YYYY');
               //console.log(f1);
               var fInicial = f1.split('-');
               //hasta
               var f = new Date();
               var mes = (f.getMonth() + 1);
               if (mes < 10) mes = '0' + mes;               
               //actualizar
               var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
               var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();
            }
            //para las 12 meses
            if (opcion=='ultimo_12_meses'){
                //desde
               const f1=moment().subtract(12, 'months').startOf('month').format('DD-MM-YYYY');
               var fInicial = f1.split('-');
               //hasta
               var f = new Date();
               var mes = (f.getMonth() + 1);
               if (mes < 10) mes = '0' + mes;               
               //actualizar
               var dia = f.getDate();
               if (dia < 10) dia = '0' + dia; 
               var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
               var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            $('#Filtros_fechaIni').val(fechaI);
            $('#Filtros_fechaFin').val(fechaF);
            if (opcion!='rango_fecha'){
                $("#generar").trigger('click');
            }
        }
        //FUNCIONES DE JAVASCRIP
        var projectList = new Array(4); //Lista de proyectos para cada gráfico             
        //llamado para generar las graficas y las tablas  
        function getChart(){           
            var inicio = $('#Filtros_fechaIni').val();
            var fin = $('#Filtros_fechaFin').val();
            var proyecto = $('#proyecto').val();            
            var valor = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();   
            var detail = $("#detail").val();         
            var parametros = {
                'FechaInicio': inicio,
                'FechaFin': fin,
                'proyecto': proyecto
            };
            //console.log(parametros);
            $.getJSON('{{path('monitorAcceso_listarData',{'idproyectos':idproyectos,'idmodule':idmodule})}}', parametros, function (data){
                var chart = data; 
                $(".table1").remove();
                $(".pager").hide();
                $("#tableContainer").empty();
                //
                var monitor = chart.table_Monitor;
                if(monitor.length == 0){
                    $("#reporte").empty();
                    $("#reporte").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                    $.isLoading("hide");
                    return false;
                }else{                                      
                    var objectType = {"9":1,"10":2,"11":3,"12":4,"13":5,"14":6};
                    $("#reporte").empty().append(createTable(monitor,undefined,undefined,objectType,'table1'));
                    $('.double-scroll').doubleScroll();
                    var pagerOptions2 = {
                        container: $(".pager"),
                        output: 'Rows  : {endRow}',
                        fixedHeight: false,
                        removeRows: true,
                        cssGoto: '.gotoPage'
                    };                   
                    $(".table1").tablesorter({
                        theme: 'blue',
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            filter_cssFilter: '',
                            filter_childRows: false,
                            filter_hideFilters: false,
                            filter_ignoreCase: true,
                            filter_reset: '.reset',
                            filter_saveFilters: true
                        }
                    }).tablesorterPager(pagerOptions2);
                    $('.pager').show();
                } 
                $.isLoading("hide");
            });
        }
        function createTable(monitor,total,nombreColTotal,type,idTable){
            var header = Object.keys(monitor[0]);
            var headerType = Object.keys(type);
            var table = '<table  class="table table-bordered table-hover table-striped table-responsive '+idTable+'"> <thead>' +
                        '<tr class="btn-info">';

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

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

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

                for (var j = 0; j < header.length; j++) {
                    var clases = ''; 
                    var idsitio = monitor[i]['SITE ID'];
                    var proyecto = monitor[i]['PROJECT'];
                    
                    if (header[j] == 'MAXIMUM TIME') {                   
                        table += "<td "+clases+" id='"+idsitio+"' data='"+proyecto+"'><a href=# onclick=detail('"+idsitio+"')>" + monitor[i][header[j]]  + "</a></td>";   
                    }else{
                         table += "<td "+clases+">" + monitor[i][header[j]]  + "</td>";   
                    }
                }

                table += '</tr>';
                if (typeof total !== 'undefined') {
                    if (i == monitor.length - 1) {
                        var headerTotal = Object.keys(total);
                        table += '<tr><td>' + nombreColTotal + '</td>';
                        for (var x = 0; x < headerTotal.length; x++) {
                            table += '<td>';
                            table += total[headerTotal[x]];
                            table += '</td>';
                        }
                        table += '</tr>';
                    }
                }
            }
            table += '</table>';
            return table;
        } 

        function hide() {
          document.getElementById("tooltip").classList.remove("block");
        }
        function show() {
          document.getElementById("tooltip").classList.add("block");
        }
        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>';
                if (title=="Total Not Accepted" || title=="Not Ok" || title=="ISSUES ERROR" || title=="SYSTEM FAULT FOUND" || title=="Total Corrected"){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi="";
                                var popup_title = "";                                
                                var strIssuesText = "";
                                var url= "";
                                if (row.hasOwnProperty('_ISSUES')){
                                    kpi='ftr';
                                    popup_title = 'Issues';
                                    var issues = row['_ISSUES'];  
                                    var arrIssues = issues == null ? null : issues.split("<br>");     
                                    if (arrIssues!=null){   
                                        var strIssuesHtml = "<ol>";
                                        if (Array.isArray(arrIssues)){ 
                                            for (var i=0; i<arrIssues.length; i++){
                                                strIssuesHtml += "<li>" + arrIssues[i] + ".</li>";
                                                strIssuesText += i + ". " +  arrIssues[i] + ".\r\n";
                                            }
                                        }else{
                                            strIssuesHtml = issues;
                                        }
                                        strIssuesHtml += "</ol>";
                                    }
                                }                                                                 
                                if (type==='display' && strIssuesText!=''){
                                    return '<a href="javascript://"  data-toggle="popover" data-title="<b>Issues</b>" ' +
                                            'data-container="body" data-placement="left" data-html="true" ' +
                                            'data-trigger="focus" ' +
                                            'data-content="' + strIssuesHtml  + '"' +
                                            '>' + dato + '</a>';
                                }else{
                                    return dato;
                                }
                            }
                            return dato;
                        }
                    });
                }else{
                    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;
            var kpi = '';
            for (var i=0; i<=(columnas.length - 1); i++){
                a.push(i);
            }
            Defs.push({ targets: a, className: 'dt-body-center' });
            for (var i=0; i<=(columnas.length - 1); i++){
                if (columnas[i].visible){
                    b.push(i);
                }
            }           
            table = $('#'+render).DataTable( {
                dom: '<"row" <"col-md-12 text-right"B>> <"row" <"col-md-6 "l> <"col-md-6"f>>rtip',
                scrollY: '60vh',
                scrollX: true,
                scrollCollapse: true,
                orderCellsTop: true,
                data:data,
                "deferRender": false,
                "processing": true,
                "language": {
                    "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                },
                "order": [[ 0, "asc" ]],
                "ordering": true,
                columns: columnas,
                columnDefs: Defs,
                lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                buttons: [
                    {
                        extend:'excel',
                        text: 'Table Excel ' + kpi,
                        exportOptions: {
                            columns: b,
                            orthogonal: 'export'
                        },
                        title: 'Excel_Detail'
                    }
                ],
                drawCallback: function() {
                    $('[data-toggle="popover"]').popover();
                } 
            } );
        }   
        //prueba
        //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();
            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=='TOTAL' || title=='SITE ID'){
                    var tit = title.toUpperCase();
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){ 
                                var table_title = 'SUPERVISOR MANAGER';                               
                                var subtitle = row['SITE ID']+' - '+row['SITE NAME'];
                                var url= "{{ path('check_list_detalle_monitor_supervisor') }}";     
                                var ord = null;
                                var parametros = {
                                    'fecha': row['FECHA INICIO'],
                                    'cliente': row['CLIENTE'],
                                    'proyecto': row['PROYECTO'],
                                    'site_id': row['SITE ID'],
                                    'site_name': row['SITE NAME'],
                                    'supervisor': row['SUPERVISOR'],
                                };
                                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;
        } 
        //DETALLE DEL SITIO
        function detail(idsitio){
            $(".muestra_detalle").empty();
            var proyecto = $("#"+idsitio).attr("data");  
            console.log(idsitio,proyecto);          
            var fin = $('#Filtros_fechaFin').val();                     
            var inicio = $('#Filtros_fechaIni').val();         
            var parametros = {
                'idsitio' : idsitio,
                'FechaInicio': inicio,
                'FechaFin': fin,
                'proyecto': proyecto
            }; 
            $("#datatable_detalle").empty();
            //$.isLoading({text: "Loading..."});
            $.getJSON("{{path('monitorAcceso_detalle',{'idproyectos':idproyectos,'idmodule':idmodule})}}", parametros, function (data){
                //console.log(data);
                if (data.length>0){            
                $("#datatable_detalle").empty();
                var col = createTableDTDetail(Object.keys(data[0]),'table_detalle', 'datatable_detalle');
                buildDatatablePrin('table_detalle',col,data);
                $('[data-toggle="popover"]').popover('destroy');
                $('[data-toggle="popover"]').popover({
                    template: '<div class="popover" role="tooltip" style="width: 800px;"><div class="arrow"></div><h3 class="popover-title"></h3><div class="popover-content"><div class="data-content"></div></div></div>'
                }).on("show.bs.popover", function () { $(this).data("bs.popover").tip().css("max-width", "600px"); });
                
                //$.isLoading('hide'); 
            }else{
                //$.isLoading('hide'); 
            }
            });
            $("#detalle").modal();   
        }
    </script>
    <div class="container-fluid">
        <div class="row">
                <div class="col-lg-12 col-md-12">
            <h1 class="text-center text-primary" style="font-size: x-large">
                <b id="titleReport"><span class="glyphicon glyphicon-th" aria-hidden="true"></span>MONITOR DE ACCESOS</b>
            </h1>
        </div>
        </div>
        <form id="formulario_filtros" onsubmit="return false;">
            <div class="panel panel-primary">
                <div class="panel-heading">
                    <h3 class="panel-title"><a data-toggle="collapse" href="#collapse1">Filters <span class="caret"></span></a></h3>
                </div>
                <div id="collapse1" class="panel-collapse collapse in">
                    <div id="panelFilter" class="panel-body">
                            <input type="hidden" name="mes_seleccionado" id="mes_seleccionado" value="">
                            <input type="hidden" name="pais_seleccionado" id="pais_seleccionado" value="">
                            <input type="hidden" name="proyecto_seleccionado" id="proyecto_seleccionado" value="">
                            <input type="hidden" class="form-control" id="Filtros_fechaIni" name="Filtros_fechaIni" value="">
                            <input type="hidden" class="form-control" id="Filtros_fechaFin" name="Filtros_fechaFin" value="">
                            <div class="row"> 
                                <div class="col-md-7 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>Date Filter: <span class="detalleRango"></span> </label><br>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="hoy">Today</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimos_7_dias">Week</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="mes_actual">This Month</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="mes_anterior">Last Month</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_6_meses">Last 6 Months</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_12_meses">Last 12 Months</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="rango_fecha">Custom Range</button>
                                    </div>
                                </div> 
                                <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                                    <div class="form-group">                                            
                                       <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>
                                        <input type="text" class="form-control" id="fechaIni" name="fechaIni" value="">
                                    </div> 
                                </div>   
                                <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                                    <div class="form-group">                                            
                                        <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>
                                        <input type="text" class="form-control" id="fechaFin" name="fechaFin" value="">
                                    </div> 
                                </div> 
                            </div>      
                            <div class="row">                                 
                                <div id="div_proyecto" class="col-md-4 col-sm-4 col-xs-12">
                                    <div id="div_proyecto" class="form-group input-group">
                                        <label>{{'monitores.proyecto' | trans}}: </label><br>
                                        <select class="form-control get-list" id="proyecto" name="proyecto">
                                            <option value="TODOS">ALL</option>
                                            {%for proyecto in proyectos %}
                                                <option value="{{proyecto.proyecto}}">{{proyecto.proyecto}}</option>
                                            {%endfor%}
                                        </select>
                                    </div>
                                </div>                              
                                
                                <div class="col-md-4 col-sm-4 col-xs-12" id="parametros">
                                    <div class="form-group">
                                        <label for="generar">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</label>
                                        <button class="btn btn-primary form-control" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
                                    </div>
                                </div>
                            </div>           
                    </div>
                </div>
            </div>
            
        </form>
        <div class="pager pager_time" style="margin: 0px 0px 10px 12px;">
            <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
            <span class="pagedisplay"></span>
        </div>
        <div class="row">
            <div id="reporte" class="col-lg-12"></div>
        </div>
        <div class="row">
            <div id="pager" class="pager tablesorter-pager" style="display: none;text-align: center">
                <form>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/first.png')}}" class="first"/>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/prev.png')}}" class="prev"/>
                    <span class="pagedisplay"></span>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/next.png')}}" class="next"/>
                    <img src="{{asset('tablesorter-master/addons/pager/icons/last.png')}}" class="last"/>
                    <select class="pagesize" title="Select page size">
                        <option selected="selected" value="1000">1000</option>
                        <option  value="500">500</option>
                        <option  value="100">100</option>
                    </select>
                </form>
            </div>
        </div>
    </div>
    
    <!-- Modal Detalle -->
    <div class="modal fade" id="detalle" role="dialog">
        <div class="modal-dialog modal-lg">
          <!-- Modal content-->
            <div class="modal-content" style="width: 1200px;margin: 0px 0px 0px -140px;">
                <div class="modal-header bg-primary">
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                    <h4 class="modal-title">Detail Site</h4>
                </div>              
                <div class="modal-body">
                    <div class="row" style="margin-top:8px">
                        <div class="col-md-12">
                            <div id="datatable_detalle" class="col-sm-12">
                                <table id="table_detalle" class="display nowrap" width="100%">
                                    <thead>
                                    <tr></tr>
                                    </thead>
                                    <tbody id="tbody_detalle"></tbody>
                                </table>
                            </div>
                        </div>                        
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                </div>    
            </div> 
        </div>
    </div>

    <!-- Modal -->
    <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document" style="width: 1000px;">
            <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>

{% 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>      
    <script type="text/javascript" src="{{ asset('bootstrap-multiselect/js/bootstrap-multiselect.js') }}"></script>
{% endblock %}