Skip to content

Instantly share code, notes, and snippets.

@fernandocamargoai

fernandocamargoai/danfe_nfce_80.jrxml

Created November 24, 2016 12:57
Show Gist options
  • Save fernandocamargoai/3a62d6ec1d3142bc44e53c67c9d6d7a4 to your computer and use it in GitHub Desktop.
Save fernandocamargoai/3a62d6ec1d3142bc44e53c67c9d6d7a4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
danfe_nfce_80.jrxml
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.0.final using JasperReports Library version 6.3.0 -->
<!-- 2016-11-24T10:44:25 -->
<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="danfe_nfce_80" pageWidth="226" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="214" leftMargin="2" rightMargin="10" topMargin="2" bottomMargin="2" uuid="5ce393bf-1e81-4d5c-8158-54fb1fa7db75">
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageWidth" value="mm"/>
<property name="com.jaspersoft.studio.data.sql.tables" value="ZmlsaWFsIEFTICw2OCwyLGI4NDNiMGE4LTgzOTEtNDU1MC05YzZkLTEzMmZjZDkxYTE0OTs="/>
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="nfce_adapter.xml"/>
<parameter name="TIME_FORMAT" class="java.text.DateFormat" isForPrompting="false">
<defaultValueExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy HH:mm:ss")]]></defaultValueExpression>
</parameter>
<parameter name="DATETIME_FORMAT" class="java.text.DateFormat" isForPrompting="false">
<defaultValueExpression><![CDATA[new SimpleDateFormat("HH:mm")]]></defaultValueExpression>
</parameter>
<queryString language="XPath">
<![CDATA[/NFe/infNFe/det]]>
</queryString>
<field name="codigoProduto" class="java.lang.String">
<fieldDescription><![CDATA[prod/cProd]]></fieldDescription>
</field>
<field name="descricaoProduto" class="java.lang.String">
<fieldDescription><![CDATA[prod/xProd]]></fieldDescription>
</field>
<field name="quantidade" class="java.lang.String">
<fieldDescription><![CDATA[prod/qCom]]></fieldDescription>
</field>
<field name="valorUnitarioProd" class="java.lang.String">
<fieldDescription><![CDATA[prod/vUnCom]]></fieldDescription>
</field>
<field name="valorTotalProd" class="java.lang.String">
<fieldDescription><![CDATA[prod/vProd]]></fieldDescription>
</field>
<detail>
<band height="10" splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
<textField>
<reportElement x="0" y="-1" width="26" height="10" uuid="51acc61e-1228-46d8-9428-c2a907a15b30">
<property name="com.jaspersoft.studio.unit.x" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
</reportElement>
<textElement textAlignment="Left">
<font fontName="Arial" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{codigoProduto}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement x="26" y="0" width="76" height="10" uuid="ea716b93-d919-4d0c-9714-8c57450f63ab">
<property name="com.jaspersoft.studio.unit.x" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{descricaoProduto}]]></textFieldExpression>
</textField>
<textField pattern="#,##0.0000">
<reportElement x="102" y="0" width="22" height="10" uuid="9ae45b72-a4d9-425a-9a10-92b41afb9595">
<property name="com.jaspersoft.studio.unit.x" value="pixel"/>
</reportElement>
<textElement textAlignment="Center">
<font fontName="Arial" size="8"/>
</textElement>
<textFieldExpression><![CDATA[new Double($F{quantidade})]]></textFieldExpression>
</textField>
<textField pattern="#,##0.000000">
<reportElement x="124" y="0" width="45" height="10" uuid="ac9d965d-5ccf-4ddb-99a4-5ab173040e2b">
<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
</reportElement>
<textElement textAlignment="Right">
<font fontName="Arial" size="8"/>
</textElement>
<textFieldExpression><![CDATA[new Double($F{valorUnitarioProd})]]></textFieldExpression>
</textField>
<textField pattern="#,##0.00">
<reportElement x="169" y="0" width="45" height="10" uuid="ec7e5b7c-2300-40c2-8f7b-78af3f91afb0">
<property name="com.jaspersoft.studio.unit.x" value="pixel"/>
</reportElement>
<textElement textAlignment="Right">
<font fontName="Arial" size="8"/>
</textElement>
<textFieldExpression><![CDATA[new Double($F{valorTotalProd})]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
Raw
datasource.xml
<NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe52161114639023000155650010000000471390010473" versao="3.10"><ide><cUF>52</cUF><cNF>39001047</cNF><natOp>VENDA</natOp><indPag>0</indPag><mod>65</mod><serie>1</serie><nNF>47</nNF><dhEmi>2016-11-22T11:08:00-02:00</dhEmi><tpNF>1</tpNF><idDest>1</idDest><cMunFG>5208707</cMunFG><tpImp>5</tpImp><tpEmis>1</tpEmis><cDV>3</cDV><tpAmb>2</tpAmb><finNFe>1</finNFe><indFinal>1</indFinal><indPres>1</indPres><procEmi>0</procEmi><verProc>1</verProc></ide><emit><CNPJ>14639023000155</CNPJ><xNome>TOPOMAP EQUIPAMENTOS GEODESICOS EIRELI EPP</xNome><xFant>TOPOMAP EQUIPAMENTOS GEODESICOS</xFant><enderEmit><xLgr>RUA TERESINA</xLgr><nro>65</nro><xCpl>SALA 1203 QUADRA05 LOTE 5/9 EDIF ESSENCIALE PREMIER</xCpl><xBairro>ALTO DA GLORIA</xBairro><cMun>5208707</cMun><xMun>GOIANIA</xMun><UF>GO</UF><CEP>74815715</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>6239225223</fone></enderEmit><IE>105188824</IE><IM>3165876</IM><CNAE>7732201</CNAE><CRT>1</CRT></emit><det nItem="1"><prod><cProd>319</cProd><cEAN>8430422071760</cEAN><xProd>NOTA FISCAL EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xProd><NCM>84717090</NCM><CEST>2804000</CEST><CFOP>5101</CFOP><uCom>UN</uCom><qCom>0.5000</qCom><vUnCom>12140.0000000000</vUnCom><vProd>6070.00</vProd><cEANTrib/><uTrib>UN</uTrib><qTrib>0.5000</qTrib><vUnTrib>12140.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMSSN102><orig>2</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISNT><CST>07</CST></PISNT></PIS><COFINS><COFINSNT><CST>07</CST></COFINSNT></COFINS></imposto></det><det nItem="2"><prod><cProd>0100</cProd><cEAN/><xProd>MAD.ESP.TAUARI(COURATARI GUIANENSIS AUBL.)SERRADA EM RIPA.KD.FAS.FSC 100% MED.19,1MMX38,1MMX2438,4MM DE COMP.</xProd><NCM>85269100</NCM><CFOP>5101</CFOP><uCom>UN</uCom><qCom>0.1000</qCom><vUnCom>12140.0000000000</vUnCom><vProd>1214.00</vProd><cEANTrib/><uTrib>UN</uTrib><qTrib>0.1000</qTrib><vUnTrib>12140.0000000000</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>502.60</vTotTrib><ICMS><ICMSSN102><orig>2</orig><CSOSN>102</CSOSN></ICMSSN102></ICMS><PIS><PISNT><CST>07</CST></PISNT></PIS><COFINS><COFINSNT><CST>07</CST></COFINSNT></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</vICMS><vICMSDeson>0.00</vICMSDeson><vFCPUFDest>0.00</vFCPUFDest><vICMSUFDest>0.00</vICMSUFDest><vICMSUFRemet>0.00</vICMSUFRemet><vBCST>0.00</vBCST><vST>0.00</vST><vProd>7284.00</vProd><vFrete>0.00</vFrete><vSeg>0.00</vSeg><vDesc>0.00</vDesc><vII>0.00</vII><vIPI>0.00</vIPI><vPIS>0.00</vPIS><vCOFINS>0.00</vCOFINS><vOutro>0.00</vOutro><vNF>7284.00</vNF><vTotTrib>502.60</vTotTrib></ICMSTot><retTrib/></total><transp><modFrete>9</modFrete></transp><pag><tPag>03</tPag><vPag>6070.00</vPag><card><tpIntegra>1</tpIntegra><tBand>02</tBand><cAut>34646235524364364366</cAut></card></pag><infAdic><infCpl>NAO INCIDENCIA DE ICMS CONFORME ART. 5, INCISO II DO DECRETO 18.955/97 DF.DADOS BANCARIOS: BANCO: BRB (070) AGENCIA: 207 CONTA: 001862-2 OBS: A NF 2167 DO FATURAMENTO DE FEVEREIRO/2016 FOI GERADO COM VALOR ATUALIZADO DA TARIFA, SENDO QUE PELA RESOLUCAO HOMOLOGATORIA N2017/16 DA ANEEL, A ATUALIZACAO MUDOU PARA 22/03, ASSIM NAO PODERIA TER CALCULADO COM AJUSTE. DESTA FORMA, NO FATURAMENTO DE MARCO/2016 NF 2199 COM VALOR REAL DE R$ 18.109,67 DESCONTO R$ 1.783,34 COBRADO: R$ 16.326,33 - PARA REGULARIZAR O VALOR COBRADO A MAIOR NO FATURAMENTO DE FEVEREIRO/2016.</infCpl></infAdic></infNFe><infNFeSupl><qrCode>http://homolog.sefaz.go.gov.br/nfeweb/sites/nfce/danfeNFCe?chNFe=52161114639023000155650010000000471390010473&amp;nVersao=100&amp;tpAmb=2&amp;dhEmi=323031362d31312d32325431313a30383a30302d30323a3030&amp;vNF=7284.00&amp;vICMS=0.00&amp;digVal=4777336b4432572f7a6d2b45713042736358444a7646543168736b3d&amp;cIdToken=000001&amp;cHashQRCode=BD8147D3F0B060362066EABD413C5AF1401F7022</qrCode></infNFeSupl><Signature xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><Reference URI="#NFe52161114639023000155650010000000471390010473"><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><DigestValue>Gw3kD2W/zm+Eq0BscXDJvFT1hsk=</DigestValue></Reference></SignedInfo><SignatureValue>tclc7+lQISaw3QNwSHlFvG+j1+tI4mi/Ql2sHFYOWlJUnBB6/zxYPyGL73lxdMXhkDPpKu4Ta0ls
Vg2XXyiCnkN0gPEj3zZaX63w7YAIJ030vl6rP7KJ7byxJ4eFsaTEdOwx1+yGMCAXxR5alo3i5x1p
49a1LG/Jy6z0LQEfQpMxWjFfR9AP+1cWtCkZ+nWI/ED+HGgguvPhLI/azYQoYRyWIuo1Td+wH0BG
dLOZziSJiR4QKt2+in1eGYEyKVgvXkVa4//zGZK8mRwhZXzpMn9Lvay613/Hpivtogacltzd+od3
Y777k6jTgtn1NoaxFQm9PNjkIo3jEWMqI9kBBw==</SignatureValue><KeyInfo><X509Data><X509Certificate>MIIH1DCCBbygAwIBAgIIEM8VERdZMu4wDQYJKoZIhvcNAQELBQAwgYkxCzAJBgNVBAYTAkJSMRMw
EQYDVQQKEwpJQ1AtQnJhc2lsMTQwMgYDVQQLEytBdXRvcmlkYWRlIENlcnRpZmljYWRvcmEgUmFp
eiBCcmFzaWxlaXJhIHYyMRIwEAYDVQQLEwlBQyBTT0xVVEkxGzAZBgNVBAMTEkFDIFNPTFVUSSBN
dWx0aXBsYTAeFw0xNTEyMDIxODUyMzJaFw0xNjEyMDExODUyMzJaMIHlMQswCQYDVQQGEwJCUjET
MBEGA1UEChMKSUNQLUJyYXNpbDE0MDIGA1UECxMrQXV0b3JpZGFkZSBDZXJ0aWZpY2Fkb3JhIFJh
aXogQnJhc2lsZWlyYSB2MjESMBAGA1UECxMJQUMgU09MVVRJMRswGQYDVQQLExJBQyBTT0xVVEkg
TXVsdGlwbGExGjAYBgNVBAsTEUNlcnRpZmljYWRvIFBKIEExMT4wPAYDVQQDEzVUT1BPTUFQIEVR
VUlQQU1FTlRPUyBHRU9ERVNJQ09TIEVJUkVMSToxNDYzOTAyMzAwMDE1NTCCASIwDQYJKoZIhvcN
AQEBBQADggEPADCCAQoCggEBANt5yBlTHdLkHjX1fUqbruM0RmsycNrODdGt56ezGf2aQA4TFSk1
1ew7Haw56bUSN/aSdNaYEV9PgDK0EJS2/FGzD0UQRGdihoJtPT1ZFkohh9ftZe4eGOIT5vVvUii4
dst9B6lOyw3/xqssuY7lwHfdk/8XdplrvigGhuxaqk23FdvgUsIKo6A0lM3uPiHmgTC74qyn9cF2
MMZ8LXVfwP1xdUuaKQtPvzurrh9PAoVnzaWUoCS+8JuBcwCbEwsYy5bvo5aEA0xgliG7x+wYnsOz
Km0jnKAd6hH0noxX1+u6UT8ByyuaGR87nGzYhpZVjrO7kygHeMPP0w2y8NoiMKUCAwEAAaOCAuAw
ggLcMFQGCCsGAQUFBwEBBEgwRjBEBggrBgEFBQcwAoY4aHR0cDovL2NjZC5hY3NvbHV0aS5jb20u
YnIvbGNyL2FjLXNvbHV0aS1tdWx0aXBsYS12MS5wN2IwHQYDVR0OBBYEFLdoPqzCcEVAebE1t4b+
u+Fp6Rs2MAkGA1UdEwQCMAAwHwYDVR0jBBgwFoAUNa4xFPZe0npPWP40qBpnlwrEmwcwXgYDVR0g
BFcwVTBTBgZgTAECASYwSTBHBggrBgEFBQcCARY7aHR0cHM6Ly9jY2QuYWNzb2x1dGkuY29tLmJy
L2RvY3MvZHBjLWFjLXNvbHV0aS1tdWx0aXBsYS5wZGYwgd4GA1UdHwSB1jCB0zA+oDygOoY4aHR0
cDovL2NjZC5hY3NvbHV0aS5jb20uYnIvbGNyL2FjLXNvbHV0aS1tdWx0aXBsYS12MS5jcmwwP6A9
oDuGOWh0dHA6Ly9jY2QyLmFjc29sdXRpLmNvbS5ici9sY3IvYWMtc29sdXRpLW11bHRpcGxhLXYx
LmNybDBQoE6gTIZKaHR0cDovL3JlcG9zaXRvcmlvLmljcGJyYXNpbC5nb3YuYnIvbGNyL0FDU09M
VVRJL2FjLXNvbHV0aS1tdWx0aXBsYS12MS5jcmwwDgYDVR0PAQH/BAQDAgXgMB0GA1UdJQQWMBQG
CCsGAQUFBwMCBggrBgEFBQcDBDCByAYDVR0RBIHAMIG9gSBmZXJuYW5kYS5mYWd1bmRlc0B0b3Bv
bWFwLmNvbS5icqAlBgVgTAEDAqAcExpGRVJOQU5EQSBEQSBST0NIQSBGQUdVTkRFU6AZBgVgTAED
A6AQEw4xNDYzOTAyMzAwMDE1NaA+BgVgTAEDBKA1EzMyMDA2MTk4MTk1Nzk2MzYzMTE1MDAwMDAw
MDAwMDAwMDAwMDAwMDM3ODM3NzBER1BDR0+gFwYFYEwBAwegDhMMMDAwMDAwMDAwMDAwMA0GCSqG
SIb3DQEBCwUAA4ICAQAcFdrfB3vNarud1sWkHR44lhzi1BcxdjFxgoIvXUDs+8Ps/j8eRVqcuI+H
RjJxPMmANGGHgHjFfQhWvO4LBsr2K9EM0jiarELRINEeRUlfxz6RjVtr+OXQtsAQeNPgPtu/3HWy
n2p3LhcODK8H9H1QHGi0rCHhCiw4TuHX2BpYlUh5JCQDfTMpLb6LlgFqASFBW8yJmlr5RuVaRuJg
UfOwGneIozFpZSpaucnEk4HblaVZHrOI4rhKNNNpGlU4N8PVJ5NkGWEjWnbuIkqdm1rRH8ThEMkq
kVyzCG0/3CJoXhcMm1FEwUuGGXI7GBExCu3SaBwLjYI2QllvXtrsqxF+ZZ5Uy+999qKVad8aEHiu
aVb2nuPwEeEpY8R6FomtVU7sQQ1Jdz6HB/qGqn3FpMq8gN7rchHjx2+7X7Xti3YZO5piQ53NLaxO
o/DvYaeUBumzDqldbUbRdaDJc1gI/P7PRMsHOUjqrtihSivirP1sgNMv0pSON05D5mNhULcip5G2
vNZHmiWQykAr1GtAhIitK0JWQYl04mMmKPDVo77XPNHYvJcXX4K9xiUj6E126gX0t2/5NCy4d44/
pYOoj3+wkbRKjIrvVrIWcLApQUFWg0ufEh4Zdu/mwLH+OI7bHWEexsI6JjQqGVaKuL7TZQgs69DG
tjYQbaDvZfYMzkbVjw==</X509Certificate></X509Data></KeyInfo></Signature></NFe>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment