Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > body text

laravel implements infinite classification

大家讲道理

Release： 2023-03-05 22:24:02

Original

4198 people have browsed it

Explanation

Everyone usually uses recursion to implement infinite classification. We all know that recursion is very inefficient. Here is a Laravel expansion package recommended etrepat/baum, quickly make your data model support infinite tree hierarchical structure while taking into account efficiency.

Using the Baum nested set model to implement the infinite classification of the Laravel model

The official documentation of the expansion package has explanation space, and the picture below is also one Simple example:

laravel implements infinite classification

Use case description

# Next, let’s talk about a few examples of infinite tree hierarchical models.

Tag system

#Reference: Laravel Taggable Adds tagging function to your model. A tag can have countless child tags, belong to one parent tag, and have multiple peer tags.

For example, the tag tree below:

$tagTree = [
    &#39;name&#39; => &#39;RootTag&#39;,
    &#39;children&#39; => [
        [&#39;name&#39; => &#39;L1Child1&#39;,
            &#39;children&#39; => [
                [&#39;name&#39; => &#39;L2Child1&#39;],
                [&#39;name&#39; => &#39;L2Child1&#39;],
                [&#39;name&#39; => &#39;L2Child1&#39;],
            ]
        ],
        [&#39;name&#39; => &#39;L1Child2&#39;],
        [&#39;name&#39; => &#39;L1Child3&#39;],
    ]];

Copy after login

Comment system

#Infinitely nested comments, such as NetEase's comment system.

laravel implements infinite classification

Laravel has a comment extension that supports unlimited nesting, see Slynova-Org/laravel-commentable.

「Navigation bar」data model

#The administrator backend needs to provide the customization function of "Navigation bar", a tree-structured navigation bar.

laravel implements infinite classification

Integrate Baum

#etrepat/baum Quickly make your data model support the infinite tree hierarchical structure while taking into account efficiency.

Next let’s talk about how to integrate.

1. Composer installation

composer require "baum/baum:~1.1"

Copy after login

2. Add provider

#Modify the config/app.php file in providers Add to the array:

&#39;Baum\Providers\BaumServiceProvider&#39;,

Copy after login

This service provider has registered two commands: artisan baum, artisan baum.install.

3. Create migration

#Install it on the existing data model:

php artisan baum:install MODEL

Copy after login

Then execute

php artisan migrate

Copy after login

Field introduction about migration

#parent_id: the id of the parent node
lft: the left index value
rgt: the right index value
depth: Hierarchical depth

The following is an example:

class Category extends Migration {
  public function up() {
    Schema::create(&#39;categories&#39;, function(Blueprint $table) {
      $table->increments(&#39;id&#39;);

         // 这四行代码
      $table->integer(&#39;parent_id&#39;)->nullable();
      $table->integer(&#39;lft&#39;)->nullable();
      $table->integer(&#39;rgt&#39;)->nullable();
      $table->integer(&#39;depth&#39;)->nullable();

      $table->string(&#39;name&#39;, 255);

      $table->timestamps();
    });
  }}

Copy after login

4. Configure the data model

#Inherit Baum\Node

class Category extends Baum\Node {}

Copy after login

After inheritance, these properties can be overridden:

class Category extends Baum\Node {
  protected $table = &#39;categories&#39;;

  // &#39;parent_id&#39; column name
  protected $parentColumn = &#39;parent_id&#39;;

  // &#39;lft&#39; column name
  protected $leftColumn = &#39;lidx&#39;;

  // &#39;rgt&#39; column name
  protected $rightColumn = &#39;ridx&#39;;

  // &#39;depth&#39; column name
  protected $depthColumn = &#39;nesting&#39;;

  // guard attributes from mass-assignment
  protected $guarded = array(&#39;id&#39;, &#39;parent_id&#39;, &#39;lidx&#39;, &#39;ridx&#39;, &#39;nesting&#39;);}

Copy after login

The integration is successful.

Use

$root = Tag::create([&#39;name&#39; => &#39;Root&#39;]);

// 创建子标签
$child1 = $root->children()->create([&#39;name&#39; => &#39;Child1&#39;]);

$child = Tag::create([&#39;name&#39; => &#39;Child2&#39;]);
$child->makeChildOf($root);

// 批量构建树
$tagTree = [
    &#39;name&#39; => &#39;RootTag&#39;,
    &#39;children&#39; => [
        [&#39;name&#39; => &#39;L1Child1&#39;,
            &#39;children&#39; => [
                [&#39;name&#39; => &#39;L2Child1&#39;],
                [&#39;name&#39; => &#39;L2Child1&#39;],
                [&#39;name&#39; => &#39;L2Child1&#39;],
            ]
        ],
        [&#39;name&#39; => &#39;L1Child2&#39;],
        [&#39;name&#39; => &#39;L1Child3&#39;],
    ]
];

Tag::buildTree($tagTree);

Copy after login

Related labels：

laravel Infinitus Classification

source：php.cn

Previous article：PHP Security - Tracking Data Next article：PHP Security - Balancing Risk vs. Usability

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn