function oaGetProductTax($cartContent, $d, $addresses)
{
$res = 0;
for ($i = 0; $i < count($cartContent["cart_content"]); $i++) {
$cartItem = $cartContent["cart_content"][$i];
$q = db_query("select count(*) from " . PRODUCTS_TABLE . " where productID=" . (int) $cartItem["productID"]);
$count = db_fetch_row($q);
if ($count[0] == 0) {
continue;
}
$cartItem = $cartContent["cart_content"][$i];
$price = $cartItem["costUC"] - $cartItem["costUC"] / 100 * $d;
$price = $price * $cartItem["quantity"];
if (is_array($addresses[0])) {
$tax = taxCalculateTax2($cartItem["productID"], $addresses[0], $addresses[1]);
} else {
$tax = taxCalculateTax($cartItem["productID"], $addresses[0], $addresses[1]);
}
$res += $tax;
}
return $res;
}
function getOrderSummarize($shippingMethodID, $paymentMethodID, $shippingAddressID, $billingAddressID, $shippingModuleFiles, $paymentModulesFiles, $shServiceID = 0)
{
// result this function
$sumOrderContent = array();
$q = db_query('select email_comments_text from ' . PAYMENT_TYPES_TABLE . ' where PID=' . (int) $paymentMethodID);
$payment_email_comments_text = db_fetch_row($q);
$payment_email_comments_text = $payment_email_comments_text[0];
$q = db_query('select email_comments_text from ' . SHIPPING_METHODS_TABLE . ' where SID=' . (int) $shippingMethodID);
$shipping_email_comments_text = db_fetch_row($q);
$shipping_email_comments_text = $shipping_email_comments_text[0];
$cartContent = cartGetCartContent();
$pred_total = oaGetClearPrice($cartContent);
if (isset($_SESSION['log'])) {
$log = $_SESSION['log'];
} else {
$log = null;
}
$d = oaGetDiscountPercent($cartContent, $log);
$discount = $pred_total / 100 * $d;
// ordering with registration
if ($shippingAddressID != 0 || isset($log)) {
$addresses = array($shippingAddressID, $billingAddressID);
$shipping_address = regGetAddressStr($shippingAddressID);
$billing_address = regGetAddressStr($billingAddressID);
$shaddr = regGetAddress($shippingAddressID);
$sh_firstname = $shaddr['first_name'];
$sh_lastname = $shaddr['last_name'];
} else {
if (!isset($_SESSION['receiver_countryID']) || !isset($_SESSION['receiver_zoneID'])) {
return NULL;
}
$shippingAddress = array('countryID' => $_SESSION['receiver_countryID'], 'zoneID' => $_SESSION['receiver_zoneID']);
$billingAddress = array('countryID' => $_SESSION['billing_countryID'], 'zoneID' => $_SESSION['billing_zoneID']);
$addresses = array($shippingAddress, $billingAddress);
$shipping_address = quickOrderGetReceiverAddressStr();
$billing_address = quickOrderGetBillingAddressStr();
$sh_firstname = $_SESSION['receiver_first_name'];
$sh_lastname = $_SESSION['receiver_last_name'];
}
foreach ($cartContent['cart_content'] as $key => $cartItem) {
// if conventional ordering
if ($shippingAddressID != 0) {
$productID = GetProductIdByItemId($cartItem['id']);
$cartItem['tax'] = taxCalculateTax($productID, $addresses[0], $addresses[1]);
} else {
$productID = $cartItem['id'];
$cartItem['tax'] = taxCalculateTax2($productID, $addresses[0], $addresses[1]);
}
if (!empty($cartItem['opt_margin']) && $paymentMethodID == 2) {
$cost = $cartItem['costUC'];
$margin = $cost / 100 * CONF_PERCENT_MARGIN;
$cost += $margin;
$costShow = show_price($cost * $cartItem['quantity']);
$pred_total += $margin * $cartItem['quantity'];
$cartContent['cart_content'][$key]['costUC'] = $cost;
$cartContent['cart_content'][$key]['cost'] = $costShow;
$cartItem['costUC'] = $cost;
$cartItem['cost'] = $costShow;
}
$sumOrderContent[] = $cartItem;
}
$shipping_method = shGetShippingMethodById($shippingMethodID);
if (!$shipping_method) {
$shipping_name = '-';
} else {
$shipping_name = $shipping_method['Name'];
}
$payment_method = payGetPaymentMethodById($paymentMethodID);
if (!$payment_method) {
$payment_name = '-';
} else {
$payment_name = $payment_method['Name'];
}
//do not calculate tax for this payment type!
if (isset($payment_method['calculate_tax']) && (int) $payment_method['calculate_tax'] == 0) {
foreach ($sumOrderContent as $key => $val) {
$sumOrderContent[$key]['tax'] = 0;
}
$orderDetails = array('first_name' => $sh_firstname, 'last_name' => $sh_lastname, 'email' => '', 'order_amount' => oaGetOrderAmountExShippingRate($cartContent, $addresses, $log, FALSE, $shServiceID));
$tax = 0;
$total = oaGetOrderAmount($cartContent, $addresses, $shippingMethodID, $log, $orderDetails, FALSE, $shServiceID);
$shipping_cost = oaGetShippingCostTakingIntoTax($cartContent, $shippingMethodID, $addresses, $orderDetails, FALSE, $shServiceID);
} else {
$orderDetails = array('first_name' => $sh_firstname, 'last_name' => $sh_lastname, 'email' => '', 'order_amount' => oaGetOrderAmountExShippingRate($cartContent, $addresses, $log, FALSE));
$tax = oaGetProductTax($cartContent, $d, $addresses);
$total = oaGetOrderAmount($cartContent, $addresses, $shippingMethodID, $log, $orderDetails, TRUE, $shServiceID);
$shipping_cost = oaGetShippingCostTakingIntoTax($cartContent, $shippingMethodID, $addresses, $orderDetails, TRUE, $shServiceID);
}
$tServiceInfo = null;
if (is_array($shipping_cost)) {
$_T = array_shift($shipping_cost);
$tServiceInfo = $_T['name'];
$shipping_cost = $_T['rate'];
}
$payment_form_html = '';
$paymentModule = modGetModuleObj($payment_method['module_id'], PAYMENT_MODULE);
if ($paymentModule) {
$order = array();
$address = array();
if ($shippingAddressID != 0) {
$payment_form_html = $paymentModule->payment_form_html(array('BillingAddressID' => $billingAddressID));
} else {
$payment_form_html = $paymentModule->payment_form_html(array('countryID' => $_SESSION['billing_countryID'], 'zoneID' => $_SESSION['billing_zoneID'], 'first_name' => $_SESSION['billing_first_name'], 'last_name' => $_SESSION['billing_last_name'], 'city' => $_SESSION['billing_city'], 'address' => $_SESSION['billing_address']));
}
}
return array('sumOrderContent' => $sumOrderContent, 'discount' => $discount, 'discount_percent' => $d, 'discount_show' => show_price($discount), 'pred_total_disc' => show_price($pred_total * ((100 - $d) / 100)), 'pred_total' => show_price($pred_total), 'totalTax' => show_price($tax), 'totalTaxUC' => $tax, 'shipping_address' => $shipping_address, 'billing_address' => $billing_address, 'shipping_name' => $shipping_name, 'payment_name' => $payment_name, 'shipping_cost' => show_price($shipping_cost), 'shipping_costUC' => $shipping_cost, 'payment_form_html' => $payment_form_html, 'total' => show_price($total), 'totalUC' => $total, 'payment_email_comments_text' => $payment_email_comments_text, 'shipping_email_comments_text' => $shipping_email_comments_text, 'orderContentCartProductsCount' => count($sumOrderContent), 'shippingServiceInfo' => $tServiceInfo);
}
function cartMoveContentFromShoppingCartsToOrderedCarts($orderID, $shippingMethodID, $paymentMethodID, $shippingAddressID, $billingAddressID, $shippingModuleFiles, $paymentModulesFiles, &$smarty_mail)
{
$sql = '
SELECT
statusID
FROM ' . ORDERS_TABLE . '
WHERE orderID=' . (int) $orderID;
$q = db_query($sql);
$order = db_fetch_row($q);
$statusID = $order['statusID'];
// select all items from SHOPPING_CARTS_TABLE
$sql = '
SELECT
itemID,
Quantity
FROM ' . SHOPPING_CARTS_TABLE . '
WHERE customerID=' . (int) regGetIdByLogin($_SESSION['log']);
$q_items = db_query($sql);
while ($item = db_fetch_row($q_items)) {
$productID = GetProductIdByItemId($item['itemID']);
if ($productID == null || trim($productID) == '') {
continue;
}
// get product by ID
$sql = '
SELECT
name,
product_code,
opt_margin
FROM ' . PRODUCTS_TABLE . '
WHERE productID=' . (int) $productID;
$q_product = db_query($sql);
$product = db_fetch_row($q_product);
// get full product name ( complex product name - $productComplexName ) -
// name with configurator options
$variants = GetConfigurationByItemId($item['itemID']);
$options = GetStrOptions($variants);
$productComplexName = $options != '' ? $product['name'] . '(' . $options . ')' : $product['name'];
if (strlen($product['product_code']) > 0) {
$productComplexName = '[' . $product['product_code'] . '] ' . $productComplexName;
}
$price = GetPriceProductWithOption($variants, $productID);
$tax = taxCalculateTax($productID, $shippingAddressID, $billingAddressID);
if (!empty($product['opt_margin']) && $paymentMethodID == 2) {
$price += $price / 100 * CONF_PERCENT_MARGIN;
}
$sql = '
INSERT INTO ' . ORDERED_CARTS_TABLE . '
SET
itemID = ' . (int) $item['itemID'] . ',
orderID=' . (int) $orderID . ',
name = "' . xEscSQL($productComplexName) . '",
Price = "' . xEscSQL($price) . '",
Quantity = ' . (int) $item['Quantity'] . ',
tax="' . xEscSQL($tax) . '"';
db_query($sql);
if ($statusID != ostGetCanceledStatusId() && CONF_CHECKSTOCK) {
$sql = '
UPDATE ' . PRODUCTS_TABLE . '
SET in_stock = in_stock - ' . (int) $item['Quantity'] . '
WHERE productID=' . (int) $productID;
db_query($sql);
$sql = '
SELECT
name,
in_stock
FROM ' . PRODUCTS_TABLE . '
WHERE productID=' . (int) $productID;
$q = db_query($sql);
$productsta = db_fetch_row($q);
if ($productsta['in_stock'] == 0) {
if (CONF_AUTOOFF_STOCKADMIN) {
$sql = '
UPDATE ' . PRODUCTS_TABLE . '
SET enabled=0
WHERE productID=' . (int) $productID;
db_query($sql);
}
if (CONF_NOTIFY_STOCKADMIN) {
$smarty_mail->assign('productstaname', $productsta['name']);
$smarty_mail->assign('productstid', $productID);
$stockadmin = $smarty_mail->fetch('notify_stockadmin.tpl');
$ressta = xMailTxtHTMLDATA(CONF_ORDERS_EMAIL, CUSTOMER_ACTIVATE_99, $stockadmin);
}
}
}
}
db_query('DELETE FROM ' . SHOPPING_CARTS_TABLE . ' WHERE customerID=' . (int) regGetIdByLogin($_SESSION['log']));
}
