@extends('backend.partials.master')
@section('title')
   Purchase Return
@endsection
@section('maincontent')
<main class="content">
    <div class="container-fluid p-0">
        <div class="mb-3">
            <h1 class="h3 d-inline align-middle">Purchase Return</h1>
        </div>
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-body">
                        <form id="purchaseReturnForm" action="@if(!empty($purchasesreturn)){{ route('purchasesreturn.update') }}@else{{ route('purchasesreturn.store') }}@endif" method="POST" enctype="multipart/form-data">
                            @csrf
                            @if(!empty($purchasesreturn))
                            @method('PUT')
                                <input type="hidden" name="id" id="id" value="{{ $purchasesreturn->id ?? '' }}"/>
                            @endif
                            <input type="hidden" name="purchase_id" value="{{ $purchasesproduct->id ?? '' }}">

                            <div class="row">
                               <div class="mb-3 col-md-3">
    <label class="form-label">Supplier <small class="text-danger">*</small></label>

    <select name="supplier_id"
        id="supplier_id"
        class="form-control choices-single {{ $errors->has('supplier_id') ? 'is-invalid' : '' }}">
    <option value="">Select Supplier</option>
    @foreach($suppliers as $supplier)
        <option value="{{ $supplier->id }}"
            {{
                // First check old input, then check existing data
                old('supplier_id', !empty($purchasesreturn) ? $purchasesreturn->supplier_id : '') == $supplier->id ? 'selected' : ''
            }}>
            {{ $supplier->name }}
        </option>
    @endforeach
</select>


    {{-- FORCE ERROR SHOW --}}
    @if ($errors->has('supplier_id'))
        <div class="text-danger mt-1">
            {{ $errors->first('supplier_id') }}
        </div>
    @endif
</div>


                                <div class="mb-3 col-md-3">
    <label class="form-label">Purchase Invoice No <small class="text-danger">*</small></label>

    <select name="purchase_no"
            id="purchase_no"
            class="form-control choices-single {{ $errors->has('purchase_no') ? 'is-invalid' : '' }}">
        <option value="">Select Purchase Invoice No.</option>
        @if(!empty($purchasesreturn->purchase_no))
            <option value="{{ $purchasesreturn->purchase_no }}" selected>
                {{ $purchasesreturn->purchase_no }}
            </option>
        @endif
    </select>

    @if ($errors->has('purchase_no'))
        <div class="text-danger mt-1">
            {{ $errors->first('purchase_no') }}
        </div>
    @endif
</div>


                                <div class="mb-3 col-md-3">
    <label class="form-label">Bill Date <small class="text-danger">*</small></label>

    <input type="date" name="date" id="date" class="form-control {{ $errors->has('date') ? 'is-invalid' : '' }}"
           value="{{ old('date', $purchasesreturn->date ?? date('Y-m-d')) }}">

      @if ($errors->has('date'))
        <div class="text-danger mt-1">
            {{ $errors->first('date') }}
        </div>
    @endif
