How to get the actual title of a Menu Type object?

Question

The SiteMenu Class does not provide any method for getting the menu title column from table *_menu_types. However that field is editable in the admin section (com_menus section, field 'title').

Is there another way than querying the database to retrieve this field (as encoded in cpanel) ?

If not, does anyone have a sample code with db query ?

Thanks !

Answer 1

Just in case it helps anyone, this is how I achieved it:

$menu = $app->getMenu();
$active_item = $menu->getActive();

$loader = function ($menu_type) {
    $db = \JFactory::getDbo();
    $result = null;
    $query = $db->getQuery(true)
        ->select('m.id, m.menutype, m.title, m.description')
        ->where("m.menutype = '{$menu_type}'")
        ->from('#__menu_types AS m');
    $db->setQuery($query);
    $list = $db->loadObjectList();
    if(count($list)) $result = array_shift($list);
    return $result;
};

$menu = $loader($active_item->menutype);
$menu_title = $menu->title;

Answer 2

You can get the current menu item alias like so:

$alias  = JFactory::getApplication()->getMenu()->getActive()->alias;

Update:

$active = JFactory::getApplication()->getMenu()->getActive();
var_dump($active);

or

//(int)$id - the actual itemid you want to get;  

$specificMenuItem = JFactory::getApplication()->getMenu()->getItem($id);
var_dump($specificMenuItem);

See: JMenu API