My application allows holiday establishments to load data and accept live bookings. There are two types of user:
1. A single establishment (in folder 'venueadmin')
2. A manageing agent who manages multiple properties (in folder 'coadmin').
Admins can make reservations when a client calls them via telephone or bookings can be made from the web by normal users. All users use the same pages for making reservations and session variables determine who is logged in and displays a few separate items depending on who is making a booking. e.g. if an adminstrator is making the booking then they do not have to accept terms and conditions and and are also offered a select list from where they can choose an existing guest name...
1. I require some code changes to the reservations functions.
All files and are constructed so it is only code that needs correcting and maybe a little extra coding to add dynamic text fields / rows to complete the whole process properly.
2. I have altered some functionality and tables as regards to enterring rates and season dates into the db. Currently the user enters a season name and date for each of their properties into the 'rates' table. This has resulted in an extremley large table due to the fact that each user may have many seasons called HIGH or Low etc. I have created a new table with 'season names' and 'dates applicable' to those seasons & establishments. The 'rates' table is linked to the 'season' table via a 'season_id'.
The requirement here is that the reservations process currently seeks to compare a "requested date" (to check for availability and extract relevant rate values) to dates in the "rates" table which no longer exist there but are now in the "seasons" table. I want to implimented the new seasons table now and need the reservations process adapted to take these new tables into account. This will mena dumping existing rates table and implimenting a new 'rates' and 'season" tables which are both created.
Access to the live site is at [url removed, login to view]
to view the admin sections log in as (top left of page) "Establishment use u/name = admin and pass = hattingh2 (case sensistive). Other admin area is "Managing agent use u/name = engela and pass = driftwood (case sensitive)
PLEASE MAKE YOURSELVES FAMILIAR WITH THE VARIOUS PAGES WITHIN THE ADMIN SECTIONS IN ORDER THAT YOU UNDERSTAND THE WORK-FLOW AND DATABASE entries.
doc attached for full description and file that needs to be altered ([url removed, login to view]). This to see the reservation function. You best login as directed above to view functionality of the other fiels mentioned in the document attahed and called 1+April+booking+[url removed, login to view]