$statusMessage = ""; $statusCode = ""; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $partNumber = $_POST["PartNumber"]; $field = $_POST["Field"]; $value = $_POST["Value"]; } $IMSBase = new IMSBase(); $log = new IMSLog(); $sql = new IMSSql(); //Set IMSLog options $opt_debugLog = $sql->getOption('Debug'); if ($opt_debugLog === false) { $log->add_log($sessionID, 'Warning', 'ModifyItem Warning: Debug Option missing or invalid.'); } else { 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', '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.
include "IMSBase.php"; $statusArray = ""; $dataArray = ""; $sessionID = ""; $statusCode = 0; try { $IMSBase = new IMSBase(); $log = new IMSLog(); $sql = new IMSSql(); if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; } //Set IMSLog options $opt_debugLog = $sql->getOption('Debug'); if ($opt_debugLog === false) { $log->add_log($sessionID, 'Warning', 'CheckThresholds Warning: Debug Option missing or invalid.'); } else { 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', 'CheckThresholds Warning: Log_File_Location Option missing or invalid.'); } else { $log->set_log_location($opt_logLoc); } $runLevel = $sql->verifySID($sessionID, "0"); $dataArray = $sql->checkThresholds();
include "Back_End/IMSLog.php"; include "Back_End/IMSSql.php"; $ipaddress = ""; $date = ""; $message = ""; $SID = ""; $key = ""; $timeout = 3600; //default is 1 hour (3600 seconds) try { $log = new IMSLog(); $sql = new IMSSql(); //Set IMSLog options $opt_debugLog = $sql->getOption('Debug'); if ($opt_debugLog === false) { $log->add_log("UNKNOWN", 'Warning', 'Default Warning: Debug Option missing or invalid.'); } else { if ($opt_debugLog == 'False') { $log->opt_debug = false; } else { $log->opt_debug = true; } } //Get Credential Time out Option $opt_timeout = $sql->getOption('Credential_Expiry_Time_Seconds'); $log->add_log("UNKNOWN", 'Warning', "Default Warning: {$opt_timeout}"); if ($opt_timeout === false) { $log->add_log("UNKNOWN", 'Warning', 'Default Warning: Credential_Expiry_Time_Seconds Option missing or invalid.'); } else { $timeout = intval($opt_timeout); }
$statusMessage = ""; $statusCode = ""; $runLevel = ""; $dataArray = NULL; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $partNumber = $_POST["PartNumber"]; } $IMSBase = new IMSBase(); $log = new IMSLog(); $sql = new IMSSql(); //Set IMSLog options $opt_debugLog = $sql->getOption('Debug'); if ($opt_debugLog === false) { $log->add_log($sessionID, 'Warning', 'RetriveItem Warning: Debug Option missing or invalid.'); } else { 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', 'RetriveItem Warning: Log_File_Location Option missing or invalid.'); } else { $log->set_log_location($opt_logLoc); } $runLevel = $sql->verifySID($sessionID); //No special permission required.
$quantity = $_POST["QN"]; } $IMSBase = new IMSBase(); $log = new IMSLog(); $sql = new IMSSql(); $IMSBase->verifyData($supplierNumber, "/^.+\$/", "Supplier Number"); if ($itemLink == "") { $itemLink = "Unknown"; } if ($quantity = "") { $quantity = 0; } //Set IMSLog options $opt_debugLog = $sql->getOption('Debug'); if ($opt_debugLog === false) { $log->add_log($sessionID, 'Warning', 'AddPurchaseListItem Warning: Debug Option missing or invalid.'); } else { 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', 'AddPurchaseListItem Warning: Log_File_Location Option missing or invalid.'); } else { $log->set_log_location($opt_logLoc); } $runLevel = $sql->verifySID($sessionID, "1"); //1 = Requires edit privileges.
$dataArray = NULL; $statusMessage = ""; $statusCode = ""; $runLevel = ""; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $emailAddress = $_POST["Email"]; } $IMSBase = new IMSBase(); $log = new IMSLog(); $sql = new IMSSql(); //Set IMSLog options $opt_debugLog = $sql->getOption('Debug'); if ($opt_debugLog === false) { $log->add_log($sessionID, 'Warning', 'AddEmailAddress Warning: Debug Option missing or invalid.'); } else { 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', 'AddEmailAddress Warning: Log_File_Location Option missing or invalid.'); } else { $log->set_log_location($opt_logLoc); } $runLevel = $sql->verifySID($sessionID, "1"); //1 = Requires edit privileges.
$quantity = ""; $somevalue = ""; $dataArray = ""; $aItem = ""; try { $sql = new IMSSql(); $IMSBase = new IMSBase(); $log = new IMSLog(); if ($_SERVER["REQUEST_METHOD"] == "POST") { $aItem = $_POST['itemList']; $sessionID = $_POST['SID']; } //Set IMSLog options $opt_debugLog = $sql->getOption('Debug'); if ($opt_debugLog === false) { $log->add_log($sessionID, 'Warning', 'RemoveManualEntries Warning: Debug Option missing or invalid.'); } else { 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', 'RemoveManualEntries Warning: Log_File_Location Option missing or invalid.'); } else { $log->set_log_location($opt_logLoc); } $runLevel = $sql->verifySID($sessionID, "1"); //1 = Requires edit privileges.
$statusMessage = ""; $statusCode = ""; $runLevel = ""; $suggestionArray = NULL; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $filter = $_POST["Filter"]; } $IMSBase = new IMSBase(); $log = new IMSLog(); $sql = new IMSSql(); //Set IMSLog options $opt_debugLog = $sql->getOption('Debug'); if ($opt_debugLog === false) { $log->add_log($sessionID, 'Warning', 'QueryAutocomplete Warning: Debug Option missing or invalid.'); } else { 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', 'QueryAutocomplete Warning: Log_File_Location Option missing or invalid.'); } else { $log->set_log_location($opt_logLoc); } $runLevel = $sql->verifySID($sessionID); //No Special privileges required.
$dataArray .= "message: " . $error['message'] . "\n"; } } print_r(sqlsrv_errors()); $dataArray .= "* ---End of result --- *\r\n"; //echo "* ---End of result --- *\r\n"; } while (sqlsrv_next_result($stmt)); sqlsrv_free_stmt($stmt); } } sqlsrv_configure("WarningsReturnAsErrors", 1); sqlsrv_close($conn); } catch (PDOException $e) { $statusCode = 1; $statusMessage = 'CreateDatabase SQLError: ' . $e->getMessage(); $log->add_log($sessionID, 'Error', $statusMessage); echo "Error: " . $e->getMessage(); sqlsrv_configure("WarningsReturnAsErrors", 1); sqlsrv_close($conn); } catch (Exception $e) { $statusCode = $e->getCode(); $statusMessage = 'CreateDatabase Error: ' . $e->getMessage(); if (!$log->add_log($sessionID, 'Error', $statusMessage, "N/A", true)) { $statusMessage = $statusMessage . " **Logging Failed**"; } echo "Error: " . $e->getMessage(); sqlsrv_configure("WarningsReturnAsErrors", 1); sqlsrv_close($conn); } if ($statusCode == 0) { $statusMessage = 'Database creation successful.';
$sessionID = ""; $statusMessage = ""; $statusCode = 0; $tableType = ""; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $tableType = $_POST["type"]; } $IMSBase = new IMSBase(); $log = new IMSLog(); $sql = new IMSSql(); //Set IMSLog options $opt_debugLog = $sql->getOption('Debug'); if ($opt_debugLog === false) { $log->add_log($sessionID, 'Warning', 'GeneratePurchaseReport Warning: Debug Option missing or invalid.'); } else { 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', 'GeneratePurchaseReport Warning: Log_File_Location Option missing or invalid.'); } else { $log->set_log_location($opt_logLoc); } $IMSBase->verifyData($sessionID, "/^.+\$/"); if ($tableType == "manual") {
$statusMessage = ""; $statusCode = ""; $runLevel = ""; $partNumberChange = NULL; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $partNumber = $_POST["PartNumber"]; } $IMSBase = new IMSBase(); $log = new IMSLog(); $sql = new IMSSql(); //Set IMSLog options $opt_debugLog = $sql->getOption('Debug'); if ($opt_debugLog === false) { $log->add_log($sessionID, 'Warning', 'CreateNewItem Warning: Debug Option missing or invalid.'); } else { 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.