with('supplier') ->select('supplier_id','offer')->orderBy('offer','asc')->where('procurement_id',$procurement_id)->first(); return $procurementQuotation; } public function pushEnquiryToSupplier($procurement_id){ $procurement=Procurement::query()->find($procurement_id); $procurement->loadMissing(['ownerMaterial.material.supplier']); if (!empty($procurement->ownerMaterial->material->supplier))$suppliers=$procurement->ownerMaterial->material->supplier; foreach ($suppliers as $supplier){ $procurementQuotation= new ProcurementQuotation([ 'procurement_id'=>$procurement_id, 'supplier_id'=>$supplier->id, ]); $procurementQuotation->save(); //TODO 推送给指定耗材类型供应商 } } }