Copyright© M&AΫϥυ 8
2.ΫΤϦείʔϓΛ͏
ModelͰҎԼͷΑ͏ʹఆٛ͠·͢ɻ
namespace App\Models;
use Illuminate\Database\Eloquent\Model as EloquentModel;
/**
* This class contains shared setup, properties and methods
* of all application models
*
*/
class Model extends EloquentModel
{
public function scopeWhereLike($query, string $attribute, string $keyword, int $position = 0)
{
$keyword = addcslashes($keyword, '\_%');
$condition = [
1 => "{$keyword}%",
-1 => "%{$keyword}",
][$position] ?? "%{$keyword}%";
return $query->where($attribute, 'LIKE', $condition);
}
public function scopeOrWhereLike($query, string $attribute, string $keyword, int $position = 0)
{
$keyword = addcslashes($keyword, '\_%');
$condition = [
1 => "{$keyword}%",
-1 => "%{$keyword}",
][$position] ?? "%{$keyword}%";
return $query->orWhere($attribute, 'LIKE', $condition);
}