@extends('backend.partials.master')
@section('title')
    Products
@endsection
@section('maincontent')
<main class="content">
    <div class="container-fluid p-0">
        <!-- <div class="row mb-2 mb-xl-3">
            <div class="col-auto d-none d-sm-block">
                <h3><strong></strong> Products Reports</h3>
            </div>
           
        </div> -->
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-body">
                       <h4><strong></strong> Products Reports</h4>
                        {{-- <form id="filterForm">
                            <div class="row">
                                <div class="mb-3 col-md-3">
                                    <label class="form-label" for="customer_id">Customer <small class="text-danger">*</small></label>
                                    <select id="customer_id" name="customer_id" class="form-control choices-single-customer">
                                        <option value=""> Select Customer</option>
                                        @foreach($customers as $customer)
                                            <option value="{{ $customer->id }}" @if(session('customer_id') == $customer->id) selected @endif>{{ $customer->name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="mb-3 col-md-2 d-flex align-items-end">
                                    <button type="button" id="searchBtn" class="btn btn-primary">Search</button>
                                </div>
                            </div>
                        </form> --}}

                        <table id="datatables-buttons" class="table table-striped nowrap" style="width:100%">
                            <thead>
                            <tr>
                                <th>SR NO </th>
                                <th>Name</th>
                                <th>SKU</th>
                                <th>Status</th>
                                <th>Category</th>
                            </tr>
                            <tr>
                                <th></th>
                                <th><input type="text" class="form-control" placeholder="search Name"></th>
                                <th><input type="text" class="form-control" placeholder="search sku"></th>
                                <th></th>
                                <th><input type="text" class="form-control" placeholder="search category"></th>
                            </tr>
                            </thead>

                        </table>
                    </div>
                </div>
            </div>
        </div>

    </div>
</main>
@endsection
<script>
    document.addEventListener("DOMContentLoaded", function() {
    var datatablesButtons = $("#datatables-buttons").DataTable({
        // responsive: true,
        processing: true,
        serverSide: true,
        scrollX: true, 
        autoWidth: false, 
        orderCellsTop: true,
        fixedHeader: true,
        ajax: {
            url: "{{ route('reports.items') }}",
            data: function (d) {
                d.customer_id = $('#customer_id').val(); // ✅ pass selected customer
            }
        },
        columns: [
    { data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false, searchable: false },
    { data: 'name', name: 'name' },
    { data: 'sku', name: 'sku' },
    { data: 'status', name: 'status' },
    { data: 'category', name: 'category' },
],

        dom: "<'row'<'col-md-6'l><'col-md-6 text-end'B>>" +
             "<'row'<'col-sm-12'tr>>" +
             "<'row'<'col-md-5'i><'col-md-7'p>>",
        buttons: [
            'copy', 'excel', 'pdf', 'print',
            {
                extend: 'colvis',
                text: 'Columns'
            }
        ],
        lengthMenu: [
            [10, 25, 50, 100, -1],
            [10, 25, 50, 100, "All"]
        ],
        drawCallback: function () {
            feather.replace(); // draw feather icons after each render
        }
    });
    // ✅ On search button click, reload the table with selected customer
    $('#searchBtn').on('click', function () {
        datatablesButtons.ajax.reload();
    });
    // Apply search filters from second header row
    $('#datatables-buttons thead tr:eq(1) th').each(function (i) {
        var input = $(this).find("input, select");
        if (input.length) {
            $(input).on("keyup change clear", function () {
                if (datatablesButtons.column(i).search() !== this.value) {
                    datatablesButtons.column(i).search(this.value).draw();
                }
            });
        }
    });
});

</script>

<!-- searchable dropdown script start-->
<script>
    document.addEventListener("DOMContentLoaded", function() {
        // Choices.js
        new Choices(document.querySelector(".choices-single-customer"));
    });
</script>
<!-- searchable dropdown script end-->