• Модуль: support
  • Путь к файлу: ~/bitrix/modules/support/classes/general/support.php
  • Класс: CAllTicket
  • Вызов: CAllTicket::GetCSupportTableFields
static function GetCSupportTableFields($name, $arrOrTable = CSupportTableFields::C_Array)
{
	$n = CSupportTableFields::VT_NUMBER;
	$s = CSupportTableFields::VT_STRING;
	$yn = CSupportTableFields::VT_Y_N;
	$ynn = CSupportTableFields::VT_Y_N_NULL;
	$d = CSupportTableFields::VT_DATE;
	$dt = CSupportTableFields::VT_DATE_TIME;
	$tables = array(
		"b_ticket" => array(
			"ID" =>								array("TYPE" => $n,	"DEF_VAL" => 0,		"AUTO_CALCULATED" => true),
			"SITE_ID" =>						array("TYPE" => $s,	"DEF_VAL" => "", 	"MAX_STR_LEN" => 2),
			"DATE_CREATE" =>					array("TYPE" => $dt,	"DEF_VAL" => null	),
			"DAY_CREATE" =>						array("TYPE" => $d,	"DEF_VAL" => null	),
			"TIMESTAMP_X" =>					array("TYPE" => $dt,	"DEF_VAL" => null	),
			"DATE_CLOSE" =>						array("TYPE" => $dt,	"DEF_VAL" => null	),
			"AUTO_CLOSED" =>					array("TYPE" => $yn,	"DEF_VAL" => null	),
			"AUTO_CLOSE_DAYS" =>				array("TYPE" => $n,	"DEF_VAL" => null	),
			"SLA_ID" =>							array("TYPE" => $n,	"DEF_VAL" => 1		),
			"NOTIFY_AGENT_ID" =>				array("TYPE" => $n,	"DEF_VAL" => null	),
			"EXPIRE_AGENT_ID" =>				array("TYPE" => $n,	"DEF_VAL" => null	),
			"OVERDUE_MESSAGES" =>				array("TYPE" => $n,	"DEF_VAL" => 0		),
			"IS_NOTIFIED" =>					array("TYPE" => $yn,	"DEF_VAL" => "N"	),
			"IS_OVERDUE" =>						array("TYPE" => $yn,	"DEF_VAL" => "N"	),
			"CATEGORY_ID" =>					array("TYPE" => $n,	"DEF_VAL" => null	),
			"CRITICALITY_ID" =>					array("TYPE" => $n,	"DEF_VAL" => null	),
			"STATUS_ID" =>						array("TYPE" => $n,	"DEF_VAL" => null	),
			"MARK_ID" =>						array("TYPE" => $n,	"DEF_VAL" => null	),
			"SOURCE_ID" =>						array("TYPE" => $n,	"DEF_VAL" => null	),
			"DIFFICULTY_ID" =>					array("TYPE" => $n,	"DEF_VAL" => null	),
			"TITLE" =>							array("TYPE" => $s,	"DEF_VAL" => "", 	"MAX_STR_LEN" => 255),
			"MESSAGES" =>						array("TYPE" => $n,	"DEF_VAL" => 0		),
			"IS_SPAM" =>						array("TYPE" => $ynn,	"DEF_VAL" => null	),
			"OWNER_USER_ID" =>					array("TYPE" => $n,	"DEF_VAL" => null	),
			"OWNER_GUEST_ID" =>					array("TYPE" => $n,	"DEF_VAL" => null	),
			"OWNER_SID" =>						array("TYPE" => $s,	"DEF_VAL" => null, 	"MAX_STR_LEN" => 255),
			"CREATED_USER_ID" =>				array("TYPE" => $n,	"DEF_VAL" => null	),
			"CREATED_GUEST_ID" =>				array("TYPE" => $n,	"DEF_VAL" => null	),
			"CREATED_MODULE_NAME" =>			array("TYPE" => $s,	"DEF_VAL" => "support", 	"MAX_STR_LEN" => 255),
			"RESPONSIBLE_USER_ID" =>			array("TYPE" => $n,	"DEF_VAL" => null	),
			"MODIFIED_USER_ID" =>				array("TYPE" => $n,	"DEF_VAL" => null	),
			"MODIFIED_GUEST_ID" =>				array("TYPE" => $n,	"DEF_VAL" => null	),
			"MODIFIED_MODULE_NAME" =>			array("TYPE" => $s,	"DEF_VAL" => null, 	"MAX_STR_LEN" => 255),
			"LAST_MESSAGE_USER_ID" =>			array("TYPE" => $n,	"DEF_VAL" => null	),
			"LAST_MESSAGE_GUEST_ID" =>			array("TYPE" => $n,	"DEF_VAL" => null	),
			"LAST_MESSAGE_SID" =>				array("TYPE" => $s,	"DEF_VAL" => null, 	"MAX_STR_LEN" => 255),
			"LAST_MESSAGE_BY_SUPPORT_TEAM" =>	array("TYPE" => $yn,	"DEF_VAL" => "N"	),
			"LAST_MESSAGE_DATE" =>				array("TYPE" => $dt,	"DEF_VAL" => null	),
			"SUPPORT_COMMENTS" =>				array("TYPE" => $s,	"DEF_VAL" => null, 	"MAX_STR_LEN" => 255),
			"PROBLEM_TIME" =>					array("TYPE" => $n,	"DEF_VAL" => null	),
			"HOLD_ON" =>						array("TYPE" => $yn,	"DEF_VAL" => "N"	),
			"REOPEN" =>							array("TYPE" => $yn,	"DEF_VAL" => "N"	),
			"COUPON" =>							array("TYPE" => $s,	"DEF_VAL" => null, 	"MAX_STR_LEN" => 255),
			"DEADLINE_SOURCE_DATE" =>			array("TYPE" => $dt,	"DEF_VAL" => null	),
		),
		
		"EventFields" => array(
			"ID" =>								array("TYPE" => $n,	"DEF_VAL" => null	),
			"LANGUAGE" =>						array("TYPE" => $s,	"DEF_VAL" => null	),
			"LANGUAGE_ID" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"WHAT_CHANGE" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"DATE_CREATE" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"TIMESTAMP" =>						array("TYPE" => $s,	"DEF_VAL" => null	),
			"DATE_CLOSE" =>						array("TYPE" => $s,	"DEF_VAL" => null	),
			"TITLE" =>							array("TYPE" => $s,	"DEF_VAL" => null	),
			"STATUS" =>							array("TYPE" => $s,	"DEF_VAL" => null	),
			"DIFFICULTY" =>						array("TYPE" => $s,	"DEF_VAL" => null	),
			"CATEGORY" =>						array("TYPE" => $s,	"DEF_VAL" => null	),
			"CRITICALITY" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"RATE" =>							array("TYPE" => $s,	"DEF_VAL" => null	),
			"SLA" =>							array("TYPE" => $s,	"DEF_VAL" => null	),
			"SOURCE" =>							array("TYPE" => $s,	"DEF_VAL" => null	),
			"MESSAGES_AMOUNT" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"SPAM_MARK" =>						array("TYPE" => $s,	"DEF_VAL" => null	),
			"ADMIN_EDIT_URL" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"PUBLIC_EDIT_URL" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"OWNER_EMAIL" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"OWNER_USER_ID" =>					array("TYPE" => $n,	"DEF_VAL" => null	),
			"OWNER_USER_NAME" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"OWNER_USER_LOGIN" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"OWNER_USER_EMAIL" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"OWNER_TEXT" =>						array("TYPE" => $s,	"DEF_VAL" => null	),
			"OWNER_SID" =>						array("TYPE" => $s,	"DEF_VAL" => null	),
			"SUPPORT_EMAIL" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"RESPONSIBLE_USER_ID" =>			array("TYPE" => $n,	"DEF_VAL" => null	),
			"RESPONSIBLE_USER_NAME" =>			array("TYPE" => $s,	"DEF_VAL" => null	),
			"RESPONSIBLE_USER_LOGIN" =>			array("TYPE" => $s,	"DEF_VAL" => null	),
			"RESPONSIBLE_USER_EMAIL" =>			array("TYPE" => $s,	"DEF_VAL" => null	),
			"RESPONSIBLE_TEXT" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"SUPPORT_ADMIN_EMAIL" =>			array("TYPE" => $s,	"DEF_VAL" => null	),
			"CREATED_USER_ID" =>				array("TYPE" => $n,	"DEF_VAL" => null	),
			"CREATED_USER_LOGIN" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"CREATED_USER_EMAIL" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"CREATED_USER_NAME" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"CREATED_MODULE_NAME" =>			array("TYPE" => $s,	"DEF_VAL" => null	),
			"CREATED_TEXT" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"MODIFIED_USER_ID" =>				array("TYPE" => $n,	"DEF_VAL" => null	),
			"MODIFIED_USER_LOGIN" =>			array("TYPE" => $s,	"DEF_VAL" => null	),
			"MODIFIED_USER_EMAIL" =>			array("TYPE" => $s,	"DEF_VAL" => null	),
			"MODIFIED_USER_NAME" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"MODIFIED_MODULE_NAME" =>			array("TYPE" => $s,	"DEF_VAL" => null	),
			"MODIFIED_TEXT" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"MESSAGE_AUTHOR_USER_ID" =>			array("TYPE" => $n,	"DEF_VAL" => null	),
			"MESSAGE_AUTHOR_USER_NAME" =>		array("TYPE" => $s,	"DEF_VAL" => null	),
			"MESSAGE_AUTHOR_USER_LOGIN" =>		array("TYPE" => $s,	"DEF_VAL" => null	),
			"MESSAGE_AUTHOR_USER_EMAIL" =>		array("TYPE" => $s,	"DEF_VAL" => null	),
			"MESSAGE_AUTHOR_TEXT" =>			array("TYPE" => $s,	"DEF_VAL" => null	),
			"MESSAGE_AUTHOR_SID" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
			"MESSAGE_SOURCE" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"MESSAGE_HEADER" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"MESSAGE_BODY" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"MESSAGE_FOOTER" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"FILES" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"FILES_LINKS" =>					array("TYPE" => $s,	"DEF_VAL" => null	),
			"IMAGE_LINK" =>						array("TYPE" => $s,	"DEF_VAL" => null	),
			"SUPPORT_COMMENTS" =>				array("TYPE" => $s,	"DEF_VAL" => null	),
		),
		
	);
	
	if(!array_key_exists($name, $tables)) return null;
	
	return new CSupportTableFields($tables[$name], $arrOrTable);
}