@php
    $tax_status = session()->get('tax_status', 'active');
    $hide_tax = session()->get('business.enable_inline_tax') == 1 ? '' : 'hide';
    
    // If tax is disabled, override hide_tax to always hide tax-related fields
    if($tax_status == 'disabled') {
        $hide_tax = 'hide';
        $tax_id = null;
        $item_tax = 0;
        $unit_price_inc_tax = $product->default_sell_price; // Use price without tax
    } else {
        $tax_id = $product->tax_id;
        $item_tax = !empty($product->item_tax) ? $product->item_tax : 0;
        $unit_price_inc_tax = $product->sell_price_inc_tax;
    }
@endphp

@php
	$common_settings = session()->get('business.common_settings');
	$multiplier = 1;

	$action = !empty($action) ? $action : '';
@endphp

@foreach($sub_units as $key => $value)
	@if(!empty($product->sub_unit_id) && $product->sub_unit_id == $key)
		@php
			$multiplier = $value['multiplier'];
		@endphp
	@endif
@endforeach

@php
    $tax_amount = 0;

    if(session()->get('business.enable_inline_tax') == 1) {
        // Calculate the tax amount as the difference between price including tax and default price
        $tax_amount = ($product->sell_price_inc_tax - $product->default_sell_price) * $product->quantity_ordered;
        
    }
@endphp

@php
    $total_tax_amount = 0;
    
    // Force reload the product with discounts to get the correct data
    $product_with_discounts = \App\Product::with(['discounts'])->find($product->product_id);
    
    // Get discount_allowed as boolean
    $discount_allowed = false;
    if($product_with_discounts) {
        if(isset($product_with_discounts->discount_allowed)) {
            if(is_bool($product_with_discounts->discount_allowed)) {
                $discount_allowed = $product_with_discounts->discount_allowed;
            } else {
                $discount_allowed = (int)$product_with_discounts->discount_allowed === 1 || $product_with_discounts->discount_allowed === '1';
            }
        }
    }
    
    // If there's a discount applied, discount is allowed
    if(!empty($discount)) {
        $discount_allowed = true;
    }
    
    // Get discounts
    $product_discounts = collect();
    $discounts_data = [];
    $discounts_json = '[]';
    
    if($discount_allowed && $product_with_discounts) {
        $product_discounts = $product_with_discounts->discounts ?? collect();
        $discounts_data = $product_discounts->toArray();
        
        // 🔥 FIX: Multiply discount quantities by the multiplier
        $adjusted_discounts = [];
        foreach($discounts_data as $discount) {
            $adjusted_discount = $discount;
            // Convert from_quantity to base unit by multiplying by multiplier
            if(isset($discount['from_quantity'])) {
                $adjusted_discount['from_quantity'] = $discount['from_quantity'] * $multiplier;
            }
            if(isset($discount['to_quantity']) && !is_null($discount['to_quantity'])) {
                $adjusted_discount['to_quantity'] = $discount['to_quantity'] * $multiplier;
            }
            // 🔥 FIX: Also multiply discount amount for fixed discounts
            if(isset($discount['discount_type']) && $discount['discount_type'] == 'fixed' && isset($discount['discount_amount'])) {
                $adjusted_discount['discount_amount'] = $discount['discount_amount'] * $multiplier;
            }
            $adjusted_discounts[] = $adjusted_discount;
        }
        $discounts_data = $adjusted_discounts;
        $discounts_json = json_encode($adjusted_discounts);
        
        // If no discounts in relationship, try direct query
        if($product_discounts->count() == 0) {
            try {
                $product_discounts = \App\ProductDiscount::where('product_id', $product->product_id)
                    ->orderBy('from_quantity', 'asc')
                    ->get();
                $discounts_data = $product_discounts->toArray();
                
                // 🔥 FIX: Multiply discount quantities and amounts by the multiplier
                $adjusted_discounts = [];
                foreach($discounts_data as $discount) {
                    $adjusted_discount = $discount;
                    if(isset($discount['from_quantity'])) {
                        $adjusted_discount['from_quantity'] = $discount['from_quantity'] * $multiplier;
                    }
                    if(isset($discount['to_quantity']) && !is_null($discount['to_quantity'])) {
                        $adjusted_discount['to_quantity'] = $discount['to_quantity'] * $multiplier;
                    }
                    if(isset($discount['discount_type']) && $discount['discount_type'] == 'fixed' && isset($discount['discount_amount'])) {
                        $adjusted_discount['discount_amount'] = $discount['discount_amount'] * $multiplier;
                    }
                    $adjusted_discounts[] = $adjusted_discount;
                }
                $discounts_data = $adjusted_discounts;
                $discounts_json = json_encode($adjusted_discounts);
            } catch(\Exception $e) {
                Log::error('Failed to fetch discounts: ' . $e->getMessage());
            }
        }
    }
    
    // Get global discount info
    $global_discount_type = !empty($discount) ? $discount->discount_type : 'fixed';
    $global_discount_amount = !empty($discount) ? $discount->discount_amount : 0;
    $has_global_discount = !empty($discount);
    
    $base_price = $product->sell_price_inc_tax;
    
    // 🔥 FIX: Fetch unit prices directly from the units table using the unit ID
    $unit_prices = [];
    $unit_prices_data = [];
    
    foreach($sub_units as $key => $value) {
        // Try to get unit price from the value array first
        $unit_price = isset($value['unit_price']) && !empty($value['unit_price']) 
            ? (float)$value['unit_price'] 
            : null;
        
        // If no unit price in the array, try to fetch from database using the unit ID
        if(is_null($unit_price) || $unit_price == 0) {
            try {
                $unit = \App\Unit::find($key);
                if($unit && !empty($unit->unit_price)) {
                    $unit_price = (float)$unit->unit_price;
                }
            } catch(\Exception $e) {
                Log::error('Failed to fetch unit price for unit ID ' . $key . ': ' . $e->getMessage());
            }
        }
        
        $unit_prices[$key] = $unit_price;
        $unit_prices_data[$key] = [
            'unit_id' => $key,
            'unit_name' => $value['name'] ?? 'Unknown',
            'unit_price' => $unit_price,
            'multiplier' => $value['multiplier'] ?? 1,
            'has_price' => !is_null($unit_price) && $unit_price > 0
        ];
    }
    
    // 🔥 Check if a price group is active (only if it's a valid ID, not '0' or empty)
    $has_price_group = false;
    $price_group_id = null;
    if(!empty($price_group) && $price_group != '0' && $price_group != 0) {
        $has_price_group = true;
        $price_group_id = $price_group;
    }
    // Also check if there's a hidden price group from the form
    if(!$has_price_group && !empty(request()->input('price_group')) && request()->input('price_group') != '0') {
        $has_price_group = true;
        $price_group_id = request()->input('price_group');
    }
    // Check session for price group
    if(!$has_price_group && session()->has('price_group_id') && session()->get('price_group_id') != '0') {
        $has_price_group = true;
        $price_group_id = session()->get('price_group_id');
    }
    
    // Log for debugging
    Log::info('Product Row Debug - RELOADED', [
        'product_id' => $product->product_id,
        'product_name' => $product->product_name,
        'discount_allowed' => $discount_allowed,
        'has_global_discount' => $has_global_discount,
        'global_discount_type' => $global_discount_type,
        'global_discount_amount' => $global_discount_amount,
        'discounts_count' => count($product_discounts),
        'discounts' => $discounts_data,
        'base_price' => $base_price,
        'discounts_json' => $discounts_json,
        'multiplier' => $multiplier,
        'unit_prices' => $unit_prices_data,
        'has_price_group' => $has_price_group,
        'price_group_id' => $price_group_id,
    ]);
@endphp

<tr class="product_row pos_tablei" 
    data-row_index="{{$row_count}}" 
    data-sell-price-inc-tax="{{ $product->sell_price_inc_tax }}" 
    data-default-sell-price="{{ $product->default_sell_price }}" 
    @if(!empty($so_line)) data-so_id="{{$so_line->transaction_id}}" @endif
    data-discount-allowed="{{ $discount_allowed ? 'true' : 'false' }}"
    data-product-id="{{ $product->product_id }}"
    data-base-price="{{ $base_price }}"
    data-product-name="{{ $product->product_name }}"
    data-discount-ranges='{{ $discounts_json }}'
    data-current-multiplier="{{ $multiplier }}"
    data-serial-number="{{ $product->matched_serial_number ?? '' }}"
    data-serial-number-id="{{ $product->serial_number_id ?? '' }}"
    data-serial-number-total-qty="{{ $product->serial_number_total_qty ?? 0 }}"
    data-serial-number-available="{{ $product->serial_number_available ?? 0 }}"
    data-has-serial-number="{{ !empty($product->matched_serial_number) ? 'true' : 'false' }}"
    data-has-global-discount="{{ $has_global_discount ? 'true' : 'false' }}"
    data-global-discount-type="{{ $global_discount_type }}"
    data-global-discount-amount="{{ $global_discount_amount }}"
    data-unit-prices='{{ json_encode($unit_prices) }}'
    data-has-price-group="{{ $has_price_group ? 'true' : 'false' }}"
    data-price-group-id="{{ $price_group_id }}">

	<td class="thwidthp">
    @if(!empty($so_line))
        <input type="hidden" 
        name="products[{{$row_count}}][so_line_id]" 
        value="{{$so_line->id}}">
    @endif

    @php
        $product_name = $product->product_name;
        if(!empty($product->brand)){ $product_name .= ' ' . $product->brand; }
    @endphp

    @php
        $hide_tax = session()->get('business.enable_inline_tax') == 1 ? '' : 'hide';
        $tax_id = $product->tax_id;
        $item_tax = !empty($product->item_tax) ? $product->item_tax : 0;
        $unit_price_inc_tax = $product->sell_price_inc_tax;

        if($hide_tax == 'hide'){
            $tax_id = null;
            $unit_price_inc_tax = $product->default_sell_price;
        }

        if(!empty($so_line) && $action !== 'edit') {
            $tax_id = $so_line->tax_id;
            $item_tax = $so_line->item_tax;
            $unit_price_inc_tax = $so_line->unit_price_inc_tax;
        }

        $discount_type = !empty($product->line_discount_type) ? $product->line_discount_type : 'fixed';
        $discount_amount = !empty($product->line_discount_amount) ? $product->line_discount_amount : 0;

        if(!empty($discount)) {
            $discount_type = $discount->discount_type;
            $discount_amount = $discount->discount_amount;
        }

        if(!empty($so_line) && $action !== 'edit') {
            $discount_type = $so_line->line_discount_type;
            $discount_amount = $so_line->line_discount_amount;
        }

        $sell_line_note = !empty($product->sell_line_note) ? $product->sell_line_note : '';
        if(!empty($so_line)){
            $sell_line_note = $so_line->sell_line_note;
        }

        $warranty_id = !empty($action) && $action == 'edit' && !empty($product->warranties->first()) ? $product->warranties->first()->id : $product->warranty_id;

        if($discount_type == 'fixed') {
            $discount_amount = $discount_amount * $multiplier;
        }

        $max_quantity = $product->qty_available;
        $formatted_max_quantity = $product->formatted_qty_available;

        if(!empty($action) && $action == 'edit' && !empty($so_line)) {
            $qty_available = $so_line->quantity - $so_line->so_quantity_invoiced + $product->quantity_ordered;
            $max_quantity = $qty_available;
            $formatted_max_quantity = number_format($qty_available, session('business.quantity_precision', 2), session('currency')['decimal_separator'], session('currency')['thousand_separator']);
        } elseif(!empty($so_line) && $so_line->qty_available <= $max_quantity) {
            $max_quantity = $so_line->qty_available;
            $formatted_max_quantity = $so_line->formatted_qty_available;
        }

        $max_qty_rule = $max_quantity;
        $max_qty_msg = __('validation.custom-messages.quantity_not_available', ['qty'=> $formatted_max_quantity, 'unit' => $product->unit]);

        $lot_enabled = session()->get('business.enable_lot_number');
        $exp_enabled = session()->get('business.enable_product_expiry');
        $lot_no_line_id = !empty($product->lot_no_line_id) ? $product->lot_no_line_id : '';
    @endphp

    <input type="hidden" class="enable_sr_no" value="{{$product->enable_sr_no}}">
    <input type="hidden" 
        class="product_type" 
        name="products[{{$row_count}}][product_type]" 
        value="{{$product->product_type}}">

    @if(!empty($discount))
        {!! Form::hidden("products[$row_count][discount_id]", $discount->id); !!}
    @endif

    @if( ($edit_price || $edit_discount) && empty($is_direct_sell) )
        <div title="@lang('lang_v1.pos_edit_product_price_help')" style="display: inline">
            <span class="text-link text-info cursor-pointer" style="color: black;" data-toggle="modal" data-target="#row_edit_product_price_modal_{{$row_count}}">
                <span style="color: black; font-weight:bold;">{!! $product_name !!}</span>
            </span>
        </div>
    @else
        <span style="color: black; font-weight:bold;">{!! $product_name !!}</span>
    @endif

