My client runs sport facilities on 2 separate locations where you can play tennis, squash and bowling. His current website enables people to make reservations for these courts. The website is not responsive though.
We need help in creating a mobile website where people can make reservations for these courts based on the booking system and database which is now in use. The system is built using PHP and MySQL. The mobile website should be responsive to all mobile devices.
The GUI design and graphics will be supplied.
See attached file for more details.
Lists the sports (tennis, squash, bowling) attached to a location (table: locations)
Lists per sport (table: activities) the booking units. (sport is bookable per ## minutes)
Lists the periodes where pricelevels are attached to. (morning, afternoon, evening are defined as EndOfMorning and BeginEvening)
Lists per sport (table: activities) the pricelevels per periode (begin- and enddate and morning, afternoon, evening and weekend)
Here are the timeslots defined where an activity is available. (table: activities)
Defines the available courts per activity (table: activities)
This table holds the booking records. Bookings are attached to a court (table: activitytracks) and are saved per booking unit. (table: activityblocks). E.g. If the booking unit is 45 minutes and someone books an activity for 1,5 hour two consecutive bookings are created.
This table lists the people who made a reservation.
Lists the locations
This table holds, as an exception, the price of the outdoor activity (tenniscourt). Fixed value.
72 freelance ont fait une offre moyenne de 678 € pour ce travail
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks