@extends('layout.app')

@section('content')
    <div class="row mb-3">
        <div class="col-md-3">
            <input type="date" id="from_date" class="form-control">
        </div>
        <div class="col-md-3">
            <input type="date" id="to_date" class="form-control">
        </div>
        <div class="col-md-6">
            <button id="filter" class="btn btn-primary">Search</button>
            <button id="reset" class="btn btn-secondary">Reset</button>
            @can('bkashWebhookReport')
                <a href="{{ route('bkashWebhookReport.export') }}" id="export" class="btn btn-success float-right">
                    <i class="fa fa-file-excel"></i> Excel
                </a>
            @endcan
        </div>
    </div>

    <div class="table-responsive">
        <table id="dataTable" class="table table-bordered table-striped">
            <thead class="bg-dark text-white">
                <tr>
                    <th>Payment Number</th>
                    <th>Amount</th>
                    <th>TrxID</th>
                    <th>Reference</th>
                    <th>Date Time</th>
                </tr>
            </thead>
        </table>
    </div>
@endsection

@section('ajax')
    <script>
        $(document).ready(function() {

            if ($.fn.DataTable.isDataTable('#dataTable')) {
                $('#dataTable').DataTable().clear().destroy();
            }

            let table = $('#dataTable').DataTable({
                processing: true,
                serverSide: true,
                destroy: true,
                pageLength: 100, // ✅ SHOW 100 ROWS
                lengthMenu: [ // ✅ OPTIONS
                    [10, 25, 50, 100, 200, 500],
                    [10, 25, 50, 100, 200, 500]
                ],
                ajax: {
                    url: '{{ route('bkashWebhookReport.datatable') }}',
                    data: function(d) {
                        d.from_date = $('#from_date').val();
                        d.to_date = $('#to_date').val();
                    }
                },
                columns: [{
                        data: 'payment_number',
                        name: 'payment_number'
                    },
                    {
                        data: 'amount',
                        name: 'amount'
                    },
                    {
                        data: 'trxid',
                        name: 'trxid'
                    },
                    {
                        data: 'reference',
                        name: 'reference'
                    },
                    {
                        data: 'date_time',
                        name: 'date_time'
                    },
                ],
                order: [
                    [4, 'desc']
                ]
            });

            $('#filter').on('click', function() {
                table.draw();
            });

            $('#reset').on('click', function() {
                $('#from_date').val('');
                $('#to_date').val('');
                table.draw();
            });

            // Carry the date range and the datatable's own search box into the export,
            // so the sheet holds exactly the rows currently on screen.
            $('#export').on('click', function() {
                var params = {
                    from_date: $('#from_date').val(),
                    to_date: $('#to_date').val(),
                    search: table.search()
                };
                Object.keys(params).forEach(function(k) {
                    if (!params[k]) delete params[k];
                });
                var qs = $.param(params);
                $(this).attr('href', '{{ route('bkashWebhookReport.export') }}' + (qs ? '?' + qs : ''));
            });

        });
    </script>
@endsection