@extends('Admin.layout')
<style>
    .dt-search {
        display: none !important;
    }
</style>
<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() }}">


<h5> Team Investment</h5>

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

    <div class="row mb-3 align-items-center p-3 g-2">

        <div class="col-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>
            </select>
        </div>

        <div class="col-auto ms-auto d-flex gap-2 align-items-center">

            <div class="position-relative">
                <input type="text" id="toDate" class="form-control ps-7" placeholder="Search...">
                <i class="ti tabler-search position-absolute top-50 start-0 translate-middle-y ms-3 text-muted"></i>
            </div>

            <button class="btn btn-label-secondary" id="excelExport">
                <i class="ti tabler-upload"></i>&nbsp; Excel
            </button>

        </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="usersTable" class="table table-bordered align-middle users-table w-100">
                        <thead>
                            <tr>
                                <th>SNO</th>
                                <th>Date</th>
                                <th>user&nbsp;ID</th>
                                <th>Name</th>
                                <th>Level</th>
                                <th>Amount</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 = $('#usersTable').DataTable({
            ajax: "{{ route('team_invest_data', $user->id) }}",
            paging: true,
            searching: true,
            info: true,
            ordering: false,
            lengthChange: false,
            pageLength: 10,
            buttons: [{
                extend: 'excelHtml5',
                title: 'Investment History',
                className: 'd-none'
            }],
            columns: [

                {
                    data: 'DT_RowIndex',
                    name: 'DT_RowIndex',
                    searchable: false,
                    orderable: false
                },

                {
                    data: 'date',
                    name: 'created_at'
                },

                {
                    data: 'user_id',
                    name: 'user_id'
                },

                {
                    data: 'name',
                    name: 'name'
                },

                {
                    data: 'level',
                    name: 'level'
                },

                {
                    data: 'amount',
                    name: 'team_invest'
                }

            ]
        });

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

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

        $('#excelExport').click(function() {
            table.button('.buttons-excel').trigger();
        });

    });
</script>




@endsection