function olc_get_products_price($products_id, $price_special, $quantity, &$price_real)
{
global $price_data;
// check if customer is allowed to see prices (if not -> no price calculations , show error message)
if (CUSTOMER_SHOW_PRICE) {
// load price data into array for further use!
$product_price_query = olc_db_query(SELECT . "\n\t products_price,\n\t\tproducts_discount_allowed,\n\t\tproducts_tax_class_id\n\t\tFROM " . TABLE_PRODUCTS . "\n\t\tWHERE\n\t\tproducts_id = '" . $products_id . APOS);
$product_price = olc_db_fetch_array($product_price_query);
$price_real = $product_price['products_price'];
$price_data = array('PRODUCTS_PRICE' => $price_real, 'PRODUCTS_UVP' => $price_uvp, 'PRODUCTS_DISCOUNT_ALLOWED' => $product_price['products_discount_allowed'], 'PRODUCT_TAX_CLASS_ID' => $product_price['products_tax_class_id']);
// check if user is allowed to see tax rates
if (CUSTOMER_SHOW_PRICE_TAX) {
// get tax rate for tax class
$products_tax = olc_get_tax_rate($price_data['PRODUCT_TAX_CLASS_ID']);
} else {
$products_tax = 0;
}
// end !CUSTOMER_SHOW_PRICE_TAX
$price_data['PRODUCTS_TAX_VALUE'] = $products_tax . ' %';
// check if special price is aviable for product (no product discount on special prices!)
//W. Kaiser - AJAX
$special_price = olc_get_products_special_price($products_id);
if ($special_price) {
//W. Kaiser - AJAX
$special_price = olc_add_tax($special_price, $products_tax);
$price = olc_add_tax($price_data['PRODUCTS_PRICE'], $products_tax);
$price_data['PRODUCTS_PRICE'] = $price;
$price_string = olc_format_special_price($special_price, $price, $price_special, true, $quantity, $products_tax);
} else {
// if ($special_price=olc_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!)!
$table_personal_offers = TABLE_PERSONAL_OFFERS_BY_CUSTOMERS_STATUS . CUSTOMER_STATUS_ID;
$group_price_query = olc_db_query(SELECT . "\n\t\t\tpersonal_offer\n FROM " . $table_personal_offers . "\n WHERE products_id='" . $products_id . APOS);
$group_price_data = olc_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 (CUSTOMER_SHOW_GRADUATED_PRICE) {
// check if there are graduated prices in db
// get quantity for products
// modifikations for new graduated prices
$qty = olc_get_qty($products_id);
if (!olc_get_qty($products_id)) {
$qty = $quantity;
}
$graduated_price_query = olc_db_query(SELECT . "\n\t\t\t\t\t\t\t\tmax(quantity)\n FROM " . $table_personal_offers . "\n WHERE products_id='" . $products_id . "'\n AND quantity<='" . $qty . APOS);
$graduated_price_data = olc_db_fetch_array($graduated_price_query);
// get singleprice
$graduated_price_query = olc_db_query(SELECT . "\n\t\t\t\t\t\tpersonal_offer\n\t FROM " . $table_personal_offers . "\n WHERE products_id='" . $products_id . "'\n AND quantity='" . $graduated_price_data['max(quantity)'] . APOS);
$graduated_price_data = olc_db_fetch_array($graduated_price_query);
$price_string = $graduated_price_data['personal_offer'];
}
$price_string = olc_add_tax($price_string, $products_tax);
//*$quantity;
} else {
// if ($group_price_data['personal_offer']!=EMPTY_STRING and $group_price_data['personal_offer']!='0.0000')
$price_string = olc_add_tax($price_data['PRODUCTS_PRICE'], $products_tax);
//*$quantity;
// check if product allows discount
if ($price_data['PRODUCTS_DISCOUNT_ALLOWED'] != '0.00') {
$discount = $price_data['PRODUCTS_DISCOUNT_ALLOWED'];
// check if group discount > max. discount on product
if ($discount > CUSTOMER_DISCOUNT) {
$discount = CUSTOMER_DISCOUNT;
}
// calculate price with rabatt
$rabatt_string = $price_string - $price_string / 100 * $discount;
if ($price_string == $rabatt_string) {
$price_string = olc_format_price($price_string * $quantity, $price_special, true);
} else {
$price_string = olc_format_special_price($rabatt_string, $price_string, $price_special, false, $quantity, $products_tax);
}
return $price_string;
break;
}
}
// format price & calculate currency
$price_string = olc_format_price($price_string * $quantity, $price_special, $calculate_currencies = true);
}
} else {
// return message, if not allowed to see prices
$price_string = NOT_ALLOWED_TO_SEE_PRICES;
}
return $price_string;
}
function olc_oe_products_price($products_id, $price_special, $quantity, $customer_status)
{
$customers_status_query = olc_db_query("select * from " . TABLE_CUSTOMERS_STATUS . " where customers_status_id = '" . $customer_status . "' ");
$customers_status = olc_db_fetch_array($customers_status_query);
// check if customer is allowed to see prices (if not -> no price calculations , show error message)
if ($customers_status[customers_status_show_price] == '1') {
// load price data into array for further use!
$product_price_query = olc_db_query("SELECT products_price,\n\t\t\t\t\t\t\t\t\t\t\tproducts_discount_allowed,\n\t\t\t\t\t\t\t\t\t\t\tproducts_tax_class_id\n\t\t\t\t\t\t\t\t\t\t\tFROM " . TABLE_PRODUCTS . " \n\t\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\tproducts_id = '" . $products_id . APOS);
$product_price = olc_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 = olc_get_tax_rate($price_data['PRODUCT_TAX_CLASS_ID']);
// check if user is allowed to see tax rates
if ($customers_status['customers_status_show_price_tax'] == '0') {
$products_tax = '';
}
// end $customers_status['customers_status_show_price_tax'] =='0'
// check if special price is aviable for product (no product discount on special prices!)
if ($special_price = olc_get_products_special_price($products_id)) {
$special_price = olc_add_tax($special_price, $products_tax);
$price_data['PRODUCTS_PRICE'] = olc_add_tax($price_data['PRODUCTS_PRICE'], $products_tax);
$price_string = olc_format_special_price($special_price, $price_data['PRODUCTS_PRICE'], $price_special, $calculate_currencies = true, $quantity, $products_tax);
} else {
// if ($special_price=olc_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 = olc_db_query("SELECT personal_offer\n\t\t\t\t\t\t\t\t\t FROM " . TABLE_PERSONAL_OFFERS_BY_CUSTOMERS_STATUS . $customers_status['customers_status_id'] . "\n\t\t\t\t\t\t\t\t\t WHERE products_id='" . $products_id . APOS);
$group_price_data = olc_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 ($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 = olc_get_qty($products_id);
if (!olc_get_qty($products_id)) {
$qty = $quantity;
}
$graduated_price_query = olc_db_query("SELECT max(quantity)\n\t\t\t\t\t\t\t\t\t FROM " . TABLE_PERSONAL_OFFERS_BY_CUSTOMERS_STATUS . $customers_status['customers_status_id'] . "\n\t\t\t\t\t\t\t\t\t WHERE products_id='" . $products_id . "'\n\t\t\t\t\t\t\t\t\t AND quantity<='" . $qty . APOS);
$graduated_price_data = olc_db_fetch_array($graduated_price_query);
// get singleprice
$graduated_price_query = olc_db_query("SELECT personal_offer\n\t\t\t\t\t FROM " . TABLE_PERSONAL_OFFERS_BY_CUSTOMERS_STATUS . $customers_status['customers_status_id'] . "\n\t\t\t\t\t\t\t\t\t WHERE products_id='" . $products_id . "'\n\t\t\t\t\t\t\t\t\t AND quantity='" . $graduated_price_data['max(quantity)'] . APOS);
$graduated_price_data = olc_db_fetch_array($graduated_price_query);
$price_string = $graduated_price_data['personal_offer'];
}
// end $_SESSION['customers_status']['customers_status_graduated_prices']=='1'
$price_string = olc_add_tax($price_string, $products_tax);
//*$quantity;
} else {
// if ($group_price_data['personal_offer']!='' and $group_price_data['personal_offer']!='0.0000')
$price_string = olc_add_tax($price_data['PRODUCTS_PRICE'], $products_tax);
//*$quantity;
// check if product allows discount
if ($price_data['PRODUCTS_DISCOUNT_ALLOWED'] != '0.00') {
$discount = $price_data['PRODUCTS_DISCOUNT_ALLOWED'];
// check if group discount > max. discount on product
if ($discount > $customers_status['customers_status_discount']) {
$discount = $customers_status['customers_status_discount'];
}
// calculate price with rabatt
$rabatt_string = $price_string - $price_string / 100 * $discount;
if ($price_string == $rabatt_string) {
$price_string = olc_format_price($price_string * $quantity, $price_special, $calculate_currencies = true);
} else {
$price_string = olc_format_special_price($rabatt_string, $price_string, $price_special, $calculate_currencies = false, $quantity, $products_tax);
}
return $price_string;
break;
}
}
// format price & calculate currency
if ($price_string == '0.00') {
$price_string = TEXT_NO_PRICE;
} else {
$price_string = olc_format_price($price_string * $quantity, $price_special, $calculate_currencies = true);
}
}
} else {
// return message, if not allowed to see prices
$price_string = NOT_ALLOWED_TO_SEE_PRICES;
}
// end ($customers_status['customers_status_show_price'] == '1')
return $price_string;
}