</div>

                                <div class="mb-3 col-md-3">
                                    <label class="form-label" for="date">Purchase Date <small class="text-danger">*</small></label>
                                    <input type="date" class="form-control @error('purchase_date') is-invalid @enderror"
                                        name="purchase_date" id="purchase_date"
                                        value="{{ old('purchase_date', $purchasesreturn->purchase_date ?? date('Y-m-d')) }}" required>
                                    @error('purchase_date')
                                        <small class="text-danger">{{ $message }}</small>
                                    @enderror
                                </div>
                                <div class="mb-3 col-md-3">
                                    <label class="form-label" for="record_no">Return Number <small class="text-danger">*</small></label>
                                    <input type="text" class="form-control @error('record_no') is-invalid @enderror"
                                        name="record_no" id="record_no"
                                         value="{{ old('record_no', $purchasesreturn->record_no ?? $record_no) }}"
                                        readonly required>
                                    @error('record_no')
                                        <small class="text-danger">{{ $message }}</small>
                                    @enderror
                                </div>

                            </div>

                            <div class="row">
                                <table class="table" id="mytable">
                                    <thead>
                                        <tr>
                                            <th style="width: 10%;">Lot No <small class="text-danger">*</small></th>
                                            <th style="width: 10%;">Product <small class="text-danger">*</small></th>
                                            <th>HSN <small class="text-danger">*</small></th>
                                            <th>Quantity <small class="text-danger">*</small></th>
                                            <th>GST (%)</th>
                                            <th>Rate</th>
                                            <th>CGST</th>
                                            <th>SGST</th>
                                            <th>IGST</th>
                                            <th>Rejected Qty<small class="text-danger">*</small></th>
                                            <th>Total <small class="text-danger">*</small></th>

                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php $i = 0; @endphp
                                        @if(!empty($purchasesdetails))
                                            @foreach($purchasesdetails as $detail)
                                                @php $i++; @endphp
                                                <tr id="row_{{ $i }}">
                                                     <td>
                                                        <input type="text" name="lot_no_{{ $i }}" id="lot_no_{{ $i }}"
                                                            class="form-control" value="{{ $detail->lot_no }}" readonly>
                                                    </td>

                                                    <td>
                                                        <select name="product_{{ $i }}" id="product_{{ $i }}" class="form-control product-select " data-row="{{ $i }}">
                                                            <option value="">Select Product</option>
                                                            @foreach($products as $product)
                                                                <option value="{{ $product->id }}"
                                                                    {{ $detail->product_id == $product->id ? 'selected' : '' }}>
                                                                    {{ $product->name }}
                                                                </option>
                                                            @endforeach
                                                        </select>
                                                    </td>
                                                    <td>
                                                        <input type="text" name="hsn_{{ $i }}" id="hsn_{{ $i }}" class="form-control" value="{{ $detail->hsn }}" readonly>
                                                    </td>
                                                  <td>
                                                        @php
                                                            $product = $products->find($detail->product_id);
                                                            $hasSerial = strtolower($product->serial) === 'yes' ? '1' : '0';
                                                        @endphp

                                                        <input
                                                            type="number"
                                                            name="quantity_{{ $i }}"
                                                            id="quantity_{{ $i }}"
                                                            class="form-control quantity-input"
                                                            data-row="{{ $i }}"
                                                            data-has-serial="{{ $hasSerial }}"
                                                            step="0.001"
                                                            value="{{ $detail->quantity }}" readonly>

                                                             <!-- <input type="number" name="quantity_{{ $i }}" id="quantity_{{ $i }}" class="form-control quantity-input" data-row="{{ $i }}" min="1" value="{{ $detail->quantity }}"> -->

                                                    </td>
                                                     <td>
                                                        <input type="text" name="gst_{{ $i }}" id="gst_{{ $i }}" class="form-control" value="{{ $detail->gst }}" readonly>
                                                    </td>
                                                    <td>
                                                        <input type="text" name="rate_{{ $i }}" id="rate_{{ $i }}" class="form-control" value="{{ $detail->rate }}" readonly>
                                                    </td>
                                                    <td>
                                                        <input type="text" name="cgst_{{ $i }}" id="cgst_{{ $i }}" class="form-control" value="{{ $detail->cgst }}" readonly>
                                                    </td>
                                                    <td>
                                                        <input type="text" name="sgst_{{ $i }}" id="sgst_{{ $i }}" class="form-control" value="{{ $detail->sgst }}" readonly>
                                                    </td>
                                                    <td>
                                                        <input type="text" name="igst_{{ $i }}" id="igst_{{ $i }}" class="form-control" value="{{ $detail->igst }}" readonly>
                                                    </td>
                                                    <td>
                                                        <input type="text"  step="0.001" name="reject_qty_{{ $i }}" id="reject_qty_{{ $i }}" class="form-control" value="{{ $detail->reject_qty }}" >
                                                    </td>

                                                    <td>
                                                        <input type="text" name="total_rate_{{ $i }}" id="total_rate_{{ $i }}" class="form-control" value="{{ $detail->total_rate }}" readonly>
                                                    </td>



                                                </tr>
                                            @endforeach
                                        @endif
                                    </tbody>
                                    <tfoot>

                                        <!--  First Row: Rejected Qty + Taxable Total -->
                                        <tr id="row_total">
                                            <th colspan="8" class="text-end">Total</th>
                                            <th><input type="text" id="total_reject_qty" class="form-control" readonly></th>
                                            <th><input type="text" id="normal_total" class="form-control" readonly></th>
                                        </tr>

                                        <!--  Total GST -->
                                        <tr id="row_total_gst">
                                            <th colspan="9" class="text-end">Total GST</th>
                                            <th><input type="text" id="total_gst" class="form-control" readonly></th>
                                        </tr>

                                        <!--  Grand Total -->
                                        <tr id="row_grand_total">
                                            <th colspan="9" class="text-end">Grand Total</th>
                                            <th><input type="text" id="grand_total" class="form-control" readonly></th>
                                        </tr>

                                    </tfoot>



                                </table>
                                <input type="hidden" name="cnt" id="cnt" value="{{ $i }}">
                            </div>

                            <!-- <div class="row">
                                <div class="col-md-6 text-right mt-2">
                                    <button type="button" class="btn btn-primary" onclick="addRow()">+ Add Row</button>
                                </div>
                            </div> -->
                            <br>
                            <button type="submit" class="btn btn-primary">{{ !empty($purchasesreturn) ? 'Update' : 'Create' }}</button>
                            <a href="{{ route('purchasesreturn') }}" class="btn btn-secondary">Cancel</a>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>
