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_qualificacao" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="10e6462f-b0a2-406d-9d69-bee3c0361a4e">
3 
	<property name="ireport.zoom" value="2.853116706110003"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="306"/>
6 
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
7 
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
8 
	</parameter>
9 
	<parameter name="IMAGEM_DIR" class="java.lang.String">
10 
		<defaultValueExpression><![CDATA["C:\\"]]></defaultValueExpression>
11 
	</parameter>
12 
	<parameter name="pNomeUsuario" class="java.lang.String"/>
13 
	<parameter name="pCpfUsuario" class="java.lang.String"/>
14 
	<parameter name="pAnoCronograma" class="java.lang.Long"/>
15 
	<parameter name="pCodigoUnidadeExercicio" class="java.lang.Long"/>
16 
	<parameter name="pSequencialGrupoAvaliacao" class="java.lang.Long"/>
17 
	<parameter name="pMatriculaServidor" class="java.lang.Long"/>
18 
	<queryString>
19 
		<![CDATA[SELECT ad.seq_servidor_dadofuncional,
20 
  	   ad.dsc_unidade_cadastro unidade,
21 
	   ad.dsc_grupo_avaliacao grupoAvaliacao,
22 
	   ad.num_cpf numeroCpf,
23 
	   ad.nom_pessoa nomeServidor,
24 
	   (ad.num_matricula_servidor || '-' || ad.num_digito_matricula) matricula_servidor,
25 
	   ad.num_nota_desempenho notaDesempenho,
26 
	   ad.num_nota_assiduidade notaAssiduidade,
27 
	   ad.num_nota_qualificacao notaQualificacao,
28 
	   ad.num_nota_pontuacao_extra pontuacaoExtra,
29 
	   ad.num_nota_final notaFinal
30 
  FROM sc_rhd.vw_avaliacao_desempenho ad
31 
 WHERE ad.num_ano = $P{pAnoCronograma}
32 
   AND (ad.seq_grupo_avaliacao = $P{pSequencialGrupoAvaliacao} OR $P{pSequencialGrupoAvaliacao} IS NULL)
33 
   AND (ad.cod_unidade_cadastro = $P{pCodigoUnidadeExercicio} OR  $P{pCodigoUnidadeExercicio} IS NULL)
34 
   AND (ad.num_matricula_servidor = $P{pMatriculaServidor} OR  $P{pMatriculaServidor} IS NULL)
35 
 ORDER BY ad.dsc_unidade_cadastro, ad.dsc_grupo_avaliacao, ad.nom_pessoa]]>
36 
	</queryString>
37 
	<field name="seq_servidor_dadofuncional" class="java.lang.Long"/>
38 
	<field name="unidade" class="java.lang.String"/>
39 
	<field name="grupoavaliacao" class="java.lang.String"/>
40 
	<field name="numerocpf" class="java.lang.String"/>
41 
	<field name="nomeservidor" class="java.lang.String"/>
42 
	<field name="matricula_servidor" class="java.lang.String"/>
43 
	<field name="notadesempenho" class="java.math.BigDecimal"/>
44 
	<field name="notaassiduidade" class="java.math.BigDecimal"/>
45 
	<field name="notaqualificacao" class="java.math.BigDecimal"/>
46 
	<field name="pontuacaoextra" class="java.math.BigDecimal"/>
47 
	<field name="notafinal" class="java.math.BigDecimal"/>
48 
	<group name="groupUnidadeExercicio">
49 
		<groupExpression><![CDATA[$F{unidade}]]></groupExpression>
50 
		<groupHeader>
51 
			<band height="29">
52 
				<textField isStretchWithOverflow="true">
53 
					<reportElement uuid="1b7ae11b-d3df-4108-8e29-221b7e53a9d4" x="2" y="4" width="555" height="20"/>
54 
					<textElement verticalAlignment="Bottom">
55 
						<font fontName="Arial" size="12" isBold="true" isUnderline="true" pdfFontName="Helvetica-Bold"/>
56 
					</textElement>
57 
					<textFieldExpression><![CDATA["UNIDADE: " + $F{unidade}]]></textFieldExpression>
58 
				</textField>
59 
			</band>
60 
		</groupHeader>
61 
	</group>
62 
	<group name="groupGrupoAvaliacao">
63 
		<groupExpression><![CDATA[$F{grupoavaliacao}]]></groupExpression>
64 
		<groupHeader>
65 
			<band height="19">
66 
				<textField>
67 
					<reportElement uuid="f0d83fb9-02c2-42c5-9a2c-d618a8de2580" mode="Opaque" x="0" y="0" width="555" height="16" forecolor="#000000" backcolor="#A9A9A9"/>
