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

{% endblock %}

{% block dashboard %}
    <style>
        table th{

        {#text-transform: uppercase;#}
            font-weight: bold;
            font-size: 12px;
        }

        table td{
        {#text-transform: uppercase;#}
            font-weight: normal;
            font-size: 12px;
        }
         /* pager wrapper, div */
        .pager {
            padding: 5px;
        }
        /* 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;
            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;
        }

        table.tablesorter thead tr th, table.tablesorter tfoot tr th {
            background-color: #428bca;
            border: 1px solid #FFF;
            font-size: 8pt;
            padding: 4px;
            color: white;
        }


        .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);}
        }
        .disabledTab{
            pointer-events: none;
        }
        .table-responsive {
            height: 400px !important;
            overflow: scroll;
            }
             .btn-claro {
            color: #fff;
            background-color: #428bca;
            border-color: #357ebd ;

            }
            .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
            }
            .table th{
                font-size: 10pt;
            }
            .table td{
                font-size: 9pt;
            }

            .double-scroll {
                width: 100%;
            }
            #parametros .panel-body .row{

                padding-left: 5px;
            }

        .header_dt{
            color: #fff;
            background-color: #428bca;
            border-color: #1598d9  !important;
        }

        .tablesorter-header-inner,table.tablesorter thead tr th,.tablesorter-filter {
            color: #fff;
            background-color: #428bca;
            border-color: #1598d9;
        }
        table.tablesorter thead tr th{
            height: 40px;
        }
        .tablesorter-blue .headerSortUp, .tablesorter-blue .tablesorter-headerSortUp, .tablesorter-blue .tablesorter-headerAsc {
            background-color: #428bca;}
        .tablesorter-blue .headerSortDown, .tablesorter-blue .tablesorter-headerSortDown, .tablesorter-blue .tablesorter-headerDesc {
            background-color: #428bca;}
        .tablesorter-blue .tablesorter-filter-row td {
            background: #428bca;border-color: #1598d9;}
        input[type="search"]{
            display: block;
            width: 100%;
            height: 34px;
            padding: 6px 12px;
            font-size: 12px;
            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;
        }
        .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.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;
        }
        /* Dropdown Button */
        .dropbtn {
          padding: 10px;
          font-size: 16px;
          border: none;
        }

        /* The container <div> - needed to position the dropdown content */
        .dropdown {
          position: relative;
          display: inline-block;
          /*width: 65px! important;*/
        }

        /* Dropdown Content (Hidden by Default) */
        .dropdown-content {
          /*display: none;
          position: absolute;
          min-width: 160px;
          z-index: 1;*/
        }

        /* Links inside the dropdown */
        .dropdown-content a {
          /*color: black;*/
          padding: 12px 16px;
          text-decoration: none;
          display: block;
        }

        /* Change color of dropdown links on hover 
        .dropdown-content a:hover {background-color: #ddd;}*/

        /* Show the dropdown menu on hover 
        .dropdown:hover .dropdown-content {display: block;}*/

        /* Change the background color of the dropdown button when the dropdown content is shown 
        .dropdown:hover .dropbtn {background-color: #1598d9;}*/

        .double-scroll {
            width: 100%;
            overflow-x: scroll !important;
        }

    </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 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 src="{{ asset('js/jquery.isloading.js') }}" type="text/javascript"></script>
    <script src="{{asset('js/jquery.doubleScroll.js')}}" type="text/javascript"></script>
    <script>
        $(document).ready(function() {  
            $(".get-list").change(function(e) {
                var data_select_refresh = $(this).attr('data');
                var data_act = $(this).attr('data-act');
                var campo_filtrar = $(this).attr('data-campo-filtro');  
                var campo_mostrar = $(this).attr('data-campo-mostrar'); 
                var data = {
                    valor_filtro : $(this).val(),
                    campo_filtrar : campo_filtrar,
                    campo_mostrar : campo_mostrar,
                };
                //console.log(data);
                $("."+data_act+" option").remove();
                $("."+data_act).append('<option value="TODOS">-- All --</option>');
                if ($(this).val()!='TODOS'){                    
                    $.getJSON('{{path('reportemshonduras_llenarSelectPo',{'idproyectos':idproyectos})}}', data, function (data){
                        var registros = data.registros;
                        for (var i = 0; i < registros.length; i++){
                            $("#"+data_select_refresh).append('<option value="' + registros[i]['valor'] + '">' + registros[i]['nombre'] + '</option>');
                        }
                    });
                }
            });

            $('.double-scroll').doubleScroll();
            $('#reporte_sitios_pendientes').doubleScroll({resetOnWindowResize: true});
            $('#myTabs a:first').tab('show');
            $(".activar_pendiente_po").show();
             $("#generar").click(function(){  
                $.isLoading({
                    text: "Loading"
                });              
               getReporte();
            });
            $('.monto').inputmask("decimal", { min: -1, allowMinus: true });
            $('.solo_numeros').on('input', function (e) {
                if (!/^[0-9]*$/i.test(this.value)) {
                    this.value = this.value.replace(/[^0-9]+/ig,"");
                }
            }); 
            $(".click_tab").click(function(){
                resizeChart();
            });
            
            $(document).on("click", ".downloadTemplate", function () {
              var data = {};
              data['medicion'] = $("#evento").val();
              data['region'] = $("#region").val();
              data['pais'] = $("#pais").val();
              data['fechaIni'] = $("#Filtros_fechaIni").val();
              data['fechaFin'] = $("#Filtros_fechaFin").val();
              data['idproyectos'] =  "" + {{idproyectos}};

              var ruta = `{{path('reportemshonduras_DownloadCP')}}?pais=${ data['pais']}&medicion=${ data['medicion']}&proyecto=${ data['proyecto']}&region=${ data['region']}&idproyectos=${data['idproyectos']}&fechaIni=${data['fechaIni']}&fechaFin=${data['fechaFin']}`
              //window.open(ruta);
              $('#downloadTemplate').attr("href",ruta);

              //alert(ruta);
            });

            $("#sitios_pendientes").click(function(){ 
                if ($("#total_monitor_pendientes_po").val()>0){
                    $(".pager_sitios_pendientes").show();
                            var pagerOptions1 = {
                                container: $(".pager"),
                                output: '{startRow} to {endRow} ({totalRows})',
                                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,
                                    pager_size: '{totalRows}',
                                }
                  }).tablesorterPager(pagerOptions1);
                    $(".pager").show();
                }else{
                    $(".pager_sitios_pendientes").hide();
                }
            });
            

            $("#pending_approval").click(function(){ 
                resizeChart();         
                if ($("#total_monitor_pending_approval").val()>0){
                    $(".pager_pending_approval").show();
                            var pagerOptions1 = {
                                container: $(".pager"),
                                output: '{startRow} to {endRow} ({totalRows})',
                                fixedHeight: false,
                                removeRows: true,
                                cssGoto: '.gotoPage'
                            };
                            $(".table2").tablesorter({
                                theme: 'blue',
                                widgets: ["zebra", "filter"],
                                widgetOptions: {
                                    filter_cssFilter: '',
                                    filter_childRows: false,
                                    filter_hideFilters: false,
                                    filter_ignoreCase: true,
                                    filter_reset: '.reset',
                                    filter_saveFilters: true,
                                    pager_size: '{totalRows}',
                                }
                  }).tablesorterPager(pagerOptions1);
                    $(".pager").show();
                }else{
                    $(".pager_pending_approval").hide();
                }
            });

            $("#activar_fallas").click(function(){ 
                resizeChart();         
                if ($("#total_monitor_falla").val()>0){
                    $(".pager_reporte_fallas").show();
                            var pagerOptions1 = {
                                container: $(".pager"),
                                output: '{startRow} to {endRow} ({totalRows})',
                                fixedHeight: false,
                                removeRows: true,
                                cssGoto: '.gotoPage'
                            };
                            $(".table5").tablesorter({
                                theme: 'blue',
                                widgets: ["zebra", "filter"],
                                widgetOptions: {
                                    filter_cssFilter: '',
                                    filter_childRows: false,
                                    filter_hideFilters: false,
                                    filter_ignoreCase: true,
                                    filter_reset: '.reset',
                                    filter_saveFilters: true,
                                    pager_size: '{totalRows}',
                                }
                  }).tablesorterPager(pagerOptions1);
                    $(".pager").show();
                }else{
                    $(".pager_reporte_fallas").hide();
                }
            });
            //AUDITORIA
            $(".activar_dashboard").click(function(){               
                $(".pager ").hide();
                resizeChart();
            });

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

                }
            });

            $('#Filtros_fechaFin').datepicker({
                    dateFormat: 'yy-mm-dd',
            });   
            resizeChart();  
            $(".usd").live('click',function(){
                $('input[name="usd[]"]').addClass('monto');
                $('.monto').inputmask("decimal", { min: -1, allowMinus: true });
            });

            $(".po_amount").live('click',function(){
                $('input[name="po_amount[]"]').addClass('monto');
                $('.monto').inputmask("decimal", { min: -1, allowMinus: true });
            });
            
            $(".registra_solped").live('click',function(){
                $('input[name="solped[]"]').addClass('solo_numeros');
                $('.solo_numeros').on('input', function (e) {
                    if (!/^[0-9]*$/i.test(this.value)) {
                        this.value = this.value.replace(/[^0-9]+/ig,"");
                    }
                }); 
            }); 

            $(".registra_po").live('click',function(){
                $('input[name="po[]"]').addClass('solo_numeros');
                $('.solo_numeros').on('input', function (e) {
                    if (!/^[0-9]*$/i.test(this.value)) {
                        this.value = this.value.replace(/[^0-9]+/ig,"");
                    }
                }); 
            }); 

            //marcar todos 
            $(".marcaAll").live('click', function (){
                if($(this).is(':checked')){
                    $('input[name="marca[]"]').prop("checked", true);
                    $('.guardarMasivo').removeAttr('disabled');
                }else{
                    $('input[name="marca[]"]').prop("checked", false);
                    $('.guardarMasivo').attr('disabled',true);
                }
            });

            $(".marcaOne").live('click', function (){
                var total = 0;
                $('input[name="marca[]"]:checked').each(function() {                
                    total++;
                });
                if (total==0){
                    $('.guardarMasivo').attr('disabled',true);
                }else{
                    $('.guardarMasivo').removeAttr('disabled');
                }
            });            

            //verificar 
            $(".apply_payment").live('change', function (){
                var rowId = $(this).attr('data');
                var id_1 = $(this).attr('data-id');
                var nro_item = $(this).attr('data-nroitem');
                if ($(this).val()=='NO'){
                    $("#reason_po_"+rowId+"_"+id_1+"_"+nro_item).removeAttr('readonly');
                }
            });

            //verificar po amount            
            $(".po_amount").live('keyup', function (){
                var rowId = $(this).attr('data');
                var id_1 = $(this).attr('data-id');
                var nro_item = $(this).attr('data-nroitem');
                var usd = $("#usd_"+rowId+"_"+id_1+"_"+nro_item).val();
                if ($(this).val() < usd){
                    $("#reason_po_"+rowId+"_"+id_1+"_"+nro_item).removeAttr('readonly');
                }
            });

            //verificar usd           
            $(".usd").live('keyup', function (){
                var rowId = $(this).attr('data');
                var id_1 = $(this).attr('data-id');
                var nro_item = $(this).attr('data-nroitem');
                var po_amount = $("#po_amount_"+rowId+"_"+id_1+"_"+nro_item).val()
                if (po_amount < $(this).val()){
                    $("#reason_po_"+rowId+"_"+id_1+"_"+nro_item).removeAttr('readonly');
                }
            });
        });
        
            $(document).on("click", ".downloadTemplateCobroMGP", function () {
               var data = {};
                data['region'] = $("#region").val();
                data['pais'] = $("#pais").val();
                data['asp'] = $("#asp").val();
                data['fechaIni'] = $("#Filtros_fechaIni").val();
                data['fechaFin'] = $("#Filtros_fechaFin").val();
              
              var ruta = `{{path('reportemshonduras_DownloadCobroMgpGT')}}?pais=${ data['pais']}&region=${ data['region']}&asp=${data['asp']}&fechaIni=${data['fechaIni']}&fechaFin=${data['fechaFin']}`
              //window.open(ruta);
              $('#downloadTemplateCobroMGP').attr("href",ruta);

              //alert(ruta);
            });

        function getReporte(){
            
            var parametros = {};
            parametros['region'] = $("#region").val();
            parametros['pais'] = $("#pais").val();
            parametros['asp'] = $("#asp").val();
            parametros['fechaIni'] = $("#Filtros_fechaIni").val();
            parametros['fechaFin'] = $("#Filtros_fechaFin").val();
            parametros['tiene_solped'] = $("#tiene_solped").val();    
            parametros['tiene_po'] = $("#tiene_po").val(); 
            parametros['fases'] = $("#fases").val(); 
            parametros['site_type'] = $("#site_type").val();            
            var inicio = $('#Filtros_fechaIni').val();
            var fin = $('#Filtros_fechaFin').val();
            $.getJSON('{{path('reportemshonduras_GenerarMonitorPo')}}',parametros, function (data) {

                ////////////////////////
                //GRAFICO1
                if (data.grafico1.categories.length > 0){
                    projectList[3] = data.grafico1.lstProy.split(",");
                    $("#grafico1").empty();                    
                    var series = getDataToObjectSerieAll(data.grafico1.data, Object.keys(data.grafico1.data[0]));
                    createChartColumn1('grafico1', data.grafico1.categories, series, 'Activities executed without Solped by Region',
                            null, null, null, null, inicio, fin, null,null,"{{ path('reportemshonduras_detalle_po') }}", data.grafico1.data);
                }else{
                    if ($("#grafico1").highcharts()!=undefined){
                        $("#grafico1").highcharts().destroy();
                    }
                    $("#grafico1").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //TABLA GRAFICA1
                if(data.table_grafico1.length == 0){
                  $(".pager_sitios_po").hide();
                  $("#datatable_grafico1").empty();
                  $("#datatable_grafico1").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                }else {
                  $("#datatable_grafico1").empty().append(createTable(data.table_grafico1,'','',3));
                  var pagerOptions3 = {
                       container: $(".pager"),
                       output: 'Rows : {endRow}',
                       fixedHeight: false,
                       removeRows: true,
                       cssGoto: '.gotoPage'
                   };
                  $(".table3").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(pagerOptions3);
                  $(".pager").show();
                }
                
                
                //GRAFICO2
                if (data.grafico2.categories.length > 0){
                    projectList[3] = data.grafico2.lstProy.split(",");
                    $("#grafico2").empty();                    
                    var series = getDataToObjectSerieAll(data.grafico2.data, Object.keys(data.grafico2.data[0]));
                    createChartColumn1('grafico2', data.grafico2.categories, series, 'Consolidated activities carried out without Solped',
                            null, null, null, null, inicio, fin, null,null,"{{ path('reportemshonduras_detalle_po') }}", data.grafico2.data);
                }else{
                    if ($("#grafico2").highcharts()!=undefined){
                        $("#grafico2").highcharts().destroy();
                    }
                    $("#grafico2").empty().append('<div class="alert alert-warning" role="alert">{{'DATOS NO ENCONTRADOS' | trans}}</div>');
                }
                //TABLA GRAFICA2
                if(data.table_grafico2.length == 0){
                  $(".pager_sitios_po").hide();
                  $("#datatable_grafico2").empty();
                  $("#datatable_grafico2").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                }else {
                  $("#datatable_grafico2").empty().append(createTable(data.table_grafico2,'','',4));
                  var pagerOptions4 = {
                       container: $(".pager"),
                       output: 'Rows : {endRow}',
                       fixedHeight: false,
                       removeRows: true,
                       cssGoto: '.gotoPage'
                   };
                  $(".table4").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(pagerOptions4);
                  $(".pager").show();
                }          
                ///////////////////////
                var monitor_pendientes  = data.monitor_pendientes;
                var monitor_falla  = data.monitor_falla;                
                var monitor_pending_approval  = data.monitor_pending_approval;
                //var monitor_po  = data.monitor_po;
                $("#total_monitor_pendientes_po").val(monitor_pendientes.length);
                $("#total_monitor_pending_approval").val(monitor_pending_approval.length);
                $("#total_monitor_falla").val(monitor_falla.length);
                //$("#total_monitor_po").val(monitor_po.length);
                if(monitor_pendientes.length == 0){
                  $(".pager_sitios_pendientes").hide();
                  $("#reporte_sitios_pendientes").empty();
                  $("#reporte_sitios_pendientes").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');                  
                  
                }else {
                  $("#reporte_sitios_pendientes").empty().append(createTable(monitor_pendientes,'','',1));
                  var pagerOptions1 = {
                       container: $(".pager"),
                       output: '{startRow} to {endRow} ({totalRows})',
                       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,
                          pager_size: 10,
                      }
                  }).tablesorterPager(pagerOptions1);
                  $(".pager").show();
                }

                 if(monitor_pending_approval.length == 0){
                  $(".pager_pending_approval").hide();
                  $("#reporte_pending_approval").empty();
                  $("#reporte_pending_approval").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');                  
                  
                }else {
                    
                  $("#reporte_pending_approval").empty().append(createTable(monitor_pending_approval,'','',2));
                  var pagerOptions2 = {
                       container: $(".pager"),
                       output: '{startRow} to {endRow} ({totalRows})',
                       fixedHeight: false,
                       removeRows: true,
                       cssGoto: '.gotoPage'
                   };
                  $(".table2").tablesorter({
                      theme: 'blue',
                      widgets: ["zebra", "filter"],
                      widgetOptions: {
                          filter_cssFilter: '',
                          filter_childRows: false,
                          filter_hideFilters: false,
                          filter_ignoreCase: true,
                          filter_reset: '.reset',
                          filter_saveFilters: true,
                          pager_size: 100,
                      }
                  }).tablesorterPager(pagerOptions2);
                  $(".pager").show();
                }

                if(monitor_falla.length == 0){
                  $("#reporte_fallas").empty();
                  $("#reporte_fallas").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');                  
                  
                }else {
                  $("#reporte_fallas").empty().append(createTable(monitor_falla,'','',5));
                  var pagerOptions3 = {
                       container: $(".pager"),
                       output: '{startRow} to {endRow} ({totalRows})',
                       fixedHeight: false,
                       removeRows: true,
                       cssGoto: '.gotoPage'
                   };
                  $(".table5").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(pagerOptions3);
                  $(".pager").show();
                }         
                resizeChart();
                $.isLoading("hide");  
            });                      
            
        }
        function createChartColumn1(render, categoria, series, title, w,
                                   target_line, target_line2, target_line3, inicio, fin, pais, orderArray, path, rawData)
        {
            //ajustar la serie para la doble axies
            var arrayReturn = new Array();
            var data = new Array();           
            if (series.length>0){
                $.each(series, function(key, value) {
                    $.each(value, function(k, v) { 
                        data.push({"name":v.name,"data":v.data,type: 'column'});
                    });
                });
            }                   
            var table_dt = "";
            var dt = "";
            var posProy = 0;
            var col = 4;
            var rotation = 0;
            var step = Math.ceil(rawData.length/50);
            var kpi = "";
            switch (render){
                
                case 'grafico1':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "grafico1_DETAIL";
                    break 
                case 'grafico2':
                    table_dt = '';
                    dt = '';
                    posProy = 2;
                    kpi = "grafico2_DETAIL";
                    break              
            }
             var options = {
                chart: {
                    zoomType: 'xy',
                    backgroundColor: {
                        linearGradient: [0, 0, 0, 450],
                        stops: [
                            [0, 'rgba(66, 139, 202, 0.3)'], //start
                            [0.5, '#ffffff'], // middle
                            [1, 'rgba(66, 139, 202, 0.2)'] //end
                        ]
                    }
                  },
                  credits: {
                    enabled: false
                  },
                  title: {text: title},
                  subtitle: {
                    text: ''
                  },
                  enableMouseTracking : false,
                  xAxis: {
                        categories: [],
                        lineWidth: 1,
                        lineColor: '#4c4c4c',
                        //tickColor: '#4c4c4c',
                        //tickWidth: 1,
                        //minorTickWidth: 1,
                        labels: {
                            groupedOptions: [{ // 1st-level
                                //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                rotation: 0,
                                lineWidth: 1,
                                tickWidth: 1,
                                style: {
                                    fontSize: '10px',
                                    color: '#333333'
                                    //color: '#4c4c4c'
                                }
                            }, // 2nd-level
                                {
                                    //autoRotation: [-10, -20, -30, -40, -50, -60, -70, -80, -90],
                                    rotation: 0,
                                    lineWidth: 0,
                                    tickWidth: 0,
                                    //align: 'right',
                                    style: {
                                        fontSize: '9px',
                                        color: '#333333'
                                        //color: '#4c4c4c'
                                    }
                                }
                            ],
                            //step: step,
                            lineWidth: 0,
                            tickWidth: 0,
                            rotation: 0,
                            style: {
                                fontSize: '10px',
                                color: '#333333'
                                //color: '#4c4c4c'
                            },
                            formatter: function () {//use formatter to check if length of string is greater than 20 and maintain its width.
                                if(this.value.length > 20){
                                    return this.value.substring(0, 17) + '...';
                                }
                                return this.value;
                            }
                        },
                        overflow: 'justify',
                        scrollbar: {
                            enabled: false
                        }
                  },
                  plotOptions:{
                    column: {
                        pointPadding: 0.2,
                        borderWidth: 0,
                        depth: 40,
                        dataLabels: {
                            enabled: true,
                            crop: false,
                            overflow: 'none'
                        }
                    },
                    series:{
                        shadow:true,
                        dataLabels: {
                            enabled: true,
                            style: {
                                fontWeight: 'bold'
                            }
                        }
                    }
                },
                responsive: {
                    rules: [{
                        condition: {
                            maxWidth: 500
                        },
                        chartOptions: {
                            legend: {
                                align: 'center',
                                verticalAlign: 'bottom',
                                layout: 'horizontal'
                            },
                            yAxis: {
                                labels: {
                                    align: 'left',
                                    x: 0,
                                    y: -5
                                },
                                title: {
                                    text: null
                                }
                            },
                            subtitle: {
                                text: null
                            },
                            credits: {
                                enabled: false
                            }
                        }
                    }]
                },
                 legend: {
                        backgroundColor: 'rgba(66, 139, 202, 0.5)'
                    },
                  yAxis: [{ // Primary yAxis
                    plotLines: [
                        {
                            value: 0,
                            width: 1,
                            color: '#808080'
                        }
                    ],
                    title: {
                      text: 'Qyt',
                      style: {
                        color: Highcharts.getOptions().colors[1]
                      }
                    }
                  }],
                  tooltip: {
                    shared: false
                  },
                  colors: ['#275f76', '#e55550', '#4fa165', '#910000', '#1aadce',
                            '#492970', '#f28f43', '#77a1e5', '#c42525', '#a6c96a'],                  
                  series: data
            };            

            if (target_line != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line[0],
                    color: '#2e8201', //Verde Grama
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: -10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line[1]
                    }
                };
            }

            if (target_line2 != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line2[0],
                    color: '#7cf23c', //Verde Manzana
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: -10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line2[1]
                    }
                };
                
            }

            if (target_line3 != null){
                options.yAxis[0].plotLines[options.yAxis[0].plotLines.length] = {
                    value: target_line3[0],
                    color: '#f7e81d', //Amarillo
                    dashStyle: 'ShortDot',
                    width: 3,
                    zIndex: 4,
                    label: {
                        verticalAlign: 'bottom',
                        textAlign: 'right',
                        align: 'right',
                        y: 10,
                        style: {
                            fontSize: '10px',
                            color: '#606060'
                        },
                        text: target_line3[1]
                    }
                };               
            }

            // OPCIONAL: El path para la tabla detallada
            if (path != null){
                options['plotOptions'] =
                {
                    series:
                    {
                        cursor: 'pointer',
                        borderWidth: 0,
                        dataLabels:
                        {
                            enabled: true
                        },
                        point:
                        {
                            events:
                            {
                                click: function (e){
                                    if (rawData != null){
                                        var row = rawData[this.x];
                                        //console.log('row',row);
                                        var params = {
                                            'kpi': kpi,
                                            'fechaIni': $('#Filtros_fechaIni').val(),
                                            'fechaFin': $('#Filtros_fechaFin').val(),
                                            'pais': $('#pais').val(),                                    
                                            'asp': $('#asp').val(),
                                            'region': $('#region').val(),
                                            'selected_item': row['_cat_Rubro'],
                                            'selected_serie': this.series.name,
                                            'tiene_solped': $("#tiene_solped").val(),
                                            'tiene_po': $("#tiene_po").val(),
                                            'fases': $("#fases").val(),
                                            'site_type': $("#site_type").val(),
                                        };
                                        var subtitle = "";
                                        var prefix = (title == null || title == '') ? params.selected_serie : title + ' - ' + params.selected_serie;
                                        if (this.series.name!='%Accepted'){
                                            generateModal(path, params, false, prefix, subtitle, orderArray);
                                        }
                                    }else{
                                        alert('Data Not Found');
                                    }
                                }
                            }
                        }
                    }
                };
            }

            var num = categoria.length;

            var baseMargin = render=='graficoDashAsp' ? 170 : 90;
            var marginBottom = baseMargin + ((num-1) * 20);
            var menor = series[1];
            var mayor = series[2];
            options.chart.marginBottom = marginBottom;


            for (var k=0; k<rawData.length; k++){
                var hasThisCategory = false;
                var categoryIndex = -1;
                var categoryPath = options.xAxis.categories;
                var lastCat = categoria[categoria.length - 1]['sql_name'];
                if (categoria.length>=1){ //Si hay 2 o mas categorias
                    // I. level of categories
                    if (categoria.length >= 1) {
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[0]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[0]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }

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

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

                    if (categoria.length >=5){
                        // IV. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;
                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[3]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[3]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    if (categoria.length >=6){
                        // V. level of categories
                        categoryPath = categoryPath[categoryIndex].categories;
                        hasThisCategory = false;
                        categoryIndex = -1;

                        Highcharts.each(categoryPath, function(category, i) {
                            if (category.name === rawData[k][categoria[4]['sql_name']]) {
                                hasThisCategory = true;
                                categoryIndex = i;
                            }
                        });
                        if (!hasThisCategory) {
                            categoryPath.push({
                                name: rawData[k][categoria[4]['sql_name']],
                                categories: []
                            });
                        }
                        if (categoryIndex === -1) categoryIndex = categoryPath.length - 1;
                    }
                    // Last level of categories
                    if (categoria.length >1) {
                        categoryPath = categoryPath[categoryIndex].categories;
                    }else{
                        //categoryPath = categoryPath[categoryIndex].categories;
                    }
                    hasThisCategory = false;
                    categoryIndex = -1;
                    Highcharts.each(categoryPath, function(category, i) {
                        if (category === rawData[k][lastCat]) {
                            hasThisCategory = true;
                        }
                    });
                    if (!hasThisCategory) {
                        categoryPath.push(rawData[k][lastCat]);
                    }
                }
            }
            if (render!='graficoCFIssues'){
                if (menor >50) menor= 50;
                options.yAxis[0].min=menor;
            } 
            return $('#' + render).highcharts(options);
        }
        function generateModal(ruta, objParams, numerar, title, subtitle, orderArray)
        { 
                    
            var title_ = title!=null ? title.trim() : "";
            var ordArr = orderArray!=null ? orderArray : null;
            //$('#myModal .tabla-datos').empty().isLoading();
            $("#datatableModalDetalle").empty().isLoading();
            //$('#myModal .tabla-datos').empty().isLoading();
            $('#myModal .punto-grafica').empty().hide();
            $('#myModal .modal_detalle_titulo').empty();

            if (title != null)
            {
                $('#myModal .modal_detalle_titulo').html(title);
                //title_ = title.trim();
                title_ = title_.replace(' ','_');
                title_ = title_.replace('-','');
                title_ = title_.replace(' ','');
            }
            else
            {
                $('#myModal .modal_detalle_titulo').html('{{'monitorii.detail' | trans }}');
                title = '{{'monitorii.detail' | trans }}';
                //title_ = title.trim();
                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 col = createTableDTDetail(Object.keys(data[0]),'tableModalDetalle', 'datatableModalDetalle',objParams.kpi,porcentaje_ohs,0);
                    buildDatatablePrin('tableModalDetalle',col,data,title_,ordArr,objParams);
                    $('[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();
            console.log('data',data);
            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;
        }
        function getDataToObjectSerieAll(data, header){
            var arrayReturn = new Array();
            var data1 = new Array();
            var menor = 1000;
            var mayor = -1;

            for (var i = 0; i < header.length; i++){
                var dataAux = new Array();
                if (header[i].indexOf('_cat_') < 0){
                    for (var j=0; j<data.length; j++){
                        var valor = parseFloat(data[j][header[i]]);
                        dataAux.push(valor);
                        if (valor < menor){
                            menor = valor;
                        }
                        if (valor > mayor){
                            mayor = valor;
                        }
                    }
                    arrayReturn.push({'name': header[i], 'data': dataAux, 'dataLabels': {'enabled': true}});
                }
            }
            data1[0] = arrayReturn;
            data1[1] = menor;
            data1[2] = mayor;
            return data1;
        }
        function createTable(monitor, total, nombreColTotal, option) {
            var header = Object.keys(monitor[0]);
            var table;
            table = '<table  id="tabla'+option+'" class="table table-bordered table-hover table-striped table'+option+'" style="text-align:left">';
            table += "<thead><tr>";
            for (var j = 0; j < header.length; j++) {
                if (header[j]!='RowId' && header[j]!='id_1' && header[j]!='nro_item' && header[j]!='rb'){
                    var strHideFilter = '';
                    if (header[j]=='Action'){
                        table += "<th style='vertical-align:middle;' class='text-center " + strHideFilter + "'>"+
                        "<input type='checkbox' id='marcaAll' class='marcaAll'>Action</th>";
                    }else{
                        table += "<th style='vertical-align:middle;' class='text-center " + strHideFilter + "'>" + header[j] + "</th>";
                    }
                }
            }
            table += "</tr></thead>";   
           
            for (var i = 0; i < monitor.length; i++) {
                table += "<tr id="+monitor[i]['RowId']+">";
                var rowId = monitor[i]['RowId'];
                var rubro = "'"+monitor[i]['rb']+"'";
                var pais = "'"+monitor[i]['Country']+"'";
                var id_1 = monitor[i]['id_1'];
                var nro_item = monitor[i]['nro_item'];
                var applyPayment = monitor[i]['Apply Payment'];
                var usd = monitor[i]['Amount Collected USD'];
                var po_amount = monitor[i]['PO Amount'];
                for (var j = 0; j < header.length; j++) {
                    var disabledButton = "";//(monitor[i][header[j]]!="" && monitor[i][header[j]]!="0.00")? 'disabled': '';
                    var readOnly = (monitor[i][header[j]]!="" && monitor[i][header[j]]!="0.00")? 'readonly': '';
                    var readOnlyG = (monitor[i][header[j]]!="0" && monitor[i][header[j]]!="-")? 'readonly': '';
                    var disabled = (monitor[i][header[j]]!="" && monitor[i][header[j]]!="0.00")? 'disabled': '';
                    {% if is_granted('ROLE_SUPERVISOR_PO') %}
                        readOnly = '';
                        readOnlyG = '';
                        disabledButton = '';
                    {% endif %} 

                    if (header[j]!='RowId' && header[j]!='id_1' && header[j]!='nro_item' && header[j]!='rb'){
                        var strHideFilter = header[j]=="Total amount USD"? 'text-align: right' : 'text-align: left';
                        if(header[j]=='Action'){
                            var action = '<div class="dropdown" style="width: 65px! important;">'+
                                  '<input class="marcaOne" type="checkbox" id="marca[]" name="marca[]" value="'+rowId+'" data-id='+id_1+' data-nroitem='+nro_item+'>'+
                                  '<button class="dropbtn" onclick="actualizarData('+rowId+','+id_1+','+nro_item+','+rubro+','+pais+')" '+disabledButton+'>'+
                                  '<i class="fa fa-lg fa-floppy-o"></i>'+
                                  '</button>'+
                                  '</div>';
                            table += "<td >" +action + "</td>"; 
                        }else if(header[j]=='Gallons of fuel'){
                            var field ='<div>'+
                            '<input style="width: 100px;" class=" form-control" type="text" id="gallons_'+rowId+'_'+id_1+'_'+nro_item+'" name="gallons[]" data="'+rowId+'"  data-id='+id_1+' data-nroitem='+nro_item+' value="'+monitor[i][header[j]]+'" '+readOnlyG+'>'+
                            '</div>';
                            table += "<td >" +field + "</td>"; 
                        }else if(header[j]=='Solped'){
                            var field ='<div>'+
                            '<input style="width: 100px;" class="registra_solped solo_numeros form-control" type="text" id="solped_'+rowId+'_'+id_1+'_'+nro_item+'" name="solped[]" data="'+rowId+'"  data-id='+id_1+' data-nroitem='+nro_item+' value="'+monitor[i][header[j]]+'" '+readOnly+'>'+
                            '</div>';
                            table += "<td >" +field + "</td>"; 
                        }else if(header[j]=='Amount Collected USD'){                          
                            var field ='<div>'+
                            '<input style="width: 100px;" class="usd form-control" type="text" id="usd_'+rowId+'_'+id_1+'_'+nro_item+'" name="usd[]" data="'+rowId+'"  data-id='+id_1+' data-nroitem='+nro_item+' value="'+monitor[i][header[j]]+'" '+readOnly+'>'+
                            '</div>';
                            table += "<td >" +field + "</td>"; 
                        }else if(header[j]=='Apply Payment'){
                            var selectedYes = monitor[i][header[j]]=='YES'?'selected':'';
                            var selectedNo = monitor[i][header[j]]=='NO'?'selected':'';
                            var field ='<div>'+
                            '<select class="apply_payment" id="apply_payment_'+rowId+'_'+id_1+'_'+nro_item+'" name="apply_payment[]" data="'+rowId+'" data-id='+id_1+' data-nroitem='+nro_item+' '+disabled+'>'+
                                '<option value="YES" '+selectedYes+'>YES</option>'+
                                '<option value="NO" '+selectedNo+'>NO</option>'+
                            '</select>'+
                            '</div>';
                            table += "<td >" +field + "</td>"; 
                        }else if(header[j]=='PO Amount'){
                            var field ='<div>'+
                            '<input style="width: 100px;" class="po_amount form-control" type="text" id="po_amount_'+rowId+'_'+id_1+'_'+nro_item+'" name="po_amount[]" data="'+rowId+'"  data-id='+id_1+' data-nroitem='+nro_item+' value="'+monitor[i][header[j]]+'" '+readOnly+'>'+
                            '</div>';
                            table += "<td >" +field + "</td>"; 
                        }else if(header[j]=='PO Number'){
                            var field ='<div>'+
                            '<input style="width: 100px;" class="registra_po solo_numeros form-control" type="text" id="po_'+rowId+'_'+id_1+'_'+nro_item+'" name="po[]" data="'+rowId+'"  data-id='+id_1+' data-nroitem='+nro_item+' value="'+monitor[i][header[j]]+'" '+readOnly+'>'+
                            '</div>';
                            table += "<td >" +field + "</td>"; 
                        }else if(header[j]=='PO release N°'){
                            var field ='<div>'+
                            '<input style="width: 100px;" class="registra_po_release solo_numeros form-control" type="text" id="po_release_'+rowId+'_'+id_1+'_'+nro_item+'" name="po_release[]" data="'+rowId+'"  data-id='+id_1+' data-nroitem='+nro_item+' value="'+monitor[i][header[j]]+'" '+readOnly+'>'+
                            '</div>';
                            table += "<td >" +field + "</td>"; 
                        }else if(header[j]=='Reason PO Amount < PO Collected or No Apply pay'){
                            var block = (applyPayment=='YES' || monitor[i][header[j]]!=='')? 'readonly' : '';
                            if ((po_amount < usd) &&  monitor[i][header[j]]==''){
                                block = '';
                            }
                            var field ='<div>'+
                            '<input style="width: 100px;" class="form-control" type="text" id="reason_po_'+rowId+'_'+id_1+'_'+nro_item+'" name="reason_po[]" data="'+rowId+'"  data-id='+id_1+' data-nroitem='+nro_item+' value="'+monitor[i][header[j]]+'" '+block+'>'+
                            '</div>';
                            table += "<td >" +field + "</td>"; 
                        }else {
                            table += "<td style='"+strHideFilter+"' >" + monitor[i][header[j]] + "</td>"; 
                        }
                        //
                    }  
                }
                table += "</tr>";
            }
            table += "</table>";
            
            return table;
        }
        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;
        });
        var projectList = new Array(4); //Lista de proyectos para cada gráfico
        function createTableDT(data, tableRender, dtRender){
            var strHeader = "";
            var strFooter="";
            var columns = [];
            var strTable = '<table id="' + tableRender + '" class="display cell-border compact stripe" width="100%">' +
                    '<thead><tr class="header_dt">';
            $('#' + dtRender).empty();
            for (var i=0; i<data.length; i++){
                var title = data[i];
                var t = title.replace(/_/g,' ');
                t = title.replace('#','');
                var visible = title.startsWith('_') ? false : true;
                strHeader += '<th style="vertical-align:middle;" 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 actualizarData(rowId,id_1,nro_item,rubro,pais){
            $.isLoading({
                text: "Loading"
            });
            var solped = $("#solped_"+rowId+"_"+id_1+"_"+nro_item).val();
            var usd = $("#usd_"+rowId+"_"+id_1+"_"+nro_item).val();
            var po = $("#po_"+rowId+"_"+id_1+"_"+nro_item).val();
            var gallons = $("#gallons_"+rowId+"_"+id_1+"_"+nro_item).val();
            var po_amount = $("#po_amount_"+rowId+"_"+id_1+"_"+nro_item).val(); 
            var apply_payment = $("#apply_payment_"+rowId+"_"+id_1+"_"+nro_item).val();
            var po_release = $("#po_release_"+rowId+"_"+id_1+"_"+nro_item).val();
            var reason_po = $("#reason_po_"+rowId+"_"+id_1+"_"+nro_item).val();
            if ((apply_payment=='NO' && reason_po=='') || (po_amount < usd && reason_po=='')){
                $.isLoading("hide");
                swal("Error!", "Required Reason PO Amount < PO Collected or No Apply pay", "error");
                return false;
            }
            var parametros = {
                'rowId': rowId,
                'id_1': id_1,
                'nro_item': nro_item,
                'rubro': rubro,
                'pais': pais,
                'solped': solped,
                'usd': usd,
                'po': po,
                'gallons':gallons,
                'apply_payment': apply_payment,
                'po_amount': po_amount,
                'po_release': po_release,
                'reason_po': reason_po
            }            
            $.getJSON('{{path('reportemshonduras_actualizarDataMonitorPo')}}',parametros, function (data) {
                if (data=='Ok'){
                    swal("Information!", "Saved Successfully", "success");
                    getReporte();
                }else{
                    swal("Error!", "Error", "error");
                }
                $.isLoading("hide");
            });
            
        }
        function actualizarMasivo(){
            $.isLoading({
                text: "Loading"
            });
            var procesarMasivo = false;
            var parametros = [];
            var errorRequireReason = false;
            var total = 0;
            $('input[name="marca[]"]:checked').each(function() {
                var rowId = $(this).val();
                var id_1 = $(this).attr('data-id');
                var nro_item = $(this).attr('data-nroitem');
                var solped = $("#solped_"+rowId+"_"+id_1+"_"+nro_item).val();
                var usd = $("#usd_"+rowId+"_"+id_1+"_"+nro_item).val();
                var po = $("#po_"+rowId+"_"+id_1+"_"+nro_item).val();
                var po_amount = $("#po_amount_"+rowId+"_"+id_1+"_"+nro_item).val(); 
                var apply_payment = $("#apply_payment_"+rowId+"_"+id_1+"_"+nro_item).val();
                var po_release = $("#po_release_"+rowId+"_"+id_1+"_"+nro_item).val();
                var reason_po = $("#reason_po_"+rowId+"_"+id_1+"_"+nro_item).val();
                if ((apply_payment=='NO' && reason_po=='') || (po_amount < usd && reason_po=='')){
                   errorRequireReason = true;
                }
                parametros.push({
                    'rowId': rowId, 
                    'id_1': id_1,
                    'nro_item': nro_item, 
                    'solped': solped,
                    'usd': usd,
                    'po': po,
                    'apply_payment': apply_payment,
                    'po_amount': po_amount,
                    'po_release': po_release,
                    'reason_po': reason_po
                });
                procesarMasivo = true;
                total++;
            });
            if (total==0){
                $.isLoading("hide");
                swal("Error!", "You must check at least one", "error");
                return false;
            }
            if (errorRequireReason){
                $.isLoading("hide");
                swal("Error!", "Required Reason PO Amount < PO Collected or No Apply pay", "error");
                return false;
            }
            if (procesarMasivo){
                $.ajax({
                    url: '{{path('reportemshonduras_actualizarDataMasivoMonitorPo')}}',
                    type: 'POST',
                    dataType: "json",
                    data: {parametros: parametros},
                    success: function(response){
                        swal("Information!", "Saved Successfully", "success");
                        getReporte();
                    }
                });
            }
        }
        
        function buildDatatablePrin(render, columnas, data,suffix_export,orderArray){
            //console.log(suffix_export,render);
            var a=[];b=[];
            var Defs = [];
            var order = [];
            var ini = (columnas.length) -5;
            var kpi = "";
            //console.log(render, columnas, data,suffix_export,orderArray);
            for (var i=0; i<=(columnas.length - 1); i++){
                a.push(i);
            }
            //Defs.push({ targets: [4], className: 'dt-body-center' });
            Defs.push({ targets: a, className: 'dt-body-center' });
            for (var i=0; i<=(columnas.length - 1); i++){
                if (columnas[i].visible){
                    b.push(i);
                }
            }
            table = $('#'+render).DataTable( {
                dom: '<"row" <"col-md-12 text-right"B>> <"row" <"col-md-6 "l> <"col-md-6"f>>rtip',
                scrollY: '60vh',
                scrollX: true,
                scrollCollapse: true,
                orderCellsTop: true,
                data:data,
                "deferRender": false,
                "processing": true,
                "language": {
                    // Replace the Processing... text with an AJAX-loader
                    "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                },
                "order": [[ 0, "asc" ]],
                columns: columnas,
                columnDefs: Defs,
                lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                buttons: [
                    {
                        extend:'excel',
                        text: 'Table Excel ' + kpi.replace("_"," "),
                        exportOptions: {
                            columns: b,
                            orthogonal: 'export'
                        },
                        title: 'Excel'
                    }
                ]
            } );
            
        }

        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();


            switch(strType.toLocaleUpperCase()){
                case 'QP':
                case 'QP_DETAIL':
                    col_issues = 8;
                    break;
                case 'OHS':
                case 'OHS_DETAIL':
                    col_issues = 9;
                    break;
            }

            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;

                if (t=='DESCRPTION'){
                    strHeader += '<th class="text-center" style="width: 350px;">' + t + '</th>';
                }else{
                    strHeader += '<th class="text-center">' + t + '</th>';
                }
                
                //console.log(title);
                if (title=="Total Not Accepted" || title=="Not Ok" || title=="SYSTEM FAULT FOUND"){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (dato>0){
                                var kpi="";
                                var popup_title = "";
                                var strIssuesHtml = "<ol>";
                                var strIssuesText = "";
                                var url= "";
                                if (row.hasOwnProperty('_ISSUES')){
                                    kpi='ftr';
                                    popup_title = 'Issues';
                                    var issues = row['_ISSUES'];     
                                    var arrIssues = issues.split("<br>");                               
                                    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'){
                                    /*return '<a href="javascript://" ' +
                                     'onClick=\'generateModal("' + url + '",' + JSON.stringify(parametros) + ',true,"' + table_title +  '","' + subtitle +  '",' + ord +  ')\'">' + dato + '</a>';*/
                                    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 if (title=='_ISSUES'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            if (Array.isArray(dato)){
                                if (dato.length>0){
                                    var strIssuesHtml = "<ol>";
                                    var strIssuesText = "";
                                    if (row.hasOwnProperty('_ISSUES')){
                                        var issues = row['_ISSUES'];
                                        var arrIssues = issues.split("<br>");
                                        if (Array.isArray(arrIssues)){
                                            for (var i=0; i<arrIssues.length; i++){
                                                strIssuesHtml += "<li>" + arrIssues[i] + ".</li>";
                                                strIssuesText += i + ". " +  arrIssues[i] + ".\r\n";
                                            }
                                        }
                                        strIssuesHtml += "</ol>";
                                    }
                                    if (type==='display'){
                                        return strIssuesHtml;
                                    }else{
                                        return strIssuesText;
                                    }
                                }
                            }
                            return dato;
                        }
                    });
                }else if (title=='OHS Index Total'){
                    columns.push({data: data[i], title: t, visible:visible,
                        render: function ( dato, type, row ) {
                            //console.log( dato, type, row);                            
                            //asignaa valores
                            if (dato == total_registros){
                                return porcentaje_ohs;    
                            }else{
                                return '';
                            }
                            
                        }
                    });
                }else{
                    columns.push({data: data[i], title: t, visible:visible});
                }
            }
            strTable += strHeader + '</tr></thead><tbody id="tbody_' + tableRender + '"></tbody>' + strFooter + '</table>';
            $('#' + dtRender).empty();
            $('#' + dtRender).html(strTable);
            $('#' + tableRender + ' thead tr').clone(true).appendTo( '#' + tableRender + ' thead' );
            $('#' + tableRender + ' thead tr:eq(1) th').each( function (i) {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%; margin: 0px; padding: 0px;"/>' );
                $( 'input', this ).on( 'keyup change', function () {
                    if ( $.fn.DataTable.isDataTable( '#' + tableRender ) ) {
                        var table = $('#' + tableRender).DataTable();
                        if ( table.column(i).search() !== this.value ) {
                            table
                                    .column(i)
                                    .search( this.value )
                                    .draw();
                        }
                    }
                } );
            } );

            return columns;
        }

        function resizeChart(){

            var panel_width = $('#panel_content').width();
            var offset = 15;

            $('#grafico1').width(panel_width-offset); 

           
            if ($("#grafico1").highcharts()!=undefined){ 
                $('#grafico1').highcharts().reflow();   
            }

            $('#grafico2').width(panel_width-offset); 

           
            if ($("#grafico2").highcharts()!=undefined){ 
                $('#grafico2').highcharts().reflow();   
            }
        }

        //exportar excel aproved
        function ExportExcelAproved() {
          document.forms['formulario_filtros'].action="{{path('reportejsa_ExcelAprovedOhs')}}";
          document.getElementById("formulario_filtros").submit();
        }

    </script>
    
    <div class="container-fluid">
            <div class="row">
              <div class="col-lg-3">
                 <label>COUNTRY: </label>
                 <select class="form-control get-list" id="pais" name="pais" data='region'
                    data-act='refresh_pais' data-campo-filtro='pais' data-campo-mostrar='region_1'>
                     {%for pais in paises%}
                        <option value="{{pais.valor}}">{{pais.nombre}}</option>
                     {%endfor%}
                 </select>
              </div>
            <div class="col-lg-3">
                <label>REGION: </label>
                <select class="form-control refresh_pais" id="region" name="region">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>  
                    {%for regione in regiones%}
                        <option value="{{regione.valor}}">{{regione.nombre}}</option>
                    {%endfor%}                     
                </select>
            </div>
            <div class="col-lg-2">
                <label>ASP: </label>
                <select class="form-control" id="asp" name="asp">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    {%for asp in asps%}
                        <option value="{{asp.valor}}">{{asp.nombre}}</option>
                    {%endfor%}
                </select>
            </div>
            <div class="col-lg-2">
                <label>SOLPED: </label>
                <select class="form-control" id="tiene_solped" name="tiene_solped">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    <option value="SI">YES</option>
                    <option value="NO">NO</option>                    
                </select>
            </div> 
            <div class="col-lg-2">
                <label>PO: </label>
                <select class="form-control" id="tiene_po" name="tiene_po">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    <option value="SI">YES</option>
                    <option value="NO">NO</option>                    
                </select>
            </div>            
                
            </div>
            <br/>
            <div class="row">
              <div class="col-lg-3">
                 <label>SITE TYPE: </label>
                 <select class="form-control" id="site_type" name="site_type">
                     <option value="TODOS">{{'inbox.all' | trans}}</option>
                     {%for site_type in site_types%}
                        <option value="{{site_type.valor}}">{{site_type.nombre}}</option>
                     {%endfor%}
                 </select>
              </div>
            <div class="col-lg-3">
                <label>FASE: </label>
                <select class="form-control" id="fases" name="fases">
                    <option value="TODOS">{{'inbox.all' | trans}}</option>
                    {%for fase in fases%}
                        <option value="{{fase.valor}}">{{fase.nombre}}</option>
                    {%endfor%}
                </select>
            </div>
            <div class="col-lg-2">
                <label> {{'monitor.etiqueta.fechaI' | trans}}:</label>
                  <input class="form-control" type="text" id="Filtros_fechaIni" value="{{ dateStart }}" name="Filtros_fechaIni">
            </div>
            <div class="col-lg-2">
                <label> {{'monitor.etiqueta.fechaF' | trans}}: </label>
                <input class="form-control" type="text" id="Filtros_fechaFin" value="{{ dateEnd }}" name="Filtros_fechaFin">
            </div> 
            <div class="col-lg-2">
            </div>            
                 <br>
                <button class="btn btn-claro" id="generar" style="vertical-align: bottom">{{'ticketDetail.boton.generar' | trans}}</button>
            </div>
            <br/>
            <div class="row">
                <div class="col-lg-12 text-center"  style="margin-top: 1%">
                    <h1>{{'PO Handling Solution in FSO' | trans}}</h1>
                 </div>
            </div>
      <form id="formulario_filtros" onsubmit="return false;">
        <input type="hidden" id="total_monitor_pendientes_po" name="total_monitor_pendientes_po" value="0">
        <input type="hidden" id="total_monitor_po" name="total_monitor_po" value="0">
        
        <input type="hidden" id="total_monitor_pending_approval" name="total_monitor_pendientes_po" value="0">
        <input type="hidden" id="total_pending_approval" name="total_pending_approval" value="0">
        <input type="hidden" id="total_monitor_falla" name="total_monitor_falla" value="0">


        <!--new-->
         <div class="row">
            <div id="panel_content" class="col-lg-12">
                <div class="panel with-nav-tabs panel-primary">
                    <div class="panel-heading">
                        <ul class="nav nav-tabs" id="myTabs">
                            <li class='activar_fallas click_tab' role="presentation" id="activar_fallas" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_activar_fallas"><strong>OPENNING CORRECTIVE (Failure)</strong></a></li>
                            <li class='activar_pending_approval click_tab' role="presentation" id="pending_approval" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_pending_approval"><strong>PENDING APPROVAL</strong></a></li>
                            <li  role="presentation" id="sitios_pendientes" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_sitios_pendientes" data="NO"><strong>PENDING PO</strong></a></li>                                                
                            <li class='activar_dashboard click_tab' role="presentation" id="dashboard" data-filtro="div_fechaIni div_fechaFin div_cliente div_proyecto div_asp"><a data-toggle="tab" href="#_dashboard"><strong>DASHBOARD</strong></a></li>
                        </ul>
                    </div>
                    <div class="panel-body">
                        <div class="tab-content">
                            <div id="_activar_fallas" class="tab-pane fade active" style="margin: 0px 0px 0px 18px;">
                                <div class="row" style="margin: 30px 0 0 0px !important;">
                                  <div class="col-lg-offset-9 col-md-offset-9">
                                      <div class="btn-group pull-right">
                                          <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                                          <ul class="dropdown-menu" role="menu">
                                              <li><a href="#" onclick="$('#reporte_fallas').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                                          </ul>
                                      </div>
                                  </div>
                                  

                                  <div class="pager pager_reporte_fallas" id="pager_reporte_fallas" style="text-align: left">
                                      <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                                      <span class="pagedisplay"></span>
                                  </div>
                                </div>
                                
                                <div class="row double-scroll">
                                    <div class="double-scroll" id="reporte_fallas"></div>
                                </div>
                                
                            </div>

                            <div id="_pending_approval" class="tab-pane fade" style="margin: 0px 0px 0px 18px;">
                                <div class="row" style="margin: 30px 0 0 0px !important;">
                                  <div class="col-lg-offset-9 col-md-offset-9">
                                      <div class="btn-group pull-right">
                                          <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                                          <ul class="dropdown-menu" role="menu">
                                              <li><a href="#" onclick="$('#reporte_pending_approval').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                                          </ul>
                                      </div>
                                  </div>

                                  <div class="row" style="margin: 50px 0 0 0px !important;">
                                    <div class="col-md-12 text-right">
                                        <button disabled class="btn btn-claro guardarMasivo" onclick="actualizarMasivo()">Save</button>
                                    </div>
                                  </div>
                                  
                                  <div class="pager pager_pending_approval" style="text-align: left">
                                      <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                                      <span class="pagedisplay"></span>
                                  </div>
                                </div>
                                
                                <div class="row double-scroll">
                                    <div class="double-scroll" id="reporte_pending_approval"></div>
                                </div>
                                
                            </div>

                            <div id="_sitios_pendientes" class="tab-pane fade" style="margin: 0px 0px 0px 18px;">
                                <div class="row" style="margin: 30px 0 0 0px !important;">
                                  <div class="col-lg-offset-9 col-md-offset-9">
                                      <div class="btn-group pull-right">
                                          <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos ' | trans}}</button>
                                          <ul class="dropdown-menu" role="menu">
                                              <li style="margin-bottom: 3px; border-bottom: dashed 1px #e4e4e4;"><a href="#" onclick="$('#reporte_sitios_pendientes').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="16px"> Datos de Tabla</a></li>
                                            
                                              <li><a href="{{ path("reportemshonduras_DownloadCobroMgpGT")}}" id="downloadTemplateCobroMGP" class="downloadTemplateCobroMGP" > <img src={{ asset("images/xls.png")}} width="16px"> Cobro MGP-GT</a></li>
                                          </ul>
                                      </div>
                                  </div>

                                  <div class="row" style="margin: 50px 0 0 0px !important;">
                                    <div class="col-md-12 text-right">
                                        <button disabled class="btn btn-claro guardarMasivo" onclick="actualizarMasivo()">Save</button>
                                    </div>
                                  </div>
                                  
                                  <div class="pager pager_sitios_pendientes" style="text-align: left">
                                      <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                                      <span class="pagedisplay"></span>
                                  </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-12" id="reporte_sitios_pendientes" style="overflow-x: auto;">
                                    </div>
                                </div>
                                
                            </div>

                            <div id="_sitios_po" class="tab-pane fade">
                                <div class="row" style="margin: 30px 0 0 0px !important;">
                                  <div class="col-lg-offset-9 col-md-offset-9">
                                      <div class="btn-group pull-right">
                                          <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                                          <ul class="dropdown-menu" role="menu">
                                              <li><a href="#" onclick="$('#reporte_sitios_po').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                                          </ul>
                                      </div>
                                  </div>
                                  
                                  <div class="pager pager_sitios_po" style="text-align: left">
                                      <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                                      <span class="pagedisplay"></span>
                                  </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-12" id="reporte_sitios_po" style="overflow-x: auto;">
                                    </div>
                                </div>
                            </div>

                            <div id="_dashboard" class="tab-pane fade">
                                <div class="row">
                                    <div id="grafico1" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <br>
                                <div class="row">
                                    <div class="col-lg-offset-9 col-md-offset-9">
                                      <div class="btn-group pull-right">
                                          <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                                          <ul class="dropdown-menu" role="menu">
                                              <li><a href="#" onclick="$('#datatable_grafico1').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                                          </ul>
                                      </div>
                                    </div>
                                    <div class="col-md-12" id="datatable_grafico1" style="overflow-x: auto;">
                                    </div>
                                    <div class="pager pager_grafica1" style="text-align: left">
                                      <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                                      <span class="pagedisplay"></span>
                                    </div>
                                </div>
                                <br>
                                <div class="row">
                                    <div id="grafico2" class="col-md-12" style="width: 100%; min-width: 320px;">
                                    </div>
                                </div>
                                <br>
                                <div class="row">
                                    <div class="col-lg-offset-9 col-md-offset-9">
                                      <div class="btn-group pull-right">
                                          <button class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> {{'Exportar datos de la tabla' | trans}}</button>
                                          <ul class="dropdown-menu" role="menu">
                                              <li><a href="#" onclick="$('#datatable_grafico2').tableExport({type: 'excel', escape: 'false'});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a></li>
                                          </ul>
                                      </div>
                                    </div>
                                    <div class="col-md-12" id="datatable_grafico2" style="overflow-x: auto;">
                                    </div>
                                    <div class="pager pager_grafica2" style="text-align: left">
                                      <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                                      <span class="pagedisplay"></span>
                                    </div>
                                </div>                                
                            </div>

                            

                        <div class="row">
                            <div id="pager" class="pager" style="display: none">
                                <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 value="10">10</option>
                                        <option value="20">20</option>
                                        <option value="30">30</option>
                                        <option value="40">40</option>
                                        <option value="50">50</option>
                                        <option value="60">60</option>
                                        <option value="70">70</option>
                                        <option value="80">80</option>
                                        <option value="90">90</option>
                                        <option value="100">100</option>
                                        <option value="999999">All Rows</option>
                                    </select>
                                </form>
                            </div>
                        </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!--fin-->
      </form>
    </div>
    
    <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" style="width: 1200px;margin: 0px 0px 0px -140px;">
                <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 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-1.12.4.js') }}"></script-->
    <script src="{{ asset('js/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('js/buttons.flash.min.js') }}"></script>
    <script src="{{ asset('js/jszip.min.js') }}"></script>
    {#<script src="{{ asset('js/pdfmake.min.js') }}"></script>#}
    <script src="{{ asset('js/vfs_fonts.js') }}"></script>
    <script src="{{ asset('js/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('js/buttons.print.min.js') }}"></script>
    <script src="{{ asset('datatables/js/dataTables.select.min.js') }}"></script>
    <script src="{{ asset('datatables/moment.min.js') }}"></script>
    <script src="{{ asset('datatables/js/datetime-moment.js') }}"></script>
    <script src="{{ asset('js/grouped-categories.js') }}"></script>

    <script src="{{ asset('highcharts5/code/modules/data.src.js') }}"></script>
    {#<script src="{{ asset('js/TableEdit/jquery.tabledit.min.js') }}"></script>#}
{% endblock %}