{% 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(){

                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);
                            }
                            $.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 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];
            if($("#site").val()=="Coloque los ID separado por coma" || 
               $("#site").val()=="") data['site'] = "s.codigo";
            else{ 
                var idsite=$("#site").val().split(",");
                var idsites="'";
                for (var j=0;j<idsite.length;j++){
                    idsites=idsites+"'"+idsite[j]+"',";
                }
                data['site'] = idsites.substring(1, idsites.length-1);
            }


               $.getJSON('{{ path('reportepreplanmx_getDetailDowloadMdrs') }}',data,function(data){

                    var monitor = data.monitor;
                    //var chart1 = data.chart1;
                    var material = data.materialC;
                    //var entregablesRechazados = data.entregables;
                    var validacion = data.validacion;
                    var validacionSDE = data.validacionSDE;
                    var prInterno = $('#idprojecInterno').val();
                    if(monitor.length == 0){

                        $("#reporte1").empty();
                        //$("#chart1").empty();
                        //$("#chart2").empty();
                        $("#reporte1").append('<div class="alert alert-warning" role="alert">NO SE HA ECONTRADO DATA</div>');
                        $.isLoading("hide");
                        $("#inicio").show();
                        return false;
                    }


                    /*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);
                    }*/
                    //createColumnChart('chart1','Deliverables by type pending for loading',chart2);


                   var objectType = {'9': 1, '10': 2, '11': 3, '12': 4, '13': 5, '14': 6};
                   $('#reporte1').empty().append(createTable(monitor, material, 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');
                }).fail(function(){
                $.isLoading('hide');
            });
        }



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] != 'ACCION SDE' && header[j] != 'MATERIAL COMPLETO' &&  header[j] != 'ACCION MDR' && header[j] != 'idticket' && header[j] != 'descargar' ) {
                    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] != 'ACCION SDE' &&  header[j] != 'ACCION MDR' && header[j] != 'MATERIAL COMPLETO' && header[j] != 'idticket' && header[j] != 'descargar'){
                           table += '<td ' + typeString + '>' + monitor[i][header[j]] + '</td>';
                        }

                        //columna MDR
                        var MDR = "";
                        if (header[j]==="MDR"){
                            MDR = `${monitor[i]['MDR']}`;

                            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{

                                table += '<td class="text-center" ' + typeString + '>' + MDR + '</td>';
                            }
                        }
                   // }
                    MDR = `${monitor[i]['MDR']}`;
                    if (j === header.length -1) {
                           if (MDR === '<span style="color:#da4f49;margin-left:45%">X</span>') {
                                table += '<td class="text-center">--</td>';

                            }else{
                              var flag="";
                              var deshabilitar="";
                                if (monitor[i]['STATUS MDR']=="VALIDADO" && monitor[i]['descargar']==0) {deshabilitar = "disabled='disabled'";}
                                if($("#site").val()!="Coloque los ID separado por coma" && $("#site").val()!="" && deshabilitar==""){
                                    flag="checked";
                                }
                                
                                
                                table += `<td class='text-center'>
                                          <div class='form-group'>
                                               <input `+flag+` `+deshabilitar+` data-id="${monitor[i]['ID']}" id="val${monitor[i]['ID']}" type="checkbox" name="checkvalid[]" value="${monitor[i]['idticket']}">
                                               <label id="val${monitor[i]['ID']}" for="val${monitor[i]['ID']}">
                                               </label>
                                          </div>
                                      </td>`;
                            }          
                    }
                }
                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;
        }

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

            var id_tickets_array = new Array(); //capturamos id de los tickets
            var id_interno = $('#client').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);
            $(".downloadTemplate").attr("href", ruta);


            if(id_tickets_array != ''){

                 data['tickets'] = window.btoa(unescape(encodeURIComponent(JSON.stringify(id_tickets_array))));
                 data['ano'] = $("#ano").val();
                 data['project'] = $("#client").val();
                 //data['idproceso'] = $("#project").val();
                 data['idestados'] = $("#idestados").val();
                 var datos = $("#project").val().split('|');
                data['idproceso'] = datos[0];
                data['idproyectoInt'] = datos[1];
               
                var ruta = `{{path('reportpreplanmx_DownloadMDR')}}?proyeto=${ data['tickets']}&ano=${data['ano']}&project=${data['project']}&idproceso=${data['idproceso']}&idproyectoInt=${data['idproyectoInt']}&idestados=${data['idestados']};`
                window.open(ruta);
            }else{
                swal('Info','Debe seleccionar los MDRs','info');
            }

        });

    </script>

    <div class="container-fluid">
        <div class="row">
            <div style="text-align: center"  class="col-lg-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> DOWNLOADS MDR </h1>
            </div>
            <div class="col-lg-2" id="identity">
                <img  width="220" height="90" id="_logo" src="{{ asset( identity.pathLogo ) }}">
            </div>
        </div>

        <div class="row">
            <div class="col-lg-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-lg-2" 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-lg-2" id="parametros">
                <textarea name="site" rows="3" cols="20" id="site">Coloque los ID separado por coma</textarea>
            </div>
            <div class="col-lg-3" id="parametros" >
                    <button class="btn btn-primary col-lg-5" id="generar">{{'monitoriii.generate' | trans}}</button>
            </div>

        </div>
        <div class="row">
            <div class="col-lg-2" id="parametros">
                <select class="form-control" id="ano">
                    <option value="">{{'Seleccione Año' | trans}}</option>

                </select>
            </div>                
            <div class="col-lg-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-lg-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>   
                <div class="row"></div>
                <div class="row"></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;">
                        <a style="cursor:pointer;" style="padding-top: 30px;" class="btn btn-success open-downloadMDR">Descargar <br>MDRs</a>
                    </div>
                </div>
                <div class="row double-scroll" id="reporte1"></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 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>


{% endblock %}