@extends('Admin.layout')

@section('content')
    <div class="row align-items-center justify-content-between mb-3">
        <div class="col-auto">
            <h5>
                
                Loaded Reports
            </h5>
        </div>
        <div class="col-auto">
            <a href="{{ route('generate_level_profit') }}"><button class="btn btn-primary">Load 5 Star</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>
                        <option value="All"> All</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>Days</th>
                                        <th>Percentage</th>
                                        <th>Action</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:425,
                    balance: 0.5,
                    ledger: 'Ledger1',
                    loan_status: 'Completed'
                },
                {
                    id: 2,
                    date: '13/10/2026',
                    user_id: 'U124',
                    user_name: 'Jane Smith',
                    amount: 2000,
                    paid: 425,
                    balance: 0.5,
                    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 => `                        <div class="d-flex">
<a href="{{ route('view_profits') }}" class="btn btn-sm btn-info view-ledger me-2" data-id="${row.id}">View Profit</a>
<a href="{{ route('view_levels') }}" class="btn btn-sm btn-info view-ledger" data-id="${row.id}">View Level</a>
</div>` },
                   
                ]
            });
        });
    </script>
@endsection