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

{% endblock %}

{% block dashboard %}
    <style>
        .text-global {

            margin-top: 10px;
        }

        .huge {
            font-size: 25px;
        }

        .panel-green {
            border-color: #5cb85c;
        }

        .panel-green .panel-heading {
            border-color: #5cb85c;
            color: #fff;
            background-color: #5cb85c;
        }

        .panel-green a {
            color: #5cb85c;
        }

        .panel-green a:hover {
            color: #3d8b3d;
        }

        .panel-red {
            border-color: #d9534f;
        }

        .panel-red .panel-heading {
            border-color: #d9534f;
            color: #fff;
            background-color: #d9534f;
        }

        .panel-red a {
            color: #d9534f;
        }

        .panel-red a:hover {
            color: #b52b27;
        }

        .panel-yellow {
            border-color: #f0ad4e;
        }

        .panel-yellow .panel-heading {
            border-color: #f0ad4e;
            color: #fff;
            background-color: #f0ad4e;
        }

        .panel-yellow a {
            color: #f0ad4e;
        }

        .panel-yellow a:hover {
            color: #df8a13;
        }

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

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

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

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

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

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

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

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

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

        .wrapper {
            padding-bottom: 50px;
        }

        .header {
            background: #000000;
        }

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

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

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

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

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

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

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

        pre, .well {
            background: #FFFFFF;
        }

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

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

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

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

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

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

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

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

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

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

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

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

        .file-area input[type=file]:valid + .file-dummy .default {
            display: none;
        }

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

        a span{
            margin-left: 5% !important;
        }

        td span{
            margin-left: 5% !important;
        }

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

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

        #menuTop {
            margin-top: 30px;
        }

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

        h1 {
            font-size: 36px;
        }

        .tablesorter-header-inner, table.tablesorter thead tr th, .tablesorter-filter {
            color: #fff;
            background-color: #082a99;
            border-color: #2643a5;

        }

        table.tablesorter thead tr th {

            height: 40px;
        }

        .tablesorter-blue .headerSortUp, .tablesorter-blue .tablesorter-headerSortUp, .tablesorter-blue .tablesorter-headerAsc {
            background-color: #082a99;
        }

        .tablesorter-blue .headerSortDown, .tablesorter-blue .tablesorter-headerSortDown, .tablesorter-blue .tablesorter-headerDesc {
            background-color: #082a99;
        }

        .tablesorter-blue .tablesorter-filter-row td {
            background: #2643a5;
        }

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


        .form-group {
          display: block;
          margin-bottom: 15px;
        }

        .form-group input {
          padding: 0;
          height: initial;
          width: initial;
          margin-bottom: 0;
          display: none;
          cursor: pointer;
        }

        .form-group label {
          position: relative;
          cursor: pointer;
        }

        .form-group label:before {
          content:'';
          -webkit-appearance: none;
          background-color: transparent;
          border: 2px solid #0079bf;
          box-shadow: 0 1px 2px rgba(0, 0, 0, 0.05), inset 0px -15px 10px -12px rgba(0, 0, 0, 0.05);
          padding: 10px;
          display: inline-block;
          position: relative;
          vertical-align: middle;
          cursor: pointer;
          margin-right: 5px;
        }

        .form-group input:checked + label:after {
          content: '';
          display: block;
          position: absolute;
          top: 2px;
          left: 9px;
          width: 6px;
          height: 14px;
          border: solid #0079bf;
          border-width: 0 2px 2px 0;
          transform: rotate(45deg);
        }

    </style>
    <script src="{{asset('js/jquery.isloading.js')}}" type="text/javascript"></script>
    <script src="{{asset('js/jquery.doubleScroll.js')}}" type="text/javascript"></script>
    <script src="{{ asset('js/tableExport.js') }}"></script>
    <script src="{{ asset('js/jquery.base64.js') }}"></script>
    <script>

        $(function () {

            $('#generar').prop("disabled", true);
            $('#project').prop("disabled", true);

            var intervalTime = null;
            $("#autoload").click(function(){
                var time = parseInt($("#time").val());
                if($(this).prop('checked')){
                    intervalTime  =  window.setInterval(getReporte, time);
                }else{
                    clearInterval(intervalTime);
                }
            });

            function intervalReport(fun,time){

            }

            $('.datepicker').datepicker({
                dateFormat: 'yy-mm-dd',
                maxDate: new Date(),
                defaultDate: new Date(),
            }).datepicker("setDate", new Date());

            $("#type").change(function(){
                if($(this).val() == 1){
                    $("#chart1").show();
                    $("#chart3").hide();
                }else{
                    $("#chart1").hide();
                    $("#chart3").show();
                }
            });

            var starYear = 2017;
            var d = new Date();
            var year = d.getFullYear();
            var month = new Array();

            $(".checklist").live('click', function () {
                window.location.href = $(this).attr('href');
            });

        for(var i=starYear; year >= i;i++ )
        {
            $('#ano').append($("<option/>", {
                value: i,
                text: i
            }));
        }

            month[0] = "January";
            month[1] = "February";
            month[2] = "March";
            month[3] = "April";
            month[4] = "May";
            month[5] = "June";
            month[6] = "July";
            month[7] = "August";
            month[8] = "September";
            month[9] = "October";
            month[10] = "November";
            month[11] = "December";
            var n = month[d.getMonth()];
            var options = new Array();

            for(var i=0;i<month.length;i++){
                if(i <=  d.getMonth()){
                    $('#mes').append($("<option/>", {
                        value: i + 1,
                        text: month[i]
                    }));
                }
            }

            $("#ano").change(function(){
                var yearSelected = parseInt($(this).val());
                var semana = ISO8601_week_no(new Date());

                $('#mes').empty();
                for(var i=0;i<month.length;i++) {
                    if (yearSelected < year) {
                        $('#mes').append($("<option/>", {
                            value: i + 1,
                            text: month[i]
                        }));
                    }else if(i <=  d.getMonth()){
                        $('#mes').append($("<option/>", {
                            value: i + 1,
                            text: month[i]
                        }));

                    }
                }
                $('#semana').empty();

                    if (yearSelected < year) {
                            var semana = 52;
                        for(var i=semana;i>=1;i--){

                            $('#semana').append($("<option/>", {
                                value: i,
                                text: i
                            }));
                        }

                    }else{

                        for(var i=semana;i>=1;i--){

                            $('#semana').append($("<option/>", {
                                value: i,
                                text: i
                            }));
                        }
                    }

            });

            $("#accion").change(function ()
            {
                var t=$(this).closest(".row");
                if (t.find('select#accion').val() == 'Rechazar'){
                    t.find('select#RechazarComentario').show();
                    t.find('select#ValidarComentario').hide();
                }else{
                    t.find('select#ValidarComentario').show();
                    t.find('select#RechazarComentario').hide();
                    t.find('#div_comentario').hide();
                }
            });

            $("select#RechazarComentario").change(function ()
            {
                var t=$(this).closest(".row");
                if (t.find('select#RechazarComentario').val() == 'Otro'){
                    t.find('#div_comentario').show();
                }else{
                    t.find('#div_comentario').hide();
                }
            });

            $("select#ValidarComentario").change(function ()
            {
                var t=$(this).closest(".row");
                if (t.find('select#ValidarComentario').val() == 'Otro'){
                    t.find('#div_comentario').show();
                }else{
                    t.find('#div_comentario').hide();
                }
            });

            //para multiples envios de reportes pre plan
            $(".accion").change(function ()
            {
                var t=$(this).closest(".row");
                if (t.find('.accion').val() == 'Rechazar'){
                    t.find('.RechazarComentario').show();
                    t.find('.ValidarComentario').hide();
                }else{
                    t.find('.ValidarComentario').show();
                    t.find('.RechazarComentario').hide();
                    t.find('.div_comentario').hide();
                }
            });

            $(".RechazarComentario").change(function ()
            {
                var t=$(this).closest(".row");
                if (t.find('.RechazarComentario').val() == 'Otro'){
                    t.find('.div_comentario').show();
                }else{
                    t.find('.div_comentario').hide();
                }
            });

            $(".ValidarComentario").change(function ()
            {
                var t=$(this).closest(".row");
                if (t.find('.ValidarComentario').val() == 'Otro'){
                    t.find('.div_comentario').show();
                }else{
                    t.find('.div_comentario').hide();
                }
            });

            $("#tipoBusqueda").on('change load',function(){

                $(this).val() == 'mes' ? $("#mes").removeAttr('class','hide'):$("#mes").addClass('hide');
                $(this).val() == 'semana' ? $("#semana").removeAttr('class','hide'):$("#semana").addClass('hide');
                $(this).val() == 'dia' ? $("#dia").removeClass('hide'):$("#dia").addClass('hide');
            });

            $("#generar").click(function(){
                if($("#client").val() == "" || $("#project").val() == ""
                        || $("#tipoBusqueda").val() == ""|| $("#tipoBusqueda").val() == "") return false;
                /*$.isLoading({
                    text:       "Loading"
                });*/
                getReporte();
            });

            $('#client').change(function(){
                console.log('Ruta: {{ path("proyectos_preplan") }}');
                var $proyect_select = $('#project');
                var data = {
                    cliente_id: $(this).val()
                };
                if ( $(this).val() == ''){
                    $proyect_select.empty();
                    $proyect_select.html("<option value=''>{{ 'Selected Project' | trans }}</option>");
                    $('#generar').prop("disabled", true);
                    $('#project').prop("disabled", true);
                }else{

                    $.isLoading({
                        text: 'Loading',
                    });
                    $.ajax({
                        type: 'post',
                        url: '{{ path("proyectos_preplan") }}',
                        data: data,
                        success: function(data) {

                            $proyect_select.html("<option value=''>{{ 'Selected Project' | trans }}</option>");
                            $('#project').removeAttr("disabled");
                            $('#generar').removeAttr("disabled");
                            for (var i = 0, total = data.length; i < total; i++) {
                                $proyect_select.append('<option value="'+ data[i].idproceso+"|"+data[i].idproyectos_interno+"|"+data[i].idestados+'">' + data[i].proyecto + '</option>');
                            }
                            if(data.length > 0){
                                $('#idprojecInterno').val(data[0].idproyectos_interno);
                                $('#idprojecInterno1').val(data[0].idproyectos_interno);
                                $('.proyectoInterno').val(data[0].idproyectos_interno);
                                $('#idestados').val(data[0].idestados);
                            }
                            $.isLoading('hide');
                        }
                    });

                }
            });

            $('#project').change(function(){
                //var data = {};
                //data['project']=$("#project").val();
                //$.getJSON('{{path('reportepreplanmx_llenarProyectoIdestados')}}',data, function (data) {
                        var datos=$("#project").val().split('|');
                        var idprojecInterno  = datos[1];
                        var idestados  = datos[2];
                        $('#idprojecInterno').val(idprojecInterno);
                        $('#idprojecInterno1').val(idprojecInterno);
                        $('.proyectoInterno').val(idprojecInterno);
                        $('#idestados').val(idestados);
                        //console.log("PROYECTO INTERNO: " + idprojecInterno)
                  //  });         
            
            });
        });

        function myFunction(index , idelment) {
          // Declare variables
          var input, filter, table, tr, td, i, tmpstr;

          input = document.getElementById('id'+index+'id');
         //   index =index-1;
          filter = input.value.toUpperCase();
          table = document.getElementById("tabla1");
          tr = table.getElementsByTagName("tr");

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

           td = tr[i].getElementsByTagName("td")[index];

            if (td) {
                tmpstr = td.innerHTML.toUpperCase();
              if (tmpstr.search(filter) > -1) {
                       tr[i].style.display = "";
              } else {
                  if(i>1)
                  {
                      tr[i].style.display = "none";
                  }

              }
            }
          }
        }

        function getParamData(){
            data = {};
            var tipo  = $("#tipoBusqueda").val();
            switch (tipo){
                case 'semana':
                    data = {'semana': $("#semana").val()}
                    break;
                case 'mes':
                    data = {'mes' : $("#mes").val()}
                    break;
                case 'dia':
                    data = {'dia' : $("#dia").val()}
                    break;
            }
            var datos = $("#project").val().split('|');
            data['ano'] = $("#ano").val();
            data['project'] = $("#client").val();
            data['idproceso'] = datos[0];
            $(".id_proceso").val(datos[0]);
            data['idestados'] = datos[2];
            data['idproyectoInt'] = datos[1];
            return data;
        }

        function getReporteChart(d){
            var datos = (d == undefined) ? getParamData() : d;

            /*$( "#divcharts" ).isLoading({
                text:       "Loading Charts",
                position:   "inside"
            });*/
            /*$( "#chart2" ).isLoading({
                text:       "Loading Chart 2",
                position:   "inside"
            });*/
            $.ajax({
                type: 'GET',
                url: "{{ path('reportepreplanmx_getDetailChart') }}",
                data: datos,
                dataType: 'json',
                success: function (data) {
                    var chart1 = data.chart1;
                    if(chart1.length == 0){
                        $('#chart1').empty();
                        $('#chart2').empty();
                    }else{
                        createColumnChart('chart1', 'Validations Deliverables By Region', chart1);

                        var total = getTotal(chart1, [1, 2, 3, 4], 0);
                        total.shift();
                        var header = Object.keys(chart1[0]);

                        var AuxArray = new Array();

                        //  for(var i=1;i<header.length;i++){
                        // console.log(parseInt(total[i-1]));
                        AuxArray.push({'estado': header[1], 'Entregables': parseInt(total[1 - 1])});
                        AuxArray.push({'estado': header[2], 'Entregables': parseInt(total[2 - 1])});
                        AuxArray.push({'estado': header[3], 'Entregables': parseInt(total[3 - 1])});
                        AuxArray.push({'estado': header[4], 'Entregables': parseInt(total[4 - 1])});
                        //   }

                        createColumnChart('chart2', 'Validations Deliverables', AuxArray);
                        //console.log(total);
                        //$('#divcharts').isLoading( "hide" );
                        //$('#chart2').isLoading( "hide" );
                    }
                },
                error: function (jqXHR, textStatus, errorThrown) {
                    //$('#divcharts').isLoading( "hide" );
                    //$('#chart2').isLoading( "hide" );
                }
            });
        }

        function getReporteMonitor(d){
            var datos = (d == undefined) ? getParamData() : d;

            $.isLoading("hide");
            $.isLoading({text: "Loading Data"});
            $('#reporte1').empty();
            $.ajax({
                type: 'GET',
                url: "{{ path('reportepreplanmx_getDetailMonitor') }}",
                data: datos,
                dataType: 'json',
                success: function (data) {
                    //console.log (data);
                    var monitor = data.monitor;
                    var material = data.materialC;
                    var validacion = data.validacion;
                    var validacionSDE = data.validacionSDE;
                    var prInterno = $('#idprojecInterno').val();
                    if(monitor.length == 0){
                        $("#reporte1").empty();
                        $("#reporte1").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                        $.isLoading("hide");
                        $("#inicio").show();
                        return false;
                    }
                    if (material.length>0) {
                        var headerMaterial = Object.keys(material[0]);
                        var materialAux = new Array();
                        var entregableAux2 = [];

                        for (var i = 0; material.length > i; i++) {
                            var c = {
                                "SIN INVENTARIO": material[i]['SIN INVENTARIO'],
                                "NO": material[i]['NO'],
                                "FALTANTE": material[i]['FALTANTES'],
                                "DISPONIBILIDAD": material[i]['DISPONIBILIDAD']
                            };
                            var objeto = {"idticket": material[i]['idticket'], data: c};
                            materialAux['T' + material[i]['idticket']] = objeto;
                        }
                    }
                    var objectType = {'9': 1, '10': 2, '11': 3, '12': 4, '13': 5, '14': 6};
                    $('#reporte1').empty().append(createTable(monitor, materialAux, prInterno, undefined, undefined, objectType,validacion, validacionSDE));
                    $('.double-scroll').doubleScroll();

                    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: 'Rows : {endRow}',
                        // 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: true
                        }
                    }).tablesorterPager(pagerOptions);
                    $(".pager").show();
                    $("#inicio").show();
                    $("#autoload").attr('disabled',false);
                    // $('#btn_enviarPlan').show();*/
                    $.isLoading( "hide" );
                },
                error: function (jqXHR, textStatus, errorThrown) {
                    $.isLoading( "hide" );
                }
            });
        }

        function getReporte(){
            /*data = {};
            var tipo  = $("#tipoBusqueda").val();
            switch (tipo){
                case 'semana':
                    data = {'semana': $("#semana").val()}
                    break;
                case 'mes':
                    data = {'mes' : $("#mes").val()}
                    break;
                case 'dia':
                    data = {'dia' : $("#dia").val()}
                    break;
            }
            //data['idinterno'] = $("#idprojecInterno").val();
            var datos = $("#project").val().split('|');
            data['ano'] = $("#ano").val();
            data['project'] = $("#client").val();
            data['idproceso'] = datos[0];
            $(".id_proceso").val(datos[0]);
            data['idestados'] = $("#idestados").val();
            data['idproyectoInt'] = datos[1];*/
            var data = getParamData();


            {% if is_granted('ROLE_VALIDACION_CLIENTE_2')  %}
                var ruta = `{{path('reportpreplanmx_DownloadSitiosValidated2')}}?ano=${data['ano']}&project=${data['project']}&idproceso=${data['idproceso']}&idestados=${data['idestados']}&idproyectoInt=${data['idproyectoInt']};`
                $(".downloadTemplate2").attr("href", ruta);
            {%elseif is_granted('ROLE_VALIDACION_CLIENTE_1')%}
                var ruta = `{{path('reportpreplanmx_DownloadSitiosValidated')}}?ano=${data['ano']}&project=${data['project']}&idproceso=${data['idproceso']}&idestados=${data['idestados']}&idproyectoInt=${data['idproyectoInt']};`
                $(".downloadTemplate").attr("href", ruta);
            {%endif%}

            //$.when(getReporteMonitor(data), getReporteChart(data));

            getReporteMonitor(data);
            getReporteChart(data);

        }

        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= 1;j<header.length;j++){

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


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

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

                    if(i == 0){

                        y[j-1].name = header[j];
                    }
                   y[j-1].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
                        }
                    }
                },

                series: data[1]
            };

            new Highcharts.Chart(segundaGraficaOpt)
        }

        function createPieChart(renderTo,title,chart)
        {
            var data = createArrayToPieChart(chart);
            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 createTable(monitor, material, prInterno, total, nombreColTotal, type,validacion,validacionSDE) {

            var header = Object.keys(monitor[0]);
            var headerType = Object.keys(type);
            var table = '<table  class="table table-bordered table-hover table-striped table-responsive table1" id="tableSitios"> <thead>' +
                        '<tr class="btn-info">';

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

                if (header[j] != 'idticket') {
                    table += '<th class=\'text-center\'>' + header[j] + '</th>';
                }

            }

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


            for (var i = 0; i < monitor.length; i++) {
                table += "<tr id="+monitor[i]['idticket']+">";
                for (var j = 0; j < header.length; j++) {

                    if ($.inArray(j, headerType)) {
                        var typeString = 'id="' + type[j] + '"';

                    }
                    //if (j != 0) {

                        if(header[j] != 'MDR' && header[j] != 'SDE' && header[j] != 'MATERIAL COMPLETO' && header[j] != 'idticket' ){
                           table += '<td ' + typeString + '>' + monitor[i][header[j]] + '</td>';
                        }
                        //columna MDR
                        var MDR = "";
                        if (header[j]==="MDR"){
                            MDR = ""+monitor[i]['MDR']+"";

                            /*nota importante:
                                en esta parte se debe mantener la class fileMDR en la misma posicion antes que todas las demas clases
                            */
                            carga_SDE = false;
                            if (MDR === '<span style="color:#da4f49;margin-left:45%">X</span>') {
                                table += "<td class='text-center'>" + '<a type="button" title="Cargar entregable MDR" style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['idticket']+' class="fileMDR rechazar open-AddFileDialog"> <img src={{ asset("images/xlsx.png")}} width="40px"></a>' + "</td>";

                            }else{

                                 carga_SDE = true;
                                //manejamos el caso de mostrar el boton editar de acuerdo al rol y proceso

                                    var texto = null;
                                    for (var m = 0; m < validacion.length; m++) {
                                        if (validacion[m]['ticket_id'] === monitor[i]['idticket']){
                                            texto = validacion[m]['estado'];
                                            break;
                                        }
                                    }

                                    {% if is_granted('ROLE_VALIDACION_CLIENTE_3')  %}
                                        switch(texto) {
                                            case 'VALIDADO': {
                                            table += '<td class="text-center" ' + typeString + '>' + MDR + '</td>';
                                            }break;
                                            default:{
                                               table += '<td class="text-center" ' + typeString + '>' + MDR + '</td>'; 
                                            }
                                        }
                                    {% elseif is_granted('ROLE_VALIDACION_CLIENTE_2')  %}
                                        switch(texto) {
                                            case 'ENVIADO A PLAN': {
                                                table += '<td class="text-center" ' + typeString + '>' + MDR + '</td>';
                                            }break;
                                            default:{
                                               table += '<td class="text-center" ' + typeString + '>' + MDR + '</td>'; 
                                            }
                                        }
                                    {%elseif is_granted('ROLE_VALIDACION_CLIENTE_1')%}
                                        switch(texto) {
                                            case 'ENVIADO A PLAN': {
                                              table += '<td class="text-center" ' + typeString + '>' + MDR + '</td>';

                                            } break;
                                            case 'VALIDADO': {
                                              table += '<td class="text-center" ' + typeString + '>' + MDR + '</td>';

                                            } break;
                                            default:{ 
                                                table += '<td class="text-center" ' + typeString + '>' + MDR + '<a type="button" style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id="'+monitor[i]['idticket']+'" class="fileMDR open-AddFileDialog editar'+monitor[i]['idticket'] +'"> <img src={{ asset("images/edit.png")}} width="25px"></a></td>';

                                            }
                                        }
                                    {%else%}
                                        switch(texto) {
                                            default:{
                                              table += '<td class="text-center" ' + typeString + '>' + MDR + '</td>';
                                            }
                                        }
                                    {%endif%}
                            }
                        }
                        //COLUMNA SDE
                        var SDE = "";
                        if (header[j]==="SDE"){
                            SDE = ""+monitor[i]['SDE']+"";
                            /*nota importante:
                                en esta parte se debe mantener la class fileSDE en la misma posicion antes que todas las demas clases
                            */
                            //varible para botones sde
                            var puede_enviar_sde = false;

                            if (SDE === '<span style="color:#da4f49;margin-left:45%">X</span>') {

                                    if (carga_SDE){
                                            
                                            table += "<td class='text-center'>" + '<a type="button" title="Cargar entregable SDE" ' +
                                                    'style="cursor:pointer;" data-id='+monitor[i]['idticket'] +
                                                    ' id='+monitor[i]['idticket']+ ' class="fileSDE rechazar open-AddFileDialog">' +
                                                    '<img src={{ asset("images/xlsx.png")}} width="40px"></a>' + "</td>";
                                    }else{
                                        table += "<td class='text-center'>---</td>";
                                    }
                            }else{
                                var pos = SDE.indexOf("SI</span>");
                                var optView = "";
                                if (pos >= 0){
                                    optView = '<a type="button" style="cursor:pointer;" data-id="'+monitor[i]['idticket'] + '" ' +
                                            'title="{{"Ver detalles" | trans}}" ' +
                                            ' id="'+monitor[i]['idticket']+'" class="fileSDE open-AddFileDialog SDE-ViewOnly"> ' +
                                            '<span class="glyphicon glyphicon-new-window" aria-hidden="true"></span></a>';
                                }else{optView='';}

                                puede_enviar_sde = true;
                                //manejamos el caso de mostrar el boton editar de acuerdo al rol y proceso 

                                var texto = null;
                                for (var m = 0; m < validacionSDE.length; m++) {
                                    if (validacionSDE[m]['ticket_id'] === monitor[i]['idticket']){
                                            texto = validacionSDE[m]['estado'];
                                            break;
                                    }
                                }

                                //*************************************************
                                //table += '<td class="text-center" ' + typeString + '>' + SDE + '<a type="button" style="cursor:pointer;" data-id='+monitor[i]['idticket']+' id="'+monitor[i]['idticket']+'" class="fileSDE open-AddFileDialog editar'+monitor[i]['idticket'] +'"> <img src={{ asset("images/edit.png")}} width="25px"></a></td>';
                                //***************************************************
                                {% if is_granted('ROLE_VALIDACION_CLIENTE_3')  %}
                                    switch(texto) {
                                        case 'VALIDADO SDE': {
                                            table += '<td class="text-center" ' + typeString + '>' + SDE +
                                                    '<a type="button" style="cursor:pointer;" ' +
                                                    'data-id="'+monitor[i]['idticket']+'" id="'+monitor[i]['idticket']+'" ' +
                                                    'class="fileSDE open-AddFileDialog editar'+monitor[i]['idticket'] +'"> ' +
                                                    '<img src={{ asset("images/edit.png")}} width="25px"></a></td>';
                                        }break;
                                        default:{
                                            table += '<td class="text-center" ' + typeString + '>' + SDE + optView + '</td>';
                                        }
                                    }
                                {% elseif is_granted('ROLE_VALIDACION_CLIENTE_2')  %}
                                    switch(texto) {
                                        case 'ENVIADO A PLAN SDE': {
                                            table += '<td class="text-center" ' + typeString + '>' + SDE +
                                                    '<a type="button" style="cursor:pointer;" ' +
                                                    'data-id="'+monitor[i]['idticket'] +'" id="'+monitor[i]['idticket']+'" ' +
                                                    'class="fileSDE open-AddFileDialog editar'+monitor[i]['idticket'] +'"> ' +
                                                    '<img src={{ asset("images/edit.png")}} width="25px"></a></td>';
                                        }break;
                                        default:{
                                            table += '<td class="text-center" ' + typeString + '>' + SDE + optView + '</td>';
                                        }
                                    }
                                {%elseif is_granted('ROLE_VALIDACION_CLIENTE_1')%}
                                    switch(texto) {
                                        case 'ENVIADO A PLAN SDE': {
                                            table += '<td class="text-center" ' + typeString + '>' + SDE + optView + '</td>';

                                        } break;

                                        default:{
                                            table += '<td class="text-center" ' + typeString + '>' + SDE +
                                                    '<a type="button" style="cursor:pointer;" data-id="'+monitor[i]['idticket'] + '" ' +
                                                    ' id="'+monitor[i]['idticket']+'" class="fileSDE open-AddFileDialog editar'+monitor[i]['idticket'] +'"> ' +
                                                    '<img src={{ asset("images/edit.png")}} width="25px"></a></td>';
                                        }
                                    }
                                {%else%}
                                    switch(texto) {
                                        default:{
                                            table += '<td class="text-center" ' + typeString + '>' + SDE + optView + '</td>';

                                        }
                                    }
                                {%endif%}
                            }
                        }


                        var VALOR=""
                        if (header[j]==="MATERIAL COMPLETO"){

                            VALOR = ""+monitor[i][header[j]]+"";
                            completo = true;
                            if (VALOR === '<span style="color:#da4f49;margin-left:45%">NO</span>') {
                                //validamos si el material esta completo
                                if (material !== undefined){
                                    var clave = 'T' + monitor[i]['idticket'];
                                    if (material[clave] !== undefined){
                                        aux= material[clave]['data'];
                                        if (aux['SIN INVENTARIO']>0 || aux['NO']>0 || aux['FALTANTES']>0
                                                || aux['DISPONIBILIDAD']==0){
                                            completo = false;
                                        }
                                    }
                                }

                                /*for (var h = 0; h < material.length; h++) {
                                    if ((material[h].idticket == monitor[i]['idticket'])){

                                        if (material[h]['DISPONIBILIDAD'] != 'SI'){
                                            completo = false;
                                            break;
                                        }
                                    }
                                }*/


                                if (completo == true){

                                        table += '<td class="text-center" ' + typeString + '>' +'<span style="color:#2643a5;margin-left:25%">SI - <a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID'] +' class="open-detailModal">Ver Detalle</a></span>';+ '</td>';
                                    }else{

                                        table += '<td class="text-center" ' + typeString + '>' +'<span style="color:#2643a5;margin-left:25%">NO - <a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID'] +' class="open-detailModal">Ver Detalle</a></span>';+ '</td>';
                                }

                            }else {
                                table += '<td ' + typeString + '>' + VALOR + '</td>';

                            }
                        }
                   // }

                    if (j === header.length -3) {
                        var texto = null;
                        for (var k = 0; k < validacion.length; k++) {
                            if (validacion[k]['ticket_id'] === monitor[i]['idticket']){
                                texto = validacion[k]['estado'];
                                break;
                            }
                        }

                        var textoSDE = null;
                        for (var k = 0; k < validacionSDE.length; k++) {
                            if (validacionSDE[k]['ticket_id'] === monitor[i]['idticket']){
                                textoSDE = validacionSDE[k]['estado'];
                                break;
                            }
                        }

                        /*
                        importante mantener las clases para los casos MDR y SDE tal cual se pueden agregar mas clases solo despues de la ultima agregada se hace uso de la posicion de cada clase para la llamada del modal
                        */

                        {% if is_granted('ROLE_VALIDACION_CLIENTE_3')  %}
                            switch(texto) {
                                case 'VALIDADO': {
                                        //caso MDR
                                        table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket']+' id='+monitor[i]['ID'] +' class="btn btn-success MDR open-liberar">Excluir del Plan</a>' + "</td>";
                                                       //caso SDE
                                        if (puede_enviar_sde){
                                                // si esta cargado SDE verifico su estado como el MDR
                                                switch(textoSDE) {
                                                    case 'VALIDADO SDE': { 
                                                        table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID']+' class="btn btn-success SDE open-liberar">Excluir SDE</a>' + "</td>";
                                                    } break;
                                                    default:{
                                                        table += "<td class='text-center'>---</td>";
                                                    } 
                                                }
                                            }else{

                                            table += "<td class='text-center'>---</td>"; 
                                        }
                                        //excluir del plan
                                        table += "<td class='text-center'><div class='form-group'><input data-id='"+monitor[i]['ID'] +"' id='val"+monitor[i]['ID']+"' type='checkbox' name='checkvalid[]' value="+monitor[i]['idticket']+"><label id='valid"+monitor[i][header['ID']]+"' for='val"+monitor[i]['ID']+"'></label></div></td>";
                                        $('#btn_enviarPlan').show();
                                }break;
                                default:{

                                  table += "<td class='text-center'>---</td>";
                                  table += "<td class='text-center'>---</td>";
                                  table += "<td class='text-center'>---</td>";
                                  //$('#btn_enviarPlan').hide();
                                }
                            }
                        {% elseif is_granted('ROLE_VALIDACION_CLIENTE_2')  %}
                            switch(texto) {
                                case 'ENVIADO A PLAN': {
                                        //caso MDR
                                        table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID'] +' class="btn btn-success MDR open-validar">Revisar</a>' + "</td>";
                                        //caso SDE
                                        if (puede_enviar_sde){
                                                // si esta cargado SDE verifico su estado como el MDR
                                                switch(textoSDE) {
                                                    case 'ENVIADO A PLAN SDE': {
                                                        table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID'] +' class="btn btn-success SDE open-validar">Revisar SDE</a>' + "</td>";
                                                    } break;

                                                    case 'VALIDADO SDE': { 
                                                        table += "<td class='text-center'>SDE en Plan</td>";
                                                    } break;

                                                    default:{
                                                        table += "<td class='text-center'>---</td>";
                                                    } 
                                                }
                                            }else{

                                            table += "<td class='text-center'>---</td>"; 
                                        }

                                        //revisar despues de enviado a plan
                                        table += "<td class='text-center'><div class='form-group'><input data-id='"+monitor[i]['ID'] +"'id='val"+monitor[i]['ID']+"' type='checkbox' name='checkvalid[]' value="+monitor[i]['idticket']+"><label id='valid"+monitor[i]['ID']+"' for='val"+monitor[i]['ID']+"'></label></div></td>";

                                        $('#btn_enviarPlan').show();
                                }break;
                                case 'VALIDADO': {
                                     //caso MDR
                                      table += "<td class='text-center'>MDR en Plan</td>";
                                      //caso SDE
                                        if (puede_enviar_sde){
                                                // si esta cargado SDE verifico su estado como el MDR
                                                switch(textoSDE) {
                                                    case 'ENVIADO A PLAN SDE': {
                                                        table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID'] +' class="btn btn-success SDE open-validar">Revisar SDE</a>' + "</td>";
                                                    } break;

                                                    case 'VALIDADO SDE': { 
                                                        table += "<td class='text-center'>SDE EN PLAN</td>";
                                                    } break;

                                                    default:{
                                                        table += "<td class='text-center'>---</td>";
                                                    } 
                                                }
                                            }else{

                                            table += "<td class='text-center'>---</td>"; 
                                        }
                                      table += "<td class='text-center'><img src={{ asset('images/greencheck.png')}} width='20px'></td>";

                                } break;
                                default:{
                                    table += "<td class='text-center'>---</td>";
                                    table += "<td class='text-center'>---</td>";
                                    table += "<td class='text-center'>---</td>";
                                }
                            }
                        {%elseif is_granted('ROLE_VALIDACION_CLIENTE_1')%}
                            switch(texto) {
                                case 'ENVIADO A PLAN': {
                                    //proceso MDR
                                    table += "<td class='text-center'>"+texto+"</td>";
                                    
                                    //proceso para el caso de los SDE

                                    //si esta enviado a plan MDR verifico si esta cargado SDE
                                    if (puede_enviar_sde){
                                            // si esta cargado SDE verifico su estado como el MDR
                                            switch(textoSDE) {
                                                case 'ENVIADO A PLAN SDE': {
                                                    table += "<td class='text-center'>"+textoSDE+"</td>";
                                                } break;

                                                case 'RECHAZADO SDE': {
                                                    table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID'] +' class="btn btn-danger SDE open-validar">Revisar SDE</a>' + "</td>";
                                                } break;

                                                case 'VALIDADO SDE': { 
                                                    table += "<td class='text-center'>SDE en Plan</td>";
                                                } break;

                                                default:{
                                                    table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID']+' class="btn btn-success SDE open-validar">Enviar a Plan SDE</a>' + "</td>";
                                                } 
                                            }
                                        }else{
                                        
                                        table += "<td class='text-center'>---</td>"; 
                                    }

                                    //proceso masivo ya chequeado  
                                    table += "<td class='text-center'><img src={{ asset('images/greencheck.png')}} width='20px'></td>";

                                } break;

                                case 'RECHAZADO': {
                                  //caso MDR 
                                  table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID']+' class="btn btn-danger MDR open-validar">Revisar</a>' + "</td>";

                                    //proceso para el caso de los SDE
                                    //si esta RECHAZADO MDR verifico si esta cargado SDE
                                    if (puede_enviar_sde){
                                            // si esta cargado SDE verifico su estado como el MDR
                                            switch(textoSDE) {
                                                case 'ENVIADO A PLAN SDE': {
                                                    table += "<td class='text-center'>"+textoSDE+"</td>";
                                                } break;

                                                case 'RECHAZADO SDE': {
                                                    table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket']+' id='+monitor[i]['ID'] +' class="btn btn-danger SDE open-validar">Revisar SDE</a>' + "</td>";
                                                } break;

                                                case 'VALIDADO SDE': { 
                                                    table += "<td class='text-center'>SDE en Plan</td>";
                                                } break;

                                                default:{
                                                    table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID']+' class="btn btn-success SDE open-validar">Enviar a Plan</a>' + "</td>";
                                                } 
                                            }
                                        }else{
                                        
                                        table += "<td class='text-center'>---</td>"; 
                                    }

                                  //revisar caso de rechazado
                                  table += "<td class='text-center'><div class='form-group'><input data-id='"+monitor[i]['ID'] +"'id='val"+monitor[i]['ID']+"' type='checkbox' name='checkvalid[]' value="+monitor[i]['idticket']+"><label id='valid"+monitor[i]['ID']+"' for='val"+monitor[i]['ID']+"'></label></div></td>";
                                  $('#btn_enviarPlan').show();

                                } break;

                                case 'VALIDADO': {
                                      //caso MDR
                                      table += "<td class='text-center'>MDR en Plan</td>";
                                      //caso SDE
                                        if (puede_enviar_sde){
                                            // si esta cargado SDE verifico su estado como el MDR
                                            switch(textoSDE) {
                                                case 'ENVIADO A PLAN SDE': {
                                                    table += "<td class='text-center'>"+textoSDE+"</td>";
                                                } break;

                                                case 'RECHAZADO SDE': {
                                                    table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID'] +' class="btn btn-danger SDE open-validar">Revisar SDE</a>' + "</td>";
                                                } break;

                                                case 'VALIDADO SDE': { 
                                                    table += "<td class='text-center'>SDE en Plan</td>";
                                                } break;

                                                default:{
                                                    table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID']+' class="btn btn-success SDE open-validar">Enviar a Plan SDE</a>' + "</td>";
                                                } 
                                            }
                                        }else{
                                        
                                          table += "<td class='text-center'>---</td>"; 
                                       }
                                      //caso masivo
                                      table += "<td class='text-center'><img src={{ asset('images/greencheck.png')}} width='20px'></td>";

                                } break;

                                default:{

                                    if (monitor[i][header[9]] != '<span style="color:#da4f49;margin-left:45%">X</span>') {
                                        
                                        //caso MDR
                                        table += "<td class='text-center'>" + '<a style="cursor:pointer;" data-id='+monitor[i]['idticket'] +' id='+monitor[i]['ID']+' class="btn btn-success MDR open-validar">Enviar a Plan</a>' + "</td>";

                                        //caso SDE
                                        table += "<td class='text-center'>---</td>";

                                        //caso enviar a plan MAsivo
                                        table += "<td class='text-center'><div class='form-group'><input data-id='"+monitor[i]['ID'] +"'id='val"+monitor[i]['ID']+"' type='checkbox' name='checkvalid[]' value="+monitor[i]['idticket']+"><label id='valid"+monitor[i]['ID']+"' for='val"+monitor[i]['ID']+"'></label></div></td>";
                                        $('#btn_enviarPlan').show();

                                    }else{
                                        table += "<td class='text-center'>---</td>";
                                        table += "<td class='text-center'>---</td>";
                                        table += "<td class='text-center'>---</td>";    
                                    }
                                }
                            }
                        {%else%}
                            switch(texto) {
                                case 'ENVIADO A PLAN': {
                                  table += "<td class='text-center'>MDR en Revision</td>";
                                  table += "<td class='text-center'>SDE en Revision</td>";
                                  table += "<td class='text-center'><img src={{ asset('images/greencheck.png')}} width='20px'></td>";

                                }break;
                                case 'VALIDADO': {
                                  table += "<td class='text-center'>Enviado a Plan MDR</td>";
                                  table += "<td class='text-center'>Enviado a Plan SDE</td>";
                                  table += "<td class='text-center'><img src={{ asset('images/greencheck.png')}} width='20px'></td>";

                                }break;
                                default:{
                                  table += "<td class='text-center'>---</td>";
                                  table += "<td class='text-center'>---</td>";
                                  table += "<td class='text-center'>---</td>";
                                }
                            }
                        {%endif%}
                    }
                }
                table += '</tr>';
            }

            table += '</table>';

            return table;
        }

        function createTableSimple(monitor,total,nombreColTotal){

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

            var table = '<table id="tableSitios"  class="table table-bordered table-hover table-striped table-responsive"> <thead>' +

                    '<tr class="btn-info">';

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


                table += "<th class='text-center'>" + header[j] + "</th>"



            }
            table += "</tr></thead>";

            for (var i = 0; i < monitor.length; i++) {
                table += "<tr>";
                for (var j = 0; j < header.length; j++) {
                    if( typeof monitor[i][header[j]] === 'object'){
                        table += "<td>" + monitor[i][header[j]].date.substring(0,19)  + "</td>";
                    }else{
                        table += "<td>" + monitor[i][header[j]]  + "</td>";
                    }

                }
                table += "</tr>";

                if(typeof total !== "undefined") {

                    if (i == monitor.length - 1) {

                        var headerTotal = Object.keys(total);
                        table += '<tr><td>' + nombreColTotal +'</td>';

                        for(var x=0; x<headerTotal.length;x++){
                            table += '<td>';
                            table += total[headerTotal[x]];

                            table += '</td>';

                        }
                        table += '</tr>';
                    }
                }
            }
            table += "</table>";

            return table;
        }

        function createTableDetalle(monitor,option){

            var header = Object.keys(monitor[0]);
            var table = '<table  class="table table-bordered table-hover table-striped table-responsive table1" id="tableDetail">';

            if (option == 1) {
                table = '<table  id="tabla1" class="table table-bordered table-hover table-striped table-responsive table1 tablesorter tablesorter-blue hasFilters" style="text-align:left"> <thead>' + '<tr class="btn-claro">';
            } else
            {
                table = '<table  id="tabla1" class="table table-bordered table-hover table-striped table-responsive table1 tablesorter tablesorter-blue hasFilters"> <thead>' + '<tr class="btn-claro">';
            }

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

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

              //EVITA CAMPOS DE BUSQUEDA SI ES UN DETALLE EN EL MONITOR, 17 ES EL NUMERO DE CAMPOS DEL QUERY PRINCIPAL DEL MONITOR
              if(header.length > 2) {
                  var flagnumber = 0;
                  for (var j = 0; j < header.length; j++) {

                      //if (header[j] != 'CLASS' && header[j] != 'ENTREGABLE' && header[j] != 'capacidad' && header[j] != 'temperatura' && header[j] != 'ID') {
                          var tmpid = 'id' + flagnumber + 'id';
                          table += "<td style='vertical-align:middle; height: 52px;' class='text-center'>\n\
                                  <input  class='form-control' style=font-size:9px type=input id=" + tmpid + " onkeyup=myFunction(" + flagnumber + "," + "id" + flagnumber + "id" + ")></td>";
                          flagnumber += 1;
                      //}
                  }
              }
              table += "</tr></thead>";



            for (var i = 0; i < monitor.length; i++) {
                table += '<tr class="text-center" id=\'' + monitor[i]['idticket'] + '\'>';
            for (var j = 0; j < header.length; j++) {
              var clase = '';

              table += "<td style='vertical-align:middle;' class='text-center'>" + monitor[i][header[j]]  + "</td>";

              }

            table += "</tr>";
            }
            table += "</table>";
            return table;
        };

        function ISO8601_week_no(dt){
            var tdt = new Date(dt.valueOf());
            var dayn = (dt.getDay() + 6) % 7;
            tdt.setDate(tdt.getDate() - dayn + 3);
            var firstThursday = tdt.valueOf();
            tdt.setMonth(0, 1);
            if (tdt.getDay() !== 4)
            {
                tdt.setMonth(0, 1 + ((4 - tdt.getDay()) + 7) % 7);
            }
            return 1 + Math.ceil((firstThursday - tdt) / 604800000);
        }

        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);
                    }
                    else
                            total[key[j]] +=  parseInt(valor[i][header[key[j]]]);

                }

            }
            return total;
        }

        //llamar al modal fileupload
        $(document).on("click", ".open-AddFileDialog", function () {
            var IdTicke = $(this).data('id');
            var project = $("#project").val();
            var carga = $(this).attr('class').split(' ');
            var disabled = true;
            if (carga[0] == 'fileMDR'){
                 //modal MDR
                $("#ticke-mdr").val(IdTicke);
                $("#project_mdr").val(project);
                $('#modalfileUpload').modal('show');
                $('#file-mdr').val('');
            }else{
                 //MODAL SDE
                $('#file-SDE').val('');
                $("#ticke-SDE").val(IdTicke);
                $("#project_sde").val(project);
                //$('#modalfileUploadSDE').modal('show');
                $("#div_upload_sde").css('display','none');
                if ($(this).hasClass('SDE-ViewOnly')){
                    $(".select-file-upload-sde").prop("disabled",true);
                    $("#divAddSDE").css('display','none');
                    disabled=true;
                }else{
                    disabled=false;
                    $(".select-file-upload-sde").prop("disabled",false);
                    $("#divAddSDE").css('display','block');
                }
                getListSDEFilesByTicket(IdTicke, disabled);
            }
        });

        //llamar al modal fileupload Nivel 1
        $(document).on("click", ".open-AddFileSiteValidate", function () {
             $('#SiteValidateUpload').modal('show');
        }); 

        //llamar al modal fileupload Nivel 2
        $(document).on("click", ".open-AddFileSiteValidate2", function () {
             $('#SiteValidateUpload2').modal('show');
        }); 
        
        //llamar al modal detail para llenar tabledetail
        $(document).on("click", ".open-detailModal", function () {
            $('#namedatalle').text($(this).attr('id'));
            var data = {
                IdTicke: $(this).data('id'),
                idproyect: $('#idprojecInterno').val()
            };

            $.isLoading({
                text: 'Loading',
            });

            $.ajax({
                type: 'post',
                url: '{{ path("proyecto_detail") }}',
                data: data,
                success: function(data){
                    $('#modalfileDetail .modal-table').empty();
                    var detalle = ''
                    detalle += '<div class="table-responsive">'
                    detalle += createTableDetalle(data);
                    detalle += '</div>'
                    $.isLoading('hide');
                    $('#modalfileDetail .modal-table').append(detalle);
                    $("#cargar").css('display','done');
                    $('#modalfileDetail').modal('show');
                },
                error: function (res) {
                    $.isLoading('hide');
                }
            });

        });

        $(document).on("click", ".open-liberar", function () {

            var idticket = $(this).data('id');
            var idprojectInter = $('#idprojecInterno').val();
            var idSite = $(this).attr('id');
            var tpen = $(this).attr('class').split(' ');
            var entregable = tpen[2];

            swal({
                title: 'Liberar...',
                text: "Desea Liberar estos materiales ya Validados?",
                type: 'warning',
                showCancelButton: true,
                confirmButtonColor: '#3085d6',
                cancelButtonColor: '#d33',
                confirmButtonText: 'SI, liberar!'
            }).then(function () {
                $.isLoading({
                    text: 'Loading',
                });
                var data = {
                    IdTicke: idticket,
                    tipoEntregable: entregable,
                    idproyect: idprojectInter,
                    id_sitio: idSite
                };
                $.ajax({
                    type: 'post',
                    url: '{{ path("Liberar_Materiales") }}',
                    data: data,
                    success: function(data) {
                        swal('Materiales Liberados', "You clicked the button!", "success");
                        $.isLoading('hide');
                        $.isLoading({
                            text: 'Actualizando Contenido',
                        });
                        getReporte();
                        $.isLoading('hide');
                    },
                    error: function (res) {
                        $.isLoading('hide');
                    }
                 });
            })
        });

        //excluir multiples materiales ya validados
        $(document).on("click", ".open-liberar-array", function () {

            var id_tickets_array = new Array(); //capturamos id de los tickets
            var id_proj_interno = $('#idprojecInterno').val();
            var id_sitio_array = new Array(); //capturamos id del sito

            $("input[type=checkbox]:checked").each(function(){
                //cada elemento seleccionado
                id_tickets_array.push($(this).val());
                id_sitio_array.push($(this).data('id'));
            });

            var idSite = JSON.stringify(id_sitio_array);
            var idticket = JSON.stringify(id_tickets_array);

            if(id_tickets_array != ''){
                swal({
                    title: 'Liberar...',
                    text: "Desea Liberar estos materiales ya Validados?",
                    type: 'warning',
                    showCancelButton: true,
                    confirmButtonColor: '#3085d6',
                    cancelButtonColor: '#d33',
                    confirmButtonText: 'SI, liberar!'
                }).then(function () {
                    $.isLoading({
                        text: 'Loading',
                    });
                    var data = {
                        IdTicke: idticket,
                        idproyect: id_proj_interno,
                        id_sitio: idSite
                    };
                    $.ajax({
                        type: 'post',
                        url: '{{ path("Liberar_Materiales_array") }}',
                        data: data,
                        success: function(data) {
                            swal('Materiales Liberados', "You clicked the button!", "success");
                            $.isLoading('hide');
                            $.isLoading({
                                text: 'Actualizando Contenido',
                            });
                            getReporte();
                            $.isLoading('hide');
                        },
                        error: function (res) {
                            $.isLoading('hide');
                        }
                     });
                });
            }else{
                swal('Info','Debe seleccionar los sitios','info');
            }

        });

       /* $(document).on("click", ".downloadTemplate", function(){
           
            data['ano'] = $("#ano").val();
            data['project'] = $("#client").val();
            data['idproceso'] = $("#project").val();

            $.isLoading({
                text: 'Download Template',
            });
            $.ajax({
                async:true,
                type: 'get',
                dataType:"html",//html
                contentType:"application/x-www-form-urlencoded",
                url: '{{ path("reportpreplanmx_DownloadSitiosValidated") }}',
                data: data,
                success: function(data) {
                    alert(data);
                    $.isLoading('hide');
                    var opResult = JSON.parse(data);
                      var $a=$("<a>");
                      $a.attr("href",opResult.data);
                      //$a.html("LNK");
                      $("body").append($a);
                      $a.attr("download","site_validate.xls");
                      $a[0].click();
                      $a.remove();
                      


                },
                error: function (res) {
                    $.isLoading('hide');
                }
            });
        });*/

        //modal solo validar /  rechazar array
        $(document).on("click", ".open-validar-array", function () {
            //caso multiples planes enviados a plan
            var id_tickets_array = new Array(); //capturamos id de los tickets
            var id_sitio_array = new Array(); //capturamos id del sito
            var id_proj_interno = $('#idprojecInterno').val();
            $('#proyecto_interno').val(id_proj_interno);
            $('.accion').val('');
            $('.ValidarComentario').val('');
            $('.comentario').val('');
            $('.RechazarComentario').val('');
            $("input[type=checkbox]:checked").each(function(){
                //cada elemento seleccionado
                id_tickets_array.push($(this).val());
                id_sitio_array.push($(this).data('id'));
            });

            if(id_tickets_array != ''){

                $('#id_sitios_array').val(JSON.stringify(id_sitio_array));
                $('#id_tickets_array').val(JSON.stringify(id_tickets_array));
                $('#modalValidaArray').modal('show');

            }else{
                swal('Info','Debe seleccionar los sitios','info');
            }
        });

        //caso MDR y SDE

        $(document).on("click", ".open-validar", function () {
            
            var tpen = $(this).attr('class').split(' ');
            var idticket = $(this).data('id');
            var idSite = $(this).attr('id');
            var entregable = tpen[2];

            if(entregable != 'SDE'){

               $("#div_adicional").show();

            }

            $('#tp_entregable').val(entregable);
            $('#idticketvalidad').val(idticket);
            $('#idsitetitle').text(idSite);
            $('#id_sitio').val(idSite);
            $('.accion').val('');
            $('.ValidarComentario').val('');
            $('.comentario').val('');
            $('.RechazarComentario').val('');

            var data = {
                IdTicke: idticket,
                tipoEntregable: entregable,
                idproyect: {{idproyectos}}
            };

            $.isLoading({
                text: 'Loading',
            });

            $.ajax({
                type: 'post',
                url: '{{ path("historico_validacion") }}',
                data: data,
                success: function(data) {
                    $('#tbodyAddHistory').empty();
                    tr = "";
                        
                        $("#adicional").prop("checked",false);
                        for(i=0;i< data.length; i++){

                            tr += `<tr>
                                     <td>${data[i].fecha}</td>
                                     <td>${data[i].nombre}</td>
                                     <td>${data[i].estado}</td>
                                     <td>${data[i].comentario}</td>
                                   <tr>`;

                            if(data[i].adicional === 'si'){
                                $("#adicional").prop("checked",true);
                            }       

                        }
                    $.isLoading('hide');
                    $('#tbodyAddHistory').append(tr);
                    $('#modalValida').modal('show');
                },
                error: function (res) {
                    $.isLoading('hide');
                }
            });
        });

        $(document).on("click", ".select-file-upload-sde", function (){
            var idTE = $(this).data('idte');
            $('#idTE').val(idTE);
            if (idTE=='0'){
                $('#lblTitleUploadFileSDE').html("<strong>{{ 'Agregar SDE' | trans}}</strong>");
            }else{
                $('#lblTitleUploadFileSDE').html("<strong>{{ 'Reemplazar SDE' | trans}}</strong>");
            }
            $('#div_upload_sde').css('display','block');
        });

        $(document).on("click","#cancelUploadFileSDE", function(){
            $('#div_upload_sde').css('display','none');
            $("#file-SDE").val("");
        });

        function getListSDEFilesByTicket(id,disabled){
            var idticket = id;
            var datos = $("#project").val().split('|');

            $('#ticke-SDE').val(idticket);
            var postData = {
                idticket: idticket,
                idproyectos: {{ idproyectos }},
                idproceso: datos[0],
                idproyecto_interno: datos[1]
            };
            $.ajax({
                type: 'POST',
                url: "{{ path('reportepreplanmx_getListSDEFilesByTicket') }}",
                data: postData,
                dataType: 'json',
                beforeSend: function (){
                    $('#divLoadingModal').show();
                    $('#divLoadingModal').html('<span id="img_initializing_loading"><img src="{{ asset('img/loading.gif' ) }}" ' +
                    'width="16" height="16"></span><strong style="margin-left: 5px;">Cargando lista de archivos SDE...</strong>');
                    $('#tbodyTableListSDE').empty();
                    $('#saveFileSDE').prop('disabled', true);
                },
                success: function (r) {
                    var str = "";
                    if (r.length>0){
                        for (var i=0; i<r.length; i++){
                            var nombre = r[i]['nombre_archivo'];
                            var path = r[i]['path'];
                            str += "<tr>" +
                                    "<td class='text-center'" + " style='font-weight: normal'>" + (i+1) + "</td>" +
                                    "<td class='text-left'" + " style='font-weight: normal'><a target='blank' href='"  + path + "'>" + nombre + "</a></td>" +
                                    "<td class='text-center'" + " style='font-weight: normal'>" + r[i]['fecha_creacion'] + "</td>"
                            if (i==0){
                                if (disabled){
                                    str += "<td class='text-center' nowrap='nowrap'>" +
                                            "<button type='button' class='btn btn-primary btn-sm' data-idte='" +
                                            r[i]['id'] + "' title='{{ 'Reemplazar SDE' | trans}}' disabled='disabled'>" +
                                            "<span class='glyphicon glyphicon-edit' aria-hidden='true'></span></button>" +
                                            "</td>";
                                }else{
                                    str += "<td class='text-center' nowrap='nowrap'>" +
                                            "<button type='button' class='btn btn-primary btn-sm select-file-upload-sde' data-idte='" + r[i]['id'] + "' title='{{ 'Reemplazar SDE' | trans}}'>" +
                                            "<span class='glyphicon glyphicon-edit' aria-hidden='true'></span></button>" +
                                            "</td>";
                                }
                            }else{
                                str += "<td class='text-center' nowrap='nowrap'></td>";
                            }
                            str += "</tr>";
                        }
                        str += "";
                        $('#tbodyTableListSDE').append(str);

                        $('#divLoadingModal').hide();
                        $('#divLoadingModal').html('');
                        $('#saveFileSDE').prop('disabled', false);
                    }else{
                        $('#divLoadingModal').hide();
                        $('#divLoadingModal').html('');
                        $('#saveFileSDE').prop('disabled', false);
                        str="<tr><td colspan='4' class='text-center' style='font-weight: normal'>No se encontraron registros.</td></tr>";
                        $('#tbodyTableListSDE').append(str);
                        return false;
                    }
                },
                error: function (jqXHR, textStatus, errorThrown) {
                    $('#divLoadingModal').hide();
                    $('#divLoadingModal').html('');
                    $('#tbodyTableListSDE').empty();
                    $('#saveFileSDE').prop('disabled', false);
                }
            });

            $("#modalfileUploadSDE").modal('show');
        }

    </script>

    <div class="container-fluid">
        <div class="row">
            <div style="text-align: center"  class="col-md-2">
                <img id="logo" src="{{ asset('images/logoEricsson.png')  }}"  width="220" height="72">
            </div>
            <div class="col-lg-8 col-md-12">
                <h1 class="text-center text-primary"><i class="fa fa-file-text-o"></i> SITIOS VALIDADOS </h1>
            </div>
            <div class="col-md-2" id="identity">
                <img  width="220" height="90" id="_logo" src="{{ asset( identity.pathLogo ) }}">
            </div>
        </div>

        <div class="row">
            <div class="col-md-2" id="parametros">

                <select class="form-control" id="client">
                    <option value="">{{'Select Client' | trans}}</option>
                    {% if clientes is defined %}
                        {% for cliente in clientes %}
                            <option value="{{cliente.idproyectos}}">{{ cliente.cliente | trans }}</option>
                        {% endfor %}
                    {% endif %}
                </select>
            </div>
            <div class="col-md-3" id="parametros">
                <input type="hidden" name="idestados" id="idestados" />
                <select class="form-control" id="project">
                    <option value="">{{'Select Project' | trans}}</option>
                </select>
            </div>
            <div class="col-md-2" id="parametros">

                <select class="form-control" id="ano">
                    <option value="">{{'Seleccione Año' | trans}}</option>

                </select>
            </div>
            <div class="col-md-2" id="parametros">

                <select class="form-control" id="tipoBusqueda">
                    <option value=""> {{'Seleccione Fecha' | trans}}</option>
                    <option value="dia">DAY</option>
                    <option value="semana">{{'monitor.week' | trans}}</option>
                    <option value="mes">{{'monitoriii.month' | trans}}</option>
                    <option value="ano">{{'monitoriii.year' | trans}}</option>

                </select>
            </div>
            <div class="col-md-2 " id="parametros" >
                <select  class="hide" id="mes">



                </select>
                <select  class="hide" id="semana">



                </select>

                    <input type="text" id="dia" class="hide form-control datepicker">


            </div>
            <div class="col-md-1" id="parametros" >
                    <button class="btn btn-primary" id="generar">{{'monitoriii.generate' | trans}}</button>
            </div>
        </div>
        <div class="row col-xs-12"><hr></div>
        <div id="divcharts" class="row" style="min-height: 100px;">
            <div class="col-lg-6 col-md-6 col-sm-12" id="chart1">

            </div>
            <div class="col-lg-6 col-md-6 col-sm-12" id="chart2">

            </div>
        </div>
        <div class="row col-xs-12"><hr></div>
        <div id="divMonitor" class="container-fluid" style="min-height: 200px;">
            <div class="row">
                <div class="btn-group pull-left" role="group" aria-label="..." style="margin-right: 50px">
                            <a href="#" onclick="$('#tableSitios').tableExport({type: 'excel', escape: 'false',fileName: 'Distribuidores',ignoreRow: [1]});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a>
                </div>

                <div class="btn-group pull-right" role="group" aria-label="..." style="margin-right: 50px">

                    {% if is_granted('ROLE_VALIDACION_CLIENTE_3')  %}

                    {% elseif is_granted('ROLE_VALIDACION_CLIENTE_2')  %}
                        <a style="cursor:pointer" class="downloadTemplate2" target="_blank"> <img src={{ asset("images/download_excel.png")}} width="30px">Download L2 </a>

                        <a class="open-AddFileSiteValidate2" id="upload2" href="#"> <img src={{ asset("images/upload_excel.png")}} width="30px">Upload L2</a>

                    {% elseif is_granted('ROLE_VALIDACION_CLIENTE_1')%}
                        <a style="cursor:pointer" class="downloadTemplate" target="_blank"> <img src={{ asset("images/download_excel.png")}} width="30px">Download </a>

                        <a class="open-AddFileSiteValidate" id="upload" href="#"> <img src={{ asset("images/upload_excel.png")}} width="30px">Upload </a>

                    {% endif %}

                </div>
                <div class="pager">
                    <span class="pagedisplay"></span>
                </div>

                <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>

            </div>
            <!--button de tabla enviar a plan multiples-->
            <div class="row col-lg-6 pull-right">
                <div id="btn_enviarPlan" class="btn-group pull-right" style="margin-right: 10px; display: none;">
                    {% if is_granted('ROLE_VALIDACION_CLIENTE_3')  %}
                        <a style="cursor:pointer;" style="padding-top: 30px;" class="btn btn-success open-liberar-array">Excluir del <br>Plan Masivo</a>

                    {% elseif is_granted('ROLE_VALIDACION_CLIENTE_2')  %}

                        <a style="cursor:pointer;" style="padding-top: 30px;" class="btn btn-success open-validar-array">Revisar <br>Masivo</a>

                    {% elseif is_granted('ROLE_VALIDACION_CLIENTE_1')%}

                        <a style="cursor:pointer;" style="padding-top: 30px;" class="btn btn-success open-validar-array">Enviar a Plan <br>Masivo</a>

                    {% endif %}
                </div>
            </div>
            <div class="row double-scroll" id="reporte1" style="min-height: 100px;">

            </div>

            <div id="pager" class="pager" style="display: none;text-align: center; ">
                <form>
                        <img src="{{asset('tablesorter-master/addons/pager/icons/first.png')}}" class="first"/>
                        <img src="{{asset('tablesorter-master/addons/pager/icons/prev.png')}}" class="prev"/>
                        <img src="{{asset('tablesorter-master/addons/pager/icons/next.png')}}" class="next"/>
                        <img src="{{asset('tablesorter-master/addons/pager/icons/last.png')}}" class="last"/>
                        <span class="pagedisplay"></span>
                        <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 id="_detail" class="tab-pane fade in">

        <div class="col-lg-6" id="chart3">

        </div>
        <div class="col-lg-6" id="chart4">

        </div>

    </div> <!-- end detail -->
