RelationTable::deleteBatch

  1. Bitrix24 API (v. 23.675.0)
  2. im
  3. RelationTable
  4. deleteBatch
  • Модуль: im
  • Путь к файлу: ~/bitrix/modules/im/lib/model/relation.php
  • Класс: BitrixImModelRelationTable
  • Вызов: RelationTable::deleteBatch
static function deleteBatch(array $filter, $limit = 0): int
{
	$tableName = static::getTableName();
	$connection = Application::getConnection();
	$sqlHelper = $connection->getSqlHelper();

	$query = new Query(static::getEntity());
	$query->setFilter($filter);
	$query->getQuery();

	$alias = $sqlHelper->quote($query->getInitAlias()) . '.';
	$where = str_replace($alias, '', $query->getWhere());

	$sql = 'DELETE FROM ' . $tableName . ' WHERE ' . $where;
	if($limit > 0)
	{
		$sql .= ' LIMIT ' . $limit;
	}

	$connection->queryExecute($sql);
	return $connection->getAffectedRowsCount();
}

Добавить комментарий