This web site will be an online facilities, employee and accounting management solution package that is designed for gyms. It is designed to track and book employee time slots (for one-on-one training), track employee compensation (salary), track billing for customers, etc.
It will have a front end interface for clients to make appointments for services and purchase service credits (packages, hour-by-hour rates, and special promotions). Clients will be able to view progress reports of exercises, usage reports, and view their accounting histories.
It will have an employee interface that allows them to check their schedules, view their income, communicate with clients, track client progress and statistics, and perform limited management functions (based on permissions levels). Employees can schedule their time and availability, if allowed, and perform all the necessary day-to-day tasks to be effective employees. Each employee task is governed by a permissions system that will allow the managers/supervisors to have full control over what the employees/clients can do.
Managers/supervisors can set employee rates, system and location policies, view powerful reports that can be exported into Excel/CSV/Quickbooks, manage the e-commerce system, manage employees, etc. They can control access levels, change email templates, etc. etc. etc.
The client interface would be set up so that it could be easily integrated into the company web site, either through an iframe, popup, etc. It would provide features like: Appointment Search Wizard (front end): Allows a client to book an entire week (or months) worth of appointments in 2 steps. 1) Specify available time ranges (early morning, morning, etc.). Specify a preferred instructor/employee (optional, if unchecked, the system will display options). Instructor/employee preference? 3. Display the week of possible times, confirm all appts in on shot. The client interface would focus on speed, simplicity, and usability.
I am looking for a proficient, dedicated CakePHP developer to oversee this project.
This bid is for planning and generating the tables meant to be baked (actual development will happen in stages, and this is stage 1: initial table structure planning). Of course I don't expect a finished database design, it will change as we proceed with development. But I am looking for something as complete as possible.