/** * deleteUnitNode * @author Thomas Schedler <*****@*****.**> * @param integer $intElementId * @version 1.0 */ public function deleteUnitNode($intUnitId) { $this->core->logger->debug('core->models->Contacts->deleteUnitNode(' . $intUnitId . ')'); $this->getUnitTable(); $objNestedSet = new NestedSet($this->objUnitTable); $objNestedSet->setDBFParent('idParentUnit'); $objNestedSet->setDBFRoot('idRootUnit'); $objNestedSet->deleteNode($intUnitId); //FIXME:: delete contacts? }
/** * deleteCategoryNode * @author Thomas Schedler <*****@*****.**> * @param integer $intElementId * @version 1.0 */ public function deleteCategoryNode($intCategoryId) { $this->core->logger->debug('core->models->Categories->deleteCategoryNode(' . $intCategoryId . ')'); $this->getCategoriesTable(); $objNestedSet = new NestedSet($this->objCategoriesTable); $objNestedSet->setDBFParent('idParentCategory'); $objNestedSet->setDBFRoot('idRootCategory'); $objNestedSet->deleteNode($intCategoryId); }
/** * deleteFolderNode * @author Thomas Schedler <*****@*****.**> * @param integer $intFolderId * @version 1.0 */ public function deleteFolderNode($intFolderId) { $this->core->logger->debug('core->models->Folders->deleteFolderNode(' . $intFolderId . ')'); $this->getFolderTable(); $objNestedSet = new NestedSet($this->objFolderTable); $objNestedSet->setDBFParent('idParentFolder'); $objNestedSet->setDBFRoot('idRootLevels'); $objNestedSet->deleteNode($intFolderId); //FIXME:: delete sub folder and content (pages, files, folders, ...) ??? }
$treeModel = new NestedSet(new PDO('mysql:host=localhost;dbname=tree', 'tree', 'tree')); if (isset($_POST['action'])) { switch ($_POST['action']) { case 'create_node': echo $treeModel->addNode('new_node'); break; case 'select_all': echo json_encode($treeModel->selectAll()->result()); break; case 'move_node': $node_data = json_decode($_POST['node_data']); //move the new node after the prev one if ($node_data->prev != 'undefined') { $treeModel->addAfter($node_data->new, $node_data->prev); } else { if ($node_data->next != 'undefined') { $treeModel->addBefore($node_data->new, $node_data->next); } else { if ($node_data->parent != 'undefined') { $treeModel->addChild($node_data->new, $node_data->parent); } } } break; case 'remove_node': if (isset($_POST['id'])) { $treeModel->deleteNode($_POST['id']); } break; } }