<?php if (isset($address_book) && isset($_SESSION["log"])) { if (isset($_GET["delete"])) { $aID = (int) $_GET["delete"]; if (regGetAddressByLogin($aID, $_SESSION["log"])) { redDeleteAddress($aID); } } if (isset($_POST["save"])) { $aID = (int) $_POST["DefaultAddress"]; if (regGetAddressByLogin($aID, $_SESSION["log"])) { regSetDefaultAddressIDByLogin($_SESSION["log"], $aID); } } $addresses = regGetAllAddressesByLogin($_SESSION["log"]); for ($i = 0; $i < count($addresses); $i++) { $addresses[$i]["addressStr"] = regGetAddressStr($addresses[$i]["addressID"]); } $defaultAddressID = regGetDefaultAddressIDByLogin($_SESSION["log"]); $smarty->assign("defaultAddressID", $defaultAddressID); $smarty->assign("addresses", $addresses); $smarty->assign("main_content_template", "address_book.tpl"); }
include $fileName; } $payment_methods = payGetAllPaymentMethods(true); $payment_methodsToShow = array(); foreach ($payment_methods as $payment_method) { if ($_GET["shippingMethodID"] == 0) { $shippingMethodsToAllow = true; } else { $shippingMethodsToAllow = false; foreach ($payment_method["ShippingMethodsToAllow"] as $ShippingMethod) { if ((int) $_GET["shippingMethodID"] == (int) $ShippingMethod["SID"] && $ShippingMethod["allow"]) { $shippingMethodsToAllow = true; break; } } } if ($shippingMethodsToAllow) { $payment_methodsToShow[] = $payment_method; } } if (count($payment_methodsToShow) == 0) { RedirectProtected("index.php?order4_confirmation=yes&" . "shippingAddressID=" . $_GET["shippingAddressID"] . "&" . "shippingMethodID=" . $_GET["shippingMethodID"] . "&" . "billingAddressID=" . regGetDefaultAddressIDByLogin($_SESSION["log"]) . "&" . "paymentMethodID=0" . (isset($_GET['shServiceID']) ? "&shServiceID=" . $_GET['shServiceID'] : '')); } $smarty->assign("shippingAddressID", $_GET["shippingAddressID"]); $smarty->assign("billingAddressID", $_GET["billingAddressID"]); $smarty->assign("shippingMethodID", $_GET["shippingMethodID"]); $smarty->assign("strAddress", regGetAddressStr($_GET["billingAddressID"])); $smarty->assign("payment_methods", $payment_methodsToShow); $smarty->assign("payment_methods_count", count($payment_methodsToShow)); $smarty->assign("main_content_template", "order3_billing.tpl"); }
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); }
$res = cartGetCartContent(); $order["orderContent"] = $res["cart_content"]; $d = oaGetDiscountPercent($res, $_SESSION["log"]); $order["order_amount"] = $res["total_price"] - $res["total_price"] / 100 * $d; return $order; } if (isset($_GET["selectedNewAddressID"])) { if (!isset($_GET["defaultBillingAddressID"])) { RedirectProtected("index.php?order2_shipping=yes" . "&shippingAddressID=" . $_GET["selectedNewAddressID"]); } else { RedirectProtected("index.php?order2_shipping=yes" . "&shippingAddressID=" . $_GET["selectedNewAddressID"] . "&defaultBillingAddressID=" . $_GET["defaultBillingAddressID"]); } } $shippingAddressID = $_GET["shippingAddressID"]; $order = _getOrder(); $strAddress = regGetAddressStr($shippingAddressID); $moduleFiles = GetFilesInDirectory("core/modules/shipping", "php"); foreach ($moduleFiles as $fileName) { include $fileName; } $shipping_methods = shGetAllShippingMethods(true); $shipping_costs = array(); $res = cartGetCartContent(); $sh_address = regGetAddress($shippingAddressID); $addresses = array($sh_address, $sh_address); $j = 0; foreach ($shipping_methods as $key => $shipping_method) { $_ShippingModule = modGetModuleObj($shipping_method["module_id"], SHIPPING_RATE_MODULE); if ($_ShippingModule) { if ($_ShippingModule->allow_shipping_to_address(regGetAddress($shippingAddressID))) { $shipping_costs[$j] = oaGetShippingCostTakingIntoTax($res, $shipping_method["SID"], $addresses, $order);
function regEmailNotification($smarty_mail, $login, $cust_password, $Email, $first_name, $last_name, $subscribed4news, $additional_field_values, $countryID, $zoneID, $state, $city, $address, $updateOperation) { $user = array(); $smarty_mail->assign("login", $login); $smarty_mail->assign("cust_password", $cust_password); $smarty_mail->assign("first_name", $first_name); $smarty_mail->assign("last_name", $last_name); $smarty_mail->assign("Email", $Email); $additional_field_values = GetRegFieldsValues($login); $smarty_mail->assign("additional_field_values", $additional_field_values); $addresses = regGetAllAddressesByLogin($login); for ($i = 0; $i < count($addresses); $i++) { $addresses[$i]["addressStr"] = regGetAddressStr((int) $addresses[$i]["addressID"]); } $smarty_mail->assign("addresses", $addresses); if (CONF_ENABLE_REGCONFIRMATION) { $sql = 'SELECT ActivationCode FROM ' . CUSTOMERS_TABLE . ' WHERE Login="******" AND cust_password="******"'; @(list($ActivationCode) = db_fetch_row(db_query($sql))); $smarty_mail->assign('ActURL', CONF_FULL_SHOP_URL . (substr(CONF_FULL_SHOP_URL, strlen(CONF_FULL_SHOP_URL) - 1, 1) == '/' ? '' : '/') . 'index.php?act_customer=1&act_code=' . $ActivationCode); $smarty_mail->assign('ActCode', $ActivationCode); } $html = $smarty_mail->fetch("register_successful.tpl"); xMailTxtHTMLDATA($Email, EMAIL_REGISTRATION, $html); }
function serExportCustomersToExcel($customers) { $maxCountAddress = 0; foreach ($customers as $customer) { $q = db_query("select count(*) from " . CUSTOMER_ADDRESSES_TABLE . " where customerID=" . $customer["customerID"]); $countAddress = db_fetch_row($q); $countAddress = $countAddress[0]; if ($maxCountAddress < $countAddress) { $maxCountAddress = $countAddress; } } // open file to write $f = fopen("core/temp/customers.csv", "w"); // head table generate $headLine = "Login;First name;Last name;Email;Group;Registered;Newsletter subscription;"; $q = db_query("select reg_field_ID, reg_field_name from " . CUSTOMER_REG_FIELDS_TABLE . " order by sort_order "); while ($row = db_fetch_row($q)) { $headLine .= _filterBadSymbolsToExcel($row["reg_field_name"]) . ";"; } for ($i = 1; $i <= $maxCountAddress; $i++) { $headLine .= "Address " . $i . ";"; } fputs($f, $headLine . "\n"); foreach ($customers as $customer) { $q = db_query("select Login, first_name, last_name, Email, custgroupID, reg_datetime, subscribed4news from " . CUSTOMERS_TABLE . " where addressID=" . (int) $customer["addressID"]); $row_cust = db_fetch_row($q); if ($row_cust["custgroupID"] != null) { $q = db_query("select custgroup_name from " . CUSTGROUPS_TABLE . " where custgroupID=" . $row_cust["custgroupID"]); $row = db_fetch_row($q); $row_cust["custgroup_name"] = $row["custgroup_name"]; } else { $row_cust["custgroup_name"] = ""; } if ($row_cust["subscribed4news"]) { $row_cust["subscribed4news"] = "+"; } else { $row_cust["subscribed4news"] = ""; } $line = ""; $line .= _filterBadSymbolsToExcel($row_cust["Login"]) . ";"; $line .= _filterBadSymbolsToExcel($row_cust["first_name"]) . ";"; $line .= _filterBadSymbolsToExcel($row_cust["last_name"]) . ";"; $line .= _filterBadSymbolsToExcel($row_cust["Email"]) . ";"; $line .= _filterBadSymbolsToExcel($row_cust["custgroup_name"]) . ";"; $line .= _filterBadSymbolsToExcel($row_cust["reg_datetime"]) . ";"; $line .= $row_cust["subscribed4news"] . ";"; $q_reg_param = db_query("select reg_field_ID, reg_field_name from " . CUSTOMER_REG_FIELDS_TABLE . " order by sort_order "); while ($row = db_fetch_row($q_reg_param)) { $q_reg_value = db_query("select reg_field_value from " . CUSTOMER_REG_FIELDS_VALUES_TABLE . " where reg_field_ID=" . $row["reg_field_ID"] . " AND customerID=" . $customer["customerID"]); $value = db_fetch_row($q_reg_value); $value = $value["reg_field_value"]; $line .= _filterBadSymbolsToExcel($value) . ";"; } $countAddress = 0; $addresses = regGetAllAddressesByLogin(regGetLoginById($customer["customerID"])); foreach ($addresses as $address) { $line .= " " . _filterBadSymbolsToExcel(regGetAddressStr($address["addressID"])) . ";"; $countAddress++; } for ($i = 1; $i <= $maxCountAddress - $countAddress; $i++) { $line .= ";"; } fputs($f, $line . "\n"); } fclose($f); }
$first_name = null; $last_name = null; $subscribed4news = null; $additional_field_values = null; regGetContactInfo($_SESSION["log"], $cust_password, $Email, $first_name, $last_name, $subscribed4news, $additional_field_values); $smarty->assign("additional_field_values", $additional_field_values); $smarty->assign("first_name", $first_name); $smarty->assign("last_name", $last_name); $smarty->assign("Email", $Email); $smarty->assign("login", $_SESSION["log"]); $customerID = regGetIdByLogin($_SESSION["log"]); $custgroup = GetCustomerGroupByCustomerId($customerID); $smarty->assign("custgroup_name", $custgroup["custgroup_name"]); $smarty->assign('affiliate_customers', affp_getCustomersNum($customerID)); if (CONF_DISCOUNT_TYPE == '2') { if ($custgroup["custgroup_discount"] > 0) { $smarty->assign("discount", $custgroup["custgroup_discount"]); } } if (CONF_DISCOUNT_TYPE == '4' || CONF_DISCOUNT_TYPE == '5') { if ($custgroup["custgroup_discount"] > 0) { $smarty->assign("min_discount", $custgroup["custgroup_discount"]); } } $defaultAddressID = regGetDefaultAddressIDByLogin($_SESSION["log"]); $addressStr = regGetAddressStr($defaultAddressID); $smarty->assign("addressStr", $addressStr); $smarty->assign("visits_count", stGetVisitsCount($_SESSION["log"])); $smarty->assign("status_distribution", ordGetDistributionByStatuses($_SESSION["log"])); $smarty->assign("main_content_template", "user_account.tpl"); }