function getRetailPrice($itemNo)
{
    $select_stmt = "SELECT FullRetailPrice FROM Item WHERE ItemNumber = '{$itemNo}'";
    $not_found_message = "Could not retrieve Full Retail Price from Item.";
    $result = get_unique_row($select_stmt, $not_found_message, $not_found_message);
    return $result['FullRetailPrice'];
}
function getAmountOff($pCode)
{
    $select_stmt = "SELECT AmountOff FROM Promotion WHERE PromoCode = {$pCode}";
    $not_found_message = "Could not retrieve Amount Off from Promotion.";
    $result = get_unique_row($select_stmt, $not_found_message, $not_found_message);
    return $result['AmountOff'];
}
function getPromotion()
{
    connect_and_select_db(DB_SERVER, DB_UN, DB_PWD, DB_NAME);
    $promoCode = $_REQUEST['promoCode'];
    $sql = "SELECT PromoCode, Name, Description, AmountOff, PromoType\n        FROM   Promotion\n        WHERE  PromoCode = '" . $promoCode . "'";
    $error_message = "Could not successfully run query to get promotion data ({$sql}) from DB: ";
    $not_found_message = "Promotion with PromoCode ({$promoCode}) not found in DB";
    $row = get_unique_row($sql, $error_message, $not_found_message);
    $promoCode = $row["PromoCode"];
    $name = $row["Name"];
    $description = $row["Description"];
    $amountOff = $row["AmountOff"];
    $promoType = $row["PromoType"];
    ui_show_update_promotion_form($promoCode, $name, $description, $amountOff, $promoType);
}
Example #4
0
function getItem()
{
    connect_and_select_db(DB_SERVER, DB_UN, DB_PWD, DB_NAME);
    $itemNumber = $_REQUEST['itemNumber'];
    $sql = "SELECT ItemNumber, ItemDescription, Category, DepartmentName, PurchaseCost, FullRetailPrice\n        FROM   Item\n        WHERE  ItemNumber = '" . $itemNumber . "'";
    $error_message = "Could not successfully run query to get item data ({$sql}) from DB: ";
    $not_found_message = "Item with Item Number ({$itemNumber}) not found in DB";
    $row = get_unique_row($sql, $error_message, $not_found_message);
    $itemNumber = $row["ItemNumber"];
    $itemDescription = $row["ItemDescription"];
    $category = $row["Category"];
    $deptName = $row["DepartmentName"];
    $purchCost = $row["PurchaseCost"];
    $retail = $row["FullRetailPrice"];
    ui_show_update_item_form($itemNumber, $itemDescription, $category, $deptName, $purchCost, $retail);
}
Example #5
0
function getEvent()
{
    connect_and_select_db(DB_SERVER, DB_UN, DB_PWD, DB_NAME);
    $eventCode = $_REQUEST['eventCode'];
    $sql = "SELECT EventCode, AdEvent.Name, StartDate, EndDate, Description, AdType\n        FROM   AdEvent\n        WHERE  EventCode = '" . $eventCode . "'";
    $error_message = "Could not successfully run query to get event data ({$sql}) from DB: ";
    $not_found_message = "Event with Event Code ({$eventCode}) not found in DB";
    $row = get_unique_row($sql, $error_message, $not_found_message);
    $eventCode = $row["EventCode"];
    $name = $row["Name"];
    $startDate = $row["StartDate"];
    $endDate = $row["EndDate"];
    $description = $row["Description"];
    $adType = $row["AdType"];
    ui_show_update_event_form($eventCode, $name, $startDate, $endDate, $description, $adType);
}