/** * Get the product variation combination record * * Method will return the product variation combination record * * @access public * @param int $variationId The product variation combination ID * @param int $productId The optional product ID for the combination * @param bool $mergeProductDetails TRUE to also get the product details, FALSE not to. Default is TRUE * @return array The product variation combination array on success, NULL if no record could be found, FALSE on error */ public function get($variationId, $productId='', $mergeProductDetails=true) { $variation = parent::get($variationId); if (!is_array($variation)) { return false; } if (isId($productId) && (!isset($variation["vcproductid"]) || $variation["vcproductid"] !== $productId)) { return false; } /** * Merge in the product details if we can */ if ($mergeProductDetails && isset($variation["vcproductid"]) && isId($variation["vcproductid"])) { $product = $this->productEntity->get($variation["vcproductid"]); if (is_array($product)) { $variation += $product; } } return $variation; }
public function get($orderId) { $order = parent::get($orderId); if (!$order) { return false; } $order["customer"] = false; if (isId($order["ordcustid"])) { $customer = $this->customer->get($order["ordcustid"]); $order["customer"] = $customer; } $order["products"] = array(); $query = "SELECT * FROM [|PREFIX|]order_products WHERE orderorderid = " . (int)$orderId; $result = $GLOBALS["ISC_CLASS_DB"]->Query($query); while ($row = $GLOBALS["ISC_CLASS_DB"]->Fetch($result)) { $prod = $this->product->get($row["ordprodid"]); if ($prod) { $prod["prodorderquantity"] = $row["ordprodqty"]; if(GetConfig('taxDefaultTaxDisplayOrders') == TAX_PRICES_DISPLAY_INCLUSIVE) { $prod['prodorderamount'] = $row['price_inc_tax']; } else { $prod['prodorderamount'] = $row['price_ex_tax']; } $prod["prodordvariationid"] = $row["ordprodvariationid"]; $prod["prodorderid"] = $row["orderprodid"]; $order["products"][] = $prod; } } return $order; }