/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

15 votes325 views3 answers
Laravel setup auth
PHP Laravel
1 vote374 views1 answer
Static function model laravel
PHP Laravel
0 vote360 views1 answer
Artisan laravel require bootstrap
PHP Laravel
0 vote404 views1 answer
Push to aws instance ssh without using laravel
PHP Laravel
0 vote353 views1 answer
Laravel get current domain
PHP Laravel
13 votes356 views5 answers
How to change validation message in laravel
PHP Laravel
6 votes326 views3 answers
Laravel foreach loop index from 1
PHP Laravel
1 vote328 views1 answer
Laravel Unable to migrate or Make Seeds
PHP Laravel
0 vote357 views1 answer
Howw to see if a value is posted laravel
PHP Laravel
6 votes319 views3 answers
Set route name laravel
PHP Laravel