<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:s="http://www.stylusstudio.com/xquery">
    <xsl:param name="input1" select="document('file:///f:/Projects/energizer/XML%20Source/ZMapTestTxResult.xml')"/>
	<xsl:key name="InvoiceByRecipient" match="MetroGroupInvoicSummary" use="Header/InvoiceRecipient"/>
    <xsl:template match="/">
        <fo:root xml:base="file:///f:/Projects/energizer/XSL-FO/" xmlns:fo="http://www.w3.org/1999/XSL/Format">
            <fo:layout-master-set>

                <!-- Define a body (or default) page. -->
                <fo:simple-page-master master-name="default-master" 
							page-width="210mm"  page-height="297mm"
          				    margin-top="0.5in"  margin-bottom="0.5in"
           					margin-left="0.5in" margin-right="0.5in">

					<!-- Central part of page -->
		        	<fo:region-body margin-top="0.25in" margin-bottom="0.25in"/>

		        	<!-- Footer -->
		       		<fo:region-after extent="0.25in"/>
				
                </fo:simple-page-master>
            </fo:layout-master-set>

            <fo:page-sequence master-reference="default-master">
				
				<!-- Define the contents of the footer. -->
			      <fo:static-content flow-name="xsl-region-after">
			        <fo:block font-size="8.0pt" font-family="sans-serif" padding-after="2.0pt"
			                  space-before="4.0pt" text-align="right"
			                  border-top-style="solid" border-bottom-width="0.5pt">
			                  <xsl:text>Page </xsl:text>
							  
			                  <fo:page-number/>
			        </fo:block>
			      </fo:static-content>               

				<!-- Body page -->

                <fo:flow flow-name="xsl-region-body">
                    <fo:block>
                        <fo:block font-family="Arial" font-size="10pt" font-weight="normal" font-style="normal" text-decoration="none" color="#000000" background="transparent">
                            <fo:block>
                                <fo:inline font-family="Arial">
                                    <fo:table background="transparent" width="100%" border-left-width="2pt" border-right-width="2pt" border-top-width="2pt" border-bottom-width="2pt">
                                        <fo:table-column/>
                                        <fo:table-body>
                                            <fo:table-row>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block text-align="center">
                                                            <fo:block>
                                                                <xsl:text>SAMMELABRECHNUNGSLISTE (INVOICE LIST)         Page: </xsl:text>															
																<fo:page-number/> <xsl:text>/</xsl:text>
																<fo:page-number-citation ref-id="last-page"/>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                            </fo:table-row>
                                        </fo:table-body>
                                    </fo:table>
                                    <fo:table background="transparent" width="100%" border-left-width="2pt" border-right-width="2pt" border-top-width="2pt" border-bottom-width="2pt">
                                        <fo:table-column/>
                                        <fo:table-column/>
                                        <fo:table-body>
                                            <fo:table-row>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block>
                                                            <fo:block>
                                                                <xsl:text>Postal recipient:</xsl:text>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block>
                                                            <fo:block>
                                                                <xsl:text>Please fill in completly:</xsl:text>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                            </fo:table-row>
                                            <fo:table-row>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block>
                                                            <fo:block>
                                                                <xsl:text>MGP </xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text> </xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text>METRO Group Account Processing GmbH</xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text>Ohmstrasse 1</xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text>Postal Address:       77691 Kehl (Germany)</xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text> </xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text>Fax +49 (0) 7851 949 172 (Live run)</xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text>Fax +49 (0) 7851 949 129 (Test run)</xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text> </xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text> </xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text> </xsl:text>
                                                            </fo:block>
                                                            <fo:block>Number of Inclosed Invoices:
                                                                <xsl:value-of select="/InvoiceStart/GrandTotal/NumberofInclosedInvoices - 1"/>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text> </xsl:text>
                                                            </fo:block>
                                                            <fo:block>
                                                                <xsl:text>Currency unit: €</xsl:text>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block>
                                                            <fo:block>
                                                                <fo:table background="transparent" width="100%" border-left-width="0pt" border-right-width="0pt" border-top-width="0pt" border-bottom-width="0pt">
                                                                    <fo:table-column/>
                                                                    <fo:table-body>
                                                                        <fo:table-row>
                                                                            <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                                                <fo:block>
                                                                                    <fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text>GLN supplier:          4027800000005</xsl:text>
                                                                                        </fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text> </xsl:text>
                                                                                        </fo:block>
                                                                                    </fo:block>
                                                                                </fo:block>
                                                                            </fo:table-cell>
                                                                        </fo:table-row>
                                                                        <fo:table-row>
                                                                            <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                                                <fo:block>
                                                                                    <fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text>METRO - (MGB-) supplierno.:          213632</xsl:text>
                                                                                        </fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text> </xsl:text>
                                                                                        </fo:block>
                                                                                    </fo:block>
                                                                                </fo:block>
                                                                            </fo:table-cell>
                                                                        </fo:table-row>
                                                                        <fo:table-row>
                                                                            <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                                                <fo:block>
                                                                                    <fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text>Suppliers VAT identification no.:     135/5917/263</xsl:text>
                                                                                        </fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text> </xsl:text>
                                                                                        </fo:block>
                                                                                    </fo:block>
                                                                                </fo:block>
                                                                            </fo:table-cell>
                                                                        </fo:table-row>
                                                                        <fo:table-row>
                                                                            <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                                                <fo:block>
                                                                                    <fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text>Name and Address of supplier:</xsl:text>
                                                                                        </fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text>          Wilkinson Sword Gmbh</xsl:text>
                                                                                        </fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text>          Schutzentr.  110</xsl:text>
                                                                                        </fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text>          42659 Solingen</xsl:text>
                                                                                        </fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text> </xsl:text>
                                                                                        </fo:block>
                                                                                    </fo:block>
                                                                                </fo:block>
                                                                            </fo:table-cell>
                                                                        </fo:table-row>
                                                                        <fo:table-row>
                                                                            <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                                                <fo:block>
                                                                                    <fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text>Invoice list no.:</xsl:text>
                                                                                        </fo:block>
                                                                                        <fo:block>Date of invoice list:
                                                                                            <xsl:value-of select="$input1/InvoiceStart/MetroGroupInvoicSummary/Header/InvoiceDate"/>
                                                                                        </fo:block>
                                                                                        <fo:block>Billing Period:
                                                                                            <xsl:value-of select="$input1/InvoiceStart/MetroGroupInvoicSummary/Header/BillingPeriod"/>
                                                                                        </fo:block>
                                                                                        <fo:block>
                                                                                            <xsl:text> </xsl:text>
                                                                                        </fo:block>
                                                                                    </fo:block>
                                                                                </fo:block>
                                                                            </fo:table-cell>
                                                                        </fo:table-row>
                                                                    </fo:table-body>
                                                                </fo:table>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                            </fo:table-row>
                                        </fo:table-body>
                                    </fo:table>
                                </fo:inline>
                            </fo:block>
                        </fo:block>
                    </fo:block>			

					<fo:block>
					
					<fo:block>
                    	<xsl:text>.   </xsl:text>
                    </fo:block>
					<fo:block>
                    	<xsl:text>.   </xsl:text>
                    </fo:block>
                        <fo:block font-family="Arial" font-size="10pt" font-weight="normal" font-style="normal" text-decoration="none" color="#000000" background="transparent">
                            <fo:block>
                                <fo:inline font-family="Arial">
                                    <fo:table background="transparent" width="100%" border-left-width="2pt" border-right-width="2pt" border-top-width="2pt" border-bottom-width="2pt">
                                        <fo:table-column/>
                                        <fo:table-column/>
                                        <fo:table-column/>
                                        <fo:table-column/>
                                        <fo:table-column/>
                                        <fo:table-column/>
                                        <fo:table-column/>
                                        <fo:table-column/>
                                        <fo:table-body>
                                            <fo:table-row>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block>
                                                            <fo:block>
                                                                <xsl:text> </xsl:text>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block text-align="center">
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>Invoice</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>No.</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block text-align="center">
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>Invoice</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>Date</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block text-align="center">
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>Invoice</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>Recipient</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block>
                                                            <fo:block>
                                                                <xsl:text> </xsl:text>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block text-align="center">
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>NET</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>Amount</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block text-align="center">
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>VAT</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>Amount</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                                <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                    <fo:block>
                                                        <fo:block text-align="center">
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>Total</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                            <fo:block>
                                                                <fo:inline font-weight="bold">
                                                                    <xsl:text>Amount</xsl:text>
                                                                </fo:inline>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:block>
                                                </fo:table-cell>
                                            </fo:table-row>
                                            <xsl:for-each select="/InvoiceStart/MetroGroupInvoicSummary">
                                                <xsl:variable name="MetroGroupInvoicSummary" select="."/>
                                                <fo:table-row>
                                                    <fo:table-cell border-left-style="solid" border-left-color="black" border-left-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                        <fo:block>
                                                            <fo:block>
                                                                <fo:block>                                                                    
                                                                    <xsl:value-of select="Header/LineNumber"/>
                                                                </fo:block>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:table-cell>
                                                    <fo:table-cell padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                        <fo:block>
                                                            <fo:block>
                                                                <fo:block>
                                                                    <xsl:value-of select="Header/InvoiceNumber"/>
                                                                </fo:block>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:table-cell>
                                                    <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                        <fo:block>
                                                            <fo:block>
                                                                <fo:block>
                                                                    <xsl:value-of select="Header/InvoiceDate"/>
                                                                </fo:block>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:table-cell>
                                                    <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                        <fo:block>
                                                            <fo:block>
                                                                <fo:block>
                                                                    <xsl:value-of select="Header/InvoiceRecipient"/>
                                                                </fo:block>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:table-cell>
                                                    <fo:table-cell border-style="solid" border-color="black" border-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                        <fo:block>
                                                            <fo:block>
                                                                <fo:block>
                                                                    <xsl:text> </xsl:text>
                                                                </fo:block>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:table-cell>
                                                    <fo:table-cell padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                        <fo:block>
                                                            <fo:block>
                                                                <fo:block>
																	<xsl:choose>
																		<xsl:when test="Last= 1">
                                                                    		<xsl:value-of select="sum(key('InvoiceByRecipient', Header/InvoiceRecipient)/InvoiceTotal/TotalNetAmount)"/>
																		</xsl:when>
																		<xsl:otherwise>
																			<fo:block>
																				<xsl:text></xsl:text>
																			</fo:block>
																		</xsl:otherwise>
																	</xsl:choose>
                                                                </fo:block>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:table-cell>
                                                    <fo:table-cell padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                        <fo:block>
                                                            <fo:block>
                                                                <fo:block>
                                                                    <xsl:value-of select="sum(key('InvoiceByRecipient', Header/InvoiceRecipient)/InvoiceTotal/VATAMT)"/>
                                                                </fo:block>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:table-cell>
                                                    <fo:table-cell border-right-style="solid" border-right-color="black" border-right-width="1pt" padding-start="1pt" padding-end="1pt" padding-before="1pt" padding-after="1pt">
                                                        <fo:block>
                                                            <fo:block>
                                                                <fo:block>
                                                                    <xsl:value-of select="InvoiceTotal/TotalAmount"/>
                                                                </fo:block>
                                                            </fo:block>
                                                        </fo:block>
                                                    </fo:table-cell>
                                                </fo:table-row>
                                            </xsl:for-each>
                                        </fo:table-body>
                                    </fo:table>
                                </fo:inline>
                            </fo:block>
                        </fo:block>
						<fo:block id="last-page"/>
                    </fo:block>
					
                </fo:flow>


            </fo:page-sequence>
        </fo:root>
    </xsl:template>
</xsl:stylesheet><!-- Stylus Studio meta-information - (c) 2004-2006. Progress Software Corporation. All rights reserved.
<metaInformation>
<scenarios ><scenario default="yes" name="Scenario1" userelativepaths="yes" externalpreview="no" url="..\XML Source\ZZMapTestTxResult.xml" htmlbaseurl="" outputurl="" processortype="saxon8" useresolver="yes" profilemode="0" profiledepth="" profilelength="" urlprofilexml="" commandline="" additionalpath="" additionalclasspath="" postprocessortype="renderx" postprocesscommandline="" postprocessadditionalpath="" postprocessgeneratedext="" validateoutput="no" validator="internal" customvalidator=""/></scenarios><MapperMetaTag><MapperInfo srcSchemaPathIsRelative="yes" srcSchemaInterpretAsXML="no" destSchemaPath="" destSchemaRoot="" destSchemaPathIsRelative="yes" destSchemaInterpretAsXML="no"/><MapperBlockPosition></MapperBlockPosition><TemplateContext></TemplateContext><MapperFilter side="source"></MapperFilter></MapperMetaTag>
</metaInformation>
-->