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_reconsideracao" 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.143588810000003"/>
4 
	<property name="ireport.x" value="8"/>
5 
	<property name="ireport.y" value="310"/>
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 
		<defaultValueExpression><![CDATA[2014L]]></defaultValueExpression>
16 
	</parameter>
17 
	<parameter name="pCodigoUnidadeExercicio" class="java.lang.Long"/>
18 
	<parameter name="pSequencialGrupoAvaliacao" class="java.lang.Long"/>
19 
	<parameter name="pMatriculaServidor" class="java.lang.Long"/>
20 
	<queryString>
21 
		<![CDATA[SELECT DISTINCT
22 
       (SELECT vu.dsc_unidade FROM sc_srv.vw_unidade vu WHERE vu.cod_unidade = ga.cod_unidade_cadastro) AS descricao_unidade,
23 
       ga.dsc_grupo_avaliacao AS grupo_avaliacao,
24 
       (SELECT ws.nom_pessoa FROM sc_srv.vw_servidor ws WHERE ws.seq_pessoa_servidor = vsd.seq_pessoa_servidor) AS nom_servidor,
25 
       (vsd.num_matricula_servidor || '-' || vsd.num_digito_matricula) AS matricula_servidor,
26 
       (SELECT ws.num_cpf FROM sc_srv.vw_servidor ws WHERE ws.seq_pessoa_servidor = vsd.seq_pessoa_servidor) AS cpf_servidor,
27 
       reconsideracao.tip_revisao AS tipo_revisao_solicitacao,
28 
       (CASE WHEN reconsideracao.tip_avaliacao = 'D' THEN 'Desempenho'
29 
             WHEN reconsideracao.tip_avaliacao = 'A' THEN 'Assiduidade'
30 
             WHEN reconsideracao.tip_avaliacao = 'Q' THEN 'Qualificação' END) tipo_avaliacao,
31 
       (CASE WHEN reconsideracao.tip_avaliacao = 'D' THEN rqa.dsc_questao_avaliadesemp ELSE NULL END) AS descricao_questao,
32 
       reconsideracao.num_nota_avaliacao nota_avaliacao,
33 
       reconsideracao.dth_cadastro AS data_solicitacao,
34 
       (CASE WHEN reconsideracao.tip_avaliacao = 'D' THEN rsa.dsc_solicitacao_revisao ELSE reconsideracao.dsc_solicitacao_revisavaliac END) AS descricao_solicitacao,
35 
       (CASE WHEN reconsideracao.tip_avaliacao = 'D' THEN rsa.dsc_resposta_solicitacao ELSE reconsideracao.dsc_resposta_solicitacao END) AS descricao_resposta_solicitacao
36 
  FROM sc_rhd.rhd_grupo_avaliacao ga
37 
  INNER JOIN sc_rhd.rhd_servidor_avaliacao sa ON sa.seq_grupo_avaliacao = ga.seq_grupo_avaliacao
38 
  INNER JOIN sc_srv.vw_servidor_dadofuncional vsd ON sa.seq_servidor_dadofuncional = vsd.seq_servidor_dadofuncional
39 
  INNER JOIN sc_rhd.rhd_solicitacao_revisavaliac reconsideracao ON (sa.seq_servidor_dadofuncional = reconsideracao.seq_servidor_dadofuncional AND reconsideracao.num_ano = sa.num_ano AND reconsideracao.tip_revisao = 'R')
40 
  LEFT JOIN sc_rhd.rhd_solrevisaval_avalidesemp rsa ON (reconsideracao.seq_solicitacao_revisavaliac = rsa.seq_solicitacao_revisavaliac)
41 
  LEFT JOIN sc_rhd.rhd_avaliacao_desempenho rad ON (rsa.seq_avaliacao_desempenho = rad.seq_avaliacao_desempenho)
42 
  LEFT JOIN sc_rhd.rhd_questao_avaliadesemp rqa ON (rad.seq_questao_avaliacao = rqa.seq_questao_avaliadesemp)
43 
WHERE sa.num_ano = $P{pAnoCronograma}
44 
  AND EXISTS (SELECT 1 FROM sc_rhd.rhd_solicitacao_revisavaliac a WHERE a.seq_servidor_dadofuncional = sa.seq_servidor_dadofuncional)
45 
AND (ga.cod_unidade_cadastro = $P{pCodigoUnidadeExercicio} OR $P{pCodigoUnidadeExercicio} IS NULL)
46 
AND (ga.seq_grupo_avaliacao = $P{pSequencialGrupoAvaliacao} OR $P{pSequencialGrupoAvaliacao} IS NULL)
47 
AND (vsd.num_matricula_servidor = $P{pMatriculaServidor} OR $P{pMatriculaServidor} IS NULL)
48 
UNION
49 
SELECT DISTINCT
50 
       (SELECT vu.dsc_unidade FROM sc_srv.vw_unidade vu WHERE vu.cod_unidade = ga.cod_unidade_cadastro) AS descricao_unidade,
51 
       ga.dsc_grupo_avaliacao AS grupo_avaliacao,
52 
       (SELECT ws.nom_pessoa FROM sc_srv.vw_servidor ws WHERE ws.seq_pessoa_servidor = vsd.seq_pessoa_servidor) AS nom_servidor,
53 
       (vsd.num_matricula_servidor || '-' || vsd.num_digito_matricula) AS matricula_servidor,
54 
       (SELECT ws.num_cpf FROM sc_srv.vw_servidor ws WHERE ws.seq_pessoa_servidor = vsd.seq_pessoa_servidor) AS cpf_servidor,
55 
       recurso.tip_revisao AS tipo_revisao_solicitacao,
56 
       (CASE WHEN recurso.tip_avaliacao = 'D' THEN 'Desempenho'
57 
             WHEN recurso.tip_avaliacao = 'A' THEN 'Assiduidade'
58 
             WHEN recurso.tip_avaliacao = 'Q' THEN 'Qualificação' END) tipo_avaliacao_recurso,
59 
       (CASE WHEN recurso.tip_avaliacao = 'D' THEN rqa.dsc_questao_avaliadesemp ELSE NULL END) AS descricao_questao,
60 
       recurso.num_nota_avaliacao AS nota_avaliacao,
61 
       recurso.dth_cadastro AS data_solicitacao,
62 
       (CASE WHEN recurso.tip_avaliacao = 'D' THEN rsa.dsc_solicitacao_revisao ELSE recurso.dsc_solicitacao_revisavaliac END) AS descricao_solicitacao,
63 
       (CASE WHEN recurso.tip_avaliacao = 'D' THEN rsa.dsc_resposta_solicitacao ELSE recurso.dsc_resposta_solicitacao END) AS descricao_resposta_solicitacao
64 
  FROM sc_rhd.rhd_grupo_avaliacao ga
65 
  INNER JOIN sc_rhd.rhd_servidor_avaliacao sa ON sa.seq_grupo_avaliacao = ga.seq_grupo_avaliacao
66 
  INNER JOIN sc_srv.vw_servidor_dadofuncional vsd ON sa.seq_servidor_dadofuncional = vsd.seq_servidor_dadofuncional
67 
  INNER JOIN sc_rhd.rhd_solicitacao_revisavaliac recurso ON (sa.seq_servidor_dadofuncional = recurso.seq_servidor_dadofuncional AND recurso.num_ano = sa.num_ano AND recurso.tip_revisao = 'U')
68 
  LEFT JOIN sc_rhd.rhd_solrevisaval_avalidesemp rsa ON (recurso.seq_solicitacao_revisavaliac = rsa.seq_solicitacao_revisavaliac)
69 
  LEFT JOIN sc_rhd.rhd_avaliacao_desempenho rad ON (rsa.seq_avaliacao_desempenho = rad.seq_avaliacao_desempenho)
70 
  LEFT JOIN sc_rhd.rhd_questao_avaliadesemp rqa ON (rad.seq_questao_avaliacao = rqa.seq_questao_avaliadesemp)
71 
WHERE sa.num_ano = $P{pAnoCronograma}
72 
  AND EXISTS (SELECT 1 FROM sc_rhd.rhd_solicitacao_revisavaliac a WHERE a.seq_servidor_dadofuncional = sa.seq_servidor_dadofuncional)
73 
AND (ga.cod_unidade_cadastro = $P{pCodigoUnidadeExercicio} OR $P{pCodigoUnidadeExercicio} IS NULL)
74 
AND (ga.seq_grupo_avaliacao = $P{pSequencialGrupoAvaliacao} OR $P{pSequencialGrupoAvaliacao} IS NULL)
75 
AND (vsd.num_matricula_servidor = $P{pMatriculaServidor} OR $P{pMatriculaServidor} IS NULL)
76 
ORDER BY descricao_unidade, grupo_avaliacao, nom_servidor, tipo_revisao_solicitacao, data_solicitacao]]>
77 
	</queryString>
