Proposed Universal Substitution System

General Idea

CM has a bunch of variable lookup systems, it would be helpful to combine these into one system.

This article is still a stub.

registrant

Substitution	Description	Source	Tag Replacement	badgecode	Notes
uid	outputs the registrant uid.	Tag Replacements	reg_uid	$uid
legal_first	outputs registrant first name.	Tag Replacements	reg_rl_first	$registrant_rl_first
legal_last	outputs registrant last name.	Tag Replacements	reg_rl_last	$registrant_rl_last
legal_name	outputs registrant "first" + "last" name.	Tag Replacements	reg_full_name
common_name	outputs registrant badge name if not empty - otherwise thier "first" + "last" name.	Tag Replacements	reg_badge_name	$registrant_fan_name
badge_name	outputs registrant badge name.	Tag Replacements	reg_birthday	$registrant_birthday
birthday	outputs registrant birthdate.	Tag Replacements	reg_first_created
first_created	outputs registrant account creation date from database.	Tag Replacements	reg_common_name	$registrant_common_name
address_ship_to_name	outputs registrant ship to name.	Tag Replacements	reg_address_ship_to_name
address_line_1	outputs registrant address line 1.	Tag Replacements	reg_address_line_1
address_line_2	outputs registrant address line 2.	Tag Replacements	reg_address_line_2
address_city	outputs registrant address city.	Tag Replacements	reg_address_city
address_state	outputs registrant address state.	Tag Replacements	reg_address_state
address_country	outputs registrant address country.	Tag Replacements	reg_address_country
address_postcode	outputs registrant address zip/postcode.	Tag Replacements	reg_address_zip
address_full	outputs registrant address with all fields combined.	Tag Replacements	reg_address_full
phone_type	outputs registrant phone type.	Tag Replacements	reg_phone_type
phone_number	outputs registrant phone number.	Tag Replacements	reg_phone_number
email	outputs registrant email.	Tag Replacements	reg_email
payment_hold_created	outputs date payment hold was created for current registrant and event.	Tag Replacements	reg_payment_hold_created
payment_hold_expiry	outputs date payment hold will expire for current registrant and event. ex: 2020-01-22 18:30:15	Tag Replacements	reg_payment_hold_expiry
payment_hold_extendable_to	outputs latest date payment hold can be extended up to for current registrant and event.	Tag Replacements	reg_payment_hold_extendable_to
payment_hold_payment_type	outputs most recent payment type selected for current registrant and event	Tag Replacements	reg_payment_hold_payment_type
payment_hold_expiry_long	outputs long date payment hold will expire for current registrant and event. ex: Wednesday, January 22, 2020, @ 6:30 PM	Tag Replacements	reg_payment_hold_expiry_long
bool_marked_deceased	Returns True if the user is marked deceased	new
bool_ConsoleUser	Returns True if the user has an active console login	new
consoleUserExpiryDate	Displays expiration date for console login	new
CompMoneyRemaining	Displays the remaining comp money	new

events

Substitution	Description	Source	Tag Replacement	badgecode	Notes
event_id	outputs the Event Id. Example: "DEMO_1"	Tag Replacements	event_id	$event_id
event_title	outputs the Event Title. Example: "Demo Event"	Tag Replacements	event_title	$events_event_title
event_start_date	outputs event start date from event settings.	Tag Replacements	event_start_date
event_end_date	outputs event end date from event settings.	Tag Replacements	event_end_date
event_age_of_maturity	outputs event age of maturity from event settings.	Tag Replacements	event_age_of_maturity
event_pre_reg_end_date	outputs event pre-reg end date from event settings.	Tag Replacements	event_pre_reg_end_date
event_address_1	outputs address line 1 from event settings.	Tag Replacements	event_address_1
event_address_2	outputs address line 2 from event settings.	Tag Replacements	event_address_2
event_address_3	outputs address line 3 from event settings.	Tag Replacements	event_address_3
event_address_4	outputs address line 4 from event settings.	Tag Replacements	event_address_4
event_address_full	outputs event address with all fields combined.	new
event_defaultFromEmail	outputs default from email address in event settings.	Tag Replacements	event_defaultFromEmail
event_defaultReplyTo	outputs default reply to: in event settings.	Tag Replacements	event_defaultReplyTo
event_chequeToName	outputs cheque to name in event settings.	Tag Replacements	event_chequeToName

