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