78 
	<field name="descricao_unidade" class="java.lang.String"/>
79 
	<field name="grupo_avaliacao" class="java.lang.String"/>
80 
	<field name="nom_servidor" class="java.lang.String"/>
81 
	<field name="matricula_servidor" class="java.lang.String"/>
82 
	<field name="cpf_servidor" class="java.lang.String"/>
83 
	<field name="tipo_revisao_solicitacao" class="java.lang.String"/>
84 
	<field name="tipo_avaliacao" class="java.lang.String"/>
85 
	<field name="descricao_questao" class="java.lang.String"/>
86 
	<field name="nota_avaliacao" class="java.math.BigDecimal"/>
87 
	<field name="data_solicitacao" class="java.sql.Timestamp"/>
88 
	<field name="descricao_solicitacao" class="java.lang.String"/>
89 
	<field name="descricao_resposta_solicitacao" class="java.lang.String"/>
90 
	<group name="groupUnidadeExercicio">
91 
		<groupExpression><![CDATA[$F{descricao_unidade}]]></groupExpression>
92 
		<groupHeader>
93 
			<band height="28">
94 
				<textField isStretchWithOverflow="true">
95 
					<reportElement uuid="1b7ae11b-d3df-4108-8e29-221b7e53a9d4" x="0" y="4" width="555" height="20"/>
