public function getItem($pk = null, $refresh = false, $emptyState = true) { Tienda::load('TiendaHelperSubscription', 'helpers.subscription'); if ($item = parent::getItem($pk, $refresh, $emptyState)) { $item->link = 'index.php?option=com_tienda&view=subscriptions&task=edit&id=' . $item->subscription_id; $item->link_view = 'index.php?option=com_tienda&view=subscriptions&task=view&id=' . $item->subscription_id; $item->history = TiendaHelperSubscription::getHistory($item->subscription_id); Tienda::load('TiendaQuery', 'library.query'); $q = new TiendaQuery(); $q->select('order_hash'); $q->from('#__tienda_orders'); $q->where('order_id = ' . $item->order_id); $db = JFactory::getDbo(); $db->setQuery($q); $item->order_hash = $db->loadResult(); } $dispatcher = JDispatcher::getInstance(); $dispatcher->trigger('onPrepare' . $this->getTable()->get('_suffix'), array(&$item)); return $item; }