attendee

Substitution	Description	Source	Tag Replacement	badgecode	Notes
bool_underage	true if below age of maturity set for event from birthdate and stored event age of maturity	badgecode		$underage
num	registration sequence number for that particular event	Tag Replacements	reg_reg_num	$events_attended_reg_num
badge_display_code	outputs registrant badge layout code. Example: FNOT	Tag Replacements	reg_badge_display_code
membership_name	outputs membership name. (setting: Group Name)	Tag Replacements	reg_membership_name	$event_membership_types_name
membership_long_name	outputs membership long name. (setting: Membership Type as printed on badge)	Tag Replacements	reg_membership_long_name	$event_membership_types_long_name
membership_full_desc	outputs membership description. (setting: Sales pitch description:)	Tag Replacements	reg_membership_full_desc
membership_rules	outputs membership rules. (setting: Rules For this membership)	Tag Replacements	reg_membership_rules
membership_type	outputs registrant membership code for current event. Example SPON_0	Tag Replacements	reg_membership_type
membership_last_updated	outputs membership last modified date for current event.	Tag Replacements	reg_membership_last_updated
membership_price	outputs membership price.	Tag Replacements	reg_membership_price
membership_avail_from	outputs membership available from date.	Tag Replacements	reg_membership_avail_from
membership_avail_to	outputs membership available to date.	Tag Replacements	reg_membership_avail_to
staff	if attendee_membership_name contains the word 'staff' this will equal true, this is not case sensitive.	badgecode		$staff	if retained, maybe this should also check membership_long_name

panelist

Substitution	Description	Source	Tag Replacement	badgecode	Notes
bool_has_confirmed_activity	useful for a true false for flagging panelist badges.	new			This is highly speculative, however I'm presuming this would work something like AS/DD in that the application would be tied to the UID of the person who applied, so we could pick it up that way, it could go into the attendee group
bool_activity_host	useful for a true false for flagging panelist badges.	new
bool_activity_assistant	useful for a true false for flagging panelist badges.	new
bool_is_panelist	true if uid matches to either activity host or assistant - useful for a true false for flagging panelist badges.	new
activity_schedule	displays a formatted list of activities a panelist is assigned/confirmed to	new

dealers

Substitution	Description	Source	Tag Replacement	badgecode	Notes
<num>_application_state	useful for doing a strcmp in badgecode to automatically tag dealers on approved dealers/artists.	new			for correctness I want to call this group artshow, but these function will only really be used by dealers den
bool_<num>_confirmed	useful for a true false for flagging dealer badges.	new			these three are listed as options
bool_<num>_assistant	useful for a true false for flagging dealer assistant badges.	new			these three are listed as options

udf

Substitution	Description	Source	Tag Replacement	badgecode	Notes
<num>_title	Will display the title of the user defined field. (If the customer has it applied to them) Ex: $UDF_12_title.	Badgecode		$udf_title
<num>_value	Will display the value of the user defined field. (If the customer has it applied to them) Ex: $UDF_12_value.	Badgecode		$udf_value
bool_<num>	Returns True is the UDF has been answered	new
<num>_type	returns the udf type	new
<num>_udf_response_list	Will display the UDF questions if relevent	new

product

Substitution	Description	Source	Tag Replacement	badgecode	Notes
bool_purchased_<num>	returns true if the customer has purchased the product	new
bool_incart_	returns true if the customer has the product in their cart	new
<num>_info	displays product description	new
<num>_price	displays product price	new
<num>_items_sold	displays how many have been sold	new
<num>_items_remaining	displays how many are remaining (cart+purchased-inventory)	new

system

Substitution	Description	Source	Tag Replacement	badgecode	Notes
cm_version	displays CM version string	new
db_version	displays db db version int	new
copyright	displays cm copyright statement	new
license_expiration	displays license expiration date	new
license_valid_events	displays list of valid events	new
bool_dev_license	returns true if dev license	new