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" whenNoDataType="NoDataSection" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="85d4a540-608e-4934-8f57-57cec53afb74">
3 
	<property name="ireport.zoom" value="1.5"/>
4 
	<property name="ireport.x" value="73"/>
5 
	<property name="ireport.y" value="1261"/>
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="ANO" class="java.lang.Integer">
19 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
20 
	</parameter>
21 
	<queryString>
22 
		<![CDATA[SELECT
23 
tr.num_ano,
24 
tr.seq_turma,
25 
tp.seq_turma_participante,
26 
pw.nom_pessoa,
27 
cp.seq_capacitacao,
28 
cp.dsc_capacitacao,
29 
COUNT(tp.seq_turma_participante) as qtd_faltas
30 
FROM sc_scs.scs_turma tr
31 
INNER JOIN sc_scs.scs_turma_participante tp ON tr.seq_turma = tp.seq_turma
32 
INNER JOIN sc_scg.vw_pessoa_fisica pw ON tp.seq_pessoa_participante = pw.seq_pessoa
33 
INNER JOIN sc_scs.scs_capacitacao cp ON tr.seq_capacitacao = cp.seq_capacitacao
34 
INNER JOIN sc_scs.scs_frequencia fr ON tr.seq_turma = fr.seq_turma
35 
INNER JOIN sc_scs.scs_presenca ps ON tp.seq_turma_participante = ps.seq_turma_participante
36 
AND ps.seq_frequencia = fr.seq_frequencia
37 
WHERE fr.ind_validado = TRUE
38 
AND ps.ind_presenca = FALSE
39 
AND tr.num_ano = $P{ANO}
40 
GROUP BY tr.num_ano, tp.seq_turma_participante, pw.nom_pessoa, cp.seq_capacitacao, cp.dsc_capacitacao, tr.seq_turma
41 
ORDER BY cp.dsc_capacitacao, pw.nom_pessoa]]>
42 
	</queryString>
43 
	<field name="num_ano" class="java.math.BigDecimal"/>
44 
	<field name="seq_turma" class="java.lang.Long"/>
45 
	<field name="seq_turma_participante" class="java.lang.Long"/>
46 
	<field name="nom_pessoa" class="java.lang.String"/>
47 
	<field name="seq_capacitacao" class="java.lang.Long"/>
48 
	<field name="dsc_capacitacao" class="java.lang.String"/>
49 
	<field name="qtd_faltas" class="java.lang.Long"/>
50 
	<group name="Capacitacao" isReprintHeaderOnEachPage="true">
51 
		<groupExpression><![CDATA[$F{dsc_capacitacao}]]></groupExpression>
52 
		<groupHeader>
53 
			<band height="68">
54 
				<elementGroup>
55 
					<rectangle>
56 
						<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="0" y="8" width="403" height="20" backcolor="#CCCCCC"/>
57 
					</rectangle>
58 
					<staticText>
59 
						<reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" x="0" y="8" width="403" height="20"/>
60 
						<textElement textAlignment="Center" verticalAlignment="Middle">
61 
							<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
62 
						</textElement>
63 
						<text><![CDATA[CAPACITAÇÃO]]></text>
64 
					</staticText>
65 
					<rectangle>
66 
						<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" mode="Transparent" x="0" y="28" width="403" height="20" backcolor="#CCCCCC"/>
67 
					</rectangle>
68 
					<textField>
69 
						<reportElement uuid="ae85f1f3-ed48-42f9-b88e-aad031c18f0c" x="0" y="28" width="403" height="20"/>
70 
						<textElement textAlignment="Center" verticalAlignment="Middle">
71 
							<font fontName="Arial"/>
72 
						</textElement>
73 
						<textFieldExpression><![CDATA[$F{dsc_capacitacao}]]></textFieldExpression>
74 
					</textField>
75 
					<rectangle>
76 
						<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="0" y="48" width="403" height="20" backcolor="#CCCCCC"/>
77 
					</rectangle>
78 
					<staticText>
79 
						<reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" x="0" y="48" width="403" height="20" isPrintWhenDetailOverflows="true"/>
80 
						<textElement textAlignment="Center" verticalAlignment="Middle">
81 
							<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
82 
						</textElement>
83 
						<text><![CDATA[PARTICIPANTES]]></text>
84 
					</staticText>
85 
					<rectangle>
86 
						<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="403" y="48" width="152" height="20" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
87 
					</rectangle>
88 
					<staticText>
