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_avaliacao_geral" 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.221020000000002"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="733"/>
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.seq_servidor_dadofuncional,
27 
  ad.dsc_unidade_cadastro unidade,
28 
  ad.dsc_grupo_avaliacao grupoAvaliacao,
29 
(
30 
  select p.nom_pessoa from sc_scg.vw_pessoa_fisica p where p.seq_pessoa = (select sdf.seq_pessoa_servidor from sc_srv.vw_servidor_dadofuncional sdf where sdf.seq_servidor_dadofuncional = ad.seq_servidor_dadofunc_avaliador)
31 
  ) nomeAvaliador,
32 
  ad.num_cpf numeroCpf,
33 
  ad.nom_pessoa nomeServidor,
34 
  (ad.num_matricula_servidor || '-' || ad.num_digito_matricula) matricula_servidor,
35 
  (EXISTS(
36 
	SELECT * FROM sc_rhd.rhd_avaliacao_desempenho ade join sc_rhd.rhd_questao_avaliadesemp qd ON ade.seq_questao_avaliacao = qd.seq_questao_avaliadesemp
37 
		WHERE ade.num_ano = ad.num_ano AND ade.seq_servidor_dadofuncional = ad.seq_servidor_dadofuncional and qd.tip_avaliacao_desempenho = 'U'
38 
	)
39 
   ) ind_autoavaliacao_realizada,
40 
  (EXISTS(
41 
	SELECT * FROM sc_rhd.rhd_avaliacao_desempenho ade join sc_rhd.rhd_questao_avaliadesemp qd ON ade.seq_questao_avaliacao = qd.seq_questao_avaliadesemp
42 
		WHERE ade.num_ano = ad.num_ano AND ade.seq_servidor_dadofuncional = ad.seq_servidor_dadofuncional and qd.tip_avaliacao_desempenho = 'A'
43 
	)
44 
  ) ind_avaliacao_realizada,
45 
  ad.num_nota_desempenho notaDesempenho,
46 
  ad.num_nota_assiduidade notaAssiduidade,
47 
  ad.num_nota_qualificacao notaQualificacao,
48 
  ad.num_nota_pontuacao_extra pontuacaoExtra,
49 
  ad.num_nota_final notaFinal,
50 
(select coalesce(sum(f.qtd_falta), 0) from sc_rhd.rhd_servidor_falta f where f.num_ano = ad.num_ano and f.seq_servidor_dadofuncional = ad.seq_servidor_dadofuncional) faltas_servidor
51 
  FROM sc_rhd.vw_avaliacao_desempenho ad
52 
where ad.num_ano = $P{pAnoCronograma}
53 
and (ad.seq_grupo_avaliacao = $P{pSequencialGrupoAvaliacao} OR $P{pSequencialGrupoAvaliacao} IS NULL)
54 
and (ad.cod_unidade_cadastro = $P{pCodigoUnidadeExercicio} OR $P{pCodigoUnidadeExercicio} IS NULL)
55 
and ((ad.num_matricula_servidor) = $P{pMatriculaServidor} OR $P{pMatriculaServidor} IS NULL)
56 
ORDER BY ad.dsc_unidade_cadastro, ad.dsc_grupo_avaliacao, ad.nom_pessoa]]>
57 
	</queryString>
58 
	<field name="seq_servidor_dadofuncional" class="java.lang.Long"/>
59 
	<field name="unidade" class="java.lang.String"/>
60 
	<field name="grupoavaliacao" class="java.lang.String"/>
61 
	<field name="nomeavaliador" class="java.lang.String"/>
62 
	<field name="numerocpf" class="java.lang.String"/>
63 
	<field name="nomeservidor" class="java.lang.String"/>
64 
	<field name="matricula_servidor" class="java.lang.String"/>
65 
	<field name="ind_autoavaliacao_realizada" class="java.lang.Boolean"/>
66 
	<field name="ind_avaliacao_realizada" class="java.lang.Boolean"/>
67 
	<field name="notadesempenho" class="java.math.BigDecimal"/>
68 
	<field name="notaassiduidade" class="java.math.BigDecimal"/>
69 
	<field name="notaqualificacao" class="java.math.BigDecimal"/>
70 
	<field name="pontuacaoextra" class="java.math.BigDecimal"/>
71 
	<field name="notafinal" class="java.math.BigDecimal"/>
72 
	<field name="faltas_servidor" class="java.math.BigDecimal"/>
73 
	<group name="unidade_exercicio">
74 
		<groupExpression><![CDATA[$F{unidade}]]></groupExpression>
75 
		<groupHeader>
76 
			<band height="42">
77 
				<textField isStretchWithOverflow="true">
