@php $item = $getRecord(); $orderId = $item->order_id; $itemId = $item->order_item_id; $supplierId = $item->supplier_id; $currentStatus = $item->current_status; // Check if item has "Needs Order" status // Get the actual status name to check $statusObj = \App\Models\ItemsStatus::find($currentStatus); $statusName = $statusObj ? $statusObj->status : ''; $isNeedsOrder = (stripos($statusName, 'needs order') !== false) || ($currentStatus == 1); // Debug: Log the status \Log::info('Item ' . $itemId . ' status: ' . $currentStatus . ' (' . $statusName . '), isNeedsOrder: ' . ($isNeedsOrder ? 'true' : 'false')); // Check if supplier is assigned (hide KSI-GA with supplier_id 73) $supplierBtn = ($supplierId && $supplierId != 73) ? "fi-btn-color-success" : ""; $supplierName = ''; if($supplierId && $supplierId != 73) { $supplier = \App\Models\Supplier::find($supplierId); $supplierName = $supplier ? $supplier->code : ''; } // Check for additional costs $additionalBtn = ""; $additionalCosts = \DB::table('orders_additional_costs') ->where('item_id', $itemId) ->where('order_id', $orderId) ->whereNotIn('cost_type', ['Supplier Credit', 'Carrier Credit']) ->get(); if($additionalCosts->count() > 0) { $additionalBtn = "fi-btn-color-success"; } // Check for supplier credits $supplierCreditBtn = ""; $supplierCredits = \DB::table('orders_additional_costs') ->where('item_id', $itemId) ->where('order_id', $orderId) ->where('cost_type', 'Supplier Credit') ->get(); if($supplierCredits->count() > 0) { $supplierCreditBtn = "fi-btn-color-success"; } // Check for carrier credits $carrierCreditBtn = ""; $carrierCredits = \DB::table('orders_additional_costs') ->where('item_id', $itemId) ->where('order_id', $orderId) ->where('cost_type', 'Carrier Credit') ->get(); if($carrierCredits->count() > 0) { $carrierCreditBtn = "fi-btn-color-success"; } // Calculate sum of costs for display $additionalCostSum = \DB::table('orders_additional_costs') ->where('item_id', $itemId) ->where('order_id', $orderId) ->whereNotIn('cost_type', ['Supplier Credit', 'Carrier Credit']) ->sum('cost'); $supplierCreditSum = \DB::table('orders_additional_costs') ->where('item_id', $itemId) ->where('order_id', $orderId) ->where('cost_type', 'Supplier Credit') ->sum('cost'); $carrierCreditSum = \DB::table('orders_additional_costs') ->where('item_id', $itemId) ->where('order_id', $orderId) ->where('cost_type', 'Carrier Credit') ->sum('cost'); @endphp
Additional Cost:
${{ number_format($additionalCostSum, 2) }}
Supplier Credit:
${{ number_format($supplierCreditSum, 2) }}
Carrier Credit:
${{ number_format($carrierCreditSum, 2) }}
@php $netImpact = $additionalCostSum - $supplierCreditSum - $carrierCreditSum; @endphp @if($additionalCostSum > 0 || $supplierCreditSum > 0 || $carrierCreditSum > 0)
Net:
${{ number_format(abs($netImpact), 2) }}
@endif
@if($isNeedsOrder)
Show Log
@endif @if($supplierName)
{{ $supplierName }}
@else @endif {{-- Fulfillment Order badge disabled as requested @if($item->fulfillment_order_id)
Fulfillment Order #{{ $item->fulfillment_order_id }}
@endif --}} {{-- Core Refund badge - shown when item has a core charge --}} @if($item->core_charge && $item->core_charge > 0)
Core Refund ${{ number_format($item->core_charge, 2) }}
@endif