<br>
{{-- Lot Number & Expiry Inline --}}
@if(!empty($product->lot_numbers) && empty($is_sales_order))
    <select class="form-control lot_number input-sm pos_tablei fldwdthi" name="products[{{$row_count}}][lot_no_line_id]" style="width: auto;" @if(!empty($product->transaction_sell_lines_id)) disabled @endif>
        <option value="">@lang('lang_v1.lot_n_expiry')</option>
        @foreach($product->lot_numbers as $lot_number)
            @php
                $selected = ($lot_number->purchase_line_id == $lot_no_line_id || (!empty($purchase_line_id) && $purchase_line_id == $lot_number->purchase_line_id)) ? "selected" : "";
                $expiry_text = '';
                if($exp_enabled == 1 && !empty($lot_number->exp_date)){
                    if(\Carbon::now()->gt(\Carbon::createFromFormat('Y-m-d', $lot_number->exp_date))){
                        $expiry_text = '(' . __('report.expired') . ')';
                    }
                }

                if($selected){
                    $max_qty_rule = $lot_number->qty_available;
                    $max_qty_msg = __('lang_v1.quantity_error_msg_in_lot', ['qty'=> $lot_number->qty_formated, 'unit' => $product->unit]);
                }
            @endphp
            <option value="{{$lot_number->purchase_line_id}}" {{$selected}}>
                @if(!empty($lot_number->lot_number) && $lot_enabled == 1){{$lot_number->lot_number}} @endif
                @if($lot_enabled == 1 && $exp_enabled == 1) - @endif
                @if($exp_enabled == 1 && !empty($lot_number->exp_date)) @lang('product.exp_date'): {{@format_date($lot_number->exp_date)}} @endif
                {{$expiry_text}}
            </option>
        @endforeach
    </select>
@endif

{{-- Serial Number Display with Quantity Info --}}
@if(!empty($product->matched_serial_number))
    <span class="serial-number-display label label-info" style="display: inline-block; margin-left: 10px; padding: 4px 8px; font-size: 12px; background-color: #17a2b8; color: white; border-radius: 3px; cursor: default;">
        <i class="fa fa-barcode"></i> 
        <strong>SN:</strong> {{ $product->matched_serial_number }}
        @if(!empty($product->serial_number_id))
            <input type="hidden" name="products[{{$row_count}}][serial_number_id]" value="{{ $product->serial_number_id }}">
        @endif
        
    </span>
@endif

    {{-- Product Price Modal --}}
    @if(empty($is_direct_sell))
        <div class="modal fade row_edit_product_price_model" id="row_edit_product_price_modal_{{$row_count}}" tabindex="-1" role="dialog">
            @include('sale_pos.partials.row_edit_product_price_modal')
        </div> 
    @endif

    {{-- Modifiers --}}
    @if(in_array('modifiers', $enabled_modules))
        <div class="modifiers_html">
            @if(!empty($product->product_ms))
                @include('restaurant.product_modifier_set.modifier_for_product', ['edit_modifiers' => true, 'row_count' => $loop->index, 'product_ms' => $product->product_ms])
            @endif
        </div>
    @endif

    {{-- Direct sell note --}}
    @if(!empty($is_direct_sell))
        <br>
        <textarea class="form-control" name="products[{{$row_count}}][sell_line_note]" rows="2">{{$sell_line_note}}</textarea>
        <p class="help-block"><small>@lang('lang_v1.sell_line_description_help')</small></p>
    @endif
</td>

<td>
    {{-- If edit then transaction sell lines will be present --}}
    @if(!empty($product->transaction_sell_lines_id))
        <input type="hidden" name="products[{{$row_count}}][transaction_sell_lines_id]" class="form-control" value="{{$product->transaction_sell_lines_id}}">
    @endif

    <input type="hidden" name="products[{{$row_count}}][product_id]" class="form-control product_id" value="{{$product->product_id}}">

    <input type="hidden" value="{{$product->variation_id}}" 
        name="products[{{$row_count}}][variation_id]" class="row_variation_id">

    <input type="hidden" value="{{$product->enable_stock}}" 
        name="products[{{$row_count}}][enable_stock]">
    
    @if(empty($product->quantity_ordered))
        @php
            $product->quantity_ordered = 1;
        @endphp
    @endif

    @php
        $allow_decimal = true;
        if($product->unit_allow_decimal != 1) {
            $allow_decimal = false;
        }
    @endphp
    @foreach($sub_units as $key => $value)
        @if(!empty($product->sub_unit_id) && $product->sub_unit_id == $key)
            @php
                $max_qty_rule = $max_qty_rule / $multiplier;
                $unit_name = $value['name'];
                $max_qty_msg = __('validation.custom-messages.quantity_not_available', ['qty'=> $max_qty_rule, 'unit' => $unit_name]);

                if(!empty($product->lot_no_line_id)){
                    $max_qty_msg = __('lang_v1.quantity_error_msg_in_lot', ['qty'=> $max_qty_rule, 'unit' => $unit_name]);
                }

                if($value['allow_decimal']) {
                    $allow_decimal = true;
                }
            @endphp
        @endif
    @endforeach

<div class="input-group input-number">
    <span class="input-group-btn">
        <button type="button" class="btn btn-default btn-flat quantity-down">
            <i class="fa fa-minus text-danger"></i>
        </button>
    </span>
    <input type="number" data-min="1" 
            class="form-control pos_quantity input_number mousetrap input_quantity quantity-input fldwidth" 
        value="{{@format_quantity($product->quantity_ordered)}}" 
        name="products[{{$row_count}}][quantity]" 
        data-allow-overselling="@if(empty($pos_settings['allow_overselling'])){{'false'}}@else{{'true'}}@endif" 
        @if($allow_decimal) 
            data-decimal=1 
        @else 
            data-decimal=0 
            data-rule-abs_digit="true" 
            data-msg-abs_digit="@lang('lang_v1.decimal_value_not_allowed')" 
        @endif
        data-rule-required="true" 
        data-msg-required="@lang('validation.custom-messages.this_field_is_required')" 
        
        {{-- Serial number validation --}}
        @if(!empty($product->matched_serial_number) && !empty($product->serial_number_available))
            data-serial-number="true"
            data-serial-max-qty="{{ $product->serial_number_available }}"
            data-rule-max-value="{{ $product->serial_number_available }}"
            data-msg-max-value="@lang('Quantity Exceeded', ['qty' => $product->serial_number_available])"
            data-msg_max_default="@lang('Quantity Exceeded', ['qty' => $product->serial_number_available])"
            style="border-color: #17a2b8;"
        @elseif($product->enable_stock && empty($pos_settings['allow_overselling']) && empty($is_sales_order))
            data-rule-max-value="{{$max_qty_rule}}" 
            data-qty_available="{{$product->qty_available}}" 
            data-msg-max-value="{{$max_qty_msg}}" 
            data-msg_max_default="@lang('validation.custom-messages.quantity_not_available', ['qty'=> $product->formatted_qty_available, 'unit' => $product->unit])" 
        @endif 
    >
    <span class="input-group-btn">
        <button type="button" class="btn btn-default btn-flat quantity-up">
            <i class="fa fa-plus text-success"></i>
        </button>
    </span>
</div>


    <!-- Sub Unit Selection - Displayed BELOW the quantity input -->
    <div class="mblshow fldwdth pos_tablei" style="margin-top: 5px;">
        @if(count($sub_units) > 0)
        <select name="products[{{$row_count}}][sub_unit_id]" class="form-control input-sm sub_unit">
            @foreach($sub_units as $key => $value)
                @php
                    // 🔥 FIX: Get the unit price from the database using the unit ID
                    $unit_price = null;
                    
                    // First check if it's in the value array
                    if(isset($value['unit_price']) && !empty($value['unit_price'])) {
                        $unit_price = (float)$value['unit_price'];
                    } else {
                        // If not, try to fetch from database
                        try {
                            $unit = \App\Unit::find($key);
                            if($unit && !empty($unit->unit_price)) {
                                $unit_price = (float)$unit->unit_price;
                            }
                        } catch(\Exception $e) {
                            // Silently fail
                        }
                    }
                    
                    // Check if this is the default unit
                    $is_default = !empty($product->sub_unit_id) && $product->sub_unit_id == $key;
                    
                    // Calculate the calculated price for display
                    $calculated_price = $product->sell_price_inc_tax * $value['multiplier'];
                @endphp
                <option value="{{$key}}" 
                    data-multiplier="{{$value['multiplier']}}" 
                    data-unit_name="{{$value['name']}}" 
                    data-allow_decimal="{{$value['allow_decimal']}}"
                    data-unit-price="{{ $unit_price ?? '' }}"
                    @if($is_default) selected @endif>
                    {{$value['name']}} 
                    @if($unit_price) 
                        
                    @else
                        
                    @endif
                </option>
            @endforeach
        </select>
    @else
        {{$product->unit}}
    @endif
    </div>

</td>

<td class="mblhide" style="width:500px !important;">
    @if(count($sub_units) > 0)
        <select name="products[{{$row_count}}][sub_unit_id]" class="form-control input-sm sub_unit">
            @foreach($sub_units as $key => $value)
                @php
                    // 🔥 FIX: Get the unit price from the database using the unit ID
                    $unit_price = null;
                    
                    // First check if it's in the value array
                    if(isset($value['unit_price']) && !empty($value['unit_price'])) {
                        $unit_price = (float)$value['unit_price'];
                    } else {
                        // If not, try to fetch from database
                        try {
                            $unit = \App\Unit::find($key);
                            if($unit && !empty($unit->unit_price)) {
                                $unit_price = (float)$unit->unit_price;
                            }
                        } catch(\Exception $e) {
                            // Silently fail
                        }
                    }
                    
                    // Check if this is the default unit
                    $is_default = !empty($product->sub_unit_id) && $product->sub_unit_id == $key;
                    
                    // Calculate the calculated price for display
                    $calculated_price = $product->sell_price_inc_tax * $value['multiplier'];
                @endphp
                <option value="{{$key}}" 
                    data-multiplier="{{$value['multiplier']}}" 
                    data-unit_name="{{$value['name']}}" 
                    data-allow_decimal="{{$value['allow_decimal']}}"
                    data-unit-price="{{ $unit_price ?? '' }}"
                    @if($is_default) selected @endif>
                    {{$value['name']}} 
                    @if($unit_price) 
                        
                    @else
                        
                    @endif
                </option>
            @endforeach
        </select>
    @else
        {{$product->unit}}
    @endif
</td>

@if(!empty($product->second_unit))
    <br>
    <span style="white-space: nowrap;">
    @lang('lang_v1.quantity_in_second_unit', ['unit' => $product->second_unit])*:</span><br>
    <input type="text" 
    name="products[{{$row_count}}][secondary_unit_quantity]" 
    value="{{@format_quantity($product->secondary_unit_quantity)}}"
    class="form-control input-sm input_number"
    required>
@endif

<input type="hidden" class="base_unit_multiplier" name="products[{{$row_count}}][base_unit_multiplier]" value="{{$multiplier}}">

<input type="hidden" class="hidden_base_unit_sell_price" value="{{$product->default_sell_price / $multiplier}}">

{{-- Hidden fields for combo products --}}
@if($product->product_type == 'combo' && !empty($product->combo_products))
    @foreach($product->combo_products as $k => $combo_product)
        @if(isset($action) && $action == 'edit')
            @php
                $combo_product['qty_required'] = $combo_product['quantity'] / $product->quantity_ordered;
                $qty_total = $combo_product['quantity'];
            @endphp
        @else
            @php
                $qty_total = $combo_product['qty_required'];
            @endphp
        @endif

        <input type="hidden" 
            name="products[{{$row_count}}][combo][{{$k}}][product_id]"
            value="{{$combo_product['product_id']}}">

        <input type="hidden" 
            name="products[{{$row_count}}][combo][{{$k}}][variation_id]"
            value="{{$combo_product['variation_id']}}">

        <input type="hidden"
            class="combo_product_qty" 
            name="products[{{$row_count}}][combo][{{$k}}][quantity]"
            data-unit_quantity="{{$combo_product['qty_required']}}"
            value="{{$qty_total}}">

        @if(isset($action) && $action == 'edit')
            <input type="hidden" 
                name="products[{{$row_count}}][combo][{{$k}}][transaction_sell_lines_id]"
                value="{{$combo_product['id']}}">
        @endif
    @endforeach
