<?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>   

         <adv_commission>

            <xsl:value-of select="reward" />

         </adv_commission>

            <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>