Laravel Eloquent query model with relationship

Question

I have 2 models with a relationship Company and DamageReport.

A DamageReport is always linked to a Company by the key company_id.

So company_id in DamageReport equals id in Company.

Very simple, right? Now my goal is to query the Company when I know the id of the DamageReport.

For example

I have a row of the DamageReport table:

id company_id

6  1

And the record of Company with id is:

id name

1  Company 1

So in my controller I have the DamageReport id (6) and need to query company with id 1.

I've set up a relationship like this in my models

Company model:

/**
 * The Damage Reprots that belong to the Company.
 */
public function damageReports()
{
    return $this->belongsToMany('App\DamageReport');
}

DamageReport model:

/**
 * The company of a damagereport
 *
 */
public function company()
{
    return $this->belongsTo('App\Company');
}

Now in my controller I tried something like this but I honestly have no clue

$company = new Company;

$company = $company->company($damageReportId);

dd($company);

Jerico Pulvera · Accepted Answer · 2017-09-20 07:50:04Z

3

Your relationship is wrong.

It should be

Company model:

/**
 * The Damage Reprots that belong to the Company.
 */
public function damageReports()
{
    return $this->hasMany('App\DamageReport');
}


DamageReport model:

/**
 * The company of a damagereport
 *
 */
public function company()
{
    return $this->belongsTo('App\Company');
}


// In your controller
public function index()
{
    $damageReportId = 1;
    $company = Company::whereHas('damageReports', function ($q) use($damageReportId) {
        $q->where('id', $damageReportId);
    })->first();

    dd($company);
}

// Or 
public function index()
{
    $damageReportId = 1;
    $company = DamageReport::find($damageReportId)->company;
    dd($company);
}

answered Sep 20, 2017 at 7:50

Jerico Pulvera

1,0427 silver badges15 bronze badges

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

Comments

Skrrp · Accepted Answer · 2017-09-20 07:38:58Z

1

You should use:

$company = DamageReport::find($damageReportId)->company;

Explanation:

DamageReport is the thing you know about, so the find($id) method will bring back the single model that you have the $id for.

Because DamageReport has its relationship to Company set up correctly, the ->company relationship will bring back the associated company model.

edited Sep 20, 2017 at 7:38

answered Sep 20, 2017 at 7:29

Skrrp

6957 silver badges11 bronze badges

Comments

Alex_Love_77 · Accepted Answer · 2017-09-20 07:40:32Z

0

Just use belongsTo and hasMany method if the relationship is one-to-many.

https://laravel.com/docs/5.5/eloquent-relationships#one-to-many

So, your DamageReport model is right, and in your Company model,

/**
 * The Damage Reprots that belong to the Company.
 */
public function damageReports()
{
    return $this->hasMany('App\DamageReport');
}

Then in you controller, @Skrrp's answer is right,

$company = DamageReport::find($damageReportId)->company;

answered Sep 20, 2017 at 7:40

Alex_Love_77

111 bronze badge

Collectives™ on Stack Overflow

Laravel Eloquent query model with relationship

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related