@endif
	@if(!empty($is_direct_sell))
		@if(!empty($pos_settings['inline_service_staff']))
			<td>
				<div class="form-group">
					<div class="input-group">
						{!! Form::select("products[" . $row_count . "][res_service_staff_id]", $waiters, !empty($product->res_service_staff_id) ? $product->res_service_staff_id : null, ['class' => 'form-control select2 order_line_service_staff', 'placeholder' => __('restaurant.select_service_staff'), 'required' => (!empty($pos_settings['is_service_staff_required']) && $pos_settings['is_service_staff_required'] == 1) ? true : false ]); !!}
					</div>
				</div>
			</td>
		@endif
		@php
			$pos_unit_price = !empty($product->unit_price_before_discount) ? $product->unit_price_before_discount : $product->default_sell_price;

			if(!empty($so_line) && $action !== 'edit') {
				$pos_unit_price = $so_line->unit_price_before_discount;
			}
		@endphp
		<td class="@if(!auth()->user()->can('edit_product_price_from_sale_screen')) hide @endif">
			<input type="text" name="products[{{$row_count}}][unit_price]" class="form-control pos_unit_price input_number mousetrap" value="{{@num_format($pos_unit_price)}}" @if(!empty($pos_settings['enable_msp'])) data-rule-min-value="{{$pos_unit_price}}" data-msg-min-value="{{__('lang_v1.minimum_selling_price_error_msg', ['price' => @num_format($pos_unit_price)])}}" @endif> 

			@if(!empty($last_sell_line))
				<br>
				<small class="text-muted">@lang('lang_v1.prev_unit_price'): @format_currency($last_sell_line->unit_price_before_discount)</small>
			@endif
		</td>
		<td @if(!$edit_discount) class="hide" @endif>
			{!! Form::text("products[$row_count][line_discount_amount]", @num_format($discount_amount), ['class' => 'form-control input_number row_discount_amount']); !!}<br>
			{!! Form::select("products[$row_count][line_discount_type]", ['fixed' => __('lang_v1.fixed'), 'percentage' => __('lang_v1.percentage')], $discount_type , ['class' => 'form-control row_discount_type']); !!}
			@if(!empty($discount))
				<p class="help-block">{!! __('lang_v1.applied_discount_text', ['discount_name' => $discount->name, 'starts_at' => $discount->formated_starts_at, 'ends_at' => $discount->formated_ends_at]) !!}</p>
			@endif

			@if(!empty($last_sell_line))
				<br>
				<small class="text-muted">
					@lang('lang_v1.prev_discount'): 
					@if($last_sell_line->line_discount_type == 'percentage')
						{{@num_format($last_sell_line->line_discount_amount)}}%
					@else
						@format_currency($last_sell_line->line_discount_amount)
					@endif
				</small>
			@endif
		</td>
		
		<td class="text-center {{$hide_tax}}">
            {!! Form::hidden("products[$row_count][item_tax]", @num_format($item_tax), ['class' => 'item_tax']); !!}
        
            {!! Form::select("products[$row_count][tax_id]", $tax_dropdown['tax_rates'], $tax_id, [
                'placeholder' => 'Select', 
                'class' => 'form-control tax_id',
                'disabled' => $tax_status == 'disabled' ? 'disabled' : ''
            ], $tax_dropdown['attributes']); !!}
        </td>

	@else
		@if(!empty($pos_settings['inline_service_staff']))
			<td>
				<div class="form-group">
					<div class="input-group">
						{!! Form::select("products[" . $row_count . "][res_service_staff_id]", $waiters, !empty($product->res_service_staff_id) ? $product->res_service_staff_id : null, ['class' => 'form-control select2 order_line_service_staff', 'placeholder' => __('restaurant.select_service_staff'), 'required' => (!empty($pos_settings['is_service_staff_required']) && $pos_settings['is_service_staff_required'] == 1) ? true : false ]); !!}
					</div>
				</div>
			</td>
		@endif
	@endif
	
	{{-- Unit price including tax column --}}
{{-- Unit price including tax column --}}
<td class="{{$hide_tax}}">
    @php
        // Get the default purchase price from the variation
        $default_purchase_price = 0;
        if(!empty($product->variation_id)) {
            $variation = \App\Variation::find($product->variation_id);
            if($variation && isset($variation->default_purchase_price)) {
                $default_purchase_price = $variation->default_purchase_price;
            }
        }
        // Fallback: if still 0, try to get from the product's variations relationship
        if($default_purchase_price == 0 && !empty($product->variations) && $product->variations->count() > 0) {
            $default_purchase_price = $product->variations->first()->default_purchase_price ?? 0;
        }
    @endphp
    <input type="text" name="products[{{$row_count}}][unit_price_inc_tax]"  style="text-align:center;"
        class="form-control pos_unit_price_inc_tax input_number fldw pos_tablei"
        value="{{@num_format($unit_price_inc_tax)}}"
        @if(!$edit_price) readonly @endif
        data-product-id="{{ $product->product_id }}"
        data-original-price="{{ $product->sell_price_inc_tax }}"
        data-default-sell-price="{{ $product->default_sell_price }}"
        data-cost-price="{{ $default_purchase_price }}"
        data-quantity="{{ $product->quantity_ordered }}"
        data-discount-allowed="{{ $discount_allowed ? 'true' : 'false' }}"
        data-base-price="{{ $base_price }}"
        data-product-name="{{ $product->product_name }}"
        data-discount-ranges='{{ $discounts_json }}'
        data-current-multiplier="{{ $multiplier }}"
        data-has-price-group="{{ $has_price_group ? 'true' : 'false' }}"
        @if(!empty($pos_settings['enable_msp'])) 
            data-rule-min-value="{{ $unit_price_inc_tax }}"
            data-msg-min-value="{{ __('lang_v1.minimum_selling_price_error_msg', ['price' => @num_format($unit_price_inc_tax)]) }}" 
        @endif>
</td>
    
<!-- In the Margin column -->
@if (empty($pos_settings['show_margin']))
<td class="text-center col-margin">
    @php
        // Get the profit_percent from the product object
        $profit_percent = $product->profit_percent ?? 0;
        // If not set, try to get from variation
        if(empty($profit_percent) && !empty($product->variations) && $product->variations->count() > 0) {
            $profit_percent = $product->variations->first()->profit_percent ?? 0;
        }
        // Check if we have a price group that might affect profit
        $has_price_group = $product->has_price_group ?? false;
        $price_group_id = $product->price_group_id ?? null;
    @endphp
    <input type="number" 
           class="form-control profit_percent_input input_number fldw pos_tablei" 
           name="products[{{$row_count}}][profit_percent]" 
           value="{{ $profit_percent }}"
           min="0"
           
           step="any"
           data-row-index="{{ $row_count }}"
           data-product-id="{{ $product->product_id }}"
           data-original-profit="{{ $profit_percent }}"
           data-has-price-group="{{ $has_price_group ? 'true' : 'false' }}"
           style="width: 70px; text-align: center;"
           title="@lang('Profit Margin %')">
</td>
@endif
	
	@if(!empty($common_settings['enable_product_warranty']) && !empty($is_direct_sell))
		<td>
			{!! Form::select("products[$row_count][warranty_id]", $warranties, $warranty_id, ['placeholder' => __('messages.please_select'), 'class' => 'form-control']); !!}
		</td>
	@endif
	<td class="text-center">
		@php
			$subtotal_type = !empty($pos_settings['is_pos_subtotal_editable']) ? 'text' : 'hidden';

		@endphp
		<input type="{{$subtotal_type}}" class="form-control pos_line_total @if(!empty($pos_settings['is_pos_subtotal_editable'])) input_number @endif" value="{{@num_format($product->quantity_ordered*$unit_price_inc_tax )}}" style="min-width:100px;">
		<span class="display_currency pos_line_total_text @if(!empty($pos_settings['is_pos_subtotal_editable'])) hide @endif" data-currency_symbol="true" style="min-width:100px;">{{$product->quantity_ordered*$unit_price_inc_tax}}</span>
	</td>
	<td class="text-center v-center">
		<i class="fa fa-times text-danger pos_remove_row cursor-pointer" aria-hidden="true"></i>
	</td>
	
	@if(session()->get('business.enable_inline_tax') == 1)
        <td class="text-center tax-amount-cell" @if($tax_status == 'disabled')  @endif style="display:none">
            <input type="text" name="products[{{$row_count}}][item_tax]"  value="{{ @num_format($item_tax) }}" readonly>
        </td>
    @endif
</tr>

