<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.12.0.final using JasperReports Library version 6.12.1-ac0eebdb29e4c0985457bab279a6db744d661530  -->
<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_ROMANEIO_PEDIDO" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" uuid="4de21f34-bb7c-412f-9e27-e7bd462a9670">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="2.1435888100000016"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="254"/>
	<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" isForPrompting="false"/>
	<parameter name="CNPJ_NOME" class="java.lang.String" isForPrompting="false"/>
	<parameter name="INSCRICAO" class="java.lang.String" isForPrompting="false"/>
	<parameter name="ID_INICIAL" class="java.lang.Integer"/>
	<parameter name="ID_FINAL" class="java.lang.Integer"/>
	<parameter name="INSCRICAO_ESTADUAL_NOME" class="java.lang.String" isForPrompting="false"/>
	<parameter name="SUBREPORT_DIR_IND" class="java.lang.String" isForPrompting="false"/>
	<parameter name="LOGO_RELATORIO" class="net.sf.jasperreports.engine.JRImageRenderer" isForPrompting="false"/>
	<parameter name="FILTRAR_CODIGO" class="java.lang.Integer"/>
	<parameter name="FILTRAR_IDENTIFICADOR" class="java.lang.Integer"/>
	<queryString>
		<![CDATA[SELECT
        e.id_pedido ,e.id_expedicao
FROM
        pedido p
inner join
expedicao e
         on (p.id_pedido=e.id_pedido)
WHERE
	($P{FILTRAR_CODIGO} = 1 and p.codigo_pedido BETWEEN $P{ID_INICIAL} AND $P{ID_FINAL}) or
          ($P{FILTRAR_IDENTIFICADOR} = 1 and p.id_pedido BETWEEN $P{ID_INICIAL} AND $P{ID_FINAL})]]>
	</queryString>
	<field name="ID_PEDIDO" class="java.lang.Integer"/>
	<field name="ID_EXPEDICAO" class="java.lang.Integer"/>
	<variable name="dataRel" class="java.util.Date" resetType="Page">
		<initialValueExpression><![CDATA[new java.util.Date()]]></initialValueExpression>
	</variable>
	<variable name="CAIXAS" class="java.lang.Integer"/>
	<variable name="TOTAL_PESO_BRUTO" class="java.math.BigDecimal" resetType="None"/>
	<variable name="TOTAL_PESO_LIQUIDO" class="java.math.BigDecimal" resetType="None"/>
	<variable name="TOTAL_VOLUMES" class="java.math.BigDecimal" resetType="None"/>
	<variable name="TOTAL_VOLUMES_UTILIZADOS" class="java.math.BigDecimal" resetType="None"/>
	<variable name="STATUS" class="java.lang.Boolean"/>
	<group name="PEDIDO" isStartNewPage="true" isReprintHeaderOnEachPage="true">
		<groupExpression><![CDATA[$F{ID_PEDIDO}]]></groupExpression>
		<groupHeader>
			<band splitType="Stretch"/>
		</groupHeader>
		<groupFooter>
			<band splitType="Stretch"/>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="70" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-12" x="154" y="9" width="279" height="17" uuid="6809eda5-98d1-4eea-9784-f928d46c6b0e"/>
				<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>
				<textFieldExpression><![CDATA[$P{NOME_EMPRESA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-14" x="433" y="16" width="35" height="14" uuid="de5010cd-8ed8-4d00-a52a-296397890f34"/>
				<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-15" x="433" y="32" width="35" height="14" uuid="b0450b89-5e7b-4f2b-8062-1fba216a2f3f"/>
				<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-13" x="467" y="16" width="67" height="14" uuid="0f1b25b3-aa12-48a3-b1ed-da5e1e7b1ead"/>
				<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><![CDATA[$V{dataRel}]]></textFieldExpression>
			</textField>
			<textField pattern="HH.mm.ss" isBlankWhenNull="true">
				<reportElement key="textField-14" x="467" y="32" width="67" height="14" uuid="0c52e427-eed3-4bd1-b7f8-158d87b29cd2"/>
				<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><![CDATA[$V{dataRel}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-16" x="158" y="33" width="27" height="12" uuid="62895231-bc3d-4731-b0db-476540141d6c"/>
				<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-17" x="267" y="33" width="77" height="12" uuid="a6b8016e-f0c8-4a6e-8262-476de6ed176a"/>
				<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-15" x="186" y="33" width="80" height="12" uuid="39d9b3ce-5e30-4a79-aabc-76e9bd2c04c8"/>
				<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><![CDATA[$P{CNPJ_NOME}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-16" x="345" y="33" width="85" height="12" uuid="34dac7fe-3ab8-4edc-9330-09a91d30468d"/>
				<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><![CDATA[$P{INSCRICAO_ESTADUAL_NOME}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line-4" x="0" y="51" width="535" height="1" uuid="3698bcfb-35b4-4dc4-a151-195b5fb74a57"/>
				<graphicElement>
					<pen lineWidth="0.25" lineStyle="Solid"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement key="staticText-5" x="0" y="56" width="535" height="14" uuid="b9599b68-75d1-4c18-aab2-40a496f7226e"/>
				<box>
					<pen lineWidth="0.5" lineStyle="Solid"/>
					<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Relatório Individual: Romaneio Pedido]]></text>
			</staticText>
			<image onErrorType="Blank">
				<reportElement key="image-1" x="0" y="0" width="154" height="52" uuid="e2e3f662-9e93-4e40-9c85-9781d0336896"/>
				<imageExpression><![CDATA[$P{LOGO_RELATORIO}]]></imageExpression>
			</image>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="96" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-12" x="-1" y="3" width="77" height="10" uuid="ea05196d-857b-4628-bba4-97f9f75c859a"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Id. do Pedido:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="79" y="3" width="190" height="10" uuid="63e408d4-e410-4b60-82ca-815bf73afa3e"/>
				<textElement textAlignment="Left">
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ID_PEDIDO}]]></textFieldExpression>
			</textField>
			<subreport isUsingCache="true">
				<reportElement key="subreport-1" positionType="Float" x="0" y="64" width="258" height="5" uuid="0f24cbb5-c4b2-48f8-8ed0-d04829197c2f"/>
				<subreportParameter name="ID_PEDIDO">
					<subreportParameterExpression><![CDATA[$F{ID_PEDIDO}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="SUBREPORT_DIR_IND">
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR_IND}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR_IND} + "SUB_IND_ROMANEIO_PEDIDO.jasper"]]></subreportExpression>
			</subreport>
			<subreport isUsingCache="true">
				<reportElement key="subreport-2" positionType="Float" isPrintRepeatedValues="false" x="0" y="90" width="258" height="6" uuid="a60e4f3c-3923-46a7-af03-fe8fd7465b36"/>
				<subreportParameter name="ID_EXPEDICAO">
					<subreportParameterExpression><![CDATA[$F{ID_EXPEDICAO}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="SUBREPORT_DIR_IND">
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR_IND}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<returnValue subreportVariable="Pesos" toVariable="TOTAL_PESO_BRUTO"/>
				<returnValue subreportVariable="Pesos_Liquidos" toVariable="TOTAL_PESO_LIQUIDO"/>
				<returnValue subreportVariable="Volumes" toVariable="TOTAL_VOLUMES"/>
				<returnValue subreportVariable="Volumes_Utilizados" toVariable="TOTAL_VOLUMES_UTILIZADOS"/>
				<returnValue subreportVariable="Lacres" toVariable="STATUS"/>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR_IND} + "SUB_IND_ROMANEIO_PEDIDO_CAIXAS.jasper"]]></subreportExpression>
			</subreport>
			<staticText>
				<reportElement key="staticText-19" positionType="Float" x="44" y="73" width="114" height="10" uuid="0b5af91d-401b-4306-bbe2-a3f1a1b7d183"/>
				<box>
					<pen lineWidth="0.0" lineStyle="Double"/>
					<topPen lineWidth="0.0" lineStyle="Double"/>
					<leftPen lineWidth="0.0" lineStyle="Double"/>
					<bottomPen lineWidth="4.5" lineStyle="Double"/>
					<rightPen lineWidth="0.0" lineStyle="Double"/>
				</box>
				<textElement textAlignment="Center">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[CONTEÚDO POR CAIXA]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-20" x="141" y="18" width="75" height="10" uuid="be6e5122-19d0-4db4-8386-6e2532bd1e66"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Peso Líquido:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-21" x="2" y="18" width="74" height="10" uuid="9d88a16c-4a9e-4e6c-b51b-ff9e07e894bd"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Peso Bruto:]]></text>
			</staticText>
			<textField evaluationTime="Band" pattern="##0.00" isBlankWhenNull="true">
				<reportElement key="textField" x="79" y="18" width="50" height="10" uuid="2c652712-cfc2-4daa-bee9-8c8eb3c4b9c4"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{TOTAL_PESO_BRUTO}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Band" pattern="##0.00" isBlankWhenNull="true">
				<reportElement key="textField" x="219" y="18" width="50" height="10" uuid="874c51f6-6b41-4311-b3c6-2786e1723cb0"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{TOTAL_PESO_LIQUIDO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-22" x="141" y="33" width="75" height="10" uuid="cfe1b21f-c31f-424b-a27f-280ce8f18b36"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[% Utilização:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-23" x="2" y="33" width="74" height="10" uuid="aa2d7512-a0bc-428a-b79f-60c503a9d9e6"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Nr.Cm3:]]></text>
			</staticText>
			<textField evaluationTime="Band" pattern="##0.00" isBlankWhenNull="true">
				<reportElement key="textField-18" x="79" y="33" width="50" height="10" uuid="34c81275-decb-41a4-a16b-4e1dfd0b7c3b"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{TOTAL_VOLUMES}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="##0.00" isBlankWhenNull="true">
				<reportElement key="textField-19" x="218" y="33" width="229" height="10" uuid="d30e5cb4-a983-4017-aff3-da5743570560"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[new Double($V{TOTAL_VOLUMES_UTILIZADOS}.doubleValue()/$V{CAIXAS}.intValue())]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" isBlankWhenNull="true">
				<reportElement key="textField" x="79" y="48" width="368" height="10" uuid="01647abc-1780-481e-bf3a-0df1b9961d3c"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{STATUS}.booleanValue()==true?"  Pedido Conferido integralmente.":" Pedido não conferido integralmente."]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-24" x="2" y="48" width="74" height="10" uuid="dcfcc722-6820-4107-8e0d-968d1147680e"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Status:]]></text>
			</staticText>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="15" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-8" x="505" y="0" width="11" height="15" uuid="83246f34-39fb-4dff-b963-596ee31761e6"/>
				<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><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" isBlankWhenNull="true">
				<reportElement key="textField-9" x="524" y="0" width="11" height="15" uuid="1e5f3eba-2c14-4661-87b5-625a43cbcabf"/>
				<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><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-8" x="516" y="0" width="8" height="15" uuid="e82a5881-e285-4579-859a-a5ce777344e3"/>
				<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="false" hyperlinkType="RemotePage">
				<reportElement key="textField-17" x="379" y="0" width="126" height="14" forecolor="#0099FF" uuid="1be4f76f-69b7-43f4-98e6-5c00722b761b"/>
				<textElement textAlignment="Center">
					<font size="9" isItalic="true" isUnderline="true" pdfFontName="Helvetica-Oblique"/>
				</textElement>
				<textFieldExpression><![CDATA["TOUCHComp.com.br"]]></textFieldExpression>
				<hyperlinkReferenceExpression><![CDATA["HTTP://WWW.CONTATOSISTEMAS.COM"]]></hyperlinkReferenceExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
