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 insert_promotion_item() { connect_and_select_db(DB_SERVER, DB_UN, DB_PWD, DB_NAME); $itemId = $_POST['itemId']; $promotionId = $_POST['promotionId']; $salePrice = $_POST['salePrice']; $insertStatement = "INSERT INTO Promotion-Item (PromoCode, ItemNumber, SalePrice,\n\t\t PromoType) values ( '{$promotionId}', '{$itemId}',\n '{$salePrice}')"; //Execute the query. The result will just be true or false $result = mysql_query($insertStatement); $message = ""; if (!$result) { $message = "Error in inserting Promotion: {$promotionId} , with Item: {$itemId}: "; } else { $message = "The Promotion {$promotionId} with Item {$itemId} was inserted successfully."; } ui_show_promotion_item_insert_result($message, $promotionId, $itemId, $salePrice); }