@extends('backend.partials.master')
@section('title')
    Stock Report
@endsection
@section('maincontent')
<main class="content">
    <div class="container-fluid p-0">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-body">
                        <h4><strong></strong>Stock Report</h4>
                        <form id="filterForm">
                            <div class="row">
                                

                               
                                {{-- <div class="mb-3 col-md-3">
                                    <label class="form-label" for="rack">Rack</label>
                                    <select id="rack" name="rack_id" class="form-control choices-single-rack" onchange="getPartition(this.value);">
                                        <option selected disabled value="">Select Rack</option>
                                    </select>
                                    @error('rack_id')
                                        <small class="text-danger">{{ $message }}</small>
                                    @enderror
                                </div>

                                <div class="mb-3 col-md-3">
                                    <label class="form-label" for="partition_id">Partitions</label>
                                    <select id="partition_id" name="partition_id" class="form-control choices-single-partition">
                                        <option selected disabled value="">Select Partition</option>
                                    </select>
                                    @error('partition_id')
                                        <small class="text-danger">{{ $message }}</small>
                                    @enderror
                                </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" style="width:100%">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>Customer Name</th>
                                    <th>Warehouse</th>
                                    <th>Rack</th>
                                    <th>Product Name</th>
                                    <th>Available Quantity</th>
                                </tr>
                                <tr>
                                    <th></th>
                                    <th><input type="text" class="form-control" placeholder="search customer"></th>
                                    <th><input type="text" class="form-control" placeholder="search warehouse"></th>
                                    <th><input type="text" class="form-control" placeholder="search rack"></th>
                                    <th><input type="text" class="form-control" placeholder="search product"></th>
                                    <th><input type="text" class="form-control" placeholder="search quantity"></th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>
@endsection
<script>
    document.addEventListener("DOMContentLoaded", function() {
    new Choices(document.querySelector(".choices-single-warehouse"), { shouldSort: false });

    var datatablesButtons = $("#datatables-buttons").DataTable({
        responsive: true,
        processing: true,
        serverSide: true,
        orderCellsTop: true,
        fixedHeader: true,
        ajax: {
            url: "{{ route('reports.stock') }}",
            data: function (d) {
                d.customer_id = $('#customer_id').val(); // ✅ pass selected customer
                d.warehouse_id = $('#warehouse_id').val(); 
            }
        },
        columns: [
            { data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false, searchable: false },
            { data: 'customer', name: 'customer' },
            { data: 'warehouse', name: 'warehouse' },
            { data: 'rack_breakdown', name: 'rack_breakdown' },
            { data: 'product_name', name: 'product_name' },
            { data: 'total_quantity', name: 'total_quantity' },

        ],
        dom: "<'row'<'col-md-6'l>>" +
             "<'row'<'col-12 mt-2'B>>" +
             "<'row'<'col-sm-12'tr>>" +
             "<'row'<'col-md-5'i><'col-md-7'p>>",
        buttons: ['copy', 'excel', 'pdf', 'print',
                {
                    extend: 'colvis',   // #xdc48; Column visibility button
                    text: 'Columns'
                }
        ],
        lengthMenu: [[10, 25, 50, 100, -1], [10, 25, 50, 100, "All"]],
        drawCallback: function () {
            feather.replace();
        }
    });

    // ✅ On search button click, reload the table with selected customer
    $('#searchBtn').on('click', function () {
        var customer_id = $('#customer_id').val();
        var warehouse_id = $('#warehouse_id').val();

        if (!customer_id) {
            alert('Please select a customer.');
            return;
        }
        if (!warehouse_id) {
            alert('Please select a warehouse.');
            return;
        }
        // ✅ All fields are valid – reload the datatable
        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>