CODEWITHSUNDEEP
laravellaravel-5laravel-permission
Sead Lab
Sead Lab

Reputation: 211

Laravel Spatie Call to undefined method Illuminate\Database\Query\Builder::assignRole()

Trying to do assignRole() to many users, but it show me Call to undefined method Illuminate\Database\Query\Builder::assignRole(). Is this spatie laravel bug?

$get_username = \App\Applicant::select('username')->whereIn('id', $ids);
        $updateUser = \App\User::whereIn('username', $get_username);
        $updateUser->assignRole('Applicant');
        $updateUser->save();

Any solution for bulk assignRole() in this case?

Upvotes: 0

Views: 2282

Answers (1)

Repox
Repox

Reputation: 15476

$get_username = \App\Applicant::select('username')->whereIn('id', $ids);

This is an incomplete query via the QueryBuilder. As well as the second line.

When utilizing the QueryBuilder you need to finish of your queries with the get() method to get a collection to iterate over.

The correct execution would like like this:

$get_username = \App\Applicant::select('username')->whereIn('id', $ids)->get();

Without knowing the exact result of this, it looks like you'd like to retrieve a collection of usernames, that you'd like to get the User model from.

You could do something like the following (untested) for bulk updating.:

$users = User::whereIn('username', function($query) use ($ids) {
    $query->select('username')
    ->from('applicants')->whereIn('id', $ids);
})->get();

foreach($users as $user) {
    $user->assignRole('Applicant');
    $user->save();
}

Upvotes: 2

Related Questions