House Map Set Up

Hello,

We have a house map that represents tables on the floor level of our house. The table number is represented by a vertical column, then there are the rows and the seat numbers. At each table are seats 1-5. They are differentiated by the Section (aka.. table number) and the row. 

We are redesigning our web site and the web developers are having issues in that they don't like the way the columns represent the "sections" (aka.. table numbers). These are in TR_Section.  They said if we leave it the way it currently is, they would have to have multiple calls to the API to find seats in each section since they are represented in column format across 3 different price zones.

They have asked that we attempt to build a new house map to represent this differently. I am at a loss as to how to do this because we can only work with Section/Row/Seat. Iam curious as to whether someone may have an idea as to how to make this work? This is a representation of how it currently looks:

SEC 7    SEC 5     SEC 3   SEC 1        SEC 101  SEC 102   SEC 103  SEC 104       SEC 2    SEC4   SEC 6  SEC 8

12345   12345     12345    12345    A   12345     12345        12345       12345      A   12345    12345  12345   12345

12345   12345     12345    12345    B  12345      12345        12345        12345    B   12345     12345   12345  12345

I don't know how to change the "section" to not have it be in a column and still be able to represent the table number? So when you have a seat assigned currently it appears as "Sec 101 Row A  Seats 1-3" 

Thanks,

Amy

Parents Reply Children