<?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_bjmx" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="842" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="20" uuid="bfcfd727-fda1-4b94-afad-79a182d8f078">
	<property name="ireport.zoom" value="1.768460768250001"/>
	<property name="ireport.x" value="29"/>
	<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="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_CH" mode="Opaque" backcolor="#FFBFBF">
		<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="bjmx" whenResourceMissingType="Empty" uuid="103f468a-d368-435a-a772-0a87d19b6773">
		<parameter name="p_where_mx" class="java.lang.String">
			<defaultValueExpression><![CDATA[]]></defaultValueExpression>
		</parameter>
		<queryString>
			<![CDATA[select (select mc  from dm_mx where dmm = '0470' and dm = tfyy) tfyy,
       bzhm, xm, ifnull(jgsyylgz, '') jgsyylgz, ifnull(jfgz, '') jfgz, tfrqq, tfrqz,
       replace(replace(replace(replace(replace(xz, '10', '养老'), '30', '失业'),'40', '工伤'), '50', '生育'), ',', ' ') xz,
    (case when zgylbz = '1' then '职工医疗' else '' end) || ' ' || (case when bcylbz = '1' then '补充医疗' else '' end) ylxz
  from GR_JGZGTF where grid in (select grid from tf_print)]]>
		</queryString>
		<field name="tfyy" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="bzhm" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="xm" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="jgsyylgz" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="jfgz" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="tfrqq" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="tfrqz" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="xz" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="ylxz" 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>
	</subDataset>
	<parameter name="p_dwdm" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="p_where" class="java.lang.String"/>
	<parameter name="p_rs" class="java.lang.Integer"/>
	<queryString>
		<![CDATA[select dwmc,dwdm,djzh from dw_xx where dwdm=$P!{p_dwdm}]]>
	</queryString>
	<field name="DWDM" class="java.lang.String"/>
	<field name="DJZH" class="java.lang.String"/>
	<field name="dwmc" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="80" splitType="Stretch">
			<staticText>
				<reportElement uuid="03f127cc-f6e7-4069-8228-24888905453c" x="182" y="50" width="479" height="24"/>
				<textElement textAlignment="Center">
					<font fontName="宋体" size="16"/>
				</textElement>
				<text><![CDATA[北京市社会保险费退费申报表（机关事业单位）]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band height="55" splitType="Stretch">
			<staticText>
				<reportElement uuid="5389803a-196c-4c60-a89a-55452f6d0c7f" x="22" y="34" width="84" height="16"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<text><![CDATA[社会保险登记号：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="6e434d56-4482-4ef9-92a2-88024e24c744" x="22" y="4" width="100" height="16"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<text><![CDATA[填报单位（公章）：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="e2161108-110f-4a3f-ad89-085efcc9b492" x="22" y="19" width="182" height="16"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<text><![CDATA[统一社会信用代码（组织机构代码）：]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement uuid="0c841c10-6d58-40c9-ab41-39befbc1ed87" x="194" y="18" width="403" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DWDM}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement uuid="dc86729f-0951-4471-ac18-c37ba14e44c8" x="106" y="34" width="491" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DJZH}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement uuid="4244e7e9-faf6-4e0d-86d9-53e7a850c6c9" x="134" y="1" width="463" height="20"/>
				<textElement>
					<font fontName="宋体"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{dwmc}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<detail>
		<band height="56" splitType="Stretch">
			<componentElement>
				<reportElement uuid="510f7bcd-4e39-4c40-86b0-e6bda6b807d7" key="table" style="table" x="21" y="3" width="664" height="50"/>
				<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="bjmx" uuid="0672795d-ca1d-410d-aaca-92f7223aa58d">
						<datasetParameter name="p_where_mx">
							<datasetParameterExpression><![CDATA[$P{p_where}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:column width="40" uuid="eb3936d3-e826-4e5a-9ae2-b53a7901f82f">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="5c5dbe71-9bac-4632-bb8b-a3db725f31f0" x="0" y="0" width="40" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="9"/>
								</textElement>
								<text><![CDATA[序号]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="6f9439d1-ed4f-4523-88f8-24acc2739bae" x="0" y="0" width="40" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="8"/>
								</textElement>
								<textFieldExpression><![CDATA[$V{xh}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="108" uuid="76e1e918-002e-4311-b56f-6536ff98c9f0">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="cc55a2ad-3a9c-426c-97be-f24b8ebffc57" x="0" y="0" width="108" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<text><![CDATA[公民身份号码]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="2e614a27-7d50-4fff-a6b0-1da29f9f7e67" x="0" y="0" width="108" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{bzhm}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="58" uuid="01ac849b-6ccf-4fe0-b473-488b5f66def0">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="150070a5-efed-408b-b937-568bce5bd194" x="0" y="0" width="58" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<text><![CDATA[姓名]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="34b79d5b-f294-4057-91c3-d4e4d9d70eaf" x="0" y="0" width="58" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{xm}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="64" uuid="9eb4b664-12ef-487a-a902-91048a8adc70">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="79eb54d7-5efc-4805-9bdd-de091cfddb5c" x="0" y="0" width="64" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<text><![CDATA[机关养老工资]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="3539cf35-7257-4b2b-821a-ed1b2939dbea" x="0" y="0" width="64" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{jgsyylgz}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="64" uuid="ddc9b9ae-07ae-482d-84d2-20f5256f516a">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="893842ef-9a99-4e4e-8d3e-92a5f2087968" x="0" y="0" width="64" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<text><![CDATA[职工缴费工资]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="a9d9befc-c534-49a2-b79d-50db7fbb61ca" x="0" y="0" width="64" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{jfgz}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="83" uuid="923db9ec-6f00-4d7c-89c6-5c9002e73030">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="3e51d20b-50bf-41b2-b835-fbb72bce8601" x="0" y="0" width="83" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<text><![CDATA[退费原因]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="4ddbd184-8e60-4add-a3ee-7603e34bb844" x="0" y="0" width="83" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{tfyy}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="122" uuid="81d8af7a-ee5d-4f9f-bc76-2f2f927cc448">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="e65846ab-aff9-4a94-aade-4dba74d24085" x="0" y="0" width="122" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="9"/>
								</textElement>
								<text><![CDATA[四险险种]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="919e698d-bdf8-4a2a-af6a-3921ace96de3" x="0" y="0" width="122" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="8"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{xz}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="103" uuid="271accb6-cc1b-4a26-bdea-aac26bc7730a">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="4fc3d212-5af6-44f8-9089-d06ce7577961" x="0" y="0" width="103" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="9"/>
								</textElement>
								<text><![CDATA[医疗险种]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="e6a9aa82-b478-4317-996c-46179050e32f" x="0" y="0" width="103" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="8"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{ylxz}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="72" uuid="c13c8ad9-063a-4847-91a1-54857d7c9f1e">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="f181c167-8ad5-48e4-a97e-d114f4d86daa" x="0" y="0" width="72" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="9"/>
								</textElement>
								<text><![CDATA[退费起日期]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="51f9ee43-1539-4e20-b46d-53f5a427e92a" x="0" y="0" width="72" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="8"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{tfrqq}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="65" uuid="0d6cae60-3083-4547-927d-dbaa786407c5">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="903636ec-0e6e-4df7-8b12-0d3119681305" x="1" y="0" width="64" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="9"/>
								</textElement>
								<text><![CDATA[退费止日期]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table_TD" height="30" rowSpan="1">
							<textField>
								<reportElement uuid="71cd5b2f-a79b-43ea-aa1b-f10683b2b859" x="1" y="0" width="64" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="8"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{tfrqz}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
		</band>
	</detail>
	<pageFooter>
		<band height="92">
			<staticText>
				<reportElement uuid="88147e49-c4bf-48bf-8298-07dd52f202c3" x="22" y="4" width="100" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[单位负责人:]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5c749957-56b7-439b-8cda-192a72f1aaed" x="22" y="20" width="100" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="2f22fc14-9690-42d1-bdcd-962f9ea6b98b" x="22" y="36" width="100" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[单位经办人:]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="15179b15-2792-4906-a763-e4cfde73432d" x="22" y="52" width="100" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="12c44d2c-492e-41e2-8bf1-de3ecf03f2e9" x="22" y="68" width="224" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[填报日期：        年       月       日]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="83d1d23d-5dfa-47b0-b9f8-d63803cb2e48" x="400" y="36" width="193" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[社保经（代）办机构经办人员（签章）：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="a4401e18-0cd0-4982-9b85-e2d4c277aab8" x="400" y="64" width="206" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[办理日期：       年       月       日]]></text>
			</staticText>
		</band>
	</pageFooter>
</jasperReport>
