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_ficha_cadastral" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="a9bd3a8d-3d73-4ab7-8540-556997aa680b">
3 
	<property name="ireport.zoom" value="1.126972201352367"/>
4 
	<property name="ireport.x" value="0"/>
5 
	<property name="ireport.y" value="96"/>
6 
	<parameter name="pSeqServidor" class="java.lang.Long">
7 
		<defaultValueExpression><![CDATA[41985L]]></defaultValueExpression>
8 
	</parameter>
9 
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
10 
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
11 
	</parameter>
12 
	<parameter name="IMAGE_DIR" class="java.lang.String" isForPrompting="false">
13 
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
14 
	</parameter>
15 
	<queryString>
16 
		<![CDATA[select 		CASE s.tip_situacao_cadastral
17 
              WHEN 'H' THEN 'HOMOLOGADO'
18 
              WHEN 'V' THEN 'VALIDADO'
19 
              WHEN 'P' THEN 'PENDENTE'
20 
          END as servidor_situacao_cadastral,
21 
          pf.nom_pessoa as servidor_nome,
22 
          CASE pf.tip_sexo
23 
              WHEN 'M' THEN 'MASCULINO'
24 
              WHEN 'F' THEN 'FEMININO'
25 
          END as servidor_sexo,
26 
          pf.nom_mae as servidor_nome_mae,
27 
          pf.nom_pai as servidor_nome_pai,
28 
          CASE pf.tip_estado_civil
29 
              WHEN 'S' THEN 'SOLTEIRO'
30 
              WHEN 'C' THEN 'CASADO'
31 
              WHEN 'D' THEN 'DIVORCIADO'
32 
              WHEN 'V' THEN 'VIÚVO'
33 
          END as servidor_estado_civil,
34 
          to_char(pf.dat_nascimento, 'dd/mm/yyyy') as servidor_data_nascimento,
35 
          gu.dsc_grau_instrucao as servidor_grau_instrucao,
36 
          n.dsc_nacionalidade as servidor_nacionalidade,
37 
          d.dsc_deficiencia as servidor_deficiencia,
38 
          pf.nom_logradouro as endereco_logradouro,
39 
          pf.num_imovel as endereco_numero,
40 
          pf.nom_bairro as endereco_bairro,
41 
          pf.cod_cep as enderedo_cep,
42 
          pf.dsc_complemento as endereco_complemento,
43 
          pf.nom_municipio as endereco_municipio,
44 
          sl.num_caixa,
45 
          sl.num_pasta,
46 
          sl.num_prateleira,
47 
          CASE sl.tip_lado
48 
          WHEN 'E' THEN 'ESQUERDO'
49 
          WHEN 'D' THEN 'DIREITO'
50 
          END AS tip_lado,
51 
          s.obj_foto as servidor_foto
52 
  from 		sc_srv.srv_servidor s
53 
  inner join	sc_scg.vw_pessoa_fisica pf on pf.seq_pessoa = s.seq_pessoa_servidor
54 
  left join	sc_srv.srv_servidor_localizacaoarquivo sl on sl.seq_pessoa_servidor = s.seq_pessoa_servidor
55 
  left join	sc_srv.srv_grau_instrucao gu on gu.cod_grau_instrucao = s.cod_grau_instrucao
56 
  left join	sc_srv.srv_nacionalidade n on n.cod_nacionalidade = s.cod_nacionalidade
57 
  left join	sc_srv.srv_deficiencia d on d.cod_deficiencia = s.cod_deficiencia
58 
  where 		s.seq_pessoa_servidor = $P{pSeqServidor}]]>
59 
	</queryString>
60 
	<field name="servidor_situacao_cadastral" class="java.lang.String"/>
61 
	<field name="servidor_nome" class="java.lang.String"/>
62 
	<field name="servidor_sexo" class="java.lang.String"/>
63 
	<field name="servidor_nome_mae" class="java.lang.String"/>
64 
	<field name="servidor_nome_pai" class="java.lang.String"/>
65 
	<field name="servidor_estado_civil" class="java.lang.String"/>
