@extends('backend.partials.master')

@section('title', 'Stock Report')

@section('maincontent')

<main class="content">
    <div class="container-fluid p-0">

        <h3><strong>Stock Report</strong></h3>

        <form id="filterForm">
            <div class="row">

                {{-- <div class="col-md-3 mb-3">
                    <label class="form-label">From Date</label>
                    <input type="date" id="from_date" name="from_date" class="form-control">
                </div>

                <div class="col-md-3 mb-3">
                    <label class="form-label">To Date</label>
                    <input type="date" id="to_date" name="to_date" class="form-control">
                </div> --}}

                <div class="col-md-3 mb-3">
                    <label class="form-label">Product </label>
                    <select id="supplier_id" name="supplier_id" class="form-control choices-single">
                        <option value="All">All</option>
                        <option value=""  disabled>Select Product</option>
                        @foreach($Product as $sup)
                            <option value="{{ $sup->id }}">{{ $sup->name }}</option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-2 mb-3 d-flex align-items-end">
                    <button type="button" id="searchBtn" class="btn btn-primary w-100">Search</button>
                </div>

            </div>
        </form>

        <div class="card mt-3">
            <div class="card-body">
                <table id="purchaseTable" class="table table-bordered table-striped">
                    <thead>
                        <tr>
                            <th>Sr. No.</th>
                            <th>Product</th>
                            <th>Purchase Stock</th>
                            <th>Sale Stock</th>
                            <th>Available Stock</th>
                        </tr>
                    </thead>
                </table>
            </div>
        </div>

    </div>
</main>

@endsection
<script>
document.addEventListener("DOMContentLoaded", function () {

   let table = $('#purchaseTable').DataTable({
    processing: true,
    serverSide: true,
    ajax: {
        url: "{{ route('reports.stock_report') }}",
        data: function (d) {
            d.from_date = $('#from_date').val();
            d.to_date = $('#to_date').val();
            d.supplier_id = $('#supplier_id').val();
        }
    },
    columns: [
        { data: 'DT_RowIndex', orderable: false, searchable: false },
        { data: 'product_name', name: 'product_name' },
        { data: 'purchase_stock', name: 'purchase_stock' },
        { data: 'sale_stock', name: 'sale_stock' },
        { data: 'available_stock', name: 'available_stock' }
    ]
});

$("#searchBtn").click(function () {
    table.ajax.reload();
});


    $("#searchBtn").click(function () {
        table.ajax.reload();
    });

});
</script>