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