<?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="1.607691607500001"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="27"/>
	<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>
	<subDataset name="xxbg" uuid="ea041070-3d51-4979-a86f-86ad48543c2b">
		<parameter name="bm" class="java.lang.String"/>
		<queryString>
			<![CDATA[select bm,
(case when instr(col_com,'-==')>1  then substr(col_com,1,instr(col_com,'-')-1) else col_com end
) bgxx,item_new,ITEM_NEW_TEXT
from xx_bg  xxbg ,dm_xxbg_jg jg where
xxbg.bm=$P{bm}
and XXBG.TABLE_NAME IN ('DW_XX','DW_XX_FS','M_CORPORATION')
and xxbg.table_name = jg.TAB_NAME
and xxbg.[COL_NAME] = jg.[COL_NAME]
and xxbg.[COL_NAME] !='FLAG'
order by jg.[TAB_NAME] asc ,jg.[COL_NAME] asc]]>
		</queryString>
		<field name="BM" class="java.lang.String"/>
		<field name="BGXX" class="java.lang.String"/>
		<field name="ITEM_NEW" class="java.lang.String"/>
		<field name="ITEM_NEW_TEXT" 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_where" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select dwmc,dwdm,djzh from dw_xx  where dwdm=$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="160" splitType="Stretch">
			<staticText>
				<reportElement uuid="216df7b5-f4e9-4e4b-b39b-9c43e05627d2" x="280" y="122" 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="221" y="30" width="378" height="20"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DWDM}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="2b7fe2b0-ae5d-4858-bd44-61731b5a414d" x="179" y="50" width="420" height="20"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</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="10"/>
				</textElement>
				<text><![CDATA[填报单位(公章)：]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="ae51ca1a-b3d4-4646-9c95-d6ed355ef842" x="54" y="30" width="181" height="20"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</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="10"/>
				</textElement>
				<text><![CDATA[社会保险登记号：]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement uuid="3ed0b82e-352a-44c5-90cc-dfcabc3ef14a" x="167" y="10" width="432" height="20"/>
				<textElement verticalAlignment="Middle">
					<font fontName="宋体"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{dwmc}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="50" splitType="Stretch">
			<componentElement>
				<reportElement uuid="275366d7-c9b2-412f-842d-b9595cbe0b12" key="table 1" style="table 1_TH" x="54" y="0" width="703" height="50" backcolor="#FFFFFF"/>
				<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="0ea84285-3058-4956-9aa3-62ba5019a91d">
						<datasetParameter name="bm">
							<datasetParameterExpression><![CDATA[$P{p_where}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:column width="119" uuid="2d1bcc02-7eb3-4b41-bde4-491c4e60abdd">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="11431ab4-47e2-4085-9cec-ea20d220953c" x="0" y="0" width="119" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<text><![CDATA[序号]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table" height="20" rowSpan="1">
							<textField>
								<reportElement uuid="541bcb34-de2e-4b8b-9853-d3f8aba6d7f9" x="0" y="0" width="119" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$V{xh}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="314" uuid="861bb3f9-67e1-4cb1-9bb7-7bbc782f8d9e">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="1734ffce-f453-48af-9b6f-24ed9ae916c2" x="0" y="0" width="314" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<text><![CDATA[变更项目]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table" height="20" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="843b72eb-7827-4573-b274-20bd2199df93" x="0" y="0" width="314" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="10"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{BGXX}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="292" uuid="f6361916-83e5-4e01-b13e-6f7a2c434fc1">
						<jr:columnHeader style="table" height="30" rowSpan="1">
							<staticText>
								<reportElement uuid="df17e216-afa1-4894-a5f3-703a9787e53a" x="0" y="0" width="292" height="30"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" size="10"/>
								</textElement>
								<text><![CDATA[变更后内容]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="table" height="20" rowSpan="1">
							<textField isBlankWhenNull="true">
								<reportElement uuid="19cf817c-3bb4-4ad2-af5c-abc215f7fe40" x="0" y="0" width="292" height="20"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{ITEM_NEW_TEXT}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
		</band>
	</detail>
	<pageFooter>
		<band height="75" splitType="Stretch">
			<staticText>
				<reportElement uuid="ba4cd21c-930a-4133-a951-05b37c14562f" x="607" y="55" width="195" height="20"/>
				<textElement>
					<font fontName="宋体" size="10"/>
				</textElement>
				<text><![CDATA[第       页      共         页]]></text>
			</staticText>
			<textField evaluationTime="Report">
				<reportElement uuid="e68a8daf-6e5f-42d9-a208-8fb8c7513f15" x="726" y="54" 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="629" y="54" width="31" height="20"/>
				<textElement>
					<font fontName="宋体" size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="a17ada5c-5a01-49d1-855a-25eb9a3924b3" x="54" y="0" width="719" height="54"/>
				<textElement>
					<font fontName="宋体" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[备注：请参保单位提供相关的变更证明材料。
单位负责人：                                                                     社保经（代）办机构经办人员（签章）：
单位经办人：
填报日期：        年        月      日                                           办理日期：        年        月      日
]]></text>
			</staticText>
		</band>
	</pageFooter>
</jasperReport>
