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_acompanhamento_avaliacao" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="96b0c032-951b-4918-9418-1135f2e13659">
3 
	<property name="ireport.zoom" value="3.138428376721004"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="0"/>
6 
	<parameter name="pSequencialGrupoAvaliacao" class="java.lang.Long">
7 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
8 
	</parameter>
9 
	<parameter name="pCodigoUnidadeExercicio" class="java.lang.Long">
10 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
11 
	</parameter>
12 
	<parameter name="pAnoCronograma" class="java.lang.Long"/>
13 
	<parameter name="IMAGEM_DIR" class="java.lang.String">
14 
		<defaultValueExpression><![CDATA["c://"]]></defaultValueExpression>
15 
	</parameter>
16 
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
17 
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
18 
	</parameter>
19 
	<parameter name="pMatriculaServidor" class="java.lang.Long">
20 
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
21 
	</parameter>
22 
	<parameter name="pNomeUsuario" class="java.lang.String"/>
23 
	<parameter name="pCpfUsuario" class="java.lang.String"/>
24 
	<queryString>
25 
		<![CDATA[SELECT
26 
  ad.dsc_unidade_cadastro unidade,
27 
  ad.dsc_grupo_avaliacao grupoAvaliacao,
28 
(
29 
  select p.nom_pessoa from sc_scg.vw_pessoa_fisica p where p.seq_pessoa = ad.seq_pessoa_avaliador
30 
  ) nomeAvaliador,
31 
  ad.num_cpf numeroCpf,
32 
  ad.nom_pessoa nomeServidor,
33 
  (ad.num_matricula_servidor || '-' || ad.num_digito_matricula) matricula_servidor,
34 
  (EXISTS(
35 
	SELECT * FROM sc_rhd.rhd_avaliacao_desempenho ade join sc_rhd.rhd_questao_avaliadesemp qd ON ade.seq_questao_avaliacao = qd.seq_questao_avaliadesemp
36 
		WHERE ade.num_ano = ad.num_ano AND ade.seq_servidor_dadofuncional = ad.seq_servidor_dadofuncional and qd.tip_avaliacao_desempenho = 'U'
37 
	)
38 
   ) ind_autoavaliacao_realizada,
39 
  (CASE WHEN (SELECT COUNT(ade.seq_avaliacao_desempenho) FROM sc_rhd.rhd_avaliacao_desempenho ade join sc_rhd.rhd_questao_avaliadesemp qd ON ade.seq_questao_avaliacao = qd.seq_questao_avaliadesemp WHERE ade.num_ano = ad.num_ano AND ade.seq_servidor_dadofuncional = ad.seq_servidor_dadofuncional and qd.tip_avaliacao_desempenho = 'A' ) >= (SELECT COUNT(*) FROM sc_rhd.rhd_questao_avaliadesemp qv WHERE qv.tip_avaliacao_desempenho = 'A') THEN TRUE ELSE FALSE END) ind_avaliacao_realizada,
40 
  ad.num_nota_desempenho notaDesempenho,
41 
  ad.num_nota_assiduidade notaAssiduidade,
42 
  ad.num_nota_qualificacao notaQualificacao,
43 
  ad.num_nota_pontuacao_extra pontuacaoExtra,
44 
  ad.num_nota_final notaFinal
45 
  FROM sc_rhd.vw_avaliacao_desempenho ad
46 
where ad.num_ano = $P{pAnoCronograma}
47 
and (ad.seq_grupo_avaliacao = $P{pSequencialGrupoAvaliacao} OR $P{pSequencialGrupoAvaliacao} IS NULL)
48 
and (ad.cod_unidade_cadastro = $P{pCodigoUnidadeExercicio} OR $P{pCodigoUnidadeExercicio} IS NULL)
49 
and ((ad.num_matricula_servidor) = $P{pMatriculaServidor} OR  $P{pMatriculaServidor} IS NULL)
50 
ORDER BY ad.dsc_unidade_cadastro, ad.dsc_grupo_avaliacao, ad.nom_pessoa]]>
51 
	</queryString>
52 
	<field name="unidade" class="java.lang.String"/>
53 
	<field name="grupoavaliacao" class="java.lang.String"/>
54 
	<field name="nomeavaliador" class="java.lang.String"/>
