| Server IP : 37.220.80.31 / Your IP : 3.144.232.71 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/esol.importexportexcel/lib/ |
Upload File : |
<?php
namespace Bitrix\KdaImportexcel;
use Bitrix\Main\Entity;
use Bitrix\Main\Localization\Loc;
Loc::loadMessages(__FILE__);
class ProfileExecStatTable extends Entity\DataManager
{
/**
* Returns path to the file which contains definition of the class.
*
* @return string
*/
public static function getFilePath()
{
return __FILE__;
}
/**
* Returns DB table name for entity
*
* @return string
*/
public static function getTableName()
{
return 'b_kdaimportexcel_profile_exec_stat';
}
/**
* Returns entity map definition.
*
* @return array
*/
public static function getMap()
{
return array(
'ID' => new Entity\IntegerField('ID', array(
'primary' => true,
'autocomplete' => true
)),
'PROFILE_ID' => new Entity\IntegerField('PROFILE_ID', array(
'required' => true
)),
'PROFILE_EXEC_ID' => new Entity\IntegerField('PROFILE_EXEC_ID', array(
'required' => true
)),
'DATE_EXEC' => new Entity\DateTimeField('DATE_EXEC', array(
'default_value' => ''
)),
'TYPE' => new Entity\StringField('TYPE', array(
'required' => true
)),
'ENTITY_ID' => new Entity\IntegerField('ENTITY_ID', array(
'required' => true
)),
'ROW_NUMBER' => new Entity\IntegerField('ROW_NUMBER', array(
'required' => true
)),
'FIELDS' => new Entity\TextField('FIELDS', array()),
'PROFILE' => new Entity\ReferenceField(
'PROFILE',
'\Bitrix\KdaImportexcel\ProfileTable',
array('=this.PROFILE_ID' => 'ref.ID'),
array('join_type' => 'LEFT')
),
'PROFILE_EXEC' => new Entity\ReferenceField(
'PROFILE_EXEC',
'\Bitrix\KdaImportexcel\ProfileExecTable',
array('=this.PROFILE_EXEC_ID' => 'ref.ID'),
array('join_type' => 'LEFT')
),
'IBLOCK_ELEMENT' => new Entity\ReferenceField(
'IBLOCK_ELEMENT',
'\Bitrix\Iblock\ElementTable',
array('=this.ENTITY_ID' => 'ref.ID'),
array('join_type' => 'LEFT')
),
'IBLOCK_SECTION' => new Entity\ReferenceField(
'IBLOCK_SECTION',
'\Bitrix\Iblock\SectionTable',
array('=this.ENTITY_ID' => 'ref.ID'),
array('join_type' => 'LEFT')
),
);
}
public static function deleteByProfile($PROFILE_ID, $arExcludedIds = array())
{
if(!is_array($arExcludedIds)) $arExcludedIds = array($arExcludedIds);
$entity = new static();
$tblName = $entity->getTableName();
$conn = $entity->getEntity()->getConnection();
$conn->queryExecute('DELETE FROM `'.$tblName.'` WHERE `PROFILE_ID`='.intval($PROFILE_ID).(count($arExcludedIds) > 0 ? ' and `PROFILE_EXEC_ID` NOT IN ('.implode(', ', array_map('intval', $arExcludedIds)).')' : ''));
}
}