/PHP/Laravel/Laravel get all users except role spatie

Laravel get all users except role spatie

You can make 2 querys to get both groups of users that you want. I mean:

1) Users who dont have any role.

User::whereDoesntHave('roles')->get();

2) Users have any role, but not admin (from Adam Kozlowski answer)

$this->users()->whereHas('roles', function ($query) {
    $query->where('name','!=', 'admin');
});

Similar codes

0 vote333 views1 answer
Laravel lazy loading
PHP Laravel
24 votes379 views2 answers
How to use join in laravel 5.4
PHP Laravel
1 vote405 views1 answer
Laravel use references in other tables
PHP Laravel
1 vote368 views1 answer
Laravel string builder
PHP Laravel
0 vote394 views1 answer
Convert time to 24 hour format laravel
PHP Laravel
0 vote380 views1 answer
Laravel form old value array
PHP Laravel
0 vote348 views1 answer
Laravel Upsert always inserting
PHP Laravel
1 vote360 views2 answers
Scheduling in laravel in custom cron
PHP Laravel
31 votes343 views2 answers
Laravel sample controller
PHP Laravel
0 vote334 views1 answer
Laravel blade check if yielded content exists
PHP Laravel