function insert_item($PO_num) { if ($PO_num <= 0) { return $PO_num; } include 'php/dbconnect.php'; if ($link->connect_error) { die("Connection failed: " . $link->connect_error); } $Insert_OK = TRUE; $sql = "SELECT SKU, Count FROM purchase_order_log WHERE PONumber = '{$PO_num}'"; $result = $link->query($sql); if ($result->num_rows > 0) { // use the first row $row = $result->fetch_assoc(); $SKU = $row["SKU"]; $Count = get_stock_count($SKU); $PO_Count = $row["Count"]; if (is_consumable($SKU)) { //Is consumable $sql = "UPDATE item SET Stock_Count=Stock_Count+{$PO_Count} WHERE item.SKU={$SKU}"; $result = $link->query($sql); $sql = "SELECT Description, Manufacturer FROM item WHERE SKU = {$SKU}"; $result = $link->query($sql); if ($result->num_rows > 0) { // use the first row $row = $result->fetch_assoc(); $Description = $row["Description"]; $Manufacturer = $row["Manufacturer"]; echo "<h3>Consumable Item Updated</h3>"; echo "<br>"; echo "Description: "; echo $Description; echo "<br>"; echo "Manufacturer: "; echo get_manufacturer($Manufacturer); echo "<br>"; echo "SKU: "; echo $SKU; echo "<br>"; echo "Stock Count: "; echo $Count; echo "<br>"; } else { //Database error $Insert_OK = FALSE; } } else { //Not consumable for ($i = 1; $i <= $PO_Count; $i++) { $Serial_Number = get_serial_number(); $sql = "SELECT Description, Manufacturer FROM item WHERE SKU = {$SKU}"; $result = $link->query($sql); if ($result->num_rows > 0) { // use the first row $row = $result->fetch_assoc(); $Description = $row["Description"]; $Manufacturer = $row["Manufacturer"]; $sql = "INSERT INTO item (Description, Manufacturer, Serial_Number, SKU, Stock_Count) VALUES ('{$Description}', '{$Manufacturer}', '{$Serial_Number}', '{$SKU}', 1)"; if ($link->query($sql) === TRUE) { echo "<h3>Equipment Entered</h3>"; echo "<br>"; echo "Description: "; echo $Description; echo "<br>"; echo "Manufacturer: "; echo get_manufacturer($Manufacturer); echo "<br>"; echo "Serial Number: "; echo $Serial_Number; echo "<br>"; echo "SKU: "; echo $SKU; echo "<br>"; echo "Stock Count: "; echo $Count; echo "<br>"; } else { $Insert_OK = FALSE; echo "Error: " . $sql . "<br>" . $link->error; } } else { //Database error $Insert_OK = FALSE; } } } } else { //error PO number not found $Insert_OK = FALSE; } if ($Insert_OK == TRUE) { close_PO($PO_num); } return $PO_num; }
} </script> <?php $name = $_REQUEST['reagent_name']; $lot_number = $_REQUEST['lot_number']; $receiver = $_REQUEST['receiver']; $new_quantity = $_REQUEST['new_quantity']; $remarks = $_REQUEST['remarks']; $dd_to = $_REQUEST['dd_to']; $mm_to = $_REQUEST['mm_to']; $yyy_to = $_REQUEST['yyyy_to']; $ts = mktime(0, 0, 0, $mm_to, $dd_to, $yyyy_to); $retur = update_stocks($name, $lot_number, $new_quantity, $receiver, $remarks, $ts); $retval = array(); $retval = get_stock_count(); ?> <h3><?php echo LangUtil::$pageTerms['Inventory']; ?> </h3> <a href='javascript:div_load();'><?php echo LangUtil::$pageTerms['Current_Inventory']; ?> </a> <?php $tips_string = LangUtil::$pageTerms['TIPS_UPDATE']; //"Enter the quantity of the stock being checked out. The table below gives account of the current inventory. "; $page_elems->getSideTip("Tips", $tips_string); ?>