Subversion Repositories Integrator Subversion

Rev

Blame | Last modification | View Log | Download | RSS feed 

<?xml version="1.0" encoding="UTF-8"?>
<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">
        <property name="ireport.zoom" value="1.126972201352367"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="96"/>
        <parameter name="pSeqServidor" class="java.lang.Long">
                <defaultValueExpression><![CDATA[41985L]]></defaultValueExpression>
        </parameter>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <parameter name="IMAGE_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[select                 CASE s.tip_situacao_cadastral
              WHEN 'H' THEN 'HOMOLOGADO'
              WHEN 'V' THEN 'VALIDADO'
              WHEN 'P' THEN 'PENDENTE'
          END as servidor_situacao_cadastral,
          pf.nom_pessoa as servidor_nome,
          CASE pf.tip_sexo
              WHEN 'M' THEN 'MASCULINO'
              WHEN 'F' THEN 'FEMININO'
          END as servidor_sexo,
          pf.nom_mae as servidor_nome_mae,
          pf.nom_pai as servidor_nome_pai,
          CASE pf.tip_estado_civil
              WHEN 'S' THEN 'SOLTEIRO'
              WHEN 'C' THEN 'CASADO'
              WHEN 'D' THEN 'DIVORCIADO'
              WHEN 'V' THEN 'VIÚVO'
          END as servidor_estado_civil,
          to_char(pf.dat_nascimento, 'dd/mm/yyyy') as servidor_data_nascimento,
          gu.dsc_grau_instrucao as servidor_grau_instrucao,
          n.dsc_nacionalidade as servidor_nacionalidade,
          d.dsc_deficiencia as servidor_deficiencia,
          pf.nom_logradouro as endereco_logradouro,
          pf.num_imovel as endereco_numero,
          pf.nom_bairro as endereco_bairro,
          pf.cod_cep as enderedo_cep,
          pf.dsc_complemento as endereco_complemento,
          pf.nom_municipio as endereco_municipio,
          sl.num_caixa,
          sl.num_pasta,
          sl.num_prateleira,
          CASE sl.tip_lado
          WHEN 'E' THEN 'ESQUERDO'
          WHEN 'D' THEN 'DIREITO'
          END AS tip_lado,
          s.obj_foto as servidor_foto
  from          sc_srv.srv_servidor s
  inner join    sc_scg.vw_pessoa_fisica pf on pf.seq_pessoa = s.seq_pessoa_servidor
  left join     sc_srv.srv_servidor_localizacaoarquivo sl on sl.seq_pessoa_servidor = s.seq_pessoa_servidor
  left join     sc_srv.srv_grau_instrucao gu on gu.cod_grau_instrucao = s.cod_grau_instrucao
  left join     sc_srv.srv_nacionalidade n on n.cod_nacionalidade = s.cod_nacionalidade
  left join     sc_srv.srv_deficiencia d on d.cod_deficiencia = s.cod_deficiencia
  where                 s.seq_pessoa_servidor = $P{pSeqServidor}]]>
        </queryString>
        <field name="servidor_situacao_cadastral" class="java.lang.String"/>
        <field name="servidor_nome" class="java.lang.String"/>
        <field name="servidor_sexo" class="java.lang.String"/>
        <field name="servidor_nome_mae" class="java.lang.String"/>
        <field name="servidor_nome_pai" class="java.lang.String"/>
        <field name="servidor_estado_civil" class="java.lang.String"/>
        <field name="servidor_data_nascimento" class="java.lang.String"/>
        <field name="servidor_grau_instrucao" class="java.lang.String"/>
        <field name="servidor_nacionalidade" class="java.lang.String"/>
        <field name="servidor_deficiencia" class="java.lang.String"/>
        <field name="endereco_logradouro" class="java.lang.String"/>
        <field name="endereco_numero" class="java.lang.String"/>
        <field name="endereco_bairro" class="java.lang.String"/>
        <field name="enderedo_cep" class="java.lang.String"/>
        <field name="endereco_complemento" class="java.lang.String"/>
        <field name="endereco_municipio" class="java.lang.String"/>
        <field name="num_caixa" class="java.lang.String"/>
        <field name="num_pasta" class="java.lang.String"/>
        <field name="num_prateleira" class="java.lang.Integer"/>
        <field name="tip_lado" class="java.lang.String"/>
        <field name="servidor_foto" class="java.lang.Object"/>
        <background>
                <band splitType="Stretch"/>
        </background>
        <pageHeader>
                <band height="118">
                        <rectangle>
                                <reportElement uuid="fe2e713f-26b5-459a-b6b3-5b7bcad61a92" isPrintRepeatedValues="false" x="0" y="10" width="80" height="100">
                                        <printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
                                </reportElement>
                        </rectangle>
                        <image scaleImage="FillFrame" onErrorType="Blank" evaluationTime="Report">
                                <reportElement uuid="f62a2dbf-5afa-4c02-8edb-2130414718b5" isPrintRepeatedValues="false" x="0" y="10" width="80" height="100">
                                        <printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1 && $F{servidor_foto} == null]]></printWhenExpression>
                                </reportElement>
                                <imageExpression><![CDATA[$P{IMAGE_DIR} + "sem_foto.jpg"]]></imageExpression>
                        </image>
                        <image scaleImage="FillFrame" isUsingCache="true" onErrorType="Blank" evaluationTime="Report">
                                <reportElement uuid="b58be868-e52d-4b28-8407-b4b8d436189b" isPrintRepeatedValues="false" x="0" y="10" width="80" height="100">
                                        <printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1 && $F{servidor_foto} != null]]></printWhenExpression>
                                </reportElement>
                                <imageExpression><![CDATA[new ByteArrayInputStream((byte[])$F{servidor_foto})]]></imageExpression>
                        </image>
                        <image hAlign="Right">
                                <reportElement uuid="9cc0d6bd-ba27-4a57-903c-0182a11a1f53" x="380" y="0" width="48" height="59" isPrintWhenDetailOverflows="true"/>
                                <imageExpression><![CDATA[$P{IMAGE_DIR} + "brasao.jpg"]]></imageExpression>
                        </image>
                        <staticText>
                                <reportElement uuid="36f361c7-c2c5-4f4b-9918-4f375cff39d2" x="252" y="62" width="298" height="40" isPrintWhenDetailOverflows="true"/>
                                <textElement textAlignment="Center" verticalAlignment="Top">
                                        <font fontName="Arial" size="10" isBold="true"/>
                                </textElement>
                                <text><![CDATA[ESTADO DE ALAGOAS
SECRETARIA DE ESTADO DA SAÚDE DE ALAGOAS
FICHA CADASTRAL]]></text>
                        </staticText>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="605" y="94" width="106" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[SITUAÇÃO CADASTRAL:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" x="711" y="94" width="89" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement textAlignment="Right" verticalAlignment="Middle">
                                        <font fontName="Arial" size="10" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{servidor_situacao_cadastral}]]></textFieldExpression>
                        </textField>
                </band>
        </pageHeader>
        <detail>
                <band height="90">
                        <rectangle>
                                <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="1" width="802" height="15"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="75" width="802" height="15"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="60" width="802" height="15"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="45" width="802" height="15"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="30" width="802" height="15"/>
                        </rectangle>
                        <rectangle>
                                <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="15" width="802" height="15"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="15" width="30" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[NOME:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="30" y="15" width="290" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{servidor_nome}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="320" y="15" width="30" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[SEXO:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="350" y="15" width="245" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{servidor_sexo}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="30" width="55" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[NOME DA MÃE:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="55" y="30" width="265" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{servidor_nome_mae}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="320" y="30" width="55" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[NOME DO PAI:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="375" y="30" width="220" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{servidor_nome_pai}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="595" y="15" width="80" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[DATA DE NASCIMENTO:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="675" y="15" width="125" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{servidor_data_nascimento}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="45" width="80" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[GRAU DE INSTRUÇÃO:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="80" y="45" width="240" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{servidor_grau_instrucao}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="320" y="45" width="65" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[NACIONALIDADE:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="385" y="45" width="210" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{servidor_nacionalidade}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="595" y="45" width="52" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[DEFICIÊNCIA:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="648" y="45" width="152" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{servidor_deficiencia}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="595" y="30" width="55" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[ESTADO CIVIL:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="650" y="30" width="150" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{servidor_estado_civil}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="60" width="60" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[LOGRADOURO:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="60" y="60" width="260" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{endereco_logradouro}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="320" y="60" width="40" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[NÚMERO:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="360" y="60" width="235" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{endereco_numero}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="595" y="60" width="37" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[BAIRRO:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="630" y="60" width="170" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{endereco_bairro}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="595" y="75" width="25" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[CEP:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="620" y="75" width="180" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{enderedo_cep}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="75" width="60" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[COMPLEMENTO:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="60" y="75" width="260" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{endereco_complemento}]]></textFieldExpression>
                        </textField>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="320" y="75" width="45" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[MUNICÍPIO:]]></text>
                        </staticText>
                        <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                                <reportElement uuid="22be9c67-2e66-47f4-839b-66695fed20fb" isPrintRepeatedValues="false" x="365" y="75" width="230" height="15" isPrintWhenDetailOverflows="true"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="8" isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{endereco_municipio}]]></textFieldExpression>
                        </textField>
                        <rectangle>
                                <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                        </rectangle>
                        <staticText>
                                <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" mode="Transparent" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="10"/>
                                        <paragraph leftIndent="5"/>
                                </textElement>
                                <text><![CDATA[DADOS PESSOAIS:]]></text>
                        </staticText>
                </band>
                <band height="45">
                        <frame>
                                <reportElement uuid="eaea0cef-699c-41ba-b69f-b38eb867f8e9" x="0" y="0" width="802" height="45"/>
                                <rectangle>
                                        <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" mode="Opaque" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                                </rectangle>
                                <subreport>
                                        <reportElement uuid="fd68e999-a392-4091-b874-e28bca3bcbb9" stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="15" width="802" height="30" isPrintWhenDetailOverflows="true"/>
                                        <subreportParameter name="pSeqServidor">
                                                <subreportParameterExpression><![CDATA[$P{pSeqServidor}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                        <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_ficha_cadastral_subreport_documentos.jasper"]]></subreportExpression>
                                </subreport>
                                <staticText>
                                        <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" mode="Transparent" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="10"/>
                                                <paragraph leftIndent="5"/>
                                        </textElement>
                                        <text><![CDATA[DOCUMENTOS:]]></text>
                                </staticText>
                                <rectangle>
                                        <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"/>
                                        <graphicElement>
                                                <pen lineWidth="1.0"/>
                                        </graphicElement>
                                </rectangle>
                        </frame>
                </band>
                <band height="15">
                        <frame>
                                <reportElement uuid="12cc43e6-c516-43e3-a03f-33d1d7921d96" x="0" y="0" width="802" height="15"/>
                                <rectangle>
                                        <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" positionType="Float" stretchType="RelativeToBandHeight" mode="Transparent" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                                        <graphicElement>
                                                <pen lineWidth="1.0"/>
                                        </graphicElement>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" x="0" y="0" width="60" height="15"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="8"/>
                                                <paragraph leftIndent="5"/>
                                        </textElement>
                                        <text><![CDATA[TELEFONES:]]></text>
                                </staticText>
                                <subreport>
                                        <reportElement uuid="a7dd6846-d926-43e9-8486-5d1a98ec3f86" stretchType="RelativeToTallestObject" x="60" y="0" width="742" height="15" isPrintWhenDetailOverflows="true"/>
                                        <subreportParameter name="pSeqServidor">
                                                <subreportParameterExpression><![CDATA[$P{pSeqServidor}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                        <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_ficha_cadastral_subreport_telefones.jasper"]]></subreportExpression>
                                </subreport>
                        </frame>
                </band>
                <band height="30">
                        <frame>
                                <reportElement uuid="dc3062d1-092f-423a-941c-0ca5eda9ae21" x="0" y="0" width="802" height="30"/>
                                <rectangle>
                                        <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" mode="Opaque" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" mode="Transparent" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="10"/>
                                                <paragraph leftIndent="5"/>
                                        </textElement>
                                        <text><![CDATA[DADOS BANCÁRIOS:]]></text>
                                </staticText>
                                <subreport>
                                        <reportElement uuid="5ef4cb30-ca69-44ff-9d7c-7091ddfe12ff" stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="15" width="802" height="15" isPrintWhenDetailOverflows="true"/>
                                        <subreportParameter name="pSeqServidor">
                                                <subreportParameterExpression><![CDATA[$P{pSeqServidor}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                        <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_ficha_cadastral_subreport_dados_bancarios.jasper"]]></subreportExpression>
                                </subreport>
                                <rectangle>
                                        <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"/>
                                </rectangle>
                        </frame>
                </band>
                <band height="30">
                        <frame>
                                <reportElement uuid="3b3a2366-26b5-44f3-ac08-8e576e247662" x="0" y="0" width="802" height="30"/>
                                <rectangle>
                                        <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" mode="Opaque" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" mode="Transparent" x="0" y="0" width="802" height="15" backcolor="#CCCCCC"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="10"/>
                                                <paragraph leftIndent="5"/>
                                        </textElement>
                                        <text><![CDATA[DEPENDENTES:]]></text>
                                </staticText>
                                <subreport>
                                        <reportElement uuid="5d82ad8b-c05f-449f-bc18-3c784847a8f1" stretchType="RelativeToTallestObject" x="0" y="15" width="802" height="15" isPrintWhenDetailOverflows="true"/>
                                        <subreportParameter name="pSeqServidor">
                                                <subreportParameterExpression><![CDATA[$P{pSeqServidor}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                        <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_ficha_cadastral_subreport_dependentes.jasper"]]></subreportExpression>
                                </subreport>
                                <rectangle>
                                        <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"/>
                                </rectangle>
                        </frame>
                </band>
                <band height="145">
                        <frame>
                                <reportElement uuid="f93ad87a-ccce-4a58-ba30-6b80a10a8d34" x="0" y="0" width="802" height="145"/>
                                <rectangle>
                                        <reportElement uuid="eabe0b10-cbe6-48c3-9f2c-8cb3e250585d" mode="Opaque" x="0" y="0" width="802" height="15" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                </rectangle>
                                <staticText>
                                        <reportElement uuid="1fc8b309-e701-4d89-85a6-bf4f5156bb18" mode="Transparent" x="0" y="0" width="802" height="15" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" backcolor="#CCCCCC"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="10"/>
                                                <paragraph leftIndent="5"/>
                                        </textElement>
                                        <text><![CDATA[DADOS FUNCIONAIS:]]></text>
                                </staticText>
                                <subreport>
                                        <reportElement uuid="af06a338-8702-4f73-aa2d-03f4f9151636" positionType="Float" stretchType="RelativeToTallestObject" x="0" y="15" width="802" height="130" isPrintWhenDetailOverflows="true"/>
                                        <subreportParameter name="pSeqServidor">
                                                <subreportParameterExpression><![CDATA[$P{pSeqServidor}]]></subreportParameterExpression>
                                        </subreportParameter>
                                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                        <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "relatorio_ficha_cadastral_subreport_dados_funcionais.jasper"]]></subreportExpression>
                                </subreport>
                                <staticText>
                                        <reportElement uuid="30e55a38-357f-4082-abac-5aa55b7f228d" x="518" y="0" width="21" height="15"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="6"/>
                                        </textElement>
                                        <text><![CDATA[CAIXA:]]></text>
                                </staticText>
                                <textField isBlankWhenNull="true">
                                        <reportElement uuid="76c2e020-7a81-4b63-8c78-82669a2fbc23" x="549" y="0" width="16" height="15"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="8" isBold="true"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$F{num_caixa}]]></textFieldExpression>
                                </textField>
                                <staticText>
                                        <reportElement uuid="6df0e1bb-3d5b-4c87-b56c-c10e5193ce7b" x="400" y="0" width="124" height="15"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="8" isBold="false"/>
                                        </textElement>
                                        <text><![CDATA[LOCALIZAÇÃO NO ARQUIVO:]]></text>
                                </staticText>
                                <staticText>
                                        <reportElement uuid="be818f05-6d2b-49a9-8910-a63051b89e3b" x="573" y="0" width="22" height="15"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="6"/>
                                        </textElement>
                                        <text><![CDATA[PASTA:]]></text>
                                </staticText>
                                <textField isBlankWhenNull="true">
                                        <reportElement uuid="83f9232e-9ae2-4940-93bf-0b20881d96ee" x="602" y="0" width="18" height="15"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="8" isBold="true"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$F{num_pasta}]]></textFieldExpression>
                                </textField>
                                <staticText>
                                        <reportElement uuid="e2b40b82-d42d-4ca7-b3a5-52b72b7140a7" x="619" y="0" width="47" height="15"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="6"/>
                                        </textElement>
                                        <text><![CDATA[PRATELEIRA:]]></text>
                                </staticText>
                                <textField isBlankWhenNull="true">
                                        <reportElement uuid="4e317b35-31ca-4880-8ede-04197088038d" x="661" y="0" width="24" height="15"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="8" isBold="true"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$F{num_prateleira}]]></textFieldExpression>
                                </textField>
                                <staticText>
                                        <reportElement uuid="1a61f59f-b410-4c85-9260-1547b0430654" x="682" y="0" width="19" height="15"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="6"/>
                                        </textElement>
                                        <text><![CDATA[LADO:]]></text>
                                </staticText>
                                <textField isBlankWhenNull="true">
                                        <reportElement uuid="cc841aa4-0842-4964-bc9d-cb8225bccff9" x="711" y="0" width="59" height="15"/>
                                        <textElement verticalAlignment="Middle">
                                                <font fontName="Arial" size="8" isBold="true"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$F{tip_lado}]]></textFieldExpression>
                                </textField>
                        </frame>
                </band>
        </detail>
        <pageFooter>
                <band height="30">
                        <textField evaluationTime="Report" isBlankWhenNull="false">
                                <reportElement uuid="506b9991-ff6d-43b5-ab78-2832586c3dda" key="textField" x="428" y="10" width="52" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="false">
                                <reportElement uuid="e5f06c72-11c0-479b-b234-4dcaf2bc0440" key="textField" x="353" y="10" width="73" height="15"/>
                                <textElement textAlignment="Right" verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <textFieldExpression><![CDATA["PÁGINA " + $V{PAGE_NUMBER} + " DE "]]></textFieldExpression>
                        </textField>
                        <textField isBlankWhenNull="true">
                                <reportElement uuid="0ad83100-9e7e-42de-97b6-51dc07b7dd68" x="0" y="10" width="208" height="15"/>
                                <textElement verticalAlignment="Middle">
                                        <font fontName="Arial" size="6" isBold="false"/>
                                </textElement>
                                <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>
                        </textField>
                </band>
        </pageFooter>
</jasperReport>