static function onBIConnectorDataSources(BitrixMainEvent $event)
{
if (!BitrixMainLoader::includeModule('crm'))
{
return;
}
$params = $event->getParameters();
//$manager = $params[0];
$result = &$params[1];
$languageId = $params[2];
$result['crm_contact'] = [
'TABLE_NAME' => 'b_crm_contact',
'TABLE_ALIAS' => 'C',
'FIELDS' => [
//ID INT (18) UNSIGNED NOT NULL AUTO_INCREMENT,
'ID' => [
'IS_PRIMARY' => 'Y',
'FIELD_NAME' => 'C.ID',
'FIELD_TYPE' => 'int',
],
//DATE_CREATE DATETIME NULL,
'DATE_CREATE' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.DATE_CREATE',
'FIELD_TYPE' => 'datetime',
],
//DATE_MODIFY DATETIME NULL,
'DATE_MODIFY' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.DATE_MODIFY',
'FIELD_TYPE' => 'datetime',
],
//CREATED_BY_ID INT (18) UNSIGNED NOT NULL,
'CREATED_BY_ID' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.CREATED_BY_ID',
'FIELD_TYPE' => 'int',
],
'CREATED_BY_NAME' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'concat_ws(' ', nullif(UC.NAME, ''), nullif(UC.LAST_NAME, ''))',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UC',
'JOIN' => 'INNER JOIN b_user UC ON UC.ID = C.CREATED_BY_ID',
'LEFT_JOIN' => 'LEFT JOIN b_user UC ON UC.ID = C.CREATED_BY_ID',
],
'CREATED_BY' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'concat_ws(' ', concat('[', C.CREATED_BY_ID, ']'), nullif(UC.NAME, ''), nullif(UC.LAST_NAME, ''))',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UC',
'JOIN' => 'INNER JOIN b_user UC ON UC.ID = C.CREATED_BY_ID',
'LEFT_JOIN' => 'LEFT JOIN b_user UC ON UC.ID = C.CREATED_BY_ID',
],
//MODIFY_BY_ID INT (18) UNSIGNED DEFAULT NULL,
'MODIFY_BY_ID' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.MODIFY_BY_ID',
'FIELD_TYPE' => 'int',
],
'MODIFIED_BY_NAME' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'if(C.MODIFY_BY_ID is null, null, concat_ws(' ', nullif(UM.NAME, ''), nullif(UM.LAST_NAME, '')))',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UM',
'JOIN' => 'INNER JOIN b_user UM ON UM.ID = C.MODIFY_BY_ID',
'LEFT_JOIN' => 'LEFT JOIN b_user UM ON UM.ID = C.MODIFY_BY_ID',
],
'MODIFIED_BY' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'if(C.MODIFY_BY_ID is null, null, concat_ws(' ', concat('[', C.MODIFY_BY_ID, ']'), nullif(UM.NAME, ''), nullif(UM.LAST_NAME, '')))',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UM',
'JOIN' => 'INNER JOIN b_user UM ON UM.ID = C.MODIFY_BY_ID',
'LEFT_JOIN' => 'LEFT JOIN b_user UM ON UM.ID = C.MODIFY_BY_ID',
],
//ASSIGNED_BY_ID INT (1) UNSIGNED DEFAULT NULL,
'ASSIGNED_BY_ID' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.ASSIGNED_BY_ID',
'FIELD_TYPE' => 'int',
],
'ASSIGNED_BY_NAME' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'if(C.ASSIGNED_BY_ID is null, null, concat_ws(' ', nullif(UA.NAME, ''), nullif(UA.LAST_NAME, '')))',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UA',
'JOIN' => 'INNER JOIN b_user UA ON UA.ID = C.ASSIGNED_BY_ID',
'LEFT_JOIN' => 'LEFT JOIN b_user UA ON UA.ID = C.ASSIGNED_BY_ID',
],
'ASSIGNED_BY' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'if(C.ASSIGNED_BY_ID is null, null, concat_ws(' ', concat('[', C.ASSIGNED_BY_ID, ']'), nullif(UA.NAME, ''), nullif(UA.LAST_NAME, '')))',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UA',
'JOIN' => 'INNER JOIN b_user UA ON UA.ID = C.ASSIGNED_BY_ID',
'LEFT_JOIN' => 'LEFT JOIN b_user UA ON UA.ID = C.ASSIGNED_BY_ID',
],
//OPENED CHAR(1) DEFAULT 'N',
'OPENED' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.OPENED',
'FIELD_TYPE' => 'string',
],
//COMPANY_ID INT (18) UNSIGNED DEFAULT NULL,
'COMPANY_ID' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.COMPANY_ID',
'FIELD_TYPE' => 'int',
],
//SOURCE_ID VARCHAR (50) DEFAULT NULL,
'SOURCE_ID' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.SOURCE_ID',
'FIELD_TYPE' => 'string',
],
//SOURCE_DESCRIPTION TEXT DEFAULT NULL,
'SOURCE_DESCRIPTION' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.SOURCE_DESCRIPTION',
'FIELD_TYPE' => 'string',
],
//TODO:FULL_NAME VARCHAR (100) DEFAULT NULL,
//NAME VARCHAR (50) DEFAULT NULL,
'NAME' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.NAME',
'FIELD_TYPE' => 'string',
],
//LAST_NAME VARCHAR (50) DEFAULT NULL,
'LAST_NAME' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.LAST_NAME',
'FIELD_TYPE' => 'string',
],
//TODO:SECOND_NAME VARCHAR (50) DEFAULT NULL,
'SECOND_NAME' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.SECOND_NAME',
'FIELD_TYPE' => 'string',
],
//TODO:PHOTO VARCHAR (10) DEFAULT NULL,
//POST VARCHAR (255) DEFAULT NULL,
'POST' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.POST',
'FIELD_TYPE' => 'string',
],
//ADDRESS text DEFAULT NULL,
'ADDRESS_1' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'ADDR.ADDRESS_1',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'ADDR',
'JOIN' => 'INNER JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
],
'ADDRESS_2' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'ADDR.ADDRESS_2',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'ADDR',
'JOIN' => 'INNER JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
],
'ADDRESS_CITY' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'ADDR.CITY',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'ADDR',
'JOIN' => 'INNER JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
],
'ADDRESS_POSTAL_CODE' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'ADDR.POSTAL_CODE',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'ADDR',
'JOIN' => 'INNER JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
],
'ADDRESS_REGION' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'ADDR.PROVINCE',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'ADDR',
'JOIN' => 'INNER JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
],
'ADDRESS_PROVINCE' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'ADDR.REGION',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'ADDR',
'JOIN' => 'INNER JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
],
'ADDRESS_COUNTRY' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'ADDR.COUNTRY',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'ADDR',
'JOIN' => 'INNER JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
],
'ADDRESS_COUNTRY_CODE' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'ADDR.COUNTRY_CODE',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'ADDR',
'JOIN' => 'INNER JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_addr ADDR ON ADDR.ANCHOR_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND ADDR.ANCHOR_ID = C.ID and ADDR.TYPE_ID = '' . BitrixCrmEntityAddressType::Primary . ''',
],
//COMMENTS TEXT DEFAULT NULL,
'COMMENTS' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.COMMENTS',
'FIELD_TYPE' => 'string',
],
//LEAD_ID INT (18) DEFAULT NULL,
'LEAD_ID' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.LEAD_ID',
'FIELD_TYPE' => 'int',
],
//EXPORT CHAR (1) DEFAULT 'N',
'EXPORT' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.EXPORT',
'FIELD_TYPE' => 'string',
],
//TYPE_ID VARCHAR (50) DEFAULT NULL,
'TYPE_ID' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.TYPE_ID',
'FIELD_TYPE' => 'string',
],
//TODO:WEBFORM_ID INT (18) UNSIGNED DEFAULT NULL,
//ORIGINATOR_ID VARCHAR(255) NULL,
'ORIGINATOR_ID' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.ORIGINATOR_ID',
'FIELD_TYPE' => 'string',
],
//ORIGIN_ID VARCHAR(255) NULL,
'ORIGIN_ID' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.ORIGIN_ID',
'FIELD_TYPE' => 'string',
],
//ORIGIN_VERSION VARCHAR(255) NULL,
'ORIGIN_VERSION' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.ORIGIN_VERSION',
'FIELD_TYPE' => 'string',
],
//BIRTHDATE DATE DEFAULT NULL,
'BIRTHDATE' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.BIRTHDATE',
'FIELD_TYPE' => 'datetime',
],
//TODO:BIRTHDAY_SORT INT(1) NOT NULL DEFAULT 1024,
//HONORIFIC VARCHAR(128) NULL,
'HONORIFIC' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.HONORIFIC',
'FIELD_TYPE' => 'string',
],
//HAS_PHONE CHAR(1) NULL,
//HAS_EMAIL CHAR(1) NULL,
//HAS_IMOL CHAR(1) DEFAULT 'N',
//FACE_ID INT(18) NULL,
'FACE_ID' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'C.FACE_ID',
'FIELD_TYPE' => 'int',
],
//TODO:SEARCH_CONTENT MEDIUMTEXT NULL,
//TODO:CATEGORY_ID INT UNSIGNED NOT NULL DEFAULT 0,
'PHONE' => [
'CONCAT_GROUP_BY' => ', ',
'CONCAT_KEY' => 'PHONE',
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'concat('[', FM_PHONE.VALUE_TYPE, '] ', FM_PHONE.VALUE)',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'FM_PHONE',
'JOIN' => 'INNER JOIN b_crm_field_multi FM_PHONE ON FM_PHONE.ENTITY_ID = 'CONTACT' and FM_PHONE.TYPE_ID = '' . CCrmFieldMulti::PHONE . '' AND FM_PHONE.ELEMENT_ID = C.ID',
'LEFT_JOIN' => 'LEFT JOIN b_crm_field_multi FM_PHONE ON FM_PHONE.ENTITY_ID = 'CONTACT' and FM_PHONE.TYPE_ID = '' . CCrmFieldMulti::PHONE . '' AND FM_PHONE.ELEMENT_ID = C.ID',
],
'WEB' => [
'CONCAT_GROUP_BY' => ', ',
'CONCAT_KEY' => 'WEB',
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'concat('[', FM_WEB.VALUE_TYPE, '] ', FM_WEB.VALUE)',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'FM_WEB',
'JOIN' => 'INNER JOIN b_crm_field_multi FM_WEB ON FM_WEB.ENTITY_ID = 'CONTACT' and FM_WEB.TYPE_ID = '' . CCrmFieldMulti::WEB . '' AND FM_WEB.ELEMENT_ID = C.ID',
'LEFT_JOIN' => 'LEFT JOIN b_crm_field_multi FM_WEB ON FM_WEB.ENTITY_ID = 'CONTACT' and FM_WEB.TYPE_ID = '' . CCrmFieldMulti::WEB . '' AND FM_WEB.ELEMENT_ID = C.ID',
],
'EMAIL' => [
'CONCAT_GROUP_BY' => ', ',
'CONCAT_KEY' => 'EMAIL',
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'concat('[', FM_EMAIL.VALUE_TYPE, '] ', FM_EMAIL.VALUE)',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'FM_EMAIL',
'JOIN' => 'INNER JOIN b_crm_field_multi FM_EMAIL ON FM_EMAIL.ENTITY_ID = 'CONTACT' and FM_EMAIL.TYPE_ID = '' . CCrmFieldMulti::EMAIL . '' AND FM_EMAIL.ELEMENT_ID = C.ID',
'LEFT_JOIN' => 'LEFT JOIN b_crm_field_multi FM_EMAIL ON FM_EMAIL.ENTITY_ID = 'CONTACT' and FM_EMAIL.TYPE_ID = '' . CCrmFieldMulti::EMAIL . '' AND FM_EMAIL.ELEMENT_ID = C.ID',
],
'IM' => [
'CONCAT_GROUP_BY' => ', ',
'CONCAT_KEY' => 'IM',
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'concat('[', FM_IM.VALUE_TYPE, '] ', FM_IM.VALUE)',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'FM_IM',
'JOIN' => 'INNER JOIN b_crm_field_multi FM_IM ON FM_IM.ENTITY_ID = 'CONTACT' and FM_IM.TYPE_ID = '' . CCrmFieldMulti::IM . '' AND FM_IM.ELEMENT_ID = C.ID',
'LEFT_JOIN' => 'LEFT JOIN b_crm_field_multi FM_IM ON FM_IM.ENTITY_ID = 'CONTACT' and FM_IM.TYPE_ID = '' . CCrmFieldMulti::IM . '' AND FM_IM.ELEMENT_ID = C.ID',
],
'UTM_SOURCE' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'UTM_S.VALUE',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UTM_S',
'JOIN' => 'INNER JOIN b_crm_utm UTM_S ON UTM_S.ENTITY_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND UTM_S.ENTITY_ID = C.ID and UTM_S.CODE = '' . BitrixCrmUtmTable::ENUM_CODE_UTM_SOURCE . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_utm UTM_S ON UTM_S.ENTITY_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND UTM_S.ENTITY_ID = C.ID and UTM_S.CODE = '' . BitrixCrmUtmTable::ENUM_CODE_UTM_SOURCE . ''',
],
'UTM_MEDIUM' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'UTM_M.VALUE',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UTM_M',
'JOIN' => 'INNER JOIN b_crm_utm UTM_M ON UTM_M.ENTITY_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND UTM_M.ENTITY_ID = C.ID and UTM_M.CODE = '' . BitrixCrmUtmTable::ENUM_CODE_UTM_MEDIUM . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_utm UTM_M ON UTM_M.ENTITY_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND UTM_M.ENTITY_ID = C.ID and UTM_M.CODE = '' . BitrixCrmUtmTable::ENUM_CODE_UTM_MEDIUM . ''',
],
'UTM_CAMPAIGN' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'UTM_C.VALUE',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UTM_C',
'JOIN' => 'INNER JOIN b_crm_utm UTM_C ON UTM_C.ENTITY_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND UTM_C.ENTITY_ID = C.ID and UTM_C.CODE = '' . BitrixCrmUtmTable::ENUM_CODE_UTM_CAMPAIGN . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_utm UTM_C ON UTM_C.ENTITY_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND UTM_C.ENTITY_ID = C.ID and UTM_C.CODE = '' . BitrixCrmUtmTable::ENUM_CODE_UTM_CAMPAIGN . ''',
],
'UTM_CONTENT' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'UTM_CT.VALUE',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UTM_CT',
'JOIN' => 'INNER JOIN b_crm_utm UTM_CT ON UTM_CT.ENTITY_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND UTM_CT.ENTITY_ID = C.ID and UTM_CT.CODE = '' . BitrixCrmUtmTable::ENUM_CODE_UTM_CONTENT . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_utm UTM_CT ON UTM_CT.ENTITY_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND UTM_CT.ENTITY_ID = C.ID and UTM_CT.CODE = '' . BitrixCrmUtmTable::ENUM_CODE_UTM_CONTENT . ''',
],
'UTM_TERM' => [
'IS_METRIC' => 'N', // 'Y'
'FIELD_NAME' => 'UTM_T.VALUE',
'FIELD_TYPE' => 'string',
'TABLE_ALIAS' => 'UTM_T',
'JOIN' => 'INNER JOIN b_crm_utm UTM_T ON UTM_T.ENTITY_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND UTM_T.ENTITY_ID = C.ID and UTM_T.CODE = '' . BitrixCrmUtmTable::ENUM_CODE_UTM_TERM . ''',
'LEFT_JOIN' => 'LEFT JOIN b_crm_utm UTM_T ON UTM_T.ENTITY_TYPE_ID = ' . CCrmOwnerType::Contact . ' AND UTM_T.ENTITY_ID = C.ID and UTM_T.CODE = '' . BitrixCrmUtmTable::ENUM_CODE_UTM_TERM . ''',
],
],
];
$messages = Loc::loadLanguageFile(__FILE__, $languageId);
$result['crm_contact']['TABLE_DESCRIPTION'] = $messages['CRM_BIC_CONTACT_TABLE'] ?: 'crm_contact';
foreach ($result['crm_contact']['FIELDS'] as $fieldCode => &$fieldInfo)
{
$fieldInfo['FIELD_DESCRIPTION'] = $messages['CRM_BIC_CONTACT_FIELD_' . $fieldCode];
if (!$fieldInfo['FIELD_DESCRIPTION'])
{
$fieldInfo['FIELD_DESCRIPTION'] = $fieldCode;
}
$fieldInfo['FIELD_DESCRIPTION_FULL'] = $messages['CRM_BIC_CONTACT_FIELD_' . $fieldCode . '_FULL'] ?? '';
}
unset($fieldInfo);
}