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_faltas" 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.8531167061100056"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="354"/>
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="pMatriculaServidor" class="java.lang.Long"/>
15 
	<parameter name="pAnoCronograma" class="java.lang.Long"/>
16 
	<parameter name="pCodigoUnidadeExercicio" class="java.lang.Long"/>
17 
	<queryString>
18 
		<![CDATA[SELECT (SELECT u.dsc_unidade FROM sc_srv.vw_unidade u WHERE u.cod_unidade = vsd.cod_unidade_exercicio) AS UNIDADE_EXERCICIO,
19 
       ws.nom_pessoa AS NOME_SERVIDOR,
20 
       ws.num_cpf AS CPF_SERVIDOR,
21 
       (vsd.num_matricula_servidor || '-' || vsd.num_digito_matricula) AS NUMERO_MATRICULA,
22 
       COALESCE(MAX(falta_servidor.MES_01), 0) AS JANEIRO,
23 
       COALESCE(MAX(falta_servidor.MES_02), 0) AS FEVEREIRO,
24 
       COALESCE(MAX(falta_servidor.MES_03), 0) AS MARCO,
25 
       COALESCE(MAX(falta_servidor.MES_04), 0) AS ABRIL,
26 
       COALESCE(MAX(falta_servidor.MES_05), 0) AS MAIO,
27 
       COALESCE(MAX(falta_servidor.MES_06), 0) AS JUNHO,
28 
       COALESCE(MAX(falta_servidor.MES_07), 0) AS JULHO,
29 
       COALESCE(MAX(falta_servidor.MES_08), 0) AS AGOSTO,
30 
       COALESCE(MAX(falta_servidor.MES_09), 0) AS SETEMBRO,
31 
       COALESCE(MAX(falta_servidor.MES_10), 0) AS OUTUBRO,
32 
       COALESCE(MAX(falta_servidor.MES_11), 0) AS NOVEMBRO,
33 
       COALESCE(MAX(falta_servidor.MES_12), 0) AS DEZEMBRO,
34 
       COALESCE(SUM(NUM_FALTA_ANO), 0) AS TOTAL_FALTA_ANO
35 
  FROM sc_srv.vw_servidor_dadofuncional vsd
36 
       INNER JOIN sc_srv.vw_servidor ws ON (vsd.seq_pessoa_servidor = ws.seq_pessoa_servidor)
37 
       INNER JOIN sc_rhd.rhd_servidor_avaliacao rsa ON (rsa.seq_servidor_dadofuncional = vsd.seq_servidor_dadofuncional)
38 
       LEFT JOIN(SELECT vsdf.num_matricula_servidor,
39 
               	   (CASE WHEN rsf.num_mes = 1 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_01,
40 
       		   (CASE WHEN rsf.num_mes = 2 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_02,
41 
		   (CASE WHEN rsf.num_mes = 3 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_03,
42 
       		   (CASE WHEN rsf.num_mes = 4 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_04,
43 
                        (CASE WHEN rsf.num_mes = 5 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_05,
44 
		   (CASE WHEN rsf.num_mes = 6 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_06,
45 
		   (CASE WHEN rsf.num_mes = 7 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_07,
46 
	    	   (CASE WHEN rsf.num_mes = 8 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_08,
47 
	          	   (CASE WHEN rsf.num_mes = 9 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_09,
48 
		   (CASE WHEN rsf.num_mes = 10 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_10,
49 
              	   (CASE WHEN rsf.num_mes = 11 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_11,
50 
       		   (CASE WHEN rsf.num_mes = 12 THEN SUM(rsf.qtd_falta) ELSE 0 END) AS MES_12,
51 
                        SUM(qtd_falta) AS NUM_FALTA_ANO
52 
          FROM sc_srv.vw_servidor_dadofuncional vsdf
53 
               INNER JOIN sc_rhd.rhd_servidor_falta rsf ON (rsf.seq_servidor_dadofuncional = vsdf.seq_servidor_dadofuncional)
54 
               WHERE rsf.num_ano = $P{pAnoCronograma}
55 
          GROUP BY vsdf.num_matricula_servidor,
56 
                   rsf.num_mes) falta_servidor ON (falta_servidor.num_matricula_servidor = vsd.num_matricula_servidor)
57 
 
58 
 WHERE rsa.num_ano = $P{pAnoCronograma}
59 
            AND (vsd.cod_unidade_exercicio = $P{pCodigoUnidadeExercicio} OR $P{pCodigoUnidadeExercicio} IS NULL)
60 
            AND (vsd.num_matricula_servidor = $P{pMatriculaServidor} OR $P{pMatriculaServidor} IS NULL) GROUP BY UNIDADE_EXERCICIO,
61 
         NOME_SERVIDOR,
62 
         CPF_SERVIDOR,
63 
         NUMERO_MATRICULA
64 
ORDER BY UNIDADE_EXERCICIO,
65 
         NOME_SERVIDOR]]>
66 
	</queryString>
67 
	<field name="unidade_exercicio" class="java.lang.String"/>
68 
	<field name="nome_servidor" class="java.lang.String"/>
69 
	<field name="cpf_servidor" class="java.lang.String"/>
70 
	<field name="numero_matricula" class="java.lang.String"/>
71 
	<field name="janeiro" class="java.math.BigDecimal"/>
72 
	<field name="fevereiro" class="java.math.BigDecimal"/>
73 
	<field name="marco" class="java.math.BigDecimal"/>
74 
	<field name="abril" class="java.math.BigDecimal"/>
75 
	<field name="maio" class="java.math.BigDecimal"/>
76 
	<field name="junho" class="java.math.BigDecimal"/>
77 
	<field name="julho" class="java.math.BigDecimal"/>
78 
	<field name="agosto" class="java.math.BigDecimal"/>
79 
	<field name="setembro" class="java.math.BigDecimal"/>
80 
	<field name="outubro" class="java.math.BigDecimal"/>
81 
	<field name="novembro" class="java.math.BigDecimal"/>
82 
	<field name="dezembro" class="java.math.BigDecimal"/>
83 
	<field name="total_falta_ano" class="java.math.BigDecimal"/>
84 
	<group name="groupCronograma">
85 
		<groupExpression><![CDATA[]]></groupExpression>
86 
	</group>
87 
	<group name="group">
88 
		<groupExpression><![CDATA[$F{unidade_exercicio}]]></groupExpression>
89 
		<groupHeader>
90 
			<band height="33">
91 
				<textField isStretchWithOverflow="true">
92 
					<reportElement uuid="1b7ae11b-d3df-4108-8e29-221b7e53a9d4" x="0" y="7" width="555" height="20"/>
93 
					<textElement verticalAlignment="Bottom">
94 
						<font fontName="Arial" size="12" isBold="true" isUnderline="true" pdfFontName="Helvetica-Bold"/>
95 
					</textElement>
96 
					<textFieldExpression><![CDATA["UNIDADE: " + $F{unidade_exercicio}]]></textFieldExpression>
97 
				</textField>
98 
			</band>
99 
		</groupHeader>
100 
	</group>
101 
	<group name="groupServidor">
102 
		<groupExpression><![CDATA[$F{numero_matricula}]]></groupExpression>
103 
		<groupHeader>
104 
			<band height="18">
105 
				<rectangle>
106 
					<reportElement uuid="929d9137-2979-443b-a76d-d93458dbea93" x="0" y="2" width="555" height="14" forecolor="#DCDCDC" backcolor="#DCDCDC"/>
107 
					<graphicElement>
108 
						<pen lineWidth="0.0"/>
109 
					</graphicElement>
110 
				</rectangle>
111 
				<textField>
112 
					<reportElement uuid="8c9e7a92-d83d-4c81-b766-e9a4bd04d45c" x="34" y="2" width="255" height="14"/>
113 
					<textElement verticalAlignment="Middle">
114 
						<font fontName="Arial" size="8" isBold="true"/>
115 
					</textElement>
116 
					<textFieldExpression><![CDATA[$F{nome_servidor}]]></textFieldExpression>
117 
				</textField>
118 
				<staticText>
119 
					<reportElement uuid="adae7f8f-0817-4705-a460-468877d15149" x="3" y="2" width="30" height="14"/>
120 
					<textElement textAlignment="Right" verticalAlignment="Middle">
121 
						<font fontName="Arial" size="8" isBold="true"/>
122 
					</textElement>
123 
					<text><![CDATA[Nome:]]></text>
124 
				</staticText>
125 
				<staticText>
126 
					<reportElement uuid="81850e19-8f8a-4e07-97f2-7bb034d4f33c" x="448" y="2" width="21" height="14"/>
127 
					<textElement textAlignment="Right" verticalAlignment="Middle">
128 
						<font fontName="Arial" size="8" isBold="true"/>
129 
					</textElement>
130 
					<text><![CDATA[CPF:]]></text>
131 
				</staticText>
132 
				<textField pattern="" isBlankWhenNull="true">
133 
					<reportElement uuid="0fad1e92-1edb-48b9-81fd-a72739f06f2f" x="470" y="2" width="80" height="14"/>
134 
					<textElement verticalAlignment="Middle">
135 
						<font fontName="Arial" size="8" isBold="true"/>
136 
					</textElement>
137 
					<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>
138 
				</textField>
139 
				<textField>
140 
					<reportElement uuid="4c6c0c07-6b3e-4497-acaf-1bf017cfd7fc" x="353" y="2" width="66" height="14"/>
141 
					<textElement verticalAlignment="Middle">
142 
						<font fontName="Arial" size="8" isBold="true"/>
143 
					</textElement>
144 
					<textFieldExpression><![CDATA[$F{numero_matricula}]]></textFieldExpression>
145 
				</textField>
146 
				<staticText>
147 
					<reportElement uuid="972dba30-0b61-4516-831d-dfabb64e7eab" x="310" y="2" width="42" height="14"/>
148 
					<textElement textAlignment="Right" verticalAlignment="Middle">
149 
						<font fontName="Arial" size="8" isBold="true"/>
150 
					</textElement>
151 
					<text><![CDATA[Matrícula:]]></text>
152 
				</staticText>
153 
			</band>
154 
		</groupHeader>
155 
	</group>
156 
	<background>
157 
		<band splitType="Stretch"/>
158 
	</background>
159 
	<title>
160 
		<band height="145" splitType="Stretch">
161 
			<staticText>
162 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="69" width="555" height="26"/>
163 
				<textElement textAlignment="Center">
164 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
165 
				</textElement>
166 
				<text><![CDATA[ESTADO DE ALAGOAS
167 
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS]]></text>
168 
			</staticText>
169 
			<staticText>
170 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="0" y="104" width="555" height="16" isPrintWhenDetailOverflows="true"/>
171 
				<textElement textAlignment="Center" verticalAlignment="Top">
172 
					<font fontName="Arial" size="10" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
173 
				</textElement>
174 
				<text><![CDATA[RELATÓRIO DE FALTAS]]></text>
175 
			</staticText>
176 
			<textField isBlankWhenNull="false">
177 
				<reportElement uuid="7e420030-8524-414a-9258-b8ff749fc009" x="0" y="125" width="555" height="15"/>
178 
				<textElement textAlignment="Center">
179 
					<font fontName="Arial" isBold="true" pdfFontName="Helvetica-Bold" isPdfEmbedded="false"/>
180 
				</textElement>
181 
				<textFieldExpression><![CDATA["CRONOGRAMA: " + $P{pAnoCronograma}]]></textFieldExpression>
182 
			</textField>
183 
			<image hAlign="Right">
184 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="259" y="1" width="48" height="59"/>
185 
				<imageExpression><![CDATA[$P{IMAGEM_DIR} + "brasao.jpg"]]></imageExpression>
186 
			</image>
187 
		</band>
188 
	</title>
189 
	<detail>
190 
		<band height="56" splitType="Stretch">
191 
			<textField isBlankWhenNull="false">
192 
				<reportElement uuid="a8119919-a812-473e-a157-651fbac5a34e" x="0" y="17" width="46" height="13"/>
193 
				<textElement textAlignment="Center" verticalAlignment="Middle">
194 
					<font fontName="Arial" size="8"/>
195 
				</textElement>
196 
				<textFieldExpression><![CDATA[$F{janeiro}]]></textFieldExpression>
197 
			</textField>
198 
			<textField isBlankWhenNull="false">
199 
				<reportElement uuid="864ee6fc-9c11-4dce-8880-1d31ac2912da" x="46" y="17" width="46" height="14"/>
200 
				<textElement textAlignment="Center" verticalAlignment="Middle">
201 
					<font fontName="Arial" size="8"/>
202 
				</textElement>
203 
				<textFieldExpression><![CDATA[$F{fevereiro}]]></textFieldExpression>
204 
			</textField>
205 
			<textField isBlankWhenNull="false">
206 
				<reportElement uuid="d33f0f9d-c1f5-470f-a0fd-bf3eeb7dc936" x="92" y="17" width="46" height="14"/>
207 
				<textElement textAlignment="Center" verticalAlignment="Middle">
208 
					<font fontName="Arial" size="8"/>
209 
				</textElement>
210 
				<textFieldExpression><![CDATA[$F{marco}]]></textFieldExpression>
211 
			</textField>
212 
			<textField isBlankWhenNull="false">
213 
				<reportElement uuid="d6772f9a-f998-41bf-91ea-cc7fc9587945" x="138" y="17" width="46" height="14"/>
214 
				<textElement textAlignment="Center" verticalAlignment="Middle">
215 
					<font fontName="Arial" size="8"/>
216 
				</textElement>
217 
				<textFieldExpression><![CDATA[$F{abril}]]></textFieldExpression>
218 
			</textField>
219 
			<textField isBlankWhenNull="false">
220 
				<reportElement uuid="109b7897-10d7-48bc-8228-6d2d56d3d1c0" x="231" y="17" width="46" height="14"/>
221 
				<textElement textAlignment="Center" verticalAlignment="Middle">
222 
					<font fontName="Arial" size="8"/>
223 
				</textElement>
224 
				<textFieldExpression><![CDATA[$F{junho}]]></textFieldExpression>
225 
			</textField>
226 
			<textField isBlankWhenNull="false">
227 
				<reportElement uuid="2ad275a3-7ce6-4689-9371-84fb1791e6ec" x="323" y="17" width="46" height="14"/>
228 
				<textElement textAlignment="Center" verticalAlignment="Middle">
229 
					<font fontName="Arial" size="8"/>
230 
				</textElement>
231 
				<textFieldExpression><![CDATA[$F{agosto}]]></textFieldExpression>
232 
			</textField>
233 
			<textField isBlankWhenNull="false">
234 
				<reportElement uuid="23c6db54-33fe-466c-bee5-78c321f87786" x="369" y="17" width="46" height="14"/>
235 
				<textElement textAlignment="Center" verticalAlignment="Middle">
236 
					<font fontName="Arial" size="8"/>
237 
				</textElement>
238 
				<textFieldExpression><![CDATA[$F{setembro}]]></textFieldExpression>
239 
			</textField>
240 
			<textField isBlankWhenNull="false">
241 
				<reportElement uuid="02f8d5ca-a2c7-423f-8387-17f14a38785f" x="415" y="17" width="46" height="14"/>
242 
				<textElement textAlignment="Center" verticalAlignment="Middle">
243 
					<font fontName="Arial" size="8"/>
244 
				</textElement>
245 
				<textFieldExpression><![CDATA[$F{outubro}]]></textFieldExpression>
246 
			</textField>
247 
			<line>
248 
				<reportElement uuid="ce3f9236-679b-49fe-a99c-f56cbfd5e945" x="-1" y="1" width="555" height="1"/>
249 
				<graphicElement>
250 
					<pen lineWidth="0.5" lineStyle="Solid"/>
251 
				</graphicElement>
252 
			</line>
253 
			<line>
254 
				<reportElement uuid="ce3f9236-679b-49fe-a99c-f56cbfd5e945" x="-1" y="1" width="1" height="29"/>
255 
				<graphicElement>
256 
					<pen lineWidth="0.5" lineStyle="Solid"/>
257 
				</graphicElement>
258 
			</line>
259 
			<textField isBlankWhenNull="false">
260 
				<reportElement uuid="a1102701-9793-4a80-a7a8-bbe08fd9bc62" x="507" y="17" width="46" height="14"/>
261 
				<textElement textAlignment="Center" verticalAlignment="Middle">
262 
					<font fontName="Arial" size="8"/>
263 
				</textElement>
264 
				<textFieldExpression><![CDATA[$F{dezembro}]]></textFieldExpression>
265 
			</textField>
266 
			<textField isBlankWhenNull="false">
267 
				<reportElement uuid="17ca6aca-39b4-4826-ad51-c31d05d4e829" x="461" y="17" width="46" height="14"/>
268 
				<textElement textAlignment="Center" verticalAlignment="Middle">
269 
					<font fontName="Arial" size="8"/>
270 
				</textElement>
271 
				<textFieldExpression><![CDATA[$F{novembro}]]></textFieldExpression>
272 
			</textField>
273 
			<textField isBlankWhenNull="false">
274 
				<reportElement uuid="5fcbb678-9e7f-4775-8066-333efa4f17b6" x="277" y="17" width="46" height="14"/>
275 
				<textElement textAlignment="Center" verticalAlignment="Middle">
276 
					<font fontName="Arial" size="8"/>
277 
				</textElement>
278 
				<textFieldExpression><![CDATA[$F{julho}]]></textFieldExpression>
279 
			</textField>
280 
			<textField isBlankWhenNull="false">
281 
				<reportElement uuid="04cdfa06-9a65-4902-91b8-69d7f9b93af1" x="185" y="17" width="46" height="14"/>
282 
				<textElement textAlignment="Center" verticalAlignment="Middle">
283 
					<font fontName="Arial" size="8"/>
284 
				</textElement>
285 
				<textFieldExpression><![CDATA[$F{maio}]]></textFieldExpression>
286 
			</textField>
287 
			<line>
288 
				<reportElement uuid="ce3f9236-679b-49fe-a99c-f56cbfd5e945" x="-1" y="30" width="555" height="1"/>
289 
				<graphicElement>
290 
					<pen lineWidth="0.5" lineStyle="Solid"/>
291 
				</graphicElement>
292 
			</line>
293 
			<line>
294 
				<reportElement uuid="ce3f9236-679b-49fe-a99c-f56cbfd5e945" x="-1" y="16" width="555" height="1"/>
295 
				<graphicElement>
296 
					<pen lineWidth="0.5" lineStyle="Solid"/>
297 
				</graphicElement>
298 
			</line>
299 
			<staticText>
300 
				<reportElement uuid="dc80aa22-c7db-4868-9c0b-ee330389d413" x="0" y="2" width="46" height="14"/>
301 
				<textElement textAlignment="Center" verticalAlignment="Middle">
302 
					<font fontName="Arial" size="8"/>
303 
				</textElement>
304 
				<text><![CDATA[JAN]]></text>
305 
			</staticText>
306 
			<staticText>
307 
				<reportElement uuid="a068fd3c-00ea-453c-8114-55eb62aefa34" x="46" y="2" width="46" height="14"/>
308 
				<textElement textAlignment="Center" verticalAlignment="Middle">
309 
					<font fontName="Arial" size="8"/>
310 
				</textElement>
311 
				<text><![CDATA[FEV]]></text>
312 
			</staticText>
313 
			<staticText>
314 
				<reportElement uuid="9f53e1b2-492b-4710-aad0-1b648344749c" x="92" y="2" width="46" height="14"/>
315 
				<textElement textAlignment="Center" verticalAlignment="Middle">
316 
					<font fontName="Arial" size="8"/>
317 
				</textElement>
318 
				<text><![CDATA[MAR]]></text>
319 
			</staticText>
320 
			<staticText>
321 
				<reportElement uuid="cf106f5c-0295-47c0-837d-9945001c5c2f" x="138" y="2" width="46" height="14"/>
322 
				<textElement textAlignment="Center" verticalAlignment="Middle">
323 
					<font fontName="Arial" size="8"/>
324 
				</textElement>
325 
				<text><![CDATA[ABR]]></text>
326 
			</staticText>
327 
			<staticText>
328 
				<reportElement uuid="d7f21695-04da-4df3-8c66-e37cf533dab4" x="184" y="2" width="46" height="14"/>
329 
				<textElement textAlignment="Center" verticalAlignment="Middle">
330 
					<font fontName="Arial" size="8"/>
331 
				</textElement>
332 
				<text><![CDATA[MAI]]></text>
333 
			</staticText>
334 
			<staticText>
335 
				<reportElement uuid="705b39dd-cda3-4d1e-9e33-90b81ae02ba1" x="231" y="2" width="46" height="14"/>
336 
				<textElement textAlignment="Center" verticalAlignment="Middle">
337 
					<font fontName="Arial" size="8"/>
338 
				</textElement>
339 
				<text><![CDATA[JUN]]></text>
340 
			</staticText>
341 
			<staticText>
342 
				<reportElement uuid="6ce5646c-f68a-410a-bb91-e1b62d544199" x="277" y="2" width="46" height="14"/>
343 
				<textElement textAlignment="Center" verticalAlignment="Middle">
344 
					<font fontName="Arial" size="8"/>
345 
				</textElement>
346 
				<text><![CDATA[JUL]]></text>
347 
			</staticText>
348 
			<staticText>
349 
				<reportElement uuid="114e96df-745c-4891-977d-e79f96b9ef4e" x="323" y="2" width="46" height="14"/>
350 
				<textElement textAlignment="Center" verticalAlignment="Middle">
351 
					<font fontName="Arial" size="8"/>
352 
				</textElement>
353 
				<text><![CDATA[AGO]]></text>
354 
			</staticText>
355 
			<staticText>
356 
				<reportElement uuid="5a8d97de-e2b8-4413-ac19-5a0d5bd277f5" x="369" y="2" width="46" height="14"/>
357 
				<textElement textAlignment="Center" verticalAlignment="Middle">
358 
					<font fontName="Arial" size="8"/>
359 
				</textElement>
360 
				<text><![CDATA[SET]]></text>
361 
			</staticText>
362 
			<staticText>
363 
				<reportElement uuid="e924b46c-899c-4fa9-9c76-0089d7e26921" x="415" y="2" width="46" height="14"/>
364 
				<textElement textAlignment="Center" verticalAlignment="Middle">
365 
					<font fontName="Arial" size="8"/>
366 
				</textElement>
367 
				<text><![CDATA[OUT]]></text>
368 
			</staticText>
369 
			<staticText>
370 
				<reportElement uuid="da431fc3-299b-4dfe-8294-b9171d7ad22e" x="461" y="2" width="46" height="14"/>
371 
				<textElement textAlignment="Center" verticalAlignment="Middle">
372 
					<font fontName="Arial" size="8"/>
373 
				</textElement>
374 
				<text><![CDATA[NOV]]></text>
375 
			</staticText>
376 
			<staticText>
377 
				<reportElement uuid="156edd30-f933-4e9c-9c9e-d9382a3b0bc9" x="507" y="2" width="46" height="14"/>
378 
				<textElement textAlignment="Center" verticalAlignment="Middle">
379 
					<font fontName="Arial" size="8"/>
380 
				</textElement>
381 
				<text><![CDATA[DEZ]]></text>
382 
			</staticText>
383 
			<staticText>
384 
				<reportElement uuid="fc69e67e-3889-4564-80cd-e2527e5ee245" x="-1" y="34" width="127" height="15"/>
385 
				<textElement textAlignment="Right">
386 
					<font fontName="Arial" isBold="true"/>
387 
				</textElement>
388 
				<text><![CDATA[Total de Faltas no Ano:]]></text>
389 
			</staticText>
390 
			<textField>
391 
				<reportElement uuid="e84e4376-7e16-4ed4-892c-fc9838a630a9" x="128" y="34" width="100" height="15"/>
392 
				<textElement>
393 
					<font fontName="Arial"/>
394 
				</textElement>
395 
				<textFieldExpression><![CDATA[$F{total_falta_ano}]]></textFieldExpression>
396 
			</textField>
397 
			<line>
398 
				<reportElement uuid="ce3f9236-679b-49fe-a99c-f56cbfd5e945" x="553" y="1" width="1" height="29"/>
399 
				<graphicElement>
400 
					<pen lineWidth="0.5" lineStyle="Solid"/>
401 
				</graphicElement>
402 
			</line>
403 
		</band>
404 
	</detail>
405 
	<pageFooter>
406 
		<band height="20" splitType="Stretch">
407 
			<textField evaluationTime="Report" isBlankWhenNull="false">
408 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="499" y="3" width="52" height="15"/>
409 
				<textElement verticalAlignment="Middle">
410 
					<font fontName="Arial" size="6" isBold="false"/>
411 
				</textElement>
412 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
413 
			</textField>
414 
			<textField isBlankWhenNull="false">
415 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="424" y="3" width="73" height="15"/>
416 
				<textElement textAlignment="Right" verticalAlignment="Middle">
417 
					<font fontName="Arial" size="6" isBold="false"/>
418 
				</textElement>
419 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
420 
			</textField>
421 
			<textField isBlankWhenNull="true">
422 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="3" width="374" height="15"/>
423 
				<textElement verticalAlignment="Middle">
424 
					<font fontName="Arial" size="6" isBold="false"/>
425 
				</textElement>
426 
				<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>
427 
			</textField>
428 
		</band>
429 
	</pageFooter>
430 
</jasperReport>