Laravel Eloquent Model Builder Macro - Search

search_builder_macro.php

 Builder::macro('search', function ($attributes, $searchTerm, $compact = false): Builder {
            $this->where(function (Builder $query) use ($compact, $attributes, $searchTerm): void {
                if ($compact) {
                    $joinedAttributes = '`'.implode('`, " " ,`', $attributes).'`';
                    $query->orWhereRaw('upper('.\DB::raw("concat({$joinedAttributes})").') LIKE ?', ["%{$searchTerm}%"]);
                } else {
                    foreach ($attributes as $attribute) {
                        $query->when(
                            str_contains($attribute, '.'),
                            function (Builder $query) use ($attribute, $searchTerm): void {
                                [$relationName, $relationAttribute] = explode('.', $attribute);

                                $query->orHasByNonDependentSubquery($relationName, function (Builder $query) use ($relationAttribute, $searchTerm): void {
                                    $query->whereRaw('upper('.$relationAttribute.') LIKE ?', ["%{$searchTerm}%"]);
                                });
                            },
                            function (Builder $query) use ($attribute, $searchTerm): void {
                                $query->orWhereRaw('upper('.$attribute.') LIKE ?', ["%{$searchTerm}%"]);
                            }
                        );
                    }
                }
            });

            return $this;
        });

Important Note: The macro has package dependency.

Package: https://github.com/mpyw/eloquent-has-by-non-dependent-subquery