How can i put condition in relation in laravel?

Question

I have File model that it store my images, and i have shop model, the shop can have many images and in shop model i wrote this code:

public function Files()
    {
        return $this->hasMany('system\models\file', 'attachment_id');
    }

and i want retrieve shop model with it's images, now my question is how can i put where condition in relation. my code for retrieve shop model is:

$shop = Shop::where('id', $id)->with('ShopType', 'User', 'Files')->get();

note: i need to put 2 condition for relation that one of theme set in Files method that call attachment_id and my second condition is attachment_type please help me. thanks

Answer 1

you could use constraining-eager-loads:

$shop = Shop::with(['ShopType','User', 'Files'=>function ($query)use($id)
{
query->where('id', $id);
}
])->get();

more details in:

https://laravel.com/docs/7.x/eloquent-relationships#constraining-eager-loads