} 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 . '\');');