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;
}
if (isset($_POST['site_license'])) {
if ($_POST['site_license'] == 'on') {
$licenses_purchased = 0;
$smarty->assign('licenses_purchased', $licenses_purchased);
}
}
if (isset($_POST['expiration'])) {
if ($_POST['expiration'] == 'on') {
$valid_license_days = 0;
$smarty->assign('valid_license_days', $valid_license_days);
}
}
//ensure all data is valid before generating the license
if ($customer_name !== null && $customer_email !== null && $product_type !== null && $key_version !== null && $valid_license_days !== null && $licenses_purchased !== null && $functionality_type !== null && $customer_type !== null) {
//get the next serial number from the database
$serial_number = get_serial_number();
//validate that serial number is valid here before proceeding
//(1000000 is the starting value for the serial numbers)
if (is_numeric($serial_number) && $serial_number >= 1000000) {
//generate the license
$rd = new RegistrationData();
//MR: if number of days valid equals 0, key does not expire
$rd->numberOfDaysValid = $valid_license_days;
//MR: if number of licenses purchased equals 0, this is a site license
$rd->numberOfLicensesPurchased = $licenses_purchased;
$rd->serialNumber = $serial_number;
$rd->productType = $product_type;
$rd->keyVersion = $key_version;
$rd->functionalityType = $functionality_type;
$rd->customerType = $customer_type;
$rd = generate_registration_key($rd);
