@extends('User.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>Micro Profit Income</h5>
    </div>

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

    <div class="row m-3 g-3 align-items-center justify-content-between">

        <!-- LEFT -->
        <div class="col-12 col-lg-auto">

            <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-12 col-lg-auto">

            <div class="d-flex flex-column flex-sm-row align-items-stretch align-items-sm-center gap-2">


                <input type="text" id="customSearch" class="form-control" placeholder="Search table...">

                <!-- <button class="btn btn-label-secondary">
                                    Export
                                </button> -->
            </div>

        </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 id="depositTable" class="table table-bordered align-middle users-table w-100">
                        <thead>
                            <tr>
                                <th>SNO</th>
                                <th>User ID</th>
                                <th>Percentage</th>
                                <th>Investment&nbsp;Amount</th>
                                <th>Credit</th>
                                <th>Service&nbsp;Charge</th>
                                <th>TDS Charge</th>
                            </tr>
                        </thead>
                    </table>
                </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() {

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

            columns: [{
                    data: 'DT_RowIndex',
                    name: 'DT_RowIndex',
                    orderable: false,
                    searchable: false
                },
                {
                    data: 'user_id',
                    name: 'user_id'
                },
                {
                    data: 'percentage',
                    name: 'percentage'
                },
                {
                    data: 'investment_amount',
                    name: 'investment_amount'
                },

                {
                    data: 'credit',
                    name: 'credit'
                },
                {
                    data: 'service_charge',
                    name: 'service_charge'
                }, {
                    data: 'tds_charge',
                    name: 'tds_charge'
                }

            ],

        });

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

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

    });
</script>



@endsection