@extends('layouts.inspinia')

@section('title', 'Edit Purchase Order')

@section('content_header', $purchaseOrder->purchase_order_number ?? 'Edit Purchase Order')

@section('breadcrumb')
    <li class="breadcrumb-item"><a href="{{ route('purchase-orders.index') }}">Purchase Orders</a></li>
    <li class="breadcrumb-item"><a href="{{ route('purchase-orders.show', $purchaseOrder) }}">{{ $purchaseOrder->purchase_order_number }}</a></li>
    <li class="breadcrumb-item active"><strong>Edit</strong></li>
@endsection

@section('content')

    @if(session('error'))
        <div class="alert alert-danger alert-dismissible">
            <button type="button" class="close" data-dismiss="alert">&times;</button>
            {{ session('error') }}
        </div>
    @endif
    @if($errors->any())
        <div class="alert alert-danger">
            <ul class="mb-0">@foreach($errors->all() as $e)<li>{{ $e }}</li>@endforeach</ul>
        </div>
    @endif

    <form method="POST" action="{{ route('purchase-orders.update', $purchaseOrder) }}">
        @csrf
        @method('PUT')

        {{-- Header --}}
        <div class="ibox">
            <div class="ibox-title">
                <h5><i class="fas fa-edit mr-1"></i> Edit: {{ $purchaseOrder->purchase_order_number }}</h5>
                <div class="ibox-tools">
                    <a href="{{ route('purchase-orders.show', $purchaseOrder) }}" class="btn btn-secondary btn-sm">
                        <i class="fas fa-arrow-left"></i> Back
                    </a>
                </div>
            </div>
            <div class="ibox-content">
                <div class="row">
                    {{-- Supplier --}}
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Vendor Name <span class="text-danger">*</span></label>
                            <select id="supplier_id" name="supplier_id"
                                    class="form-control @error('supplier_id') is-invalid @enderror"
                                    style="width:100%" required>
                                @if($purchaseOrder->supplier)
                                    <option value="{{ $purchaseOrder->supplier_id }}" selected>
                                        {{ $purchaseOrder->supplier->name }}
                                        {{ $purchaseOrder->supplier->phone ? '| '.$purchaseOrder->supplier->phone : '' }}
                                    </option>
                                @else
                                    <option value="">— Search supplier —</option>
                                @endif
                            </select>
                            @error('supplier_id')<div class="invalid-feedback">{{ $message }}</div>@enderror
                        </div>
                    </div>
                    {{-- Warehouse --}}
                    <div class="col-md-2">
                        <div class="form-group">
                            <label>Warehouse <span class="text-danger">*</span></label>
                            <select name="warehouse_id"
                                    class="form-control form-control-sm @error('warehouse_id') is-invalid @enderror" required>
                                <option value="">— Select —</option>
                                @foreach($warehouses as $w)
                                    <option value="{{ $w->id }}"
                                        {{ old('warehouse_id', $purchaseOrder->warehouse_id) == $w->id ? 'selected' : '' }}>
                                        {{ $w->name }}
                                    </option>
                                @endforeach
                            </select>
                            @error('warehouse_id')<div class="invalid-feedback">{{ $message }}</div>@enderror
                        </div>
                    </div>
                    {{-- PO Date --}}
                    <div class="col-md-2">
                        <div class="form-group">
                            <label>Date <span class="text-danger">*</span></label>
                            <input type="date" name="purchase_order_date"
                                   class="form-control form-control-sm @error('purchase_order_date') is-invalid @enderror"
                                   value="{{ old('purchase_order_date', $purchaseOrder->purchase_order_date?->format('Y-m-d')) }}" required>
                            @error('purchase_order_date')<div class="invalid-feedback">{{ $message }}</div>@enderror
                        </div>
                    </div>
                    {{-- Expected Delivery --}}
                    <div class="col-md-2">
                        <div class="form-group">
                            <label>Expected Delivery</label>
                            <input type="date" name="expected_delivery_date"
                                   class="form-control form-control-sm"
                                   value="{{ old('expected_delivery_date', $purchaseOrder->expected_delivery_date?->format('Y-m-d')) }}">
                        </div>
                    </div>
                    {{-- Payment Method --}}
                    <div class="col-md-2">
                        <div class="form-group">
                            <label>Payment</label>
                            <select name="payment_method" class="form-control form-control-sm">
                                <option value="">— Select —</option>
                                @foreach(['cash'=>'Cash','cheque'=>'Cheque','bank_transfer'=>'Bank Transfer','credit'=>'Credit','mobile_money'=>'Mobile Money'] as $val => $label)
                                    <option value="{{ $val }}" {{ old('payment_method', $purchaseOrder->payment_method) === $val ? 'selected' : '' }}>{{ $label }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                </div>

                <div class="row">
                    {{-- Receipt Number --}}
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Receipt Number</label>
                            <input type="text" name="receipt_number" id="receipt_number"
                                   class="form-control form-control-sm @error('receipt_number') is-invalid @enderror"
                                   value="{{ old('receipt_number', $purchaseOrder->receipt_number) }}"
                                   placeholder="EFD Receipt No.">
                            @error('receipt_number')<div class="invalid-feedback">{{ $message }}</div>@enderror
                            <div id="receiptDuplicateWarning" class="text-danger small mt-1" style="display:none"></div>
                        </div>
                    </div>
                    {{-- Receipt Date --}}
                    <div class="col-md-2">
                        <div class="form-group">
                            <label>Receipt Date</label>
                            <input type="date" name="receipt_date"
                                   class="form-control form-control-sm"
                                   value="{{ old('receipt_date', $purchaseOrder->receipt_date?->format('Y-m-d')) }}">
                        </div>
                    </div>
                    {{-- Supplier VRN --}}
                    <div class="col-md-2">
                        <div class="form-group">
                            <label>Supplier VRN</label>
                            <input type="text" name="supplier_vrn" id="supplier_vrn"
                                   class="form-control form-control-sm"
                                   value="{{ old('supplier_vrn', $purchaseOrder->supplier_vrn ?? $purchaseOrder->supplier?->vrn) }}"
                                   placeholder="Auto-filled from supplier">
                        </div>
                    </div>
                    {{-- Source File Ref --}}
                    <div class="col-md-2">
                        <div class="form-group">
                            <label>File Reference</label>
                            <input type="text" name="source_file_reference"
                                   class="form-control form-control-sm"
                                   value="{{ old('source_file_reference', $purchaseOrder->source_file_reference) }}">
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-2">
                        <div class="form-group">
                            <label>Reconciliation Status</label>
                            <select name="reconciliation_status" class="form-control form-control-sm">
                                @foreach(['unchecked'=>'Unchecked','matched'=>'Matched','variance'=>'Variance','missing'=>'Missing','verified'=>'Verified'] as $val => $label)
                                    <option value="{{ $val }}" {{ old('reconciliation_status', $purchaseOrder->reconciliation_status ?? 'unchecked') === $val ? 'selected' : '' }}>{{ $label }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="form-group">
                            <label>Reconciliation Notes</label>
                            <input type="text" name="reconciliation_notes" class="form-control form-control-sm"
                                   value="{{ old('reconciliation_notes', $purchaseOrder->reconciliation_notes) }}">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Internal Notes</label>
                            <textarea name="notes" rows="1" class="form-control form-control-sm">{{ old('notes', $purchaseOrder->notes) }}</textarea>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        {{-- Items Table --}}
        <div class="ibox">
            <div class="ibox-title">
                <h5><i class="fas fa-list mr-1"></i> Order Items</h5>
                <div class="ibox-tools">
                    <button type="button" class="btn btn-sm btn-outline-primary" id="addRow">
                        <i class="fas fa-plus"></i> Add Item
                    </button>
                </div>
            </div>
            @error('items')<div class="alert alert-danger mb-0 rounded-0 mx-3 mt-2">{{ $message }}</div>@enderror
            <div class="ibox-content p-0">
                <div class="table-responsive">
                    <table class="table table-bordered table-sm mb-0">
                        <thead class="thead-light">
                        <tr>
                            <th style="min-width:240px">Items <span class="text-danger">*</span></th>
                            <th width="70">Qty <span class="text-danger">*</span></th>
                            <th width="110">Unit</th>
                            <th width="130">Price <span class="text-danger">*</span></th>
                            <th width="65">VAT %</th>
                            <th width="110">VAT Amt</th>
                            <th width="120">Total Excl</th>
                            <th width="120">Total Incl</th>
                            <th width="90">Items Check</th>
                            <th width="30"></th>
                        </tr>
                        </thead>
                        <tbody id="itemsBody">
                        @php $oldItems = old('items'); @endphp
                        @foreach($purchaseOrder->items as $i => $item)
                        <tr class="item-row">
                            <input type="hidden" name="items[{{ $i }}][purchase_request_item_id]" value="{{ $item->purchase_request_item_id ?? '' }}">
                            <input type="hidden" name="items[{{ $i }}][item_id]" class="hid-item-id" value="{{ $oldItems[$i]['item_id'] ?? $item->item_id ?? '' }}">
                            <input type="hidden" name="items[{{ $i }}][item_alias_id]" class="hid-alias-id" value="{{ $oldItems[$i]['item_alias_id'] ?? $item->item_alias_id ?? '' }}">
                            <input type="hidden" name="items[{{ $i }}][discount_amount]" value="0">
                            <td>
                                <select class="form-control form-control-sm item-search-select" style="width:100%"></select>
                                <input type="text" name="items[{{ $i }}][description]"
                                       class="form-control form-control-sm desc-input mt-1" required
                                       value="{{ $oldItems[$i]['description'] ?? $item->description }}">
                            </td>
                            <td><input type="number" name="items[{{ $i }}][quantity]"
                                       class="form-control form-control-sm qty-input"
                                       min="0.01" step="0.01" required
                                       value="{{ $oldItems[$i]['quantity'] ?? $item->quantity }}"></td>
                            <td>
                                <select name="items[{{ $i }}][unit_id]" class="form-control form-control-sm">
                                    <option value="">—</option>
                                    @foreach($units as $u)
                                        <option value="{{ $u->id }}"
                                            {{ ($oldItems[$i]['unit_id'] ?? $item->unit_id) == $u->id ? 'selected' : '' }}>
                                            {{ $u->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </td>
                            <td><input type="number" name="items[{{ $i }}][unit_cost]"
                                       class="form-control form-control-sm cost-input"
                                       min="0" step="0.01" required style="min-width:110px"
                                       value="{{ $oldItems[$i]['unit_cost'] ?? $item->unit_cost }}"></td>
                            <td><input type="number" name="items[{{ $i }}][tax_rate]"
                                       class="form-control form-control-sm tax-input"
                                       min="0" max="100" step="0.01"
                                       value="{{ $oldItems[$i]['tax_rate'] ?? $item->tax_rate }}"></td>
                            @php
                                $exclVal = (float)$item->quantity * (float)$item->unit_cost;
                                $vatVal  = (float)$item->tax_amount;
                                $inclVal = (float)$item->line_total;
                            @endphp
                            <td><input type="text" class="form-control form-control-sm vat-display"
                                       readonly tabindex="-1" value="{{ number_format($vatVal, 2) }}"></td>
                            <td><input type="text" class="form-control form-control-sm excl-display"
                                       readonly tabindex="-1" value="{{ number_format($exclVal, 2) }}"></td>
                            <td><input type="text" class="form-control form-control-sm total-display font-weight-bold"
                                       readonly tabindex="-1" value="{{ number_format($inclVal, 2) }}"></td>
                            <td>
                                <select name="items[{{ $i }}][items_check]" class="form-control form-control-sm">
                                    @foreach(['pending'=>'Pending','checked'=>'Checked','mismatch'=>'Mismatch'] as $cv => $cl)
                                        <option value="{{ $cv }}" {{ ($oldItems[$i]['items_check'] ?? $item->items_check ?? 'pending') === $cv ? 'selected' : '' }}>{{ $cl }}</option>
                                    @endforeach
                                </select>
                            </td>
                            <td class="text-center">
                                <button type="button" class="btn btn-sm btn-outline-danger remove-row" title="Remove">
                                    <i class="fas fa-times"></i>
                                </button>
                            </td>
                        </tr>
                        @endforeach
                        </tbody>
                        <tfoot class="thead-light">
                        <tr>
                            <td colspan="5" class="text-right font-weight-bold">Totals:</td>
                            <td><input type="text" id="totalVat"   class="form-control form-control-sm font-weight-bold" readonly value="{{ number_format((float)$purchaseOrder->tax_amount, 2) }}" title="Total VAT"></td>
                            <td><input type="text" id="totalExcl"  class="form-control form-control-sm" readonly value="{{ number_format((float)$purchaseOrder->subtotal, 2) }}" title="Total Excl VAT"></td>
                            <td><input type="text" id="grandTotal" class="form-control form-control-sm font-weight-bold text-success" readonly value="{{ number_format((float)$purchaseOrder->total_amount, 2) }}" title="Grand Total"></td>
                            <td colspan="2"></td>
                        </tr>
                        </tfoot>
                    </table>
                </div>
                <div class="d-flex justify-content-between p-3">
                    <a href="{{ route('purchase-orders.show', $purchaseOrder) }}" class="btn btn-secondary">
                        <i class="fas fa-arrow-left"></i> Back
                    </a>
                    <button type="submit" class="btn btn-warning">
                        <i class="fas fa-save"></i> Update Purchase Order
                    </button>
                </div>
            </div>
        </div>

    </form>

@endsection

@push('js')
<script>
    function initItemSelect(el) {
        el.select2({
            placeholder: '— Search item —',
            minimumInputLength: 0,
            width: '100%',
            ajax: {
                url: '{{ route("ajax.items.search") }}',
                dataType: 'json',
                delay: 250,
                data: function(p) { return { q: p.term }; },
                processResults: function(d) { return { results: d.results }; },
            },
        });
        el.on('select2:select', function(e) {
            const data = e.params.data;
            const row  = $(this).closest('tr');
            row.find('.hid-item-id').val(data.item_id);
            row.find('.hid-alias-id').val(data.id);
            row.find('.desc-input').val(data.text);
            calcRow(row);
        });
    }

    $('#supplier_id').select2({
        ajax: {
            url: '{{ route('ajax.suppliers.search') }}',
            dataType: 'json',
            delay: 200,
            data: function(p) { return { q: p.term }; },
            processResults: function(d) { return { results: d.results }; },
        },
        placeholder: '— Search supplier —',
        allowClear: true,
        minimumInputLength: 0,
    });

    $('#supplier_id').on('select2:select', function(e) {
        const vrn = e.params.data.vrn || '';
        if (!$('#supplier_vrn').val()) { $('#supplier_vrn').val(vrn); }
        checkReceiptDuplicate();
    });

    // ── Duplicate receipt check ────────────────────────────────────────────────
    let receiptCheckTimer = null;
    function checkReceiptDuplicate() {
        const supplierId = $('#supplier_id').val();
        const receiptNo  = $('#receipt_number').val().trim();
        const $warn      = $('#receiptDuplicateWarning');
        if (!supplierId || !receiptNo) { $warn.hide(); return; }
        clearTimeout(receiptCheckTimer);
        receiptCheckTimer = setTimeout(function() {
            $.getJSON('{{ route("ajax.purchases.check-receipt") }}', {
                supplier_id: supplierId,
                receipt_number: receiptNo,
                exclude_id: {{ $purchaseOrder->id }},
            }).done(function(res) {
                if (res.exists) {
                    $warn.html('<i class="fas fa-exclamation-triangle"></i> ' + res.message +
                        ' <a href="' + res.route + '" target="_blank" class="text-danger font-weight-bold">' +
                        res.document_number + '</a>').show();
                } else { $warn.hide(); }
            }).fail(function() { $warn.hide(); });
        }, 400);
    }
    $('#receipt_number').on('input', checkReceiptDuplicate);

    // ── Row calculations ───────────────────────────────────────────────────────
    function calcRow(row) {
        const qty     = parseFloat($(row).find('.qty-input').val()) || 0;
        const cost    = parseFloat($(row).find('.cost-input').val()) || 0;
        const taxRate = parseFloat($(row).find('.tax-input').val()) || 0;
        const excl    = qty * cost;
        const vatAmt  = excl * taxRate / 100;
        const incl    = excl + vatAmt;
        $(row).find('.excl-display').val(excl.toFixed(2));
        $(row).find('.vat-display').val(vatAmt.toFixed(2));
        $(row).find('.total-display').val(incl.toFixed(2));
        updateTotals();
    }

    function updateTotals() {
        let totalExcl = 0, totalVat = 0, grandTotal = 0;
        $('#itemsBody .item-row').each(function() {
            totalExcl  += parseFloat($(this).find('.excl-display').val()) || 0;
            totalVat   += parseFloat($(this).find('.vat-display').val()) || 0;
            grandTotal += parseFloat($(this).find('.total-display').val()) || 0;
        });
        $('#totalExcl').val(totalExcl.toFixed(2));
        $('#totalVat').val(totalVat.toFixed(2));
        $('#grandTotal').val(grandTotal.toFixed(2));
    }

    $(document).on('input', '.qty-input, .cost-input, .tax-input', function() {
        calcRow($(this).closest('tr'));
    });

    let rowIndex = {{ $purchaseOrder->items->count() }};
    const unitOptions = `{!! $units->map(fn($u) => "<option value='{$u->id}'>{$u->name}</option>")->implode('') !!}`;

    $('#addRow').on('click', function() {
        const i = rowIndex++;
        const row = `
        <tr class="item-row">
            <input type="hidden" name="items[${i}][purchase_request_item_id]" value="">
            <input type="hidden" name="items[${i}][item_id]" class="hid-item-id" value="">
            <input type="hidden" name="items[${i}][item_alias_id]" class="hid-alias-id" value="">
            <input type="hidden" name="items[${i}][discount_amount]" value="0">
            <td>
                <select class="form-control form-control-sm item-search-select" style="width:100%"></select>
                <input type="text" name="items[${i}][description]" class="form-control form-control-sm desc-input mt-1" required placeholder="Description">
            </td>
            <td><input type="number" name="items[${i}][quantity]" class="form-control form-control-sm qty-input" min="0.01" step="0.01" required></td>
            <td><select name="items[${i}][unit_id]" class="form-control form-control-sm"><option value="">—</option>${unitOptions}</select></td>
            <td><input type="number" name="items[${i}][unit_cost]" class="form-control form-control-sm cost-input" min="0" step="0.01" required style="min-width:110px"></td>
            <td><input type="number" name="items[${i}][tax_rate]" class="form-control form-control-sm tax-input" min="0" max="100" step="0.01" value="18"></td>
            <td><input type="text" class="form-control form-control-sm vat-display" readonly tabindex="-1" value="0.00"></td>
            <td><input type="text" class="form-control form-control-sm excl-display" readonly tabindex="-1" value="0.00"></td>
            <td><input type="text" class="form-control form-control-sm total-display font-weight-bold" readonly tabindex="-1" value="0.00"></td>
            <td><select name="items[${i}][items_check]" class="form-control form-control-sm"><option value="pending" selected>Pending</option><option value="checked">Checked</option><option value="mismatch">Mismatch</option></select></td>
            <td class="text-center"><button type="button" class="btn btn-sm btn-outline-danger remove-row" title="Remove"><i class="fas fa-times"></i></button></td>
        </tr>`;
        $('#itemsBody').append(row);
        initItemSelect($('#itemsBody .item-row:last .item-search-select'));
    });

    $(document).on('click', '.remove-row', function() {
        if ($('#itemsBody .item-row').length <= 1) { alert('At least one item is required.'); return; }
        $(this).closest('tr').remove();
        updateTotals();
    });

    $('.item-search-select').each(function() { initItemSelect($(this)); });
</script>
@endpush