<?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_IMP_SALDO" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="ID_IMPLANTA_SALDO" class="java.lang.Integer"/>
	<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="FECHO" class="java.lang.String" isForPrompting="false"/>
	<parameter name="LOGO_RELATORIO" class="net.sf.jasperreports.engine.JRImageRenderer" isForPrompting="false"/>
	<queryString>
		<![CDATA[select

    i.id_implanta_saldo,
    i.DATA_ENTRADA_SAIDA,
    P.ID_PRODUTO,
    P.NOME AS PRODUTO,
    l.ID_LOTE_FABRICACAO,
    l.LOTE_FABRICACAO,
    l.DATA_VALIDADE,
    c.NOME AS COR,
    g.QUANTIDADE

       from implantacao_saldo i
inner join ITEM_IMPLANTA_SALDO it on it.ID_IMPLANTA_SALDOS = i.ID_IMPLANTA_SALDO
inner join GRADE_ITEM_IMP_SALDO g on g.ID_ITEM_IMP_SALDO = it.ID_ITEM_IMPLANTA_SALDO
left join GRADE_COR           gc on gc.ID_GRADE_COR = g.ID_GRADE_COR
left join cor                  c on c.ID_COR = gc.ID_COR
left join LOTE_FABRICACAO       l on l.ID_LOTE_FABRICACAO = g.ID_LOTE_FABRICACAO
inner join PRODUTO              P ON P.ID_PRODUTO = IT.ID_PRODUTO

where

    i.id_implanta_saldo = $P{ID_IMPLANTA_SALDO}

ORDER BY

    i.id_implanta_saldo,
    P.ID_PRODUTO]]>
	</queryString>
	<field name="ID_IMPLANTA_SALDO" class="java.lang.Integer"/>
	<field name="DATA_ENTRADA_SAIDA" class="java.sql.Date"/>
	<field name="ID_PRODUTO" class="java.lang.Integer"/>
	<field name="PRODUTO" class="java.lang.String"/>
	<field name="ID_LOTE_FABRICACAO" class="java.lang.Long"/>
	<field name="LOTE_FABRICACAO" class="java.lang.String"/>
	<field name="DATA_VALIDADE" class="java.sql.Date"/>
	<field name="COR" class="java.lang.String"/>
	<field name="QUANTIDADE" class="java.math.BigDecimal"/>
	<variable name="dataRel" class="java.util.Date">
		<initialValueExpression><![CDATA[new java.util.Date()]]></initialValueExpression>
	</variable>
	<group name="IMPLANTACAO">
		<groupExpression><![CDATA[$F{ID_IMPLANTA_SALDO}]]></groupExpression>
		<groupHeader>
			<band height="30">
				<rectangle>
					<reportElement x="0" y="4" width="555" height="12" backcolor="#A49898"/>
				</rectangle>
				<staticText>
					<reportElement key="staticText-17" x="132" y="5" width="65" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Data Entrada:]]></text>
				</staticText>
				<textField>
					<reportElement x="66" y="5" width="48" height="10"/>
					<textElement textAlignment="Center">
						<font size="7"/>
					</textElement>
					<textFieldExpression class="java.lang.Integer"><![CDATA[$F{ID_IMPLANTA_SALDO}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy">
					<reportElement x="198" y="5" width="100" height="10"/>
					<textElement textAlignment="Center">
						<font size="7"/>
					</textElement>
					<textFieldExpression class="java.util.Date"><![CDATA[$F{DATA_ENTRADA_SAIDA}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="staticText-12" x="10" y="5" width="57" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Identificador:]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-5" x="363" y="20" width="50" height="10"/>
					<textElement textAlignment="Center">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Validade]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-4" x="279" y="20" width="81" height="10"/>
					<textElement>
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Lote de Fabricação]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-6" x="417" y="20" width="73" height="10"/>
					<textElement>
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Cor]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-2" x="14" y="20" width="212" height="10"/>
					<textElement>
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Produto]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-7" x="493" y="20" width="61" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Quantidade]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-3" x="228" y="20" width="48" height="10"/>
					<textElement textAlignment="Right">
						<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Id. Lote]]></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="164" 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-3" x="169" 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>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-5" x="356" 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>
			<staticText>
				<reportElement key="staticText-4" x="278" 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="197" 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 pattern="HH.mm.ss" isBlankWhenNull="true">
				<reportElement key="textField-3" x="478" 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>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement key="textField-2" x="478" 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>
			<staticText>
				<reportElement key="staticText-1" x="444" 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="444" 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>
			<image onErrorType="Blank">
				<reportElement key="image-1" x="10" y="0" width="154" height="52"/>
				<imageExpression class="net.sf.jasperreports.engine.JRRenderable"><![CDATA[$P{LOGO_RELATORIO}]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band height="15" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-20" x="0" y="1" width="555" height="14"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="1.0" lineColor="#000000"/>
					<rightPen lineWidth="1.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: Implantação de Saldo]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement x="14" y="0" width="212" height="10"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ID_PRODUTO} + " - " + $F{PRODUTO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="228" y="0" width="48" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Long"><![CDATA[$F{ID_LOTE_FABRICACAO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="279" y="0" width="81" height="10"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{LOTE_FABRICACAO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="363" y="0" width="50" height="10"/>
				<textElement textAlignment="Center">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{DATA_VALIDADE}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="417" y="0" width="73" height="10"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{COR}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement x="493" y="0" width="61" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{QUANTIDADE}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="15" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-8" x="536" y="0" 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>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-8" x="525" y="0" 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-11" x="365" y="0" width="160" height="15" forecolor="#0066FF"/>
				<textElement textAlignment="Center">
					<font size="8" isItalic="true" isUnderline="true" pdfFontName="Helvetica-Oblique"/>
				</textElement>
				<text><![CDATA[www.contatosistemas.com]]></text>
			</staticText>
			<textField evaluationTime="Report" isBlankWhenNull="true">
				<reportElement key="textField-9" x="544" y="0" 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>
		</band>
	</pageFooter>
	<summary>
		<band height="23" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField-12" x="0" y="0" width="555" height="23" isRemoveLineWhenBlank="true"/>
				<textElement textAlignment="Center" markup="html"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{FECHO}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
