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 getAll()
{
$items = parent::getAll();
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;
$item->url_itemid = $item->itemid ? $item->url . "&Itemid=" . $item->itemid : $item->url;
}
return $items;
}
