/**
* @param Entity_Tree $tree
* @param Entity_Block $block
* @return bool
*/
public function updateBlock($tree, $block)
{
$old = new Entity_Tree();
$old->init($this->treeDAO->getOne($tree->getId()));
$link = rtrim($old->getLink(), $old->getName()) . $tree->getName();
$tree->setLink($link);
$block->setId($old->getTypeId());
return $this->blockDAO->update($block) && $this->treeDAO->updateTree($tree);
}
/**
* @param Entity_Tree $tree
* @param Entity_Page $page
* @return bool
*/
public function updatePage($tree, $page)
{
$old = new Entity_Tree();
$old->init($this->treeDAO->getOne($tree->getId()));
$link = rtrim($old->getLink(), $old->getName()) . $tree->getName();
$tree->setLink($link);
$page->setId($old->getTypeId());
return $this->pageDAO->update($page) && $this->treeDAO->updateTree($tree);
}
/**
* @param Entity_Tree $tree
* @return bool
*/
public function updateTree($tree)
{
$id = $tree->getId();
$title = $tree->getTitle();
$name = $tree->getName();
$link = $tree->getLink();
$stmt = $this->DB->prepare('UPDATE `site_tree` SET
`title`=:title,
`name`=:name,
`link`=:link
WHERE `id`=:id');
$stmt->bindParam(':id', $id);
$stmt->bindParam(':title', $title);
$stmt->bindParam(':name', $name);
$stmt->bindParam(':link', $link);
return $stmt->execute();
}
/**
* @param Entity_Tree $tree
* @return mixed
*/
public function addTree($tree)
{
$rk = $tree->getRightKey();
$lev = $tree->getLevel();
$tit = $tree->getTitle();
$nam = $tree->getName();
$link = $tree->getLink();
$typ = $tree->getType();
$tid = $tree->getTypeId();
$pid = $tree->getPid();
$stmt = $this->DB->prepare('UPDATE `site_tree`
SET `right_key` = `right_key` + 2,
`left_key` = IF(`left_key` > :right_key,
`left_key` + 2, `left_key`)
WHERE `right_key` >= :right_key');
$stmt->bindParam(':right_key', $rk);
$stmt->execute();
$stmt = $this->DB->prepare('INSERT INTO `site_tree`
SET `left_key` = :right_key,
`right_key` = :right_key + 1,
`level` = :level + 1,
`title`=:title,
`name`=:name,
`link`=:link,
`type`=:type,
`type_id`=:type_id,
`pid`=:pid');
$stmt->bindParam(':right_key', $rk);
$stmt->bindParam(':level', $lev);
$stmt->bindParam(':title', $tit);
$stmt->bindParam(':name', $nam);
$stmt->bindParam(':link', $link);
$stmt->bindParam(':type', $typ);
$stmt->bindParam(':type_id', $tid);
$stmt->bindParam(':pid', $pid);
$stmt->execute();
return $this->DB->lastInsertId();
}