96 
					<textElement verticalAlignment="Bottom">
97 
						<font fontName="Arial" size="12" isBold="true" isUnderline="true" pdfFontName="Helvetica-Bold"/>
98 
					</textElement>
99 
					<textFieldExpression><![CDATA["UNIDADE: " + $F{descricao_unidade}]]></textFieldExpression>
100 
				</textField>
101 
			</band>
102 
		</groupHeader>
103 
	</group>
104 
	<group name="groupGrupoAvaliacao">
105 
		<groupExpression><![CDATA[$F{grupo_avaliacao}]]></groupExpression>
106 
		<groupHeader>
107 
			<band height="19">
108 
				<textField>
109 
					<reportElement uuid="f0d83fb9-02c2-42c5-9a2c-d618a8de2580" mode="Opaque" x="0" y="0" width="555" height="16" forecolor="#000000" backcolor="#A9A9A9"/>
110 
					<textElement verticalAlignment="Middle">
111 
						<font fontName="Arial" isBold="true" isUnderline="false" pdfFontName="Helvetica-Bold"/>
112 
					</textElement>
113 
					<textFieldExpression><![CDATA[" GRUPO: " + $F{grupo_avaliacao}]]></textFieldExpression>
114 
				</textField>
115 
			</band>
116 
		</groupHeader>
117 
	</group>
118 
	<group name="groupServidor">
119 
		<groupExpression><![CDATA[$F{nom_servidor}]]></groupExpression>
120 
		<groupHeader>
121 
			<band height="16">
122 
				<rectangle>
123 
					<reportElement uuid="929d9137-2979-443b-a76d-d93458dbea93" x="0" y="0" width="555" height="14" forecolor="#DCDCDC" backcolor="#DCDCDC"/>
124 
					<graphicElement>
125 
						<pen lineWidth="0.0"/>
126 
					</graphicElement>
127 
				</rectangle>
128 
				<textField>
