// registration form if (isset($_GET["user_details"]) && isset($_SESSION["log"])) { $cust_password = null; $Email = null; $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);
function regGetCustomers($callBackParam, &$count_row, $navigatorParams = null) { if ($navigatorParams != null) { $offset = $navigatorParams["offset"]; $CountRowOnPage = $navigatorParams["CountRowOnPage"]; } else { $offset = 0; $CountRowOnPage = 0; } $where_clause = ""; if (isset($callBackParam["Login"])) { $callBackParam["Login"] = xEscSQL($callBackParam["Login"]); $where_clause .= " Login LIKE '%" . $callBackParam["Login"] . "%' "; } if (isset($callBackParam["first_name"])) { $callBackParam["first_name"] = xEscSQL($callBackParam["first_name"]); if ($where_clause != "") { $where_clause .= " AND "; } $where_clause .= " first_name LIKE '%" . $callBackParam["first_name"] . "%' "; } if (isset($callBackParam["last_name"])) { $callBackParam["last_name"] = xEscSQL($callBackParam["last_name"]); if ($where_clause != "") { $where_clause .= " AND "; } $where_clause .= " last_name LIKE '%" . $callBackParam["last_name"] . "%' "; } if (isset($callBackParam["email"])) { $callBackParam["email"] = xEscSQL($callBackParam["email"]); if ($where_clause != "") { $where_clause .= " AND "; } $where_clause .= " Email LIKE '%" . $callBackParam["email"] . "%' "; } if (isset($callBackParam["groupID"])) { if ($callBackParam["groupID"] != 0) { if ($where_clause != "") { $where_clause .= " AND "; } $where_clause .= " custgroupID = " . (int) $callBackParam["groupID"] . " "; } } if (isset($callBackParam["ActState"])) { switch ($callBackParam["ActState"]) { #activated case 1: if ($where_clause != "") { $where_clause .= " AND "; } $where_clause .= " (ActivationCode='' OR ActivationCode IS NULL)"; break; #not activated #not activated case 0: if ($where_clause != "") { $where_clause .= " AND "; } $where_clause .= " ActivationCode!=''"; break; } } if ($where_clause != "") { $where_clause = " where " . $where_clause; } $order_clause = ""; if (isset($callBackParam["sort"])) { $order_clause .= " order by " . xEscSQL($callBackParam["sort"]) . " "; if (isset($callBackParam["direction"])) { if ($callBackParam["direction"] == "ASC") { $order_clause .= " ASC "; } else { $order_clause .= " DESC "; } } } $q = db_query("select customerID, Login, cust_password, Email, first_name, last_name, subscribed4news, " . " custgroupID, addressID, reg_datetime, ActivationCode " . " from " . CUSTOMERS_TABLE . " " . $where_clause . " " . $order_clause); $data = array(); $i = 0; //var_dump ($navigatorParams); while ($row = db_fetch_row($q)) { if ($i >= $offset && $i < $offset + $CountRowOnPage || $navigatorParams == null) { $group = GetCustomerGroupByCustomerId($row["customerID"]); $row["custgroup_name"] = $group["custgroup_name"]; $row["allowToDelete"] = regVerifyToDelete($row["customerID"]); $row["reg_datetime"] = format_datetime($row["reg_datetime"]); $data[] = $row; } $i++; } $count_row = $i; return $data; }
function dscCalculateDiscount($orderPrice, $log) { $discount = array("discount_percent" => 0, "discount_standart_unit" => 0, "discount_current_unit" => 0, "rest_standart_unit" => 0, "rest_current_unit" => 0, "priceUnit" => getPriceUnit()); $customerID = (int) regGetIdByLogin($log); switch (CONF_DISCOUNT_TYPE) { // discount is switched off case 1: return $discount; break; // discount is based on customer group // discount is based on customer group case 2: if (!is_bool($customerID = regGetIdByLogin($log))) { $customer_group = GetCustomerGroupByCustomerId($customerID); if ($customer_group) { $discount["discount_percent"] = $customer_group["custgroup_discount"]; } else { $discount["discount_percent"] = 0; } } else { return $discount; } break; // discount is calculated with help general order price // discount is calculated with help general order price case 3: $discount["discount_percent"] = _calculateGeneralPriceDiscount($orderPrice, $log); break; // discount equals to discount is based on customer group plus // discount calculated with help general order price // discount equals to discount is based on customer group plus // discount calculated with help general order price case 4: if (!is_bool($customerID)) { $customer_group = GetCustomerGroupByCustomerId($customerID); if (!$customer_group) { $customer_group = array("custgroup_discount" => 0); } } else { $customer_group["custgroup_discount"] = 0; } $discount["discount_percent"] = $customer_group["custgroup_discount"] + _calculateGeneralPriceDiscount($orderPrice, $log); break; // discount is calculated as MAX( discount is based on customer group, // discount calculated with help general order price ) // discount is calculated as MAX( discount is based on customer group, // discount calculated with help general order price ) case 5: if (!is_bool($customerID)) { $customer_group = GetCustomerGroupByCustomerId($customerID); } else { $customer_group["custgroup_discount"] = 0; } if ($customer_group["custgroup_discount"] >= _calculateGeneralPriceDiscount($orderPrice, $log)) { $discount["discount_percent"] = $customer_group["custgroup_discount"]; } else { $discount["discount_percent"] = _calculateGeneralPriceDiscount($orderPrice, $log); } break; } $discount["discount_standart_unit"] = (double) $orderPrice / 100 * (double) $discount["discount_percent"]; $discount["discount_current_unit"] = show_priceWithOutUnit($discount["discount_standart_unit"]); $discount["rest_standart_unit"] = $orderPrice - $discount["discount_standart_unit"]; $discount["rest_current_unit"] = show_priceWithOutUnit($discount["rest_standart_unit"]); return $discount; }