Seat booking system for the browser.
This modul allows you to book seats in a cinema. It knows the status free – reserved – booked – blocked
Each status has a color.
Before booking you have to record the seats in the room. For this process you have a layout of the room with the seats as png file to upload
You can zoom into and point to each seat. Each point and click records the x-y coordinates in a database together with a index.
To group seats as rows you can sign them with a row or column identifier (A..Z, 1..xxx)
Each time you point and click, a circle is drawn on these coordinates.
A seat has for example the followig record:
id rowid xcoord ycoord rowname placename category status
1 1 1232 14123 A 101 1 0
2 1 1456 14145 A 102 1 0
1 2 2134 15643 B 201 2 0
2 2 2145 15754 B 202 2 0
For booking you zoom into the area, click on the choosen seat (circle). The result is a change of the color of the circle by changing the status.
In a table the placename, the rowname and the category is entered as a transaction.
Can you study its and give an idea of the solution and the costs.