<!-- Created with Jaspersoft Studio version 7.0.3.final using JasperReports Library version 7.0.3-41034ca841d452f3305ba55b9042260aaa1ab5dd  -->
<jasperReport name="Registered Users" language="java" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenResourceMissingType="Key" uuid="3e7741d2-c713-4336-a492-4803b0b71cb0">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<import>net.sf.jasperreports.engine.*</import>
	<import>java.util.*</import>
	<import>net.sf.jasperreports.engine.data.*</import>
	<query language="sql"><![CDATA[import com.openkm.db.*;
import com.openkm.db.service.AuthSrv;
import com.openkm.db.bean.*;
import com.openkm.util.ContextWrapper;
import org.springframework.web.context.WebApplicationContext;

WebApplicationContext cc = (WebApplicationContext) ContextWrapper.getContext();
AuthSrv authSrv = cc.getBean(AuthSrv.class);
List al = new ArrayList();
for (DbUser user : authSrv.findAllUsers(false)) {
  Map usr = new HashMap();
  usr.put("id", user.getId());
  usr.put("name", user.getName());
  usr.put("email", user.getEmail());
  usr.put("roles", user.getRoles().toString());
  al.add(usr);
}

return al]]></query>
	<field name="name" class="java.lang.String">
		<description><![CDATA[name]]></description>
	</field>
	<field name="email" class="java.lang.String">
		<description><![CDATA[email]]></description>
	</field>
	<field name="id" class="java.lang.String">
		<description><![CDATA[id]]></description>
	</field>
	<background splitType="Stretch"/>
	<title height="44" splitType="Stretch">
		<element kind="image" uuid="5b066c43-46dc-406d-bc79-7ebad3369898" key="image-1" x="374" y="0" width="150" height="35">
			<expression><![CDATA["http://localhost:8080/openkm/logo/report"]]></expression>
		</element>
		<element kind="textField" uuid="314fc921-63f7-4279-9869-e5c0ce085efc" key="textField-13" x="0" y="0" width="65" height="10" forecolor="#010101" fontName="Arial" fontSize="8.0" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" pattern="yyyy/MM/dd" blankWhenNull="false" underline="false" bold="true" vTextAlign="Middle">
			<expression><![CDATA[new Date()]]></expression>
			<box>
				<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="0.0" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
		</element>
		<element kind="textField" uuid="a66138fb-97a8-412c-b039-2b3e9b2a3478" key="textField-14" x="0" y="10" width="65" height="10" forecolor="#010101" fontName="Arial" fontSize="8.0" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" pattern="h.mm.ss a" blankWhenNull="false" underline="false" bold="true" vTextAlign="Middle">
			<expression><![CDATA[new Date()]]></expression>
			<box>
				<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="0.0" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
		</element>
		<element kind="line" uuid="a4710a41-c915-4de2-968d-24906a84e916" key="line-3" x="-15" y="42" width="562" height="1" forecolor="#010101"/>
		<element kind="staticText" uuid="c924f820-f9a6-4549-8842-e3820414ebb1" x="77" y="0" width="297" height="44" fontName="Arial" fontSize="22.0" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" bold="true" pdfEmbedded="false" hTextAlign="Center" vTextAlign="Middle">
			<text><![CDATA[Registered Users]]></text>
		</element>
	</title>
	<pageHeader splitType="Stretch"/>
	<columnHeader height="30" splitType="Stretch">
		<element kind="line" uuid="200f8f8c-272e-457b-b258-f02c8b11b408" key="line-4" x="0" y="28" width="140" height="1" forecolor="#010101"/>
		<element kind="line" uuid="825466a3-8839-45e8-bed3-2b36a85773cd" key="line-5" x="145" y="28" width="390" height="1" forecolor="#010101"/>
		<element kind="staticText" uuid="7b9156a7-0395-48ed-ace3-00a6342033de" x="0" y="12" width="127" height="14" fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" bold="true" pdfEmbedded="false">
			<text><![CDATA[Id]]></text>
		</element>
		<element kind="staticText" uuid="92f83440-d7e0-4fae-8386-4962706b542a" x="155" y="12" width="100" height="14" fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" bold="true" pdfEmbedded="false">
			<text><![CDATA[Name]]></text>
		</element>
		<element kind="staticText" uuid="91def653-f477-49e3-93d5-803f3460faf4" x="330" y="11" width="100" height="14" fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" bold="true" pdfEmbedded="false">
			<text><![CDATA[Mail]]></text>
		</element>
	</columnHeader>
	<detail>
		<band height="18" splitType="Stretch">
			<element kind="textField" uuid="62d1949d-37e6-42f3-88e9-b7a0d68bc1b6" key="textField" x="329" y="0" width="206" height="18" fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" blankWhenNull="false">
				<expression><![CDATA[$F{email}]]></expression>
			</element>
			<element kind="textField" uuid="f50f5001-3dcb-4732-a9a7-279007e249c4" key="textField" x="0" y="0" width="127" height="18" fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" blankWhenNull="false">
				<expression><![CDATA[$F{id}]]></expression>
			</element>
			<element kind="textField" uuid="e12114a8-c89c-4b20-a68d-9c17420e7819" key="textField" x="155" y="0" width="162" height="18" fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" blankWhenNull="false">
				<expression><![CDATA[$F{name}]]></expression>
			</element>
		</band>
	</detail>
	<columnFooter splitType="Stretch"/>
	<pageFooter height="30" splitType="Stretch">
		<element kind="line" uuid="de824263-ff19-4137-a709-7c42c1bc5182" key="line-2" x="-15" y="4" width="567" height="1" forecolor="#010101" backcolor="#FFFFFF"/>
	</pageFooter>
	<summary splitType="Stretch"/>
</jasperReport>