78 
					<reportElement uuid="1b7ae11b-d3df-4108-8e29-221b7e53a9d4" x="0" y="21" width="555" height="20"/>
79 
					<textElement verticalAlignment="Bottom">
80 
						<font fontName="Arial" size="12" isBold="true" isUnderline="true" pdfFontName="Helvetica-Bold"/>
81 
					</textElement>
82 
					<textFieldExpression><![CDATA["UNIDADE: " + $F{unidade}]]></textFieldExpression>
83 
				</textField>
84 
			</band>
85 
		</groupHeader>
86 
	</group>
87 
	<group name="grupo_avaliacao">
88 
		<groupExpression><![CDATA[$F{grupoavaliacao}]]></groupExpression>
89 
		<groupHeader>
90 
			<band height="53">
91 
				<textField>
92 
					<reportElement uuid="f0d83fb9-02c2-42c5-9a2c-d618a8de2580" mode="Opaque" x="0" y="16" width="555" height="16" forecolor="#000000" backcolor="#A9A9A9"/>
93 
					<textElement verticalAlignment="Middle">
94 
						<font fontName="Arial" isBold="true" isUnderline="false" pdfFontName="Helvetica-Bold"/>
95 
					</textElement>
96 
					<textFieldExpression><![CDATA[" GRUPO: " + $F{grupoavaliacao}]]></textFieldExpression>
97 
				</textField>
98 
				<textField>
99 
					<reportElement uuid="f0d83fb9-02c2-42c5-9a2c-d618a8de2580" mode="Opaque" x="0" y="31" width="555" height="16" forecolor="#000000" backcolor="#A9A9A9"/>
100 
					<textElement verticalAlignment="Middle">
101 
						<font fontName="Arial" size="8" isBold="true" isUnderline="false" pdfFontName="Helvetica-Bold"/>
102 
					</textElement>
103 
					<textFieldExpression><![CDATA[" AVALIADOR(A): " + $F{nomeavaliador}]]></textFieldExpression>
104 
				</textField>
105 
			</band>
106 
		</groupHeader>
107 
	</group>
108 
	<background>
109 
		<band splitType="Stretch"/>
110 
	</background>
111 
	<title>
112 
		<band height="145" splitType="Stretch">
113 
			<textField isBlankWhenNull="false">
114 
				<reportElement uuid="7e420030-8524-414a-9258-b8ff749fc009" x="0" y="116" width="555" height="15"/>
115 
				<textElement textAlignment="Center">
116 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
117 
				</textElement>
118 
				<textFieldExpression><![CDATA["CRONOGRAMA: " + $P{pAnoCronograma}]]></textFieldExpression>
119 
			</textField>
120 
			<image hAlign="Right">
121 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="259" y="1" width="48" height="59"/>
122 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.jpg"]]></imageExpression>
123 
			</image>
124 
			<staticText>
125 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="95" width="555" height="16" isPrintWhenDetailOverflows="true"/>
126 
				<textElement textAlignment="Center" verticalAlignment="Top">
127 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
128 
				</textElement>
129 
				<text><![CDATA[RELATÓRIO DE AVALIAÇÃO GERAL]]></text>
130 
			</staticText>
131 
			<staticText>
132 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="64" width="555" height="26"/>
133 
				<textElement textAlignment="Center">
134 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
135 
				</textElement>
136 
				<text><![CDATA[ESTADO DE ALAGOAS
137 
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS]]></text>
138 
			</staticText>
139 
		</band>
140 
	</title>
141 
	<pageHeader>
142 
		<band splitType="Stretch"/>
143 
	</pageHeader>
144 
	<detail>
145 
		<band height="91" splitType="Stretch">
146 
			<rectangle>
147 
				<reportElement uuid="929d9137-2979-443b-a76d-d93458dbea93" x="0" y="0" width="555" height="14" forecolor="#DCDCDC" backcolor="#DCDCDC"/>
148 
				<graphicElement>
149 
					<pen lineWidth="0.0"/>
150 
				</graphicElement>
151 
			</rectangle>
152 
			<textField isStretchWithOverflow="true">
153 
				<reportElement uuid="6061d8f0-769a-4fd2-9713-b0908f153b4c" x="318" y="0" width="55" height="14"/>
154 
				<textElement verticalAlignment="Middle">
155 
					<font fontName="Arial" size="8"/>
156 
				</textElement>
157 
				<textFieldExpression><![CDATA[$F{matricula_servidor}]]></textFieldExpression>
158 
			</textField>
159 
			<textField isStretchWithOverflow="true">
160 
				<reportElement uuid="a92ba739-a606-4b85-8c12-d540a5ba9a08" x="31" y="0" width="205" height="14"/>
