Subversion Repositories Integrator Subversion

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
1 espaco 1 
<?xml version="1.0" encoding="UTF-8"?>
2 
<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="relatorio" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="85d4a540-608e-4934-8f57-57cec53afb74">
3 
	<property name="ireport.zoom" value="1.0"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="0"/>
6 
	<parameter name="IMAGEM_DIR" class="java.lang.String">
7 
		<defaultValueExpression><![CDATA["C:\\"]]></defaultValueExpression>
8 
	</parameter>
9 
	<parameter name="SEQ_PESSOA_FISICA" class="java.lang.Long">
10 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
11 
	</parameter>
12 
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
13 
		<defaultValueExpression><![CDATA["C:\\Repositorio\\DESENVOLVIMENTO\\SESAU\\JAVA\\Repositorio\\rhcapacitacao\\FONTES\\IMPLEMENTACAO\\DESENVOLVIMENTO\\scs\\scs-core\\src\\main\\resources\\relatorios\\"]]></defaultValueExpression>
14 
	</parameter>
15 
	<parameter name="ANO" class="java.lang.Integer">
16 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
17 
	</parameter>
18 
	<parameter name="NOM_USUARIO" class="java.lang.String">
19 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
20 
	</parameter>
21 
	<parameter name="CPF_USUARIO" class="java.lang.String">
22 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
23 
	</parameter>
24 
	<queryString>
25 
		<![CDATA[SELECT
26 
pf.seq_pessoa, pf.nom_pessoa, pf.num_documento
27 
FROM sc_scg.vw_pessoa_fisica pf
28 
WHERE pf.seq_pessoa = $P{SEQ_PESSOA_FISICA}
29 
AND EXISTS
30 
(
31 
   SELECT
32 
   tp.seq_pessoa_participante
33 
   FROM sc_scs.scs_turma_participante tp
34 
   WHERE tp.seq_pessoa_participante = pf.seq_pessoa
35 
)]]>
36 
	</queryString>
37 
	<field name="seq_pessoa" class="java.lang.Long"/>
38 
	<field name="nom_pessoa" class="java.lang.String"/>
39 
	<field name="num_documento" class="java.lang.String"/>
40 
	<pageHeader>
41 
		<band height="116">
42 
			<staticText>
43 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="48" width="555" height="36"/>
44 
				<textElement textAlignment="Center" verticalAlignment="Top">
45 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
46 
				</textElement>
47 
				<text><![CDATA[Secretaria de Estado da Saúde
48 
Coordenadoria Setorial de Gestão e Desenvolvimento de Pessoas
49 
Gerência de Desenvolvimento e Educação de Pessoas
50 
]]></text>
51 
			</staticText>
52 
			<image scaleImage="RealSize" hAlign="Center" vAlign="Middle" onErrorType="Icon">
53 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="258" y="0" width="33" height="36"/>
54 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.png"]]></imageExpression>
55 
			</image>
56 
			<staticText>
57 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="37" width="555" height="12"/>
58 
				<textElement textAlignment="Center" verticalAlignment="Top">
59 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
60 
				</textElement>
61 
				<text><![CDATA[Estado de Alagoas]]></text>
62 
			</staticText>
63 
			<staticText>
64 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="92" width="555" height="12"/>
65 
				<textElement textAlignment="Center" verticalAlignment="Middle">
66 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
67 
				</textElement>
68 
				<text><![CDATA[Relatório de Capacitação por Participante]]></text>
69 
			</staticText>
70 
		</band>
71 
	</pageHeader>
72 
	<columnHeader>
73 
		<band height="60">
74 
			<elementGroup>
75 
				<rectangle>
76 
					<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="555" height="20" backcolor="#CCCCCC"/>
77 
				</rectangle>
78 
				<staticText>
79 
					<reportElement uuid="5b3ddd59-b852-459a-a68d-6529ce9bb9a6" x="0" y="0" width="555" height="20"/>
80 
					<textElement textAlignment="Center" verticalAlignment="Middle">
81 
						<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
82 
					</textElement>
83 
					<text><![CDATA[PARTICIPANTE]]></text>
84 
				</staticText>
85 
				<rectangle>
86 
					<reportElement uuid="19f89383-f30c-43a6-9677-4bcceba181d8" x="0" y="20" width="280" height="20" backcolor="#CCCCCC"/>
87 
				</rectangle>
88 
				<rectangle>
89 
					<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="280" y="20" width="275" height="20" backcolor="#CCCCCC"/>
90 
				</rectangle>
91 
				<staticText>
92 
					<reportElement uuid="718efbbe-2056-445a-ae3e-45fe27bd0f07" x="0" y="20" width="280" height="20"/>
93 
					<textElement textAlignment="Center" verticalAlignment="Middle">
94 
						<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
95 
					</textElement>
96 
					<text><![CDATA[NOME]]></text>
97 
				</staticText>
98 
				<staticText>
99 
					<reportElement uuid="26da0dfe-0a8e-49e4-ae89-92fe241d1733" x="280" y="20" width="275" height="20"/>
100 
					<textElement textAlignment="Center" verticalAlignment="Middle">
101 
						<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
102 
					</textElement>
103 
					<text><![CDATA[CPF]]></text>
104 
				</staticText>
105 
				<rectangle>
106 
					<reportElement uuid="c3eedd42-a096-4b5c-8c9c-ef04da5f8b58" x="0" y="40" width="280" height="20"/>
107 
				</rectangle>
108 
				<rectangle>
109 
					<reportElement uuid="b5955532-652d-4a7a-881a-29fa82c7b637" x="280" y="40" width="275" height="20"/>
110 
				</rectangle>
111 
				<textField>
112 
					<reportElement uuid="a07939dd-ee07-4456-ad06-b7d04c33f146" x="0" y="41" width="280" height="19"/>
113 
					<textElement textAlignment="Center" verticalAlignment="Middle">
114 
						<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
115 
					</textElement>
116 
					<textFieldExpression><![CDATA[$F{nom_pessoa}]]></textFieldExpression>
117 
				</textField>
118 
				<textField>
119 
					<reportElement uuid="a07939dd-ee07-4456-ad06-b7d04c33f146" x="280" y="41" width="275" height="19"/>
120 
					<textElement textAlignment="Center" verticalAlignment="Middle">
121 
						<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
122 
					</textElement>
123 
					<textFieldExpression><![CDATA[$F{num_documento}]]></textFieldExpression>
124 
				</textField>
125 
			</elementGroup>
126 
		</band>
127 
	</columnHeader>
128 
	<detail>
129 
		<band height="20">
130 
			<subreport>
131 
				<reportElement uuid="690c85e2-8e91-4f16-830b-6228301c9ada" x="0" y="0" width="555" height="20" isRemoveLineWhenBlank="true"/>
132 
				<subreportParameter name="SUBREPORT_DIR">
133 
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
134 
				</subreportParameter>
135 
				<subreportParameter name="SEQ_PESSOA_FISICA">
136 
					<subreportParameterExpression><![CDATA[$P{SEQ_PESSOA_FISICA}]]></subreportParameterExpression>
137 
				</subreportParameter>
138 
				<subreportParameter name="ANO">
139 
					<subreportParameterExpression><![CDATA[$P{ANO}]]></subreportParameterExpression>
140 
				</subreportParameter>
141 
				<subreportParameter name="IMAGEM_DIR">
142 
					<subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
143 
				</subreportParameter>
144 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
145 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioCapacitacaoPorParticipante_sub_ano.jasper"]]></subreportExpression>
146 
			</subreport>
147 
		</band>
148 
	</detail>
149 
	<pageFooter>
150 
		<band height="15">
151 
			<textField isBlankWhenNull="true">
152 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="0" width="374" height="15"/>
153 
				<textElement verticalAlignment="Middle">
154 
					<font fontName="Arial" size="6" isBold="false"/>
155 
				</textElement>
156 
				<textFieldExpression><![CDATA["Gerado por " + $P{NOM_USUARIO} + ", CPF: " + $P{CPF_USUARIO} + new java.text.SimpleDateFormat("', em 'dd 'de' MMMMM 'de' yyyy' às 'HH:mm", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
157 
			</textField>
158 
			<textField isBlankWhenNull="false">
159 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="428" y="0" width="73" height="15"/>
160 
				<textElement textAlignment="Right" verticalAlignment="Middle">
161 
					<font fontName="Arial" size="6" isBold="false"/>
162 
				</textElement>
163 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
164 
			</textField>
165 
			<textField evaluationTime="Report" isBlankWhenNull="false">
166 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="502" y="0" width="52" height="15"/>
167 
				<textElement verticalAlignment="Middle">
168 
					<font fontName="Arial" size="6" isBold="false"/>
169 
				</textElement>
170 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
171 
			</textField>
172 
		</band>
173 
	</pageFooter>
174 
	<summary>
175 
		<band height="43">
176 
			<subreport>
177 
				<reportElement uuid="0cc07e30-0a52-4545-b963-c91c8820bd36" x="0" y="23" width="555" height="20"/>
178 
				<subreportParameter name="SUBREPORT_DIR">
179 
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
180 
				</subreportParameter>
181 
				<subreportParameter name="SEQ_PESSOA_FISICA">
182 
					<subreportParameterExpression><![CDATA[$P{SEQ_PESSOA_FISICA}]]></subreportParameterExpression>
183 
				</subreportParameter>
184 
				<subreportParameter name="ANO">
185 
					<subreportParameterExpression><![CDATA[$P{ANO}]]></subreportParameterExpression>
186 
				</subreportParameter>
187 
				<subreportParameter name="IMAGEM_DIR">
188 
					<subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
189 
				</subreportParameter>
190 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
191 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioCapacitacaoPorParticipante_sub_totalizador.jasper"]]></subreportExpression>
192 
			</subreport>
193 
		</band>
194 
	</summary>
195 
</jasperReport>