@endsection
@push('scripts')

<script>
document.addEventListener("DOMContentLoaded", () => {
    let rowCount = parseInt(document.getElementById('cnt').value || '0');
    const products = @json($products);

    const supplierSelect = document.getElementById('supplier_id');

    // ✅ Filter products by selected supplier for all rows
  function filterProductsBySupplier() {
    const selectedSupplier = supplierSelect.value;
    if (!selectedSupplier) return;

    for (let i = 1; i <= rowCount; i++) {
        const productSelect = document.getElementById(`product_${i}`);
        if (!productSelect) continue;

        const currentSelection = productSelect.value;
        productSelect.innerHTML = `<option value="">Select Product</option>`;

        products.forEach(p => {
            // 🟡 Allow current selection even if supplier doesn't match
            if (p.supplier_id == selectedSupplier || p.id == currentSelection) {
                const option = document.createElement('option');
                option.value = p.id;
                option.text = p.name;
                if (p.id == currentSelection) option.selected = true;
                productSelect.appendChild(option);
            }
        });
    }
}

supplierSelect.addEventListener('change', function () {
    //alert("hii");
    const supplierId = this.value;

    filterProductsBySupplier(); // existing function

    // Fetch Purchase Numbers for selected supplier
    // Fetch Purchase Numbers for selected supplier
if (supplierId) {
    fetch(`{{ route('purchases.bySupplier', ':id') }}`.replace(':id', supplierId))
        .then(response => response.json())
        .then(data => {
            const purchaseNoSelect = document.getElementById('purchase_no');
            purchaseNoSelect.innerHTML = '<option value="">Select Purchase No.</option>';
            data.forEach(purchase => {
                const option = document.createElement('option');
                option.value = purchase.invoice_no;
                option.text = purchase.invoice_no;
                purchaseNoSelect.appendChild(option);
            });
        })
        .catch(err => {
            console.error('Error fetching purchase numbers:', err);
        });
}

});

    // When a Purchase No is selected
$('#purchase_no').on('change', function () {
    const purchaseNo = $(this).val();
    if (!purchaseNo) return;

    $.ajax({
        url: "{{ route('purchase.details', ':purchase_no') }}".replace(':purchase_no', purchaseNo),
        type: "GET",
        dataType: "json",
        success: function (data) {

            $('#purchase_date').val(data.purchase_date);

            const $tbody = $("#mytable tbody");
            $tbody.empty(); // clear existing rows
            let rowCount = 0;

            data.details.forEach(function (detail) {
                rowCount++;

                const row = `
                    <tr>
                        <td>
                            <input type="text" name="lot_no_${rowCount}" id="lot_no_${rowCount}"
                                class="form-control" value="${detail.lot_no}" readonly>
                        </td>
                        <td>
                            <select name="product_${rowCount}" id="product_${rowCount}" class="form-control product-select" data-row="${rowCount}">
                                <option value="${detail.material_id}" selected>${detail.product_name}</option>
                            </select>
                        </td>
                        <td><input type="text" name="hsn_${rowCount}" id="hsn_${rowCount}" class="form-control" value="${detail.hsn}" readonly></td>
                        <td>
                            <input type="number" name="quantity_${rowCount}" id="quantity_${rowCount}"
                                class="form-control quantity-input" data-row="${rowCount}"
                                value="${detail.quantity}" step="0.001" readonly>
                        </td>
                        <td><input type="text" name="gst_${rowCount}" id="gst_${rowCount}" class="form-control" value="${detail.gst}" readonly></td>
                        <td><input type="text" name="rate_${rowCount}" id="rate_${rowCount}" class="form-control" value="${detail.rate}" readonly></td>
                        <td><input type="text" name="cgst_${rowCount}" id="cgst_${rowCount}" class="form-control" value="${detail.cgst}" readonly></td>
                        <td><input type="text" name="sgst_${rowCount}" id="sgst_${rowCount}" class="form-control" value="${detail.sgst}" readonly></td>
                        <td><input type="text" name="igst_${rowCount}" id="igst_${rowCount}" class="form-control" value="${detail.igst}" readonly></td>
                        <td><input type="text" step="0.001" name="reject_qty_${rowCount}" id="reject_qty_${rowCount}" class="form-control" value="0"></td>
                        <td><input type="text" name="total_rate_${rowCount}" id="total_rate_${rowCount}" class="form-control" value="0" readonly></td>
                    </tr>
                `;

                $tbody.append(row);
            });

            $('#cnt').val(rowCount);
            calculateTotals(); // recalc totals
        },
        error: function (xhr, status, error) {
            console.error('Failed to fetch purchase details:', error);
        }
    });
});


    // ✅ Product selection: fetch HSN, GST, rate, etc.
    document.addEventListener('change', function (event) {
        if (event.target.classList.contains('product-select')) {
            const row = event.target.dataset.row;
            const productId = event.target.value;

            if (!productId) return;

            fetch(`{{ url('/product-details') }}/${productId}`)
                .then(res => res.json())
                .then(data => {
                    document.getElementById(`hsn_${row}`).value = data.hsn;
                    document.getElementById(`gst_${row}`).value = data.gst;
                    document.getElementById(`rate_${row}`).value = data.rate;

                    const qtyInput = document.getElementById(`quantity_${row}`);
                    qtyInput.dataset.hasSerial = data.has_serial ? '1' : '0';

                    if (qtyInput.value) {
                        qtyInput.dispatchEvent(new Event('input'));
                    }
                })
                .catch(err => console.error("Fetch error:", err));
        }
    });

//  Show alert + clear rejected quantity if it exceeds available quantity
// Rejected qty calculation
// Rejected qty input handler
    // document.addEventListener('input', function (event) {
    //     if (event.target.id.startsWith('reject_qty_')) {
    //         const row = event.target.id.split('_')[2];
    //         const qty = parseFloat($(`#quantity_${row}`).val()) || 0;
    //         const rejectQty = parseFloat($(`#reject_qty_${row}`).val()) || 0;

    //         if (rejectQty > qty) {
    //             alert("Rejected quantity cannot exceed available quantity.");
    //             $(`#reject_qty_${row}`).val('0');
    //         }

    //         const rate = parseFloat($(`#rate_${row}`).val()) || 0;
    //         const gst = parseFloat($(`#gst_${row}`).val()) || 0;

    //         const taxable = rejectQty * rate;
    //         const cgst = (gst / 2) / 100 * taxable;
    //         const sgst = (gst / 2) / 100 * taxable;
    //         const igst = (gst / 100) * taxable;

    //         $(`#cgst_${row}`).val(cgst.toFixed(2));
    //         $(`#sgst_${row}`).val(sgst.toFixed(2));
    //         $(`#igst_${row}`).val(igst.toFixed(2));

    //         const total = taxable + cgst + sgst + igst;
    //         $(`#total_rate_${row}`).val(total.toFixed(2));

    //         calculateTotals();
    //     }
    // });

document.addEventListener('input', function (event) {
    if (event.target.id.startsWith('reject_qty_')) {
        const row = event.target.id.split('_')[2];

        const quantity = parseFloat(document.getElementById(`quantity_${row}`).value) || 0;
        const rejectQtyInput = document.getElementById(`reject_qty_${row}`);
        let rejectedQty = parseFloat(rejectQtyInput.value) || 0;

        //  If rejected quantity > actual quantity → alert + clear field
        if (rejectedQty > quantity) {
            alert("Rejected quantity cannot be more than available quantity.");
            rejectQtyInput.value = '';
            document.getElementById(`total_rate_${row}`).value = '0.00';
            return; // stop here
        }

        //  Recalculate total if value is valid
        const rate = parseFloat(document.getElementById(`rate_${row}`).value) || 0;
        const gst = parseFloat(document.getElementById(`gst_${row}`).value) || 0;
        const total = rejectedQty * rate * (1 + gst / 100);
        document.getElementById(`total_rate_${row}`).value = total.toFixed(2);
    }
    calculateTotals();
});

    // ✅ Trigger product filtering for existing rows if editing
    if (supplierSelect.value) {
        filterProductsBySupplier();
    }
    calculateTotals();

});

