public static function getOrder($oid) { self::onExecuteBefore(array(&$oid)); if (!empty($oid)) { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select(' o.id, o.cost, o.discounts, o.user_id, o.region_id, o.shipping_id, o.shipping_coords, o.customer_fields, o.address_fields, o.payment_id, o.note, o.status_id, o.date_add, os.title AS status_name ')->from('#__ksenmart_orders AS o')->leftjoin('#__ksenmart_order_statuses AS os ON o.status_id=os.id')->where('o.id=' . $db->escape($oid)); $db->setQuery($query); $order = $db->loadObject(); self::setUserInfoField2Order($order); $query = $db->getQuery(true); $query->select('*')->from('#__ksenmart_order_items')->where('order_id=' . $oid); $db->setQuery($query); $order->items = $db->loadObjectList(); $order->costs = array('cost' => KSMPrice::getPriceInDefaultCurrency($order->cost), 'cost_val' => KSMPrice::showPriceWithTransform($order->cost), 'discount_cost' => 0, 'discount_cost_val' => KSMPrice::showPriceWithTransform(0), 'shipping_cost' => 0, 'shipping_cost_val' => KSMPrice::showPriceWithTransform(0), 'total_cost' => KSMPrice::getPriceInDefaultCurrency($order->cost), 'total_cost_val' => KSMPrice::showPriceWithTransform($order->cost)); $dispatcher = JDispatcher::getInstance(); $dispatcher->trigger('onAfterGetOrder', array(&$order)); self::onExecuteAfter(array(&$order)); return $order; } return new stdClass(); }