/** * @param null $modelAlias * @param \Propel\Runtime\ActiveQuery\Criteria|null $criteria * * @return \Orm\Zed\Category\Persistence\SpyCategoryClosureTableQuery */ public function createCategoryClosureTableQuery($modelAlias = null, Criteria $criteria = null) { return SpyCategoryClosureTableQuery::create($modelAlias, $criteria); }
/** * @param int $nodeId * @param int $parentId * * @return void */ protected function persistNode($nodeId, $parentId) { $closureQuery = new SpyCategoryClosureTableQuery(); $nodes = $closureQuery->findByFkCategoryNodeDescendant($parentId); foreach ($nodes as $node) { $entity = new SpyCategoryClosureTable(); $entity->setFkCategoryNode($node->getFkCategoryNode()); $entity->setFkCategoryNodeDescendant($nodeId); $entity->setDepth($node->getDepth() + 1); $entity->save(); } $entity = new SpyCategoryClosureTable(); $entity->setFkCategoryNode($nodeId); $entity->setFkCategoryNodeDescendant($nodeId); $entity->setDepth(0); $entity->save(); }
/** * @param \Generated\Shared\Transfer\NodeTransfer $categoryNode * * @return void */ protected function touchCategoryDeletedRecursive(NodeTransfer $categoryNode) { $closureQuery = new SpyCategoryClosureTableQuery(); $nodes = $closureQuery->findByFkCategoryNode($categoryNode->getIdCategoryNode()); foreach ($nodes as $node) { $this->touchCategoryDeleted($node->getFkCategoryNodeDescendant()); } $this->touchCategoryDeleted($categoryNode->getIdCategoryNode()); }