@extends('layouts/contentNavbarLayout')

@section('title', 'Wallet Transaction Report')

@section('vendor-style')
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">
@endsection

@section('content')
    <meta name="csrf-token" content="{{ csrf_token() }}">

    <div class="card">
        <div class="card-header bg-primary text-white">
            Wallet Transaction Report
        </div>

        <div class="card-body">
            <form id="filter-form" class="mb-3 mt-2">
                <div class="row g-3">
                    {{-- Row 1 --}}
                    <div class="col-md-3 position-relative">
                        <div class="form-floating form-floating-outline w-100">
                            <input type="text" id="user" name="user" class="form-control live-user-input"
                                placeholder="User Name Or UID">
                            <label for="user">User Name Or UID</label>

                            <ul class="list-group live-user-dropdown position-absolute w-100 mt-1 bg-white border rounded"
                                style="z-index: 9999; display: none;"></ul>
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="form-floating form-floating-outline w-100">
                            <input type="text" id="refid" name="refid" class="form-control" placeholder="Ref ID">
                            <label for="refid">Ref ID</label>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-floating form-floating-outline w-100">
                            <input type="date" name="start_date" id="start_date" class="form-control"
                                placeholder="Start Date">
                            <label for="start_date">From (Start date)</label>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-floating form-floating-outline w-100">
                            <input type="date" name="end_date" id="end_date" class="form-control"
                                placeholder="End Date">
                            <label for="end_date">To (End date)</label>
                        </div>
                    </div>

                    <div class="col-md-2">
                        <button type="submit" class="btn btn-primary w-100">Apply</button>
                    </div>

                    <div class="col-md-2">
                        <button type="button" class="btn btn-outline-primary w-100" id="reset_filter">Reset</button>
                    </div>
                </div>
            </form>
            <div class="table-responsive mt-4 px-3">
                <table class="table table-bordered table-striped table-hover text-center align-middle w-100"
                    id="walletTxTable">
                    <thead class="table-primary">
                        <tr>
                            <th>S.No.</th>
                            <th>User</th>
                            <th>Contact Details</th>
                            <th>Service Name</th>
                            <th>Ref No.</th> {{-- ✅ Ref ID column --}}
                            <th>Opening Balance</th>
                            <th>Amount</th>
                            <th>Charge</th>
                            <th>Total Amount</th>
                            <th>Closing Balance</th>
                            <th>Credit</th>
                            <th>Debit</th>
                            <th>Description</th>
                            <th>Created</th>
                        </tr>
                    </thead>
                </table>
            </div>

        </div>
    </div>
@endsection

@section('js')
    <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/dataTables.buttons.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.print.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.js"></script>
    {{-- If you already use this for live user suggestions, keep it --}}
    <script src="{{ asset('assets/js/live-user-search.js') }}"></script>

    <script>
        $(document).ready(function() {

            // If you later switch to POST Ajax, CSRF is already available
            $.ajaxSetup({
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                }
            });

            let table = $('#walletTxTable').DataTable({
                processing: true,
                serverSide: true,
                scrollX: true,
                responsive: true,
                lengthMenu: [
                    [10, 25, 100, 1000, 10000, -1],
                    [10, 25, 100, 1000, 10000, "All"]
                ],
                dom: '<"row mb-3"<"col-sm-6"l><"col-sm-6"<"d-flex justify-content-end"<"dt-buttons-wrapper">>>>frtip',
                buttons: [{
                        extend: 'excelHtml5',
                        text: '<i class="bx bx-file"></i> Export to Excel',
                        className: 'btn btn-sm btn-outline-success mx-1'
                    },
                    {
                        extend: 'csvHtml5',
                        text: '<i class="bx bx-file"></i> Export to CSV',
                        className: 'btn btn-sm btn-outline-primary mx-1'
                    },
                ],
                initComplete: function() {
                    this.api().buttons().container().appendTo($('.dt-buttons-wrapper'));
                },
                ajax: {
                    url: "{{ route('admin.wallet.transaction.filter') }}",
                    data: function(d) {
                        d.user = $('#user').val();
                        d.refid = $('#refid').val();
                        d.start_date = $('#start_date').val();
                        d.end_date = $('#end_date').val();
                    }
                },

                columns: [{
                        data: 'DT_RowIndex',
                        orderable: false,
                        searchable: false
                    },

                    // these 2 should be coming from controller as addColumn
                    {
                        data: 'user_display',
                        orderable: false,
                        searchable: false,
                        defaultContent: '-'
                    },
                    {
                        data: 'contact_details',
                        orderable: false,
                        searchable: false,
                        defaultContent: '-'
                    },

                    {
                        data: 'service_name',
                        name: 'service_name',
                        defaultContent: '-'
                    },

                    // ✅ Ref ID column
                    {
                        data: 'refid',
                        name: 'refid',
                        defaultContent: '-'
                    },

                    {
                        data: 'opening_balance',
                        name: 'opening_balance',
                        defaultContent: '-'
                    },
                    {
                        data: 'amount',
                        name: 'amount',
                        defaultContent: '-'
                    },
                    {
                        data: 'total_charge',
                        name: 'total_charge',
                        defaultContent: '-'
                    },
                    {
                        data: 'total_amount',
                        name: 'total_amount',
                        defaultContent: '-'
                    },
                    {
                        data: 'closing_balance',
                        name: 'closing_balance',
                        defaultContent: '-'
                    },
                    {
                        data: 'credit',
                        name: 'credit',
                        defaultContent: '-'
                    },
                    {
                        data: 'debit',
                        name: 'debit',
                        defaultContent: '-'
                    },

                    {
                        data: 'description',
                        name: 'description',
                        defaultContent: '-'
                    },
                    {
                        data: 'created_at',
                        name: 'created_at',
                        defaultContent: '-'
                    }
                ],

                // Created column index = 13 (0-based)
                order: [
                    [13, 'desc']
                ]
            });

            // Reload on filter changes
            // $('#user, #refid, #start_date, #end_date').on('input change', function() {
            //     table.ajax.reload();
            // });
            $('#filter-form').on('submit', function(e) {
                e.preventDefault();
                table.ajax.reload();
            });

            $('#reset_filter').on('click', function(e) {
                e.preventDefault();
                $('#filter-form')[0].reset();
                table.ajax.reload();
            });

            // If you have live user search, keep it (safe check)
            if (typeof initLiveUserSearch === 'function') {
                initLiveUserSearch('#user', '.live-user-dropdown', '{{ route('admin.user.search') }}', function() {
                    table.ajax.reload();
                });
            }

        });
    </script>
@endsection