Query (list all users) by team session

[l2aelba]

I making an endpoint to query all users which is just super-admin and admin can use the endpoint.

Route::get('/list', [UserController::class, 'list'])->middleware(['role:super-admin|admin']);

public function list()
{
  $current_user = app('auth')->user();
  $result = [];


  if ($current_user->hasRole('super-admin')) {
    // Super-admins query all users
    $result = User::with('teams')->get(); // ✅ this is working good (easy to query all users)
  } else if ($current_user->hasRole('admin')) {
    // Admins query users in their team
    // ❓❓❓❓
  }

  // Return response
  return response()->api($result, 200);
}

User model:

public function teams()
{
  return $this->belongsToMany(Team::class, 'model_has_roles', 'model_id', 'team_id')->withPivot('model_type');
}

The question is if admin calls this endpoint, how to list the users just on his team? by using getPermissionsTeamId() or something…

I know I can query all users and filter one by one, but I think that is not correct way to do, or bad perf.

Thanks for help

[parallels999]

how to list the users just on his team? by using getPermissionsTeamId() or something…

by using setPermissionsTeamId($your_team_id) before the query

[parallels999]

Did you try?

User::whereHas('teams', fn($q) => $q->where('team_id', $your_team_id))->get();

[l2aelba]

Wow thanks so much, seems like it works…

$team_id = getPermissionsTeamId();
$result = User::whereHas('teams', fn ($q) => $q->where('team_id', $team_id))->with(['teams', 'permissions', 'roles'])->get();