@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