Example #1
0
 /**
  * Filter the query to restrict the result to siblings of an object.
  * The result does not include the object passed as parameter.
  *
  * @param     ChildCategory $category The object to use for sibling search
  * @param      ConnectionInterface $con Connection to use.
  *
  * @return    $this|ChildCategoryQuery The current query, for fluid interface
  */
 public function siblingsOf(ChildCategory $category, ConnectionInterface $con = null)
 {
     if ($category->isRoot()) {
         return $this->add(ChildCategory::LEVEL_COL, '1<>1', Criteria::CUSTOM);
     } else {
         return $this->childrenOf($category->getParent($con))->prune($category);
     }
 }
Example #2
0
 /**
  * Moves current node and its subtree to be the next sibling of $sibling
  * The modifications in the current object and the tree are immediate
  *
  * @param      ChildCategory $sibling    Propel object for sibling node
  * @param      ConnectionInterface $con    Connection to use.
  *
  * @return     $this|ChildCategory The current Propel object
  */
 public function moveToNextSiblingOf(ChildCategory $sibling, ConnectionInterface $con = null)
 {
     if (!$this->isInTree()) {
         throw new PropelException('A ChildCategory object must be already in the tree to be moved. Use the insertAsNextSiblingOf() instead.');
     }
     if ($sibling->isRoot()) {
         throw new PropelException('Cannot move to next sibling of a root node.');
     }
     if ($sibling->isDescendantOf($this)) {
         throw new PropelException('Cannot move a node as sibling of one of its subtree nodes.');
     }
     $this->moveSubtreeTo($sibling->getRightValue() + 1, $sibling->getLevel() - $this->getLevel(), $con);
     return $this;
 }