</div>

    </div>

</div>#}
<!--modal files detalles -->
    <div class="modal fade" id="modalfileDetail" 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"> Detalles Materiales <label id="namedatalle"></label></h2>
                </div>
                <div class="modal-body">
                    <input type="hidden" name="id_project_interno" id="idprojecInterno"/>
                    <div class="btn-group pull-right" role="group" aria-label="..." style="margin-right: 50px">
                        <a href="#" onclick="$('#tableDetail').tableExport({type: 'excel', escape: 'false',fileName: 'DetellesProject',ignoreRow: [1]});"> <img src={{ asset("images/xls.png")}} width="24px"> XLS</a>
                    </div>
                    <div id="tableDetail" class="modal-body col-lg-12 modal-table">
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                </div>
            </div>
        </div>
    </div>
<!--===================== MODAL FILE INPUT MDR===================== -->
<div class="modal fade" id="modalfileUpload" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header  bg-primary">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                <h2 class="modal-title text-center" id="myModalLabel"> {{ 'Upload MDR' | trans}}</h2>
            </div>
            <form id="form-sitevalidate" name="form-sitevalidate" method="post" action="{{ path('reportpreplanmx_uploadSiteValidate',{'idproyectos':idproyectos,'idmodule':idmodule})}}" enctype="multipart/form-data">
                <div class="modal-body">
                    <div class="row">
                        <div class="col-lg-12"  style="margin-top: 1%">
                            <div class="file-area">
                                <input type="hidden" name="ticke" id="ticke-mdr" required="required"/>
                                <input type="hidden" name="project_mdr" id="project_mdr" required="required"/>
                                <input type="file" name="file" id="file-mdr" required="required"/>
                                <div class="file-dummy">
                                    <span class="success">Great, your files are selected.</span>
                                    <span class="default">Please select some files.</span>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <div class="alert alert-success col-lg-8 text-center" style="display:none;" id="response-incidencias"></div>
                    <button id="saveFileMDR" type="submit" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                    <button id="closemodal" type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                </div>
            </form>

        </div>
    </div>
