/**
* Method will be invoked after an database record updated.
*
* @param array $oldRecord All fields before update.
* @param array $newRecord All fields after update.
*
* @return void
*/
public static function afterUpdateTrigger(array $oldRecord, array $newRecord)
{
if ($oldRecord['TITLE'] !== $newRecord['TITLE']) {
if (\CModule::IncludeModule("pull")) {
$ar = \CIMChat::GetRelationById($newRecord['CHAT_ID']);
foreach ($ar as $rel) {
\CIMContactList::CleanChatCache($rel['USER_ID']);
\CPullStack::AddByUser($rel['USER_ID'], array('module_id' => 'im', 'command' => 'chatRename', 'params' => array('chatId' => $newRecord['CHAT_ID'], 'chatTitle' => htmlspecialcharsbx($newRecord['TITLE']))));
}
}
}
if ($oldRecord['AVATAR'] !== $newRecord['AVATAR']) {
if (\CModule::IncludeModule('pull')) {
$avatarImage = \CIMChat::GetAvatarImage($newRecord['AVATAR']);
$ar = \CIMChat::GetRelationById($newRecord['CHAT_ID']);
foreach ($ar as $relation) {
\CIMContactList::CleanChatCache($relation['USER_ID']);
\CPullStack::AddByUser($relation['USER_ID'], array('module_id' => 'im', 'command' => 'chatAvatar', 'params' => array('chatId' => $newRecord['CHAT_ID'], 'chatAvatar' => $avatarImage)));
}
}
}
if ($oldRecord['COLOR'] !== $newRecord['COLOR']) {
if (\CModule::IncludeModule('pull')) {
$ar = \CIMChat::GetRelationById($newRecord['CHAT_ID']);
foreach ($ar as $relation) {
\CIMContactList::CleanChatCache($relation['USER_ID']);
\CPullStack::AddByUser($relation['USER_ID'], array('module_id' => 'im', 'command' => 'chatChangeColor', 'params' => array('chatId' => $newRecord['CHAT_ID'], 'chatColor' => \Bitrix\Im\Color::getColor($newRecord['COLOR']))));
}
}
}
}
public function SetColor($chatId, $color)
{
global $DB;
$chatId = intval($chatId);
if ($chatId <= 0 || !IM\Color::isSafeColor($color)) {
return false;
}
$strSql = "\n\t\t\tSELECT R.CHAT_ID, C.COLOR CHAT_COLOR, C.AUTHOR_ID CHAT_AUTHOR_ID\n\t\t\tFROM b_im_relation R LEFT JOIN b_im_chat C ON R.CHAT_ID = C.ID\n\t\t\tWHERE R.USER_ID = " . $this->user_id . " AND R.MESSAGE_TYPE IN ('" . IM_MESSAGE_OPEN . "','" . IM_MESSAGE_CHAT . "') AND R.CHAT_ID = " . $chatId;
$dbRes = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
if ($arRes = $dbRes->Fetch()) {
if ($arRes['CHAT_COLOR'] == $color) {
return false;
}
IM\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))));
if (CModule::IncludeModule("pull")) {
$ar = CIMChat::GetRelationById($chatId);
foreach ($ar as $rel) {
CIMContactList::CleanChatCache($rel['USER_ID']);
CPullStack::AddByUser($rel['USER_ID'], array('module_id' => 'im', 'command' => 'chatChangeColor', 'params' => array('chatId' => $chatId, 'chatColor' => IM\Color::getColor($color))));
}
}
return true;
}
return false;
}
public static function GetUserColor($id, $gender)
{
$code = IM\Color::getCodeByNumber($id);
if ($gender == 'M') {
$replaceColor = IM\Color::getReplaceColors();
if (isset($replaceColor[$code])) {
$code = $replaceColor[$code];
}
}
return IM\Color::getColor($code);
}
public static function GetList($arParams = array())
{
if (!is_array($arParams)) {
$arParams = array();
}
$arID = array();
if (isset($arParams['ID']) && is_array($arParams['ID']) && !empty($arParams['ID'])) {
foreach ($arParams['ID'] as $key => $value) {
$arID[] = intval($value);
}
} else {
if (isset($arParams['ID']) && intval($arParams['ID']) > 0) {
$arID[] = intval($arParams['ID']);
}
}
$arParams['GET_OFFLINE'] = !empty($arID) && isset($arParams['GET_OFFLINE']) && $arParams['GET_OFFLINE'] == 'Y' ? 'Y' : 'N';
global $USER;
$userId = is_object($USER) ? intval($USER->GetID()) : 0;
$bBusShowAll = !IsModuleInstalled('intranet') && COption::GetOptionInt('im', 'contact_list_show_all_bus');
if (!$bBusShowAll && !isset($arParams['ID']) && $userId > 0 && !isset($arParams['SKIP_CHECK'])) {
if (isset(self::$FRIENDS_USERS[$userId])) {
$arID = self::$FRIENDS_USERS[$userId];
} else {
if (CModule::IncludeModule('socialnetwork') && CSocNetUser::IsFriendsAllowed()) {
$arID = array($userId);
$dbFriends = CSocNetUserRelations::GetList(array(), array("USER_ID" => $userId, "RELATION" => SONET_RELATIONS_FRIEND), false, false, array("ID", "FIRST_USER_ID", "SECOND_USER_ID"));
if ($dbFriends) {
while ($arFriends = $dbFriends->Fetch()) {
$arID[] = $userId == $arFriends["FIRST_USER_ID"] ? $arFriends["SECOND_USER_ID"] : $arFriends["FIRST_USER_ID"];
}
}
self::$FRIENDS_USERS[$userId] = $arID;
}
}
}
$arUsers = array();
if (self::$ONLINE_USERS && $arParams['GET_OFFLINE'] == 'N') {
$arUsers = self::$ONLINE_USERS;
} else {
if (!self::$ONLINE_USERS || $arParams['GET_OFFLINE'] == 'Y') {
$enable = self::Enable();
$arUsers = array();
$query = new \Bitrix\Main\Entity\Query(\Bitrix\Main\UserTable::getEntity());
$query->registerRuntimeField('', new \Bitrix\Main\Entity\ReferenceField('ref', 'Bitrix\\Im\\StatusTable', array('=this.ID' => 'ref.USER_ID')));
$query->addSelect('ID')->addSelect('ref.COLOR', 'COLOR')->addSelect('PERSONAL_GENDER');
if ($enable) {
$query->addSelect('ref.STATUS', 'STATUS')->addSelect('ref.IDLE', 'IDLE')->addSelect('ref.MOBILE_LAST_DATE', 'MOBILE_LAST_DATE');
}
if ($arParams['GET_OFFLINE'] == 'N') {
$query->addFilter('>LAST_ACTIVITY_DATE', new \Bitrix\Main\DB\SqlExpression(Bitrix\Main\Application::getConnection()->getSqlHelper()->addSecondsToDateTime('-180')));
} else {
$sago = Bitrix\Main\Application::getConnection()->getSqlHelper()->addSecondsToDateTime('-180');
$query->registerRuntimeField('', new \Bitrix\Main\Entity\ExpressionField('IS_ONLINE_CUSTOM', 'CASE WHEN LAST_ACTIVITY_DATE > ' . $sago . ' THEN \'Y\' ELSE \'N\' END'));
$query->addSelect('IS_ONLINE_CUSTOM');
$query->addFilter('=ID', $arID);
}
$result = $query->exec();
while ($arUser = $result->fetch()) {
$color = null;
if (isset($arUser['COLOR']) && strlen($arUser['COLOR']) > 0) {
$color = IM\Color::getColor($arUser['COLOR']);
}
if (!$color) {
$color = \CIMContactList::GetUserColor($arUser["ID"], $arUser['PERSONAL_GENDER'] == 'M' ? 'M' : 'F');
}
$arUsers[$arUser["ID"]] = array('id' => $arUser["ID"], 'status' => $enable && in_array($arUser['STATUS'], self::$AVAILABLE_STATUSES) ? $arUser['STATUS'] : 'online', 'color' => $color, 'idle' => $enable && is_object($arUser['IDLE']) ? $arUser['IDLE']->getTimestamp() : 0, 'mobileLastDate' => $enable && is_object($arUser['MOBILE_LAST_DATE']) ? $arUser['MOBILE_LAST_DATE']->getTimestamp() : 0);
if ($arParams['GET_OFFLINE'] == 'Y' && $arUser['IS_ONLINE_CUSTOM'] == 'N') {
$arUsers[$arUser["ID"]]['status'] = 'offline';
$arUsers[$arUser["ID"]]['idle'] = 0;
$arUsers[$arUser["ID"]]['mobileLastDate'] = 0;
}
}
if ($arParams['GET_OFFLINE'] == 'N') {
self::$ONLINE_USERS = $arUsers;
}
}
}
$arResult = array();
if (empty($arID)) {
$arResult = $arUsers;
} else {
foreach ($arID as $userId) {
if (isset($arUsers[$userId])) {
$arResult[$userId] = $arUsers[$userId];
}
}
}
return array('users' => $arResult);
}
