PM_Paladin

TODO

1. Attaching DB to other servers
2. Sending data from DB to Angular HTML
3. Finish implementing db functions (they're in routes/deprecated_api.js) and arranging them in api.js
4. URL Routing
5. Update DB with ToolNo and WorkstationNo columns

Our development environment

Bryan Mitchell: MacBook Pro (Early 2011), OS X Yosemite Luis Murphy: Lenovo Y40-80, Windows 10 Home

Setting up DB

1. Install Microsoft SQL Server 2016 Express (setup file included) and Microsoft SQL Server Management Studio (setup file not included)
2. Open Services.msc
3. Make sure SQL Server (SQLEXPRESS), and SQL Server Browser are Running
4. Jot down SQLEXPRESS service 'Log On As' value
5. Open SQL Server Configuration Manager
6. Go to SQL Server Services and make sure SQL Server and SQL Server Browser are also running
7. Go to SQL Server Network Configuration > Protocols for SQL Express and make sure TCP/IP is on. If not, enable and restart the services (Server, Browser)
8. Right-click mdf and ldf files, Properties, Security, Edit, Add, enter 'Log On As' value from Step 4
9. Open SSMS, right-click on Databases folder (in Object Explorer), click Attach, add Your\Path\PM_Paladin\PM_Paladin\data\paladin.mdf and OK (might bump into an error...)
10. If all else fails, open SSMS as admin, log on with Windows authentication, good luck.

Setting up Node/Express development

Download project from Git Install Node.js (v4.6.1 included)

C:\Users\You> npm install npm@latest -g
C:\Users\You> npm install -g express
C:\Users\You> npm install -g express-generator
C:\Users\You> cd Your\Path\PM_Paladin\PM_Paladin
C:\Users\You\PM_Paladin\PM_Paladin> express --ejs` (You should skip this, this creates the express scaffold
C:\Users\You\PM_Paladin\PM_Paladin> npm install
C:\Users\You\PM_Paladin\PM_Paladin> npm install -g nodemon
C:\Users\You\PM_Paladin\PM_Paladin> npm install sendgrid
C:\Users\You\PM_Paladin\PM_Paladin> npm install -g browserify
C:\Users\You\PM_Paladin\PM_Paladin> npm install dotenv --save
C:\Users\You\PM_Paladin\PM_Paladin> npm install mssql
C:\Users\You\PM_Paladin\PM_Paladin> npm install bcryptjs
C:\Users\You\PM_Paladin\PM_Paladin> npm install angular-chartist.js chartist angular --save

To start your server:

C:\Users\You\PM_Paladin\PM_Paladin> nodemon bin/www and leave running forever... :)

Note that if you make BIG changes to the files, turn nodemon off or your computer WILL lag.

Remember to set your ./public/app/.env file with: SENDGRID_API_KEY=your_api_key SQL_USER=your_ssms_user SQL_PASSWORD=your_ssms_pwd SQL_SERVER=your_ssms_server SQL_DB=your_ssms_db SALT=your_salt_int EMAIL_AUTHOR=your@email.com PROJECT_PATH=C:\YOUR\PATH

To set up the recurring scripts (for updating tasks statuses, and notifications through emails):

1. WinKey + R
2. Type taskschd.msc and press Enter
3. On the left-side menu, right-click on Task Scheduler Library and click 'New Folder', name it PMPaladin
4. Right-click on the newly created folder and click 'Create Basic Task...'
5. Create a task that starts a program (C:\PROJECT\PATH\PM_Paladin\PM_Paladin\bin\Daily.bat) daily at midnight, and set the task to start in C:\PROJECT\PATH\PM_Paladin
6. Do the same for C:\PROJECT\PATH\PM_Paladin\PM_Paladin\bin\Weekly.bat, and set it to run every Sunday at midnight