where(function ($q) use ($keyword) { $q->where('name', 'like', "%$keyword%") ->orWhere('unit', 'like', "%$keyword%"); }); } public function purchaseOrder(){ return $this->belongsTo(PurchaseOrder::class); } public function vendorProduct() { return $this->belongsTo(VendorProduct::class, 'vendor_product_id', 'id'); } public function supplier() { return $this->belongsTo(Supplier::class); } public function purchaseOrderVendorDetails() { return $this->hasMany(PurchaseOrderVendorDetail::class); } }