@extends('Admin.layout')
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">
@section('content')
    <meta name="csrf-token" content="{{ csrf_token() }}">

    <div class="row align-items-center justify-content-between mb-3 mt-3 m-2">
        <div class="col-auto">
            <h5>Transactions</h5>
        </div>
    </div>

    <div class="card p-0 m-2">
        <div class="row mb-3 align-items-center p-3 g-2">
            <div class="col-1">
                <select id="pageLength" class="form-select">
                    <option value="10">10</option>
                    <option value="25">25</option>
                    <option value="50">50</option>
                    <option value="100">100</option>
                </select>
            </div>

            <div class="col-lg-2 col-md-3">
                <select id="filterMethod" class="form-select">
                    <option value="">All Methods</option>
                    <option value="Cash">Cash</option>
                    <option value="UPI">UPI</option>
                    <option value="Card">Card</option>
                    <option value="Bank Transfer">Bank Transfer</option>
                </select>
            </div>

            <div class="col-lg-2 col-md-3">
                <select id="filterStatus" class="form-select">
                    <option value="">All Status</option>
                    <option value="Paid">Paid</option>
                    <option value="Failed">Failed</option>
                    <option value="Refunded">Refunded</option>
                </select>
            </div>

            <div class="col-lg-2 col-md-3">
                <select id="filterType" class="form-select">
                    <option value="">All Types</option>
                    <option value="Advance">Advance</option>
                    <option value="Balance Settlement">Balance Settlement</option>
                    <option value="Refund">Refund</option>
                </select>
            </div>

            <div class="col-md-3 ms-auto">
                <input type="text" id="customSearch" class="form-control" placeholder="Search Txn / Booking / Customer">
            </div>
        </div>

        <div class="table-responsive pt-0 pb-2">
            <table class="table" id="transactionsTable">
                <thead>
                    <tr>
                        <th>S.No</th>
                        <th class="text-nowrap">Paid Date</th>
                        <th class="text-nowrap">Transaction ID</th>
                        <th class="text-nowrap">Booking ID</th>
                        <th>Customer</th>
                        <th>Amount</th>
                        <th class="text-nowrap">Payment Method</th>
                        <th>Type</th>
                        <th class="text-nowrap">Payment Status</th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>

    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    <script>
        $(document).ready(function () {
            const table = $('#transactionsTable').DataTable({
                processing: true,
                serverSide: true,
                ajax: {
                    url: "{{ route('transaction_data') }}",
                    data: function (d) {
                        d.payment_method = $('#filterMethod').val();
                        d.payment_status = $('#filterStatus').val();
                        d.type = $('#filterType').val();
                    }
                },
                columns: [
                    { data: 'DT_RowIndex', orderable: false, searchable: false },
                    { data: 'paid_at', orderable: false, searchable: false },
                    { data: 'transaction_id' },
                    { data: 'booking_ref', orderable: false, searchable: false },
                    { data: 'customer_name' },
                    { data: 'amount', orderable: false, searchable: false },
                    { data: 'payment_method', orderable: false, searchable: false },
                    { data: 'type', orderable: false, searchable: false },
                    { data: 'payment_status', orderable: false, searchable: false },
                ],
                dom: 'rt<"d-flex justify-content-between align-items-center p-3"ip>',
            });

            $('#customSearch').on('keyup', function () {
                table.search(this.value).draw();
            });

            $('#pageLength').on('change', function () {
                table.page.len(this.value).draw();
            });

            $('#filterMethod, #filterStatus, #filterType').on('change', function () {
                table.draw();
            });
        });
    </script>
@endsection