<?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="xxbg" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e580d1b5-c00c-4568-8932-321ba47a8e0c">
	<property name="ireport.zoom" value="0.9982500000000003"/>
	<property name="ireport.x" value="0"/>
	<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>
	<style name="table 1">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 2">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 3">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 3_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 3_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<subDataset name="xxbg" uuid="53375aae-04d8-4663-a21d-c46c150af2b7">
		<parameter name="p_xxbg_bzhm" class="java.lang.String">
			<defaultValueExpression><![CDATA[]]></defaultValueExpression>
		</parameter>
		<queryString>
			<![CDATA[select xh,xm,xbmcc,bzhm,ITEMMC,item_new,ITEM_NEW_TEXT from (
select '1' xh,gr.xm,(select mc from dm_mx where dmm='0201' and dm=gr.xb) xbmcc ,gr.bzhm,
( case when instr(JG.col_com,'-==')>1  then substr(JG.col_com,1,instr(JG.col_com,'-')-1) else JG.col_com end) ITEMMC,xxbg.item_new,xxbg.ITEM_NEW_TEXT
from xx_bg xxbg,gr_xx gr ,DM_XXBG_JG JG  where gr.bzhm = xxbg.bm and gr.bzhm=$P{p_xxbg_bzhm}
and xxbg.table_name in ('GR_XX', 'GR_YLZF_L', 'GR_YLZF_YLJ_L', 'M_PERSON')
AND xxbg.table_name = JG.TAB_NAME
AND XXBG.COL_NAME = JG.COL_NAME
and xxbg.[COL_NAME] !='FLAG'
union all
select '1' xh,
gr.xm,
(select mc from dm_mx where dmm='0201' and dm=gr.xb) xbmcc ,
gr.bzhm,
'机关事业补缴工资','',
xx.x
 from (
select bzhm,substr(max(a)||max(b)||max(c)||max(d),1,length(max(a)||max(b)||max(c)||max(d))-1) x from (
select grid,bzhm,
case when qrq='2014.10' then '['||qrq||'-'||zrq||'],'||jfgz||';'  else ''  end a,
case when qrq='2016.07' then '['||qrq||'-'||zrq||'],'||jfgz||';'  else ''   end b,
case when qrq='2017.07' then '['||qrq||'-'||zrq||'],'||jfgz||';'  else ''  end c,
case when qrq='2018.07' then '['||qrq||'-'||zrq||'],'||jfgz||';'  else '' end d from DM_JGGR_BJJFGZ where bzhm = $P{p_xxbg_bzhm}
and grid is not null and (blsj = '' or blsj is null )  )
group by bzhm ) xx,gr_xx gr
where gr.bzhm = xx.bzhm and xx.bzhm=$P{p_xxbg_bzhm})
order by [ITEMMC] asc]]>
		</queryString>
		<field name="XH" class="java.lang.String"/>
		<field name="XM" class="java.lang.String"/>
		<field name="XBMCC" class="java.lang.String"/>
		<field name="BZHM" class="java.lang.String"/>
		<field name="ITEMMC" class="java.lang.String"/>
		<field name="ITEM_NEW" class="java.lang.String"/>
		<field name="ITEM_NEW_TEXT" class="java.lang.String"/>
		<variable name="vxh" class="java.lang.Integer" calculation="Count">
			<variableExpression><![CDATA[$V{vxh}.valueOf(1)]]></variableExpression>
			<initialValueExpression><![CDATA[1]]></initialValueExpression>
		</variable>
	</subDataset>
	<parameter name="p_where" class="java.lang.String">
		<defaultValueExpression><![CDATA[110109196212142111]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select dwmc,dwdm,djzh from dw_xx  where dwdm=(SELECT DWDM FROM GR_XX WHERE BZHM =$P{p_where})]]>
	</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>
	<pageHeader>
		<band height="165" splitType="Stretch">
			<staticText>
				<reportElement uuid="216df7b5-f4e9-4e4b-b39b-9c43e05627d2" x="251" y="127" width="330" height="38"/>
				<textElement>
					<font fontName="宋体" size="20"/>
				</textElement>
				<text><![CDATA[北京市社会保险个人信息变更登记表]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="70" splitType="Stretch">
			<textField>
				<reportElement uuid="514c1058-383f-456b-af20-5872529b56ca" x="257" y="30" width="379" height="20"/>
				<textElement>
					<font fontName="宋体" size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DWDM}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="2b7fe2b0-ae5d-4858-bd44-61731b5a414d" x="179" y="50" width="457" height="20"/>
				<textElement>
					<font fontName="宋体" size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DJZH}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="5968ebd5-6c5b-43aa-9d5b-dead51c75e33" x="54" y="10" width="124" height="20"/>
				<textElement>
					<font fontName="宋体" size="12"/>
				</textElement>
				<text><![CDATA[填报单位(公章)：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="ae51ca1a-b3d4-4646-9c95-d6ed355ef842" x="54" y="30" width="208" height="20"/>
				<textElement>
					<font fontName="宋体" size="12"/>
				</textElement>
				<text><![CDATA[统一社会信用代码（组织机构代码）：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="d0ce1911-2b9d-496a-8422-3f3f5f235c94" x="54" y="50" width="124" height="20"/>
				<textElement>
					<font fontName="宋体" size="12"/>
				</textElement>
				<text><![CDATA[社会保险登记号：]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement uuid="adb63ca5-5994-4f0e-9ed3-d3db6e221db2" x="154" y="12" width="485" height="20"/>
				<textElement verticalAlignment="Top">
					<font fontName="宋体" size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{dwmc}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="50" splitType="Stretch">
			<componentElement>
				<reportElement uuid="f904f3ed-ce6d-4d83-97b4-c85ac4723ff5" key="table 3" x="54" y="0" width="719" 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="xxbg" uuid="b7976b7f-2825-4f5e-a76f-4b702628024d">
						<datasetParameter name="p_xxbg_bzhm">
							<datasetParameterExpression><![CDATA[$P{p_where}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:column width="45" uuid="77867652-3745-4f7c-a88c-7ad0606ef8ef">
						<jr:columnHeader style="table 3_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="76d4c899-14ad-4f74-90e4-2cf029dba713" x="0" y="0" width="45" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="12"/>
								</textElement>
								<text><![CDATA[序号]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table 3_TD" height="20" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="d9d11176-2b08-440e-8444-0685a21df359" x="0" y="0" width="45" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$V{vxh}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="e63bb5f6-0560-4e1f-9458-cc3d99962418">
						<jr:columnHeader style="table 3_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="26e43d98-48b4-4d9c-8040-69eabcb14029" x="0" y="0" width="90" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="12"/>
								</textElement>
								<text><![CDATA[姓名]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table 3_TD" height="20" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="3710b690-895d-493d-91f9-b536881a91d4" x="0" y="0" width="90" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{XM}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="28" uuid="4c5b6efc-0837-48d2-a379-ac774fbf2569">
						<jr:columnHeader style="table 3_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="86c8ff1f-f06a-4e3c-a3cf-0ecff5498bd5" x="0" y="0" width="28" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="12"/>
								</textElement>
								<text><![CDATA[性别]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table 3_TD" height="20" rowSpan="1">
							<textField>
								<reportElement uuid="9be2bb22-4570-4351-b5ce-90024e2431ad" x="0" y="0" width="28" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{XBMCC}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="131" uuid="217c1b0a-e550-48de-96cb-78eb024b2808">
						<jr:columnHeader style="table 3_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="4d3fa308-0746-4601-bc6f-249d94ba8336" x="0" y="0" width="131" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="12"/>
								</textElement>
								<text><![CDATA[公民身份号码]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table 3_TD" height="20" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="2a5b4c12-4dfc-45a2-8bd5-ce92dee19a89" x="0" y="0" width="131" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{BZHM}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="209" uuid="d247a80c-480e-4a0d-a018-661f3bdb72a0">
						<jr:columnHeader style="table 3_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="a3a6a8ba-abc4-41fb-8c95-d2c19d488c68" x="0" y="0" width="209" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="12"/>
								</textElement>
								<text><![CDATA[变更项目]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table 3_TD" height="20" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="184c9e22-b1b4-40b1-9ef1-41b8a8925722" x="0" y="0" width="209" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="10"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{ITEMMC}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="241" uuid="c6497431-d597-4e04-ac74-468199c28cda">
						<jr:columnHeader style="table 3_TD" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="3e606065-d10f-4b04-8c8f-cf2fd6e75283" x="0" y="0" width="241" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="12"/>
								</textElement>
								<text><![CDATA[变更后内容]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table 3_TD" height="20" rowSpan="1">
							<textField isStretchWithOverflow="true" isBlankWhenNull="true">
								<reportElement uuid="b45cdd8b-d7a8-464c-9af7-95cdbb7169bc" x="0" y="0" width="241" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{ITEM_NEW_TEXT}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
		</band>
	</detail>
	<columnFooter>
		<band height="65" splitType="Stretch">
			<staticText>
				<reportElement uuid="a17ada5c-5a01-49d1-855a-25eb9a3924b3" x="54" y="0" width="719" height="65"/>
				<textElement>
					<font fontName="宋体" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[备注：请参保单位提供相关的变更证明材料。
单位负责人：                                           社保经（代）办机构经办人员（签章）：
单位经办人：
填报日期：        年        月      日                  办理日期：        年        月      日
]]></text>
			</staticText>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="34" splitType="Stretch">
			<staticText>
				<reportElement uuid="ba4cd21c-930a-4133-a951-05b37c14562f" x="578" y="14" width="195" height="20"/>
				<textElement>
					<font fontName="宋体" size="12"/>
				</textElement>
				<text><![CDATA[第       页      共         页]]></text>
			</staticText>
			<textField evaluationTime="Report">
				<reportElement uuid="e68a8daf-6e5f-42d9-a208-8fb8c7513f15" x="714" y="13" width="36" height="20"/>
				<textElement>
					<font fontName="宋体" size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="0c3febb8-e3df-4ce3-887d-8b025ae81bb2" x="605" y="13" width="31" height="20"/>
				<textElement>
					<font fontName="宋体" size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>