89 
						<reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" x="403" y="48" width="151" height="20" isPrintWhenDetailOverflows="true"/>
90 
						<textElement textAlignment="Center" verticalAlignment="Middle">
91 
							<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
92 
						</textElement>
93 
						<text><![CDATA[QUANTIDADE DE FALTAS]]></text>
94 
					</staticText>
95 
					<rectangle>
96 
						<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="403" y="8" width="152" height="20" backcolor="#CCCCCC"/>
97 
					</rectangle>
98 
					<rectangle>
99 
						<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" mode="Opaque" x="403" y="28" width="152" height="20" backcolor="#FFFFFF"/>
100 
					</rectangle>
101 
					<staticText>
102 
						<reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" mode="Transparent" x="403" y="8" width="151" height="20"/>
103 
						<textElement textAlignment="Center" verticalAlignment="Middle">
104 
							<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
105 
						</textElement>
106 
						<text><![CDATA[TURMA]]></text>
107 
					</staticText>
108 
					<textField>
109 
						<reportElement uuid="a2231f3b-8e55-40d6-b970-2967e005a2a1" x="403" y="28" width="152" height="20"/>
110 
						<textElement textAlignment="Center" verticalAlignment="Middle">
111 
							<font fontName="Arial"/>
112 
						</textElement>
113 
						<textFieldExpression><![CDATA[$F{seq_turma}]]></textFieldExpression>
114 
					</textField>
115 
				</elementGroup>
116 
			</band>
117 
		</groupHeader>
118 
	</group>
119 
	<pageHeader>
120 
		<band height="130">
121 
			<staticText>
122 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="48" width="555" height="36"/>
123 
				<textElement textAlignment="Center" verticalAlignment="Top">
124 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
125 
				</textElement>
126 
				<text><![CDATA[Secretaria de Estado da Saúde
127 
Coordenadoria Setorial de Gestão e Desenvolvimento de Pessoas
128 
Gerência de Desenvolvimento e Educação de Pessoas
129 
]]></text>
130 
			</staticText>
131 
			<image scaleImage="RealSize" hAlign="Center" vAlign="Middle" onErrorType="Icon">
132 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="258" y="0" width="33" height="36"/>
133 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.png"]]></imageExpression>
134 
			</image>
135 
			<staticText>
136 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="37" width="555" height="12"/>
137 
				<textElement textAlignment="Center" verticalAlignment="Top">
138 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
139 
				</textElement>
140 
				<text><![CDATA[Estado de Alagoas]]></text>
141 
			</staticText>
142 
			<staticText>
143 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="92" width="555" height="12"/>
144 
				<textElement textAlignment="Center" verticalAlignment="Middle">
145 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
146 
				</textElement>
147 
				<text><![CDATA[Relatório de Participantes Faltantes]]></text>
148 
			</staticText>
149 
			<textField>
150 
				<reportElement uuid="db29e6fb-e831-48bb-a00b-1ead719928b1" x="0" y="104" width="555" height="12"/>
151 
				<textElement textAlignment="Center" verticalAlignment="Middle">
152 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
153 
				</textElement>
154 
				<textFieldExpression><![CDATA["Ano de Exercício: " + $P{ANO}]]></textFieldExpression>
155 
			</textField>
156 
		</band>
157 
	</pageHeader>
158 
	<detail>
159 
		<band height="20">
160 
			<rectangle>
161 
				<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" mode="Transparent" x="403" y="0" width="152" height="20" backcolor="#CCCCCC"/>
162 
			</rectangle>
163 
			<rectangle>
164 
				<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" mode="Transparent" x="0" y="0" width="403" height="20" backcolor="#CCCCCC"/>
165 
			</rectangle>
166 
			<textField>
167 
				<reportElement uuid="8b920c02-2e1b-4b83-8985-55864d199982" x="0" y="0" width="403" height="20"/>
168 
				<textElement textAlignment="Center" verticalAlignment="Middle">
169 
					<font fontName="Arial"/>
170 
				</textElement>
171 
				<textFieldExpression><![CDATA[$F{nom_pessoa}]]></textFieldExpression>
172 
			</textField>
173 
			<textField>
174 
				<reportElement uuid="56b6e42d-1272-48a5-a912-8d1c46903eb6" x="403" y="0" width="151" height="20"/>
175 
				<textElement textAlignment="Center" verticalAlignment="Middle">
176 
					<font fontName="Arial"/>
177 
				</textElement>
