<?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="INDIVIDUAL_AVISOPREVIO" pageWidth="595" pageHeight="793" columnWidth="570" leftMargin="25" rightMargin="0" topMargin="38" bottomMargin="0" uuid="4c700b27-8bcd-41f3-a904-6b31edcc7ebb">
	<property name="ireport.zoom" value="0.6997610703145999"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="21"/>
	<parameter name="ID_RECISAO" class="java.lang.Long"/>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["D:\\Projetos\\Projeto Mentor\\Mentor Atual\\Mentor\\reports\\rh\\folhapagamento\\recisao\\"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
p.nome as NOME,
c.nome_mae as NOME_MAE,
e.logradouro as LOGRADOURO,
e.complemento AS COMPLEMENTO,
e.bairro AS BAIRRO,
e.numero AS NUMERO,
e.cep AS CEP,
u.sigla AS UF,
cp.cel1 as CELULAR,
C.numero_pis AS NUMERO_PIS,
C.carteira_profissional AS CARTEIRA_TRABALHO,
cp.cnpj AS CPF_COLABORADOR,
c.serie_carteira_profissional as SERIE_CARTEIRA,
UC.sigla AS UF_CARTEIRA,
F.descricao AS FUNCAO,
RH.cod_cnae AS CNAE,
CEM.cnpj AS CNPJ_EMPRESA,
c.data_admissao as DATA_ADMISSAO,
R.data_afastamento AS DATA_AFASTAMENTO,
CP.data_nascimento AS DATA_NASCIMENTO,
c.sexo as SEXO,
g.codigo as GRAU_INSTRUCAO,
c.jornada_semanal as JORNADA_SEMANAL,
r.aviso_previo_indenizado as AVISO_INDENIZADO,
CB.codigo AS CBO ,
r.id_recisao,
C.ID_COLABORADOR AS ID_COLABORADOR

 from recisao    r
inner join colaborador c   on c.id_colaborador = r.id_colaborador
inner join pessoa      p   on p.id_pessoa = c.id_pessoa
inner join endereco    e   on e.id_endereco = p.id_endereco
inner join cidade      cid on cid.id_cidade = e.id_cidade
inner join uf          u   on u.id_uf = cid.id_uf
inner join complemento cp  on cp.id_complemento = p.id_complemento
INNER JOIN FUNCAO      F   ON F.id_funcao = C.id_funcao
INNER JOIN empresa_rh  RH  ON RH.id_empresa = C.id_empresa
INNER JOIN EMPRESA     EMP ON EMP.id_emp = C.id_empresa
INNER JOIN PESSOA      PEM ON PEM.id_pessoa = EMP.id_pessoa
INNER JOIN COMPLEMENTO CEM ON CEM.id_complemento = PEM.id_complemento
INNER JOIN grau_instrucao g on g.id_grau_instrucao = c.id_grau_instrucao
INNER JOIN CBO         CB  ON CB.id_cbo=F.id_cbo
LEFT JOIN UF           uc  on uc.id_uf = c.id_uf_cart_profissional
WHERE r.id_recisao = $P{ID_RECISAO}]]>
	</queryString>
	<field name="NOME" class="java.lang.String"/>
	<field name="NOME_MAE" class="java.lang.String"/>
	<field name="LOGRADOURO" class="java.lang.String"/>
	<field name="COMPLEMENTO" class="java.lang.String"/>
	<field name="BAIRRO" class="java.lang.String"/>
	<field name="NUMERO" class="java.lang.String"/>
	<field name="CEP" class="java.lang.String"/>
	<field name="UF" class="java.lang.String"/>
	<field name="CELULAR" class="java.lang.String"/>
	<field name="NUMERO_PIS" class="java.lang.String"/>
	<field name="CARTEIRA_TRABALHO" class="java.lang.String"/>
	<field name="CPF_COLABORADOR" class="java.lang.String"/>
	<field name="SERIE_CARTEIRA" class="java.lang.String"/>
	<field name="UF_CARTEIRA" class="java.lang.String"/>
	<field name="FUNCAO" class="java.lang.String"/>
	<field name="CNAE" class="java.lang.String"/>
	<field name="CNPJ_EMPRESA" class="java.lang.String"/>
	<field name="DATA_ADMISSAO" class="java.sql.Date"/>
	<field name="DATA_AFASTAMENTO" class="java.sql.Date"/>
	<field name="DATA_NASCIMENTO" class="java.sql.Date"/>
	<field name="SEXO" class="java.lang.Integer"/>
	<field name="GRAU_INSTRUCAO" class="java.lang.String"/>
	<field name="JORNADA_SEMANAL" class="java.lang.Double"/>
	<field name="AVISO_INDENIZADO" class="java.lang.Integer"/>
	<field name="CBO" class="java.lang.String"/>
	<field name="ID_RECISAO" class="java.lang.Integer"/>
	<field name="ID_COLABORADOR" class="java.lang.Integer"/>
	<variable name="dataEmpresa" class="java.lang.String">
		<variableExpression><![CDATA[]]></variableExpression>
	</variable>
	<variable name="dataVencPrimeiroIntervalo" class="java.lang.String">
		<variableExpression><![CDATA[]]></variableExpression>
	</variable>
	<title>
		<band height="509" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="16" y="60" width="553" height="13" uuid="9e350159-43a1-45f7-88f5-ea54f75a292d"/>
				<textElement>
					<font size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{NOME}.toUpperCase()]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="16" y="96" width="552" height="13" uuid="ff59bb09-c94e-4e0f-a932-af55fde4ed94"/>
				<textElement>
					<font size="10"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{NOME_MAE}.toUpperCase()]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="16" y="134" width="551" height="13" uuid="9d3f8a90-760f-4f9c-b399-ab954a2decf3"/>
				<textElement>
					<font size="10"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{LOGRADOURO}.toUpperCase()+
