$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'])) {