Proposed Universal Substitution System - Revision history

Aloha: Aloha moved page Universal Substitution System to Proposed Universal Substitution System

2021-07-22T03:45:54Z

Aloha moved page Universal Substitution System to Proposed Universal Substitution System

← Older revision	Revision as of 22:45, 21 July 2021
(No difference)

Aloha at 03:42, 22 July 2021

2021-07-22T03:42:04Z

← Older revision		Revision as of 22:42, 21 July 2021
Line 1:		Line 1:
			=== 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.

	{\| class="wikitable"		{\| class="wikitable"
Line 39:		Line 41:
	\| address_country\|\|outputs registrant address country. \|\|Tag Replacements\|\|reg_address_country\|\|\|\|		\| address_country\|\|outputs registrant address country. \|\|Tag Replacements\|\|reg_address_country\|\|\|\|
	\|-		\|-
	\| ~~address_zip~~\|\|outputs registrant address zip. \|\|Tag Replacements\|\|reg_address_zip\|\|\|\|		\| 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\|\|\|\|		\| address_full\|\|outputs registrant address with all fields combined. \|\|Tag Replacements\|\|reg_address_full\|\|\|\|

Aloha at 03:31, 22 July 2021

2021-07-22T03:31:14Z

← Older revision		Revision as of 22:31, 21 July 2021
Line 222:		Line 222:

	{\| class="wikitable"		{\| class="wikitable"
	\|+ ~~product~~		\|+ system
	\| align="center" style="background:#f0f0f0;"\|'''Substitution'''		\| align="center" style="background:#f0f0f0;"\|'''Substitution'''
	\| align="center" style="background:#f0f0f0;"\|'''Description'''		\| align="center" style="background:#f0f0f0;"\|'''Description'''
Line 233:		Line 233:
	\|-		\|-
	\| db_version\|\|displays db db version int\|\|new\|\|\|\|\|\|		\| db_version\|\|displays db db version int\|\|new\|\|\|\|\|\|
			\|-
			\| copyright\|\|displays cm copyright statement\|\|new\|\|\|\|\|\|
	\|-		\|-
	\| license_expiration\|\|displays license expiration date\|\|new\|\|\|\|\|\|		\| license_expiration\|\|displays license expiration date\|\|new\|\|\|\|\|\|

Aloha at 03:29, 22 July 2021

2021-07-22T03:29:57Z

← Older revision		Revision as of 22:29, 21 July 2021
Line 158:		Line 158:
	\| bool_activity_assistant\|\|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_true~~ if uid matches to either activity host or 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\|\|\|\|\|\|\|		\| activity_schedule\|\|displays a formatted list of activities a panelist is assigned/confirmed to\|\|new\|\|\|\|\|\|\|

Aloha at 03:27, 22 July 2021

2021-07-22T03:27:26Z

← Older revision		Revision as of 22:27, 21 July 2021
Line 116:		Line 116:
	\| align="center" style="background:#f0f0f0;"\|'''Notes'''		\| align="center" style="background:#f0f0f0;"\|'''Notes'''
	\|-		\|-
	\| bool_underage\|\|true if below age of maturity set for event from birthdate and stored event age of maturity\|\|badgecode\|\|\|\|$underage\|\|\|\|		\| 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\|\|\|\|		\| 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\|\|\|\|		\| 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_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_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_full_desc\|\|outputs membership description. (setting: Sales pitch description:) \|\|Tag Replacements\|\|reg_membership_full_desc\|\|\|\|

Aloha at 03:26, 22 July 2021

2021-07-22T03:26:35Z

← Older revision		Revision as of 22:26, 21 July 2021
Line 78:		Line 78:
	\| align="center" style="background:#f0f0f0;"\|'''Notes'''		\| align="center" style="background:#f0f0f0;"\|'''Notes'''
	\|-		\|-
	\| event_id\|\|outputs the Event Id. Example: "DEMO_1"\|\|Tag Replacements\|\|event_id\|\|$event_id\|\|\|\|		\| 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_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_start_date\|\|outputs event start date from event settings. \|\|Tag Replacements\|\|event_start_date\|\|\|\|

Aloha at 03:26, 22 July 2021

2021-07-22T03:26:09Z

← Older revision		Revision as of 22:26, 21 July 2021
Line 63:		Line 63:
	\| bool_ConsoleUser\|\|Returns True if the user has an active console login\|\|new\|\|\|\|\|\|		\| bool_ConsoleUser\|\|Returns True if the user has an active console login\|\|new\|\|\|\|\|\|
	\|-		\|-
	\| consoleUserExpiryDate\|\|Displays expiration date for console login\|\|new\|\|\|\|\|		\| consoleUserExpiryDate\|\|Displays expiration date for console login\|\|new\|\|\|\|\|\|
	\|-		\|-
	\| CompMoneyRemaining\|\|Displays the remaining comp money\|\|new\|\|\|\|\|		\| CompMoneyRemaining\|\|Displays the remaining comp money\|\|new\|\|\|\|\|\|
	\|}		\|}

Aloha at 03:25, 22 July 2021

2021-07-22T03:25:54Z

← Older revision		Revision as of 22:25, 21 July 2021
Line 59:		Line 59:
	\| 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\|\|\|\|		\| 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_marked_deceased\|\|Returns True if the user is marked deceased\|\|new\|\|\|\|\|\|
	\|-		\|-
	\| bool_ConsoleUser\|\|Returns True if the user has an active console login\|\|new\|\|\|\|\|		\| bool_ConsoleUser\|\|Returns True if the user has an active console login\|\|new\|\|\|\|\|\|
	\|-		\|-
	\| consoleUserExpiryDate\|\|Displays expiration date for console login\|\|new\|\|\|\|\|		\| consoleUserExpiryDate\|\|Displays expiration date for console login\|\|new\|\|\|\|\|

Aloha at 03:25, 22 July 2021

2021-07-22T03:25:18Z

← Older revision		Revision as of 22:25, 21 July 2021
Line 154:		Line 154:
	\| 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_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_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_activity_assistant\|\|useful for a true false for flagging panelist badges.\|\|new\|\|\|\|\|\|\|
	\|-		\|-
	\| bool_is_true if uid matches to either activity host or assistant - useful for a true false for flagging panelist badges.\|\|new\|\|\|\|\|\|		\| bool_is_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\|\|\|\|\|\|		\| activity_schedule\|\|displays a formatted list of activities a panelist is assigned/confirmed to\|\|new\|\|\|\|\|\|\|
	\|}		\|}

