Setup search in test table

1 files changed, 10 insertions, 0 deletions

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)
+        ));
+    }
 }