Example #1
0
function updateItem()
{
    $itemNumber = $_POST['itemNumber'];
    $itemNum = $_POST['itemNum'];
    $description = $_POST['itemDescription'];
    $category = $_POST['category'];
    $deptName = $_POST['departmentName'];
    $purchaseCost = $_POST['purchaseCost'];
    $retailPrice = $_POST['retailPrice'];
    $updateStatement = "Update Item SET ItemNumber = '" . $itemNum . "', ItemDescription = '" . $description . "', Category = '" . $category . "', DepartmentName = '" . $deptName . "', PurchaseCost = '" . $purchaseCost . "', FullRetailPrice = '" . $retailPrice . "' WHERE ItemNumber = '" . $itemNumber . "'";
    // Execute the query--it will return either true or false
    $result = mysql_query($updateStatement);
    $message = "";
    if (!$result) {
        $message = "Error in updating Item: {$itemNum}, {$description}";
    } else {
        $message = "Data for Item: {$itemNum} updated successfully";
    }
    recalculateSalePrice($itemNum);
    showItemUpdateResult($message, $itemNum, $description, $category, $deptName, $purchaseCost, $retailPrice);
}
function updateAdEvent()
{
    $eventCode = $_POST['eventCode'];
    $oldCode = $_POST['code'];
    $name = $_POST['eventName'];
    $description = $_POST['eventDescription'];
    $startDateUnformatted = $_POST['startDate'];
    $endDateUnformatted = $_POST['endDate'];
    $eventType = $_POST['eventType'];
    $temp = "";
    $startDates = explode("/", $startDateUnformatted);
    //[10], [28], [2015]
    $startDatesReversed = array_reverse($startDates);
    //[2015], [28], [10]
    $temp = $startDatesReversed[1];
    //[2015], [28], [10] t:[28]
    $startDatesReversed[1] = $startDatesReversed[2];
    //[2015], [10], [10] t:[28]
    $startDatesReversed[2] = $temp;
    //[2015], [10], [28]
    $startDate = implode("-", $startDatesReversed);
    //2015-10-28
    $endDates = explode("/", $endDateUnformatted);
    $endDatesReversed = array_reverse($endDates);
    $temp = $endDatesReversed[1];
    $endDatesReversed[1] = $endDatesReversed[2];
    $endDatesReversed[2] = $temp;
    $endDate = implode("-", $endDatesReversed);
    $updateStatement = "Update AdEvent SET EventCode = '" . $eventCode . "', Description = '" . $description . "', Name = '" . $name . "', StartDate = '" . $startDate . "', EndDate = '" . $endDate . "', AdType = '" . $eventType . "' WHERE EventCode = '" . $oldCode . "'";
    // Execute the query--it will return either true or false
    $result = mysql_query($updateStatement);
    $message = "";
    if (!$result) {
        $message = "Error in updating Ad Event: {$eventCode}, {$description}";
    } else {
        $message = "Data for Event Code: {$name} updated successfully";
    }
    showItemUpdateResult($message, $eventCode, $description, $name, $startDate, $endDate, $eventType);
}
function updatePromotion()
{
    $promoCode = $_POST['promoCode'];
    $promoName = $_POST['promoName'];
    $description = $_POST['promoDescription'];
    $amountOff = $_POST['amountOff'];
    $promoType = $_POST['promoType'];
    if ($promoType == 'Percent' && $amountOff >= 1) {
        $amountOff = str_replace("%", "", $amountOff);
        $amountOff = $amountOff / 100;
    }
    $updateStatement = "Update Promotion SET Name = '" . $promoName . "', Description = '" . $description . "', AmountOff = '" . $amountOff . "', PromoType = '" . $promoType . "' WHERE PromoCode = '" . $promoCode . "'";
    // Execute the query--it will return either true or false
    $result = mysql_query($updateStatement);
    $message = "";
    if (!$result) {
        $message = "Error in updating Promotion: {$promoCode}, {$description}";
    } else {
        $message = "Data for Promotion: {$promoCode} updated successfully";
    }
    recalculateSalePrice($promoCode);
    showItemUpdateResult($message, $promoCode, $description, $promoName, $amountOff, $promoType);
}