($F{NUMERO}!=null?", "+$F{NUMERO}.toUpperCase():"")+
($F{BAIRRO}!=null?", "+$F{BAIRRO}.toUpperCase():"")]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="16" y="170" width="236" height="13" uuid="8251f743-2276-484c-b3d7-3f879b0c2d4c"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{COMPLEMENTO}.toUpperCase()]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="462" y="170" width="83" height="13" uuid="aae91682-65bd-4ce1-b19b-290b051d8d36"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CELULAR}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="16" y="204" width="200" height="13" uuid="0134cc2d-4cb0-485b-b632-5560e1f92475"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{NUMERO_PIS}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="218" y="204" width="92" height="13" uuid="5eb5ebe7-0d21-41b2-b048-dcdfd7a5928a"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CARTEIRA_TRABALHO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="318" y="204" width="44" height="13" uuid="4dba2b4d-bf37-4830-ad3e-0aa6cf99e803"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SERIE_CARTEIRA}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="362" y="204" width="31" height="13" uuid="6dfd1e33-91a0-4561-a2f6-5fe5cf8b92a2"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{UF_CARTEIRA}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="443" y="204" width="129" height="13" uuid="ee3d06e6-6940-499f-b3a8-07648cad9499"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CPF_COLABORADOR}.substring(0,3)+"."+$F{CPF_COLABORADOR}.substring(3,6)+"."+
$F{CPF_COLABORADOR}.substring(6,9)+"-"+$F{CPF_COLABORADOR}.substring(9)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="77" y="239" width="10" height="13" uuid="4da2a0c6-ddaa-45b9-854f-41caa4f83b92"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA["1"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="114" y="239" width="227" height="13" uuid="496945eb-1f64-4373-8da9-2d77be3eb04d"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CNPJ_EMPRESA}.substring(0,2)+"."+
$F{CNPJ_EMPRESA}.substring(2,5)+"."+
$F{CNPJ_EMPRESA}.substring(5,8)+"/"+
$F{CNPJ_EMPRESA}.substring(8,12)+"-"+
$F{CNPJ_EMPRESA}.substring(12)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="358" y="239" width="91" height="13" uuid="9c5ddf4a-e6eb-4960-aa54-c1fe3723a931"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CNAE}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="21" y="278" width="103" height="13" uuid="1765dbb8-372b-477c-afca-b641e655b3a7"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CBO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="129" y="278" width="286" height="13" uuid="da187436-17cb-47c1-9ac8-52ff660b028b"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{FUNCAO}.toUpperCase()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="24" y="348" width="102" height="13" uuid="6bbf31a8-6e06-4d24-97ef-5e78e187d8de"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("dd").format($F{DATA_ADMISSAO})
+"       "+
new java.text.SimpleDateFormat("MM").format($F{DATA_ADMISSAO})
+"       "+
new java.text.SimpleDateFormat("yy").format($F{DATA_ADMISSAO})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="134" y="348" width="128" height="13" uuid="6eac23c3-d4d9-4bc8-b149-0d409fdc01b1"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("dd").format($F{DATA_AFASTAMENTO})
+"       "+
new java.text.SimpleDateFormat("MM").format($F{DATA_AFASTAMENTO})
+"       "+
new java.text.SimpleDateFormat("yy").format($F{DATA_AFASTAMENTO})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="292" y="348" width="23" height="13" uuid="43e5614e-b0d9-46b2-bda7-4b4bf9fc3a32"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SEXO}.intValue()==0?1:2]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="377" y="348" width="16" height="13" uuid="7bfe4431-fc83-4313-9d72-49f6513a18b8"/>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{GRAU_INSTRUCAO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="395" y="348" width="103" height="13" uuid="f39110ed-7e2b-4393-a9db-4e949c3c23ef"/>
				<textElement textAlignment="Center">
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.text.SimpleDateFormat("dd").format($F{DATA_NASCIMENTO})
+"       "+
new java.text.SimpleDateFormat("MM").format($F{DATA_NASCIMENTO})
+"       "+
new java.text.SimpleDateFormat("yy").format($F{DATA_NASCIMENTO})]]></textFieldExpression>
			</textField>
			<textField pattern="###0;-###0">
				<reportElement x="509" y="348" width="42" height="13" uuid="ad474a28-fa68-4e2c-bf1d-805abc8e833f"/>
				<textElement textAlignment="Right">
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{JORNADA_SEMANAL}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="260" y="170" width="110" height="13" uuid="30289d5f-22a3-4115-9379-53607f157ed3"/>
				<textFieldExpression><![CDATA[$F{CEP}.substring(0,5)+"-"+$F{CEP}.substring(5)]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="391" y="170" width="51" height="13" uuid="b3a9bcb6-e50a-41f0-8efe-eeaec0050e48"/>
				<textFieldExpression><![CDATA[$F{UF}.toUpperCase()]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement x="16" y="381" width="553" height="30" uuid="32065b35-269c-4f17-b418-cc917d7aefef"/>
				<subreportParameter name="ID_COLABORADOR">
					<subreportParameterExpression><![CDATA[$F{ID_COLABORADOR}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA["SUBREPORT_RESCISAO.jasper"]]></subreportExpression>
			</subreport>
		</band>
	</title>
</jasperReport>
