CAllCrmActivity::CreateLogicalField

static function CreateLogicalField($fieldName, &$arFields)
{
	global $DB;

	$fieldName = strval($fieldName);

	if($fieldName === 'TYPE_NAME')
	{
		if(isset(self::$FIELDS_CACHE[LANGUAGE_ID]) && isset(self::$FIELDS_CACHE[LANGUAGE_ID]['TYPE_NAME']))
		{
			$arFields['TYPE_NAME'] = self::$FIELDS_CACHE[LANGUAGE_ID]['TYPE_NAME'];
			return;
		}

		$arTypeDescr = CCrmActivityType::GetAllDescriptions();
		if(count($arTypeDescr) == 0)
		{
			return;
		}

		$sql = 'CASE '.self::TABLE_ALIAS.'.TYPE_ID';
		foreach($arTypeDescr as $typeID=>&$typeDescr)
		{
			$sql .= " WHEN {$typeID} THEN '{$DB->ForSql($typeDescr)}'";
		}
		unset($typeDescr);
		$sql .= ' END';

		if(!isset(self::$FIELDS_CACHE[LANGUAGE_ID]))
		{
			self::$FIELDS_CACHE[LANGUAGE_ID] = array();
		}
		$arFields['TYPE_NAME'] = self::$FIELDS_CACHE[LANGUAGE_ID]['TYPE_NAME'] = array('FIELD' => $sql, 'TYPE' => 'string');
	}
}