hongtaiyang/runtime/ctrlhome/server/extzip/HR/SOC/ReportTable/BenefitReportData.r1-print

<DocRoot>
	<Parameters />
	<DataSources>
		<Reference name="PersonDetailQuery" alias.zh_CN="人员账户明细信息" alias="#1" desc.zh_CN="人员账户明细信息" desc="#1" info="::/com/kingdee/eas/hr/benefit/app/PersonDetailQuery.bos-query" />
		<Reference name="benefitData" alias.zh_CN="社保数据" alias.en="" alias.zh_TW="社保數據" alias="#1" desc.zh_TW="社保數據" desc.en="" desc.zh_CN="社保数据" desc="#1" info="benefitData.bos-query">
			<Params>
				<Param name="perNumber">
					<Associate dataSourceID="PersonDetailQuery">number</Associate>
				</Param>
			</Params>
		</Reference>
	</DataSources>
	<Styles version="1.0">
		<Style id="3">
			<Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
			<Borders>
				<Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="diagonalleft" lineStyle="NullLine" />
				<Border position="diagonalright" lineStyle="NullLine" />
			</Borders>
			<Interior color="#ffffff00" pattern="None" patternColor="#000000" />
			<Alignment horizontal="center" vertical="middle" wrapText="true" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
			<Protection hidden="false" locked="false" />
		</Style>
		<Style id="7">
			<Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
			<Borders>
				<Border position="left" lineStyle="NullLine" />
				<Border position="top" lineStyle="NullLine" />
				<Border position="right" lineStyle="NullLine" />
				<Border position="bottom" lineStyle="NullLine" />
				<Border position="diagonalleft" lineStyle="NullLine" />
				<Border position="diagonalright" lineStyle="NullLine" />
			</Borders>
			<Interior color="#ffffff00" pattern="None" patternColor="#000000" />
			<Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
			<Protection hidden="false" locked="false" />
			<NumberFormat>G/通用格式</NumberFormat>
		</Style>
		<Style id="2">
			<Alignment horizontal="left" />
		</Style>
		<Style id="0">
			<Font size="16" />
		</Style>
		<Style id="14">
			<Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
			<Borders>
				<Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="diagonalleft" lineStyle="NullLine" />
				<Border position="diagonalright" lineStyle="NullLine" />
			</Borders>
			<Interior color="#ffffff00" pattern="None" patternColor="#000000" />
			<Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
			<Protection hidden="false" locked="false" />
			<NumberFormat>0.00;-0.00;"0"</NumberFormat>
		</Style>
		<Style id="1" />
		<Style id="6">
			<NumberFormat>G/通用格式</NumberFormat>
		</Style>
		<Style id="10">
			<Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
			<Borders>
				<Border position="left" lineStyle="NullLine" />
				<Border position="top" lineStyle="NullLine" />
				<Border position="right" lineStyle="NullLine" />
				<Border position="bottom" lineStyle="NullLine" />
				<Border position="diagonalleft" lineStyle="NullLine" />
				<Border position="diagonalright" lineStyle="NullLine" />
			</Borders>
			<Interior color="#ffffff00" pattern="None" patternColor="#000000" />
			<Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
			<Protection hidden="false" locked="false" />
			<NumberFormat>0.00;-0.00;"0"</NumberFormat>
		</Style>
		<Style id="5">
			<NumberFormat>g/通用格式</NumberFormat>
		</Style>
		<Style id="13">
			<Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
			<Borders>
				<Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="diagonalleft" lineStyle="NullLine" />
				<Border position="diagonalright" lineStyle="NullLine" />
			</Borders>
			<Interior color="#ffffff00" pattern="None" patternColor="#000000" />
			<Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
			<Protection hidden="false" locked="false" />
			<NumberFormat>0.00;-0.00;"0"</NumberFormat>
		</Style>
		<Style id="9">
			<Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
			<Borders>
				<Border position="left" lineStyle="NullLine" />
				<Border position="top" lineStyle="NullLine" />
				<Border position="right" lineStyle="NullLine" />
				<Border position="bottom" lineStyle="NullLine" />
				<Border position="diagonalleft" lineStyle="NullLine" />
				<Border position="diagonalright" lineStyle="NullLine" />
			</Borders>
			<Interior color="#ffffff00" pattern="None" patternColor="#000000" />
			<Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
			<Protection hidden="false" locked="false" />
			<NumberFormat>0.00;-0.00;"0"</NumberFormat>
		</Style>
		<Style id="11">
			<Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
			<Borders>
				<Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="diagonalleft" lineStyle="NullLine" />
				<Border position="diagonalright" lineStyle="NullLine" />
			</Borders>
			<Interior color="#ffffff00" pattern="None" patternColor="#000000" />
			<Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
			<Protection hidden="false" locked="false" />
			<NumberFormat>g/通用格式</NumberFormat>
		</Style>
		<Style id="4">
			<Borders>
				<Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
			</Borders>
			<Alignment wrapText="true" />
		</Style>
		<Style id="8">
			<Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
			<Borders>
				<Border position="left" lineStyle="NullLine" />
				<Border position="top" lineStyle="NullLine" />
				<Border position="right" lineStyle="NullLine" />
				<Border position="bottom" lineStyle="NullLine" />
				<Border position="diagonalleft" lineStyle="NullLine" />
				<Border position="diagonalright" lineStyle="NullLine" />
			</Borders>
			<Interior color="#ffffff00" pattern="None" patternColor="#000000" />
			<Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
			<Protection hidden="false" locked="false" />
			<NumberFormat>0.00;-0.00;"0"</NumberFormat>
		</Style>
		<Style id="12">
			<Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
			<Borders>
				<Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
				<Border position="diagonalleft" lineStyle="NullLine" />
				<Border position="diagonalright" lineStyle="NullLine" />
			</Borders>
			<Interior color="#ffffff00" pattern="None" patternColor="#000000" />
			<Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
			<Protection hidden="false" locked="false" />
			<NumberFormat>g/通用格式</NumberFormat>
		</Style>
	</Styles>
	<Report type="r1-print" version="6.3.0">
		<Page id="page1" width="1720" height="2470">
			<Sub-objects>
				<PrintLayoutGrid id="layoutGrid1" x="7" y="3">
					<Data />
					<Col width="1701" id="column1" />
					<TR height="141" id="row1">
						<TD id="cell1" styleId="0">
							<Value type="text"><![CDATA[员工社保信息]]></Value>
						</TD>
					</TR>
					<TR height="400" id="row2" styleId="1">
						<TD id="cell4" styleId="1">
							<Sub-objects>
								<PrintLayoutGrid id="layoutGrid2" x="0" y="0" horizontalFill="true" verticalFill="true">
									<Data />
									<Col width="258" id="column2" styleId="1" />
									<Col width="308" id="column7" styleId="1" />
									<Col width="259" id="column6" styleId="1" />
									<Col width="308" id="column5" styleId="1" />
									<Col width="258" id="column3" styleId="1" />
									<Col width="308" id="column4" styleId="1" />
									<TR height="99" id="row4" styleId="1">
										<TD id="cell2" styleId="2">
											<Value type="text"><![CDATA[员工编码：]]></Value>
										</TD>
										<TD id="cell19" styleId="2">
											<Value type="field" dataSource="PersonDetailQuery">number</Value>
										</TD>
										<TD id="cell16" styleId="2">
											<Value type="text"><![CDATA[姓名：]]></Value>
										</TD>
										<TD id="cell13" styleId="2">
											<Value type="field" dataSource="PersonDetailQuery">name</Value>
										</TD>
										<TD id="cell3" styleId="2">
											<Value type="text"><![CDATA[性别：]]></Value>
										</TD>
										<TD id="cell5" styleId="2">
											<Script><![CDATA[if(toStr(getFieldValue("gender")) == "1")
{
	setValue("男");
}
else if (toStr(getFieldValue("gender")) == "2")
{
	setValue("女");
}
else 
{
	setValue(null);
}]]></Script>
											<Value type="field" dataSource="PersonDetailQuery">gender</Value>
										</TD>
									</TR>
									<TR height="100" id="row5" styleId="1">
										<TD id="cell6" styleId="2">
											<Value type="text"><![CDATA[身份证号码：]]></Value>
										</TD>
										<TD id="cell20" styleId="2">
											<Value type="field" dataSource="PersonDetailQuery">idCardNO</Value>
										</TD>
										<TD id="cell17" styleId="2">
											<Value type="text"><![CDATA[职位：]]></Value>
										</TD>
										<TD id="cell14" styleId="2">
											<Value type="field" dataSource="PersonDetailQuery">position.name</Value>
										</TD>
										<TD id="cell8" styleId="2">
											<Value type="text"><![CDATA[所属部门：]]></Value>
										</TD>
										<TD id="cell9" styleId="2">
											<Value type="field" dataSource="PersonDetailQuery">admin.name</Value>
										</TD>
									</TR>
									<TR height="100" id="row6" styleId="1">
										<TD id="cell10" styleId="2">
											<Value type="text"><![CDATA[账户类型：]]></Value>
										</TD>
										<TD id="cell21" styleId="2">
											<Value type="field" dataSource="PersonDetailQuery">accountType.name</Value>
										</TD>
										<TD id="cell18" styleId="2">
											<Value type="text"><![CDATA[账号：]]></Value>
										</TD>
										<TD id="cell15" styleId="2">
											<Value type="field" dataSource="PersonDetailQuery">accountDetail.accounts</Value>
										</TD>
										<TD id="cell11" styleId="2">
											<Value type="text"><![CDATA[办理日期：]]></Value>
										</TD>
										<TD id="cell12" styleId="2">
											<Value type="field" dataSource="PersonDetailQuery">accountDetail.transactDate</Value>
										</TD>
									</TR>
									<TR height="99" id="row7" styleId="1">
										<TD id="cell22" styleId="2">
											<Value type="text"><![CDATA[建立日期：]]></Value>
										</TD>
										<TD id="cell23" styleId="2">
											<Value type="field" dataSource="PersonDetailQuery">accountDetail.createDate</Value>
										</TD>
										<TD id="cell24" styleId="2">
											<Value type="text"><![CDATA[停缴日期：]]></Value>
										</TD>
										<TD id="cell25" styleId="2">
											<Value type="field" dataSource="PersonDetailQuery">accountDetail.stopDate</Value>
										</TD>
										<TD id="cell26" styleId="2" />
										<TD id="cell27" styleId="2" />
									</TR>
								</PrintLayoutGrid>
							</Sub-objects>
						</TD>
					</TR>
					<TR height="66" id="row3">
						<TD id="cell7" styleId="1" />
					</TR>
					<TR height="300" id="row9" styleId="1">
						<TD id="cell29" styleId="1">
							<Sub-objects>
								<PrintLayoutGrid id="layoutGrid4" x="0" y="0" horizontalFill="true" verticalFill="true">
									<Data />
									<Col width="188" id="column26" />
									<Col width="188" id="column10" styleId="1" />
									<Col width="189" id="column11" styleId="1" />
									<Col width="189" id="column12" styleId="1" />
									<Col width="189" id="column18" styleId="1" />
									<Col width="189" id="column17" styleId="1" />
									<Col width="189" id="column16" styleId="1" />
									<Col width="189" id="column15" styleId="1" />
									<Col width="189" id="column14" styleId="1" />
									<TR height="149" id="row11">
										<TD id="cell38" styleId="3">
											<Value type="text"><![CDATA[社保期间]]></Value>
										</TD>
										<TD id="cell32" styleId="4">
											<Value type="text"><![CDATA[险种名称]]></Value>
										</TD>
										<TD id="cell33" styleId="4">
											<Value type="text"><![CDATA[保险号]]></Value>
										</TD>
										<TD id="cell34" styleId="4">
											<Value type="text"><![CDATA[基数]]></Value>
										</TD>
										<TD id="cell56" styleId="4">
											<Value type="text"><![CDATA[个人当月缴纳]]></Value>
										</TD>
										<TD id="cell53" styleId="4">
											<Value type="text"><![CDATA[公司当月缴纳]]></Value>
										</TD>
										<TD id="cell50" styleId="4">
											<Value type="text"><![CDATA[个人缴纳入账户余额金额]]></Value>
										</TD>
										<TD id="cell47" styleId="4">
											<Value type="text"><![CDATA[公司缴纳入账户余额金额]]></Value>
										</TD>
										<TD id="cell44" styleId="4">
											<Value type="text"><![CDATA[账户余额
]]></Value>
										</TD>
									</TR>
									<TR height="149" id="row12">
										<TD id="cell39" styleId="1">
											<Sub-objects>
												<PrintDataGrid id="dataGrid1" styleId="1" x="0" y="8" horizontalFill="true">
													<Data dataSource="benefitData" />
													<Col width="187" id="column13" styleId="5" />
													<Col width="187" id="column19" styleId="6" />
													<Col width="189" id="column20" styleId="7" />
													<Col width="189" id="column21" styleId="8" />
													<Col width="189" id="column22" styleId="9" />
													<Col width="189" id="column23" styleId="10" />
													<Col width="189" id="column24" styleId="10" />
													<Col width="189" id="column25" styleId="10" />
													<Col width="189" id="column27" styleId="10" />
													<TR height="46" type="detail" repeatTimes="10" id="row14" styleId="1">
														<TD id="cell43" styleId="11">
															<Value type="field">cmpPeriod</Value>
														</TD>
														<TD id="cell46" styleId="12">
															<Value type="field">benefitName</Value>
														</TD>
														<TD id="cell49" styleId="12">
															<Value type="field">benefitNum</Value>
														</TD>
														<TD id="cell60" styleId="13">
															<Value type="field">Base_insu</Value>
														</TD>
														<TD id="cell63" styleId="14">
															<Value type="field">Emp_insu</Value>
														</TD>
														<TD id="cell66" styleId="14">
															<Value type="field">Com_insu</Value>
														</TD>
														<TD id="cell69" styleId="14">
															<Value type="field">Emp_Sum</Value>
														</TD>
														<TD id="cell72" styleId="14">
															<Value type="field">Com_Sum</Value>
														</TD>
														<TD id="cell75" styleId="14">
															<Value type="field">Balance</Value>
														</TD>
													</TR>
												</PrintDataGrid>
											</Sub-objects>
										</TD>
										<TD id="cell35" styleId="1" />
										<TD id="cell36" styleId="1" />
										<TD id="cell37" styleId="1" />
										<TD id="cell57" styleId="1" />
										<TD id="cell54" styleId="1" />
										<TD id="cell51" styleId="1" />
										<TD id="cell48" styleId="1" />
										<TD id="cell45" styleId="1" />
									</TR>
									<MergeBlocks>
										<Block left="0" right="8" top="1" bottom="1" />
									</MergeBlocks>
								</PrintLayoutGrid>
							</Sub-objects>
						</TD>
					</TR>
				</PrintLayoutGrid>
			</Sub-objects>
		</Page>
	</Report>
	<PrintInfo>
		<PaperSetup>
			<Paper>iso-a4</Paper>
			<Orientation>PORTRAIT</Orientation>
			<PageMargin left="190" right="190" top="250" bottom="250" />
			<Header height="150" margin="100" />
			<Footer height="150" margin="100" />
		</PaperSetup>
		<PrinterSetup>
			<DynamicPaper>false</DynamicPaper>
			<EconomizePaper isVerEconomizePaper="false" verSpace="0" isHorEconomizePaper="false" horSpace="0" />
		</PrinterSetup>
		<PreviewSetup>
			<BackgroundPicture>false</BackgroundPicture>
		</PreviewSetup>
	</PrintInfo>
</DocRoot>