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