public function indexAction()
{
$this->getLayout()->getAdminHmenu()->add($this->getTranslator()->trans('menu'), array('action' => 'index'));
$menuId = 1;
if ($this->getRequest()->getParam('menu')) {
$menuId = (int) $this->getRequest()->getParam('menu');
}
$menuMapper = new MenuMapper();
$pageMapper = new PageMapper();
/*
* Saves the item tree to database.
*/
if ($this->getRequest()->isPost()) {
if ($this->getRequest()->getPost('save')) {
$sortItems = json_decode($this->getRequest()->getPost('hiddenMenu'));
$items = $this->getRequest()->getPost('items');
$oldItems = $menuMapper->getMenuItems($menuId);
/*
* Deletes old entries from database.
*/
if (!empty($oldItems)) {
foreach ($oldItems as $oldItem) {
if (!isset($items[$oldItem->getId()])) {
$menuMapper->deleteItem($oldItem);
}
}
}
if ($items) {
$sortArray = array();
foreach ($sortItems as $sortItem) {
if ($sortItem->item_id !== null) {
$sortArray[$sortItem->item_id] = (int) $sortItem->parent_id;
}
}
foreach ($items as $item) {
$menuItem = new MenuItem();
if (strpos($item['id'], 'tmp_') !== false) {
$tmpId = str_replace('tmp_', '', $item['id']);
} else {
$menuItem->setId($item['id']);
}
$menuItem->setMenuId($menuId);
$menuItem->setType($item['type']);
$menuItem->setSiteId($item['siteid']);
$menuItem->setHref($item['href']);
$menuItem->setTitle($item['title']);
if ((int) $item['boxkey'] > 0) {
$menuItem->setBoxId($item['boxkey']);
} else {
$menuItem->setBoxKey($item['boxkey']);
}
$menuItem->setModuleKey($item['modulekey']);
$newId = $menuMapper->saveItem($menuItem);
if (isset($tmpId)) {
foreach ($sortArray as $id => $parentId) {
if ($id == $tmpId) {
unset($sortArray[$id]);
$sortArray[$newId] = $parentId;
}
if ($parentId == $tmpId) {
$sortArray[$id] = $newId;
}
}
}
}
$sort = 0;
foreach ($sortArray as $id => $parent) {
$menuItem = new MenuItem();
$menuItem->setId($id);
$menuItem->setSort($sort);
$menuItem->setParentId($parent);
$menuMapper->saveItem($menuItem);
$sort += 10;
}
}
$menu = new MenuModel();
$menu->setId($menuId);
$menuMapper->save($menu);
}
if ($this->getRequest()->getPost('delete')) {
$id = (int) $this->getRequest()->getParam('menu');
$menuMapper->delete($id);
$this->redirect(array('action' => 'index'));
}
$this->addMessage('saveSuccess');
}
$menuItems = $menuMapper->getMenuItemsByParent($menuId, 0);
$menu = $menuMapper->getMenu($menuId);
$menus = $menuMapper->getMenus();
$moduleMapper = new \Modules\Admin\Mappers\Module();
$boxMapper = new \Modules\Admin\Mappers\Box();
$locale = '';
if ((bool) $this->getConfig()->get('multilingual_acp')) {
if ($this->getTranslator()->getLocale() != $this->getConfig()->get('content_language')) {
$locale = $this->getTranslator()->getLocale();
}
}
$this->getView()->set('menu', $menu);
$this->getView()->set('menus', $menus);
$this->getView()->set('menuItems', $menuItems);
$this->getView()->set('menuMapper', $menuMapper);
$this->getView()->set('pages', $pageMapper->getPageList($locale));
$this->getView()->set('boxes', (array) $boxMapper->getBoxList($locale));
$this->getView()->set('modules', $moduleMapper->getModules());
}
/**
* Gets all menu items by parent item id.
*/
public function getMenuItemsByParent($menuId, $itemId)
{
$items = array();
$itemRows = $this->db()->select('*')->from('menu_items')->where(array('menu_id' => $menuId, 'parent_id' => $itemId))->order(array('sort' => 'ASC'))->execute()->fetchRows();
if (empty($itemRows)) {
return null;
}
foreach ($itemRows as $itemRow) {
$itemModel = new MenuItem();
$itemModel->setId($itemRow['id']);
$itemModel->setType($itemRow['type']);
$itemModel->setSiteId($itemRow['page_id']);
$itemModel->setBoxId($itemRow['box_id']);
$itemModel->setBoxKey($itemRow['box_key']);
$itemModel->setHref($itemRow['href']);
$itemModel->setTitle($itemRow['title']);
$itemModel->setModuleKey($itemRow['module_key']);
$itemModel->setParentId($itemId);
$itemModel->setMenuId($menuId);
$items[] = $itemModel;
}
return $items;
}