129 
					<reportElement uuid="8c9e7a92-d83d-4c81-b766-e9a4bd04d45c" x="32" y="0" width="255" height="14"/>
130 
					<textElement verticalAlignment="Middle">
131 
						<font fontName="Arial" size="8" isBold="true"/>
132 
					</textElement>
133 
					<textFieldExpression><![CDATA[$F{nom_servidor}]]></textFieldExpression>
134 
				</textField>
135 
				<staticText>
136 
					<reportElement uuid="adae7f8f-0817-4705-a460-468877d15149" x="1" y="0" width="30" height="14"/>
137 
					<textElement textAlignment="Right" verticalAlignment="Middle">
138 
						<font fontName="Arial" size="8" isBold="true"/>
139 
					</textElement>
140 
					<text><![CDATA[Nome:]]></text>
141 
				</staticText>
142 
				<staticText>
143 
					<reportElement uuid="81850e19-8f8a-4e07-97f2-7bb034d4f33c" x="438" y="0" width="21" height="14"/>
144 
					<textElement textAlignment="Right" verticalAlignment="Middle">
145 
						<font fontName="Arial" size="8" isBold="true"/>
146 
					</textElement>
147 
					<text><![CDATA[CPF:]]></text>
148 
				</staticText>
149 
				<textField pattern="" isBlankWhenNull="true">
150 
					<reportElement uuid="0fad1e92-1edb-48b9-81fd-a72739f06f2f" x="460" y="0" width="89" height="14"/>
151 
					<textElement verticalAlignment="Middle">
152 
						<font fontName="Arial" size="8" isBold="true"/>
153 
					</textElement>
154 
					<textFieldExpression><![CDATA[($F{cpf_servidor} == null)? null : (($F{cpf_servidor}.trim().length() == 11)? $F{cpf_servidor}.trim().replaceAll("(\\d{3})(\\d{3})(\\d{3})(\\d{2})", "$1.$2.$3-$4") : $F{cpf_servidor})]]></textFieldExpression>
155 
				</textField>
156 
				<textField>
157 
					<reportElement uuid="4c6c0c07-6b3e-4497-acaf-1bf017cfd7fc" x="343" y="0" width="66" height="14"/>
158 
					<textElement verticalAlignment="Middle">
159 
						<font fontName="Arial" size="8" isBold="true"/>
160 
					</textElement>
161 
					<textFieldExpression><![CDATA[$F{matricula_servidor}]]></textFieldExpression>
162 
				</textField>
163 
				<staticText>
164 
					<reportElement uuid="972dba30-0b61-4516-831d-dfabb64e7eab" x="300" y="0" width="42" height="14"/>
165 
					<textElement textAlignment="Right" verticalAlignment="Middle">
166 
						<font fontName="Arial" size="8" isBold="true"/>
167 
					</textElement>
168 
					<text><![CDATA[Matrícula:]]></text>
169 
				</staticText>
170 
			</band>
171 
		</groupHeader>
172 
	</group>
173 
	<group name="groupTipoRevisaoSolicitacao">
174 
		<groupExpression><![CDATA[$F{tipo_revisao_solicitacao}]]></groupExpression>
175 
		<groupHeader>
176 
			<band height="24">
177 
				<textField>
178 
					<reportElement uuid="c617c15b-b4d4-4423-9c6b-464e8ad908ca" x="0" y="6" width="554" height="14"/>
179 
					<textElement textAlignment="Center" verticalAlignment="Middle">
180 
						<font fontName="Arial" isBold="true" isUnderline="true"/>
181 
					</textElement>
182 
					<textFieldExpression><![CDATA[$F{tipo_revisao_solicitacao}.equals("R")? "RECONSIDERAÇÕES" : "RECURSOS"]]></textFieldExpression>
183 
				</textField>
184 
			</band>
185 
		</groupHeader>
186 
	</group>
187 
	<background>
188 
		<band splitType="Stretch"/>
189 
	</background>
190 
	<title>
191 
		<band height="146">
192 
			<staticText>
193 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="68" 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 
			<image hAlign="Right">
201 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="259" y="0" width="48" height="59"/>
202 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.jpg"]]></imageExpression>
203 
			</image>
