Dimitrii dimitriipro

## slugify.py
from transliterate import slugify
i_name = slugify(name)

## Удалить все цены у заданных производителей Битрикс.sql
DELETE FROM bitrix_49.b_catalog_price WHERE CATALOG_GROUP_ID = 1 AND PRODUCT_ID IN (
SELECT bcp.ID FROM bitrix_49.b_catalog_product AS bcp
	INNER JOIN bitrix_49.b_iblock_element AS bie
				ON bcp.ID = bie.ID
	INNER JOIN bitrix_49.b_iblock_element_property AS brend
				ON bcp.ID = brend.IBLOCK_ELEMENT_ID
                WHERE brend.IBLOCK_PROPERTY_ID = 29
                # перечисляем производителей у которых надо удалить цену
                AND brend.VALUE IN (1285,962, 1029, 988));

## Разбить текст на слова и цифры.py
import re

s = 'Абат2 НП34-4ЖШ gn3 br 1 tn'
t = re.findall('[a-zA-Zа-яА-Я]+|\\d+', s)
m = ' '.join(t)
print(m)
	DELETE FROM bitrix_49.b_catalog_price WHERE CATALOG_GROUP_ID = 1 AND PRODUCT_ID IN (
	SELECT bcp.ID FROM bitrix_49.b_catalog_product AS bcp
	INNER JOIN bitrix_49.b_iblock_element AS bie
	ON bcp.ID = bie.ID
	INNER JOIN bitrix_49.b_iblock_element_property AS brend
	ON bcp.ID = brend.IBLOCK_ELEMENT_ID
	WHERE brend.IBLOCK_PROPERTY_ID = 29
	# перечисляем производителей у которых надо удалить цену
	AND brend.VALUE IN (1285,962, 1029, 988));
	import re

	s = 'Абат2 НП34-4ЖШ gn3 br 1 tn'
	t = re.findall('[a-zA-Zа-яА-Я]+\|\\d+', s)
	m = ' '.join(t)
	print(m)