Level 75
why would benefits have to be a great-grandchild, just make it a child of company.
Mar 12, 2019
5
Level 3
Eloquent query for great-grandchildren?
Ok, so I have the following model hierarchy:
- Companies have Departments.
- Departments have Employees.
- Employees have Benefits.
So, Benefits are great-grandchilden of Companies.
At the place in my code where I'm stuck, I have a particular instance of the Company model. And, I know that I can do the following with Eloquent to retrieve a given Company's Employees:
public function index(Company $company)
{
$employees = $company->hasManyThrough('App\Employees', 'App\Departments');
}
But, what I actually need for the particular $company instance are that company's Benefits. The only way I know how to do this is by looping through the $employees collection as follows:
public function index(Company $company)
{
$employees = $company
->hasManyThrough('App\Employees', 'App\Departments');
foreach ($employees as $employee)
{
$company_benefits = $employee->benefits;
}
}
More specifically, what I really need is to find the benefits that started after a certain date. So:
public function index(Company $company)
{
$employees = $company
->hasManyThrough('App\Employees', 'App\Departments');
foreach ($employees as $employee)
{
$new_company_benefits = $employee->benefits->where('starts_on', '>=', '2019/01/01');
}
}
Is there a way with Eloquent to do this that avoids having to do the whole foreach thing?
Level 37
@JLRDW - Using his example, each employee's benefits date would be different, based on when they started with the company and/or when their probationary period concludes, for example.
Level 75
The employee table should have a company column therefore you can add a benefits date column as well, and other columns as needed.
Since that date is unique per employee and employer
A relationship needs to be addressed both directions, an employee belongs to a company.
A good read on this: http://laravel.io/forum/05-12-2015-has-many-through-relationship-depth
Level 24
Laravel has no native support for a direct relationship.
I've created a package for this case: https://github.com/staudenmeir/eloquent-has-many-deep
You can use it like this:
class Company extends Model
{
use \Staudenmeir\EloquentHasManyDeep\HasRelationships;
public function benefits()
{
return $this->hasManyDeep(Benefit::class, [Department::class, Employee::class]);
}
}
$benefits = $company->benefits()->where('starts_on', '>=', '2019/01/01')->get();
1 like
Level 3
@STAUDENMEIR - Holy cow! This is awesome. Thanks!!
Please or to participate in this conversation.