function xtc_get_products_price_export($products_id, $price_special, $quantity, $group_id = 0, $add_tax = 1, $currency, $calculate_currencies = true)
{
// load price data into array for further use!
$product_price_query = xtc_db_query("SELECT products_price,\n products_discount_allowed,\n products_tax_class_id\n FROM " . TABLE_PRODUCTS . "\n WHERE\n products_id = '" . $products_id . "'");
$product_price = xtc_db_fetch_array($product_price_query);
$price_data = array();
$price_data = array('PRODUCTS_PRICE' => $product_price['products_price'], 'PRODUCTS_DISCOUNT_ALLOWED' => $product_price['products_discount_allowed'], 'PRODUCT_TAX_CLASS_ID' => $product_price['products_tax_class_id']);
// get tax rate for tax class
$products_tax = xtc_get_tax_rate_export($price_data['PRODUCT_TAX_CLASS_ID']);
// check if user is allowed to see tax rates
if ($add_tax == '0') {
$products_tax = '';
}
// end $_SESSION['customers_status']['customers_status_show_price_tax'] =='0'
// check if special price is available for product (no product discount on special prices!)
if ($special_price = xtc_get_products_special_price($products_id)) {
$special_price = xtc_add_tax($special_price, $products_tax);
$price_data['PRODUCTS_PRICE'] = xtc_add_tax($price_data['PRODUCTS_PRICE'], $products_tax);
$price_string = xtc_format_special_price_export($special_price, $price_data['PRODUCTS_PRICE'], $price_special, $calculate_currencies = true, $quantity, $products_tax, $add_tax, $currency);
} else {
// if ($special_price=xtc_get_products_special_price($products_id))
// Check if there is another price for customers_group (if not, take norm price and calculte discounts (NOTE: no discount on group PRICES(only OT DISCOUNT!)!
$group_price_query = xtc_db_query("SELECT personal_offer\n FROM personal_offers_by_customers_status_" . $group_id . "\n WHERE products_id='" . $products_id . "'");
$group_price_data = xtc_db_fetch_array($group_price_query);
// if we found a price, everything is ok if not, we will use normal price
if ($group_price_data['personal_offer'] != '' and $group_price_data['personal_offer'] != '0.0000') {
$price_string = $group_price_data['personal_offer'];
// check if customer is allowed to get graduated prices
// if ($_SESSION['customers_status']['customers_status_graduated_prices']=='1'){
// check if there are graduated prices in db
// get quantity for products
// modifikations for new graduated prices
$qty = xtc_get_qty($products_id);
if (!xtc_get_qty($products_id)) {
$qty = $quantity;
}
$graduated_price_query = xtc_db_query("SELECT max(quantity)\n FROM personal_offers_by_customers_status_" . $group_id . "\n WHERE products_id='" . $products_id . "'\n AND quantity<='" . $qty . "'");
$graduated_price_data = xtc_db_fetch_array($graduated_price_query);
// get singleprice
$graduated_price_query = xtc_db_query("SELECT personal_offer\n FROM personal_offers_by_customers_status_" . $group_id . "\n WHERE products_id='" . $products_id . "'\n AND quantity='" . $graduated_price_data['max(quantity)'] . "'");
$graduated_price_data = xtc_db_fetch_array($graduated_price_query);
$price_string = $graduated_price_data['personal_offer'];
// } // end $_SESSION['customers_status']['customers_status_graduated_prices']=='1'
$price_string = xtc_add_tax($price_string, $products_tax);
//*$quantity;
} else {
// if ($group_price_data['personal_offer']!='' and $group_price_data['personal_offer']!='0.0000')
$price_string = xtc_add_tax($price_data['PRODUCTS_PRICE'], $products_tax);
//*$quantity;
// check if product allows discount
}
// format price & calculate currency
$price_string = $price_string * $quantity;
// currency calculations
$currencies_query = xtc_db_query("SELECT *\n FROM " . TABLE_CURRENCIES . " WHERE\n code = '" . $currency . "'");
$currencies_value = xtc_db_fetch_array($currencies_query);
$currencies_data = array();
$currencies_data = array('SYMBOL_LEFT' => $currencies_value['symbol_left'], 'SYMBOL_RIGHT' => $currencies_value['symbol_right'], 'DECIMAL_PLACES' => $currencies_value['decimal_places'], 'VALUE' => $currencies_value['value']);
if ($calculate_currencies == 'true') {
$price_string = $price_string * $currencies_data['VALUE'];
}
$price_string = xtc_precision($price_string, $currencies_data['DECIMAL_PLACES']);
if ($price_special == '1') {
$currencies_query = xtc_db_query("SELECT *\n FROM " . TABLE_CURRENCIES . " WHERE\n code = '" . $currency . "'");
$currencies_value = xtc_db_fetch_array($currencies_query);
$price_string = number_format($price_string, $currencies_data['DECIMAL_PLACES'], $currencies_value['decimal_point'], $currencies_value['thousands_point']);
if ($show_currencies == 1) {
$price_string = $currencies_data['SYMBOL_LEFT'] . ' ' . $price_string . ' ' . $currencies_data['SYMBOL_RIGHT'];
}
}
}
//}
return $price_string;
// return $price_data['PRODUCTS_PRICE'];
}
/**
* Searches the graduated price of a product for a specified quantity
*
* @param Integer $pID product id
* @param Double $qty quantity
* @return Double graduated price
*/
function xtcGetGraduatedPrice($pID, $qty)
{
if (defined('GRADUATED_ASSIGN') && GRADUATED_ASSIGN == 'true') {
$actual_content_qty = xtc_get_qty($pID);
$qty = $actual_content_qty > $qty ? $actual_content_qty : $qty;
}
if (empty($this->actualGroup)) {
$this->actualGroup = DEFAULT_CUSTOMERS_STATUS_ID_GUEST;
}
$graduated_price_query = xtDBquery("SELECT max(quantity) AS qty\n FROM " . TABLE_PERSONAL_OFFERS_BY . $this->actualGroup . "\n WHERE products_id='" . $pID . "'\n AND quantity<='" . $qty . "'");
$graduated_price_data = xtc_db_fetch_array($graduated_price_query, true);
if ($graduated_price_data['qty']) {
$graduated_price_query = xtDBquery("SELECT personal_offer\n FROM " . TABLE_PERSONAL_OFFERS_BY . $this->actualGroup . "\n WHERE products_id='" . $pID . "'\n AND quantity='" . $graduated_price_data['qty'] . "'");
$graduated_price_data = xtc_db_fetch_array($graduated_price_query, true);
$sPrice = $graduated_price_data['personal_offer'];
if ($sPrice != 0.0) {
return $sPrice;
}
} else {
return;
}
}