CCrmEvent::GetFields

static function GetFields()
{
	$relationJoin = 'INNER JOIN b_crm_event CE ON CE.ID = CER.EVENT_ID';
	$createdByJoin = 'LEFT JOIN b_user U ON CE.CREATED_BY_ID = U.ID';

	return [
		'ID' => ['FIELD' => 'CER.ID', 'TYPE' => 'int'],

		'ENTITY_TYPE' => ['FIELD' => 'CER.ENTITY_TYPE', 'TYPE' => 'string'],
		'ENTITY_ID' => ['FIELD' => 'CER.ENTITY_ID', 'TYPE' => 'int'],
		'ENTITY_FIELD' => ['FIELD' => 'CER.ENTITY_FIELD', 'TYPE' => 'string'],

		'EVENT_REL_ID' => ['FIELD' => 'CER.EVENT_ID', 'TYPE' => 'string'],
		'EVENT_ID' => ['FIELD' => 'CE.EVENT_ID', 'TYPE' => 'string', 'FROM' => $relationJoin],
		'EVENT_TYPE' => ['FIELD' => 'CE.EVENT_TYPE', 'TYPE' => 'string', 'FROM' => $relationJoin],
		'EVENT_NAME' => ['FIELD' => 'CE.EVENT_NAME', 'TYPE' => 'string', 'FROM' => $relationJoin],
		'EVENT_TEXT_1' => ['FIELD' => 'CE.EVENT_TEXT_1', 'TYPE' => 'string', 'FROM' => $relationJoin],
		'EVENT_TEXT_2' => ['FIELD' => 'CE.EVENT_TEXT_2', 'TYPE' => 'string', 'FROM' => $relationJoin],
		'FILES' => ['FIELD' => 'CE.FILES', 'TYPE' => 'string', 'FROM' => $relationJoin],

		'CREATED_BY_ID' => ['FIELD' => 'CE.CREATED_BY_ID', 'TYPE' => 'int', 'FROM' => $relationJoin],
		'CREATED_BY_LOGIN' => ['FIELD' => 'U.LOGIN', 'TYPE' => 'string', 'FROM' => $createdByJoin],
		'CREATED_BY_NAME' => ['FIELD' => 'U.NAME', 'TYPE' => 'string', 'FROM' => $createdByJoin],
		'CREATED_BY_LAST_NAME' => ['FIELD' => 'U.LAST_NAME', 'TYPE' => 'string', 'FROM' => $createdByJoin],
		'CREATED_BY_SECOND_NAME' => ['FIELD' => 'U.SECOND_NAME', 'TYPE' => 'string', 'FROM' => $createdByJoin],
		'CREATED_BY_PERSONAL_PHOTO' => ['FIELD' => 'U.PERSONAL_PHOTO', 'TYPE' => 'int', 'FROM' => $createdByJoin],

		'DATE_CREATE' => ['FIELD' => 'CE.DATE_CREATE', 'TYPE' => 'datetime', 'FROM' => $relationJoin],
		'ASSIGNED_BY_ID' => ['FIELD' => 'CER.ASSIGNED_BY_ID', 'TYPE' => 'int'],
	];
}