@extends('admin.layout')
<style>
    .dt-search,
    .dt-length {
        display: none;
    }
</style>
@section('content')
<h5>
    <!-- <button type="button" class="btn btn-icon bg-white me-2 waves-effect waves-light" style="box-shadow: 0px 9px 12px -2px #66328E1F;">
                <a href="{{ url()->previous() }}">
                    <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>
                        <path d="M15 6l-6 6l6 6"></path>
                    </svg>
                </a>
            </button> -->
    Purchase List
</h5>
<div class="card p-0 mt-3">


    <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">
            <div class="d-flex justify-content-end align-items-center gap-2 flex-nowrap">

                <!-- Search -->
                <div class="input-group" style="width:200px;">
                    <span class="input-group-text border-end-0">
                        <i class="ti tabler-search"></i>
                    </span>
                    <input type="text" id="customSearch" class="form-control border-start-0" placeholder="Search">
                </div>

                <button class="btn btn-light px-4" id="btnExcel">
                    <i class="ti tabler-download"></i> Excel
                </button>

            </div>
        </div>

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

            <input type="text" id="customSearch" class="form-control" placeholder="Search" style="width:200px;">

        </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 ID</th>
                                <th>User&nbsp;Name</th>
                                <th>Product Name</th>
                                <th>Amount</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody></tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>



<!-- jQuery (REQUIRED FIRST) -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

<!-- DataTables Core -->
<script src="https://cdn.datatables.net/2.3.4/js/dataTables.min.js"></script>

<!-- Bootstrap 5 Integration -->
<script src="https://cdn.datatables.net/2.3.4/js/dataTables.bootstrap5.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>

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

        let table = $('#usersTable').DataTable({
            processing: true,
            serverSide: false,

            ajax: {
                url: "{{ url('admin/purchase_list_data') }}",
                dataSrc: ''
            },

             buttons: [{
                extend: 'excelHtml5',
                title: 'purchase list',
                exportOptions: {
                    columns: ':not(:last-child)',
                    modifier: {
                        search: 'applied',
                        order: 'applied',
                        page: 'all' 
                    }
                }
            }],

            columns: [{
                    data: 'DT_RowIndex'
                },
                {
                    data: 'created_at'
                },
                {
                    data: 'user_id'
                },
                {
                    data: 'user_name'
                },
                {
                    data: 'package_name'
                },
                {
                    data: 'price',
                    render: function(data) {
                        return '₹' + Number(data).toLocaleString();
                    }
                },
                {
                    data: 'action'
                }
            ]
        });

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

        // 🔥 SEARCH FIX
        $('#customSearch').on('keyup', function() {
            table.search(this.value).draw();
        });

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

       
    });
</script>
@endsection