/**
  * @param int $to
  * @param bool $forward
  */
 protected function moveTo($to, $forward)
 {
     $this->owner->setAttribute($this->sortAttribute, $to);
     $tableName = $this->owner->tableName();
     $path = $this->getParentPath($this->node->getAttribute($this->pathAttribute));
     $like = strtr($path . $this->delimiter, ['%' => '\\%', '_' => '\\_', '\\' => '\\\\']);
     $unallocated = (new Query())->select("{$tableName}.[[{$this->sortAttribute}]]")->from("{$tableName}")->leftJoin("{$tableName} n", ['and', ['like', "n.[[{$this->pathAttribute}]]", $like . '%', false], ["n.[[{$this->depthAttribute}]]" => $this->node->getAttribute($this->depthAttribute), "n.[[{$this->sortAttribute}]]" => new Expression("{$tableName}.[[{$this->sortAttribute}]] " . ($forward ? '+' : '-') . " 1")]])->where(['and', ['like', "{$tableName}.[[{$this->pathAttribute}]]", $like . '%', false], [$forward ? '>=' : '<=', "{$tableName}.[[{$this->sortAttribute}]]", $to], ["{$tableName}.[[{$this->depthAttribute}]]" => $this->node->getAttribute($this->depthAttribute), "n.[[{$this->sortAttribute}]]" => null]])->orderBy(["{$tableName}.[[{$this->sortAttribute}]]" => $forward ? SORT_ASC : SORT_DESC])->limit(1)->scalar($this->owner->getDb());
     $this->owner->updateAll([$this->sortAttribute => new Expression("[[{$this->sortAttribute}]] " . ($forward ? '+' : '-') . " 1")], ['and', ['like', "[[{$this->pathAttribute}]]", $like . '%', false], ["[[{$this->depthAttribute}]]" => $this->node->getAttribute($this->depthAttribute)], ['between', $this->sortAttribute, $forward ? $to : $unallocated, $forward ? $unallocated : $to]]);
 }
 /**
  * @return \yii\db\ActiveQuery
  */
 protected function getSortableQuery()
 {
     switch ($this->operation) {
         case self::OPERATION_PREPEND_TO:
         case self::OPERATION_APPEND_TO:
             $path = $this->node->getAttribute($this->pathAttribute);
             $depth = $this->node->getAttribute($this->depthAttribute) + 1;
             break;
         case self::OPERATION_INSERT_BEFORE:
         case self::OPERATION_INSERT_AFTER:
             $path = $this->node->getParentPath();
             $depth = $this->node->getAttribute($this->depthAttribute);
             break;
         default:
             $path = $this->getParentPath();
             $depth = $this->owner->getAttribute($this->depthAttribute);
     }
     $tableName = $this->owner->tableName();
     return $this->owner->find()->andWhere($this->treeCondition())->andWhere($path !== null ? ['like', "{$tableName}.[[{$this->pathAttribute}]]", $this->getLike($path), false] : '1=0')->andWhere(["{$tableName}.[[{$this->depthAttribute}]]" => $depth]);
 }