Differential D399 Diff 1002 core/units/system_event_subscriptions/system_event_subscriptions_config.php

Changeset View

Standalone View

core/units/system_event_subscriptions/system_event_subscriptions_config.php

	Show First 20 Lines • Show All 78 Lines • ▼ Show 20 Line(s)
	LEFT JOIN ' . TABLE_PREFIX . 'Users u ON %1$s.UserId = u.PortalUserId			LEFT JOIN ' . TABLE_PREFIX . 'Users u ON %1$s.UserId = u.PortalUserId
	LEFT JOIN ' . TABLE_PREFIX . 'Categories c ON %1$s.CategoryId = c.CategoryId',			LEFT JOIN ' . TABLE_PREFIX . 'Categories c ON %1$s.CategoryId = c.CategoryId',
	),			),

	'CalculatedFields' => Array (			'CalculatedFields' => Array (
	'' => Array (			'' => Array (
	'BindToSystemEvent' => 'et.BindToSystemEvent',			'BindToSystemEvent' => 'et.BindToSystemEvent',
	'EmailTemplateName' => 'et.TemplateName',			'EmailTemplateName' => 'et.TemplateName',
	'Username' => 'CASE %1$s.UserId WHEN ' . USER_ROOT . ' THEN "root" WHEN ' . USER_GUEST . ' THEN "Guest" ELSE IF(CONCAT(u.FirstName, u.LastName) <> "", CONCAT(u.FirstName, " ", u.LastName), IF(%1$s.UserId IS NULL, "Guest", IF(u.Username = "", u.Email, u.Username))) END',			'Username' => 'CASE %1$s.UserId WHEN ' . USER_ROOT . ' THEN "root" WHEN ' . USER_SYSTEM . ' THEN "system" WHEN ' . USER_GUEST . ' THEN "Guest" ELSE IF(CONCAT(u.FirstName, u.LastName) <> "", CONCAT(u.FirstName, " ", u.LastName), IF(%1$s.UserId IS NULL, "Guest", IF(u.Username = "", u.Email, u.Username))) END',
	'CategoryName' => 'c.l%2$s_Name',			'CategoryName' => 'c.l%2$s_Name',
	'ItemName' => '%1$s.ItemId',			'ItemName' => '%1$s.ItemId',
	'ParentItemName' => '%1$s.ParentItemId',			'ParentItemName' => '%1$s.ParentItemId',
	),			),
	),			),

	'ListSortings' => Array (			'ListSortings' => Array (
	'' => Array (			'' => Array (
	'Sorting' => Array ('SubscriptionId' => 'desc'),			'Sorting' => Array ('SubscriptionId' => 'desc'),
	)			)
	),			),

	'Fields' => Array (			'Fields' => Array (
	'SubscriptionId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),			'SubscriptionId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
	'EmailTemplateId' => Array (			'EmailTemplateId' => Array (
	'type' => 'int',			'type' => 'int',
	'formatter' => 'kOptionsFormatter', 'options_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'EmailTemplates WHERE BindToSystemEvent <> "" ORDER BY TemplateName ASC', 'option_key_field' => 'TemplateId', 'option_title_field' => 'BindToSystemEvent',			'formatter' => 'kOptionsFormatter', 'options_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'EmailTemplates WHERE BindToSystemEvent <> "" ORDER BY TemplateName ASC', 'option_key_field' => 'TemplateId', 'option_title_field' => 'BindToSystemEvent',
	'required' => 1, 'default' => NULL			'required' => 1, 'default' => NULL
	),			),
	'SubscriberEmail' => Array ('type' => 'string', 'max_len' => 255, 'not_null' => 1, 'default' => ''),			'SubscriberEmail' => Array ('type' => 'string', 'max_len' => 255, 'not_null' => 1, 'default' => ''),
				Lint: Generic.PHP.LowerCaseKeyword.Found Edit Delete PHP keywords must be lowercase; expected "array" but found "Array" Lint: Generic.PHP.LowerCaseKeyword.Found: PHP keywords must be lowercase; expected "array" but found "Array"
				Lint: CodingStandard.Arrays.Array.SpaceAfterKeyword Edit Delete There must be no space between the Array keyword and the opening parenthesis Lint: CodingStandard.Arrays.Array.SpaceAfterKeyword: There must be no space between the Array keyword and the opening parenthesis
	'UserId' => Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'Users WHERE %s', 'left_key_field' => 'PortalUserId', 'left_title_field' => USER_TITLE_FIELD, 'default' => NULL),			'UserId' => Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array (USER_ROOT => 'root', USER_SYSTEM => 'system', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'Users WHERE %s', 'left_key_field' => 'PortalUserId', 'left_title_field' => USER_TITLE_FIELD, 'default' => NULL),
				Lint: Generic.PHP.LowerCaseConstant.Found Edit Delete TRUE, FALSE and NULL must be lowercase; expected "null" but found "NULL" Lint: Generic.PHP.LowerCaseConstant.Found: TRUE, FALSE and NULL must be lowercase; expected "null" but found "NULL"
				Lint: CodingStandard.Arrays.Array.SpaceAfterKeyword Edit Delete There must be no space between the Array keyword and the opening parenthesis Lint: CodingStandard.Arrays.Array.SpaceAfterKeyword: There must be no space between the Array keyword and the opening parenthesis
				Lint: Generic.PHP.LowerCaseKeyword.Found Edit Delete PHP keywords must be lowercase; expected "array" but found "Array" Lint: Generic.PHP.LowerCaseKeyword.Found: PHP keywords must be lowercase; expected "array" but found "Array"
				Lint: CodingStandard.Arrays.Array.SpaceAfterKeyword Edit Delete There must be no space between the Array keyword and the opening parenthesis Lint: CodingStandard.Arrays.Array.SpaceAfterKeyword: There must be no space between the Array keyword and the opening parenthesis
				Lint: Generic.PHP.LowerCaseKeyword.Found Edit Delete PHP keywords must be lowercase; expected "array" but found "Array" Lint: Generic.PHP.LowerCaseKeyword.Found: PHP keywords must be lowercase; expected "array" but found "Array"
				Lint: CodingStandard.Arrays.Array.SpaceAfterKeyword Edit Delete There must be no space between the Array keyword and the opening parenthesis Lint: CodingStandard.Arrays.Array.SpaceAfterKeyword: There must be no space between the Array keyword and the opening parenthesis
				Lint: Generic.PHP.LowerCaseKeyword.Found Edit Delete PHP keywords must be lowercase; expected "array" but found "Array" Lint: Generic.PHP.LowerCaseKeyword.Found: PHP keywords must be lowercase; expected "array" but found "Array"
	'CategoryId' => Array ('type' => 'int', 'default' => NULL),			'CategoryId' => Array ('type' => 'int', 'default' => NULL),
				Lint: CodingStandard.Arrays.Array.SpaceAfterKeyword Edit Delete There must be no space between the Array keyword and the opening parenthesis Lint: CodingStandard.Arrays.Array.SpaceAfterKeyword: There must be no space between the Array keyword and the opening parenthesis
				Lint: Generic.PHP.LowerCaseKeyword.Found Edit Delete PHP keywords must be lowercase; expected "array" but found "Array" Lint: Generic.PHP.LowerCaseKeyword.Found: PHP keywords must be lowercase; expected "array" but found "Array"
				Lint: Generic.PHP.LowerCaseConstant.Found Edit Delete TRUE, FALSE and NULL must be lowercase; expected "null" but found "NULL" Lint: Generic.PHP.LowerCaseConstant.Found: TRUE, FALSE and NULL must be lowercase; expected "null" but found "NULL"
	'IncludeSublevels' => Array (			'IncludeSublevels' => Array (
	'type' => 'int',			'type' => 'int',
	'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1,			'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1,
	'not_null' => 1, 'default' => 1			'not_null' => 1, 'default' => 1
	),			),
	'ItemId' => Array ('type' => 'int', 'default' => NULL),			'ItemId' => Array ('type' => 'int', 'default' => NULL),
	'ParentItemId' => Array ('type' => 'int', 'default' => NULL),			'ParentItemId' => Array ('type' => 'int', 'default' => NULL),
	'SubscribedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'required' => 1, 'default' => '#NOW#')			'SubscribedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'required' => 1, 'default' => '#NOW#')
	Show All 29 Lines