Timesheet system

Application: Timesheet system

Purpose: To capture timesheets for all contractors, employees working on various problems.

Destination environment:
1. Web based (.Net with Mysql database)
2. Twitter (works in conjunction with website)
3. Android (read & write timesheet information)
4. Iphone (read & write timesheet information - OPTIONAL)

Summary
The application will need a backend database (mysql) in order to store all the timesheets.

Capability to create a configuration for each project detailing
- Rates of Salary per day for resource type
- Resource types :
Project Manager
Site Manager
Technical Specialist
Labourer
- Project Tasks (one line per task.)
- Project Name (unique)
- Project Code (unique)
- Total Project budget (based on Man hours : standard & hour time rate)

The ability to create a configuration for each contractor/employee containing
- contractor name
- Contractor rate
- invoice template (upload word document)
- Run query to show timesheets
- by project
- submitted
- approved
- paid
- unpaid
- Once timesheets are approved generate timesheets using uploaded timesheet template and email finance manager who will then make payment and upload to google DOCS.

Each timesheet will contain the following information
- Project name (unique)
- Project Code (Unique)
- Individual names (contractor or employee)
- Timesheet will be based on a 7 day week (Monday start)
- Enter time information on based 24 hour clock

Timesheets will need to have a 3 stage approval
- 1 approval : Contractor/employee
- 2 approval : Site Manager
- 3 Approval : Project Manager

The finance manager can view all submitted timesheets against invoices from this system and make payment. This should be a single page to keep the process of payment simple and quick.

Twitter service which will allow for timesheets to be created on the basis of key information be sent to the service which in turn creates a timesheet for the contractor/employee. When the timesheet is created for the first time it is not required to fill in all the other days of the week, and it can be left open until approved or all week details completed. Project Manager can delete timesheet per site.
i.e.
to : Twitter Service
Subject : Project Code
Body: Contractor <name> Day <Tuesday> Time <xx:xx to xx:xx)
Or
to : Twitter Service
Subject : Project Code
Body: Contractor <name> Week <commencing date xx/xx/xx> Time <xx:xx to xx:xx>
Or
to : Twitter Service
Subject : Project Code
Body: Approver <project Manager Name> Contractor <name> Week <commencing date
xx/xx/xx> Approved
Or
to : Twitter Service
Subject : Project Code
Body: Approver <Project Manager name> Contractor <name> Day <Tuesday> Approved

Day 1 deliverables
1. Web site to access the above functionality
2. Twitter service
3. Documentation of complete system with implementation code.

Day 2 Deliverables
1. Android Application

Day 3 Deliverables
1. Gateway access to direct payment from Employer account to contract account.