<?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_TICKET_FISCAL" pageWidth="612" pageHeight="792" columnWidth="612" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="fd5cfbb5-da15-4767-88ac-4601b6925e72">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="178"/>
	<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_ESTADUAL_NOME" class="java.lang.String" isForPrompting="false"/>
	<parameter name="FECHO" class="java.lang.String" isForPrompting="false"/>
	<parameter name="DATA_INICIAL" class="java.util.Date" isForPrompting="false"/>
	<parameter name="DATA_FINAL" class="java.util.Date" isForPrompting="false"/>
	<parameter name="SUBREPORT_DIR_LIST" class="java.lang.String" isForPrompting="false"/>
	<parameter name="LOGO_RELATORIO" class="net.sf.jasperreports.engine.JRImageRenderer" isForPrompting="false"/>
	<parameter name="SUBREPORT_DIR_IND" class="java.lang.String" isForPrompting="false"/>
	<parameter name="ID_TICKET" class="java.lang.Integer" isForPrompting="false"/>
	<queryString>
		<![CDATA[SELECT
  p.nome AS cliente,
  t.data_FECHAMENTO,
  pes.nome AS transportador,
  pr.nome AS produto,
  t.peso_veiculo,
  t.peso_total as peso_total,
  t.peso_total-t.peso_veiculo AS peso_liquido,
  l.lote_fabricacao,
  T.ID_TICKET_FISCAL,
  T.NUMERO,
  e.cep,
  e.numero,
  e.logradouro,
  cit.descricao,
  u.sigla,
  e.bairro,
  com.inscricao_estadual,
  com.cnpj,
  com.fone1,
  t.nome_transportador as NOME_TRANSPORTADOR,
  t.placa as PLACA
FROM
  ticket_fiscal t
    INNER JOIN cliente                  c ON (c.id_cliente                  = t.id_cliente)
    INNER JOIN pessoa                   p ON (p.id_pessoa                   = c.id_pessoa)
    INNER JOIN endereco                 e ON (e.id_endereco                 = p.id_endereco)
    INNER JOIN complemento            com ON (com.id_complemento            = p.id_complemento)
    INNER JOIN cidade                 cit ON (cit.id_cidade                 = e.id_cidade)
    INNER JOIN uf                       u ON (u.id_uf                       = cit.id_uf)
    LEFT JOIN  conjunto_transportador  co ON (co.id_conjunto_transportador  = t.id_conjunto_transportador)
    LEFT JOIN  transportador_agregado tra ON (tra.id_transportador_agregado = co.id_transportador_agregado)
    LEFT JOIN  pessoa                 pes ON (pes.id_pessoa                 = tra.id_pessoa)
    INNER JOIN produto                 pr ON (pr.id_produto                 = t.id_produto)
    INNER JOIN lote_fabricacao          l ON (l.id_produto                  = pr.id_produto)
WHERE
  T.ID_TICKET_FISCAL = $P{ID_TICKET}]]>
	</queryString>
	<field name="CLIENTE" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="DATA_FECHAMENTO" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="TRANSPORTADOR" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PRODUTO" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PESO_VEICULO" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PESO_TOTAL" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="PESO_LIQUIDO" class="java.math.BigDecimal"/>
	<field name="LOTE_FABRICACAO" class="java.lang.String"/>
	<field name="ID_TICKET_FISCAL" class="java.lang.Integer"/>
	<field name="NUMERO" class="java.lang.Integer"/>
	<field name="CEP" class="java.lang.String"/>
	<field name="LOGRADOURO" class="java.lang.String"/>
	<field name="DESCRICAO" class="java.lang.String"/>
	<field name="SIGLA" class="java.lang.String"/>
	<field name="BAIRRO" class="java.lang.String"/>
	<field name="INSCRICAO_ESTADUAL" class="java.lang.String"/>
	<field name="CNPJ" class="java.lang.String"/>
	<field name="FONE1" class="java.lang.String"/>
	<field name="NOME_TRANSPORTADOR" class="java.lang.String"/>
	<field name="PLACA" class="java.lang.String"/>
	<variable name="dataRel" class="java.util.Date" resetType="Page">
		<initialValueExpression><![CDATA[new java.util.Date()]]></initialValueExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="363" splitType="Stretch">
			<textField isBlankWhenNull="false">
				<reportElement uuid="88a9df72-10a8-40d5-8598-3bffe2f3a166" key="textField" x="15" y="70" width="332" height="18"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{CLIENTE}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy HH.mm.ss" isBlankWhenNull="false">
				<reportElement uuid="071f1f91-1097-4eff-833f-4626229b2d88" key="textField" x="35" y="250" width="175" height="13"/>
				<textElement verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{DATA_FECHAMENTO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement uuid="ef591ca4-e5c8-408d-8aa0-42842a52fb29" key="textField" x="35" y="264" width="175" height="13"/>
				<textElement/>
				<textFieldExpression><![CDATA[new String($F{TRANSPORTADOR} != null ? $F{TRANSPORTADOR} : $F{NOME_TRANSPORTADOR})]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="false">
				<reportElement uuid="bd23a176-4421-4b6b-b22a-d8994358ac5f" key="textField" x="274" y="248" width="207" height="13"/>
				<textElement verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{PRODUTO}]]></textFieldExpression>
			</textField>
			<subreport isUsingCache="true">
				<reportElement uuid="1b19e4ba-0cee-4cdb-9202-dd3dddb9296a" key="subreport-1" x="2" y="144" width="407" height="2"/>
				<subreportParameter name="ID_TICKET">
					<subreportParameterExpression><![CDATA[$F{ID_TICKET_FISCAL}]]></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_TICKET_FISCAL_OBS.jasper"]]></subreportExpression>
			</subreport>
			<textField pattern="##0.00" isBlankWhenNull="false">
				<reportElement uuid="14a9c3b5-e24f-4c40-85e9-2c5ec813cdfc" key="textField" x="274" y="261" width="100" height="13"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{PESO_TOTAL}]]></textFieldExpression>
			</textField>
			<textField pattern="##0.00" isBlankWhenNull="false">
				<reportElement uuid="26be934f-4347-4e88-953e-d1bc608cb150" key="textField" x="274" y="273" width="100" height="13"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{PESO_VEICULO}]]></textFieldExpression>
			</textField>
			<subreport isUsingCache="true">
				<reportElement uuid="cefc2d8b-1af7-4da4-bee1-9b2d4483dc37" key="subreport-3" x="35" y="284" width="175" height="10"/>
				<subreportParameter name="ID_TICKET">
					<subreportParameterExpression><![CDATA[$F{ID_TICKET_FISCAL}]]></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_TICKET_FISCAL_PLACAS.jasper"]]></subreportExpression>
			</subreport>
			<textField pattern="##0.00" isBlankWhenNull="false">
				<reportElement uuid="f59079ae-b2c6-4df3-99d7-d8d55162e9ae" key="textField" x="274" y="285" width="100" height="13"/>
				<textElement verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{PESO_LIQUIDO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement uuid="218da8ba-44b0-4348-8b14-9b91a17906de" key="textField" x="381" y="285" width="100" height="13"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{LOTE_FABRICACAO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement uuid="6d83ef9b-9452-4ef2-aced-ecbd9f0c4e65" key="textField" x="325" y="7" width="63" height="13"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression><![CDATA[$F{NUMERO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement uuid="9ad3c009-c396-42d5-b0fa-d5270396dee3" key="textField-1" stretchType="RelativeToTallestObject" x="15" y="88" width="361" height="62" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="true" isPrintWhenDetailOverflows="true"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{LOGRADOURO}+","+$F{NUMERO}+" - "+$F{BAIRRO}+"\n"+
$F{DESCRICAO}+" - "+$F{SIGLA}+"  CEP: "+$F{CEP}+"  FONE: "+$F{FONE1}+"\n"+
"I.E: "+$F{INSCRICAO_ESTADUAL}+" CNPJ: "+$F{CNPJ}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="d2999bec-9298-400b-ae93-4ec349776686" x="35" y="286" width="100" height="13">
					<printWhenExpression><![CDATA[new Boolean($F{TRANSPORTADOR} == null)]]></printWhenExpression>
				</reportElement>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{PLACA}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band splitType="Stretch"/>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
