for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
/**
* @link https://github.com/creocoder/yii2-nested-sets
* @copyright Copyright (c) 2015 Alexander Kochetov
* @license http://opensource.org/licenses/BSD-3-Clause
*/
namespace creocoder\nestedsets;
use yii\base\Behavior;
use yii\db\Expression;
* NestedSetsQueryBehavior
*
* @property \yii\db\ActiveQuery $owner
* @author Alexander Kochetov <[email protected]>
class NestedSetsQueryBehavior extends Behavior
{
* Gets the root nodes.
* @return \yii\db\ActiveQuery the owner
public function roots()
$model = new $this->owner->modelClass();
$this->owner
->andWhere([$model->leftAttribute => 1])
->addOrderBy([$model->primaryKey()[0] => SORT_ASC]);
return $this->owner;
}
* Gets the leaf nodes.
public function leaves()
$db = $model->getDb();
$columns = [$model->leftAttribute => SORT_ASC];
if ($model->treeAttribute !== false) {
$columns = [$model->treeAttribute => SORT_ASC] + $columns;
->andWhere([$model->rightAttribute => new Expression($db->quoteColumnName($model->leftAttribute) . '+ 1')])
->addOrderBy($columns);