***********************************************************************/ include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $emailAddress = ""; $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) {
$sortDirection = ""; $dataArray = NULL; $statusMessage = ""; $statusCode = ""; $runLevel = ""; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $classNumber = $_POST["Class"]; $partNumber = $_POST["PartNumber"]; $quantity = $_POST["Quantity"]; $date = $_POST["Date"]; $sortColumn = $_POST["SortColumn"]; $sortDirection = $_POST["SortDirection"]; } $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', 'AddNewClassData 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) {
* Code written by: Robert Johnson * Reference: * https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e0908b2f-4afa-4626-830d-9683486186c8/backup-database?forum=sqldriverforphp * * Date: 18 February 2016 ***********************************************************************/ header('content-type: text/plain;charset=UTF-8'); include "IMSLog.php"; include "IMSBase.php"; include "IMSSql.php"; $statusMessage = ''; $statusCode = 0; $sessionID = ''; $dataArray = ''; 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; }
<?php /*********************************************************************** * Script: Test_MailSend.php * Description: Script for testing the SendEmail function in IMSBase. * * Author: Craig Irvine () * Date: 24 Feb 2016 * ***********************************************************************/ include "IMSTest.php"; include "../IMSBase.php"; try { $base = new IMSBase(); $subject = "Purchase Requirements"; $message = "<p>This is a Purchase Requirements email</p>" . "<table><tr><th>Date</th><th>Part</th><th>MFG PN</th><th>Qty</th></tr>" . "<tr><td>Date</td><td>Part</td><td>MFG PN</td><td>Qty</td></tr>" . "<tr><td>Date</td><td>Part</td><td>MFG PN</td><td>Qty</td></tr>" . "</table>"; $base->sendEmail(array("*****@*****.**"), $subject, $message); } catch (phpmailerException $e) { echo "phpmailerException: " . $e->errorMessage(); } catch (Exception $e) { echo "Exception: " . $e->getMessage(); } ?>
include "IMSSql.php"; $sessionID = ""; $statusMessage = ""; $statusCode = 0; $runLevel = ""; $supplierNumber = ""; $itemLink = ""; $quantity = ""; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $supplierNumber = $_POST["SN"]; $itemLink = $_POST["IL"]; $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') {
***********************************************************************/ include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $partNumber = ""; $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) {
include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $partNumber = ""; $field = ""; $value = ""; $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) {
* * Usage: GetOption.php?SID=<session ID> ***********************************************************************/ include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $statusMessage = ""; $statusCode = 0; $dataArray = NULL; $runLevel = "0"; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; } $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', 'GetOption 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) {
***********************************************************************/ include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $filter = ""; $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) {
* * Usage: RetrieveEmailAddress.php?SID=<session id> ***********************************************************************/ include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $statusMessage = ""; $statusCode = ""; $runLevel = ""; $dataArray = NULL; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; } $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', 'RetrieveEmailAddress 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) {
* login: SQL server login * password: SQL server password * DB: DB to connect to (most likely will be "Master") * * Date: 26 March 2016 ***********************************************************************/ header('content-type: text/plain;charset=UTF-8'); include "IMSLog.php"; include "IMSBase.php"; $statusMessage = ''; $statusCode = 0; $sessionID = ''; $dataArray = ''; $query = array("USE Master", "CREATE DATABASE IMS", "CREATE TABLE [IMS].[dbo].[Class_Data] (\n\t\t\t\tId int NOT NULL PRIMARY KEY IDENTITY (1,1),\n\t\t\t\tClass varchar(50) NOT NULL,\n\t\t\t\tPart varchar(50) NOT NULL,\n\t\t\t\tQuantity int NOT NULL,\n\t\t\t\tDate date NOT NULL)", "CREATE TABLE [IMS].[dbo].[Emails] (\n\t\t\t\tId int NOT NULL PRIMARY KEY IDENTITY (1,1),\n\t\t\t\tRecipients varchar(MAX) NOT NULL,\n\t\t\t\tEmail varchar(MAX) NOT NULL)", "CREATE TABLE [IMS].[dbo].[Inventory] (\n\t\t\t\tId int NOT NULL IDENTITY (1,1),\n\t\t\t\tName varchar(50) NOT NULL PRIMARY KEY DEFAULT 'Empty',\n\t\t\t\tSupplier_Part_Number varchar(50) NOT NULL DEFAULT 'Empty',\n\t\t\t\tQuantity int NOT NULL DEFAULT 0,\n\t\t\t\tDescription varchar(MAX) NOT NULL DEFAULT 'Empty',\n\t\t\t\tLocation varchar(50) NOT NULL DEFAULT 'Empty',\n\t\t\t\tType varchar(50) NOT NULL DEFAULT 'Empty',\n\t\t\t\tOrdering_Threshold int NOT NULL DEFAULT 0,\n\t\t\t\tValue varchar(50) NOT NULL DEFAULT 'Empty',\n\t\t\t\tSuppliers_Name varchar(50) NOT NULL DEFAULT 'Empty',\n\t\t\t\tItem_Link varchar(MAX) NOT NULL DEFAULT 'Empty',\n\t\t\t\tConsumable_Flag bit NOT NULL DEFAULT 0,\n\t\t\t\tEquipment_Flag bit NOT NULL DEFAULT 0,\n\t\t\t\tLab_Part_Flag bit NOT NULL DEFAULT 0,\n\t\t\t\tThreshold_Reported bit NOT NULL DEFAULT 0,\n\t\t\t\tLab_Quantity int NOT NULL DEFAULT 0)", "CREATE TABLE [IMS].[dbo].[Options] (\n\t\t\t\t[Option] varchar(50) NOT NULL PRIMARY KEY,\n\t\t\t\tValue varchar(MAX) NOT NULL)", "CREATE TABLE [IMS].[dbo].[Purchase_List] (\n\t\t\t\tSupplier_Part_Number varchar(50) NOT NULL PRIMARY KEY,\n\t\t\t\tItem_Link varchar(MAX) NOT NULL,\n\t\t\t\tQuantity int NOT NULL DEFAULT 0,\n\t\t\t\tThreshold_Reported bit NOT NULL DEFAULT 0)", "CREATE TABLE [IMS].[dbo].[SID_List] (\n\t\t\t\tID int NOT NULL IDENTITY (1,1),\n\t\t\t\tSID varchar(50) NOT NULL PRIMARY KEY,\n\t\t\t\tCLIENT_IP varchar(50) NOT NULL,\n\t\t\t\tEXPIRE datetime NOT NULL,\n\t\t\t\t[LEVEL] int NOT NULL)", "INSERT INTO [IMS].[dbo].[Options] ([Option], Value) VALUES \n\t\t('Automated_Backups_Enabled', 'False'),\n\t\t('Backup_Frequency', '10'),\n\t\t('Credential_Expiry_Time_Seconds', '3500'),\n\t\t('Debug', 'True'),\n\t\t('Email_fromEmail', '*****@*****.**'),\n\t\t('Email_fromName', 'Your Name'),\n\t\t('Email_Pass', 'Email server password'),\n\t\t('Email_Server', 'smtp.usask.ca'),\n\t\t('Email_User', 'Email server login'),\n\t\t('Log_File_Location', 'C:\\inetpub\\wwwroot\\Back_End\\log\\'),\n\t\t('Remote_Server_Enabled', 'True'),\n\t\t('Thresholds_Enabled', 'True')", "USE [IMS]", "CREATE USER [guest] WITHOUT LOGIN WITH DEFAULT SCHEMA=[dbo]", "GRANT CONNECT to guest", "GRANT DELETE to guest", "GRANT EXECUTE to guest", "GRANT INSERT to guest", "GRANT SELECT to guest", "GRANT UPDATE to guest", "CREATE USER [IMSBackup] WITHOUT LOGIN WITH DEFAULT SCHEMA=[dbo]", "EXEC db_addrolemember 'db_backupoperator', 'IMSBackup'", "EXEC db_addrolemember 'db_denydatareader', 'IMSBackup'", "EXEC db_addrolemember 'db_denydatawriter', 'IMSBackup'"); try { $IMSBase = new IMSBase(); $log = new IMSLog(); if ($_SERVER["REQUEST_METHOD"] == "POST") { $server = $_POST["server"]; $login = $_POST["login"]; $password = $_POST["password"]; $DB = $_POST["DB"]; } $conn = sqlsrv_connect($server, array('UID' => $login, 'PWD' => $password, 'Database' => $DB, 'CharacterSet' => 'UTF-8')); if (!$conn) { print_r(sqlsrv_errors()); exit; } sqlsrv_configure("WarningsReturnAsErrors", 0); foreach ($query as $current) { if ($stmt = sqlsrv_query($conn, $current)) {
include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $option = ""; $data = ""; $statusMessage = ""; $statusCode = 0; $runlevel = ""; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $option = $_POST["Option"]; $data = $_POST["Data"]; } $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', 'ModifyOption 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) {
* * Usage: GeneratePurcahseReport.php?SID=<session ID>&type=<manual or blank> ***********************************************************************/ include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $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) {
***********************************************************************/ include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $partNumber = ""; $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) {
* Usage: RetrieveLog.php?SID=<session id>&LogLevel=<log level> ***********************************************************************/ include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $logLevel = ""; $statusMessage = ""; $statusCode = ""; $runLevel = ""; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $logLevel = $_POST["LogLevel"]; } $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', 'RetrieveLog 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) {
***********************************************************************/ include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $statusMessage = ""; $statusCode = 0; $supplierNumber = ""; $itemLink = ""; $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; }
$sessionID = ""; $recordID = ""; $field = ""; $value = ""; $statusMessage = ""; $statusCode = ""; $runLevel = ""; $dataArray = NULL; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $recordID = $_POST["ID"]; $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', 'ModifyEmailAddress 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) {
$statusMessage = ""; $statusCode = ""; $runLevel = ""; $dataArray = NULL; $sortColumn = ""; $sortDirection = ""; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $recordID = $_POST["ID"]; $field = $_POST["Field"]; $value = $_POST["Value"]; $sortColumn = $_POST["SortColumn"]; $sortDirection = $_POST["SortDirection"]; } $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', 'ModifyClassData 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) {
$sortCoumn = ""; $sortDirection = "ASC"; //ascending is default. $filter = ""; $statusMessage = ""; $statusCode = ""; $runLevel = ""; $dataArray = NULL; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $sortColumn = $_POST["SortColumn"]; $sortDirection = $_POST["SortDirection"]; $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', 'RetrieveBroswerData 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) {
* if thresholds_enabled is set in options. * * Inputs: SID - Session ID of client * * Author: Justin Fraser * ****************************************************/ include "IMSSql.php"; include "IMSLog.php"; 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; }
***********************************************************************/ include "IMSBase.php"; include "IMSLog.php"; include "IMSSql.php"; $sessionID = ""; $id = ""; $statusMessage = ""; $statusCode = ""; $runLevel = ""; $dataArray = NULL; try { if ($_SERVER["REQUEST_METHOD"] == "POST") { $sessionID = $_POST["SID"]; $id = $_POST["ID"]; } $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', 'DeleteEmailAddress 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) {