<?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="th_rascunho" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" whenResourceMissingType="Error" uuid="1266203d-1d0b-4051-9372-f613d3fba581">
	<property name="ireport.zoom" value="1.9965000000000037"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="116"/>
	<style name="Grade" fill="Solid" hAlign="Center" vAlign="Middle" markup="none">
		<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
			<pen lineWidth="0.0"/>
			<topPen lineWidth="0.25"/>
			<leftPen lineWidth="0.0"/>
			<bottomPen lineWidth="0.25"/>
			<rightPen lineWidth="0.0"/>
		</box>
	</style>
	<style name="Total" hAlign="Center" vAlign="Middle" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
	<style name="Zebra" backcolor="#F3F5FA" hAlign="Left" vAlign="Middle">
		<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
			<topPen lineWidth="0.5" lineColor="#D4D7DD"/>
			<leftPen lineWidth="0.5" lineColor="#D4D7DD"/>
			<bottomPen lineWidth="0.5" lineColor="#D4D7DD"/>
			<rightPen lineWidth="0.5" lineColor="#D4D7DD"/>
		</box>
		<conditionalStyle>
			<conditionExpression><![CDATA[new Boolean( $V{REPORT_COUNT}.intValue() % 2 == 0)]]></conditionExpression>
			<style mode="Opaque" backcolor="#F3F5FA"/>
		</conditionalStyle>
	</style>
	<style name="Coluna" mode="Opaque" forecolor="#FFFFFF" backcolor="#1E486C" fill="Solid" hAlign="Center" vAlign="Middle" markup="none" fontSize="9" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false">
		<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
			<pen lineWidth="0.5" lineColor="#FFFFFF"/>
			<topPen lineWidth="0.5" lineColor="#FFFFFF"/>
			<leftPen lineWidth="0.5" lineColor="#FFFFFF"/>
			<bottomPen lineWidth="0.5" lineColor="#FFFFFF"/>
			<rightPen lineWidth="0.5" lineColor="#FFFFFF"/>
		</box>
	</style>
	<style name="Linhas-Zebra" backcolor="#F5F7FA" hAlign="Left" vAlign="Middle" isBlankWhenNull="true" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false">
		<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
			<topPen lineWidth="0.5" lineColor="#D4D7DD"/>
			<leftPen lineWidth="0.5" lineColor="#D4D7DD"/>
			<bottomPen lineWidth="0.5" lineColor="#D4D7DD"/>
			<rightPen lineWidth="0.5" lineColor="#D4D7DD"/>
		</box>
		<conditionalStyle>
			<conditionExpression><![CDATA[new Boolean( $V{REPORT_COUNT}.intValue() % 2 == 0)]]></conditionExpression>
			<style mode="Opaque" backcolor="#F3F5FA"/>
		</conditionalStyle>
	</style>
	<style name="Título" hAlign="Left" vAlign="Middle" isBlankWhenNull="true" fontSize="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" isPdfEmbedded="false">
		<box topPadding="1" bottomPadding="1"/>
	</style>
	<style name="Filtros" hAlign="Left" vAlign="Middle" isBlankWhenNull="false" fontSize="7" isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false">
		<box topPadding="2" bottomPadding="5">
			<bottomPen lineWidth="0.75"/>
		</box>
	</style>
	<style name="Data/Hora" hAlign="Right" vAlign="Middle" isBlankWhenNull="false" fontSize="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false">
		<box topPadding="1" bottomPadding="1">
			<bottomPen lineWidth="0.0"/>
		</box>
	</style>
	<style name="Apr-Clean" fill="Solid" hAlign="Center" vAlign="Middle" markup="none" isBlankWhenNull="true" fontSize="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" isPdfEmbedded="false">
		<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
			<pen lineWidth="0.0"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.0" lineStyle="Dashed"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.0" lineStyle="Dashed"/>
		</box>
	</style>
	<style name="Apr-Duplo" fill="Solid" hAlign="Center" vAlign="Middle" markup="none" isBlankWhenNull="true" fontSize="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" isPdfEmbedded="false">
		<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
			<pen lineWidth="0.0"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Grupo1" hAlign="Left" vAlign="Middle" isBlankWhenNull="true" fontSize="9" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" isPdfEmbedded="false">
		<box topPadding="9" bottomPadding="3"/>
	</style>
	<style name="Totalizador" hAlign="Left" vAlign="Middle" isBlankWhenNull="false" fontSize="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" isPdfEmbedded="false">
		<box topPadding="0" leftPadding="1" bottomPadding="0" rightPadding="1">
			<pen lineWidth="0.5"/>
			<topPen lineWidth="0.5" lineColor="#D4D7DD"/>
			<leftPen lineWidth="0.5" lineColor="#D4D7DD"/>
			<bottomPen lineWidth="0.5" lineColor="#D4D7DD"/>
			<rightPen lineWidth="0.5" lineColor="#D4D7DD"/>
		</box>
	</style>
	<style name="Versão" hAlign="Left" vAlign="Middle" isBlankWhenNull="false" fontSize="7" isBold="true" isItalic="true" isUnderline="false" isStrikeThrough="false" isPdfEmbedded="false">
		<box topPadding="0" bottomPadding="1">
			<pen lineWidth="0.0"/>
			<topPen lineWidth="0.75" lineColor="#000000"/>
			<leftPen lineWidth="0.0"/>
			<bottomPen lineWidth="0.0"/>
			<rightPen lineWidth="0.0"/>
		</box>
	</style>
	<parameter name="P_VERBA" class="java.lang.Integer">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="P_USU" class="java.lang.Integer">
		<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

