List of Unique Users with Certain Role From Many To Many Relationship

@Laraveldeep

Normally I practice with pluck() or lists() to get the list of data.

https://laravel.com/docs/5.3/queries#retrieving-results

@Laraveldeep from Users side you can use:

$users = App\User::whereHas('roles', function($query) use ($roleName) {
    $query->where('rolename', '=', $roleName);
})->get();

From Roles side you can use the following code to retreive the users for a role:

$role = App\Role::where('rolename','=', $roleName)->first();
$users = $role->users()->get();

Usman.

Thanks both for the quick response.

@usman : I got your point, but as I mentioned my rolename is repeated (because of permission). So in this case I will retrieve $roles instead of single role, which I have to break down with foreach loop.

Also for each role, I need to merge the users result somewhere, so was checking the doc on collections

https://laravel.com/docs/5.3/eloquent-collections

https://laravel.com/docs/5.3/collections

I am thinking of something like this:

        $adminroles = Role::where('rolename', 'admin')->get();


        $admins = collect();

        foreach($adminroles as $adminrole)
        {
            $admins->push($adminrole->users()->select('name','email')->get());
        }

        foreach($admins as $admin)
        {
            // list each user
            // but if user have multiple roles it might repeat too
        }

But still I will get duplicate users depending upon multiple role a user will have.

I am not sure if I am doing this correctly.

This looks lengthy...

Is there an alternative for this by using something like groupby and having in eloquent?

or

single line of code which can do all these that I am not aware of?

My goal is to get unique users with certain rolename disregarding the permission

Thanks!

@Laraveldeep If your role names are being repeated then what is the point of having a many to many relationship. Please first checkout some resource on many to many relationships in an RDBMS and why they exist.

You will also need a many to many relationship for role and permissions.

Regards!

Oh...

that was a quick decision made thinking it will be easier to check role and permission.

Now I realize that I need to break permission on separate table.

Thanks @usman

@Laraveldeep No problem :) happy that I could help.

Maybe this could help to have unique records in a collection

https://laravel.com/docs/5.4/collections#method-unique

@USMAN - hi man.. i try this exemplo and fine, but i'm try a list of patient from user auth, this is Policy? With your exemple ai have all users, but how list just users from auth->user(). this auth->user() hava a relation with a company. It's in resolve in policy? like ai list how you learn in my policy i try something link this: $user->id === $company->user_id?

@ELINARDO - Several tables aren't really needed

id  |   email            |  roles             |  company  //  other fields

1   |  [email protected]     |  user,admin,hr     |  acme