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 :
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.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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>
Voici donc ce que j'ai réalisé :
J'obtiens bien ce que je veux à savoir :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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>
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).
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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>
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.
Si je lance la transformation, j'obtiens ceci :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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>
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.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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>
J'ai donc pensé à utiliser la balise :afin d’effectuer la transformation PIX par PIX (tout en vérifiant si celui ci est éligible à une modification).
Code : Sélectionner tout - Visualiser dans une fenêtre à part <xsl:for-each select="/tXML/Message/PIX">
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
Partager