I am trying to build a PHP and MySQL based web application which would help employees submit their timesheets and shift schedules. The employees will also be able to submit their leaves through this application which will be approved by the respective Team Leads/Managers. Through this application the admin users like Team Lead/HR will be viewing the timesheets submitted by the employees. The admin users will also be able to define the shift schedules for the employees for the upcoming weeks.
The timesheet & shift schedules will be submitted for each week separately.
Kindly help me with providing your inputs on with some ideas about the setting up the client interface and the database structure. If any similar application reference can be provided that will be more helpful.
This is a basic overview of the application. Kindly let me know if any more information is required.