204 
			<textField isBlankWhenNull="false">
205 
				<reportElement uuid="7e420030-8524-414a-9258-b8ff749fc009" x="0" y="124" width="555" height="15"/>
206 
				<textElement textAlignment="Center">
207 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
208 
				</textElement>
209 
				<textFieldExpression><![CDATA["CRONOGRAMA: " + $P{pAnoCronograma}]]></textFieldExpression>
210 
			</textField>
211 
			<staticText>
212 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="103" width="555" height="16" isPrintWhenDetailOverflows="true"/>
213 
				<textElement textAlignment="Center" verticalAlignment="Top">
214 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
215 
				</textElement>
216 
				<text><![CDATA[RELATÓRIO DE RECONSIDERAÇÕES]]></text>
217 
			</staticText>
218 
		</band>
219 
	</title>
220 
	<detail>
221 
		<band height="17" splitType="Stretch">
222 
			<staticText>
223 
				<reportElement uuid="125facc0-bf21-4b1d-a43f-bac7729ace28" x="0" y="1" width="68" height="14"/>
224 
				<textElement textAlignment="Right" verticalAlignment="Middle">
225 
					<font fontName="Arial" size="8"/>
226 
				</textElement>
227 
				<text><![CDATA[Tipo da Avaliação:]]></text>
228 
			</staticText>
229 
			<staticText>
230 
				<reportElement uuid="26496a34-1854-4db7-afaf-eaa143885716" x="290" y="1" width="25" height="14"/>
231 
				<textElement textAlignment="Right" verticalAlignment="Middle">
232 
					<font fontName="Arial" size="8"/>
233 
				</textElement>
234 
				<text><![CDATA[Nota:]]></text>
235 
			</staticText>
236 
			<staticText>
237 
				<reportElement uuid="7b860212-567b-4ddc-aec9-c70471604b9d" x="390" y="1" width="75" height="14"/>
238 
				<textElement textAlignment="Right" verticalAlignment="Middle">
239 
					<font fontName="Arial" size="8"/>
240 
				</textElement>
241 
				<text><![CDATA[Data da Solicitação:]]></text>
242 
			</staticText>
243 
			<textField>
244 
				<reportElement uuid="11ac78d4-98c2-4b31-9fc5-392d67a7290f" x="70" y="1" width="216" height="14"/>
245 
				<textElement verticalAlignment="Middle">
246 
					<font fontName="Arial" size="8"/>
247 
				</textElement>
248 
				<textFieldExpression><![CDATA[$F{tipo_avaliacao}]]></textFieldExpression>
249 
			</textField>
250 
			<textField pattern="#,##0.00">
251 
				<reportElement uuid="1cdc1f8c-8d59-4664-b1dc-bde632d60c76" x="316" y="1" width="60" height="14"/>
252 
				<textElement verticalAlignment="Middle">
253 
					<font fontName="Arial" size="8"/>
254 
				</textElement>
255 
				<textFieldExpression><![CDATA[$F{nota_avaliacao}]]></textFieldExpression>
256 
			</textField>
257 
			<textField pattern="dd/MM/yyyy">
258 
				<reportElement uuid="ad27e913-765e-4479-88b5-62ee5b884609" x="466" y="1" width="90" height="14"/>
259 
				<textElement verticalAlignment="Middle">
260 
					<font fontName="Arial" size="8"/>
261 
				</textElement>
262 
				<textFieldExpression><![CDATA[$F{data_solicitacao}]]></textFieldExpression>
263 
			</textField>
264 
		</band>
265 
		<band height="20">
266 
			<printWhenExpression><![CDATA["Desempenho".equals($F{tipo_avaliacao})]]></printWhenExpression>
267 
			<staticText>
268 
				<reportElement uuid="1dcf3e47-2f39-43dd-a350-17de319a6dd2" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="0" width="43" height="14"/>
269 
				<textElement textAlignment="Right" verticalAlignment="Middle">
270 
					<font fontName="Arial" size="8"/>
271 
				</textElement>
272 
				<text><![CDATA[Questão:]]></text>
