Right there could be multiple sponsor levels per conference and each COULD exhibit and get additional perks based on if they also choose to exhibit.. For example:
Bronze: 1 free guest Bronze + Exhibit: 1 free guest $300 off Exhibit fee Silver: 2 free guests Free access to bonus event Silver + Exhibit: 2 free guests Free access to bonus event $500 off exhibit fee They could also JUST exhibit and not be a sponsor in which they would get a different perk entirely.. The system works for the sponsor level just fine, but NOT if they want to be a sponsor and choose to exhibit. They register as a sponsor, choose Silver level and if takes off 2 guests fees.. but I need to be able to ask "Would you like to exhibit?" and if so then apply the discount perk to the total. On Tue, May 15, 2012 at 9:19 AM, Scott Stewart <[email protected]>wrote: > > Just My $.02 > > It sounds like a registrant can gave multiple sponsor levels, link the > sponsor level to the registrant as a one to many (one registrant can > have multiple sponsor levels) > with the perks based on sponsor level, as a one to many, you should be > able to query for perks by registrant, through a couple of joins > > On 5/15/2012 9:49 AM, Greg Morphis wrote: > > I'm working on a registration system and I'm trying to add the ability to > > add perks and discounts based on registration type. > > For example, if you register as a bronze sponsor you get a free guest, > but > > if you sponsor and exhibit you get the free guest plus a discount off the > > exhibit fee based on the sponsor level you choose. > > > > I'm having a hard time making it dynamic, I just can't see it happening, > > tunnel vision or something.. Any ideas or thoughts would be appreciated. > > The system is set up like > > attendee (general information) > > attendee_conference (conference specific information per attendee) > > attendee_conference_sponsor (if they choose to be a sponsor, this has > their > > sponsor information) > > ... > > > > The back end has: > > conference (main conference table) > > conference_sponsorlevel (has the various levels per conference) > > conference_sponsorperks (one to many, sponsorlevel_id to perk) > > > > The perks are not standardized, but one almost always perk is a number of > > free guests.. > > so I have a column in the conference_sponsorperks table > "compedRegistrants" > > which if the perk involves an amount of free registrants then they > populate > > that and it works it into the total. > > > > But how would I add "if and only if they're an exhibitor then take, say > > 300, off the total"? > > > > Thanks! > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