66 
	<field name="servidor_data_nascimento" class="java.lang.String"/>
67 
	<field name="servidor_grau_instrucao" class="java.lang.String"/>
68 
	<field name="servidor_nacionalidade" class="java.lang.String"/>
69 
	<field name="servidor_deficiencia" class="java.lang.String"/>
70 
	<field name="endereco_logradouro" class="java.lang.String"/>
71 
	<field name="endereco_numero" class="java.lang.String"/>
72 
	<field name="endereco_bairro" class="java.lang.String"/>
73 
	<field name="enderedo_cep" class="java.lang.String"/>
74 
	<field name="endereco_complemento" class="java.lang.String"/>
75 
	<field name="endereco_municipio" class="java.lang.String"/>
76 
	<field name="num_caixa" class="java.lang.String"/>
77 
	<field name="num_pasta" class="java.lang.String"/>
78 
	<field name="num_prateleira" class="java.lang.Integer"/>
79 
	<field name="tip_lado" class="java.lang.String"/>
80 
	<field name="servidor_foto" class="java.lang.Object"/>
81 
	<background>
82 
		<band splitType="Stretch"/>
83 
	</background>
84 
	<pageHeader>
85 
		<band height="118">
86 
			<rectangle>
87 
				<reportElement uuid="fe2e713f-26b5-459a-b6b3-5b7bcad61a92" isPrintRepeatedValues="false" x="0" y="10" width="80" height="100">
88 
					<printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
89 
				</reportElement>
90 
			</rectangle>
91 
			<image scaleImage="FillFrame" onErrorType="Blank" evaluationTime="Report">
92 
				<reportElement uuid="f62a2dbf-5afa-4c02-8edb-2130414718b5" isPrintRepeatedValues="false" x="0" y="10" width="80" height="100">
93 
					<printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1 && $F{servidor_foto} == null]]></printWhenExpression>
94 
				</reportElement>
95 
				<imageExpression><![CDATA[$P{IMAGE_DIR} + "sem_foto.jpg"]]></imageExpression>
96 
			</image>
97 
			<image scaleImage="FillFrame" isUsingCache="true" onErrorType="Blank" evaluationTime="Report">
98 
				<reportElement uuid="b58be868-e52d-4b28-8407-b4b8d436189b" isPrintRepeatedValues="false" x="0" y="10" width="80" height="100">
99 
					<printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1 && $F{servidor_foto} != null]]></printWhenExpression>
100 
				</reportElement>
101 
				<imageExpression><![CDATA[new ByteArrayInputStream((byte[])$F{servidor_foto})]]></imageExpression>
102 
			</image>
103 
			<image hAlign="Right">
104 
				<reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="380" y="0" width="48" height="59" isPrintWhenDetailOverflows="true"/>
105 
				<imageExpression><![CDATA[$P{IMAGE_DIR} + "brasao.jpg"]]></imageExpression>
106 
			</image>
107 
			<staticText>
108 
				<reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="252" y="62" width="298" height="40" isPrintWhenDetailOverflows="true"/>
109 
				<textElement textAlignment="Center" verticalAlignment="Top">
110 
					<font fontName="Arial" size="10" isBold="true"/>
111 
				</textElement>
112 
				<text><![CDATA[ESTADO DE ALAGOAS
113 
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS
114 
FICHA CADASTRAL]]></text>
115 
			</staticText>
116 
			<staticText>
117 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="605" y="94" width="106" height="15" isPrintWhenDetailOverflows="true"/>
118 
				<textElement verticalAlignment="Middle">
119 
					<font fontName="Arial" size="8"/>
120 
					<paragraph leftIndent="5"/>
121 
				</textElement>
122 
				<text><![CDATA[SITUAÇÃO CADASTRAL:]]></text>
123 
			</staticText>
124 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
125 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" x="711" y="94" width="89" height="15" isPrintWhenDetailOverflows="true"/>
126 
				<textElement textAlignment="Right" verticalAlignment="Middle">
127 
					<font fontName="Arial" size="10" isBold="true"/>
128 
				</textElement>
129 
				<textFieldExpression><![CDATA[$F{servidor_situacao_cadastral}]]></textFieldExpression>