68 
					<textElement verticalAlignment="Middle">
69 
						<font fontName="Arial" isBold="true" isUnderline="false" pdfFontName="Helvetica-Bold"/>
70 
					</textElement>
71 
					<textFieldExpression><![CDATA[" GRUPO: " + $F{grupoavaliacao}]]></textFieldExpression>
72 
				</textField>
73 
			</band>
74 
		</groupHeader>
75 
	</group>
76 
	<group name="groupServidor">
77 
		<groupExpression><![CDATA[$F{nomeservidor}]]></groupExpression>
78 
		<groupHeader>
79 
			<band height="20">
80 
				<rectangle>
81 
					<reportElement uuid="929d9137-2979-443b-a76d-d93458dbea93" x="0" y="3" width="555" height="14" forecolor="#DCDCDC" backcolor="#DCDCDC"/>
82 
					<graphicElement>
83 
						<pen lineWidth="0.0"/>
84 
					</graphicElement>
85 
				</rectangle>
86 
				<textField>
87 
					<reportElement uuid="8c9e7a92-d83d-4c81-b766-e9a4bd04d45c" x="34" y="3" width="255" height="14"/>
88 
					<textElement verticalAlignment="Middle">
89 
						<font fontName="Arial" size="8" isBold="true"/>
90 
					</textElement>
91 
					<textFieldExpression><![CDATA[$F{nomeservidor}]]></textFieldExpression>
92 
				</textField>
93 
				<staticText>
94 
					<reportElement uuid="adae7f8f-0817-4705-a460-468877d15149" x="2" y="3" width="31" height="14"/>
95 
					<textElement textAlignment="Right" verticalAlignment="Middle">
96 
						<font fontName="Arial" size="8" isBold="true"/>
97 
					</textElement>
98 
					<text><![CDATA[Nome:]]></text>
99 
				</staticText>
100 
				<staticText>
101 
					<reportElement uuid="81850e19-8f8a-4e07-97f2-7bb034d4f33c" x="438" y="3" width="21" height="14"/>
102 
					<textElement textAlignment="Right" verticalAlignment="Middle">
103 
						<font fontName="Arial" size="8" isBold="true"/>
104 
					</textElement>
105 
					<text><![CDATA[CPF:]]></text>
106 
				</staticText>
107 
				<textField pattern="" isBlankWhenNull="true">
108 
					<reportElement uuid="0fad1e92-1edb-48b9-81fd-a72739f06f2f" x="460" y="3" width="92" height="14"/>
109 
					<textElement verticalAlignment="Middle">
110 
						<font fontName="Arial" size="8" isBold="true"/>
111 
					</textElement>
112 
					<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>
113 
				</textField>
114 
				<textField>
115 
					<reportElement uuid="4c6c0c07-6b3e-4497-acaf-1bf017cfd7fc" x="343" y="3" width="66" height="14"/>
116 
					<textElement verticalAlignment="Middle">
117 
						<font fontName="Arial" size="8" isBold="true"/>
118 
					</textElement>
119 
					<textFieldExpression><![CDATA[$F{matricula_servidor}]]></textFieldExpression>
120 
				</textField>
121 
				<staticText>
122 
					<reportElement uuid="972dba30-0b61-4516-831d-dfabb64e7eab" x="300" y="3" width="42" height="14"/>
123 
					<textElement textAlignment="Right" verticalAlignment="Middle">
124 
						<font fontName="Arial" size="8" isBold="true"/>
125 
					</textElement>
126 
					<text><![CDATA[Matrícula:]]></text>
127 
				</staticText>
128 
			</band>
129 
		</groupHeader>
130 
		<groupFooter>
131 
			<band height="28">
132 
				<staticText>
133 
					<reportElement uuid="49351e71-14bd-4688-9d0a-7865b1094ed3" x="447" y="8" width="69" height="14"/>
134 
					<textElement textAlignment="Right">
135 
						<font fontName="Arial" size="8" isBold="true"/>
136 
					</textElement>
137 
					<text><![CDATA[Pontuação Extra:]]></text>
138 
				</staticText>
139 
				<staticText>
140 
					<reportElement uuid="fc69e67e-3889-4564-80cd-e2527e5ee245" x="271" y="8" width="115" height="14"/>
141 
					<textElement textAlignment="Right">
142 
						<font fontName="Arial" size="8" isBold="true"/>
143 
					</textElement>
144 
					<text><![CDATA[Pontuação da Qualificação:]]></text>
145 
				</staticText>
146 
				<line>
