/**
* 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;
}
}
