在 Laravel 中制作可重用的模型搜索：高效设置和最佳实践

<?php

namespace app\traits;

trait searchable
{
    public function scopesearch($query, array $filters)
    {
        foreach ($filters as $filter => $value) {
            if (method_exists($this, $method = 'filter' . ucfirst($filter))) {
                $this->$method($query, $value);
            } else {
                $query->where($filter, 'like', '%' . $value . '%');
            }
        }

        return $query;
    }
}

<?php

namespace app\models;

use illuminate\database\eloquent\model;
use app\traits\searchable;

class user extends model
{
    use searchable;

    // define custom filters if needed
    public function filterrole($query, $value)
    {
        return $query->where('role', $value);
    }
}

$filters = [
    'name' => 'john',
    'email' => 'example@example.com',
    'role' => 'admin'
];

$users = user::search($filters)->get();

php artisan make:migration add_indexes_to_users_table

schema::table('users', function (blueprint $table) {
    $table->index('name');
    $table->index('email');
    $table->index('role');
});

$users = user::with('roles')->search($filters)->get();

$users = User::search($filters)->paginate(20);