| Server IP : 37.220.80.31 / Your IP : 18.117.7.212 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 : |
<?php
namespace Bitrix\Socialservices;
use Bitrix\Main;
use Bitrix\Main\Entity;
use Bitrix\Main\Type\DateTime;
/**
* Class ContactConnectTable
*
* Fields:
* <ul>
* <li> ID int mandatory
* <li> TIMESTAMP_X datetime optional default 'CURRENT_TIMESTAMP'
* <li> CONTACT_ID int mandatory
* <li> CONTACT_PROFILE_ID int mandatory
* <li> CONTACT_PORTAL string(255) mandatory
* <li> CONNECT_TYPE string(1) optional default 'P'
* </ul>
*
* @package Bitrix\Socialservices
*
* DO NOT WRITE ANYTHING BELOW THIS
*
* <<< ORMENTITYANNOTATION
* @method static EO_ContactConnect_Query query()
* @method static EO_ContactConnect_Result getByPrimary($primary, array $parameters = array())
* @method static EO_ContactConnect_Result getById($id)
* @method static EO_ContactConnect_Result getList(array $parameters = array())
* @method static EO_ContactConnect_Entity getEntity()
* @method static \Bitrix\Socialservices\EO_ContactConnect createObject($setDefaultValues = true)
* @method static \Bitrix\Socialservices\EO_ContactConnect_Collection createCollection()
* @method static \Bitrix\Socialservices\EO_ContactConnect wakeUpObject($row)
* @method static \Bitrix\Socialservices\EO_ContactConnect_Collection wakeUpCollection($rows)
*/
class ContactConnectTable extends Main\Entity\DataManager
{
const TYPE_PORTAL = 'P'; // bitrix24 portal
const TYPE_EXTERNAL = 'E'; // external site (box)
/**
* Returns DB table name for entity.
*
* @return string
*/
public static function getTableName()
{
return 'b_socialservices_contact_connect';
}
/**
* Returns entity map definition.
*
* @return array
*/
public static function getMap()
{
return array(
'ID' => array(
'data_type' => 'integer',
'primary' => true,
'autocomplete' => true,
),
'TIMESTAMP_X' => array(
'data_type' => 'datetime',
),
'CONTACT_ID' => array(
'data_type' => 'integer',
),
'LINK_ID' => array(
'data_type' => 'integer',
),
'CONTACT_PROFILE_ID' => array(
'data_type' => 'integer',
'required' => true,
),
'CONTACT_PORTAL' => array(
'data_type' => 'string',
'required' => true,
),
'LAST_AUTHORIZE' => array(
'data_type' => 'datetime',
),
'CONNECT_TYPE' => array(
'data_type' => 'enum',
'values' => array(static::TYPE_PORTAL, static::TYPE_EXTERNAL),
),
'CONTACT' => array(
'data_type' => 'Bitrix\Socialservices\ContactTable',
'reference' => array('=this.CONTACT_ID' => 'ref.ID'),
),
'LINK' => array(
'data_type' => 'Bitrix\Socialservices\UserLinkTable',
'reference' => array('=this.LINK_ID' => 'ref.ID'),
),
);
}
public static function onBeforeUpdate(Entity\Event $event)
{
$result = new Entity\EventResult();
$data = $event->getParameter("fields");
if(!isset($data['TIMESTAMP_X']))
{
$data['TIMESTAMP_X'] = new DateTime();
$result->modifyFields($data);
}
}
public static function deleteByLink($linkId)
{
$connection = \Bitrix\Main\Application::getConnection();
return $connection->query("
DELETE
FROM ".self::getTableName()."
WHERE LINK_ID='".intval($linkId)."'
");
}
public static function deleteByContact($contactId)
{
$connection = \Bitrix\Main\Application::getConnection();
return $connection->query("
DELETE
FROM ".self::getTableName()."
WHERE CONTACT_ID='".intval($contactId)."'
");
}
}