Laravel - Getting count of nested relationship

Question

I have an application where users can control their properties and leases.

These are the relationships defined:

//Team.php
/**
 * A team can have many properties.
 */
public function properties():
{
    return $this->hasMany(Property::class);
}

//Property.php
/**
 * A property can have many leases.
 */
public function leases():
{
    return $this->hasMany(Lease::class);
}

As you can see here, a Team can have many properties, and each property can also have many leases.

I am trying to figure out how I can get the number of leases that is associated with a Team:

$team = Auth::user()->currentTeam;

return $team->properties->leases->count();

However, the above code returns an error:

Property [leases] does not exist on this collection instance.

You're have to iterate properties; that's a Collection of Property instances, so calling ->properties->leases won't work as it doesn't know which property->leases you're referencing. There's a hasManyThrough(), but it doesn't work for nested many-to-many, but hasManyDepp(), via this package does. — Tim Lewis
– Tim Lewis, Commented Sep 24, 2021 at 15:05
@TimLewis After reading a bit more about hasManyThrough I do believe I can use it actually. (See my proposed answer) — oliverbj
– oliverbj, Commented Sep 26, 2021 at 9:17
Nice! I misread your question a bit, you don't quite have a nest many-to-many like I originally thought, you have nested one-to-many (one Team -> many Properties -> many Leases), so hasManyThrough should actually work just fine here. Glad you got it working regardless! — Tim Lewis
– Tim Lewis, Commented Sep 27, 2021 at 0:36

Rateb Habbab · Accepted Answer · 2021-09-24 15:42:43Z

1

You could add this method to your Team.php:

public function leasesCount(){
    return count(
        Team::
            join('properties', 'properties.team_id', '=', 'teams.id')
            ->join('leases', 'leases.property_id', '=', 'properties.id')
            ->where('teams.id', $this->id)
            ->get()
    );
}

answered Sep 24, 2021 at 15:42

Rateb Habbab

1,79910 silver badges14 bronze badges

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

Comments

oliverbj · Accepted Answer · 2021-09-26 08:29:03Z

1

I ended up using a hasManyThrough relationship on the Team model, like so:

//Team.php

/**
 * Get all of the leases for the team.
 */
public function leases()
{
    return $this->hasManyThrough(Lease::class, Property::class);
}

Then I can simply get the number of leases created by a specific team by:

return $team->leases()->count();

answered Sep 26, 2021 at 8:29

oliverbj

6,11031 gold badges102 silver badges198 bronze badges

Collectives™ on Stack Overflow

Laravel - Getting count of nested relationship

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related