Develop a web application to manage housekeeping service in properties like hotels.
The main goal of housekeeping module is to provide the manager an overview of cleaning service in Hotel accommodations. It must be able to handle compliments and complaints from the customers. Sum the points received to each housekeeper acting as a "gamification" environment, leading the team to a healthier competition.
The online peer evaluation system will be divided into five parts:
Schedule control - form to control cleaning schedule dates, priorities, rooms and housekeeper/maid;
Housekeeper dashboard - showing total points, top 5 housekeeper's ranking, next duties and last duties notes (paginate);
Admin service approval - form for supervisor approve and take notes about housekeeper services;
Customer service approval - form to add notes from customer compliments or complaints;
Reports - simple synthesized report about quality services.
Prerequisite: Design must be responsive (mobile friendly), bootstrap, Framework CakePHP and Mysql Database.
1) As a pattern suggestion to save cleaning appointments developer should use a table. I suggest this pattern table from CakePHP Full Calendar Plugin you may download in [login to view URL]
2) A basic ER Diagram is attached, It's not definitive, take it more as a suggestion.