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="556" leftMargin="20" rightMargin="19" topMargin="20" bottomMargin="20" uuid="85d4a540-608e-4934-8f57-57cec53afb74">
3 
	<property name="ireport.zoom" value="1.5"/>
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="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
10 
		<defaultValueExpression><![CDATA["C:\\Repositorio\\DESENVOLVIMENTO\\SESAU\\JAVA\\Repositorio\\rhcapacitacao\\FONTES\\IMPLEMENTACAO\\DESENVOLVIMENTO\\scs\\scs-core\\src\\main\\resources\\relatorios\\"]]></defaultValueExpression>
11 
	</parameter>
12 
	<parameter name="NOM_USUARIO" class="java.lang.String">
13 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
14 
	</parameter>
15 
	<parameter name="CPF_USUARIO" class="java.lang.String">
16 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
17 
	</parameter>
18 
	<parameter name="SEQ_TURMA" class="java.lang.Long">
19 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
20 
	</parameter>
21 
	<queryString>
22 
		<![CDATA[SELECT
23 
(SELECT COUNT(fr.seq_turma) FROM sc_scs.scs_frequencia fr WHERE fr.seq_turma = $P{SEQ_TURMA} AND fr.ind_validado = true) as qtd_frequencia,
24 
tu.seq_turma,
25 
cp.dsc_capacitacao,
26 
tu.num_ano
27 
FROM sc_scs.scs_turma tu
28 
INNER JOIN sc_scs.scs_capacitacao cp ON tu.seq_capacitacao = cp.seq_capacitacao
29 
WHERE tu.seq_turma = $P{SEQ_TURMA}]]>
30 
	</queryString>
31 
	<field name="qtd_frequencia" class="java.lang.Long"/>
32 
	<field name="seq_turma" class="java.lang.Long"/>
33 
	<field name="dsc_capacitacao" class="java.lang.String"/>
34 
	<field name="num_ano" class="java.math.BigDecimal"/>
35 
	<pageHeader>
36 
		<band height="116">
37 
			<staticText>
38 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="48" width="555" height="36"/>
39 
				<textElement textAlignment="Center" verticalAlignment="Top">
40 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
41 
				</textElement>
42 
				<text><![CDATA[Secretaria de Estado da Saúde
43 
Coordenadoria Setorial de Gestão e Desenvolvimento de Pessoas
44 
Gerência de Desenvolvimento e Educação de Pessoas
45 
]]></text>
46 
			</staticText>
47 
			<image scaleImage="RealSize" hAlign="Center" vAlign="Middle" onErrorType="Icon">
48 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="258" y="0" width="33" height="36"/>
49 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.png"]]></imageExpression>
50 
			</image>
51 
			<staticText>
52 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="37" width="555" height="12"/>
53 
				<textElement textAlignment="Center" verticalAlignment="Top">
54 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
55 
				</textElement>
56 
				<text><![CDATA[Estado de Alagoas]]></text>
57 
			</staticText>
58 
			<staticText>
59 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="92" width="555" height="12"/>
60 
				<textElement textAlignment="Center" verticalAlignment="Middle">
61 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
62 
				</textElement>
63 
				<text><![CDATA[Relatório de Participantes por Turma]]></text>
64 
			</staticText>
65 
		</band>
66 
	</pageHeader>
67 
	<detail>
68 
		<band height="120">
69 
			<rectangle>
70 
				<reportElement uuid="c3eedd42-a096-4b5c-8c9c-ef04da5f8b58" x="0" y="40" width="92" height="20"/>
71 
			</rectangle>
72 
			<rectangle>
73 
				<reportElement uuid="19f89383-f30c-43a6-9677-4bcceba181d8" x="0" y="20" width="92" height="20" backcolor="#CCCCCC"/>
74 
			</rectangle>
75 
			<rectangle>
76 
				<reportElement uuid="ec12e2f3-a174-4a7a-98ca-9718faa79aad" x="0" y="0" width="556" height="20" backcolor="#CCCCCC"/>
77 
			</rectangle>
78 
			<rectangle>
79 
				<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="164" y="20" width="392" height="20" backcolor="#CCCCCC"/>
80 
			</rectangle>
81 
			<staticText>
