Project Management Software
This program should be a web-based open source program using PHP and MySQL. Javascript should be kept to a minimum, all error checking should be done on the server side. All styling should be done in CSS.
I. Scheduling Projects for individuals within set time frame/Allocating Project Hours
a. Enter Multiple employees
i. Set Level 1 (full control) and Level 2 (review and report)
ii. Set number of hours for normal business days (M-F) on individual basis (actual time of day irrelevant, just need one hour blocks)
iii. All employees log in at the beginning of the day to see summary page of schedule (just the individual for Level 2 but everybody for Level 1)
b. For New Projects:
i. Enter in customer, contact information for customer, name/description of project, estimated time for project to be completed in, and total cost.
ii. System will notify person entering the above of approximate finish date.
iii. Person creating project can assign employees to the project and assign how much time each employee will spend on the project.
iv. The person assigning the project can also request the project be given priority and assign a maximum date the project needs to be completed by.
v. Only level one employees can accept/reject priority requests.
vi. Employees will have the ability to override generic delay setting.
c. Project Management
i. Employee has ability to override current projects with another project in database.
ii. In an override, system asks employee the estimated amount of time he intends to work on the other project.
iii. Once an override occurs, the system accounts for it by pushing back other projects.
iv. Once an override is complete, the employee notifies the system to switch back to the other project.
v. Each divided chunk of time for a project should carry an actual and estimated time.
d. Instant Alerts
i. When actual time on a project is postponed past estimated date by a certain set amount of business days, system notifies select users.
ii. Ability to have employee notify system that delay email was sent to customer
e. Settings
i. Control what Level 1/2 employees can see and do
ii. Specify how many days/hours late a project can be before late notification is sent and who it is sent to.
II. Statistical Reports
a. Pick a date range for the company or an employee and report on the following:
i. Estimated time worked vs. Actual (showing an over/under summary)
ii. Projects completed within time frame, and estimated time worked vs. actual for each project and in total
b. Projects (all listed projects should show their monetary value)
i. Open projects for company or individual employees
ii. Number of delay emails sent overall and for specific projects
