問題描述

在 Laravel 中，我有一個包含 id、parent_id、slug (Self-referring) 的表，

In Laravel, I have a table which contains id, parent_id, slug (Self-referring),

當我有一個ID時，我需要以這樣的格式(以/"分隔)獲取其所有祖先.

When I have an ID, I need to get all its ancestors in a format like this (Separated by "/").

level1/level2/level3

但是在沒有像laravel-nestedset"這樣的包的情況下以一種有效的方式".

But in an efficient way without a package like "laravel-nestedset ".

我是這樣實現的.

public function parent()
{
    return $this->belongsTo('Collection', 'parent_id');
}

public function getParentsAttribute()
{
    $parents = collect([]);

    $parent = $this->parent;

    while(!is_null($parent)) {
        $parents->push($parent);
        $parent = $parent->parent;
    }

    return $parents;
}

還有其他方法可以有效地做到這一點并用/"分隔嗎?

Any other way to do it efficiently and separated by "/" ?

推薦答案

在評論中進行了一些交談后，我認為這是一個很好的解決方案:

After a little conversation in the comments I think this is a good solution:

// YourModel.php

// Add this line of you want the "parents" property to be populated all the time.
protected $appends = ['parents'];

public function getParentsAttribute()
{
    $collection = collect([]);
    $parent = $this->parent;
    while($parent) {
        $collection->push($parent);
        $parent = $parent->parent;
    }

    return $collection;
}

然后您可以使用以下方法檢索您的父母:

Then you can retrieve your parents using:

• YourModel::find(123)->parents(集合實例)
• YourModel::find(123)->parents->implode('yourprop', '/')(內爆為字符串，見 https://laravel.com/docs/5.4/collections#method-implode)
• YourModel::find(123)->parents->reverse()->implode('yourprop', '/')(倒序https://laravel.com/docs/5.4/collections#method-reverse)

• YourModel::find(123)->parents (collection instance)
• YourModel::find(123)->parents->implode('yourprop', '/') (imploded to string, see https://laravel.com/docs/5.4/collections#method-implode)
• YourModel::find(123)->parents->reverse()->implode('yourprop', '/') (reversed order https://laravel.com/docs/5.4/collections#method-reverse)

正如 Nikolai Kiselev https://stackoverflow.com/a/55103589/1346367 所指出的，您也可以將它組合起來這樣可以節省一些查詢:

As noted by Nikolai Kiselev https://stackoverflow.com/a/55103589/1346367 you may also combine it with this to save a few queries:

protected $with = ['parent.parent.parent'];
// or inline:
YourModel::find(123)->with(['parent.parent.parent']);

這會在對象加載時預加載父級.如果您決定不使用它，則在您調用 $yourModel->parent 時(延遲)加載父項.

This preloads the parent on object load. If you decide not to use this, the parent is (lazy) loaded as soon as you call $yourModel->parent.

這篇關于Laravel 獲取祖先(URL)的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！