@extends('layouts.app')
@section('title', 'Edit Shipment')

@section('css')
    <link href="{{ asset('assets/libs/select2/css/select2.min.css') }}" rel="stylesheet" type="text/css" />
    <link href="{{ asset('assets/libs/bootstrap-datepicker/css/bootstrap-datepicker.min.css') }}" rel="stylesheet">
    <style>
        .form-control:disabled {
            background-color: #f8f9fa !important;
            opacity: 0.6;
            cursor: not-allowed;
        }
    </style>
@endsection

@section('content')
<div class="content-wrapper">
    <div class="row">
        <div class="col-md-12 grid-margin stretch-card">
            <div class="card">
                <div class="card-body">
                    <h4 class="card-title">Edit Shipment</h4>

                    <form id="editShipmentForm" action="{{ route('shipments.update', $shipment->id) }}" method="POST">
                        @csrf
                        @method('PUT')

                        <div class="row mt-4">
                            <div class="col-md-6">
                                <div class="form-group">
                                    <label for="customer_id">Customer <span class="text-danger">*</span></label>
                                    <select class="form-control select2 @error('customer_id') is-invalid @enderror"
                                        id="customer_id" name="customer_id" required>
                                                                                <option value="">-- Select Customer --</option>
                                        @foreach($customers as $customer)
                                            <option value="{{ $customer->id }}" {{ $shipment->customer_id == $customer->id ? 'selected' : '' }}>
                                                {{ $customer->user->name }} - {{ $customer->company_name }}
                                            </option>
                                        @endforeach
                                    </select>
                                    @error('customer_id')
                                        <div class="invalid-feedback">{{ $message }}</div>
                                    @enderror
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group">
                                    <label for="rate_plan_id">Rate Plan <span class="text-danger">*</span></label>
                                    <select class="form-control select2 @error('rate_plan_id') is-invalid @enderror"
                                        id="rate_plan_id" name="rate_plan_id" required>
                                        <option value="">-- Select Rate Plan --</option>
                                        @foreach($ratePlans as $ratePlan)
                                            <option value="{{ $ratePlan->id }}" data-price-cbm="{{ $ratePlan->price_per_cbm }}"
                                                data-price-kg="{{ $ratePlan->price_per_kg }}"
                                                {{ old('rate_plan_id', $shipment->rate_plan_id) == $ratePlan->id ? 'selected' : '' }}>
                                                {{ $ratePlan->name }} (CBM: {{ number_format($ratePlan->price_per_cbm, 2) }}, KG: {{ number_format($ratePlan->price_per_kg, 2) }})
                                            </option>
                                        @endforeach
                                    </select>
                                    @error('rate_plan_id')
                                        <div class="invalid-feedback">{{ $message }}</div>
                                    @enderror
                                </div>
                            </div>
                        </div>

                        <div class="row">
                            <div class="col-md-6">
                                <div class="form-group">
                                    <label for="resi_number">{{ __('invoice_page.resi') }} Number <span class="text-danger">*</span></label>
                                    <input type="text" class="form-control @error('resi_number') is-invalid @enderror"
                                        id="resi_number" name="resi_number" value="{{ old('resi_number', $shipment->resi_number) }}" required>
                                    <small class="form-text text-muted">Enter the shipment tracking number manually</small>
                                    @error('resi_number')
                                        <div class="invalid-feedback">{{ $message }}</div>
                                    @enderror
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label for="date_received">Date Received <span class="text-danger">*</span></label>
                                    <input type="date" class="form-control @error('date_received') is-invalid @enderror"
                                        id="date_received" name="date_received" value="{{ old('date_received', $shipment->date_received instanceof \Carbon\Carbon ? $shipment->date_received->format('Y-m-d') : $shipment->date_received) }}" required>
                                    @error('date_received')
                                        <div class="invalid-feedback">{{ $message }}</div>
                                    @enderror
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label for="discount_amount">Discount Amount</label>
                                    <input type="number" step="0.01" class="form-control @error('discount_amount') is-invalid @enderror"
                                        id="discount_amount" name="discount_amount" value="{{ old('discount_amount', $shipment->discount_amount) }}">
                                    @error('discount_amount')
                                        <div class="invalid-feedback">{{ $message }}</div>
                                    @enderror
                                </div>
                            </div>
                        </div>

                        <hr>
                        <h5>Shipment Items</h5>

                        <div id="items-container">
                            <!-- Item rows will be added here dynamically -->
                        </div>

                        <div class="row mt-3">
                            <div class="col-md-12 text-right">
                                <button type="button" class="btn btn-info" id="add-item-btn">
                                    <i class="mdi mdi-plus"></i> Add Item
                                </button>
                            </div>
                        </div>

                        <!-- Total Calculation Section -->
                        <div class="row mt-4">
                            <div class="col-md-12">
                                <div class="card">
                                    <div class="card-header">
                                        <h5 class="card-title mb-0">Calculation Summary</h5>
                                    </div>
                                    <div class="card-body">
                                        <!-- Calculation Details -->
                                        <div class="row">
                                            <div class="col-md-6">
                                                <h6 class="text-primary">Volume & Weight Details</h6>
                                                <div class="row">
                                                    <div class="col-md-6">
                                                        <div class="form-group">
                                                            <label>Total Volume (CBM)</label>
                                                            <input type="text" class="form-control" id="total-volume" readonly>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-6">
                                                        <div class="form-group">
                                                            <label>Total Weight (KG)</label>
                                                            <input type="text" class="form-control" id="total-weight" readonly>
                                                        </div>
                                                    </div>
                                                </div>

                                                <div class="row">
                                                    <div class="col-md-6">
                                                        <div class="form-group">
                                                            <label>Berat Tercover (600kg/CBM)</label>
                                                            <input type="text" class="form-control" id="volume-weight" readonly>
                                                            <small class="text-muted">Volume × 600kg</small>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-6">
                                                        <div class="form-group">
                                                            <label><strong>Hasil CBM (Volume + Kelebihan)</strong></label>
                                                            <input type="text" class="form-control font-weight-bold" id="chargeable-weight" readonly>
                                                            <small class="text-muted">Volume asli + kelebihan dari berat</small>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>

                                            <div class="col-md-6">
                                                <h6 class="text-success">Pricing Details</h6>
                                                <div class="row">
                                                    <div class="col-md-6">
                                                        <div class="form-group">
                                                            <label>Harga per CBM (Rate Plan)</label>
                                                            <input type="text" class="form-control" id="cost-per-cbm" readonly>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-6">
                                                        <div class="form-group">
                                                            <label>Harga per KG (Calculated)</label>
                                                            <input type="text" class="form-control" id="cost-per-kg" readonly>
                                                            <small class="text-muted">Dihitung: (Hasil CBM × Harga CBM) ÷ Total Berat</small>
                                                        </div>
                                                    </div>
                                                </div>

                                                <div class="row">
                                                    <div class="col-md-6">
                                                        <div class="form-group">
                                                            <label>Biaya CBM (Hasil CBM × Rate)</label>
                                                            <input type="text" class="form-control" id="volume-cost" readonly>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-6">
                                                        <div class="form-group">
                                                            <label>Biaya KG (Total Berat × Rate KG)</label>
                                                            <input type="text" class="form-control" id="weight-cost" readonly>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

                                        <hr>

                                        <!-- Final Calculation -->
                                        <div class="row">
                                            <div class="col-md-3">
                                                <div class="form-group">
                                                    <label><strong>Biaya Pengiriman</strong></label>
                                                    <input type="text" class="form-control font-weight-bold" id="chargeable-cost" readonly>
                                                </div>
                                            </div>
                                            <div class="col-md-3">
                                                <div class="form-group">
                                                    <label><strong>Biaya Asuransi</strong></label>
                                                    <input type="text" class="form-control" id="insurance-cost" readonly>
                                                    <small class="text-muted">Asuransi untuk nilai > 20jt/CBM</small>
                                                </div>
                                            </div>
                                            <div class="col-md-3">
                                                <div class="form-group">
                                                    <label>Discount Amount</label>
                                                    <input type="text" class="form-control" id="discount-display" readonly>
                                                </div>
                                            </div>
                                            <div class="col-md-3">
                                                <div class="form-group">
                                                    <label for="total_charge"><strong>{{ __('invoice_page.total') }} PEMBAYARAN</strong></label>
                                                    <input type="number" step="0.01" class="form-control font-weight-bold text-primary @error('total_charge') is-invalid @enderror"
                                                           id="total_charge" name="total_charge" value="{{ old('total_charge', $shipment->total_charge) }}" style="font-size: 18px;">
                                                    <small class="form-text text-muted">Total yang harus dibayar customer</small>
                                                    @error('total_charge')
                                                        <div class="invalid-feedback">{{ $message }}</div>
                                                    @enderror
                                                </div>
                                            </div>
                                        </div>

                                        <div class="row">
                                            <div class="col-md-12">
                                                <div class="alert alert-info">
                                                    <small class="text-info">
                                                        <i class="mdi mdi-information"></i>
                                                        <strong>Cara Perhitungan Baru (1 CBM = Maks 600kg):</strong>
                                                    </small>
                                                    <ul class="small mb-0 mt-2">
                                                        <li><strong>Berat Tercover:</strong> Total CBM × 600kg</li>
                                                        <li><strong>Selisih Berat:</strong> Total Berat - Berat Tercover (jika positif)</li>
                                                        <li><strong>Kelebihan CBM:</strong> Selisih Berat ÷ 2000</li>
                                                        <li><strong>Hasil CBM:</strong> Total Volume + Kelebihan CBM</li>
                                                        <li><strong>Harga per KG:</strong> (Hasil CBM × Harga Per CBM) ÷ Total Berat</li>
                                                        <li><strong>Jika Berat > 600kg/CBM:</strong> Gunakan harga per KG langsung</li>
                                                        <li><strong>Asuransi:</strong> Nilai > 20jt/CBM akan dikenakan biaya tambahan 1% setiap kelipatan 10jt</li>
                                                        <li><strong>Total Final:</strong> Biaya Pengiriman + Biaya Asuransi - Discount</li>
                                                    </ul>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <hr>
                        <div class="row mt-4">
                            <div class="col-md-12 text-right">
                                <a href="{{ route('shipments.show', $shipment->id) }}" class="btn btn-secondary">{{ __('buttons.cancel') }}</a>
                                <button type="submit" class="btn btn-primary">Update Shipment</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Item Template (Hidden) -->
