public static function checkUserLinks($socservUserId)
{
$dbRes = UserTable::getByPrimary($socservUserId);
$arUser = $dbRes->fetch();
if ($arUser) {
$sql = "\nSELECT sul.ID, su_link.USER_ID\nFROM " . self::getTableName() . " sul\nLEFT JOIN " . SocservUserTable::getTableName() . " su_link ON sul.LINK_UID=su_link.XML_ID\nWHERE (1=1)\nAND sul.SOCSERV_USER_ID='" . $arUser['ID'] . "'\nAND su_link.EXTERNAL_AUTH_ID='" . $arUser['EXTERNAL_AUTH_ID'] . "'\nAND sul.LINK_USER_ID IS NULL\n";
$connection = \Bitrix\Main\Application::getConnection();
return $connection->query($sql);
} else {
return false;
}
}
<?php
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\Text\Converter;
/**
* @global int $ID - Edited user id
* @global string $strError - Save error
* @global \CUser $USER
* @global CMain $APPLICATION
*/
Loc::loadMessages(__FILE__);
$ID = intval($ID);
if ($ID > 0 && \Bitrix\Main\Loader::includeModule('socialservices') && \Bitrix\Main\Config\Option::get("socialservices", "bitrix24net_id", "") != "") {
$dbRes = \Bitrix\Socialservices\UserTable::getList(array('filter' => array('=USER_ID' => $ID, '=EXTERNAL_AUTH_ID' => CSocServBitrix24Net::ID)));
$profileInfo = $dbRes->fetch();
?>
<input type="hidden" name="profile_module_id[]" value="socialservices">
<?php
if (!$profileInfo) {
?>
<tr>
<td>
<?php
echo BeginNote();
if ($ID == $USER->GetID()) {
$url = \Bitrix\Socialservices\Network::getAuthUrl("popup", array("admin"));
?>
<?php
echo Loc::getMessage("SS_USERTAB_NOT_CONNECTED_SELF");
?>
<input type="button" onclick="BX.util.popup('<?php
/**
* Prepares and shows popup offerring current user to attach bitrix24.net account
*/
public static function displayAdminPopup(array $params = array())
{
global $USER;
if (static::getAdminPopupSession()) {
$dbRes = UserTable::getList(array('filter' => array('=USER_ID' => $USER->GetID(), '=EXTERNAL_AUTH_ID' => \CSocServBitrix24Net::ID)));
if (!$dbRes->fetch()) {
static::initAdminPopup($params);
} else {
static::setAdminPopupSession();
}
}
}
protected function deleteStorageTokens()
{
global $USER;
if (is_object($USER) && $USER->IsAuthorized()) {
$dbSocservUser = \Bitrix\Socialservices\UserTable::getList(array('filter' => array('=USER_ID' => $USER->GetID(), "=EXTERNAL_AUTH_ID" => static::SERVICE_ID), 'select' => array("ID")));
while ($accessToken = $dbSocservUser->fetch()) {
\Bitrix\Socialservices\UserTable::delete($accessToken['ID']);
}
}
}
<?php
if (!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED !== true) {
die;
}
if (\Bitrix\Main\Loader::includeModule('socialservices')) {
$dbRes = \Bitrix\SocialServices\UserTable::getList(array('filter' => array('USER_ID' => $arParams['USER_ID'], 'EXTERNAL_AUTH_ID' => CSocServBitrix24Net::ID), 'select' => array('NAME', 'LAST_NAME', 'LOGIN', 'PERSONAL_WWW')));
$arResult['NETWORK_ACCOUNT'] = $dbRes->fetch();
}
protected function deleteStorageTokens()
{
if ($this->userId > 0) {
$dbSocservUser = \Bitrix\Socialservices\UserTable::getList(array('filter' => array('=USER_ID' => $this->userId, "=EXTERNAL_AUTH_ID" => static::SERVICE_ID), 'select' => array("ID")));
while ($accessToken = $dbSocservUser->fetch()) {
\Bitrix\Socialservices\UserTable::delete($accessToken['ID']);
}
}
}
<?php
/**
* @global int $ID - Edited user id
* @global string $strError - Save error
* @global \CUser $USER
* @global CMain $APPLICATION
*/
use Bitrix\Main\Config\Option;
use Bitrix\Main\Loader;
use Bitrix\Socialservices\UserTable;
$ID = intval($ID);
$socialservices_res = true;
if ($ID > 0 && isset($_REQUEST["SS_REMOVE_NETWORK"]) && $_REQUEST["SS_REMOVE_NETWORK"] == "Y" && Option::get("socialservices", "bitrix24net_id", "") != "" && Loader::includeModule('socialservices') && check_bitrix_sessid()) {
$dbRes = UserTable::getList(array('filter' => array('=USER_ID' => $ID, '=EXTERNAL_AUTH_ID' => CSocServBitrix24Net::ID), 'select' => array('ID')));
$profileInfo = $dbRes->fetch();
if ($profileInfo) {
$deleteResult = UserTable::delete($profileInfo["ID"]);
$socialservices_res = $deleteResult->isSuccess();
if ($socialservices_res) {
\Bitrix\Socialservices\Network::clearAdminPopupSession($ID);
}
}
}
public function AuthorizeUser($socservUserFields)
{
global $USER, $APPLICATION;
if (!isset($socservUserFields['XML_ID']) || $socservUserFields['XML_ID'] == '') {
return false;
}
if (!isset($socservUserFields['EXTERNAL_AUTH_ID']) || $socservUserFields['EXTERNAL_AUTH_ID'] == '') {
return false;
}
$oauthKeys = array();
if (isset($socservUserFields["OATOKEN"])) {
$oauthKeys["OATOKEN"] = $socservUserFields["OATOKEN"];
}
if (isset($socservUserFields["REFRESH_TOKEN"]) && $socservUserFields["REFRESH_TOKEN"] !== '') {
$oauthKeys["REFRESH_TOKEN"] = $socservUserFields["REFRESH_TOKEN"];
}
if (isset($socservUserFields["OATOKEN_EXPIRES"])) {
$oauthKeys["OATOKEN_EXPIRES"] = $socservUserFields["OATOKEN_EXPIRES"];
}
$errorCode = SOCSERV_AUTHORISATION_ERROR;
$dbSocUser = UserTable::getList(array('filter' => array('=XML_ID' => $socservUserFields['XML_ID'], '=EXTERNAL_AUTH_ID' => $socservUserFields['EXTERNAL_AUTH_ID']), 'select' => array("ID", "USER_ID", "ACTIVE" => "USER.ACTIVE")));
$socservUser = $dbSocUser->fetch();
if ($USER->IsAuthorized()) {
if (!$this->checkRestrictions || !self::isSplitDenied()) {
if (!$socservUser) {
$socservUserFields["USER_ID"] = $USER->GetID();
$result = UserTable::add(UserTable::filterFields($socservUserFields));
$id = $result->getId();
} else {
$id = $socservUser['ID'];
// socservice link split
if ($socservUser['USER_ID'] != $USER->GetID()) {
if ($this->allowChangeOwner) {
$dbSocUser = UserTable::getList(array('filter' => array('=USER_ID' => $USER->GetID(), '=EXTERNAL_AUTH_ID' => $socservUserFields['EXTERNAL_AUTH_ID']), 'select' => array("ID")));
if ($dbSocUser->fetch()) {
return SOCSERV_AUTHORISATION_ERROR;
} else {
$oauthKeys['USER_ID'] = $USER->GetID();
$oauthKeys['CAN_DELETE'] = 'Y';
}
} else {
return SOCSERV_AUTHORISATION_ERROR;
}
}
}
if ($_SESSION["OAUTH_DATA"] && is_array($_SESSION["OAUTH_DATA"])) {
$oauthKeys = array_merge($oauthKeys, $_SESSION['OAUTH_DATA']);
unset($_SESSION["OAUTH_DATA"]);
}
UserTable::update($id, $oauthKeys);
} else {
return SOCSERV_REGISTRATION_DENY;
}
} else {
$entryId = 0;
$USER_ID = 0;
if ($socservUser) {
$entryId = $socservUser['ID'];
if ($socservUser["ACTIVE"] === 'Y') {
$USER_ID = $socservUser["USER_ID"];
}
} else {
// check for user with old socialservices linking system (socservice ID in user's EXTERNAL_AUTH_ID)
$dbUsersOld = CUser::GetList($by = 'ID', $ord = 'ASC', array('XML_ID' => $socservUserFields['XML_ID'], 'EXTERNAL_AUTH_ID' => $socservUserFields['EXTERNAL_AUTH_ID'], 'ACTIVE' => 'Y'), array('NAV_PARAMS' => array("nTopCount" => "1")));
$socservUser = $dbUsersOld->Fetch();
if ($socservUser) {
$USER_ID = $socservUser["ID"];
} else {
// theoretically possible situation with abandoned external user w/o b_socialservices_user entry
$dbUsersNew = CUser::GetList($by = 'ID', $ord = 'ASC', array('XML_ID' => $socservUserFields['XML_ID'], 'EXTERNAL_AUTH_ID' => 'socservices', 'ACTIVE' => 'Y'), array('NAV_PARAMS' => array("nTopCount" => "1")));
$socservUser = $dbUsersNew->Fetch();
if ($socservUser) {
$USER_ID = $socservUser["ID"];
} elseif (COption::GetOptionString("main", "new_user_registration", "N") == "Y" && COption::GetOptionString("socialservices", "allow_registration", "Y") == "Y") {
$socservUserFields['PASSWORD'] = randString(30);
//not necessary but...
$socservUserFields['LID'] = SITE_ID;
$def_group = Option::get('main', 'new_user_registration_def_group', '');
if ($def_group != '') {
$socservUserFields['GROUP_ID'] = explode(',', $def_group);
}
if ($this->checkRestrictions && !empty($socservUserFields['GROUP_ID']) && self::isAuthDenied($socservUserFields['GROUP_ID'])) {
$errorCode = SOCSERV_REGISTRATION_DENY;
} else {
$userFields = $socservUserFields;
$userFields["EXTERNAL_AUTH_ID"] = "socservices";
if (isset($userFields['PERSONAL_PHOTO']) && is_array($userFields['PERSONAL_PHOTO'])) {
$res = CFile::CheckImageFile($userFields["PERSONAL_PHOTO"]);
if ($res != '') {
unset($userFields['PERSONAL_PHOTO']);
}
}
$USER_ID = $USER->Add($userFields);
if ($USER_ID <= 0) {
$errorCode = SOCSERV_AUTHORISATION_ERROR;
}
}
} elseif (Option::get("main", "new_user_registration", "N") == "N") {
$errorCode = SOCSERV_REGISTRATION_DENY;
}
$socservUserFields['CAN_DELETE'] = 'N';
}
}
if (isset($_SESSION["OAUTH_DATA"]) && is_array($_SESSION["OAUTH_DATA"])) {
foreach ($_SESSION['OAUTH_DATA'] as $key => $value) {
$socservUserFields[$key] = $value;
}
unset($_SESSION["OAUTH_DATA"]);
}
if ($USER_ID > 0) {
$arGroups = $USER->GetUserGroup($USER_ID);
if ($this->checkRestrictions && self::isAuthDenied($arGroups)) {
return SOCSERV_AUTHORISATION_ERROR;
}
if ($entryId > 0) {
UserTable::update($entryId, UserTable::filterFields($socservUserFields));
} else {
$socservUserFields['USER_ID'] = $USER_ID;
UserTable::add(UserTable::filterFields($socservUserFields));
}
if (isset($socservUserFields["TIME_ZONE_OFFSET"]) && $socservUserFields["TIME_ZONE_OFFSET"] !== null) {
CTimeZone::SetCookieValue($socservUserFields["TIME_ZONE_OFFSET"]);
}
$USER->AuthorizeWithOtp($USER_ID);
if ($USER->IsJustAuthorized()) {
ContactTable::onUserLoginSocserv($socservUserFields);
foreach (GetModuleEvents("socialservices", "OnUserLoginSocserv", true) as $arEvent) {
ExecuteModuleEventEx($arEvent, array($socservUserFields));
}
}
} else {
return $errorCode;
}
// possible redirect after authorization, so no spreading. Store cookies in the session for next hit
$APPLICATION->StoreCookies();
}
return true;
}
public static function onNetworkBroadcast($data)
{
$contactsList = array();
$possibleContactsList = array();
if (isset($data["contact"]) && is_array($data["contact"])) {
foreach ($data["contact"] as $contact) {
if (!isset($contactsList[$contact['CONTACT_OWNER']])) {
$contactsList[$contact['CONTACT_OWNER']] = array();
}
$contactsList[$contact['CONTACT_OWNER']][] = $contact;
}
}
if (isset($data["contact_possible"]) && is_array($data["contact_possible"])) {
foreach ($data["contact_possible"] as $contact) {
if (!isset($possibleContactsList[$contact['CONTACT_OWNER']])) {
$possibleContactsList[$contact['CONTACT_OWNER']] = array();
}
$possibleContactsList[$contact['CONTACT_OWNER']][] = $contact;
}
}
$dbRes = UserTable::getList(array('filter' => array('=EXTERNAL_AUTH_ID' => \CSocServBitrix24Net::ID, '=XML_ID' => array_unique(array_merge(array_keys($contactsList), array_keys($possibleContactsList)))), 'select' => array('ID', 'USER_ID', 'XML_ID')));
while ($owner = $dbRes->fetch()) {
if (count($contactsList) > 0 && count($contactsList[$owner["XML_ID"]]) > 0) {
static::processContacts($owner, $contactsList[$owner["XML_ID"]]);
}
if (count($possibleContactsList) > 0 && count($possibleContactsList[$owner["XML_ID"]]) > 0) {
static::processPossibleContacts($owner, $possibleContactsList[$owner["XML_ID"]]);
}
}
}