130 
			</textField>
131 
		</band>
132 
	</pageHeader>
133 
	<detail>
134 
		<band height="90">
135 
			<rectangle>
136 
				<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="1" width="802" height="15"/>
137 
			</rectangle>
138 
			<rectangle>
139 
				<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="75" width="802" height="15"/>
140 
			</rectangle>
141 
			<rectangle>
142 
				<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="60" width="802" height="15"/>
143 
			</rectangle>
144 
			<rectangle>
145 
				<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="45" width="802" height="15"/>
146 
			</rectangle>
147 
			<rectangle>
148 
				<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="30" width="802" height="15"/>
149 
			</rectangle>
150 
			<rectangle>
151 
				<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="15" width="802" height="15"/>
152 
			</rectangle>
153 
			<staticText>
154 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="15" width="30" height="15"/>
155 
				<textElement verticalAlignment="Middle">
156 
					<font fontName="Arial" size="6"/>
157 
					<paragraph leftIndent="5"/>
158 
				</textElement>
159 
				<text><![CDATA[NOME:]]></text>
160 
			</staticText>
161 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
162 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="30" y="15" width="290" height="15" isPrintWhenDetailOverflows="true"/>
163 
				<textElement verticalAlignment="Middle">
164 
					<font fontName="Arial" size="8" isBold="true"/>
165 
				</textElement>
166 
				<textFieldExpression><![CDATA[$F{servidor_nome}]]></textFieldExpression>
167 
			</textField>
168 
			<staticText>
169 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="320" y="15" width="30" height="15"/>
170 
				<textElement verticalAlignment="Middle">
171 
					<font fontName="Arial" size="6"/>
172 
					<paragraph leftIndent="5"/>
173 
				</textElement>
174 
				<text><![CDATA[SEXO:]]></text>
175 
			</staticText>
176 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
177 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="350" y="15" width="245" height="15" isPrintWhenDetailOverflows="true"/>
178 
				<textElement verticalAlignment="Middle">
179 
					<font fontName="Arial" size="8" isBold="true"/>
180 
				</textElement>
181 
				<textFieldExpression><![CDATA[$F{servidor_sexo}]]></textFieldExpression>
182 
			</textField>
183 
			<staticText>
184 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="30" width="55" height="15"/>
185 
				<textElement verticalAlignment="Middle">
186 
					<font fontName="Arial" size="6"/>
187 
					<paragraph leftIndent="5"/>
188 
				</textElement>
189 
				<text><![CDATA[NOME DA MÃE:]]></text>
190 
			</staticText>
191 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
192 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="55" y="30" width="265" height="15" isPrintWhenDetailOverflows="true"/>
193 
				<textElement verticalAlignment="Middle">
194 
					<font fontName="Arial" size="8" isBold="true"/>
195 
				</textElement>
196 
				<textFieldExpression><![CDATA[$F{servidor_nome_mae}]]></textFieldExpression>
197 
			</textField>
198 
			<staticText>
199 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="320" y="30" width="55" height="15"/>
200 
				<textElement verticalAlignment="Middle">
201 
					<font fontName="Arial" size="6"/>
202 
					<paragraph leftIndent="5"/>
203 
				</textElement>
204 
				<text><![CDATA[NOME DO PAI:]]></text>
205 
			</staticText>
206 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
207 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="375" y="30" width="220" height="15" isPrintWhenDetailOverflows="true"/>
208 
				<textElement verticalAlignment="Middle">
209 
					<font fontName="Arial" size="8" isBold="true"/>
210 
				</textElement>
211 
				<textFieldExpression><![CDATA[$F{servidor_nome_pai}]]></textFieldExpression>
212 
			</textField>
213 
			<staticText>
214 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="595" y="15" width="80" height="15"/>
215 
				<textElement verticalAlignment="Middle">
216 
					<font fontName="Arial" size="6"/>
217 
					<paragraph leftIndent="5"/>
218 
				</textElement>
219 
				<text><![CDATA[DATA DE NASCIMENTO:]]></text>
220 
			</staticText>
