Laravel 5 create Table and Self-Referenced model (self Referencing)

Question

Laravel 5 create Table and Self-Referenced model (self Referencing)

Navigation

#1 by (1 votes)
#2 by (0 votes)

2

How do I create a table autor referenced and how do I do the relationship in the same model?:

Example:

Tengo una tabla: Categoria
Campos: categoria_id, nombre, categoria_padre

It translates that a category (parent) can have many sub-categories (daughters) making the reference in the field category_father

php laravel eloquent laravel-5

asked by Rioyi Kaji 16.02.2018 в 05:35

source

2 answers

Nearby GeoPoints with firestore Access nested JavaScript functions from HTML

score 1 · Answer 1

It really is very simple in Laravel, you simply define the relationships in the same model, with their respective foreign key:

public function hijas()
{
    return $this->hasMany('Categoria', 'categoria_padre');
}

public function padre()
{
    return $this->belongsTo('Categoria', 'categoria_padre');
}

score 0 · Answer 2

Yes, it's simple and for more advanced operations I recommend the package Baum , you can get all the descendants of a node in one only consultation, no matter how deep the tree.

class Catalog extends Node
{
    protected $fillable = [
        'name',
        'parent_id',
        'left',
        'right',
        'depth'
    ];
}

and already includes the relationships you need:

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

public function children()
{
    return $this->hasMany(Catalog::class, 'parent_id');
}

among others:

ancestorsAndSelf()
ancestors()
siblingsAndSelf()
siblings()
leaves()
descendantsAndSelf()
descendants()
immediateDescendants()