<script>
$(document).ready(function() {

    console.log('=== PRODUCT ROW INITIALIZED ===');

    // Log all product rows with discount info
    $('tr.product_row').each(function() {
        const row = $(this);
        const productId = row.data('product-id');
        const productName = row.data('product-name') || 'Unknown';
        const discountAllowed = row.data('discount-allowed');
        const basePrice = row.data('base-price');
        const currentPrice = row.find('.pos_unit_price_inc_tax').val();
        const discountRanges = row.data('discount-ranges');
        const multiplier = row.data('current-multiplier') || 1;
        const hasPriceGroup = row.data('has-price-group') === 'true';

        const unitPrices = row.data('unit-prices');

        console.log(`Product: ${productName} (ID: ${productId})`, {
            discount_allowed_raw: discountAllowed,
            discount_allowed_boolean: discountAllowed === true || discountAllowed === 'true',
            base_price: basePrice,
            current_price: currentPrice,
            discount_ranges: discountRanges,
            discount_ranges_type: typeof discountRanges,
            multiplier: multiplier,
            unit_prices: unitPrices,
            has_price_group: hasPriceGroup
        });
    });

    // Get rounding method from PHP
    let roundingMethod = {{ $pos_settings['amount_rounding_method'] ?? 0 }};

    // Function to check if price group is enabled
    function isPriceGroupEnabled() {
        const priceGroupSelect = document.getElementById('price_group');
        if (priceGroupSelect) {
            const value = priceGroupSelect.value;
            const hasPriceGroup = value && value !== '' && value !== '0';
            console.log(`Price group select value: ${value}, hasPriceGroup: ${hasPriceGroup}`);
            return hasPriceGroup;
        }
        return false;
    }

    // Function to check if volume discount is enabled
    function isDiscountEnabled() {
        const checkbox = document.getElementById('enable_volume_discount');
        if (checkbox) {
            return checkbox.checked;
        }
        const hiddenInput = document.getElementById('enable_volume_discount_hidden');
        if (hiddenInput) {
            return hiddenInput.value === '1';
        }
        return false;
    }

    // ============================================================
    // HELPER: Resolve the correct unit price for a row
    // Returns: { price, useUnitPrice, unitPrice, multiplier, hasPriceGroup }
    // ============================================================
    function resolveUnitPrice(row) {
        const subUnitSelect = row.find('.sub_unit:visible');
        const selectedOption = subUnitSelect.find('option:selected');
        const multiplier = parseFloat(selectedOption.data('multiplier')) || 1;
        const unitPrice = parseFloat(selectedOption.data('unit-price')) || 0;
        const hasPriceGroup = row.data('has-price-group') === 'true' || isPriceGroupEnabled();
        const useUnitPrice = unitPrice > 0 && !hasPriceGroup;

        return {
            multiplier: multiplier,
            unitPrice: unitPrice,
            hasPriceGroup: hasPriceGroup,
            useUnitPrice: useUnitPrice,
            unitName: selectedOption.data('unit_name') || ''
        };
    }

    // ============================================================
    // HELPER: Compute the correct base price for a row
    // If a unit with a unit_price is selected → use unit_price
    // If price group is active → use originalPrice * multiplier
    // Otherwise → use basePrice * multiplier
    // ============================================================
    function computeRowPrice(row, priceInput) {
        const info = resolveUnitPrice(row);
        const basePrice = parseFloat(priceInput.data('base-price') || 0);
        const originalPrice = parseFloat(priceInput.data('original-price') || 0);

        let price;
        if (info.hasPriceGroup) {
            price = originalPrice * info.multiplier;
        } else if (info.useUnitPrice) {
            price = info.unitPrice; // ✅ use unit_price from units table
        } else {
            price = basePrice * info.multiplier;
        }
        return { price: price, info: info, basePrice: basePrice, originalPrice: originalPrice };
    }

    // Function to reset all product prices when discount is disabled
    function resetAllProductPrices() {
        console.log('=== Resetting all product prices ===');
        const discountEnabled = isDiscountEnabled();
        const priceGroupEnabled = isPriceGroupEnabled();

        $('tr.product_row').each(function() {
            const row = $(this);
            const priceInput = row.find('.pos_unit_price_inc_tax');
            const productName = row.data('product-name') || 'Unknown';
            const multiplier = row.data('current-multiplier') || 1;

            // Check if this is an existing row - don't reset it
            const hasTransactionId = row.data('has-transaction-line') === 'true';
            if (hasTransactionId) {
                console.log(`Existing row detected for ${productName}, not resetting price`);
                const currentPrice = parseFloat(priceInput.val() || 0);
                const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
                const lineTotal = quantity * currentPrice;
                row.find('.pos_line_total').val(lineTotal.toFixed(2));
                row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
                return;
            }

            // Check if there's an existing discount - preserve it
            const hasExistingDiscount = parseFloat(priceInput.data('current-discount') || 0) > 0;
            if (hasExistingDiscount) {
                console.log(`Existing discount detected for ${productName}, not resetting price`);
                const currentPrice = parseFloat(priceInput.val() || 0);
                const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
                const lineTotal = quantity * currentPrice;
                row.find('.pos_line_total').val(lineTotal.toFixed(2));
                row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
                return;
            }

            if (priceInput.data('manual-override') === true) {
                console.log(`Manual override active for ${productName}, not resetting price`);
                const currentPrice = parseFloat(priceInput.val() || 0);
                const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
                const lineTotal = quantity * currentPrice;
                row.find('.pos_line_total').val(lineTotal.toFixed(2));
                row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
                return;
            }

            // ✅ Use the shared helper to compute the correct price
            const resolved = computeRowPrice(row, priceInput);
            const resetPrice = resolved.price;

            if (!discountEnabled) {
                console.log(`Resetting ${productName} to ${resetPrice}`);
                priceInput.val(resetPrice.toFixed(2));
                priceInput.data('current-discount', 0);
                priceInput.data('current-discount-type', 'fixed');
                row.find('.discount-info').hide();

                const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
                const lineTotal = quantity * resetPrice;
                row.find('.pos_line_total').val(lineTotal.toFixed(2));
                row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
            }
        });

        updateTotalTax();
        updateItemsAndQuantity();
        updateFinalTotal();
    }

    // ============ MODAL PRICE SYNC WITH SUB-UNIT ============

    function updateModalPrice(row) {
        const rowIndex = row.data('row_index');
        const modal = $('#row_edit_product_price_modal_' + rowIndex);

        if (modal.length === 0) return;

        const priceInput = row.find('.pos_unit_price_inc_tax');
        const currentPrice = parseFloat(priceInput.val()) || 0;

        const modalPriceInput = modal.find('.modal-unit-price');
        if (modalPriceInput.length) {
            modalPriceInput.val(currentPrice.toFixed(2));
        }

        const modalPriceDisplay = modal.find('.modal-unit-price-display');
        if (modalPriceDisplay.length) {
            modalPriceDisplay.text(currentPrice.toFixed(2));
        }

        const priceInputData = priceInput.data();
        modalPriceInput.data('original-price', priceInputData.originalPrice);
        modalPriceInput.data('default-sell-price', priceInputData.defaultSellPrice);
        modalPriceInput.data('cost-price', priceInputData.costPrice);
        modalPriceInput.data('base-price', priceInputData.basePrice);
        modalPriceInput.data('current-multiplier', row.data('current-multiplier') || 1);
        modalPriceInput.data('discount-ranges', row.data('discount-ranges') || []);
        modalPriceInput.data('discount-allowed', row.data('discount-allowed'));
        modalPriceInput.data('has-price-group', row.data('has-price-group'));
        modalPriceInput.data('tax-rate', priceInputData.taxRate || 0);

        console.log(`Modal price updated for row ${rowIndex}: ${currentPrice}`);
    }

    $(document).on('change', '.sub_unit', function() {
        const row = $(this).closest('tr.product_row');
        setTimeout(function() {
            updateModalPrice(row);
        }, 300);
    });

    $(document).on('change', '.quantity-input', function() {
        const row = $(this).closest('tr.product_row');
        setTimeout(function() {
            updateModalPrice(row);
        }, 300);
    });

    $(document).on('change', '.pos_unit_price_inc_tax', function() {
        const row = $(this).closest('tr.product_row');
        updateModalPrice(row);
    });

    $(document).on('change', '#enable_volume_discount', function() {
        setTimeout(function() {
            $('tr.product_row').each(function() {
                updateModalPrice($(this));
            });
        }, 400);
    });

    $(document).on('change', '#price_group', function() {
        setTimeout(function() {
            $('tr.product_row').each(function() {
                updateModalPrice($(this));
            });
        }, 400);
    });

    // ============ MODAL SYNC ============

    $(document).on('hidden.bs.modal', '.row_edit_product_price_model', function() {
        const modal = $(this);
        const rowIndex = modal.attr('id').replace('row_edit_product_price_modal_', '');
        const row = $('tr.product_row[data-row_index="' + rowIndex + '"]');

        if (row.length === 0) return;

        console.log(`=== Syncing modal data for row ${rowIndex} ===`);

        const modalUnitPrice = modal.find('.pos_unit_price').val();
        const modalDiscountType = modal.find('.row_discount_type').val();
        const modalDiscountAmount = modal.find('.row_discount_amount').val();
        const modalTaxId = modal.find('.tax_id').val();
        const modalSellLineNote = modal.find('textarea[name*="sell_line_note"]').val();

        const priceInput = row.find('.pos_unit_price_inc_tax');
        const originalPrice = parseFloat(priceInput.data('original-price') || 0);
        const multiplier = row.data('current-multiplier') || 1;

        const basePrice = parseFloat(modalUnitPrice.replace(/,/g, '')) || originalPrice;

        let finalPrice = basePrice;
        let discountAmount = parseFloat(modalDiscountAmount.replace(/,/g, '')) || 0;
        const discountType = modalDiscountType || 'fixed';

        if (discountAmount > 0) {
            if (discountType === 'percentage') {
                finalPrice = basePrice * (1 - (discountAmount / 100));
                console.log(`Applying percentage discount: ${discountAmount}% off, new price: ${finalPrice}`);
            } else {
                finalPrice = basePrice - discountAmount;
                console.log(`Applying fixed discount: ${discountAmount} off, new price: ${finalPrice}`);
            }
            finalPrice = Math.max(0, finalPrice);
        }

        if (finalPrice > 0) {
            console.log(`Updating price from modal: ${finalPrice} (original: ${basePrice})`);
            priceInput.val(finalPrice.toFixed(2));
            priceInput.data('manual-override', true);

            if (discountAmount > 0) {
                priceInput.data('current-discount', discountAmount);
                priceInput.data('current-discount-type', discountType);

                let discountInfo = row.find('.discount-info');
                if (discountInfo.length === 0) {
                    discountInfo = $('<small class="text-muted discount-info" style="display: block; font-size: 11px; color: #28a745;"></small>');
                    priceInput.after(discountInfo);
                }
                discountInfo.show();
            } else {
                priceInput.data('current-discount', 0);
                priceInput.data('current-discount-type', 'fixed');
                row.find('.discount-info').hide();
            }

            const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
            const lineTotal = quantity * finalPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
        }

        if (modalTaxId !== undefined && modalTaxId !== '') {
            const taxSelect = row.find('.tax_id');
            if (taxSelect.length) {
                taxSelect.val(modalTaxId).trigger('change');
            }
        }

        if (modalSellLineNote !== undefined) {
            const noteTextarea = row.find('textarea[name*="sell_line_note"]');
            if (noteTextarea.length) {
                noteTextarea.val(modalSellLineNote);
            }
        }

        updateTotalTax();
        updateItemsAndQuantity();
        updateFinalTotal();

        console.log(`=== Modal sync complete for row ${rowIndex} ===`);
    });

    $(document).on('show.bs.modal', '.row_edit_product_price_model', function() {
        const modal = $(this);
        const rowIndex = modal.attr('id').replace('row_edit_product_price_modal_', '');
        const row = $('tr.product_row[data-row_index="' + rowIndex + '"]');

        if (row.length === 0) return;

        console.log(`=== Populating modal for row ${rowIndex} ===`);

        const priceInput = row.find('.pos_unit_price_inc_tax');
        const currentPrice = parseFloat(priceInput.val() || 0);
        const currentDiscount = parseFloat(priceInput.data('current-discount') || 0);
        const currentDiscountType = priceInput.data('current-discount-type') || 'fixed';
        const currentTaxId = row.find('.tax_id').val();
        const currentNote = row.find('textarea[name*="sell_line_note"]').val() || '';

        const modalPriceInput = modal.find('.pos_unit_price');
        if (modalPriceInput.length && currentPrice > 0) {
            modalPriceInput.val(currentPrice.toFixed(2));
        }

        const modalDiscountType = modal.find('.row_discount_type');
        if (modalDiscountType.length) {
            modalDiscountType.val(currentDiscountType);
        }

        const modalDiscountAmount = modal.find('.row_discount_amount');
        if (modalDiscountAmount.length && currentDiscount > 0) {
            modalDiscountAmount.val(currentDiscount.toFixed(2));
        }

        const modalTaxSelect = modal.find('.tax_id');
        if (modalTaxSelect.length && currentTaxId) {
            modalTaxSelect.val(currentTaxId);
        }

        const modalNote = modal.find('textarea[name*="sell_line_note"]');
        if (modalNote.length) {
            modalNote.val(currentNote);
        }

        console.log(`=== Modal populated for row ${rowIndex} ===`);
    });

    $(document).on('change', '.row_edit_product_price_model .pos_unit_price', function() {
        const modal = $(this).closest('.modal');
        const rowIndex = modal.attr('id').replace('row_edit_product_price_modal_', '');
        const row = $('tr.product_row[data-row_index="' + rowIndex + '"]');

        if (row.length === 0) return;

        const newPrice = parseFloat($(this).val().replace(/,/g, '')) || 0;
        const priceInput = row.find('.pos_unit_price_inc_tax');

        if (newPrice > 0) {
            priceInput.val(newPrice.toFixed(2));
            priceInput.data('manual-override', true);

            const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
            const lineTotal = quantity * newPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

            updateTotalTax();
            updateFinalTotal();
        }
    });

    $(document).on('change', '.row_edit_product_price_model .row_discount_type, .row_edit_product_price_model .row_discount_amount', function() {
        const modal = $(this).closest('.modal');
        const rowIndex = modal.attr('id').replace('row_edit_product_price_modal_', '');
        const row = $('tr.product_row[data-row_index="' + rowIndex + '"]');

        if (row.length === 0) return;

        const discountType = modal.find('.row_discount_type').val() || 'fixed';
        const discountAmount = parseFloat(modal.find('.row_discount_amount').val().replace(/,/g, '')) || 0;
        const priceInput = row.find('.pos_unit_price_inc_tax');

        const originalPrice = parseFloat(priceInput.data('original-price') || 0);
        const multiplier = row.data('current-multiplier') || 1;
        const basePrice = originalPrice * multiplier;

        let finalPrice = basePrice;

        if (discountAmount > 0) {
            if (discountType === 'percentage') {
                finalPrice = basePrice * (1 - (discountAmount / 100));
            } else {
                finalPrice = basePrice - discountAmount;
            }
            finalPrice = Math.max(0, finalPrice);

            priceInput.val(finalPrice.toFixed(2));
            priceInput.data('current-discount', discountAmount);
            priceInput.data('current-discount-type', discountType);
            priceInput.data('manual-override', true);

            let discountInfo = row.find('.discount-info');
            if (discountInfo.length === 0) {
                discountInfo = $('<small class="text-muted discount-info" style="display: block; font-size: 11px; color: #28a745;"></small>');
                priceInput.after(discountInfo);
            }
            discountInfo.show();
        } else {
            priceInput.val(basePrice.toFixed(2));
            priceInput.data('current-discount', 0);
            priceInput.data('current-discount-type', 'fixed');
            row.find('.discount-info').hide();
        }

        const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
        const lineTotal = quantity * finalPrice;
        row.find('.pos_line_total').val(lineTotal.toFixed(2));
        row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

        updateTotalTax();
        updateFinalTotal();
    });

    // Function to calculate product discount based on quantity
    function calculateProductDiscount(productId, quantity, basePrice) {
        console.log(`Calculating discount for product ${productId}, quantity: ${quantity}, basePrice: ${basePrice}`);

        const discountEnabled = isDiscountEnabled();
        console.log(`Discount checkbox enabled: ${discountEnabled}`);

        if (!discountEnabled) {
            console.log('Discount checkbox is NOT checked - no discount applied');
            return { price: basePrice, discount: 0, type: 'fixed' };
        }

        let discountedPrice = basePrice;
        let discountAmount = 0;
        let discountType = 'fixed';

        const row = $('tr.product_row[data-product-id="' + productId + '"]');
        let discountData = row.data('discount-ranges');

        if (typeof discountData === 'string') {
            try {
                discountData = JSON.parse(discountData);
                row.data('discount-ranges', discountData);
            } catch(e) {
                console.error('Failed to parse discount data:', e);
                discountData = null;
            }
        }

        if (!discountData || quantity <= 0) {
            return { price: basePrice, discount: 0, type: 'fixed' };
        }

        let discounts = [];
        if (Array.isArray(discountData)) {
            discounts = discountData;
        }

        if (discounts.length === 0) {
            return { price: basePrice, discount: 0, type: 'fixed' };
        }

        let applicableDiscount = null;
        for (let i = discounts.length - 1; i >= 0; i--) {
            const d = discounts[i];
            const fromQty = parseFloat(d.from_quantity) || 0;
            const toQty = d.to_quantity ? parseFloat(d.to_quantity) : null;

            if (quantity >= fromQty && (toQty === null || quantity <= toQty)) {
                applicableDiscount = d;
                break;
            }
        }

        if (applicableDiscount) {
            discountType = applicableDiscount.discount_type || 'fixed';
            discountAmount = parseFloat(applicableDiscount.discount_amount) || 0;

            if (discountType === 'percentage') {
                discountedPrice = basePrice - (basePrice * discountAmount / 100);
            } else {
                discountedPrice = basePrice - discountAmount;
            }
            discountedPrice = Math.max(0, discountedPrice);
        }

        return {
            price: discountedPrice,
            discount: discountAmount,
            type: discountType
        };
    }

    // ============================================
    // MARKUP PERCENTAGE HANDLING (Profit on Cost)
    // ============================================

    function calculatePriceFromMargin(costPrice, markupPercent) {
        const markupDecimal = markupPercent / 100;
        const price = costPrice * (1 + markupDecimal);
        return Math.round(price * 100) / 100;
    }

    function calculateMarginFromPrice(costPrice, sellingPrice) {
        if (sellingPrice <= 0 || costPrice <= 0) return 0;
        const markup = ((sellingPrice - costPrice) / costPrice) * 100;
        return Math.round(markup * 100) / 100;
    }

    $(document).on('change', '.profit_percent_input', function() {
        const row = $(this).closest('tr.product_row');
        const markupPercent = parseFloat($(this).val()) || 0;
        const productId = $(this).data('product-id');

        console.log(`Markup changed for product ${productId}: ${markupPercent}%`);

        const priceInput = row.find('.pos_unit_price_inc_tax');
        const costPrice = parseFloat(priceInput.data('cost-price') || 0);
        const originalPrice = parseFloat(priceInput.data('original-price') || 0);

        let finalCostPrice = costPrice;
        if (finalCostPrice <= 0) {
            console.warn('Cost price not available for product', productId);
            finalCostPrice = originalPrice * 0.6;
        }

        if (markupPercent <= 0) {
            const quantity = parseFloat(row.find('.quantity-input').val().replace(/,/g, '')) || 0;
            const newPrice = originalPrice;
            priceInput.val(newPrice.toFixed(2));

            const lineTotal = quantity * newPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

            updateTotalTax();
            updateFinalTotal();
            return;
        }

        let newPrice = calculatePriceFromMargin(finalCostPrice, markupPercent);

        // ✅ Use shared helper
        const info = resolveUnitPrice(row);

        if (info.hasPriceGroup) {
            newPrice = newPrice * info.multiplier;
        } else if (info.useUnitPrice) {
            const unitCostPrice = parseFloat(priceInput.data('cost-price')) || finalCostPrice;
            newPrice = calculatePriceFromMargin(unitCostPrice, markupPercent);
        } else {
            newPrice = newPrice * info.multiplier;
        }

        newPrice = Math.round(newPrice * 100) / 100;

        priceInput.val(newPrice.toFixed(2));
        priceInput.data('manual-override', true);
        priceInput.data('margin-percent', markupPercent);
        priceInput.data('cost-price', finalCostPrice);

        const quantity = parseFloat(row.find('.quantity-input').val().replace(/,/g, '')) || 0;
        const lineTotal = quantity * newPrice;
        row.find('.pos_line_total').val(lineTotal.toFixed(2));
        row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

        updateTotalTax();
        updateFinalTotal();
    });

    $(document).on('change', '.pos_unit_price_inc_tax', function() {
        const row = $(this).closest('tr.product_row');
        const priceInput = $(this);
        const marginInput = row.find('.profit_percent_input');
        const sellingPrice = parseFloat(priceInput.val()) || 0;
        const costPrice = parseFloat(priceInput.data('cost-price') || 0);
        const originalPrice = parseFloat(priceInput.data('original-price') || 0);

        let finalCostPrice = costPrice;
        if (finalCostPrice <= 0) {
            finalCostPrice = originalPrice * 0.6;
        }

        const info = resolveUnitPrice(row);

        if (info.hasPriceGroup) {
            finalCostPrice = finalCostPrice * info.multiplier;
        } else if (info.useUnitPrice) {
            const unitCostPrice = parseFloat(priceInput.data('cost-price')) || finalCostPrice;
            finalCostPrice = unitCostPrice;
        }

        let markup = calculateMarginFromPrice(finalCostPrice, sellingPrice);

        marginInput.val(markup.toFixed(2));
        marginInput.data('cost-price', finalCostPrice);
    });

    // ============================================
    // END MARKUP PERCENTAGE HANDLING
    // ============================================

    function updateTotalTax() {
        let totalTaxAmount = 0;

        $('tr.product_row').each(function() {
            const row = $(this);

            const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
            const inputField = row.find('.pos_unit_price_inc_tax');
            const manualPrice = parseFloat((inputField.val() || '0').replace(/,/g, '')) || 0;
            const defaultSellPrice = parseFloat((inputField.data('default-sell-price') || '0').toString().replace(/,/g, '')) || 0;
            const originalPrice = parseFloat((inputField.data('original-price') || '0').toString().replace(/,/g, '')) || 0;
            const productId = inputField.data('product-id');

            let taxAmount = 0;

            if (manualPrice !== originalPrice) {
                fetch(`/get-tax-rate/${productId}`)
                    .then(response => response.json())
                    .then(data => {
                        const rate = parseFloat((data.rate || '0').toString().replace(/,/g, '')) || 0;
                        const priceExclTax = manualPrice / (1 + (rate / 100));
                        taxAmount = (manualPrice - priceExclTax) * quantity;
                        row.find('.tax-amount-cell input').val(taxAmount.toFixed(2));
                        updateRunningTotalTax();
                        updateFinalTotal();
                    })
                    .catch(error => {
                        console.warn('Tax rate fetch failed for product ID', productId, error);
                    });
            } else {
                taxAmount = (originalPrice - defaultSellPrice) * quantity;
                row.find('.tax-amount-cell input').val(taxAmount.toFixed(2));
            }
            totalTaxAmount += taxAmount;
        });
        updateRunningTotalTax();
    }

    function updateRunningTotalTax() {
        let totalTax = 0;
        $('.tax-amount-cell input').each(function() {
            const tax = parseFloat(($(this).val() || '0').replace(/,/g, '')) || 0;
            totalTax += tax;
        });
        $('#total_order_tax').val(totalTax.toFixed(2));
        $('#total_order_tax1').val(totalTax.toFixed(2));
    }

    function updateItemsAndQuantity() {
        let totalItems = 0;
        let totalQuantity = 0;

        $('tr.product_row').each(function() {
            totalItems++;
            const qty = parseFloat(($(this).find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
            totalQuantity += qty;
        });

        $('#total_items_count').text(totalItems);
        $('#total_quantity_count').text(totalQuantity.toFixed(2));
    }

    function updateFinalTotal() {
        let subtotal = 0;

        $('tr.product_row').each(function() {
            const row = $(this);
            const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
            const priceInput = row.find('.pos_unit_price_inc_tax');
            const unitPrice = parseFloat((priceInput.val() || '0').replace(/,/g, '')) || 0;
            const lineTotal = quantity * unitPrice;
            subtotal += lineTotal;

            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
        });

        let discountAmount = parseFloat($('#discount_amount').val() || 0);
        let discountType = $('#discount_type').val() || 'percentage';
        let discountValue = 0;

        if (discountType === 'percentage') {
            discountValue = (subtotal * discountAmount) / 100;
        } else {
            discountValue = discountAmount;
        }

        let shippingCharges = parseFloat($('#shipping_charges').val() || 0);
        let packingFee = parseFloat($('#packing_charge_text').text() || 0);
        let taxAmount = parseFloat($('#total_order_tax').val() || 0);

        let finalTotal = subtotal - discountValue + shippingCharges + packingFee;

        let roundOffAmount = 0;
        let preRoundTotal = finalTotal;

        if (roundingMethod > 0) {
            switch(parseInt(roundingMethod)) {
                case 1:
                    finalTotal = Math.round(finalTotal);
                    roundOffAmount = finalTotal - preRoundTotal;
                    break;
                case 2:
                    finalTotal = Math.ceil(finalTotal);
                    roundOffAmount = finalTotal - preRoundTotal;
                    break;
                case 3:
                    finalTotal = Math.floor(finalTotal);
                    roundOffAmount = finalTotal - preRoundTotal;
                    break;
                case 4:
                    finalTotal = Math.round(finalTotal * 2) / 2;
                    roundOffAmount = finalTotal - preRoundTotal;
                    break;
                case 5:
                    finalTotal = Math.ceil(finalTotal * 2) / 2;
                    roundOffAmount = finalTotal - preRoundTotal;
                    break;
                case 6:
                    finalTotal = Math.floor(finalTotal * 2) / 2;
                    roundOffAmount = finalTotal - preRoundTotal;
                    break;
            }

            const currencySymbol = '{{ session()->get("currency")["symbol"] ?? "$" }}';
            $('#round_off_text').text(currencySymbol + ' ' + Math.abs(roundOffAmount).toFixed(2));
            $('#round_off_amount').val(roundOffAmount.toFixed(2));
        } else {
            $('#round_off_text').text('0.00');
            $('#round_off_amount').val(0);
        }

        const currencySymbol = '{{ session()->get("currency")["symbol"] ?? "$" }}';
        $('#total_discount').text(currencySymbol + ' ' + discountValue.toFixed(2));
        $('#shipping_charges_amount').text(shippingCharges.toFixed(2));

        $('#total_payable_display, #amount_due_display, #total_payable').text(currencySymbol + ' ' + finalTotal.toFixed(2));
        $('#final_total_input, #final_total_input_hidden, input[name="final_total"]').val(finalTotal.toFixed(2));
        $('.total_amount').text(currencySymbol + ' ' + finalTotal.toFixed(2));
        $('#total_amount').val(finalTotal.toFixed(2));

        if ($('#subtotal_display').length) {
            $('#subtotal_display').text(currencySymbol + ' ' + subtotal.toFixed(2));
        }
        if ($('#discount_display').length) {
            $('#discount_display').text(currencySymbol + ' ' + discountValue.toFixed(2));
        }
        if ($('#shipping_display').length) {
            $('#shipping_display').text(currencySymbol + ' ' + shippingCharges.toFixed(2));
        }
        if ($('#packing_display').length) {
            $('#packing_display').text(currencySymbol + ' ' + packingFee.toFixed(2));
        }
        if ($('#tax_display').length) {
            $('#tax_display').text(currencySymbol + ' ' + taxAmount.toFixed(2));
        }
    }

    // ============ SUB-UNIT HANDLING ============
function updateSubUnit(row) {
    const info = resolveUnitPrice(row);

    console.log(`=== Sub-unit changed for ${row.data('product-name')} ===`);
    console.log(`Multiplier: ${info.multiplier}, Unit: ${info.unitName}`);
    console.log(`Unit Price: ${info.unitPrice}, Use Unit Price: ${info.useUnitPrice}`);
    console.log(`Has Price Group: ${info.hasPriceGroup}`);

    const priceInput = row.find('.pos_unit_price_inc_tax');
    const hasTransactionId = row.data('has-transaction-line') === 'true';
    const hasExistingDiscount = parseFloat(priceInput.data('current-discount') || 0) > 0;

    // ✅ Only preserve price for existing rows or when a discount is already applied
    if (hasTransactionId || hasExistingDiscount) {
        console.log(`Preserving price on sub-unit change`);
        const quantity = parseFloat(row.find('.quantity-input').val().replace(/,/g, '')) || 0;
        const currentPrice = parseFloat(priceInput.val() || 0);
        const lineTotal = quantity * currentPrice;
        row.find('.pos_line_total').val(lineTotal.toFixed(2));
        row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
        row.data('current-multiplier', info.multiplier);
        row.data('current-unit', info.unitName);
        row.find('.base_unit_multiplier').val(info.multiplier);
        updateTotalTax();
        updateFinalTotal();
        return;
    }

    // ✅ Clear manual override since user explicitly changed unit
    priceInput.data('manual-override', false);
    priceInput.data('current-discount', 0);
    priceInput.data('current-discount-type', 'fixed');
    row.find('.discount-info').hide();

    row.data('current-multiplier', info.multiplier);
    row.data('current-unit', info.unitName);
    row.find('.base_unit_multiplier').val(info.multiplier);

    // ✅ Compute correct price using shared helper
    const resolved = computeRowPrice(row, priceInput);
    priceInput.val(resolved.price.toFixed(2));

    const quantity = parseFloat(row.find('.quantity-input').val().replace(/,/g, '')) || 0;
    const lineTotal = quantity * resolved.price;
    row.find('.pos_line_total').val(lineTotal.toFixed(2));
    row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

    updateDiscountRangesForRow(row, info.multiplier);
    updateProductDiscount(row);
    updateTotalTax();
    updateItemsAndQuantity();
    updateFinalTotal();
}

    function updateDiscountRangesForRow(row, multiplier) {
        const productId = row.data('product-id');
        const discountAllowed = row.data('discount-allowed') === 'true';

        if (!discountAllowed) return;

        console.log(`Updating discount ranges for product ${productId} with multiplier ${multiplier}`);

        $.ajax({
            url: '/get-product-discounts',
            method: 'GET',
            data: {
                product_id: productId,
                multiplier: multiplier
            },
            success: function(response) {
                if (response.success && response.discounts && response.discounts.length > 0) {
                    console.log(`Discounts loaded with multiplier ${multiplier}:`, response.discounts);
                    row.data('discount-ranges', response.discounts);
                    updateProductDiscount(row);
                } else {
                    console.log(`No discounts found for product ${productId}`);
                    row.data('discount-ranges', []);
                }
            },
            error: function(xhr, status, error) {
                console.error(`Failed to fetch discounts for product ${productId}:`, error);
                row.data('discount-ranges', []);
            }
        });
    }

    // ============ PRODUCT DISCOUNT FUNCTION ============
    function updateProductDiscount(row) {
        const quantityInput = row.find('.quantity-input');
        const quantity = parseFloat((quantityInput.val() || '0').replace(/,/g, '')) || 0;
        const priceInput = row.find('.pos_unit_price_inc_tax');
        const productId = priceInput.data('product-id');
        const productName = priceInput.data('product-name') || 'Unknown';

        const info = resolveUnitPrice(row);
        const hasTransactionId = row.data('has-transaction-line') === 'true';

        if (hasTransactionId) {
            console.log(`Existing row detected for ${productName}: preserving price ${priceInput.val()}`);
            const currentPrice = parseFloat(priceInput.val() || 0);
            const lineTotal = quantity * currentPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
            updateTotalTax();
            updateFinalTotal();
            return;
        }

        const manualOverride = priceInput.data('manual-override') === true;
        if (manualOverride) {
            console.log(`Manual override active for ${productName}: preserving price ${priceInput.val()}`);
            const currentPrice = parseFloat(priceInput.val() || 0);
            const lineTotal = quantity * currentPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
            updateTotalTax();
            updateFinalTotal();
            return;
        }

        const currentDiscount = parseFloat(priceInput.data('current-discount') || 0);
        const currentDiscountType = priceInput.data('current-discount-type') || 'fixed';
        const hasExistingDiscount = currentDiscount > 0;
        const originalPrice = parseFloat(priceInput.data('original-price') || 0);

        if (hasExistingDiscount) {
            console.log(`Existing discount detected for ${productName}: ${currentDiscountType} ${currentDiscount}, preserving price`);
            const currentPrice = parseFloat(priceInput.val() || 0);
            const lineTotal = quantity * currentPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
            updateTotalTax();
            updateFinalTotal();
            return;
        }

        // ✅ Determine base price correctly (respect unit_price)
        let basePrice = parseFloat(priceInput.data('base-price') || 0);

        if (info.hasPriceGroup) {
            basePrice = originalPrice;
            console.log(`✅ Price group active: using original price ${originalPrice} as base`);
        } else if (info.useUnitPrice) {
            basePrice = info.unitPrice;
            console.log(`✅ Using unit price: ${info.unitPrice} (instead of ${priceInput.data('base-price')})`);
        }

        const actualQuantity = quantity * info.multiplier;
        const hasGlobalDiscount = row.data('has-global-discount') === 'true';
        const discountAllowed = (row.data('discount-allowed') === true || row.data('discount-allowed') === 'true') || hasGlobalDiscount;
        const discountEnabled = isDiscountEnabled();

        console.log(`=== updateProductDiscount called for ${productName} ===`);
        console.log(`Display Quantity: ${quantity}, Multiplier: ${info.multiplier}`);
        console.log(`Actual Quantity: ${actualQuantity}`);
        console.log(`Base Price: ${basePrice}`);
        console.log(`Use Unit Price: ${info.useUnitPrice}`);
        console.log(`Unit Price: ${info.unitPrice}`);
        console.log(`Has Price Group: ${info.hasPriceGroup}`);
        console.log(`Discount Allowed: ${discountAllowed}`);
        console.log(`Has Global Discount: ${hasGlobalDiscount}`);
        console.log(`Discount checkbox enabled: ${discountEnabled}`);

        // ✅ Helper to compute the "reset" price correctly
        function getResetPrice() {
            if (info.hasPriceGroup) {
                return originalPrice * info.multiplier;
            } else if (info.useUnitPrice) {
                return info.unitPrice;
            } else {
                return originalPrice * info.multiplier;
            }
        }

        if (!discountEnabled) {
            console.log(`Discount checkbox is unchecked - reverting ${productName} to original price`);
            const priceToUse = getResetPrice();
            priceInput.val(priceToUse.toFixed(2));
            priceInput.data('current-discount', 0);
            priceInput.data('current-discount-type', 'fixed');
            row.find('.discount-info').hide();

            const lineTotal = quantity * priceToUse;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

            updateTotalTax();
            updateFinalTotal();
            return;
        }

        if (quantity <= 0) {
            console.log(`Quantity is 0 or less, checking if discount exists`);
            if (hasExistingDiscount) {
                const currentPrice = parseFloat(priceInput.val() || 0);
                const lineTotal = 0;
                row.find('.pos_line_total').val(lineTotal.toFixed(2));
                row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
                updateTotalTax();
                updateFinalTotal();
                return;
            }

            const priceToUse = getResetPrice();
            priceInput.val(priceToUse.toFixed(2));
            row.find('.discount-info').hide();
            const lineTotal = 0;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
            updateTotalTax();
            updateFinalTotal();
            return;
        }

        if (discountAllowed) {
            console.log(`✅ Discount is allowed for this product`);

            if (!basePrice) {
                console.log(`Invalid base price (${basePrice})`);
                return;
            }

            if (hasGlobalDiscount) {
                const globalDiscountType = row.data('global-discount-type') || 'fixed';
                const globalDiscountAmount = parseFloat(row.data('global-discount-amount') || 0);

                console.log(`✅ Applying global discount: ${globalDiscountType} ${globalDiscountAmount}`);

                if (globalDiscountAmount > 0) {
                    applyGlobalDiscount(row, globalDiscountType, globalDiscountAmount, quantity, basePrice, info.multiplier, info);
                    return;
                }
            }

            if (discountEnabled) {
                let productDiscounts = row.data('discount-ranges');

                if (typeof productDiscounts === 'string') {
                    try {
                        productDiscounts = JSON.parse(productDiscounts);
                        row.data('discount-ranges', productDiscounts);
                    } catch(e) {
                        console.error(`Failed to parse discount ranges for ${productName}:`, e);
                        productDiscounts = null;
                    }
                }

                if (productDiscounts && Array.isArray(productDiscounts) && productDiscounts.length > 0) {
                    console.log(`Using cached discount ranges for ${productName} with actual quantity ${actualQuantity}`);
                    applyVolumeDiscount(row, productDiscounts, actualQuantity, quantity, basePrice, info.multiplier, info);
                } else {
                    console.log(`No discount ranges loaded for ${productName}, fetching from server...`);
                    $.ajax({
                        url: '/get-product-discounts',
                        method: 'GET',
                        data: {
                            product_id: productId,
                            multiplier: info.multiplier
                        },
                        success: function(response) {
                            console.log(`Discount fetch response for ${productName}:`, response);
                            if (response.success && response.discounts && response.discounts.length > 0) {
                                row.data('discount-ranges', response.discounts);
                                applyVolumeDiscount(row, response.discounts, actualQuantity, quantity, basePrice, info.multiplier, info);
                            } else {
                                console.log(`No discounts found for ${productName}`);
                                row.data('discount-ranges', []);
                                const currentPrice = parseFloat(priceInput.val() || 0);
                                if (currentPrice > 0) {
                                    const lineTotal = quantity * currentPrice;
                                    row.find('.pos_line_total').val(lineTotal.toFixed(2));
                                    row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
                                    row.find('.discount-info').hide();
                                    updateTotalTax();
                                    updateFinalTotal();
                                } else {
                                    const priceToUse = getResetPrice();
                                    priceInput.val(priceToUse.toFixed(2));
                                    row.find('.discount-info').hide();
                                    const lineTotal = quantity * priceToUse;
                                    row.find('.pos_line_total').val(lineTotal.toFixed(2));
                                    row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
                                    updateTotalTax();
                                    updateFinalTotal();
                                }
                            }
                        },
                        error: function(xhr, status, error) {
                            console.error(`Failed to fetch product discounts for ${productName}:`, error);
                            row.data('discount-ranges', []);
                        }
                    });
                }
            } else {
                console.log(`Volume discount checkbox is unchecked - keeping current price`);
                const currentPrice = parseFloat(priceInput.val() || 0);
                if (currentPrice > 0) {
                    const lineTotal = quantity * currentPrice;
                    row.find('.pos_line_total').val(lineTotal.toFixed(2));
                    row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
                    row.find('.discount-info').hide();
                    updateTotalTax();
                    updateFinalTotal();
                } else {
                    const priceToUse = getResetPrice();
                    priceInput.val(priceToUse.toFixed(2));
                    row.find('.discount-info').hide();
                    const lineTotal = quantity * priceToUse;
                    row.find('.pos_line_total').val(lineTotal.toFixed(2));
                    row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
                    updateTotalTax();
                    updateFinalTotal();
                }
            }
        } else {
            console.log(`No discount applied - Product does not have discount allowed and no global discount`);
            const priceToUse = getResetPrice();
            priceInput.val(priceToUse.toFixed(2));
            row.find('.discount-info').hide();
            const lineTotal = quantity * priceToUse;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
            updateTotalTax();
            updateFinalTotal();
            return;
        }
    }

    // Function to apply global discount (respects unit_price)
    function applyGlobalDiscount(row, discountType, discountAmount, displayQuantity, basePrice, multiplier, info) {
        const productName = row.data('product-name') || 'Unknown';
        const priceInput = row.find('.pos_unit_price_inc_tax');
        const unitName = (info && info.unitName) || row.data('current-unit') || '';

        // ✅ If a unit price is set, discount applies directly to that unit price
        const useUnitPrice = info && info.useUnitPrice;

        console.log(`=== applyGlobalDiscount called for ${productName} ===`);
        console.log(`Type: ${discountType}, Amount: ${discountAmount}`);
        console.log(`Use Unit Price: ${useUnitPrice}`);

        let discountedPrice;

        if (useUnitPrice) {
            // Apply discount directly to unit price
            if (discountType === 'percentage') {
                discountedPrice = info.unitPrice - (info.unitPrice * discountAmount / 100);
            } else {
                discountedPrice = info.unitPrice - discountAmount;
            }
        } else {
            let discountOnBasePrice = 0;
            if (discountType === 'percentage') {
                discountOnBasePrice = basePrice * discountAmount / 100;
            } else {
                discountOnBasePrice = discountAmount;
            }
            discountedPrice = (basePrice - discountOnBasePrice) * multiplier;
        }

        discountedPrice = Math.max(0, discountedPrice);

        console.log(`Final unit price: ${discountedPrice} per ${unitName}`);

        priceInput.val(discountedPrice.toFixed(2));
        priceInput.data('current-discount', discountAmount);
        priceInput.data('current-discount-type', discountType);
        priceInput.data('manual-override', false);
        priceInput.data('current-multiplier', multiplier);

        let discountInfo = row.find('.discount-info');
        if (discountInfo.length === 0) {
            discountInfo = $('<small class="text-muted discount-info" style="display: block; font-size: 11px; color: #28a745;"></small>');
            priceInput.after(discountInfo);
        }

        let discountText = '';
        if (discountType === 'percentage') {
            discountText = discountAmount + '% off';
        } else {
            const currencySymbol = '{{ session()->get("currency")["symbol"] ?? "$" }}';
            discountText = currencySymbol + discountAmount + ' off';
        }

        discountInfo.text('🌐 Global: ' + discountText);
        discountInfo.show();

        const lineTotal = displayQuantity * discountedPrice;
        row.find('.pos_line_total').val(lineTotal.toFixed(2));
        row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

        updateTotalTax();
        updateFinalTotal();
    }

    // Volume discount application (respects unit_price)
    function applyVolumeDiscount(row, discounts, actualQuantity, displayQuantity, basePrice, multiplier, info) {
        const productName = row.data('product-name') || 'Unknown';
        const priceInput = row.find('.pos_unit_price_inc_tax');
        const originalPrice = parseFloat(priceInput.data('original-price') || 0);

        // ✅ Get unit price info
        const useUnitPrice = info && info.useUnitPrice;
        const unitPrice = info ? info.unitPrice : 0;
        const unitName = info ? info.unitName : (row.data('current-unit') || '');

        const discountEnabled = isDiscountEnabled();
        if (!discountEnabled) {
            console.log(`Discount checkbox is unchecked - reverting ${productName} to original price`);

            let priceToUse;
            if (info && info.hasPriceGroup) {
                priceToUse = originalPrice * multiplier;
            } else if (useUnitPrice) {
                priceToUse = unitPrice;
            } else {
                priceToUse = originalPrice * multiplier;
            }
            priceInput.val(priceToUse.toFixed(2));
            priceInput.data('manual-override', false);
            priceInput.data('current-discount', 0);
            priceInput.data('current-discount-type', 'fixed');

            row.find('.discount-info').hide();

            const lineTotal = displayQuantity * priceToUse;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

            updateTotalTax();
            updateFinalTotal();
            return;
        }

        console.log(`=== applyVolumeDiscount called for ${productName} ===`);
        console.log(`Display Quantity: ${displayQuantity}, Actual Quantity: ${actualQuantity}`);
        console.log(`Base Price: ${basePrice}, Multiplier: ${multiplier}`);
        console.log(`Use Unit Price: ${useUnitPrice}, Unit Price: ${unitPrice}`);
        console.log('Discounts:', discounts);

        let discountedPrice = useUnitPrice ? unitPrice : (basePrice * multiplier);
        let discountAmount = 0;
        let discountType = 'fixed';
        let discountApplied = false;
        let appliedRange = null;

        if (discounts && discounts.length > 0) {
            for (let i = discounts.length - 1; i >= 0; i--) {
                const d = discounts[i];
                const fromQty = parseFloat(d.from_quantity) || 0;
                const toQty = d.to_quantity ? parseFloat(d.to_quantity) : null;

                console.log(`Checking range ${i}: from=${fromQty}, to=${toQty} against actual quantity: ${actualQuantity}`);

                if (actualQuantity >= fromQty && (toQty === null || actualQuantity <= toQty)) {
                    appliedRange = d;
                    discountType = d.discount_type || 'fixed';
                    discountAmount = parseFloat(d.discount_amount) || 0;
                    discountApplied = true;
                    console.log(`✅ Applicable volume discount found for ${productName}:`, d);
                    break;
                }
            }
        }

        if (discountApplied) {
            if (useUnitPrice) {
                // ✅ Apply discount directly to unit price
                if (discountType === 'percentage') {
                    discountedPrice = unitPrice - (unitPrice * discountAmount / 100);
                } else {
                    discountedPrice = unitPrice - discountAmount;
                }
                discountedPrice = Math.max(0, discountedPrice);
                console.log(`✅ Discounted unit price: ${discountedPrice}`);
            } else {
                let discountOnBasePrice = 0;
                if (discountType === 'percentage') {
                    discountOnBasePrice = basePrice * discountAmount / 100;
                } else {
                    discountOnBasePrice = discountAmount * multiplier;
                }
                discountedPrice = (basePrice - discountOnBasePrice) * multiplier;
                discountedPrice = Math.max(0, discountedPrice);
                console.log(`Discounted base price with multiplier: ${discountedPrice}`);
            }

            console.log(`Final unit price: ${discountedPrice} per ${unitName}`);

            priceInput.val(discountedPrice.toFixed(2));
            priceInput.data('current-discount', discountAmount);
            priceInput.data('current-discount-type', discountType);
            priceInput.data('manual-override', false);
            priceInput.data('current-multiplier', multiplier);
            priceInput.data('actual-quantity', actualQuantity);
            priceInput.data('original-price-before-discount', originalPrice);

            let discountInfo = row.find('.discount-info');
            if (discountInfo.length === 0) {
                discountInfo = $('<small class="text-muted discount-info" style="display: block; font-size: 11px; color: #28a745;"></small>');
                priceInput.after(discountInfo);
            }

            let discountText = '';
            if (discountType === 'percentage') {
                discountText = discountAmount + '% off';
            } else {
                const currencySymbol = '{{ session()->get("currency")["symbol"] ?? "$" }}';
                const totalDiscount = useUnitPrice ? discountAmount : (discountAmount * multiplier);
                discountText = currencySymbol + totalDiscount + ' off';
            }

            discountInfo.show();

            const lineTotal = displayQuantity * discountedPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

            updateTotalTax();
            updateFinalTotal();
        } else {
            console.log(`No volume discount applied for ${productName} (actual quantity: ${actualQuantity})`);

            let priceToUse;
            if (info && info.hasPriceGroup) {
                priceToUse = originalPrice * multiplier;
            } else if (useUnitPrice) {
                priceToUse = unitPrice;
            } else {
                priceToUse = originalPrice * multiplier;
            }
            priceInput.val(priceToUse.toFixed(2));
            priceInput.data('current-discount', 0);
            priceInput.data('current-discount-type', 'fixed');
            console.log(`Reverted to price: ${priceToUse}`);

            row.find('.discount-info').hide();

            const lineTotal = displayQuantity * parseFloat(priceInput.val() || 0);
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

            updateTotalTax();
            updateFinalTotal();
        }
    }

    // ============ EVENT HANDLERS ============

    $(document).on('change', '.pos_unit_price_inc_tax', function() {
        console.log('Manual price change detected');
        $(this).data('manual-override', true);
        updateTotalTax();
        updateFinalTotal();
    });

    $(document).on('change', '.quantity-input', function() {
        console.log('=== Quantity changed (with serial validation) ===');
        const input = $(this);
        const row = input.closest('tr.product_row');
        const productName = row.data('product-name') || 'Unknown';
        const hasSerialNumber = row.data('has-serial-number') === 'true';

        const hasTransactionId = row.data('has-transaction-line') === 'true';
        if (hasTransactionId) {
            let value = parseFloat(input.val().replace(/,/g, '')) || 0;
            if (value <= 0) {
                value = 1;
                input.val(1);
            }
            const priceInput = row.find('.pos_unit_price_inc_tax');
            const currentPrice = parseFloat(priceInput.val() || 0);
            const lineTotal = value * currentPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
            updateTotalTax();
            updateItemsAndQuantity();
            updateFinalTotal();
            return;
        }

        const priceInput = row.find('.pos_unit_price_inc_tax');
        const hasExistingDiscount = parseFloat(priceInput.data('current-discount') || 0) > 0;
        if (hasExistingDiscount) {
            let value = parseFloat(input.val().replace(/,/g, '')) || 0;
            if (value <= 0) {
                value = 1;
                input.val(1);
            }
            const currentPrice = parseFloat(priceInput.val() || 0);
            const lineTotal = value * currentPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
            updateTotalTax();
            updateItemsAndQuantity();
            updateFinalTotal();
            return;
        }

        let value = parseFloat(input.val().replace(/,/g, '')) || 0;

        if (value <= 0) {
            value = 1;
            input.val(1);
        }

        console.log(`New quantity for ${productName}: ${value}`);

        if (hasSerialNumber) {
            const availableQty = parseFloat(row.data('serial-number-available') || 0);
            const serialNumber = row.data('serial-number') || 'Unknown';

            if (availableQty <= 0) {
                const errorMsg = `Serial number ${serialNumber} has no available quantity`;
                input.val(0);
                showSerialNumberError(row, errorMsg);
                updateSerialNumberDisplay(row);
                updateTotalTax();
                updateFinalTotal();
                return;
            }

            if (value > availableQty) {
                const errorMsg = `Quantity cannot exceed ${availableQty} for serial number ${serialNumber}`;
                input.val(availableQty);
                showSerialNumberError(row, errorMsg);
                value = availableQty;
            } else {
                hideSerialNumberError(row);
            }

            updateSerialNumberDisplay(row);
        } else {
            hideSerialNumberError(row);
        }

        updateProductDiscount(row);
        updateTotalTax();
        updateItemsAndQuantity();
        updateFinalTotal();
    });

    $(document).on('keyup', '.quantity-input', function() {
        const row = $(this).closest('tr.product_row');

        const hasTransactionId = row.data('has-transaction-line') === 'true';
        if (hasTransactionId) {
            const input = $(this);
            let value = parseFloat(input.val().replace(/,/g, '')) || 0;
            if (value <= 0) {
                value = 1;
                input.val(1);
            }
            const priceInput = row.find('.pos_unit_price_inc_tax');
            const currentPrice = parseFloat(priceInput.val() || 0);
            const lineTotal = value * currentPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
            updateTotalTax();
            updateItemsAndQuantity();
            updateFinalTotal();
            return;
        }

        const priceInput = row.find('.pos_unit_price_inc_tax');
        const hasExistingDiscount = parseFloat(priceInput.data('current-discount') || 0) > 0;
        if (hasExistingDiscount) {
            const input = $(this);
            let value = parseFloat(input.val().replace(/,/g, '')) || 0;
            if (value <= 0) {
                value = 1;
                input.val(1);
            }
            const currentPrice = parseFloat(priceInput.val() || 0);
            const lineTotal = value * currentPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
            updateTotalTax();
            updateItemsAndQuantity();
            updateFinalTotal();
            return;
        }

        updateProductDiscount(row);
    });

// ✅ Sub-unit change - use unit price when available
$(document).on('change', '.sub_unit', function() {
    console.log('=== Sub-unit changed ===');
    const row = $(this).closest('tr.product_row');
    const selectedOption = $(this).find('option:selected');
    const multiplier = parseFloat(selectedOption.data('multiplier')) || 1;
    const unitName = selectedOption.data('unit_name') || '';
    const unitPrice = parseFloat(selectedOption.data('unit-price')) || 0;
    const useUnitPrice = unitPrice > 0;
    const hasPriceGroup = row.data('has-price-group') === 'true' || isPriceGroupEnabled();

    console.log(`Multiplier: ${multiplier}, Unit: ${unitName}`);
    console.log(`Unit Price: ${unitPrice}, Use Unit Price: ${useUnitPrice}`);
    console.log(`Has Price Group: ${hasPriceGroup}`);

    row.data('current-multiplier', multiplier);
    row.data('current-unit', unitName);
    row.find('.base_unit_multiplier').val(multiplier);

    const priceInput = row.find('.pos_unit_price_inc_tax');
    const hasTransactionId = row.data('has-transaction-line') === 'true';
    const hasExistingDiscount = parseFloat(priceInput.data('current-discount') || 0) > 0;

    // ✅ Only preserve price for existing rows OR when a discount is already applied.
    // Changing the unit is an explicit user action → re-price the row.
    if (hasTransactionId || hasExistingDiscount) {
        console.log(`Preserving price on sub-unit change (existing row or existing discount)`);
        const quantity = parseFloat(row.find('.quantity-input').val().replace(/,/g, '')) || 0;
        const currentPrice = parseFloat(priceInput.val() || 0);
        const lineTotal = quantity * currentPrice;
        row.find('.pos_line_total').val(lineTotal.toFixed(2));
        row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
        updateTotalTax();
        updateFinalTotal();
        return;
    }

    // ✅ Clear manual override since user explicitly changed the unit
    priceInput.data('manual-override', false);
    priceInput.data('current-discount', 0);
    priceInput.data('current-discount-type', 'fixed');
    row.find('.discount-info').hide();

    // ✅ Compute correct price (unit_price takes precedence over multiplier)
    const basePrice = parseFloat(priceInput.data('base-price') || 0);
    const originalPrice = parseFloat(priceInput.data('original-price') || 0);

    let newPrice;
    if (hasPriceGroup) {
        newPrice = originalPrice * multiplier;
        console.log(`Price group active: using original price ${originalPrice} × ${multiplier} = ${newPrice}`);
    } else if (useUnitPrice) {
        // ✅ USE UNIT PRICE FROM UNITS TABLE
        newPrice = unitPrice;
        console.log(`✅ Set price from unit: ${unitPrice}`);
    } else {
        newPrice = basePrice * multiplier;
        console.log(`Set price from multiplier: ${newPrice}`);
    }

    priceInput.val(newPrice.toFixed(2));

    const quantity = parseFloat(row.find('.quantity-input').val().replace(/,/g, '')) || 0;
    const lineTotal = quantity * newPrice;
    row.find('.pos_line_total').val(lineTotal.toFixed(2));
    row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

    updateDiscountRangesForRow(row, multiplier);
    updateProductDiscount(row);
    updateTotalTax();
    updateItemsAndQuantity();
    updateFinalTotal();
});

    // Listen for price group changes
    $(document).on('change', '#price_group', function() {
        console.log('=== Price group changed ===');
        const value = this.value;
        const hasPriceGroup = value && value !== '' && value !== '0';
        console.log(`Price group selected: ${value}, hasPriceGroup: ${hasPriceGroup}`);

        $('tr.product_row').each(function() {
            const row = $(this);
            const priceInput = row.find('.pos_unit_price_inc_tax');
            const originalPrice = parseFloat(priceInput.data('original-price') || 0);
            const multiplier = row.data('current-multiplier') || 1;
            const productName = row.data('product-name') || 'Unknown';

            const hasTransactionId = row.data('has-transaction-line') === 'true';
            if (hasTransactionId) {
                console.log(`Existing row detected for ${productName}, not resetting price on price group change`);
                return;
            }

            const hasExistingDiscount = parseFloat(priceInput.data('current-discount') || 0) > 0;
            if (hasExistingDiscount) {
                console.log(`Existing discount detected for ${productName}, not resetting price on price group change`);
                return;
            }

            if (priceInput.data('manual-override') === true) {
                console.log(`Manual override active for ${productName}, not resetting price`);
                return;
            }

            const subUnitSelect = row.find('.sub_unit:visible');
            const selectedOption = subUnitSelect.find('option:selected');
            const unitPrice = parseFloat(selectedOption.data('unit-price')) || 0;
            const useUnitPrice = unitPrice > 0;

            let newPrice;
            if (hasPriceGroup) {
                newPrice = originalPrice * multiplier;
                console.log(`Price group selected: setting ${productName} to ${newPrice} (${originalPrice} × ${multiplier})`);
            } else if (useUnitPrice) {
                // ✅ USE UNIT PRICE
                newPrice = unitPrice;
                console.log(`No price group: setting ${productName} to unit price ${newPrice}`);
            } else {
                newPrice = originalPrice * multiplier;
                console.log(`No price group, no unit price: setting ${productName} to ${newPrice}`);
            }

            priceInput.val(newPrice.toFixed(2));

            const quantity = parseFloat(row.find('.quantity-input').val().replace(/,/g, '')) || 0;
            const lineTotal = quantity * newPrice;
            row.find('.pos_line_total').val(lineTotal.toFixed(2));
            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));

            row.data('has-price-group', hasPriceGroup);
        });

        updateTotalTax();
        updateItemsAndQuantity();
        updateFinalTotal();
    });

    // Discount checkbox toggle
    $(document).on('change', '#enable_volume_discount', function() {
        console.log('=== Discount checkbox toggled ===');
        console.log(`Discount enabled: ${this.checked}`);

        if (!this.checked) {
            resetAllProductPrices();
        } else {
            $('tr.product_row').each(function() {
                const row = $(this);
                const discountAllowed = (row.data('discount-allowed') === true || row.data('discount-allowed') === 'true') ||
                                       (row.data('has-global-discount') === 'true');

                if (discountAllowed) {
                    updateProductDiscount(row);
                }
            });
            updateTotalTax();
            updateItemsAndQuantity();
            updateFinalTotal();
        }
    });

    // Row removal
    $(document).on('click', '.pos_remove_row', function() {
        console.log('Row removed');
        setTimeout(function() {
            updateItemsAndQuantity();
            updateTotalTax();
            updateFinalTotal();
        }, 100);
    });

    $(document).on('change', '#discount_amount, #discount_type', function() {
        updateFinalTotal();
    });

    $(document).on('change', '#shipping_charges', function() {
        updateFinalTotal();
    });

    $(document).on('click', '.service_modal_btn', function() {
        setTimeout(function() {
            updateFinalTotal();
        }, 500);
    });

    $(document).on('change', '#packing_charge_text', function() {
        updateFinalTotal();
    });

    $(document).on('click', '#saveDiscountBtn', function() {
        setTimeout(function() {
            updateFinalTotal();
        }, 200);
    });

    $(document).on('click', '#saveShippingBtn', function() {
        setTimeout(function() {
            updateFinalTotal();
        }, 200);
    });

    // ============ TAX STATUS TOGGLE ============

    let taxStatus = '{{ session()->get('tax_status', 'active') }}';

    $('#saveTaxStatus').on('click', function() {
        const selectedStatus = $('input[name="tax_status_modal"]:checked').val();

        if (!selectedStatus) {
            toastr.warning('Please select a tax status');
            return;
        }

        if (selectedStatus === taxStatus) {
            $('#taxToggleModal').modal('hide');
            return;
        }

        const $btn = $(this);
        $btn.prop('disabled', true).html('<i class="fas fa-spinner fa-spin"></i> Updating...');

        $.ajax({
            url: '{{ route("toggle.tax.status") }}',
            method: 'POST',
            data: {
                _token: '{{ csrf_token() }}',
                tax_status: selectedStatus
            },
            success: function(response) {
                if (response.success) {
                    taxStatus = response.tax_status;

                    if (taxStatus === 'disabled') {
                        $('#total_order_tax, #total_order_tax1').val('0.00');
                        $('.tax-amount-cell input').val('0.00');
                        $('.tax_id').prop('disabled', true);
                        $('.pos_unit_price_inc_tax').prop('readonly', true);

                        $('tr.product_row').each(function() {
                            const row = $(this);
                            const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
                            const priceInput = row.find('.pos_unit_price_inc_tax');
                            const priceWithoutTax = parseFloat(priceInput.data('default-sell-price') || 0);
                            const lineTotal = quantity * priceWithoutTax;

                            priceInput.val(priceWithoutTax.toFixed(2));
                            row.find('.pos_line_total').val(lineTotal.toFixed(2));
                            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
                        });
                    } else {
                        $('#total_order_tax, #total_order_tax1').val('0.00');
                        $('.tax-amount-cell input').val('0.00');
                        $('.tax_id').prop('disabled', false);
                        $('.pos_unit_price_inc_tax').prop('readonly', false);

                        $('tr.product_row').each(function() {
                            const row = $(this);
                            const quantity = parseFloat((row.find('.quantity-input').val() || '0').replace(/,/g, '')) || 0;
                            const priceInput = row.find('.pos_unit_price_inc_tax');
                            const originalPrice = parseFloat(priceInput.data('original-price') || 0);
                            const lineTotal = quantity * originalPrice;

                            priceInput.val(originalPrice.toFixed(2));
                            row.find('.pos_line_total').val(lineTotal.toFixed(2));
                            row.find('.pos_line_total_text').text(__currency_trans_from_en(lineTotal, false));
                        });

                        if ($('tr.product_row').length > 0) {
                            updateTotalTax();
                        }
                    }

                    updateFinalTotal();

                    if (taxStatus === 'active') {
                        $('.tax-toggle-badge')
                            .html('<i class="fas fa-check-circle"></i> Active')
                            .css('background-color', '#28a745')
                            .removeClass('bg-danger')
                            .addClass('bg-success');
                    } else {
                        $('.tax-toggle-badge')
                            .html('<i class="fas fa-times-circle"></i> Disabled')
                            .css('background-color', '#dc3545')
                            .removeClass('bg-success')
                            .addClass('bg-danger');
                    }

                    $('#taxToggleModal').modal('hide');
                    toastr.success('Tax status updated to ' + taxStatus);
                }
            },
            error: function(xhr) {
                let errorMsg = 'Error updating tax status';
                if (xhr.responseJSON && xhr.responseJSON.message) {
                    errorMsg = xhr.responseJSON.message;
                }
                toastr.error(errorMsg);
                console.error(xhr.responseText);
            },
            complete: function() {
                $btn.prop('disabled', false).html('<i class="fas fa-save"></i> Update Tax Status');
            }
        });
    });

    $('#taxToggleModal').on('hidden.bs.modal', function() {
        $('input[name="tax_status_modal"][value="' + taxStatus + '"]').prop('checked', true);
    });

    $(document).on('change', '.tax_id', function() {
        if (taxStatus === 'active') {
            updateTotalTax();
        }
    });

    // ============ SERIAL NUMBER QUANTITY VALIDATION ============

    function validateSerialNumberQuantity(input) {
        const row = input.closest('tr.product_row');
        const hasSerialNumber = row.data('has-serial-number') === 'true';

        if (!hasSerialNumber) {
            return true;
        }

        const availableQty = parseFloat(row.data('serial-number-available') || 0);
        const inputValue = parseFloat(input.val().replace(/,/g, '')) || 0;
        const serialNumber = row.data('serial-number') || 'Unknown';

        if (availableQty <= 0) {
            const errorMsg = `Serial number ${serialNumber} has no available quantity (${availableQty} available)`;
            input.val('0');
            showSerialNumberError(row, errorMsg);
            return false;
        }

        if (inputValue > availableQty) {
            const errorMsg = `Quantity cannot exceed ${availableQty} for serial number ${serialNumber}`;
            input.val(availableQty);
            showSerialNumberError(row, errorMsg);
            return false;
        }

        hideSerialNumberError(row);
        return true;
    }

    function showSerialNumberError(row, message) {
        let errorDiv = row.find('.serial-number-error');
        if (errorDiv.length === 0) {
            errorDiv = $('<div class="serial-number-error text-danger" style="font-size: 12px; margin-top: 4px;"></div>');
            row.find('.quantity-input').after(errorDiv);
        }
        errorDiv.html('<i class="fa fa-exclamation-circle"></i> ' + message);
        row.find('.quantity-input').addClass('is-invalid');
        row.addClass('has-serial-error');
    }

    function hideSerialNumberError(row) {
        row.find('.serial-number-error').remove();
        row.find('.quantity-input').removeClass('is-invalid');
        row.removeClass('has-serial-error');
    }

    function updateSerialNumberDisplay(row) {
        const hasSerialNumber = row.data('has-serial-number') === 'true';
        if (!hasSerialNumber) return;

        const availableQty = parseFloat(row.data('serial-number-available') || 0);
        const input = row.find('.quantity-input');
        const currentValue = parseFloat(input.val().replace(/,/g, '')) || 0;
        const remainingQty = Math.max(0, availableQty - currentValue);

        const qtyDisplay = row.find('.serial-available-qty');
        if (qtyDisplay.length) {
            qtyDisplay.text(remainingQty);
            if (remainingQty <= 0) {
                qtyDisplay.css('color', '#dc3545');
            } else if (remainingQty <= availableQty * 0.2) {
                qtyDisplay.css('color', '#ffc107');
            } else {
                qtyDisplay.css('color', '#28a745');
            }
        }

        const maxDisplay = row.find('.serial-max-qty-display');
        if (maxDisplay.length) {
            maxDisplay.text(availableQty);
        }
    }

    // ============ QUANTITY BUTTON CLICK HANDLING ============

    $(document).on('click', '.quantity-up', function() {
        const row = $(this).closest('tr.product_row');
        const input = row.find('.quantity-input');
        const hasSerialNumber = row.data('has-serial-number') === 'true';
        const maxQty = hasSerialNumber ?
            parseFloat(row.data('serial-number-available') || 0) :
            parseFloat(input.data('rule-max-value') || 999999);

        let currentVal = parseFloat(input.val().replace(/,/g, '')) || 0;
        let newVal = currentVal;

        if (newVal > maxQty) {
            newVal = maxQty;
            if (hasSerialNumber) {
                const serialNumber = row.data('serial-number') || 'Unknown';
                const errorMsg = `Maximum quantity for serial number ${serialNumber} is ${maxQty}`;
                showSerialNumberError(row, errorMsg);
            }
        } else {
            if (hasSerialNumber) {
                hideSerialNumberError(row);
            }
        }

        input.val(formatQuantity(newVal)).trigger('change');
    });

    $(document).on('click', '.quantity-down', function() {
        const row = $(this).closest('tr.product_row');
        const input = row.find('.quantity-input');
        const minVal = 1;

        let currentVal = parseFloat(input.val().replace(/,/g, '')) || 0;
        let newVal = Math.max(minVal, currentVal);

        input.val(formatQuantity(newVal)).trigger('change');
    });

    function formatQuantity(value) {
        const precision = 2;
        return Number(value).toFixed(precision);
    }

    // ============ INITIALIZATION ============

    console.log('=== INITIALIZATION START ===');

    $('#total_order_tax, #total_order_tax1').val('0.00');

    $('tr.product_row').each(function() {
        const row = $(this);
        const info = resolveUnitPrice(row);

        row.data('current-multiplier', info.multiplier);
        row.data('current-unit', info.unitName);
        row.find('.base_unit_multiplier').val(info.multiplier);

        const priceInput = row.find('.pos_unit_price_inc_tax');
        const basePrice = parseFloat(priceInput.data('base-price') || 0);
        const originalPrice = parseFloat(priceInput.data('original-price') || 0);

        const hasTransactionId = row.data('has-transaction-line') === 'true';
        if (hasTransactionId) {
            console.log(`Existing row detected for ${row.data('product-name')}, preserving price on init`);
            return;
        }

        const hasExistingDiscount = parseFloat(priceInput.data('current-discount') || 0) > 0;
        if (hasExistingDiscount) {
            console.log(`Existing discount detected for ${row.data('product-name')}, preserving price on init`);
            return;
        }

        if (priceInput.data('manual-override') === true) {
            console.log(`Manual override active for ${row.data('product-name')}, skipping initialization`);
            return;
        }

        // ✅ Compute initial price correctly
        let initialPrice;
        if (info.hasPriceGroup) {
            initialPrice = originalPrice * info.multiplier;
            console.log(`Price group active: initializing ${row.data('product-name')} with ${originalPrice} × ${info.multiplier} = ${initialPrice}`);
        } else if (info.useUnitPrice) {
            // ✅ USE UNIT PRICE FROM UNITS TABLE
            initialPrice = info.unitPrice;
            console.log(`✅ Initialized ${row.data('product-name')} with unit price: ${info.unitPrice}`);
        } else {
            initialPrice = basePrice * info.multiplier;
            console.log(`Initialized ${row.data('product-name')} with multiplier: ${info.multiplier}, unit: ${info.unitName}, price: ${initialPrice}`);
        }

        priceInput.val(initialPrice.toFixed(2));
    });

    // Preload discount ranges for products that have discount allowed
    $('tr.product_row[data-discount-allowed="true"]').each(function() {
        const row = $(this);
        const priceInput = row.find('.pos_unit_price_inc_tax');

        const hasTransactionId = row.data('has-transaction-line') === 'true';
        if (hasTransactionId) {
            console.log(`Existing row detected, skipping discount preload`);
            return;
        }

        const hasExistingDiscount = parseFloat(priceInput.data('current-discount') || 0) > 0;
        if (hasExistingDiscount) {
            console.log(`Existing discount detected for ${row.data('product-name')}, skipping discount preload`);
            return;
        }

        if (priceInput.data('manual-override') === true) {
            console.log(`Manual override active for ${row.data('product-name')}, skipping discount preload`);
            return;
        }

        const productId = row.data('product-id');
        const productName = row.data('product-name') || 'Unknown';
        const multiplier = row.data('current-multiplier') || 1;

        console.log(`Initializing discounts for ${productName} (ID: ${productId}) with multiplier ${multiplier}`);

        let discountRanges = row.data('discount-ranges');

        if (typeof discountRanges === 'string') {
            try {
                discountRanges = JSON.parse(discountRanges);
                row.data('discount-ranges', discountRanges);
            } catch(e) {
                console.error(`Failed to parse initial discount ranges for ${productName}:`, e);
                discountRanges = null;
            }
        }

        if (!discountRanges || (Array.isArray(discountRanges) && discountRanges.length === 0)) {
            console.log(`No discount ranges in data attribute, fetching for ${productName}...`);
            $.ajax({
                url: '/get-product-discounts',
                method: 'GET',
                data: {
                    product_id: productId,
                    multiplier: multiplier
                },
                success: function(response) {
                    if (response.success && response.discounts && response.discounts.length > 0) {
                        row.data('discount-ranges', response.discounts);
                        setTimeout(function() {
                            if (priceInput.data('manual-override') !== true) {
                                updateProductDiscount(row);
                            }
                        }, 100);
                    } else {
                        row.data('discount-ranges', []);
                    }
                },
                error: function(xhr, status, error) {
                    console.error(`Failed to fetch discounts for ${productName}:`, error);
                    row.data('discount-ranges', []);
                }
            });
        } else if (Array.isArray(discountRanges) && discountRanges.length > 0) {
            console.log(`Using data attribute discount ranges for ${productName}:`, discountRanges);
            setTimeout(function() {
                if (priceInput.data('manual-override') !== true) {
                    updateProductDiscount(row);
                }
            }, 100);
        }
    });

    updateItemsAndQuantity();

    if (taxStatus === 'active' && $('tr.product_row').length > 0) {
        updateTotalTax();
    }

    updateFinalTotal();

    console.log('=== INITIALIZATION COMPLETE ===');

    setInterval(function() {
        updateItemsAndQuantity();
        if (taxStatus === 'active') {
            updateRunningTotalTax();
        }
        updateFinalTotal();
    }, 2000);

});
</script>