<?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_ADIANTAMENTO_TRANSP_AGREGADO" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="1.6105100000000012"/>
	<property name="ireport.x" value="242"/>
	<property name="ireport.y" value="0"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<parameter name="LOGO" class="java.lang.String" isForPrompting="false"/>
	<parameter name="NOME_EMPRESA" class="java.lang.String"/>
	<parameter name="CNPJ_NOME" class="java.lang.String"/>
	<parameter name="INSCRICAO_ESTADUAL_NOME" class="java.lang.String"/>
	<parameter name="DATA_INICIAL" class="java.util.Date" isForPrompting="false"/>
	<parameter name="DATA_FINAL" class="java.util.Date" isForPrompting="false"/>
	<parameter name="FECHO" class="java.lang.String" isForPrompting="false"/>
	<parameter name="SUBREPORT_DIR_IND" class="java.lang.String" isForPrompting="false"/>
	<parameter name="ID_ADIANTAMENTO_AGREGADOS" class="java.lang.Long" isForPrompting="false"/>
	<parameter name="LOGO_RELATORIO" class="net.sf.jasperreports.engine.JRImageRenderer" isForPrompting="false"/>
	<queryString language="hql">
		<![CDATA[select
a.identificador as idAdiantamento,
a.valor as valor,
a.numParcelas as numParcelas,
a.data as dataAdiantamento,
a.numParcelas as parcelas,
a.observacao as observacao,
a.transportadorAgregado.identificador as idTranspAgregado,
a.transportadorAgregado.pessoa.nome as agregado,
a.transportadorAgregado.pessoa.complemento.cnpj as cnpj,
t.identificador as idTitulo,
t.dataVencimento as dataVencimentoTitulo,
t.numParcTituloEstnota as parcelaTitulo,
t.valor as valorTitulo
from AdiantamentoTransportadorAgregado a
inner join a.itensAdTranspAgregado i
inner join i.titulo t

WHERE a.identificador=$P{ID_ADIANTAMENTO_AGREGADOS}]]>
	</queryString>
	<field name="idAdiantamento" class="java.lang.Long"/>
	<field name="dataAdiantamento" class="java.util.Date"/>
	<field name="observacao" class="java.lang.String"/>
	<field name="parcelas" class="java.lang.Short"/>
	<field name="valor" class="java.lang.Double"/>
	<field name="idTranspAgregado" class="java.lang.Long"/>
	<field name="agregado" class="java.lang.String"/>
	<field name="cnpj" class="java.lang.String"/>
	<field name="idTitulo" class="java.lang.Long"/>
	<field name="parcelaTitulo" class="java.lang.Short"/>
	<field name="dataVencimentoTitulo" class="java.util.Date"/>
	<field name="valorTitulo" class="java.lang.Double"/>
	<variable name="dataRel" class="java.util.Date" resetType="Page">
		<initialValueExpression><![CDATA[new java.util.Date()]]></initialValueExpression>
	</variable>
	<group name="consumo">
		<groupExpression><![CDATA[$F{idAdiantamento}]]></groupExpression>
		<groupHeader>
			<band height="54">
				<staticText>
					<reportElement key="staticText-12" x="0" y="0" width="62" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Identificador:]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-17" x="112" y="0" width="73" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Data Adiantamento:]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement key="textField" x="75" y="0" width="37" height="10"/>
					<textElement textAlignment="Right">
						<font size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.Long"><![CDATA[$F{idAdiantamento}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement key="textField" x="190" y="0" width="47" height="10"/>
					<textElement textAlignment="Center">
						<font size="7"/>
					</textElement>
					<textFieldExpression class="java.util.Date"><![CDATA[$F{dataAdiantamento}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement x="0" y="30" width="530" height="11" isPrintWhenDetailOverflows="true"/>
					<textElement>
						<font size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{observacao}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="staticText-17" x="0" y="20" width="62" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Observação:]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-17" x="237" y="0" width="73" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Valor:]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-17" x="377" y="0" width="73" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Parcelas:]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-17" x="0" y="10" width="62" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Trans. Agregado:]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-17" positionType="Float" x="0" y="41" width="49" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Id. Título]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-17" positionType="Float" x="49" y="41" width="49" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Parcela:]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-17" positionType="Float" x="98" y="41" width="71" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Data Vencimento:]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-17" positionType="Float" x="169" y="41" width="71" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Valor:]]></text>
				</staticText>
				<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
					<reportElement key="textField" x="310" y="0" width="47" height="10"/>
					<textElement textAlignment="Right">
						<font size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.Double"><![CDATA[$F{valor}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement key="textField" x="450" y="0" width="47" height="10"/>
					<textElement textAlignment="Right">
						<font size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.Short"><![CDATA[$F{parcelas}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement key="textField" x="75" y="10" width="37" height="10"/>
					<textElement textAlignment="Right">
						<font size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.Long"><![CDATA[$F{idTranspAgregado}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement key="textField" x="117" y="10" width="283" height="10"/>
					<textElement>
						<font size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{agregado}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement key="textField" x="453" y="10" width="82" height="10"/>
					<textElement>
						<font size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{cnpj}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="staticText-17" x="400" y="10" width="50" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[CNPJ:]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band/>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="52" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-1" x="154" y="8" width="277" height="17"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="13" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{NOME_EMPRESA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-1" x="434" y="15" width="34" height="14"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Data :]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-2" x="434" y="31" width="34" height="14"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Hora :]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement key="textField-2" x="468" y="15" width="67" height="14"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="10"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$V{dataRel}]]></textFieldExpression>
			</textField>
			<textField pattern="HH.mm.ss" isBlankWhenNull="true">
				<reportElement key="textField-3" x="468" y="31" width="67" height="14"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="10"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$V{dataRel}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-3" x="159" y="32" width="27" height="12"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="8" isBold="true" isItalic="true" pdfFontName="Helvetica-BoldOblique"/>
				</textElement>
				<text><![CDATA[CNPJ :]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="268" y="32" width="77" height="12"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="8" isBold="true" isItalic="true" pdfFontName="Helvetica-BoldOblique"/>
				</textElement>
				<text><![CDATA[Inscrição Estadual :]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-4" x="187" y="32" width="79" height="12"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{CNPJ_NOME}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-5" x="346" y="32" width="84" height="12"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{INSCRICAO_ESTADUAL_NOME}]]></textFieldExpression>
			</textField>
			<image onErrorType="Blank">
				<reportElement key="image-1" x="0" y="0" width="154" height="52"/>
				<imageExpression class="net.sf.jasperreports.engine.JRRenderable"><![CDATA[$P{LOGO_RELATORIO}]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="29" splitType="Stretch">
			<line>
				<reportElement key="line-1" x="0" y="2" width="535" height="1"/>
				<graphicElement>
					<pen lineWidth="0.25"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement key="staticText-21" mode="Transparent" x="0" y="19" width="534" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
					<topPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Cadastro]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-20" x="0" y="5" width="534" height="14"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Relatório Individual: Adiantamento Transportador Agregado]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement positionType="Float" x="0" y="2" width="49" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Long"><![CDATA[$F{idTitulo}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement positionType="Float" x="49" y="2" width="49" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Short"><![CDATA[$F{parcelaTitulo}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement positionType="Float" x="0" y="15" width="535" height="1"/>
			</line>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement positionType="Float" x="98" y="2" width="71" height="10"/>
				<textElement textAlignment="Center">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{dataVencimentoTitulo}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement positionType="Float" x="169" y="2" width="71" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{valorTitulo}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="14" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-8" x="505" y="-1" width="11" height="15"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" isBlankWhenNull="true">
				<reportElement key="textField-9" x="524" y="-1" width="11" height="15"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-8" x="516" y="-1" width="8" height="15"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[/]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-11" x="400" y="-1" width="105" height="14" forecolor="#0066FF"/>
				<textElement textAlignment="Center">
					<font size="8" isItalic="true" isUnderline="true" pdfFontName="Helvetica-Oblique"/>
				</textElement>
				<text><![CDATA[TOUCHComp.com.br]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="17" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField-12" x="0" y="0" width="535" height="17" isRemoveLineWhenBlank="true"/>
				<textElement textAlignment="Center" markup="html"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{FECHO}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
