30-01-2010, 07:47 AM
Description : This Project is a web based solution for employees time tracking. Solution must run on MS Windows Server2003 as an ASP.NET application (under IIS 6) using MS SQL 2000 database. We prefer solution in Delphi, C#, but C/C++ with managed extensions is also acceptable.Functional requirements: Users must login first before using the system. Integrated Windows authentication is preferred. Each employee must be able to enter task that he or she is working on with starting and ending date/time. Times should have one minute precision. Ending time can be entered later upon task completion. No task should span over day limit (midnight). Each employee is assigned to one primary group and zero or more secondary groups. Groups carry information about the cost of the resource (employee) per hour. Tasks must be hierarchically grouped into projects. There must be at least one level of hierarchy, but more levels must be possible (no upper limit). Project (on top level) should contain information about the customer, to whom the charges for employee's work will be invoiced. It should also contain information about the type of project: internal (no charge to customer), external (all work is charged to customer), other (user defined). On the other hand, employee's manager must be able (but not required) to review employee's entries and correct them if necessary or approve them.After tasks are reviewed and approved, another employee, responsible for invoicing to customers must be able to group all tasks that should be invoiced to a customer for a selected period together either by person or by project or for uninvoiced tasks only. After displaying the result of chosen report, the same employee must be able to select/deselect all or individual tasks for invoicing. Result should be displayed on screen and available for download as a plain text file. After invoicing is confirmed, tasks must be marked as "invoiced". Other required reports: employee's sum of working time by day, week, month and year, cumulative working time by day, week, month and year, invoiced times by customer and project and/or period of time and/or employee categorization (e.g. engineer 1, engineer 2, technician, ...). There must also be administrative part of application in order to maintain basic data (employee categories, projects,user profiles, etc.). Customers must be able to login and review the details on work performed for them. Customers are one of the users of this system.
Technologies : Jsp,Java and Servlet
Back End : Oracle
