<?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="UserList" language="groovy" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="fbcef7db-af89-4fef-935a-6e5388ed1223">
	<property name="ireport.zoom" value="1.2100000000000029"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="isLocked" class="java.lang.String">
		<defaultValueExpression><![CDATA['N']]></defaultValueExpression>
	</parameter>
	<parameter name="roleId" class="java.lang.String">
		<defaultValueExpression><![CDATA[1]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select fmx_user.user_id,
fmx_user.user_name,
fmx_user.account,
nvl(fmx_user.user_emp_no,'  ') user_emp_no,
nvl(fmx_user.central_account,'  ') central_account,
case when fmx_user.is_locked='Y' then '是' else '否' end is_locked
from fmx_user,fmx_role,fmx_role_user
where fmx_user.user_id=fmx_role_user.user_id
and fmx_role.role_id=fmx_role_user.role_id
and (case when $P{isLocked} is not null and is_locked =$P{isLocked} then 1 when $P{isLocked} is null then 1 else 0 end )=1
and (case when $P{roleId} is not null and fmx_role.role_id =$P{roleId} then 1 when $P{roleId} is null then 1 else 0 end )=1
order by fmx_user.user_id]]>
	</queryString>
	<field name="USER_ID" class="java.math.BigDecimal"/>
	<field name="USER_NAME" class="java.lang.String"/>
	<field name="ACCOUNT" class="java.lang.String"/>
	<field name="USER_EMP_NO" class="java.lang.String"/>
	<field name="CENTRAL_ACCOUNT" class="java.lang.String"/>
	<field name="IS_LOCKED" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="46" splitType="Stretch">
			<staticText>
				<reportElement key="uTitle" x="0" y="3" width="555" height="41" uuid="de505895-1848-46a0-abd0-92eb18cbcabb"/>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="24" isBold="true" pdfFontName="stsong.ttf" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[用户信息]]></text>
			</staticText>
		</band>
	</title>
	<columnHeader>
		<band height="21" splitType="Stretch">
			<staticText>
				<reportElement x="176" y="1" width="96" height="20" uuid="0d9d8f70-42f3-484c-8272-de248e42d27e"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[工号]]></text>
			</staticText>
			<staticText>
				<reportElement x="76" y="1" width="100" height="20" uuid="bdf42190-6484-4a97-925f-a37c9dce7805"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[用户名称]]></text>
			</staticText>
			<staticText>
				<reportElement x="1" y="1" width="75" height="20" uuid="8b790b36-d947-418f-bfac-0a0affbca203"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[用户ID]]></text>
			</staticText>
			<staticText>
				<reportElement x="272" y="1" width="100" height="20" uuid="a3678796-7bb6-4643-9249-3bc80d1a61b7"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[登录账号]]></text>
			</staticText>
			<staticText>
				<reportElement x="372" y="1" width="100" height="20" uuid="861cf807-0af7-4b4d-9547-967a7c63a8c2"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[中心账号]]></text>
			</staticText>
			<staticText>
				<reportElement x="472" y="1" width="83" height="20" uuid="9084995b-ac6a-4f2c-909e-60e86814bff6"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[是否锁定]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<textField>
				<reportElement x="1" y="0" width="75" height="20" uuid="37750a03-2aaa-438b-8210-85a311812ea6"/>
				<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" markup="none">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{USER_ID}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="272" y="0" width="100" height="20" uuid="56d75fcb-29d2-4ae3-a33f-2793180fcc8f"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ACCOUNT}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="372" y="0" width="100" height="20" uuid="fecd8851-ffaa-4db0-ab25-da1cd198428a"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CENTRAL_ACCOUNT}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="76" y="0" width="100" height="20" uuid="b0845370-413a-4b9a-8507-cfc5adad58e9"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{USER_NAME}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="176" y="0" width="96" height="20" uuid="c42b3699-3090-4f7e-a365-c483211bec59"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{USER_EMP_NO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="472" y="0" width="83" height="20" uuid="ff77a320-127d-4ab8-9325-3ea09eb0f977"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center">
					<font fontName="微软雅黑" size="12" pdfFontName="STSONG.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{IS_LOCKED}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
