Laravel 5 - 限制来自雄辩的all（）函数的记录

I have an AccountType model which is related to the user table.

public function users()
    {
        return $this->hasMany('App\User','account_type_id');
    }

We have built the website based on the AccountType with data like (Normal User, Editor, Admin) and now we want to add a new type as SuperAdmin which is for the site admin. But we don't want that account type to be displayed where the AccountType::all() code is called and also in the users search result. We have used the all() function in most of the places. So we don't want to change it everywhere. Is there any way to override the default function only for this AccountType model?

The best way, (not the easiest) is to create a global scope. Like the SoftDelete trait which removes all deleted entities from your queries.

You add a global scope to AccountType to permenently remove SuperAdmin from all of your queries.

Ex: AccountType::all() will return ['Normal User', 'Editor']

And

AccountType::withSuperAdmin()->all() will return the previous array plus the SuperAmin type.

See : http://softonsofa.com/laravel-5-eloquent-global-scope-how-to/

You don't have to use the Sofa Package to make this works.

Open the SoftDelete trait and try to understand why this does.

Add this method to AccountType model. This method will override Model::all() -- default method.

public static function all($columns = array('*'))
    {
        $columns = is_array($columns) ? $columns : func_get_args();

        $instance = new static;

        return $instance->newQuery()->where('account_type', '!=', 'SuperAdmin')->get($columns);
    }

The easiest way is to just put SuperAdmin id in your config and overwrite the all() method in AccountType model:

public static function all($columns = ['*'])
{
  $columns = is_array($columns) ? $columns : func_get_args();
  return static::where('id', '<>', Config::get('app.super_admin_id')->get($columns);
}

If you want to exclude SuperAdmin from all SELECT queries that your application does, you could also check Eloquent's global scopes - an example is the SoftDeletes trait you can read about here: http://laravel.com/docs/5.1/eloquent#soft-deleting. It will require much more code and would also work globally so you'd need to update how you fetch account types where you want SuperAdmin to be returned.