<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="report_a4_txxx" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="2b3fb092-6905-4cb6-ad52-f2579f11afce">
	<property name="ireport.zoom" value="1.771561000000001"/>
	<property name="ireport.x" value="43"/>
	<property name="ireport.y" value="0"/>
	<style name="table">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<subDataset name="sx" uuid="6d517548-08ac-49f3-beeb-b0b95031a4e5">
		<parameter name="p_where_tx" class="java.lang.String"/>
		<queryString>
			<![CDATA[select 1 xh,b.bzhm bzhm, a.xm xm, c.dacsrq dacsrq,
			(select mc from dm_mx where dmm ='1202' and dm=b.txlb) txlb
			, b.txrq txrq, b.zfrq zfrq,
			(select mc from dm_mx where dmm ='JG0010' and dm=b.jfbf)  jfbf,c.stnx,
	       (select sum(je)
	           from GR_YLZF_YLJ_TX_L
	          where YLJDM ='01D20'
	            and bzhm = a.bzhm) t
			  from gr_xx_tx a, gr_ylzf_tx_l b ,GR_XX_TX c
			 where a.bzhm = b.bzhm
			   and a.bzhm =c.bzhm
			   and jfbf = '1001'  and a.dwdm=$P{p_where_tx}
			union all
			select 1 xh,b.bzhm bzhm, a.xm xm, c.dacsrq dacsrq,
			(select mc from dm_mx where dmm ='1202' and dm=b.txlb) txlb
			, b.txrq txrq, b.zfrq zfrq, 	(select mc from dm_mx where dmm ='JG0010' and dm=b.jfbf) jfbf,c.stnx,
			       (select sum(je)
			           from GR_YLZF_YLJ_TX_L
			          where YLJDM ='01D20'
			            and bzhm = a.bzhm) t
			  from gr_xx_tx a, gr_ylzf_tx_l b ,GR_XX_TX c
			 where a.bzhm = b.bzhm
			   and a.bzhm =c.bzhm
			   and jfbf = '1002'
                                       and a.dwdm=$P{p_where_tx}]]>
		</queryString>
		<field name="XH" class="java.lang.String"/>
		<field name="BZHM" class="java.lang.String"/>
		<field name="XM" class="java.lang.String"/>
		<field name="DACSRQ" class="java.lang.String"/>
		<field name="TXLB" class="java.lang.String"/>
		<field name="TXRQ" class="java.lang.String"/>
		<field name="ZFRQ" class="java.lang.String"/>
		<field name="JFBF" class="java.lang.String"/>
		<field name="STNX" class="java.lang.String"/>
		<field name="T" class="java.lang.String"/>
		<variable name="xh" class="java.lang.Integer" calculation="Count">
			<variableExpression><![CDATA[$V{xh}.valueOf(1)]]></variableExpression>
			<initialValueExpression><![CDATA[1]]></initialValueExpression>
		</variable>
		<group name="BZHM">
			<groupExpression><![CDATA[$F{BZHM}]]></groupExpression>
		</group>
	</subDataset>
	<parameter name="p_where" class="java.lang.String"/>
	<queryString>
		<![CDATA[select dwmc,dwdm,djzh from dw_xx  where dwdm=$P{p_where}]]>
	</queryString>
	<field name="dwdm" class="java.lang.String"/>
	<field name="dwmc" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="56" splitType="Stretch">
			<staticText>
				<reportElement uuid="1e3bf389-d28a-4541-864f-7a1b629183f3" x="0" y="11" width="802" height="45"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="宋体" size="20"/>
				</textElement>
				<text><![CDATA[北京市机关事业单位改革前退休人员待遇信息过录表]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band height="20">
			<staticText>
				<reportElement uuid="dc1d7beb-94ff-4046-ad61-e13386977cb7" x="0" y="0" width="173" height="20"/>
				<textElement/>
				<text><![CDATA[统一社会信用代码（组织机构代码）：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="4231202b-bc87-4906-bed1-0218246d6536" x="313" y="0" width="82" height="20"/>
				<textElement/>
				<text><![CDATA[单位名称（章）：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="901cb659-928f-42b9-8260-7cc406d5d179" x="672" y="0" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[单位:元(保留两位小数)]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement uuid="cdaf8fa1-d74e-4955-84f8-903576b94771" x="169" y="0" width="144" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{dwdm}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement uuid="7c8fcb12-ca15-4d6f-b714-4cc39fda5ce3" x="395" y="0" width="293" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{dwmc}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<detail>
		<band height="125" splitType="Stretch">
			<componentElement>
				<reportElement uuid="26b89f7c-866b-4a17-b296-1dbcc4cecfa1" key="table" style="table" x="0" y="0" width="802" height="52"/>
				<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
					<datasetRun subDataset="sx" uuid="73f8354a-754b-4ffa-842a-562b81159989">
						<datasetParameter name="p_where_tx">
							<datasetParameterExpression><![CDATA[$P{p_where}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:column width="31" uuid="e37361aa-3dce-4031-a168-d831363e35a3">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="89d5fbad-da71-4ca5-b267-7d7bc858f36a" x="0" y="0" width="31" height="30"/>
								<box>
									<pen lineWidth="1.0"/>
									<topPen lineWidth="1.0"/>
									<leftPen lineWidth="1.0"/>
									<bottomPen lineWidth="1.0"/>
									<rightPen lineWidth="1.0"/>
								</box>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[序号]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell height="30" rowSpan="1">
							<textField>
								<reportElement uuid="a0fa2bac-ce24-4708-8601-d698182b95f1" x="0" y="0" width="31" height="30"/>
								<box>
									<pen lineWidth="1.0"/>
									<topPen lineWidth="1.0"/>
									<leftPen lineWidth="1.0"/>
									<bottomPen lineWidth="1.0"/>
									<rightPen lineWidth="1.0"/>
								</box>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$V{xh}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="10f99083-0d65-4c98-a6b3-23fbd8c23312">
						<jr:columnHeader style="table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="386773c1-20c6-4191-8d95-723fef766ffd" style="table" mode="Opaque" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[公民身份号码]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="a346a334-6263-4d20-930f-8442cfd10d78" x="0" y="0" width="90" height="30"/>
								<box>
									<pen lineWidth="1.0"/>
									<topPen lineWidth="1.0"/>
									<leftPen lineWidth="1.0"/>
									<bottomPen lineWidth="1.0"/>
									<rightPen lineWidth="1.0"/>
								</box>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{BZHM}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="6e630311-2bb8-4348-8bb6-876132f93bec">
						<jr:columnHeader style="table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="9fdaf6c1-6fa9-4481-8819-6faeb82a3840" style="table" mode="Opaque" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[姓名]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="1869ee26-b6de-43c4-baa2-7edd8f79ddce" x="0" y="0" width="90" height="30"/>
								<box>
									<pen lineWidth="1.0"/>
									<topPen lineWidth="1.0"/>
									<leftPen lineWidth="1.0"/>
									<bottomPen lineWidth="1.0"/>
									<rightPen lineWidth="1.0"/>
								</box>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{XM}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="1f0c2dea-c55f-4951-8b68-a4173f83beb4">
						<jr:columnHeader style="table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="8678f675-48b0-43ba-bd3c-bbffe6fe8412" style="table" mode="Opaque" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[退休时认定
出生日期]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="a5775c59-4dca-4371-b97e-7ec6d8324f8b" x="0" y="0" width="90" height="30"/>
								<box>
									<pen lineWidth="1.0"/>
									<topPen lineWidth="1.0"/>
									<leftPen lineWidth="1.0"/>
									<bottomPen lineWidth="1.0"/>
									<rightPen lineWidth="1.0"/>
								</box>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{DACSRQ}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="268a5daa-a9a9-4f58-9f6d-7eb193a3f806">
						<jr:columnHeader style="table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="51c87793-1d93-4592-8648-4d29f75ebda6" style="table" mode="Opaque" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[退休类别]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="79f204e0-4943-40a5-9941-93cf6f5bc640" x="0" y="0" width="90" height="30"/>
								<box>
									<pen lineWidth="1.0"/>
									<topPen lineWidth="1.0"/>
									<leftPen lineWidth="1.0"/>
									<bottomPen lineWidth="1.0"/>
									<rightPen lineWidth="1.0"/>
								</box>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{TXLB}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="58" uuid="0cb8be5a-1e58-495c-9855-33e0122e0e79">
						<jr:columnHeader height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="0ef0a446-fd26-4a7e-8545-a0357ac08c88" x="0" y="0" width="58" height="30"/>
								<box>
									<pen lineWidth="1.0"/>
									<topPen lineWidth="1.0"/>
									<leftPen lineWidth="1.0"/>
									<bottomPen lineWidth="1.0"/>
									<rightPen lineWidth="1.0"/>
								</box>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[视同缴
费年限]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="1e3c5b71-30b6-4da7-b838-50787492b0a9" x="0" y="0" width="58" height="30"/>
								<box>
									<pen lineWidth="1.0"/>
									<topPen lineWidth="1.0"/>
									<leftPen lineWidth="1.0"/>
									<bottomPen lineWidth="1.0"/>
									<rightPen lineWidth="1.0"/>
								</box>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{STNX}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="13db2635-ecb5-498b-9374-af7df1fe0a3c">
						<jr:columnHeader style="table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="26928081-3d2d-4f4f-ae5a-60601cef93a6" style="table" mode="Opaque" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[退休日期]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="9518dca4-b1e2-43fa-9eae-632d602eaace" x="0" y="0" width="90" height="30"/>
								<box>
									<pen lineWidth="1.0"/>
									<topPen lineWidth="1.0"/>
									<leftPen lineWidth="1.0"/>
									<bottomPen lineWidth="1.0"/>
									<rightPen lineWidth="1.0"/>
								</box>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{TXRQ}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="68" uuid="584dcb69-5d73-443d-b62f-d95117ec2794">
						<jr:columnHeader style="table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="25976c37-42bd-4ae7-be70-c6a52f4c1018" style="table" mode="Opaque" x="0" y="0" width="68" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[起始支
付日期]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="f8316d66-1617-44cc-b351-50c565d88e8a" style="table" x="0" y="0" width="68" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{ZFRQ}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="71" uuid="d02d1af6-6693-496a-95b7-4ed2f55ffe15">
						<jr:columnHeader style="table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="1cee069f-acd5-45d8-a744-98bf4a1dd00d" style="table" mode="Opaque" x="0" y="0" width="71" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[计发类别]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="8468a199-e858-48a4-98a0-0a1710040f98" style="table" x="0" y="0" width="71" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{JFBF}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="4ab1c7f6-ee33-4648-954c-e881a88101ec">
						<jr:columnHeader style="table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="76403629-f5f2-4e57-8129-5a78187ff2c7" style="table" mode="Opaque" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[统筹支
付金额]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="85a559c1-1709-49d2-892f-9d807540acaf" x="0" y="0" width="90" height="30"/>
								<box>
									<pen lineWidth="1.0"/>
									<topPen lineWidth="1.0"/>
									<leftPen lineWidth="1.0"/>
									<bottomPen lineWidth="1.0"/>
									<rightPen lineWidth="1.0"/>
								</box>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{T}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
		</band>
	</detail>
	<columnFooter>
		<band height="45" splitType="Stretch">
			<staticText>
				<reportElement uuid="c973e378-cbb0-4dd7-8d2e-3daf4173b2e1" x="0" y="0" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[单位负责人：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5678b9a6-0db5-433d-9d75-2b4feee4276a" x="446" y="0" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[组织人事部门（章）]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="d8956d0a-361b-4d56-9bf8-b8d74426af63" x="0" y="25" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[日期：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="266a89a6-4445-498f-b358-754ecbb842fd" x="446" y="25" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[组织人事负责人：]]></text>
			</staticText>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="20" splitType="Stretch">
			<staticText>
				<reportElement uuid="d7119ca9-12af-481d-998a-a25efeebb4f8" x="446" y="0" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[日期：]]></text>
			</staticText>
		</band>
	</pageFooter>
</jasperReport>
