PHPackages                             echolevan/closure-table - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. echolevan/closure-table

ActiveLibrary[Database & ORM](/categories/database)

echolevan/closure-table
=======================

A closure table tree package for laravel eloquent

04PHP

Since Jul 30Pushed 1y agoCompare

[ Source](https://github.com/echolevan/closure-table)[ Packagist](https://packagist.org/packages/echolevan/closure-table)[ RSS](/packages/echolevan-closure-table/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

About
-----

[](#about)

优雅的树形数据结构管理包,基于`Closure Table`模式设计.

Features
--------

[](#features)

- 优雅的树形数据设计模式
- 最少的数据库查询
- 一个Eloquent Trait简单操作
- 完善的树形结构操作方法
- 支持生成树形数据
- 支持多个根存在
- 支持节点/树修复
- 支持软删除
- ...

依赖
--

[](#依赖)

- php > 5.6.0
- laravel 5.0 - 11.0
- mysql > 5.1.0

关于 `Closure Table`
------------------

[](#关于-closure-table)

> Closure table is a simple and elegant way of storing and querying hierarchical data in any RDBMS. By hierarchical data we mean a set of data that has some parent – child relationship among them. We use the word ‘tree’ instead of hierarchies commonly. As an example we may take the relationships between geographic locations like ‘Countries’, ‘States/ Province’, ‘Districts/ Cities’ etc.

`Closure Table` 将树中每个节点与其后代节点的关系存储在数据库中, 这将需要一个存储节点关系的表 `xxx_closure`.

例如一个菜单表 `menus`:

idnameparent1A02AA13AB14AAA25ABA36ABAA5一个基本的 `closure` 表包含 `ancestor` ,`descendant` , `distance` 3个字段,如:

ancestordescendantdistance110121131142152163220241330351362440550561660这个表记录了每个节点之间的关系,并且还记录了一条自身的关联,如：`1,1,0`.

使用
--

[](#使用)

`ClosureTable` 提供了大量方法操作树结构.

### 影响树结构的方法

[](#影响树结构的方法)

```