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_observacoes" 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.4522712143931042"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="608"/>
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 
  ad.num_cpf numeroCpf,
30 
  ad.nom_pessoa nomeServidor,
31 
(ad.num_matricula_servidor || '-' || ad.num_digito_matricula) matricula_servidor,
32 
 qd.dsc_questao_avaliadesemp pergunta,
33 
 ade.dsc_resposta_aberta resposta
34 
  FROM sc_rhd.vw_avaliacao_desempenho ad
35 
  JOIN sc_rhd.rhd_avaliacao_desempenho ade ON (ade.seq_servidor_dadofuncional = ad.seq_servidor_dadofuncional)
36 
  JOIN sc_rhd.rhd_questao_avaliadesemp qd ON (ade.seq_questao_avaliacao = qd.seq_questao_avaliadesemp AND qd.tip_avaliacao_desempenho = 'U' and qd.tip_questao = 'A')
37 
where ad.num_ano = $P{pAnoCronograma}
38 
and (ad.seq_grupo_avaliacao = $P{pSequencialGrupoAvaliacao} OR $P{pSequencialGrupoAvaliacao} IS NULL)
39 
and (ad.cod_unidade_cadastro = $P{pCodigoUnidadeExercicio} OR $P{pCodigoUnidadeExercicio} IS NULL)
40 
and (ad.num_matricula_servidor = $P{pMatriculaServidor} OR $P{pMatriculaServidor} IS NULL)
41 
ORDER BY ad.dsc_unidade_cadastro, ad.dsc_grupo_avaliacao, ad.nom_pessoa]]>
42 
	</queryString>
43 
	<field name="seq_servidor_dadofuncional" class="java.lang.Long"/>
44 
	<field name="unidade" class="java.lang.String"/>
45 
	<field name="grupoavaliacao" class="java.lang.String"/>
46 
	<field name="numerocpf" class="java.lang.String"/>
47 
	<field name="nomeservidor" class="java.lang.String"/>
48 
	<field name="matricula_servidor" class="java.lang.String"/>
49 
	<field name="pergunta" class="java.lang.String"/>
50 
	<field name="resposta" class="java.lang.String"/>
51 
	<group name="unidade_exercicio">
52 
		<groupExpression><![CDATA[$F{unidade}]]></groupExpression>
53 
		<groupHeader>
54 
			<band height="42">
55 
				<textField isStretchWithOverflow="true">
56 
					<reportElement uuid="1b7ae11b-d3df-4108-8e29-221b7e53a9d4" x="0" y="21" width="555" height="20"/>
57 
					<textElement verticalAlignment="Bottom">
58 
						<font fontName="Arial" size="12" isBold="true" isUnderline="true" pdfFontName="Helvetica-Bold"/>
59 
					</textElement>
60 
					<textFieldExpression><![CDATA["UNIDADE: " + $F{unidade}]]></textFieldExpression>
61 
				</textField>
62 
			</band>
63 
		</groupHeader>
64 
	</group>
65 
	<group name="grupo_avaliacao">
66 
		<groupExpression><![CDATA[$F{grupoavaliacao}]]></groupExpression>
67 
		<groupHeader>
68 
			<band height="26">
69 
				<textField>
70 
					<reportElement uuid="f0d83fb9-02c2-42c5-9a2c-d618a8de2580" mode="Opaque" x="0" y="7" width="555" height="16" forecolor="#000000" backcolor="#A9A9A9"/>
71 
					<textElement verticalAlignment="Middle">
72 
						<font fontName="Arial" isBold="true" isUnderline="false" pdfFontName="Helvetica-Bold"/>
73 
					</textElement>
74 
					<textFieldExpression><![CDATA[" GRUPO: " + $F{grupoavaliacao}]]></textFieldExpression>
75 
				</textField>
76 
			</band>
77 
		</groupHeader>
78 
	</group>
79 
	<group name="servidor_avaliacao">
80 
		<groupExpression><![CDATA[$F{seq_servidor_dadofuncional}]]></groupExpression>