221 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
222 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="675" y="15" width="125" height="15" isPrintWhenDetailOverflows="true"/>
223 
				<textElement verticalAlignment="Middle">
224 
					<font fontName="Arial" size="8" isBold="true"/>
225 
				</textElement>
226 
				<textFieldExpression><![CDATA[$F{servidor_data_nascimento}]]></textFieldExpression>
227 
			</textField>
228 
			<staticText>
229 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="45" width="80" height="15"/>
230 
				<textElement verticalAlignment="Middle">
231 
					<font fontName="Arial" size="6"/>
232 
					<paragraph leftIndent="5"/>
233 
				</textElement>
234 
				<text><![CDATA[GRAU DE INSTRUÇÃO:]]></text>
235 
			</staticText>
236 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
237 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="80" y="45" width="240" height="15" isPrintWhenDetailOverflows="true"/>
238 
				<textElement verticalAlignment="Middle">
239 
					<font fontName="Arial" size="8" isBold="true"/>
240 
				</textElement>
241 
				<textFieldExpression><![CDATA[$F{servidor_grau_instrucao}]]></textFieldExpression>
242 
			</textField>
243 
			<staticText>
244 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="320" y="45" width="65" height="15"/>
245 
				<textElement verticalAlignment="Middle">
246 
					<font fontName="Arial" size="6"/>
247 
					<paragraph leftIndent="5"/>
248 
				</textElement>
249 
				<text><![CDATA[NACIONALIDADE:]]></text>
250 
			</staticText>
251 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
252 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="385" y="45" width="210" height="15" isPrintWhenDetailOverflows="true"/>
253 
				<textElement verticalAlignment="Middle">
254 
					<font fontName="Arial" size="8" isBold="true"/>
255 
				</textElement>
256 
				<textFieldExpression><![CDATA[$F{servidor_nacionalidade}]]></textFieldExpression>
257 
			</textField>
258 
			<staticText>
259 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="595" y="45" width="52" height="15"/>
260 
				<textElement verticalAlignment="Middle">
261 
					<font fontName="Arial" size="6"/>
262 
					<paragraph leftIndent="5"/>
263 
				</textElement>
264 
				<text><![CDATA[DEFICIÊNCIA:]]></text>
265 
			</staticText>
266 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
267 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="648" y="45" width="152" height="15" isPrintWhenDetailOverflows="true"/>
268 
				<textElement verticalAlignment="Middle">
269 
					<font fontName="Arial" size="8" isBold="true"/>
270 
				</textElement>
271 
				<textFieldExpression><![CDATA[$F{servidor_deficiencia}]]></textFieldExpression>
272 
			</textField>
273 
			<staticText>
274 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="595" y="30" width="55" height="15"/>
275 
				<textElement verticalAlignment="Middle">
276 
					<font fontName="Arial" size="6"/>
277 
					<paragraph leftIndent="5"/>
278 
				</textElement>
279 
				<text><![CDATA[ESTADO CIVIL:]]></text>
280 
			</staticText>
281 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
282 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="650" y="30" width="150" height="15" isPrintWhenDetailOverflows="true"/>
283 
				<textElement verticalAlignment="Middle">
284 
					<font fontName="Arial" size="8" isBold="true"/>
285 
				</textElement>
286 
				<textFieldExpression><![CDATA[$F{servidor_estado_civil}]]></textFieldExpression>
287 
			</textField>
288 
			<staticText>
289 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="60" width="60" height="15"/>
290 
				<textElement verticalAlignment="Middle">
291 
					<font fontName="Arial" size="6"/>
292 
					<paragraph leftIndent="5"/>
293 
				</textElement>
294 
				<text><![CDATA[LOGRADOURO:]]></text>
295 
			</staticText>
296 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
297 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="60" y="60" width="260" height="15" isPrintWhenDetailOverflows="true"/>
298 
				<textElement verticalAlignment="Middle">
299 
					<font fontName="Arial" size="8" isBold="true"/>
300 
				</textElement>
301 
				<textFieldExpression><![CDATA[$F{endereco_logradouro}]]></textFieldExpression>