</div>


<!--===================== MODAL FILE INPUT SDE===================== -->
<div class="modal fade" id="modalfileUploadSDE" tabindex="-1" role="dialog" aria-labelledby="modalfileUploadSDE">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header  bg-primary">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                <h2 class="modal-title text-center" id="myModalLabel"> {{ 'Agregar SDE' | trans}}</h2>
            </div>
            <form id="form-fileSDE" name="form-fileSDE" method="post" action="{{ path('reportpreplanmx_uploadfileSDE',{'idproyectos':idproyectos,'idmodule':idmodule})}}" enctype="multipart/form-data">
                <div class="modal-body">
                    <div class="row pull-right" style="margin-bottom: 5px;">
                        <div id="divAddSDE" class="col-md-12">
                            <button id="btnAddSDE" type="button" class="btn btn-primary btn-md select-file-upload-sde" data-idte="0">
                                <span class="glyphicon glyphicon-save-file" aria-hidden="true"></span>{{ 'Agregar SDE' | trans}}</button>
                        </div>
                    </div>
                    <div class="row" id="div_upload_sde" style="display: none;">
                        <div class="col-md-12"  style="margin-top: 2px;">
                            <div style="margin-bottom: 2px;"><span class="label label-info" id="lblTitleUploadFileSDE"></span></div>
                            <div class="file-area">
                                <input type="hidden" name="ticke" id="ticke-SDE" required="required"/>
                                <input type="hidden" name="idTE" id="idTE" required="required"/>
                                <input type="hidden" name="project_sde" id="project_sde" required="required"/>
                                <input type="file" name="file" id="file-SDE" required="required"/>
                                <div class="file-dummy">
                                    <span class="success">Great, your files are selected.</span>
                                    <span class="default">Please select some files.</span>
                                </div>
                            </div>
                            <div class="pull-right" style="margin-bottom: 2px;">
                                <button id="cancelUploadFileSDE" type="button" class="btn btn-info btn-sm">{{ 'ticketDetail.status.cancel' | trans}}</button>
                            </div>
                        </div>
                    </div>
                    <div class="row" style="height: 5px;"></div>
                    <div class="row">
                        <div class="col-md-12">
                            <div id="divLoadingModal" class="alert alert-warning" role="alert">

                            </div>
                        </div>
                    </div>
                    <div class="row" id="tableListSDE">
                        <div class="col-md-12 text-center">
                            <table class="table table-striped table-hover">
                                <thead>
                                    <tr class="bg-primary">
                                        <th class="text-center" style="width: 20px" nowrap="nowrap">#</th>
                                        <th class="text-left">Nombre Archivo</th>
                                        <th class="text-center">Fecha</th>
                                        <th class="text-center" style="width: 30px" nowrap="nowrap">Acción</th>
                                    </tr>
                                </thead>
                                <tbody id="tbodyTableListSDE" style="font-weight: normal">

                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <div class="alert alert-success col-lg-8 text-center" style="display:none;" id="response-incidenciasSDE"></div>
                    <button id="saveFileSDE" type="submit" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                    <button id="closemodal" type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                </div>
            </form>

        </div>
    </div>
