| Server IP : 37.220.80.31 / Your IP : 3.144.9.82 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/forum/lib/ |
Upload File : |
<?php
namespace Bitrix\Forum;
use Bitrix\Main;
use Bitrix\Main\ORM\Fields\Relations\Reference;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Main\Entity;
/**
* Class UserForumTable
*
* DO NOT WRITE ANYTHING BELOW THIS
*
* <<< ORMENTITYANNOTATION
* @method static EO_UserForum_Query query()
* @method static EO_UserForum_Result getByPrimary($primary, array $parameters = array())
* @method static EO_UserForum_Result getById($id)
* @method static EO_UserForum_Result getList(array $parameters = array())
* @method static EO_UserForum_Entity getEntity()
* @method static \Bitrix\Forum\EO_UserForum createObject($setDefaultValues = true)
* @method static \Bitrix\Forum\EO_UserForum_Collection createCollection()
* @method static \Bitrix\Forum\EO_UserForum wakeUpObject($row)
* @method static \Bitrix\Forum\EO_UserForum_Collection wakeUpCollection($rows)
*/
class UserForumTable extends Main\Entity\DataManager
{
public static function getTableName(): string
{
return 'b_forum_user_forum';
}
public static function getMap()
{
return [
new Entity\IntegerField('ID', ['autocomplete' => true]),
new Entity\IntegerField('USER_ID', ['primary' => true]),
new Entity\IntegerField('FORUM_ID', ['primary' => true]),
new Entity\DatetimeField('LAST_VISIT'),
new Entity\DatetimeField('MAIN_LAST_VISIT'),
new Reference('USER', Main\UserTable::class, Join::on('this.USER_ID', 'ref.ID')),
new Reference('FORUM_USER', UserTable::class, Join::on('this.USER_ID', 'ref.USER_ID')),
];
}
public static function deleteBatch(array $filter)
{
$tableName = static::getTableName();
$connection = Main\Application::getConnection();
$helper = $connection->getSqlHelper();
$where = [];
foreach ($filter as $key => $value)
{
$where[] = $helper->prepareAssignment($tableName, $key, $value);
}
$where = implode(' AND ', $where);
if($where)
{
$quotedTableName = $helper->quote($tableName);
$connection->queryExecute("DELETE FROM {$quotedTableName} WHERE {$where}");
}
}
}