| Server IP : 37.220.80.31 / Your IP : 18.191.139.245 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/sale/lib/exchange/integration/entity/ |
Upload File : |
<?php
namespace Bitrix\Sale\Exchange\Integration\Entity;
use Bitrix\Main;
/**
* Class B24IntegrationRelationTable
*
* DO NOT WRITE ANYTHING BELOW THIS
*
* <<< ORMENTITYANNOTATION
* @method static EO_B24IntegrationRelation_Query query()
* @method static EO_B24IntegrationRelation_Result getByPrimary($primary, array $parameters = array())
* @method static EO_B24IntegrationRelation_Result getById($id)
* @method static EO_B24IntegrationRelation_Result getList(array $parameters = array())
* @method static EO_B24IntegrationRelation_Entity getEntity()
* @method static \Bitrix\Sale\Exchange\Integration\Entity\EO_B24IntegrationRelation createObject($setDefaultValues = true)
* @method static \Bitrix\Sale\Exchange\Integration\Entity\EO_B24IntegrationRelation_Collection createCollection()
* @method static \Bitrix\Sale\Exchange\Integration\Entity\EO_B24IntegrationRelation wakeUpObject($row)
* @method static \Bitrix\Sale\Exchange\Integration\Entity\EO_B24IntegrationRelation_Collection wakeUpCollection($rows)
*/
class B24IntegrationRelationTable extends Main\Entity\DataManager
{
public static function getTableName()
{
return 'b_sale_b24integration_relation';
}
public static function getMap()
{
return [
new Main\Entity\IntegerField('SRC_ENTITY_TYPE_ID', [ 'primary' => true ]),
new Main\Entity\IntegerField('SRC_ENTITY_ID', [ 'primary' => true ]),
new Main\Entity\IntegerField('DST_ENTITY_TYPE_ID', [ 'primary' => true ]),
new Main\Entity\IntegerField('DST_ENTITY_ID', [ 'primary' => true ]),
new Main\Entity\DatetimeField('CREATED_TIME'),
new Main\Entity\DatetimeField('LAST_UPDATED_TIME')
];
}
public static function upsert(array $data)
{
$srcEntityTypeID = isset($data['SRC_ENTITY_TYPE_ID']) ? (int)$data['SRC_ENTITY_TYPE_ID'] : \CCrmOwnerType::Undefined;
$srcEntityID = isset($data['SRC_ENTITY_ID']) ? (int)$data['SRC_ENTITY_ID'] : 0;
$dstEntityTypeID = isset($data['DST_ENTITY_TYPE_ID']) ? (int)$data['DST_ENTITY_TYPE_ID'] : \CCrmOwnerType::Undefined;
$dstEntityID = isset($data['DST_ENTITY_ID']) ? (int)$data['DST_ENTITY_ID'] : 0;
$now = Main\Type\DateTime::createFromTimestamp(time() + \CTimeZone::GetOffset());
$insertFields = [
'SRC_ENTITY_TYPE_ID' => $srcEntityTypeID,
'SRC_ENTITY_ID' => $srcEntityID,
'DST_ENTITY_TYPE_ID' => $dstEntityTypeID,
'DST_ENTITY_ID' => $dstEntityID,
'CREATED_TIME' => $now,
'LAST_UPDATED_TIME' => $now
];
$updateFields = [
'LAST_UPDATED_TIME' => $now,
'SRC_ENTITY_TYPE_ID' => $srcEntityTypeID,
'SRC_ENTITY_ID' => $srcEntityID,
'DST_ENTITY_TYPE_ID' => $dstEntityTypeID,
'DST_ENTITY_ID' => $dstEntityID
];
$connection = Main\Application::getConnection();
$queries = $connection->getSqlHelper()->prepareMerge(
static::getTableName(),
[
'SRC_ENTITY_TYPE_ID',
'SRC_ENTITY_ID',
'DST_ENTITY_TYPE_ID',
'DST_ENTITY_ID'
],
$insertFields,
$updateFields
);
foreach($queries as $query)
{
$connection->queryExecute($query);
}
}
}