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

{% endblock %}

{% block dashboard %}
    <style>
        .double-scroll {
            width: 100%;
            margin-bottom: 40px;
        }
        /* pager wrapper, div */
        .pager {
            padding-left: 0;
             margin: 0;
            text-align: left;
            list-style: none;
        }
        /* pager wrapper, in thead/tfoot */
        td.pager {
            background-color: #e6eeee;
        }
        /* pager navigation arrows */
        .pager img {
            vertical-align: middle;
            margin-right: 2px;
        }
        /* pager output text */
        .pager .pagedisplay {
            font-size: 14px;
            font-weight: bold;
            padding: 0 5px 0 5px;
            width: 50px;
            text-align: center;
        }

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

        /*** css used when "updateArrows" option is true ***/
        /* the pager itself gets a disabled class when the number of rows is less than the size */
        .pager.disabled {
            display: none;
        }
        /* hide or fade out pager arrows when the first or last row is visible */
        .pager img.disabled {
            /* visibility: hidden */
            opacity: 0.5;
            filter: alpha(opacity=50);
        }

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

        .wrapper{padding-bottom:50px;}
        .header{background:#000000;}.header .container{padding-bottom:20px;}.header .container h1{color:#FFF;line-height:50px;margin-top:30px;margin-bottom:0;}
        .header .container h3{color:#E0E0E0;font-size:16px;margin-top:-5px;}.header .container h3 a{color:#66aacc;}.header .container h3 a:hover{color:#b3d5e6;}
        .top-menu{position:absolute;z-index:9999;}.top-menu .nav-list{background:rgba(255, 255, 255, 0.8);border:1px solid #CCC;margin:20px;position:fixed;right:0;}
        pre,.well{background:#FFFFFF;}
        .syntax-container{background:#FCFCFC;-webkit-border-radius:7px;-webkit-background-clip:padding-box;-moz-border-radius:7px;-moz-background-clip:padding;border-radius:7px;background-clip:padding-box;border:1px solid #e3e3e3;margin-bottom:30px;padding-bottom:20px;}
        .isloading-wrapper.isloading-right{margin-left:10px;}
        .isloading-overlay{position:relative;text-align:center;}.isloading-overlay .isloading-wrapper{background:#FFFFFF;-webkit-border-radius:7px;-webkit-background-clip:padding-box;-moz-border-radius:7px;-moz-background-clip:padding;border-radius:7px;background-clip:padding-box;display:inline-block;margin:0 auto;padding:10px 20px;top:10%;z-index:9000;}

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

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

        @keyframes spin {
            from { transform: scale(1) rotate(0deg);}
            to { transform: scale(1) rotate(360deg);}
        }
        #menuTop {
            margin-top: 30px;
        }
            body {
                /*margin-top: 80px;*/
            }
        h1{
            font-size: 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;
        }


        .wrapper{padding-bottom:50px;}
        .header{background:#000000;}.header .container{padding-bottom:20px;}.header .container h1{color:#FFF;line-height:50px;margin-top:30px;margin-bottom:0;}
        .header .container h3{color:#E0E0E0;font-size:16px;margin-top:-5px;}.header .container h3 a{color:#66aacc;}.header .container h3 a:hover{color:#b3d5e6;}
        .top-menu{position:absolute;z-index:9999;}.top-menu .nav-list{background:rgba(255, 255, 255, 0.8);border:1px solid #CCC;margin:20px;position:fixed;right:0;}
        pre,.well{background:#FFFFFF;}
        .syntax-container{background:#FCFCFC;-webkit-border-radius:7px;-webkit-background-clip:padding-box;-moz-border-radius:7px;-moz-background-clip:padding;border-radius:7px;background-clip:padding-box;border:1px solid #e3e3e3;margin-bottom:30px;padding-bottom:20px;}
        .isloading-wrapper.isloading-right{margin-left:10px;}
        .isloading-overlay{position:relative;text-align:center;}.isloading-overlay .isloading-wrapper{background:#FFFFFF;-webkit-border-radius:7px;-webkit-background-clip:padding-box;-moz-border-radius:7px;-moz-background-clip:padding;border-radius:7px;background-clip:padding-box;display:inline-block;margin:0 auto;padding:10px 20px;top:10%;z-index:9000;}

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

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

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

        #menuTop {
            margin-top: 10px;
        }
        .fixed-panel {
            min-height: 200px;
            /* max-height: 800px; */
            overflow-y: auto;
        }
        #parametros .panel-body .row{

            padding-left: 5px;
        }
        #chart .panel-body {
            padding: 0px;
        }
        .btn-claro {
            color: #fff;
            /*background-color: #00569C;
            border-color: #3D59CA;*/
            background-color: #428bca;
            border-color: #3071a9;
        }
        .btn-claro:hover, .btn-claro:focus {
            color: #fcfcfc;
            text-decoration: none;
        }
        .tabla-detalle
        {
                text-transform: uppercase;
                font-size: 9px;
        }

        .disabledTab{
            pointer-events: none;
        }
        #menuTop { margin-top: 0px; }

        .form-inline .form-group { margin-bottom: 20px; }

        .form-group{ margin-left: 20px; }

        hr.style14 {
            border: 0;
            height: 1px;
            background-image: -webkit-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -moz-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -ms-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
            background-image: -o-linear-gradient(left, #f0f0f0, #8c8b8b, #f0f0f0);
        }

        .hrHide { display: none; }

        .highcharts-container{width:100% !important;}


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

        table td{
            {#text-transform: uppercase;#}
            font-weight: normal;
            font-size: 12px;
        }

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

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

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

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

        .verticalResizer{
            cursor: ns-resize;
        }

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

        .badge {
            font-size: 85%;
        }

        .gradiente {
          height: 100px;
          background-color: #428BCA; /* For browsers that do not support gradients */
          background-image: linear-gradient(0deg, #428BCA, #031A48);
        }
        .container {
            width: 100%;
            height: 400px;
        }
        .chart {
          width: 80%;
        }
    </style>
    <link  href="{{ asset('bootstrap-multiselect/css/bootstrap-multiselect.css') }}" rel="stylesheet" type="text/css" />
    <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 () {

            $("#proyecto").multiselect({
                includeSelectAllOption: true, 
                buttonTextAlignment: 'left',
                buttonWidth: '200px'
            });
            $.fn.dataTable.moment( 'YYYY-MMM' );
            $('#Filtros_fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#Filtros_fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });            
            $('#Filtros_fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });
            //
            $('#fechaIni').datepicker({
                dateFormat: 'yy-mm-dd',
                onClose: function (selectedDate){
                    $("#fechaFin").datepicker("option", "minDate", selectedDate);
                }
            });            
            $('#fechaFin').datepicker({
                dateFormat: 'yy-mm-dd',
            });
            //
            var f = new Date();
            var mes = (f.getMonth() + 1);
            if (mes < 10)
                mes = '0' + mes;
            var fechaI = f.getFullYear() + '-' + mes + "-01";
            var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();
            $('#fechaIni').val(fechaI);
            $('#fechaFin').val(fechaF);
            $(".div_fecha").hide();
            $(".ajuste_fecha").click(function(){
                $('.ajuste_fecha').removeClass('btn-primary');
                $('.ajuste_fecha').addClass('btn-default');
                var id = $(this).attr('id');
                $("#"+id).addClass('btn-primary');
                $(".div_fecha").hide();
                if (id=="rango_fecha"){
                    $(".div_fecha").show();
                }
                rangosFecha(id);
            });

            $("#export").click(function(){

                $("#formExport").submit();

                return false;

            });
            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 = 2020;
            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
            }));
        }
            var anho_actual = i-1;

            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());
                //console.log(yearSelected + ' - ' + semana);
                $('#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
                            }));
                        }
                    }
            });
            $('#ano').val(anho_actual);
            $('#ano').trigger("change");

            $("#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 ($("#rango_fecha").hasClass("btn-primary")){
                    $('#Filtros_fechaIni').val($('#fechaIni').val());
                    $('#Filtros_fechaFin').val($('#fechaFin').val());  
                }
                if ($('#Filtros_fechaIni').val()=="" ||  $('#Filtros_fechaFin').val()==""){
                    swal("Error!", "Date Required", "error");
                }else{
                    $.isLoading({
                        text: "Loading"
                    });
                    getReporte();
                }
            });
            $(".tab_summary").click(function(){
                if ($("#total_summary").val()>0){
                    $(".pager_summary").show();
                    var pagerOptions1 = {
                        container: $(".pager"),
                        output: 'Rows : {endRow}',
                        fixedHeight: false,
                        removeRows: true,
                        cssGoto: '.gotoPage'
                    };
                    $(".table1").tablesorter({
                        theme: 'blue',
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            filter_cssFilter: '',
                            filter_childRows: false,
                            filter_hideFilters: false,
                            filter_ignoreCase: true,
                            filter_reset: '.reset',
                            filter_saveFilters: true
                        }
                    }).tablesorterPager(pagerOptions1);
                    $(".pager").show();
                }else{
                    $(".pager_summary").hide();
                }
            });
            $(".tab_time").click(function(){

                if ($("#total_time").val()>0){
                    $(".pager_time").show();
                    var pagerOptions1 = {
                        container: $(".pager"),
                        output: 'Rows : {endRow}',
                        fixedHeight: false,
                        removeRows: true,
                        cssGoto: '.gotoPage'
                    };
                    $(".table2").tablesorter({
                        theme: 'blue',
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            filter_cssFilter: '',
                            filter_childRows: false,
                            filter_hideFilters: false,
                            filter_ignoreCase: true,
                            filter_reset: '.reset',
                            filter_saveFilters: true
                        }
                    }).tablesorterPager(pagerOptions1);
                    $(".pager").show();
                }else{
                    $(".pager_time").hide();
                }
            });
        });

        function getReporte(){
            var proyectoId = '{{idproyectos}}';
            $("#idReporte").val('1008');

            parametros = {};
            var inicio = $('#Filtros_fechaIni').val();
            var fin = $('#Filtros_fechaFin').val();            
            var proyecto = $('#proyecto').val();
            var valor = $('#Filtros_fechaIni').val() + " | "+ $('#Filtros_fechaFin').val();   
            var detail = $("#detail").val();
            
            var parametros = {
                'FechaInicio': inicio,
                'FechaFin': fin,
                'idReporte': $("#idReporte").val(),
                'date': valor,
                'detail': detail,
                'idproyectos':'{{idproyectos}}',
                'proyecto': proyecto
            };
            $.getJSON('{{ path('pr_getReportInventoryMDR') }}',parametros,function(data){
                var monitor = data.monitor;
                var chart1 = data.chart1;
                var chart2 = data.chart2;
                var chart = data;
                $("#total_summary").val(monitor.length);

                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>');
                    $("#inicio").show();
                }else{
                    var objectType = {"9":1,"10":2,"11":3,"12":4,"13":5,"14":6};
                    $("#reporte1").empty().append(createTable(monitor,undefined,undefined,objectType,'table1'));
                    $('.double-scroll').doubleScroll();
                    var pagerOptions = {
                        container: $(".pager"),
                        output: 'Rows : {endRow}',
                        fixedHeight: false,
                        removeRows: true,
                        cssGoto: '.gotoPage'
                    };
                    // initial sort set using sortList option
                    $(".table1").tablesorter({
                        theme: 'blue',
                        widgets: ["zebra", "filter"],
                        widgetOptions: {
                            filter_cssFilter: '',
                            filter_childRows: false,
                            filter_hideFilters: false,
                            filter_ignoreCase: true,
                            filter_reset: '.reset',
                            filter_saveFilters: true
                        }
                    }).tablesorterPager(pagerOptions);
                    $(".pager").show();
                    $("#inicio").show();
                    $("#autoload").attr('disabled',false);
                }
                $.isLoading('hide');
            })
            
        }

        function createTable(monitor,total,nombreColTotal,type,table){
            var header = Object.keys(monitor[0]);
            var headerType = Object.keys(type);
            var table = '<table  class="table table-bordered table-hover table-striped table-responsive '+table+'" id="tableSitios"> <thead>' +
                    '<tr class="btn-info">';
            for (var j = 0; j < header.length; j++) {
                if( j != 0 && 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][header['idticket']] +"'>";

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

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

                      if(header[j] == 'ESTADO'){
                          var estado = monitor[i][['ESTADO']];

                          if(estado == 'Aprobado'){
                              clases = 'btn-success';
                          }else if(estado == 'Rechazado'){
                              clases = 'btn-danger';
                          }else if(estado == 'Pendiente por Revision'){
                              clases = 'btn-warning';
                          }/*else{
                              clases = 'btn-warning';
                          }*/
                      }


                    if( j != 0 && header[j] != 'idticket' && header[j] != 'SDE') {
                        table += "<td class='"+clases+"'>" + monitor[i][header[j]] + "</td>";
                    }

                    if (header[j] == 'SDE')
                    {
                        if (monitor[i]['SDE'] != null) {
                            var un = "'" + monitor[i]['SDE'] + "'";
                            table += "<td class='text-center' ><a class='btn btn-link' target='_blank' href="+ un +">SI</a></td>";
                            //table += "<td ><a class='btn btn-link' target='_blank' href="+ un +"><img border=0; src='{{ asset('images/greencheck.png') }}'; width='20' height='20'></img></a></td>";

                        } else
                        {
                          table += "<td class='text-center'>NO</td>";
                            //table += "<td ><img border=0; src='{{ asset('images/gray_sync.png') }}'; width='20' height='20'></img></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 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 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);
                        //alert(total[key[j]]);
                    }
                    else
                        total[key[j]] +=  parseInt(valor[i][header[key[j]]]);
                }
            }
            return total;
        }
        
        function rangosFecha(opcion){
            //para el dia actual
            if (opcion=='hoy'){
                var f = new Date();
                var mes = (f.getMonth() + 1);
                if (mes < 10) mes = '0' + mes;
                var dia = f.getDate();
                if (dia < 10) dia = '0' + dia;
                var fechaI = f.getFullYear() + '-' + mes + "-" + dia;
                var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            //para ultimos_7_dias
            if (opcion=='ultimos_7_dias'){
                var f = new Date();
                //console.log(f);
                var mes = (f.getMonth() + 1);
                if (mes < 10) mes = '0' + mes;
                //OBTENER EL DIA DE LA SEMANA DE LA FECHA ACTUAL
                var weekday = f.getDay();
                //console.log(weekday);
                //SI ES LUNES
                if (weekday==1){
                    var nueva_fecha = new Date();
                    var nuevo_mes = (nueva_fecha.getMonth() + 1);
                    if (nuevo_mes < 10) nuevo_mes = '0' + nuevo_mes;
                    var dia_n = nueva_fecha.getDate();
                    if (dia_n < 10) dia_n = '0' + dia_n;
                }else{
                    if (weekday==2){ //SI ES MARTES
                        cantidad_dias_restar = 1;
                    }
                    if (weekday==3){ //SI ES MIERCOLES
                        cantidad_dias_restar = 2;
                    }
                    if (weekday==4){ //SI ES JUEVES
                        cantidad_dias_restar = 3;
                    }
                    if (weekday==5){ //SI ES VIERNES
                        cantidad_dias_restar = 4;
                    }
                    if (weekday==6){ //SI ES SABADO
                        cantidad_dias_restar = 5;
                    }
                    if (weekday==0){ //SI ES DOMINGO
                        cantidad_dias_restar = 6;
                    }
                    var dias_restar = 1000 * 60 * 60 * 24 * cantidad_dias_restar;
                    var resta = f.getTime() - dias_restar;
                    var nueva_fecha = new Date(resta);
                    var nuevo_mes = (nueva_fecha.getMonth() + 1);
                    if (nuevo_mes < 10) nuevo_mes = '0' + nuevo_mes;
                    var dia_n = nueva_fecha.getDate();
                    if (dia_n < 10) dia_n = '0' + dia_n;
                }                
                var fechaI = nueva_fecha.getFullYear() + '-' + nuevo_mes + "-" + dia_n;
                var dia = f.getDate();
                if (dia < 10) dia = '0' + dia;
                var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            //para el mes actual
            if (opcion=='mes_actual'){
                var f = new Date();
                var mes = (f.getMonth() + 1);
                if (mes < 10) mes = '0' + mes;
                var fechaI = f.getFullYear() + '-' + mes + "-01";
                var dia = f.getDate();
                if (dia < 10) dia = '0' + dia;
                var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }
            //para mes_anterior
            if (opcion=='mes_anterior'){
                //desde
               const f1=moment().subtract(1, 'months').startOf('month').format('DD-MM-YYYY');
               //console.log(f1);
               var fInicial = f1.split('-');
               //hasta
               const f2=moment().subtract(1, 'months').endOf('month').format('DD-MM-YYYY');
               var fFinal = f2.split('-');
               //actualizar
               var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
               var fechaF = fFinal[2] + '-' + fFinal[1] + "-" + fFinal[0];

            }
            //para las 6 meses
            if (opcion=='ultimo_6_meses'){
                //desde
               const f1=moment().subtract(5, 'months').startOf('month').format('DD-MM-YYYY');
               //console.log(f1);
               var fInicial = f1.split('-');
               //hasta
               var f = new Date();
               var mes = (f.getMonth() + 1);
               if (mes < 10) mes = '0' + mes;               
               //actualizar
               var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
               var fechaF = f.getFullYear() + '-' + mes + "-" + f.getDate();
            }
            //para las 12 meses
            if (opcion=='ultimo_12_meses'){
                //desde
               const f1=moment().subtract(12, 'months').startOf('month').format('DD-MM-YYYY');
               var fInicial = f1.split('-');
               //hasta
               var f = new Date();
               var mes = (f.getMonth() + 1);
               if (mes < 10) mes = '0' + mes;               
               //actualizar
               var dia = f.getDate();
               if (dia < 10) dia = '0' + dia; 
               var fechaI = fInicial[2] + '-' + fInicial[1] + "-" + fInicial[0];
               var fechaF = f.getFullYear() + '-' + mes + "-" + dia;
            }            
            $('#Filtros_fechaIni').val(fechaI);
            $('#Filtros_fechaFin').val(fechaF);
            if (opcion!='rango_fecha'){
                $("#generar").trigger('click');
            }
        }

        //configuracion de los datatable
        function buildDatatablePrin(render, columnas, data,suffix_export,orderArray)
        {
            var a=[];b=[];
            var Defs = [];
            var ini = (columnas.length) -5;
            var kpi = '';
            if (render=='table_IssuesExecuted'){
                kpi = 'Issues Executed';
            }else if(render=='table_ExecutedNotExecuted'){
                kpi = 'Reasons Not Executed';
            }

            for (var i=0; i<=(columnas.length - 1); i++){
                a.push(i);
            }
            Defs.push({ targets: a, className: 'dt-body-center' });
            for (var i=0; i<=(columnas.length - 1); i++){
                if (columnas[i].visible){
                    b.push(i);
                }
            }
            table = $('#'+render).DataTable( {
                dom: '<"row" <"col-md-12 text-right"B>> <"row" <"col-md-6 "l> <"col-md-6"f>>rtip',
                scrollY: '60vh',
                scrollX: true,
                scrollCollapse: true,
                orderCellsTop: true,
                data:data,
                "deferRender": false,
                "processing": true,
                "language": {
                    "processing": "<div class='table-loading' style='z-index: 99999'><img src='{{ asset('images/spiral.gif') }}' /></div>"
                },
                //"order": [[ 0, "asc" ]],
                "ordering": false,
                columns: columnas,
                columnDefs: Defs,
                lengthMenu: [[25, 50, 100, 250, 500], [25, 50, 100, 250, 500]],
                buttons: [
                    {
                        extend:'excel',
                        text: 'Table Excel ' + kpi,
                        exportOptions: {
                            columns: b,
                            orthogonal: 'export'
                        },
                        title: 'Usage' + kpi
                    }
                ],
                drawCallback: function() {
                    $('[data-toggle="popover"]').popover();
                }
            } );
        }

    </script>

    <div class="container-fluid">
        <input type="hidden" id="total_summary" name="total_summary">
        <input type="hidden" id="total_time" name="total_time">
        <div class="row">
            <div class="col-lg-2" id="parametros">
            </div>
            <div class="col-lg-2" id="parametros">
            </div>
            <div class="col-lg-2 " id="parametros" >
            </div>
            <div class="col-lg-3" id="parametros" >
            </div>

        </div>
        <div class="panel panel-primary">
                <div class="panel-heading">
                    <h3 class="panel-title"><a data-toggle="collapse" href="#collapse1">Filters <span class="caret"></span></a></h3>
                </div>
                <div id="collapse1" class="panel-collapse collapse in">
                    <div id="panelFilter" class="panel-body">
                        <div class="row">
                            <input type="hidden" class="form-control" id="Filtros_fechaIni" name="Filtros_fechaIni" value="">
                            <input type="hidden" class="form-control" id="Filtros_fechaFin" name="Filtros_fechaFin" value="">
                            <div class="row"> 
                                <div class="col-md-7 col-sm-6 col-xs-12">
                                    <div class="form-group">
                                        <label>Date Filter: <span class="detalleRango"></span> </label><br>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="hoy">Today</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimos_7_dias">Week</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="mes_actual">This Month</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="mes_anterior">Last Month</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_6_meses">Last 6 Months</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="ultimo_12_meses">Last 12 Months</button>
                                        <button type="button" class="btn btn-default ajuste_fecha" id="rango_fecha">Custom Range</button>
                                    </div>
                                </div> 
                                <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                                    <div class="form-group">                                            
                                       <label>{{'monitor.etiqueta.fechaI' | trans}}: </label>
                                        <input type="text" class="form-control" id="fechaIni" name="fechaIni" value="">
                                    </div> 
                                </div>   
                                <div  class="col-md-2 col-sm-8 col-xs-12 div_fecha">
                                    <div class="form-group">                                            
                                        <label>{{'monitor.etiqueta.fechaF' | trans}}: </label>
                                        <input type="text" class="form-control" id="fechaFin" name="fechaFin" value="">
                                    </div> 
                                </div> 
                            </div>                            
                        </div>
                        {# if idproyectos==11 #}
                        
                            <div class="row">  
                                <div class="col-md-3 col-sm-3 col-xs-12">
                                    <div class="form-group">
                                        <label>{{'PROJECT' | trans}}: </label><br>
                                        <select class="form-control" id="proyecto" name="proyecto[]" multiple="multiple" style="width: 100%;">                                            
                                                {%for proyecto in proyectos %}
                                                    <option value="{{proyecto.proyecto}}">{{proyecto.proyecto}}</option>
                                                {%endfor%}
                                        </select>

                                        
                                    </div>
                                </div>                                                           
                         {# endif #}
                        <div class="row">
                            <div class="col-md-4 col-sm-4 col-xs-12">                                
                            </div>
                            <div class="col-md-4 col-sm- col-xs-12">
                                    <label for="generar">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</label>
                                    <button class="btn btn-primary form-control" id="generar">{{'ticketDetail.boton.generar' | trans}}</button>
                            </div>
                            <div class="col-md-4 col-sm-4 col-xs-12">
                            </div>
                        </div>
                    </div>  
                </div>
        </div>
        <div class="row">
            {% if identity is not empty %}

                <div class="pull-right" style="">

                    <div class="col-lg-12">
                        <img id="logo" src="{{ asset( identity.pathLogo ) }}"  width="350" height="65">
                        <p class="text-center" style="font-size: 14pt;font-weight: bold;">{{ identity.alias }}</p>
                    </div>
                </div>

            {% endif %}

        </div>
       </div>
    <div id="inicio">
        
        <row>
            <div class="col-lg-12 col-md-12">
                <h1 class="text-center text-primary"><i class="fa fa-file-text-o"></i>MDR Despachados</h1>
            </div>
        </row>        

        <div class="tab-content" style="margin-top: 20px;">

                <div class="row">
                    <div class="btn-group pull-right" 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>-->
                        <form id="formExport"  action="{{ path('exportReporte',{'idproyectos':idproyectos}) }}" method="POST">
                            <input type="hidden" id="idReporte" name="idReporte" value="1008">
                        </form>
                        <a id="export" href="{{ path('exportReporte',{'idproyectos':idproyectos}) }}?idReporte=1008" > <img src={{ asset("images/xls.png")}} width="24px"> XLS</a>

                    </div>

                </div>
                <div class="pager pager_summary">
                    <a  class="reset"><i class="fa fa-eraser" aria-hidden="true"></i></a>
                    <span class="pagedisplay"></span>
                </div>
                <div class="row double-scroll" id="reporte1">


                </div>

        </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>


{% endblock %}
{% block javascripts %}
    <link rel="stylesheet" href="{{ asset('css/jquery.dataTables.min.css')}}">
    <link rel="stylesheet" href="{{ asset('css/buttons.dataTables.min.css')}}">
    <link rel="stylesheet" href="{{ asset('datatables/css/select.bootstrap.min.css')}}">
    <script src="{{ asset('js/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('js/buttons.flash.min.js') }}"></script>
    <script src="{{ asset('js/jszip.min.js') }}"></script>
    <script src="{{ asset('js/pdfmake.min.js') }}"></script>
    <script src="{{ asset('js/vfs_fonts.js') }}"></script>
    <script src="{{ asset('js/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('js/buttons.print.min.js') }}"></script>
    <script src="{{ asset('datatables/js/dataTables.select.min.js') }}"></script>
    <script src="{{ asset('datatables/moment.min.js') }}"></script>
    <script src="{{ asset('datatables/js/datetime-moment.js') }}"></script>
    <script src="{{ asset('js/grouped-categories.js') }}"></script>
    <script type="text/javascript" src="{{ asset('bootstrap-multiselect/js/bootstrap-multiselect.js') }}"></script>
{% endblock %}