</div>

<!--modal validar-->
<div class="modal fade modalValida" id="modalValida" 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"> Validar Sitio <label id="idsitetitle"></label> </h2>
            </div>
            <form id="formValidacion" name="formValidacion" action="{{ path('reportpreplanMx_validatePrePlan',{'idproyectos':idproyectos,'idmodule':idmodule}) }}" method="POST">
                <div class="modal-body">
                    <div class="row" id="primeraFila" style="margin-top:8px">
                        <input type="hidden" name="ticke" id="idticketvalidad"/>
                        <input type="hidden" name="id_proceso" id="id_proceso" class="id_proceso" />
                        <input type="hidden" name="tipo_entregable" id="tp_entregable"/>
                        <input type="hidden" name="repuesto" id="repuesto" value="16802"/>
                            {% if is_granted('ROLE_VALIDACION_CLIENTE_1') or is_granted('ROLE_VALIDACION_CLIENTE_2') %}

                                {% if is_granted('ROLE_VALIDACION_CLIENTE_2') %}

                                        <div class="col-lg-4">
                                            <label>Acción</label>
                                            <select required id="accion" name="accion[]" class="accion">
                                                <option value="Validar">Validar</option>
                                                <option value="Rechazar">Rechazar</option>
                                            </select>
                                        </div>
                                        <div class="col-lg-4">
                                            <label>Comentario</label>
                                            <select id="ValidarComentario" name="ValidarComentario[]" class="ValidarComentario">
                                                <option value="Entregable Correcto">Entregable Correcto</option>
                                            </select>
                                            <select id="RechazarComentario" name="RechazarComentario[]" style="display:none;" class="RechazarComentario">
                                                <option value="Pendiente OT">Pendiente OT</option>
                                                <option value="Material Incompleto">Material Incompleto</option>
                                                <option value="Otro">Otro</option>
                                            </select>
                                        </div>
                                        <div id="div_comentario" class="col-lg-3 div_comentario" style="display:none">
                                            <label>Detalle</label>
                                            <textarea id="comentario" name="comentario[]" class="comentario"></textarea>
                                        </div>


                                    {% else %}

                                        <div class="col-lg-4">
                                                <label>Acción</label>
                                                <select required id="accion" name="accion[]" class="accion">
                                                    <option value="Enviar a Plan">Enviar a Plan</option>
                                                </select>
                                        </div>
                                        <div class="col-lg-4">
                                            <label>Comentario</label>
                                            <select id="ValidarComentario" name="ValidarComentario[]" class="ValidarComentario">
                                                <option value="Entregable para Revision">Entregable para Revisión</option>
                                                <option value="Otro">Otro</option>
                                            </select>
                                        </div>
                                        <div id="div_comentario" class="col-lg-4 div_comentario" style="display:none">
                                            <label>Detalle</label>
                                            <textarea id="comentario" name="comentario[]" class="comentario"></textarea>
                                        </div>
                                {% endif %}
                            {% endif %}
                            <div class="col-lg-4" style="display: none;" id="div_adicional">
                                <label>Sitio Adicional</label>
                                <div class='form-group'>
                                    <input data-id="" id="adicional" type="checkbox" value="si" name="checkAdicional" value="">
                                    <label id="" for="adicional"></label>
                                </div>
                            </div>
                            <div class="col-lg-12">
                                <table  class="table-bordered table-hover table-striped tablesorter table-responsive col-xs-12 col-lg-12 tablesorter-blue" id="tableHistorial">
                                    <thead>
                                        <th>Fecha</th>
                                        <th>Usuario</th>
                                        <th>Estado</th>
                                        <th>Comentario</th>
                                    </thead>
                                    <tbody id="tbodyAddHistory"></tbody>
                                </table>
                            </div>

                    </div><!-- fila 1 -->
                    <input type="hidden" name="id_project_interno1" id="idprojecInterno1"/>
                    <input type="hidden" name="id_sitio" id="id_sitio"/>
                </div>
                <div class="modal-footer">
                    <button id="savePlanvalid" type="submit" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                    <button id="closemodalvalid" type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                </div>
            </form>
        </div>
    </div>
