I need a reporting website that connects to a FoxPro database and shows timesheet data.
1. The FoxPro database is created by FingerTec and is easy to decipher
2. The website needs to be in classic ASP (will consider ASP.NET)
3. The website needs to login the user using the "administrator" credentials already present in the database (I think password is simple text)
4. The database contains raw clocking schedule for each employee. The website needs to calculate the total hours worked for a 2 weeks period. The starting 2-week period is a pre-calculated date in the past and the user is given a simple drop-down list to select the year (2014) and the 2-week period (Sep 2 to Sep 16, etc). The default is the current year and the current period.
The page displays the list of employees (sorted by last name) along with total hours (in decimal) worked for the selected period. The "hours" should be a link to show detail view for the employee, which includes daily clocking schedule (8:00 AM - 12:30 PM - 1:00 PM - 5:00 PM: Total: 8.50 hours) followed by the total hours worked in decimal (8.50 hours). The detail view can be a separate pane on the same page, or it can be an overlay display that can be easily dismissed (by a click of a mouse, or ESC).
6 freelancers are bidding on average $171 for this job
Hi, I have 10 years experience with ASP classic and Vbscript, with strong SQL skills. I can handle this project and deliver clean code. I\'m able to start quickly. Regards.