302 
			</textField>
303 
			<staticText>
304 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="320" y="60" width="40" height="15"/>
305 
				<textElement verticalAlignment="Middle">
306 
					<font fontName="Arial" size="6"/>
307 
					<paragraph leftIndent="5"/>
308 
				</textElement>
309 
				<text><![CDATA[NÚMERO:]]></text>
310 
			</staticText>
311 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
312 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="360" y="60" width="235" height="15" isPrintWhenDetailOverflows="true"/>
313 
				<textElement verticalAlignment="Middle">
314 
					<font fontName="Arial" size="8" isBold="true"/>
315 
				</textElement>
316 
				<textFieldExpression><![CDATA[$F{endereco_numero}]]></textFieldExpression>
317 
			</textField>
318 
			<staticText>
319 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="595" y="60" width="37" height="15"/>
320 
				<textElement verticalAlignment="Middle">
321 
					<font fontName="Arial" size="6"/>
322 
					<paragraph leftIndent="5"/>
323 
				</textElement>
324 
				<text><![CDATA[BAIRRO:]]></text>
325 
			</staticText>
326 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
327 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="630" y="60" width="170" height="15" isPrintWhenDetailOverflows="true"/>
328 
				<textElement verticalAlignment="Middle">
329 
					<font fontName="Arial" size="8" isBold="true"/>
330 
				</textElement>
331 
				<textFieldExpression><![CDATA[$F{endereco_bairro}]]></textFieldExpression>
332 
			</textField>
333 
			<staticText>
334 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="595" y="75" width="25" height="15"/>
335 
				<textElement verticalAlignment="Middle">
336 
					<font fontName="Arial" size="6"/>
337 
					<paragraph leftIndent="5"/>
338 
				</textElement>
339 
				<text><![CDATA[CEP:]]></text>
340 
			</staticText>
341 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
342 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="620" y="75" width="180" height="15" isPrintWhenDetailOverflows="true"/>
343 
				<textElement verticalAlignment="Middle">
344 
					<font fontName="Arial" size="8" isBold="true"/>
345 
				</textElement>
346 
				<textFieldExpression><![CDATA[$F{enderedo_cep}]]></textFieldExpression>
347 
			</textField>
348 
			<staticText>
349 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="75" width="60" height="15"/>
350 
				<textElement verticalAlignment="Middle">
351 
					<font fontName="Arial" size="6"/>
352 
					<paragraph leftIndent="5"/>
353 
				</textElement>
354 
				<text><![CDATA[COMPLEMENTO:]]></text>
355 
			</staticText>
356 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
357 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="60" y="75" width="260" height="15" isPrintWhenDetailOverflows="true"/>
358 
				<textElement verticalAlignment="Middle">
359 
					<font fontName="Arial" size="8" isBold="true"/>
360 
				</textElement>
361 
				<textFieldExpression><![CDATA[$F{endereco_complemento}]]></textFieldExpression>
362 
			</textField>
363 
			<staticText>
364 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="320" y="75" width="45" height="15"/>
365 
				<textElement verticalAlignment="Middle">
366 
					<font fontName="Arial" size="6"/>
367 
					<paragraph leftIndent="5"/>
368 
				</textElement>
369 
				<text><![CDATA[MUNICÍPIO:]]></text>
370 
			</staticText>
371 
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
372 
				<reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="365" y="75" width="230" height="15" isPrintWhenDetailOverflows="true"/>
373 
				<textElement verticalAlignment="Middle">
374 
					<font fontName="Arial" size="8" isBold="true"/>
375 
				</textElement>
376 
				<textFieldExpression><![CDATA[$F{endereco_municipio}]]></textFieldExpression>
377 
			</textField>
378 
			<rectangle>
379 
				<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
380 
			</rectangle>
381 
			<staticText>
382 
				<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" mode="Transparent" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
383 
				<textElement verticalAlignment="Middle">
384 
					<font fontName="Arial" size="10"/>
385 
					<paragraph leftIndent="5"/>
386 
				</textElement>
387 
				<text><![CDATA[DADOS PESSOAIS:]]></text>
