public static function getMenuItems($id_lang, $id_shop)
{
$sql = new DbQuery();
$sql->select('i.*, il.url, il.title, il.name');
$sql->from('ct_top_menu_item', 'i');
$sql->leftJoin('ct_top_menu_item_lang', 'il', 'i.id_ct_top_menu_item = il.id_ct_top_menu_item AND il.id_lang = ' . (int) $id_lang);
$sql->innerJoin('ct_top_menu_item_shop', 'ishop', 'i.id_ct_top_menu_item = ishop.id_ct_top_menu_item AND ishop.id_shop = ' . (int) $id_shop);
$sql->orderBy('ishop.position ASC');
return (array) Db::getInstance()->executeS($sql);
} /**
* Builds and returns menu tree, really for templates
*
* @param int $id_lang
* @param int $id_shop
*
* @return array
*/
public function getMenu($id_lang, $id_shop)
{
$menu = array();
$menuItems = CTTopMenuItem::getMenuItems($id_lang, $id_shop);
foreach ($menuItems as $menuItem) {
if ($menuItem['active']) {
$compiledMenuItem = $this->buildMenuItem($menuItem, $id_shop, $id_lang);
if (!empty($compiledMenuItem)) {
$menu[] = $compiledMenuItem;
}
}
}
return $menu;
}