How to get a list of roles with certain permission in Spatie/permission (Laravel)

Question

I am trying to get it by same way i am getting the list of users with a certain Permission, but with role it's not working throwing me

Call to undefined method Spatie\Permission\Models\Role::roles()

The way i get list of users with a certain role:

$permission = $request->permission;
$usersWithPerms = User::permission($permission)->get(); 
return array("usersWithPerms"=>$usersWithPerms);

The way im trying to get roles with a certain permission:

  $groupsWithPerms = Role::permission('perms_givePermToRole')->get(); 
  return array("groupsWithPerms"=>$groupsWithPerms);

BadMethodCallException Call to undefined method Spatie\Permission\Models\Role::roles()

i think your question is wrong because every role has many permissions not the opposite — Ahmad Elkenany, Dec 25 '18 at 13:14
no, it's not wrong, cause there are many roles with same perm, so i want a list of roles that have assigned some perm. But i got it work. Ty — Ascerx, Dec 25 '18 at 19:49

score 2 · Answer 1 · answered Nov 27 '19 at 05:23

get the permissions of a role and get the roles of a permission

$permission = Permission::findOrFail(1);
$groupsWithPerms = $permission->getRoleNames();
//dd($groupsWithPerms);

$role = Role::findOrFail(1);
$groupsWithRoles = $role->getPermissionNames();
//dd($groupsWithRoles);

Ascerx · Answer 2 · 2018-12-25T19:52:32.447

1

The only thing i get its a name but not id of the roles with a certain permission:

$permission = Permission::findOrFail($request->idPermission);
$groupsWithPerms = $permission->getRoleNames();

Where: getRoleNames() is a method from spatie package. So this works fine but you only get the names of the roles not ids.

edited Dec 25 '18 at 19:52

answered Dec 25 '18 at 19:45

Ascerx

59
1
9

score 0 · Answer 3 · answered Nov 20 '21 at 01:06

There is no in-built shortcut to get them in the package, but querying for them is simple enough:

//Eager load roles to get all data in just 1 query
$permission = Permission::with('roles')
    ->where('name', 'perms_givePermToRole')
    ->first();
$rolesWithPerm = $permission->roles;

//or

$rolesWithPerm = Role::whereHas('permissions', function($permissions){
   $permissions->where('name', 'perms_givePermToRole');
})->get();

How to get a list of roles with certain permission in Spatie/permission (Laravel)

3 Answers3