@extends('admin.layouts.masterlayout')

@section('content')
<link rel="stylesheet" href="{{ asset('css/admin/datatable.css') }}">
<script src="{{ asset('js/admin/datatable.js') }}"></script>

<script>
  $(document).ready(function () {
    $('[data-toggle="tooltip"]').tooltip();
  });
</script>

<div class="content-wrapper">
    <div class="row page-titles mx-0" data-aos="fade-up">
        <div class="col-sm-6 p-md-0"></div>
        <div class="col-sm-6 p-md-0 justify-content-sm-end mt-2 mt-sm-0 d-flex">
            <ol class="breadcrumb">
                <li class="breadcrumb-item active">Yearly Session Report</li>
            </ol>

        </div>
    </div>
    <div class="row">
        <div class="col-12">
            <div class="card" data-aos="fade-up">
                <div class="card-header">
                    <h4>Yearly Session Report</h4>
                    <div class="mb-3">
                        <label for="filterSessionYear"><strong>Session Year:</strong></label>
                        <select id="filterSessionYear" class="form-control" style="width: 200px; display: inline-block; margin-left: 10px;">
                            <option value="">All</option>
                            <option value="2023-2024">2023-2024</option>
                            <option value="2022-2023">2022-2023</option>
                            <option value="2021-2022">2021-2022</option>
                            <!-- Add more options as needed -->
                        </select>
                    </div>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table id="dataList" class="display" style="min-width: 845px">
                            <thead>
                                <tr>
                                    <th>S No.</th>
                                    <th>Session Year</th>
                                    <th>User ID</th>
                                    <th>Opening Balance</th>
                                    <th>Invested Amount</th>
                                    <th>Total Opening Balance</th>
                                    <th>Total Commission</th>
                                    <th>Total Deposit</th>
                                    <th>Total Withdraw</th>
                                    <th>Total TDS Deducted</th>
                                    <th>Created At</th>
                                </tr>
                            </thead>
                            <tfoot>
                                <tr>
                                    <th>S No.</th>
                                    <th>Session Year</th>
                                    <th>User ID</th>
                                    <th>Opening Balance</th>
                                    <th>Invested Amount</th>
                                    <th>Total Opening Balance</th>
                                    <th>Total Commission</th>
                                    <th>Total Deposit</th>
                                    <th>Total Withdraw</th>
                                    <th>Total TDS Deducted</th>
                                    <th>Created At</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<script type="text/javascript">
$(document).ready(function () {
    var table = $('#dataList').DataTable({
        processing: true,
        serverSide: true,
        ajax: {
            url: "{{ route('Registerusers.yearly_report_view') }}",
            type: 'POST',
            data: function (d) {
                d._token = '{{ csrf_token() }}';
                d.session_year = $('#filterSessionYear').val(); // 🔥 Add selected year
            }
        },
        columns: [
            { data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false, searchable: false },
            { data: 'session_year', name: 'session_year' },
            { data: 'user_id', name: 'user_id' },
            { data: 'opening_balance', name: 'opening_balance' },
            { data: 'invested_amount', name: 'invested_amount' },
            { data: 'total_opening_balance', name: 'total_opening_balance' },
            { data: 'total_commission', name: 'total_commission' },
            { data: 'total_deposit', name: 'total_deposit' },
            { data: 'total_withdraw', name: 'total_withdraw' },
            { data: 'total_tds_dedcuted', name: 'total_tds_dedcuted' },
            { data: 'created_at', name: 'created_at' },
        ]
    });

    // 🔁 On dropdown change, redraw table
    $('#filterSessionYear').change(function () {
        table.ajax.reload();
    });
});

</script>
@endsection