function calculateTotals() {
    let totalRejectQty = 0;
    let normalTotal = 0;
    let totalGST = 0;

    const rowCount = parseInt(document.getElementById('cnt').value);

    for (let i = 1; i <= rowCount; i++) {
        const rejectQty = parseFloat($(`#reject_qty_${i}`).val()) || 0;
        const rate = parseFloat($(`#rate_${i}`).val()) || 0;
        const gstPercent = parseFloat($(`#gst_${i}`).val()) || 0;

        totalRejectQty += rejectQty;
        normalTotal += rejectQty * rate;

        // Calculate GST for rejected quantity only
        totalGST += (rejectQty * rate * gstPercent / 100);
    }

    const grandTotal = normalTotal + totalGST;

    $("#total_reject_qty").val(totalRejectQty.toFixed(2));
    $("#normal_total").val(normalTotal.toFixed(2));
    $("#total_gst").val(totalGST.toFixed(2));
    $("#grand_total").val(grandTotal.toFixed(2));
}



</script>
@endpush

<script>
document.addEventListener('DOMContentLoaded', function() {
    const form = document.getElementById('purchaseReturnForm');

    form.addEventListener('submit', function(e) {
        let allZero = true;

        // Get all reject_qty inputs inside this form
        const rejectQtyInputs = form.querySelectorAll('input[name^="reject_qty_"]');

        rejectQtyInputs.forEach(function(input) {
            const value = parseFloat(input.value) || 0; // empty string becomes 0
            if (value > 0) {
                allZero = false; // At least one value > 0
            }
        });

        if (allZero) {
            e.preventDefault(); // Stop form submission
            alert('At least 1 product should be returned!');
        }
    });
});
</script>