From 08ce4949f964790a77f580cb19ba40818fa316ad Mon Sep 17 00:00:00 2001 From: Sam Light Date: Sun, 19 Jan 2025 00:43:21 +0000 Subject: Setup search in test table --- workbench/app/Models/Product.php | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'workbench/app/Models/Product.php') diff --git a/workbench/app/Models/Product.php b/workbench/app/Models/Product.php index c51569c..11e88e5 100644 --- a/workbench/app/Models/Product.php +++ b/workbench/app/Models/Product.php @@ -4,6 +4,7 @@ namespace Workbench\App\Models; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Database\Eloquent\Model; +use Illuminate\Database\Eloquent\Builder; class Product extends Model { @@ -13,4 +14,13 @@ class Product extends Model { return \Workbench\Database\Factories\ProductFactory::new(); } + + public function scopeSearch(Builder $q, string $s): void + { + $s = "%{$s}%"; + $q->where(fn(Builder $q) => ( + $q->orWhere('name', 'like', $s) + ->orWhere('description', 'like', $s) + )); + } } -- cgit v1.2.3