| Server IP : 78.140.185.180 / Your IP : 18.226.181.89 Web Server : LiteSpeed System : Linux cpanel13.v.fozzy.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : builderbox ( 1072) PHP Version : 7.3.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /proc/self/root/proc/thread-self/root/home/builderbox/www/common/Search/ |
Upload File : |
<?php
namespace Common\Search;
use Illuminate\Database\Eloquent\Builder;
trait Searchable
{
use \Laravel\Scout\Searchable;
public function scopeMysqlSearch(Builder $builder, string $query): Builder
{
$searchableFields = [];
$searchableRelations = [];
foreach ((new static())->toSearchableArray() as $field => $value) {
if (!in_array($field, static::filterableFields())) {
if (method_exists(self::class, $field)) {
$searchableRelations[] = $field;
} else {
$searchableFields[] = $field;
}
}
}
$builder->matches($searchableFields, $query);
foreach ($searchableRelations as $relation) {
$builder->orWhereHas($relation, function (Builder $q) use ($query) {
$q->mysqlSearch($query);
});
}
return $builder;
}
public function scopeMatches(
Builder $builder,
array $columns,
string $value
): Builder {
$mode = config('common.site.scout_mysql_mode');
if ($mode === 'fulltext' && strlen($value) >= 3) {
if (is_null($builder->getQuery()->columns)) {
$builder->select($this->qualifyColumn('*'));
}
$colString = implode(',', $columns);
$builder->selectRaw(
"MATCH($colString) AGAINST(? IN NATURAL LANGUAGE MODE) AS relevance",
[$value],
);
$builder->whereRaw("MATCH($colString) AGAINST(?)", [$value]);
} else {
if ($mode === 'basic') {
$value = "$value%";
} else {
$value = "%$value%";
}
$colCount = count($columns);
foreach ($columns as $key => $column) {
$bool = $colCount === $key - 1 || $key === 0 ? 'and' : 'or';
$builder->where($column, 'like', $value, $bool);
}
}
return $builder;
}
public function getSearchableValues(): array
{
$searchableValues = [];
foreach ($this->toSearchableArray() as $key => $value) {
if (!in_array($key, self::filterableFields())) {
$searchableValues[] = $value;
}
}
return $searchableValues;
}
public static function getSearchableKeys($skipRelations = false): array
{
$searchableKeys = [];
foreach ((new static())->toSearchableArray() as $key => $value) {
if (
!in_array($key, static::filterableFields()) &&
(!$skipRelations || !method_exists(self::class, $key))
) {
$searchableKeys[] = $key;
}
}
return $searchableKeys;
}
}