ProductAction::convertCrmProducts

static function convertCrmProducts(array $productIdList, int $type): MainResult
{
	$connection = MainApplication::getConnection();
	$helper = $connection->getSqlHelper();

	$productIdSql = $helper->forSql(implode(',', $productIdList));
	$sql = sprintf(
		'UPDATE %s SET TYPE = %d WHERE PRODUCT_ID IN (%s)',
		$helper->quote(CrmProductRowTable::getTableName()),
		$type,
		$productIdSql
	);

	try
	{
		$connection->query($sql);
	}
	catch (MainDBSqlQueryException $exception)
	{
		return (new MainResult())->addError(new MainError($exception->getMessage()));
	}

	return new MainResult();
}