@extends('admin.layout')

@section('content')
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.4/css/jquery.dataTables.min.css">

    <div class="row mb-3">
        <div class="row d-flex justify-content-between">
            <h4 class="page-top-heading">Withdraw Request History</h4>
        </div>

        <div class="container my-4">
            <!-- Filter Section -->
            {{-- <div class="d-flex justify-content-between align-items-center mb-3">
                <div class="d-flex gap-2">
                    <input type="date" class="form-control" placeholder="From Date">
                    <input type="date" class="form-control" placeholder="To Date">
                </div>
                <div class="d-flex gap-2">
                    <button class="btn btn-primary">Search</button>
                    <button class="btn btn-secondary">Reset</button>
                </div>
            </div> --}}

            <!-- Table Card -->
            <div class="card p-3">
                <div class="table-responsive">
                    <table id="withdrawHistoryTable" class="table table-hover table-borderless">
                        <thead>
                            <tr>
                                <th>S/N</th>
                                <th>Date & Time</th>
                                <th>User ID</th>
                                <th>Amount</th>
                                <th>Account Number</th>
                                <th>Account Holder Name</th>
                                <th>IFSC Code</th>
                                <th>Bank Name</th>
                                <th>Branch Name</th>
                                <th>Remark</th>
                                <th>Action At</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        @php
                            $sn = 1;
                        @endphp
                        <tbody>
                            @foreach ($datatables as $data)
                                @php
                                    $bank_details = DB::table('bank_details')
                                        ->where('user_id', $data->user_id)
                                        ->first();
                                @endphp
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ $data->created_at }}</td>
                                    <td>{{ $data->user_id }}</td>
                                    <td>{{ $data->amount }}</td>
                                    <td>{{ $bank_details->acc_no }}</td>
                                    <td>{{ $bank_details->acc_holder_name }}</td>
                                    <td>{{ $bank_details->ifsc }}</td>
                                    <td>{{ $bank_details->bank_name }}</td>
                                    <td>{{ $bank_details->branch_name }}</td>
                                    <td>{{ $data->remark ?? '--' }}</td>
                                    <td>{{ $data->action_at ?? '--' }}</td>
                                    <td>{{ $data->status }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.4/js/jquery.dataTables.min.js"></script>

    <script>
        $(document).ready(function() {
            $('#withdrawHistoryTable').DataTable();
        });
    </script>
@endsection