<template id="item-template">
    <div class="item-row border p-3 mb-3 rounded bg-light">
        <div class="row">
            <div class="col-md-11">
                <h6 class="text-primary">Item <span class="item-number"></span></h6>
            </div>
            <div class="col-md-1 text-right">
                <button type="button" class="btn btn-sm btn-danger remove-item-btn">
                    <i class="mdi mdi-delete"></i>
                </button>
            </div>
        </div>

        <div class="row">
            <div class="col-md-12">
                <div class="form-group">
                    <label>Description <span class="text-danger">*</span></label>
                    <input type="text" class="form-control" name="items[__index__][description]" required>
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-md-6">
                <div class="form-group">
                    <label>Product Name</label>
                    <input type="text" class="form-control" name="items[__index__][product_name]" placeholder="Enter product name">
                    <small class="form-text text-muted">Will be saved as a new product if specified</small>
                </div>
            </div>

            <div class="col-md-6">
                <div class="form-group">
                    <label>Category</label>
                    <select name="items[__index__][category_id]" class="form-control">
                        <option value="">-- Choose Category --</option>
                        @foreach($categories as $category)
                            <option value="{{ $category->id }}">{{ $category->name }}</option>
                        @endforeach
                    </select>
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-md-6">
                <div class="form-group">
                    <label>{{ __('invoice_page.barcode') }}</label>
                    <input type="text" class="form-control" name="items[__index__][barcode]" placeholder="Enter barcode">
                </div>
            </div>
            <div class="col-md-6">
                <div class="form-group">
                    <label>Cartons</label>
                    <input type="number" class="form-control" name="items[__index__][cartons]" min="0" placeholder="Number of cartons">
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-md-6">
                <div class="form-group">
                    <label>RMB Value</label>
                    <input type="number" step="0.01" class="form-control" name="items[__index__][rmb]" min="0" placeholder="RMB value for insurance calculation">
                    <small class="form-text text-muted">Used for insurance calculation</small>
                </div>
            </div>
            <div class="col-md-6">
                <div class="form-group">
                    <label>CBM (Optional)</label>
                    <input type="number" step="0.0001" class="form-control" name="items[__index__][cbm]" min="0" placeholder="Manual CBM value">
                    <small class="form-text text-muted">Leave empty to calculate from dimensions</small>
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-md-3">
                <div class="form-group">
                    <label>Length (cm) <span class="text-danger">*</span></label>
                    <input type="number" class="form-control dimension-input" name="items[__index__][length_m]" min="0" required>
                </div>
            </div>
            <div class="col-md-3">
                <div class="form-group">
                    <label>Width (cm) <span class="text-danger">*</span></label>
                    <input type="number" class="form-control dimension-input" name="items[__index__][width_m]" min="0" required>
                </div>
            </div>
            <div class="col-md-3">
                <div class="form-group">
                    <label>Height (cm) <span class="text-danger">*</span></label>
                    <input type="number" class="form-control dimension-input" name="items[__index__][height_m]" min="0" required>
                </div>
            </div>
            <div class="col-md-3">
                <div class="form-group">
                    <label>Volume (CBM)</label>
                    <input type="text" class="form-control volume-display" readonly>
                    <small class="form-text text-muted">Calculated: L×W×H÷1,000,000</small>
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-md-6">
                <div class="form-group">
                    <label>Weight (kg) <span class="text-danger">*</span></label>
                    <input type="number" class="form-control weight-input" name="items[__index__][weight_kg]" min="0" step="0.01" required>
                </div>
            </div>
            <div class="col-md-6">
                <div class="form-group">
                    <label>Quantity <span class="text-danger">*</span></label>
                    <input type="number" class="form-control quantity-input" name="items[__index__][quantity]" min="1" value="1" required>
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-md-6">
                <div class="form-group">
                    <label>Custom Price Per CBM</label>
                    <div class="input-group">
                        <input type="number" step="0.01" class="form-control item-price-cbm" name="items[__index__][price_per_cbm]" placeholder="Leave empty to use rate plan price">
                        <div class="input-group-append">
                            <button type="button" class="btn btn-outline-secondary clear-item-cbm-btn" title="Clear CBM Price">
                                <i class="mdi mdi-close"></i>
                            </button>
                        </div>
                    </div>
                    <small class="form-text text-muted">Override rate plan CBM price for this item only</small>
                </div>
            </div>

            <div class="col-md-6">
                <div class="form-group">
                    <label>Custom Price Per KG</label>
                    <div class="input-group">
                        <input type="number" step="0.01" class="form-control item-price-kg" name="items[__index__][price_per_kg]" placeholder="Leave empty to use rate plan price">
                        <div class="input-group-append">
                            <button type="button" class="btn btn-outline-secondary clear-item-kg-btn" title="Clear KG Price">
                                <i class="mdi mdi-close"></i>
                            </button>
                        </div>
                    </div>
                    <small class="form-text text-muted">Override rate plan KG price for this item only</small>
                </div>
            </div>
        </div>
    </div>
