Eionet
Conversion and Quality Assessment Service
View stylesheet
| XML schema |
http://dd.eionet.europa.eu/schemas/ods-2024/ODSReport.xsd
|
|---|---|
| Output type | HTML |
| Description | HTML Factsheet |
| XSL file | ODS_ProdImportExport_2024.xsl (Last modified: 10 Feb 2025 10:13 ) |
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns="http://www.w3.org/1999/xhtml" version="1.0"
xmlns:ext="http://exslt.org/common"
exclude-result-prefixes="xml">
<xsl:output method="xml" indent="yes"
doctype-public="-//W3C//DTD XHTML 1.0 Strict//EN"
doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"
omit-xml-declaration="yes"/>
<xsl:preserve-space elements="published reasons-specify"/>
<xsl:strip-space elements= "SubstanceCode Substance substancecode"/>
<xsl:decimal-format decimal-separator="."/> <!--20211112-->
<xsl:param name="envelopeurl" />
<xsl:param name="filename" />
<xsl:param name="envelopepath" />
<xsl:param name="acceptable" />
<xsl:param name="submissionDate" />
<!-- variables -->
<xsl:variable name="current-date" select="current-dateTime()"/>
<xsl:variable name="isProducer" select="/ODSReporting/GeneralReportData/Company/Actor/Producer"/>
<xsl:variable name="isImporter" select="/ODSReporting/GeneralReportData/Company/Actor/Importer"/>
<xsl:variable name="isExporter" select="/ODSReporting/GeneralReportData/Company/Actor/Exporter"/>
<xsl:variable name="isPauUser" select="/ODSReporting/GeneralReportData/Company/Actor/ProcessAgent"/>
<xsl:variable name="isFdstUser" select="/ODSReporting/GeneralReportData/Company/Actor/Feedstock"/>
<xsl:variable name="isDestructor" select="/ODSReporting/GeneralReportData/Company/Actor/Destruction"/>
<xsl:variable name="noReporting" select="/ODSReporting/GeneralReportData/Company/Actor/NoReporting"/>
<xsl:variable name="referenceYear" select="/ODSReporting/GeneralReportData/TransactionYear"/>
<xsl:template match="ODSReporting">
<html>
<!--xsl:attribute name="xml:lang"><xsl:value-of select="@xml:lang" /></xsl:attribute-->
<head>
<title>Factsheet</title>
<style type="text/css"><![CDATA[
img {
border: 2px solid #ccc;
margin: 10px;
}
h1 {
font-family: arial, verdana, sans-serif;
font-size: 160%;
border-bottom: 1px solid #999999;
}
h2 {
font-size: 120%;
padding-bottom: 0.5em;
border-bottom: 1px solid #999999;
}
body {
font-size: 80%;
font-family: verdana, helvetica, arial, sans-serif;
color: #333;
}
caption {
display: none;
font-family: vardana, verdana, helvetica, arial, sans-serif;
text-align: left;
font-size: 150%;
}
th {
background-color:#f6f6f6;
text-align:left;
vertical-align: top;
font-weight: normal;
color: black;
}
table {
font-size: 100%;
border: 1px solid #bbb;
margin: 0 0 2em 0;
border-collapse: collapse;
}
table table {
border: 0px solid #bbb;
margin: 0;
}
th, td {
font-size: 100%;
border: 1px solid #bbb;
padding: 2px 2px 2px 2px;
}
.has_table {
border: 0px solid #bbb;
padding: 0;
}
th.header_3 {
padding: 0.4em 0;
font-size: 120%;
font-weight: bold;
}
th.tlabel {
width: 300px;
}
.header_info {
margin: 20px 0px;
padding: 5px;
font-size: 120%;
border: 1px dashed #999999;
background-color: #f0f0f0;
}
.header_info div {
margin: 5px;
}
p.report_end {
border-bottom: dashed;
border-width: 2px;
border-color: #000000;
}
sup {
font-size:75%
}
.metadata_table tr th:first-child{
width:150px;
}
.metadata_table td{
width:350px;
}
.total{
font-weight:bold;
color: black;
background-color: #bbb;
border: 1px solid #fff;
}
.num_cell{
text-align:right;
background-color: #FFFFE0;
}
.substance_cell{
text-align:center;
font-weight:bold;
}
.row_height{
height: 1em;
}
.bold{
font-weight:bold;
}
]]>
</style>
</head>
<body>
<h1>Report on the Ozone depleting substances</h1>
<xsl:apply-templates/>
</body>
</html>
</xsl:template>
<xsl:template match="GeneralReportData">
<table class="metadata_table">
<tr>
<th>XML file: </th>
<td><xsl:attribute name="href"><xsl:value-of select="concat($envelopeurl,'/',$filename)"/></xsl:attribute>
<xsl:attribute name="target"><xsl:value-of select="'blank_'"/></xsl:attribute>
<xsl:value-of select="$filename"/></td>
</tr>
<tr>
<th>XML file converted at: </th>
<td>
<xsl:value-of select="concat(substring(string($current-date), 1, 19), 'Z')"/>
</td>
</tr>
<xsl:if test="$acceptable = 'true' or $acceptable = 'false'">
<tr>
<th>Envelope submission date: </th>
<td>
<xsl:value-of select="$submissionDate"/>
</td>
</tr>
</xsl:if>
<tr>
<th>Converted from: </th>
<td>
<xsl:attribute name="href">
<xsl:value-of select="$envelopeurl"/>
</xsl:attribute>
<xsl:value-of select="$envelopeurl"/>
</td>
</tr>
<tr>
<th>Envelope status: </th>
<xsl:choose>
<xsl:when test="$acceptable = 'true'">
<td>Accepted by automated quality control</td>
</xsl:when>
<xsl:when test="$acceptable = 'false'">
<td>Rejected by automated quality control</td>
</xsl:when>
<xsl:otherwise>
<td>Draft envelope (not yet submitted)</td>
</xsl:otherwise>
</xsl:choose>
</tr>
</table>
<xsl:apply-templates mode="general"/>
</xsl:template>
<xsl:template match="SubmissionDate|TransactionYear" mode="general"/>
<xsl:template match="Company" mode="general">
<h2>1. Reporting undertaking</h2>
<table class="metadata_table">
<tr>
<th>ODS number</th>
<td>
<xsl:value-of select="CompanyId"/>
</td>
</tr>
<tr>
<th>Company Name</th>
<td>
<xsl:value-of select="CompanyName"/>
</td>
</tr>
<tr>
<th>Company Address</th>
<td>
<xsl:value-of select="PostalAddress/StreetAddress"/>
</td>
</tr>
<tr>
<th>City</th>
<td>
<xsl:value-of select="PostalAddress/City"/>
<!--<xsl:if test="string-length(PostalAddress/Region) > 0">,
<xsl:value-of select="PostalAddress/Region"/>
</xsl:if>-->
</td>
</tr>
<!--<tr>
<th>Region</th>
<td>
<xsl:value-of select="PostalAddress/Region"/>
</td>
</tr>-->
<tr>
<th>Postal Code</th>
<td>
<xsl:value-of select="PostalAddress/PostalCode"/>
</td>
</tr>
<tr>
<th>Country</th>
<td>
<xsl:value-of select="Country"/>
</td>
</tr>
<tr>
<th>EORI number</th>
<td>
<xsl:value-of select="EoriCode"/>
</td>
</tr>
<tr>
<th>VAT number</th>
<td>
<xsl:value-of select="VatCode"/>
</td>
</tr>
<xsl:for-each select="ContactInfo">
<tr>
<td colspan="2" class="row_height"/>
</tr>
<tr>
<th class="transactionColum">Contact Person
<xsl:if test="count(../ContactInfo) > 1">(<xsl:value-of select="position()"/>)
</xsl:if>
</th>
<td class="generalReportDataColum">
<xsl:value-of select="ContactPerson"/>
</td>
</tr>
<tr>
<th class="transactionColum">Phone Number</th>
<td class="generalReportDataColum">
<xsl:value-of select="Telephone"/>
</td>
</tr>
<tr>
<th class="transactionColum">Fax Number</th>
<td class="generalReportDataColum">
<xsl:value-of select="FaxNumber"/>
</td>
</tr>
<tr>
<th class="transactionColum">Email Address</th>
<td class="generalReportDataColum">
<xsl:value-of select="Email"/>
</td>
</tr>
</xsl:for-each>
<tr>
<td colspan="2">
<span style="color:red;font-weight:bold">
<xsl:attribute name="style">
<xsl:choose>
<xsl:when test="@status='confirmed' or @status='submitted' ">color:green</xsl:when>
<xsl:otherwise>color:red</xsl:otherwise>
</xsl:choose>
;font-weight:bold
</xsl:attribute>
<xsl:value-of select="@status"/>
</span>
</td>
</tr>
</table>
<table class="metadata_table">
<tr>
<th>Transaction Year</th>
<td>
<xsl:value-of select="../TransactionYear"/>
</td>
</tr>
<tr>
<th>Activities</th>
<td>
<xsl:if test="Actor/Producer='true'">
<div>Producer</div>
</xsl:if>
<xsl:if test="Actor/Importer='true'">
<div>Importer</div>
</xsl:if>
<xsl:if test="Actor/Exporter='true'">
<div>Exporter</div>
</xsl:if>
<xsl:if test="Actor/Destruction='true'">
<div>Destruction</div>
</xsl:if>
<xsl:if test="Actor/ProcessAgent='true'">
<div>Process Agent use</div>
</xsl:if>
<xsl:if test="Actor/Feedstock='true'">
<div>Feedstock use</div>
</xsl:if>
<xsl:if test="Actor/NoReporting='true'">
<div>Not obliged to report (NIL report)</div>
</xsl:if>
</td>
</tr>
</table>
</xsl:template>
<xsl:template match="ODSSubstances">
<xsl:if test="$noReporting='false' or count(ODSSubstances/Substance[string-length(Code) > 0]) > 0">
<h2>2. Definition of substances</h2>
<table>
<xsl:apply-templates/>
</table>
</xsl:if>
</xsl:template>
<xsl:template match="Substance">
<tr>
<td>
<!--<xsl:value-of select="Code"/>--> <!-- ORIGINAL 20231020 -->
<!-- NEW 20231020 -->
<xsl:if test="Code = 'Complex and inconsistent mixture of fluorinated hydrocarbons(non-virgin)'">
<xsl:text>Complex and inconsistent mixture containing ODS(non-virgin)</xsl:text>
</xsl:if>
<xsl:if test="Code != 'Complex and inconsistent mixture of fluorinated hydrocarbons(non-virgin)'">
<xsl:value-of select="Code"/>
</xsl:if>
<!-- 20231020 -->
</td>
</tr>
</xsl:template>
<xsl:template match="ODSQuantities">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="TotalProduction">
<xsl:if test="$isProducer='true' or count(ProductionQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>3. Total production</h2>
<table>
<tr>
<th align="center" width="200px">Use</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<tr>
<!--<xsl:apply-templates/>--> <!-- original 20221122 -->
<xsl:apply-templates select="ProductionQuantity"/> <!-- 20221122 -->
<br/>
<td style="text-align:right;font-weight:bold;">
<xsl:attribute name="colspan">
<xsl:value-of select="1"/>
</xsl:attribute>
Total
</td>
<xsl:for-each select="//ODSSubstances/Substance">
<xsl:variable name="substance">
<xsl:value-of select="Code"/>
</xsl:variable>
<td align="right" class="total">
<!--<xsl:value-of
select="format-number(sum(//ODSQuantities/TotalProduction/ProductionQuantity[ not (Subject/@usetype = 'emissions during production') ]/Quantity/Value[../SubstanceCode=$substance and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>--> <!--original 20211112-->
<!-- start new 20211112
<xsl:if test="contains(//ODSQuantities/TotalProduction/ProductionQuantity[ not (Subject/@usetype = 'emissions during production') ]/Quantity/Value[../SubstanceCode=$substance and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)],'.')">
<xsl:value-of
select="format-number(sum(//ODSQuantities/TotalProduction/ProductionQuantity[ not (Subject/@usetype = 'emissions during production') ]/Quantity/Value[../SubstanceCode=$substance and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'0.0000000')"/>
</xsl:if>
<xsl:if test="not(contains(//ODSQuantities/TotalProduction/ProductionQuantity[ not (Subject/@usetype = 'emissions during production') ]/Quantity/Value[../SubstanceCode=$substance and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)],'.'))">
<xsl:value-of
select="format-number(sum(//ODSQuantities/TotalProduction/ProductionQuantity[ not (Subject/@usetype = 'emissions during production') ]/Quantity/Value[../SubstanceCode=$substance and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>
</xsl:if>
end new 20211112 -->
<!-- start new 20220112 -->
<xsl:variable name="count" select="count( (//ODSQuantities/TotalProduction/ProductionQuantity[ not (Subject/@usetype = 'emissions during production') ]/Quantity/Value[../SubstanceCode=$substance and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0) and contains(., '.') ] ) )" />
<xsl:choose>
<xsl:when test="$count >= 1">
<xsl:value-of
select="format-number(sum(//ODSQuantities/TotalProduction/ProductionQuantity[ not (Subject/@usetype = 'emissions during production') ]/Quantity/Value[../SubstanceCode=$substance and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'0.0000000')"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of
select="format-number(sum(//ODSQuantities/TotalProduction/ProductionQuantity[ not (Subject/@usetype = 'emissions during production') ]/Quantity/Value[../SubstanceCode=$substance and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>
</xsl:otherwise>
</xsl:choose>
<!-- end new 20220112 -->
</td>
</xsl:for-each>
</tr>
</table>
<xsl:apply-templates select="Comments"/>
</xsl:if>
</xsl:template>
<xsl:template match="ProductionQuantity">
<tr>
<xsl:apply-templates select="Subject"/>
<xsl:for-each select="Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template match="CompanyQuantity">
<xsl:if test="Subject/@usetype != ''">
<tr>
<xsl:apply-templates select="Company"/>
<xsl:apply-templates select="Subject"/>
<xsl:for-each select="Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
</xsl:if>
</xsl:template>
<xsl:template match="Company">
<xsl:variable name="companyName">
<xsl:value-of select="CompanyName"/>
<xsl:if test="string-length(CompanyName) > 0">;</xsl:if>
</xsl:variable>
<xsl:variable name="companyAddress">
<xsl:value-of select="CompanyAddress"/>
<xsl:if test="string-length(CompanyAddress) > 0">;</xsl:if>
</xsl:variable>
<td>
<xsl:value-of select="$companyName"/><xsl:value-of select="$companyAddress"/><xsl:value-of
select="Country/@desc"/>
</td>
</xsl:template>
<xsl:template match="ImportQuantity">
<tr>
<xsl:apply-templates select="Subject"/>
<td>
<xsl:value-of select="CustomsProcedure"/><xsl:value-of select="Company/Country/@desc"/>
</td>
<td>
<xsl:value-of select="Country/@desc"/>
</td>
<xsl:for-each select="Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template match="StockQuantity">
<tr>
<td>
<xsl:call-template name="DateLabel">
<xsl:with-param name="date">
<xsl:value-of select="./@date"/>
</xsl:with-param>
</xsl:call-template>
<xsl:value-of select="Subject/@usetype"/>
</td>
<xsl:for-each select="Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template match="Emissions">
<tr>
<td>
<xsl:value-of select="Subject/@usetype"/>
</td>
<xsl:for-each select="Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template match="Quantity" mode="comments">
<xsl:if test="string-length(Description) > 0">
<xsl:variable name="datelabel">
<xsl:call-template name="DateLabel">
<xsl:with-param name="date">
<xsl:value-of select="../@date"/>
</xsl:with-param>
</xsl:call-template>
</xsl:variable>
<xsl:variable name="uselabel">
<xsl:value-of select="concat($datelabel, ' ', ../Subject/@usetype) "/>
</xsl:variable>
<tr>
<td>
<!--<xsl:value-of select="SubstanceCode"/>--> <!-- ORIGINAL 20231025 -->
<!-- NEW 20231025 -->
<xsl:if test="SubstanceCode = 'Complex and inconsistent mixture of fluorinated hydrocarbons(non-virgin)'">
<xsl:text>Complex and inconsistent mixture containing ODS(non-virgin)</xsl:text>
</xsl:if>
<xsl:if test="SubstanceCode != 'Complex and inconsistent mixture of fluorinated hydrocarbons(non-virgin)'">
<xsl:value-of select="SubstanceCode"/>
</xsl:if>
<!-- 20231025 -->
</td>
<td>
<xsl:value-of select="$uselabel"/>
</td>
<td class="num_cell">
<xsl:value-of select="Value"/>
</td>
<td>
<xsl:value-of select="Description"/>
</td>
</tr>
</xsl:if>
</xsl:template>
<xsl:template match="RecycledReclaimedQuantity">
<tr>
<xsl:apply-templates select="Subject"/>
<xsl:for-each select="Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template match="Subject">
<td>
<xsl:choose>
<!--
<xsl:when test=".!='' and ./@usetype!='other'">
<xsl:value-of select="."/>
</xsl:when>
-->
<xsl:when test="./@usetype='recycled'">Total quantity recycled</xsl:when>
<xsl:when test="./@usetype='reclaimed'">Total quantity reclaimed</xsl:when>
<xsl:when test=".!=''">
<xsl:value-of select="./@usetype"/>:<xsl:text> </xsl:text><xsl:value-of select="."/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="./@usetype"/>
</xsl:otherwise>
</xsl:choose>
</td>
</xsl:template>
<xsl:template match="ExportQuantity">
<tr>
<xsl:apply-templates select="Subject"/>
<td>
<xsl:value-of select="CustomsProcedure"/><xsl:value-of select="Company/Country/@desc"/>
</td>
<td>
<xsl:value-of select="Country/@desc"/>
</td>
<xsl:for-each select="Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template match="SaleEUQuantity">
<tr>
<xsl:apply-templates select="Company"/>
<xsl:apply-templates select="Subject"/>
<xsl:for-each select="Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
</xsl:template>
<!--<xsl:template match="IndustrialRationalisation">
<xsl:if test="$isProducer='true' or count(CompanyQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>4. Production under industrial rationalisation</h2>
<table>
<tr>
<th width="250px">Transferring undertaking</th>
<th width="200px">Use</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<xsl:apply-templates/>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">2</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
</xsl:call-template>
</table>
</xsl:if>
</xsl:template>-->
<xsl:template match="RecycledReclaimed">
<xsl:if test="$isProducer='true'">
<!-- 20211214 -->
<xsl:if test="not(./RecycledReclaimedQuantity)">
<h2>5. Recycling and reclamation by producers</h2>
<table>
<tr>
<th width="250px">Recycling and reclamation (for any uses inside or outside EU)</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<tr>
<th width="250px" style="background-color:white">Total quantity recycled</th>
<xsl:call-template name="SubstancesHeaderColsEmpty"/>
</tr>
<tr>
<th width="250px" style="background-color:white">Total quantity reclaimed</th>
<xsl:call-template name="SubstancesHeaderColsEmpty"/>
</tr>
<tr>
<th style="text-align:right;font-weight:bold;background-color:white" width="250px">Total</th>
<xsl:call-template name="SubstancesHeaderColsEmptyTotal"/>
</tr>
</table>
</xsl:if>
<!-- 20211214 -->
<xsl:if test="count(RecycledReclaimedQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>5. Recycling and reclamation by producers</h2>
<table>
<tr>
<th width="250px">Recycling and reclamation (for any uses inside or outside EU)</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<xsl:apply-templates select="RecycledReclaimedQuantity"><xsl:sort select="Subject/@usetype" order="descending"/></xsl:apply-templates>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">1</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
</xsl:call-template>
</table>
</xsl:if>
</xsl:if>
</xsl:template>
<xsl:template match="TotalRecieved">
<xsl:if test="$noReporting='false' or count(CompanyQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>6. Quantities received from undertakings in the EU (e.g. purchases)</h2>
<table>
<tr>
<th width="250px">Supplier</th>
<th width="200px">Use</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<xsl:apply-templates/>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">2</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
</xsl:call-template>
</table>
</xsl:if>
</xsl:template>
<xsl:template match="TotalImports">
<xsl:if test="$isImporter='true' or count(ImportQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>7. Total imports from countries or territories outside EU.</h2>
<table>
<tr>
<th width="200px">Use</th>
<th width="250px">Customs procedure</th>
<th width="150px">Source country</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<!--<xsl:apply-templates/>--> <!-- original 20221223 -->
<xsl:apply-templates select="ImportQuantity"/> <!-- 20221223 -->
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">3</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
</xsl:call-template>
</table>
<xsl:apply-templates select="Comments"/> <!-- 20221223 -->
</xsl:if>
</xsl:template>
<xsl:template match="TotalStocks">
<xsl:if test="$noReporting = 'false' or count(StockQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>8. Total stocks</h2>
<table>
<tr>
<th width="200px">Total stocks at the beginning / end of reporting year and emissions</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<!-- Stock quantities at the beginning of the year -->
<xsl:apply-templates select="StockQuantity[@date = '01-01']">
<xsl:sort select="string-length(substring-before('|free release|customs bondage|destruction|', concat('|', Subject/@usetype, '|')))" data-type="number"/>
</xsl:apply-templates>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">1</xsl:with-param>
<xsl:with-param name="date">01-01</xsl:with-param>
<xsl:with-param name="sumtext">
<xsl:call-template name="DateLabel">
<xsl:with-param name="date">01-01</xsl:with-param>
</xsl:call-template>
Total
</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
</xsl:call-template>
<!-- Emissions -->
<xsl:apply-templates select="Emissions">
<xsl:sort select="Subject/@usetype"/>
</xsl:apply-templates>
<!-- Stock quantities at the end of the year -->
<xsl:apply-templates select="StockQuantity[@date = '12-31']">
<xsl:sort select="string-length(substring-before('|free release|customs bondage|destruction|', concat('|', Subject/@usetype, '|')))" data-type="number"/>
</xsl:apply-templates>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">1</xsl:with-param>
<xsl:with-param name="date">12-31</xsl:with-param>
<xsl:with-param name="sumtext">
<xsl:call-template name="DateLabel">
<xsl:with-param name="date">12-31</xsl:with-param>
</xsl:call-template>
Total
</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
</xsl:call-template>
<!-- Stocks consumed -->
<tr>
<td align="right" style="font-weight:bold">Stocks consumed</td>
<xsl:for-each select="//ODSSubstances/Substance">
<xsl:variable name="code">
<xsl:value-of select="Code"/>
</xsl:variable>
<td align="right" class="total">
<xsl:variable name="consumed">
<xsl:value-of
select="format-number(
sum(//ODSQuantities/TotalStocks/StockQuantity/Quantity/Value[
translate(normalize-space(../SubstanceCode),' ','') =
translate(normalize-space($code),' ','') and
../../@date = '01-01' and string-length(.) > 0 and
(number(.) > 0 or number(.) <= 0)]) -
sum(//ODSQuantities/TotalStocks/StockQuantity/Quantity/Value[
translate(normalize-space(../SubstanceCode),' ','') =
translate(normalize-space($code),' ','') and
../../@date = '12-31' and string-length(.) > 0 and
(number(.) > 0 or number(.) <= 0)]),'#')" />
</xsl:variable>
<xsl:choose>
<xsl:when test="$consumed > 0">
<xsl:value-of select="$consumed"/>
</xsl:when>
<xsl:when test="$consumed < 0">
<xsl:value-of select="$consumed"/>
</xsl:when>
<xsl:otherwise>0</xsl:otherwise>
</xsl:choose>
</td>
</xsl:for-each>
</tr>
</table>
<!-- Comments Section -->
<xsl:if test="count(StockQuantity/Quantity[string-length(Description)>0] | Emissions/Quantity[string-length(Description)>0]) > 0">
<span style="font-weight:bold">
<sup>*</sup>
Values have related comments that are listed in the table below
</span>
<h2>Comments with relation to the stocks and emissions</h2>
<table>
<tr>
<th>Substance</th>
<th>Date Usetype</th>
<th>Quantity</th>
<th>Comment</th>
</tr>
<xsl:apply-templates mode="comments" select="StockQuantity/Quantity[string-length(Description)>0] | Emissions/Quantity[string-length(Description)>0]"><xsl:sort select="string-length(substring-before('|free release|customs bondage|destruction|Emissions from storage|Emissions from transport|', concat('|', ../Subject/@usetype, '|')))" data-type="number"/></xsl:apply-templates>
</table>
</xsl:if>
</xsl:if>
</xsl:template>
<xsl:template match="ProducerStocks">
<xsl:if test="$isProducer='true'">
<xsl:if test="$isImporter='true' or count(StockQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>9. Stocks resulting from excess production during the reporting year</h2>
<table>
<tr>
<th align="center" width="200px">
</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<xsl:apply-templates select="StockQuantity[@date = '12-31']"><xsl:sort select="Subject/@usetype" order="descending"/></xsl:apply-templates>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">1</xsl:with-param>
<xsl:with-param name="date">12-31</xsl:with-param>
<xsl:with-param name="sumtext">
<xsl:call-template name="DateLabel">
<xsl:with-param name="date">12-31</xsl:with-param>
</xsl:call-template>
Total
</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
</xsl:call-template>
</table>
</xsl:if>
</xsl:if>
</xsl:template>
<xsl:template match="SalesEUMarket">
<xsl:if test="$isImporter='true' or $isProducer='true' or $isExporter='true' or $isPauUser='true' or $isFdstUser='true' or count(SaleEUQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>10. Placing on the EU market during the reporting year (sales etc.)</h2>
<table>
<tr>
<th align="center">Recipient</th>
<th align="center">Use</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<xsl:apply-templates/>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">2</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
</xsl:call-template>
</table>
</xsl:if>
</xsl:template>
<xsl:template match="ExportFromEU">
<xsl:if test="$isExporter='true' or count(ExportQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>11. Exports to countries and territories outside EU</h2>
<table>
<tr>
<th width="200px">Use</th>
<th width="250px">Customs procedure</th>
<th width="150px">Destination country</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<!--<xsl:apply-templates/>--> <!-- original 20221223 -->
<xsl:apply-templates select="ExportQuantity"/> <!-- 20221223 -->
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">3</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
</xsl:call-template>
</table>
<xsl:apply-templates select="Comments"/> <!-- 20221223 -->
</xsl:if>
</xsl:template>
<xsl:template match="PauFdst">
<xsl:if test="$isPauUser='true' or $isFdstUser='true' or count(ProcessQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>12. Feedstock and process agent use within the reporting undertaking</h2>
<table>
<tr>
<th colspan="2" align="center">Processes</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<xsl:apply-templates select="ProcessQuantity"/>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">2</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
<xsl:with-param name="subtable">MakeUp</xsl:with-param>
<xsl:with-param name="sumtext">Total Make-up</xsl:with-param>
</xsl:call-template>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">2</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
<xsl:with-param name="subtable">Emissions</xsl:with-param>
<xsl:with-param name="sumtext">Total Emission</xsl:with-param>
</xsl:call-template>
</table>
<xsl:if test="count(ProcessQuantity/*/Quantity[string-length(Description)>0]) > 0">
<span style="font-weight:bold">
<sup>*</sup>
Values have related comments that are listed in the table below
</span>
<h2>Comments with relation to the use within the company</h2>
<table>
<tr>
<th>Substance</th>
<th>Process</th>
<th>Usetype</th>
<th>Quantity</th>
<th>Estimated value</th>
</tr>
<xsl:for-each select="ProcessQuantity/MakeUp/Quantity">
<xsl:if test="string-length(Description) > 0">
<tr>
<td>
<xsl:value-of select="SubstanceCode"/>
</td>
<td>
<xsl:value-of select="../../Process"/>
</td>
<td>Make-up</td>
<td class="num_cell">
<xsl:value-of select="Value"/>
</td>
<td>
<xsl:value-of select="EstimatedValue"/>
</td>
</tr>
</xsl:if>
</xsl:for-each>
<xsl:for-each select="ProcessQuantity/Emissions/Quantity">
<xsl:if test="string-length(Description) > 0">
<tr>
<td>
<xsl:value-of select="SubstanceCode"/>
</td>
<td>
<xsl:value-of select="../../Process"/>
</td>
<td>Emission</td>
<td class="num_cell">
<xsl:value-of select="Value"/>
</td>
<td>
<xsl:value-of select="EstimatedValue"/>
</td>
</tr>
</xsl:if>
</xsl:for-each>
</table>
</xsl:if>
<xsl:apply-templates select="Comments"/>
</xsl:if>
</xsl:template>
<xsl:template match="UseWithinReporting">
<xsl:if test="$noReporting='false'">
<h2>13. Use within the reporting undertaking (no longer applicable)</h2>
<table>
<tr/>
</table>
</xsl:if>
</xsl:template>
<xsl:template match="ReporterUses">
<xsl:if test="$referenceYear < 2015 and ($isImporter='true' or $isProducer='true' or $isExporter='true' or count(UsedQuantity//Quantity[string-length(Value) > 0]) > 0)">
<h2>13. Use within the reporting undertaking</h2>
<table>
<tr>
<th align="center">Use</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<xsl:apply-templates/>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">1</xsl:with-param>
<xsl:with-param name="tablename"><xsl:value-of select="name(.)"/></xsl:with-param>
</xsl:call-template>
</table>
</xsl:if>
</xsl:template>
<xsl:template match="UsedQuantity">
<tr>
<xsl:apply-templates select="Subject"/>
<xsl:for-each select="Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template match="Destruction">
<xsl:if test="$isDestructor='true' or count(DestructionQuantity//Quantity[string-length(Value) > 0]) > 0">
<h2>14. Quantities destroyed at your facility</h2>
<table>
<tr>
<th align="center">Destruction technology</th>
<xsl:call-template name="SubstancesHeaderCols"/>
</tr>
<!--<xsl:apply-templates/>--> <!-- original 20221122 -->
<xsl:apply-templates select="DestructionQuantity"/> <!-- 20221122 -->
<br/>
<xsl:call-template name="QuantitySumRow">
<xsl:with-param name="cols">1</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="name(.)"/>
</xsl:with-param>
</xsl:call-template>
</table>
<xsl:apply-templates select="Comments"/>--> <!--Task 249647. 20231109 -->
</xsl:if>
</xsl:template>
<xsl:template match="Comments">
<xsl:if test="string-length(.) > 0">
<h2>Comments</h2>
<div>
<xsl:value-of select="."/>
</div>
</xsl:if>
</xsl:template>
<xsl:template match="DestructionQuantity">
<tr>
<td>
<p>
<xsl:value-of select="DestructionTechnology" />
</p>
<p class="bold">Total amount destroyed</p>
</td>
<xsl:for-each select="Quantity">
<td class="num_cell">
<xsl:value-of select="./Value" />
</td>
</xsl:for-each>
</tr>
<tr>
<td style="padding-left: 5%;">Thereof: from by-production</td>
<xsl:for-each select="Quantity">
<td class="num_cell">
<xsl:value-of select="./ByP" />
</td>
</xsl:for-each>
</tr>
<tr>
<td style="padding-left: 5%;">Thereof: from equipment</td>
<xsl:for-each select="Quantity">
<td class="num_cell">
<xsl:value-of select="./Eq" />
</td>
</xsl:for-each>
</tr>
<tr>
<td style="padding-left: 5%;">Thereof: emissions during destruction</td>
<xsl:for-each select="Quantity">
<td class="num_cell">
<xsl:value-of select="./Table14Emissions" />
</td>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template match="ProcessQuantity">
<xsl:variable name="process">
<xsl:value-of select="Process"/>
</xsl:variable>
<xsl:variable name="comment">
<xsl:choose>
<xsl:when test="string-length(Process/@comment) > 0">
<xsl:value-of select="concat(' Comment: ', Process/@comment)"/>
</xsl:when>
</xsl:choose>
</xsl:variable>
<xsl:variable name="containment">
<xsl:choose>
<xsl:when test="string-length(Process/@containment) > 0">
<xsl:value-of select="concat(' Containment method: ', Process/@containment)"/>
</xsl:when>
</xsl:choose>
</xsl:variable>
<xsl:variable name="alternatives">
<xsl:choose>
<xsl:when test="string-length(Process/@alternatives) > 0">
<xsl:value-of select="concat(' Alternatives: ', Process/@alternatives)"/>
</xsl:when>
</xsl:choose>
</xsl:variable>
<tr>
<td rowspan="4">
<!-- Show the Process first, then each of the other variables on a new line -->
<div><xsl:value-of select="substring-after($process, ' ')"/></div>
<xsl:choose>
<xsl:when test="string-length($comment) > 0">
<div><xsl:value-of select="$comment"/></div>
</xsl:when>
</xsl:choose>
<xsl:choose>
<xsl:when test="string-length($containment) > 0">
<div><xsl:value-of select="$containment"/></div>
</xsl:when>
</xsl:choose>
<xsl:choose>
<xsl:when test="string-length($alternatives) > 0">
<div><xsl:value-of select="$alternatives"/></div>
</xsl:when>
</xsl:choose>
</td>
<td class="bold">Make-up</td>
<xsl:for-each select="MakeUp/Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
<tr>
<td>Estimation next year</td>
<xsl:for-each select="MakeUp/Quantity">
<xsl:apply-templates select="EstimatedValue"/>
</xsl:for-each>
</tr>
<tr>
<td class="bold">Emission</td>
<xsl:for-each select="Emissions/Quantity">
<xsl:apply-templates select="Value"/>
</xsl:for-each>
</tr>
<tr>
<td>Estimation next year</td>
<xsl:for-each select="Emissions/Quantity">
<xsl:apply-templates select="EstimatedValue"/>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template match="Process">
<td rowspan="4">
<xsl:value-of select="."/>
</td>
</xsl:template>
<xsl:template name="QuantitySumRow">
<xsl:param name="tablename"/>
<xsl:param name="date"/>
<xsl:param name="sumtext"/>
<xsl:param name="cols"/>
<xsl:param name="subtable"/>
<tr>
<td style="text-align:right;font-weight:bold;">
<xsl:attribute name="colspan">
<xsl:value-of select="$cols"/>
</xsl:attribute>
<xsl:choose>
<xsl:when test="$sumtext=''">Total</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$sumtext"/>
</xsl:otherwise>
</xsl:choose>
</td>
<xsl:for-each select="//ODSSubstances/Substance">
<xsl:variable name="code">
<xsl:value-of select="Code"/>
</xsl:variable>
<xsl:call-template name="QuantitySumCol">
<xsl:with-param name="substancecode">
<xsl:value-of select="$code"/>
</xsl:with-param>
<xsl:with-param name="tablename">
<xsl:value-of select="$tablename"/>
</xsl:with-param>
<xsl:with-param name="subtable">
<xsl:value-of select="$subtable"/>
</xsl:with-param>
<xsl:with-param name="date">
<xsl:value-of select="$date"/>
</xsl:with-param>
</xsl:call-template>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template name="QuantitySumCol">
<xsl:param name="tablename"/>
<xsl:param name="substancecode"/>
<xsl:param name="subtable"/>
<xsl:param name="date"/>
<td align="right" class="total">
<xsl:choose>
<xsl:when test="$subtable != ''">
<!--<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/*[name()=$subtable]/Quantity/Value[../SubstanceCode=$substancecode and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>--> <!--commented on 20210415-->
<!--<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/*[name()=$subtable]/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>--> <!--new 20210415--> <!-- commented on 20211112 -->
<!-- start new 20211112
<xsl:if test="contains(//ODSQuantities/*[name()=$tablename]/*/*[name()=$subtable]/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)],'.')">
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/*[name()=$subtable]/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'0.0000000')"/>
</xsl:if>
<xsl:if test="not(contains(//ODSQuantities/*[name()=$tablename]/*/*[name()=$subtable]/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)],'.'))">
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/*[name()=$subtable]/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>
</xsl:if>
end new 20211112 -->
<!-- start new 20220112 -->
<xsl:variable name="count" select="count( (//ODSQuantities/*[name()=$tablename]/*/*[name()=$subtable]/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0) and contains(., '.') ] ) )" />
<xsl:choose>
<xsl:when test="$count >= 1">
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/*[name()=$subtable]/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'0.0000000')"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/*[name()=$subtable]/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>
</xsl:otherwise>
</xsl:choose>
<!-- end new 20220112 -->
</xsl:when>
<xsl:when test="$date != ''">
<!--<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[../SubstanceCode=$substancecode and (substring(../../@date, 6,5) = $date or ../../@date = $date) and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>--> <!--commented on 20210415-->
<!--<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and (substring(../../@date, 6,5) = $date or ../../@date = $date) and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>--> <!--new 20210415--> <!-- commented on 20211112 -->
<!-- start new 20211112
<xsl:if test="contains(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and (substring(../../@date, 6,5) = $date or ../../@date = $date) and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)],'.')">
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and (substring(../../@date, 6,5) = $date or ../../@date = $date) and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'0.0000000')"/>
</xsl:if>
<xsl:if test="not(contains(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and (substring(../../@date, 6,5) = $date or ../../@date = $date) and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)],'.'))">
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and (substring(../../@date, 6,5) = $date or ../../@date = $date) and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>
</xsl:if>
end new 20211112 -->
<!-- start new 20220112 -->
<xsl:variable name="count" select="count( (//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and (substring(../../@date, 6,5) = $date or ../../@date = $date) and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0) and contains(., '.') ] ) )" />
<xsl:choose>
<xsl:when test="$count >= 1">
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and (substring(../../@date, 6,5) = $date or ../../@date = $date) and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'0.0000000')"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and (substring(../../@date, 6,5) = $date or ../../@date = $date) and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>
</xsl:otherwise>
</xsl:choose>
<!-- end new 20220112 -->
</xsl:when>
<xsl:otherwise>
<!--<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[../SubstanceCode=$substancecode and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>--> <!--commented on 20210415-->
<!--<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>--> <!--new 20210415--> <!-- commented on 20211112 -->
<!-- start new 20211112
<xsl:if test="contains(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)],'.')">
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'0.0000000')"/>
</xsl:if>
<xsl:if test="not(contains(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)],'.'))">
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>
</xsl:if>
end new 20211112 -->
<!-- start new 20220112 -->
<xsl:variable name="count" select="count( (//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0) and contains(., '.') ] ) )" />
<xsl:choose>
<xsl:when test="$count >= 1">
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'0.0000000')"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of
select="format-number(sum(//ODSQuantities/*[name()=$tablename]/*/Quantity/Value[translate(normalize-space(../SubstanceCode),' ','')=translate(normalize-space($substancecode),' ','') and string-length(.) > 0 and (number(.) > 0 or number(.) <= 0)]),'#')"/>
</xsl:otherwise>
</xsl:choose>
<!-- end new 20220112 -->
</xsl:otherwise>
</xsl:choose>
</td>
</xsl:template>
<xsl:template name="DateLabel">
<xsl:param name="date"/>
<xsl:choose>
<xsl:when test="$date = '01-01'">
At 01 January
</xsl:when>
<xsl:when test="$date = '12-31'">
At 31 December
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$date"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:template name="SubstancesHeaderCols">
<xsl:for-each select="//ODSSubstances/Substance">
<th width="100px" class="substance_cell">
<!--<xsl:value-of select="Code"/>--> <!-- ORIGINAL 20231020 -->
<!-- NEW 20231020 -->
<xsl:if test="Code = 'Complex and inconsistent mixture of fluorinated hydrocarbons(non-virgin)'">
<xsl:text>Complex and inconsistent mixture containing ODS(non-virgin)</xsl:text>
</xsl:if>
<xsl:if test="Code != 'Complex and inconsistent mixture of fluorinated hydrocarbons(non-virgin)'">
<xsl:value-of select="Code"/>
</xsl:if>
<!-- 20231020 -->
</th>
</xsl:for-each>
</xsl:template>
<xsl:template name="SubstancesHeaderColsEmpty">
<xsl:for-each select="//ODSSubstances/Substance">
<td width="100px" class="num_cell">
</td>
</xsl:for-each>
</xsl:template>
<xsl:template name="SubstancesHeaderColsEmptyTotal">
<xsl:for-each select="//ODSSubstances/Substance">
<td width="100px" align="right" class="total">
0
</td>
</xsl:for-each>
</xsl:template>
<xsl:template match="Value">
<td class="num_cell">
<xsl:value-of select="."/>
</td>
</xsl:template>
<xsl:template match="EstimatedValue">
<td class="num_cell">
<xsl:value-of select="."/>
</td>
</xsl:template>
<xsl:template match="*">
</xsl:template>
</xsl:stylesheet>