388 
			</staticText>
389 
		</band>
390 
		<band height="45">
391 
			<frame>
392 
				<reportElement uuid="eaea0cef-699c-41ba-b69f-b38eb867f8e9" x="0" y="0" width="802" height="45"/>
393 
				<rectangle>
394 
					<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" mode="Opaque" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
395 
				</rectangle>
396 
				<subreport>
397 
					<reportElement uuid="fd68e999-a392-4091-b874-e28bca3bcbb9" stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="15" width="802" height="30" isPrintWhenDetailOverflows="true"/>
398 
					<subreportParameter name="pSeqServidor">
399 
						<subreportParameterExpression><![CDATA[$P{pSeqServidor}]]></subreportParameterExpression>
400 
					</subreportParameter>
401 
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
402 
					<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_ficha_cadastral_subreport_documentos.jasper"]]></subreportExpression>
403 
				</subreport>
404 
				<staticText>
405 
					<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" mode="Transparent" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
406 
					<textElement verticalAlignment="Middle">
407 
						<font fontName="Arial" size="10"/>
408 
						<paragraph leftIndent="5"/>
409 
					</textElement>
410 
					<text><![CDATA[DOCUMENTOS:]]></text>
411 
				</staticText>
412 
				<rectangle>
413 
					<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" positionType="Float" stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="15" width="802" height="30" isRemoveLineWhenBlank="true" backcolor="#CCCCCC"/>
414 
					<graphicElement>
415 
						<pen lineWidth="1.0"/>
416 
					</graphicElement>
417 
				</rectangle>
418 
			</frame>
419 
		</band>
420 
		<band height="15">
421 
			<frame>
422 
				<reportElement uuid="12cc43e6-c516-43e3-a03f-33d1d7921d96" x="0" y="0" width="802" height="15"/>
423 
				<rectangle>
424 
					<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" positionType="Float" stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
425 
					<graphicElement>
426 
						<pen lineWidth="1.0"/>
427 
					</graphicElement>
428 
				</rectangle>
429 
				<staticText>
430 
					<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="0" width="60" height="15"/>
431 
					<textElement verticalAlignment="Middle">
432 
						<font fontName="Arial" size="8"/>
433 
						<paragraph leftIndent="5"/>
434 
					</textElement>
435 
					<text><![CDATA[TELEFONES:]]></text>
436 
				</staticText>
437 
				<subreport>
438 
					<reportElement uuid="a7dd6846-d926-43e9-8486-5d1a98ec3f86" stretchType="RelativeToTallestObject" x="60" y="0" width="742" height="15" isPrintWhenDetailOverflows="true"/>
439 
					<subreportParameter name="pSeqServidor">
440 
						<subreportParameterExpression><![CDATA[$P{pSeqServidor}]]></subreportParameterExpression>
441 
					</subreportParameter>
442 
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
443 
					<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_ficha_cadastral_subreport_telefones.jasper"]]></subreportExpression>
444 
				</subreport>
445 
			</frame>
446 
		</band>
447 
		<band height="30">
448 
			<frame>
449 
				<reportElement uuid="dc3062d1-092f-423a-941c-0ca5eda9ae21" x="0" y="0" width="802" height="30"/>
450 
				<rectangle>
451 
					<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" mode="Opaque" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
452 
				</rectangle>
453 
				<staticText>
454 
					<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" mode="Transparent" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
455 
					<textElement verticalAlignment="Middle">
456 
						<font fontName="Arial" size="10"/>
457 
						<paragraph leftIndent="5"/>
458 
					</textElement>
459 
					<text><![CDATA[DADOS BANCÁRIOS:]]></text>
460 
				</staticText>
461 
				<subreport>
462 
					<reportElement uuid="5ef4cb30-ca69-44ff-9d7c-7091ddfe12ff" stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="15" width="802" height="15" isPrintWhenDetailOverflows="true"/>
463 
					<subreportParameter name="pSeqServidor">
464 
						<subreportParameterExpression><![CDATA[$P{pSeqServidor}]]></subreportParameterExpression>
465 
					</subreportParameter>
