Postback custom transform

XSLT template

Campaign id

Type

id	campaign_id	type	xslt_template	is_active	created_at	Control
22	13	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-08-07 10:04:41
21	12	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-08-07 10:02:04
20	11	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-08-07 10:01:17
19	10	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-08-07 09:57:12
18	9	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-08-07 09:56:27
17	8	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-08-07 09:55:17
16	7	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-08-07 09:54:04
15	6	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-08-07 09:51:30
14	5	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-08-07 09:43:04
13	2	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-08-07 09:38:49
12	84	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Все статусы как new --> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <xsl:if test="target_code = 'first_login'"> <first_login>1</first_login> </xsl:if> <xsl:if test="target_code = 'active_user'"> <level>1</level> </xsl:if> </item> </xsl:template> </xsl:stylesheet>	1	2025-07-30 12:33:06
4	3	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	1	2025-07-21 11:52:51
1	0	postback	<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl"> <xsl:output method="xml" encoding="utf-8" indent="no"/> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <xsl:variable name="amount"> <xsl:value-of select="substring(orderamount ,'2','10')"/> </xsl:variable> <item> <xsl:if test="number(orderamount)=0.00 or orderamount = '0.00' or orderamount = '¥0.00' "> <invalid_lead>1</invalid_lead> </xsl:if> <xsl:if test="number(orderamount)!=0.00"> <order_id> <xsl:choose> <xsl:when test="not(order_id)"> <xsl:value-of select="orderid"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="order_id"/> </xsl:otherwise> </xsl:choose> </order_id> <xsl:choose> <xsl:when test="not(click_id)"> <click_id> <xsl:value-of select="ouid"/> </click_id> </xsl:when> <xsl:when test="click_id = '' and campaign_secret='BbqZpm'"> <!-- для Panzar --> <click_id>30990-1-1544790995-9170755</click_id> <!-- system click --> </xsl:when> <xsl:when test="click_id = '' and campaign_secret='5dMyMw'"> <!-- для Panzar motiv--> <click_id>30385-1-1544790949-9172617</click_id> <!-- system click --> </xsl:when> </xsl:choose> <order_total> <xsl:value-of select="php:function('preg_replace','/\,/i','',string($amount))"/> </order_total> <xsl:choose> <xsl:when test="ordertype = 'Trains'"> <customer_type>ZHD</customer_type> </xsl:when> <xsl:when test="ordertype = 'HotelInternate'"> <customer_type>H</customer_type> </xsl:when> <xsl:when test="ordertype = 'HotelDomestic'"> <customer_type>H</customer_type> </xsl:when> <xsl:when test="ordertype = 'FlightInternate'"> <customer_type>F</customer_type> </xsl:when> <xsl:when test="ordertype = 'FlightDomestic'"> <customer_type>F</customer_type> </xsl:when> <xsl:otherwise> <invalid_lead>1</invalid_lead> </xsl:otherwise> </xsl:choose> </xsl:if> </item> </xsl:template> </xsl:stylesheet>	1	2025-07-03 12:02:06
188	872	postback	<?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <!-- Нам приходит комиссия с НДС (20%), тут мы удаляем НДС --> <xsl:value-of select="adv_commission div 1.2" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="adv_commission = 0">cancel</xsl:when> <xsl:otherwise> <xsl:value-of select="status" /> </xsl:otherwise> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	0	2025-09-11 17:56:57
66	273	postback	<?xml version="1.0" encoding="UTF-8"?> <!-- Смена статуса и обработака adv_commission \| adv_comission--> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" version="1.0"> <xsl:output method="xml" encoding="utf-8" indent="no" /> <xsl:template match="root"> <items> <xsl:apply-templates /> </items> </xsl:template> <xsl:template match="data"> <item> <order_id> <xsl:value-of select="order_id" /> </order_id> <click_id> <xsl:value-of select="click_id" /> </click_id> <adv_commission> <xsl:value-of select="adv_commission \| adv_comission" /> </adv_commission> <order_total> <xsl:value-of select="order_total" /> </order_total> <status> <xsl:choose> <xsl:when test="status = 'Lead'">new</xsl:when> <xsl:when test="status = 'Sale'">done</xsl:when> <xsl:when test="status = 'Reject'">cancel</xsl:when> </xsl:choose> </status> </item> </xsl:template> </xsl:stylesheet>	0	2025-08-15 19:47:11

Connection: processing; host: nl1-processing-mysql1; user: proc; database: processing; table: transform_custom_postback