Laravel: get the last parent in nested list eloquent recursive

Question

I need to get the latest parent in a nested tree with laravel :

Example:

Example

Schema of the table in my database :

enter image description here

Relationships in my model :

public function parentUnit() {
    return $this->belongsTo('Unit', 'unit_id', 'id');
}

public function allParentUnit() {
    return $this->parentUnit()->with('allParentUnit');
}

Question:

How can I get the latest parent in the picture above:

The latest parent of G is A

And the last parent of F is B

Collin James · Accepted Answer · 2015-04-14 14:17:22Z

2

I would add a method to the model to find the first parent.

public function getLatestParent()
{
    if ($this->parentUnit)
        return $this->parentUnit->getLatestParent();

    return $this;
}

answered Apr 14, 2015 at 14:17

Collin James

9,3302 gold badges30 silver badges36 bronze badges

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

1 Comment

Le-Mr-Ruyk Over a year ago

How can I add it in Eloquent Model ??

Collectives™ on Stack Overflow

Laravel: get the last parent in nested list eloquent recursive

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related