I developed a activity tracker application for college students, but during half the project, the site owner had some difficulties and just vanished!! But I have the project, which I even converted to Code Igniter.
It allows you to add categories, functional areas (work areas), allow you to create/manage users and assign them to various category and functional areas. Also work assigned can be of model Onsite/Offshore which is also captured.
Then user can login work hours every day against the work. I designed a sorting and sorting table based on some column values using jquery. The database was Oracle, with PHP 5 and Apache 2 server. I think I can do a good job with the same type of project, for sure and with ease.