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

                            <div class="row">

                               <div class="mb-3 col-md-3">
                                    <label class="form-label" for="invoice_no">Invoice Return Number <small class="text-danger">*</small></label>
                                    <input type="text" class="form-control @error('invoice_no') is-invalid @enderror"
                                        name="invoice_no" id="invoice_no"
                                         value="{{ old('invoice_no', $salereturn->invoice_no ?? $invoice_no) }}"
                                        readonly required>
                                    @error('invoice_no')
                                        <small class="text-danger">{{ $message }}</small>
                                    @enderror
                                </div>
                                <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 @error('customer_id') is-invalid @enderror" required>
                                        <option disabled selected value="">Select Customer</option>
                                       @foreach($customers as $customer)
                                            <option value="{{ $customer->id }}"
                                                {{ old('customer_id', $salereturn->customer_id ?? '') == $customer->id ? 'selected' : '' }}>
                                                {{ $customer->fname }}
                                            </option>
                                        @endforeach
                                    </select>
                                    @error('customer_id')
                                        <small class="text-danger">{{ $message }}</small>
                                    @enderror
                                </div>
                                <div class="mb-3 col-md-3">
    <label class="form-label" for="saleinvoice_no">Sale Invoice No.<small class="text-danger">*</small></label>
    <select name="saleinvoice_no" id="saleinvoice_no" class="form-control" required>
        <option value="">Select Sale Invoice No.</option>
        @if(!empty($salereturn->saleinvoice_no))
            <option selected>{{ $salereturn->saleinvoice_no }}</option>
        @endif
    </select>
    @error('saleinvoice_no')
        <small class="text-danger">{{ $message }}</small>
    @enderror
</div>


                                {{-- <div class="mb-3 col-md-3">
                                    <label class="form-label" for="firm">Firm <small class="text-danger">*</small></label>
                                    <select id="firm" name="firm" class="form-control choices-single" required>
                                        <option disabled selected value="">Select Firm</option>
                                        @foreach($firms as $firm)
                                            <option value="{{ $firm->id }}"
                                                {{ old('firm', $salereturn->firm ?? '') == $firm->id ? 'selected' : '' }}>
                                                {{ $firm->name }}
                                            </option>
                                        @endforeach
                                    </select>
                                    @error('firm')
                                        <small class="text-danger">{{ $message }}</small>
                                    @enderror
                                </div> --}}
                                 <div class="mb-3 col-md-3">
                                    <label class="form-label" for="date">Date <small class="text-danger">*</small></label>
                                    <input type="date" class="form-control @error('idate') is-invalid @enderror"
                                        name="idate" id="idate"
                                        value="{{ old('idate', $salereturn->idate ?? date('Y-m-d')) }}" required>
                                    @error('idate')
                                        <small class="text-danger">{{ $message }}</small>
                                    @enderror
                                </div>
                                <div class="mb-3 col-md-3">
                                    <label class="form-label" for="date">Invoice Date <small class="text-danger">*</small></label>
                                    <input type="date" class="form-control"
                                        name="invoice_date" id="invoice_date"
                                        value="{{ old('invoice_date', $salereturn->invoice_date ?? date('Y-m-d')) }}" required>
                                    @error('invoice_date')
                                        <small class="text-danger">{{ $message }}</small>
                                    @enderror
                                </div>

                            </div>

                            <div class="row">
                                <table class="table" id="mytable">
                                    <thead>
                                        <tr>
                                            <th>Lot No</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>Serial No(s)</th>
                                            <th>MAC Id(s)</th> --}}
                                            <th>GST (%)</th>
                                            <th>Rate</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($salesdetails))
                                            @foreach($salesdetails 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>
                                                         @error('lot_no_'.$i)
                                                            <small class="text-danger">{{ $message }}</small>
                                                        @enderror
                                                    </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" min="1" value="{{ $detail->quantity }}">

                                                    </td>
                                                    @php

                                                        $product = $products->firstWhere('id', $detail->product_id);

                                                    @endphp

                                                    <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" step="0.001"
                                                        name="reject_qty_{{ $i }}"
                                                        id="reject_qty_{{ $i }}"
                                                        class="form-control @error('reject_qty_'.$i) is-invalid @enderror"
                                                        value="{{ old('reject_qty_'.$i, $detail->reject_qty ?? '') }}">

                                                    @error('reject_qty_'.$i)
                                                        <small class="text-danger">{{ $message }}</small>
                                                    @enderror
                                                </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>
                                </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($salereturn) ? 'Update' : 'Create' }}</button>
                            <a href="{{ route('salereturn') }}" 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('customer_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.customer_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 customerId = this.value;

    filterProductsBySupplier(); // existing function

    // Fetch Purchase Numbers for selected supplier
    // Fetch Purchase Numbers for selected supplier
if (customerId) {
    fetch(`{{ route('sales.byCustomer', ':id') }}`.replace(':id', customerId))
        .then(response => response.json())
        .then(data => {
            const purchaseNoSelect = document.getElementById('saleinvoice_no');
            purchaseNoSelect.innerHTML = '<option value="">Select Sale Invoice No.</option>';
            data.forEach(sales => {
                const option = document.createElement('option');
                option.value = sales.invoice_no;
                option.text = sales.invoice_no;
                purchaseNoSelect.appendChild(option);
            });
        })
        .catch(err => {
            console.error('Error fetching sale invoice numbers:', err);
        });
}

});

    // When a Purchase No is selected
document.getElementById('saleinvoice_no').addEventListener('change', function () {
    const purchaseNo = this.value;
    if (!purchaseNo) return;

    const url = `{{ route('sale.details', ':saleinvoice_no') }}`.replace(':saleinvoice_no', purchaseNo);
    console.log('Fetching URL:', url); // Debug the URL

    fetch(url, {
        headers: {
            'Accept': 'application/json' // Ensure Laravel returns JSON even for errors
        }
    })
    .then(response => {
        if (!response.ok) {
            // Server returned 404/500/etc
            return response.text().then(text => {
                throw new Error(`Server error: ${response.status}\n${text}`);
            });
        }
        return response.json(); // Parse JSON if OK
    })
    .then(data => {

        // Your existing functionality stays exactly the same
        document.getElementById('invoice_date').value = data.invoice_date;

        const tbody = document.querySelector("#mytable tbody");
        tbody.innerHTML = '';
        let rowCount = 0;

     data.details.forEach((detail) => {
    rowCount++;
    const rowId = `row_${rowCount}`;

    const qtyValue = parseInt(detail.quantity) || 0;
    const qtyStyle = qtyValue === 0 ? 'background:#f5f5f5;color:#888;' : '';

    const row = document.createElement('tr');
    row.id = rowId;

    row.innerHTML = `
         <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.product_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>
             <small class="text-muted">Returned: ${detail.already_returned} / ${detail.original_qty}</small>
        </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="reject_qty_${rowCount}" id="reject_qty_${rowCount}"  step="0.001" class="form-control" value=""></td>
        <td><input type="text" name="total_rate_${rowCount}" id="total_rate_${rowCount}" class="form-control" value="0" readonly></td>
    `;

    tbody.appendChild(row);
});

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

    })
    .catch(error => {
        // Show a friendly error in console and alert
        console.error('Failed to fetch purchase details:', error);
        alert('Failed to fetch purchase details. Check console for details.');
    });
});

    // ✅ 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('/saleproduct-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
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 (rejectedQty < 1) {
                        alert("Rejected quantity must be at least 1.");
                        rejectQtyInput.value = '';
                        document.getElementById(`total_rate_${row}`).value = '0.00';
                        return;
                    }

        //  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);
    }
});

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


</script>
@endpush