466 
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
467 
					<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_ficha_cadastral_subreport_dados_bancarios.jasper"]]></subreportExpression>
468 
				</subreport>
469 
				<rectangle>
470 
					<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" positionType="Float" stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="15" width="802" height="15" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
471 
				</rectangle>
472 
			</frame>
473 
		</band>
474 
		<band height="30">
475 
			<frame>
476 
				<reportElement uuid="3b3a2366-26b5-44f3-ac08-8e576e247662" x="0" y="0" width="802" height="30"/>
477 
				<rectangle>
478 
					<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" mode="Opaque" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
479 
				</rectangle>
480 
				<staticText>
481 
					<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" mode="Transparent" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
482 
					<textElement verticalAlignment="Middle">
483 
						<font fontName="Arial" size="10"/>
484 
						<paragraph leftIndent="5"/>
485 
					</textElement>
486 
					<text><![CDATA[DEPENDENTES:]]></text>
487 
				</staticText>
488 
				<subreport>
489 
					<reportElement uuid="5d82ad8b-c05f-449f-bc18-3c784847a8f1" stretchType="RelativeToTallestObject" x="0" y="15" width="802" height="15" isPrintWhenDetailOverflows="true"/>
490 
					<subreportParameter name="pSeqServidor">
491 
						<subreportParameterExpression><![CDATA[$P{pSeqServidor}]]></subreportParameterExpression>
492 
					</subreportParameter>
493 
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
494 
					<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_ficha_cadastral_subreport_dependentes.jasper"]]></subreportExpression>
495 
				</subreport>
496 
				<rectangle>
497 
					<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" positionType="Float" stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="15" width="802" height="15" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" backcolor="#FFFFFF"/>
498 
				</rectangle>
499 
			</frame>
500 
		</band>
501 
		<band height="145">
502 
			<frame>
503 
				<reportElement uuid="f93ad87a-ccce-4a58-ba30-6b80a10a8d34" x="0" y="0" width="802" height="145"/>
504 
				<rectangle>
505 
					<reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" mode="Opaque" x="0" y="0" width="802" height="15" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
506 
				</rectangle>
507 
				<staticText>
508 
					<reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" mode="Transparent" x="0" y="0" width="802" height="15" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
509 
					<textElement verticalAlignment="Middle">
510 
						<font fontName="Arial" size="10"/>
511 
						<paragraph leftIndent="5"/>
512 
					</textElement>
513 
					<text><![CDATA[DADOS FUNCIONAIS:]]></text>
514 
				</staticText>
515 
				<subreport>
516 
					<reportElement uuid="af06a338-8702-4f73-aa2d-03f4f9151636" positionType="Float" stretchType="RelativeToTallestObject" x="0" y="15" width="802" height="130" isPrintWhenDetailOverflows="true"/>
517 
					<subreportParameter name="pSeqServidor">
518 
						<subreportParameterExpression><![CDATA[$P{pSeqServidor}]]></subreportParameterExpression>
519 
					</subreportParameter>
520 
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
521 
					<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_ficha_cadastral_subreport_dados_funcionais.jasper"]]></subreportExpression>
522 
				</subreport>
523 
				<staticText>
524 
					<reportElement uuid="30e55a38-357f-4082-abac-5aa55b7f228d" x="518" y="0" width="21" height="15"/>
525 
					<textElement verticalAlignment="Middle">
526 
						<font fontName="Arial" size="6"/>
527 
					</textElement>
528 
					<text><![CDATA[CAIXA:]]></text>
529 
				</staticText>
530 
				<textField isBlankWhenNull="true">
531 
					<reportElement uuid="76c2e020-7a81-4b63-8c78-82669a2fbc23" x="549" y="0" width="16" height="15"/>
532 
					<textElement verticalAlignment="Middle">
533 
						<font fontName="Arial" size="8" isBold="true"/>
534 
					</textElement>
535 
					<textFieldExpression><![CDATA[$F{num_caixa}]]></textFieldExpression>
536 
				</textField>
537 
				<staticText>