147 
					<reportElement uuid="4b7649e6-5f9c-4267-b78e-dad8716e1c3d" positionType="Float" mode="Transparent" x="0" y="24" width="555" height="1"/>
148 
					<graphicElement>
149 
						<pen lineWidth="0.5" lineStyle="Dashed"/>
150 
					</graphicElement>
151 
				</line>
152 
				<textField pattern="#,##0.00">
153 
					<reportElement uuid="fb8706c8-1707-47eb-8125-1afab8e5b931" x="517" y="8" width="38" height="14"/>
154 
					<textElement>
155 
						<font fontName="Arial" size="8" isBold="true"/>
156 
					</textElement>
157 
					<textFieldExpression><![CDATA[$F{pontuacaoextra}]]></textFieldExpression>
158 
				</textField>
159 
				<textField pattern="#,##0.00">
160 
					<reportElement uuid="213bdc21-5420-4819-aaf7-dd1d9327d879" x="387" y="8" width="40" height="14"/>
161 
					<textElement>
162 
						<font fontName="Arial" size="8" isBold="true"/>
163 
					</textElement>
164 
					<textFieldExpression><![CDATA[$F{notaqualificacao}]]></textFieldExpression>
165 
				</textField>
166 
			</band>
167 
		</groupFooter>
168 
	</group>
169 
	<background>
170 
		<band splitType="Stretch"/>
171 
	</background>
172 
	<title>
173 
		<band height="141" splitType="Stretch">
174 
			<image hAlign="Right">
175 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="259" y="1" width="48" height="59"/>
176 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.jpg"]]></imageExpression>
177 
			</image>
178 
			<staticText>
179 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="104" width="555" height="16" isPrintWhenDetailOverflows="true"/>
180 
				<textElement textAlignment="Center" verticalAlignment="Top">
181 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
182 
				</textElement>
183 
				<text><![CDATA[RELATÓRIO DE QUALIFICAÇÃO]]></text>
184 
			</staticText>
185 
			<textField isBlankWhenNull="false">
186 
				<reportElement uuid="7e420030-8524-414a-9258-b8ff749fc009" x="0" y="125" width="555" height="15"/>
187 
				<textElement textAlignment="Center">
188 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
189 
				</textElement>
190 
				<textFieldExpression><![CDATA["CRONOGRAMA: " + $P{pAnoCronograma}]]></textFieldExpression>
191 
			</textField>
192 
			<staticText>
193 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="69" width="555" height="26"/>
194 
				<textElement textAlignment="Center">
195 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
196 
				</textElement>
197 
				<text><![CDATA[ESTADO DE ALAGOAS
198 
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS]]></text>
199 
			</staticText>
200 
		</band>
201 
	</title>
202 
	<detail>
203 
		<band height="12" splitType="Stretch">
204 
			<subreport>
205 
				<reportElement uuid="300395b1-058c-43c7-b543-effe4bfca979" x="0" y="0" width="555" height="11" isPrintWhenDetailOverflows="true"/>
206 
				<subreportParameter name="pAnoCronograma">
207 
					<subreportParameterExpression><![CDATA[$P{pAnoCronograma}]]></subreportParameterExpression>
208 
				</subreportParameter>
209 
				<subreportParameter name="pSequencialServidorDadoFuncional">
210 
					<subreportParameterExpression><![CDATA[$F{seq_servidor_dadofuncional}]]></subreportParameterExpression>
211 
				</subreportParameter>
212 
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
213 
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_avaliacao_geral_subreport_qualificacoes_servidor.jasper"]]></subreportExpression>
214 
			</subreport>
215 
		</band>
216 
	</detail>
217 
	<pageFooter>
218 
		<band height="28" splitType="Stretch">
219 
			<textField evaluationTime="Report" isBlankWhenNull="false">
220 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="527" y="6" width="27" height="15"/>
221 
				<textElement verticalAlignment="Middle">
222 
					<font fontName="Arial" size="6" isBold="false"/>
223 
				</textElement>
224 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
225 
			</textField>
226 
			<textField isBlankWhenNull="false">
227 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="452" y="6" width="73" height="15"/>
228 
				<textElement textAlignment="Right" verticalAlignment="Middle">
229 
					<font fontName="Arial" size="6" isBold="false"/>
230 
				</textElement>
231 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
232 
			</textField>
233 
			<textField isBlankWhenNull="true">
234 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="6" width="374" height="15"/>
235 
				<textElement verticalAlignment="Middle">
236 
					<font fontName="Arial" size="6" isBold="false"/>
237 
				</textElement>
238 
				<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>
239 
			</textField>
240 
		</band>
241 
	</pageFooter>
242 
</jasperReport>