Laravel hasMany with where in a Polymorphic relationship

Question

I have 3 tables, Cars, Flats and Shops. Each table has its photos. Photos is stored in database. I want to use only one table for photos, I don't want to create Photos table for each Cars, Flats and Shops.

Photos tables structe is like this;

| id |           photo_url        | type  | destination_id |
------------------------------------------------------------
  1  |   http://example.com/1.jpg | Cars  |      1         |
  2  |   http://example.com/2.jpg | Flats |      1         |
  3  |   http://example.com/3.jpg | Flats |      2         |
  4  |   http://example.com/4.jpg | Shops |      1         |
  5  |   http://example.com/3.jpg | Shops |      2         |

I need to define hasMany relationship with type in Shops, Flats and Cars model classes.

What is the correct way to do this?

score 113 · Answer 1 · edited Oct 25 '16 at 22:42

113

You can treat the relationship objects kind of like queries, in that you can call query building functions with them. The example below should get you going in the right direction.

class Cars extends Eloquent
{
    function photos()
    {
        return $this->hasMany('Photo')->where('photos.type', '=', 'Cars');
    }
}

edited Oct 25 '16 at 22:42

Patrick Moore

13,251
5
38
63

answered Oct 17 '14 at 22:03

Logan Bailey

7,039
7
36
44

2

Thanks a lot, i needed to call `Order::with('orderItems')->where('orderItems.type',1)->with('orderItems.orderItemOptions', 'orderItems.orderMenuItems')->first()`, and scopes would not work that way – cnlevy Nov 05 '15 at 21:20
1

Which method is best , first method or second method ?? – Kabir Hossain Jul 25 '18 at 08:46
3

Is ther any way to pass an argument for this?? to use the argument in where clause? – Slimane MEHARZI Oct 17 '18 at 08:21
1

@Logan How do we pass an argument in this function using `WITH function`, can you please explain about it? – Pankaj Jha Oct 29 '18 at 19:14
2

If you need add conditions to "with", do with((['Model' => function ($query) { $query->where('title', 'like', '%first%'); }])) – George Henrique May 22 '19 at 20:19
@George Henrique, Would you please explain with example? – Rejaul Apr 16 '20 at 02:23

Bogdan · Accepted Answer · 2014-10-17T22:19:26.913

You can make use of Eloquent's Polymorphic relationships. The example in the Laravel Documentation actually showcases setting up a common images table for multiple models, so that should point you in the right direction. In your case something your models would look something like this:

class Photo extends Eloquent {

    public function imageable()
    {
        return $this->morphTo();
    }

}

class Car extends Eloquent {

    public function photos()
    {
        return $this->morphMany('Photo', 'imageable');
    }

}

class Flat extends Eloquent {

    public function photos()
    {
        return $this->morphMany('Photo', 'imageable');
    }

}

class Shop extends Eloquent {

    public function photos()
    {
        return $this->morphMany('Photo', 'imageable');
    }

}

And you could access the photos for, let's say a given Flat, like this:

Flat::find($id)->photos;

For this to work you'd also need to add 2 additional columns to your photos table:

imageable_id: integer  <-- This will be the ID of the model
imageable_type: string <-- This will be the model's class name (Car/Flat/Shop)

Laravel hasMany with where in a Polymorphic relationship

2 Answers2

Linked