/** * getorderinfo * * @param INTEGER $orderid orderid * @param INTEGER $store_id store_id * * @since 2.2 * * @return null */ public function getorderinfo($orderid = '0', $store_id = 0) { $db = JFactory::getDBO(); $user = JFactory::getUser(); $jinput = JFactory::getApplication()->input; if ($orderid == '0') { $orderid = $jinput->get('orderid', ''); } if (empty($orderid)) { return 0; } // In result id field belongs to order table not user table(due to same column name in both table last column is selected) $query = "SELECT u.* ,o.processor, o.amount,o.coupon_code , o.transaction_id,o.ip_address,o.cdate, o.payee_id,o.status,o.id,\n\t\t\t\to.order_tax,o.order_tax_details,o.order_shipping,o.order_shipping_details,\n\t\t\t\to.amount,o.currency,o.customer_note,o.prefix,o.extra\n\t\t\t\tFROM #__kart_orders as o JOIN #__kart_users as u ON o.id = u.order_id\n\t\t\t\tWHERE o.id=" . $orderid . " order by u.id DESC"; // ." AND o.payee_id=".$user->id; $db->setQuery($query); $order_result = $db->loadObjectList(); // Change for backward compatiblity for user info not saving order id against it if (empty($order_result)) { $query = "SELECT u.* ,o.processor, o.amount,o.coupon_code , o.transaction_id,o.ip_address,o.cdate, o.payee_id,o.status,\n\t\t\t\t\to.id,o.order_tax,o.order_tax_details,o.order_shipping,o.order_shipping_details,\n\t\t\t\t\to.amount,o.currency,o.customer_note,o.prefix,o.extra\n\t\t\t\t\tFROM #__kart_orders as o JOIN #__kart_users as u ON o.user_info_id = u.user_id\n\t\t\t\t\tWHERE o.id=" . $orderid . " AND u.order_id IS NULL"; $db->setQuery($query); $order_result = $db->loadObjectList(); } // NOTE :: for mystore :: get all order releated to store IF store_id is found $where = " i.order_id=" . $orderid; if (!empty($store_id)) { $where = $where . " AND i.store_id=" . $store_id; } $orderlist["order_info"] = $order_result; @($orderlist["order_info"][0]->customer_note = preg_replace('/\\<br(\\s*)?\\/?\\>/i', " ", $orderlist['order_info'][0]->customer_note)); $query = "SELECT i.order_item_id,i.item_id,store_id,i.order_item_name,\n\t\t\t\t\ti.product_attribute_names,i.product_quantity,i.product_item_price,\n\t\t\t\t\ti.product_attributes_price, i.product_attributes, i.product_final_price,i.params,i.`item_tax`,\n\t\t\t\t\ti.`item_tax_detail`,i.`item_shipcharges`,i.`item_shipDetail`\n\t\t\t\t\tFROM #__kart_order_item as i\n\t\t\t\t\tWHERE " . $where . " ORDER BY store_id"; // ." AND o.payee_id=".$user->id; $db->setQuery($query); $orderlist['items'] = $db->loadObjectList(); $comquick2cartHelper = new comquick2cartHelper(); if (!empty($orderlist) && $orderlist['order_info'][0]->status == 'P') { $comquick2cartHelper->syncOrderItems($orderlist["items"], $order_result[0]->user_id, $orderid); } $orderlist = $this->addCountryRegionNames($orderlist); return $orderlist; }