cart->clear(); ]]> load->model('checkout/order'); $this->data['orderDetails'] = $this->model_checkout_order->getOrder($this->session->data['order_id']); $this->data['orderProducts'] = $this->model_checkout_order->getOrderProducts($this->session->data['order_id']); $this->data['orderShipping'] = $this->model_checkout_order->getOrderShipping($this->session->data['order_id']); $this->data['orderTax'] = $this->model_checkout_order->getOrderTax($this->session->data['order_id']); ]]> db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'"); return $query->rows; } public function getOrderShipping($order_id) { $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_total WHERE order_id = '" . (int)$order_id . "' AND code = 'shipping' AND EXISTS (SELECT * FROM " . DB_PREFIX . "order_total WHERE order_id = '" . (int)$order_id . "' AND code = 'shipping') UNION SELECT 0, ". (int)$order_id. ", '', '', '', 0, 0 FROM " . DB_PREFIX . "order_total WHERE NOT EXISTS (SELECT * FROM " . DB_PREFIX . "order_total WHERE order_id = '" . (int)$order_id . "' AND code = 'shipping')"); return $query->rows; } public function getOrderTax($order_id) { $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_total WHERE order_id = '" . (int)$order_id . "' AND code = 'tax' AND EXISTS (SELECT * FROM " . DB_PREFIX . "order_total WHERE order_id = '" . (int)$order_id . "' AND code = 'tax') UNION SELECT 0, ". (int)$order_id. ", '', '', '', 0, 0 FROM " . DB_PREFIX . "order_total WHERE NOT EXISTS (SELECT * FROM " . DB_PREFIX . "order_total WHERE order_id = '" . (int)$order_id . "' AND code = 'tax')"); return $query->rows; } ]]> ]]> ]]>