82 
				<reportElement uuid="5b3ddd59-b852-459a-a68d-6529ce9bb9a6" x="0" y="0" width="556" height="20"/>
83 
				<textElement textAlignment="Center" verticalAlignment="Middle">
84 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
85 
				</textElement>
86 
				<text><![CDATA[TURMA]]></text>
87 
			</staticText>
88 
			<rectangle>
89 
				<reportElement uuid="b5955532-652d-4a7a-881a-29fa82c7b637" x="92" y="40" width="72" height="20"/>
90 
			</rectangle>
91 
			<rectangle>
92 
				<reportElement uuid="19f89383-f30c-43a6-9677-4bcceba181d8" x="92" y="20" width="72" height="20" backcolor="#CCCCCC"/>
93 
			</rectangle>
94 
			<staticText>
95 
				<reportElement uuid="5a3503cf-7325-4d4f-b9df-ffdf89f3ecc3" x="0" y="20" width="92" height="20"/>
96 
				<textElement textAlignment="Center" verticalAlignment="Middle">
97 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
98 
				</textElement>
99 
				<text><![CDATA[IDENTIFICADOR]]></text>
100 
			</staticText>
101 
			<staticText>
102 
				<reportElement uuid="92d74d74-bf89-40b6-8935-534fefbfdd6a" x="92" y="20" width="72" height="20"/>
103 
				<textElement textAlignment="Center" verticalAlignment="Middle">
104 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
105 
				</textElement>
106 
				<text><![CDATA[ANO]]></text>
107 
			</staticText>
108 
			<staticText>
109 
				<reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" x="166" y="20" width="390" height="20"/>
110 
				<textElement textAlignment="Center" verticalAlignment="Middle">
111 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
112 
				</textElement>
113 
				<text><![CDATA[CAPACITAÇÃO]]></text>
114 
			</staticText>
115 
			<rectangle>
116 
				<reportElement uuid="b5955532-652d-4a7a-881a-29fa82c7b637" x="164" y="40" width="392" height="20"/>
117 
			</rectangle>
118 
			<textField>
119 
				<reportElement uuid="ef447b8d-0dd6-4679-954e-4dd6301fcd3a" x="0" y="40" width="92" height="20"/>
120 
				<textElement textAlignment="Center" verticalAlignment="Middle">
121 
					<font isStrikeThrough="false"/>
122 
					<paragraph leftIndent="5"/>
123 
				</textElement>
124 
				<textFieldExpression><![CDATA[$F{seq_turma}]]></textFieldExpression>
125 
			</textField>
126 
			<textField>
127 
				<reportElement uuid="1ef917e4-287f-403b-b41d-f31d75f26b29" x="92" y="40" width="72" height="20"/>
128 
				<textElement textAlignment="Center" verticalAlignment="Middle">
129 
					<paragraph leftIndent="5"/>
130 
				</textElement>
131 
				<textFieldExpression><![CDATA[$F{num_ano}]]></textFieldExpression>
132 
			</textField>
133 
			<textField>
134 
				<reportElement uuid="67a97f5b-cb79-4c66-9a22-dccea39f27bc" x="164" y="40" width="392" height="20"/>
135 
				<textElement textAlignment="Center" verticalAlignment="Middle">
136 
					<font isStrikeThrough="false"/>
137 
					<paragraph leftIndent="5"/>
138 
				</textElement>
139 
				<textFieldExpression><![CDATA[$F{dsc_capacitacao}]]></textFieldExpression>
140 
			</textField>
141 
			<subreport>
142 
				<reportElement uuid="f6b7315c-0b31-42d0-866a-ec7075b0ebc1" positionType="Float" x="0" y="80" width="556" height="20"/>
143 
				<subreportParameter name="SUBREPORT_DIR">
144 
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
145 
				</subreportParameter>
146 
				<subreportParameter name="NOM_USUARIO">
147 
					<subreportParameterExpression><![CDATA[$P{NOM_USUARIO}]]></subreportParameterExpression>
148 
				</subreportParameter>
149 
				<subreportParameter name="IMAGEM_DIR">
150 
					<subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
151 
				</subreportParameter>
152 
				<subreportParameter name="CPF_USUARIO">
153 
					<subreportParameterExpression><![CDATA[$P{CPF_USUARIO}]]></subreportParameterExpression>
