user_id = intval($USER->GetID()); } } else { $this->user_id = intval($user_id); } if (isset($arParams['HIDE_LINK']) && $arParams['HIDE_LINK'] == 'Y') { $this->bHideLink = true; } } public function GetMessage($ID) { global $DB; $strSql = " SELECT M.*, C.TYPE CHAT_TYPE, R.USER_ID RID FROM b_im_message M INNER JOIN b_im_chat C ON C.ID = M.CHAT_ID LEFT JOIN b_im_relation R ON R.CHAT_ID = M.CHAT_ID AND R.USER_ID = ".$this->user_id." WHERE M.ID = ".intval($ID)." "; $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); if ($arRes = $dbRes->Fetch()) { $arRes['CHAT_TYPE'] = trim($arRes['CHAT_TYPE']); if ($arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN) { if (intval($arRes['RID']) <= 0 && IM\User::getInstance($this->user_id)->isExtranet()) { return false; } } else if (intval($arRes['RID']) <= 0) { return false; } unset($arRes['CHAT_TYPE']); unset($arRes['RID']); return $arRes; } return false; } /** * @param $toChatId * @param bool $fromUserId * @param bool $loadExtraData * @param bool $bTimeZone * @param bool $limit * @return array|bool * @throws \Bitrix\Main\ArgumentException * @throws \Bitrix\Main\LoaderException * @throws \Bitrix\Main\ObjectPropertyException * @throws \Bitrix\Main\SystemException */ function GetLastMessage($toChatId, $fromUserId = false, $loadExtraData = false, $bTimeZone = true, $limit = true) { global $DB; $fromUserId = intval($fromUserId); if ($fromUserId <= 0) $fromUserId = $this->user_id; $toChatId = intval($toChatId); if ($toChatId <= 0) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_EMPTY_CHAT_ID"), "ERROR_TO_CHAT_ID"); return false; } $orm = IM\Model\ChatTable::getById($toChatId); if (!($chatData = $orm->fetch())) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_CHAT_NOT_EXISTS"), "ERROR_CHAT_NOT_EXISTS"); return false; } if ($chatData['TYPE'] == IM_MESSAGE_OPEN && !CIMMessenger::CheckEnableOpenChat()) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_CHAT_NOT_EXISTS"), "ERROR_CHAT_NOT_EXISTS"); return false; } if ($limit) { if ($DB->type == "MYSQL") $sqlLimit = " AND M.DATE_CREATE > DATE_SUB(NOW(), INTERVAL 30 DAY)"; elseif ($DB->type == "MSSQL") $sqlLimit = " AND M.DATE_CREATE > dateadd(day, -30, getdate())"; elseif ($DB->type == "ORACLE") $sqlLimit = " AND M.DATE_CREATE > SYSDATE-30"; } $readService = new IM\V2\Message\ReadService($fromUserId); $lastMessageIdInChat = $readService->getLastMessageIdInChat($toChatId); $limitById = ''; $limitFetchMessages = 30; $relations = \CIMChat::GetRelationById($toChatId, false, $bTimeZone, false); if (isset($relations[$fromUserId])) { if ($relations[$fromUserId]['START_ID'] > 0) { $limitById = 'AND M.ID >= '.intval($relations[$fromUserId]['START_ID']); } //if ($relations[$fromUserId]['STATUS'] != IM_STATUS_READ && $relations[$fromUserId]['COUNTER'] > $limitFetchMessages) $messageCountFilter = \Bitrix\Main\ORM\Query\Query::filter() ->where('ID', '>=', (int)$relations[$fromUserId]['START_ID']) ->where('ID', '>=', (int)$relations[$fromUserId]['LAST_ID']) ->where('ID', '<=', $lastMessageIdInChat) ->where('CHAT_ID', $toChatId) ; $messageCount = \Bitrix\Im\Model\MessageTable::getCount($messageCountFilter); $limitFetchMessages = max($messageCount, 30); } if (!$bTimeZone) CTimeZone::Disable(); $crmEntityType = null; $crmEntityId = null; if ($chatData['TYPE'] == IM_MESSAGE_OPEN_LINE && \Bitrix\Main\Loader::includeModule('imopenlines')) { $explodeData = explode('|', $chatData['ENTITY_DATA_1']); $crmEntityType = ($explodeData[0] == 'Y') ? $explodeData[1] : null; $crmEntityId = ($explodeData[0] == 'Y') ? intval($explodeData[2]) : null; } $strSql = ""; if ($chatData['TYPE'] == IM_MESSAGE_OPEN) { $strSql = " SELECT M.ID, M.CHAT_ID, M.MESSAGE, ".$DB->DatetimeToTimestampFunction('M.DATE_CREATE')." DATE_CREATE, M.AUTHOR_ID, C.TYPE CHAT_TYPE, C.ENTITY_TYPE CHAT_ENTITY_TYPE, R.USER_ID RID FROM b_im_message M INNER JOIN b_im_chat C ON C.ID = M.CHAT_ID AND C.TYPE = '".IM_MESSAGE_OPEN."' LEFT JOIN b_im_relation R ON R.CHAT_ID = M.CHAT_ID AND R.USER_ID = ".$fromUserId." WHERE M.CHAT_ID = ".$toChatId." ".$limitById." #LIMIT# ORDER BY M.DATE_CREATE DESC "; } else if ( $chatData['TYPE'] == IM_MESSAGE_OPEN_LINE && \Bitrix\Main\Loader::includeModule('imopenlines') && \Bitrix\ImOpenLines\Config::canJoin($toChatId, $crmEntityType, $crmEntityId) ) { $strSql = " SELECT M.ID, M.CHAT_ID, M.MESSAGE, ".$DB->DatetimeToTimestampFunction('M.DATE_CREATE')." DATE_CREATE, M.AUTHOR_ID, C.TYPE CHAT_TYPE, C.ENTITY_TYPE CHAT_ENTITY_TYPE, R.USER_ID RID FROM b_im_message M INNER JOIN b_im_chat C ON C.ID = M.CHAT_ID AND C.TYPE = '".IM_MESSAGE_OPEN_LINE."' LEFT JOIN b_im_relation R ON R.CHAT_ID = M.CHAT_ID AND R.USER_ID = ".$fromUserId." WHERE M.CHAT_ID = ".$toChatId." ".$limitById." #LIMIT# ORDER BY M.DATE_CREATE DESC "; \Bitrix\Im\Disk\NoRelationPermission::add($toChatId, $fromUserId); } else if (isset($relations[$fromUserId])) { $strSql = " SELECT M.ID, M.CHAT_ID, M.MESSAGE, ".$DB->DatetimeToTimestampFunction('M.DATE_CREATE')." DATE_CREATE, M.AUTHOR_ID, C.TYPE CHAT_TYPE, C.ENTITY_TYPE CHAT_ENTITY_TYPE, '".$fromUserId."' RID FROM b_im_message M INNER JOIN b_im_chat C ON C.ID = M.CHAT_ID WHERE M.CHAT_ID = ".$toChatId." ".$limitById." #LIMIT# ORDER BY M.DATE_CREATE DESC "; } if (!$bTimeZone) CTimeZone::Enable(); $chatType = $chatData['TYPE']; $chatRelationUserId = 0; $arUsers = Array(); $arMessages = Array(); $arMessageId = Array(); $arUsersMessage = Array(); $arUnreadMessages = Array(); $readedList = Array(); if ($strSql) { $strSql = $DB->TopSql($strSql, $limitFetchMessages); //LEFT JOIN b_im_message_param MP on MP.MESSAGE_ID = M.ID and MP.PARAM_NAME = 'FOR_USER_ID' //and (MP.PARAM_VALUE is null or MP.PARAM_VALUE = '".$fromUserId."') if ($limit) { $dbRes = $DB->Query(str_replace("#LIMIT#", $sqlLimit, $strSql), false, "File: ".__FILE__."
Line: ".__LINE__); if (!$dbRes->SelectedRowsCount()) $dbRes = $DB->Query(str_replace("#LIMIT#", "", $strSql), false, "File: ".__FILE__."
Line: ".__LINE__); } else { $dbRes = $DB->Query(str_replace("#LIMIT#", "", $strSql), false, "File: ".__FILE__."
Line: ".__LINE__); } $lastReads = $readService ->getViewedService() ->getDateViewedByMessageIdForEachUser($lastMessageIdInChat, array_keys($relations)) ; while ($arRes = $dbRes->Fetch()) { if ($arRes['CHAT_ENTITY_TYPE'] != 'LIVECHAT' && \Bitrix\Im\User::getInstance($fromUserId)->isConnector()) { return false; } $arRes['CHAT_TYPE'] = trim($arRes['CHAT_TYPE']); $chatType = $arRes['CHAT_TYPE']; $chatRelationUserId = intval($arRes['RID']); $arMessages[$arRes['ID']] = Array( 'id' => $arRes['ID'], 'chatId' => $arRes['CHAT_ID'], 'senderId' => $arRes['AUTHOR_ID'], 'recipientId' => $arRes['CHAT_ID'], 'date' => \Bitrix\Main\Type\DateTime::createFromTimestamp($arRes['DATE_CREATE']), 'text' => \Bitrix\Im\Text::parse($arRes['MESSAGE']), 'textLegacy' => \Bitrix\Im\Text::parseLegacyFormat($arRes['MESSAGE']), ); $arMessageId[] = $arRes['ID']; if ($arRes['AUTHOR_ID'] > 0) { $arUsers[] = $arRes['AUTHOR_ID']; } if (isset($relations[$fromUserId]) && $relations[$fromUserId]['LAST_ID'] < $arRes['ID']) { $arUnreadMessages['chat'.$arRes['CHAT_ID']][] = $arRes['ID']; } $arUsersMessage[$arRes['CHAT_ID']][] = $arRes['ID']; foreach ($relations as $userId => $relation) { $readedList['chat'.$arRes['CHAT_ID']][$relation['USER_ID']] = Array( 'messageId' => $relation['LAST_ID'], 'date' => $lastReads[$userId] ?? null, ); } } foreach ($arUsersMessage as $chatId => $messageIds) { $arUsersMessage[$chatId] = array_values(array_unique($messageIds)); } } if ( $chatType == IM_MESSAGE_OPEN && $chatRelationUserId <= 0 || $chatType == IM_MESSAGE_OPEN_LINE && $chatRelationUserId <= 0 ) { if (IM\User::getInstance($fromUserId)->isExtranet()) { $arMessages = Array(); $arMessageId = Array(); $arUsersMessage = Array(); $loadExtraData = false; } else if (CModule::IncludeModule('pull')) { CPullWatch::Add($fromUserId, 'IM_PUBLIC_'.$toChatId, true); } } $params = CIMMessageParam::Get($arMessageId); $arFiles = Array(); foreach ($params as $messageId => $param) { $arMessages[$messageId]['params'] = $param; if ( mb_strlen($arMessages[$messageId]['text']) <= 0 && !isset($param['FILE_ID']) && !isset($param['KEYBOARD']) && !isset($param['ATTACH']) ) { $arMessages[$messageId]['text'] = GetMessage('IM_MESSAGE_DELETED'); $arMessages[$messageId]['params']['IS_DELETED'] = 'Y'; } if (isset($param['FILE_ID'])) { foreach ($param['FILE_ID'] as $fileId) { $arFiles[$fileId] = $fileId; } } } $arChatFiles = CIMDisk::GetFiles($toChatId, $arFiles); $arMessages = CIMMessageLink::prepareShow($arMessages, $params); $arResult = Array( 'chatId' => $toChatId, 'message' => $arMessages, 'usersMessage' => $arUsersMessage, 'unreadMessage' => $arUnreadMessages, 'users' => Array(), 'userInGroup' => Array(), 'readedList' => $readedList, 'files' => $arChatFiles ); if (is_array($loadExtraData) || is_bool($loadExtraData) && $loadExtraData == true) { $bDepartment = true; if (is_array($loadExtraData) && $loadExtraData['DEPARTMENT'] == 'N') $bDepartment = false; $arChat = self::GetChatData(array( 'ID' => $toChatId, 'USE_CACHE' => 'N' )); if ( isset($arChat['chat'][$toChatId]) && $arChat['chat'][$toChatId]['message_type'] == IM_MESSAGE_OPEN || isset($arChat['chat'][$toChatId]) && $arChat['chat'][$toChatId]['message_type'] == IM_MESSAGE_OPEN_LINE || isset($arChat['userInChat'][$toChatId]) && in_array($fromUserId, $arChat['userInChat'][$toChatId]) ) { $arResult['lines'] = $arChat['lines']; $arResult['userInChat'] = $arChat['userInChat']; $arResult['userChatBlockStatus'] = $arChat['userChatBlockStatus']; $ar = CIMContactList::GetUserData(array( 'ID' => array_values(array_merge($arUsers, $arChat['userInChat'][$toChatId])), 'DEPARTMENT' => ($bDepartment? 'Y': 'N'), 'USE_CACHE' => 'N' ) ); $arResult['users'] = $ar['users']; $arResult['userInGroup'] = $ar['userInGroup']; if ($arChat['chat'][$toChatId]['extranet'] === "") { $isExtranet = false; foreach ($ar['users'] as $userData) { if ($userData['extranet']) { $isExtranet = true; break; } } IM\Model\ChatTable::update($toChatId, Array('EXTRANET' => $isExtranet? "Y":"N")); $arChat['chat'][$toChatId]['extranet'] = $isExtranet; } $arResult['chat'] = $arChat['chat']; } } if ($chatData['ENTITY_TYPE'] == 'LINES' && $chatData['ENTITY_ID'] && CModule::IncludeModule('imopenlines')) { [, $lineId] = explode('|', $chatData["ENTITY_ID"]); $configManager = new \Bitrix\ImOpenLines\Config(); $arResult['openlines']['canVoteAsHead'][$lineId] = $configManager->canVoteAsHead($lineId); } else if ($chatData['ENTITY_TYPE'] == 'LIVECHAT' && $chatData['ENTITY_ID'] && CModule::IncludeModule('imopenlines')) { [$lineId, $userId] = explode('|', $chatData["ENTITY_ID"]); $userCode = 'livechat|' . $lineId . '|' . $chatData['ID'] . '|' . $userId; unset($lineId, $userId); foreach ($arResult['users'] as $userId => $userData) { $arResult['users'][$userId] = \Bitrix\ImOpenLines\Connector::getOperatorInfo($lineId, $userId, $userCode); } } return $arResult; } function GetLastMessageLimit($chatId, $messageStartId, $messageEndId = 0, $loadExtraData = false, $bTimeZone = true, $order = 'DESC') { $messageStartId = intval($messageStartId); $messageEndId = intval($messageEndId); $chatId = intval($chatId); if ($chatId <= 0) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_EMPTY_CHAT_ID"), "ERROR_TO_CHAT_ID"); return false; } $orm = IM\Model\ChatTable::getById($chatId); if (!($chatData = $orm->fetch())) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_CHAT_NOT_EXISTS"), "ERROR_CHAT_NOT_EXISTS"); return false; } global $DB; if (!$bTimeZone) CTimeZone::Disable(); $strSql = " SELECT M.ID, M.CHAT_ID, M.MESSAGE, ".$DB->DatetimeToTimestampFunction('M.DATE_CREATE')." DATE_CREATE, M.AUTHOR_ID, C.TYPE CHAT_TYPE FROM b_im_message M INNER JOIN b_im_chat C ON C.ID = M.CHAT_ID WHERE M.CHAT_ID = ".$chatId." AND M.ID >= ".$messageStartId." ".($messageEndId > 0? "AND M.ID <= ".$messageEndId: "")." ORDER BY M.DATE_CREATE ".($order == 'ASC'? 'ASC': 'DESC')." "; if (!$bTimeZone) CTimeZone::Enable(); $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); $arMessages = Array(); $arMessageId = Array(); $arUsers = Array(); $arUsersMessage = Array(); while ($arRes = $dbRes->Fetch()) { $arMessages[$arRes['ID']] = Array( 'id' => $arRes['ID'], 'chatId' => $arRes['CHAT_ID'], 'senderId' => $arRes['AUTHOR_ID'], 'recipientId' => $arRes['CHAT_ID'], 'date' => \Bitrix\Main\Type\DateTime::createFromTimestamp($arRes['DATE_CREATE']), 'text' => \Bitrix\Im\Text::parse($arRes['MESSAGE']), 'textLegacy' => \Bitrix\Im\Text::parseLegacyFormat($arRes['MESSAGE']), ); $arMessageId[] = $arRes['ID']; $arUsersMessage[$arRes['CHAT_ID']][] = $arRes['ID']; $arUsers[$arRes['CHAT_ID']][] = $arRes['AUTHOR_ID']; } if ($chatData['TYPE'] == IM_MESSAGE_OPEN_LINE) { \Bitrix\Im\Disk\NoRelationPermission::add($chatId, $this->user_id); } $params = CIMMessageParam::Get($arMessageId); $arFiles = Array(); foreach ($params as $messageId => $param) { $arMessages[$messageId]['params'] = $param; if (isset($param['FILE_ID'])) { foreach ($param['FILE_ID'] as $fileId) { $arFiles[$fileId] = $fileId; } } } $arChatFiles = CIMDisk::GetFiles($chatId, $arFiles); // TODO get files for sessions $arMessages = CIMMessageLink::prepareShow($arMessages, $params); $arResult = Array( 'chatId' => $chatId, 'message' => $arMessages, 'usersMessage' => $arUsersMessage, 'users' => Array(), 'userInGroup' => Array(), 'files' => $arChatFiles ); if (is_array($loadExtraData) || is_bool($loadExtraData) && $loadExtraData == true) { $bDepartment = true; if (is_array($loadExtraData) && $loadExtraData['DEPARTMENT'] == 'N') $bDepartment = false; $arChat = self::GetChatData(array( 'ID' => $chatId, 'USE_CACHE' => 'N' )); $arResult['lines'] = $arChat['lines']; $arResult['userInChat'] = $arChat['userInChat']; $arResult['userChatBlockStatus'] = $arChat['userChatBlockStatus']; $ar = CIMContactList::GetUserData(array( 'ID' => $arUsers[$chatId], 'DEPARTMENT' => ($bDepartment? 'Y': 'N'), 'USE_CACHE' => 'N' ) ); $arResult['users'] = $ar['users']; $arResult['userInGroup'] = $ar['userInGroup']; $arResult['chat'] = $arChat['chat']; } return $arResult; } public static function getChatType($chatData) { return \Bitrix\Im\Chat::getType($chatData); } public function GetLastSendMessage($arParams) { global $DB; if (!isset($arParams['ID'])) return false; $chatId = $arParams['ID']; $fromUserId = isset($arParams['FROM_USER_ID']) && intval($arParams['FROM_USER_ID'])>0? intval($arParams['FROM_USER_ID']): $this->user_id; $limit = isset($arParams['LIMIT']) && intval($arParams['LIMIT'])>0? intval($arParams['LIMIT']): false; $bTimeZone = isset($arParams['USE_TIME_ZONE']) && $arParams['USE_TIME_ZONE'] == 'N'? false: true; $arChatId = Array(); if (is_array($chatId)) { foreach ($chatId as $val) $arChatId[] = intval($val); } else { $arChatId[] = intval($chatId); } if (empty($arChatId)) return Array(); $sqlLimit = ''; if ($limit) { if ($DB->type == "MYSQL") $sqlLimit = " AND M.DATE_CREATE > DATE_SUB(NOW(), INTERVAL ".$limit." DAY)"; elseif ($DB->type == "MSSQL") $sqlLimit = " AND M.DATE_CREATE > dateadd(day, -".$limit.", getdate())"; elseif ($DB->type == "ORACLE") $sqlLimit = " AND M.DATE_CREATE > SYSDATE-".$limit; } if (!$bTimeZone) CTimeZone::Disable(); $strSql = " SELECT M.ID, M.CHAT_ID, M.MESSAGE, ".$DB->DatetimeToTimestampFunction('M.DATE_CREATE')." DATE_CREATE, M.AUTHOR_ID, C.TITLE CHAT_TITLE, C.COLOR CHAT_COLOR, C.ENTITY_TYPE CHAT_ENTITY_TYPE, C.ENTITY_DATA_1 CHAT_ENTITY_DATA_1, C.ENTITY_DATA_2 CHAT_ENTITY_DATA_2, C.ENTITY_DATA_3 CHAT_ENTITY_DATA_3, ".$DB->DatetimeToTimestampFunction('C.DATE_CREATE')." CHAT_DATE_CREATE, C.TYPE CHAT_TYPE, R.ID RID FROM b_im_message M INNER JOIN b_im_chat C ON C.ID = M.CHAT_ID AND C.LAST_MESSAGE_ID = M.ID LEFT JOIN b_im_relation R ON R.CHAT_ID = M.CHAT_ID AND R.USER_ID = ".$fromUserId." WHERE M.ID = C.LAST_MESSAGE_ID AND M.CHAT_ID IN (".implode(",",$arChatId).") ".$sqlLimit." "; if (!$bTimeZone) CTimeZone::Enable(); $arMessages = Array(); $enableOpenChat = CIMMessenger::CheckEnableOpenChat(); $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); while ($arRes = $dbRes->Fetch()) { $arRes['CHAT_TYPE'] = trim($arRes['CHAT_TYPE']); if ($arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN) { if (!$enableOpenChat) { continue; } else if (intval($arRes['RID']) <= 0 && IM\User::getInstance($this->user_id)->isExtranet()) { continue; } } else if (intval($arRes['RID']) <= 0) { continue; } $chatType = \Bitrix\Im\Chat::getType($arRes); $arMessages[$arRes['CHAT_ID']] = Array( 'id' => $arRes['ID'], 'senderId' => $arRes['AUTHOR_ID'], 'recipientId' => $arRes['CHAT_ID'], 'chatTitle' => \Bitrix\Im\Text::decodeEmoji($arRes['CHAT_TITLE']), 'date' => \Bitrix\Main\Type\DateTime::createFromTimestamp($arRes['DATE_CREATE']), 'color' => $arRes["CHAT_COLOR"] == ""? IM\Color::getColorByNumber($arRes['CHAT_ID']): IM\Color::getColor($arRes['CHAT_COLOR']), 'type' => $chatType, 'messageType' => $arRes["CHAT_TYPE"], 'text' => \Bitrix\Im\Text::parse($arRes['MESSAGE']), 'textLegacy' => \Bitrix\Im\Text::parseLegacyFormat($arRes['MESSAGE']), ); } return $arMessages; } public static function GetRelationById($ID, $userId = false, $timezone = true, $withCounter = true) { global $DB; $ID = intval($ID); $userId = intval($userId); $arResult = Array(); if (!$timezone) { CTimeZone::Disable(); } $strSql = " SELECT R.*, U.EXTERNAL_AUTH_ID FROM b_im_relation R LEFT JOIN b_user U ON U.ID = R.USER_ID WHERE R.CHAT_ID = ".$ID." ".($userId>0? "AND R.USER_ID = ".$userId: ""); if (!$timezone) { CTimeZone::Enable(); } $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); while ($arRes = $dbRes->Fetch()) $arResult[$arRes['USER_ID']] = $arRes; if ($userId > 0) $arResult = isset($arResult[$userId])? $arResult[$userId]: false; if ($arResult === false) { return $arResult; } // region New counter if ($withCounter) { $readService = new IM\V2\Message\ReadService($userId); if ($userId > 0) { $arResult['COUNTER'] = $readService->getCounterService()->getByChat($ID); $lastRead = $readService->getViewedService()->getDateViewedByMessageId($arResult['LAST_ID']); $arResult['LAST_READ'] = isset($lastRead) ? $lastRead->getTimestamp() : null; } else { $userIds = array_keys($arResult); $counters = $readService->getCounterService()->getByChatForEachUsers($ID, $userIds); $lastIdInChat = $readService->getViewedService()->getLastMessageIdInChat($ID) ?? 0; $lastReads = $readService->getViewedService()->getDateViewedByMessageIdForEachUser($lastIdInChat, $userIds); foreach ($arResult as $id => $user) { $arResult[$id]['COUNTER'] = $counters[$id] ?? 0; $arResult[$id]['LAST_READ'] = isset($lastReads[$id]) ? $lastReads[$id]->getTimestamp() : null; } } } // endregion return $arResult; } public function GetPersonalChat(?int $userId = null) { if (!$userId) { $userId = $this->user_id; } $favoriteChatResult = \Bitrix\IM\V2\Chat\FavoriteChat::find(['TO_USER_ID' => $userId]); if (!$favoriteChatResult->hasResult()) { $favoriteChatResult = IM\V2\Chat\ChatFactory::getInstance()->addChat([ 'TYPE' => \Bitrix\Im\V2\Chat::IM_TYPE_PRIVATE, 'ENTITY_TYPE' => \Bitrix\Im\V2\Chat::ENTITY_TYPE_FAVORITE, 'AUTHOR_ID' => $userId, 'USERS' => [$userId], 'MESSAGE' => GetMessage('IM_PERSONAL_DESCRIPTION') ]); } $result = $favoriteChatResult->getResult(); return $result['ID']; } /** * @deprecated * @use ... * @param $fromUserId * @param $toUserId * @return array */ public static function GetPrivateRelation($fromUserId, $toUserId) { global $DB; $fromUserId = intval($fromUserId); $toUserId = intval($toUserId); $arResult = Array(); $strSql = " SELECT RF.* FROM b_im_relation RF INNER JOIN b_im_relation RT on RF.CHAT_ID = RT.CHAT_ID WHERE RF.USER_ID = ".$fromUserId." and RT.USER_ID = ".$toUserId." and RF.MESSAGE_TYPE = '".IM_MESSAGE_PRIVATE."' "; $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); if ($arRes = $dbRes->Fetch()) $arResult = $arRes; return $arResult; } public static function GetGeneralChatId() { return COption::GetOptionString("im", "general_chat_id"); } public static function InstallGeneralChat($agentMode = false) { global $DB; $chatId = self::GetGeneralChatId(); if ($chatId > 0) { if ($DB->query('SELECT ID FROM b_im_chat WHERE ID = '.$chatId)->fetch()) { return $agentMode? '': true; } COption::RemoveOption("im", "general_chat_id"); } if (!IsModuleInstalled('intranet')) { return $agentMode? '': false; } $userCount = 0; $types = \Bitrix\Main\UserTable::getExternalUserTypes(); $silentInstall = false; $sqlCounter = " SELECT COUNT(ID) as CNT FROM b_user WHERE ACTIVE = 'Y' AND (EXTERNAL_AUTH_ID NOT IN ('".implode("','", $types)."') OR EXTERNAL_AUTH_ID IS NULL OR b_user.EXTERNAL_AUTH_ID = '')"; $dbRes = $DB->Query($sqlCounter, false, "File: ".__FILE__."
Line: ".__LINE__); if ($row = $dbRes->Fetch()) { $userCount = $row['CNT']; if ($userCount > 50) { if (\Bitrix\Main\Loader::includeModule('bitrix24')) { $perms = Array(); $admins = \CBitrix24::getAllAdminId(); foreach ($admins as $userId) { $perms[] = 'U'.$userId; } CIMChat::SetAccessToGeneralChat(false, $perms); $silentInstall = true; } else if ($userCount > 500) { return $agentMode? '': false; } } } $res = $DB->Query("select ID from b_user_field where entity_id='USER' AND field_name='UF_DEPARTMENT'"); if ($result = $res->Fetch()) { $fieldId = intval($result['ID']); } else { return $agentMode? '': false; } $CIMChat = new self(0); $chatId = $CIMChat->Add(Array( 'TYPE' => IM_MESSAGE_OPEN, 'COLOR' => "AZURE", 'USERS' => false, 'TITLE' => GetMessage('IM_GENERAL_TITLE'), 'DESCTIPTION' => GetMessage('IM_GENERAL_DESCRIPTION') )); if (!$chatId) { return $agentMode? '': false; } $messageId = $CIMChat->AddMessage(Array( "TO_CHAT_ID" => $chatId, "MESSAGE" => GetMessage('IM_GENERAL_DESCRIPTION'), "FROM_USER_ID" => 0, "SYSTEM" => 'Y', "PUSH" => 'N', )); $sql = " insert into b_im_relation (USER_ID, MESSAGE_TYPE, CHAT_ID, STATUS) select distinct b_user.ID, '".IM_MESSAGE_OPEN."', ".intval($chatId).", ".IM_STATUS_READ." from b_user inner join b_utm_user on b_utm_user.VALUE_ID = b_user.ID and b_utm_user.FIELD_ID = ".$fieldId." and b_utm_user.VALUE_INT > 0 WHERE b_user.ACTIVE = 'Y' AND (b_user.EXTERNAL_AUTH_ID NOT IN ('".implode("','", $types)."') OR b_user.EXTERNAL_AUTH_ID IS NULL OR b_user.EXTERNAL_AUTH_ID = '') "; $result = $DB->Query($sql); if (!$result) { return $agentMode? '': false; } self::linkGeneralChatId($chatId); return $agentMode? '': true; } public static function GetGeneralChatAutoMessageStatus($type) { $status = false; if ($type == self::GENERAL_MESSAGE_TYPE_JOIN) { $status = COption::GetOptionString("im", "general_chat_message_join"); } else if ($type == self::GENERAL_MESSAGE_TYPE_LEAVE) { $status = COption::GetOptionString("im", "general_chat_message_leave"); } return $status; } public static function CanSendMessageToGeneralChat($userId = null) { global $USER; $userId = \Bitrix\Im\Common::getUserId($userId); if ($userId <= 0) { return false; } if (COption::GetOptionString("im", "allow_send_to_general_chat_all", "Y") == "Y") { return true; } $chatRights = COption::GetOptionString("im", "allow_send_to_general_chat_rights"); if (!empty($chatRights)) { $arUserGroupCode = $USER->GetAccessCodes(); $chatRights = explode(",", $chatRights); foreach($chatRights as $right) { if (in_array($right, $arUserGroupCode)) { return true; } } return false; } return false; } public static function SetAccessToGeneralChat($allowAll = true, $allowCodes = Array()) { $prevAllow = COption::GetOptionString("im", "allow_send_to_general_chat_all"); $prevCodes = COption::GetOptionString("im", "allow_send_to_general_chat_rights"); if ($allowAll) { $allow = 'Y'; $codes = 'AU'; } else { $allow = 'N'; if (is_array($allowCodes) && count($allowCodes) > 0) { $codes = implode(",", $allowCodes); } else { $codes = ""; } } COption::SetOptionString("im", "allow_send_to_general_chat_all", $allow); COption::SetOptionString("im", "allow_send_to_general_chat_rights", $codes); if ($prevAllow != $allow || $prevCodes != $codes) { if (CModule::IncludeModule('pull')) { CPullStack::AddShared(Array( 'module_id' => 'im', 'command' => 'generalChatAccess', 'params' => Array( "status" => $prevAllow == 'Y' && $allow == 'N'? 'blocked': 'allowed' ), 'extra' => \Bitrix\Im\Common::getPullExtra() )); } } return true; } public static function CanJoinGeneralChatId($userId) { $userId = intval($userId); if ($userId <= 0) return false; $chatId = self::GetGeneralChatId(); if ($chatId <= 0) return false; if (!IsModuleInstalled('intranet')) return false; global $DB; $res = $DB->Query("select ID from b_user_field where entity_id='USER' AND field_name='UF_DEPARTMENT'"); if ($result = $res->Fetch()) { $fieldId = intval($result['ID']); } else { return false; } $result = false; $sql = " SELECT UU.ID, U.ACTIVE, U.EXTERNAL_AUTH_ID FROM b_utm_user UU LEFT JOIN b_user U ON U.ID = UU.VALUE_ID WHERE UU.VALUE_ID = ".$userId." and UU.FIELD_ID = ".$fieldId." and UU.VALUE_INT > 0"; $res = $DB->Query($sql); if ($row = $res->Fetch()) { $result = $row['ACTIVE'] == 'Y'; } return $result; } public static function linkGeneralChatId($chatId) { COption::SetOptionInt("im", "general_chat_id", $chatId); if (CModule::IncludeModule('pull')) { CPullStack::AddShared(Array( 'module_id' => 'im', 'command' => 'generalChatId', 'params' => Array( "id" => $chatId ), 'extra' => \Bitrix\Im\Common::getPullExtra() )); } return true; } public static function UnlinkGeneralChatId() { COption::RemoveOption("im", "general_chat_id"); if (CModule::IncludeModule('pull')) { CPullStack::AddShared(Array( 'module_id' => 'im', 'command' => 'generalChatId', 'params' => Array( "id" => 0 ), 'extra' => \Bitrix\Im\Common::getPullExtra() )); } return true; } public static function GetChatData($arParams = Array()) { global $DB; $arParams['PHOTO_SIZE'] = isset($arParams['PHOTO_SIZE'])? intval($arParams['PHOTO_SIZE']): 200; $from = " FROM b_im_relation R1 INNER JOIN b_im_chat C ON C.ID = R1.CHAT_ID "; if (isset($arParams['SKIP_PRIVATE']) && $arParams['SKIP_PRIVATE'] == 'Y') { $from .= " AND C.TYPE IN ('".IM_MESSAGE_OPEN."','".IM_MESSAGE_CHAT."','".IM_MESSAGE_OPEN_LINE."')"; } $innerJoin = $whereUser = ""; if (isset($arParams['GET_LIST']) && $arParams['GET_LIST'] == 'Y') { if (!isset($arParams['USER_ID'])) return false; $innerJoin = "INNER JOIN b_im_relation R2 ON R2.CHAT_ID = C.ID"; $whereGeneral = "WHERE R2.USER_ID = ".intval($arParams['USER_ID']); } else { $arFilter = Array(); if (isset($arParams['ID']) && is_array($arParams['ID'])) { foreach ($arParams['ID'] as $key => $value) $arFilter['ID'][$key] = intval($value); } else if (isset($arParams['ID']) && intval($arParams['ID']) > 0) { $arFilter['ID'][] = intval($arParams['ID']); } if (empty($arFilter['ID'])) { return false; } if (isset($arParams['USER_ID'])) { $innerJoin = "LEFT JOIN b_im_relation R2 ON R2.CHAT_ID = C.ID AND R2.USER_ID = ".intval($arParams['USER_ID']); } $whereGeneral = "WHERE R1.CHAT_ID IN (".implode(',', $arFilter['ID']).") "; } $strSql = " SELECT C.ID CHAT_ID, C.TITLE CHAT_TITLE, C.CALL_TYPE CHAT_CALL_TYPE, C.AUTHOR_ID CHAT_OWNER_ID, C.CALL_NUMBER CHAT_CALL_NUMBER, C.EXTRANET CHAT_EXTRANET, C.COLOR CHAT_COLOR, C.TYPE CHAT_TYPE, C.AVATAR, C.ENTITY_TYPE, C.ENTITY_DATA_1 ENTITY_DATA_1, C.ENTITY_DATA_2 ENTITY_DATA_2, C.ENTITY_DATA_3 ENTITY_DATA_3, A.ALIAS ALIAS_NAME, ".$DB->DatetimeToTimestampFunction('C.DATE_CREATE')." CHAT_DATE_CREATE, C.ENTITY_ID, R1.NOTIFY_BLOCK RELATION_NOTIFY_BLOCK, R1.USER_ID RELATION_USER_ID, R1.CALL_STATUS, R1.MANAGER RELATION_MANAGER ".(isset($arParams['USER_ID'])? ", R2.ID RID": "")." ".$from." ".$innerJoin." LEFT JOIN b_im_alias A ON A.ENTITY_ID = C.ID AND A.ENTITY_TYPE = C.ENTITY_TYPE ".$whereGeneral." "; $arChat = Array(); $arLines = Array(); $arUserInChat = Array(); $arUserCallStatus = Array(); $arUserChatBlockStatus = Array(); $arManagerList = Array(); $enableOpenChat = CIMMessenger::CheckEnableOpenChat(); $generalChatId = CIMChat::GetGeneralChatId(); $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); while ($arRes = $dbRes->GetNext(true, false)) { $arRes['CHAT_TYPE'] = trim($arRes['CHAT_TYPE']); if (isset($arParams['USER_ID'])) { if ($arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN) { if (!$enableOpenChat) { continue; } else if (intval($arRes['RID']) <= 0 && IM\User::getInstance($arParams['USER_ID'])->isExtranet()) { continue; } } else if (intval($arRes['RID']) <= 0) { continue; } } $arRes["RELATION_USER_ID"] = (int)$arRes["RELATION_USER_ID"]; if (!isset($arChat[$arRes["CHAT_ID"]])) { $avatar = '/bitrix/js/im/images/blank.gif'; if (intval($arRes["AVATAR"]) > 0) { $avatar = self::GetAvatarImage($arRes["AVATAR"], $arParams['PHOTO_SIZE']); } $chatType = \Bitrix\Im\Chat::getType($arRes); if ($arRes["ENTITY_TYPE"] == 'LINES') { $fieldData = explode("|", $arRes['ENTITY_DATA_1']); $arLines[$arRes["CHAT_ID"]] = $fieldData[5]; } else if ($generalChatId == $arRes['CHAT_ID']) { $arRes["ENTITY_TYPE"] = 'GENERAL'; } $publicOption = ''; if ($arRes['ALIAS_NAME']) { $publicOption = [ 'code' => $arRes['ALIAS_NAME'], 'link' => IM\Alias::getPublicLink($arRes['ENTITY_TYPE'], $arRes['ALIAS_NAME']) ]; } $arChat[$arRes["CHAT_ID"]] = Array( 'id' => $arRes["CHAT_ID"], 'name' => \Bitrix\Im\Text::decodeEmoji($arRes["CHAT_TITLE"]), 'owner' => $arRes["CHAT_OWNER_ID"], 'color' => $arRes["CHAT_COLOR"] == ""? IM\Color::getColorByNumber($arRes['CHAT_ID']): IM\Color::getColor($arRes['CHAT_COLOR']), 'extranet' => $arRes["CHAT_EXTRANET"] == ""? "": ($arRes["CHAT_EXTRANET"] == "Y"? true: false), 'avatar' => $avatar, 'call' => trim($arRes["CHAT_CALL_TYPE"]), 'call_number' => trim($arRes["CHAT_CALL_NUMBER"]), 'entity_type' => trim($arRes["ENTITY_TYPE"]), 'entity_id' => trim($arRes["ENTITY_ID"]), 'entity_data_1' => trim($arRes["ENTITY_DATA_1"]), 'entity_data_2' => trim($arRes["ENTITY_DATA_2"]), 'entity_data_3' => trim($arRes["ENTITY_DATA_3"]), 'public' => $publicOption, 'mute_list' => array(), 'manager_list' => array(), 'date_create' => $arRes["CHAT_DATE_CREATE"]? \Bitrix\Main\Type\DateTime::createFromTimestamp($arRes["CHAT_DATE_CREATE"]): false, 'type' => $chatType, 'message_type' => $arRes["CHAT_TYPE"], ); } $arUserInChat[$arRes["CHAT_ID"]][] = $arRes["RELATION_USER_ID"]; $arUserChatBlockStatus[$arRes["CHAT_ID"]][$arRes["RELATION_USER_ID"]] = $arRes["RELATION_NOTIFY_BLOCK"] == 'Y'; $arUserCallStatus[$arRes["CHAT_ID"]][$arRes["RELATION_USER_ID"]] = trim($arRes["CALL_STATUS"]); $arChat[$arRes["CHAT_ID"]]['mute_list'] = $arUserChatBlockStatus[$arRes["CHAT_ID"]]; if ($arRes["RELATION_MANAGER"] == 'Y') { $arManagerList[$arRes["CHAT_ID"]][] = (int)$arRes["RELATION_USER_ID"]; } $arChat[$arRes["CHAT_ID"]]['manager_list'] = $arManagerList[$arRes["CHAT_ID"]] ?? null; } foreach ($arUserInChat as $chatId => $userIds) { $arUserInChat[$chatId] = array_values(array_unique($userIds)); } $lines = Array(); if (!empty($arLines) && CModule::IncludeModule('imopenlines')) { $orm = \Bitrix\Imopenlines\Model\SessionTable::getList(Array( 'select' => Array('CHAT_ID', 'ID', 'STATUS', 'DATE_CREATE'), 'filter' => Array( '=ID' => array_values($arLines) ) )); while($row = $orm->fetch()) { $lines[$row['CHAT_ID']] = Array( 'id' => (int)$row['ID'], 'status' => (int)$row['STATUS'], 'date_create' => $row['DATE_CREATE'], ); } } $result = array( 'chat' => $arChat, 'lines' => $lines, 'userInChat' => $arUserInChat, 'userCallStatus' => $arUserCallStatus, 'userChatBlockStatus' => $arUserChatBlockStatus ); return $result; } public static function GetOpenChatData($arParams = Array()) { global $DB; $arParams['PHOTO_SIZE'] = isset($arParams['PHOTO_SIZE'])? intval($arParams['PHOTO_SIZE']): 100; $existsSql = "SELECT R3.ID FROM b_im_relation R3 WHERE R3.CHAT_ID = C.ID"; if ($DB->type == "MYSQL") { $existsSql .= ' LIMIT 1'; } $strSql = " SELECT C.ID CHAT_ID, C.TITLE CHAT_TITLE, C.CALL_TYPE CHAT_CALL_TYPE, C.AUTHOR_ID CHAT_OWNER_ID, C.CALL_NUMBER CHAT_CALL_NUMBER, C.EXTRANET CHAT_EXTRANET, C.COLOR CHAT_COLOR, C.TYPE CHAT_TYPE, C.AVATAR, C.ENTITY_TYPE, C.ENTITY_DATA_1, C.ENTITY_DATA_2, C.ENTITY_DATA_3, ".$DB->DatetimeToTimestampFunction('C.DATE_CREATE')." CHAT_DATE_CREATE, C.ENTITY_ID, R2.NOTIFY_BLOCK RELATION_NOTIFY_BLOCK, R2.USER_ID RELATION_USER_ID, R2.USER_ID RELATION_MANAGER, R2.CALL_STATUS, R2.ID RID FROM b_im_chat C LEFT JOIN b_im_relation R2 ON R2.CHAT_ID = C.ID AND R2.USER_ID = ".intval($arParams['USER_ID'])." WHERE C.TYPE = '".IM_MESSAGE_OPEN."' AND EXISTS(".$existsSql.") "; $arChat = Array(); $arUserInChat = Array(); $arUserCallStatus = Array(); $arUserChatBlockStatus = Array(); $arManagerList = Array(); $generalChatId = CIMChat::GetGeneralChatId(); $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); while ($arRes = $dbRes->GetNext(true, false)) { if (intval($arRes['RID']) <= 0 && IM\User::getInstance($arParams['USER_ID'])->isExtranet()) { continue; } $arRes['CHAT_TYPE'] = trim($arRes['CHAT_TYPE']); if (!isset($arChat[$arRes["CHAT_ID"]])) { $avatar = '/bitrix/js/im/images/blank.gif'; if (intval($arRes["AVATAR"]) > 0) { $avatar = self::GetAvatarImage($arRes["AVATAR"], $arParams['PHOTO_SIZE']); } $chatType = \Bitrix\Im\Chat::getType($arRes); if ($generalChatId == $arRes['CHAT_ID']) { $arRes["ENTITY_TYPE"] = 'GENERAL'; } $arChat[$arRes["CHAT_ID"]] = Array( 'id' => $arRes["CHAT_ID"], 'name' => \Bitrix\Im\Text::decodeEmoji($arRes["CHAT_TITLE"]), 'owner' => $arRes["CHAT_OWNER_ID"], 'color' => $arRes["CHAT_COLOR"] == ""? IM\Color::getColorByNumber($arRes['CHAT_ID']): IM\Color::getColor($arRes['CHAT_COLOR']), 'extranet' => $arRes["CHAT_EXTRANET"] == ""? "": ($arRes["CHAT_EXTRANET"] == "Y"? true: false), 'avatar' => $avatar, 'call' => trim($arRes["CHAT_CALL_TYPE"]), 'call_number' => trim($arRes["CHAT_CALL_NUMBER"]), 'entity_type' => trim($arRes["ENTITY_TYPE"]), 'entity_data_1' => trim($arRes["ENTITY_DATA_1"]), 'entity_data_2' => trim($arRes["ENTITY_DATA_2"]), 'entity_data_3' => trim($arRes["ENTITY_DATA_3"]), 'mute_list' => array(), 'manager_list' => array(), 'date_create' => $arRes["CHAT_DATE_CREATE"]? \Bitrix\Main\Type\DateTime::createFromTimestamp($arRes["CHAT_DATE_CREATE"]): false, 'entity_id' => trim($arRes["ENTITY_ID"]), 'type' => $chatType, 'message_type' => $arRes["CHAT_TYPE"], ); } $arUserChatBlockStatus[$arRes["CHAT_ID"]][$arRes["RELATION_USER_ID"]] = $arRes['RELATION_NOTIFY_BLOCK'] == 'Y'; $arUserInChat[$arRes["CHAT_ID"]][] = $arRes["RELATION_USER_ID"]; $arUserCallStatus[$arRes["CHAT_ID"]][$arRes["RELATION_USER_ID"]] = trim($arRes["CALL_STATUS"] ?? ''); $arChat[$arRes["CHAT_ID"]]['mute_list'] = $arUserChatBlockStatus[$arRes["CHAT_ID"]]; if ($arRes["RELATION_MANAGER"] == 'Y') { $arManagerList[$arRes["CHAT_ID"]][] = (int)$arRes["RELATION_USER_ID"]; } $arChat[$arRes["CHAT_ID"]]['manager_list'] = $arManagerList[$arRes["CHAT_ID"]] ?? null; } $result = array( 'chat' => $arChat, 'userInChat' => $arUserInChat, 'userCallStatus' => $arUserCallStatus, 'userChatBlockStatus' => $arUserChatBlockStatus ); return $result; } public function SetReadMessage($chatId, $lastId = null, $byEvent = false) { global $DB; $chatId = intval($chatId); if ($chatId <= 0) return false; CIMMessenger::SpeedFileDelete($this->user_id, IM_SPEED_GROUP); $chat = IM\V2\Chat::getInstance($chatId); if ( $chat->getType() == IM_MESSAGE_OPEN_LINE && $chat->getAuthorId() == 0 ) { return false; } $readService = new IM\V2\Message\ReadService($this->user_id); $startId = $readService->getLastIdByChatId($chatId); $counter = 0; if (isset($lastId)) { $message = new \Bitrix\Im\V2\Message(); $message->setMessageId((int)$lastId)->setChatId($chatId); $counter = $readService->readTo($message)->getResult()['COUNTER']; } else { $counter = $readService->readAllInChat($chatId)->getResult()['COUNTER']; } $relation = CIMMessage::SetLastId($chatId, $this->user_id, 0); if (!$relation) { return false; } $endId = (int)($relation['LAST_ID'] ?? 0); /*\Bitrix\Main\Application::getConnection()->query( "UPDATE b_im_recent SET DATE_UPDATE = NOW() WHERE USER_ID = ".$this->user_id." AND ITEM_CID = ".intval($chatId) );*/ if (CModule::IncludeModule("pull")) { CIMNotify::DeleteBySubTag("IM_MESS_".$chatId.'_'.$this->user_id, false, false); CPushManager::DeleteFromQueueBySubTag($this->user_id, 'IM_MESS'); if ( $chat->getEntityType() == 'LIVECHAT' || !\Bitrix\Im\User::getInstance($this->user_id)->isConnector() ) { \Bitrix\Pull\Event::add($this->user_id, Array( 'module_id' => 'im', 'command' => 'readMessageChat', 'params' => Array( 'dialogId' => 'chat'.$chatId, 'chatId' => (int)$chatId, 'lastId' => $endId, 'counter' => $counter, 'muted' => $relation['NOTIFY_BLOCK'] === 'Y', 'unread' => Im\Recent::isUnread($this->user_id, $relation['MESSAGE_TYPE'], 'chat'.$chatId), 'lines' => $relation['MESSAGE_TYPE'] === IM_MESSAGE_OPEN_LINE, 'viewedMessages' => [(int)$lastId], ), 'extra' => \Bitrix\Im\Common::getPullExtra() )); } $arRelation = self::GetRelationById($chatId, false, true, false); unset($arRelation[$this->user_id]); $pushMessage = Array( 'module_id' => 'im', 'command' => 'readMessageChatOpponent', 'expiry' => 600, 'params' => Array( 'dialogId' => 'chat'.$chatId, 'chatId' => (int)$chatId, 'userId' => (int)$this->user_id, 'userName' => \Bitrix\Im\User::getInstance($this->user_id)->getFullName(false), 'lastId' => $endId, 'date' => date('c', time()), 'viewedMessages' => [(int)$lastId], 'chatMessageStatus' => $relation['CHAT_MESSAGE_STATUS'], ), 'extra' => \Bitrix\Im\Common::getPullExtra() ); if ($chat->getEntityType() == 'LINES') { foreach ($arRelation as $rel) { if ($rel["EXTERNAL_AUTH_ID"] == 'imconnector') { unset($arRelation[$rel["USER_ID"]]); } } } if (count($arRelation) < 200) { \Bitrix\Pull\Event::add(array_keys($arRelation), $pushMessage); if ($chat->getType() == IM_MESSAGE_OPEN || $chat->getType() == IM_MESSAGE_OPEN_LINE) { CPullWatch::AddToStack('IM_PUBLIC_'.$chatId, $pushMessage); } } } foreach(GetModuleEvents("im", "OnAfterChatRead", true) as $arEvent) { ExecuteModuleEventEx($arEvent, array(Array( 'CHAT_ID' => $chat->getChatId(), 'CHAT_ENTITY_TYPE' => $chat->getEntityType(), 'CHAT_ENTITY_ID' => $chat->getEntityId(), 'START_ID' => $startId, 'END_ID' => $endId, 'COUNT' => $relation['COUNTER'], 'USER_ID' => $this->user_id, 'BY_EVENT' => $byEvent ))); } return Array( 'DIALOG_ID' => 'chat'.$chatId, 'CHAT_ID' => (int)$chatId, 'LAST_ID' => $endId, 'COUNTER' => (int)$relation['COUNTER'] ); } public function SetUnReadMessage($chatId, $lastId) { //global $DB; $chatId = intval($chatId); if ($chatId <= 0) return false; $lastId = intval($lastId); if (intval($lastId) <= 0) return false; /*$result = Bitrix\Im\V2\Chat::getInstance($chatId)->unreadToMessage(new IM\V2\Message($lastId)); return $result->isSuccess();*/ $readService = new IM\V2\Message\ReadService($this->user_id); $endId = $readService->getLastMessageIdInChat($chatId); $relation = CIMMessage::SetLastIdForUnread($chatId, $this->user_id, $lastId); if ($relation) { $chat = Bitrix\Im\V2\Chat::getInstance($chatId); \Bitrix\Main\Application::getConnection()->query( "UPDATE b_im_recent SET DATE_UPDATE = NOW() WHERE USER_ID = ".$this->user_id." AND ITEM_CID = ".intval($chatId) ); CIMMessenger::SpeedFileDelete($this->user_id, IM_SPEED_GROUP); if (CModule::IncludeModule("pull")) { $lastMessageStatuses = $readService->getViewedService()->getMessageStatuses($chat->getLastMessages($endId, $lastId)); \Bitrix\Pull\Event::add($this->user_id, Array( 'module_id' => 'im', 'command' => 'unreadMessageChat', 'params' => Array( 'dialogId' => 'chat'.$chatId, 'chatId' => (int)$chatId, 'lastId' => $endId, 'date' => new \Bitrix\Main\Type\DateTime(), 'counter' => (int)$relation['COUNTER'], 'muted' => $relation['NOTIFY_BLOCK'] === 'Y', 'lines' => $relation['MESSAGE_TYPE'] === IM_MESSAGE_OPEN_LINE, 'unreadTo' => $lastId, 'unread' => Im\Recent::isUnread($this->user_id, $relation['MESSAGE_TYPE'], 'chat'.$chatId), 'lastMessageStatuses' => $lastMessageStatuses, 'lastMessageViews' => Im\Common::toJson($chat->getLastMessageViews()), ), 'push' => Array('badge' => 'Y'), 'extra' => \Bitrix\Im\Common::getPullExtra() )); $arRelation = self::GetRelationById($chatId, false, true, false); unset($arRelation[$this->user_id]); $pushMessage = Array( 'module_id' => 'im', 'command' => 'unreadMessageChatOpponent', 'expiry' => 600, 'params' => Array( 'dialogId' => 'chat'.$chatId, 'chatId' => (int)$chatId, 'userId' => (int)$this->user_id, 'chatMessageStatus' => $relation['CHAT_MESSAGE_STATUS'], 'unreadTo' => $lastId, 'lastMessageStatuses' => $lastMessageStatuses, ), 'extra' => \Bitrix\Im\Common::getPullExtra() ); if ($chat->getEntityType() == 'LINES') { foreach ($arRelation as $rel) { if ($rel["EXTERNAL_AUTH_ID"] == 'imconnector') { unset($arRelation[$rel["USER_ID"]]); } } } $viewsByGroups = $chat->getLastMessageViewsByGroups(); foreach ($viewsByGroups as $view) { $pushMessage['params']['lastMessageViews'] = Im\Common::toJson($view['VIEW_INFO']); $usersForPush = array_keys($arRelation); $recipient = array_intersect($usersForPush, $view['USERS']); \Bitrix\Pull\Event::add($recipient, $pushMessage); } /*\Bitrix\Pull\Event::add(array_keys($arRelation), $pushMessage); if ($chat->getType() == IM_MESSAGE_OPEN || $chat->getType() == IM_MESSAGE_OPEN_LINE) { CPullWatch::AddToStack('IM_PUBLIC_'.$chatId, $pushMessage); }*/ } return true; } return false; } /** * @deprecated * @use .. * @param $arParams * @return array */ public function GetUnreadMessage($arParams = Array()) { global $DB; $bSpeedCheck = isset($arParams['SPEED_CHECK']) && $arParams['SPEED_CHECK'] == 'N'? false: true; $lastId = !isset($arParams['LAST_ID']) || $arParams['LAST_ID'] == null? null: intval($arParams['LAST_ID']); $loadDepartment = isset($arParams['LOAD_DEPARTMENT']) && $arParams['LOAD_DEPARTMENT'] == 'N'? false: true; $bTimeZone = isset($arParams['USE_TIME_ZONE']) && $arParams['USE_TIME_ZONE'] == 'N'? false: true; $bGroupByChat = isset($arParams['GROUP_BY_CHAT']) && $arParams['GROUP_BY_CHAT'] == 'Y'? true: false; $bUserLoad = isset($arParams['USER_LOAD']) && $arParams['USER_LOAD'] == 'N'? false: true; $bFileLoad = isset($arParams['FILE_LOAD']) && $arParams['FILE_LOAD'] == 'N'? false: true; $arExistUserData = isset($arParams['EXIST_USER_DATA']) && is_array($arParams['EXIST_USER_DATA'])? $arParams['EXIST_USER_DATA']: Array(); $messageType = isset($arParams['MESSAGE_TYPE']) && in_array($arParams['MESSAGE_TYPE'], Array(IM_MESSAGE_OPEN, IM_MESSAGE_CHAT, IM_MESSAGE_OPEN_LINE))? $arParams['MESSAGE_TYPE']: 'ALL'; $arMessages = Array(); $arUnreadMessage = Array(); $arUsersMessage = Array(); $arResult = Array( 'message' => Array(), 'unreadMessage' => Array(), 'usersMessage' => Array(), 'users' => Array(), 'userInGroup' => Array(), 'files' => Array(), 'countMessage' => 0, 'chat' => Array(), 'userChatBlockStatus' => Array(), 'userInChat' => Array(), 'result' => false ); $bLoadMessage = $bSpeedCheck? CIMMessenger::SpeedFileExists($this->user_id, IM_SPEED_GROUP): false; $count = CIMMessenger::SpeedFileGet($this->user_id, IM_SPEED_GROUP); if (!$bLoadMessage || ($bLoadMessage && intval($count) > 0)) { /*$ssqlLastId = "R1.LAST_ID"; $ssqlStatus = " AND R1.STATUS < ".IM_STATUS_READ; if (!is_null($lastId) && intval($lastId) > 0 && !CIMMessenger::CheckXmppStatusOnline()) { $ssqlLastId = intval($lastId); $ssqlStatus = ""; } $arRelations = Array(); if ($ssqlStatus <> '') { $strSql =" SELECT R1.USER_ID, R1.CHAT_ID, R1.LAST_ID FROM b_im_relation R1 WHERE R1.USER_ID = ".$this->user_id." ".($messageType == 'ALL'? "AND R1.MESSAGE_TYPE IN ('".IM_MESSAGE_OPEN."','".IM_MESSAGE_CHAT."','".IM_MESSAGE_OPEN_LINE."')": "AND R1.MESSAGE_TYPE = '".$messageType."'")." ".$ssqlStatus." "; $dbSubRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); while ($arRes = $dbSubRes->Fetch()) { //$ssqlLastId = intval($arRes['LAST_ID']); $arRelations[] = $arRes; } }*/ $arMessageId = Array(); $arMessageChatId = Array(); $arLastMessage = Array(); $arMark = Array(); $arChat = Array(); $arPrepareResult = Array(); $arFilteredResult = Array(); if (!$bTimeZone) CTimeZone::Disable(); $strSql = " SELECT M.ID, M.CHAT_ID, M.MESSAGE, ".$DB->DatetimeToTimestampFunction('M.DATE_CREATE')." DATE_CREATE, M.AUTHOR_ID, R1.MESSAGE_TYPE MESSAGE_TYPE FROM b_im_message M INNER JOIN b_im_relation R1 ON M.CHAT_ID = R1.CHAT_ID AND R1.USER_ID != M.AUTHOR_ID INNER JOIN b_im_message_unread MU ON M.ID = MU.MESSAGE_ID AND MU.USER_ID = " . $this->user_id . " WHERE R1.USER_ID = ".$this->user_id." ".($messageType == 'ALL'? "AND R1.MESSAGE_TYPE IN ('".IM_MESSAGE_OPEN."','".IM_MESSAGE_CHAT."','".IM_MESSAGE_OPEN_LINE."')": "AND R1.MESSAGE_TYPE = '".$messageType."'")." "; if (!$bTimeZone) CTimeZone::Enable(); $strSql = $DB->TopSql($strSql, 1000); $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); while ($arRes = $dbRes->Fetch()) { $arPrepareResult[$arRes['CHAT_ID']][$arRes['ID']] = $arRes; } foreach ($arPrepareResult as $chatId => $arRes) { if (count($arPrepareResult[$chatId]) > 100) { $arPrepareResult[$chatId] = array_slice($arRes, -100, 100); } $arFilteredResult = array_merge($arFilteredResult, $arPrepareResult[$chatId]); } unset($arPrepareResult); foreach ($arFilteredResult as $arRes) { $arUsers[] = $arRes['AUTHOR_ID']; $arMessages[$arRes['ID']] = Array( 'id' => $arRes['ID'], 'chatId' => $arRes['CHAT_ID'], 'senderId' => $arRes['AUTHOR_ID'], 'recipientId' => $arRes['CHAT_ID'], 'date' => \Bitrix\Main\Type\DateTime::createFromTimestamp($arRes['DATE_CREATE']), 'text' => $arRes['MESSAGE'], 'messageType' => $arRes['MESSAGE_TYPE'], ); if ($bGroupByChat) { $arMessages[$arRes['ID']]['conversation'] = $arRes['CHAT_ID']; $arMessages[$arRes['ID']]['unread'] = $this->user_id != $arRes['AUTHOR_ID']? 'Y': 'N'; } else { $arUsersMessage[$arRes['CHAT_ID']][] = $arRes['ID']; } /*if ($arRes['R1_STATUS'] == IM_STATUS_UNREAD && (!isset($arMark[$arRes["CHAT_ID"]]) || $arMark[$arRes["CHAT_ID"]] < $arRes["ID"])) $arMark[$arRes["CHAT_ID"]] = $arRes["ID"];*/ if (!isset($arLastMessage[$arRes["CHAT_ID"]]) || $arLastMessage[$arRes["CHAT_ID"]] < $arRes["ID"]) $arLastMessage[$arRes["CHAT_ID"]] = $arRes["ID"]; $arChat[$arRes["CHAT_ID"]] = $arRes["CHAT_ID"]; $arMessageId[] = $arRes['ID']; $arMessageChatId[$arRes['CHAT_ID']][$arRes["ID"]] = $arRes["ID"]; } $params = CIMMessageParam::Get($arMessageId); if ($bFileLoad) { foreach ($arMessageChatId as $chatId => $messages) { $files = Array(); foreach ($messages as $messageId) { $arMessages[$messageId]['params'] = $params[$messageId]; if (isset($params[$messageId]['FILE_ID'])) { foreach ($params[$messageId]['FILE_ID'] as $fileId) { $files[$fileId] = $fileId; } } } $arMessageFiles = CIMDisk::GetFiles($chatId, $files); foreach ($arMessageFiles as $key => $value) { $arResult['files'][$chatId][$key] = $value; } } } else { foreach ($params as $messageId => $param) { $arMessages[$messageId]['params'] = $param; } } if (!empty($arMessages)) { foreach ($arMark as $chatId => $lastSendId) CIMMessage::SetLastSendId($chatId, $this->user_id, $lastSendId); } if ($bGroupByChat) { foreach ($arMessages as $key => $value) { $arMessages[$arLastMessage[$value['conversation']]]['counter']++; if ($arLastMessage[$value['conversation']] != $value['id']) { unset($arMessages[$key]); } else { $arMessages[$key]['text'] = \Bitrix\Im\Text::parse($value['text']); $arMessages[$key]['textLegacy'] = \Bitrix\Im\Text::parseLegacyFormat($value['text']); $arUsersMessage[$value['conversation']][] = $value['id']; if ($value['params']['NOTIFY'] === 'N' || is_array($value['params']['NOTIFY']) && !in_array($this->user_id, $value['params']['NOTIFY'])) { // skip unread } else if ($value['unread'] == 'Y') { $arUnreadMessage[$value['conversation']][] = $value['id']; } unset($arMessages[$key]['conversation']); unset($arMessages[$key]['unread']); } } } else { foreach ($arMessages as $key => $value) { $arMessages[$key]['text'] = \Bitrix\Im\Text::parse($value['text']); $arMessages[$key]['textLegacy'] = \Bitrix\Im\Text::parseLegacyFormat($value['text']); if ($value['params']['NOTIFY'] === 'N' || is_array($value['params']['NOTIFY']) && !in_array($this->user_id, $value['params']['NOTIFY'])) { // skip unread } else if ($this->user_id != $value['senderId']) { $arUnreadMessage[$value['chatId']][] = $value['id']; } } } $arResult['message'] = $arMessages; $arResult['unreadMessage'] = $arUnreadMessage; $arResult['usersMessage'] = $arUsersMessage; $arChat = self::GetChatData(array( 'ID' => $arChat, 'USE_CACHE' => 'N' )); if (!empty($arChat)) { $arResult['lines'] = $arChat['lines']; $arResult['chat'] = $arChat['chat']; $arResult['userChatBlockStatus'] = $arChat['userChatBlockStatus']; $arResult['userInChat'] = $arChat['userInChat']; foreach ($arChat['userInChat'] as $value) $arUsers[] = $value; } if ($bUserLoad && !empty($arUsers)) { $arUserData = CIMContactList::GetUserData(Array('ID' => array_diff(array_unique($arUsers), $arExistUserData), 'DEPARTMENT' => ($loadDepartment? 'Y': 'N'))); $arResult['users'] = $arUserData['users']; $arResult['userInGroup'] = $arUserData['userInGroup']; } else { $arResult['users'] = Array(); $arResult['userInGroup'] = Array(); $arResult['userInGroup'] = Array(); } $arResult['countMessage'] = CIMMessenger::GetMessageCounter($this->user_id, $arResult); if (!$bGroupByChat) CIMMessenger::SpeedFileCreate($this->user_id, $arResult['countMessage'], IM_SPEED_GROUP); $arResult['result'] = true; } else { $arResult['countMessage'] = CIMMessenger::GetMessageCounter($this->user_id, $arResult); } return $arResult; } public function SetOwner($chatId, $userId, $checkPermission = true) { $chatId = intval($chatId); $userId = intval($userId); $chat = IM\Model\ChatTable::getById($chatId)->fetch(); if (!$chat) return false; if ($checkPermission && $chat['AUTHOR_ID'] != $this->user_id) return false; if ($userId == $chat['AUTHOR_ID']) return true; $arRelation = self::GetRelationById($chatId, false, true, false); if (!isset($arRelation[$userId])) return false; IM\Model\ChatTable::update($chatId, Array('AUTHOR_ID' => $userId)); IM\Model\RelationTable::update($arRelation[$userId]['ID'], Array('MANAGER' => 'Y')); if (isset($arRelation[$chat['AUTHOR_ID']])) { IM\Model\RelationTable::update($arRelation[$chat['AUTHOR_ID']]['ID'], Array('MANAGER' => 'N')); } if (CModule::IncludeModule('pull')) { \Bitrix\Pull\Event::add(array_keys($arRelation), Array( 'module_id' => 'im', 'command' => 'chatOwner', 'params' => Array( 'dialogId' => 'chat'.$chatId, 'chatId' => (int)$chatId, 'userId' => $userId ), 'extra' => \Bitrix\Im\Common::getPullExtra() )); } return true; } public function SetDescription($chatId, $description) { \Bitrix\Im\Model\ChatTable::update($chatId, Array( 'DESCRIPTION' => $description )); if (CModule::IncludeModule('pull')) { $arRelation = self::GetRelationById($chatId, false, true, false); \Bitrix\Pull\Event::add(array_keys($arRelation), Array( 'module_id' => 'im', 'command' => 'chatDescription', 'params' => Array( 'chatId' => $chatId, 'description' => \Bitrix\Im\Text::parse($description) ), 'extra' => \Bitrix\Im\Common::getPullExtra() )); } return true; } public static function SetChatParams($chatId, $params) { $update = []; if (isset($params['ENTITY_TYPE'])) $update['ENTITY_TYPE'] = $params['ENTITY_TYPE']; if (isset($params['ENTITY_ID'])) $update['ENTITY_ID'] = $params['ENTITY_ID']; if (isset($params['ENTITY_DATA_1'])) $update['ENTITY_DATA_1'] = $params['ENTITY_DATA_1']; if (isset($params['ENTITY_DATA_2'])) $update['ENTITY_DATA_2'] = $params['ENTITY_DATA_2']; if (isset($params['ENTITY_DATA_3'])) $update['ENTITY_DATA_3'] = $params['ENTITY_DATA_3']; \Bitrix\Im\Model\ChatTable::update($chatId, $update); if (CModule::IncludeModule('pull')) { if (isset($update['NAME'])) { $update['NAME'] = htmlspecialcharsbx($update['NAME']); } $arRelation = self::GetRelationById($chatId, false, true, false); \Bitrix\Pull\Event::add(array_keys($arRelation), Array( 'module_id' => 'im', 'command' => 'chatUpdateParams', 'params' => Array( 'dialogId' => 'chat'.$chatId, 'chatId' => (int)$chatId, 'params' => array_change_key_case($update) ), 'extra' => \Bitrix\Im\Common::getPullExtra() )); } return true; } public function SetManager($chatId, $userId, $isManager = true, $checkPermission = true) { return $this->SetManagers($chatId, Array($userId => $isManager), $checkPermission); } public function SetManagers($chatId, $users, $checkPermission = true) { $chatId = intval($chatId); $chat = IM\Model\ChatTable::getById($chatId)->fetch(); if (!$chat) return false; if ($checkPermission && $chat['AUTHOR_ID'] != $this->user_id) return false; $relations = self::GetRelationById($chatId, false, true, false); foreach ($users as $userId => $status) { $userId = intval($userId); if ($userId == $chat['AUTHOR_ID'] || $userId <= 0) continue; if (!isset($relations[$userId])) continue; $relations[$userId]['MANAGER'] = $status? 'Y': 'N'; IM\Model\RelationTable::update($relations[$userId]['ID'], Array('MANAGER' => $status)); } $managers = []; foreach ($relations as $relation) { if ($relation['MANAGER'] === 'Y' || $relation['USER_ID'] == $chat['AUTHOR_ID']) { $managers[] = (int)$relation['USER_ID']; } } if (CModule::IncludeModule('pull')) { \Bitrix\Pull\Event::add(array_keys($relations), Array( 'module_id' => 'im', 'command' => 'chatManagers', 'params' => Array( 'dialogId' => 'chat'.$chatId, 'chatId' => (int)$chatId, 'list' => $managers ), 'extra' => \Bitrix\Im\Common::getPullExtra() )); } return true; } public function SetColor($chatId, $color) { global $DB; $chatId = intval($chatId); $color = ToUpper($color); if ($chatId <= 0 || !IM\Color::isSafeColor($color)) return false; $strSql = " SELECT R.CHAT_ID, C.COLOR CHAT_COLOR, C.AUTHOR_ID CHAT_AUTHOR_ID, C.TYPE CHAT_TYPE, C.ENTITY_TYPE CHAT_ENTITY_TYPE, C.ENTITY_ID CHAT_ENTITY_ID FROM b_im_relation R LEFT JOIN b_im_chat C ON R.CHAT_ID = C.ID WHERE R.USER_ID = ".$this->user_id." AND R.MESSAGE_TYPE IN ('".IM_MESSAGE_OPEN."','".IM_MESSAGE_CHAT."','".IM_MESSAGE_OPEN_LINE."') AND R.CHAT_ID = ".$chatId; $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); if ($arRes = $dbRes->Fetch()) { $arRes['CHAT_TYPE'] = trim($arRes['CHAT_TYPE']); if ($arRes['CHAT_COLOR'] == $color) return false; IM\Model\ChatTable::update($chatId, array('COLOR' => $color)); CIMChat::AddSystemMessage(Array( 'CHAT_ID' => $chatId, 'USER_ID' => $this->user_id, 'MESSAGE_CODE' => 'IM_CHAT_CHANGE_COLOR_', 'MESSAGE_REPLACE' => Array('#CHAT_COLOR#' => IM\Color::getName($color)) )); $ar = CIMChat::GetRelationById($chatId, false, true, false); if ($arRes['CHAT_ENTITY_TYPE'] == 'LINES') { foreach ($ar as $rel) { if ($rel["EXTERNAL_AUTH_ID"] == 'imconnector') { unset($ar[$rel["USER_ID"]]); } } } if ($arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN) { CIMContactList::CleanAllChatCache(); } else { foreach ($ar as $rel) { CIMContactList::CleanChatCache($rel['USER_ID']); } } if (CModule::IncludeModule("pull")) { $arPushMessage = Array( 'module_id' => 'im', 'command' => 'chatChangeColor', 'expiry' => 3600, 'params' => Array( 'chatId' => $chatId, 'color' => IM\Color::getColor($color), ), 'extra' => \Bitrix\Im\Common::getPullExtra() ); \Bitrix\Pull\Event::add(array_keys($ar), $arPushMessage); if ($arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN || $arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN_LINE) { CPullWatch::AddToStack('IM_PUBLIC_'.$chatId, $arPushMessage); } } return true; } return false; } public function SetAvatarId($chatId, $fileId) { if ($chatId <= 0) return false; $orm = \Bitrix\Im\Model\ChatTable::getById($chatId); $chat = $orm->fetch(); if (!$chat) return false; if ($fileId > 0) { $orm = \Bitrix\Main\FileTable::getById($fileId); $file = $orm->fetch(); if (!$file) return false; if ($file['HEIGHT'] <= 0 || $file['WIDTH'] <= 0) return false; } IM\Model\ChatTable::update($chatId, Array('AVATAR' => $fileId)); if (CModule::IncludeModule('pull')) { $relation = self::GetRelationById($chatId, false, true, false); $users = []; foreach ($relation as $rel) { if ($rel["EXTERNAL_AUTH_ID"] != 'imconnector') { $users[$rel['USER_ID']]; } } \Bitrix\Pull\Event::add($users, Array( 'module_id' => 'im', 'command' => 'chatAvatar', 'params' => Array( 'chatId' => $chatId, 'avatar' => self::GetAvatarImage($fileId), ), 'extra' => \Bitrix\Im\Common::getPullExtra() )); } return true; } public function Rename($chatId, $title, $checkPermission = true, $sendMessage = true) { global $DB; $chatId = intval($chatId); $title = mb_substr(trim($title), 0, 255); if ($chatId <= 0 || $title == '') return false; if ($checkPermission) { $strSql = " SELECT R.CHAT_ID, C.TITLE CHAT_TITLE, C.AUTHOR_ID CHAT_AUTHOR_ID, C.TYPE CHAT_TYPE, C.ENTITY_TYPE CHAT_ENTITY_TYPE, C.ENTITY_ID CHAT_ENTITY_ID, R.MANAGER IS_MANAGER FROM b_im_relation R LEFT JOIN b_im_chat C ON R.CHAT_ID = C.ID WHERE R.USER_ID = ".$this->user_id." AND R.MESSAGE_TYPE IN ('".IM_MESSAGE_OPEN."','".IM_MESSAGE_CHAT."','".IM_MESSAGE_OPEN_LINE."') AND R.CHAT_ID = ".$chatId; } else { $strSql = " SELECT C.ID CHAT_ID, C.TITLE CHAT_TITLE, C.AUTHOR_ID CHAT_AUTHOR_ID, C.TYPE CHAT_TYPE, C.ENTITY_TYPE CHAT_ENTITY_TYPE, C.ENTITY_ID CHAT_ENTITY_ID, 'Y' IS_MANAGER FROM b_im_chat C WHERE C.ID = ".$chatId." AND C.TYPE IN ('".IM_MESSAGE_OPEN."','".IM_MESSAGE_CHAT."','".IM_MESSAGE_OPEN_LINE."')"; } $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); if ($arRes = $dbRes->Fetch()) { $arRes['CHAT_TITLE'] = \Bitrix\Im\Text::decodeEmoji($arRes['CHAT_TITLE']); if ($arRes['CHAT_TITLE'] == $title) return false; if ($arRes['CHAT_ENTITY_TYPE'] === 'ANNOUNCEMENT' && $arRes['IS_MANAGER'] !== 'Y') { return false; } $arRes['CHAT_TYPE'] = trim($arRes['CHAT_TYPE']); IM\Model\ChatTable::update($chatId, array('TITLE' => $title)); if ($sendMessage) { if ($checkPermission) { CIMChat::AddSystemMessage(Array( 'CHAT_ID' => $chatId, 'USER_ID' => $this->user_id, 'MESSAGE_CODE' => 'IM_CHAT_CHANGE_TITLE_', 'MESSAGE_REPLACE' => Array('#CHAT_TITLE#' => $title) )); } else { self::AddMessage(Array( "TO_CHAT_ID" => $chatId, "MESSAGE" => GetMessage("IM_CHAT_CHANGE_TITLE", Array('#CHAT_TITLE#' => $title)), "SYSTEM" => 'Y', )); } } $ar = CIMChat::GetRelationById($chatId, false, true, false); if ($arRes['CHAT_ENTITY_TYPE'] == 'LINES') { foreach ($ar as $rel) { if ($rel["EXTERNAL_AUTH_ID"] == 'imconnector') { unset($ar[$rel["USER_ID"]]); } } } if ($arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN) { CIMContactList::CleanAllChatCache(); } else { foreach ($ar as $rel) { CIMContactList::CleanChatCache($rel['USER_ID']); } } if (CModule::IncludeModule("pull")) { $pushMessage = Array( 'module_id' => 'im', 'command' => 'chatRename', 'params' => Array( 'chatId' => $chatId, 'name' => $title, ), 'extra' => \Bitrix\Im\Common::getPullExtra() ); \Bitrix\Pull\Event::add(array_keys($ar), $pushMessage); if ($arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN || $arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN_LINE) { CPullWatch::AddToStack('IM_PUBLIC_'.$chatId, $pushMessage); } } foreach(GetModuleEvents("im", "OnChatRename", true) as $arEvent) { ExecuteModuleEventEx($arEvent, array($chatId, $title, $arRes['CHAT_ENTITY_TYPE'], $arRes['CHAT_ENTITY_ID'], $this->user_id)); } return true; } return false; } /** * @param $arParams * @return array|false|int * @throws Exception * * @deprecated Use Bitrix\Im\V2\Chat\ChatFactory::addChat() * @see Bitrix\Im\V2\Chat\ChatFactory::addChat() */ public function Add($arParams) { $type = ''; if (isset($arParams['MESSAGE_TYPE'])) { $type = $arParams['MESSAGE_TYPE']; } elseif (isset($arParams['TYPE'])) { $type = $arParams['MESSAGE_TYPE'] = $arParams['TYPE']; } $arParams['USER_ID'] = $this->user_id; $authorId = $arParams['USER_ID']; if (isset($arParams['AUTHOR_ID'])) { $authorId = intval($arParams['AUTHOR_ID']); } if (isset($arParams['OWNER_ID'])) { $authorId = intval($arParams['OWNER_ID']); } if ($authorId) { $arParams['AUTHOR_ID'] = $authorId; } if (isset($arParams['AVATAR_ID'])) { $arParams['AVATAR'] = (int) $arParams['AVATAR_ID']; } $chatResult = IM\V2\Chat\ChatFactory::getInstance()->addChat($arParams); if (!$chatResult->isSuccess() || !$chatResult->hasResult()) { return false; } if (isset($arParams['MESSAGE'])) { $message = trim($arParams['MESSAGE']); } if (isset($message) && $message) { if ($type === IM\V2\Chat::IM_TYPE_PRIVATE) { CIMMessage::Add([ "FROM_USER_ID" => $this->user_id, "TO_USER_ID" => $this->user_id, "MESSAGE" => $message, ]); } else { self::AddMessage([ "TO_CHAT_ID" => $chatResult->getResult()['CHAT_ID'], "FROM_USER_ID" => $this->user_id, "SYSTEM" => $this->user_id ? 'N' : 'Y', "MESSAGE" => $message, ]); } } $chat = $chatResult->getResult()['CHAT']; CIMContactList::CleanAllChatCache(); return $chat->getChatId(); /** global $DB; $chatTitle = ''; if (isset($arParams['TITLE'])) $chatTitle = trim($arParams['TITLE']); $chatDescription = ''; if (isset($arParams['DESCRIPTION'])) $chatDescription = trim($arParams['DESCRIPTION']); $userId = Array(); if (isset($arParams['USERS'])) $userId = $arParams['USERS']; $callNumber = ''; if (isset($arParams['CALL_NUMBER'])) $callNumber = $arParams['CALL_NUMBER']; $avatarId = 0; if (isset($arParams['AVATAR_ID'])) $avatarId = intval($arParams['AVATAR_ID']); $authorId = $this->user_id; if (isset($arParams['AUTHOR_ID'])) $authorId = intval($arParams['AUTHOR_ID']); if (isset($arParams['OWNER_ID'])) $authorId = intval($arParams['OWNER_ID']); $parentId = 0; if (isset($arParams['PARENT_ID'])) $parentId = intval($arParams['PARENT_ID']); $parentMid = 0; if (isset($arParams['PARENT_MID'])) $parentMid = intval($arParams['PARENT_MID']); $pinMessageId = 0; if (isset($arParams['PIN_MESSAGE_ID'])) $pinMessageId = intval($arParams['PIN_MESSAGE_ID']); $managers = array(); if (isset($arParams['MANAGERS'])) $managers = $arParams['MANAGERS']; $entityType = ''; if (isset($arParams['ENTITY_TYPE'])) $entityType = $arParams['ENTITY_TYPE']; $entityId = ''; if (isset($arParams['ENTITY_ID'])) $entityId = $arParams['ENTITY_ID']; $entityData1 = ''; if (isset($arParams['ENTITY_DATA_1'])) $entityData1 = $arParams['ENTITY_DATA_1']; $entityData2 = ''; if (isset($arParams['ENTITY_DATA_2'])) $entityData2 = $arParams['ENTITY_DATA_2']; $entityData3 = ''; if (isset($arParams['ENTITY_DATA_3'])) $entityData3 = $arParams['ENTITY_DATA_3']; $message = ''; if (isset($arParams['MESSAGE'])) $message = trim($arParams['MESSAGE']); $color = ''; if (isset($arParams['COLOR']) && IM\Color::isSafeColor($arParams['COLOR'])) $color = $arParams['COLOR']; $skipAddMessage = isset($arParams['SKIP_ADD_MESSAGE']) && $arParams['SKIP_ADD_MESSAGE'] === 'Y'; $type = IM_MESSAGE_CHAT; if (isset($arParams['TYPE']) && in_array($arParams['TYPE'], Array(IM_MESSAGE_OPEN, IM_MESSAGE_CHAT, IM_MESSAGE_PRIVATE, IM_MESSAGE_OPEN_LINE))) { if (!CIMMessenger::CheckEnableOpenChat() && $arParams['TYPE'] == IM_MESSAGE_OPEN) { $type = IM_MESSAGE_CHAT; } else if ($this->user_id == 0 || !IM\User::getInstance($this->user_id)->isExtranet()) { $type = $arParams['TYPE']; } } $skipUserAdd = false; if ($userId === false) { $skipUserAdd = true; } $arUserId = Array(); if ($this->user_id > 0) { $arUserId[$this->user_id] = $this->user_id; } if (is_array($userId)) { $arUserId += \CIMContactList::PrepareUserIds($userId); } else if (intval($userId) > 0) { $arUserId[intval($userId)] = intval($userId); } if (!$skipUserAdd) { if (count($arUserId) < 1) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_MIN_USER"), "MIN_USER"); return false; } if (false && count($arUserId) > 500) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_MAX_USER", Array('#COUNT#' => 500)), "MAX_USER"); return false; } if ( $entityType != 'PERSONAL' && !IsModuleInstalled('intranet') && CModule::IncludeModule('socialnetwork') && CSocNetUser::IsFriendsAllowed() ) { $arFriendUsers = Array(); $dbFriends = CSocNetUserRelations::GetList(array(),array("USER_ID" => $this->user_id, "RELATION" => SONET_RELATIONS_FRIEND), false, false, array("ID", "FIRST_USER_ID", "SECOND_USER_ID", "DATE_CREATE", "DATE_UPDATE", "INITIATED_BY")); while ($arFriends = $dbFriends->Fetch()) { $friendId = $this->user_id == $arFriends["FIRST_USER_ID"]? $arFriends["SECOND_USER_ID"]: $arFriends["FIRST_USER_ID"]; $arFriendUsers[$friendId] = $friendId; } foreach ($arUserId as $id => $userId) { if ($userId == $this->user_id) continue; if (!isset($arFriendUsers[$userId]) && CIMSettings::GetPrivacy(CIMSettings::PRIVACY_CHAT, $userId) == CIMSettings::PRIVACY_RESULT_CONTACT) unset($arUserId[$id]); } if (count($arUserId) <= 1) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_MIN_USER_BY_PRIVACY"), "MIN_USER_BY_PRIVACY"); return false; } } } $arUsers = CIMContactList::GetUserData(array( 'ID' => array_values($arUserId), 'DEPARTMENT' => 'N', 'USE_CACHE' => 'N' )); $arUsers = is_array($arUsers['users'])? $arUsers['users']: Array(); $arUsersName = Array(); if ($chatDescription == '' && $type == IM_MESSAGE_OPEN) { $chatDescription = $message; } $chatColorCode = ""; if ($entityType === 'VIDEOCONF') { CGlobalCounter::Increment('im_videoconf_count', CGlobalCounter::ALL_SITES, false); $videoconfCount = CGlobalCounter::GetValue('im_videoconf_count', CGlobalCounter::ALL_SITES); if ($videoconfCount === 999) { CGlobalCounter::Set('im_videoconf_count', 1, CGlobalCounter::ALL_SITES, '', false); } } else if (IM\Color::isEnabled()) { if ($color) { $chatColorCode = $color; } else { CGlobalCounter::Increment('im_chat_color_id', CGlobalCounter::ALL_SITES, false); $chatColorId = CGlobalCounter::GetValue('im_chat_color_id', CGlobalCounter::ALL_SITES); $chatColorCode = \Bitrix\Im\Color::getCodeByNumber($chatColorId); CGlobalCounter::Increment('im_chat_color_'.$chatColorCode, CGlobalCounter::ALL_SITES, false); } $chatColorCodeCount = CGlobalCounter::GetValue('im_chat_color_'.$chatColorCode, CGlobalCounter::ALL_SITES); if ($chatColorCodeCount == 99) { CGlobalCounter::Set('im_chat_color_'.$chatColorCode, 1, CGlobalCounter::ALL_SITES, '', false); } } if ($chatTitle == "") { if ($entityType === 'VIDEOCONF') { $chatTitle = GetMessage('IM_VIDEOCONF_NAME_FORMAT_NEW', [ '#NUMBER#' => $videoconfCount ]); } else if (IM\Color::isEnabled()) { $chatTitle = GetMessage('IM_CHAT_NAME_FORMAT', Array( '#COLOR#' => \Bitrix\Im\Color::getName($chatColorCode), '#NUMBER#' => $chatColorCodeCount+1, )); } else { foreach ($arUserId as $userId) { $arUsersName[$userId] = htmlspecialcharsback($arUsers[$userId]['name']); } $chatTitle = implode(', ', $arUsersName); } } $isExtranet = false; if (!in_array($entityType, Array('LINES', 'LIVECHAT'))) { foreach ($arUsers as $userData) { if ($userData['extranet']) { $isExtranet = true; break; } } } $result = IM\Model\ChatTable::add(Array( "PARENT_ID" => $parentId, "PARENT_MID" => $parentMid, "PIN_MESSAGE_ID" => $pinMessageId, "TITLE" => mb_substr($chatTitle, 0, 255), "DESCRIPTION" => $chatDescription, "TYPE" => $type, "COLOR" => $chatColorCode, "AVATAR" => $avatarId, "AUTHOR_ID" => $authorId, "ENTITY_TYPE" => $entityType, "ENTITY_ID" => $entityId, "ENTITY_DATA_1" => $entityData1, "ENTITY_DATA_2" => $entityData2, "ENTITY_DATA_3" => $entityData3, "EXTRANET" => $isExtranet? 'Y': 'N', "CALL_NUMBER" => $callNumber, "USER_COUNT" => count($arUsers) )); $publicLink = ''; $chatId = $result->getId(); if (!$result->isSuccess()) { $errors = $result->getErrors(); if (!empty($errors)) { $firstError = $errors[0]; $GLOBALS["APPLICATION"]->ThrowException($firstError->getMessage(), $firstError->getCode()); } return false; } if ($chatId > 0) { $params = $result->getData(); if (intval($params['AVATAR']) > 0) $this->lastAvatarId = $params['AVATAR']; $arUsersName = Array(); foreach ($arUserId as $userId) { if ($userId != $this->user_id) $arUsersName[$userId] = htmlspecialcharsback($arUsers[$userId]['name']); Im\Model\RelationTable::add(array( "CHAT_ID" => $chatId, "MESSAGE_TYPE" => $params['TYPE'], "USER_ID" => $userId, //"STATUS" => IM_STATUS_READ, "MANAGER" => $authorId == $userId || isset($managers[$userId]) ? 'Y' : 'N', )); if ($params['TYPE'] != IM_MESSAGE_OPEN) { CIMContactList::CleanChatCache($userId); } } if ($params['TYPE'] == IM_MESSAGE_OPEN) { CIMContactList::CleanAllChatCache(); } $generalChatId = self::GetGeneralChatId(); if (false && $params['TYPE'] == IM_MESSAGE_OPEN && $generalChatId > 0) // disabled auto-posting in general chat about new open chan { $attach = new CIMMessageParamAttach(null, Bitrix\Im\Color::getColor($chatColorCode)); $attach->AddChat(Array( "NAME" => $params['TITLE'], "CHAT_ID" => $chatId )); $attach->AddMessage($params['DESCRIPTION']); if ($this->user_id > 0 && !$skipAddMessage) { $createText = GetMessage("IM_GENERAL_CREATE_BY_USER_NEW", Array('#USER_NAME#' => htmlspecialcharsback($arUsers[$this->user_id]['name']))); } else { $createText = GetMessage("IM_GENERAL_CREATE_NEW"); } self::AddMessage(Array( "TO_CHAT_ID" => $generalChatId, "FROM_USER_ID" => $this->user_id, "MESSAGE" => $createText, "SYSTEM" => 'Y', "ATTACH" => $attach )); } if ($entityType === 'VIDEOCONF') { $aliasData = $arParams['VIDEOCONF']['ALIAS_DATA']; IM\Model\AliasTable::update($aliasData['ID'], [ 'ENTITY_ID' => $chatId ]); $conferenceData = [ 'ALIAS_ID' => $aliasData['ID'] ]; if (isset($arParams['VIDEOCONF']['PASSWORD'])) { $conferenceData['PASSWORD'] = $arParams['VIDEOCONF']['PASSWORD']; } if (isset($arParams['VIDEOCONF']['INVITATION'])) { $conferenceData['INVITATION'] = $arParams['VIDEOCONF']['INVITATION']; } $conferenceData['IS_BROADCAST'] = isset($arParams['VIDEOCONF']['IS_BROADCAST']) && $arParams['VIDEOCONF']['IS_BROADCAST'] === 'Y'? 'Y': 'N'; $creationResult = IM\Model\ConferenceTable::add($conferenceData); if (isset($arParams['VIDEOCONF']['PRESENTERS'])) { foreach ($arParams['VIDEOCONF']['PRESENTERS'] as $presenter) { IM\Model\ConferenceUserRoleTable::add([ 'CONFERENCE_ID' => $creationResult->getId(), 'USER_ID' => $presenter, 'ROLE' => Im\Call\Conference::ROLE_PRESENTER ]); } } $attach = new CIMMessageParamAttach(null, Bitrix\Im\Color::getColor($chatColorCode)); $attach->AddLink([ "NAME" => $aliasData['LINK'], "DESC" => GetMessage("IM_VIDEOCONF_SHARE_LINK"), "LINK" => $aliasData['LINK'] ]); $keyboard = new \Bitrix\Im\Bot\Keyboard(); $keyboard->addButton( [ "TEXT" => GetMessage("IM_VIDEOCONF_COPY_LINK"), "ACTION" => "COPY", "ACTION_VALUE" => $aliasData['LINK'], "DISPLAY" => "LINE", "BG_COLOR" => "#A4C31E", "TEXT_COLOR" => "#FFF" ] ); self::AddMessage([ "TO_CHAT_ID" => $chatId, "SYSTEM" => 'Y', "FROM_USER_ID" => $this->user_id, "MESSAGE" => GetMessage("IM_VIDEOCONF_LINK_TITLE"), "ATTACH" => $attach, "KEYBOARD" => $keyboard ]); } if ($message) { if ($params['TYPE'] == IM_MESSAGE_PRIVATE) { if ($params['ENTITY_TYPE'] == 'PERSONAL') { CUserOptions::SetOption('im', 'personalChat', $chatId, false, $this->user_id); } CIMMessage::Add(Array( "FROM_USER_ID" => $this->user_id, "TO_USER_ID" => $this->user_id, "MESSAGE" => $message, )); } else { self::AddMessage(Array( "TO_CHAT_ID" => $chatId, "FROM_USER_ID" => $this->user_id, "SYSTEM" => $this->user_id? 'N': 'Y', "MESSAGE" => $message, )); } } else if ($params['TYPE'] == IM_MESSAGE_OPEN && !$skipUserAdd) { if ($this->user_id > 0) { $createText = GetMessage("IM_CHAT_CREATE_OPEN_".$arUsers[$this->user_id]['gender']."_NEW", Array('#USER_NAME#' => htmlspecialcharsback($arUsers[$this->user_id]['name']), '#CHAT_TITLE#' => $params['TITLE'])); } else { $createText = GetMessage("IM_CHAT_CREATE_OPEN_NEW", Array('#CHAT_TITLE#' => $params['TITLE'])); } self::AddMessage(Array( "TO_CHAT_ID" => $chatId, "FROM_USER_ID" => $this->user_id, "MESSAGE" => $createText, "SYSTEM" => 'Y', )); } if (isset($arUsers[$this->user_id]) && count($arUsersName) >= 1 && !$skipUserAdd && !$skipAddMessage) { self::AddMessage(Array( "TO_CHAT_ID" => $chatId, "FROM_USER_ID" => $this->user_id, "MESSAGE" => GetMessage("IM_CHAT_JOIN_".$arUsers[$this->user_id]['gender'], Array('#USER_1_NAME#' => htmlspecialcharsback($arUsers[$this->user_id]['name']), '#USER_2_NAME#' => implode(', ', $arUsersName))), "SYSTEM" => 'Y', )); } foreach ($arUserId as $userId) { if (IM\User::getInstance($userId)->isBot()) { IM\Bot::changeChatMembers($chatId, $userId); IM\Bot::onJoinChat('chat'.$chatId, Array( 'CHAT_TYPE' => $type, 'MESSAGE_TYPE' => $type, 'BOT_ID' => $userId, 'USER_ID' => $this->user_id, "CHAT_AUTHOR_ID" => $authorId, "CHAT_ENTITY_TYPE" => $entityType, "CHAT_ENTITY_ID" => $entityId, "ACCESS_HISTORY" => true, )); } } self::addChatIndex((int)$chatId, mb_substr($chatTitle, 0, 255)); } else { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_IM_ERROR_EMPTY_USER_OR_CHAT"), "ERROR_OF_CREATE_CHAT"); return false; } return $chatId; */ } public static function AddMessage($arFields) { $arFields['MESSAGE_TYPE'] = IM_MESSAGE_CHAT; return CIMMessenger::Add($arFields); } public static function AddGeneralMessage($arFields) { $arFields['MESSAGE_TYPE'] = IM_MESSAGE_OPEN; $arFields['TO_CHAT_ID'] = self::GetGeneralChatId(); return CIMMessenger::Add($arFields); } public function Join($chatId) { $chatId = intval($chatId); if ($chatId <= 0) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_EMPTY_CHAT_ID"), "EMPTY_CHAT_ID"); return false; } $orm = IM\Model\ChatTable::getById($chatId); if (!($chatData = $orm->fetch())) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_CHAT_NOT_EXISTS"), "ERROR_CHAT_NOT_EXISTS"); return false; } if ($chatData['TYPE'] != IM_MESSAGE_OPEN) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_ACCESS_JOIN"), "ACCESS_JOIN"); return false; } if (IM\User::getInstance($this->user_id)->isExtranet()) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_ACCESS_JOIN"), "ACCESS_JOIN"); return false; } $chat = new CIMChat(0); $chat->AddUser($chatId, $this->user_id); return true; } public function JoinParent($chatId, $messageId) { $chatId = intval($chatId); if ($chatId <= 0) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_EMPTY_CHAT_ID"), "EMPTY_CHAT_ID"); return false; } $messageId = intval($messageId); if ($messageId <= 0) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_EMPTY_CHAT_ID"), "EMPTY_CHAT_ID"); return false; } $CIMMessage = new CIMMessage($this->user_id); $message = $CIMMessage->GetMessage($messageId, true); if (!$message) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_ACCESS_JOIN"), "ACCESS_JOIN"); return false; } $relations = IM\Chat::getRelation($chatId, ['WITHOUT_COUNTERS' => 'Y']); if (!isset($relations[$this->user_id])) { $chat = new CIMChat(0); $chat->AddUser($chatId, $this->user_id); } return true; } public function AddUser($chatId, $userId, $hideHistory = null, $skipMessage = false, $skipRecent = false) { global $DB; $chatId = intval($chatId); if ($chatId <= 0) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_EMPTY_CHAT_ID"), "EMPTY_CHAT_ID"); return false; } $arUserId = Array(); if (is_array($userId)) { $arUserId = \CIMContactList::PrepareUserIds($userId); } else if (intval($userId) > 0) { $arUserId[intval($userId)] = intval($userId); } if ($this->user_id > 0) { $arUserId[$this->user_id] = $this->user_id; } if (count($arUserId) <= 0) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_EMPTY_USER_ID"), "EMPTY_USER_ID"); return false; } if ($this->user_id > 0 && !IsModuleInstalled('intranet') && CModule::IncludeModule('socialnetwork') && CSocNetUser::IsFriendsAllowed()) { $arFriendUsers = Array(); $dbFriends = CSocNetUserRelations::GetList(array(),array("USER_ID" => $this->user_id, "RELATION" => SONET_RELATIONS_FRIEND), false, false, array("ID", "FIRST_USER_ID", "SECOND_USER_ID", "DATE_CREATE", "DATE_UPDATE", "INITIATED_BY")); while ($arFriends = $dbFriends->Fetch()) { $friendId = $this->user_id == $arFriends["FIRST_USER_ID"]? $arFriends["SECOND_USER_ID"]: $arFriends["FIRST_USER_ID"]; $arFriendUsers[$friendId] = $friendId; } foreach ($arUserId as $id => $uid) { if ($uid == $this->user_id) continue; if (!isset($arFriendUsers[$uid]) && CIMSettings::GetPrivacy(CIMSettings::PRIVACY_CHAT, $uid) == CIMSettings::PRIVACY_RESULT_CONTACT) unset($arUserId[$id]); } if (count($arUserId) <= 0) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_EMPTY_USER_ID_BY_PRIVACY"), "EMPTY_USER_ID_BY_PRIVACY"); return false; } } if ($this->user_id > 0) { $strSql = " SELECT C.ID CHAT_ID, C.PARENT_MID CHAT_PARENT_MID, C.TITLE CHAT_TITLE, C.AUTHOR_ID CHAT_AUTHOR_ID, C.EXTRANET CHAT_EXTRANET, C.DISK_FOLDER_ID, C.TYPE CHAT_TYPE, C.ENTITY_TYPE CHAT_ENTITY_TYPE, C.ENTITY_DATA_1 CHAT_ENTITY_DATA_1, C.ENTITY_DATA_2 CHAT_ENTITY_DATA_2, C.ENTITY_DATA_3 CHAT_ENTITY_DATA_3, C.MESSAGE_COUNT CHAT_MESSAGE_COUNT, ".$DB->DatetimeToTimestampFunction('C.DATE_CREATE')." CHAT_DATE_CREATE FROM b_im_chat C WHERE C.TYPE = '".IM_MESSAGE_OPEN."' AND C.ID = ".$chatId." "; $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); $arRes = $dbRes->Fetch(); if ($arRes) { if (\Bitrix\Im\User::getInstance()->isExtranet()) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_AUTHORIZE_ERROR"), "AUTHORIZE_ERROR"); return false; } } else { $strSql = " SELECT R.CHAT_ID, C.PARENT_MID CHAT_PARENT_MID, C.TITLE CHAT_TITLE, C.AUTHOR_ID CHAT_AUTHOR_ID, C.EXTRANET CHAT_EXTRANET, C.DISK_FOLDER_ID, C.TYPE CHAT_TYPE, C.ENTITY_TYPE CHAT_ENTITY_TYPE, C.ENTITY_ID CHAT_ENTITY_ID, C.ENTITY_DATA_1 CHAT_ENTITY_DATA_1, C.ENTITY_DATA_2 CHAT_ENTITY_DATA_2, C.ENTITY_DATA_3 CHAT_ENTITY_DATA_3, C.MESSAGE_COUNT CHAT_MESSAGE_COUNT, ".$DB->DatetimeToTimestampFunction('C.DATE_CREATE')." CHAT_DATE_CREATE FROM b_im_relation R LEFT JOIN b_im_chat C ON R.CHAT_ID = C.ID WHERE ".($this->user_id > 0? "R.USER_ID = ".$this->user_id." AND ": "")." R.MESSAGE_TYPE IN ('".IM_MESSAGE_OPEN."','".IM_MESSAGE_CHAT."','".IM_MESSAGE_OPEN_LINE."') AND R.CHAT_ID = ".$chatId." "; $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); $arRes = $dbRes->Fetch(); } } else { $strSql = " SELECT C.ID CHAT_ID, C.PARENT_MID CHAT_PARENT_MID, C.TITLE CHAT_TITLE, C.AUTHOR_ID CHAT_AUTHOR_ID, C.EXTRANET CHAT_EXTRANET, C.DISK_FOLDER_ID, C.TYPE CHAT_TYPE, C.ENTITY_TYPE CHAT_ENTITY_TYPE, C.ENTITY_ID CHAT_ENTITY_ID, C.ENTITY_DATA_1 CHAT_ENTITY_DATA_1, C.ENTITY_DATA_2 CHAT_ENTITY_DATA_2, C.ENTITY_DATA_3 CHAT_ENTITY_DATA_3, C.MESSAGE_COUNT CHAT_MESSAGE_COUNT, ".$DB->DatetimeToTimestampFunction('C.DATE_CREATE')." CHAT_DATE_CREATE FROM b_im_chat C WHERE C.TYPE IN ('".IM_MESSAGE_OPEN."','".IM_MESSAGE_CHAT."','".IM_MESSAGE_OPEN_LINE."') AND C.ID = ".$chatId." "; $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); $arRes = $dbRes->Fetch(); } if (!$arRes) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_AUTHORIZE_ERROR"), "AUTHORIZE_ERROR"); return false; } $arRes['CHAT_TYPE'] = trim($arRes['CHAT_TYPE']); $chatEntityType = $arRes['CHAT_ENTITY_TYPE'] ; $chatParentMessageId = $arRes['CHAT_PARENT_MID'] ; if ($chatEntityType == 'LINES') { foreach ($arUserId as $id => $uid) { if ( !\Bitrix\Im\User::getInstance($uid)->isConnector() && (\Bitrix\Im\User::getInstance($uid)->isExtranet() || \Bitrix\Im\User::getInstance($uid)->isNetwork()) ) { unset($arUserId[$id]); } } } $extranetFlag = false; if (!in_array($chatEntityType, Array('LINES', 'LIVECHAT'))) { $extranetFlag = $arRes["CHAT_EXTRANET"] == ""? "": ($arRes["CHAT_EXTRANET"] == "Y"? true: false); } $chatTitle = \Bitrix\Im\Text::decodeEmoji($arRes['CHAT_TITLE']); $chatAuthorId = intval($arRes['CHAT_AUTHOR_ID']); $chatType = $arRes['CHAT_TYPE']; $arRelation = self::GetRelationById($chatId, false, true, false); $arExistUser = Array(); foreach ($arRelation as $relation) $arExistUser[] = $relation['USER_ID']; $arUserId = array_diff($arUserId, $arExistUser); if (empty($arUserId)) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_NOTHING_TO_ADD"), "NOTHING_TO_ADD"); return false; } $arUserSelect = $arUserId; if ($this->user_id > 0) { $arUserSelect[] = $this->user_id; } if ($chatEntityType === 'VIDEOCONF') { $wasUserBlocked = IM\Model\BlockUserTable::getList( [ 'select' => ['ID'], 'filter' => [ '=CHAT_ID' => $chatId, '@USER_ID' => new Bitrix\Main\DB\SqlExpression(implode(', ', $arUserId)) ] ] )->fetchAll(); if (count($wasUserBlocked) === 1) { IM\Model\BlockUserTable::delete($wasUserBlocked[0]['ID']); } else if (count($wasUserBlocked) > 1) { foreach ($wasUserBlocked as $blockedUser) { IM\Model\BlockUserTable::delete($blockedUser['ID']); } } } $arUsers = CIMContactList::GetUserData(array( 'ID' => array_values($arUserSelect), 'DEPARTMENT' => 'N', 'USE_CACHE' => 'N' )); $arUsers = $arUsers['users']; if ($extranetFlag !== true) { $isExtranet = false; if ($chatEntityType !== 'VIDEOCONF') { foreach ($arUsers as $userData) { if ($userData['extranet']) { $isExtranet = true; break; } } } if ($isExtranet || $extranetFlag === "") { IM\Model\ChatTable::update($chatId, Array('EXTRANET' => $isExtranet? "Y":"N")); } $extranetFlag = $isExtranet; } $arUsersName = Array(); foreach ($arUserId as $uid) { $arUsersName[] = '[USER='.$uid.'][/USER]'; } $message = ''; if ($this->user_id > 0) { $message = GetMessage("IM_CHAT_JOIN_".$arUsers[$this->user_id]['gender'], Array('#USER_1_NAME#' => htmlspecialcharsback($arUsers[$this->user_id]['name']), '#USER_2_NAME#' => implode(', ', $arUsersName))); } else { if ($skipMessage) { $message = ''; } else if ($chatId == self::GetGeneralChatId()) { if (self::GetGeneralChatAutoMessageStatus(self::GENERAL_MESSAGE_TYPE_JOIN)) { if (count($arUsersName) > 1) { $message = GetMessage("IM_CHAT_GENERAL_JOIN_PLURAL", Array('#USERS_NAME#' => implode(', ', $arUsersName))); } else { $arUserList = array_values($arUserId); $joinMessage = "IM_CHAT_GENERAL_JOIN"; if ($arUsers[$arUserList[0]]['gender'] == 'F') { $joinMessage .= '_F'; } $message = GetMessage($joinMessage, Array('#USER_NAME#' => implode(', ', $arUsersName))); } } } else { if (count($arUsersName) > 1) { $message = GetMessage("IM_CHAT_SELF_JOIN", Array('#USERS_NAME#' => implode(', ', $arUsersName))); } else { $arUserList = array_values($arUserId); $message = GetMessage("IM_CHAT_SELF_JOIN_".$arUsers[$arUserList[0]]['gender'], Array('#USER_NAME#' => implode(', ', $arUsersName))); } } } $fileMaxId = 0; if ((int)$arRes['DISK_FOLDER_ID'] > 0) { $fileMaxId = \CIMDisk::getMaxFileId($chatId); } $startId = 0; $maxId = 0; $strSql = "SELECT MAX(ID) ID FROM b_im_message WHERE CHAT_ID = ".$chatId." GROUP BY CHAT_ID"; $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); if ($arMax = $dbRes->Fetch()) { $startId = $arMax['ID']+1; $maxId = $arMax['ID']; } $publicPullWatch = false; if (($chatType == IM_MESSAGE_OPEN || $chatType == IM_MESSAGE_OPEN_LINE) && CModule::IncludeModule("pull")) { $publicPullWatch = true; } if ($chatEntityType == 'LINES' || $arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN_LINE) { $hideHistory = false; } else if (is_null($hideHistory)) { $hideHistory = CIMSettings::GetStartChatMessage() == CIMSettings::START_MESSAGE_LAST && $arRes['CHAT_TYPE'] == IM_MESSAGE_CHAT; } if ($this->user_id > 0 && !$hideHistory && $arRelation[$this->user_id]['START_ID'] > 0) { $hideHistory = true; $startId = $arRelation[$this->user_id]['START_ID']; } foreach ($arUserId as $uid) { if ($publicPullWatch) { \CPullWatch::Delete($uid, 'IM_PUBLIC_'.$chatId); } $hideHistoryFlag = $hideHistory; if ($chatEntityType != 'LINES' && $arRes['CHAT_TYPE'] != IM_MESSAGE_PRIVATE && \Bitrix\Im\User::getInstance($uid)->isExtranet()) { $hideHistoryFlag = true; } $startCounter = 0; if ($hideHistoryFlag && $startId > 0) { $startCounter = (int)$arRes['CHAT_MESSAGE_COUNT']; } $orm = IM\Model\RelationTable::add(array( "CHAT_ID" => $chatId, "MESSAGE_TYPE" => $arRes['CHAT_TYPE'], "USER_ID" => $uid, "START_ID" => $hideHistoryFlag? $startId: 0, "LAST_ID" => $maxId, //"LAST_SEND_ID" => $maxId, "LAST_FILE_ID" => $hideHistoryFlag? $fileMaxId: 0, "START_COUNTER" => $startCounter )); $relationId = $orm->getId(); if ($arRes['CHAT_TYPE'] != IM_MESSAGE_OPEN) { \CIMContactList::CleanChatCache($uid); } } if ($arRes['CHAT_TYPE'] == IM_MESSAGE_OPEN) { \CIMContactList::CleanAllChatCache(); } $newUsersCount = $this->getChatActiveUserCount($chatId); $this->updateChatUserCount($chatId, $newUsersCount); if (CModule::IncludeModule("pull")) { $pushMessage = Array( 'module_id' => 'im', 'command' => 'chatUserAdd', 'params' => Array( 'chatId' => $chatId, 'dialogId' => 'chat'.$chatId, 'chatTitle' => $chatTitle, 'chatOwner' => $chatAuthorId, 'chatExtranet' => $extranetFlag == 'Y', 'users' => $arUsers, 'newUsers' => array_values($arUserId), 'userCount' => $newUsersCount ), 'extra' => \Bitrix\Im\Common::getPullExtra() ); if ($chatEntityType == 'LINES') { foreach ($arRelation as $rel) { if ($rel["EXTERNAL_AUTH_ID"] == 'imconnector') { unset($arRelation[$rel["USER_ID"]]); } } } \Bitrix\Pull\Event::add(array_merge(array_keys($arRelation), array_keys($arUsers)), $pushMessage); if ($chatType == IM_MESSAGE_OPEN || $chatType == IM_MESSAGE_OPEN_LINE) { CPullWatch::AddToStack('IM_PUBLIC_'.$chatId, $pushMessage); } } if ($message) { $lastId = self::AddMessage(Array( "TO_CHAT_ID" => $chatId, "MESSAGE" => $message, "FROM_USER_ID" => $this->user_id, "SYSTEM" => 'Y', "RECENT_ADD" => $skipRecent? 'N': 'Y', "PARAMS" => Array( "CODE" => 'CHAT_JOIN', "NOTIFY" => $chatEntityType == 'LINES'? 'Y': 'N', ), "PUSH" => 'N' )); } else { $lastId = 0; } CIMDisk::ChangeFolderMembers($chatId, $arUserId); foreach ($arUserId as $uid) { if (IM\User::getInstance($uid)->isBot()) { IM\Bot::changeChatMembers($chatId, $uid); IM\Bot::onJoinChat('chat'.$chatId, Array( 'CHAT_TYPE' => $chatType, 'MESSAGE_TYPE' => $chatType, 'BOT_ID' => $uid, 'USER_ID' => $this->user_id, 'CHAT_ID' => $chatId, "CHAT_AUTHOR_ID" => $arRes['CHAT_AUTHOR_ID'], "CHAT_ENTITY_TYPE" => $arRes['CHAT_ENTITY_TYPE'], "CHAT_ENTITY_ID" => $arRes['CHAT_ENTITY_ID'], "ACCESS_HISTORY" => $hideHistoryFlag? false: true, )); } } if ( in_array($arRes['CHAT_TYPE'], [\Bitrix\Im\Chat::TYPE_OPEN, \Bitrix\Im\Chat::TYPE_GROUP]) && $arRes['CHAT_ENTITY_TYPE'] != 'LIVECHAT' ) { self::updateChatIndex($chatId); } if (!empty($chatEntityType)) { $eventCode = str_replace('_', '', ucfirst(ucwords(mb_strtolower($chatEntityType), '_'))); foreach(GetModuleEvents("im", "OnChatUserAddEntityType".$eventCode, true) as $arEvent) { ExecuteModuleEventEx($arEvent, array([ 'CHAT_ID' => $chatId, 'NEW_USERS' => $arUserId, ])); } } IM\V2\Chat::cleanAccessCache($chatId); return true; } private function getChatActiveUserCount($chatId): int { $chatUserCount = IM\Model\RelationTable::getList( [ 'select' => ['CNT', 'CHAT_ID'], 'filter' => [ ['=CHAT_ID' => $chatId], ['=USER.ACTIVE' => 'Y'] ], 'runtime' => [ new Bitrix\Main\Entity\ExpressionField('CNT', 'COUNT(*)') ] ] )->fetch(); return (int)$chatUserCount['CNT']; } private function updateChatUserCount($chatId, $newCount): \Bitrix\Main\ORM\Data\UpdateResult { return IM\Model\ChatTable::update($chatId, [ 'USER_COUNT' => $newCount ]); } public function MuteNotify($chatId, $mute = true) { return \Bitrix\Im\Chat::mute($chatId, $mute, $this->user_id); } public function DeleteUser($chatId, $userId, $checkPermission = true, $skipMessage = false, $skipRecent = false) { global $DB; $chatId = intval($chatId); $userId = intval($userId); if ($chatId <= 0 || $userId <= 0) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_EMPTY_USER_OR_CHAT"), "EMPTY_USER_OR_CHAT"); return false; } if ( !\Bitrix\Im\Chat::isActionAllowed('chat' . $chatId, 'LEAVE_OWNER') && \Bitrix\Im\Chat::getOwnerById('chat' . $chatId) === $userId ) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_LEAVE_OWNER_FORBIDDEN"), "LEAVE_OWNER_FORBIDDEN"); return false; } $pullLoad = CModule::IncludeModule('pull'); $strSql = " SELECT R.CHAT_ID, C.PARENT_MID CHAT_PARENT_MID, C.TITLE CHAT_TITLE, C.AUTHOR_ID CHAT_AUTHOR_ID, C.EXTRANET CHAT_EXTRANET, C.ENTITY_TYPE CHAT_ENTITY_TYPE, C.ENTITY_ID CHAT_ENTITY_ID, C.TYPE CHAT_TYPE FROM b_im_relation R LEFT JOIN b_im_chat C ON R.CHAT_ID = C.ID WHERE R.USER_ID = ".$userId." AND R.MESSAGE_TYPE IN ('".IM_MESSAGE_OPEN."','".IM_MESSAGE_CHAT."','".IM_MESSAGE_OPEN_LINE."') AND R.CHAT_ID = ".$chatId; $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); $arRes = $dbRes->Fetch(); if (!$arRes) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_USER_NOT_FOUND"), "USER_NOT_FOUND"); return false; } $chatParentMessageId = $arRes['CHAT_PARENT_MID']; $arRes['CHAT_TYPE'] = trim($arRes['CHAT_TYPE']); $chatEntityType = trim($arRes['CHAT_ENTITY_TYPE']); $chatEntityId = trim($arRes['CHAT_ENTITY_ID']); $extranetFlag = false; if (!in_array($arRes['CHAT_ENTITY_TYPE'], Array('LINES', 'LIVECHAT'))) { $extranetFlag = $arRes["CHAT_EXTRANET"] == ""? "": ($arRes["CHAT_EXTRANET"] == "Y"? true: false); } $chatTitle = \Bitrix\Im\Text::decodeEmoji($arRes['CHAT_TITLE']); $chatType = $arRes['CHAT_TYPE']; $chatAuthorId = intval($arRes['CHAT_AUTHOR_ID']); if ($chatAuthorId == $userId) { $strSql = " SELECT R.USER_ID FROM b_im_relation R WHERE R.CHAT_ID = ".$chatId." AND R.USER_ID <> ".$chatAuthorId; $strSql = $DB->TopSql($strSql, 1); $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); if ($res = $dbRes->Fetch()) { self::SetOwner($chatId, $res['USER_ID']); } } $bSelf = true; $arUsers = Array($userId); if($this->user_id != $userId) { if ( $chatEntityType === 'VIDEOCONF' && !IM\User::getInstance($this->user_id)->isExtranet() && IM\User::getInstance($userId)->isExtranet() ) { } else if ($checkPermission && $chatAuthorId != $this->user_id) { $GLOBALS["APPLICATION"]->ThrowException(GetMessage("IM_ERROR_KICK"), "IM_ERROR_KICK"); return false; } $bSelf = false; $arUsers[] = $this->user_id; } $arOldRelation = CIMChat::GetRelationById($chatId, false, true, false); $arUsers = CIMContactList::GetUserData(array( 'ID' => array_keys($arOldRelation), 'DEPARTMENT' => 'N', 'USE_CACHE' => 'N' )); $arUsers = $arUsers['users']; if ($chatEntityType === 'VIDEOCONF') { $externalAuthId = IM\User::getInstance($userId)->getExternalAuthId(); if ($externalAuthId === 'call') { IM\Model\BlockUserTable::add( [ 'CHAT_ID' => $chatId, 'USER_ID' => $userId, 'BLOCK_DATE' => new SqlExpression("NOW()") ] ); } } $message = ''; if ($skipMessage) { $message = ''; } else if ($bSelf) { if (in_array($chatEntityType, ['ANNOUNCEMENT'])) { $message = ''; } else if ($chatId == self::GetGeneralChatId()) { if (self::GetGeneralChatAutoMessageStatus(self::GENERAL_MESSAGE_TYPE_LEAVE)) { $message = GetMessage("IM_CHAT_GENERAL_LEAVE_".$arUsers[$userId]['gender'], Array('#USER_NAME#' => htmlspecialcharsback($arUsers[$userId]['name']))); } } else { $message = GetMessage("IM_CHAT_LEAVE_".$arUsers[$userId]['gender'], Array('#USER_NAME#' => htmlspecialcharsback($arUsers[$userId]['name']))); } } else { $message = GetMessage("IM_CHAT_KICK_".$arUsers[$this->user_id]['gender'], Array('#USER_1_NAME#' => htmlspecialcharsback($arUsers[$this->user_id]['name']), '#USER_2_NAME#' => htmlspecialcharsback($arUsers[$userId]['name']))); } CIMContactList::DeleteRecent($chatId, true, $userId); \Bitrix\Im\LastSearch::delete('chat'.$chatId, $userId); $relationList = IM\Model\RelationTable::getList(array( "select" => array("ID", "USER_ID"), "filter" => array( "=CHAT_ID" => $chatId, "=USER_ID" => $userId, ), )); while ($relation = $relationList->fetch()) { IM\Model\RelationTable::delete($relation["ID"]); if ($extranetFlag !== false) { $isExtranet = false; foreach ($arUsers as $userData) { if ($userData['id'] == $userId) continue; if ($userData['extranet']) { $isExtranet = true; break; } } if (!$isExtranet || $extranetFlag === "") { IM\Model\ChatTable::update($chatId, Array('EXTRANET' => $isExtranet? "Y":"N")); } $extranetFlag = $isExtranet; } } if (IM\User::getInstance($userId)->isBot()) { IM\Bot::changeChatMembers($chatId, $userId, false); IM\Bot::onLeaveChat('chat'.$chatId, Array( 'CHAT_TYPE' => $chatType, 'MESSAGE_TYPE' => $chatType, 'BOT_ID' => $userId, 'USER_ID' => $this->user_id, "CHAT_AUTHOR_ID" => $chatAuthorId, "CHAT_ENTITY_TYPE" => $chatEntityType, "CHAT_ENTITY_ID" => $chatEntityId, )); } CIMDisk::ChangeFolderMembers($chatId, $userId, false); if ($message) { self::AddMessage(Array( "TO_CHAT_ID" => $chatId, "MESSAGE" => $message, "FROM_USER_ID" => $this->user_id, "SYSTEM" => 'Y', "RECENT_ADD" => $skipRecent? 'N': 'Y', "PARAMS" => Array( "CODE" => 'CHAT_LEAVE', "NOTIFY" => $chatEntityType == 'LINES'? 'Y': 'N', ), "PUSH" => 'N', "SKIP_USER_CHECK" => "Y", )); } if (!$bSelf && $chatType !== IM_MESSAGE_OPEN_LINE) { $gender = \Bitrix\Im\User::getInstance($this->user_id)->getGender(); $userName = \Bitrix\Im\User::getInstance($this->user_id)->getFullName(false); $userName = '[USER='.$this->user_id.']'.$userName.'[/USER]'; $notificationMessage = Loc::getMessage('IM_CHAT_KICK_NOTIFICATION_'. $gender, ["#USER_NAME#" => $userName]); $notificationFields = [ 'TO_USER_ID' => $userId, 'FROM_USER_ID' => 0, 'NOTIFY_TYPE' => IM_NOTIFY_SYSTEM, 'NOTIFY_MODULE' => 'im', 'NOTIFY_TITLE' => htmlspecialcharsback(\Bitrix\Main\Text\Emoji::decode($arRes['CHAT_TITLE'])), 'NOTIFY_MESSAGE' => $notificationMessage, ]; CIMNotify::Add($notificationFields); } if ($chatType == IM_MESSAGE_OPEN) { CIMContactList::CleanAllChatCache(); } else { CIMContactList::CleanChatCache($userId); } $newUsersCount = $this->getChatActiveUserCount($chatId); $this->updateChatUserCount($chatId, $newUsersCount); $pushMessage = Array( 'module_id' => 'im', 'command' => 'chatUserLeave', 'params' => Array( 'dialogId' => 'chat'.$chatId, 'chatId' => (int)$chatId, 'chatTitle' => $chatTitle, 'userId' => (int)$userId, 'message' => $bSelf? '': htmlspecialcharsbx($message), 'userCount' => $newUsersCount ), 'extra' => \Bitrix\Im\Common::getPullExtra() ); if ($arRes['CHAT_ENTITY_TYPE'] == 'LINES' ) { foreach ($arOldRelation as $rel) { if ($rel["EXTERNAL_AUTH_ID"] == 'imconnector') { unset($arOldRelation[$rel["USER_ID"]]); } } } if ($pullLoad) { \Bitrix\Pull\Event::add(array_keys($arOldRelation), $pushMessage); } if ( in_array($arRes['CHAT_TYPE'], [\Bitrix\Im\Chat::TYPE_OPEN, \Bitrix\Im\Chat::TYPE_GROUP]) && $arRes['CHAT_ENTITY_TYPE'] != 'LIVECHAT' ) { self::updateChatIndex($chatId); } if (!empty($chatEntityType)) { $eventCode = str_replace('_', '', ucfirst(ucwords(mb_strtolower($chatEntityType), '_'))); foreach(GetModuleEvents("im", "OnChatUserDeleteEntityType".$eventCode, true) as $arEvent) { ExecuteModuleEventEx($arEvent, array([ 'CHAT_ID' => $chatId, 'USER_ID' => $userId, ])); } } IM\V2\Chat::cleanAccessCache($chatId); return true; } public static function GetAvatarImage($id, $size = 200, $addBlankPicture = true) { $url = $addBlankPicture? '/bitrix/js/im/images/blank.gif': ''; $id = intval($id); if ($id > 0 && $size > 0) { $arFileTmp = CFile::ResizeImageGet( $id, array('width' => $size, 'height' => $size), BX_RESIZE_IMAGE_EXACT, false, false, true ); if (!empty($arFileTmp['src'])) { $url = $arFileTmp['src']; } } return $url; } public static function AddSystemMessage($params) { $chatId = intval($params['CHAT_ID']); if ($chatId <= 0) return false; $arUser = false; $userId = intval($params['USER_ID']); if ($userId > 0) { $arSelect = Array("ID", "LAST_NAME", "NAME", "LOGIN", "SECOND_NAME", "PERSONAL_GENDER"); $dbUsers = CUser::GetList('', '', array('ID_EQUAL_EXACT' => $userId), array('FIELDS' => $arSelect)); if ($arUser = $dbUsers->Fetch()) { $arUser['NAME'] = \Bitrix\Im\User::formatFullNameFromDatabase($arUser); $arUser['PERSONAL_GENDER'] = $arUser["PERSONAL_GENDER"] == 'F'? 'F': 'M'; } } if (isset($params['MESSAGE_CODE'])) { $messageReplace = is_array($params['MESSAGE_REPLACE'])? $params['MESSAGE_REPLACE']: Array(); if ($arUser) { $messageReplace['#USER_NAME#'] = $arUser['NAME']; $message = GetMessage($params['MESSAGE_CODE'].$arUser['PERSONAL_GENDER'], $messageReplace); } else { $message = GetMessage($params['MESSAGE_CODE'], $messageReplace); } } else { $messageReplace = is_array($params['MESSAGE_REPLACE'])? $params['MESSAGE_REPLACE']: Array(); $message = trim($params['MESSAGE']); if ($message <> '' && !empty($messageReplace)) { $message = str_replace(array_keys($messageReplace), array_values($messageReplace), $message); } } if ($message == '') return false; return self::AddMessage(Array( "TO_CHAT_ID" => $chatId, "FROM_USER_ID" => $userId, "MESSAGE" => $message, "SYSTEM" => 'Y', )); } public static function CheckRestriction($chatId, $action) { if (is_int($chatId)) { if (self::GetGeneralChatId() == $chatId) { $chat['ENTITY_TYPE'] = 'GENERAL'; } else { $chat = IM\Model\ChatTable::getById($chatId)->fetch(); if (!$chat) return true; } } else if(is_array($chatId)) { $chat = $chatId; } else { return true; } $options = self::GetChatOptions(); if (isset($options[$chat['ENTITY_TYPE']][$action]) && !self::$entityOption[$chat['ENTITY_TYPE']][$action]) { return true; } return false; } public static function GetChatOptions() { if (!is_null(self::$entityOption)) { return self::$entityOption; } global $USER; self::$entityOption = []; $default = [ 'AVATAR' => true, 'RENAME' => true, 'EXTEND' => true, 'CALL' => true, 'MUTE' => true, 'LEAVE' => true, 'LEAVE_OWNER' => true, 'SEND' => true, 'USER_LIST' => true, ]; self::$entityOption['GENERAL'] = [ 'AVATAR' => false, 'RENAME' => false, 'EXTEND' => false, 'CALL' => true, 'LEAVE' => false, 'LEAVE_OWNER' => false, 'SEND' => CIMChat::CanSendMessageToGeneralChat((int)$USER->GetID()) ]; if (\Bitrix\Main\Loader::includeModule('imbot')) { self::$entityOption[\Bitrix\ImBot\Service\Notifier::CHAT_ENTITY_TYPE] = [ 'AVATAR' => false, 'RENAME' => false, 'LEAVE_OWNER' => false, ]; self::$entityOption[\Bitrix\ImBot\Bot\Support24::CHAT_ENTITY_TYPE] = [ 'AVATAR' => false, 'RENAME' => true, 'EXTEND' => false, 'CALL' => false, 'MUTE' => false, 'LEAVE' => false, 'LEAVE_OWNER' => false, 'USER_LIST' => false, ]; } if (\Bitrix\Main\ModuleManager::isModuleInstalled('socialnetwork')) { $path = COption::GetOptionString("socialnetwork", "workgroups_page", "/workgroups/", SITE_ID); $path = $path.'group/#ID#/'; self::$entityOption['SONET_GROUP'] = [ 'AVATAR' => false, 'RENAME' => false, 'EXTEND' => false, 'LEAVE' => false, 'LEAVE_OWNER' => false, 'PATH' => $path, 'PATH_TITLE' => GetMessage('IM_PATH_TITLE_SONET') ]; } if (\Bitrix\Main\Loader::includeModule('tasks')) { $path = \CTasksTools::GetOptionPathTaskUserEntry(SITE_ID, "/company/personal/user/#user_id#/tasks/task/view/#task_id#/"); $path = str_replace(Array('#user_id#', '#task_id#'), Array($USER->GetId(), '#ID#'), mb_strtolower($path)); self::$entityOption['TASKS'] = Array( 'AVATAR' => true, 'RENAME' => true, 'EXTEND' => true, 'LEAVE' => true, 'LEAVE_OWNER' => true, 'PATH' => $path, 'PATH_TITLE' => GetMessage('IM_PATH_TITLE_TASKS') ); } if (\Bitrix\Main\Loader::includeModule('calendar')) { $path = \CCalendar::GetPathForCalendarEx($USER->GetId()); $path = \CHTTP::urlAddParams($path, ['EVENT_ID' => '#ID#']); self::$entityOption[\CCalendar::CALENDAR_CHAT_ENTITY_TYPE] = Array( 'AVATAR' => true, 'RENAME' => true, 'EXTEND' => true, 'LEAVE' => true, 'LEAVE_OWNER' => true, 'PATH' => $path, 'PATH_TITLE' => GetMessage('IM_PATH_TITLE_CALENDAR_EVENT') ); } if (\Bitrix\Main\Loader::includeModule('crm')) { self::$entityOption['CRM'] = Array( 'AVATAR' => false, 'RENAME' => false, 'EXTEND' => true, 'LEAVE' => true, 'LEAVE_OWNER' => false, 'PATH' => '', 'PATH_TITLE' => '' ); } foreach (self::$entityOption as $code => $value) { self::$entityOption[$code] = array_merge($default, $value); } self::$entityOption['DEFAULT'] = $default; return self::$entityOption; } public static function GetSonetGroupChatId($groupId) { if (!CModule::IncludeModule('socialnetwork')) return false; $chatData = \Bitrix\Socialnetwork\Integration\Im\Chat\Workgroup::getChatData(Array( 'group_id' => $groupId, 'skipAvailabilityCheck' => true )); if (!empty($chatData[$groupId]) && intval($chatData[$groupId]) > 0) { $chatId = $chatData[$groupId]; } else { $chatId = \Bitrix\Socialnetwork\Integration\Im\Chat\Workgroup::createChat(Array( 'group_id' => $groupId )); } return $chatId; } public static function GetCrmChatId($code) { if (!CModule::IncludeModule('crm')) return false; [$entityType, $entityId] = explode('|', $code); global $USER; $chatId = \Bitrix\Crm\Integration\Im\Chat::joinChat(Array( 'ENTITY_TYPE' => $entityType, 'ENTITY_ID' => $entityId, 'USER_ID' => $USER->GetId() )); return $chatId; } public static function GetUserCount($chatId) { $result = \Bitrix\Im\Model\ChatTable::getList( [ 'select' => ['USER_COUNT'], 'filter' => ['=ID' => $chatId] ] )->fetch(); if (!$result) { return false; } return (int)$result['USER_COUNT']; } public static function GetEntityChat($entityType, $entityId) { $entityType = trim($entityType); $entityId = trim($entityId); if (empty($entityType) || empty($entityId)) { return false; } $chatData = \Bitrix\Im\Model\ChatTable::getList(Array( 'select' => ['ID'], 'filter' => [ '=ENTITY_TYPE' => $entityType, '=ENTITY_ID' => $entityId, ] ))->fetch(); if (!$chatData) { return false; } return $chatData['ID']; } public static function DeleteEntityChat($entityType, $entityId) { $entityType = trim($entityType); $entityId = trim($entityId); if (empty($entityType) || empty($entityId)) { return false; } $chatData = \Bitrix\Im\Model\ChatTable::getList(Array( 'select' => ['ID', 'DISK_FOLDER_ID'], 'filter' => [ '=ENTITY_TYPE' => $entityType, '=ENTITY_ID' => $entityId, ], ))->fetch(); if (!$chatData) { return false; } self::deleteChat($chatData); return true; } public static function deleteChat(array $chatData): void { global $DB; self::hide($chatData['ID']); $strSQL = "DELETE FROM b_im_chat WHERE ID = ".$chatData['ID']; $DB->Query($strSQL, true, "File: ".__FILE__."
Line: ".__LINE__); $strSQL = "DELETE FROM b_im_relation WHERE CHAT_ID = ".$chatData['ID']; $DB->Query($strSQL, true, "File: ".__FILE__."
Line: ".__LINE__); $strSQL = "DELETE FROM b_im_message WHERE CHAT_ID = ".$chatData['ID']; $DB->Query($strSQL, true, "File: ".__FILE__."
Line: ".__LINE__); IM\V2\Link\Url\UrlCollection::deleteByChatsIds([(int)$chatData['ID']]); IM\V2\Chat::cleanCache((int)$chatData['ID']); if ($chatData['DISK_FOLDER_ID']) { $folderModel = \Bitrix\Disk\Folder::getById($chatData['DISK_FOLDER_ID']); if ($folderModel) { $folderModel->deleteTree(\Bitrix\Disk\SystemUser::SYSTEM_USER_ID); } } } public static function hide($chatId) { $pushList = []; $relations = \CIMChat::GetRelationById($chatId, false, true, false); foreach($relations as $userId => $relation) { \CIMContactList::DeleteRecent($chatId, true, $userId); if (!\Bitrix\Im\User::getInstance($userId)->isConnector()) { $pushList[] = $userId; } } if ( !empty($pushList) && \Bitrix\Main\Loader::includeModule("pull") ) { \Bitrix\Pull\Event::add($pushList, Array( 'module_id' => 'im', 'command' => 'chatHide', 'expiry' => 3600, 'params' => Array( 'dialogId' => 'chat'.$chatId, ), 'extra' => \Bitrix\Im\Common::getPullExtra() )); } return true; } public static function index($chatId) { $index = \Bitrix\Im\Internals\ChatIndex::create() ->setChatId((int)$chatId) ; static::fillChatIndexWithUserFullNames($index); \Bitrix\Im\Model\ChatTable::indexRecord($index); return true; } public static function addChatIndex(int $chatId, string $chatTitle) { $index = \Bitrix\Im\Internals\ChatIndex::create() ->setChatId($chatId) ->setTitle($chatTitle) ; static::fillChatIndexWithUserFullNames($index); \Bitrix\Im\Model\ChatTable::addIndexRecord($index); return true; } public static function updateChatIndex($chatId) { $index = \Bitrix\Im\Internals\ChatIndex::create() ->setChatId((int)$chatId) ; static::fillChatIndexWithUserFullNames($index); \Bitrix\Im\Model\ChatTable::updateIndexRecord($index); return true; } public static function fillChatIndexWithUserFullNames(\Bitrix\Im\Internals\ChatIndex $index) { $query = \Bitrix\Im\Model\RelationTable::query() ->addSelect('USER_ID') ->where('CHAT_ID', $index->getChatId()) ->setLimit(100) ; $users = []; foreach ($query->exec() as $relation) { $users[] = \Bitrix\Im\User::getInstance($relation['USER_ID'])->getFullName(false); } $index->setUserList($users); } public static function getNextConferenceDefaultTitle() { $counter = CGlobalCounter::GetValue('im_videoconf_count', CGlobalCounter::ALL_SITES) + 1; return GetMessage('IM_VIDEOCONF_NAME_FORMAT_NEW', [ '#NUMBER#' => $counter ]); } }