Courses

Eloquent: The Expert Level (Laravel 9)

HasManyThrough: 2-Level Deep hasMany

Previous: Advanced BelongsToMany with Extra Pivot Table Features
avatar

we have multiple task for the user in the above given condition and I want to filter it out by created at date or specific task for all users which might be assigned on different dates. how to achive that? for the same I am trying with product > product_variants > daily_stocks. I want to filter daily_stock on conditions like issued_stock = 100. so expected output are only product with product record and daily_stock records where on the days when 100 records where issued.

avatar

Well, you could use hasManyThrough and then do Product::whereHas('daily_stocks', function($query) { $query->where('issued_stock', 100); } maybe?

avatar
You can use Markdown
avatar

What would you recommend for the inverse of this relation - "belongs to through"? As I know, Laraver doesn't provide method BelongsToThrough

avatar

There's a package for this: staudenmeir/belongs-to-through

avatar
You can use Markdown
avatar
You can use Markdown