538 
					<reportElement uuid="6df0e1bb-3d5b-4c87-b56c-c10e5193ce7b" x="400" y="0" width="124" height="15"/>
539 
					<textElement verticalAlignment="Middle">
540 
						<font fontName="Arial" size="8" isBold="false"/>
541 
					</textElement>
542 
					<text><![CDATA[LOCALIZAÇÃO NO ARQUIVO:]]></text>
543 
				</staticText>
544 
				<staticText>
545 
					<reportElement uuid="be818f05-6d2b-49a9-8910-a63051b89e3b" x="573" y="0" width="22" height="15"/>
546 
					<textElement verticalAlignment="Middle">
547 
						<font fontName="Arial" size="6"/>
548 
					</textElement>
549 
					<text><![CDATA[PASTA:]]></text>
550 
				</staticText>
551 
				<textField isBlankWhenNull="true">
552 
					<reportElement uuid="83f9232e-9ae2-4940-93bf-0b20881d96ee" x="602" y="0" width="18" height="15"/>
553 
					<textElement verticalAlignment="Middle">
554 
						<font fontName="Arial" size="8" isBold="true"/>
555 
					</textElement>
556 
					<textFieldExpression><![CDATA[$F{num_pasta}]]></textFieldExpression>
557 
				</textField>
558 
				<staticText>
559 
					<reportElement uuid="e2b40b82-d42d-4ca7-b3a5-52b72b7140a7" x="619" y="0" width="47" height="15"/>
560 
					<textElement verticalAlignment="Middle">
561 
						<font fontName="Arial" size="6"/>
562 
					</textElement>
563 
					<text><![CDATA[PRATELEIRA:]]></text>
564 
				</staticText>
565 
				<textField isBlankWhenNull="true">
566 
					<reportElement uuid="4e317b35-31ca-4880-8ede-04197088038d" x="661" y="0" width="24" height="15"/>
567 
					<textElement verticalAlignment="Middle">
568 
						<font fontName="Arial" size="8" isBold="true"/>
569 
					</textElement>
570 
					<textFieldExpression><![CDATA[$F{num_prateleira}]]></textFieldExpression>
571 
				</textField>
572 
				<staticText>
573 
					<reportElement uuid="1a61f59f-b410-4c85-9260-1547b0430654" x="682" y="0" width="19" height="15"/>
574 
					<textElement verticalAlignment="Middle">
575 
						<font fontName="Arial" size="6"/>
576 
					</textElement>
577 
					<text><![CDATA[LADO:]]></text>
578 
				</staticText>
579 
				<textField isBlankWhenNull="true">
580 
					<reportElement uuid="cc841aa4-0842-4964-bc9d-cb8225bccff9" x="711" y="0" width="59" height="15"/>
581 
					<textElement verticalAlignment="Middle">
582 
						<font fontName="Arial" size="8" isBold="true"/>
583 
					</textElement>
584 
					<textFieldExpression><![CDATA[$F{tip_lado}]]></textFieldExpression>
585 
				</textField>
586 
			</frame>
587 
		</band>
588 
	</detail>
589 
	<pageFooter>
590 
		<band height="30">
591 
			<textField evaluationTime="Report" isBlankWhenNull="false">
592 
				<reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="428" y="10" width="52" height="15"/>
593 
				<textElement verticalAlignment="Middle">
594 
					<font fontName="Arial" size="6" isBold="false"/>
595 
				</textElement>
596 
				<textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
597 
			</textField>
598 
			<textField isBlankWhenNull="false">
599 
				<reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="353" y="10" width="73" height="15"/>
600 
				<textElement textAlignment="Right" verticalAlignment="Middle">
601 
					<font fontName="Arial" size="6" isBold="false"/>
602 
				</textElement>
603 
				<textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
604 
			</textField>
605 
			<textField isBlankWhenNull="true">
606 
				<reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="10" width="208" height="15"/>
607 
				<textElement verticalAlignment="Middle">
608 
					<font fontName="Arial" size="6" isBold="false"/>
609 
				</textElement>
610 
				<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>
611 
			</textField>
612 
		</band>
613 
	</pageFooter>
614 
</jasperReport>