I think we've established that they can be both a sponsor and an exhibitor,
You have sponsor levels (bronze, silver and gold) exhibitor just becomes
another level.


On 5/15/2012 10:36 AM, Greg Morphis wrote:
> Well the registrant is either a Sponsor or Exhibitor type (right now), it's
> just that Sponsors could also Exhibit. Almost as if I need a flag or
> something.. but I still need to be able to pull additional perks. I'm not
> sure what you're asking though.
>
>
> On Tue, May 15, 2012 at 9:33 AM, Scott Stewart<webmaster@sstw...>wrote:
>
>> 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:351167
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm