{% extends 'base.html.twig' %}

{% block body_id 'search' %}

    {#
        the homepage is a special page which displays neither a header nor a footer.
        this is done with the 'trick' of defining empty Twig blocks without any content
    #}

    {% block stylesheets %}
        {{ parent() }}
        <link rel="stylesheet" href="{{ asset('static/c4rg0_themes/assets/js/vendor/datatables/css/dataTables.bootstrap.css') }}">
        <link rel="stylesheet" href="{{ asset('static/c4rg0_themes/assets/js/vendor/datatables/css/ColVis.css') }}">
        <link rel="stylesheet" href="{{ asset('static/c4rg0_themes/assets/js/vendor/datatables/css/TableTools.css') }}">
        <link rel="stylesheet" href="{{ asset('static/DataTables/DataTables-1.10.20/css/jquery.dataTables.min.css') }}">
        <link rel="stylesheet" href="{{ asset('static/c4rg0_themes/assets/js/vendor/datepicker/css/bootstrap-datetimepicker.css') }}">
    {% endblock %}

    {% block header %}
    {% endblock %}

    {% block modal %}
        {{ parent() }}
        <div class="md-modal md-effect-10 md-hotpink colorize-overlay" id="id-msg-red">
            <div class="md-content">
                <h3>ERROR</h3>   
                <div id="id-msg-err" class="tile-body nopadding rounded-corners">
                </div>
                <button class="md-close btn btn-default">{{ "OK"|trans }}</button>
            </div>
        </div>
        <div class="md-modal md-effect-10 md-black colorize-overlay" id="id-msg-log" style="min-width: 90%;">
            <div class="md-content" style="background-color: #08354E;">
                <h3>LOG</h3>   
                <div id="id-log-err" class="tile-body nopadding rounded-corners">
                    <div class="log-table" id="id-log-table" style="max-height: 800px; overflow: auto; padding: 10px; margin: 6px;">

                        <section id="log-result" class="tile transparent">   
                            <div id="id-log-error-msg" class="error-red"></div>
                            <table id="logresult" class="display search-result table-datatable" style="width:100%">
                                <thead>
                                    <tr>
                                        <th>{{ "Items Code"|trans }}</th>
                                        <th>{{ "Date"|trans }}</th>
                                        <th>{{ "Try"|trans }}</th>                                     
                                        <th>{{ "Status"|trans }}</th>
                                        <th>&nbsp;</th>
                                    </tr>
                                </thead>
                            </table>            
                        </section>                      

                    </div>
                </div>
                <div style="padding: 10px;">
                    <button onclick="javascript: closeLog();" class="md-close btn btn-default">{{ "OK"|trans }}</button>
                </div>
            </div>
        </div>
        <div class="md-overlay"></div><!-- the overlay element -->        

    {% endblock %}

    {% block body %}

        <!-- Page content -->
        <div id="content" class="col-md-12">

            <!-- page header -->
            <div class="pageheader">




            </div>

            <div class="col-md-12">
                <section class="tile transparent" id="id-search-block" style="margin-top: 55px;">
                    <!-- tile widget -->
                    <div class="tile-widget color transparent-black rounded-top-corners">
                        <div class="block-menu-filter menu-start">
                            <div class="btn-group btn-w100" style="padding-right: 20px; width: unset; display: inline-block;">
                                <a href="{{ path('managment_pannel_page') }}">
                                    <h1>
                                        <i class="fa fa-briefcase"></i>
                                        {{ 'Management'|trans }}
                                    </h1>
                                </a>
                            </div>

                        </div>
                        <div class="block-menu-filter menu-center">
                            <div class="btn-group btn-w100">
                                <img class="logo-delivered-erp" style="width: 4vw;" src="{{ asset('/static/images/loghi_aziende/Oracle_Corporation_logo.svg') }}">
                            </div>
                        </div>
                        <div class="block-menu-filter menu-end">
                            <div class="btn-group">
                                <a class="on-close-btn" href="javascript:window.history.back();" title="Back"><div class="user-close"><i class="fas fa-chevron-circle-left"></i></div></a>
                            </div>
                        </div>
                    </div>

                </section>
            </div>    

            <!-- /page header -->

            <!-- tile -->

            <!--    <section id="search-result" class="tile transparent">
    
                    <style>
                        .lds-ring {
                            display: inline-block;
                            position: relative;
                            width: 64px;
                            height: 64px;
                        }
                        .lds-ring div {
                            box-sizing: border-box;
                            display: block;
                            position: absolute;
                            width: 51px;
                            height: 51px;
                            margin: 6px;
                            border: 6px solid #fff;
                            border-radius: 50%;
                            animation: lds-ring 1.2s cubic-bezier(0.5, 0, 0.5, 1) infinite;
                            border-color: #fff transparent transparent transparent;
                        }
                        .lds-ring div:nth-child(1) {
                            animation-delay: -0.45s;
                        }
                        .lds-ring div:nth-child(2) {
                            animation-delay: -0.3s;
                        }
                        .lds-ring div:nth-child(3) {
                            animation-delay: -0.15s;
                        }
                        @keyframes lds-ring {
                            0% {
                                transform: rotate(0deg);
                            }
                            100% {
                                transform: rotate(360deg);
                            }
                        }
    
                    </style>
                    <div style="width: 100%; height: 200px; text-align: center; margin-top: 100px;">
                        <div class="lds-ring"><div></div><div></div><div></div><div></div></div>
                    </div>
                    
                    
                    
                    
                </section> -->

            <div class="col-md-12">

                <section class="tile transparent" id="id-search-block" style="margin-top: 0;">
                    <!-- tile widget -->


                    <div class="tile-widget color transparent-black rounded-top-corners">
                        <div class="block-menu-filter menu-start">
                            <div class="btn-group" style="margin-left: 10px;">
                                <input type="text" class="form-control" id="id-search" style="width: 20vw;float: left;background-color: #d3d3d369;margin-right: 6px;">                                
                                <button style="height: 38px;" onclick="javascript:search();" type="button" class="btn btn-blue margin-left-20"><i class="fa fa-search fa-2x"></i></button>
                            </div>
                        </div>
                        <div class="block-menu-filter menu-center">
                            <div class="btn-group btn-w100">
                                <input autocomplete="off" type="text" class="form-control datepicker" id="datepicker" style="width: 14vw; float: left; background-color: #d3d3d369; margin-right: 6px;" placeholder="{{ "Select date"|trans }}"/>
                                <label for="datepicker" class="control-label" style="float: left;"><i class="fa fa-calendar fa-2x"></i></label>
                            </div>
                        </div>
                        <div class="block-menu-filter menu-end">
                            <div class="btn-group" style="float: right;">

                                <button type="button" id="type-D30" class="btn btn-custom filter-menu" onclick="javascript:log(-1)">{{ 'Show global log'|trans }}</button>
                            </div>                        
                        </div>
                    </div>
                    <div class="detail-search"></div>
                </section>



                <section id="search-result" class="tile transparent">   
                    <div id="id-error-msg" class="error-red"></div>
                    <table id="searchresult" class="display search-result table-datatable" style="width:100%">
                        <thead>
                            <tr>
                                <th>{{ "Date"|trans }}</th>
                                <th>{{ "Items Code"|trans }}</th>
				<th>{{ "Weight [Kg]"|trans }}</th>
                             {#   <th>{{ "Volume"|trans }}</th> #}
				<th>{{ "H [m]"|trans }}</th>
				<th>{{ "L [m]"|trans }}</th>
				<th>{{ "W [m]"|trans }}</th>
                              {#  <th style="text-align: center;">{{ "N. Box"|trans }}</th>#}
                                <th>{{ "Status"|trans }}</th>
                                <th>{{ "Upload Date"|trans }}</th>
                                <th>&nbsp;</th>
                                <th>&nbsp;</th>
                            </tr>
                        </thead>
                    </table>            
                </section>     
            </div>
            <br />

            <br /><br /><br /><br /><br /><br /><br /><br />
            <!-- /tile -->








        </div>
        <!-- Page content end -->
    {% endblock %}
    {% block javascripts %}
        {{ parent() }}
        <script type="text/javascript" src="{{ asset('static/js/base64.js') }}"></script>

        <script type="text/javascript" src="{{ asset('static/c4rg0_themes/assets/js/vendor/datatables/jquery.dataTables.min.js') }}"></script>
        <script type="text/javascript" src="{{ asset('static/c4rg0_themes/assets/js/vendor/datatables/ColReorderWithResize.js') }}"></script>
        <script type="text/javascript" src="{{ asset('static/c4rg0_themes/assets/js/vendor/datatables/colvis/dataTables.colVis.min.js') }}"></script>
        <script type="text/javascript" src="{{ asset('static/c4rg0_themes/assets/js/vendor/datatables/tabletools/ZeroClipboard.js') }}"></script>
        <script type="text/javascript" src="{{ asset('static/c4rg0_themes/assets/js/vendor/datatables/tabletools/dataTables.tableTools.min.js') }}"></script>
        <script type="text/javascript" src="{{ asset('static/c4rg0_themes/assets/js/vendor/datatables/dataTables.bootstrap.js') }}"></script>
        <script type="text/javascript" src="{{ asset('static/c4rg0_themes/assets/js/vendor/chosen/chosen.jquery.min.js') }}"></script>        
        <script type="text/javascript" src="{{ asset('static/js/moment/moment.min.js') }}"></script>
        <script type="text/javascript" src="{{ asset('static/DataTables/DataTables-1.10.20/js/jquery.dataTables.min.js') }}"></script>
        <script type="text/javascript" src="{{ asset('static/DataTables/dataTables.fixedHeader.min.js') }}"></script>


        <script type="text/javascript" src="{{ asset('static/c4rg0_themes/assets/js/vendor/momentjs/moment-with-langs.min.js') }}"></script>

        <script type="text/javascript" src="{{ asset('static/c4rg0_themes/assets/js/vendor/datepicker/bootstrap-datetimepicker.min.js') }}"></script>
        <script type="text/javascript" src="{{ asset('static/js/jquery-dateformat.min.js') }}"></script>
        {{ encore_entry_script_tags('search') }}
        <script>
            var table = null;
            var tablelog = null;
            var tot = 0.0;
            var tipo = '{{ tipo }}';
            var filtri = '{{ filtri }}';
            var filtrodata = '{{ data }}';
            var cursearch = "{{ path(path, {'data':data,'p':tipo,'filtri':filtri}) }}";
            var logcursearch = "{{ path(path, {'data':'A','p':'','filtri':''}) }}";
            function searchByDate(date, cleardate, clearsearch) {
                table.clear();
                $('.block-menu-filter.menu-end .filter-menu').removeClass('filter-selected');
                if (cleardate) {
                    $("#dataDa").val('');
                    $("#dataA").val('');
                }
                if (clearsearch) {
                    $('#id-search').val('');
                }
                if (!date.startsWith('R')) {
                    $('.filter-menu#type-' + date).addClass('filter-selected');
                    $('#id-search').val('');
                } else {
                }
                filtrodata = date;
                cursearch = "{{ path(path, {'data':':::VALORE','p':':::TIPO'}) }}".replace(':::VALORE', date).replace(':::TIPO', tipo);
                table.ajax.url(cursearch).load().draw();
                $('.dataTables_empty').html('<div id="page-wrapper"><div class="loading">Loading...</div></div>');
            }
            function search() {
                var searchval = 'R' + Base64.encode($('#id-search').val());
                filtrodata = searchval;
                searchByDate(searchval, true, false);
            }
            function conteggi() {
                location.href = '{{ path('list_page') }}';
            }
            function acquisizioni() {
                location.href = '{{ path('search_page') }}';
            }
            $(function () {
                /* Get the rows which are currently selected */
                //initialize datepicker
                $('.open-search-advance').on('click', function (ev) {
                    if ($(this).hasClass('fa-chevron-down')) {
                        $(this).removeClass('fa-chevron-down')
                        $(this).addClass('fa-chevron-up')
                        $('#id-search-block').animate({height: '+=200'}, 100, function () {
                            $(".detail-search").fadeIn(500);
                        });
                    } else {
                        $(this).removeClass('fa-chevron-up')
                        $(this).addClass('fa-chevron-down')
                        $(".detail-search").fadeOut(500);
                        $('#id-search-block').animate({height: '-=200'});
                    }
                });

                jQuery.extend(jQuery.fn.dataTableExt.oSort, {
                    "alt-string-pre": function (a) {
                        var valore = a.match(/alt="(.*?)"/);
                        if (valore !== null && valore.length > 1) {
                            return a.match(/alt="(.*?)"/)[1].toLowerCase();
                        } else {
                            return '';
                        }
                    },
                    "alt-string-asc": function (a, b) {
                        return ((a < b) ? -1 : ((a > b) ? 1 : 0));
                    },
                    "alt-string-desc": function (a, b) {
                        return ((a < b) ? 1 : ((a > b) ? -1 : 0));
                    },
                    "items-pre": function (a) {
                        var valore = a.match(/data-value="(.*?)"/);
                        if (valore !== null && valore.length > 1) {
                            var sv = a.match(/data-value="(.*?)"/)[1].toLowerCase();
                            var v = parseInt(sv)
                            if (isNaN(v)) {
                                return 0;
                            } else {
                                return v;
                            }
                        } else {
                            return '';
                        }
                    },
                    "items-asc": function (a, b) {
                        return ((a < b) ? -1 : ((a > b) ? 1 : 0));
                    },
                    "items-desc": function (a, b) {
                        return ((a < b) ? 1 : ((a > b) ? -1 : 0));
                    }
                });
                var today = new Date();
                var dd = today.getDate();

                var mm = today.getMonth() + 1;
                var yyyy = today.getFullYear();
                if (dd < 10)
                {
                    dd = '0' + dd;
                }

                if (mm < 10)
                {
                    mm = '0' + mm;
                }

                today = mm + '/' + dd + '/' + yyyy;

                $('#datepicker').datetimepicker({
                    format: "DD/MM/YYYY",
                    defaultDate: today,
                    icons: {
                        time: "fa fa-clock-o",
                        date: "fa fa-calendar",
                        up: "fa fa-arrow-up",
                        down: "fa fa-arrow-down"
                    }
                });

                $("#datepicker").on("dp.show", function (e) {
                    var newtop = $('.bootstrap-datetimepicker-widget').position().top - 45;
                    $('.bootstrap-datetimepicker-widget').css('top', newtop + 'px');
                });

                $("#datepicker").on("dp.change", function (e) {
                    var mese = (e.date.month() + 1);
                    var datasel = e.date.year().toString() + '-' + mese.toString().padStart(2, '0') + '-' + e.date.date().toString().padStart(2, '0');
                    $(this).blur();
                    searchByDate(datasel, false, true);
                    //    location.href="{{ path('stat_page', {'id':2,'data':'DATASELEZIONATA'}) }}".replace('DATASELEZIONATA', datasel);
                    // alert();
                });



                $('.block-menu-filter.menu-end .filter-menu').removeClass('filter-selected');
                if ('{{ data }}'.startsWith('R')) {
                    var searchval = Base64.decode('{{ data }}'.substring(1));
                    $('#id-search').val(searchval);
                } else {
                    $('.filter-menu#type-{{ data }}').addClass('filter-selected');
                }
                table = $('#searchresult').DataTable({
                    "ajax": {
                        "type": "GET",
                        "url": "{{ path(path, {'data':data,'p':tipo,'filtri':filtri}) }}",
                        "dataSrc": function (json) {
                            $('#search #search-result .error-red').html('');
                            $('#search #search-result .error-red').hide();
                            if (json.err === 0) {
                                tot = json.tot;
                                return json.data;
                            } else {
                                tot = 0;
                                $('#search #search-result .error-red').html(json.errmsg);
                                $('#search #search-result .error-red').show();
                                return new Array();
                            }
                        }
                    },
                    "language": {
                        "search": "{{ 'Filter records'|trans }}:"
                    },
                    "fixedHeader": true,
                    "lengthMenu": [25, 50, 100, 200, 500],
                    "deferRender": true,
                    "order": [[0, "desc"]],
                    "columns": [
                        {"data": "Date"},
                        {"data": "obj_code"},
			{"data": "weight"},
                        {#     {"data": "volume"},#}
			{"data": "h"},
			{"data": "l"},
			{"data": "w"},
                        {# {"data": "DatoScelto"},#}
                        {"data": "StatoText"},
                        {"data": "last_ok"},
                        {"data": "last_err"}
                    ]
                    , "columnDefs": [
                        {
                            "render": function (data, type, row) {
                                if (data !== null && data != "") {
                                    return '<span class="hide-column">' + data + '</span>' + window.moment(data, 'YYYY-MM-DD HH:mm:ss', 'it', true).format('DD/MM/YYYY HH:mm');
                                } else {
                                    return data;
                                }
                            },
                            "width": "15%",
                            "targets": 0
                        },
                        {
                            "render": function (data, type, row) {
                                if (parseInt(row['nudo_vestito']) === 1) {
                                    return '<a href="' + row['awburl'] + '"><div class="grid-search-icon"><img class="grid-search-icon-img" src="{{ asset('/static/c4rg0_themes/assets/images/icons/ico_packed_p.png') }}"></div>' + data + '</a>';
                                } else {
                                    return '<a href="' + row['awburl'] + '"><div class="grid-search-icon"></div>' + data + '</a>';
                                }
                            },
                            "targets": 1
                        },
                        {
                            "render": function (data, type, row) {
                                var stato = parseInt(row['status']);
                                var id = parseInt(row['id']);
                                return '<i data-id="' + id + '" onclick="javascript:downloadExport(6, ' + id + ');" alt="Download json file" class="fa fa-file-code" style="font-size: 23px; margin-right: 10px; display: inline-block;"></i><div class="label-stato stato-items-' + stato + '" style="display: inline-block;">' + data + '</div>';
                            },
                            "targets": 6
                        },
                        {
                            "render": function (data, type, row) {
                                if (data !== null && data != "") {
                                    return '<span class="hide-column">' + data + '</span>' + window.moment(data, 'YYYY-MM-DD HH:mm:ss', 'it', true).format('DD/MM/YYYY HH:mm');
                                } else {
                                    return data;
                                }
                            },
                            "width": "15%",
                            "targets": 7
                        },
                        
                        {
                            "render": function (data, type, row) {
                                var stato = parseInt(row['status']);
                                var id = parseInt(row['id']);
                                return '<a href="#" style="margin-right: 14px; font-weight: 900;" onclick="javascript:log(' + id + ')">LOG</a>';
                            },
                            "orderable": false,
                            "targets": 9 
                        },
                        {
                            "render": function (data, type, row) {
                                var stato = parseInt(row['status']);
                                var show_err = parseInt(row['show_error']);
                                var ret = '';
                                var logtxt = '';
                                var logstatus = parseInt(row['logstatus']);
                                //var stato = parseInt(data);
                                var last_err = row['last_err'];
                                var format_last_err_date = '';
                                if (last_err !== null && last_err != "") {
                                    format_last_err_date = '<span class="hide-column">' + last_err + '</span>' + window.moment(last_err, 'YYYY-MM-DD HH:mm:ss', 'it', true).format('DD/MM/YYYY HH:mm');
                                } else {
                                    format_last_err_date = last_err;
                                }

                                if (!isNaN(logstatus)) {
                                    var pstato = -logstatus;
                                    switch (pstato) {
                                        case 0:
                                            logtxt = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\"><img id=\"logo-oracle-" + row['id'] + "\" class=\"logo-delivered logo-status\" src=\"{{ asset('/static/images/loghi_aziende/Oracle_Corporation_logo.svg') }}\">Ok</div>"; 
                                            break;
                                        case 1:
                                            logtxt = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\">{{ 'Token Connection Error'|trans }}</div>"; 
                                            break;
                                        case 2:
                                            logtxt = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\">{{ 'Token Response Error'|trans }}</div>"; 
                                            break;
                                        case 3:
                                            logtxt = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\">{{ 'Oracle Connection Error'|trans }}</div>"; 
                                            break;
                                        case 4:
                                            logtxt = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\">{{ 'Oracle Invalid Response Error'|trans }}</div>"; 
                                            break;
                                        case 100:
                                            //var response = JSON.parse(row['id']);
                                            logtxt = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\">{{ 'Oracle Response Error'|trans }}</div>"; 
                                            break;
                                        default:
                                            logtxt = logstatus;
                                    }
                                }

                                        ret = '<table id="alert-' + row['id'] + '" class="alert-log-area alert-stato-' + stato + '">'
                                        + '<tr>'
                                + '<td class="col-alert">' + ((show_err === 1) ? '<span class="certificate my-tooltip"><i class="fas fa-exclamation-triangle"></i><span class="tooltiptext" style="text-align: left; padding: 10px; height: 200px;">{{ 'Last Error'|trans }}:<br />' + logtxt + '</br />{{ 'Date'|trans }}: ' + format_last_err_date + '</span></span>' : '') + '</td>'
                                        + '<td class="col-erp"><img class="logo-delivered-erp" src="{{ asset('/static/images/loghi_aziende/Oracle_Corporation_logo.svg') }}"></td>'
                                        + '<td class="col-cloud"><img class="logo-delivered-cloud" src="{{ asset('/static/images/ICO_Cloud_C4RGO.png') }}"></td>'
                                        + '<td class="col-retry-3"><img class="logo-on-process" src="{{ asset('/static/images/retry-Oracle_TR_azzurro.png') }}"></img></td>'
                                        + '<td class="col-retry-more"><div>{{ 'Retry'|trans }}</div></td>'
                                        + '<td class="col-retry-incompleted"><div>{{ 'Incompleted'|trans }}</div></td>'
                                        + '<td class="col-retry-empty"><div>&nbsp;</div></td>'                                
                                        + '</tr>'
                                        + '</table>';                                
                                switch (stato) {
                                    case 1:

//                                        ret = "<div class=\"info stato-items-" + stato + "\" id=\"spin-id-" + row['conta'] + "\"></div>";
                                        break;
                                    case 2:
                                        //ret = "<div class=\"info stato-items-" + stato + "\" id=\"spin-id-" + row['conta'] + "\">{{ 'Incompleted data'|trans }}</div>";
                                        break;
                                    case 3:
                                        //ret = "";
                                        break;
                                    case 4:
                                        //ret = "<i class=\"fas fa-exclamation-triangle\" style=\"color: yellow;margin-right: 10px;\"></i><img id=\"logo-oracle-" + row['conta'] + "\" class=\"logo-on-process logo-status\" src=\"{{ asset('/static/images/retry-Oracle_TR_azzurro.png') }}\"></img><div class=\"n-retry\" id=\"n-retry-id-" + row['export_retry'] + "\" style=\"display: inline-block;\"> (" + row['nretry'] + ")</div>";
                                        break;
                                    case 5:
                                        //ret = "<i class=\"fas fa-exclamation-triangle\" style=\"color: yellow;margin-right: 10px; display: inline-block;\"></i><div class=\"info stato-items-" + stato + "\" id=\"spin-id-" + row['conta'] + "\" style=\"display: inline-block;\">{{ 'Retry'|trans }} (" + row['nretry'] + ")</div>";
                                        break;
                                    case 6:
                                        //ret = "<i class=\"fas fa-exclamation-triangle\" style=\"color: yellow;margin-right: 10px;\"></i><div class=\"info stato-items-" + stato + "\" id=\"spin-id-" + row['conta'] + "\">" + row['incompleti'] + "</div>";
                                        break;
                                    case 7:
                                       // ret = "<div class=\"info stato-items-" + stato + "\" id=\"spin-id-" + row['conta'] + "\"></div>";
                                        break;
                                    case 8:
                                       // ret = "<div class=\"info stato-items-" + stato + "\" id=\"spin-id-" + row['conta'] + "\"><img id=\"logo-oracle-" + row['id'] + "\" class=\"logo-delivered logo-status\" src=\"{{ asset('/static/images/loghi_aziende/Oracle_Corporation_logo.svg') }}\"><img id=\"logo-cloud-" + row['id'] + "\" class=\"logo-delivered-cloud logo-status\" src=\"/static/images/ICO_Cloud_C4RGO.png\"></div>";
                                        break;
                                    case 9:
                                        //ret = "<div class=\"info stato-items-" + stato + "\" id=\"spin-id-" + row['conta'] + "\"><img id=\"logo-cloud-" + row['id'] + "\" class=\"logo-delivered-cloud logo-status\" src=\"/static/images/ICO_Cloud_C4RGO.png\"></div>";
                                        break;
                                    case 10:
                                       // ret = "<div class=\"info stato-items-" + stato + "\" id=\"spin-id-" + row['conta'] + "\"><img id=\"logo-cloud-" + row['id'] + "\" class=\"logo-delivered-cloud logo-status\" src=\"/static/images/ICO_Cloud_C4RGO.png\"></div>";
                                        break;
                                    case 11:
                                       // ret = "<div class=\"info stato-items-" + stato + "\" id=\"spin-id-" + row['conta'] + "\"><img id=\"logo-cloud-" + row['id'] + "\" class=\"logo-delivered-cloud logo-status\" src=\"/static/images/ICO_Cloud_C4RGO.png\"></div>";
                                        break;
                                    default:
                                      //  ret = '';
                                }
                                return ret;
                            },
                            "width": "300px",
                            "orderable": false,
                            "targets": 8
                        }
                        // , { "visible": false,  "targets": [ 4 ] }
                    ],
                    "headerCallback": function (thead, data, start, end, display) {
                        /*  var api = this.api(), data;
                         var caption = "{{ 'N. Items'|trans }}";
                         var total = "{{ 'Total items'|trans }}";
                         switch (tipo) {
                         case 'S':
                         caption = "{{ 'N. Items'|trans }}";
                         total = "{{ 'Total items'|trans }}";
                         break;
                         case 'CW':
                         caption = "{{ 'Weight'|trans }}";
                         total = "{{ 'Total weight'|trans }}";                                
                         break;
                         case 'CV':
                         caption = "{{ 'Volume'|trans }}";
                         total = "{{ 'Total volume'|trans }}";                                
                         break;
                         case 'W':
                         caption = "{{ 'Weight'|trans }}";                                
                         total = "{{ 'Total weight'|trans }}";                                
                         break;
                         case 'V':
                         caption = "{{ 'Volume'|trans }}";
                         total = "{{ 'Total volume'|trans }}";                                
                         break;
                         case 'A':
                         caption = "{{ 'N. Items'|trans }}";
                         total = "{{ 'Total items'|trans }}";
                         break;
                         case 'O':
                         caption = "{{ 'N. Objects'|trans }}";
                         total = "{{ 'Total objects'|trans }}";
                         break;
                         case 'I':
                         caption = "{{ 'N. Items'|trans }}";
                         total = "{{ 'Total items'|trans }}";
                         break;
                         default:
                         
                         }
                         $(thead).find('th').eq(2).html( total + ': ' + String(tot));
                         $( api.column( 2 ).header() ).html(
                         caption
                         );*/

                    }
                });







                tablelog = $('#logresult').DataTable({
                    "ajax": {
                        "type": "GET",
                        "url": "{{ path(logurl, {'data':'N','p':'A','filtri':filtri}) }}",
                        "dataSrc": function (json) {
                            $('#search #search-result .error-red').html('');
                            $('#search #search-result .error-red').hide();
                            if (json.err === 0) {
                                tot = json.tot;
                                return json.data;
                            } else {
                                tot = 0;
                                return new Array();
                            }
                        }
                    },
                    "language": {
                        "search": "{{ 'Filter records'|trans }}:"
                    },
                    "fixedHeader": true,
                    "lengthMenu": [10, 25, 50, 100, 200, 500],
                    "deferRender": true,
                    "order": [[0, "desc"]],
                    "columns": [
                        {"data": "obj_code"},
                        {"data": "logdate"},
                        {"data": "logtry"},
                        {"data": "logstatus"},
                        {"data": "logid"},
                    ]
                    , "columnDefs": [
                        {
                            "render": function (data, type, row) {
                                if (data !== null && data != "") {
                                    return '<span class="hide-column">' + data + '</span>' + window.moment(data, 'YYYY-MM-DD HH:mm:ss', 'it', true).format('DD/MM/YYYY HH:mm');
                                } else {
                                    return data;
                                }
                            },
                            "width": "15%",
                            "targets": 1
                        },
                        {
                            "render": function (data, type, row) {
                                var stato = parseInt(data);
                                if (!isNaN(stato)) {
                                    var ret = '';
                                    var pstato = -stato;
                                    switch (pstato) {
                                        case 0:
                                            ret = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\"><img id=\"logo-oracle-" + row['id'] + "\" class=\"logo-delivered logo-status\" src=\"{{ asset('/static/images/loghi_aziende/Oracle_Corporation_logo.svg') }}\">Ok</div>"; 
                                            break;
                                        case 1:
                                            ret = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\"><i id=\"logo-oracle-" + row['id'] + "\" class=\"fa fa-chain-broken logo-delivered logo-status\"></i>{{ 'Token Connection Error'|trans }}</div>"; 
                                            break;
                                        case 2:
                                            ret = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\"><i id=\"logo-oracle-" + row['id'] + "\" class=\"fa fa-chain-broken logo-delivered logo-status\"></i>{{ 'Token Response Error'|trans }}</div>"; 
                                            break;
                                        case 3:
                                            ret = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\"><i id=\"logo-oracle-" + row['id'] + "\" class=\"fa fa-chain-broken logo-delivered logo-status\"></i>{{ 'Oracle Connection Error'|trans }}</div>"; 
                                            break;
                                        case 4:
                                            ret = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\"><i id=\"logo-oracle-" + row['id'] + "\" class=\"fa fa-exclamation-circle logo-delivered logo-status\"></i>{{ 'Oracle Invalid Response Error'|trans }}</div>"; 
                                            break;
                                        case 100:
                                            //var response = JSON.parse(row['id']);
                                            ret = "<div class=\"info stato-items-" + pstato + "\" id=\"spin-id-" + row['conta'] + "\"><i id=\"logo-oracle-" + row['id'] + "\" class=\"fas fa-exclamation-circle logo-delivered logo-status\"></i>{{ 'Oracle Response Error'|trans }}</div>"; 
                                            break;
                                        default:
                                            ret = stato;
                                    }
                                    return ret;
                                }
                                else {
                                    return data;
                                }
                            },
                            "width": "15%",
                            "targets": 3
                        },
                         {
                            "render": function (data, type, row) {
                                var id = row['logid'];
                                return '<i data-id="' + id + '" onclick="javascript:downloadReq(6, ' + id + ');" alt="Download json file" class="fa fa-download" style="font-size: 23px; margin-right: 10px; display: inline-block;"></i><div class="label-stato" style="display: inline-block; margin-right: 20px;">{{ 'Request'|trans }}</div><i data-id="' + id + '" onclick="javascript:downloadResp(6, ' + id + ');" alt="Download json file" class="fa fa-download" style="font-size: 23px; margin-right: 10px; display: inline-block;"></i><div class="label-stato" style="display: inline-block;">{{ 'Response'|trans }}</div>';
                            },
                            "width": "15%",
                            "targets": 4
                        }                       
                        
                    ]

                });




                $('.dataTables_empty').html('<div id="page-wrapper"><div class="loading">Loading...</div></div>');
            })
            function exportToCED(id, v) {
                $('#spin-id-' + id).removeClass('hidden-element');
                $('#id-' + id).addClass('hidden-element');
                $.ajax({
                    type: "GET",
                    url: "{{ path('app_genoracle', {'sid':'--','id':'::CODE'}) }}".replace('::CODE', v),
                    data: {}
                })
                        .done(function (v) {
                            if (v.err === 0) {
                                $('#id-' + id).html('OK');
                            } else {
                                $('#id-' + id).html('ERROR');
                            }
                            if (cursearch !== '') {
                                table.ajax.url(cursearch).load().draw();
                                $('.dataTables_empty').html('<div id="page-wrapper"><div class="loading">Loading...</div></div>');
                            }

                        })
                        .fail(function (err) {
                            //alert(JSON.stringify(err));
                        })
                        .always(function () {
                            $('#spin-id-' + id).addClass('hidden-element');
                            $('#id-' + id).removeClass('hidden-element');
                        });

            }


            function downloadExport(t, id) {
                var url = "{{ path('app_getjson', {'id':'::ID'}) }}";
                url = url.replace('::ID', id);
                document.location.href = url;
            }

            function downloadReq(t, id) {
                var url = "{{ path('app_getrequest', {'id':'::ID'}) }}";
                url = url.replace('::ID', id);
                document.location.href = url;
            }
            function downloadResp(t, id) {
                var url = "{{ path('app_getresponse', {'id':'::ID'}) }}";
                url = url.replace('::ID', id);
                document.location.href = url;
            }

            function log(v) {
                var modalMsgLog = document.querySelector('#id-msg-log');
                tablelog.clear();
                classie.add(modalMsgLog, 'md-show');
                logcursearch = "{{ path(logurl, {'data':':::VALORE','p':':::TIPO'}) }}".replace(':::VALORE', 'A').replace(':::TIPO', 'IL' + v);
                tablelog.ajax.url(logcursearch).load().draw();
                $('#logresult_wrapper .dataTables_empty').html('<div id="page-wrapper"><div class="loading">Loading...</div></div>');                
            }
            function closeLog() {
                var modalMsgLog = document.querySelector('#id-msg-log');
                classie.remove(modalMsgLog, 'md-show');
            }
        </script>
    {% endblock %}

    {% block footer %}
    {% endblock %}