'Contrato - Verba de Fornecedores' as relatorio,
	to_char(now(),'dd/mm/yyyy HH24:MI') as dtimpr,
	'th_verba_fornecedor_v25.08.29.1 - www.brsistemas.com.br' as versao,

e.pardes as empdes,
e.parcnpjcpf as empcnpj,
e.parrua as parend,
e.parbai as parcit,
func.pardes as func,
func.parcnpjcpf as funccnpj,
f.pardes as fordes,
f.parcnpjcpf as forcnpj,
f.parrua as forend,
f.parbai as forcit,
contratoverbacod,
contratoverbatipoverba,
contratoverbavalortotal,
to_char(contratoverbadtinicio,'dd/mm/yyyy') as contratoverbadtinicio,
to_char(contratoverbadtpag,'dd/mm/yyyy') as contratoverbadtpag,
contratoverbadtfim,
contratoverbafinalidade,
contratoverbaobs

from contratoverba
join emp on empparcod = contratoverbaempparcod
join forn on forparcod = contratoverbaforparcod
join par f on f.parcod = forparcod
join par e on e.parcod = empparcod
left join usu on usuid = $P{P_USU}
left join par func on usufunparcod = func.parcod

where contratoverbacod = $P{P_VERBA}]]>
	</queryString>
	<field name="relatorio" class="java.lang.String"/>
	<field name="dtimpr" class="java.lang.String"/>
	<field name="versao" class="java.lang.String"/>
	<field name="empdes" class="java.lang.String"/>
	<field name="empcnpj" class="java.lang.String"/>
	<field name="parend" class="java.lang.String"/>
	<field name="parcit" class="java.lang.String"/>
	<field name="func" class="java.lang.String"/>
	<field name="funccnpj" class="java.lang.String"/>
	<field name="fordes" class="java.lang.String"/>
	<field name="forcnpj" class="java.lang.String"/>
	<field name="forend" class="java.lang.String"/>
	<field name="forcit" class="java.lang.String"/>
	<field name="contratoverbacod" class="java.lang.Integer"/>
	<field name="contratoverbatipoverba" class="java.lang.String"/>
	<field name="contratoverbavalortotal" class="java.math.BigDecimal"/>
	<field name="contratoverbadtinicio" class="java.lang.String"/>
	<field name="contratoverbadtpag" class="java.lang.String"/>
	<field name="contratoverbadtfim" class="java.sql.Date"/>
	<field name="contratoverbafinalidade" class="java.lang.String"/>
	<field name="contratoverbaobs" class="java.lang.String"/>
	<pageHeader>
		<band height="39">
			<staticText>
				<reportElement style="Título" x="0" y="19" width="555" height="20" uuid="7f747881-d5b1-477d-aa45-449548388b4d"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[TERMO DE COMPROMISSO COM FORNECEDOR]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="0" width="555" height="19" uuid="ecc5acd4-79dd-4fae-9322-dfa202286f51"/>
				<box leftPadding="2" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{relatorio}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="292">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="0" y="15" width="555" height="60" uuid="ff31b5ab-e688-4773-8674-53c0720d0669"/>
				<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["Pelo presente termo de compromisso, a empresa "+"<b>"+$F{empdes}+"</b>"+
" com sede na cidade de "+"<b>"+$F{parcit}+"</b>"+", "+"<b>"+$F{parend}+"</b>"+", "+
"inscrita no CNPJ sob o nº "+"<b>"+$F{empcnpj}+"</b>"+
", por intermédio de seu negociador legalmente habilitado, Sr(a). "+"<b>"+$F{func}+"</b>"+
", portador do CPF nº "+"<b>"+$F{funccnpj}+"</b>"+
", doravante denominado(a) FORNECEDOR(a),"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="270" height="15" uuid="1151c174-328e-40c2-be34-c046829a31df"/>
				<box leftPadding="2">
					<topPen lineWidth="0.5"/>
					<leftPen lineWidth="0.0" lineStyle="Solid"/>
					<bottomPen lineWidth="0.5"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Nr.]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="0" y="75" width="555" height="52" uuid="544dec85-af3b-409d-8e55-31cb9eb2c5d2"/>
				<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["e a empresa "+"<b>"+$F{fordes}+"</b>"+
" , estabelecida na cidade de "+"<b>"+$F{forcit}+"</b>"+", "+"<b>"+$F{forend}+"</b>"+" , "+
"inscrita no CNPJ sob o nº "+"<b>"+$F{forcnpj}+"</b>"+
", por intermédio de seu representante legal, doravante denominado(a) COMPRADOR(a),"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="0" y="127" width="335" height="16" uuid="ebc930e7-0875-4499-b2c3-558660e8d837"/>
				<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["1ª) O(a) FORNECEDOR(a) compromete-se a pagar o(a) COMPRADOR(a) a quantia de: R$ "]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="0" y="143" width="555" height="40" uuid="faad8587-ae00-4525-950b-ebeaba5040a9"/>
				<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["2ª) Caso não ocorra o pagamento dentro do prazo, a(o) COMPRADOR(a) fica autorizada a descontar o valor deste termo nas primeiras duplicatas ou boletos do(a) FORNECEDOR(a) com vencimento após essa data."]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="0" y="183" width="555" height="32" uuid="d3de61bb-1d7d-457d-9cf3-fb657e3bc6a6"/>
				<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["3ª) Caso não existam duplicatas ou boletos a pagar, o(a) COMPRADOR(a) emitirá um boleto no valor devido e enviará para pagamento dentro do prazo estabelecido."]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="0" y="215" width="555" height="27" uuid="928d7839-075f-4a26-960a-9b9819dff96d"/>
				<box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["4ª) Fica eleito o foro da comarca de Brasília - DF para resolver quaisquer questões decorrentes deste contrato."]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="7" y="276" width="203" height="1" uuid="55220bbc-9b11-48b1-b59c-ab2b50a20714"/>
			</line>
			<line>
				<reportElement x="346" y="276" width="203" height="1" uuid="a7ae5a4f-ffab-4444-9749-8ac1f04831f1"/>
			</line>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="7" y="277" width="203" height="15" uuid="f89a3324-5215-4434-a6aa-954d0e5a8471"/>
				<box leftPadding="3" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{fordes}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="346" y="277" width="203" height="15" uuid="937c7a7a-d1d8-4b51-af16-ffb5d924e129"/>
				<box leftPadding="3" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{empdes}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="270" y="0" width="285" height="15" uuid="a10fc0e8-8e90-4410-b74f-c345536de7e7"/>
				<box leftPadding="3" rightPadding="2">
					<topPen lineWidth="0.5"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.5"/>
				</box>
				<textElement verticalAlignment="Middle" markup="html">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{contratoverbacod}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="335" y="127" width="53" height="16" uuid="5bdd0457-be58-4c88-986a-e973edae3482"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" rightPadding="0">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{contratoverbavalortotal}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="388" y="126" width="167" height="17" uuid="610f0b72-abfd-4bb4-8dd4-8ca139051b6a"/>
				<box topPadding="1" leftPadding="0" bottomPadding="1" rightPadding="0">
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[" Data de pagamento: até "+"<b>"+$F{contratoverbadtpag}+"</b>"+"."]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<pageFooter>
		<band height="19">
			<textField evaluationTime="Report">
				<reportElement x="514" y="4" width="41" height="15" uuid="ee2ffe36-27f2-4758-8017-712e2d3081b5"/>
				<textElement verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="435" y="4" width="79" height="15" uuid="2e5a6f0f-0494-49da-8402-e2cd3b88bbd1"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA["Página "+$V{PAGE_NUMBER}+" de"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="4" width="435" height="15" uuid="10c3d8b2-95b9-4945-a6ea-23b94c78cb86"/>
				<box leftPadding="3" rightPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font size="9" isItalic="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{versao}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>