55 
	<field name="numerocpf" class="java.lang.String"/>
56 
	<field name="nomeservidor" class="java.lang.String"/>
57 
	<field name="matricula_servidor" class="java.lang.String"/>
58 
	<field name="ind_autoavaliacao_realizada" class="java.lang.Boolean"/>
59 
	<field name="ind_avaliacao_realizada" class="java.lang.Boolean"/>
60 
	<field name="notadesempenho" class="java.math.BigDecimal"/>
61 
	<field name="notaassiduidade" class="java.math.BigDecimal"/>
62 
	<field name="notaqualificacao" class="java.math.BigDecimal"/>
63 
	<field name="pontuacaoextra" class="java.math.BigDecimal"/>
64 
	<field name="notafinal" class="java.math.BigDecimal"/>
65 
	<group name="servidores_sem_grupo_avaliacao">
66 
		<groupExpression><![CDATA[$P{pAnoCronograma}]]></groupExpression>
67 
		<groupFooter>
68 
			<band height="54">
69 
				<subreport>
70 
					<reportElement uuid="f09708ad-41eb-489f-8e24-9315f7e9f99b" x="0" y="32" width="555" height="22"/>
71 
					<subreportParameter name="pMatriculaServidor">
72 
						<subreportParameterExpression><![CDATA[$P{pMatriculaServidor}]]></subreportParameterExpression>
73 
					</subreportParameter>
74 
					<subreportParameter name="pAnoCronograma">
75 
						<subreportParameterExpression><![CDATA[$P{pAnoCronograma}]]></subreportParameterExpression>
76 
					</subreportParameter>
77 
					<subreportParameter name="pCodigoUnidadeExercicio">
78 
						<subreportParameterExpression><![CDATA[$P{pCodigoUnidadeExercicio}]]></subreportParameterExpression>
79 
					</subreportParameter>
80 
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
81 
					<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_acompanhamento_avaliacao_subreport_servidores_sem_grupo_avaliacao.jasper"]]></subreportExpression>
82 
				</subreport>
83 
			</band>
84 
		</groupFooter>
85 
	</group>
86 
	<group name="unidade_exercicio">
87 
		<groupExpression><![CDATA[$F{unidade}]]></groupExpression>
88 
		<groupHeader>
89 
			<band height="42">
90 
				<textField isStretchWithOverflow="true">
91 
					<reportElement uuid="1b7ae11b-d3df-4108-8e29-221b7e53a9d4" x="0" y="21" width="555" height="20"/>
92 
					<textElement verticalAlignment="Bottom">
93 
						<font fontName="Arial" size="12" isBold="true" isUnderline="true" pdfFontName="Helvetica-Bold"/>
94 
					</textElement>
95 
					<textFieldExpression><![CDATA["UNIDADE: " + $F{unidade}]]></textFieldExpression>
96 
				</textField>
97 
			</band>
98 
		</groupHeader>
99 
	</group>
100 
	<group name="grupo_avaliacao">
101 
		<groupExpression><![CDATA[$F{grupoavaliacao}]]></groupExpression>
102 
		<groupHeader>
103 
			<band height="61">
104 
				<rectangle>
105 
					<reportElement uuid="ebb138a6-6dac-4aee-bb4b-a43843d53ba2" x="0" y="46" width="555" height="14" forecolor="#BABABA" backcolor="#BABABA"/>
106 
					<graphicElement>
107 
						<pen lineWidth="1.0"/>
108 
					</graphicElement>
109 
				</rectangle>
110 
				<staticText>
111 
					<reportElement uuid="6389c3a0-d78e-451f-b563-47d7e6136a21" x="435" y="47" width="36" height="14"/>
112 
					<textElement textAlignment="Center" verticalAlignment="Middle">
113 
						<font fontName="Arial" size="8" isBold="false"/>
114 
					</textElement>
115 
					<text><![CDATA[Qualif.]]></text>
116 
				</staticText>
117 
				<staticText>
118 
					<reportElement uuid="6389c3a0-d78e-451f-b563-47d7e6136a21" x="471" y="47" width="39" height="14"/>
119 
					<textElement textAlignment="Center" verticalAlignment="Middle">
120 
						<font fontName="Arial" size="8" isBold="false"/>
121 
					</textElement>
122 
					<text><![CDATA[Pont. Ext.]]></text>
