Getting roles that has the same exact permissions

@Tray2 sorry i think I didn't mention that the package is using a polymorph relationship not one table

@merabetabdelhalim Can you share the content of your table?

@Tray2

• Roles table -ID -Name -timestamps

• Permissions table -ID -Name -timestamps

• role_has_permissions table -ID -Permission_foreignID -Role_foreignID -timestamps

*https://github.com/spatie/laravel-permission

@merabetabdelhalim The content not the structure.

@Tray2 yeah sure here are the default Permissions from my seeder

$DefaultPermissions = [
            'super admin',
            'profile.view', 'profile.edit',
            'role.view', 'role.edit', 'role.delete', 'role.create',
            'user.view', 'user.edit', 'user.delete', 'user.create', 'user.assign_role',
            'activityLog.view','activityLog.delete'
        ];

then the admin of the app is free to structure them into roles.

for example "Users Manager" role would have permissions to 'user.view', 'user.edit', 'user.delete', 'user.create', the problem is the admin can create another role "Dummy Role" with the same exact permissions

i solved it Using PHP by pulling all roles and i give em a check, but i would like to do it DB side

@Sinnbeck

 $roles = Role::with('permissions')->get()->pluck('permissions')->map(function ($item, $key) {
            return $item->pluck('id');
        })->toArray();

this with return an array of roles with arrays containing ids for permissions

then i compare it to what the user posted like this

dd(in_array(array_values(Arr::sort($this->selectedPermissions)), $roles));

what do you think ? a bit big i know :p

@merabetabdelhalim doesn't this have the same issue as mine? Check if the amount of permissions match first

@Sinnbeck nope the first part of code is just to get all roles in the database with their permissions in an array like this

$db_roles = [
0=>[1,2],
1=>[2],
2=>[5,6]
];

then i check if the given array by user matches any of those sub-arrays with the php function in_array (it matches only if exact same array is founded)

in_array($ids_to_check, $db_roles);

it works ; Roles number in any application should not hit 3 digits any way .... but it's kind of Not LARAVALIAN solution yet :p

@Sinnbeck yeah it returns roles that have either Permission "1" or "2" , i want them to be exactly "1" and "2"

@merabetabdelhalim count them to check perhaps? This should work

$ids = [2,3,7];
$roles = Role::withCount('permissions') - >whereHas('permissions', function ($query) use ($ids) {
    $query->whereIn('id', $ids);
}, '=', count($ids))->get();
$final = $roles->filter(function ($item) use ($ids) {
    return $item->permissions_count === count($ids);
});

@Sinnbeck that does the trick thanks for burning some brain cells here , really appreciate it ! :D

@merabetabdelhalim no worries. Fun challenge. Hard to do without a computer, but happy it worked

@Sinnbeck Was taking a look at this solution since I have a problem that has similar needs. Doesn't this solution fail when you have a similar set of permissions with the same count?

For example, the input [2,4,7] would fetch the same model as the input [2,3,7] since the whereIn will catch any permission with id 2 or 7 and the having / count will match since the array size is the same.

The whereIn does not ensure that ALL the ids are found, only that one of them is, or maybe I am missing something.

@oaaron you are correct, i faced the same issue until i added

'=',count($value)

to whereHas so the code becomes

$similar_role = Role::withCount('permissions')
                ->whereHas('permissions', fn ($query) => $query->whereIn('id', $value),'=',count($value))
                ->having('permissions_count',count($value))
                ->get();

it works well , [2,4,7] input will not fetch the same model for [2,3,7] input now tell me if am doing something wrong ...

@H4L1M ah I almost had it. Close to my initial idea, but clever with the having() check