Zack's Journal

[Zackeree]

September 10, 2018:

• Configuring eclipse to use with github

[Zackeree]

September 17, 2018:

• Helped to organize use cases and requirements as issues on our repository.

[Zackeree]

September 24, 2018:

• Helped produce UML diagram for analysis and design
• Started to organize project repository for easier navigation
• Started learning bootstrap for our webpages

[Zackeree]

October 1, 2018

• 249ea3b6, fbb58d96 Added LoadPosition, started createTables, finished create SOP table

• 92b0c225 Finished load methods for Position and SOP

• 8d47a677 Started filling out PositionControllerTest

• 6aeb76f3, f8a7093a Added a missing skeleton to a controller, fixed an error in another controller

• 7c00ccd2 Started filling out TransitionWatcher

• 2fc4754b Started filling out PositionController

• fad19b53 Fixed an initialization error in UserController

• 9c24746c Started filling out PositionTest

• 04c46e95, ea38d2e9 Filled out Position getters/setters and fields

• 4aab0332 Added additional constructors to User and Position to generate non-empty objects, started on FakeDatabase

• Began working with mySQL workbench

[Zackeree]

October 8, 2018

• Started working on MySQL Database

• 356ad2bc Added in my initial SqlDatabase class

• 9039f107, 68d3ea2d Added all of our table inserts to SqlDatabase

• b63e9567 Added a missing field to one of our model classes

• 9bffb899, dafcfbaa Made all of our insert methods easier to use

• e7cc7f1e2 Added some initial queries

• 7329d10d Added DatabaseTest with some skeletons for later implementation

[Zackeree]

October 15 & 22, 2018

• 64155c06 Started filling out UserControllerTest and added a preliminary validateEmail method

• 3a5ed600 Implemented 5 findSOPby... queries, fixed indentation in our createTables

• 3fe5883e Fixed a big problem with our Insert statements

• dc49ee18, f694d907 Began testing DB methods

• d124523e Added methods to generate and delete a test DB for unit testing the database

• f7fcd7d6, b2588c72 Started on InitialData and loadInitialData

• fabba0f6, b273fdd7 Added skeletons for queries and began filling them in

• e010e288, d3397ec1 Started LoadInitialData, finished two queries, then fixed a typo in one of the queries.

• 11703aa9 Adding a missing piece of the previously added LoadInitialData method

• 28abba6e, 06c173a4, f35d9e29 Populated InitialData and implemented LoadInitialData, then added the LoadInitialData call to one of our main methods in the Database.

• b4da691f, 778cbbd1 Tidied up some of our tests, and implemented testInsertUser

• 343facce, 35d69ea0 Added and filled out more database tests, which led me to..

• 90b00889, b57b80af Fixing some bugs that had been haunting me since I first started the database

• bda8ee2f Moved SqlDatabase to an easier to use Database class, and had to fix some of my unit tests

• 7367a26c Fixed more instances of the lingering SOP bug

• 0faa2e5eb User can create an account

• 13452d2e Added an initial test for DeletePosition

[Zackeree]

October 29, 2018

• 12053361, f4869968, fdc0851b Started implementing password hashing in the database

• 7a9daa11, e5bc55f5 Finished password hashing, moved the method to UserController

• 83a8c0e5, 62eab2f4 Added Position requirement functionality by utilizing our PositionSOP table

• 8ad27ea2, 23a3d077 Cleaned up the positioning of the buttons on our main page

[Zackeree]

November 5, 2018

• e5644fbe, 9e53bcab Passwords are hashed and salted #94

• af21ea8, 4976be4 Database now drops and recreates itself on compile of Database.java. This remedied having to go into the command line and create the database before running the class.

• 642a9f6 Implemented a Permissions table. This will allow us to differentiate what different users can and can't do

• 5280129 Implemented the junction table which links Permission to Position, implemented CompletedSOP table to track employees with SOPs in the priority queue

• 2cfeaa73 Testing my new tables with Initial Data

• 8bf23160 Conferred with team to determine preference for InsertPosition_Permission, changing what I had originally

• 3a389757 Implemented InsertCompletedSOP

• efb9e027 Implemented a Subordinate table, which will allow us to track which managers are in charge of which employees. Also caught a bug in my CompletedSOP table.

• 7c70a499, 91426b3d Caught something on my joint inserts that I fixed, implemented insertSubordinate

• 8793e722 Implemented removeSubordinate

• 06c4d2f0, 16de0371 Bugfixes

• 8dfdaa3d Started initial Permissions

[Zackeree]

November 12, 2018

• 1d27c21c, 523af720 Fixed a bug where changing a user's password was still utilizing our old hashing method

• b803c13d, f36e1d70 Began to implement some of our final queries, but had to write a method in Database to parse the queries

• accc933c Wrote the above method and got the two queries working: userHasPermission, ManagerHasSubordinate

• 30dbe784 Testing and optimizing userHasPermission so Logan has an easier time using it

• c68412f0, c4ee2738 Implemented isLockedOut and SOPisCompleted methods in UserController, and changed the database and model classes to reflect the new query. Since we now have a permissions table, we didn't need the adminFlag field anymore

• dfda7ddd Implemented the initial Permissions for good this time. Also added employee_id as a field to the user table, and the corresponding changeEmployeeID method

• 63d9234e Added the functionality to search by Employee ID

• 847ff8240, 2db2888d Implemented two of the last queries we'll need for this milestone, listSubordinates, and hasRequirements

• Logan and I began reworking our UML to depict changes in the project, Database Schema, and tidying up our use cases.

• efdc53b2 Fixed a redirect issue in Create Position, removed text from our description boxes, made the login and password entry boxes smaller as they got tired of touching the page edge

[Zackeree]

November 19, 2018

• 62ecfbf6, b9e56022 Implemented backend support for a time clock: a Clock table, isClockedIn, clockIn, and clockOut

  • dcd11d92, feab6fe9 Updated the previous methods to use a support format for our queries that I had forgottten to use

• f99f8b17 Implemented UserSOP table, and the accompanying assignSOP method

• 1cd637a2, 59d6f395 Implemented UnresolvedClockIn and CompletedShift tables, along with refactoring their old methods which worked with our ClockTime model class

• de28f37b Noticed and fixed a bug with the calculation of hours in a shift

• 91ca6690, 9ac5c18e Implemented Quarantine table and accompanying insertQuarantineUser and verifyUser. This will allow for email verification of new accounts

• d89e4171 Utilized the Messenger to send an email with the verification pin when an account is registered into the Quarantine table

• 7f70d500 Added error checking to the insertQuarantineUser method, implemented retrySendEmail

• 0600d441, 41b51fb3 Setting up the web pages for verification, filled out VerifyEmailServlet. Now onto the jsp

• 92cc554e, 7c529538 Accounts now require email verification

• 081bc5c0, 31042ab8 Wrote ResetPasswordServlet, resetPassword method in UserController, and filled out reset_password.jsp. Ironing out some bugs, and password resets will be functional

• e7efa200 User can reset password #69

• 185771ef, bbfacc10 Generated pin upon account create and generated password on reset are now a 10 digit string with random characters

• c9c33be8, 1d8077d8 Automated emails with links now contain hyperlinks

• 102e140b, 216590f1 Added error checking to Login and ResetPassword pages

• 8f93622c Hashed verification string in database