161 
				<textElement verticalAlignment="Middle">
162 
					<font fontName="Arial" size="8"/>
163 
				</textElement>
164 
				<textFieldExpression><![CDATA[$F{nomeservidor}]]></textFieldExpression>
165 
			</textField>
166 
			<textField isStretchWithOverflow="true">
167 
				<reportElement uuid="04d5aaaa-8a49-4b1a-bc70-0a51baa44eba" x="431" y="0" width="74" height="14"/>
168 
				<textElement verticalAlignment="Middle">
169 
					<font fontName="Arial" size="8"/>
170 
				</textElement>
171 
				<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>
172 
			</textField>
173 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
174 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" x="63" y="37" width="38" height="14"/>
175 
				<textElement verticalAlignment="Middle">
176 
					<font fontName="Arial" size="8"/>
177 
				</textElement>
178 
				<textFieldExpression><![CDATA[$F{notadesempenho}]]></textFieldExpression>
179 
			</textField>
180 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
181 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" x="176" y="37" width="36" height="14"/>
182 
				<textElement verticalAlignment="Middle">
183 
					<font fontName="Arial" size="8"/>
184 
				</textElement>
185 
				<textFieldExpression><![CDATA[$F{notaassiduidade}]]></textFieldExpression>
186 
			</textField>
187 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
188 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" x="288" y="37" width="36" height="14"/>
189 
				<textElement verticalAlignment="Middle">
190 
					<font fontName="Arial" size="8"/>
191 
				</textElement>
192 
				<textFieldExpression><![CDATA[$F{notaqualificacao}]]></textFieldExpression>
193 
			</textField>
194 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
195 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" x="410" y="37" width="41" height="14"/>
196 
				<textElement verticalAlignment="Middle">
197 
					<font fontName="Arial" size="8"/>
198 
				</textElement>
199 
				<textFieldExpression><![CDATA[$F{pontuacaoextra}]]></textFieldExpression>
200 
			</textField>
201 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
202 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" x="510" y="37" width="45" height="14"/>
203 
				<textElement verticalAlignment="Middle">
204 
					<font fontName="Arial" size="8"/>
205 
				</textElement>
206 
				<textFieldExpression><![CDATA[$F{notafinal}]]></textFieldExpression>
207 
			</textField>
208 
			<staticText>
209 
				<reportElement uuid="0f0b30e9-81e0-45d8-a61b-90a41c3c317c" x="0" y="0" width="30" height="14"/>
210 
				<textElement textAlignment="Right" verticalAlignment="Middle">
211 
					<font fontName="Arial" size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
212 
				</textElement>
213 
				<text><![CDATA[Nome:]]></text>
214 
			</staticText>
215 
			<staticText>
216 
				<reportElement uuid="23f0c781-e4f0-45c5-bd32-15987a7bddde" x="263" y="0" width="54" height="14"/>
217 
				<textElement textAlignment="Right" verticalAlignment="Middle">
218 
					<font fontName="Arial" size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
219 
				</textElement>
220 
				<text><![CDATA[Matrícula:]]></text>
221 
			</staticText>
222 
			<staticText>
223 
				<reportElement uuid="0d2e9575-caaa-4892-87d1-4192e87fa1d1" x="401" y="0" width="29" height="14"/>
224 
				<textElement textAlignment="Right" verticalAlignment="Middle">
225 
					<font fontName="Arial" size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
226 
				</textElement>
227 
				<text><![CDATA[CPF:]]></text>
228 
			</staticText>
229 
			<line>
230 
				<reportElement uuid="0c98e0eb-c48d-4b4c-9a0b-913909cfb210" positionType="Float" x="0" y="88" width="555" height="1" isPrintWhenDetailOverflows="true"/>
231 
				<graphicElement>
232 
					<pen lineWidth="0.5" lineStyle="Dashed"/>
233 
				</graphicElement>
234 
			</line>
235 
			<staticText>
236 
				<reportElement uuid="8923e989-fc9c-45b3-83ba-d971367f36da" x="0" y="19" width="555" height="15"/>
237 
				<textElement textAlignment="Center">
238 
					<font fontName="Arial" size="9" isBold="true" isUnderline="true" pdfFontName="Helvetica-Bold"/>
239 
				</textElement>
240 
				<text><![CDATA[NOTAS]]></text>
241 
			</staticText>
242 
			<staticText>
243 
				<reportElement uuid="0f0b30e9-81e0-45d8-a61b-90a41c3c317c" x="0" y="37" width="62" height="14"/>
244 
				<textElement textAlignment="Right" verticalAlignment="Middle">
