We are implementing a new ranking/allocation system for our donors and subscribers to order tickets and get prime seats online or at the box office for season ticket orders. We have figured out the procedure that will automate rankings and can figure out the allocation codes for the shows. However, there are still 2 outstanding issues we can't seem to figure out.
The 1st issue is that people of a certain donor level have always been guaranteed their orders will be filled in advance of everyone else up to 6 tickets per performance. Now with this system, everyone will order and pick out seats at the same time, but the big donors will have access to specific allocation codes. But we want to be able to restrict their access to these allocation codes online up to 6 tickets. We can restrict the order to 6 but whose to say they wont go in and submit another order of tickets in that location. We have considered wiping out their rank but what if they want to add on another show. I have been researching the LWP_VALIDATE_CART procedure and the LTR_TNEW_VALIDATE_CART system table. However, can this be used for something like this, where it can prevent them from getting additional tickets in the prime allocations online for shows they ordered but still allow it for shows they haven't?
Our other issue is that we have a small group of very elite donors. We have never offered a fixed seat package, but these donors donate enough that for a 5 year period, they are guaranteed the same 2 or 4 seats in the auditorium for every performance they desire. We have some of them that would want to order online, but short of building a separate rank and MOS for every donor, which numbers around 50, we can't think of a way they can log on and see their seats and all the other seats around them but others wouldn't have access to the donor seats. We've thought about the fixed seat package, but if a donor donates enough for 2 but orders 4 tickets to each show, we can't guarantee they can get 2 seats next to them and they don't always order the same number of tickets to each show.