123 
				</staticText>
124 
				<staticText>
125 
					<reportElement uuid="6389c3a0-d78e-451f-b563-47d7e6136a21" x="510" y="47" width="45" height="14"/>
126 
					<textElement textAlignment="Center" verticalAlignment="Middle">
127 
						<font fontName="Arial" size="8" isBold="false"/>
128 
					</textElement>
129 
					<text><![CDATA[Nota. Fin.]]></text>
130 
				</staticText>
131 
				<staticText>
132 
					<reportElement uuid="b5777072-9dd1-422b-96c8-08baa2b919a8" x="165" y="47" width="55" height="14"/>
133 
					<textElement textAlignment="Center" verticalAlignment="Middle">
134 
						<font fontName="Arial" size="8" isBold="false"/>
135 
					</textElement>
136 
					<text><![CDATA[Matrícula]]></text>
137 
				</staticText>
138 
				<staticText>
139 
					<reportElement uuid="429fefa5-0682-4c77-8746-0ff489e5b80b" x="1" y="47" width="164" height="14"/>
140 
					<textElement verticalAlignment="Middle">
141 
						<font fontName="Arial" size="8" isBold="false"/>
142 
					</textElement>
143 
					<text><![CDATA[Nome]]></text>
144 
				</staticText>
145 
				<staticText>
146 
					<reportElement uuid="99fb2043-08a8-4412-a02a-786a275cb654" x="220" y="47" width="74" height="14"/>
147 
					<textElement textAlignment="Center" verticalAlignment="Middle">
148 
						<font fontName="Arial" size="8" isBold="false"/>
149 
					</textElement>
150 
					<text><![CDATA[CPF]]></text>
151 
				</staticText>
152 
				<textField>
153 
					<reportElement uuid="f0d83fb9-02c2-42c5-9a2c-d618a8de2580" mode="Opaque" x="0" y="24" width="555" height="16" forecolor="#000000" backcolor="#999999"/>
154 
					<textElement verticalAlignment="Middle">
155 
						<font fontName="Arial" size="8" isBold="true" isUnderline="false" pdfFontName="Helvetica-Bold"/>
156 
					</textElement>
157 
					<textFieldExpression><![CDATA[" AVALIADOR(A): " + $F{nomeavaliador}]]></textFieldExpression>
158 
				</textField>
159 
				<staticText>
160 
					<reportElement uuid="a3e49187-7580-445e-a660-2f20a1809c57" x="331" y="47" width="30" height="14"/>
161 
					<textElement textAlignment="Center" verticalAlignment="Middle">
162 
						<font fontName="Arial" size="8" isBold="false"/>
163 
					</textElement>
164 
					<text><![CDATA[Aval.]]></text>
165 
				</staticText>
166 
				<textField>
167 
					<reportElement uuid="f0d83fb9-02c2-42c5-9a2c-d618a8de2580" mode="Opaque" x="0" y="8" width="555" height="16" forecolor="#000000" backcolor="#999999"/>
168 
					<textElement verticalAlignment="Middle">
169 
						<font fontName="Arial" isBold="true" isUnderline="false" pdfFontName="Helvetica-Bold"/>
170 
					</textElement>
171 
					<textFieldExpression><![CDATA[" GRUPO: " + $F{grupoavaliacao}]]></textFieldExpression>
172 
				</textField>
173 
				<staticText>
174 
					<reportElement uuid="6389c3a0-d78e-451f-b563-47d7e6136a21" x="399" y="47" width="36" height="14"/>
175 
					<textElement textAlignment="Center" verticalAlignment="Middle">
176 
						<font fontName="Arial" size="8" isBold="false"/>
177 
					</textElement>
178 
					<text><![CDATA[Assid.]]></text>
179 
				</staticText>
180 
				<staticText>
181 
					<reportElement uuid="a3e49187-7580-445e-a660-2f20a1809c57" x="294" y="47" width="37" height="14"/>
182 
					<textElement textAlignment="Center" verticalAlignment="Middle">
183 
						<font fontName="Arial" size="8" isBold="false"/>
184 
					</textElement>
185 
					<text><![CDATA[Autoav.]]></text>
186 
				</staticText>
187 
				<staticText>