Aloha at 03:24, 22 July 2021

2021-07-22T03:24:51Z

← Older revision		Revision as of 22:24, 21 July 2021
Line 29:		Line 29:
	\| address_ship_to_name\|\|outputs registrant ship to name. \|\|Tag Replacements\|\|reg_address_ship_to_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_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_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_city\|\|outputs registrant address city. \|\|Tag Replacements\|\|reg_address_city\|\|\|\|
	\|-		\|-
	\| address_state\|\|outputs registrant address state. \|\|Tag Replacements\|\|reg_address_state\|\|\|		\| address_state\|\|outputs registrant address state. \|\|Tag Replacements\|\|reg_address_state\|\|\|\|
	\|-		\|-
	\| address_country\|\|outputs registrant address country. \|\|Tag Replacements\|\|reg_address_country\|\|\|		\| address_country\|\|outputs registrant address country. \|\|Tag Replacements\|\|reg_address_country\|\|\|\|
	\|-		\|-
	\| address_zip\|\|outputs registrant address zip. \|\|Tag Replacements\|\|reg_address_zip\|\|\|		\| address_zip\|\|outputs registrant address zip. \|\|Tag Replacements\|\|reg_address_zip\|\|\|\|
	\|-		\|-
	\| address_full\|\|outputs registrant address with all fields combined. \|\|Tag Replacements\|\|reg_address_full\|\|\|		\| 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_type\|\|outputs registrant phone type. \|\|Tag Replacements\|\|reg_phone_type\|\|\|\|
	\|-		\|-
	\| phone_number\|\|outputs registrant phone number. \|\|Tag Replacements\|\|reg_phone_number\|\|\|		\| phone_number\|\|outputs registrant phone number. \|\|Tag Replacements\|\|reg_phone_number\|\|\|\|
	\|-		\|-
	\| email\|\|outputs registrant email. \|\|Tag Replacements\|\|reg_email\|\|\|		\| 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_created\|\|outputs date payment hold was created for current registrant and event. \|\|Tag Replacements\|\|reg_payment_hold_created\|\|\|\|
Line 59:		Line 59:
	\| 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\|\|\|\|		\| 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_marked_deceased\|\|Returns True if the user is marked deceased\|\|new\|\|\|\|\|
	\|-		\|-
	\| bool_ConsoleUser\|\|Returns True if the user has an active console login\|\|new\|\|\|\|		\| bool_ConsoleUser\|\|Returns True if the user has an active console login\|\|new\|\|\|\|\|
	\|-		\|-
	\| consoleUserExpiryDate\|\|Displays expiration date for console login\|\|new\|\|\|\|		\| consoleUserExpiryDate\|\|Displays expiration date for console login\|\|new\|\|\|\|\|
	\|-		\|-
	\| CompMoneyRemaining\|\|Displays the remaining comp money\|\|new\|\|\|\|		\| CompMoneyRemaining\|\|Displays the remaining comp money\|\|new\|\|\|\|\|
	\|}		\|}