Eloquent Relationship using DB Laravel

Question

I've got 4 tables.

Clients Jobs Rounds Job_Rounds

I've created the following relationships:

Clients > Jobs
Jobs > Rounds

Here are my models

Client

class Client extends Model
{   

    protected $dates = [
        'created_at',
        'updated_at',
        'last_done'
    ];


    public function Jobs()
    {
        return $this->hasMany('App\Job','client_id');
    }
}

Job

class Job extends Model
{
    protected $dates = [
        'created_at',
        'updated_at',
        'last_done',
        'due_date'
    ];

    public function Round()
    {
        return $this->belongsTo('App\Round','round_id');
    }

    public function Client()
    {
        return $this->belongsTo('App\Client','client_id');
    }
}

Round

class Round extends Model
{
    protected $dates = [
        'created_at',
        'updated_at',
        'date_scheduled',
        'date_finished'
    ];

    public function Clients()
    {
        return $this->hasMany('App\RoundClients', 'round_id');
    }

    public function Jobs()
    {
        return $this->belongsToMany('App\Job', 'job_rounds', 'round_id', 'job_id');
    }
}

JobRound

class JobRound extends Model
{
    public $timestamps = false;
}

On my round view I'm outputting all the jobs not in the round and all the jobs in the round.

I'm doing this by creating a DB::table to perform the check - see my code:

public function show($id)
    {   
        $round = Auth::user()->rounds()->FindOrFail($id);

        $not = DB::table('jobs')->whereNotIn('id', function($query) use($round) {
        $query->select('job_id')
          ->from('job_rounds')
          ->where('round_id', $round->id);
        })->get();

        $are = DB::table('job_rounds')
        ->join('jobs', 'job_rounds.job_id', '=', 'jobs.id')
        ->select('job_rounds.*', 'jobs.*' ,'job_rounds.id as DAS')
        ->where('job_rounds.round_id',$round->id)
        ->get();   

        return view('app.round',compact('round','not','are'));
    }

The problem I have is in my view, the Client to Job relationship for outputting the client name won't work as I have created my own DB query, I'm outputting the client information on my view like

Jobs on the round

@foreach($are as $job)
  {{ $job->client->first_name }}
@endforeach

Jobs not on the round

@foreach($not as $job)
  {{ $job->client->first_name }}
@endforeach

I get the error:

Variable $client not found etc

have you defined the relationship on the models? can you post the model files for each one — Carlos
– Carlos, Commented Sep 8, 2016 at 15:08
@Carlos I'm not familiar with doing it in the relationship, i've included the models above. — Dev.W
– Dev.W, Commented Sep 8, 2016 at 15:14
if you use normal database relationship methods, each job has a client, then each job round has a job.so automatically job round and client relationship is made. — Sachith Muhandiram
– Sachith Muhandiram, Commented Sep 8, 2016 at 15:47

Nestor Mata Cuthbert · Accepted Answer · 2016-09-08 16:14:05Z

3

Your relationships methods starts with uppercase (which btw, you should change to start with lowercase for standard).

The problem is that your methods and the ones you call are not the same, you need to use the same case in both, like this...

@foreach($are as $job)
    {{ $job->Client->first_name }}
@endforeach

Update

Besides the fact of the case, you are not using Eloquent.
You are just using the database query builder directly.
In order to use Eloquent you must use the Model class static methods, like this:

Job::whereNoIn('id', .....

Instead of this:

DB::table('jobs')->whereNotIn('id', ....

edited Sep 8, 2016 at 16:14

answered Sep 8, 2016 at 15:47

Nestor Mata Cuthbert

1,36910 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Dev.W Over a year ago

Thanks Nestor, I've tried that but I still get the Undefined property: stdClass::$Client

Nestor Mata Cuthbert Over a year ago

Ohh, I see, you are not using Eloquent, that is why. You are using the Database Query Builder. If you want to use Eloquent you have to call the Class static methods, like Job::whereNotIn(..... instead of DB::table('jobs'). If you don't use Eloquent, those relationships are not available.

Dev.W Over a year ago

I'd love to make to code look cleaner in my controller though :( ha.

Nestor Mata Cuthbert Over a year ago

You could use the Repository pattern. bosnadev.com/2015/03/07/using-repository-pattern-in-laravel-5

Sachith Muhandiram · Accepted Answer · 2016-09-09 05:06:14Z

2

DB::table does not return an App\Job class. For this reason you cannot use relationship. ( $job->Client... )

Try make the queries using Eloquent instead.For more details, follow this offical Laravel documantation.

edited Sep 9, 2016 at 5:06

Sachith Muhandiram

2,97811 gold badges54 silver badges113 bronze badges

answered Sep 8, 2016 at 16:16

diegofelix

3961 silver badge3 bronze badges

Collectives™ on Stack Overflow

Eloquent Relationship using DB Laravel

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related