188 
					<reportElement uuid="6389c3a0-d78e-451f-b563-47d7e6136a21" x="361" y="47" width="38" height="14"/>
189 
					<textElement textAlignment="Center" verticalAlignment="Middle">
190 
						<font fontName="Arial" size="8" isBold="false"/>
191 
					</textElement>
192 
					<text><![CDATA[Desemp.]]></text>
193 
				</staticText>
194 
			</band>
195 
		</groupHeader>
196 
	</group>
197 
	<background>
198 
		<band splitType="Stretch"/>
199 
	</background>
200 
	<title>
201 
		<band height="145" splitType="Stretch">
202 
			<textField isBlankWhenNull="false">
203 
				<reportElement uuid="7e420030-8524-414a-9258-b8ff749fc009" x="0" y="116" width="555" height="15"/>
204 
				<textElement textAlignment="Center">
205 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
206 
				</textElement>
207 
				<textFieldExpression><![CDATA["CRONOGRAMA: " + $P{pAnoCronograma}]]></textFieldExpression>
208 
			</textField>
209 
			<image hAlign="Right">
210 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="259" y="1" width="48" height="59"/>
211 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.jpg"]]></imageExpression>
212 
			</image>
213 
			<staticText>
214 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="95" width="555" height="16" isPrintWhenDetailOverflows="true"/>
215 
				<textElement textAlignment="Center" verticalAlignment="Top">
216 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
217 
				</textElement>
218 
				<text><![CDATA[RELATÓRIO DE ACOMPANHAMENTO DA AVALIAÇÃO]]></text>
219 
			</staticText>
220 
			<staticText>
221 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="64" width="555" height="26"/>
222 
				<textElement textAlignment="Center">
223 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
224 
				</textElement>
225 
				<text><![CDATA[ESTADO DE ALAGOAS
226 
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS]]></text>
227 
			</staticText>
228 
		</band>
229 
	</title>
230 
	<pageHeader>
231 
		<band splitType="Stretch"/>
232 
	</pageHeader>
233 
	<detail>
234 
		<band height="14" splitType="Stretch">
235 
			<rectangle>
236 
				<reportElement uuid="929d9137-2979-443b-a76d-d93458dbea93" stretchType="RelativeToBandHeight" x="0" y="0" width="555" height="14" isPrintWhenDetailOverflows="true" forecolor="#DCDCDC" backcolor="#DCDCDC">
237 
					<printWhenExpression><![CDATA[new Boolean(($V{COLUMN_COUNT}.intValue() % 2) == 0)]]></printWhenExpression>
238 
				</reportElement>
239 
				<graphicElement>
240 
					<pen lineWidth="0.0"/>
241 
				</graphicElement>
242 
			</rectangle>
243 
			<textField isStretchWithOverflow="true">
244 
				<reportElement uuid="6061d8f0-769a-4fd2-9713-b0908f153b4c" x="165" y="0" width="55" height="14"/>
245 
				<textElement textAlignment="Center" verticalAlignment="Middle">
246 
					<font fontName="Arial" size="8"/>
247 
				</textElement>
248 
				<textFieldExpression><![CDATA[$F{matricula_servidor}]]></textFieldExpression>
249 
			</textField>
250 
			<textField isStretchWithOverflow="true">
251 
				<reportElement uuid="a92ba739-a606-4b85-8c12-d540a5ba9a08" x="0" y="0" width="165" height="14"/>
252 
				<textElement verticalAlignment="Middle">
253 
					<font fontName="Arial" size="8"/>
254 
				</textElement>
255 
				<textFieldExpression><![CDATA[$F{nomeservidor}]]></textFieldExpression>
256 
			</textField>
257 
			<textField isStretchWithOverflow="true">
258 
				<reportElement uuid="04d5aaaa-8a49-4b1a-bc70-0a51baa44eba" x="220" y="0" width="74" height="14"/>
259 
				<textElement textAlignment="Center" verticalAlignment="Middle">
260 
					<font fontName="Arial" size="8"/>
261 
				</textElement>
262 
				<textFieldExpression><![CDATA[($F{numerocpf} == null)? null : (($F{numerocpf}.trim().length() == 11)? $F{numerocpf}.trim().replaceAll("(\\d{3})(\\d{3})(\\d{3})(\\d{2})", "$1.$2.$3-$4") : $F{numerocpf})]]></textFieldExpression>