</div>

<!--modal validar array-->
<div class="modal fade modalValida" id="modalValidaArray" 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"> Validar Sitios </label> </h2>
            </div>
            <form id="formValidacion" name="formValidacion" action="{{ path('reportpreplanMx_validatePrePlanArray',{'idproyectos':idproyectos,'idmodule':idmodule}) }}" method="POST">
                <div class="modal-body">
                    <div class="row" id="primeraFila" style="margin-top:8px">
                        <input type="hidden" name="id_sitio" id="id_sitios_array"/>
                        <input type="hidden" name="ticke" id="id_tickets_array"/>
                        <input type="hidden" name="id_proceso" id="id_proceso" class="id_proceso"/>
                        <input type="hidden" name="repuesto" id="repuesto" value="16802"/>
                        <input type="hidden" name="id_project_interno1" id="proyecto_interno"/>


                            {% if is_granted('ROLE_VALIDACION_CLIENTE_1') or is_granted('ROLE_VALIDACION_CLIENTE_2') %}

                                {% if is_granted('ROLE_VALIDACION_CLIENTE_2') %}

                                        <div class="col-lg-4">
                                            <label>Acción</label>
                                            <select required id="accion" name="accion[]" class="accion">
                                                <option value="Validar">Validar</option>
                                                <option value="Rechazar">Rechazar</option>
                                            </select>
                                        </div>
                                        <div class="col-lg-4">
                                            <label>Comentario</label>
                                            <select id="ValidarComentario" name="ValidarComentario[]" class="ValidarComentario">
                                                <option value="Entregable Correcto">Entregable Correcto</option>
                                            </select>
                                            <select id="RechazarComentario" name="RechazarComentario[]" style="display:none;" class="RechazarComentario">
                                                <option value="Pendiente OT">Pendiente OT</option>
                                                <option value="Material Incompleto">Material Incompleto</option>
                                                <option value="Otro">Otro</option>
                                            </select>
                                        </div>
                                        <div id="div_comentario" class="col-lg-3" style="display:none">
                                            <label>Detalle</label>
                                            <textarea id="comentario" name="comentario[]" class="comentario"></textarea>
                                        </div>
                                {% else %}

                                        <div class="col-lg-4">
                                                <label>Acción</label>
                                                <select required id="accion" name="accion[]" class="accion">
                                                    <option value="Enviar a Plan">Enviar a Plan</option>
                                                </select>
                                        </div>
                                        <div class="col-lg-4">
                                            <label>Comentario</label>
                                            <select id="ValidarComentario" name="ValidarComentario[]" class="ValidarComentario">
                                                <option value="Entregable para Revision">Entregable para Revisión</option>
                                                <option value="Otro">Otro</option>
                                            </select>
                                        </div>
                                        <div id="div_comentario" class="col-lg-4" style="display:none">
                                            <label>Detalle</label>
                                            <textarea id="comentario" name="comentario[]" class="comentario"></textarea>
                                        </div>

                                {% endif %}
                            {% endif %}
                            <div class="col-lg-4">
                                <label>Sitio Adicional</label>
                                <div class='form-group'>
                                    <input data-id="" id="adicionalArray" type="checkbox" value="si" name="checkAdicionalArray" value="">
                                    <label id="" for="adicionalArray"></label>
                                </div>
                            </div>
                    </div><!-- fila 1 -->
                </div>
                <div class="modal-footer">
                    <button id="savePlanvalid" type="submit" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                    <button id="closemodalvalid" type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                </div>
            </form>
        </div>
    </div>