178 
				<textFieldExpression><![CDATA[$F{qtd_faltas}]]></textFieldExpression>
179 
			</textField>
180 
		</band>
181 
	</detail>
182 
	<pageFooter>
183 
		<band height="15">
184 
			<textField isBlankWhenNull="true">
185 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="0" width="374" height="15"/>
186 
				<textElement verticalAlignment="Middle">
187 
					<font fontName="Arial" size="6" isBold="false"/>
188 
				</textElement>
189 
				<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>
190 
			</textField>
191 
			<textField isBlankWhenNull="false">
192 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="428" y="0" width="73" height="15"/>
193 
				<textElement textAlignment="Right" verticalAlignment="Middle">
194 
					<font fontName="Arial" size="6" isBold="false"/>
195 
				</textElement>
196 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
197 
			</textField>
198 
			<textField evaluationTime="Report" isBlankWhenNull="false">
199 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="502" y="0" width="52" height="15"/>
200 
				<textElement verticalAlignment="Middle">
201 
					<font fontName="Arial" size="6" isBold="false"/>
202 
				</textElement>
203 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
204 
			</textField>
205 
		</band>
206 
	</pageFooter>
207 
	<noData>
208 
		<band height="802">
209 
			<rectangle>
210 
				<reportElement uuid="1ce4fd6f-836f-4005-96f5-d0a9bf065420" x="0" y="130" width="555" height="20" backcolor="#CCCCCC"/>
211 
			</rectangle>
212 
			<staticText>
213 
				<reportElement uuid="cd5b1a6e-c479-428f-ac03-5ad82545cd5a" x="0" y="130" width="554" height="20"/>
214 
				<textElement textAlignment="Center" verticalAlignment="Middle">
215 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
216 
				</textElement>
217 
				<text><![CDATA[NÃO EXISTEM PARTICIPANTES FALTANTES]]></text>
218 
			</staticText>
219 
			<staticText>
220 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="48" width="555" height="36"/>
221 
				<textElement textAlignment="Center" verticalAlignment="Top">
222 
					<font fontName="Arial" size="10" isBold="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
223 
				</textElement>
224 
				<text><![CDATA[Secretaria de Estado da Saúde
225 
Coordenadoria Setorial de Gestão e Desenvolvimento de Pessoas
226 
Gerência de Desenvolvimento e Educação de Pessoas
227 
]]></text>
228 
			</staticText>
229 
			<image scaleImage="RealSize" hAlign="Center" vAlign="Middle" onErrorType="Icon">
230 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" positionType="Float" mode="Transparent" x="258" y="0" width="33" height="36"/>
231 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.png"]]></imageExpression>
232 
			</image>
233 
			<staticText>
234 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="37" width="555" height="12"/>
235 
				<textElement textAlignment="Center" verticalAlignment="Top">
236 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
237 
				</textElement>
238 
				<text><![CDATA[Estado de Alagoas]]></text>
239 
			</staticText>
240 
			<staticText>
241 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="92" width="555" height="12"/>
242 
				<textElement textAlignment="Center" verticalAlignment="Middle">
243 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
244 
				</textElement>
245 
				<text><![CDATA[Relatório de Participantes Faltantes]]></text>
246 
			</staticText>
247 
			<textField>
248 
				<reportElement uuid="db29e6fb-e831-48bb-a00b-1ead719928b1" x="0" y="104" width="555" height="12"/>
249 
				<textElement textAlignment="Center" verticalAlignment="Middle">
250 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="true"/>
251 
				</textElement>
252 
				<textFieldExpression><![CDATA["Ano de Exercício: " + $P{ANO}]]></textFieldExpression>
253 
			</textField>
254 
			<textField isBlankWhenNull="true">
255 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="1" y="787" width="374" height="15"/>
256 
				<textElement verticalAlignment="Middle">
257 
					<font fontName="Arial" size="6" isBold="false"/>
258 
				</textElement>
259 
				<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>
260 
			</textField>
261 
			<textField isBlankWhenNull="false">
262 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="482" y="787" width="73" height="15"/>
263 
				<textElement textAlignment="Center" verticalAlignment="Middle">
264 
					<font fontName="Arial" size="6" isBold="false"/>
265 
				</textElement>
266 
				<textFieldExpression><![CDATA["PÁGINA 1 DE 1"]]></textFieldExpression>
267 
			</textField>
268 
		</band>
269 
	</noData>
270 
</jasperReport>