<?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="report1" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ea77bfb2-4dc0-4811-998f-b8a7f4a9b0af">
	<property name="ireport.zoom" value="1.6105100000000008"/>
	<property name="ireport.x" value="14"/>
	<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="mx" whenResourceMissingType="Empty" uuid="754e084e-e3e9-4bd8-9252-66fbc847ecf1">
		<parameter name="p_dwdm_mx" class="java.lang.String"/>
		<parameter name="p_where_mx" class="java.lang.String"/>
		<parameter name="p2_mx" class="java.lang.String"/>
		<parameter name="p4_mx" class="java.lang.String"/>
		<queryString>
			<![CDATA[select xm,case when xb='1' then '男' else '女' end xbmc,bzhm,(select mc from dm_mx where dmm='0237' and dm=jfrylb) jfrylbmc ,case when jgylgz is null then 0 else jgylgz end jgylgz ,zggz from GR_JGSY_JSHD $P!{p_where_mx}]]>
		</queryString>
		<field name="XM" class="java.lang.String"/>
		<field name="XBMC" class="java.lang.String"/>
		<field name="BZHM" class="java.lang.String"/>
		<field name="JFRYLBMC" class="java.lang.String"/>
		<field name="JGYLGZ" class="java.lang.String"/>
		<field name="ZGGZ" 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"/>
	<parameter name="p_nian" class="java.lang.String"/>
	<parameter name="p_where" class="java.lang.String"/>
	<parameter name="p2" class="java.lang.String"/>
	<parameter name="p4" class="java.lang.String"/>
	<queryString>
		<![CDATA[select dwmc,dwdm,djzh from dw_xx where dwdm=$P{p_dwdm}]]>
	</queryString>
	<field name="DWMC" class="java.lang.String"/>
	<field name="DWDM" class="java.lang.String"/>
	<field name="DJZH" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="44" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement uuid="776bc815-658d-4e59-adb9-4b5e7c12687f" x="322" y="21" width="60" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="宋体" size="16"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{p_nian}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="8620d8f8-ea6e-4f90-a7ce-cef05ae2189f" x="322" y="24" width="301" height="20"/>
				<textElement>
					<font fontName="宋体" size="16"/>
				</textElement>
				<text><![CDATA[（    ）年度]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="1d8d04c4-bbb7-42c2-9901-169a06a28d3f" x="0" y="0" width="802" height="24"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="宋体" size="16"/>
				</textElement>
				<text><![CDATA[北京市机关养老上年月均工资申报明细表]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band height="48" splitType="Stretch">
			<staticText>
				<reportElement uuid="3b2cf571-2ee7-4136-a831-7b5ccc9ba328" x="99" y="2" width="100" height="16"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<text><![CDATA[单位名称:(盖章)：]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement uuid="b2a7874b-1364-42cc-869c-f6d9c78385b1" x="266" y="16" width="254" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DWDM}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement uuid="6d20d705-24fd-4899-a2cf-8ed642f4913e" x="223" y="32" width="297" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DJZH}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="1f8e57dc-ccfc-436c-aaa5-8f57c1e54a48" x="636" y="28" width="100" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[单位：人、元]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="7df8171f-ce79-4db8-a572-5e1cd2cb20cb" x="99" y="17" width="183" height="16"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<text><![CDATA[统一社会信用代码（组织机构代码）：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="f1b84015-7e08-4e55-95e2-092b33a07968" x="99" y="32" width="124" height="16"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<text><![CDATA[社会保险登记号：]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement uuid="de8e820d-c5ff-4441-a74e-0f0070dce364" x="199" y="2" width="321" height="14"/>
				<textElement>
					<font fontName="宋体"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DWMC}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<detail>
		<band height="58">
			<componentElement>
				<reportElement uuid="2a1db92e-2105-47b7-8c3e-fa26ef825085" key="table" style="table" x="99" y="0" width="630" height="58"/>
				<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="mx" uuid="1725ec46-c354-4e15-b253-6933f8e9959f">
						<datasetParameter name="p_where_mx">
							<datasetParameterExpression><![CDATA[$P{p_where}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="p2_mx">
							<datasetParameterExpression><![CDATA[$P{p2}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="p4_mx">
							<datasetParameterExpression><![CDATA[$P{p4}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:column width="90" uuid="8cd1e12b-a208-4040-8eb0-1647c7b1d943">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="1f1444c5-f067-41b3-80fc-087014d26f95" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[序号]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="8d73e9bd-67f7-4d1d-9e32-7cd7fbe0c02b" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[合计]]></text>
							</staticText>
						</jr:columnFooter>
						<jr:detailCell style="table" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="ca56a843-819b-4f2d-b769-24dca6a1aeb2" x="0" y="0" width="90" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$V{xh}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="7ec79e60-a45c-48d8-88c3-242d783dae24">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="896c017f-a9d1-49cd-bd9c-3b115fe3c4a2" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[*姓名]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="5072091a-09b2-4140-8a49-02f248834c7a" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[------]]></text>
							</staticText>
						</jr:columnFooter>
						<jr:detailCell style="table" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="01e6d3a7-e709-4744-9dda-eb522206cb96" x="0" y="0" width="90" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{XM}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="c9e1e0b7-1e0d-41a0-91ee-58b8b7c6e4ea">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="b94b77d3-3544-4ff5-8953-fa65ae2b4506" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[性别]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="7eccdf8d-f29e-44df-b799-c2f2789ba975" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[------]]></text>
							</staticText>
						</jr:columnFooter>
						<jr:detailCell style="table" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="423a53d6-dfd6-45ff-b9ff-9eebef4e7366" x="0" y="0" width="90" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{XBMC}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="1d75b511-db5b-4b8d-bf31-b5f584340690">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="29904f11-302e-4a3c-a412-7648d91a451d" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[*公民身份号码]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="25273e6a-2758-4382-bdb4-6981e2f19f10" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[------]]></text>
							</staticText>
						</jr:columnFooter>
						<jr:detailCell style="table" height="30" rowSpan="1">
							<textField isStretchWithOverflow="true" isBlankWhenNull="true">
								<reportElement uuid="13d3d8c0-3381-4b0f-bdc2-7459af8f68c6" x="0" y="0" width="90" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{BZHM}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="59ec21fc-b47b-483c-9ac2-24eab0a092c9">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="a778596f-99fe-48ab-aba9-7789c95e49ac" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[*缴费人员类别]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="ccd4f63b-200f-401b-9c46-bb6df59b24f4" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[------]]></text>
							</staticText>
						</jr:columnFooter>
						<jr:detailCell style="table" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="a2533d37-bad3-4614-bbb6-20c08833203b" x="0" y="0" width="90" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{JFRYLBMC}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="1716d33d-1b68-4cba-9bb0-0ee04a55309d">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="25544140-f46d-4382-a8cc-488d4e5563be" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[*申报机关养老月均工资(元)]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="table" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="e34ffc21-28a4-434a-8579-52eab60307a4" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$P{p2_mx}]]></textFieldExpression>
							</textField>
						</jr:columnFooter>
						<jr:detailCell style="table" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="aff40c72-3ae3-459a-9a83-c1eff898653f" x="0" y="0" width="90" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{JGYLGZ}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="2bb370e3-808f-469b-981f-d6eb286cd839">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="1edec7f3-c889-4496-86c1-24222f806fc7" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[*申报职工其他险种月均工资 (元)]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="table" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="24ac3fbd-e70b-4ba2-bd2b-ceb0a18bb594" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$P{p4_mx}]]></textFieldExpression>
							</textField>
						</jr:columnFooter>
						<jr:detailCell style="table" height="30" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="d8c3b308-4367-4936-a28e-012a34dd7f49" x="0" y="0" width="90" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{ZGGZ}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
		</band>
	</detail>
	<columnFooter>
		<band height="45" splitType="Stretch">
			<staticText>
				<reportElement uuid="0964982f-ce95-45f4-ba55-75053b286c29" x="99" y="16" width="452" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[      该表由单位保存备查。]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="65cc6de5-fcb1-4239-a201-50596c69cb02" x="99" y="0" width="206" height="16"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<text><![CDATA[备注：表格中带*的项目为必录项；]]></text>
			</staticText>
		</band>
	</columnFooter>
</jasperReport>
