Many to many deep

[dpetrovaliev]

Hey, I have the following structure:

customers
 - id
 - name

sport_parks
 - id
 - name

fields
 - id
 - name
 - sport_park_id

field_customer
 - field_id
 - customer_id

I need to have a sportParks relationship in my Customers' Model that should return all of the sport parks through the fields that the customer is related to. How I'm I able to achieve this with the /staudenmeir/eloquent-has-many-deep package?

Here is how I do it with plain SQL:

-- get all sport_parks by customer
SELECT sport_parks.* FROM sport_parks
INNER JOIN fields ON fields.sport_park_id = sport_parks.id
INNER JOIN field_customer ON field_customer.field_id = fields.id
WHERE field_customer.customer_id = 1
GROUP BY sport_parks.id

[staudenmeir]

Hi @dpetrovaliev,
Use this relationship:

class Customer extends Model
{
    use \Staudenmeir\EloquentHasManyDeep\HasRelationships;

    public function sportParks()
    {
        return $this->hasManyDeep(SportPark::class, ['field_customer', Field::class], [null, null, 'id'], [null, null, 'sport_park_id']);
    }
}

Try adding ->distinct() to get unique results:

$uniqueSportParks = $customer->sportParks()->distinct()->get();

[dpetrovaliev]

Yes,' that works! Thanks a lot.

[dpetrovaliev]

@staudenmeir
Here is also the opposite relation:

class SportPark extends Model
{
    use \Staudenmeir\EloquentHasManyDeep\HasRelationships;

    public function customers()
    {
        return $this->hasManyDeep(Customer::class, [Field::class, 'field_customer']);
    }
}