</div>

<!-- modal para la carga de templete de todos los MDR site validate-->

<!--===================== MODAL FILE INPUT MDR TEMPLETE===================== -->
<div class="modal fade" id="SiteValidateUpload" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header  bg-primary">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                <h2 class="modal-title text-center" id="myModalLabel"> {{ 'Enviar a Plan Masivo (file Site Validate)' | trans}}</h2>
            </div>
            <form id="formUploadSiteValidate" name="formUploadSiteValidate" method="post" action="{{ path('reportpreplanmx_SiteValidateUpload',{'idproyectos':idproyectos,'idmodule':idmodule})}}" enctype="multipart/form-data">

                <div class="modal-body">
                    <div class="row">
                        <div class="col-lg-12"  style="margin-top: 1%">
                            <div class="file-area">
                                <input type="hidden" name="id_project_interno1" class="proyectoInterno"/>
                                <input type="hidden" name="id_proceso" id="id_proceso" class="id_proceso" />
                                <input type="hidden" name="accion[]" id="accion" class="accion" value="Enviar a Plan"/>
                                <input type="file" name="file" id="file-mdr" required="required"/>
                                <div class="file-dummy">
                                    <span class="success">Great, your files are selected.</span>
                                    <span class="default">Please select some files.</span>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <div class="alert alert-success col-lg-8 text-center" style="display:none;" id="response-incidencias"></div>
                    <button id="saveFileMDR" type="submit" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                    <button id="closemodal" type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                </div>
            </form>

        </div>
    </div>
