<?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.607691607500001"/>
	<property name="ireport.x" value="13"/>
	<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 bzhm,xm,jgyljfgz,zgjfgz,
(case when ylxzzt='1' then '养老' else '' end)||
(case when syxzzt='1' then ',失业' else '' end)||
(case when gsxzzt='1' then ',工伤' else '' end)||
(case when sxxzzt='1' then ',生育' else '' end) xz,
(case when zgylxzzt='1' then '职工医疗' else '' end)||
(case when bcylxzzt='1' then ',补充医疗3%' else '' end) ylxz,bjqrq,bjzrq
,(case when jgsybjbs='1' then '机关补缴' else '企业补缴' end) jgsybjbs
,(select mc from dm_mx where dmm ='0471' and dm =bjyy) bjyy,jgyljsc,syjsc,gsjsc,sxjsc
 from GR_JGBJ_ZBQ where grid in (select grid from jgbjzbq_print)]]>
		</queryString>
		<field name="bzhm" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="xm" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="jgyljfgz" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="zgjfgz" 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"/>
		<field name="bjqrq" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="bjzrq" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="jgsybjbs" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="bjyy" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="jgyljsc" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="syjsc" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="gsjsc" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<field name="sxjsc" class="java.lang.String">
			<fieldDescription><![CDATA[]]></fieldDescription>
		</field>
		<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"/>
	<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="79" splitType="Stretch">
			<staticText>
				<reportElement uuid="03f127cc-f6e7-4069-8228-24888905453c" x="280" y="55" width="347" height="24"/>
				<textElement>
					<font fontName="宋体" size="16"/>
				</textElement>
				<text><![CDATA[北京市社会保险费补缴申报表（机关事业单位）]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band height="46" splitType="Stretch">
			<staticText>
				<reportElement uuid="5389803a-196c-4c60-a89a-55452f6d0c7f" x="31" y="30" width="124" height="16"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<text><![CDATA[社会保险登记号：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="6e434d56-4482-4ef9-92a2-88024e24c744" x="31" y="0" width="100" height="16"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<text><![CDATA[填报单位（公章）：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="e2161108-110f-4a3f-ad89-085efcc9b492" x="31" y="15" width="224" height="16"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<text><![CDATA[社会统一信用代码（组织机构代码）：]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement uuid="0c841c10-6d58-40c9-ab41-39befbc1ed87" x="205" y="15" width="268" 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="155" y="30" width="272" 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="50" splitType="Stretch">
			<componentElement>
				<reportElement uuid="510f7bcd-4e39-4c40-86b0-e6bda6b807d7" key="table" style="table" x="31" y="0" width="757" 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="28" uuid="19c7df74-2be0-4b9c-b2ae-6eef1d5258de">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="285bddb4-6c85-46c9-843f-15f574d81e03" x="0" y="0" width="28" 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 isBlankWhenNull="true">
								<reportElement uuid="13c68864-b09c-4809-86a7-a80943953764" x="0" y="0" width="28" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$V{xh}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="86" uuid="eb3936d3-e826-4e5a-9ae2-b53a7901f82f">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="8bf523be-a145-4dfd-b13e-55aae5f318d9" x="0" y="0" width="86" 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="a8b323f2-44ef-466a-9227-9715454d6c5c" x="0" y="0" width="86" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{bjyy}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="88" uuid="76e1e918-002e-4311-b56f-6536ff98c9f0">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="380b6d1f-de0a-4713-8cf4-46b5a5464861" x="0" y="0" width="88" 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="afa3d6cd-95bc-456d-955c-5e862462dfbe" x="0" y="0" width="88" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{bzhm}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="46" uuid="01ac849b-6ccf-4fe0-b473-488b5f66def0">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="0acb9412-fe2b-44ed-89a8-bd23fa5c4860" x="0" y="0" width="46" 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="9691f4fd-ea61-4481-8804-3a76d69484af" x="0" y="0" width="46" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{xm}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="48" uuid="ddc9b9ae-07ae-482d-84d2-20f5256f516a">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="0b477ee5-1dc8-42f9-889f-2f93a2ff27e3" x="0" y="0" width="48" 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 isBlankWhenNull="true">
								<reportElement uuid="5e95e800-50db-4d22-b4e4-e221c890acb4" x="0" y="0" width="48" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{zgjfgz}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="63" uuid="923db9ec-6f00-4d7c-89c6-5c9002e73030">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="62730fde-e783-478b-9ab6-7fbe4ff2c56a" x="0" y="0" width="63" 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 isBlankWhenNull="true">
								<reportElement uuid="bd743cdb-9397-4921-9bdb-3a1a4c62e5d3" x="0" y="0" width="63" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{jgyljsc}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="66" uuid="e17e5bd4-0045-487c-aff8-26267a241694">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="e07e98be-c57f-437c-a92b-35b86a250bed" x="0" y="0" width="66" 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 isBlankWhenNull="true">
								<reportElement uuid="d9c76981-1d8d-48b5-8d43-848417fce8fe" x="0" y="0" width="66" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{syjsc}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="69" uuid="0eb646a1-3d7e-4d5e-a8cd-034697466e23">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="d634de3f-0807-4ae7-bbcd-799f35b2fa47" x="0" y="0" width="69" 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 isBlankWhenNull="true">
								<reportElement uuid="71ce872d-63e5-4151-afaf-ff1e1ec5e7d4" x="0" y="0" width="69" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{gsjsc}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="62" uuid="3929a31c-cda0-4dbd-8781-4893f0227a5f">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="d5eb34a9-129f-4bab-a12a-0aa205f08b71" x="0" y="0" width="62" 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 isBlankWhenNull="true">
								<reportElement uuid="c6319158-b02b-4c14-b375-1fb21bcd0fe8" x="0" y="0" width="62" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{sxjsc}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="95" uuid="21c2cde1-a8b5-4059-bd61-c4291b1910e7">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="bd067fad-e92e-441e-9922-1a3813c15023" x="0" y="0" width="95" 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="fd7f21fc-cb0b-4fee-b623-36d91ab26be4" x="0" y="0" width="95" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{xz}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="53" uuid="00b20909-0cdc-4277-992f-d7d8d63aa864">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="1a129f18-4f06-4415-840f-0a75da481397" x="0" y="0" width="53" 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="b0f4f729-b0a9-4189-af74-348c0c1757fc" x="0" y="0" width="53" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{bjqrq}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="54" uuid="8d376671-9987-4d26-ac48-9c23da06dbb8">
						<jr:columnHeader style="table_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="598e29ef-f67a-43bc-86ab-06f0d7d0461f" x="0" y="0" width="53" 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="0c9e101c-179a-414d-9739-2b102b264cc4" x="0" y="0" width="53" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{bjzrq}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
		</band>
	</detail>
	<pageFooter>
		<band height="104">
			<staticText>
				<reportElement uuid="88147e49-c4bf-48bf-8298-07dd52f202c3" x="31" y="0" width="100" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[单位负责人:]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5c749957-56b7-439b-8cda-192a72f1aaed" x="31" y="16" width="100" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="2f22fc14-9690-42d1-bdcd-962f9ea6b98b" x="31" y="32" width="100" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[单位经办人:]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="15179b15-2792-4906-a763-e4cfde73432d" x="31" y="48" width="100" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="12c44d2c-492e-41e2-8bf1-de3ecf03f2e9" x="31" y="64" width="224" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[填报日期：        年       月       日]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="83d1d23d-5dfa-47b0-b9f8-d63803cb2e48" x="462" y="32" width="193" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[社保经（代）办机构经办人员（签章）：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="a4401e18-0cd0-4982-9b85-e2d4c277aab8" x="462" y="64" width="206" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[办理日期：       年       月       日]]></text>
			</staticText>
		</band>
	</pageFooter>
</jasperReport>
