- u_payDB.sql
- Removed rank, numDeductions, salary from employee table
- New employeeHistory table
- Changed DATETIME columns to DATE
- Corrections to projectCostHistory, projectDepartmentAssociation, and
projectEmployeeAssociation table definitions
- Updated test data set to work with new schema updates
- EditEmployee.php, doEditEmployee.php
- When adding employee, username, password fields are now displayed
further down in separate section
- Added startDate when adding employee
- Salary affecting properties (numDeductions, rank, salary) are stored
in separate employee history record
- SelectEmployee.php
- Added mode to select employee to view employee information (MyInfo)
- When no employees found, display a message instead of empty list
- EmployeeInfo.php, LoginSession.php: Updated for new DB schema changes
- MyInfo.php: Updated to allow passing in id parameter to select
employee if admin
- Employee.php:
- Removed numDeductions, rank & salary properties
- Added "current" property, which contains the most recent history
record for the employee.
- page.php
- Added output buffering to ensure redirects work if requested after
output has been written
- Bring in code & css for datepicker component
- Rearranged menus & added new menu options
- DBInterface.php:
- Added error checking for statement preparation failure
- Remove times from formatted dates
- Added readEmployeeHistory() method
- Added writeEmployeeHistory() method
- Updates for new DB schema changes
- BUGFIX: readProjects() was attempting to read from wrong database
table