</div>

<!--===================== MODAL FILE INPUT MDR TEMPLETE NIVEL2===================== -->
<div class="modal fade" id="SiteValidateUpload2" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header  bg-primary">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                <h2 class="modal-title text-center" id="myModalLabel"> {{ 'Validar Plan Masivo (file Site Validate)' | trans}}</h2>
            </div>
            <form id="formUploadSiteValidate2" name="formUploadSiteValidate2" method="post" action="{{ path('reportpreplanmx_SiteValidateUpload2',{'idproyectos':idproyectos,'idmodule':idmodule})}}" enctype="multipart/form-data">

                <div class="modal-body">
                    <div class="row">
                        <div class="col-lg-12"  style="margin-top: 1%">
                            <div class="file-area">
                                <input type="hidden" name="id_project_interno1" class="proyectoInterno"/>
                                <input type="hidden" name="id_proceso" id="id_proceso" class="id_proceso" />
                                <input type="hidden" name="accion[]" id="accion" class="accion" value="Validar"/>
                                <input type="file" name="file" id="file-mdr" required="required"/>
                                <div class="file-dummy">
                                    <span class="success">Great, your files are selected.</span>
                                    <span class="default">Please select some files.</span>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <div class="alert alert-success col-lg-8 text-center" style="display:none;" id="response-incidencias"></div>
                    <button id="saveFileMDR" type="submit" class="btn btn-default"><i class="fa fa-lg fa-save text-primary"></i></button>
                    <button id="closemodal" type="button" class="btn btn-default" data-dismiss="modal"><i class="fa fa-lg fa-times text-danger"></i></button>
                </div>
            </form>

        </div>
    </div>
