public function getList() { $db = JFactory::getDBO(); $db->setQuery('SELECT * FROM #__menu_types ORDER BY id'); $menutypes = $db->loadObjectList(); foreach ($menutypes as $menutype) { $table = JTable::getInstance('Menus', 'MysiteTable'); $table->load(array('menutype' => $menutype->menutype)); if (empty($table->menu_id)) { $table->menutype = $menutype->menutype; $table->title = $menutype->title; $table->description = $menutype->description; $table->enabled = 0; $table->save(); } } $list = parent::getList(); if (empty($list)) { return array(); } foreach ($list as $item) { $db->setQuery("SELECT COUNT(item_id) FROM #__mysite_items WHERE menutype = '{$item->menutype}'"); $item->count = $db->loadResult(); } return $list; }
public function getList() { $items = parent::getList(); foreach (@$items as $item) { $item->link = 'index.php?option=com_mysite&controller=items&view=items&task=edit&id=' . $item->item_id; $item->id = $item->item_id; // JHTML::_('menu.treerecurse') needs $item->id to be set $item->name = $item->title; if (strpos($item->url, 'Itemid') !== false || empty($item->itemid) || !JURI::isInternal($item->url) || empty($item->url)) { // is a menulink or an external URL $item->url_itemid = $item->url; } else { $item->url_itemid = $item->url . "&Itemid=" . $item->itemid; } } return $items; }