@extends('backend.partials.master')
@section('title')
   Backup List
@endsection
@section('maincontent')
<main class="content">
    <div class="container-fluid p-0">
        @if (hasPermission('administerbk_read') == true)
        <a href="{{route('database.backup')}}" class="btn btn-primary float-end mt-n1"><i class="fas fa-plus"></i> Create Backup</a>
        @endif
        <div class="mb-3">
            <h1 class="h3 d-inline align-middle">Backup List</h1>
        </div>

        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-body">
                        <table id="datatables-buttons" class="table table-striped" style="width:100%">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>Date</th>
                                    <th>File</th>
                                </tr>
                                <tr>
                                    <th></th>
                                    <th><input type="text" placeholder="search date" class="form-control"></th>
                                    <th></th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>

    </div>
</main>
@endsection
<script>
    document.addEventListener("DOMContentLoaded", function() {
        // Datatables with Buttons
        var datatablesButtons = $("#datatables-buttons").DataTable({
            responsive: true,
            processing: true,
            serverSide: true,
            orderCellsTop: true,
            fixedHeader: true,
            ajax: "{{ route('database.backuplist') }}", // Your route
            columns: [
                { data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false, searchable: false },
                { data: 'created_at', name: 'created_at' },
                { data: 'file_name', name: 'file_name' }
            ],
            dom: "<'row'<'col-md-6'l>>" +
            "<'row'<'col-12 mt-2'B>>" +
            "<'row'<'col-sm-12'tr>>" +
            "<'row'<'col-md-5'i><'col-md-7'p>>",
            buttons: ['copy', 'excel', 'pdf', 'print',
                {
                    extend: 'colvis',   // #xdc48; Column visibility button
                    text: 'Columns'
                }
            ],
            lengthMenu: [
                [10, 25, 50, 100, -1],
                [10, 25, 50, 100, "All"]
            ],
            drawCallback: function () {
                feather.replace(); // draw feather icons after each render
            }
        });
        // Apply search filters from second header row
        $('#datatables-buttons thead tr:eq(1) th').each(function (i) {
            var input = $(this).find("input, select");
            if (input.length) {
                $(input).on("keyup change clear", function () {
                    if (datatablesButtons.column(i).search() !== this.value) {
                        datatablesButtons.column(i).search(this.value).draw();
                    }
                });
            }
        });
    });
</script>