@extends('backend.partials.master')
@section('title')
    Payment Leadger
@endsection
@section('maincontent')
<main class="content">
    <div class="container-fluid p-0">
        <div class="row mb-2 mb-xl-3">
            <div class="col-auto d-none d-sm-block">
                <h3><strong></strong> Payment Leadger Table</h3>
            </div>
        </div>
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-body">
                        <form id="filterForm">
                            <div class="row">
                                 <div class="mb-3 col-md-3">
                                    <label class="form-label" for="from_date">From Date</label>
                                    <input type="date" name="from_date" id="from_date" class="form-control">
                                </div>
                                <div class="mb-3 col-md-3">
                                    <label class="form-label" for="to_date">To Date</label>
                                    <input type="date" name="to_date" id="to_date" class="form-control">
                                </div>
                                <div class="mb-3 col-md-2 d-flex align-items-end">
                                    <button type="button" id="searchBtn" class="btn btn-primary">Search</button>
                                </div>
                            </div>
                        </form>
                        <table id="datatables-buttons" class="table table-striped" style="width:100%">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>Date</th>
                                    <th>Type</th>
                                    <th>Amount</th>
                                    <th>Pending Amount</th>
                                </tr>
                                <tr>
                                    <th></th>
                                    <th><input type="text" class="form-control" placeholder="search date"></th>
                                    <th><input type="text" class="form-control" placeholder="search type"></th>
                                    <th><input type="text" class="form-control" placeholder="search amount"></th>
                                    <th><input type="text" class="form-control" placeholder="search pending amount"></th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>

    </div>
</main>
@endsection
<script>
    document.addEventListener("DOMContentLoaded", function() {
        const today = new Date();
        const lastWeek = new Date();
        lastWeek.setDate(today.getDate() - 7);

        const formatDate = (date) => date.toISOString().split('T')[0];
        document.getElementById('to_date').value = formatDate(today);
        document.getElementById('from_date').value = formatDate(lastWeek);
        // Datatables with Buttons
        var datatablesButtons = $("#datatables-buttons").DataTable({
            responsive: true,
            processing: true,
            serverSide: true,
            orderCellsTop: true,
            fixedHeader: true,
            ajax: {
                url: "{{ route('customers.paymentleadger') }}",
                data: function (d) {
                    d.from_date = $('#from_date').val();
                    d.to_date = $('#to_date').val();
                }
            },
            columns: [
                { data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false, searchable: false },
                { data: 'date', name: 'date' },
                { data: 'type', name: 'type' },
                { data: 'amount', name: 'amount' },
                { data: 'pending_after_this', name: 'pending_after_this' },
            ],
            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
            }
        });
         $('#searchBtn').on('click', function () {
            datatablesButtons.ajax.reload();
        });
        // 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>