library kp-tree

kittencup/kp-tree

KpTree是一个基于Zend Framweork 2的模块，实现MYSQL树的几个TableGateway

1.概述

KpTree是一个基于Zend Framweork 2模块,实现MYSQL树形的几个TableGateway, _(*1)

2.安装

github下载 或者 composer require "kittencup/kp-tree": "dev-master", _(*2)

#application.config.php
return [
    'modules' => [
        // ...
        'KpTree',
    ],
];

3.设置

1.嵌套集(NestedTable), _(*3)

数据库参考KpTree/data/nested, _(*4)

namespace KpTest\Model\TestTable;
use KpTree\Model\NestedTable;
class TestTable extends NestedTable{
    // 设置数据库名
    protected $table = 'nested';
    // 设定左 字段
    protected $lColumn = 'l';
    // 设定右字段
    protected $rColumn = 'r';
    // 设定深度字段
    protected $depthColumn = 'depth';
}

2.路径枚举(PathEnumTable), _(*5)

数据库参考KpTree/data/pathEnum, _(*6)

namespace KpTest\Model\TestTable;
use KpTree\Model\PathEnumTable;
class TestTable extends PathEnumTable{
    // 数据库名
    protected $table = 'pathEnum';
    // 设定路径字段
    protected $pathColumn = 'path';
    // 设定路径分隔符
    protected $pathDelimiter = '/';
    // 设定深度字段
    protected $depthColumn = 'depth';
}

3.闭包表(ClosureTable), _(*7)

数据库参考KpTree/data/closure, _(*8)

namespace KpTest\Model\TestTable;
use KpTree\Model\ClosureTable;
class TestTable extends ClosureTable{
    // 数据库表名
    protected $table = 'closure';
    // 存储引用关系的表名
    protected $pathsTable = 'closurePaths';
    // $pathsTable表内 祖先字段名
    protected $ancestorColumn = 'ancestor';
    // $pathsTable表内 后辈字段名
    protected $descendantColumn = 'descendant';
    // $table内 深度字段
    protected $depthColumn = 'depth';
}

4.使用

具体可参考 KpTree\Model\TreeTableInterface, _(*9)

添加一个节点, _(*10)

$table->addNode(['name'=>'kittencup'],4);

移动节点, _(*11)

 $table->moveNode(2, 3)

根据节点id获取父节点, _(*12)

$table->getParentNodeById(12);
$table->getParentNodeById(12,2)
$table->getParentNodeById(12,2,'ASC')
$table->getParentNodeById(12,2,'ASC',['id','name'])

根据节点id获取子节点, _(*13)

$table->getChildNodeById(12);
$table->getChildNodeById(12,2)
$table->getChildNodeById(12,2,'ASC')
$table->getChildNodeById(12,2,'ASC',['id','name'])

根据节点id 删除所有子元素, _(*14)

$table->deleteChildNodeById(1);
$table->deleteChildNodeById(1,false);

根据节点id 删除节点, _(*15)

$table->deleteNodeById(1);