263 
			</textField>
264 
			<textField isStretchWithOverflow="true">
265 
				<reportElement uuid="46a8fda5-9660-47a6-aa8b-45881fcedc41" x="294" y="0" width="37" height="14"/>
266 
				<textElement textAlignment="Center" verticalAlignment="Middle">
267 
					<font fontName="Arial" size="8"/>
268 
				</textElement>
269 
				<textFieldExpression><![CDATA[$F{ind_autoavaliacao_realizada}? "SIM" : "NÃO"]]></textFieldExpression>
270 
			</textField>
271 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
272 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" x="361" y="0" width="38" height="14"/>
273 
				<textElement textAlignment="Center" verticalAlignment="Middle">
274 
					<font fontName="Arial" size="8"/>
275 
				</textElement>
276 
				<textFieldExpression><![CDATA[$F{notadesempenho}]]></textFieldExpression>
277 
			</textField>
278 
			<textField isStretchWithOverflow="true">
279 
				<reportElement uuid="46a8fda5-9660-47a6-aa8b-45881fcedc41" x="331" y="0" width="30" height="14"/>
280 
				<textElement textAlignment="Center" verticalAlignment="Middle">
281 
					<font fontName="Arial" size="8"/>
282 
				</textElement>
283 
				<textFieldExpression><![CDATA[$F{ind_avaliacao_realizada}? "SIM" : "NÃO"]]></textFieldExpression>
284 
			</textField>
285 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
286 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" x="399" y="0" width="36" height="14"/>
287 
				<textElement textAlignment="Center" verticalAlignment="Middle">
288 
					<font fontName="Arial" size="8"/>
289 
				</textElement>
290 
				<textFieldExpression><![CDATA[$F{notaassiduidade}]]></textFieldExpression>
291 
			</textField>
292 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
293 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" x="435" y="0" width="36" height="14"/>
294 
				<textElement textAlignment="Center" verticalAlignment="Middle">
295 
					<font fontName="Arial" size="8"/>
296 
				</textElement>
297 
				<textFieldExpression><![CDATA[$F{notaqualificacao}]]></textFieldExpression>
298 
			</textField>
299 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
300 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" x="471" y="0" width="39" height="14"/>
301 
				<textElement textAlignment="Center" verticalAlignment="Middle">
302 
					<font fontName="Arial" size="8"/>
303 
				</textElement>
304 
				<textFieldExpression><![CDATA[$F{pontuacaoextra}]]></textFieldExpression>
305 
			</textField>
306 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
307 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" x="510" y="0" width="45" height="14"/>
308 
				<textElement textAlignment="Center" verticalAlignment="Middle">
309 
					<font fontName="Arial" size="8"/>
310 
				</textElement>
311 
				<textFieldExpression><![CDATA[$F{notafinal}]]></textFieldExpression>
312 
			</textField>
313 
		</band>
314 
	</detail>
315 
	<pageFooter>
316 
		<band height="21">
317 
			<textField isBlankWhenNull="true">
318 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="6" width="374" height="15"/>
319 
				<textElement verticalAlignment="Middle">
320 
					<font fontName="Arial" size="6" isBold="false"/>
321 
				</textElement>
322 
				<textFieldExpression><![CDATA["Gerado por " + $P{pNomeUsuario} + ", CPF: " + $P{pCpfUsuario} + new java.text.SimpleDateFormat("', em ' dd 'de' MMMMM 'de' yyyy ' às ' HH:mm", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
323 
			</textField>
324 
			<textField evaluationTime="Report" isBlankWhenNull="false">
325 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="502" y="6" width="52" height="15"/>
326 
				<textElement verticalAlignment="Middle">
327 
					<font fontName="Arial" size="6" isBold="false"/>
328 
				</textElement>
329 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
330 
			</textField>
331 
			<textField isBlankWhenNull="false">
332 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="428" y="6" width="73" height="15"/>
333 
				<textElement textAlignment="Right" verticalAlignment="Middle">
334 
					<font fontName="Arial" size="6" isBold="false"/>
335 
				</textElement>
336 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
337 
			</textField>
338 
		</band>
339 
	</pageFooter>
340 
	<summary>
341 
		<band splitType="Stretch"/>
342 
	</summary>
343 
</jasperReport>