﻿<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output version="4.0" method="html" indent="no" encoding="UTF-8" doctype-public="-//W3C//DTD HTML 4.01 Transitional//EN"/>
	<xsl:param name="SV_OutputFormat" select="'HTML'"/>
	<xsl:variable name="XML1" select="/"/>
	<xsl:decimal-format decimal-separator="," grouping-separator=" " />
	<xsl:template match="/">
		<html>
			<head>
				<title/>
				<meta http-equiv="X-UA-Compatible" content="IE=5"/>
				<style type="text/css">
					@page 
					{ 
					margin-left:0.6in; 
					margin-right:0.6in; 
					margin-top:0.79in; 
					margin-bottom:0.79in 
					} 
				</style>
				<style>
					td
					{padding-top:1px;
					padding-right:3px;
					padding-bottom:1px;
					padding-left:3px;
					color:windowtext;
					font-size:9pt;
					font-weight:400;
					font-style:normal;
					text-decoration:none;
					font-family:"Arial";					
					vertical-align:center;
					color:#191970;
					word-wrap:break-word;}
					tr
					{height:20}
					
				</style>
			</head>
			<body>
				<xsl:for-each select="$XML1">
					<xsl:for-each select="RTS_DOC">
						
							<xsl:for-each select="BUH03">
								<table width="100%" style="color=#191970;  word-wrap:break-word; border:0; border-bottom:0; border-collapse:collapse; border-left:0; border-right:0;" border="1">
									<tr>
										<td colspan="5" style="text-align: center; font-size:14; font-weight:bold;">
											<xsl:text>Сводный ежедневный отчет итоговых денежных расчетов</xsl:text>
											<br/>
											<xsl:text>по исполненным договорам за </xsl:text>
											<xsl:for-each select="@ReportDate">
												<xsl:variable name="seqContentStrings_0">
													<xsl:value-of select="format-number(number(substring(string(string(.)), 9, 2)), '00')"/>
													<xsl:text>-</xsl:text>
													<xsl:value-of select="format-number(number(substring(string(string(.)), 6, 2)), '00')"/>
													<xsl:text>-</xsl:text>
													<xsl:value-of select="format-number(number(substring(string(string(string(.))), 1, 4)), '0000')"/>
												</xsl:variable>
												<xsl:variable name="sContent_0" select="string($seqContentStrings_0)"/>
												<xsl:value-of select="$sContent_0"/>
											</xsl:for-each>
										</td>
									</tr>
								</table>
							<xsl:choose>
								<xsl:when test="MEMBER/CURRENCY/@SettleCurrency='USD'">
									<table width="100%" style="color=#191970; font-size:8; word-wrap:break-word; border:0; border-bottom:0; border-collapse:collapse; border-left:0; border-right:0;" border="1">
										<tr height="20" style="background=#CFCED9; text-align:center;">
											<td>
												<xsl:text>Код УК</xsl:text>
											</td>
											<td>
												<xsl:text>Кр. наим. УК</xsl:text>
											</td>											
											<td>
												<xsl:text>Валюта расчетов</xsl:text>
											</td>											
											<td>
												<xsl:text>Получено средств, usd</xsl:text>
											</td>
											<td>
												<xsl:text>Уплачено средств, usd</xsl:text>
											</td>											
										</tr>
										<xsl:for-each select="MEMBER">
											<xsl:for-each select="CURRENCY">
												<xsl:for-each select="TURNOVER">
													<xsl:choose>
														<xsl:when test="../@SettleCurrency='USD'">
															<tr>
																<td>
																	<xsl:value-of select="../../@MemberCode"/>
																</td>
																<td>
																	<xsl:value-of select="../../@MemberShortName"/>
																</td>
																<td style="text-align: center">
																	<xsl:for-each select="../@SettleCurrency">
																		<xsl:value-of select="string(.)"/>
																	</xsl:for-each>
																</td>																
																<td style="text-align: right;">
																	<xsl:for-each select="@VolumeDebit">
																		<xsl:value-of select="format-number(number(string(.)), '# ##0,00')"/>
																	</xsl:for-each>
																</td>
																<td style="text-align: right;">
																	<xsl:for-each select="@VolumeCredit">
																		<xsl:value-of select="format-number(number(string(.)), '# ##0,00')"/>
																	</xsl:for-each>
																</td>
																
															</tr>
														</xsl:when>
													</xsl:choose>
												</xsl:for-each>
											</xsl:for-each>
										</xsl:for-each>
										<xsl:for-each select="TOTAL">
											<xsl:for-each select="CURRENCY">
												<xsl:choose>
													<xsl:when test="@SettleCurrency='USD'">
														<xsl:for-each select="TURNOVER">
															<tr style="background=#EEECCC; font-weight:bold; text-align:left;">
																<td colspan="3" style="font-weight:bold; text-align:right;">
																	<xsl:text>Cуммарные обороты:&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;</xsl:text>
																</td>
																<td  style="font-weight:bold; text-align: right;">
																	<xsl:for-each select="@VolumeDebit">
																		<xsl:value-of select="format-number(number(string(.)), '# ##0,00')"/>
																	</xsl:for-each>
																</td>
																<td  style="font-weight:bold; text-align: right;">
																	<xsl:for-each select="@VolumeCredit">
																		<xsl:value-of select="format-number(number(string(.)), '# ##0,00')"/>
																	</xsl:for-each>
																</td>
																
															</tr>
														</xsl:for-each>
													</xsl:when>
												</xsl:choose>
											</xsl:for-each>
										</xsl:for-each>

									</table>
								</xsl:when>
							</xsl:choose>
							<br/>
							<xsl:choose>
								<xsl:when test="MEMBER/CURRENCY/@SettleCurrency='RUB'">
									<table width="100%" style="color=#191970; font-size:11; word-wrap:break-word; border:0; border-bottom:0; border-collapse:collapse; border-left:0; border-right:0;" border="1">
										<tr style="background=#CFCED9; text-align:center">
											<td>
												<xsl:text>Код УК</xsl:text>
											</td>
											<td>
												<xsl:text>Кр. наим. УК</xsl:text>
											</td>
											<td>
												<xsl:text>Валюта расчетов</xsl:text>
											</td>
											<td>
												<xsl:text>Получено средств, руб</xsl:text>
											</td>
											<td>
												<xsl:text>Уплачено средств, руб</xsl:text>
											</td>
										</tr>
										<xsl:for-each select="MEMBER">
											<xsl:for-each select="CURRENCY">
												<xsl:for-each select="TURNOVER">
													<xsl:choose>
														<xsl:when test="../@SettleCurrency='RUB'">
															<tr>
																<td>
																	<xsl:value-of select="../../@MemberCode"/>
																</td>
																<td>
																	<xsl:value-of select="../../@MemberShortName"/>
																</td>																
																<td style="text-align: center">
																	<xsl:for-each select="../@SettleCurrency">
																		<xsl:value-of select="string(.)"/>
																	</xsl:for-each>
																</td>																
																<td style="text-align: right;">
																	<xsl:for-each select="@VolumeDebit">
																		<xsl:value-of select="format-number(number(string(.)), '# ##0,00')"/>
																	</xsl:for-each>
																</td>
																<td style="text-align: right;">
																	<xsl:for-each select="@VolumeCredit">
																		<xsl:value-of select="format-number(number(string(.)), '# ##0,00')"/>
																	</xsl:for-each>
																</td>																
															</tr>
														</xsl:when>
													</xsl:choose>
												</xsl:for-each>
											</xsl:for-each>
										</xsl:for-each>
										<xsl:for-each select="TOTAL">
											<xsl:for-each select="CURRENCY">
												<xsl:choose>
													<xsl:when test="@SettleCurrency='RUB'">
														<xsl:for-each select="TURNOVER">
															<tr style="background=#EEECCC; font-weight:bold; text-align:left;">
																<td colspan="3" style="font-weight:bold; text-align:right;">
																	<xsl:text>Cуммарные обороты:&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;</xsl:text>
																</td>
																<td  style="font-weight:bold; text-align:right;">
																	<xsl:for-each select="@VolumeDebit">
																		<xsl:value-of select="format-number(number(string(.)), '# ##0,00')"/>
																	</xsl:for-each>
																</td>
																<td  style="font-weight:bold; text-align:right;">
																	<xsl:for-each select="@VolumeCredit">
																		<xsl:value-of select="format-number(number(string(.)), '# ##0,00')"/>
																	</xsl:for-each>
																</td>																
															</tr>
														</xsl:for-each>
													</xsl:when>
												</xsl:choose>
											</xsl:for-each>
										</xsl:for-each>

									</table>
								</xsl:when>
							</xsl:choose>
						</xsl:for-each>
					</xsl:for-each>					
				</xsl:for-each>
			</body>
		</html>
	</xsl:template>
</xsl:stylesheet>
