//end if (tep_db_num_rows($download_query) > 0) {
                    }
                    //end if (DOWNLOAD_ENABLED == 'true') {
                    //end downloads
                }
                //end foreach($_POST['add_product_options'] as $option_id => $option_value_id) {
            }
            //end if (isset($_POST['add_product_options'])) {
            // Get Product Info
            //BOF Added languageid (otherwise products_name is empty)
            //$product_query = tep_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_query = tep_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 . "' and pd.language_id = '" . $languages_id . "'");
            //EOF Added languageid
            $product = tep_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 = tep_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 = tep_db_query("\r\n\t\t\tSELECT specials_new_products_price \r\n\t\t\tFROM " . TABLE_SPECIALS . " \r\n\t\t\tWHERE products_id =" . $add_product_products_id . " \r\n\t\t\tAND status");
            $new_price = tep_db_fetch_array($special_price);
            if ($new_price) {
                $product['products_price'] = $new_price['specials_new_products_price'];
            }
            //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..
                $c_id_result = tep_db_query('SELECT customers_id 
	        FROM orders 
	        WHERE orders_id="' . (int) $oID . '"');
Exemple #2
0
 function adjust_zones()
 {
     $customer_country_id = oe_get_country_id($this->customer['country']);
     $this->customer['country'] = array('id' => $customer_country_id, 'title' => $this->customer['country'], 'iso_code_2' => oe_get_country_iso_code_2($customer_country_id), 'iso_code_3' => oe_get_country_iso_code_3($customer_country_id));
     $this->customer['zone_id'] = oe_get_zone_id($customer_country_id, $this->customer['state']);
     $billing_country_id = oe_get_country_id($this->billing['country']);
     $this->billing['country'] = array('id' => $billing_country_id, 'title' => $this->billing['country'], 'iso_code_2' => oe_get_country_iso_code_2($billing_country_id), 'iso_code_3' => oe_get_country_iso_code_3($billing_country_id));
     $this->billing['zone_id'] = oe_get_zone_id($billing_country_id, $this->billing['state']);
     $delivery_country_id = oe_get_country_id($this->delivery['country']);
     $this->delivery['country'] = array('id' => $delivery_country_id, 'title' => $this->delivery['country'], 'iso_code_2' => oe_get_country_iso_code_2($delivery_country_id), 'iso_code_3' => oe_get_country_iso_code_3($delivery_country_id));
     $this->delivery['zone_id'] = oe_get_zone_id($delivery_country_id, $this->delivery['state']);
 }