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

{% endblock %}

{% block dashboard %}
    <style>
        @media (max-width: 767px){
            #logo {
                margin-top: 8px;
            }
        }
        /* 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: #aa0001;
            border: 1px solid #FFF;
            font-size: 9pt;
            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);}
        }
        .table-responsive {
            /*height: 400px !important;*/
            overflow: scroll;
        }
        .btn-claro {
            color: #fff;
            background-color: #aa0001;
            border-color: #e06a70;

        }

        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
        }
        tr {cursor:pointer}

        .tablesorter-header-inner,table.tablesorter thead tr th,.tablesorter-filter {
            color: #fff;
            background-color: #aa0001;
            border-color: #aa0001;
        }
        table.tablesorter thead tr th{
            height: 40px;
        }
        .tablesorter-blue .headerSortUp, .tablesorter-blue .tablesorter-headerSortUp, .tablesorter-blue .tablesorter-headerAsc {
            background-color: #aa0001;}
        .tablesorter-blue .headerSortDown, .tablesorter-blue .tablesorter-headerSortDown, .tablesorter-blue .tablesorter-headerDesc {
            background-color: #aa0001;}
        .tablesorter-blue .tablesorter-filter-row td {
            background: #aa0001;border-color: #aa0001;}
        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;
        }
        .bg_cell_yellow {
            color: rgb(255,153,0) !important;
        }
        .bg_cell_red{
            color: red !important;
        }
        .bg_cell_blue{
            color: #000066 !important;
        }
        .tabledetail {
            color: #fff;
            background-color: #00569C;
            border-color: #00569C;
        }
        .bg_cell_yellow_ {
            background-color: #f0ad4e !important;
            color: black !important;
        }
        .bg_cell_red_{
            background-color: #d9534f !important;
            color: white !important;
        }
    </style>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <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>
    function crearPopover(){
        $('body').popover({
            selector: '.has-popover',
            title: 'Motivo Rechazo',
            html: true,
            trigger: 'click',
            placement: 'top',
            content: function () { return $(this).data('motivo'); }
        });
    }
        $(document).ready(function(){
            $("#btnGenerate").click(function(){
                $.isLoading({
                    text: "Loading, Please Wait"
                });
                $("#quantity").html(0);
                reporteBateria();

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

            var f = new Date();
            var month = (f.getMonth() + 1);

            if (month < 10) month = '0' + month;
            var dateI = f.getFullYear() + '-' + month + "-01";
            var dateF = f.getFullYear() + '-' + month + "-" + f.getDate();

            $('#txtStartDate').val(dateI);
            $('#txtEndDate').val(dateF);

            $(document).on("click", ".downloadTemplate", function () {
                var data = {};
                data['country'] = $("#cmbCountry").val();
                data['startDate'] = $("#txtStartDate").val();
                data['endDate'] = $("#txtEndDate").val();

                var ruta = "{{path('reportAmx_DownloadAmxImplementAspHn')}}?country=" + data['country']
                        + "&startDate=" + data['startDate'] + "&endDate=" + data['endDate'] + "";
                //window.open(ruta);
                $('.downloadTemplate').attr("href",ruta);

                //alert(ruta);
            });

            $("#cmbCountry").change(function(){

              var country = $("#cmbCountry").val();
              //alert(country);
              $(".listD").remove();
              if (country == 'HONDURAS') {
                //$('#chart1').show();
                var a = $(".dropdown-menu").append(`<li class="listD">
                    <a class="downloadTemplate" href="{{ path("reportemshonduras_DownloadMg")}}"
                       id="downloadTemplate"> <img src={{ asset("images/xls.png")}} width="24px"> XLS
                    </a>
                </li>`);

              }else {
                //$('#chart1').hide();
                var a = $(".dropdown-menu").append(`<li class="listD"><a href="#" onclick="$('#primer_reporte').tableExport({type: 'excel', escape: 'false'});">
                        <img src={{ asset("images/xls.png")}} width="24px"> XLS
                    </a>
                </li>`);

              }

            });

            function reporteBateria(){
              var country = $("#cmbCountry").val();

                data = {};
                data['country'] = $("#cmbCountry").val();
                data['startDate'] = $("#txtStartDate").val();
                data['endDate'] = $("#txtEndDate").val();
                //data['customer'] = $("#cmbCustomer").val();
                //data['project'] = $("#cmbProject").val();
                //data['asp'] = $("#cmbAsp").val();
                //console.log( JSON.stringify(data, null, 2) );

                $.getJSON('{{path('reportAmx_reporteMonitorAmxImplementASP')}}',data, function (data) {
                    var bateria  = data.bateria;
                    var chart1 = 0;
                    var chart1 = data.chart;
                    var flag = true;
                    if(bateria.length == 0){
                        $("#primer_reporte").empty();
                        $("#primer_reporte").append('<div class="alert alert-warning" role="alert">NO SE HA ENCONTRADO DATA</div>');
                        $.isLoading("hide");
                        return false;
                    }

                    if(chart1.length == 0){
                        $("#chart1").empty();
                        $("#chart1").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                        $.isLoading("hide");
                        $("#inicio").show();
                        flag = false;

                    }
                    if(flag){

                        createColumnChart('chart1','Deliverables',chart1);


                        /*var total = getTotal(chart1,[1,2,3,4,5,6,7,8,9,10,11],2);
                        total.shift();
                        var header = Object.keys(chart1[0]);
                        var AuxArray = new Array();
                        for(var i=1;i<header.length;i++){

                            AuxArray.push({'estado':header[i],'Sitios': total[i-1]})
                        }*/

                        //createColumnChart('chart2','Implementation Deliverables',AuxArray);
                    }

                    $("#cantidad").html(bateria.length);
                    crearPopover();
                    $("#primer_reporte").empty().append(createTable(bateria));

                    if (country == 'HONDURAS') {
                      $('#chart1').show();
                    }else {
                      $('#chart1').hide();
                    }

                    $.isLoading("hide");
                    var pagerOptions = {
                        // target the pager markup - see the HTML block below
                        container: $(".pager"),
                        // output string - default is '{page}/{totalPages}'; possible variables: {page}, {totalPages}, {startRow}, {endRow} and {totalRows}
                        output: '{filteredRows}',
                        // if true, the table will remain the same height no matter how many records are displayed. The space is made up by an empty
                        // table row set to a height to compensate; default is false
                        fixedHeight: false,
                        // remove rows from the table to speed up the sort of large tables.
                        // setting this to false, only hides the non-visible rows; needed if you plan to add/remove rows with the pager enabled.
                        removeRows: true,
                        // go to page selector - select dropdown that sets the current page
                        cssGoto: '.gotoPage'
                    };
                    // initial sort set using sortList option
                    $(".table1").tablesorter({
                        theme: 'blue',
                        // sort on the first column and second column in ascending order
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            // extra css class applied to the table row containing the filters & the inputs within that row
                            filter_cssFilter: '',
                            // If there are child rows in the table (rows with class name from "cssChildRow" option)
                            // and this option is true and a match is found anywhere in the child row, then it will make that row
                            // visible; default is false
                            filter_childRows: false,
                            // if true, filters are collapsed initially, but can be revealed by hovering over the grey bar immediately
                            // below the header row. Additionally, tabbing through the document will open the filter row when an input gets focus
                            filter_hideFilters: false,
                            // Set this option to false to make the searches case sensitive
                            filter_ignoreCase: true,
                            // jQuery selector string of an element used to reset the filters
                            filter_reset: '.reset',
                            // Use the $.tablesorter.storage utility to save the most recent filters
                            filter_saveFilters: false,
                            filter_columnFilters : true
                        }
                    }).tablesorterPager(pagerOptions);
                    $('.pager').show();
                });
            }

            function formatEstatusCell(value){
                var cad = value;
                switch (value){
                    case 'POR REVISAR':
                        cad = "<span class='bg_cell_yellow'>" + value + "</span>";
                        break;
                    case 'RECHAZADO':
                        cad = "<span class='bg_cell_red'>" + value + "</span>";
                        break;
                    case 'APROBADO':
                        cad = "<span class='bg_cell_blue'>" + value + "</span>";
                        break;
                }
                return cad;
            }

            function createArrayToChart(chart,text)
            {
                var header = Object.keys(chart[0]);
                var x = new Array();
                var y = new Array();


                for(var i=0;i<chart.length;i++){

                     x.push(chart[i][header[0]]);

                }

                for(var j= 0;j<header.length;j++){

                    y.push({name:"",data:[]});
                }


                for(var i=0;i<chart.length;i++){

                    for(var j= 0;j<header.length;j++){

                        if(i == 0){

                            y[j-0].name = header[j];
                        }
                       y[j-0].data.push(parseInt(chart[i][header[j]]));
                    }

                }



                return new Array(x,y);

            }

            function createArrayToPieChart(chart)
            {
                if(chart.length == 0) return false;
                var auxArray = new Array();
                var header = Object.keys(chart[0]);
                for(var i=0;i<chart.length;i++){
                  auxArray.push({'name':chart[i][header[0]],y:parseFloat(chart[i][header[1]])});
                }

                return auxArray;
            }

            function createColumnChart(renderTo,title,chart)
            {
                var data = createArrayToChart(chart);

                var segundaGraficaOpt = {
                    chart: {
                        type: 'column',
                        renderTo: renderTo,

                    },

                    title: {
                        text: title
                    },

                    xAxis: {
                        categories: data[0],
                        crosshair: true
                    },

                    yAxis: {

                        title: {
                            text: ''
                        },
                        plotLines:[]
                    },

                    tooltip: {
                        headerFormat: '<span style="font-size:10px">{point.key}</span><table>',
                        pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' +
                        '<td style="padding:0"><b>{point.y:.0f}</b></td></tr>',
                        footerFormat: '</table>',
                        shared: true,
                        useHTML: true
                    },

                    plotOptions: {
                        column: {
                            pointPadding: 0.2,

                            borderWidth: 0,
                            depth: 40,
                            dataLabels: {
                                enabled: true,
                                crop: false,
                                overflow: 'none'
                            }
                        }
                    },

                    series: data[1]
                };

                new Highcharts.Chart(segundaGraficaOpt)
            }
            function createPieChart(renderTo,title,chart)
            {
                var data = createArrayToPieChart(chart);
                console.log(data);
                    var pie = {
                        chart: {
                            plotBackgroundColor: null,
                            plotBorderWidth: null,
                            plotShadow: false,
                            type: 'pie',
                            renderTo: renderTo
                        },
                        title: {
                            text: title
                        },
                        tooltip: {
                            pointFormat: '{series.name}: <b>{point.y:.0f}</b>'
                        },
                        plotOptions: {
                            pie: {
                                allowPointSelect: true,
                                cursor: 'pointer',
                                dataLabels: {
                                    enabled: true,
                                    format: '<b>{point.name}</b>: {point.percentage:.1f} %',
                                    style: {
                                        color: (Highcharts.theme && Highcharts.theme.contrastTextColor) || 'black'
                                    }

                                },
                                showInLegend: true
                            }
                        },
                        series: [{
                            name: 'Sites',
                            colorByPoint: true,
                            data: data
                        }]
                    };
                new Highcharts.Chart(pie);
            }

            function getTotal(valor,key,tipo)
            {
                var total = new Array();

                var header = Object.keys(valor[0]);


                for(var i = 0; i< valor.length;i++){

                    for(var j = 0; j< key.length;j++){

                        if(typeof total[key[j]] === "undefined"){
                            total[key[j]] = 0;
                        }

                        if (tipo==1){
                            total[key[j]] +=  parseFloat(valor[i][header[key[j]]]);
                            if (i == (valor.length-1)) total[key[j]]=parseFloat(total[key[j]]).toPrecision(3);
                            //alert(total[key[j]]);
                        }
                        else
                            total[key[j]] +=  parseInt(valor[i][header[key[j]]]);

                    }

                }
                return total;
            }

            function createTable(monitor, total, nombreColTotal, option) {
                var header = Object.keys(monitor[0]);
                var table;
                var idproyectos = {{idproyectos}};

                table = '<table id="tabla1" class="table table-bordered table-hover table-striped table-responsive table1">';
                table += "<thead><tr>";

                for (var j = 0; j < header.length; j++) {
                    if (!header[j].startsWith('_')){
                        table += "<th style='vertical-align:middle;' class='text-center'>" + header[j] + "</th>";
                    }
                }
                table += "</tr></thead>";
                var aux="";
                var motivo = "";
                for (var i = 0; i < monitor.length; i++) {
                  if(monitor[i]['COUNTRY']=='COSTA RICA'){
                    table += "<tr>";
                    table += "<td>" + monitor[i]['COUNTRY'] + "</td>"; //Country
                    table += "<td>" + monitor[i]['CUSTOMER'] + "</td>"; //Customer
                    table += "<td>" + monitor[i]['PROJECT'] + "</td>"; //Project
                    table += "<td align='center'>" + monitor[i]['ID'] + "</td>"; //Site Id
                    table += "<td>" + monitor[i]['SITE NAME'] + "</td>"; //Site Name
                    table += "<td align='center'>" + monitor[i]['DATE'] + "</td>"; //Date
                    table += "<td>" + monitor[i]['ASP'] + "</td>"; //Asp
                    table += "<td>" + monitor[i]['LEADER'] + "</td>"; //Leader
                    //table += "<td align='center'>" + monitor[i]['JSA'] + "</td>"; //Country
                    table += "<td align='center'>" + monitor[i]['ATS CHECKIN'] + "</td>"; //Customer
                    table += "<td align='center'>" + monitor[i]['CHECKOUT'] + "</td>"; //Project
                    table += "<td align='center'>" + monitor[i]['MATERIAL'] + "</td>"; //Site Name
                    //table += "<td align='center'>" + monitor[i]['REASON MATERIAL REJECTION'] + "</td>"; //Asp
                    table += "<td align='center'>" + monitor[i]['DISASSEMBLY'] + "</td>"; //Leader
                    //table += "<td align='center'>" + monitor[i]['REASON REJECTION DISASSEMBLY'] + "</td>"; //Country
                    table += "<td align='center'>" + monitor[i]['ASBUILT'] + "</td>"; //Customer
                    //table += "<td align='center'>" + monitor[i]['REASON REJECTION ASBUILT'] + "</td>"; //Project
                    table += "<td align='center'>" + monitor[i]['CLEAN SITE'] + "</td>"; //Country
                    //table += "<td align='center'>" + monitor[i]['REASON REJECT CLEAN SITE'] + "</td>"; //Customer
                    table += "<td align='center'>" + monitor[i]['RF PRE'] + "</td>";
                    table += "<td align='center'>" + monitor[i]['RF POST'] + "</td>";
                    //table += "<td align='center'>" + monitor[i]['AUDIT RF (FULL)'] + "</td>"; //Project
                    //table += "<td align='center'>" + monitor[i]['REASON RF REJECTION'] + "</td>"; //Site Name
                    table += "<td align='center'>" + monitor[i]['RF AUDIT'] + "</td>"; //Asp
                    //table += "<td align='center'>" + monitor[i]['REASON RF AUDIT REJECTION'] + "</td>"; //Leader
                    table += "<td align='center'>" + monitor[i]['BULLET'] + "</td>"; //Customer
                    table += "<td align='center'>" + monitor[i]['ATP DSS'] + "</td>"; //Customer
                    table += "<td align='center'>" + monitor[i]['ASBUILT DSS'] + "</td>"; //Customer
                    table += "<td align='center'>" + monitor[i]['REVIEWER'] + "</td>"; //Country
                    //table += "<td align='center'>" + monitor[i]['MOTIVO RECHAZO VINETA'] + "</td>"; //Project
                  }else if(monitor[i]['COUNTRY']=='NICARAGUA'){
                    table += "<tr>";
                    table += "<td>" + monitor[i]['COUNTRY'] + "</td>"; //Country
                    table += "<td>" + monitor[i]['CUSTOMER'] + "</td>"; //Customer
                    table += "<td>" + monitor[i]['PROJECT'] + "</td>"; //Project
                    table += "<td align='center'>" + monitor[i]['ID'] + "</td>"; //Site Id
                    table += "<td>" + monitor[i]['SITE NAME'] + "</td>"; //Site Name
                    table += "<td align='center'>" + monitor[i]['DATE'] + "</td>"; //Date
                    table += "<td>" + monitor[i]['ASP'] + "</td>"; //Asp
                    //table += "<td>" + monitor[i]['LEADER'] + "</td>"; //Leader
                    //table += "<td align='center'>" + monitor[i]['JSA'] + "</td>"; //Country
                    table += "<td align='center'>" + monitor[i]['ATS CHECKIN'] + "</td>"; //Customer
                    table += "<td align='center'>" + monitor[i]['PRE RF'] + "</td>"; //Leader
                    table += "<td align='center'>" + monitor[i]['POST RF'] + "</td>"; //Site Name
                    //table += "<td align='center'>" + monitor[i]['REASON MATERIAL REJECTION'] + "</td>"; //Asp
                    //table += "<td align='center'>" + monitor[i]['REASON REJECTION DISASSEMBLY'] + "</td>"; //Country
                    //table += "<td align='center'>" + monitor[i]['VELOCITY TEST'] + "</td>"; //Customer
                    //table += "<td align='center'>" + monitor[i]['REASON REJECTION ASBUILT'] + "</td>"; //Project
                    table += "<td align='center'>" + monitor[i]['ATP'] + "</td>"; //Country
                    table += "<td align='center'>" + monitor[i]['DISASSEMBLY'] + "</td>"; //Country
                    table += "<td align='center'>" + monitor[i]['ASBUILT'] + "</td>"; //Country
                    table += "<td align='center'>" + monitor[i]['SITE CLEAN'] + "</td>"; //Country
                    table += "<td align='center'>" + monitor[i]['REVIEWER'] + "</td>"; //Country
                  }else if(monitor[i]['COUNTRY']=='HONDURAS'){//HONDURAS
                    table += "<tr>";
                    table += "<td>" + monitor[i]['COUNTRY'] + "</td>"; //Country
                    table += "<td>" + monitor[i]['CUSTOMER'] + "</td>"; //Customer
                    table += "<td>" + monitor[i]['PROJECT'] + "</td>"; //Project
                    table += "<td align='center'>" + monitor[i]['ID'] + "</td>"; //Site Id
                    table += "<td>" + monitor[i]['SITE NAME'] + "</td>"; //Site Name
                    table += "<td align='center'>" + monitor[i]['DATE'] + "</td>"; //Date
                    table += "<td>" + monitor[i]['ASP'] + "</td>"; //Asp
                    //table += "<td>" + monitor[i]['LEADER'] + "</td>"; //Leader
                    table += "<td align='center'>" + monitor[i]['ATS CHECKIN'] + "</td>"; //Country
                    //table += "<td align='center'>" + monitor[i]['INPUT'] + "</td>"; //Customer
                    table += "<td align='center'>" + monitor[i]['ATP'] + "</td>"; //ASP

                    aux=monitor[i]['RF AUDITING'];
                    motivo = monitor[i]['_ma'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RF AUDITING'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RF AUDITING'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RF AUDITING'] + "</td>"; //Asp
                    }

                    aux=monitor[i]['CAPITALIZATION'];
                    motivo = monitor[i]['_amx_02'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['CAPITALIZATION'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['CAPITALIZATION'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['CAPITALIZATION'] + "</td>"; //Country
                    }

                    aux=monitor[i]['DISASSEMBLY'];
                    motivo = monitor[i]['_amx_03'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['DISASSEMBLY'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['DISASSEMBLY'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['DISASSEMBLY'] + "</td>"; //Customer
                    }

                    aux=monitor[i]['RETURNED MATERIAL'];
                    motivo = monitor[i]['_amx_04'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RETURNED MATERIAL'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RETURNED MATERIAL'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RETURNED MATERIAL'] + "</td>"; //Project
                    }

                    /*aux=monitor[i]['ACTIVITIES'];
                    motivo = monitor[i]['_amx_05'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['ACTIVITIES'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['ACTIVITIES'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['ACTIVITIES'] + "</td>"; //Asp
                    }*/

                    aux=monitor[i]['INSTALATION'];
                    motivo = monitor[i]['_amx_06'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['INSTALATION'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['INSTALATION'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['INSTALATION'] + "</td>"; //Asp
                    }
/*
                    aux=monitor[i]['CPL'];
                    motivo = monitor[i]['_cpl'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['CPL'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['CPL'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['CPL'] + "</td>"; //Asp
                    }                    
                    
                    aux=monitor[i]['DUG20'];
                    motivo = monitor[i]['_amx_07'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['DUG20'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['DUG20'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['DUG20'] + "</td>"; //Country
                    }

                    aux=monitor[i]['DUS31'];
                    motivo = monitor[i]['_amx_08'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['DUS31'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['DUS31'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['DUS31'] + "</td>"; //Customer
                    }

                    aux=monitor[i]['DUS41'];
                    motivo = monitor[i]['_amx_09'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['DUS41'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['DUS41'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['DUS41'] + "</td>"; //Project
                    }

                    aux=monitor[i]['DUW20'];
                    motivo = monitor[i]['_amx_10'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['DUW20'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['DUW20'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['DUW20'] + "</td>"; //Asp
                    }

                    aux=monitor[i]['DUW30'];
                    motivo = monitor[i]['_amx_11'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['DUW30'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['DUW30'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['DUW30'] + "</td>"; //Asp
                    }

                    aux=monitor[i]['DUW31'];
                    motivo = monitor[i]['_amx_12'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['DUW31'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['DUW31'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['DUW31'] + "</td>"; //Country
                    }

                    aux=monitor[i]['DUW41'];
                    motivo = monitor[i]['_amx_13'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['DUW41'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['DUW41'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['DUW41'] + "</td>"; //Customer
                    }

                    aux=monitor[i]['RBS2106'];
                    motivo = monitor[i]['_amx_14'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RBS2106'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RBS2106'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RBS2106'] + "</td>"; //Project
                    }

                    aux=monitor[i]['RBS2106i'];
                    motivo = monitor[i]['_amx_15'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RBS2106i'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RBS2106i'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RBS2106i'] + "</td>"; //Asp
                    }

                    aux=monitor[i]['RBS2111'];
                    motivo = monitor[i]['_amx_16'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RBS2111'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RBS2111'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RBS2111'] + "</td>"; //Asp
                    }

                    aux=monitor[i]['RBS2111 PBC02'];
                    motivo = monitor[i]['_amx_17'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RBS2111 PBC02'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RBS2111 PBC02'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RBS2111 PBC02'] + "</td>"; //Country
                    }

                    aux=monitor[i]['RBS2111 PBC05'];
                    motivo = monitor[i]['_amx_18'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RBS2111 PBC05'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RBS2111 PBC05'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RBS2111 PBC05'] + "</td>"; //Customer
                    }

                    aux=monitor[i]['RBS2111 SSC02'];
                    motivo = monitor[i]['_amx_19'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RBS2111 SSC02'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RBS2111 SSC02'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RBS2111 SSC02'] + "</td>"; //Project
                    }

                    aux=monitor[i]['RBS2206'];
                    motivo = monitor[i]['_amx_20'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RBS2206'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RBS2206'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RBS2206'] + "</td>"; //Asp
                    }

                    aux=monitor[i]['RBS3106'];
                    motivo = monitor[i]['_amx_21'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RBS3106'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RBS3106'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RBS3106'] + "</td>"; //Asp
                    }

                    aux=monitor[i]['RBS3518 PBC02'];
                    motivo = monitor[i]['_amx_22'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RBS3518 PBC02'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RBS3518 PBC02'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RBS3518 PBC02'] + "</td>"; //Asp
                    }

                    aux=monitor[i]['RBS3518 PBC05'];
                    motivo = monitor[i]['_amx_23'];
                    aux=aux.toUpperCase();
                    if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RBS3518 PBC05'] + "</td>"; //Asp
                    }else if(aux.indexOf('RECHAZADO')>0){
                      table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                              "data-motivo='" + motivo + "'>" + monitor[i]['RBS3518 PBC05'] + "</td>";
                    }else{
                      table += "<td align='center'>" + monitor[i]['RBS3518 PBC05'] + "</td>"; //Asp
                    }
*/
                    table += "<td align='center'>" + monitor[i]['CPL'] + "</td>"; //Country
                    table += "<td align='center'>" + monitor[i]['REVIEWER'] + "</td>"; //Country
                  // EL SALVADOR DESDE AQUI
                }else if(monitor[i]['COUNTRY']=='EL SALVADOR'){//EL SALVADOR
                  table += "<tr>";
                  table += "<td align='center'>" + monitor[i]['COUNTRY'] + "</td>"; //Country
                  table += "<td align='center'>" + monitor[i]['CUSTOMER'] + "</td>"; //Customer
                  table += "<td align='center'>" + monitor[i]['PROJECT'] + "</td>"; //Project
                  table += "<td align='center'>" + monitor[i]['ID'] + "</td>"; //Site Id
                  table += "<td align='center'>" + monitor[i]['SITE NAME'] + "</td>"; //Site Name
                  table += "<td align='center'>" + monitor[i]['DATE'] + "</td>"; //Date
                  table += "<td align='center'>" + monitor[i]['ASP'] + "</td>"; //Asp
                  table += "<td align='center'>" + monitor[i]['LEADER'] + "</td>"; //Leader
                  table += "<td align='center'>" + monitor[i]['ATS/CHECKIN'] + "</td>"; //Country
 
                  aux=monitor[i]['DISASSEMBLY'];
                  //motivo = monitor[i]['_amx_01'];
                  aux=aux.toUpperCase();
                  if(aux.indexOf('POR REVISAR')>0){
                      table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['DISASSEMBLY'] + "</td>"; //Asp
                  }else if(aux.indexOf('RECHAZADO')>0){
                    table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                            "'>" + monitor[i]['DISASSEMBLY'] + "</td>";
                  }else{
                    table += "<td align='center'>" + monitor[i]['DISASSEMBLY'] + "</td>"; //Asp
                  }

                  aux=monitor[i]['INVENTORY'];
                  //motivo = monitor[i]['_amx_01'];
                  aux=aux.toUpperCase();
                  if(aux.indexOf('POR REVISAR')>0){
                      table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['INVENTORY'] + "</td>"; //Asp
                  }else if(aux.indexOf('RECHAZADO')>0){
                    table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                            "'>" + monitor[i]['INVENTORY'] + "</td>";
                  }else{
                    table += "<td align='center'>" + monitor[i]['INVENTORY'] + "</td>"; //Asp
                  }

                  aux=monitor[i]['EQUIPMENT'];
                  //motivo = monitor[i]['_amx_01'];
                  aux=aux.toUpperCase();
                  if(aux.indexOf('POR REVISAR')>0){
                      table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['EQUIPMENT'] + "</td>"; //Asp
                  }else if(aux.indexOf('RECHAZADO')>0){
                    table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                            "'>" + monitor[i]['EQUIPMENT'] + "</td>";
                  }else{
                    table += "<td align='center'>" + monitor[i]['EQUIPMENT'] + "</td>"; //Asp
                  }

                  aux=monitor[i]['MDR'];
                  //motivo = monitor[i]['_amx_01'];
                  aux=aux.toUpperCase();
                  if(aux.indexOf('POR REVISAR')>0){
                      table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['MDR'] + "</td>"; //Asp
                  }else if(aux.indexOf('RECHAZADO')>0){
                    table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                            "'>" + monitor[i]['MDR'] + "</td>";
                  }else{
                    table += "<td align='center'>" + monitor[i]['MDR'] + "</td>"; //Asp
                  }

                  aux=monitor[i]['PRE RF'];
                  //motivo = monitor[i]['_amx_01'];
                  aux=aux.toUpperCase();
                  if(aux.indexOf('POR REVISAR')>0){
                      table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['PRE RF'] + "</td>"; //Asp
                  }else if(aux.indexOf('RECHAZADO')>0){
                    table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                            "'>" + monitor[i]['PRE RF'] + "</td>";
                  }else{
                    table += "<td align='center'>" + monitor[i]['PRE RF'] + "</td>"; //Asp
                  }

                  aux=monitor[i]['POST RF'];
              
                  //motivo = monitor[i]['_amx_01'];
                  aux=aux.toUpperCase();
                  if(aux.indexOf('POR REVISAR')>0){
                      table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['POST RF'] + "</td>"; //Asp
                  }else if(aux.indexOf('RECHAZADO')>0){
                    table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                            "'>" + monitor[i]['POST RF'] + "</td>";
                  }else{
                    table += "<td align='center'>" + monitor[i]['POST RF'] + "</td>"; //Asp
                  }

                  aux=monitor[i]['RED GREEN'];
                  //motivo = monitor[i]['_amx_01'];
                  aux=aux.toUpperCase();
                  if(aux.indexOf('POR REVISAR')>0){
                      table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['RED GREEN'] + "</td>"; //Asp
                  }else if(aux.indexOf('RECHAZADO')>0){
                    table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                            "'>" + monitor[i]['RED GREEN'] + "</td>";
                  }else{
                    table += "<td align='center'>" + monitor[i]['RED GREEN'] + "</td>"; //Asp
                  }

                  aux=monitor[i]['ATP'];
                  //motivo = monitor[i]['_amx_01'];
                  aux=aux.toUpperCase();
                  if(aux.indexOf('POR REVISAR')>0){
                      table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['ATP'] + "</td>"; //Asp
                  }else if(aux.indexOf('RECHAZADO')>0){
                    table += "<td class='bg_cell_red_ text-center has-popover' style='color: #ffffff;'" +
                            "'>" + monitor[i]['ATP'] + "</td>";
                  }else{
                    table += "<td align='center'>" + monitor[i]['ATP'] + "</td>"; //Asp
                  }

                  table += "<td align='center'>" + monitor[i]['REVIEWER'] + "</td>"; //Country
                  }else{
                    //No hace Nada fin de la parte de EL SALVADOR
                  }
                }
                table += "</table>";
                return table;
            }
        })

        function createTableDetail(monitor,seeDetail){
            var table;
            var idproyectos = {{idproyectos}};
            if (seeDetail == 0){
              if (monitor.length >0) {
                  table = '<table id="tablaDetail" class="table table-bordered table-hover table-striped table-responsive">';
                  table += "<thead class='tabledetail'><tr>";
                  table += "<th style='vertical-align:middle;' class='text-center'>#</th>";
                  table += "<th style='vertical-align:middle;' class='text-center'>ARCHIVO</th>";
                  table += "<th style='vertical-align:middle;' class='text-center'>FECHA</th>";
                  table += "</tr></thead>";
                  var strLast="";
                  for (var i = 0; i < monitor.length; i++) {
                      isLast = monitor[i]['isLast'];
                      if (isLast==1) {strLast="*"}else{strLast='';}
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (i+1 ) + "</td>";
                      table += "<td class='text-left'><a target='_blank' href='"
                              + monitor[i]['path'] + "'>"
                              +"<span class='glyphicon glyphicon-file' aria-hidden='true'></span>&nbsp;" +
                              monitor[i]['filename'] + strLast+ "</a></td>";
                      table += "<td class='text-center' nowrap>" + monitor[i]['fecha'] + "</td>";
                      table += "</tr>";

                  }
                  table += "</table>";
              } //FIN DEL IF seeDetail = 0
            }else{
              if (monitor.length >0) {
                  table = '<table width="1100" id="tablaDetail" class="table table-bordered table-hover table-striped table-responsive">';
                  table += "<thead class='tabledetail'><tr>";
                  table += "<th style='vertical-align:middle;' class='text-center'>#</th>";
                  table += "<th style='vertical-align:middle;' class='text-center'>DELIVERABLE</th>";
                  table += "<th style='vertical-align:middle;' class='text-center'>CONDITION</th>";
                  table += "<th style='vertical-align:middle;' class='text-center'>REASON FOR REJECTION</th>";
                  table += "<th style='vertical-align:middle;' class='text-center'>REVIEWER</th>";
                  table += "<th style='vertical-align:middle;' class='text-center'>DATE</th>";
                  table += "</tr></thead>";
                  var strLast="";
                  for (var i = 0; i < monitor.length; i++) {
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (1) + "</td>";

                      aux=monitor[i]['_DUG20'];
                      motivo = monitor[i]['_amx_07'];
                      aux=aux.toUpperCase();
                      console.log(aux);
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>DUG20</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_DUG20'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>DUG20</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_DUG20'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>DUG20</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_DUG20'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>DUG20</td>";
                        table += "<td align='center'>-</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>";
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (2) + "</td>";
                      aux=monitor[i]['_DUS31'];
                      motivo = monitor[i]['_amx_08'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>DUS31</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_DUS31'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>DUS31</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_DUS31'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>DUS31</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_DUS31'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>DUS31</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (3) + "</td>";
                      aux=monitor[i]['_DUS41'];
                      motivo = monitor[i]['_amx_09'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>DUS41</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_DUS41'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>DUS41</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_DUS41'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>DUS41</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_DUS41'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>DUS41</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (4) + "</td>";
                      aux=monitor[i]['_DUW20'];
                      motivo = monitor[i]['_amx_10'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>DUW20</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_DUW20'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>DUW20</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_DUW20'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>DUW20</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_DUW20'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>DUW20</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (5) + "</td>";
                      aux=monitor[i]['_DUW30'];
                      motivo = monitor[i]['_amx_11'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>DUW30</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_DUW30'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>DUW30</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_DUW30'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>DUW30</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_DUW30'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>DUW30</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (6) + "</td>";
                      aux=monitor[i]['_DUW31'];
                      motivo = monitor[i]['_amx_12'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>DUW31</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_DUW31'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>DUW31</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_DUW31'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>DUW31</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_DUW31'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>DUW31</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (7) + "</td>";
                      aux=monitor[i]['_DUW41'];
                      motivo = monitor[i]['_amx_13'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>DUW41</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_DUW41'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>DUW41</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_DUW41'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>DUW41</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_DUW41'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>DUW41</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (8) + "</td>";
                      aux=monitor[i]['_RBS2106'];
                      motivo = monitor[i]['_amx_14'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>RBS2106</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_RBS2106'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>RBS2106</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_RBS2106'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>RBS2106</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_RBS2106'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>RBS2106</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (9) + "</td>";
                      aux=monitor[i]['_RBS2106i'];
                      motivo = monitor[i]['_amx_15'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>RBS2106i</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_RBS2106i'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>RBS2106i</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_RBS2106i'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>RBS2106i</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_RBS2106i'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>RBS2106i</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (10) + "</td>";
                      aux=monitor[i]['_RBS2111'];
                      motivo = monitor[i]['_amx_16'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>RBS2111</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_RBS2111'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>RBS2111</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_RBS2111'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>RBS2111</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_RBS2111'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>RBS2111</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (11) + "</td>";
                      aux=monitor[i]['_RBS2111 PBC02'];
                      motivo = monitor[i]['_amx_17'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>RBS2111 PBC02</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_RBS2111 PBC02'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>RBS2111 PBC02</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_RBS2111 PBC02'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>RBS2111 PBC02</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_RBS2111 PBC02'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>RBS2111 PBC02</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (12) + "</td>";
                      aux=monitor[i]['_RBS2111 PBC05'];
                      motivo = monitor[i]['_amx_18'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>RBS2111 PBC05</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_RBS2111 PBC05'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>RBS2111 PBC05</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_RBS2111 PBC05'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>RBS2111 PBC05</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_RBS2111 PBC05'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>RBS2111 PBC05</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (13) + "</td>";
                      aux=monitor[i]['_RBS2111 SSC02'];
                      motivo = monitor[i]['_amx_19'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>RBS2111 SSC02</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_RBS2111 SSC02'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>RBS2111 SSC02</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_RBS2111 SSC02'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>RBS2111 SSC02</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_RBS2111 SSC02'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>RBS2111 SSC02</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (14) + "</td>";
                      aux=monitor[i]['_RBS2206'];
                      motivo = monitor[i]['_amx_20'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>RBS2206</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_RBS2206'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>RBS2206</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_RBS2206'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>RBS2206</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_RBS2206'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>RBS2206</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (15) + "</td>";
                      aux=monitor[i]['_RBS3106'];
                      motivo = monitor[i]['_amx_21'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>RBS3106</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_RBS3106'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>RBS3106</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_RBS3106'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>RBS3106</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_RBS3106'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>RBS3106</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (16) + "</td>";
                      aux=monitor[i]['_RBS3518 PBC02'];
                      motivo = monitor[i]['_amx_22'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>RBS3518 PBC02</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_RBS3518 PBC02'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>RBS3518 PBC02</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_RBS3518 PBC02'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>RBS3518 PBC02</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_RBS3518 PBC02'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>RBS3518 PBC02</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";
                      table += "<tr>";
                      table += "<td class='text-center' nowrap>" + (17) + "</td>";
                      aux=monitor[i]['_RBS3518 PBC05'];
                      motivo = monitor[i]['_amx_23'];
                      aux=aux.toUpperCase();
                      if(aux.indexOf('POR REVISAR')>0){
                        table += "<td class='text-center' nowrap>RBS3518 PBC05</td>";
                        table += "<td class='bg_cell_yellow_ text-center'>" + monitor[i]['_RBS3518 PBC05'] + "</td>"; //Asp
                        table += "<td class='text-center' nowrap>-</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('RECHAZADO')>0){
                        table += "<td class='text-center' nowrap>RBS3518 PBC05</td>";
                        table += "<td class='bg_cell_red_ text-center' style='color: #ffffff;'" + "'>" + monitor[i]['_RBS3518 PBC05'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ motivo +"</td>";
                        table += "<td class='text-center' nowrap>" + monitor[i]['REVIEWER'] + "</td>";
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else if(aux.indexOf('APROBADO')>0){
                        table += "<td class='text-center' nowrap>RBS3518 PBC05</td>";
                        table += "<td class=''text-center' nowrap'" + "'>" + monitor[i]['_RBS3518 PBC05'] + "</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>"+ monitor[i]['REVIEWER'] +"</td>"; //Country
                        table += "<td class='text-center' nowrap>"+ monitor[i]['DATE'] +"</td>";
                      }else{
                        table += "<td class='text-center' nowrap>RBS3518 PBC05</td>";
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                        table += "<td align='center'>-</td>"; //Country
                      }
                      table += "</tr>";

                  }
                  table += "</table>";
              } //FIN DEL IF seeDetail = 1
            }

            return table;
        }

        function reporteBateriaDetail(ticket,sitio,entregable,seeDetail) {
            data = {};
            data['ticket'] = ticket;
            data['sitio'] = sitio;
            data['entregable'] = entregable;
            data['seeDetail'] = seeDetail;

            $.getJSON('{{path('reportAmx_reporteMonitorAmxImplementASPDetail')}}', data, function (data) {
                var bateria = data.bateria;
                if (bateria.length == 0) {
                    $("#reporte_detail").empty();
                    $("#reporte_detail").append('<div class="alert alert-warning" role="alert">NO SE HA ENCONTRADO DATA</div>');
                    $.isLoading("hide");
                    return false;
                }
                if (seeDetail == 0){
                    $('#myModalLabel').html("DETALLE " + bateria[0]['entregable']);
                }else{
                  $('#myModalLabel').html("DETALLES VARIOS CPL");
                }
                $("#reporte_detail").empty().append(createTableDetail(bateria,seeDetail));
                $.isLoading("hide");
            })
            return true;
        }

        function _detail(ticket,site,entregable,seeDetail){
            $('#myModalLabel').html("");
            $("#reporte_detail").empty();
            $.isLoading({
                text:       "Loading, Please Wait"
            });
            reporteBateriaDetail(ticket,site,entregable,seeDetail);
            $('#myModalDetalle').modal('show');
        }
    </script>
    <div class="row">
        <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
            <img id="logo" class="pull-right" src="{{ asset('images/claro.jpg') }}"  width="220" height="72" />
        </div>
    </div>
    <div class="row">
        <div class="col-md-4 form-group">
            <label for="cmbCountry">{{'monitores.pais' | trans}}: </label>
            <select class="form-control" id="cmbCountry" name="cmbCountry">
                <!-- <option value="TODOS">{{"inbox.all" | trans}}</option> -->
                {%for country in countries%}
                    <option value="{{country.id}}">{{country.name}}</option>
                {%endfor%}
            </select>
        </div>
        <div class="col-md-3 form-group">
            <label for="txtStartDate">{{'monitor.etiqueta.fechaI' | trans}}: </label>
            <input type="text" class="form-control" id="txtStartDate" name="txtStartDate" value="">
        </div>
        <div class="col-md-3 form-group">
            <label for="txtEndDate">{{'monitor.etiqueta.fechaF' | trans}}: </label>
            <input type="text" class="form-control" id="txtEndDate" name="txtEndDate" value="">
        </div>
        <div class="col-md-2 col-sm-2 form-group">
            <label for="btnGenerate">&nbsp;&nbsp;&nbsp;&nbsp;</label>
            <button class="btn btn-claro form-control" id="btnGenerate"><strong>{{'ticketDetail.boton.generar' | trans}}</strong></button>
        </div>
    </div>
    {#<div class="row">
        <div class="col-md-3 form-group">
            <label for="cmbProject">{{'monitores.proyecto' | trans}}: </label>
            <select class="form-control" id="cmbProject" name="cmbProject">
                <option value="TODOS">-- All --</option>
            </select>
        </div>
        <div class="col-md-3 form-group">
            <label for="cmbAsp">{{'ASP' | trans}}: </label>
            <select class="form-control" id="cmbAsp" name="cmbAsp">
                <option value="TODOS">-- All --</option>
            </select>
        </div>
        <div class="col-md-3 form-group">
            <label for="btnGenerate">&nbsp;&nbsp;&nbsp;&nbsp;</label>
            <button class="btn btn-primary form-control" id="btnGenerate"><strong>{{'ticketDetail.boton.generar' | trans}}</strong></button>
        </div>
        <div class="col-md-3">
            &nbsp;
        </div>
    </div>#}
    <div class="row">
        <div id="title" class="col-md-12 text-center">
            <h2><strong>DELIVERABLES IMPLEMENTATION</strong></h2>
        </div>
    </div>
    <br>
    <br>
    <div class="row">
        <div class="col-lg-12" id="chart1">
        </div>

    </div>
    <div class="container-fluid">
        <div class="row">
            <div class="pager col-lg-3" style="text-align: left">
                {{"Cantidad" | trans}}: <span id="quantity" class="pagedisplay"></span>
            </div>
            <div class="col-lg-offset-9 col-md-offset-9 download">
                <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 class="listD"><a href="#" onclick="$('#primer_reporte').tableExport({type: 'excel', escape: 'false'});">
                                <img src={{ asset("images/xls.png")}} width="24px"> XLS
                            </a>
                      </li>
                    </ul>
                </div>
            </div>
        </div>
        <div class="row" style="overflow-x: auto;">
            <div id="primer_reporte" class="col-lg-12"></div>
        </div>
        <div class="row">
            <div id="pager" class="pager col-lg-12" 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 selected="selected" value="1000">1000</option>
                        <option  value="500">500</option>
                        <option  value="100">100</option>
                    </select>
                </form>
            </div>
        </div>
    </div>

    <div class="modal fade" id="myModalDetalle" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header  bg-primary">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                    <h2 class="modal-title text-center" id="myModalLabel">DETALLE</h2>
                </div>

                <div class="modal-body">
                    <div class="row" style="overflow-x: auto;">
                        <div id="reporte_detail" class="col-md-12"></div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">{{'monitorii.close' | trans}}</button>

                </div>

            </div>
        </div>
    </div>
{% endblock %}