Ejemplos de ui_show_promotion_item_insert_result en PHP

Ejemplo n.º 1

Archivo: add_item_to_promotion.php Proyecto: rjoac1/CSC423_TermProject

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);
}

Ejemplo n.º 2

Archivo: insert_promotion_item.php Proyecto: evanlws/423-Term-Project

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);
}