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="Relatório Quatitativo de Função" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="a9bd3a8d-3d73-4ab7-8540-556997aa680b">
3 
	<property name="ireport.zoom" value="1.5"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="0"/>
6 
	<style name="table">
7 
		<box>
8 
			<pen lineWidth="1.0" lineColor="#000000"/>
9 
		</box>
10 
	</style>
11 
	<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
12 
		<box>
13 
			<pen lineWidth="0.5" lineColor="#000000"/>
14 
		</box>
15 
	</style>
16 
	<style name="table_CH" mode="Opaque" backcolor="#CCCCCC">
17 
		<box>
18 
			<pen lineWidth="0.5" lineColor="#000000"/>
19 
		</box>
20 
	</style>
21 
	<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
22 
		<box>
23 
			<pen lineWidth="0.5" lineColor="#000000"/>
24 
		</box>
25 
		<conditionalStyle>
26 
			<conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>
27 
			<style backcolor="#F3F6F8"/>
28 
		</conditionalStyle>
29 
	</style>
30 
	<subDataset name="funcao" uuid="f8c4d4e7-e9fb-43ab-9295-e01767f3bece">
31 
		<queryString>
32 
			<![CDATA[SELECT
33 
        f.cod_funcao,
34 
        f.dsc_funcao,
35 
        f.tip_funcao,
36 
        f.num_quantidade_vagas,
37 
        f.dsc_nivel_funcao,
38 
        f.ind_ativo,
39 
        (
40 
            SELECT count(cod_funcao) as total FROM
41 
            sc_srv.srv_servdadofunc_matricula sm
42 
            WHERE sm.cod_funcao=f.cod_funcao AND sm.cod_situacao_servidor = 1
43 
        ) as vagas_ocupadas,
44 
        (
45 
            SELECT count(cod_funcao) as total FROM
46 
            sc_srv.srv_servdadofunc_matricula sm
47 
            INNER JOIN sc_srv.srv_servidor_dadofuncional df on (sm.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
48 
            INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
49 
            WHERE sm.cod_funcao=f.cod_funcao and fi.tip_vinculo_forma_ingresso = 'E' AND sm.cod_situacao_servidor = 1
50 
        )as vagas_ocupadas_efetivo,
51 
        (
52 
            SELECT count(cod_funcao) as total FROM
53 
            sc_srv.srv_servdadofunc_matricula sm
54 
            INNER JOIN sc_srv.srv_servidor_dadofuncional df on (sm.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
55 
            INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
56 
            WHERE sm.cod_funcao=f.cod_funcao and fi.tip_vinculo_forma_ingresso = 'T' AND sm.cod_situacao_servidor = 1
57 
        )as vagas_ocupadas_contratado,
58 
        (
59 
            SELECT count(cod_funcao) as total FROM
60 
            sc_srv.srv_servdadofunc_matricula sm
61 
            INNER JOIN sc_srv.srv_servidor_dadofuncional df on (sm.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
62 
            INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
63 
            WHERE sm.cod_funcao=f.cod_funcao and fi.tip_vinculo_forma_ingresso = 'L' AND sm.cod_situacao_servidor = 1
64 
        )as vagas_ocupadas_celetista,
65 
        (
66 
            SELECT count(cod_funcao) as total FROM
67 
            sc_srv.srv_servdadofunc_matricula sm
68 
            INNER JOIN sc_srv.srv_servidor_dadofuncional df on (sm.seq_servidor_dadofuncional=df.seq_servidor_dadofuncional)
69 
            INNER JOIN sc_srv.srv_forma_ingresso fi on (fi.cod_forma_ingresso=df.cod_forma_ingresso)
70 
            WHERE sm.cod_funcao=f.cod_funcao and fi.tip_vinculo_forma_ingresso = 'C' AND sm.cod_situacao_servidor = 1
71 
        )as vagas_ocupadas_comissionado,
72 
        (
73 
            (num_quantidade_vagas) -
74 
            (
75 
                SELECT count(cod_funcao) as total FROM
76 
                sc_srv.srv_servdadofunc_matricula sm
77 
                WHERE sm.cod_funcao=f.cod_funcao AND sm.cod_situacao_servidor = 1
78 
            )
79 
        )as saldo_vagas,
80 
        (
81 
            SELECT sum(num_quantidade_vagas) as total FROM sc_srv.srv_funcao
82 
        )as total_vagas_disponiveis,
83 
        (
84 
            SELECT count(cod_funcao) as total FROM
85 
            sc_srv.srv_servdadofunc_matricula sm
86 
            WHERE sm.cod_situacao_servidor = 1
87 
        )as total_vagas_ocupadas,
88 
        (
89 
            (SELECT sum(num_quantidade_vagas) as total FROM sc_srv.srv_funcao) -
90 
            (SELECT count(cod_funcao) as total FROM sc_srv.srv_servdadofunc_matricula sm
91 
            WHERE sm.cod_situacao_servidor = 1)
92 
        )as total_saldo_vagas
93 
        FROM sc_srv.srv_funcao f
94 
        ORDER BY f.dsc_funcao]]>
95 
		</queryString>
96 
		<field name="cod_funcao" class="java.math.BigDecimal"/>
97 
		<field name="dsc_funcao" class="java.lang.String"/>
98 
		<field name="tip_funcao" class="java.lang.String"/>
99 
		<field name="num_quantidade_vagas" class="java.math.BigDecimal"/>
100 
		<field name="dsc_nivel_funcao" class="java.lang.String"/>
101 
		<field name="ind_ativo" class="java.lang.Boolean"/>
102 
		<field name="vagas_ocupadas" class="java.lang.Long"/>
103 
		<field name="vagas_ocupadas_efetivo" class="java.lang.Long"/>
104 
		<field name="vagas_ocupadas_contratado" class="java.lang.Long"/>
105 
		<field name="vagas_ocupadas_celetista" class="java.lang.Long"/>
106 
		<field name="vagas_ocupadas_comissionado" class="java.lang.Long"/>
107 
		<field name="saldo_vagas" class="java.math.BigDecimal"/>
108 
		<field name="total_vagas_disponiveis" class="java.math.BigDecimal"/>
109 
		<field name="total_vagas_ocupadas" class="java.lang.Long"/>
110 
		<field name="total_saldo_vagas" class="java.math.BigDecimal"/>
111 
	</subDataset>
112 
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
113 
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
114 
	</parameter>
115 
	<parameter name="IMAGE_DIR" class="java.lang.String" isForPrompting="false">
116 
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
117 
	</parameter>
118 
	<queryString>
119 
		<![CDATA[SELECT * FROM sc_srv.srv_funcao limit 1]]>
120 
	</queryString>
121 
	<field name="cod_funcao" class="java.math.BigDecimal"/>
122 
	<field name="dsc_funcao" class="java.lang.String"/>
123 
	<field name="dsc_nivel_funcao" class="java.lang.String"/>
124 
	<field name="tip_funcao" class="java.lang.String"/>
125 
	<field name="num_quantidade_vagas" class="java.math.BigDecimal"/>
126 
	<field name="ind_ativo" class="java.lang.Boolean"/>
127 
	<background>
128 
		<band splitType="Stretch"/>
129 
	</background>
130 
	<pageHeader>
131 
		<band height="110">
132 
			<image hAlign="Right">
133 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="253" y="1" width="48" height="59" isPrintWhenDetailOverflows="true"/>
134 
				<imageExpression><![CDATA[$P{IMAGE_DIR} + "brasao.jpg"]]></imageExpression>
135 
			</image>
136 
			<staticText>
137 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="62" width="555" height="39" isPrintWhenDetailOverflows="true"/>
138 
				<textElement textAlignment="Center" verticalAlignment="Top">
139 
					<font fontName="Arial" size="10" isBold="true"/>
140 
				</textElement>
141 
				<text><![CDATA[ESTADO DE ALAGOAS
142 
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS
143 
RELATÓRIO DE ACOMPANHAMENTO DO SERVIDOR - QUANTITATIVO DE FUNÇÃO]]></text>
144 
			</staticText>
145 
		</band>
146 
	</pageHeader>
147 
	<columnHeader>
148 
		<band height="15">
149 
			<rectangle>
150 
				<reportElement uuid="423b9a10-6789-4023-9a4d-1cd8ecd4119f" positionType="Float" x="0" y="0" width="555" height="15" backcolor="#CCCCCC"/>
151 
			</rectangle>
152 
			<staticText>
153 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" positionType="Float" mode="Transparent" x="0" y="0" width="555" height="15" backcolor="#CCCCCC"/>
154 
				<textElement textAlignment="Center" verticalAlignment="Middle">
155 
					<font fontName="Arial" size="8" isBold="true"/>
156 
					<paragraph leftIndent="5"/>
157 
				</textElement>
158 
				<text><![CDATA[QUANTITATIVO DE FUNÇÃO]]></text>
159 
			</staticText>
160 
		</band>
161 
	</columnHeader>
162 
	<detail>
163 
		<band height="42">
164 
			<componentElement>
165 
				<reportElement uuid="d544b12e-4a9e-4e24-9e16-b3c298778f8d" key="table" style="table" x="0" y="0" width="555" height="40"/>
166 
				<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
167 
					<datasetRun subDataset="funcao" uuid="235e1965-b170-49ae-bff2-1c8ee15bedc5">
168 
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
169 
					</datasetRun>
170 
					<jr:column uuid="466342e1-bd5b-40fd-b9e7-86fa6a3e83cc" width="168">
171 
						<jr:columnHeader style="table_CH" height="31" rowSpan="2">
172 
							<staticText>
173 
								<reportElement uuid="ca9e68fe-16e6-4297-a0fd-2a6397666366" x="0" y="0" width="168" height="30"/>
174 
								<textElement textAlignment="Center" verticalAlignment="Middle">
175 
									<font fontName="Arial" size="8"/>
176 
								</textElement>
177 
								<text><![CDATA[FUNÇÃO]]></text>
178 
							</staticText>
179 
						</jr:columnHeader>
180 
						<jr:columnFooter style="table_TD" height="15" rowSpan="1">
181 
							<staticText>
182 
								<reportElement uuid="ca9e68fe-16e6-4297-a0fd-2a6397666366" x="0" y="0" width="166" height="15"/>
183 
								<textElement textAlignment="Right" verticalAlignment="Middle">
184 
									<font fontName="Arial" size="8"/>
185 
								</textElement>
186 
								<text><![CDATA[TOTAL GERAL:]]></text>
187 
							</staticText>
188 
						</jr:columnFooter>
189 
						<jr:detailCell style="table_TD" height="15" rowSpan="1">
190 
							<textField isBlankWhenNull="true">
191 
								<reportElement uuid="50e05625-444b-4c14-b523-aca5062b3efc" x="1" y="0" width="167" height="15"/>
192 
								<textElement verticalAlignment="Middle">
193 
									<font fontName="Arial" size="8"/>
194 
									<paragraph leftIndent="5"/>
195 
								</textElement>
196 
								<textFieldExpression><![CDATA[$F{dsc_funcao}]]></textFieldExpression>
197 
							</textField>
198 
						</jr:detailCell>
199 
					</jr:column>
200 
					<jr:column uuid="a3d93193-512d-4a36-a739-0c64b3587cef" width="56">
201 
						<jr:columnHeader style="table_CH" height="31" rowSpan="2">
202 
							<staticText>
203 
								<reportElement uuid="022378a9-2a9e-41d3-9fbd-e60fe1843947" x="0" y="0" width="56" height="30"/>
204 
								<textElement textAlignment="Center" verticalAlignment="Middle">
205 
									<font fontName="Arial" size="8"/>
206 
								</textElement>
207 
								<text><![CDATA[DISPONÍVEL]]></text>
208 
							</staticText>
209 
						</jr:columnHeader>
210 
						<jr:columnFooter style="table_TD" height="15" rowSpan="1">
211 
							<textField isBlankWhenNull="true">
212 
								<reportElement uuid="9ff26279-09e1-4679-87f3-d8436412d437" x="0" y="0" width="56" height="15"/>
213 
								<textElement textAlignment="Center" verticalAlignment="Middle">
214 
									<font fontName="Arial" size="8"/>
215 
								</textElement>
216 
								<textFieldExpression><![CDATA[$F{total_vagas_disponiveis}]]></textFieldExpression>
217 
							</textField>
218 
						</jr:columnFooter>
219 
						<jr:detailCell style="table_TD" height="15" rowSpan="1">
220 
							<textField isBlankWhenNull="true">
221 
								<reportElement uuid="9dd9a8dc-00bc-4a5d-89c8-3877f2191563" x="0" y="0" width="56" height="15"/>
222 
								<textElement textAlignment="Center" verticalAlignment="Middle">
223 
									<font fontName="Arial" size="8"/>
224 
								</textElement>
225 
								<textFieldExpression><![CDATA[$F{num_quantidade_vagas}==null? "n/a" :$F{num_quantidade_vagas}]]></textFieldExpression>
226 
							</textField>
227 
						</jr:detailCell>
228 
					</jr:column>
229 
					<jr:columnGroup uuid="1dfefb0f-0cdf-4ee5-9a01-c6fbab46ac66" width="278">
230 
						<jr:columnHeader style="table_CH" height="15" rowSpan="1">
231 
							<staticText>
232 
								<reportElement uuid="ca9e68fe-16e6-4297-a0fd-2a6397666366" x="0" y="0" width="278" height="15"/>
233 
								<textElement textAlignment="Center" verticalAlignment="Middle">
234 
									<font fontName="Arial" size="8"/>
235 
								</textElement>
236 
								<text><![CDATA[OCUPADOS]]></text>
237 
							</staticText>
238 
						</jr:columnHeader>
239 
						<jr:column uuid="977f3fb9-aa32-4cb2-9715-620b0e1baaec" width="45">
240 
							<jr:columnHeader style="table_CH" height="16" rowSpan="1">
241 
								<staticText>
242 
									<reportElement uuid="8dc09efc-a62d-4324-b133-f96145a44443" x="0" y="0" width="45" height="15"/>
243 
									<textElement textAlignment="Center" verticalAlignment="Middle">
244 
										<font fontName="Arial" size="8"/>
245 
									</textElement>
246 
									<text><![CDATA[EFETIVO]]></text>
247 
								</staticText>
248 
							</jr:columnHeader>
249 
							<jr:detailCell style="table_TD" height="15" rowSpan="1">
250 
								<textField isBlankWhenNull="true">
251 
									<reportElement uuid="c9f994f6-f75b-42e4-a837-d5d1d87b7553" x="0" y="0" width="45" height="15"/>
252 
									<textElement textAlignment="Center" verticalAlignment="Middle">
253 
										<font fontName="Arial" size="8"/>
254 
									</textElement>
255 
									<textFieldExpression><![CDATA[$F{vagas_ocupadas_efetivo}]]></textFieldExpression>
256 
								</textField>
257 
							</jr:detailCell>
258 
						</jr:column>
259 
						<jr:column uuid="db7f36bc-dacc-4c52-bc88-03b6a9a5eaa7" width="68">
260 
							<jr:columnHeader style="table_CH" height="16" rowSpan="1">
261 
								<staticText>
262 
									<reportElement uuid="f8b25834-20bb-4a6c-bf2f-cb7e888f09fe" x="0" y="0" width="68" height="15"/>
263 
									<textElement textAlignment="Center" verticalAlignment="Middle">
264 
										<font fontName="Arial" size="8"/>
265 
									</textElement>
266 
									<text><![CDATA[CONTRATADO]]></text>
267 
								</staticText>
268 
							</jr:columnHeader>
269 
							<jr:detailCell style="table_TD" height="15" rowSpan="1">
270 
								<textField isBlankWhenNull="true">
271 
									<reportElement uuid="f02ee07f-553a-441a-8d2a-019c3e3225f7" x="0" y="0" width="68" height="15"/>
272 
									<textElement textAlignment="Center" verticalAlignment="Middle">
273 
										<font fontName="Arial" size="8"/>
274 
									</textElement>
275 
									<textFieldExpression><![CDATA[$F{vagas_ocupadas_contratado}]]></textFieldExpression>
276 
								</textField>
277 
							</jr:detailCell>
278 
						</jr:column>
279 
						<jr:column uuid="4c712216-cb8e-4fa5-a5a3-bfd8cfaf04d4" width="55">
280 
							<jr:columnHeader style="table_CH" height="16" rowSpan="1">
281 
								<staticText>
282 
									<reportElement uuid="8a6b5afd-7c27-4086-89d1-71d1620e8469" x="0" y="0" width="55" height="15"/>
283 
									<textElement textAlignment="Center" verticalAlignment="Middle">
284 
										<font fontName="Arial" size="8"/>
285 
									</textElement>
286 
									<text><![CDATA[CELETISTA]]></text>
287 
								</staticText>
288 
							</jr:columnHeader>
289 
							<jr:detailCell style="table_TD" height="15" rowSpan="1">
290 
								<textField isBlankWhenNull="true">
291 
									<reportElement uuid="a03f18df-4094-4e1f-9121-1099f4849489" x="0" y="0" width="55" height="15"/>
292 
									<textElement textAlignment="Center" verticalAlignment="Middle">
293 
										<font fontName="Arial" size="8"/>
294 
									</textElement>
295 
									<textFieldExpression><![CDATA[$F{vagas_ocupadas_celetista}]]></textFieldExpression>
296 
								</textField>
297 
							</jr:detailCell>
298 
						</jr:column>
299 
						<jr:column uuid="d83b562b-46a4-43f3-b29f-04abf5e7b32d" width="70">
300 
							<jr:columnHeader style="table_CH" height="16" rowSpan="1">
301 
								<staticText>
302 
									<reportElement uuid="ec5b3212-4b3a-4a1a-93bc-16668cabbbf6" x="0" y="0" width="70" height="15"/>
303 
									<textElement textAlignment="Center" verticalAlignment="Middle">
304 
										<font fontName="Arial" size="8"/>
305 
									</textElement>
306 
									<text><![CDATA[COMISSIONADO]]></text>
307 
								</staticText>
308 
							</jr:columnHeader>
309 
							<jr:detailCell style="table_TD" height="15" rowSpan="1">
310 
								<textField isBlankWhenNull="true">
311 
									<reportElement uuid="5abbdc99-dda5-4bba-b46d-d042b901d759" x="0" y="0" width="70" height="15"/>
312 
									<textElement textAlignment="Center" verticalAlignment="Middle">
313 
										<font fontName="Arial" size="8"/>
314 
									</textElement>
315 
									<textFieldExpression><![CDATA[$F{vagas_ocupadas_comissionado}]]></textFieldExpression>
316 
								</textField>
317 
							</jr:detailCell>
318 
						</jr:column>
319 
						<jr:column uuid="b4a29af0-1c36-4b2f-9243-8f4c02f724fa" width="40">
320 
							<jr:columnHeader style="table_CH" height="16" rowSpan="1">
321 
								<staticText>
322 
									<reportElement uuid="12d87179-a051-4eac-a373-f687ca2b6862" x="0" y="0" width="40" height="15"/>
323 
									<textElement textAlignment="Center" verticalAlignment="Middle">
324 
										<font fontName="Arial" size="8"/>
325 
									</textElement>
326 
									<text><![CDATA[TOTAL]]></text>
327 
								</staticText>
328 
							</jr:columnHeader>
329 
							<jr:columnFooter style="table_TD" height="15" rowSpan="1">
330 
								<textField isBlankWhenNull="true">
331 
									<reportElement uuid="6edb0595-d757-44f3-99ae-473526591447" x="0" y="0" width="40" height="15"/>
332 
									<textElement textAlignment="Center" verticalAlignment="Middle">
333 
										<font fontName="Arial" size="8"/>
334 
									</textElement>
335 
									<textFieldExpression><![CDATA[$F{total_vagas_ocupadas}]]></textFieldExpression>
336 
								</textField>
337 
							</jr:columnFooter>
338 
							<jr:detailCell style="table_TD" height="15" rowSpan="1">
339 
								<textField isBlankWhenNull="true">
340 
									<reportElement uuid="3e1c696a-025f-4a43-bda6-98f36a8086ab" x="0" y="0" width="40" height="15"/>
341 
									<textElement textAlignment="Center" verticalAlignment="Middle">
342 
										<font fontName="Arial" size="8"/>
343 
									</textElement>
344 
									<textFieldExpression><![CDATA[$F{vagas_ocupadas}]]></textFieldExpression>
345 
								</textField>
346 
							</jr:detailCell>
347 
						</jr:column>
348 
					</jr:columnGroup>
349 
					<jr:column uuid="7c76de04-8952-478b-9001-7de6181ab5fa" width="53">
350 
						<jr:columnHeader style="table_CH" height="31" rowSpan="2">
351 
							<staticText>
352 
								<reportElement uuid="6969a9fe-509d-47d3-b4fd-82ae58e5652f" x="0" y="0" width="49" height="30"/>
353 
								<textElement textAlignment="Center" verticalAlignment="Middle">
354 
									<font fontName="Arial" size="8"/>
355 
								</textElement>
356 
								<text><![CDATA[SALDO]]></text>
357 
							</staticText>
358 
						</jr:columnHeader>
359 
						<jr:columnFooter style="table_TD" height="15" rowSpan="1">
360 
							<textField isBlankWhenNull="true">
361 
								<reportElement uuid="93ac7620-8a6e-4b57-94fc-fdae5bcb023c" x="0" y="0" width="49" height="15"/>
362 
								<textElement textAlignment="Center" verticalAlignment="Middle">
363 
									<font fontName="Arial" size="8"/>
364 
								</textElement>
365 
								<textFieldExpression><![CDATA[($F{total_saldo_vagas}.intValue() < 0 ? "n/a":$F{total_saldo_vagas})]]></textFieldExpression>
366 
							</textField>
367 
						</jr:columnFooter>
368 
						<jr:detailCell style="table_TD" height="15" rowSpan="1">
369 
							<textField isBlankWhenNull="true">
370 
								<reportElement uuid="7bda85e7-ab71-4526-96d9-b45e923fd3ee" x="0" y="0" width="49" height="15"/>
371 
								<textElement textAlignment="Center" verticalAlignment="Middle">
372 
									<font fontName="Arial" size="8"/>
373 
								</textElement>
374 
								<textFieldExpression><![CDATA[$F{saldo_vagas}==null? "n/a" :$F{saldo_vagas}]]></textFieldExpression>
375 
							</textField>
376 
						</jr:detailCell>
377 
					</jr:column>
378 
				</jr:table>
379 
			</componentElement>
380 
		</band>
381 
	</detail>
382 
	<pageFooter>
383 
		<band height="33">
384 
			<textField evaluationTime="Report" isBlankWhenNull="false">
385 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="497" y="10" width="52" height="15"/>
386 
				<textElement verticalAlignment="Middle">
387 
					<font fontName="Arial" size="6" isBold="false"/>
388 
				</textElement>
389 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
390 
			</textField>
391 
			<textField isBlankWhenNull="false">
392 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="422" y="10" width="73" height="15"/>
393 
				<textElement textAlignment="Right" verticalAlignment="Middle">
394 
					<font fontName="Arial" size="6" isBold="false"/>
395 
				</textElement>
396 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
397 
			</textField>
398 
			<textField isBlankWhenNull="true">
399 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="10" width="289" height="15"/>
400 
				<textElement verticalAlignment="Middle">
401 
					<font fontName="Arial" size="6" isBold="false"/>
402 
				</textElement>
403 
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("'Gerado em ' dd 'de' MMMMM 'de' yyyy ' às ' HH:mm", new Locale("pt", "BR")).format(new java.util.Date()).toUpperCase()]]></textFieldExpression>
404 
			</textField>
405 
		</band>
406 
	</pageFooter>
407 
	<summary>
408 
		<band height="47"/>
409 
	</summary>
410 
</jasperReport>