$order_id = tep_db_insert_id();
tep_db_query("UPDATE orders_random_no SET status='1' WHERE orders_id='{$order_no['orders_id']}'");
$order_status_DA = array('orders_id' => $order_id, 'orders_status_id' => $new_order_status, 'date_added' => date("Y-m-d H:i:s"), 'customer_notified' => '0', 'comments' => $order_create['info']['comment']);
tep_db_perform('orders_status_history', $order_status_DA);
$product_tax = 0;
$is_bp = k_is_bp($customer['status']);
$subtotal = 0;
$products_total = count($order_create['products']);
$products_count = 0;
$exp_delivery_date = date('Y-m-d', strtotime("+9"));
foreach ($order_create['products'] as $pid => $p) {
$products_count++;
$product_query = tep_db_query("SELECT p.products_price FROM products p WHERE p.products_id={$pid}");
$product = tep_db_fetch_array($product_query);
if ($is_bp) {
$p['final_price'] = k_calculate_bp_price($product['products_price'], $p['model'], true);
} else {
$p['final_price'] = $p['price'];
}
$p['price'] = $product['products_price'];
$order_products_DA = array('orders_id' => $order_id, 'products_id' => $p['id'], 'products_model' => $p['model'], 'products_name' => $p['name'], 'products_price' => $p['price'], 'final_price' => $p['final_price'], 'products_tax' => $product_tax, 'products_quantity' => $p['qty'], 'order_item_count' => $products_count, 'order_item_total' => $products_total, 'status' => '1', 'expected_delivery_date' => $exp_delivery_date);
tep_db_perform('orders_products', $order_products_DA);
$subtotal += $p['qty'] * $p['final_price'];
}
//ORDER TOTALLLL:
$order_total = array();
//Subtotal
$ot = array();
$ot['title'] = 'Zwischensumme:';
$ot['text'] = number_format($subtotal, 2, ',', '.') . " {$currency}";
$ot['value'] = $subtotal;
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) {
unset($order_create['products'][$pid]);
} else {
$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;
}
} else {
if (isset($order_create['customer'])) {
