@extends('Admin.layout')

@section('content')
    <div class="row align-items-center justify-content-between mb-3">
        <div class="col-auto">
            <h5>
                <button type="button" class="btn btn-icon bg-white me-2" style="box-shadow: 0px 9px 12px -2px #66328E1F;">
                    <a href="{{ route('loan_requests') }}"> <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24"
                            viewBox="0 0 24 24" fill="none" stroke="#000" stroke-width="2" stroke-linecap="round"
                            stroke-linejoin="round" class="icon icon-tabler">
                            <path stroke="none" d="M0 0h24v24H0z" fill="none" />
                            <path d="M15 6l-6 6l6 6" />
                        </svg>
                    </a>
                </button>
                Loan Reports
            </h5>
        </div>
        <div class="col-auto">
            <a href="{{ route('give_loans') }}"><button class="btn btn-primary">Grant Loans</button> </a>
        </div>

    </div>
    <div class="mt-2">
        <div class="card p-0">

            <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-md-3 ms-auto">
                    <input type="text" id="toDate" class="form-control" placeholder="Search">
                </div>
            </div>


            <div class="table-responsive pt-0 pb-2">
                <div class="row card-header flex-column flex-md-row border-bottom mx-0 p-0">
                    <div class="justify-content-between dt-layout-table">
                        <div class=" justify-content-between align-items-center dt-layout-full table-responsive">
                            <table class="table" id="usersTable">
                                <thead>
                                    <tr>
                                        <th>Sno</th>
                                        <th>Date</th>
                                        <th>User ID</th>
                                        <th>User Name</th>
                                        <th>Amount</th>
                                        <th>Paid</th>
                                        <th>Balance</th>
                                        <th>Ledger</th>
                                        <th>Loan Status</th>
                                    </tr>
                                </thead>
                                <tbody></tbody>
                            </table>

                        </div>
                    </div>
                </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.6/js/jquery.dataTables.min.js"></script>

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

            // Dummy frontend data
            const tableData = [
                {
                    id: 1,
                    date: '12/10/2026',
                    user_id: 'U123',
                    user_name: 'John Doe',
                    amount: 1000,
                    paid: 500,
                    balance: 500,
                    ledger: 'Ledger1',
                    loan_status: 'Completed'
                },
                {
                    id: 2,
                    date: '13/10/2026',
                    user_id: 'U124',
                    user_name: 'Jane Smith',
                    amount: 2000,
                    paid: 1500,
                    balance: 500,
                    ledger: 'Ledger2',
                    loan_status: 'Completed'
                }
            ];

            const table = $('#usersTable').DataTable({
                data: tableData,
                searching: true,
                paging: true,
                info: true,
                lengthChange: false,
                pageLength: 10,
                ordering: false,
                  columnDefs: [
        {
            targets: '_all',
            className: 'text-nowrap'
        }
    ],

                columns: [
                    { data: null, render: (data, type, row, meta) => meta.row + 1 }, // Sno
                    { data: 'date' },
                    { data: 'user_id' },
                    { data: 'user_name' },
                    { data: 'amount' },
                    { data: 'paid' },
                    { data: 'balance' },
                    { data: null, render: row => `<button class="btn btn-sm btn-info view-ledger" data-id="${row.id}">View</button>` },
                    {
                        data: 'loan_status',
                        render: function (data) {
                            if (data === 'Pending') {
                                return `<span class="text-danger fw-bold">${data}</span>`;
                            } else if (data === 'Completed') {
                                return `<span class="text-success fw-bold">${data}</span>`;
                            } else {
                                return `<span>${data}</span>`;
                            }
                        }
                    },
                ]
            });
        });
    </script>
@endsection