<?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="rpt_pre_matricula" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="3.0"/>
	<property name="ireport.x" value="362"/>
	<property name="ireport.y" value="384"/>
	<parameter name="id_pre_matricula" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT
	*
FROM
	qry_pre_matricula_relatorio
WHERE
	id_pre_matricula = $P{id_pre_matricula}]]>
	</queryString>
	<field name="id_pre_matricula" class="java.lang.Integer"/>
	<field name="nome_aluno" class="java.lang.String"/>
	<field name="nome_curso" class="java.lang.String"/>
	<field name="nome_ano_serie" class="java.lang.String"/>
	<field name="nome_necessidade_especial" class="java.lang.String"/>
	<field name="sexo" class="java.lang.String"/>
	<field name="id_responsavel" class="java.lang.Integer"/>
	<field name="id_curso" class="java.lang.Integer"/>
	<field name="id_curso_ano_serie" class="java.lang.Integer"/>
	<field name="fez_inscricao_ano_anterior" class="java.lang.String"/>
	<field name="numero_inscricao_anterior" class="java.lang.String"/>
	<field name="data_nascimento" class="java.sql.Date"/>
	<field name="id_necessidade_especial" class="java.lang.Integer"/>
	<field name="doenca_cronica_incapacitante" class="java.lang.String"/>
	<field name="descricao_doenca_cronica_incapacitante" class="java.lang.String"/>
	<field name="registro_excluido" class="java.lang.Integer"/>
	<field name="id_bairro" class="java.lang.Integer"/>
	<field name="numero" class="java.lang.String"/>
	<field name="logradouro" class="java.lang.String"/>
	<field name="complemento" class="java.lang.String"/>
	<field name="cep" class="java.lang.String"/>
	<field name="nome" class="java.lang.String"/>
	<field name="cpf" class="java.lang.String"/>
	<field name="procedencia" class="java.lang.Integer"/>
	<field name="nome_escola_origem" class="java.lang.String"/>
	<field name="valor_aluguel" class="java.lang.Float"/>
	<field name="nome_bairro" class="java.lang.String"/>
	<field name="qnt_residentes_domicilio" class="java.lang.Integer"/>
	<field name="qnt_criancas_domicilio" class="java.lang.Integer"/>
	<field name="nome_familiar" class="java.lang.String"/>
	<field name="salario" class="java.lang.Float"/>
	<field name="adicionais" class="java.lang.Float"/>
	<field name="telefone" class="java.lang.String"/>
	<field name="telefone_2" class="java.lang.String"/>
	<field name="nome_grau_parentesco" class="java.lang.String"/>
	<field name="ocupacao" class="java.lang.String"/>
	<field name="renda_percapita" class="java.lang.Double"/>
	<field name="endereco_1" class="java.lang.String"/>
	<field name="endereco_2" class="java.lang.String"/>
	<field name="procedencia_2" class="java.lang.String"/>
	<field name="ocupacao_2" class="java.lang.String"/>
	<field name="data_nascimento_1" class="java.lang.Object"/>
	<field name="responsavel_familiar_registro_excluido" class="java.lang.Long"/>
	<field name="possui_bolsa_familia" class="java.lang.String"/>
	<field name="responsavel_tel_1" class="java.lang.String"/>
	<field name="responsavel_tel_2" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="445" splitType="Stretch">
			<textField>
				<reportElement x="2" y="58" width="236" height="20"/>
				<textElement verticalAlignment="Top">
					<font fontName="Arial" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nome_curso}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="448" y="58" width="107" height="20"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{id_pre_matricula}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="121" y="140" width="228" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{nome}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="162" y="276" width="308" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{procedencia_2}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="256" width="162" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Ano:]]></text>
			</staticText>
			<textField>
				<reportElement x="121" y="120" width="228" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{sexo}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="162" y="296" width="155" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{fez_inscricao_ano_anterior}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="121" y="80" width="228" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{nome_aluno}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="162" y="356" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{doenca_cronica_incapacitante}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="316" width="162" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Residentes no domicílio:]]></text>
			</staticText>
			<textField>
				<reportElement x="162" y="336" width="63" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{qnt_criancas_domicilio}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="121" y="180" width="228" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{endereco_2}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="120" width="114" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Sexo:]]></text>
			</staticText>
			<textField>
				<reportElement x="454" y="82" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{data_nascimento_1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="121" y="100" width="228" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{nome_necessidade_especial}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="162" y="316" width="63" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{qnt_residentes_domicilio}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="140" width="114" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Nome Responsável:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="336" width="162" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Crianças até 12 anos:]]></text>
			</staticText>
			<textField>
				<reportElement x="121" y="160" width="228" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{endereco_1}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="376" width="162" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Valor do aluguel:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="160" width="114" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Endereço:]]></text>
			</staticText>
			<staticText>
				<reportElement x="354" y="82" width="100" height="20"/>
				<textElement textAlignment="Right">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Data Nasc.:]]></text>
			</staticText>
			<textField>
				<reportElement x="162" y="376" width="155" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{valor_aluguel}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="80" width="114" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Nome do aluno(a):]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="100" width="114" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Necessidade especial:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="356" width="162" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Doença crônica / incapacitante:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="396" width="162" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Renda percapita:]]></text>
			</staticText>
			<textField>
				<reportElement x="162" y="396" width="155" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{renda_percapita}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="296" width="162" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Pré-Matrícula ano anterior:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="276" width="162" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Procedência:]]></text>
			</staticText>
			<textField>
				<reportElement x="162" y="256" width="86" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{nome_ano_serie}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="419" width="162" height="13"/>
				<textElement>
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Adultos residentes no domicílio:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="432" width="136" height="13"/>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Nome:]]></text>
			</staticText>
			<staticText>
				<reportElement x="136" y="432" width="89" height="13"/>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Grau de Parentesco:]]></text>
			</staticText>
			<staticText>
				<reportElement x="225" y="432" width="70" height="13"/>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Ocupação:]]></text>
			</staticText>
			<staticText>
				<reportElement x="2" y="0" width="293" height="17"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Estado do Rio de Janeiro]]></text>
			</staticText>
			<staticText>
				<reportElement x="2" y="21" width="293" height="17"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[PREFEITURA MUNICIPAL DE TERESÓPOLIS]]></text>
			</staticText>
			<staticText>
				<reportElement x="2" y="41" width="293" height="17"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Secretaria Municipal de Educação]]></text>
			</staticText>
			<staticText>
				<reportElement x="348" y="58" width="100" height="20"/>
				<textElement textAlignment="Right">
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Pré-Matrícula:]]></text>
			</staticText>
			<staticText>
				<reportElement x="295" y="432" width="75" height="13"/>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Salário:]]></text>
			</staticText>
			<staticText>
				<reportElement x="370" y="432" width="75" height="13"/>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Adicional:]]></text>
			</staticText>
			<staticText>
				<reportElement x="445" y="432" width="75" height="13"/>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Telefone:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="229" width="114" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Bolsa Família:]]></text>
			</staticText>
			<textField>
				<reportElement x="121" y="229" width="228" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{possui_bolsa_familia}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="201" width="114" height="20"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Telefone(s):]]></text>
			</staticText>
			<textField>
				<reportElement x="120" y="201" width="105" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{responsavel_tel_1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="225" y="201" width="105" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{responsavel_tel_2}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="14" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="136" height="14"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nome_familiar}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="136" y="0" width="89" height="14"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nome_grau_parentesco}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement positionType="Float" x="225" y="0" width="70" height="14"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ocupacao}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement positionType="Float" x="295" y="0" width="75" height="14"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{salario}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement positionType="Float" x="370" y="0" width="75" height="14"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{adicionais}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement positionType="Float" x="445" y="0" width="75" height="14"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{telefone}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement x="438" y="2" width="80" height="20"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement x="518" y="2" width="36" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy">
				<reportElement x="2" y="2" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="42" splitType="Stretch"/>
	</summary>
</jasperReport>
