Tentative de conversion de valeurs sur plusieurs balises identiques
Bonjour à tous,
Etant complètement néophyte dans la création d'XSLT, j'ai énormément de mal à réaliser ce que je souhaite... j'en appelle donc à votre aide :) .
Voici le contexte :
Travaillant actuellement sur un WMS (logiciel de gestion d'entrepôt), celui ci envoie plusieurs messages à un ERP pour confirmer des réceptions, des mouvements de stocks,etc. On appelle ces messages des PIX, ils ont tous la même structure et sont envoyés sous format XML. Un même fichier XML peut comporter plusieurs PIX.
Notre WMS travaillant en centimètres et notre ERP en mètres, je dois appliquer une conversion directement sur mon XML de sortie sur certaines balises particulières avant d'envoyer le message à mon ERP. D'où l'utilisation d'un XSLT.
En partant , d'un fichier comportant uniquement un PIX comme celui ci :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
| <?xml version="1.0" encoding="UTF-8"?>
<tXML>
<Header>
<Source>MANH_wms</Source>
<Message_Type>PIX</Message_Type>
</Header>
<Message>
<PIX>
<TransactionType>606</TransactionType>
<TransactionCode>03</TransactionCode>
<TransactionNumber>14818</TransactionNumber>
<SequenceNumber>1</SequenceNumber>
<UserID>WMADMIN</UserID>
<ItemDefinition>
<Style>2020</Style>
<StyleSuffix>TISS1</StyleSuffix>
<SizeDesc>01</SizeDesc>
</ItemDefinition>
<SubItemFields>
<InventoryType>F</InventoryType>
<BatchNumber></BatchNumber>
</SubItemFields>
<PIXFields>
<DateCreated>04/16/20 18:50:49</DateCreated>
<InvAdjustmentQty>200</InvAdjustmentQty>
<UnitOfMeasure>M</UnitOfMeasure>
<InvAdjustmentType>A</InvAdjustmentType>
<Warehouse>FRM</Warehouse>
<TransReasonCode></TransReasonCode>
<ReceiptsVariance></ReceiptsVariance>
<UnitsShipped>0</UnitsShipped>
<UnitsReceived>200</UnitsReceived>
<ReferenceCode1>12</ReferenceCode1>
<Reference1>POW105001</Reference1>
<ReferenceCode2>C02</ReferenceCode2>
<Reference2>BL00000123</Reference2>
<ReferenceCode3>C03</ReferenceCode3>
<Reference3>2020-04-07 03:46:00.0</Reference3>
<ReferenceCode4>37</ReferenceCode4>
<Reference4>5001285</Reference4>
<ReferenceCode5>43</ReferenceCode5>
<Reference5>PW105-TISS1-01-3</Reference5>
<ReferenceCode6>08</ReferenceCode6>
<Reference6>000000110</Reference6>
<ReferenceCode7>C07</ReferenceCode7>
<Reference7></Reference7>
<ReferenceCode8>25</ReferenceCode8>
<Reference8>QH</Reference8>
<ReferenceCode9></ReferenceCode9>
<Reference9></Reference9>
<ReferenceCode10></ReferenceCode10>
<Reference10></Reference10>
<ActionCode></ActionCode>
</PIXFields>
</PIX>
</Message>
</tXML> |
Je souhaite modifier les balises <InvAdjustmentQty>, <UnitsShipped> et , <UnitsReceived> à condition que la valeur de <UnitOfMeasure> soit en M ou M2 . Sinon je ne réalise aucune opération et renvoie la valeur initiale.
Voici donc ce que j'ai réalisé :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
| <?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output omit-xml-declaration="yes" indent="yes"/>
<xsl:template match="node()|@*">
<xsl:copy>
<xsl:apply-templates select="node()|@*"/>
</xsl:copy>
</xsl:template>
<!-- Template Conversion Valeur-->
<xsl:variable name= "var1" select = "0.01"/>
<xsl:variable name= "var2" select = "0.0001"/>
<xsl:template match="*/UnitsReceived">
<xsl:choose>
<xsl:when test="/tXML/Message/PIX/PIXFields/UnitOfMeasure='M'">
<UnitsReceived>
<xsl:value-of select="/tXML/Message/PIX/PIXFields/UnitsReceived * $var1"/>
</UnitsReceived>
</xsl:when>
<xsl:when test="/tXML/Message/PIX/PIXFields/UnitOfMeasure='M2'">
<UnitsReceived>
<xsl:value-of select="/tXML/Message/PIX/PIXFields/UnitsReceived * $var2"/>
</UnitsReceived>
</xsl:when>
<xsl:otherwise>
<UnitsReceived>
<xsl:value-of select="node()|@*"/>
</UnitsReceived>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:template match="*/UnitsShipped">
<xsl:choose>
<xsl:when test="/tXML/Message/PIX/PIXFields/UnitOfMeasure='M'">
<UnitsShipped>
<xsl:value-of select="/tXML/Message/PIX/PIXFields/UnitsShipped * $var1"/>
</UnitsShipped>
</xsl:when>
<xsl:when test="/tXML/Message/PIX/PIXFields/UnitOfMeasure='M2'">
<UnitsShipped>
<xsl:value-of select="/tXML/Message/PIX/PIXFields/UnitsShipped * $var2"/>
</UnitsShipped>
</xsl:when>
<xsl:otherwise>
<UnitsShipped>
<xsl:value-of select="node()|@*"/>
</UnitsShipped>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:template match="*/InvAdjustmentQty">
<xsl:choose>
<xsl:when test="/tXML/Message/PIX/PIXFields/UnitOfMeasure='M'">
<InvAdjustmentQty>
<xsl:value-of select="/tXML/Message/PIX/PIXFields/InvAdjustmentQty * $var1"/>
</InvAdjustmentQty>
</xsl:when>
<xsl:when test="/tXML/Message/PIX/PIXFields/UnitOfMeasure='M2'">
<InvAdjustmentQty>
<xsl:value-of select="/tXML/Message/PIX/PIXFields/InvAdjustmentQty * $var2"/>
</InvAdjustmentQty>
</xsl:when>
<xsl:otherwise>
<InvAdjustmentQty>
<xsl:value-of select="node()|@*"/>
</InvAdjustmentQty>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
</xsl:stylesheet> |
J'obtiens bien ce que je veux à savoir :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
| <tXML>
<Header>
<Source>MANH_wms</Source>
<Message_Type>PIX</Message_Type>
</Header>
<Message>
<PIX>
<TransactionType>606</TransactionType>
<TransactionCode>03</TransactionCode>
<TransactionNumber>14818</TransactionNumber>
<SequenceNumber>1</SequenceNumber>
<UserID>WMADMIN</UserID>
<ItemDefinition>
<Style>2020</Style>
<StyleSuffix>TISS1</StyleSuffix>
<SizeDesc>01</SizeDesc>
</ItemDefinition>
<SubItemFields>
<InventoryType>F</InventoryType>
<BatchNumber/>
</SubItemFields>
<PIXFields>
<DateCreated>04/16/20 18:50:49</DateCreated>
<InvAdjustmentQty>20</InvAdjustmentQty>
<UnitOfMeasure>M</UnitOfMeasure>
<InvAdjustmentType>A</InvAdjustmentType>
<Warehouse>FRM</Warehouse>
<TransReasonCode/>
<ReceiptsVariance/>
<UnitsShipped>100</UnitsShipped>
<UnitsReceived>50</UnitsReceived>
<ReferenceCode1>12</ReferenceCode1>
<Reference1>POW105001</Reference1>
<ReferenceCode2>C02</ReferenceCode2>
<Reference2>BL00000123</Reference2>
<ReferenceCode3>C03</ReferenceCode3>
<Reference3>2020-04-07 03:46:00.0</Reference3>
<ReferenceCode4>37</ReferenceCode4>
<Reference4>5001285</Reference4>
<ReferenceCode5>43</ReferenceCode5>
<Reference5>PW105-TISS1-01-3</Reference5>
<ReferenceCode6>08</ReferenceCode6>
<Reference6>000000110</Reference6>
<ReferenceCode7>C07</ReferenceCode7>
<Reference7/>
<ReferenceCode8>25</ReferenceCode8>
<Reference8>QH</Reference8>
<ReferenceCode9/>
<Reference9/>
<ReferenceCode10/>
<Reference10/>
<ActionCode/>
</PIXFields>
</PIX>
</Message>
</tXML> |
Jusque là c'est OK. Sauf que dans mon fichier XML, comme je l'ai mentionné plus haut, plusieurs PIX seront présents (un nombre de PIX aléatoire).
Supposons maintenant que mon WMS envoie 3 PIX dans un même fichier. Les deux premiers en M éligibles à une conversion , le dernier en Unit non.
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151
| <?xml version="1.0" encoding="UTF-8"?>
<tXML>
<Header>
<Source>MANH_wms</Source>
<Message_Type>PIX</Message_Type>
</Header>
<Message>
<PIX>
<TransactionType>300</TransactionType>
<TransactionCode>01</TransactionCode>
<TransactionNumber>14836</TransactionNumber>
<SequenceNumber>1</SequenceNumber>
<ItemDefinition>
<Style>2020</Style>
<StyleSuffix>CUIR1</StyleSuffix>
<SizeDesc>01</SizeDesc>
</ItemDefinition>
<SubItemFields>
<InventoryType>P</InventoryType>
<BatchNumber>A128348</BatchNumber>
</SubItemFields>
<PIXFields>
<DateCreated>04/16/20 19:44:22</DateCreated>
<InvAdjustmentQty>10000</InvAdjustmentQty>
<UnitOfMeasure>M</UnitOfMeasure>
<InvAdjustmentType>S</InvAdjustmentType>
<Warehouse>FRM</Warehouse>
<TransReasonCode></TransReasonCode>
<ReceiptsVariance></ReceiptsVariance>
<UnitsShipped>150</UnitsShipped>
<UnitsReceived>3000</UnitsReceived>
<ReferenceCode1>12</ReferenceCode1>
<Reference1>110350</Reference1>
<ReferenceCode2>C02</ReferenceCode2>
<Reference2>BL00001123</Reference2>
<ReferenceCode3>C03</ReferenceCode3>
<Reference3>2016-09-15 03:28:00.0</Reference3>
<ReferenceCode4>37</ReferenceCode4>
<Reference4></Reference4>
<ReferenceCode5>43</ReferenceCode5>
<Reference5></Reference5>
<ReferenceCode6>08</ReferenceCode6>
<Reference6>SASN20301</Reference6>
<ReferenceCode7>C07</ReferenceCode7>
<Reference7></Reference7>
<ReferenceCode8>25</ReferenceCode8>
<Reference8>PS</Reference8>
<ReferenceCode9></ReferenceCode9>
<Reference9></Reference9>
<ReferenceCode10></ReferenceCode10>
<Reference10></Reference10>
<ActionCode>19</ActionCode>
</PIXFields>
</PIX>
<PIX>
<TransactionType>300</TransactionType>
<TransactionCode>01</TransactionCode>
<TransactionNumber>14836</TransactionNumber>
<SequenceNumber>1</SequenceNumber>
<ItemDefinition>
<Style>2020</Style>
<StyleSuffix>CUIR1</StyleSuffix>
<SizeDesc>01</SizeDesc>
</ItemDefinition>
<SubItemFields>
<InventoryType>P</InventoryType>
<BatchNumber>A128348</BatchNumber>
</SubItemFields>
<PIXFields>
<DateCreated>04/16/20 19:44:22</DateCreated>
<InvAdjustmentQty>3000</InvAdjustmentQty>
<UnitOfMeasure>M</UnitOfMeasure>
<InvAdjustmentType>S</InvAdjustmentType>
<Warehouse>FRM</Warehouse>
<TransReasonCode></TransReasonCode>
<ReceiptsVariance></ReceiptsVariance>
<UnitsShipped>0</UnitsShipped>
<UnitsReceived>3000</UnitsReceived>
<ReferenceCode1>12</ReferenceCode1>
<Reference1>110350</Reference1>
<ReferenceCode2>C02</ReferenceCode2>
<Reference2>BL00001123</Reference2>
<ReferenceCode3>C03</ReferenceCode3>
<Reference3>2016-09-15 03:28:00.0</Reference3>
<ReferenceCode4>37</ReferenceCode4>
<Reference4></Reference4>
<ReferenceCode5>43</ReferenceCode5>
<Reference5></Reference5>
<ReferenceCode6>08</ReferenceCode6>
<Reference6>SASN20301</Reference6>
<ReferenceCode7>C07</ReferenceCode7>
<Reference7></Reference7>
<ReferenceCode8>25</ReferenceCode8>
<Reference8>PS</Reference8>
<ReferenceCode9></ReferenceCode9>
<Reference9></Reference9>
<ReferenceCode10></ReferenceCode10>
<Reference10></Reference10>
<ActionCode>19</ActionCode>
</PIXFields>
</PIX>
<PIX>
<TransactionType>300</TransactionType>
<TransactionCode>01</TransactionCode>
<TransactionNumber>14836</TransactionNumber>
<SequenceNumber>1</SequenceNumber>
<ItemDefinition>
<Style>2020</Style>
<StyleSuffix>CUIR1</StyleSuffix>
<SizeDesc>01</SizeDesc>
</ItemDefinition>
<SubItemFields>
<InventoryType>P</InventoryType>
<BatchNumber>A128348</BatchNumber>
</SubItemFields>
<PIXFields>
<DateCreated>04/16/20 19:44:22</DateCreated>
<InvAdjustmentQty>4000</InvAdjustmentQty>
<UnitOfMeasure>Unit</UnitOfMeasure>
<InvAdjustmentType>S</InvAdjustmentType>
<Warehouse>FRM</Warehouse>
<TransReasonCode></TransReasonCode>
<ReceiptsVariance></ReceiptsVariance>
<UnitsShipped>0</UnitsShipped>
<UnitsReceived>4000</UnitsReceived>
<ReferenceCode1>12</ReferenceCode1>
<Reference1>110350</Reference1>
<ReferenceCode2>C02</ReferenceCode2>
<Reference2>BL00001123</Reference2>
<ReferenceCode3>C03</ReferenceCode3>
<Reference3>2016-09-15 03:28:00.0</Reference3>
<ReferenceCode4>37</ReferenceCode4>
<Reference4></Reference4>
<ReferenceCode5>43</ReferenceCode5>
<Reference5></Reference5>
<ReferenceCode6>08</ReferenceCode6>
<Reference6>SASN20301</Reference6>
<ReferenceCode7>C07</ReferenceCode7>
<Reference7></Reference7>
<ReferenceCode8>25</ReferenceCode8>
<Reference8>PS</Reference8>
<ReferenceCode9></ReferenceCode9>
<Reference9></Reference9>
<ReferenceCode10></ReferenceCode10>
<Reference10></Reference10>
<ActionCode>19</ActionCode>
</PIXFields>
</PIX>
</Message>
</tXML> |
Si je lance la transformation, j'obtiens ceci :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150
| <tXML>
<Header>
<Source>MANH_wms</Source>
<Message_Type>PIX</Message_Type>
</Header>
<Message>
<PIX>
<TransactionType>300</TransactionType>
<TransactionCode>01</TransactionCode>
<TransactionNumber>14836</TransactionNumber>
<SequenceNumber>1</SequenceNumber>
<ItemDefinition>
<Style>2020</Style>
<StyleSuffix>CUIR1</StyleSuffix>
<SizeDesc>01</SizeDesc>
</ItemDefinition>
<SubItemFields>
<InventoryType>P</InventoryType>
<BatchNumber>A128348</BatchNumber>
</SubItemFields>
<PIXFields>
<DateCreated>04/16/20 19:44:22</DateCreated>
<InvAdjustmentQty>100</InvAdjustmentQty>
<UnitOfMeasure>M</UnitOfMeasure>
<InvAdjustmentType>S</InvAdjustmentType>
<Warehouse>FRM</Warehouse>
<TransReasonCode/>
<ReceiptsVariance/>
<UnitsShipped>1.5</UnitsShipped>
<UnitsReceived>30</UnitsReceived>
<ReferenceCode1>12</ReferenceCode1>
<Reference1>110350</Reference1>
<ReferenceCode2>C02</ReferenceCode2>
<Reference2>BL00001123</Reference2>
<ReferenceCode3>C03</ReferenceCode3>
<Reference3>2016-09-15 03:28:00.0</Reference3>
<ReferenceCode4>37</ReferenceCode4>
<Reference4/>
<ReferenceCode5>43</ReferenceCode5>
<Reference5/>
<ReferenceCode6>08</ReferenceCode6>
<Reference6>SASN20301</Reference6>
<ReferenceCode7>C07</ReferenceCode7>
<Reference7/>
<ReferenceCode8>25</ReferenceCode8>
<Reference8>PS</Reference8>
<ReferenceCode9/>
<Reference9/>
<ReferenceCode10/>
<Reference10/>
<ActionCode>19</ActionCode>
</PIXFields>
</PIX>
<PIX>
<TransactionType>300</TransactionType>
<TransactionCode>01</TransactionCode>
<TransactionNumber>14836</TransactionNumber>
<SequenceNumber>1</SequenceNumber>
<ItemDefinition>
<Style>2020</Style>
<StyleSuffix>CUIR1</StyleSuffix>
<SizeDesc>01</SizeDesc>
</ItemDefinition>
<SubItemFields>
<InventoryType>P</InventoryType>
<BatchNumber>A128348</BatchNumber>
</SubItemFields>
<PIXFields>
<DateCreated>04/16/20 19:44:22</DateCreated>
<InvAdjustmentQty>100</InvAdjustmentQty>
<UnitOfMeasure>M</UnitOfMeasure>
<InvAdjustmentType>S</InvAdjustmentType>
<Warehouse>FRM</Warehouse>
<TransReasonCode/>
<ReceiptsVariance/>
<UnitsShipped>1.5</UnitsShipped>
<UnitsReceived>30</UnitsReceived>
<ReferenceCode1>12</ReferenceCode1>
<Reference1>110350</Reference1>
<ReferenceCode2>C02</ReferenceCode2>
<Reference2>BL00001123</Reference2>
<ReferenceCode3>C03</ReferenceCode3>
<Reference3>2016-09-15 03:28:00.0</Reference3>
<ReferenceCode4>37</ReferenceCode4>
<Reference4/>
<ReferenceCode5>43</ReferenceCode5>
<Reference5/>
<ReferenceCode6>08</ReferenceCode6>
<Reference6>SASN20301</Reference6>
<ReferenceCode7>C07</ReferenceCode7>
<Reference7/>
<ReferenceCode8>25</ReferenceCode8>
<Reference8>PS</Reference8>
<ReferenceCode9/>
<Reference9/>
<ReferenceCode10/>
<Reference10/>
<ActionCode>19</ActionCode>
</PIXFields>
</PIX>
<PIX>
<TransactionType>300</TransactionType>
<TransactionCode>01</TransactionCode>
<TransactionNumber>14836</TransactionNumber>
<SequenceNumber>1</SequenceNumber>
<ItemDefinition>
<Style>2020</Style>
<StyleSuffix>CUIR1</StyleSuffix>
<SizeDesc>01</SizeDesc>
</ItemDefinition>
<SubItemFields>
<InventoryType>P</InventoryType>
<BatchNumber>A128348</BatchNumber>
</SubItemFields>
<PIXFields>
<DateCreated>04/16/20 19:44:22</DateCreated>
<InvAdjustmentQty>100</InvAdjustmentQty>
<UnitOfMeasure>Unit</UnitOfMeasure>
<InvAdjustmentType>S</InvAdjustmentType>
<Warehouse>FRM</Warehouse>
<TransReasonCode/>
<ReceiptsVariance/>
<UnitsShipped>1.5</UnitsShipped>
<UnitsReceived>30</UnitsReceived>
<ReferenceCode1>12</ReferenceCode1>
<Reference1>110350</Reference1>
<ReferenceCode2>C02</ReferenceCode2>
<Reference2>BL00001123</Reference2>
<ReferenceCode3>C03</ReferenceCode3>
<Reference3>2016-09-15 03:28:00.0</Reference3>
<ReferenceCode4>37</ReferenceCode4>
<Reference4/>
<ReferenceCode5>43</ReferenceCode5>
<Reference5/>
<ReferenceCode6>08</ReferenceCode6>
<Reference6>SASN20301</Reference6>
<ReferenceCode7>C07</ReferenceCode7>
<Reference7/>
<ReferenceCode8>25</ReferenceCode8>
<Reference8>PS</Reference8>
<ReferenceCode9/>
<Reference9/>
<ReferenceCode10/>
<Reference10/>
<ActionCode>19</ActionCode>
</PIXFields>
</PIX>
</Message>
</tXML> |
Ce n'est donc pas le comportement que je souhaite. Il me semble que le fichier prend le premier PIX et applique les mêmes données sur les suivants sans distinctions.
J'ai donc pensé à utiliser la balise :
Code:
<xsl:for-each select="/tXML/Message/PIX">
afin d’effectuer la transformation PIX par PIX (tout en vérifiant si celui ci est éligible à une modification).
J'ai tenté de la placer de diverses façons mais je n'ai jamais réussi à avoir le résultat souhaité donc je ne sais plus quoi faire...
Pouvez vous m'aider svp ? Est-ce que la balise for each est la bonne manière de faire ? Si oui , où faut-il la placer ?
Merci d'avance