$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) {
$pid = tep_db_prepare_input($key);
$qty = tep_db_prepare_input($quantity);
if (isset($order_create['products'][$pid])) {
if ($qty == 0) {
}
$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;
$_SESSION['order-create'] = serialize($order_create);
header('Location: ?open=order-create-2');
exit;
}
