} else {
$log->opt_debug = true;
}
}
$opt_logLoc = $sql->getOption('Log_File_Location');
if ($opt_logLoc === false) {
$log->add_log($sessionID, 'Warning', 'ModifyItem Warning: Log_File_Location Option missing or invalid.');
} else {
$log->set_log_location($opt_logLoc);
}
$runLevel = $sql->verifySID($sessionID, "1");
//1 = Requires edit privileges.
$IMSBase->verifyData($partNumber, "/^.+\$/", "Part Number");
$IMSBase->verifyData($field, "/^.+\$/", "Item Field");
$IMSBase->verifyData($value, "/^.+\$/", "Item Value");
if ($sql->exists($partNumber, 'dbo.Inventory') == FALSE) {
$statusCode = '1';
$statusMessage = "ModifyItem Error: Part Number, {$partNumber}, does not exist.";
$log->add_log($sessionID, 'Warning', $statusMessage);
} else {
$sql->command("UPDATE dbo.Inventory SET [{$field}]='{$value}' WHERE Name='{$partNumber}';");
$statusCode = '0';
$statusMessage = "Item({$partNumber}) {$field} was updated with {$value}";
$log->add_log($sessionID, 'Information', $statusMessage, $partNumber);
}
} catch (PDOException $e) {
$statusCode = '1';
$statusMessage = 'ModifyItem SQLError: ' . $e->getMessage();
$log->add_log($sessionID, 'Error', $statusMessage);
} catch (Exception $e) {
$statusCode = $e->getCode();
if ($opt_debugLog == 'False') {
$log->opt_debug = false;
} else {
$log->opt_debug = true;
}
}
$opt_logLoc = $sql->getOption('Log_File_Location');
if ($opt_logLoc === false) {
$log->add_log($sessionID, 'Warning', 'CreateNewItem Warning: Log_File_Location Option missing or invalid.');
} else {
$log->set_log_location($opt_logLoc);
}
$runLevel = $sql->verifySID($sessionID, "1");
//1 = Requires edit privileges.
$IMSBase->verifyData($partNumber, "/^.+\$/", "Part Number");
while ($sql->exists($partNumber, 'dbo.Inventory') == TRUE) {
$oldPN = $partNumber;
//Check for revision code at end of part number
$revisionCode = substr($partNumber, -3);
if (preg_match("/^-[0-9][0-9]\$/", $revisionCode)) {
$intRev = intval(substr($revisionCode, -2));
$intRev = $intRev + 1;
$newRevStr = str_pad($intRev, 2, "0", STR_PAD_LEFT);
$partNumber = substr($partNumber, 0, strlen($partNumber) - 3) . "-" . $newRevStr;
} else {
$partNumber = $partNumber . "-01";
}
$log->add_log($sessionID, 'Warning', "CreateNewItem.php: Part number {$oldPN} existed, replaced with {$partNumber}.");
$partNumberChange[0]['Part'] = $partNumber;
}
$sql->command('INSERT INTO dbo.Inventory (Name) VALUES (\'' . $partNumber . '\');');