273 
			</staticText>
274 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
275 
				<reportElement uuid="e497a9c2-0ff2-4efd-a0dc-31a751bb22d0" positionType="Float" stretchType="RelativeToBandHeight" x="47" y="0" width="508" height="14"/>
276 
				<textElement textAlignment="Justified" verticalAlignment="Middle">
277 
					<font fontName="Arial" size="8" isPdfEmbedded="false"/>
278 
				</textElement>
279 
				<textFieldExpression><![CDATA[$F{descricao_questao}]]></textFieldExpression>
280 
			</textField>
281 
		</band>
282 
		<band height="20">
283 
			<staticText>
284 
				<reportElement uuid="72feed84-b505-4296-86e8-be9cca0348b2" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="0" width="43" height="14"/>
285 
				<textElement textAlignment="Right" verticalAlignment="Middle">
286 
					<font fontName="Arial" size="8"/>
287 
				</textElement>
288 
				<text><![CDATA[Solicitação:]]></text>
289 
			</staticText>
290 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
291 
				<reportElement uuid="34398bb3-fbec-47a1-b3ed-722af49eae42" positionType="Float" stretchType="RelativeToBandHeight" x="47" y="0" width="507" height="14"/>
292 
				<textElement textAlignment="Justified" verticalAlignment="Middle">
293 
					<font fontName="Arial" size="8" isPdfEmbedded="false"/>
294 
				</textElement>
295 
				<textFieldExpression><![CDATA[$F{descricao_solicitacao}]]></textFieldExpression>
296 
			</textField>
297 
		</band>
298 
		<band height="20">
299 
			<staticText>
300 
				<reportElement uuid="ab041ec3-f616-40d4-ba26-359ab930da1a" positionType="Float" stretchType="RelativeToBandHeight" x="0" y="0" width="43" height="14"/>
301 
				<textElement textAlignment="Right" verticalAlignment="Middle">
302 
					<font fontName="Arial" size="8"/>
303 
				</textElement>
304 
				<text><![CDATA[Resposta:]]></text>
305 
			</staticText>
306 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
307 
				<reportElement uuid="904e7909-fdf6-4919-a059-5cda25a2a09e" positionType="Float" stretchType="RelativeToBandHeight" x="47" y="0" width="507" height="14"/>
308 
				<textElement textAlignment="Justified" verticalAlignment="Middle">
309 
					<font fontName="Arial" size="8" isPdfEmbedded="false"/>
310 
				</textElement>
311 
				<textFieldExpression><![CDATA[$F{descricao_resposta_solicitacao}]]></textFieldExpression>
312 
			</textField>
313 
		</band>
314 
		<band height="1">
315 
			<line>
316 
				<reportElement uuid="0090dcde-b68c-4665-bcbc-685d2aa15f3a" positionType="Float" x="0" y="0" width="554" height="1"/>
317 
				<graphicElement>
318 
					<pen lineWidth="0.5" lineStyle="Dashed"/>
319 
				</graphicElement>
320 
			</line>
321 
		</band>
322 
	</detail>
323 
	<pageFooter>
324 
		<band height="29" splitType="Stretch">
325 
			<textField evaluationTime="Report" isBlankWhenNull="false">
326 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="527" y="6" width="27" height="15"/>
327 
				<textElement verticalAlignment="Middle">
328 
					<font fontName="Arial" size="6" isBold="false"/>
329 
				</textElement>
330 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
331 
			</textField>
332 
			<textField isBlankWhenNull="false">
333 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="452" y="6" width="73" height="15"/>
334 
				<textElement textAlignment="Right" verticalAlignment="Middle">
335 
					<font fontName="Arial" size="6" isBold="false"/>
336 
				</textElement>
337 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
338 
			</textField>
339 
			<textField isBlankWhenNull="true">
340 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="6" y="6" width="374" height="15"/>
341 
				<textElement verticalAlignment="Middle">
342 
					<font fontName="Arial" size="6" isBold="false"/>
343 
				</textElement>
344 
				<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>
345 
			</textField>
346 
		</band>
347 
	</pageFooter>
348 
</jasperReport>