$lid = 2;
$pquery = "SELECT p.products_id AS id, p.products_model AS model, pd.products_name AS name, {$pqty} AS qty, p.products_price AS price FROM products p";
$pquery .= " LEFT JOIN products_description pd ON pd.products_id=p.products_id AND pd.language_id={$lid}";
$pquery .= " WHERE p.{$pfilter}='{$pdata}'";
$presult = tep_db_query($pquery);
if (tep_db_num_rows($presult) == 1) {
if (!isset($order_create['products'])) {
$order_create['products'] = array();
}
$product = tep_db_fetch_array($presult);
$pid = $product['id'];
if (isset($order_create['products'][$pid])) {
$order_create['products'][$pid]['qty'] += $pqty;
} else {
//CHECK CUSTOMER STATUS FOR DISCOUNT CALCULATION
$is_ambassador = k_is_ambassador($order_create['customer']['status']);
$is_bp = k_is_bp($order_create['customer']['status']);
//PROCESS DISCOUNT
if ($is_ambassador) {
$product['price'] = k_calculate_ambassador_price($product['price'], $product['model']);
} elseif ($is_bp) {
$product['price'] = k_calculate_bp_price($product['price'], $product['model']);
}
$order_create['products'][$pid] = $product;
}
$_SESSION['order-create'] = serialize($order_create);
} else {
$messagebox->add("<strong>{$pfieldtype} {$pdata}</strong> is not found / not specific enough");
}
} elseif ($_POST['me_action'] == 'CREATEORDERUPDATEQTY') {
foreach ($_POST['pqty'] as $key => $quantity) {
function customerStatus($status)
{
if (k_is_ambassador($status)) {
$result = 'Ambassador';
} elseif (k_is_bp($status)) {
$result = 'Business Partner';
} else {
switch ($status) {
case 'P':
$result = 'Press';
break;
case 'D':
$result = 'J&G Designer';
break;
default:
$result = 'J&G Friends';
}
}
return $result;
}
} elseif ($_POST['me_action'] == 'CREATEORDERCONFIRMCUSTOMER') {
$cid = tep_db_prepare_input($_POST['customers_id']);
if ($cid != $order_create['customer']['id']) {
unset($order_create['address']);
}
$customer_query = tep_db_query("SELECT customers_id AS id, customers_email_address AS email, CONCAT(customers_firstname,' ',customers_lastname) AS name, customers_status AS status FROM customers WHERE customers_id={$cid}");
$customer = tep_db_fetch_array($customer_query);
//CHECK IF ANY PRODUCT IS ADDED AND CUSTOMER STATUS IS CHANGING
if (isset($order_create['customer'])) {
if ($order_create['customer']['status'] != $customer['status']) {
if (isset($order_create['products']) && count($order_create['products']) > 0) {
foreach ($order_create['products'] as $pid => $product) {
$pquery = tep_db_query("SELECT p.products_model AS model, p.products_price AS price FROM products p WHERE p.products_id='{$pid}'");
$p = tep_db_fetch_array($pquery);
//CHECK CUSTOMER STATUS FOR DISCOUNT CALCULATION
$is_ambassador = k_is_ambassador($customer['status']);
$is_bp = k_is_bp($customer['status']);
//PROCESS DISCOUNT
if ($is_ambassador) {
$p_price = k_calculate_ambassador_price($p['price'], $p['model']);
} elseif ($is_bp) {
$p_price = k_calculate_bp_price($p['price'], $p['model']);
} else {
$p_price = $p['price'];
}
$order_create['products'][$pid]['price'] = $p_price;
}
}
}
}
$order_create['customer'] = $customer;
