Get all team members job sites if current user is the owner of the Team

Since its an authorization part, you can use Gate at Laravel [1].

Another approach can be establishing relationships between user and job site. Then you just check whether that user is eligible for modify or not by using logic.

1. https://laravel.com/docs/5.6/authorization#gates

@tisuchi

at the moment i just want to write the query which will get all of the Users on the team Job sites. There is a relationship already between Job Sites and users. Also i am using the teams functionality that is baked into Laravel Spark.

I have never used Gates before

Hard to say without seeing your models and relations... But something like that could give you an hint.

$jobSites =  DB::table('job_sites')
    ->join('users', 'job_sites.user_id', '=', 'users.id')
    ->join('teams', 'teams.id', '=', 'users.team_id') //if you need column from this table
    ->where('users.team_id', Auth::user()->team_id)
    ->get();

Just add a select() to not have all columns...

This should do it, or be pretty close... could be shorter but wanted it to be verbose for self-explanation

if (auth()->user()->roleOnCurrentTeam() == 'owner') {
    $teamMembers = auth()->user()->currentTeam->users;
    $memberIds = $teamMembers->pluck('id');

    $jobSites = DB::table('job_sites')->whereIn('user_id', $memberIds)->get();
}