<?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="rel_pes_aniversario" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" uuid="eab7cef0-def4-4941-b1f4-e98760261b87">
<property name="ireport.zoom" value="2.0"/>
<property name="ireport.x" value="460"/>
<property name="ireport.y" value="0"/>
<property name="ireport.callouts" value="##Sun Mar 27 18:31:22 BRT 2016"/>
<parameter name="pPessoa" class="java.lang.Integer">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select p.id, p.nome, p.fantasia, p.tipo, p.cpfCnpj, p.ie, p.dtCad, p.dtNasc, telefone1, telefone2, p.email, c.nome as cidade, c.uf, p.cep, p.endereco, p.numero, p.bairro, p.complemento, (select dataEmissao from docs where idCliForn = p.id order by registro desc limit 1) as dtUltimaComp, (select vlrTotal from docs where idCliForn = p.id order by registro desc limit 1) as vlrUltimaComp from pessoas p
left join cidades c on p.idCidade = c.id
where p.tipoPessoa = $P{pPessoa}]]>
</queryString>
<field name="id" class="java.lang.Integer">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="nome" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="fantasia" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="tipo" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="cpfCnpj" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="ie" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="dtCad" class="java.sql.Timestamp">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="dtNasc" class="java.sql.Date">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="telefone1" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="telefone2" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="email" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="cidade" class="java.lang.String"/>
<field name="uf" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="cep" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="endereco" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="numero" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="bairro" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="complemento" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="dtUltimaComp" class="java.sql.Date"/>
<field name="vlrUltimaComp" class="java.math.BigDecimal"/>
<title>
<band height="46" splitType="Stretch">
<line>
<reportElement x="0" y="0" width="555" height="1" uuid="95736449-f48e-447a-ba7e-1a118c79fd55"/>
</line>
<staticText>
<reportElement x="0" y="0" width="555" height="45" uuid="a9772369-b847-4883-9142-bc0765ada00d"/>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="18"/>
</textElement>
<text><![CDATA[RelatĂłrio de Clientes]]></text>
</staticText>
<line>
<reportElement x="0" y="45" width="555" height="1" uuid="56f720c8-19f1-4be1-97a0-6d982112adc8"/>
</line>
<textField pattern="EEEEE, dd MMMMM yyyy">
<reportElement x="445" y="18" width="110" height="10" uuid="5abbfbc4-4a9e-4d5f-94a4-59060e4afb0e"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
</band>
</title>
<pageHeader>
<band height="20"/>
</pageHeader>
<detail>
<band height="72" splitType="Stretch">
<textField>
<reportElement x="30" y="0" width="34" height="15" uuid="1d8d45a2-9826-4da1-8cf5-cff8193256a0"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("000000").format($F{id})]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="true">
<reportElement x="357" y="46" width="198" height="15" uuid="f75663e4-84db-43e6-8a7f-2b074ed98398"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{telefone1} + " " + $F{telefone2} + " " + ($F{email}.equals("") ? "" : $F{email} == null ? "" : $F{email})]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="0" width="30" height="15" uuid="abe0f995-9398-4478-80b2-7484e2ece688"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[CĂłdigo:]]></text>
</staticText>
<textField isBlankWhenNull="true">
<reportElement x="174" y="0" width="170" height="15" uuid="b625333b-e5fc-43aa-8e84-3e8907ca7365"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{nome}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="118" y="0" width="56" height="15" uuid="a22d2939-40f4-42a2-bbac-ed3b24f37034"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[RazĂŁo Soccial:]]></text>
</staticText>
<textField isBlankWhenNull="true">
<reportElement x="385" y="0" width="170" height="15" uuid="d502d380-e244-465b-ad32-4067e83a0b76"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{fantasia}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="71" y="0" width="37" height="15" uuid="ce062101-5fe0-41b1-a359-f5061f4795fc"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{tipo}.equals("F") ? "FĂsica" : "JurĂdica"]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="40" y="16" width="78" height="15" uuid="5ef857cc-da6f-4a1b-bfda-bcdad2445038"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{cpfCnpj}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="16" width="40" height="15" uuid="d81db634-18ec-4246-9628-a55b9844d1fc"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{tipo}.equals("F") ? "CPF: " : "CNPJ: "]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="158" y="16" width="41" height="15" uuid="8ee00e39-cf48-409b-870a-536222939943"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{ie}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="118" y="16" width="40" height="15" uuid="8efa313a-8a3a-4691-812a-50b2f1b14216"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[Inscrição:]]></text>
</staticText>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
<reportElement x="357" y="16" width="65" height="15" uuid="604a2591-15b4-449a-8459-cdf46e275cf3"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{dtCad}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="285" y="16" width="72" height="15" uuid="8e915516-db68-43f4-90e1-689f385b1327"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[Data de Cadastro: ]]></text>
</staticText>
<textField isBlankWhenNull="true">
<reportElement x="40" y="31" width="240" height="15" uuid="d6e26bd4-d6af-4732-92d9-4c5dd19e7ad2"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{endereco} + " " + $F{numero} + ($F{complemento} != null ? " " + $F{complemento} : "") + ($F{bairro}.equals("") ? "" : ", " + $F{bairro})]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="31" width="40" height="15" uuid="3225a5a6-1f36-471a-90ef-e38c327aaf90"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[Endereço:]]></text>
</staticText>
<staticText>
<reportElement x="0" y="46" width="40" height="15" uuid="5ac97150-817b-4ff4-a9fb-e5553bcc0c61"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[Cidade:]]></text>
</staticText>
<textField isBlankWhenNull="true">
<reportElement x="40" y="46" width="277" height="15" uuid="2481072f-a821-4f1f-b2a8-9c80a83a6cb6"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{cidade} + "/" + $F{uf} + ($F{cep} == null ? "" : $F{cep}.equals(" -") ? "" : " CEP: " + $F{cep})]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="317" y="46" width="40" height="15" uuid="e4aba5d1-db6e-4ff3-ac04-5ce9cbd6297c"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[Contatos: ]]></text>
</staticText>
<line>
<reportElement x="0" y="15" width="555" height="1" uuid="9ebea537-582c-4ab6-bca5-0c6eedfe1e22"/>
<graphicElement>
<pen lineStyle="Dotted"/>
</graphicElement>
</line>
<line>
<reportElement x="0" y="0" width="555" height="1" uuid="58b8e48b-228e-43a4-970d-bdad4dbbb096"/>
<graphicElement>
<pen lineStyle="Dotted"/>
</graphicElement>
</line>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
<reportElement x="357" y="31" width="65" height="15" uuid="41a6b23a-d8e2-4a89-b5ea-483a890bdc53"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{dtNasc}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="280" y="31" width="77" height="15" uuid="744c39b6-1c8b-43be-9ca5-71114796f4f9"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[Data de Nascimento: ]]></text>
</staticText>
<textField isBlankWhenNull="true">
<reportElement x="344" y="0" width="41" height="15" uuid="1917f8c6-d293-4f22-824d-45438062c3fd"/>
<textElement verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{tipo}.equals("F") ? "" : "Fantasia: "]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
<reportElement x="506" y="16" width="49" height="15" uuid="48dd2a0e-a198-451f-9e27-6fa97236fa94"/>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{dtUltimaComp}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="422" y="16" width="80" height="15" uuid="5db438cc-464e-4e6e-99cc-ccf815406699"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[Data Ăšltima Compra:]]></text>
</staticText>
<staticText>
<reportElement x="422" y="31" width="80" height="15" uuid="b0c570fc-d132-49ef-b0cd-3e48dc80236a"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<text><![CDATA[Valor Ăšltima Compra:]]></text>
</staticText>
<textField pattern="¤ #,##0.00" isBlankWhenNull="true">
<reportElement x="506" y="31" width="49" height="15" uuid="26ee6247-6044-4fea-84a6-8644be67b882"/>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{vlrUltimaComp}]]></textFieldExpression>
</textField>
</band>
</detail>
<pageFooter>
<band height="20">
<line>
<reportElement x="0" y="19" width="555" height="1" uuid="931503fb-5f7d-4e91-8552-7cf2a4764b46"/>
<graphicElement>
<pen lineStyle="Dotted"/>
</graphicElement>
</line>
<textField isStretchWithOverflow="true" evaluationTime="Report">
<reportElement positionType="Float" stretchType="RelativeToTallestObject" isPrintRepeatedValues="false" x="535" y="0" width="20" height="20" uuid="431e48be-6cc9-4488-9247-d7681d43a7d0"/>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="535" height="20" uuid="aab7047f-0af0-485b-af95-84ebd8f3e57f"/>
<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None">
<paragraph lineSpacing="Single"/>
</textElement>
<textFieldExpression><![CDATA["Página " + $V{PAGE_NUMBER} + " de "]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band height="15">
<textField pattern="###0.000">
<reportElement x="0" y="0" width="555" height="15" uuid="55ccd598-14c4-43d8-b608-774a5ccdb1e1"/>
<textElement verticalAlignment="Middle">
<font size="8" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["Total de Clientes: " + $V{REPORT_COUNT}]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>