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

                            <div class="row">
                                
                               <div class="mb-3 col-md-3">
                                    <label class="form-label" for="record_no">Record Number <small class="text-danger">*</small></label>
                                    <input type="text" class="form-control @error('invoice_no') is-invalid @enderror"
                                        name="record_no" id="record_no"
                                         value="{{ old('record_no', $returnmaterial->record_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" required>
                                        <option disabled selected value="">Select Customer</option>
                                       @foreach($customers as $customer)
                                            <option value="{{ $customer->id }}"
                                                {{ old('customer_id', $returnmaterial->customer_id ?? '') == $customer->id ? 'selected' : '' }}>
                                                {{ $customer->name }}
                                            </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="consumption_no">Consumption No.</label>
                                    <select name="consumption_no" id="consumption_no" class="form-control">
                                        <option value="">Select Sale Invoice No.</option>
                                        @if(!empty($returnmaterial->consumption_no))
                                            <option selected>{{ $returnmaterial->consumption_no }}</option>
                                        @endif
                                    </select>
                                    @error('consumption_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', $returnmaterial->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', $returnmaterial->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">Consumption Date <small class="text-danger">*</small></label>
                                    <input type="date" class="form-control @error('consumption_date') is-invalid @enderror"
                                        name="consumption_date" id="consumption_date"
                                        value="{{ old('consumption_date', $returnmaterial->consumption_date ?? date('Y-m-d')) }}" required>
                                    @error('consumption_date')
                                        <small class="text-danger">{{ $message }}</small>
                                    @enderror
                                </div>
                                 
                            </div>

                            <div class="row">
                                <table class="table" id="mytable">
                                    <thead>
                                        <tr>
                                            <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>Rejected Qty<small class="text-danger">*</small></th>
                                           
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php $i = 0; @endphp
                                        @if(!empty($returnmaterialdetails))
                                            @foreach($returnmaterialdetails as $detail)
                                                @php $i++; @endphp
                                                <tr id="row_{{ $i }}">
                                                    <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 }}" min="1" value="{{ $detail->quantity }}">

                                                    </td>
                                                    @php
                                                        $serials = explode(',', $detail->serial_no);
                                                        $macs = explode(',', $detail->mac_id);
                                                        $product = $products->firstWhere('id', $detail->product_id);

                                                    @endphp

                                                  
                                                    <td id="serial_no_container_{{ $i }}">
                                                        @if($product && $product->serial == 'yes')
                                                        @foreach($serials as $serial)
                                                            <input type="text" name="serial_no_{{ $i }}[]" class="form-control mb-1" value="{{ $serial }}" required>
                                                        @endforeach
                                                        @endif
                                                    </td>
                                                    <td id="mac_id_container_{{ $i }}">
                                                        @if($product && $product->serial == 'yes')
                                                        @foreach($macs as $mac)
                                                            <input type="text" name="mac_id_{{ $i }}[]" class="form-control mb-1" value="{{ $mac }}" required>
                                                        @endforeach
                                                        @endif
                                                    </td>
                                                     
                                                   
                                                    <td>
                                                        <input type="text" name="reject_qty_{{ $i }}" id="reject_qty_{{ $i }}" class="form-control" value="{{ $detail->reject_qty }}" >
                                                    </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($returnmaterial) ? 'Update' : 'Create' }}</button>
                            <a href="{{ route('returnmaterial') }}" class="btn btn-secondary">Cancel</a>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>
@endsection
@section('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('consumption_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 Return material numbers:', err);
        });
}

});

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

    fetch(`{{ route('sale.details', ':consumption_no') }}`.replace(':consumption_no', purchaseNo))
        .then(response => response.json())
        .then(data => {
            document.getElementById('firm').value = data.firm;
            document.getElementById('consumption_date').value = data.consumption_date;

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

          data.details.forEach((detail) => {
            const serials = detail.serial_no ? detail.serial_no.split(',') : [];
            const macs = detail.mac_id ? detail.mac_id.split(',') : [];

            // ✅ Take the maximum of qty, serials count, and macs count
            let qty = parseInt(detail.quantity);
            if (isNaN(qty)) qty = 0;

            const totalRows = Math.max(qty, serials.length, macs.length, 1);

            for (let q = 1; q <= totalRows; q++) {
                const serialInput = serials[q - 1] || '';
                const macInput = macs[q - 1] || '';

                rowCount++;
                const rowId = `row_${rowCount}`;

                const qtyValue = 1; // usually per serial row = 1 qty
                const qtyStyle = qty === 0 ? 'background:#f5f5f5;color:#888;' : '';

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

                row.innerHTML = `
                    <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="${qtyValue}" 
                            min="0"
                            style="${qtyStyle}" readonly>
                        <small class="text-muted">Returned: ${detail.already_returned} / ${detail.original_qty}</small>
                    </td>
                    <td id="serial_no_container_${rowCount}">
                        ${serialInput ? `<input type="text" name="serial_no_${rowCount}[]" class="form-control mb-1" value="${serialInput}" required>` : ''}
                    </td>
                    <td id="mac_id_container_${rowCount}">
                        ${macInput ? `<input type="text" name="mac_id_${rowCount}[]" class="form-control mb-1" value="${macInput}" required>` : ''}
                    </td>
                    <td><input type="text" name="reject_qty_${rowCount}" id="reject_qty_${rowCount}" class="form-control" value=""></td>
                `;

                tbody.appendChild(row);
            }

            });


            document.getElementById('cnt').value = rowCount;
        })
        .catch(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('/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 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>
@endsection