154 
				</subreportParameter>
155 
				<subreportParameter name="SEQ_TURMA">
156 
					<subreportParameterExpression><![CDATA[$P{SEQ_TURMA}]]></subreportParameterExpression>
157 
				</subreportParameter>
158 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
159 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioParticipantePorTurma_sub_periodos.jasper"]]></subreportExpression>
160 
			</subreport>
161 
			<subreport>
162 
				<reportElement uuid="56b24167-017e-4c01-a2ff-d96501b7c52a" positionType="Float" x="0" y="100" width="556" height="20"/>
163 
				<subreportParameter name="SUBREPORT_DIR">
164 
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
165 
				</subreportParameter>
166 
				<subreportParameter name="QTD_FREQUENCIA">
167 
					<subreportParameterExpression><![CDATA[$F{qtd_frequencia}]]></subreportParameterExpression>
168 
				</subreportParameter>
169 
				<subreportParameter name="NOM_USUARIO">
170 
					<subreportParameterExpression><![CDATA[$P{NOM_USUARIO}]]></subreportParameterExpression>
171 
				</subreportParameter>
172 
				<subreportParameter name="IMAGEM_DIR">
173 
					<subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
174 
				</subreportParameter>
175 
				<subreportParameter name="CPF_USUARIO">
176 
					<subreportParameterExpression><![CDATA[$P{CPF_USUARIO}]]></subreportParameterExpression>
177 
				</subreportParameter>
178 
				<subreportParameter name="SEQ_TURMA">
179 
					<subreportParameterExpression><![CDATA[$P{SEQ_TURMA}]]></subreportParameterExpression>
180 
				</subreportParameter>
181 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
182 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioParticipantePorTurma_sub_participante.jasper"]]></subreportExpression>
183 
			</subreport>
184 
			<subreport>
185 
				<reportElement uuid="cfec7a7e-37d9-4f8f-a3cf-2a13d6c4ca39" positionType="Float" x="0" y="60" width="556" height="20"/>
186 
				<subreportParameter name="SUBREPORT_DIR">
187 
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression>
188 
				</subreportParameter>
189 
				<subreportParameter name="NOM_USUARIO">
190 
					<subreportParameterExpression><![CDATA[$P{NOM_USUARIO}]]></subreportParameterExpression>
191 
				</subreportParameter>
192 
				<subreportParameter name="IMAGEM_DIR">
193 
					<subreportParameterExpression><![CDATA[$P{IMAGEM_DIR}]]></subreportParameterExpression>
194 
				</subreportParameter>
195 
				<subreportParameter name="CPF_USUARIO">
196 
					<subreportParameterExpression><![CDATA[$P{CPF_USUARIO}]]></subreportParameterExpression>
197 
				</subreportParameter>
198 
				<subreportParameter name="SEQ_TURMA">
199 
					<subreportParameterExpression><![CDATA[$P{SEQ_TURMA}]]></subreportParameterExpression>
200 
				</subreportParameter>
201 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
202 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorioParticipantePorTurma_sub_organizadores.jasper"]]></subreportExpression>
203 
			</subreport>
204 
		</band>
205 
	</detail>
206 
	<pageFooter>
207 
		<band height="15">
208 
			<textField isBlankWhenNull="true">
209 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="0" width="374" height="15"/>
210 
				<textElement verticalAlignment="Middle">
211 
					<font fontName="Arial" size="6" isBold="false"/>
212 
				</textElement>
213 
				<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>
214 
			</textField>
215 
			<textField isBlankWhenNull="false">
216 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="428" y="0" width="73" height="15"/>
217 
				<textElement textAlignment="Right" verticalAlignment="Middle">
218 
					<font fontName="Arial" size="6" isBold="false"/>
219 
				</textElement>
220 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
221 
			</textField>
222 
			<textField evaluationTime="Report" isBlankWhenNull="false">
223 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="502" y="0" width="52" height="15"/>
224 
				<textElement verticalAlignment="Middle">
225 
					<font fontName="Arial" size="6" isBold="false"/>
226 
				</textElement>
227 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
228 
			</textField>
229 
		</band>
230 
	</pageFooter>
231 
</jasperReport>