function add_item_to_promotion() { connect_and_select_db(DB_SERVER, DB_UN, DB_PWD, DB_NAME); $itemNumbers = $_POST['itemNumbers']; $promoCode = $_REQUEST['promoCode']; //echo "Item number = $itemNumber \nPromoCode = $promoCode"; //Calculate sale price $promoType = getPromoType($promoCode); $amountOff = getAmountOff($promoCode); $message = ""; if (empty($itemNumbers)) { $message .= "Error: No Items Selected."; } else { $count = count($itemNumbers); $message .= "{$count} Items selected to be added to Promotion.<br />"; foreach ($itemNumbers as $itemNumber) { if (!itemExistsAlreadyInPromotion($itemNumber, $promoCode)) { $item_retail_price = getItemRetailPrice($itemNumber); //echo "retail price : $item_retail_price \n promotype: $promoType \n amount off: $amountOff"; $salePrice = getSalePrice($item_retail_price, $promoType, $amountOff); $insertStmt = "INSERT INTO PromotionItem (PromoCode, ItemNumber, SalePrice) values ( '{$promoCode}','{$itemNumber}', '{$salePrice}')"; $result = mysql_query($insertStmt); if (!$result) { $message .= "Error adding Item to Promotion. <br />Promo Code: {$promoCode}<br />Item Number:\n {$itemNumber}<br />Sale Price: {$salePrice}<br /><br />" . mysql_error() . "<br />"; } else { $message .= "Item added to Promotion successfully.<br />Promo Code: {$promoCode}<br />Item Number:\n {$itemNumber}<br />Sale Price: {$salePrice}<br /><br />"; } } else { $message .= "Item (Item Number: {$itemNumber}) already exists in Promotion (Promo Code: {$promoCode}).<br /><br />"; } } } ui_show_promotion_item_insert_result($message); }
function getNewSalePrice($item_retail_price, $promoCode) { $promoType = getPromoType($promoCode); $amountOff = getAmountOff($promoCode); //echo "PromoType: $promoType\nAmount off: $amountOff\nRetail Price: $item_retail_price\n"; if ($promoType == "Percent") { $result = $item_retail_price - $amountOff * $item_retail_price; //echo "Percent result: $result"; } else { $result = $item_retail_price - $amountOff; //echo "Dollar result: $result"; } $result = round($result, 2); return $result; }