</div>



<script type="text/javascript">
    //$(function () {
        $('form[name="form-sitevalidate"]').submit(function (e) {
            var formData = new FormData(document.getElementById("form-sitevalidate"));
            var idticket = $('#ticke-mdr').val();

            $.ajax({
                url: "{{path('reportpreplanmx_uploadSiteValidate',{'idproyectos':idproyectos,'idmodule':idmodule})}}",
                type: "post",
                dataType: "html",
                data: formData,
                beforeSend: function () {
                    $.isLoading({text: "Loading"});
                    $("#saveFileMDR").prop("disabled", true);
                    $("#closemodal").prop("disabled", true);
                },
                complete: function () {
                    $.isLoading("hide");
                    $("#file-mdr").val("");
                    $("#response-incidencias").toggle();
                    $("#response-incidencias").html("Se ha cargado con éxito");
                    setTimeout(function() {


                        $("#response-incidencias").fadeOut(1500);
                        $("#saveFileMDR").prop("disabled", false);
                        $("#closemodal").prop("disabled", false);
                        $('#modalfileUpload').modal('hide');
                        $.isLoading({
                            text: "update content"
                        });
                        getReporte(); //recarga la tabla
                    },3000);

                },
                error: function (res) {
                    $("#response-incidencias").toggle();
                    $("#response-incidencias").html(res);
                    setTimeout(function() {
                        $("#response-incidencias").fadeOut(1500);
                    },12000);
                    $('#modalfileUpload').modal('hide');
                },
                cache: false,
                contentType: false,
                processData: false
            }).done(function (res) {
               //console.log(res);
            });
            e.preventDefault(); // avoid to execute the actual submit of the form.
        });
      //}); // end ready document*/

      //proceder a validar y rechazar
        $('form[name="form-fileSDE"]').submit(function (e) {
            e.preventDefault(); // avoid to execute the actual submit of the form.

            var formData = new FormData(document.getElementById("form-fileSDE"));
            var idticket = $('#ticke-SDE').val();
            var btnDisabled = $("#btnAddSDE").is('[disabled]');

            $.ajax({
                url: "{{path('reportpreplanmx_uploadfileSDE',{'idproyectos':idproyectos,'idmodule':idmodule})}}",
                type: "post",
                //dataType: "html",
                data: formData,
                cache: false,
                contentType: false,
                processData: false,
                beforeSend: function () {
                    $.isLoading({text: "Loading"});
                    $("#saveFileSDE").prop("disabled", true);
                    $("#closemodal").prop("disabled", true);
                },
                complete: function () {
                    $.isLoading("hide");
                    $("#file-SDE").val("");
                    $('#idTE').val("");
                    $("#response-incidenciasSDE").toggle();
                    $("#response-incidenciasSDE").html("Se ha cargado con éxito");
                    $("#response-incidenciasSDE").fadeOut(3500);
                    $("#saveFileSDE").prop("disabled", false);
                    $("#closemodal").prop("disabled", false);
                    $("#div_upload_sde").css('display','none');
                    //$('#modalfileUploadSDE').modal('hide');
                    getListSDEFilesByTicket($("#ticke-SDE").val(),btnDisabled);
                },
                error: function (res) {
                    $("#response-incidenciasSDE").toggle();
                    $("#response-incidenciasSDE").html(res);
                    $("#div_upload_sde").css('display','none');
                    /*setTimeout(function() {
                        $("#response-incidenciasSDE").fadeOut(1500);
                    },12000);
                    $('#modalfileUploadSDE').modal('hide');*/
                }
            }).done(function (res) {
               console.log(res);
            });
        });



</script>

    <script type="text/javascript">

        $('form[name="formValidacion"]').ajaxForm({

                beforeSubmit: function (formData, jqForm, options) {

                    $.isLoading({text: "Loading"});

                },

                error: function (error) {
                    swal(error, "error!", "success");
                    $.isLoading('hide');

                },

                success: function (responseText, statusText, xhr, $form) {

                    $.isLoading('hide');

                    swal(responseText, "You clicked the button!", "success");

                    $('.accion').val('');
                    $('.ValidarComentario').val('');
                    $('.comentario').val('');
                    $('.RechazarComentario').val('');
                    $(".modalValida").modal('hide');

                    $.isLoading({
                        text: "update content"
                    });
                    getReporte(); //recarga la tabla

                }

        });

        $('form[name="formUploadSiteValidate"]').ajaxForm({

                beforeSubmit: function (formData, jqForm, options) {

                    $.isLoading({text: "Upload Template"});

                },

                error: function (error) {
                    swal(error, "error!", "success");
                    $.isLoading('hide');

                },

                success: function (responseText, statusText, xhr, $form) {
                    $.isLoading('hide');
                    $("#SiteValidateUpload").modal('hide');
                    swal("Procesado","Upload Complete...", "success");
                    //$("#SiteValidateUpload").modal('hide');

                    $.isLoading({
                        text: "update content"
                    });

                    getReporte(); //recarga la tabla

                }

        });
        $('form[name="formUploadSiteValidate2"]').ajaxForm({

                beforeSubmit: function (formData, jqForm, options) {

                    $.isLoading({text: "Upload Template"});

                },

                error: function (error) {
                    swal(error, "error!", "success");
                    $.isLoading('hide');

                },

                success: function (responseText, statusText, xhr, $form) {
                    $.isLoading('hide');
                    $("#SiteValidateUpload2").modal('hide');
                    swal("Procesado","Upload Complete...", "success");
                    //$("#SiteValidateUpload").modal('hide');

                    $.isLoading({
                        text: "update content"
                    });

                    getReporte(); //recarga la tabla

                }

        });

    </script>

{% endblock %}