245 
					<font fontName="Arial" size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
246 
				</textElement>
247 
				<text><![CDATA[Desempenho:]]></text>
248 
			</staticText>
249 
			<staticText>
250 
				<reportElement uuid="0f0b30e9-81e0-45d8-a61b-90a41c3c317c" x="113" y="37" width="62" height="14"/>
251 
				<textElement textAlignment="Right" verticalAlignment="Middle">
252 
					<font fontName="Arial" size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
253 
				</textElement>
254 
				<text><![CDATA[Assiduidade:]]></text>
255 
			</staticText>
256 
			<staticText>
257 
				<reportElement uuid="0f0b30e9-81e0-45d8-a61b-90a41c3c317c" x="225" y="37" width="62" height="14"/>
258 
				<textElement textAlignment="Right" verticalAlignment="Middle">
259 
					<font fontName="Arial" size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
260 
				</textElement>
261 
				<text><![CDATA[Qualificação:]]></text>
262 
			</staticText>
263 
			<staticText>
264 
				<reportElement uuid="0f0b30e9-81e0-45d8-a61b-90a41c3c317c" x="338" y="37" width="71" height="14"/>
265 
				<textElement textAlignment="Right" verticalAlignment="Middle">
266 
					<font fontName="Arial" size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
267 
				</textElement>
268 
				<text><![CDATA[Pontuação Extra:]]></text>
269 
			</staticText>
270 
			<staticText>
271 
				<reportElement uuid="0f0b30e9-81e0-45d8-a61b-90a41c3c317c" x="461" y="37" width="48" height="14"/>
272 
				<textElement textAlignment="Right" verticalAlignment="Middle">
273 
					<font fontName="Arial" size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
274 
				</textElement>
275 
				<text><![CDATA[Nota Final:]]></text>
276 
			</staticText>
277 
			<subreport>
278 
				<reportElement uuid="300395b1-058c-43c7-b543-effe4bfca979" x="0" y="58" width="555" height="11" isPrintWhenDetailOverflows="true"/>
279 
				<subreportParameter name="pAnoCronograma">
280 
					<subreportParameterExpression><![CDATA[$P{pAnoCronograma}]]></subreportParameterExpression>
281 
				</subreportParameter>
282 
				<subreportParameter name="pSequencialServidorDadoFuncional">
283 
					<subreportParameterExpression><![CDATA[$F{seq_servidor_dadofuncional}]]></subreportParameterExpression>
284 
				</subreportParameter>
285 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
286 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_avaliacao_geral_subreport_qualificacoes_servidor.jasper"]]></subreportExpression>
287 
			</subreport>
288 
			<staticText>
289 
				<reportElement uuid="0f0b30e9-81e0-45d8-a61b-90a41c3c317c" positionType="Float" x="0" y="72" width="90" height="14"/>
290 
				<textElement textAlignment="Right" verticalAlignment="Middle">
291 
					<font fontName="Arial" size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
292 
				</textElement>
293 
				<text><![CDATA[Quantidade de faltas:]]></text>
294 
			</staticText>
295 
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
296 
				<reportElement uuid="c93aa7da-14b7-4d3c-814d-bcdb33b00027" positionType="Float" x="91" y="72" width="39" height="14"/>
297 
				<textElement verticalAlignment="Middle">
298 
					<font fontName="Arial" size="8"/>
299 
				</textElement>
300 
				<textFieldExpression><![CDATA[$F{faltas_servidor}]]></textFieldExpression>
301 
			</textField>
302 
		</band>
303 
	</detail>
304 
	<pageFooter>
305 
		<band height="21">
306 
			<textField evaluationTime="Report" isBlankWhenNull="false">
307 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="502" y="6" width="52" height="15"/>
308 
				<textElement verticalAlignment="Middle">
309 
					<font fontName="Arial" size="6" isBold="false"/>
310 
				</textElement>
311 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
312 
			</textField>
313 
			<textField isBlankWhenNull="false">
314 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="428" y="6" width="73" height="15"/>
315 
				<textElement textAlignment="Right" verticalAlignment="Middle">
316 
					<font fontName="Arial" size="6" isBold="false"/>
317 
				</textElement>
318 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
319 
			</textField>
320 
			<textField isBlankWhenNull="true">
321 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="6" width="386" height="15"/>
322 
				<textElement verticalAlignment="Middle">
323 
					<font fontName="Arial" size="6" isBold="false"/>
324 
				</textElement>
325 
				<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>
326 
			</textField>
327 
		</band>
328 
	</pageFooter>
329 
	<summary>
330 
		<band splitType="Stretch"/>
331 
	</summary>
332 
</jasperReport>