</template>
@endsection

@section('footer')
<script src="{{ asset('assets/libs/select2/js/select2.min.js') }}"></script>
<script>
    $(document).ready(function() {
        // Initialize Select2
        $('.select2').select2();

        // Item counter
        let itemCount = 0;

        // Add existing items first
        const shipmentItems = @json($shipment->items);

        if (shipmentItems.length > 0) {
            shipmentItems.forEach(function(item) {
                addItem(item);
            });
        } else {
            // Add a blank item if no existing items
            addItem();
        }

        // Add item button handler
        $('#add-item-btn').click(function() {
            addItem();
        });

        // Remove item button handler (delegated)
        $(document).on('click', '.remove-item-btn', function() {
            if ($('.item-row').length > 1) {
                $(this).closest('.item-row').remove();
                renumberItems();
                calculateTotalCost();
            } else {
                alert('At least one item is required.');
            }
        });

        // Calculate volume when dimensions change (delegated)
        $(document).on('input', '.dimension-input', function() {
            const row = $(this).closest('.item-row');
            calculateVolume(row);
            calculateTotalCost();
        });

        // Calculate total weight when weight changes (quantity TIDAK mempengaruhi perhitungan)
        $(document).on('input', '.weight-input', function() {
            calculateTotalCost();
        });

        // Update total weight display when quantity changes (HANYA untuk display, TIDAK untuk perhitungan)
        $(document).on('input', '.quantity-input', function() {
            // Quantity tidak mempengaruhi perhitungan
        });

        // Calculate total when weight, pricing, or RMB changes (QUANTITY TIDAK TERMASUK)
        $(document).on('input', '.weight-input, .item-price-cbm, .item-price-kg, input[name$="[rmb]"]', function() {
            calculateTotalCost();
        });

        // Recalculate when discount changes
        $('#discount_amount').on('input', function() {
            calculateTotalCost();
        });

        // Variable to store current exchange rate
        let currentRmbToIdrRate = 2200; // Default fallback rate

        // Function to get real-time RMB to IDR exchange rate
        async function getCurrentExchangeRate() {
            try {
                const response = await fetch('/api/exchange-rate/rmb-to-idr');
                if (response.ok) {
                    const data = await response.json();
                    if (data.success && data.rate) {
                        currentRmbToIdrRate = parseFloat(data.rate);
                        console.log('Updated exchange rate:', currentRmbToIdrRate);
                        return currentRmbToIdrRate;
                    }
                }
            } catch (error) {
                console.warn('Failed to fetch exchange rate, using fallback:', error);
            }
            return currentRmbToIdrRate;
        }

        // Get exchange rate on page load
        getCurrentExchangeRate();

        // Update exchange rate every 5 minutes
        setInterval(getCurrentExchangeRate, 300000); // 5 minutes

        // Recalculate when rate plan changes
        $('#rate_plan_id').change(function() {
            calculateTotalCost();
        }).trigger('change');

        // Clear button handlers for item pricing
        $(document).on('click', '.clear-item-cbm-btn', function() {
            $(this).closest('.input-group').find('.item-price-cbm').val('').trigger('input');
        });

        $(document).on('click', '.clear-item-kg-btn', function() {
            $(this).closest('.input-group').find('.item-price-kg').val('').trigger('input');
        });

        // Function to calculate total cost
        function calculateTotalCost() {
            let totalVolume = 0;
            let totalWeight = 0;
            let totalChargeableCost = 0;
            let totalInsuranceCost = 0;

            // Get rate plan prices
            const ratePlanOption = $('#rate_plan_id').find('option:selected');
            const ratePlanCbm = parseFloat(ratePlanOption.data('price-cbm')) || 0;
            const ratePlanKg = parseFloat(ratePlanOption.data('price-kg')) || 0;

            // Calculate totals from all items
            $('.item-row').each(function() {
                const length = parseFloat($(this).find('input[name$="[length_m]"]').val()) || 0;
                const width = parseFloat($(this).find('input[name$="[width_m]"]').val()) || 0;
                const height = parseFloat($(this).find('input[name$="[height_m]"]').val()) || 0;
                const weight = parseFloat($(this).find('input[name$="[weight_kg]"]').val()) || 0;
                const quantity = parseFloat($(this).find('input[name$="[quantity]"]').val()) || 1;

                // Get item-specific pricing or use rate plan defaults
                const itemCbmPrice = parseFloat($(this).find('.item-price-cbm').val()) || ratePlanCbm;
                const itemKgPrice = parseFloat($(this).find('.item-price-kg').val()) || ratePlanKg;

                // Calculate volume in cubic meters (CBM) - panjang × lebar × tinggi dalam CM, dibagi 1.000.000
                const itemVolume = (length * width * height) / 1000000; // CBM (jika input dalam CM)

                // PERBAIKAN: Volume dikalikan quantity untuk total volume
                totalVolume += itemVolume * quantity;

                // PERBAIKAN PENTING: Weight TIDAK PERNAH dikalikan quantity untuk perhitungan harga
                // Quantity hanya untuk data pendataan, bukan untuk calculation
                totalWeight += weight; // HANYA weight per unit, TIDAK dikalikan quantity

                // Apply new calculation logic per item - QUANTITY TIDAK MEMPENGARUHI PERHITUNGAN BIAYA
                const itemTotalVolume = itemVolume * quantity; // Volume boleh dikali quantity
                const itemTotalWeight = weight; // Weight TIDAK dikali quantity untuk perhitungan biaya

                // Check if weight exceeds 600kg per CBM
                const weightPerCbm = itemTotalVolume > 0 ? itemTotalWeight / itemTotalVolume : 0;

                let itemChargeableCost = 0;

                // Debug logging untuk memastikan quantity tidak mempengaruhi perhitungan
                console.log('Edit Form - Item Calculation Debug:', {
                    itemIndex: $(this).index(),
                    weight: weight + ' kg (per unit)',
                    quantity: quantity + ' (HANYA untuk data, TIDAK untuk calculation)',
                    itemVolume: itemVolume.toFixed(4) + ' CBM per unit',
                    itemTotalVolume: itemTotalVolume.toFixed(4) + ' CBM total',
                    itemTotalWeight: itemTotalWeight.toFixed(2) + ' kg (TIDAK dikali quantity)',
                    weightPerCbm: weightPerCbm.toFixed(2) + ' kg/CBM'
                });

                if (weightPerCbm > 600) {
                    // If weight > 600kg/cbm, use KG pricing
                    itemChargeableCost = itemTotalWeight * itemKgPrice;
                } else {
                    // RUMUS BENAR: Use CBM-based calculation with new formula
                    // 1. Berat Tercover = Volume × 600kg
                    const beratTercover = itemTotalVolume * 600;

                    // 2. Selisih Berat = Total Berat - Berat Tercover
                    const selisihBerat = Math.max(0, itemTotalWeight - beratTercover);

                    // 3. Kelebihan CBM = Selisih Berat ÷ 2000
                    const kelebihanCbm = selisihBerat / 2000;

                    // 4. Hasil CBM = Total Volume + Kelebihan CBM
                    const hasilCbm = itemTotalVolume + kelebihanCbm;

                    // 5. Calculate based on CBM
                    itemChargeableCost = hasilCbm * itemCbmPrice;
                }

                totalChargeableCost += itemChargeableCost;

                // PERBAIKAN: Calculate insurance cost dengan konversi RMB ke IDR yang benar
                const rmbValue = parseFloat($(this).find('input[name$="[rmb]"]').val()) || 0;

                if (rmbValue > 0 && itemTotalVolume > 0) {
                    // PERBAIKAN: Gunakan exchange rate yang real-time
                    const valueInIdr = rmbValue * currentRmbToIdrRate;

                    // Calculate value per CBM dalam IDR
                    const valuePerCbmIdr = valueInIdr / itemTotalVolume;

                    // Standard coverage limit: 20,000,000 IDR per CBM
                    const standardCoverageLimit = 20000000; // 20 juta IDR per CBM

                    console.log('Edit Form - Insurance Calculation Debug:', {
                        rmbValue: rmbValue,
                        exchangeRate: currentRmbToIdrRate,
                        valueInIdr: valueInIdr,
                        itemTotalVolume: itemTotalVolume,
                        valuePerCbmIdr: valuePerCbmIdr,
                        standardCoverageLimit: standardCoverageLimit,
                        exceedsLimit: valuePerCbmIdr > standardCoverageLimit
                    });

                    if (valuePerCbmIdr > standardCoverageLimit) {
                        // Calculate excess value per CBM dalam IDR
                        const excessValuePerCbm = valuePerCbmIdr - standardCoverageLimit;

                        // Calculate insurance rate based on excess value
                        // For every 10 million IDR excess, add 1% insurance
                        const excessMultiplier = Math.ceil(excessValuePerCbm / 10000000); // Kelipatan 10 jt IDR
                        const insuranceRate = excessMultiplier * 0.01; // 1% per kelipatan 10 jt

                        // Calculate insurance cost per CBM
                        const insuranceCostPerCbm = insuranceRate * excessValuePerCbm;

                        // Total insurance cost for this item
                        const itemInsuranceCost = insuranceCostPerCbm * itemTotalVolume;
                        totalInsuranceCost += itemInsuranceCost;

                        console.log('Edit Form - Insurance Cost Calculated:', {
                            excessValuePerCbm: excessValuePerCbm,
                            excessMultiplier: excessMultiplier,
                            insuranceRate: (insuranceRate * 100) + '%',
                            insuranceCostPerCbm: insuranceCostPerCbm,
                            itemInsuranceCost: itemInsuranceCost
                        });
                    }
                }
            });

            // Calculate overall metrics for display menggunakan rumus yang BENAR
            // RUMUS BENAR:
            // 1. Berat Tercover = Total Volume × 600kg
            const totalBeratTercover = totalVolume * 600;

            // 2. Selisih Berat = Total Berat Barang - Berat Tercover
            const totalSelisihBerat = Math.max(0, totalWeight - totalBeratTercover);

            // 3. Kelebihan CBM = Selisih Berat ÷ 2000
            const totalKelebihanCbm = totalSelisihBerat / 2000;

            // 4. Hasil CBM = Total Volume + Kelebihan CBM
            const totalHasilCbm = totalVolume + totalKelebihanCbm;

            // 5. Total Tagihan = Hasil CBM × Harga Per CBM
            const totalTagihan = totalHasilCbm * ratePlanCbm;

            // 6. Harga Per KG = Total Tagihan ÷ Berat Barang
            const calculatedPricePerKg = totalWeight > 0 ? totalTagihan / totalWeight : 0;

            // Override total chargeable cost dengan calculation yang benar
            totalChargeableCost = totalTagihan;

            console.log('EDIT FORM - RUMUS PERHITUNGAN YANG BENAR:', {
                step1_BeratTercover: totalBeratTercover.toFixed(2) + ' kg (Total Volume × 600kg)',
                step2_SelisihBerat: totalSelisihBerat.toFixed(2) + ' kg (Total Berat - Berat Tercover)',
                step3_KelebihanCBM: totalKelebihanCbm.toFixed(4) + ' CBM (Selisih Berat ÷ 2000)',
                step4_HasilCBM: totalHasilCbm.toFixed(4) + ' CBM (Total Volume + Kelebihan CBM)',
                step5_TotalTagihan: totalTagihan.toFixed(2) + ' (Hasil CBM × Harga Per CBM)',
                step6_HargaPerKG: calculatedPricePerKg.toFixed(2) + ' (Total Tagihan ÷ Berat Barang)',
                totalVolume: totalVolume.toFixed(4) + ' CBM',
                totalWeight: totalWeight.toFixed(2) + ' kg (TIDAK dikali quantity)',
                ratePlanCbm: ratePlanCbm
            });

            // Get discount
            const discountAmount = parseFloat($('#discount_amount').val()) || 0;
            const subTotal = totalChargeableCost + totalInsuranceCost;
            const finalTotal = Math.max(0, subTotal - discountAmount);

            // Update display fields dengan hasil perhitungan yang BENAR
            $('#total-volume').val(totalVolume.toFixed(4));
            $('#total-weight').val(totalWeight.toFixed(2)); // TIDAK dikali quantity
            $('#volume-weight').val(totalBeratTercover.toFixed(2)); // Berat Tercover (600kg/CBM)
            $('#chargeable-weight').val(totalHasilCbm.toFixed(4)); // Hasil CBM (sesuai rumus)
            $('#cost-per-cbm').val('Rp ' + formatNumber(ratePlanCbm));
            $('#cost-per-kg').val('Rp ' + formatNumber(calculatedPricePerKg)); // Harga per KG sesuai rumus
            $('#volume-cost').val('Rp ' + formatNumber(totalHasilCbm * ratePlanCbm)); // CBM Cost
            $('#weight-cost').val('Rp ' + formatNumber(totalWeight * calculatedPricePerKg)); // Weight Cost
            $('#chargeable-cost').val('Rp ' + formatNumber(totalChargeableCost)); // Total tagihan sesuai rumus
            $('#insurance-cost').val('Rp ' + formatNumber(totalInsuranceCost)); // Insurance cost
            $('#discount-display').val('Rp ' + formatNumber(discountAmount));
            $('#total_charge').val(finalTotal.toFixed(2)); // Grand total dengan insurance

            // Update additional info displays (untuk debugging dan transparansi)
            console.log('=== EDIT FORM - PERHITUNGAN AKHIR (QUANTITY TIDAK MEMPENGARUHI HARGA) ===', {
                rumus: 'Berat Tercover = Volume × 600kg → Selisih = Berat - Tercover → Kelebihan CBM = Selisih ÷ 2000 → Hasil CBM = Volume + Kelebihan → Tagihan = Hasil CBM × Harga CBM → Harga/KG = Tagihan ÷ Berat',
                totalVolume: totalVolume.toFixed(4) + ' CBM',
                totalWeight: totalWeight.toFixed(2) + ' KG (TIDAK dikali quantity)',
                beratTercover: totalBeratTercover.toFixed(2) + ' KG (Volume × 600kg)',
                selisihBerat: totalSelisihBerat.toFixed(2) + ' KG',
                kelebihanCbm: totalKelebihanCbm.toFixed(4) + ' CBM',
                hasilCbm: totalHasilCbm.toFixed(4) + ' CBM',
                hargaCbm: 'Rp ' + formatNumber(ratePlanCbm),
                totalTagihan: 'Rp ' + formatNumber(totalChargeableCost),
                hargaPerKg: 'Rp ' + formatNumber(calculatedPricePerKg) + '/KG',
                totalInsuranceCost: 'Rp ' + formatNumber(totalInsuranceCost),
                subTotal: 'Rp ' + formatNumber(subTotal),
                finalTotal: 'Rp ' + formatNumber(finalTotal)
            });
        }

        // Function to add new item
        function addItem(existingItem = null) {
            const template = $('#item-template').html();
            const newItem = template.replace(/__index__/g, itemCount);
            $('#items-container').append(newItem);

            const $lastRow = $('.item-row').last();

            // Update item number
            $lastRow.find('.item-number').text(itemCount + 1);

            // If we have an existing item, fill in the values
            if (existingItem) {
                // Fill in the form fields manually
                $lastRow.find('input[name$="[description]"]').val(existingItem.description);
                $lastRow.find('input[name$="[product_name]"]').val(existingItem.product_name || '');
                $lastRow.find('select[name$="[category_id]"]').val(existingItem.category_id || '');
                $lastRow.find('input[name$="[barcode]"]').val(existingItem.barcode || '');
                $lastRow.find('input[name$="[cartons]"]').val(existingItem.cartons || '');
                $lastRow.find('input[name$="[rmb]"]').val(existingItem.rmb || '');
                $lastRow.find('input[name$="[cbm]"]').val(existingItem.cbm || '');
                $lastRow.find('input[name$="[length_m]"]').val(existingItem.length_m);
                $lastRow.find('input[name$="[width_m]"]').val(existingItem.width_m);
                $lastRow.find('input[name$="[height_m]"]').val(existingItem.height_m);
                $lastRow.find('input[name$="[weight_kg]"]').val(existingItem.weight_kg);
                $lastRow.find('input[name$="[quantity]"]').val(existingItem.quantity);
                $lastRow.find('input[name$="[price_per_cbm]"]').val(existingItem.price_per_cbm || '');
                $lastRow.find('input[name$="[price_per_kg]"]').val(existingItem.price_per_kg || '');

                // Calculate and display volume
                calculateVolume($lastRow);

                // Add item id for existing items
                $lastRow.append('<input type="hidden" name="items[' + itemCount + '][id]" value="' + existingItem.id + '">');

                // Add product_id hidden field if it exists
                if (existingItem.product_id) {
                    $lastRow.append('<input type="hidden" name="items[' + itemCount + '][product_id]" value="' + existingItem.product_id + '">');
                }
            }

            itemCount++;
            calculateTotalCost();
        }

        // Function to renumber items
        function renumberItems() {
            $('.item-row').each(function(index) {
                $(this).find('.item-number').text(index + 1);

                // Update input names with correct index
                $(this).find('input, select').each(function() {
                    const name = $(this).attr('name');
                    if (name) {
                        $(this).attr('name', name.replace(/items\[\d+\]/g, `items[${index}]`));
                    }
                });
            });
            calculateTotalCost();
        }

        // Function to calculate volume
        function calculateVolume(row) {
            const length = parseFloat(row.find('input[name$="[length_m]"]').val()) || 0;
            const width = parseFloat(row.find('input[name$="[width_m]"]').val()) || 0;
            const height = parseFloat(row.find('input[name$="[height_m]"]').val()) || 0;

            // Calculate volume in cubic meters (CBM) - jika input dalam CM, dibagi 1.000.000
            const volume = (length * width * height) / 1000000; // Asumsikan input dalam CM

            if (volume > 0) {
                row.find('.volume-display').val(volume.toFixed(4));
            } else {
                row.find('.volume-display').val('');
            }
        }

        // Helper function to format numbers
        function formatNumber(num) {
            return new Intl.NumberFormat('id-ID', {
                minimumFractionDigits: 0,
                maximumFractionDigits: 2
            }).format(num);
        }
    });
</script>
@endsection