Laravel query using existing model

Question

I've got two models: Offers and Speciality with many to many relatioship:

in Offer.php

public function specialities()
{
    return $this->belongsToMany('App\Speciality');
}

in Speciality.php

public function offers()
{
    return $this->belongsToMany(Offer::class);
}

this is simple so far.

Now, I'm building query to get only Offers with certain speciality. The problem is that I'm using when helper function, so I don't know how to access speciality model:

public function template($person = "", $speciality = "")
{
      $offers = Offer::when($speciality, function($query, $speciality) {
        return $query->specialities()->where('speciality_name', $speciality)->get();
      })->orderBy('created_at','desc')->paginate(9);
}

And this is not working for me. Can anyone give me a tip how should I write it?

Jonas Staudenmeir · Accepted Answer · 2018-10-11 16:25:36Z

3

Use whereHas():

$offers = Offer::when($speciality, function($query, $speciality) {
    $query->whereHas('specialities', function($query) use($speciality) {
        $query->where('speciality_name', $speciality);
    });
})->orderBy('created_at', 'desc')->paginate(9);

answered Oct 11, 2018 at 16:25

Jonas Staudenmeir

26k7 gold badges70 silver badges115 bronze badges

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

1 Comment

gileneusz Over a year ago

that's the right answer, thank you. Huge thanks also for @acabala for his help for solving this issue +1

acabala · Accepted Answer · 2018-10-11 14:05:08Z

2

For querying you should use join instead specialities() relation, so it will look more like:

 $offers = Offer:join('offer_specialities os', 'offer.id', 'os.offer_id')
 ->join('specialities', 'specialities.id', 'os.speciality_id')
 ->when($speciality, function($query, $speciality) {
    return $query->where('specialities.speciality_name', $speciality)->get();
  })->orderBy('created_at','desc')->paginate(9);

answered Oct 11, 2018 at 14:05

acabala

1491 silver badge14 bronze badges

14 Comments

gileneusz Over a year ago

thank you for your answer, but I'm not familiar with manual joining multiple tables (there I have pivot table offer_speciality) and when I've got model already configured, I want to use it...

acabala Over a year ago

then try something like this one:

$offers = Offer::with('specialities')->when($speciality, function($query, $speciality) {         return $query->where('speciality_name', $speciality)->get();       })->orderBy('created_at','desc')->paginate(9);

(adding with to your primary query).

gileneusz Over a year ago

this gives me unknown collumn (after added with('specialities'))

acabala Over a year ago

Is speciality_name correct column name? Maybe you have just name, so then it will be speciality.name

gileneusz Over a year ago

I'm putting the correct column name, and it seems that this with('specialities') solution does not work

|

Collectives™ on Stack Overflow

Laravel query using existing model

2 Answers 2

1 Comment

14 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

14 Comments

Your Answer

Sign up or log in

Post as a guest

Related