81 
		<groupHeader>
82 
			<band height="18">
83 
				<rectangle>
84 
					<reportElement uuid="929d9137-2979-443b-a76d-d93458dbea93" x="0" y="0" width="555" height="14" forecolor="#DCDCDC" backcolor="#DCDCDC"/>
85 
					<graphicElement>
86 
						<pen lineWidth="0.0"/>
87 
					</graphicElement>
88 
				</rectangle>
89 
				<textField isStretchWithOverflow="true">
90 
					<reportElement uuid="6061d8f0-769a-4fd2-9713-b0908f153b4c" x="316" y="0" width="55" height="14"/>
91 
					<textElement verticalAlignment="Middle">
92 
						<font fontName="Arial" size="8"/>
93 
					</textElement>
94 
					<textFieldExpression><![CDATA[$F{matricula_servidor}]]></textFieldExpression>
95 
				</textField>
96 
				<textField isStretchWithOverflow="true">
97 
					<reportElement uuid="a92ba739-a606-4b85-8c12-d540a5ba9a08" x="31" y="0" width="216" height="14"/>
98 
					<textElement verticalAlignment="Middle">
99 
						<font fontName="Arial" size="8"/>
100 
					</textElement>
101 
					<textFieldExpression><![CDATA[$F{nomeservidor}]]></textFieldExpression>
102 
				</textField>
103 
				<textField isStretchWithOverflow="true">
104 
					<reportElement uuid="04d5aaaa-8a49-4b1a-bc70-0a51baa44eba" x="429" y="0" width="74" height="14"/>
105 
					<textElement verticalAlignment="Middle">
106 
						<font fontName="Arial" size="8"/>
107 
					</textElement>
108 
					<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>
109 
				</textField>
110 
				<staticText>
111 
					<reportElement uuid="23f0c781-e4f0-45c5-bd32-15987a7bddde" x="261" y="0" width="54" height="14"/>
112 
					<textElement textAlignment="Right" verticalAlignment="Middle">
113 
						<font fontName="Arial" size="8" isBold="true"/>
114 
					</textElement>
115 
					<text><![CDATA[Matrícula:]]></text>
116 
				</staticText>
117 
				<staticText>
118 
					<reportElement uuid="0d2e9575-caaa-4892-87d1-4192e87fa1d1" x="399" y="0" width="29" height="14"/>
119 
					<textElement textAlignment="Right" verticalAlignment="Middle">
120 
						<font fontName="Arial" size="8" isBold="true"/>
121 
					</textElement>
122 
					<text><![CDATA[CPF:]]></text>
123 
				</staticText>
124 
				<staticText>
125 
					<reportElement uuid="0f0b30e9-81e0-45d8-a61b-90a41c3c317c" x="0" y="0" width="30" height="14"/>
126 
					<textElement textAlignment="Right" verticalAlignment="Middle">
127 
						<font fontName="Arial" size="8" isBold="true"/>
128 
					</textElement>
129 
					<text><![CDATA[Nome:]]></text>
130 
				</staticText>
131 
			</band>
132 
		</groupHeader>
133 
	</group>
134 
	<background>
135 
		<band splitType="Stretch"/>
136 
	</background>
137 
	<title>
138 
		<band height="145" splitType="Stretch">
139 
			<textField isBlankWhenNull="false">
140 
				<reportElement uuid="7e420030-8524-414a-9258-b8ff749fc009" x="0" y="116" width="555" height="15"/>
141 
				<textElement textAlignment="Center">
142 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
143 
				</textElement>
144 
				<textFieldExpression><![CDATA["CRONOGRAMA: " + $P{pAnoCronograma}]]></textFieldExpression>
145 
			</textField>
146 
			<image hAlign="Right">
147 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="259" y="1" width="48" height="59"/>
148 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.jpg"]]></imageExpression>
149 
			</image>
150 
			<staticText>
151 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="95" width="555" height="16" isPrintWhenDetailOverflows="true"/>
152 
				<textElement textAlignment="Center" verticalAlignment="Top">
153 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
154 
				</textElement>
