| Server IP : 37.220.80.31 / Your IP : 3.133.134.58 Web Server : Apache/2.4.52 (Ubuntu) System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64 User : www-root ( 1010) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/socialservices/lib/ |
Upload File : |
<?
namespace Bitrix\Socialservices;
use \Bitrix\Main\Entity\DataManager;
use \Bitrix\Socialservices\UserTable as SocservUserTable;
/**
* Class UserLinkTable
*
* DO NOT WRITE ANYTHING BELOW THIS
*
* <<< ORMENTITYANNOTATION
* @method static EO_UserLink_Query query()
* @method static EO_UserLink_Result getByPrimary($primary, array $parameters = array())
* @method static EO_UserLink_Result getById($id)
* @method static EO_UserLink_Result getList(array $parameters = array())
* @method static EO_UserLink_Entity getEntity()
* @method static \Bitrix\Socialservices\EO_UserLink createObject($setDefaultValues = true)
* @method static \Bitrix\Socialservices\EO_UserLink_Collection createCollection()
* @method static \Bitrix\Socialservices\EO_UserLink wakeUpObject($row)
* @method static \Bitrix\Socialservices\EO_UserLink_Collection wakeUpCollection($rows)
*/
class UserLinkTable extends DataManager
{
public static function getFilePath()
{
return __FILE__;
}
public static function getTableName()
{
return 'b_socialservices_user_link';
}
public static function getMap()
{
$fieldsMap = array(
'ID' => array(
'data_type' => 'integer',
'primary' => true,
'autocomplete' => true,
),
'USER_ID' => array(
'data_type' => 'integer',
'required' => true,
),
'SOCSERV_USER_ID' => array(
'data_type' => 'integer',
'required' => true,
),
'LINK_USER_ID' => array(
'data_type' => 'integer',
),
'LINK_UID' => array(
'data_type' => 'string',
'required' => true,
),
'LINK_NAME' => array(
'data_type' => 'string',
),
'LINK_LAST_NAME' => array(
'data_type' => 'string',
),
'LINK_PICTURE' => array(
'data_type' => 'string',
),
'USER' => array(
'data_type' => 'Bitrix\Main\UserTable',
'reference' => array('=this.USER_ID' => 'ref.ID'),
),
'SOCSERV_USER' => array(
'data_type' => 'Bitrix\Socialservices\UserTable',
'reference' => array('=this.SOCSERV_USER_ID' => 'ref.ID'),
),
'LINK_USER' => array(
'data_type' => 'Bitrix\Main\UserTable',
'reference' => array('=this.LINK_USER_ID' => 'ref.ID'),
),
);
return $fieldsMap;
}
public static function deleteBySocserv($userId, $socservProfileId)
{
$connection = \Bitrix\Main\Application::getConnection();
$query = $connection->query("
DELETE
FROM ".self::getTableName()."
WHERE USER_ID='".intval($userId)."' AND SOCSERV_USER_ID='".intval($socservProfileId)."'
");
}
public static function compareUserLinks($userId, $socservUserId, $links)
{
$dbRes = static::getList(array(
'filter' => array(
//'USER_ID' => $userId, // link USER_ID doesn't update with socserv_user
'=SOCSERV_USER_ID' => $socservUserId,
),
'select' => array('ID', 'LINK_UID')
));
$currentList = array();
while($linkInfo = $dbRes->fetch())
{
$currentList[$linkInfo['LINK_UID']] = $linkInfo['ID'];
}
foreach($links as $key => $link)
{
if(array_key_exists($link['uid'], $currentList))
{
unset($currentList[$link['uid']]);
unset($links[$key]);
}
}
foreach($currentList as $linkId)
{
static::delete($linkId);
}
foreach($links as $link)
{
static::add(array(
'USER_ID' => $userId,
'SOCSERV_USER_ID' => $socservUserId,
'LINK_USER_ID' => null, // !!!!!!
'LINK_UID' => $link['uid'],
'LINK_NAME' => $link['first_name'],
'LINK_LAST_NAME' => $link['last_name'],
'LINK_PICTURE' => $link['picture'],
));
}
}
public static function checkUserLinks($socservUserId)
{
$dbRes = UserTable::getByPrimary($socservUserId);
$socservUserInfo = $dbRes->fetch();
if($socservUserInfo)
{
$connection = \Bitrix\Main\Application::getConnection();
$sqlHelper = $connection->getSqlHelper();
$sql = "
SELECT sul.ID, su_link.USER_ID
FROM ".static::getTableName()." sul
LEFT JOIN ".SocservUserTable::getTableName()." su_link ON sul.LINK_UID=su_link.XML_ID
WHERE (1=1)
AND sul.SOCSERV_USER_ID='".intval($socservUserInfo['ID'])."'
AND su_link.EXTERNAL_AUTH_ID='".$sqlHelper->forSql($socservUserInfo['EXTERNAL_AUTH_ID'])."'
AND sul.LINK_USER_ID IS NULL
";
return $connection->query($sql);
}
else
{
return false;
}
}
}