function quote($method = '')
{
global $order, $shipping_weight, $shipping_num_boxes;
if (!$order) {
$order = new order();
$shipping_weight = $_SESSION['cart']->show_weight();
}
$order_delivery_country = $order->delivery['country'];
if (MODULE_SHIPPING_TABLE_MODE == 'price') {
$order_total = $_SESSION['cart']->show_total();
} else {
$order_total = $shipping_weight;
}
$table_cost = split("[:,]", MODULE_SHIPPING_TABLE_COST);
$size = sizeof($table_cost);
for ($i = 0, $n = $size; $i < $n; $i += 2) {
if ($order_total <= $table_cost[$i]) {
$shipping = $table_cost[$i + 1];
break;
}
}
if (MODULE_SHIPPING_TABLE_MODE == 'weight') {
$shipping = $shipping * $shipping_num_boxes;
}
$this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_TABLE_TEXT_TITLE, 'methods' => array(array('id' => $this->code, 'title' => MODULE_SHIPPING_TABLE_TEXT_WAY, 'cost' => $shipping + MODULE_SHIPPING_TABLE_HANDLING)));
if ($this->tax_class > 0) {
$this->quotes['tax'] = olc_get_tax_rate($this->tax_class, $order_delivery_country['id'], $order->delivery['zone_id']);
}
if (olc_not_null($this->icon)) {
$this->quotes['icon'] = olc_image($this->icon, $this->title);
}
return $this->quotes;
}
function olc_format_price_graduated($price_string, $price_special, $calculate_currencies, $products_tax_class)
{
if ((int) $price_string == 0) {
$price_string = EMPTY_STRING;
} else {
include DIR_FS_INC . 'olc_get_currency_parameters.inc.php';
if ($calculate_currencies == TRUE_STRING_S) {
$price_string = $price_string * CURRENCY_VALUE;
}
// add tax
if ($_SESSION['customers_status']['customers_status_show_price_tax'] != '0') {
$products_tax = olc_get_tax_rate($products_tax_class);
$price_string = olc_add_tax($price_string, $products_tax);
}
// round price
$price_string = olc_precision($price_string, CURRENCY_DECIMAL_PLACES);
if ($price_special == '1') {
$price_string = number_format($price_string, CURRENCY_DECIMAL_PLACES, CURRENCY_DECIMAL_POINT, CURRENCY_THOUSANDS_POINT);
$price_string = CURRENCY_SYMBOL_LEFT . $price_string . CURRENCY_SYMBOL_RIGHT;
}
//1,00 -> 1,--
global $is_print_version, $is_pdf;
if ($is_print_version) {
if ($is_pdf) {
$s = CURRENCY_DECIMAL_ZEROES_DASHES_PRINT_PDF;
} else {
$s = CURRENCY_DECIMAL_ZEROES_DASHES_PRINT;
}
} else {
$s = CURRENCY_DECIMAL_ZEROES_DASHES;
}
$price_string = str_replace(CURRENCY_DECIMAL_ZEROES, $s, $price_string);
}
return $price_string;
}
function olc_get_products_attribute_price($attribute_price, $tax_class, $price_special, $quantity, $prefix, $calculate_currencies = TRUE_STRING_S)
{
if ($_SESSION['customers_status']['customers_status_show_price'] == '1') {
$attribute_tax = olc_get_tax_rate($tax_class);
// check if user is allowed to see tax rates
if ($_SESSION['customers_status']['customers_status_show_price_tax'] == '0') {
$attribute_tax = '';
}
// add tax
$price_string = olc_add_tax($attribute_price, $attribute_tax) * $quantity;
if ($_SESSION['customers_status']['customers_status_discount_attributes'] == '0') {
// format price & calculate currency
$price_string = olc_format_price($price_string, $price_special, $calculate_currencies);
if ($price_special == '1') {
$price_string = BLANK . $prefix . BLANK . $price_string . BLANK;
}
} else {
$discount = $_SESSION['customers_status']['customers_status_discount'];
$rabatt_string = $price_string - $price_string / 100 * $discount;
$price_string = olc_format_price($price_string, $price_special, $calculate_currencies);
$rabatt_string = olc_format_price($rabatt_string, $price_special, $calculate_currencies);
if ($price_special == '1' && $price_string != $rabatt_string) {
$price_string = BLANK . $prefix . '<font color="ff0000"><s>' . $price_string . '</s></font> ' . $rabatt_string . BLANK;
} else {
$price_string = $rabatt_string;
if ($price_special == '1') {
$price_string = BLANK . $prefix . BLANK . $price_string;
}
}
}
} else {
$price_string = ' ' . NOT_ALLOWED_TO_SEE_PRICES;
}
return $price_string;
}
function process()
{
global $order, $currencies;
if (MODULE_ORDER_TOTAL_VERPACKUNG_LOW_ORDER_FEE == TRUE_STRING_S) {
switch (MODULE_ORDER_TOTAL_VERPACKUNG_DESTINATION) {
case 'national':
if ($order->delivery['country_id'] == STORE_COUNTRY) {
$pass = true;
}
break;
case 'international':
if ($order->delivery['country_id'] != STORE_COUNTRY) {
$pass = true;
}
break;
case 'both':
$pass = true;
break;
default:
$pass = false;
break;
}
if ($pass == true && $order->info['total'] - $order->info['verpackung_cost'] < MODULE_ORDER_TOTAL_VERPACKUNG_ORDER_UNDER) {
$tax = olc_get_tax_rate(MODULE_ORDER_TOTAL_VERPACKUNG_TAX_CLASS, $order->delivery['country']['id'], $order->delivery['zone_id']);
$tax_description = olc_get_tax_description(MODULE_ORDER_TOTAL_VERPACKUNG_TAX_CLASS, $order->delivery['country']['id'], $order->delivery['zone_id']);
$order->info['tax'] += olc_calculate_tax(MODULE_ORDER_TOTAL_VERPACKUNG_FEE, $tax);
$order->info['tax_groups']["{$tax_description}"] += olc_calculate_tax(MODULE_ORDER_TOTAL_VERPACKUNG_FEE, $tax);
$order->info['total'] += MODULE_ORDER_TOTAL_VERPACKUNG_FEE + olc_calculate_tax(MODULE_ORDER_TOTAL_VERPACKUNG_FEE, $tax);
$this->output[] = array('title' => $this->title . ':', 'text' => $currencies->format(olc_add_tax(MODULE_ORDER_TOTAL_VERPACKUNG_FEE, $tax), true, $order->info['currency'], $order->info['currency_value']), 'value' => olc_add_tax(MODULE_ORDER_TOTAL_VERPACKUNG_FEE, $tax));
}
}
}
function get_order_total()
{
global $order, $cart;
$order_total = $order->info['total'];
// Check if gift voucher is in cart and adjust total
$products = $cart->get_products();
for ($i = 0; $i < sizeof($products); $i++) {
$t_prid = olc_get_prid($products[$i]['id']);
$gv_query = olc_db_query("select products_price, products_tax_class_id, products_model from " . TABLE_PRODUCTS . " where products_id = '" . $t_prid . APOS);
$gv_result = olc_db_fetch_array($gv_query);
if (ereg('^GIFT', addslashes($gv_result['products_model']))) {
$qty = $cart->get_quantity($t_prid);
$products_tax = olc_get_tax_rate($gv_result['products_tax_class_id']);
if ($this->include_tax == FALSE_STRING_S) {
$gv_amount = $gv_result['products_price'] * $qty;
} else {
$gv_amount = ($gv_result['products_price'] + olc_calculate_tax($gv_result['products_price'], $products_tax)) * $qty;
}
$order_total = $order_total - $gv_amount;
}
}
if ($this->include_tax == FALSE_STRING_S) {
$order_total = $order_total - $order->info['tax'];
}
if ($this->include_shipping == FALSE_STRING_S) {
$order_total = $order_total - $order->info['shipping_cost'];
}
return $order_total;
}
function process()
{
global $order, $currencies;
if (MODULE_ORDER_TOTAL_LOWORDERFEE_LOW_ORDER_FEE == TRUE_STRING_S) {
$pass = false;
if ($_SESSION['shipping']['id'] != 'selfpickup_selfpickup') {
$country = $order->delivery['country_id'];
switch (MODULE_ORDER_TOTAL_LOWORDERFEE_DESTINATION) {
case 'national':
if ($country == STORE_COUNTRY) {
$pass = true;
}
break;
case 'international':
if ($country != STORE_COUNTRY) {
$pass = true;
}
break;
case 'both':
$pass = true;
break;
}
}
if ($pass) {
if ($order->info['total'] - $order->info['shipping_cost'] < MODULE_ORDER_TOTAL_LOWORDERFEE_ORDER_UNDER) {
$delivery_country = $order->delivery['country']['id'];
$delivery_zone_id = $order->delivery['zone_id'];
$tax = olc_get_tax_rate(MODULE_ORDER_TOTAL_LOWORDERFEE_TAX_CLASS, $delivery_country, $delivery_zone_id);
$tax_description = olc_get_tax_description(MODULE_ORDER_TOTAL_LOWORDERFEE_TAX_CLASS, $delivery_country, $delivery_zone_id);
$low_order_fee = MODULE_ORDER_TOTAL_LOWORDERFEE_FEE;
$low_order_fee_tax = olc_calculate_tax($low_order_fee, $tax);
$low_order_fee = olc_add_tax($low_order_fee, $tax);
if ($_SESSION['customers_status']['customers_status_show_price_tax'] == 1) {
$order->info['tax'] += $low_order_fee_tax;
$order->info['tax_groups'][TAX_ADD_TAX . "{$tax_description}"] += $low_order_fee_tax;
$order->info['total'] += $low_order_fee;
} else {
if ($_SESSION['customers_status']['customers_status_add_tax_ot'] == 1) {
$order->info['tax'] += $low_order_fee_tax;
$order->info['tax_groups'][TAX_NO_TAX . "{$tax_description}"] += $low_order_fee_tax;
}
$order->info['subtotal'] += $low_order_fee;
$order->info['total'] += $low_order_fee;
}
$this->output[] = array('title' => $this->title . ':', 'text' => olc_format_price($low_order_fee, 1, 1, 1), 'value' => $low_order_fee);
}
}
}
}
function process()
{
global $order, $currencies, $customer_id;
// if (MODULE_ORDER_TOTAL_HANDLING_HANDLING == TRUE_STRING_S) {
$freequery = olc_db_query("SELECT SUM(cb.customers_basket_quantity) AS total FROM " . TABLE_CUSTOMERS_BASKET . " cb LEFT JOIN " . TABLE_PRODUCTS . " p ON cb.products_id = p.products_id WHERE cb.customers_id = '" . $customer_id . "' AND cb.final_price < '0.01' AND p.products_price < '0.01'");
$freestuff = olc_db_fetch_array($freequery);
$freeitems = $freestuff['total'];
$handlingfree = $order->info['subtotal'] / 100 * 0.85;
$tax = olc_get_tax_rate(MODULE_ORDER_TOTAL_HANDLING_TAX_CLASS, $order->delivery['country']['id'], $order->delivery['zone_id']);
$tax_description = olc_get_tax_description(MODULE_ORDER_TOTAL_HANDLING_TAX_CLASS, $order->delivery['country']['id'], $order->delivery['zone_id']);
$order->info['tax'] += olc_calculate_tax($handlingfree, $tax);
$order->info['tax_groups']["{$tax_description}"] += olc_calculate_tax($handlingfree, $tax);
$order->info['total'] += $handlingfree + olc_calculate_tax($handlingfree, $tax);
$this->output[] = array('title' => $this->title . ':', 'text' => olc_format_price(olc_add_tax($handlingfree, $tax), true, $order->info['currency'], $order->info['currency_value']), 'value' => olc_add_tax($handlingfree, $tax));
}
function olcGetPrice($pID, $format = true, $qty, $tax_class, $pPrice, $vpeStatus = 0, $cedit_id = 0, $show_tax = 0)
{
// check if group is allowed to see prices
if ($this->cStatus['customers_status_show_price'] == '0') {
return $this->olcShowNote($vpeStatus, $vpeStatus);
}
// get Tax rate
if ($cedit_id != 0) {
$cinfo = olc_oe_customer_infos($cedit_id);
$products_tax = olc_get_tax_rate($tax_class, $cinfo['country_id'], $cinfo['zone_id']);
} else {
$products_tax = $this->TAX[$tax_class];
}
if ($show_tax == 0) {
if ($this->cStatus['customers_status_show_price_tax'] == '0') {
$products_tax = '';
}
}
// add taxes
if ($pPrice == 0) {
$pPrice = $this->getPprice($pID);
}
$pPrice = $this->olcAddTax($pPrice, $products_tax);
// check specialprice
if ($sPrice = $this->olcCheckSpecial($pID)) {
return $this->olcFormatSpecial($pID, $this->olcAddTax($sPrice, $products_tax), $pPrice, $format, $vpeStatus);
}
// check graduated
if ($this->cStatus['customers_status_graduated_prices'] == '1') {
if ($sPrice = $this->olcGetGraduatedPrice($pID, $qty)) {
return $this->olcFormatSpecialGraduated($pID, $this->olcAddTax($sPrice, $products_tax), $pPrice, $format, $vpeStatus, $pID);
}
} else {
// check Group Price
if ($sPrice = $this->olcGetGroupPrice($pID, 1)) {
return $this->olcFormatSpecialGraduated($pID, $this->olcAddTax($sPrice, $products_tax), $pPrice, $format, $vpeStatus, $pID);
}
}
// check Product Discount
if ($discount = $this->olcCheckDiscount($pID)) {
return $this->olcFormatSpecialDiscount($pID, $discount, $pPrice, $format, $vpeStatus);
}
return $this->olcFormat($pPrice, $format, 0, false, $vpeStatus, $pID);
}
function quote($method = '')
{
global $order, $total_count;
if (!$order) {
$order = new order();
}
if (!$shipping_weight) {
$shipping_weight = $_SESSION['cart']->show_weight();
}
$order_delivery_country = $order->delivery['country'];
$this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_ITEM_TEXT_TITLE, 'methods' => array(array('id' => $this->code, 'title' => MODULE_SHIPPING_ITEM_TEXT_WAY, 'cost' => MODULE_SHIPPING_ITEM_COST * $total_count + MODULE_SHIPPING_ITEM_HANDLING)));
if ($this->tax_class > 0) {
$this->quotes['tax'] = olc_get_tax_rate($this->tax_class, $order_delivery_country['id'], $order->delivery['zone_id']);
}
if (olc_not_null($this->icon)) {
$this->quotes['icon'] = olc_image($this->icon, $this->title);
}
return $this->quotes;
}
function olc_oe_get_products_attribute_price($attribute_price, $tax_class, $price_special, $quantity, $prefix, $calculate_currencies = TRUE_STRING_S, $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);
if ($customers_status['customers_status_show_price'] == '1') {
$attribute_tax = olc_get_tax_rate($tax_class);
// check if user is allowed to see tax rates
if ($customers_status['customers_status_show_price_tax'] == '0') {
$attribute_tax = '';
}
// add tax
$price_string = olc_add_tax($attribute_price, $attribute_tax) * $quantity;
if ($customers_status['customers_status_discount_attributes'] == '0') {
// format price & calculate currency
$price_string = olc_format_price($price_string, $price_special, $calculate_currencies);
if ($price_special == '1') {
$price_string = BLANK . $prefix . BLANK . $price_string . BLANK;
}
} else {
$discount = $customers_status['customers_status_discount'];
$rabatt_string = $price_string - $price_string / 100 * $discount;
$price_string = olc_format_price($price_string, $price_special, $calculate_currencies);
$rabatt_string = olc_format_price($rabatt_string, $price_special, $calculate_currencies);
if ($price_special == '1' && $price_string != $rabatt_string) {
$price_string = BLANK . $prefix . '<font color="ff0000"><s>' . $price_string . '</s></font> ' . $rabatt_string . BLANK;
} else {
$price_string = $rabatt_string;
if ($price_special == '1') {
$price_string = BLANK . $prefix . BLANK . $price_string;
}
}
}
} else {
$price_string = ' ' . NOT_ALLOWED_TO_SEE_PRICES;
}
return $price_string;
}
function process()
{
global $order, $currencies, $cod_cost, $cod_country, $shipping;
if (strtolower(MODULE_ORDER_TOTAL_COD_STATUS) == TRUE_STRING_S) {
//Will become true, if cod can be processed.
$cod_country = false;
//check if payment method is cod. If yes, check if cod is possible.
if ($_SESSION['payment'] == 'cod') {
//process installed shipping modules
$shipping_id = $_SESSION['shipping']['id'];
$split_text = "[:,]";
if ($shipping_id == 'flat_flat') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_FLAT);
} elseif ($shipping_id == 'item_item') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_ITEM);
} elseif ($shipping_id == 'table_table') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_TABLE);
} elseif ($shipping_id == 'zones_zones') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_ZONES);
} elseif ($shipping_id == 'ap_ap') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_AP);
} elseif ($shipping_id == 'dp_dp') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_DP);
} elseif ($shipping_id == 'dpd_dpd') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_DPD);
} elseif ($shipping_id == 'ups_ups') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_UPS);
} elseif ($shipping_id == 'upse_upse') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_UPSE);
} elseif ($shipping_id == 'freeamountausl_freeamountausl') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_FREEAMOUNTAUSL);
} elseif ($shipping_id == 'freeamount_freeamount') {
$cod_zones = split($split_text, MODULE_ORDER_TOTAL_COD_FEE_FREEAMOUNT);
}
$country_iso_code_2 = $order->billing['country']['iso_code_2'];
for ($i = 0; $i < count($cod_zones); $i++) {
if ($cod_zones[$i] == $country_iso_code_2) {
$cod_cost = $cod_zones[$i + 1];
$cod_country = true;
//print('match' . $cod_zones[$i] . ': ' . $cod_cost);
break;
} elseif ($cod_zones[$i] == '00') {
$cod_cost = $cod_zones[$i + 1];
$cod_country = true;
//print('match' . $i . ': ' . $cod_cost);
break;
} else {
//print('no match');
}
$i++;
}
} else {
//COD selected, but no shipping module which offers COD
}
if ($cod_country) {
$cod_tax = olc_get_tax_rate(MODULE_ORDER_TOTAL_COD_TAX_CLASS, $order->delivery['country']['id'], $order->delivery['zone_id']);
$cod_tax_description = olc_get_tax_description(MODULE_ORDER_TOTAL_COD_TAX_CLASS, $order->delivery['country']['id'], $order->delivery['zone_id']);
if ($_SESSION['customers_status']['customers_status_show_price_tax'] == 1) {
$order->info['tax'] += olc_add_tax($cod_cost, $cod_tax) - $cod_cost;
$order->info['tax_groups'][TAX_ADD_TAX . "{$cod_tax_description}"] += olc_add_tax($cod_cost, $cod_tax) - $cod_cost;
$order->info['total'] += $cod_cost + (olc_add_tax($cod_cost, $cod_tax) - $cod_cost);
$cod_cost_value = olc_add_tax($cod_cost, $cod_tax);
$cod_cost = olc_format_price($cod_cost_value, $price_special = 1, $calculate_currencies = true);
}
if ($_SESSION['customers_status']['customers_status_show_price_tax'] == 0 && $_SESSION['customers_status']['customers_status_add_tax_ot'] == 1) {
$order->info['tax'] += olc_add_tax($cod_cost, $cod_tax) - $cod_cost;
$order->info['tax_groups'][TAX_NO_TAX . "{$cod_tax_description}"] += olc_add_tax($cod_cost, $cod_tax) - $cod_cost;
$cod_cost_value = $cod_cost;
$cod_cost = olc_format_price($cod_cost, $price_special = 1, $calculate_currencies = true);
$order->info['subtotal'] += $cod_cost_value;
$order->info['total'] += $cod_cost_value;
}
if (!$cod_cost_value) {
$cod_cost_value = $cod_cost;
$cod_cost = olc_format_price($cod_cost, $price_special = 1, $calculate_currencies = true);
$order->info['total'] += $cod_cost_value;
}
$this->output[] = array('title' => $this->title . ':', 'text' => $cod_cost, 'value' => $cod_cost_value);
} else {
//Following code should be improved if we can't get the shipping modules disabled, who don't allow COD
// as well as countries who do not have cod
// $this->output[] = array('title' => $this->title . ':',
// 'text' => 'No COD for this module.',
// 'value' => '');
}
}
}
function quote($method = '')
{
global $order, $shipping_weight, $shipping_num_boxes;
if (!$order) {
$order = new order();
}
if (!$shipping_weight) {
$shipping_weight = $_SESSION['cart']->show_weight();
}
$order_delivery_country = $order->delivery['country'];
$dest_country = $order_delivery_country['iso_code_2'];
$dest_zone = 0;
$error = false;
for ($j = 1; $j <= $this->num_chp; $j++) {
$countries_table = constant('MODULE_SHIPPING_CHP_COUNTRIES_' . $j);
$country_zones = split("[,]", $countries_table);
if (in_array($dest_country, $country_zones)) {
$dest_zone = $j;
break;
}
}
if ($dest_zone == 0) {
$error = true;
} else {
$shipping = -1;
$chp_cost_eco = @constant('MODULE_SHIPPING_CHP_COST_ECO_' . $j);
$chp_cost_pri = @constant('MODULE_SHIPPING_CHP_COST_PRI_' . $j);
$chp_cost_urg = @constant('MODULE_SHIPPING_CHP_COST_URG_' . $j);
$methods = array();
if ($chp_cost_eco != '') {
$chp_table_eco = split("[:,]", $chp_cost_eco);
for ($i = 0; $i < sizeof($chp_table_eco); $i += 2) {
if ($shipping_weight <= $chp_table_eco[$i]) {
$shipping_eco = $chp_table_eco[$i + 1];
break;
}
}
if ($shipping_eco == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_CHP_UNDEFINED_RATE;
} else {
$shipping_cost_1 = $shipping_eco + MODULE_SHIPPING_CHP_HANDLING;
}
if ($shipping_eco != 0) {
$methods[] = array('id' => 'ECO', 'title' => 'Economy', 'cost' => (MODULE_SHIPPING_CHP_HANDLING + $shipping_cost_1) * $shipping_num_boxes);
}
}
if ($chp_cost_pri != '') {
$chp_table_pri = split("[:,]", $chp_cost_pri);
for ($i = 0; $i < sizeof($chp_table_pri); $i += 2) {
if ($shipping_weight <= $chp_table_pri[$i]) {
$shipping_pri = $chp_table_pri[$i + 1];
break;
}
}
if ($shipping_pri == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_CHP_UNDEFINED_RATE;
} else {
$shipping_cost_2 = $shipping_pri + MODULE_SHIPPING_CHP_HANDLING;
}
if ($shipping_pri != 0) {
$methods[] = array('id' => 'PRI', 'title' => 'Priority', 'cost' => (MODULE_SHIPPING_CHP_HANDLING + $shipping_cost_2) * $shipping_num_boxes);
}
}
if ($chp_cost_urg != '') {
$chp_table_urg = split("[:,]", $chp_cost_urg);
for ($i = 0; $i < sizeof($chp_table_urg); $i += 2) {
if ($shipping_weight <= $chp_table_urg[$i]) {
$shipping_urg = $chp_table_urg[$i + 1];
break;
}
}
if ($shipping_urg == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_CHP_UNDEFINED_RATE;
} else {
$shipping_cost_3 = $shipping_urg + MODULE_SHIPPING_CHP_HANDLING;
}
if ($shipping_urg != 0) {
$methods[] = array('id' => 'URG', 'title' => 'Urgent', 'cost' => (MODULE_SHIPPING_CHP_HANDLING + $shipping_cost_3) * $shipping_num_boxes);
}
}
}
$this->quotes = array('id' => $this->code, 'module' => $this->title . LPAREN . $shipping_num_boxes . ' x ' . number_format($shipping_weight, CURRENCY_DECIMAL_PLACES, CURRENCY_DECIMAL_POINT, CURRENCY_THOUSANDS_POINT) . BLANK . MODULE_SHIPPING_CHP_TEXT_UNITS . RPAREN);
$this->quotes['methods'] = $methods;
if ($this->tax_class > 0) {
$this->quotes['tax'] = olc_get_tax_rate($this->tax_class, $order_delivery_country['id'], $order->delivery['zone_id']);
}
if (olc_not_null($this->icon)) {
$this->quotes['icon'] = olc_image($this->icon, $this->title);
}
if ($error == true) {
$this->quotes['error'] = MODULE_SHIPPING_CHP_INVALID_ZONE;
}
if (olc_not_null($method) && isset($this->types[$method])) {
for ($i = 0; $i < sizeof($methods); $i++) {
if ($method == $methods[$i]['id']) {
$methodsc = array();
$methodsc[] = array('id' => $methods[$i]['id'], 'title' => $methods[$i]['title'], 'cost' => $methods[$i]['cost']);
break;
}
}
$this->quotes['methods'] = $methodsc;
}
return $this->quotes;
}
function process()
{
global $order, $currencies;
$shipping_cost = $order->info['shipping_cost'];
if (MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING == TRUE_STRING_S) {
$country_id = $order->delivery['country_id'];
switch (MODULE_ORDER_TOTAL_SHIPPING_DESTINATION) {
case 'national':
if ($country_id == STORE_COUNTRY) {
$pass = true;
}
break;
case 'international':
if ($country_id != STORE_COUNTRY) {
$pass = true;
}
break;
case 'both':
$pass = true;
break;
default:
$pass = false;
break;
}
if ($pass) {
$total_ex_ship = $order->info['total'] - $shipping_cost;
if ($total_ex_ship >= MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER) {
$shipping_method = $this->title . LPAREN . sprintf(FREE_SHIPPING_DESCRIPTION, olc_format_price(MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER, true, true, true)) . RPAREN;
$order->info['shipping_method'] = $shipping_method;
$order->info['total'] = $total_ex_ship;
$shipping_cost = 0;
}
}
}
if (true or $shipping_cost > 0) {
$module = substr($_SESSION['shipping']['id'], 0, strpos($_SESSION['shipping']['id'], UNDERSCORE));
if (olc_not_null($order->info['shipping_method'])) {
$tax_class = $GLOBALS[$module]->tax_class;
$country_id = $order->delivery['country']['id'];
$zone_id = $order->delivery['zone_id'];
$shipping_tax = olc_get_tax_rate($tax_class, $country_id, $zone_id);
$shipping_tax_description = olc_get_tax_description($tax_class, $country_id, $zone_id);
$new_shipping_cost = olc_add_tax($shipping_cost, $shipping_tax);
$tax = $new_shipping_cost - $shipping_cost;
if ($_SESSION['customers_status']['customers_status_show_price_tax'] == 1) {
// price with tax
$shipping_cost = $new_shipping_cost;
$order->info['tax'] += $tax;
$order->info['tax_groups'][TAX_ADD_TAX . "{$shipping_tax_description}"] += $tax;
$order->info['total'] += $tax;
} else {
if ($_SESSION['customers_status']['customers_status_add_tax_ot'] == 1) {
$order->info['tax'] += $tax;
$order->info['tax_groups'][TAX_NO_TAX . "{$shipping_tax_description}"] += $tax;
}
}
if (true or $shipping_cost) {
$this->output[] = array('title' => $order->info['shipping_method'] . COLON, 'text' => olc_format_price($shipping_cost, true, true, true, true), 'value' => $shipping_cost);
}
}
}
}
function quote($method = '')
{
global $order, $shipping_weight, $shipping_num_boxes;
if (!$order) {
$order = new order();
}
if (!$shipping_weight) {
$shipping_weight = $_SESSION['cart']->show_weight();
}
$order_delivery_country = $order->delivery['country'];
$dest_country = $order_delivery_country['iso_code_2'];
$dest_zone = 0;
$error = false;
for ($i = 1; $i <= $this->num_dp; $i++) {
$countries_table = constant('MODULE_SHIPPING_DP_COUNTRIES_' . $i);
$country_zones = split("[,]", $countries_table);
if (in_array($dest_country, $country_zones)) {
$dest_zone = $i;
break;
}
}
if ($dest_zone == 0) {
$error = true;
} else {
$shipping = -1;
$dp_cost = constant('MODULE_SHIPPING_DP_COST_' . $i);
$dp_table = split("[:,]", $dp_cost);
for ($i = 0; $i < sizeof($dp_table); $i += 2) {
if ($shipping_weight <= $dp_table[$i]) {
$shipping = $dp_table[$i + 1];
$shipping_method = MODULE_SHIPPING_DP_TEXT_WAY . BLANK . $order_delivery_country['title'] . ': ';
break;
}
}
if ($shipping == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_DP_UNDEFINED_RATE;
} else {
$shipping_cost = $shipping + MODULE_SHIPPING_DP_HANDLING;
}
}
$this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_DP_TEXT_TITLE, 'methods' => array(array('id' => $this->code, 'title' => $shipping_method . LPAREN . $shipping_num_boxes . ' x ' . number_format($shipping_weight, CURRENCY_DECIMAL_PLACES, CURRENCY_DECIMAL_POINT, CURRENCY_THOUSANDS_POINT) . BLANK . MODULE_SHIPPING_DP_TEXT_UNITS . RPAREN, 'cost' => $shipping_cost * $shipping_num_boxes)));
if ($this->tax_class > 0) {
$this->quotes['tax'] = olc_get_tax_rate($this->tax_class, $order_delivery_country['id'], $order->delivery['zone_id']);
}
if (olc_not_null($this->icon)) {
$this->quotes['icon'] = olc_image($this->icon, $this->title);
}
if ($error == true) {
$this->quotes['error'] = MODULE_SHIPPING_DP_INVALID_ZONE;
}
return $this->quotes;
}
function quote($method = '')
{
global $order, $shipping_weight, $shipping_num_boxes;
if (!$order) {
$order = new order();
}
if (!$shipping_weight) {
$shipping_weight = $_SESSION['cart']->show_weight();
}
$order_delivery_country = $order->delivery['country'];
$dest_country = $order_delivery_country['iso_code_2'];
$dest_zone = 0;
$error = false;
for ($j = 1; $j <= $this->num_fedexeu; $j++) {
$countries_table = constant('MODULE_SHIPPING_FEDEXEU_COUNTRIES_' . $j);
$country_zones = split("[,]", $countries_table);
if (in_array($dest_country, $country_zones)) {
$dest_zone = $j;
break;
}
}
if ($dest_zone == 0) {
$error = true;
} else {
$shipping = -1;
$fedexeu_cost_env = @constant('MODULE_SHIPPING_FEDEXEU_COST_ENV_' . $j);
$fedexeu_cost_pak = @constant('MODULE_SHIPPING_FEDEXEU_COST_PAK_' . $j);
$fedexeu_cost_box = @constant('MODULE_SHIPPING_FEDEXEU_COST_BOX_' . $j);
$methods = array();
if ($fedexeu_cost_pak != '') {
$fedexeu_table_pak = split("[:,]", $fedexeu_cost_pak);
for ($i = 0; $i < sizeof($fedexeu_table_pak); $i += 2) {
if ($shipping_weight <= $fedexeu_table_pak[$i]) {
$shipping_pak = $fedexeu_table_pak[$i + 1];
break;
}
}
if ($shipping_pak == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_FEDEXEU_UNDEFINED_RATE;
} else {
$shipping_cost_1 = $shipping_pak + MODULE_SHIPPING_FEDEXEU_HANDLING;
}
if ($shipping_pak != 0) {
$methods[] = array('id' => 'PAK', 'title' => 'FedEx Pak', 'cost' => (MODULE_SHIPPING_FEDEXEU_HANDLING + $shipping_cost_1) * $shipping_num_boxes);
}
}
if ($fedexeu_cost_env != '') {
$fedexeu_table_env = split("[:,]", $fedexeu_cost_env);
for ($i = 0; $i < sizeof($fedexeu_table_env); $i += 2) {
if ($shipping_weight <= $fedexeu_table_env[$i]) {
$shipping_env = $fedexeu_table_env[$i + 1];
break;
}
}
if ($shipping_env == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_FEDEXEU_UNDEFINED_RATE;
} else {
$shipping_cost_1 = $shipping_env + MODULE_SHIPPING_FEDEXEU_HANDLING;
}
if ($shipping_env != 0) {
$methods[] = array('id' => 'ENV', 'title' => 'FedEx Envelope', 'cost' => (MODULE_SHIPPING_FEDEXEU_HANDLING + $shipping_cost_1) * $shipping_num_boxes);
}
}
if ($fedexeu_cost_box != '') {
$fedexeu_table_box = split("[:,]", $fedexeu_cost_box);
if ($shipping_weight > 10 and $shipping_weight <= 20) {
$shipping_box = number_format(($shipping_weight - 10) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_FEDEXEU_STEP_BOX_20_' . $j) + $fedexeu_table_box[count($fedexeu_table_box) - 1];
} elseif ($shipping_weight > 20 and $shipping_weight <= 40) {
$shipping_box = number_format(($shipping_weight - 20) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_FEDEXEU_STEP_BOX_40_' . $j) + 20 * constant('MODULE_SHIPPING_FEDEXEU_STEP_BOX_20_' . $j) + $fedexeu_table_box[count($fedexeu_table_box) - 1];
} elseif ($shipping_weight > 40 and $shipping_weight <= 70) {
$shipping_box = number_format(($shipping_weight - 40) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_FEDEXEU_STEP_BOX_70_' . $j) + 20 * constant('MODULE_SHIPPING_FEDEXEU_STEP_BOX_20_' . $j) + 40 * constant('MODULE_SHIPPING_FEDEXEU_STEP_BOX_40_' . $j) + $fedexeu_table_box[count($fedexeu_table_box) - 1];
} else {
for ($i = 0; $i < sizeof($fedexeu_table_box); $i += 2) {
if ($shipping_weight <= $fedexeu_table_box[$i]) {
$shipping_box = $fedexeu_table_box[$i + 1];
break;
}
}
}
if ($shipping_box == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_FEDEXEU_UNDEFINED_RATE;
} else {
$shipping_cost_2 = $shipping_box + MODULE_SHIPPING_FEDEXEU_HANDLING;
}
if ($shipping_box != 0) {
$methods[] = array('id' => 'BOX', 'title' => 'FedEx Box', 'cost' => (MODULE_SHIPPING_FEDEXEU_HANDLING + $shipping_cost_2) * $shipping_num_boxes);
}
}
}
$this->quotes = array('id' => $this->code, 'module' => $this->title . LPAREN . $shipping_num_boxes . ' x ' . number_format($shipping_weight, CURRENCY_DECIMAL_PLACES, CURRENCY_DECIMAL_POINT, CURRENCY_THOUSANDS_POINT) . BLANK . MODULE_SHIPPING_FEDEXEU_TEXT_UNITS . RPAREN);
$this->quotes['methods'] = $methods;
if ($this->tax_class > 0) {
$this->quotes['tax'] = olc_get_tax_rate($this->tax_class, $order_delivery_country['id'], $order->delivery['zone_id']);
}
if (olc_not_null($this->icon)) {
$this->quotes['icon'] = olc_image($this->icon, $this->title);
}
if ($error == true) {
$this->quotes['error'] = MODULE_SHIPPING_FEDEXEU_INVALID_ZONE;
}
if (olc_not_null($method) && isset($this->types[$method])) {
for ($i = 0; $i < sizeof($methods); $i++) {
if ($method == $methods[$i]['id']) {
$methodsc = array();
$methodsc[] = array('id' => $methods[$i]['id'], 'title' => $methods[$i]['title'], 'cost' => $methods[$i]['cost']);
break;
}
}
$this->quotes['methods'] = $methodsc;
}
return $this->quotes;
}
require_once DIR_FS_INC . 'olc_format_price.inc.php';
$current_product_id = $_POST['current_product_id'];
// I found the easiest way to do this is just delete the current attributes & start over =)
olc_db_query(DELETE_FROM . TABLE_PRODUCTS_ATTRIBUTES . " WHERE products_id = '" . $current_product_id . APOS);
// Simple, yet effective.. loop through the selected Option Values.. find the proper price & prefix.. insert.. yadda yadda yadda.
for ($i = 0; $i < sizeof($_POST['optionValues']); $i++) {
$optionValues = $_POST['optionValues'][$i];
$query = "SELECT * FROM " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_values_id = '" . $optionValues . APOS;
$result = olc_db_query($query);
$matches = olc_db_num_rows($result);
while ($line = olc_db_fetch_array($result, olc_db_ASSOC)) {
$optionsID = $line['products_options_id'];
}
$value_price = $_POST[$optionValues . '_price'];
if (PRICE_IS_BRUTTO == TRUE_STRING_S) {
$value_price = $value_price / (olc_get_tax_rate(olc_get_tax_class_id($current_product_id)) + 100) * 100;
}
$value_price = olc_round($value_price, PRICE_PRECISION);
$value_prefix = $_POST[$optionValues . '_prefix'];
$value_sortorder = $_POST[$optionValues . '_sortorder'];
$value_weight_prefix = $_POST[$optionValues . '_weight_prefix'];
$value_model = $_POST[$optionValues . '_model'];
$value_stock = $_POST[$optionValues . '_stock'];
$value_weight = $_POST[$optionValues . '_weight'];
$insert_into = INSERT_INTO . TABLE_PRODUCTS_ATTRIBUTES . "(products_id,options_id,options_values_id,options_values_price,price_prefix" . COMMA;
$comma_blank = "','";
if ($optionTypeInstalled == '1') {
$value_type = $_POST[$optionValues . '_type'];
$value_qty = $_POST[$optionValues . '_qty'];
$value_order = $_POST[$optionValues . '_order'];
$value_linked = $_POST[$optionValues . '_linked'];
while ($group_values = olc_db_fetch_array($group_query)) {
// load data into array
$i++;
$group_data[$i] = array('STATUS_NAME' => $group_values['customers_status_name'], 'STATUS_IMAGE' => $group_values['customers_status_image'], 'STATUS_ID' => $group_values['customers_status_id']);
}
echo HTML_BR . '<span class="pageHeading">' . HEADING_PRICES_OPTIONS . '</span>';
?>
<table width="100%" border="0" class="table_bordered" style="border: 1px solid;">
<tr>
<td width="15%" class="main"><?php
echo TEXT_PRODUCTS_PRICE;
?>
</td>
<?php
// calculate brutto price for display
$tax_rate = (100 + olc_get_tax_rate($pInfo->products_tax_class_id)) / 100;
$is_brutto = PRICE_IS_BRUTTO == TRUE_STRING_S;
$products_price0 = olc_round($pInfo->products_price, PRICE_PRECISION);
$products_price = $products_price0;
if ($is_brutto) {
$products_price = $products_price * $tax_rate;
}
//$products_price = olc_round($products_price,PRICE_PRECISION);
?>
<td width="85%" class="main">
<?php
echo olc_draw_input_field('products_price', str_replace(COMMA, DOT, $products_price));
if ($is_brutto) {
echo BLANK . TEXT_NETTO . HTML_B_START . olc_format_price($products_price0, '1', '0', '1') . '</b> ';
}
?>
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;
}
$current_value_id_old = $current_value_id;
$current_value_id = $tempTextID;
echo '<input type="checkbox" name="optionValuesText[]" value="' . $current_value_id . '"' . $CHECKED . '> ' . $current_value_name . ' ';
echo '<input type="hidden" name="' . $current_value_id . '_options_id" value="' . $current_product_option_id . '">';
} else {
echo "<input type=\"checkbox\" name=\"optionValues[]\" value=\"" . $current_value_id . "\"" . $CHECKED . "> " . $current_value_name . " ";
}
echo "</td>";
echo "<td class=\"main\" align=\"left\"><input type=\"text\" name=\"" . $current_value_id . "_sortorder\" value=\"" . $sortorder . "\" size=\"4\"></td>";
echo "<td class=\"main\" align=\"left\"><input type=\"text\" name=\"" . $current_value_id . "_model\" value=\"" . $attribute_value_model . "\" size=\"15\"></td>";
echo "<td class=\"main\" align=\"left\"><input type=\"text\" name=\"" . $current_value_id . "_stock\" value=\"" . $attribute_value_stock . "\" size=\"4\"></td>";
echo "<td class=\"main\" align=\"left\"><input type=\"text\" name=\"" . $current_value_id . "_weight\" value=\"" . $attribute_value_weight . "\" size=\"10\"></td>";
echo "<td class=\"main\" align=\"left\"><select name=\"" . $current_value_id . "_weight_prefix\"><option value=\"+\"" . $posCheck_weight . ">+<option value=\"-\"" . $negCheck_weight . ">-</SELECT></td>";
// brutto Admin
if (PRICE_IS_BRUTTO == TRUE_STRING_S) {
$attribute_value_price_calculate = olc_format_price(olc_round($attribute_value_price * ((100 + olc_get_tax_rate(olc_get_tax_class_id($_POST['current_product_id']))) / 100), PRICE_PRECISION), false, false);
} else {
$attribute_value_price_calculate = olc_round($attribute_value_price, PRICE_PRECISION);
}
echo "<td class=\"main\" align=\"left\"><input type=\"text\" name=\"" . $current_value_id . "_price\" value=\"" . $attribute_value_price_calculate . "\" size=\"10\">";
// brutto Admin
if (PRICE_IS_BRUTTO == TRUE_STRING_S) {
echo TEXT_NETTO . HTML_B_START . olc_format_price(olc_round($attribute_value_price, PRICE_PRECISION), true, false) . '</b> ';
}
echo "</td>";
if ($optionTypeInstalled == '1') {
extraValues($current_value_id, $_POST['current_product_id']);
echo "<td class=\"main\" align=\"left\"><input type=\"text\" name=\"" . $current_value_id . "_prefix\" value=\"" . $attribute_prefix . "\" size=\"4\"></td>";
echo "<td class=\"main\" align=\"left\"><select name=\"" . $current_value_id . "_type\">";
displayOptionTypes($attribute_type);
echo "</SELECT></td>";
function cart($customer_id = EMPTY_STRING)
{
global $currencies;
if ($customer_id == EMPTY_STRING) {
$customer_id = CUSTOMER_ID;
}
$this->content_type = $_SESSION['cart']->get_content_type();
$customer_address_query = olc_db_query("\n\t\tselect\n\t\tc.customers_firstname,\n\t\tc.customers_cid,\n\t\tc.customers_gender,\n\t\tc.customers_lastname,\n\t\tc.customers_telephone,\n\t\tc.customers_email_address,\n\t\tc.customers_email_type,\n\t\tab.entry_company,\n\t\tab.entry_street_address,\n\t\tab.entry_suburb,\n\t\tab.entry_postcode,\n\t\tab.entry_city,\n\t\tab.entry_zone_id,\n\t\tab.entry_state,\n\t\tz.zone_name,\n\t\tco.countries_id,\n\t\tco.countries_name,\n\t\tco.countries_iso_code_2,\n\t\tco.countries_iso_code_3,\n\t\tco.address_format_id\n\t\tfrom " . TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " ab\n\t\tleft join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id)\n\t\tleft join " . TABLE_COUNTRIES . " co on (ab.entry_country_id = co.countries_id)\n\t\twhere\n\t\tc.customers_id = '" . $customer_id . "'\n\t\tand ab.customers_id = '" . $customer_id . "'\n\t\tand c.customers_default_address_id = ab.address_book_id");
$customer_address = olc_db_fetch_array($customer_address_query);
$shipping_address_query = olc_db_query("\n\t\tselect\n\t\tab.entry_firstname,\n\t\tab.entry_lastname,\n\t\tab.entry_company,\n\t\tab.entry_street_address,\n\t\tab.entry_suburb,\n\t\tab.entry_postcode,\n\t\tab.entry_city,\n\t\tab.entry_zone_id,\n\t\tab.entry_country_id,\n\t\tab.entry_state,\n\t\tz.zone_name,\n\t\tc.countries_id,\n\t\tc.countries_name,\n\t\tc.countries_iso_code_2,\n\t\tc.countries_iso_code_3,\n\t\tc.address_format_id\n\t\tfrom " . TABLE_ADDRESS_BOOK . " ab\n\t\tleft join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id)\n\t\tleft join " . TABLE_COUNTRIES . " c on (ab.entry_country_id = c.countries_id)\n\t\twhere\n\t\tab.customers_id = '" . $customer_id . "'\n\t\tand ab.address_book_id = '" . $_SESSION['sendto'] . APOS);
$shipping_address = olc_db_fetch_array($shipping_address_query);
$billing_address_query = olc_db_query("\n\t\tselect\n\t\tab.entry_firstname,\n\t\tab.entry_lastname,\n\t\tab.entry_company,\n\t\tab.entry_street_address,\n\t\tab.entry_suburb,\n\t\tab.entry_postcode,\n\t\tab.entry_city,\n\t\tab.entry_zone_id,\n\t\tab.entry_state,\n\t\tab.entry_country_id,\n\t\tz.zone_name,\n\t\tc.countries_id,\n\t\tc.countries_name,\n\t\tc.countries_iso_code_2,\n\t\tc.countries_iso_code_3,\n\t\tc.address_format_id\n\t\tfrom " . TABLE_ADDRESS_BOOK . " ab\n\t\tleft join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id)\n\t\tleft join " . TABLE_COUNTRIES . " c on (ab.entry_country_id = c.countries_id)\n\t\twhere ab.customers_id = '" . $customer_id . "'\n\t\tand ab.address_book_id = '" . $_SESSION['billto'] . APOS);
$billing_address = olc_db_fetch_array($billing_address_query);
$tax_address_query = olc_db_query("\n\t\tselect\n\t\tab.entry_country_id,\n\t\tab.entry_zone_id\n\t\tfrom " . TABLE_ADDRESS_BOOK . " ab\n\t\tleft join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id)\n\t\twhere ab.customers_id = '" . $_SESSION['$customer_id'] . "' and ab.address_book_id = '" . ($this->content_type == 'virtual' ? $_SESSION['billto'] : $_SESSION['sendto']) . APOS);
$tax_address = olc_db_fetch_array($tax_address_query);
$shipping = $_SESSION['shipping'];
$shipping_class = $shipping['id'];
//$shipping_class=$shipping['id'];
$pos = strpos($shipping_class, UNDERSCORE);
if ($pos > 0) {
$shipping_class = substr($shipping_class, 0, $pos);
}
$this->info = array('order_status' => DEFAULT_ORDERS_STATUS_ID, 'currency' => $_SESSION['currency'], 'currency_value' => $currencies->currencies[$_SESSION['currency']]['value'], 'payment_method' => $_SESSION['payment'], 'cc_type' => $GLOBALS['cc_type'], 'cc_owner' => $GLOBALS['cc_owner'], 'cc_number' => $GLOBALS['cc_number'], 'cc_expires' => $GLOBALS['cc_expires'], 'cc_start' => $GLOBALS['cc_start'], 'cc_issue' => $GLOBALS['cc_issue'], 'cc_cvv' => $GLOBALS['cc_cvv'], 'shipping_class' => $shipping_class, 'shipping_method' => $shipping['title'], 'shipping_cost' => $shipping['cost'], 'comments' => $_SESSION['comments'], 'payment_class' => $_SESSION['payment'], 'customers_order_reference' => $_SESSION['customers_order_reference']);
if (isset($_SESSION['payment']) && is_object($_SESSION['payment'])) {
$this->info['payment_method'] = $_SESSION['payment']->title;
$this->info['payment_class'] = $_SESSION['payment']->title;
if (isset($_SESSION['payment']->order_status) && is_numeric($_SESSION['payment']->order_status) && $_SESSION['payment']->order_status > 0) {
$this->info['order_status'] = $_SESSION['payment']->order_status;
}
}
$this->customer = array('firstname' => $customer_address['customers_firstname'], 'lastname' => $customer_address['customers_lastname'], 'csID' => $customer_address['customers_cid'], 'gender' => $customer_address['customers_gender'], 'company' => $customer_address['entry_company'], 'street_address' => $customer_address['entry_street_address'], 'suburb' => $customer_address['entry_suburb'], 'city' => $customer_address['entry_city'], 'postcode' => $customer_address['entry_postcode'], 'state' => olc_not_null($customer_address['entry_state']) ? $customer_address['entry_state'] : $customer_address['zone_name'], 'zone_id' => $customer_address['entry_zone_id'], 'country' => array('id' => $customer_address['countries_id'], 'title' => $customer_address['countries_name'], 'iso_code_2' => $customer_address['countries_iso_code_2'], 'iso_code_3' => $customer_address['countries_iso_code_3']), 'format_id' => $customer_address['address_format_id'], 'telephone' => $customer_address['customers_telephone'], 'email_address' => $customer_address['customers_email_address'], 'email_type' => $customer_address['customers_email_type']);
$this->delivery = array('firstname' => $shipping_address['entry_firstname'], 'lastname' => $shipping_address['entry_lastname'], 'company' => $shipping_address['entry_company'], 'street_address' => $shipping_address['entry_street_address'], 'suburb' => $shipping_address['entry_suburb'], 'city' => $shipping_address['entry_city'], 'postcode' => $shipping_address['entry_postcode'], 'state' => olc_not_null($shipping_address['entry_state']) ? $shipping_address['entry_state'] : $shipping_address['zone_name'], 'zone_id' => $shipping_address['entry_zone_id'], 'country' => array('id' => $shipping_address['countries_id'], 'title' => $shipping_address['countries_name'], 'iso_code_2' => $shipping_address['countries_iso_code_2'], 'iso_code_3' => $shipping_address['countries_iso_code_3']), 'country_id' => $shipping_address['entry_country_id'], 'format_id' => $shipping_address['address_format_id']);
$this->billing = array('firstname' => $billing_address['entry_firstname'], 'lastname' => $billing_address['entry_lastname'], 'company' => $billing_address['entry_company'], 'street_address' => $billing_address['entry_street_address'], 'suburb' => $billing_address['entry_suburb'], 'city' => $billing_address['entry_city'], 'postcode' => $billing_address['entry_postcode'], 'state' => olc_not_null($billing_address['entry_state']) ? $billing_address['entry_state'] : $billing_address['zone_name'], 'zone_id' => $billing_address['entry_zone_id'], 'country' => array('id' => $billing_address['countries_id'], 'title' => $billing_address['countries_name'], 'iso_code_2' => $billing_address['countries_iso_code_2'], 'iso_code_3' => $billing_address['countries_iso_code_3']), 'country_id' => $billing_address['entry_country_id'], 'format_id' => $billing_address['address_format_id']);
$index = 0;
$tax_country = $tax_address['entry_country_id'];
$tax_zone = $tax_address['entry_zone_id'];
$products = $_SESSION['cart']->get_products();
for ($i = 0, $n = sizeof($products); $i < $n; $i++) {
$product = $products[$i];
$quantity = $product['quantity'];
$products_id = $product['id'];
$price = olc_get_products_price($products_id, $price_special = 0, $quantity, $price_real);
$price = abs($price_real);
$products_attributes = $product['attributes'];
if ($products_attributes) {
$attributes_price = $_SESSION['cart']->attributes_price($products_id);
if ((double) $attributes_price != 0) {
$attributes_price = olc_get_products_attribute_price_checkout($attributes_price, 0, 0, 1, EMPTY_STRING, false);
$price += $attributes_price;
}
}
$final_price = $price * $quantity;
$tax_class = $product['tax_class_id'];
$this->products[$index] = array('qty' => $quantity, 'name' => $product['name'], 'model' => $product['model'], 'tax' => olc_get_tax_rate($tax_class, $tax_country, $tax_zone), 'tax_description' => olc_get_tax_description($tax_class, $tax_country, $tax_zone), 'price' => $price, 'final_price' => $final_price, 'weight' => $product['weight'], 'id' => $products_id, 'auctionid' => $product['auctionid']);
if ($products_attributes) {
$subindex = 0;
reset($products_attributes);
while (list($option, $value) = each($products_attributes)) {
$attributes_query = olc_db_query("\n\t\t\t\t\tselect\n\t\t\t\t\tpopt.products_options_name,\n\t\t\t\t\tpoval.products_options_values_name,\n\t\t\t\t\tpa.options_values_price,\n\t\t\t\t\tpa.price_prefix\n\t\t\t\t\tfrom " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa\n\t\t\t\t\twhere\n\t\t\t\t\tpa.products_id = '" . $products_id . "' and pa.options_id = '" . $option . "'\n\t\t\t\t\tand pa.options_id = popt.products_options_id\n\t\t\t\t\tand pa.options_values_id = '" . $value . "'\n\t\t\t\t\tand pa.options_values_id = poval.products_options_values_id\n\t\t\t\t\tand popt.language_id = '" . SESSION_LANGUAGE_ID . "'\n\t\t\t\t\tand poval.language_id = '" . SESSION_LANGUAGE_ID . APOS);
$attributes = olc_db_fetch_array($attributes_query);
$attributes_price = $attributes['options_values_price'];
if ($attributes_price > 0) {
$attributes_price_prefix = $attributes['price_prefix'];
} else {
$attributes_price_prefix = EMPTY_STRING;
}
$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options_name'], 'value' => $attributes['products_options_values_name'], 'option_id' => $option, 'value_id' => $value, 'prefix' => $attributes['price_prefix'], 'price' => $attributes_price);
$subindex++;
}
}
$subtotal += $final_price;
$shown_price = $final_price;
if (CUSTOMER_SHOW_OT_DISCOUNT) {
$shown_price_tax = $shown_price - $shown_price / 100 * CUSTOMER_OT_DISCOUNT;
}
$products_tax = $this->products[$index]['tax'];
$products_tax_description = $this->products[$index]['tax_description'];
if (CUSTOMER_SHOW_PRICE_TAX) {
if (CUSTOMER_SHOW_OT_DISCOUNT) {
$shown_price = $shown_price_tax;
}
$products_tax_1 = str_replace(DOT, EMPTY_STRING, $products_tax);
$products_tax_1 = $products_tax < 10 ? "1.0" . $products_tax_1 : "1." . $products_tax_1;
$this->info['tax'] += $shown_price - $shown_price / $products_tax_1;
$this->info['tax_groups'][TAX_ADD_TAX . "{$products_tax_description}"] += $shown_price / (100 + $products_tax) * $products_tax;
} else {
if (CUSTOMER_SHOW_OT_DISCOUNT) {
$shown_price = $shown_price_tax;
}
$shown_price = $shown_price / 100 * $products_tax;
$this->info['tax'] += $shown_price;
$this->info['tax_groups'][TAX_NO_TAX . $products_tax_description] += $shown_price;
}
$index++;
}
$this->info['subtotal'] = $subtotal;
$this->info['total'] = $subtotal + $this->info['shipping_cost'];
if (CUSTOMER_SHOW_OT_DISCOUNT) {
$discount = $subtotal * (CUSTOMER_OT_DISCOUNT / 100);
$this->info['total'] -= $discount;
$this->info['orders_discount'] = $discount;
}
}
function get_products($use_saved_cart = false)
{
if (!is_array($this->contents)) {
return false;
}
//if product is an auction
$sql0 = SELECT . "\n\t\t\tp.products_id,\n\t\t\tpd.products_name,\n\t\t\tp.products_image,\n\t\t\tp.products_model,\n\t\t\tp.products_min_order_quantity,\n\t\t\tp.products_weight,\n\t\t\tp.products_uvp,\n\t\t\tp.products_tax_class_id,";
$from = "\n\t\tfrom " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd";
$where = "\n\t\twhere\n\t\t\tp.products_id = '#' and\n\t\t\tpd.products_id = p.products_id and\n\t\t\tpd.language_id = '" . SESSION_LANGUAGE_ID . APOS;
//query: also select for auctionid -
//there might be more than one auction from the same product (same productid) with different prices
$auction_trailer = "\n\t\tad.auction_endprice" . $from . ", " . TABLE_AUCTION_DETAILS . " ad, " . TABLE_AUCTION_LIST . " al" . $where . "\n\t\tAND ad.auction_id = al.auction_id\n\t\tAND al.product_id=p.products_id\n\t\tAND\tal.auction_id = '" . ATSIGN . APOS;
//normal shopproduct - normal select
$normal_trailer = "\n\t\tp.products_price" . $from . $where;
$sql0_normal = $sql0 . $normal_trailer;
$sql0_auction = $sql0 . $auction_trailer;
$products_array = array();
reset($this->contents);
while (list($products_id, ) = each($this->contents)) {
$auctionid = $this->contents[$products_id][AUCTION_ID_TEXT];
if ($auctionid) {
$sql = str_replace(ATSIGN, $auctionid, $sql0_auction);
} else {
$sql = $sql0_normal;
}
$sql = str_replace(HASH, olc_get_prid($products_id), $sql);
$products_query = olc_db_query($sql);
if ($product = olc_db_fetch_array($products_query)) {
$product_tax_class_id = $product['products_tax_class_id'];
//if auction - get right excl. tax price
if ($auctionid) {
//auctionprice is incl. tax - so you have to get the price without tax (because in cart it automatically added)
$product_price = $product['auction_endprice'];
$product_tax = olc_get_tax_rate($product_tax_class_id);
if ($product_tax) {
$product_price = $product_price / (1 + $product_tax / 100);
}
} else {
//normal price - normal shopproduct
$product_price = $product['products_price'];
}
//$product_price = abs(olc_get_products_price($products_id, $price_special=0, $quantity=1,$price_real));
$product_price = olc_get_products_price($products_id, $price_special = 0, $quantity = 1, $price_real);
$product_price = abs($price_real);
$products_array[] = array('id' => $products_id, AUCTION_ID_TEXT => $auctionid, 'name' => $product['products_name'], 'model' => $product['products_model'], 'image' => $product['products_image'], 'price' => $product_price, 'discount_allowed' => $max_product_discount, 'quantity' => $this->contents[$products_id]['qty'], 'min_quantity' => $product['products_min_order_quantity'], 'weight' => $product['products_weight'], 'final_price' => $product_price + $this->attributes_price($products_id), 'tax_class_id' => $products_tax_class_id, 'attributes' => $this->contents[$products_id]['attributes']);
}
}
return $products_array;
}
function tep_get_tax_rate($x, $y = -1, $z = -1)
{
return olc_get_tax_rate($x, $y, $z);
}
function calculate()
{
$this->total = 0;
$this->weight = 0;
if (!is_array($this->contents)) {
return 0;
}
reset($this->contents);
while (list($products_id, ) = each($this->contents)) {
$qty = $this->contents[$products_id]['qty'];
// products price
$product_query = olc_db_query("select products_id, products_price, products_tax_class_id, products_weight from " . TABLE_PRODUCTS . " where products_id='" . olc_get_prid($products_id) . APOS);
if ($product = olc_db_fetch_array($product_query)) {
$prid = $product['products_id'];
$products_tax = olc_get_tax_rate($product['products_tax_class_id']);
$products_price = $product['products_price'];
$products_weight = $product['products_weight'];
$specials_query = olc_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . $prid . "' and status = '1'");
if (olc_db_num_rows($specials_query)) {
$specials = olc_db_fetch_array($specials_query);
$products_price = $specials['specials_new_products_price'];
}
$this->total += olc_add_tax($products_price, $products_tax) * $qty;
$this->weight += $qty * $products_weight;
}
// attributes price
if ($this->contents[$products_id]['attributes']) {
reset($this->contents[$products_id]['attributes']);
while (list($option, $value) = each($this->contents[$products_id]['attributes'])) {
$attribute_price_query = olc_db_query("select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $prid . "' and options_id = '" . $option . "' and options_values_id = '" . $value . APOS);
$attribute_price = olc_db_fetch_array($attribute_price_query);
if ($attribute_price['price_prefix'] == '+') {
$this->total += $qty * olc_add_tax($attribute_price['options_values_price'], $products_tax);
} else {
$this->total -= $qty * olc_add_tax($attribute_price['options_values_price'], $products_tax);
}
}
}
}
}
function calculate_tax_deduction($amount, $od_amount, $method)
{
global $order;
switch ($method) {
case 'Standard':
$ratio1 = olc_round($od_amount / $amount, 2);
$tod_amount = 0;
reset($order->info['tax_groups']);
while (list($key, $value) = each($order->info['tax_groups'])) {
$tax_rate = olc_get_tax_rate_from_desc($key);
$total_net += $tax_rate * $order->info['tax_groups'][$key];
}
if ($od_amount > $total_net) {
$od_amount = $total_net;
}
reset($order->info['tax_groups']);
while (list($key, $value) = each($order->info['tax_groups'])) {
$tax_rate = olc_get_tax_rate_from_desc($key);
$net = $tax_rate * $order->info['tax_groups'][$key];
if ($net > 0) {
$god_amount = $order->info['tax_groups'][$key] * $ratio1;
$tod_amount += $god_amount;
$order->info['tax_groups'][$key] = $order->info['tax_groups'][$key] - $god_amount;
}
}
$order->info['tax'] -= $tod_amount;
$order->info['total'] -= $tod_amount;
break;
case 'Credit Note':
$tax_rate = olc_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
$tax_desc = olc_get_tax_description($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
$tod_amount = $this->deduction / (100 + $tax_rate) * $tax_rate;
$order->info['tax_groups'][$tax_desc] -= $tod_amount;
// $order->info['total'] -= $tod_amount; //// ????? Strider
break;
default:
}
return $tod_amount;
}
function quote($method = '')
{
global $order, $shipping_weight, $shipping_num_boxes;
if (!$order) {
$order = new order();
}
if (!$shipping_weight) {
$shipping_weight = $_SESSION['cart']->show_weight();
}
$order_delivery_country = $order->delivery['country'];
$dest_country = $order_delivery_country['iso_code_2'];
$dest_zone = 0;
$error = false;
for ($j = 1; $j <= $this->num_dhl; $j++) {
$countries_table = constant('MODULE_SHIPPING_DHL_COUNTRIES_' . $j);
$country_zones = split("[,]", $countries_table);
if (in_array($dest_country, $country_zones)) {
$dest_zone = $j;
break;
}
}
if ($dest_zone == 0) {
$error = true;
} else {
$shipping = -1;
$dhl_cost_ecx = @constant('MODULE_SHIPPING_DHL_COST_ECX_' . $j);
$dhl_cost_dox = @constant('MODULE_SHIPPING_DHL_COST_DOX_' . $j);
$dhl_cost_wpx = @constant('MODULE_SHIPPING_DHL_COST_WPX_' . $j);
$dhl_cost_mdx = @constant('MODULE_SHIPPING_DHL_COST_MDX_' . $j);
$dhl_cost_sdx = @constant('MODULE_SHIPPING_DHL_COST_SDX_' . $j);
$methods = array();
$n == 0;
if ($dhl_cost_ecx != '') {
$dhl_table_ecx = split("[:,]", $dhl_cost_ecx);
if ($shipping_weight > 10 and $shipping_weight <= 20) {
$shipping_ecx = number_format(($shipping_weight - 10) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_ECX_20_' . $j) + $dhl_table_ecx[count($dhl_table_ecx) - 1];
} elseif ($shipping_weight > 20 and $shipping_weight <= 30) {
$shipping_ecx = number_format(($shipping_weight - 20) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_ECX_30_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_ECX_20_' . $j) + $dhl_table_ecx[count($dhl_table_ecx) - 1];
} elseif ($shipping_weight > 30 and $shipping_weight <= 50) {
$shipping_ecx = number_format(($shipping_weight - 30) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_ECX_50_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_ECX_20_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_ECX_30_' . $j) + $dhl_table_ecx[count($dhl_table_ecx) - 1];
} elseif ($shipping_weight > 50) {
$shipping_ecx = number_format(($shipping_weight - 50) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_ECX_51_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_ECX_20_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_ECX_30_' . $j) + 40 * constant('MODULE_SHIPPING_DHL_STEP_ECX_50_' . $j) + $dhl_table_ecx[count($dhl_table_ecx) - 1];
} else {
for ($i = 0; $i < sizeof($dhl_table_ecx); $i += 2) {
if ($shipping_weight <= $dhl_table_ecx[$i]) {
$shipping_ecx = $dhl_table_ecx[$i + 1];
break;
}
}
}
if ($shipping_ecx == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_DHL_UNDEFINED_RATE;
} else {
$shipping_cost_1 = $shipping_ecx + MODULE_SHIPPING_DHL_HANDLING;
}
$methods[] = array('id' => 'ECX', 'title' => 'EU Express Service', 'cost' => (MODULE_SHIPPING_DHL_HANDLING + $shipping_cost_1) * $shipping_num_boxes);
$n++;
}
if ($dhl_cost_dox != '') {
$dhl_table_dox = split("[:,]", $dhl_cost_dox);
if ($shipping_weight > 10 and $shipping_weight <= 20) {
$shipping_dox = number_format(($shipping_weight - 10) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_DOX_20_' . $j) + $dhl_table_dox[count($dhl_table_dox) - 1];
} elseif ($shipping_weight > 20 and $shipping_weight <= 30) {
$shipping_dox = number_format(($shipping_weight - 20) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_DOX_30_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_DOX_20_' . $j) + $dhl_table_dox[count($dhl_table_dox) - 1];
} elseif ($shipping_weight > 30 and $shipping_weight <= 50) {
$shipping_dox = number_format(($shipping_weight - 30) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_DOX_50_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_DOX_20_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_DOX_30_' . $j) + $dhl_table_dox[count($dhl_table_dox) - 1];
} elseif ($shipping_weight > 50) {
$shipping_dox = number_format(($shipping_weight - 50) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_DOX_51_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_DOX_20_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_DOX_30_' . $j) + 40 * constant('MODULE_SHIPPING_DHL_STEP_DOX_50_' . $j) + $dhl_table_dox[count($dhl_table_dox) - 1];
} else {
for ($i = 0; $i < sizeof($dhl_table_dox); $i += 2) {
if ($shipping_weight <= $dhl_table_dox[$i]) {
$shipping_dox = $dhl_table_dox[$i + 1];
break;
}
}
}
if ($shipping_dox == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_DHL_UNDEFINED_RATE;
} else {
$shipping_cost_2 = $shipping_dox + MODULE_SHIPPING_DHL_HANDLING;
}
$methods[] = array('id' => 'DOX', 'title' => 'Document Express Service', 'cost' => (MODULE_SHIPPING_DHL_HANDLING + $shipping_cost_2) * $shipping_num_boxes);
$n++;
}
if ($dhl_cost_wpx != '') {
$dhl_table_wpx = split("[:,]", $dhl_cost_wpx);
if ($shipping_weight > 10 and $shipping_weight <= 20) {
$shipping_wpx = number_format(($shipping_weight - 10) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_WPX_20_' . $j) + $dhl_table_wpx[count($dhl_table_wpx) - 1];
} elseif ($shipping_weight > 20 and $shipping_weight <= 30) {
$shipping_wpx = number_format(($shipping_weight - 20) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_WPX_30_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_WPX_20_' . $j) + $dhl_table_wpx[count($dhl_table_wpx) - 1];
} elseif ($shipping_weight > 30 and $shipping_weight <= 50) {
$shipping_wpx = number_format(($shipping_weight - 30) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_WPX_50_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_WPX_20_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_WPX_30_' . $j) + $dhl_table_wpx[count($dhl_table_wpx) - 1];
} elseif ($shipping_weight > 50) {
$shipping_wpx = number_format(($shipping_weight - 50) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_WPX_51_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_WPX_20_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_WPX_30_' . $j) + 40 * constant('MODULE_SHIPPING_DHL_STEP_WPX_50_' . $j) + $dhl_table_wpx[count($dhl_table_wpx) - 1];
} else {
for ($i = 0; $i < sizeof($dhl_table_wpx); $i += 2) {
if ($shipping_weight <= $dhl_table_wpx[$i]) {
$shipping_wpx = $dhl_table_wpx[$i + 1];
break;
}
}
}
if ($shipping_wpx == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_DHL_UNDEFINED_RATE;
} else {
$shipping_cost_3 = $shipping_wpx + MODULE_SHIPPING_DHL_HANDLING;
}
$methods[] = array('id' => 'WPX', 'title' => 'Waren Express Service', 'cost' => (MODULE_SHIPPING_DHL_HANDLING + $shipping_cost_3) * $shipping_num_boxes);
$n++;
}
if ($dhl_cost_mdx != '') {
$dhl_table_mdx = split("[:,]", $dhl_cost_mdx);
if ($shipping_weight > 10 and $shipping_weight <= 20) {
$shipping_mdx = number_format(($shipping_weight - 10) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_MDX_20_' . $j) + $dhl_table_mdx[count($dhl_table_mdx) - 1];
} elseif ($shipping_weight > 20 and $shipping_weight <= 30) {
$shipping_mdx = number_format(($shipping_weight - 20) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_MDX_30_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_MDX_20_' . $j) + $dhl_table_mdx[count($dhl_table_mdx) - 1];
} elseif ($shipping_weight > 30 and $shipping_weight <= 50) {
$shipping_mdx = number_format(($shipping_weight - 30) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_MDX_50_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_MDX_20_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_MDX_30_' . $j) + $dhl_table_mdx[count($dhl_table_mdx) - 1];
} elseif ($shipping_weight > 50) {
$shipping_mdx = number_format(($shipping_weight - 50) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_MDX_51_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_MDX_20_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_MDX_30_' . $j) + 40 * constant('MODULE_SHIPPING_DHL_STEP_MDX_50_' . $j) + $dhl_table_mdx[count($dhl_table_mdx) - 1];
} else {
for ($i = 0; $i < sizeof($dhl_table_mdx); $i += 2) {
if ($shipping_weight <= $dhl_table_mdx[$i]) {
$shipping_mdx = $dhl_table_mdx[$i + 1];
break;
}
}
}
if ($shipping_mdx == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_DHL_UNDEFINED_RATE;
} else {
$shipping_cost_4 = $shipping_mdx + MODULE_SHIPPING_DHL_HANDLING;
}
$methods[] = array('id' => 'MDX', 'title' => 'Mid Day Express Service', 'cost' => (MODULE_SHIPPING_DHL_HANDLING + $shipping_cost_4) * $shipping_num_boxes);
$n++;
}
if ($dhl_cost_sdx != '') {
$dhl_table_sdx = split("[:,]", $dhl_cost_sdx);
if ($shipping_weight > 10 and $shipping_weight <= 20) {
$shipping_sdx = number_format(($shipping_weight - 10) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_SDX_20_' . $j) + $dhl_table_sdx[count($dhl_table_sdx) - 1];
} elseif ($shipping_weight > 20 and $shipping_weight <= 30) {
$shipping_sdx = number_format(($shipping_weight - 20) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_SDX_30_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_SDX_20_' . $j) + $dhl_table_sdx[count($dhl_table_sdx) - 1];
} elseif ($shipping_weight > 30 and $shipping_weight <= 50) {
$shipping_sdx = number_format(($shipping_weight - 30) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_SDX_50_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_SDX_20_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_SDX_30_' . $j) + $dhl_table_sdx[count($dhl_table_sdx) - 1];
} elseif ($shipping_weight > 50) {
$shipping_sdx = number_format(($shipping_weight - 50) * 2 + 0.5, 0) * constant('MODULE_SHIPPING_DHL_STEP_SDX_51_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_SDX_20_' . $j) + 20 * constant('MODULE_SHIPPING_DHL_STEP_SDX_30_' . $j) + 40 * constant('MODULE_SHIPPING_DHL_STEP_SDX_50_' . $j) + $dhl_table_sdx[count($dhl_table_sdx) - 1];
} else {
for ($i = 0; $i < sizeof($dhl_table_sdx); $i += 2) {
if ($shipping_weight <= $dhl_table_sdx[$i]) {
$shipping_sdx = $dhl_table_sdx[$i + 1];
break;
}
}
}
if ($shipping_sdx == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_DHL_UNDEFINED_RATE;
} else {
$shipping_cost_5 = $shipping_sdx + MODULE_SHIPPING_DHL_HANDLING;
}
$methods[] = array('id' => 'SDX', 'title' => 'Start Day Express Service', 'cost' => (MODULE_SHIPPING_DHL_HANDLING + $shipping_cost_5) * $shipping_num_boxes);
$n++;
}
}
$this->quotes = array('id' => $this->code, 'module' => $this->title . LPAREN . $shipping_num_boxes . ' x ' . $shipping_weight . BLANK . MODULE_SHIPPING_DHL_TEXT_UNITS . RPAREN);
$this->quotes['methods'] = $methods;
if ($this->tax_class > 0) {
$this->quotes['tax'] = olc_get_tax_rate($this->tax_class, $order_delivery_country['id'], $order->delivery['zone_id']);
}
if (olc_not_null($this->icon)) {
$this->quotes['icon'] = olc_image($this->icon, $this->title);
}
if ($error == true) {
$this->quotes['error'] = MODULE_SHIPPING_DHL_INVALID_ZONE;
}
if (olc_not_null($method) && isset($this->types[$method])) {
for ($i = 0; $i < sizeof($methods); $i++) {
if ($method == $methods[$i]['id']) {
$methodsc = array();
$methodsc[] = array('id' => $methods[$i]['id'], 'title' => $methods[$i]['title'], 'cost' => $methods[$i]['cost']);
break;
}
}
$this->quotes['methods'] = $methodsc;
}
return $this->quotes;
}
function get_order_total()
{
global $order, $olPrice;
$module = substr($_SESSION['shipping']['id'], 0, strpos($_SESSION['shipping']['id'], '_'));
$shipping_tax = olc_get_tax_rate($GLOBALS[$module]->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
if ($_SESSION['customers_status']['customers_status_show_price_tax'] == 0 && $_SESSION['customers_status']['customers_status_add_tax_ot'] == 1) {
$order_total = $order->info['tax'] + $order->info['total'];
}
if ($_SESSION['customers_status']['customers_status_show_price_tax'] != 0) {
$order_total = $order->info['total'];
}
if ($_SESSION['customers_status']['customers_status_show_price_tax'] == 0 && $_SESSION['customers_status']['customers_status_add_tax_ot'] == 0) {
$order_total = $order->info['total'];
}
// Check if gift voucher is in cart and adjust total
$products = $_SESSION['cart']->get_products();
for ($i = 0; $i < sizeof($products); $i++) {
$t_prid = olc_get_prid($products[$i]['id']);
$gv_query = olc_db_query("select products_price, products_tax_class_id, products_model from " . TABLE_PRODUCTS . " where products_id = '" . $t_prid . APOS);
$gv_result = olc_db_fetch_array($gv_query);
if (ereg('^GIFT', addslashes($gv_result['products_model']))) {
$qty = $_SESSION['cart']->get_quantity($t_prid);
$products_tax = $olPrice->TAX[$gv_result['products_tax_class_id']];
if ($this->include_tax == FALSE_STRING_S) {
$gv_amount = $gv_result['products_price'] * $qty;
} else {
$gv_amount = ($gv_result['products_price'] + $olPrice->calcTax($gv_result['products_price'], $products_tax)) * $qty;
}
$order_total = $order_total - $gv_amount;
}
}
if ($this->include_tax == FALSE_STRING_S && !($_SESSION['customers_status']['customers_status_show_price_tax'] == 0 && $_SESSION['customers_status']['customers_status_add_tax_ot'] == 0)) {
$order_total = $order_total - $order->info['tax'];
}
if ($this->include_shipping == FALSE_STRING_S) {
$order_total = $order_total - $order->info['shipping_cost'];
if ($_SESSION['customers_status']['customers_status_show_price_tax'] == 1) {
$order_total += $order->info['shipping_cost'] / (100 + $shipping_tax) * $shipping_tax;
}
}
// OK thats fine for global coupons but what about restricted coupons
// where you can only redeem against certain products/categories.
// and I though this was going to be easy !!!
$coupon_query = olc_db_query("select coupon_code from " . TABLE_COUPONS . " where coupon_id='" . $_SESSION['cc_id'] . APOS);
if (olc_db_num_rows($coupon_query) != 0) {
$coupon_result = olc_db_fetch_array($coupon_query);
$coupon_get = olc_db_query("select coupon_amount, coupon_minimum_order,restrict_to_products,restrict_to_categories, coupon_type from " . TABLE_COUPONS . " where coupon_code='" . $coupon_result['coupon_code'] . APOS);
$get_result = olc_db_fetch_array($coupon_get);
$in_cat = false;
$in_cart = false;
if ($get_result['restrict_to_categories']) {
$cat_ids = split("[,]", $get_result['restrict_to_categories']);
for ($i = 0; $i < count($cat_ids); $i++) {
if (is_array($_SESSION['cart']->contents)) {
reset($_SESSION['cart']->contents);
while (list($products_id, ) = each($_SESSION['cart']->contents)) {
$cat_query = olc_db_query("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $products_id . "' and categories_id = '" . $cat_ids[$i] . APOS);
if (olc_db_num_rows($cat_query) != 0 && stristr($pr_in_cat, olc_get_prid($products_id)) === FALSE) {
$in_cat = true;
$pr_in_cat .= ',' . $products_id;
$total_price += $this->get_product_price($products_id);
}
}
}
}
}
if ($get_result['restrict_to_products']) {
$pr_ids = split("[,]", $get_result['restrict_to_products']);
$products_array = $_SESSION['cart']->get_products();
for ($i = 0; $i < sizeof($pr_ids); $i++) {
for ($ii = 1; $ii <= sizeof($products_array); $ii++) {
if (olc_get_prid($products_array[$ii - 1]['id']) == $pr_ids[$i] && stristr($pr_in_cat, olc_get_prid($products_array[$ii - 1]['id'])) === FALSE) {
$in_cart = true;
$total_price += $this->get_product_price($products_array[$ii - 1]['id']);
}
}
}
}
if ($in_cat || $in_cart) {
if ($this->include_shipping == TRUE_STRING_S) {
if ($_SESSION['customers_status']['customers_status_show_price_tax'] == 0 && $_SESSION['customers_status']['customers_status_add_tax_ot'] == 1) {
if ($this->include_tax == FALSE_STRING_S) {
$total_price += $order->info['shipping_cost'];
} else {
$total_price += olc_add_tax($order->info['shipping_cost'], $shipping_tax);
// original code $total_price += $order->info['shipping_cost'] = olc_add_tax($order->info['shipping_cost'], $shipping_tax);
}
} else {
if ($this->include_tax == FALSE_STRING_S) {
$total_price += $order->info['shipping_cost'];
if (!($_SESSION['customers_status']['customers_status_show_price_tax'] == 0 && $_SESSION['customers_status']['customers_status_add_tax_ot'] == 0)) {
$total_price -= $order->info['shipping_cost'] / (100 + $shipping_tax) * $shipping_tax;
}
} else {
$total_price += $order->info['shipping_cost'];
}
}
}
if ($total_price > $order_total) {
$total_price = $order_total;
}
$order_total = $total_price;
}
}
return $order_total;
}
<td class="dataTableContent"><?php
echo $PRODUCTS_id[0];
?>
</td>
<!--// Adam@CP: Added Model Number and image thumbnail. -->
<td class="dataTableContent"><?php
echo $PRODUCTS_model[0];
?>
</td>
<td class="dataTableContent"><?php
echo $PRODUCTS_name[0];
?>
</td>
<td class="dataTableContent"><?php
echo $currencies->display_price($PRODUCTS_price[0], olc_get_tax_rate($product_info_values['products_tax_class_id']));
?>
</td>
<td class="dataTableContent"><select name="<?php
echo $PRODUCTS_id[0];
?>
">
<?php
for ($y = 1; $y <= $ordering_size; $y++) {
echo "<option value=\"{$y}\"";
if (!strcmp($y, "{$order_PR[$i]}")) {
echo "SELECTED";
}
echo ">{$y}</option>";
}
?>
function quote()
{
global $order, $shipping_weight;
$this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_CHRONOPOST_TEXT_TITLE, 'methods' => array());
if (!$order) {
$order = new order();
}
if (!$shipping_weight) {
$shipping_weight = $_SESSION['cart']->show_weight();
}
$order_delivery_country = $order->delivery['country'];
$dest_country = $order_delivery_country['iso_code_2'];
if (olc_not_null($this->icon)) {
$this->quotes['icon'] = olc_image($this->icon, $this->title);
}
if ($this->tax_class > 0) {
$this->quotes['tax'] = olc_get_tax_rate($this->tax_class, $order_delivery_country['id'], $order->delivery['zone_id']);
}
$dest_zone = 0;
for ($i = 1; $i <= $this->num_chronopost; $i++) {
$countries_table = constant('MODULE_SHIPPING_CHRONOPOST_COUNTRIES_' . $i);
$country = split("[,]", $countries_table);
if (in_array($dest_country, $country)) {
$dest_zone = $i;
break;
}
}
if ($dest_zone == 0) {
$this->quotes['error'] = MODULE_SHIPPING_CHRONOPOST_INVALID_ZONE;
return $this->quotes;
}
$table = split("[:,]", constant('MODULE_SHIPPING_CHRONOPOST_COST_' . $dest_zone));
$cost = -1;
for ($i = 0, $n = sizeof($table); $i < $n; $i += 2) {
if ($shipping_weight <= $table[$i]) {
$cost = $table[$i + 1] + MODULE_SHIPPING_CHRONOPOST_HANDLING + SHIPPING_HANDLING;
break;
}
}
if ($cost == -1) {
$this->quotes['error'] = MODULE_SHIPPING_CHRONOPOST_UNDEFINED_RATE;
return $this->quotes;
}
$this->quotes['methods'][] = array('id' => $this->code, 'title' => MODULE_SHIPPING_CHRONOPOST_TEXT_WAY . BLANK . $order_delivery_country['title'], 'cost' => $cost + MODULE_SHIPPING_CHRONOPOST_HANDLING + SHIPPING_HANDLING);
return $this->quotes;
}
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 SendProducts()
{
global $_GET, $LangID;
if (defined('SET_TIME_LIMIT')) {
@set_time_limit(0);
}
$schema = '<?xml version="1.0" encoding="' . CHARSET . '"?>' . "\n" . '<PRODUCTS>' . "\n";
$sql = "select products_id,products_fsk18, products_quantity, products_model, products_image, products_price, " . "products_date_added, products_last_modified, products_date_available, products_weight, " . "products_status, products_tax_class_id, manufacturers_id, products_ordered from " . TABLE_PRODUCTS;
$from = olc_db_prepare_input($_GET['products_from']);
$anz = olc_db_prepare_input($_GET['products_count']);
if (isset($from)) {
if (!isset($anz)) {
$anz = 1000;
}
$sql .= " limit " . $from . "," . $anz;
}
$orders_query = olc_db_query($sql);
//W. Kaiser
require_once DIR_FS_INC . 'olc_image.inc.php';
require_once DIR_FS_INC . 'olc_get_customers_statuses.inc.php';
$http_catalog = HTTP_SERVER . DIR_WS_CATALOG;
$deep_link = $http_catalog . $olc_filename['product_info'] . '?products_id=';
while ($products = olc_db_fetch_array($orders_query)) {
$products_image = $products['products_image'];
$products_id = $products['products_id'];
$schema .= '<PRODUCT_INFO>' . "\n" . '<PRODUCT_DATA>' . "\n" . '<PRODUCT_ID>' . $products_id . '</PRODUCT_ID>' . "\n" . '<PRODUCT_DEEPLINK>' . $deep_link . $products_id . '</PRODUCT_DEEPLINK>' . "\n" . '<PRODUCT_QUANTITY>' . $products['products_quantity'] . '</PRODUCT_QUANTITY>' . "\n" . '<PRODUCT_MODEL>' . htmlspecialchars($products['products_model']) . '</PRODUCT_MODEL>' . "\n" . '<PRODUCT_FSK18>' . htmlspecialchars($products['products_fsk18']) . '</PRODUCT_FSK18>' . "\n" . '<PRODUCT_IMAGE>' . htmlspecialchars($products_image) . '</PRODUCT_IMAGE>' . "\n";
if ($products_image) {
//W. Kaiser - pictures-on-the-fly
/*
$schema .=
'<PRODUCT_IMAGE_POPUP>'.
$http_catalog.DIR_WS_POPUP_IMAGES.$products_image.
'</PRODUCT_IMAGE_POPUP>'. "\n" .
'<PRODUCT_IMAGE_SMALL>'.
$http_catalog.DIR_WS_INFO_IMAGES.$products_image.
'</PRODUCT_IMAGE_SMALL>'. "\n" .
'<PRODUCT_IMAGE_THUMBNAIL>'.
$http_catalog.DIR_WS_THUMBNAIL_IMAGES.$products_image.
'</PRODUCT_IMAGE_THUMBNAIL>'. "\n" .
'<PRODUCT_IMAGE_ORIGINAL>'.
$http_catalog.DIR_WS_ORIGINAL_IMAGES.$products_image.
'</PRODUCT_IMAGE_ORIGINAL>'. "\n";
*/
$schema .= '<PRODUCT_IMAGE_ORIGINAL>' . olc_image($http_catalog . DIR_WS_ORIGINAL_IMAGES . $products_image) . '</PRODUCT_IMAGE_ORIGINAL>' . "\n" . '<PRODUCT_IMAGE_SMALL>' . olc_image($http_catalog . DIR_WS_INFO_IMAGES . $products_image) . '</PRODUCT_IMAGE_SMALL>' . "\n" . '<PRODUCT_IMAGE_POPUP>' . olc_image($http_catalog . DIR_WS_POPUP_IMAGES . $products_image) . '</PRODUCT_IMAGE_POPUP>' . "\n" . '<PRODUCT_IMAGE_THUMBNAIL>' . olc_image($http_catalog . DIR_WS_THUMBNAIL_IMAGES . $products_image) . '</PRODUCT_IMAGE_THUMBNAIL>' . "\n";
//W. Kaiser - pictures-on-the-fly
}
$schema .= '<PRODUCT_PRICE>' . $products['products_price'] . '</PRODUCT_PRICE>' . "\n";
/* Wird von CAO derzeit nicht verwendet !!! */
$customers_status = olc_get_customers_statuses();
for ($i = 1, $n = sizeof($customers_status); $i < $n; $i++) {
if ($customers_status[$i]['id'] != 0) {
$schema .= "<PRODUCT_GROUP_PRICES ID='" . $customers_status[$i]['id'] . "' NAME='" . $customers_status[$i]['text'] . "'>" . "\n";
$group_price_query = olc_db_query("SELECT * FROM " . TABLE_PERSONAL_OFFERS_BY_CUSTOMERS_STATUS . $customers_status[$i]['id'] . " WHERE products_id='" . $products_id . "'");
while ($group_price_data = olc_db_fetch_array($group_price_query)) {
//if ($group_price_data['personal_offer']!='0')
//{
$schema .= '<PRICE_ID>' . $group_price_data['price_id'] . '</PRICE_ID>';
$schema .= '<PRODUCT_ID>' . $group_price_data['products_id'] . '</PRODUCT_ID>';
$schema .= '<QTY>' . $group_price_data['quantity'] . '</QTY>';
$schema .= '<PRICE>' . $group_price_data['personal_offer'] . '</PRICE>';
//}
}
$schema .= "</PRODUCT_GROUP_PRICES>\n";
}
}
// products Options
//W. Kaiser
$products_attributes = '';
$products_options_data = array();
$products_options_array = array();
$products_attributes_query = olc_db_query("select count(*) as total\n from " . TABLE_PRODUCTS_OPTIONS . "\n popt, " . TABLE_PRODUCTS_ATTRIBUTES . "\n patrib where\n patrib.products_id='" . $products['products_id'] . "'\n and patrib.options_id = popt.products_options_id\n and popt.language_id = '" . $LangID . "'");
$products_attributes = olc_db_fetch_array($products_attributes_query);
if ($products_attributes['total'] > 0) {
$products_options_name_query = olc_db_query("select distinct\n popt.products_options_id,\n popt.products_options_name\n from " . TABLE_PRODUCTS_OPTIONS . "\n popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib\n where patrib.products_id='" . $products['products_id'] . "'\n and patrib.options_id = popt.products_options_id\n and popt.language_id = '" . $LangID . "' order by popt.products_options_name");
$row = 0;
$col = 0;
$products_options_data = array();
while ($products_options_name = olc_db_fetch_array($products_options_name_query)) {
$selected = 0;
$products_options_array = array();
$products_options_data[$row] = array('NAME' => $products_options_name['products_options_name'], 'ID' => $products_options_name['products_options_id'], 'DATA' => '');
$products_options_query = olc_db_query("select\n pov.products_options_values_id,\n pov.products_options_values_name,\n pa.attributes_model,\n pa.options_values_price,\n pa.options_values_weight,\n pa.price_prefix,\n pa.weight_prefix,\n pa.attributes_stock,\n pa.attributes_model\n from " . TABLE_PRODUCTS_ATTRIBUTES . "\n pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . "\n pov\n where\n pa.products_id = '" . $products['products_id'] . "'\n and pa.options_id = '" . $products_options_name['products_options_id'] . "' and\n pa.options_values_id = pov.products_options_values_id and\n pov.language_id = '" . $LangID . "'\n order by pov.products_options_values_name");
$col = 0;
while ($products_options = olc_db_fetch_array($products_options_query)) {
$products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);
if ($products_options['options_values_price'] != '0') {
$products_options_array[sizeof($products_options_array) - 1]['text'] .= ' ' . $products_options['price_prefix'] . ' ' . $products_options['options_values_price'] . ' ' . $_SESSION['currency'];
}
$price = '';
$products_options_data[$row]['DATA'][$col] = array('ID' => $products_options['products_options_values_id'], 'TEXT' => $products_options['products_options_values_name'], 'MODEL' => $products_options['attributes_model'], 'WEIGHT' => $products_options['options_values_weight'], 'PRICE' => $products_options['options_values_price'], 'WEIGHT_PREFIX' => $products_options['weight_prefix'], 'PREFIX' => $products_options['price_prefix']);
$col++;
}
$row++;
}
}
if (sizeof($products_options_data) != 0) {
for ($i = 0, $n = sizeof($products_options_data); $i < $n; $i++) {
$schema .= "<PRODUCT_ATTRIBUTES NAME='" . $products_options_data[$i]['NAME'] . "'>";
for ($ii = 0, $nn = sizeof($products_options_data[$i]['DATA']); $ii < $nn; $ii++) {
$schema .= '<OPTION>';
$schema .= '<ID>' . $products_options_data[$i]['DATA'][$ii]['ID'] . '</ID>';
$schema .= '<MODEL>' . $products_options_data[$i]['DATA'][$ii]['MODEL'] . '</MODEL>';
$schema .= '<TEXT>' . $products_options_data[$i]['DATA'][$ii]['TEXT'] . '</TEXT>';
$schema .= '<WEIGHT>' . $products_options_data[$i]['DATA'][$ii]['WEIGHT'] . '</WEIGHT>';
$schema .= '<PRICE>' . $products_options_data[$i]['DATA'][$ii]['PRICE'] . '</PRICE>';
$schema .= '<WEIGHT_PREFIX>' . $products_options_data[$i]['DATA'][$ii]['WEIGHT_PREFIX'] . '</WEIGHT_PREFIX>';
$schema .= '<PREFIX>' . $products_options_data[$i]['DATA'][$ii]['PREFIX'] . '</PREFIX>';
$schema .= '</OPTION>';
}
$schema .= '</PRODUCT_ATTRIBUTES>';
}
}
/* End Wird zur Zeit nicht verwendet */
require_once DIR_FS_INC . 'olc_get_tax_rate.inc.php';
if (SWITCH_MWST == 'true') {
// switch IDs
if ($products['products_tax_class_id'] == 1) {
$products['products_tax_class_id'] = 2;
} else {
if ($products['products_tax_class_id'] == 2) {
$products['products_tax_class_id'] = 1;
}
}
}
$schema .= '<PRODUCT_WEIGHT>' . $products['products_weight'] . '</PRODUCT_WEIGHT>' . "\n" . '<PRODUCT_STATUS>' . $products['products_status'] . '</PRODUCT_STATUS>' . "\n" . '<PRODUCT_TAX_CLASS_ID>' . $products['products_tax_class_id'] . '</PRODUCT_TAX_CLASS_ID>' . "\n" . '<PRODUCT_TAX_RATE>' . olc_get_tax_rate($products['products_tax_class_id']) . '</PRODUCT_TAX_RATE>' . "\n" . '<MANUFACTURERS_ID>' . $products['manufacturers_id'] . '</MANUFACTURERS_ID>' . "\n" . '<PRODUCT_DATE_ADDED>' . $products['products_date_added'] . '</PRODUCT_DATE_ADDED>' . "\n" . '<PRODUCT_LAST_MODIFIED>' . $products['products_last_modified'] . '</PRODUCT_LAST_MODIFIED>' . "\n" . '<PRODUCT_DATE_AVAILABLE>' . $products['products_date_available'] . '</PRODUCT_DATE_AVAILABLE>' . "\n" . '<PRODUCTS_ORDERED>' . $products['products_ordered'] . '</PRODUCTS_ORDERED>' . "\n";
/* Wird von CAO derzeit nicht verwendet !!! */
$categories_query = olc_db_query("SELECT\n categories_id\n FROM " . TABLE_PRODUCTS_TO_CATEGORIES . "\n where products_id='" . $products['products_id'] . "'");
$categories = array();
while ($categories_data = olc_db_fetch_array($categories_query)) {
$categories[] = $categories_data['categories_id'];
}
$categories = implode(',', $categories);
$schema .= '<PRODUCTS_CATEGORIES>' . $categories . '</PRODUCTS_CATEGORIES>' . "\n";
/* Ende Wird zur Zeit nicht verwendet */
$detail_query = olc_db_query("select\n products_id,\n language_id,\n products_name, " . TABLE_PRODUCTS_DESCRIPTION . ".products_description,\n products_short_description,\n products_meta_title,\n products_meta_description,\n products_meta_keywords,\n products_url,\n name as language_name, code as language_code " . "from " . TABLE_PRODUCTS_DESCRIPTION . ", " . TABLE_LANGUAGES . " " . "where " . TABLE_PRODUCTS_DESCRIPTION . ".language_id=" . TABLE_LANGUAGES . ".languages_id " . "and " . TABLE_PRODUCTS_DESCRIPTION . ".products_id=" . $products['products_id']);
while ($details = olc_db_fetch_array($detail_query)) {
$schema .= "<PRODUCT_DESCRIPTION ID='" . $details["language_id"] . "' CODE='" . $details["language_code"] . "' NAME='" . $details["language_name"] . "'>\n";
if ($details["products_name"] != 'Array') {
$schema .= "<NAME>" . htmlspecialchars($details["products_name"]) . "</NAME>" . "\n";
}
$schema .= "<URL>" . htmlspecialchars($details["products_url"]) . "</URL>" . "\n";
$prod_details = $details["products_description"];
if ($prod_details != 'Array') {
$schema .= "<DESCRIPTION>" . htmlspecialchars($details["products_description"]) . "</DESCRIPTION>" . "\n";
$schema .= "<SHORT_DESCRIPTION>" . htmlspecialchars($details["products_short_description"]) . "</SHORT_DESCRIPTION>" . "\n";
$schema .= "<META_TITLE>" . htmlspecialchars($details["products_meta_title"]) . "</META_TITLE>" . "\n";
$schema .= "<META_DESCRIPTION>" . htmlspecialchars($details["products_meta_description"]) . "</META_DESCRIPTION>" . "\n";
$schema .= "<META_KEYWORDS>" . htmlspecialchars($details["products_meta_keywords"]) . "</META_KEYWORDS>" . "\n";
}
$schema .= "</PRODUCT_DESCRIPTION>\n";
}
// NEU JP 26.08.2005 Aktionspreise exportieren
$special_query = "SELECT * from " . TABLE_SPECIALS . " " . "where products_id=" . $products['products_id'] . " limit 0,1";
$special_result = olc_db_query($special_query);
while ($specials = olc_db_fetch_array($special_result)) {
$schema .= '<SPECIAL>' . "\n" . '<SPECIAL_PRICE>' . $specials['specials_new_products_price'] . '</SPECIAL_PRICE>' . "\n" . '<SPECIAL_DATE_ADDED>' . $specials['specials_date_added'] . '</SPECIAL_DATE_ADDED>' . "\n" . '<SPECIAL_LAST_MODIFIED>' . $specials['specials_last_modified'] . '</SPECIAL_LAST_MODIFIED>' . "\n" . '<SPECIAL_DATE_EXPIRES>' . $specials['expires_date'] . '</SPECIAL_DATE_EXPIRES>' . "\n" . '<SPECIAL_STATUS>' . $specials['status'] . '</SPECIAL_STATUS>' . "\n" . '<SPECIAL_DATE_STATUS_CHANGE>' . $specials['date_status_change'] . '</SPECIAL_DATE_STATUS_CHANGE>' . "\n" . '</SPECIAL>' . "\n";
}
// Ende Aktionspreise
$schema .= '</PRODUCT_DATA>' . "\n" . '</PRODUCT_INFO>' . "\n";
}
$schema .= '</PRODUCTS>' . "\n\n";
echo $schema;
}
