<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1  -->
<!-- 2017-08-07T15:44:11 -->
<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="OUTROS_ROMANEIO_EXPEDICAO" pageWidth="275" pageHeight="170" whenNoDataType="AllSectionsNoDetail" columnWidth="275" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="bec65ff9-0dfe-450c-a047-387ee88ebdba">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<parameter name="NOME_EMPRESA" class="java.lang.String" isForPrompting="false"/>
	<parameter name="TELEFONE" class="java.lang.String" isForPrompting="false"/>
	<parameter name="DATA" class="java.util.Date" isForPrompting="false"/>
	<parameter name="CLIENTE" class="java.lang.String" isForPrompting="false"/>
	<parameter name="CIDADE" class="java.lang.String" isForPrompting="false"/>
	<parameter name="UF" class="java.lang.String" isForPrompting="false"/>
	<parameter name="NR_CAIXA" class="java.lang.Integer" isForPrompting="false"/>
	<parameter name="CODIGO_PEDIDO" class="java.lang.Long" isForPrompting="false"/>
	<parameter name="ID_PEDIDO" class="java.lang.Long" isForPrompting="false"/>
	<parameter name="LACRADA" class="java.lang.Short" isForPrompting="false"/>
	<parameter name="NR_INICIAL" class="java.lang.Long"/>
	<parameter name="NR_FINAL" class="java.lang.Long"/>
	<parameter name="ID_EMPRESA" class="java.lang.Long"/>
	<queryString>
		<![CDATA[SELECT distinct
NP.numero_nota,P.nome,CI.descricao,ex.id_expedicao,em.id_embalagem_expedicao,uf.sigla,
com.fone1 ,pess.nome transportado ,compl.fone1 as fone_trans,ped.id_pedido

FROM
nota_propria NP
INNER JOIN
unidade_fat_cliente U ON (U.id_unidade_fat_cliente=NP.id_unidade_fat_cliente)
INNER JOIN
CLIENTE CO ON (CO.id_cliente=U.id_cliente)
INNER JOIN
PESSOA P ON (P.id_pessoa = CO.id_pessoa)
INNER JOIN
endereco E ON (E.id_endereco=P.id_endereco)
INNER JOIN
CIDADE CI ON (CI.id_cidade=E.id_cidade)
inner join
expedicao ex on (ex.id_expedicao=np.id_expedicao)
inner join
embalagem_expedicao em on (em.id_expedicao=ex.id_expedicao)
inner join
uf uf on (uf.id_uf=ci.id_uf)
inner join
complemento com on (com.id_complemento=p.id_complemento)
inner join
pedido ped on (ped.id_pedido=ex.id_pedido)
inner join
transportador t on (t.id_trasnportador=ped.id_transportador)
inner join
pessoa pess on (pess.id_pessoa=t.id_pessoa)
inner join
complemento compl on (compl.id_complemento=pess.id_complemento)
where
np.numero_nota between $P{NR_INICIAL} AND $P{NR_FINAL}
and NP.id_empresa = $P{ID_EMPRESA} 
order by np.numero_nota]]>
	</queryString>
	<field name="NUMERO_NOTA" class="java.lang.Integer"/>
	<field name="NOME" class="java.lang.String">
		<fieldDescription><![CDATA["teste"]]></fieldDescription>
	</field>
	<field name="DESCRICAO" class="java.lang.String"/>
	<field name="ID_EXPEDICAO" class="java.lang.Integer"/>
	<field name="ID_EMBALAGEM_EXPEDICAO" class="java.lang.Integer"/>
	<field name="SIGLA" class="java.lang.String"/>
	<field name="FONE1" class="java.lang.String"/>
	<field name="TRANSPORTADO" class="java.lang.String"/>
	<field name="FONE_TRANS" class="java.lang.String"/>
	<field name="ID_PEDIDO" class="java.lang.Integer"/>
	<variable name="CONTADOR" class="java.lang.Integer" resetType="Group" resetGroup="NUMERO_NOTA" calculation="Count">
		<variableExpression><![CDATA[$F{NUMERO_NOTA}]]></variableExpression>
	</variable>
	<group name="NUMERO_NOTA">
		<groupExpression><![CDATA[$F{NUMERO_NOTA}]]></groupExpression>
		<groupHeader>
			<band splitType="Stretch"/>
		</groupHeader>
		<groupFooter>
			<band splitType="Stretch"/>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="170" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-1" x="28" y="41" width="41" height="12" uuid="70cc2bae-5c62-41d3-b0f6-fcc50fba620d"/>
				<textElement verticalAlignment="Bottom">
					<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Cliente]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="28" y="53" width="244" height="11" uuid="b461d610-eedd-426a-9026-10e83ce58c34"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{NOME}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="28" y="13" width="123" height="28" uuid="77af2a83-0ebc-426d-973f-66f692e19f2e"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="14" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA["NF: "+$F{NUMERO_NOTA}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="163" y="40" width="26" height="13" uuid="cc4f518f-a910-45e5-af6d-bb5924bae4df"/>
				<textElement textAlignment="Right">
					<font size="9" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{CONTADOR}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Group" evaluationGroup="NUMERO_NOTA" isBlankWhenNull="false">
				<reportElement key="textField-1" x="196" y="40" width="35" height="13" uuid="7a5e380b-9ec8-4723-a6b0-68c2db6a6594"/>
				<textElement textAlignment="Left">
					<font size="9" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{CONTADOR}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-2" x="28" y="62" width="49" height="12" uuid="9da71b69-9bd5-4544-8f26-c20e03912afd"/>
				<textElement verticalAlignment="Bottom">
					<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Telefone]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="198" y="96" width="13" height="12" uuid="7257af4e-6002-4bb3-ab36-49283c2eb6d0"/>
				<textElement textAlignment="Right" verticalAlignment="Bottom">
					<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[UF]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-6" x="28" y="105" width="59" height="12" uuid="5fa515bb-3119-44f5-ab32-51f1834bd890"/>
				<textElement verticalAlignment="Bottom">
					<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Transportador:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-7" x="28" y="130" width="41" height="12" uuid="e071b289-e8df-4e67-b670-ce9f56b47f72"/>
				<textElement textAlignment="Left" verticalAlignment="Bottom">
					<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Telefone:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-8" x="117" y="40" width="46" height="13" uuid="911d1c64-21d4-4039-8c64-9cebabba66b4"/>
				<textElement textAlignment="Right" verticalAlignment="Bottom">
					<font size="9" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Caixa:]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="28" y="74" width="100" height="11" uuid="01170c8c-1e9b-41b4-a710-2a6c0237a8e0"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{FONE1}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="28" y="96" width="166" height="11" uuid="f287b8dc-13c5-4e85-a1b5-7237f53ae122"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{DESCRICAO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-9" x="28" y="84" width="49" height="12" uuid="9a482faa-baae-4d05-87a2-c1fccf06d9f9"/>
				<textElement verticalAlignment="Bottom">
					<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Cidade]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="212" y="96" width="25" height="12" uuid="951b60a2-0696-4dea-bcf3-658f753aefee"/>
				<textElement textAlignment="Center">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SIGLA}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="28" y="117" width="173" height="11" uuid="dff0b43b-420b-4bad-b329-dbbb272e00b4"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{TRANSPORTADO}]]></textFieldExpression>
			</textField>
			<line direction="BottomUp">
				<reportElement key="line-1" x="189" y="40" width="7" height="13" uuid="9722a185-a0eb-4501-846c-9be7e1cfdb7c"/>
			</line>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="69" y="130" width="181" height="11" uuid="c966bf24-6b42-4b4c-9805-b5d8e916d4a5"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{FONE_TRANS}!=null && $F{FONE_TRANS}.length()>6?($F{FONE_TRANS}.substring(0,2)+"-"+
$F{FONE_TRANS}.substring(2,6)+"-"+$F{FONE_TRANS}.substring(6)):""]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="28" y="3" width="244" height="11" uuid="0018b864-e251-48d4-9005-2c0167c40243"/>
				<textElement textAlignment="Center">
					<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{NOME_EMPRESA}]]></textFieldExpression>
			</textField>
			<componentElement>
				<reportElement x="28" y="142" width="222" height="28" uuid="55bb0aa4-1942-40cd-8d5c-fd761fcf340c"/>
				<jr:barbecue xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" type="3of9" drawText="true" checksumRequired="false">
					<jr:codeExpression><![CDATA[$F{ID_EMBALAGEM_EXPEDICAO}.toString()]]></jr:codeExpression>
				</jr:barbecue>
			</componentElement>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="149" y="14" width="123" height="28" uuid="346f77c6-2c97-4207-bdaa-c2ae51124824"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="14" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA["PED: "+$F{ID_PEDIDO}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
