/PHP/Laravel/User order by role spatie laravel

User order by role spatie laravel

$values = Team::query()
      ->leftJoin('users', 'users.team_id', '=', 'teams.id')
      ->leftJoin('model_has_roles', function ($join) {
          $join->on('model_has_roles.model_id', '=', 'users.id')
               ->where('model_has_roles.model_type', '=', 'appModelsUser');
      })
      ->leftJoin('roles', 'roles.id', '=', 'model_has_roles.role_id')
      ->orderBy('roles.name')
      ->get();

Source: coderedirect.com

Similar codes

0 vote333 views1 answer
Laravel resource set status code
PHP Laravel
14 votes339 views6 answers
Redirect back laravel
PHP Laravel
2 votes383 views3 answers
Laravel migration drop foreign keys
PHP Laravel
16 votes370 views6 answers
Laravel redirect back
PHP Laravel
16 votes378 views4 answers
Add foreign key column laravel 5.8
PHP Laravel
0 vote366 views1 answer
Laravel collection get
PHP Laravel
2 votes381 views1 answer
Laravel vendor:publish not working
PHP Laravel
1 vote412 views2 answers
Htaccess redirect https laravel
PHP Laravel
53 votes473 views6 answers
Laravel where in
PHP Laravel
0 vote371 views6 answers
Use varable on all site pages laravel
PHP Laravel