function vam_get_products($session) { if (!is_array($session)) { return false; } $products_array = array(); reset($session); if (is_array($session['cart']->contents)) { while (list($products_id, ) = each($session['cart']->contents)) { $products_query = vam_db_query("select p.products_id, pd.products_name,p.products_image, p.products_model, p.products_price, p.products_discount_allowed, p.products_weight, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id='" . vam_get_prid($products_id) . "' and pd.products_id = p.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "'"); if ($products = vam_db_fetch_array($products_query)) { $prid = $products['products_id']; // dirty workaround $vamPrice = new vamPrice($session['currency'], $session['customers_status']['customers_status_id'], $_SESSION['customer_id'] ? $_SESSION['customer_id'] : ""); $products_price = $vamPrice->GetPrice($products['products_id'], $format = false, $session['cart']->contents[$products_id]['qty'], $products['products_tax_class_id'], $products['products_price']); $products_array[] = array('id' => $products_id, 'name' => $products['products_name'], 'model' => $products['products_model'], 'image' => $products['products_image'], 'price' => $products_price + attributes_price($products_id, $session), 'quantity' => $session['cart']->contents[$products_id]['qty'], 'weight' => $products['products_weight'], 'final_price' => $products_price + attributes_price($products_id, $session), 'tax_class_id' => $products['products_tax_class_id'], 'attributes' => $session['contents'][$products_id]['attributes']); } } return $products_array; } return false; }
// Get Product Info $product_query = vam_db_query("select p.products_model, p.products_price, pd.products_name, p.products_tax_class_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id where p.products_id = '" . (int) $add_product_products_id . "'"); $product = vam_db_fetch_array($product_query); $country_id = oe_get_country_id($order->delivery["country"]); $zone_id = oe_get_zone_id($country_id, $order->delivery['state']); $products_tax = vam_get_tax_rate($product['products_tax_class_id'], $country_id, $zone_id); // 2.1.3 Pull specials price from db if there is an active offer $special_price = vam_db_query("\n\t\t\tSELECT specials_new_products_price \n\t\t\tFROM " . TABLE_SPECIALS . " \n\t\t\tWHERE products_id =" . $add_product_products_id . " \n\t\t\tAND status"); $new_price = vam_db_fetch_array($special_price); if ($new_price) { $product['products_price'] = $new_price['specials_new_products_price']; } // Спец. цена //Modified 4 VAM //$product['products_price']=b2b_display_price($add_product_products_id,$product['products_price']); $products_price = $vamPrice->GetPrice($add_product_products_id, $format = true, 1, $product['products_tax_class_id'], $product['products_price'], 1); $product['products_price'] = $products_price['plain']; //End mod 4 VAM // Спец. цена - скидка //Modified 4 VAM // if ($new_price = //vam_get_products_special_price($add_product_products_id)) //{$p_products_price=$new_price;} // //$p_products_price=b2b_display_price($add_product_products_id,$p_products_price); //End mod 4 VAM //sppc patch //Set to false by default, configurable in the Order Editor section of the admin panel //thanks to whistlerxj for the original version of this patch if (ORDER_EDITOR_USE_SPPC == 'true') { // first find out the customer associated with this order ID..