Hi
We need a timesheet management system created in HTML/ Javascript/ PHP/ MySQL or PostgreSQL.
The interface needs to be configurable for different companies to adapt to their logo/look and feel. (Stylesheet)
Multiple companies will use this timesheet system.
Admin
-------------------
An admin user must be able to setup clients, e.g. "Microsoft".
An admin user must be able to setup projects, e.g. "ERP CRM Implementation 2008".
An admin user must be able to setup elements, e.g. "Sick Leave" (non billable) or "Client Meeting" (Billable).
An admin must be able to add users with details such as user email, user first and last name, user cost (price p e r h o u r), mobile number.
An admin must be able to link users to projects. Projects must in turn be connected to CLients and timesheet elements (e.g. "Sick Leave"/ "Client Meeting") must be linkable to [login to view URL] if a user logs in he must only be able to capture time for specific clients and projects he is working on.
an Admin must be able to configure the work week (e.g. Monday to Sunday or Sunday to Saturday).
Reporting:
----------------------
About 5 default reports must be created for reviewing billable hours per user/ per client/ per project/ per task- either monthly or weekly.
Leave must also be reportable on and all reports must be exportable to excel (CSV).
Outstanding timesheets must be reportable.
Reports must be runnable for all timeperiods current and in the past.
a timeperiod will typically be the Mont of August or September ( 01-August-2008 - 31-August-2008)
If something is non billable it must not add up on the monthly billable report.
Error checking:
------------------------------
a User should not be able to enter more than 24 hours a day.
a User cannot enter more than one entry per timeslot. Thus you cannot have two elements overlapping the same timeslot. u User cannot book sime for a meeting but also book the same time slot for sick leave, for instance.
Users must be able to log on and capture hours per day.
Program must be developed with as much reusability as possible.
Application must look proffesional.
The application must be secure.
We will build the database structure as we are ERP database design experts to streamline the process and give some guidance.
We will retain ownership of all code and intellectual property.