<?php include "../../convenienceDB.php"; $salesNo = $_GET['salesNo']; $transactionNo = $_GET['transactionNo']; $ro = new convenienceDB(); $salesQTY = $ro->selectNow("convenience_sales", "qty", "salesNo", $salesNo); $inventoryNo = $ro->selectNow("convenience_sales", "inventoryNo", "salesNo", $salesNo); $newQTY = $ro->selectNow("convenienceInventory", "qty", "inventoryNo", $inventoryNo) + $salesQTY; $ro->editNow("convenienceInventory", "inventoryNo", $inventoryNo, "qty", $newQTY); $ro->deleteNow("convenience_sales", "salesNo", $salesNo); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/convenience/sales_output_update.php?transactionNo={$transactionNo}");
<?php include "../../convenienceDB.php"; $inventoryNo = $_GET['inventoryNo']; $transactionNo = $_GET['transactionNo']; $description = $_GET['description']; $price = $_GET['price']; $qty = $_GET['qty']; $username = $_GET['username']; $ro = new convenienceDB(); $dateAdded = date("Y-m-d"); $timeAdded = date("H:i:s"); $total = $price * $qty; if ($ro->selectNow("convenienceInventory", "qty", "inventoryNo", $inventoryNo) >= $qty) { $newQTY = $ro->selectNow("convenienceInventory", "qty", "inventoryNo", $inventoryNo) - $qty; $ro->editNow("convenienceInventory", "inventoryNo", $inventoryNo, "qty", $newQTY); $ro->addSales($inventoryNo, $transactionNo, $description, $price, $qty, $total, $dateAdded, $timeAdded, $username); } else { $ro->getBack("Your Requested Quantity is Higher than the available quantity"); }