can you set up "exhibitor" in the sponsor table and link it to it's
acompanying perks?

think of the sponsor table as a level table instead of a sponsor table
On 5/15/2012 10:28 AM, Greg Morphis wrote:
> 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<webmaster@sstw...>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:351164
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm