Bus / Airline Style Seat Map

Seat Assignment Module: This is an update for an existing train trip site, using existing mySQL table/field names. Success with this update will lead to immediate additional update projects. Projects should be completely checked for all security and SQL injection, and comply with modern web standards. BASIC FLOW: 1) Initial screen will display a calendar for the current month with all available trip dates highlighted and selectable, and the current date cell highlighted. Available dates will come from the existing mySQL database. User may select other months. Clicking on a trip date will take the user to the next screen. Only available dates are clickable. 2) This screen will display the trip date selected and a list of passengers for the trip selected on the left side. Passenger information will include booking number, last name, number of seats booked, along with CAR# and SEATS. If passenger has already been assigned a car and seats, this will be shown in these fields. If seats have not been assigned, a message will be shown to indicate this. Option to view the list of passengers ordered by booking number or number of passengers (highest to lowest). Each passenger will have a 'view seats" button with will show their currently selected seats displayed on a seat map on the right. Clicking on a passenger name or "assign seats" button will continue to the next screen. 3) This screen will show basic passenger information on the left side (trip date, passenger name, number of seats booked, class of service), and display a seat map on the right side. Passenger information will also contain two fields, CAR# and SEATS. Multiple seat maps will be available to select from on the right side of the screen by clicking on the seat map ID link. Only the selected seat map is displayed. Changing seat maps should not cause a screen refresh. The currently selected seat map number will be displayed in the CAR# field. The default state of each seat map will be to show currently "taken" seats based on information from the mySQL database. These seats will not be clickable. All other seats will be clickable. If this passenger has already been assigned seats, the seats will be highlighted on the seat map as "selected" and the correct seat map automatically selected. Clicking on seats will assign them to the SEATS field and change the seat image to "taken". Clciking on a seat number again will un-assign the seat. Changing to a different seat map will clear the SEATS field. If seats selected do not match the class the passenger has booked, and alert box should be displayed to indicate this, however seat selection can still continue in this class of service. Once seats have been selected, user will click on the save button to return to screen 2). If the number of seats selected is less than the number of seats booked by the passenger, an alert box will be displayed. User must assign additional seats to continue. NOTES: - There are currently two tables used for these functions: "passenger" and "trip". All data for the above update will come from these tables. Database information will be provided to winning bidder. - Seat map design will be similar to typical airline graphic seat map you will find on any airline site today. - Seat maps need to be easily created or changed. All seats will be displayed as graphic elements as "available", "taken" or "selected". Also allowance for graphic elements such as emergency exits, toilets, section dividers, etc. Can be hard-coded as long as it is relatively easy to create or add new seat maps. Each seat map will have a permanent ID ("CAR" above). - Each seat is assigned a seat number and service class. If user tries to select seats in a different class than what passenger has booked, an alert box will be displayed to notify the user, but seat assignment can still continue in the different class. We can provide all graphic elements and design, main need is for back-end programming to make this update work.