@php
    $item = $getRecord();
    $orderId = $item->order_id ?? 0;
    $itemId = $item->order_item_id ?? 0;
    
    // Calculate sum of additional costs (excluding credits)
    $additionalCostSum = \DB::table('orders_additional_costs')
        ->where('item_id', $itemId)
        ->where('order_id', $orderId)
        ->whereNotIn('cost_type', ['Supplier Credit', 'Carrier Credit'])
        ->sum('cost');
    
    // Calculate sum of supplier credits
    $supplierCreditSum = \DB::table('orders_additional_costs')
        ->where('item_id', $itemId)
        ->where('order_id', $orderId)
        ->where('cost_type', 'Supplier Credit')
        ->sum('cost');
    
    // Calculate sum of carrier credits
    $carrierCreditSum = \DB::table('orders_additional_costs')
        ->where('item_id', $itemId)
        ->where('order_id', $orderId)
        ->where('cost_type', 'Carrier Credit')
        ->sum('cost');
    
    // Get count of each type for tooltip
    $additionalCostCount = \DB::table('orders_additional_costs')
        ->where('item_id', $itemId)
        ->where('order_id', $orderId)
        ->whereNotIn('cost_type', ['Supplier Credit', 'Carrier Credit'])
        ->count();
    
    $supplierCreditCount = \DB::table('orders_additional_costs')
        ->where('item_id', $itemId)
        ->where('order_id', $orderId)
        ->where('cost_type', 'Supplier Credit')
        ->count();
    
    $carrierCreditCount = \DB::table('orders_additional_costs')
        ->where('item_id', $itemId)
        ->where('order_id', $orderId)
        ->where('cost_type', 'Carrier Credit')
        ->count();
@endphp

<div class="item-costs-column" data-item-id="{{ $itemId }}" style="display: flex; flex-direction: column; gap: 4px; min-width: 100px;">
    <!-- Additional Cost -->
    <div style="display: flex; flex-direction: column; align-items: start;">
        <span style="font-size: 10px; color: #666; font-weight: 500;">Additional Cost:</span>
        <span class="cost-value {{ $additionalCostSum > 0 ? 'text-danger' : 'text-muted' }}" 
              style="font-size: 13px; font-weight: {{ $additionalCostSum > 0 ? '600' : '400' }}; color: {{ $additionalCostSum > 0 ? '#dc3545' : '#999' }};"
              @if($additionalCostCount > 1)
              title="{{ $additionalCostCount }} entries"
              @endif>
            ${{ number_format($additionalCostSum, 2) }}
        </span>
    </div>
    
    <!-- Supplier Credit -->
    <div style="display: flex; flex-direction: column; align-items: start;">
        <span style="font-size: 10px; color: #666; font-weight: 500;">Supplier Credit:</span>
        <span class="cost-value {{ $supplierCreditSum > 0 ? 'text-success' : 'text-muted' }}" 
              style="font-size: 13px; font-weight: {{ $supplierCreditSum > 0 ? '600' : '400' }}; color: {{ $supplierCreditSum > 0 ? '#28a745' : '#999' }};"
              @if($supplierCreditCount > 1)
              title="{{ $supplierCreditCount }} entries"
              @endif>
            ${{ number_format($supplierCreditSum, 2) }}
        </span>
    </div>
    
    <!-- Carrier Credit -->
    <div style="display: flex; flex-direction: column; align-items: start;">
        <span style="font-size: 10px; color: #666; font-weight: 500;">Carrier Credit:</span>
        <span class="cost-value {{ $carrierCreditSum > 0 ? 'text-success' : 'text-muted' }}" 
              style="font-size: 13px; font-weight: {{ $carrierCreditSum > 0 ? '600' : '400' }}; color: {{ $carrierCreditSum > 0 ? '#28a745' : '#999' }};"
              @if($carrierCreditCount > 1)
              title="{{ $carrierCreditCount }} entries"
              @endif>
            ${{ number_format($carrierCreditSum, 2) }}
        </span>
    </div>
    
    <!-- Net Impact (optional - shows the total financial impact) -->
    @php
        $netImpact = $additionalCostSum - $supplierCreditSum - $carrierCreditSum;
    @endphp
    @if($additionalCostSum > 0 || $supplierCreditSum > 0 || $carrierCreditSum > 0)
        <div style="border-top: 1px solid #dee2e6; padding-top: 4px; margin-top: 4px;">
            <span style="font-size: 10px; color: #666; font-weight: 500;">Net Impact:</span>
            <span class="cost-value {{ $netImpact > 0 ? 'text-danger' : ($netImpact < 0 ? 'text-success' : 'text-muted') }}" 
                  style="font-size: 13px; font-weight: 700; color: {{ $netImpact > 0 ? '#dc3545' : ($netImpact < 0 ? '#28a745' : '#999') }};">
                ${{ number_format(abs($netImpact), 2) }}
                @if($netImpact != 0)
                    {{ $netImpact > 0 ? '↑' : '↓' }}
                @endif
            </span>
        </div>
    @endif
</div>

<style>
    .item-costs-column .cost-value {
        cursor: pointer;
        transition: all 0.2s;
    }
    
    .item-costs-column .cost-value:hover {
        text-decoration: underline;
    }
    
    /* Dark mode support */
    .dark .item-costs-column span {
        color: #cbd5e0 !important;
    }
    
    .dark .item-costs-column .text-danger {
        color: #fc8181 !important;
    }
    
    .dark .item-costs-column .text-success {
        color: #68d391 !important;
    }
    
    .dark .item-costs-column .text-muted {
        color: #718096 !important;
    }
</style>