155 
				<text><![CDATA[RELATÓRIO DE OBSERVAÇÕES]]></text>
156 
			</staticText>
157 
			<staticText>
158 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="64" width="555" height="26"/>
159 
				<textElement textAlignment="Center">
160 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
161 
				</textElement>
162 
				<text><![CDATA[ESTADO DE ALAGOAS
163 
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS]]></text>
164 
			</staticText>
165 
		</band>
166 
	</title>
167 
	<pageHeader>
168 
		<band splitType="Stretch"/>
169 
	</pageHeader>
170 
	<detail>
171 
		<band height="38" splitType="Stretch">
172 
			<line>
173 
				<reportElement uuid="0c98e0eb-c48d-4b4c-9a0b-913909cfb210" positionType="Float" x="0" y="32" width="555" height="1" isPrintWhenDetailOverflows="true"/>
174 
				<graphicElement>
175 
					<pen lineWidth="0.5" lineStyle="Dashed"/>
176 
				</graphicElement>
177 
			</line>
178 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
179 
				<reportElement uuid="11d1dab6-e787-499e-aa67-594ba712691c" positionType="Float" x="45" y="0" width="500" height="14" isPrintWhenDetailOverflows="true"/>
180 
				<textElement verticalAlignment="Middle">
181 
					<font fontName="Arial" size="8"/>
182 
				</textElement>
183 
				<textFieldExpression><![CDATA[$F{pergunta}]]></textFieldExpression>
184 
			</textField>
185 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
186 
				<reportElement uuid="efa4cb36-bb17-4826-895a-abdfb4ec1267" positionType="Float" x="45" y="14" width="500" height="14" isPrintWhenDetailOverflows="true"/>
187 
				<textElement verticalAlignment="Middle">
188 
					<font fontName="Arial" size="8"/>
189 
				</textElement>
190 
				<textFieldExpression><![CDATA[$F{resposta}]]></textFieldExpression>
191 
			</textField>
192 
			<staticText>
193 
				<reportElement uuid="0f0b30e9-81e0-45d8-a61b-90a41c3c317c" positionType="Float" x="1" y="0" width="42" height="14"/>
194 
				<textElement textAlignment="Right" verticalAlignment="Middle">
195 
					<font fontName="Arial" size="8" isBold="true"/>
196 
				</textElement>
197 
				<text><![CDATA[Pergunta:]]></text>
198 
			</staticText>
199 
			<staticText>
200 
				<reportElement uuid="0f0b30e9-81e0-45d8-a61b-90a41c3c317c" positionType="Float" x="1" y="14" width="42" height="14"/>
201 
				<textElement textAlignment="Right" verticalAlignment="Middle">
202 
					<font fontName="Arial" size="8" isBold="true"/>
203 
				</textElement>
204 
				<text><![CDATA[Resposta:]]></text>
205 
			</staticText>
206 
		</band>
207 
	</detail>
208 
	<pageFooter>
209 
		<band height="19">
210 
			<textField evaluationTime="Report" isBlankWhenNull="false">
211 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="502" y="4" width="52" height="15"/>
212 
				<textElement verticalAlignment="Middle">
213 
					<font fontName="Arial" size="6" isBold="false"/>
214 
				</textElement>
215 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
216 
			</textField>
217 
			<textField isBlankWhenNull="false">
218 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="428" y="4" width="73" height="15"/>
219 
				<textElement textAlignment="Right" verticalAlignment="Middle">
220 
					<font fontName="Arial" size="6" isBold="false"/>
221 
				</textElement>
222 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
223 
			</textField>
224 
			<textField isBlankWhenNull="true">
225 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="4" width="374" height="15"/>
226 
				<textElement verticalAlignment="Middle">
227 
					<font fontName="Arial" size="6" isBold="false"/>
228 
				</textElement>
229 
				<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>
230 
			</textField>
231 
		</band>
232 
	</pageFooter>
233 
	<summary>
234 
		<band splitType="Stretch"/>
235 
	</summary>
236 
</jasperReport>