function check_add_coupons($auto_apply, $new_coupon_code, &$new_coupon_error) { global $db, $site_id, $table_prefix, $date_show_format; global $currency; $shopping_cart = get_session("shopping_cart"); $order_coupons = get_session("session_coupons"); $user_info = get_session("session_user_info"); $user_id = get_setting_value($user_info, "user_id", ""); $user_type_id = get_setting_value($user_info, "user_type_id", ""); $user_tax_free = get_setting_value($user_info, "tax_free", 0); $user_discount_type = get_session("session_discount_type"); $user_discount_amount = get_session("session_discount_amount"); if (!is_array($shopping_cart) || sizeof($shopping_cart) < 1) { return; } // check basic product prices before any further checks foreach ($shopping_cart as $cart_id => $item) { $item_id = $item["ITEM_ID"]; $properties_more = $item["PROPERTIES_MORE"]; if (!$item_id || $properties_more > 0) { continue; } $item_type_id = $item["ITEM_TYPE_ID"]; $properties = $item["PROPERTIES"]; $quantity = $item["QUANTITY"]; $tax_id = $item["TAX_ID"]; $tax_free = $item["TAX_FREE"]; $discount_applicable = $item["DISCOUNT"]; $buying_price = $item["BUYING_PRICE"]; $price = $item["PRICE"]; $is_price_edit = $item["PRICE_EDIT"]; $properties_price = $item["PROPERTIES_PRICE"]; $properties_percentage = $item["PROPERTIES_PERCENTAGE"]; $properties_buying = $item["PROPERTIES_BUYING"]; $properties_discount = $item["PROPERTIES_DISCOUNT"]; $components = $item["COMPONENTS"]; if ($discount_applicable) { if (!$is_price_edit) { if ($user_discount_type == 1) { $price -= round($price * $user_discount_amount / 100, 2); } else { if ($user_discount_type == 2) { $price -= round($user_discount_amount, 2); } else { if ($user_discount_type == 3) { $price -= round($price * $user_discount_amount / 100, 2); } else { if ($user_discount_type == 4) { $price -= round(($price - $buying_price) * $user_discount_amount / 100, 2); } } } } } } if ($properties_percentage && $price) { $properties_price += round($price * $properties_percentage / 100, 2); } if ($properties_discount > 0) { $properties_price -= round($properties_price * $properties_discount / 100, 2); } if ($discount_applicable) { if ($user_discount_type == 1) { $properties_price -= round($properties_price * $user_discount_amount / 100, 2); } else { if ($user_discount_type == 4) { $properties_price -= round(($properties_price - $properties_buying) * $user_discount_amount / 100, 2); } } } $price += $properties_price; // add components prices if (is_array($components) && sizeof($components) > 0) { foreach ($components as $property_id => $component_values) { foreach ($component_values as $property_item_id => $component) { $component_price = $component["price"]; $component_tax_id = $component["tax_id"]; $component_tax_free = $component["tax_free"]; if ($user_tax_free) { $component_tax_free = $user_tax_free; } $sub_item_id = $component["sub_item_id"]; $sub_quantity = $component["quantity"]; if ($sub_quantity < 1) { $sub_quantity = 1; } $sub_type_id = $component["item_type_id"]; if (!strlen($component_price)) { $sub_price = $component["base_price"]; $sub_buying = $component["buying"]; $sub_user_price = $component["user_price"]; $sub_user_action = $component["user_price_action"]; $sub_prices = get_product_price($sub_item_id, $sub_price, $sub_buying, 0, 0, $sub_user_price, $sub_user_action, $user_discount_type, $user_discount_amount); $component_price = $sub_prices["base"]; } // add to the item price component price $price += $component_price; } } } $shopping_cart[$cart_id]["BASIC_PRICE"] = $price; // basic price to calculate discount amount for product coupons $shopping_cart[$cart_id]["DISCOUNTED_PRICE"] = $price; // product price with all coupon discounts } // end of product prices check // check if any product coupons should be removed $exclusive_applied = false; $new_coupons_total = 0; $coupons_total = 0; foreach ($shopping_cart as $cart_id => $item) { $item_id = $item["ITEM_ID"]; $properties_more = $item["PROPERTIES_MORE"]; if (!$item_id || $properties_more > 0) { continue; } $item_type_id = $item["ITEM_TYPE_ID"]; $basic_price = $item["BASIC_PRICE"]; $discounted_price = $item["DISCOUNTED_PRICE"]; $quantity = $item["QUANTITY"]; // product coupons if (isset($item["COUPONS"]) && is_array($item["COUPONS"])) { foreach ($item["COUPONS"] as $coupon_id => $coupon_info) { if ($auto_apply && $coupon_info["AUTO_APPLY"]) { // always remove auto-apply coupons unset($shopping_cart[$cart_id]["COUPONS"][$coupon_id]); } else { $sql = " SELECT * FROM " . $table_prefix . "coupons "; $sql .= " WHERE coupon_id=" . $db->tosql($coupon_id, INTEGER); $db->query($sql); if ($db->next_record()) { $discount_type = $db->f("discount_type"); $coupon_discount = $db->f("discount_amount"); $min_quantity = $db->f("min_quantity"); $max_quantity = $db->f("max_quantity"); $minimum_amount = $db->f("minimum_amount"); $maximum_amount = $db->f("maximum_amount"); $is_exclusive = $db->f("is_exclusive"); // check cart fields and total values $min_cart_quantity = $db->f("min_cart_quantity"); $max_cart_quantity = $db->f("max_cart_quantity"); $min_cart_cost = $db->f("min_cart_cost"); $max_cart_cost = $db->f("max_cart_cost"); $cart_items_all = $db->f("cart_items_all"); $cart_items_ids = $db->f("cart_items_ids"); $cart_items_types_ids = $db->f("cart_items_types_ids"); check_cart_totals($cart_quantity, $cart_cost, $shopping_cart, $cart_items_all, $cart_items_ids, $cart_items_types_ids); if ($quantity < $min_quantity || $basic_price < $minimum_amount || $max_quantity && $max_quantity < $quantity || $maximum_amount && $maximum_amount < $basic_price || $cart_quantity < $min_cart_quantity || $cart_cost < $min_cart_cost || $max_cart_quantity && $max_cart_quantity < $cart_quantity || $max_cart_cost && $max_cart_cost < $cart_cost) { unset($shopping_cart[$cart_id]["COUPONS"][$coupon_id]); } else { // descrease product price for coupon discount $discount_amount = $coupon_info["DISCOUNT_AMOUNT"]; $discounted_price -= $discount_amount; $shopping_cart[$cart_id]["DISCOUNTED_PRICE"] = $discounted_price; if ($is_exclusive) { $exclusive_applied = true; } $coupons_total++; } } else { unset($shopping_cart[$cart_id]["COUPONS"][$coupon_id]); } } } } } // check if any order coupons should be removed // cart_quantity and cart_cost variable is used to check order coupons if (is_array($order_coupons)) { foreach ($order_coupons as $coupon_id => $coupon_info) { if ($auto_apply && $coupon_info["AUTO_APPLY"]) { // always remove auto-apply coupons unset($order_coupons[$coupon_id]); } else { $sql = " SELECT c.* FROM "; if (isset($site_id)) { $sql .= "("; } $sql .= $table_prefix . "coupons c"; if (isset($site_id)) { $sql .= " LEFT JOIN " . $table_prefix . "coupons_sites s ON s.coupon_id=c.coupon_id)"; } $sql .= " WHERE c.coupon_id=" . $db->tosql($coupon_id, INTEGER); if (isset($site_id)) { $sql .= " AND (c.sites_all=1 OR s.site_id=" . $db->tosql($site_id, INTEGER, true, false) . ")"; } else { $sql .= " AND c.sites_all=1 "; } $sql .= " ORDER BY c.apply_order "; $db->query($sql); if ($db->next_record()) { $discount_type = $db->f("discount_type"); $coupon_discount = $db->f("discount_amount"); $is_exclusive = $db->f("is_exclusive"); // check cart fields and cart totals $min_cart_quantity = $db->f("min_cart_quantity"); $max_cart_quantity = $db->f("max_cart_quantity"); $min_cart_cost = $db->f("min_cart_cost"); $max_cart_cost = $db->f("max_cart_cost"); check_cart_totals($cart_quantity, $cart_cost, $shopping_cart, 1, "", ""); if ($cart_quantity < $min_cart_quantity || $cart_cost < $min_cart_cost || $max_cart_quantity && $max_cart_quantity < $cart_quantity || $max_cart_cost && $max_cart_cost < $cart_cost) { unset($order_coupons[$coupon_id]); } else { if ($is_exclusive) { $exclusive_applied = true; } $coupons_total++; } } else { unset($order_coupons[$coupon_id]); } } } } // check if new coupons could be added $new_coupons = array(); $coupon_title = ""; if (strlen($new_coupon_code)) { $sql = " SELECT c.* FROM (" . $table_prefix . "coupons c"; if (isset($site_id)) { $sql .= " LEFT JOIN " . $table_prefix . "coupons_sites s ON s.coupon_id=c.coupon_id)"; } else { $sql .= ")"; } $sql .= " WHERE c.coupon_code=" . $db->tosql($new_coupon_code, TEXT); if (isset($site_id)) { $sql .= " AND (c.sites_all=1 OR s.site_id=" . $db->tosql($site_id, INTEGER, true, false) . ")"; } else { $sql .= " AND c.sites_all=1 "; } $sql .= " ORDER BY c.apply_order "; $db->query($sql); if ($db->next_record()) { $new_coupon_id = $db->f("coupon_id"); $start_date_db = $db->f("start_date", DATETIME); $expiry_date_db = $db->f("expiry_date", DATETIME); $coupon_title = $db->f("coupon_title"); $new_coupons[$new_coupon_id] = $db->Record; $new_coupons[$new_coupon_id]["start_date_db"] = $start_date_db; $new_coupons[$new_coupon_id]["expiry_date_db"] = $expiry_date_db; } } $discount_types = array("3,4", "1,2", "5"); // check products coupons, then order coupons and only then vouchers if ($auto_apply) { for ($dt = 0; $dt < sizeof($discount_types); $dt++) { $sql = " SELECT c.* FROM "; if (isset($site_id)) { $sql .= " ( "; } $sql .= $table_prefix . "coupons c"; if (isset($site_id)) { $sql .= " LEFT JOIN " . $table_prefix . "coupons_sites s ON s.coupon_id=c.coupon_id)"; } $sql .= " WHERE c.is_auto_apply=1 "; $sql .= " AND c.discount_type IN (" . $discount_types[$dt] . ") "; if (isset($site_id)) { $sql .= " AND (c.sites_all=1 OR s.site_id=" . $db->tosql($site_id, INTEGER, true, false) . ")"; } else { $sql .= " AND c.sites_all=1 "; } $sql .= " ORDER BY c.apply_order "; $db->query($sql); while ($db->next_record()) { $new_coupon_id = $db->f("coupon_id"); $start_date_db = $db->f("start_date", DATETIME); $expiry_date_db = $db->f("expiry_date", DATETIME); $new_coupons[$new_coupon_id] = $db->Record; $new_coupons[$new_coupon_id]["start_date_db"] = $start_date_db; $new_coupons[$new_coupon_id]["expiry_date_db"] = $expiry_date_db; } } } // check if new coupons could be added if (sizeof($new_coupons) > 0) { foreach ($new_coupons as $new_coupon_id => $data) { $coupon_error = ""; $is_active = $data["is_active"]; $new_coupon_id = $data["coupon_id"]; $coupon_auto_apply = $data["is_auto_apply"]; $coupon_code = $data["coupon_code"]; $coupon_title = $data["coupon_title"]; $discount_type = $data["discount_type"]; $discount_quantity = $data["discount_quantity"]; $coupon_discount = $data["discount_amount"]; $free_postage = $data["free_postage"]; $coupon_tax_free = $data["coupon_tax_free"]; $coupon_order_tax_free = $data["order_tax_free"]; $items_all = $data["items_all"]; $items_ids = $data["items_ids"]; $items_types_ids = $data["items_types_ids"]; $search_items_ids = explode(",", $items_ids); $search_items_types_ids = explode(",", $items_types_ids); $cart_items_all = $data["cart_items_all"]; $cart_items_ids = $data["cart_items_ids"]; $cart_items_types_ids = $data["cart_items_types_ids"]; $users_all = $data["users_all"]; $users_use_limit = $data["users_use_limit"]; $users_ids = $data["users_ids"]; $users_types_ids = $data["users_types_ids"]; $search_users_ids = explode(",", $users_ids); $search_users_types_ids = explode(",", $users_types_ids); $expiry_date = ""; $is_expired = false; $expiry_date_db = $data["expiry_date_db"]; if (is_array($expiry_date_db)) { $expiry_date = va_date($date_show_format, $expiry_date_db); $expiry_date_ts = mktime(0, 0, 0, $expiry_date_db[MONTH], $expiry_date_db[DAY], $expiry_date_db[YEAR]); $current_date_ts = va_timestamp(); if ($current_date_ts > $expiry_date_ts) { $is_expired = true; } } $start_date = ""; $is_upcoming = false; $start_date_db = $data["start_date_db"]; if (is_array($start_date_db)) { $start_date = va_date($date_show_format, $start_date_db); $start_date_ts = mktime(0, 0, 0, $start_date_db[MONTH], $start_date_db[DAY], $start_date_db[YEAR]); $current_date_ts = va_timestamp(); if ($current_date_ts < $start_date_ts) { $is_upcoming = true; } } // check number how many times user can use coupon $user_not_limited = false; if ($users_use_limit && $user_id) { if ($discount_type == 3 || $discount_type == 4) { $sql = " SELECT COUNT(*) FROM " . $table_prefix . "orders_items oi "; $sql .= " WHERE oi.user_id=" . $db->tosql($user_id, INTEGER); $sql .= " AND (oi.coupons_ids=" . $db->tosql($new_coupon_id, TEXT); $sql .= " OR oi.coupons_ids LIKE '" . $db->tosql($new_coupon_id, INTEGER) . ",%'"; $sql .= " OR oi.coupons_ids LIKE '%," . $db->tosql($new_coupon_id, INTEGER) . "'"; $sql .= " OR oi.coupons_ids LIKE '%," . $db->tosql($new_coupon_id, INTEGER) . ",%') "; } else { $sql = " SELECT COUNT(*) FROM (" . $table_prefix . "orders o "; $sql .= " INNER JOIN " . $table_prefix . "orders_coupons oc ON o.order_id=oc.order_id) "; $sql .= " WHERE o.user_id=" . $db->tosql($user_id, INTEGER); $sql .= " AND oc.coupon_id=" . $db->tosql($new_coupon_id, INTEGER); } $user_uses = get_db_value($sql); if ($users_use_limit > $user_uses) { $user_not_limited = true; } } // check goods cost limits $orders_period = $data["orders_period"]; $orders_interval = $data["orders_interval"]; $orders_min_goods = $data["orders_min_goods"]; $orders_max_goods = $data["orders_max_goods"]; $orders_goods_coupon = false; if ($user_id && ($orders_min_goods || $orders_max_goods)) { // check if user buy something in the past $sql = " SELECT SUM(o.goods_total) FROM (" . $table_prefix . "orders o "; $sql .= " INNER JOIN " . $table_prefix . "order_statuses os ON o.order_status=os.status_id) "; $sql .= " WHERE o.user_id=" . $db->tosql($user_id, INTEGER); $sql .= " AND os.paid_status=1 "; if ($orders_period && $orders_interval) { $cd = va_time(); if ($orders_period == 1) { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY] - $orders_interval, $cd[YEAR]); } elseif ($orders_period == 2) { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY] - $orders_interval * 7, $cd[YEAR]); } elseif ($orders_period == 3) { $od = mktime(0, 0, 0, $cd[MONTH] - $orders_interval, $cd[DAY], $cd[YEAR]); } else { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY], $cd[YEAR] - $orders_interval); } $sql .= " AND order_placed_date>=" . $db->tosql($od, DATETIME); } $user_goods_cost = get_db_value($sql); if ($user_goods_cost >= $orders_min_goods && ($user_goods_cost <= $orders_max_goods || !strlen($orders_max_goods))) { $orders_goods_coupon = true; } } // check for friends coupons $friends_coupon = false; $friends_discount_type = $data["friends_discount_type"]; $friends_all = $data["friends_all"]; $friends_ids = $data["friends_ids"]; $friends_types_ids = $data["friends_types_ids"]; $friends_period = $data["friends_period"]; $friends_interval = $data["friends_interval"]; $friends_min_goods = $data["friends_min_goods"]; $friends_max_goods = $data["friends_max_goods"]; $search_friends_ids = explode(",", $friends_ids); $search_friends_types_ids = explode(",", $friends_types_ids); if ($friends_discount_type == 1) { // check if user friends buy something $user_friends_goods = 0; if ($user_id) { $sql = " SELECT SUM(o.goods_total) FROM (" . $table_prefix . "orders o "; $sql .= " INNER JOIN " . $table_prefix . "order_statuses os ON o.order_status=os.status_id) "; $sql .= " WHERE o.friend_user_id=" . $db->tosql($user_id, INTEGER); $sql .= " AND os.paid_status=1 "; if ($friends_period && $friends_interval) { $cd = va_time(); if ($friends_period == 1) { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY] - $friends_interval, $cd[YEAR]); } elseif ($friends_period == 2) { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY] - $friends_interval * 7, $cd[YEAR]); } elseif ($friends_period == 3) { $od = mktime(0, 0, 0, $cd[MONTH] - $friends_interval, $cd[DAY], $cd[YEAR]); } else { $od = mktime(0, 0, 0, $cd[MONTH], $cd[DAY], $cd[YEAR] - $friends_interval); } $sql .= " AND order_placed_date>=" . $db->tosql($od, DATETIME); } $user_friends_goods = get_db_value($sql); } if ($user_friends_goods >= $friends_min_goods && ($user_friends_goods <= $friends_max_goods || !strlen($friends_max_goods))) { $friends_coupon = true; } } elseif ($friends_discount_type == 2) { $friend_code = get_session("session_friend"); $friend_user_id = get_friend_info(); $friend_type_id = get_session("session_friend_type_id"); // check whose friends could use coupon if ($friends_all && $friend_user_id || $friend_user_id && in_array($friend_user_id, $search_friends_ids) || $friend_type_id && in_array($friend_type_id, $search_friends_types_ids)) { $friends_coupon = true; } } // global options $is_exclusive = $data["is_exclusive"]; $quantity_limit = $data["quantity_limit"]; $coupon_uses = $data["coupon_uses"]; // check cart total values $min_cart_quantity = $data["min_cart_quantity"]; $max_cart_quantity = $data["max_cart_quantity"]; $min_cart_cost = $data["min_cart_cost"]; $max_cart_cost = $data["max_cart_cost"]; if ($discount_type <= 2) { $cart_items_all = 1; } // for order coupons always use all cart products to calculate totals check_cart_totals($cart_quantity, $cart_cost, $shopping_cart, $cart_items_all, $cart_items_ids, $cart_items_types_ids); // product specific fields $min_quantity = $data["min_quantity"]; $max_quantity = $data["max_quantity"]; $minimum_amount = $data["minimum_amount"]; $maximum_amount = $data["maximum_amount"]; // check if coupon can be applied if (!$is_active) { $coupon_error = COUPON_NON_ACTIVE_MSG; } elseif ($quantity_limit > 0 && $coupon_uses >= $quantity_limit) { $coupon_error = COUPON_USED_MSG; } elseif ($is_expired) { $coupon_error = COUPON_EXPIRED_MSG; } elseif ($is_upcoming) { $coupon_error = COUPON_UPCOMING_MSG; } elseif (($exclusive_applied || $is_exclusive && $coupons_total > 0) && $discount_type != 5 && !is_only_gift_certificate()) { //Customization by Vital - allow gift cert. with other coupons $coupon_error = COUPON_EXCLUSIVE_MSG; } elseif ($discount_type <= 4 && $min_cart_cost > $cart_cost) { $coupon_error = str_replace("{cart_amount}", currency_format($min_cart_cost), MIN_CART_COST_ERROR); } elseif ($discount_type <= 4 && $max_cart_cost && $max_cart_cost < $cart_cost) { $coupon_error = str_replace("{cart_amount}", currency_format($max_cart_cost), MAX_CART_COST_ERROR); } elseif ($discount_type <= 4 && $min_cart_quantity > $cart_quantity) { $coupon_error = str_replace("{min_quantity}", $min_cart_quantity, COUPON_MIN_QTY_ERROR); } elseif ($discount_type <= 4 && $max_cart_quantity && $max_cart_quantity < $cart_quantity) { $coupon_error = str_replace("{max_quantity}", $max_cart_quantity, COUPON_MAX_QTY_ERROR); } elseif (!($users_all || $user_id && in_array($user_id, $search_users_ids) || $user_type_id && in_array($user_type_id, $search_users_types_ids))) { $coupon_error = COUPON_CANT_BE_USED_MSG; // coupon can't be used for current user } elseif ($users_use_limit && !$user_not_limited) { // coupon can't be used more times if ($users_use_limit == 1) { $coupon_error = COUPON_CAN_BE_USED_ONCE_MSG; } else { $coupon_error = str_replace("{use_limit}", $users_use_limit, COUPON_SAME_USE_LIMIT_MSG); } } elseif ($friends_discount_type > 0 && !$friends_coupon) { $coupon_error = COUPON_CANT_BE_USED_MSG; // coupon has friends options which can't be used for current user } elseif (($orders_min_goods || $orders_max_goods) && !$orders_goods_coupon) { $coupon_error = COUPON_CANT_BE_USED_MSG; // the sum of user purchased goods doesn't match with goods values for this coupon } // end coupons checks if (!$coupon_error) { // check products coupons $coupon_items = false; foreach ($shopping_cart as $cart_id => $item) { $item_id = $item["ITEM_ID"]; $item_type_id = $item["ITEM_TYPE_ID"]; $properties_more = $item["PROPERTIES_MORE"]; //Customization by Vital $properties_info_array = $item["PROPERTIES_INFO"]; $properties_info_array = reset($properties_info_array); $coupon_size_applies = array(); if (preg_match('#\\((.*?)\\)#', $coupon_title, $sizes)) { //get all sizes $sizes[1] = strtolower(str_replace(" ", "", $sizes[1])); //remove spaces and lowercase it $coupon_size_applies = explode(",", $sizes[1]); //place them in array } //place them in array $size_does_not_apply = false; $item_size = ""; if (count($coupon_size_applies) != 0 && strcasecmp($properties_info_array["NAME"], "size") == 0) { $sql = "SELECT property_value FROM va_items_properties_values WHERE item_property_id=" . $properties_info_array["VALUES"][0]; $db->query($sql); if ($db->next_record()) { $item_size = strtolower($db->f("property_value")); } $size_does_not_apply = !in_array($item_size, $coupon_size_applies); } //Check if the coupon applies for the item size if (strcasecmp($properties_info_array["NAME"], "size") == 0 && !$items_all) { $sql = "SELECT COUNT(*) FROM va_coupons_sizes WHERE coupon_id=" . $new_coupon_id . " AND item_id=" . $item_id . " AND item_size_id=" . $properties_info_array["VALUES"][0]; $size_is_in = get_db_value($sql); $sql = "SELECT COUNT(*) FROM va_coupons_sizes WHERE coupon_id=" . $new_coupon_id . " AND item_id=" . $item_id; $other_sizes = get_db_value($sql); $size_does_not_apply = $size_is_in == 0 && $other_sizes != 0 ? true : false; } //$coupon_error = $size_does_not_apply." ".$coupon_size_applies; //if (!$item_id || $properties_more > 0) { //original line if (!$item_id || $properties_more > 0 || $size_does_not_apply) { //EDN customization // ignore the products which has options to be added first continue; } $quantity = $item["QUANTITY"]; $basic_price = $item["BASIC_PRICE"]; $discounted_price = $item["DISCOUNTED_PRICE"]; // add a new coupon if ($discount_type == 3 || $discount_type == 4) { if ($basic_price >= $minimum_amount && $quantity >= $min_quantity && (!$maximum_amount || $basic_price <= $maximum_amount) && (!$max_quantity || $quantity <= $max_quantity) && ($items_all || in_array($item_id, $search_items_ids) || in_array($item_type_id, $search_items_types_ids))) { // add coupon to products $coupon_items = true; if ($discount_type == 3) { $discount_amount = round($basic_price / 100 * $coupon_discount, 2); } else { $discount_amount = $coupon_discount; } if ($discount_amount > $discounted_price) { $discount_amount = $discounted_price; } $shopping_cart[$cart_id]["DISCOUNTED_PRICE"] -= $discount_amount; if (!isset($shopping_cart[$cart_id]["COUPONS"][$new_coupon_id])) { // calculate number of new applied coupons $new_coupons_total++; } $shopping_cart[$cart_id]["COUPONS"][$new_coupon_id] = array("COUPON_ID" => $new_coupon_id, "EXCLUSIVE" => $is_exclusive, "DISCOUNT_QUANTITY" => $discount_quantity, "DISCOUNT_AMOUNT" => $discount_amount, "AUTO_APPLY" => $coupon_auto_apply); if ($is_exclusive) { $exclusive_applied = true; } $coupons_total++; } } } if (($discount_type == 3 || $discount_type == 4) && !$coupon_items) { $coupon_error = COUPON_PRODUCTS_MSG; } // end products checks // check order coupons if ($discount_type <= 2 || $discount_type == 5) { if (!isset($order_coupons[$new_coupon_id])) { $new_coupons_total++; } // add new coupon to system $order_coupons[$new_coupon_id] = array("COUPON_ID" => $new_coupon_id, "DISCOUNT_TYPE" => $discount_type, "EXCLUSIVE" => $is_exclusive, "COUPON_TAX_FREE" => $coupon_tax_free, "MIN_QUANTITY" => $min_cart_quantity, "MAX_QUANTITY" => $max_cart_quantity, "MIN_AMOUNT" => $min_cart_cost, "MAX_AMOUNT" => $max_cart_cost, "ORDER_TAX_FREE" => $coupon_order_tax_free, "AUTO_APPLY" => $coupon_auto_apply); if ($is_exclusive) { $exclusive_applied = true; } $coupons_total++; } // end order coupons checks } if (strtolower($coupon_code) == strtolower($new_coupon_code) && $coupon_error) { $new_coupon_error = $coupon_error; } } } // end check a new coupons and auto-applied coupons // update shopping cart and order coupons set_session("shopping_cart", $shopping_cart); set_session("session_coupons", $order_coupons); // return number of applied coupons return $new_coupons_total; }
if (!strlen($sub_is_points_price)) { $sub_is_points_price = $points_prices; } if (!strlen($component_price)) { $sub_price = $db->f($price_field); $sub_is_sales = $db->f("is_sales"); $sub_sales = $db->f($sales_field); // check price for selected quantity for current user $sub_user_price = ""; $sub_user_action = 0; $q_prices = get_quantity_price($sub_item_id, $quantity * $sub_quantity); if ($q_prices) { $sub_user_price = $q_prices[0]; $sub_user_action = $q_prices[2]; } $sub_prices = get_product_price($sub_item_id, $sub_price, $sub_buying, $sub_is_sales, $sub_sales, $sub_user_price, $sub_user_action, $user_discount_type, $user_discount_amount); $component_price = $sub_prices["base"]; // update information in the cart as well if ($sub_is_sales && $sub_sales > 0) { $component["base_price"] = $sub_sales; } else { $component["base_price"] = $sub_price; } $component["buying"] = $db->f("buying_price"); $component["user_price"] = $sub_user_price; $component["user_price_action"] = $sub_user_action; $shopping_cart[$cart_id]["COMPONENTS"][$property_id][$item_property_id] = $component; } if ($sub_points_price <= 0) { $sub_points_price = $component_price * $points_conversion_rate; }
<?php include 'db_connect.inc.php'; session_start(); if (isset($_POST['product_id'])) { $user_id = $_SESSION['vsm_user_id']; $user_name = $_SESSION['vsm_user_name']; $product_id = $_POST['product_id']; $current_cash = get_current_cash($user_id); $amount = get_product_price($product_id); $balance = $current_cash - $amount; if ($balance < 0) { $allow = 0; } else { $allow = 1; } $success = 0; if ($allow == 1) { global $con; $err = 0; $sql = "INSERT into redeem_req (user_id , user_name , product_id) values ('{$user_id}', '{$user_name}', '{$product_id}')"; $sql1 = "UPDATE players set current_cash = '{$balance}' where user_id = '{$user_id}'"; $query = mysqli_query($con, $sql); $query1 = mysqli_query($con, $sql1); if (!$query && !$query1) { $err = mysqli_error(); $allow = 0; $success = 0; } else { $success = 1; }
// points data $is_points_price = $db->f("is_points_price"); $points_price = $db->f("points_price"); $reward_type = $db->f("reward_type"); $reward_amount = $db->f("reward_amount"); $credit_reward_type = $db->f("credit_reward_type"); $credit_reward_amount = $db->f("credit_reward_amount"); if (!strlen($reward_type)) { $reward_type = $db->f("type_bonus_reward"); $reward_amount = $db->f("type_bonus_amount"); } if (!strlen($credit_reward_type)) { $credit_reward_type = $db->f("type_credit_reward"); $credit_reward_amount = $db->f("type_credit_amount"); } $prices = get_product_price($sub_item_id, $item_price, $buying_price, $is_sales, $sales_price, $user_price, $user_action, $user_discount_type, $user_discount_amount); $base_price = $prices["base"]; $real_price = $prices["real"]; if (strlen($component_price)) { $price = $component_price; } else { $price = $base_price; } // re-calculate price in case if prices include some default tax rate $item_tax = get_tax_amount($tax_rates, $item_type_id, $price, 1, $item_tax_id, $item_tax_free, $item_tax_percent, $default_tax_rates); $item_real_tax = get_tax_amount($tax_rates, $item_type_id, $real_price, 1, $item_tax_id, $item_tax_free, $item_tax_percent, $default_tax_rates); //$item_buying_tax = get_tax_amount($tax_rates, $item_type_id, $buying_price, $item_tax_free, $item_tax_percent, $default_tax_rates); $item_code = $db->f("item_code"); $manufacturer_code = $db->f("manufacturer_code"); $item_name = $db->f("item_name"); $downloadable = $db->f("downloadable");