OpenERP Brazilian Portuguese Localization (pt_BR)

Merge lp://qastaging/~cmsa/openerp.pt-br-localiz/l10n_br_cnab into lp://qastaging/~openerp-brazil-core-team/openerp.pt-br-localiz/openerp.pt-br-localiz-v7.0

l10n_br_cnab
Merge into openerp.pt-br-localiz-v7.0

Proposed by Carlos Almeida on 2013-06-18

Status:	Needs review
Proposed branch:	lp://qastaging/~cmsa/openerp.pt-br-localiz/l10n_br_cnab
Merge into:	lp://qastaging/~openerp-brazil-core-team/openerp.pt-br-localiz/openerp.pt-br-localiz-v7.0
Diff against target:	1992 lines (+1813/-0) 32 files modified l10n_br_cnab_base/__init__.py (+27/-0) l10n_br_cnab_base/__openerp__.py (+56/-0) l10n_br_cnab_base/data/cnab400-remessa.xml (+113/-0) l10n_br_cnab_base/data/cnab400-retorno.xml (+118/-0) l10n_br_cnab_base/file_format.py (+85/-0) l10n_br_cnab_base/file_format_view.xml (+91/-0) l10n_br_cnab_base/res_bank.py (+37/-0) l10n_br_cnab_base/res_bank_view.xml (+22/-0) l10n_br_cnab_base/root_menus.xml (+12/-0) l10n_br_cnab_base/sequence_type.xml (+11/-0) l10n_br_cnab_base/wizard/__init__.py (+27/-0) l10n_br_cnab_base/wizard/export_cnab.py (+90/-0) l10n_br_cnab_base/wizard/export_cnab_view.xml (+43/-0) l10n_br_cnab_base/wizard/file_format_loader.py (+112/-0) l10n_br_cnab_base/wizard/file_format_loader_view.xml (+40/-0) l10n_br_cnab_base/wizard/generator.py (+87/-0) l10n_br_cnab_base/wizard/import_cnab.py (+162/-0) l10n_br_cnab_base/wizard/import_cnab_view.xml (+39/-0) l10n_br_cnab_base/wizard/parser.py (+85/-0) l10n_br_cnab_bradesco/__init__.py (+29/-0) l10n_br_cnab_bradesco/__openerp__.py (+54/-0) l10n_br_cnab_bradesco/cnab_payee_info.py (+64/-0) l10n_br_cnab_bradesco/cnab_payee_info_view.xml (+32/-0) l10n_br_cnab_bradesco/cnab_payer_info.py (+39/-0) l10n_br_cnab_bradesco/cnab_payer_info_view.xml (+25/-0) l10n_br_cnab_bradesco/res_company.py (+36/-0) l10n_br_cnab_bradesco/res_company_view.xml (+18/-0) l10n_br_cnab_bradesco/res_partner.py (+36/-0) l10n_br_cnab_bradesco/res_partner_view.xml (+18/-0) l10n_br_cnab_bradesco/sequences.xml (+14/-0) l10n_br_cnab_bradesco/wizard/__init__.py (+25/-0) l10n_br_cnab_bradesco/wizard/export_cnab.py (+166/-0)
To merge this branch:	bzr merge lp://qastaging/~cmsa/openerp.pt-br-localiz/l10n_br_cnab
Related bugs:	Link a bug report
Related blueprints:	Boletos eletrônicos e arquivos de remessa (Undefined)

Reviewer	Review Type	Date Requested	Status
OpenERP Brazil Core Team		2013-06-18	Pending
Review via email: mp+170208@code.qastaging.launchpad.net

Description of the change

Exportação e Exportação CNAB400
Adicionei dois módulos:
- l10n_cnan_base e
- l10n_cnab_bradesco
Que fazem a exportação e importação de ficheiros CNAB400. Para já só do Bradesco.
O módulo base deve ter o código comum a todos os bancos, como só fiz para o Bradesco pode ser que haja código a mudar do módulo l10n_cnab_bradesco para o base ao implementar outros bancos.
PARA INSTALAR E CONFIGURAR:
1. Contabilidade-->File Format Loader
2. Aí carreguem o formato de remessa e retorno, seleccionando o tipo deles, remessa ou retorno
NOTA: Os ficheiros XML com a estrutura estão na pasta l10n_cnab_base/data
3. Por fim, configurar o Banco. Na comfiguração da empresa, adicionem nova conta e no campo Banco 'Criar e Editar...' tem uma secção CNAB, aí seleccionem o booleano CNAB e coloquem o nome e código, no caso do Bradesco é BRADESCO 137.
PRÓXIMOS DESENVOLVIMENTOS:
1. Desenvolver para outros bancos, pois só deve funcionar com o Bradesco.

Revision history for this message

Luis Felipe Miléo - http://www.kmee.com.br (mileo) wrote on 2013-06-18:

Download full text (98.1 KiB)

Muito bom, testarei em breve!

Em 18 de junho de 2013 19:25, Carlos Almeida
<email address hidden>escreveu:

Muito bom, testarei em breve!

Em 18 de junho de 2013 19:25, Carlos Almeida
<cma@thinkopensolutions.com>escreveu:

> Carlos Almeida has proposed merging
> lp:~cmsa/openerp.pt-br-localiz/l10n_br_cnab into lp:openerp.pt-br-localiz.
>
> Requested reviews:
>   OpenERP Brazil Core Team (openerp-brazil-core-team)
>
> For more details, see:
>
> https://code.launchpad.net/~cmsa/openerp.pt-br-localiz/l10n_br_cnab/+merge/170208
>
> Exportação e Exportação CNAB400
> Adicionei dois módulos:
> - l10n_cnan_base e
> - l10n_cnab_bradesco
> Que fazem a exportação e importação de ficheiros CNAB400. Para já só do
> Bradesco.
> O módulo base deve ter o código comum a todos os bancos, como só fiz para
> o Bradesco pode ser que haja código a mudar do módulo l10n_cnab_bradesco
> para o base ao implementar outros bancos.
> PARA INSTALAR E CONFIGURAR:
> 1. Contabilidade-->File Format Loader
> 2. Aí carreguem o formato de remessa e retorno, seleccionando o tipo
> deles, remessa ou retorno
> NOTA: Os ficheiros XML com a estrutura estão na pasta l10n_cnab_base/data
> 3. Por fim, configurar o Banco. Na comfiguração da empresa, adicionem nova
> conta e no campo Banco 'Criar e Editar...' tem uma secção CNAB, aí
> seleccionem o booleano CNAB e coloquem o nome e código, no caso do Bradesco
> é BRADESCO 137.
> PRÓXIMOS DESENVOLVIMENTOS:
> 1. Desenvolver para outros bancos, pois só deve funcionar com o Bradesco.
> --
>
> https://code.launchpad.net/~cmsa/openerp.pt-br-localiz/l10n_br_cnab/+merge/170208
> You are subscribed to branch lp:openerp.pt-br-localiz.
>
> === added directory 'l10n_br_cnab_base'
> === added file 'l10n_br_cnab_base/__init__.py'
> --- l10n_br_cnab_base/__init__.py       1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/__init__.py       2013-06-18 22:24:26 +0000
> @@ -0,0 +1,27 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import file_format
> +import wizard
> +import res_bank
> \ No newline at end of file
>
> === added file 'l10n_br_cnab_base/__openerp__.py'
> --- l10n_br_cnab_base/__openerp__.py    1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/__openerp__.py    2013-06-18 22:24:26 +0000
> @@ -0,0 +1,56 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +{
> +    'name': 'CNAB Base',
> +    'version': '0.011',
> +    'category': 'CNAB',
> +    'sequence': 38,
> +    'complexity': 'normal',
> +    'description': '''== CNAB Base Module ==
> +CNAB export and import base module.
> +See other modules for bank specific formats (eg. cnab_bradesco).''',
> +    'author': 'ThinkOpen Solutions',
> +    'website': 'http://www.thinkopensolution.com',
> +    'images': ['images/oerp61.jpeg',],
> +    'depends': ['base',
> +                'account',
> +                ],
> +    'init_xml': [],
> +    'update_xml': [#'cnab_base_view.xml',
> +                   #'cnab_base_workflow.xml',
> +                   'sequence_type.xml',
> +                   'root_menus.xml',
> +                   'file_format_view.xml',
> +                   'res_bank_view.xml',
> +                   'wizard/file_format_loader_view.xml',
> +                   'wizard/export_cnab_view.xml',
> +                   'wizard/import_cnab_view.xml',
> +                   ],
> +    'demo_xml': [#'cnab_base_demo.xml',
> +                 ],
> +    'installable': True,
> +    'application': True,
> +    'certificate': '',
> +}
>
> === added directory 'l10n_br_cnab_base/data'
> === added file 'l10n_br_cnab_base/data/cnab400-remessa.xml'
> --- l10n_br_cnab_base/data/cnab400-remessa.xml  1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/data/cnab400-remessa.xml  2013-06-18 22:24:26 +0000
> @@ -0,0 +1,113 @@
> +<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> +<txg:Texgit xmlns:txg="http://gilmatryx.googlepages.com/Texgit"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="
> http://gilmatryx.googlepages.com/Texgitfile:////home/gilmar/NFM/WORKSPACE/TexgitSchema.xsd" version="1.0-academic">
> +    <FlatFile>
> +        <layout>
> +            <name>Layout de Geração de arquivos remessa cnab400</name>
> +            <version>Versão 0.0.1</version>
> +            <description>
> +                Através deste layout, você poderá gerar arquivos para
> remessa cnab400
> +            </description>
> +        </layout>
> +        <GroupOfRecords>
> +            <Record name="Header">
> +                <GroupOfFields>
> +                    <IdType name="IDReg" value="0" length="1"
> position="1"/>
> +                    <Field name="IdentificacaoRemessa" value="1"
> type="INTEGER" length="1" padding="ZERO_LEFT"/>
> +                    <Field name="LiteralRemessa" value="REMESSA"
> length="7"/>
> +                    <Field name="CodigoServico" value="01" type="INTEGER"
> length="2" padding="ZERO_LEFT"/>
> +                    <Field name="LiteralServico" value="COBRANCA"
> length="15"/>
> +                    <Field name="CodigoEmpresa" type="INTEGER"
> length="20" padding="ZERO_LEFT"/>
> +                    <Field name="NomeEmpresa" length="30"/>
> +                    <Field name="NumeroBanco" type="INTEGER" value="237"
> length="3" padding="ZERO_LEFT"/>
> +                    <Field name="NomeBanco" length="15" value="BRADESCO"/>
> +                    <Field name="DataGravacaoArquivo" type="DATE"
> length="6" format="DATE_DDMMYY"/>
> +                    <Field name="Branco" value=" " length="8"/>
> +                    <Field name="IdentificacaoSistema" value="MX"
> length="2"/>
> +                    <Field name="NroSequencialArquivo" type="INTEGER"
> length="7" padding="ZERO_LEFT"/>
> +                    <Field name="Branco2" value=" " length="277"/>
> +                    <Field name="NroSequencialRegistro" type="INTEGER"
> length="6" padding="ZERO_LEFT"/>
> +                </GroupOfFields>
> +            </Record>
> +            <Record name="Detalhe-Transacao" repeatable="true">
> +                <GroupOfFields>
> +                    <IdType name="IDReg" value="1" length="1"
> position="1"/>
> +                    <Field name="AgenciaDebito" length="5" type="INTEGER"
> padding="ZERO_LEFT"/>
> +                    <Field name="DigitoAgenciaDebito" length="1"/>
> +                    <Field name="RazaoContaCorrenteDebito" length="5"
> type="INTEGER" padding="ZERO_LEFT"/>
> +                    <Field name="ContaCorrenteDebito" length="7"
> type="INTEGER" padding="ZERO_LEFT"/>
> +                    <Field name="DigitoContaCorrenteDebito" length="1"
> type="INTEGER"/>
> +                    <Field name="Zero" type="INTEGER" length="1"
> value="0"/>
> +                    <Field name="Carteira" type="INTEGER" length="3"
> padding="ZERO_LEFT"/>
> +                    <Field name="AgenciaCedente" type="INTEGER"
> length="5" padding="ZERO_LEFT"/>
> +                    <Field name="ContaCorrente" type="INTEGER" length="7"
> padding="ZERO_LEFT"/>
> +                    <Field name="DigitoContaCorrente" type="INTEGER"
> length="1" padding="ZERO_LEFT"/>
> +                    <Field name="NroControleParticipante" length="25"
> type="INTEGER"/>
> +                    <Field name="CodigoBanco" type="INTEGER" length="3"
> padding="ZERO_LEFT" value="237"/>
> +                    
> +                    <Field name="Multa" type="INTEGER" length="1"/>
> +                    <Field name="PercentagemMulta" type="INTEGER"
> length="4" padding="ZERO_LEFT"/>
> +                    <Field name="NossoNumero" type="INTEGER" length="12"
> padding="ZERO_LEFT"/>
> +                    <Field name="DescontoBonificacaoDia" type="INTEGER"
> length="10" value="0" padding="ZERO_LEFT"/>
> +                    <Field name="EmissaoPapeletaCobranca" type="INTEGER"
> length="1" padding="ZERO_LEFT"/>
> +                    <Field name="EmissaoPapeletaDebitoAutomatico"
> length="1"/>
> +                    <Field name="Branco3" length="10" value=" "/>
> +                    <Field name="IndicadorRateioCredito" length="1"/>
> +                    <Field name="AvisoDebitoAutomatico" type="INTEGER"
> length="1" padding="ZERO_LEFT"/>
> +                    <Field name="Branco4" length="2" value=" "/>
> +                    
> +                    <Field name="IdentificacaoOcorrencia" type="INTEGER"
> length="2" value="01" padding="ZERO_LEFT"/>
> +                    <Field name="NDocumento" length="10" type="INTEGER"
> padding="ZERO_LEFT"/>
> +                    <Field name="DataVencimentoTitulo" type="DATE"
> length="6" format="DATE_DDMMYY"/>
> +                    <Field name="ValorTitulo" type="INTEGER" length="13"
> padding="ZERO_LEFT"/>
> +                    
> +                    <Field name="BancoEncarregadoCobranca" type="INTEGER"
> length="3" value="0" padding="ZERO_LEFT"/>
> +                    <Field name="AgenciaDepositaria" type="INTEGER"
> length="5" value="0" padding="ZERO_LEFT"/>
> +                    <Field name="EspecieTitulo" type="INTEGER" length="2"
> padding="ZERO_LEFT"/>
> +                    <Field name="Identificacao" length="1"/>
> +                    <Field name="DataEmissaoTitulo" type="DATE"
> length="6" format="DATE_DDMMYY"/>
> +                    <Field name="1Instrucao" type="INTEGER" length="2"
> padding="ZERO_LEFT"/>
> +                    <Field name="2Instrucao" type="INTEGER" length="2"
> padding="ZERO_LEFT"/>
> +                    <Field name="MoraDiaria" type="INTEGER" length="13"
> padding="ZERO_LEFT"/>
> +                    <Field name="DataLimiteDesconto" type="DATE"
> length="6" format="DATE_DDMMYY"/>
> +                    <Field name="ValorDesconto" type="INTEGER"
> length="13" value="0" padding="ZERO_LEFT"/>
> +                    <Field name="ValorIOF" type="INTEGER" length="13"
> value="0" padding="ZERO_LEFT"/>
> +                    <Field name="ValorAbatimento" type="INTEGER"
> length="13" value="0" padding="ZERO_LEFT"/>
> +                    <Field name="IdentificacaoInscricaoSacado"
> type="INTEGER" length="2" padding="ZERO_LEFT"/>
> +                    <Field name="NInscricaoSacado" type="INTEGER"
> length="14" padding="ZERO_LEFT"/>
> +                    <Field name="NomeSacado" length="40"/>
> +                    <Field name="EnderecoCompleto" length="40"/>
> +                    <Field name="1Mensagem" length="12"/>
> +                    <Field name="Cep" length="8"/>
> +                    <Field name="Avalista-2Mensagem" length="60"/>
> +                    <Field name="NroSequencialRegistro" type="INTEGER"
> length="6" padding="ZERO_LEFT"/>
> +                </GroupOfFields>
> +                <GroupOfInnerRecords>
> +                    <Record name="DadosBoleto">
> +                        <GroupOfFields>
> +                            <IdType name="IDReg" value="2" length="1"
> position="1" />
> +                            <Field name="Mensagem1" length="80" />
> +                            <Field name="Mensagem2" length="80" />
> +                            <Field name="Mensagem3" length="80" />
> +                            <Field name="Mensagem4" length="80" />
> +                            <Field name="Filler" length="45" />
> +                            <Field name="Carteira" length="3"
> type="INTEGER" padding="ZERO_LEFT" />
> +                            <Field name="Agencia" length="5"
> type="INTEGER" padding="ZERO_LEFT" />
> +                            <Field name="ContaCorrente" length="7"
> type="INTEGER" padding="ZERO_LEFT" />
> +                            <Field name="DigitoCC" length="1"
> type="CHARACTER" />
> +                            <Field name="NossoNumero" length="12"
> padding="ZERO_LEFT" type="INTEGER"/>
> +                            <SequencialNumber
> name="NroSequencialRegistro" type="INTEGER" length="6" position="13"
> padding="ZERO_LEFT" />
> +                        </GroupOfFields>
> +                    </Record>
> +                </GroupOfInnerRecords>
> +            </Record>
> +            <Record name="Trailler">
> +                <GroupOfFields>
> +                    <IdType name="IDReg" value="9" length="1"
> position="1"/>
> +                    <Field name="Branco5" value=" " length="393"/>
> +                    <Field name="NroSequencialRegistro" type="INTEGER"
> length="6" padding="ZERO_LEFT"/>
> +                </GroupOfFields>
> +            </Record>
> +        </GroupOfRecords>
> +    </FlatFile>
> +
> +</txg:Texgit>
>
> === added file 'l10n_br_cnab_base/data/cnab400-retorno.xml'
> --- l10n_br_cnab_base/data/cnab400-retorno.xml  1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/data/cnab400-retorno.xml  2013-06-18 22:24:26 +0000
> @@ -0,0 +1,118 @@
> +<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> +<txg:Texgit xmlns:txg="http://gilmatryx.googlepages.com/Texgit"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="
> http://gilmatryx.googlepages.com/Texgitfile:////home/gilmar/NFM/WORKSPACE/TexgitSchema.xsd" version="1.0-academic">
> +    <FlatFile>
> +        <layout>
> +            <name>Layout de Leitura de arquivos retorno cnab400</name>
> +            <version>Versão 0.0.1</version>
> +            <description>
> +                Através deste layout, você poderá ler/gerar arquivos para
> retorno cnab400
> +            </description>
> +        </layout>
> +        <GroupOfRecords>
> +            <Record name="Header">
> +                <GroupOfFields>
> +                    <IdType name="IDReg" value="0" length="1"
> position="1"/>
> +                    <Field name="IdentificacaoRetorno" value="2"
> type="INTEGER" length="1" padding="ZERO_LEFT"/>
> +                    <Field name="LiteralRetorno" value="RETORNO"
> length="7"/>
> +                    <Field name="CodigoServico" value="01" type="INTEGER"
> length="2" padding="ZERO_LEFT"/>
> +                    <Field name="LiteralServico" value="COBRANCA"
> length="15"/>
> +                    <Field name="CodigoEmpresa" type="INTEGER"
> length="20" padding="ZERO_LEFT"/>
> +                    <Field name="NomeEmpresa" length="30"/>
> +                    <Field name="NumeroBanco" type="INTEGER" value="237"
> length="3" padding="ZERO_LEFT"/>
> +                    <Field name="NomeBanco" length="15" value="BRADESCO"/>
> +                    <Field name="DataGravacaoArquivo" type="DATE"
> length="6" format="DATE_DDMMYY"/>
> +                    <Field name="Zeros" value="0" type="INTEGER"
> length="8" padding="ZERO_LEFT"/>
> +                    <Field name="NAvisoBancario" type="INTEGER"
> length="5" padding="ZERO_LEFT"/>
> +                    <Field name="Branco2" value=" " length="266"/>
> +                    <Field name="DataCredito" type="DATE" length="6"
> format="DATE_DDMMYY"/>
> +                    <Field name="Branco3" value=" " length="9"/>
> +                    <Field name="NroSequencialRegistro" type="INTEGER"
> length="6" padding="ZERO_LEFT"/>
> +                </GroupOfFields>
> +            </Record>
> +            <Record name="Detalhe-Transacao" repeatable="true">
> +                <GroupOfFields>
> +                    <IdType name="IDReg" value="1" length="1"
> position="1"/>
> +                    <Field name="TipoInscricaoEmpresa" length="2"
> type="INTEGER" padding="ZERO_LEFT"/>
> +                    <Field name="NInscricaoEmpresa" length="14"
> type="INTEGER" padding="ZERO_LEFT"/>
> +                    <Field name="Zeros1" length="3" type="INTEGER"
> padding="ZERO_LEFT" value="0"/>
> +                    <Field name="Zero" type="INTEGER" length="1"
> value="0"/>
> +                    <Field name="Carteira" type="INTEGER" length="3"
> padding="ZERO_LEFT"/>
> +                    <Field name="AgenciaCedente" type="INTEGER"
> length="5" padding="ZERO_LEFT"/>
> +                    <Field name="ContaCorrente" type="INTEGER" length="7"
> padding="ZERO_LEFT"/>
> +                    <Field name="DigitoContaCorrente" type="INTEGER"
> length="1" padding="ZERO_LEFT"/>
> +                    <Field name="NroControleParticipante" length="25"
> type="INTEGER"/>
> +                    <Field name="Zeros2" length="8" type="INTEGER"
> padding="ZERO_LEFT" value="0"/>
> +                    <Field name="IdentificacaoTitulo1" type="INTEGER"
> length="12" padding="ZERO_LEFT"/>
> +                    <Field name="Brancos1" value=" " length="10"/>
> +                    <Field name="Zeros3" length="12" type="INTEGER"
> padding="ZERO_LEFT" value="0"/>
> +                    <Field name="IndicadorRateioCredito" length="1"/>
> +                    <Field name="Zeros4" length="2" type="INTEGER"
> padding="ZERO_LEFT" value="0"/>
> +                    <Field name="CarteiraHmm" type="INTEGER" length="1"
> padding="ZERO_LEFT"/>
> +                    <Field name="IdentificacaoOcorrencia" type="INTEGER"
> length="2" padding="ZERO_LEFT"/>
> +                    <Field name="DataOcorrencia" type="DATE" length="6"
> format="DATE_DDMMYY"/>
> +                    <Field name="NDocumento" length="10" type="INTEGER"
> padding="ZERO_LEFT"/>
> +                    <Field name="IdentificacaoTitulo2" type="INTEGER"
> length="20" padding="ZERO_LEFT"/>
> +                    <Field name="DataVencimentoTitulo" type="DATE"
> length="6" format="DATE_DDMMYY"/>
> +                    <Field name="ValorTitulo" type="INTEGER" length="13"
> padding="ZERO_LEFT"/>
> +                    <Field name="CodigoBanco" type="INTEGER" length="3"
> padding="ZERO_LEFT" value="237"/>
> +                    <Field name="AgenciaCedente" type="INTEGER"
> length="5" padding="ZERO_LEFT"/>
> +                    <Field name="EspecieTitulo" length="2"/>
> +                    <Field name="DespesasCobranca" type="INTEGER"
> length="13" padding="ZERO_LEFT"/>
> +                    <Field name="OutrasDespeses" type="INTEGER"
> length="13" padding="ZERO_LEFT"/>
> +                    <Field name="JurosAtraso" type="INTEGER" length="13"
> padding="ZERO_LEFT"/>
> +                    <Field name="ValorIOF" type="INTEGER" length="13"
> padding="ZERO_LEFT"/>
> +                    <Field name="ValorAbatimento" type="INTEGER"
> length="13" padding="ZERO_LEFT"/>
> +                    <Field name="ValorDesconto" type="INTEGER"
> length="13" padding="ZERO_LEFT"/>
> +                    <Field name="ValorPago" type="INTEGER" length="13"
> padding="ZERO_LEFT"/>
> +                    <Field name="JurosMora" type="INTEGER" length="13"
> padding="ZERO_LEFT"/>
> +                    <Field name="OutrosCreditos" type="INTEGER"
> length="13" padding="ZERO_LEFT"/>
> +                    <Field name="Brancos2" value=" " length="2"/>
> +                    <Field name="MotivoCodigo19" length="1"/>
> +                    <Field name="DataCredito" type="DATE" length="6"
> format="DATE_DDMMYY"/>
> +                    <Field name="OrigemPagamento" type="INTEGER"
> length="3" padding="ZERO_LEFT"/>
> +                    <Field name="Brancos3" value=" " length="10"/>
> +                    <Field name="CodigoBanco" type="INTEGER" length="4"
> padding="ZERO_LEFT"/>
> +                    <Field name="MotivosRejeicoes" type="INTEGER"
> length="10" padding="ZERO_LEFT"/>
> +                    <Field name="Brancos4" value=" " length="40"/>
> +                    <Field name="NCartorio" type="INTEGER" length="2"
> padding="ZERO_LEFT"/>
> +                    <Field name="NProtocolo" length="10"/>
> +                    <Field name="Brancos5" value=" " length="14"/>
> +                    <Field name="NroSequencialRegistro" type="INTEGER"
> length="6" padding="ZERO_LEFT"/>
> +                </GroupOfFields>
> +            </Record>
> +            <Record name="Trailler">
> +                <GroupOfFields>
> +                    <IdType name="IDReg" value="9" length="1"
> position="1"/>
> +                    <Field name="IdentificacaoRetorno" type="INTEGER"
> length="1" padding="ZERO_LEFT"/>
> +                    <Field name="TipoRegisto" type="INTEGER" length="2"
> padding="ZERO_LEFT"/>
> +                    <Field name="CodigoBanco" type="INTEGER" length="3"
> padding="ZERO_LEFT" value="237"/>
> +                    <Field name="Brancos1" value=" " length="10"/>
> +                    <Field name="QuantidadeTitulos" type="INTEGER"
> length="8" padding="ZERO_LEFT"/>
> +                    <Field name="ValorTotal" type="INTEGER" length="14"
> padding="ZERO_LEFT"/>
> +                    <Field name="NAviso" type="INTEGER" length="8"
> padding="ZERO_LEFT"/>
> +                    <Field name="Brancos2" value=" " length="10"/>
> +                    <Field name="QuantidadeRegistos02" type="INTEGER"
> length="5" padding="ZERO_LEFT"/>
> +                    <Field name="ValorRegistros02" type="INTEGER"
> length="12" padding="ZERO_LEFT"/>
> +                    <Field name="ValorRegistros06Liquidacao"
> type="INTEGER" length="12" padding="ZERO_LEFT"/>
> +                    <Field name="QuantidadeRegistros06Liquidacao"
> type="INTEGER" length="5" padding="ZERO_LEFT"/>
> +                    <Field name="ValorRegistros06" type="INTEGER"
> length="12" padding="ZERO_LEFT"/>
> +                    <Field name="QuantidadeRegistros0910" type="INTEGER"
> length="5" padding="ZERO_LEFT"/>
> +                    <Field name="ValorRegistros0910" type="INTEGER"
> length="12" padding="ZERO_LEFT"/>
> +                    <Field name="QuantidadeRegistros13" type="INTEGER"
> length="5" padding="ZERO_LEFT"/>
> +                    <Field name="ValorRegistros13" type="INTEGER"
> length="12" padding="ZERO_LEFT"/>
> +                    <Field name="QuantidadeRegistros14" type="INTEGER"
> length="5" padding="ZERO_LEFT"/>
> +                    <Field name="ValorRegistros14" type="INTEGER"
> length="12" padding="ZERO_LEFT"/>
> +                    <Field name="QuantidadeRegistros12" type="INTEGER"
> length="5" padding="ZERO_LEFT"/>
> +                    <Field name="ValorRegistros12" type="INTEGER"
> length="12" padding="ZERO_LEFT"/>
> +                    <Field name="QuantidadeRegistros19" type="INTEGER"
> length="5" padding="ZERO_LEFT"/>
> +                    <Field name="ValorRegistros19" type="INTEGER"
> length="12" padding="ZERO_LEFT"/>
> +                    <Field name="Brancos3" value=" " length="174"/>
> +                    <Field name="ValorTotalRateios" type="INTEGER"
> length="15" padding="ZERO_LEFT"/>
> +                    <Field name="QuantidadeTotalRateios" type="INTEGER"
> length="8" padding="ZERO_LEFT"/>
> +                    <Field name="Brancos4" value=" " length="9"/>
> +                    <Field name="NroSequencialRegistro" type="INTEGER"
> length="6" padding="ZERO_LEFT"/>
> +                </GroupOfFields>
> +            </Record>
> +        </GroupOfRecords>
> +    </FlatFile>
> +</txg:Texgit>
>
> === added directory 'l10n_br_cnab_base/edi'
> === added file 'l10n_br_cnab_base/file_format.py'
> --- l10n_br_cnab_base/file_format.py    1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/file_format.py    2013-06-18 22:24:26 +0000
> @@ -0,0 +1,85 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import time
> +import netsvc
> +from tools.translate import _
> +from osv import osv, fields
> +
> +FORMAT_TYPES = ('Arquivo-Remessa', 'Arquivo-Retorno')
> +
> +class FileFormat(osv.osv):
> +    _name = 'cnab.file_format'
> +
> +    _columns = {
> +                'name': fields.char('Name', size=256),
> +                'version': fields.char('Version', size=256),
> +                'description': fields.text('Description'),
> +                'records_ids': fields.one2many('cnab.record_format',
> 'file_id', 'Records'),
> +                'type': fields.selection(zip(FORMAT_TYPES, FORMAT_TYPES),
> 'Type', required=True),
> +                }
> +
> +class RecordFormat(osv.osv):
> +    _name = 'cnab.record_format'
> +
> +    def _get_id(self, cr, uid, ids, field_name, arg, context=None):
> +        res = {}
> +        for recordformat in self.browse(cr, uid, ids):
> +            res[recordformat.id] = recordformat.fields_ids[0].value
> +        return res
> +
> +    _columns = {
> +                'file_id': fields.many2one('cnab.file_format', 'File'),
> +                'record_id': fields.many2one('cnab.record_format',
> 'Parent Record'),
> +                'identifier': fields.function(_get_id, method=True,
> type='char', string="IdType"),
> +                'name': fields.char('Name', size=256),
> +                'description': fields.char('Description', size=256),
> +                'repeatable': fields.boolean('repeatable'),
> +                'records_ids': fields.one2many('cnab.record_format',
> 'record_id', 'Inner Records'),
> +                'fields_ids': fields.one2many('cnab.field_format',
> 'record_id', 'Fields'),
> +                }
> +
> +class FieldFormat(osv.osv):
> +    _name = 'cnab.field_format'
> +
> +    VALID_TYPES = ('STRING', 'CHARACTER', 'INTEGER', 'DATE', 'BIGDECIMAL')
> +    VALID_FORMATS = ('DATE_DDMMYY', 'DECIMAL_DD')
> +    VALID_PADDINGS = ('ZERO_LEFT',)
> +
> +    InternalTypes = ('IdType', 'Field', 'SequencialNumber')
> +
> +    _columns = {
> +                'record_id': fields.many2one('cnab.record_format',
> 'Record'),
> +                'sequence': fields.integer('Sequence'),
> +                'type': fields.selection(zip(InternalTypes,
> InternalTypes), 'Type'),
> +                'name': fields.char('Name', size=256),
> +                'value': fields.char('Value', size=256),
> +                'length': fields.integer('Length'),
> +                'position': fields.integer('Position'),
> +                'value_type': fields.selection(zip(VALID_TYPES,
> VALID_TYPES), 'Value Type'),
> +                'format': fields.selection(zip(VALID_FORMATS,
> VALID_FORMATS), 'Format'),
> +                'padding': fields.selection(zip(VALID_PADDINGS,
> VALID_PADDINGS), 'Padding'),
> +                }
> +
> +    _order = 'sequence'
>
> === added file 'l10n_br_cnab_base/file_format_view.xml'
> --- l10n_br_cnab_base/file_format_view.xml      1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/file_format_view.xml      2013-06-18 22:24:26 +0000
> @@ -0,0 +1,91 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data>
> +
> +        <record id="action_cnab_file_format"
> model="ir.actions.act_window">
> +            <field name="name">Formato de Arquivos</field>
> +            <field name="res_model">cnab.file_format</field>
> +            <field name="view_type">form</field>
> +            <field name="view_mode">tree,form</field>
> +            <field name="domain">[]</field>
> +        </record>
> +
> +        <menuitem
> +            id="menu_cnab_file_format"
> +            name="Formato de Arquivos"
> +            action="action_cnab_file_format"
> +            parent="menu_cnab_root"
> +            sequence="10" />
> +
> +        <record id="cnab_file_format_form" model="ir.ui.view">
> +            <field name="name">cnab.file_format</field>
> +            <field name="view_type">form</field>
> +            <field name="model">cnab.file_format</field>
> +            <field name="arch" type="xml">
> +                <form string="Formato de Arquivos">
> +                    <group>
> +                        <field name="name"/>
> +                        <field name="version"/>
> +                        <field name="type"/>
> +                        <field name="description"/>
> +                        <field name="records_ids"/>
> +                    </group>
> +                </form>
> +            </field>
> +        </record>
> +
> +        <record id="cnab_file_format_tree" model="ir.ui.view">
> +            <field name="name">cnab.file_format</field>
> +            <field name="view_type">tree</field>
> +            <field name="model">cnab.file_format</field>
> +            <field name="arch" type="xml">
> +                <tree string="Formatos de Arquivos">
> +                    <field name="name"/>
> +                    <field name="version"/>
> +                </tree>
> +            </field>
> +        </record>
> +
> +        <record id="cnab_file_format_search" model="ir.ui.view">
> +            <field name="name">cnab.file_format</field>
> +            <field name="view_type">search</field>
> +            <field name="model">cnab.file_format</field>
> +            <field name="arch" type="xml">
> +                <search>
> +                    <field name="name"/>
> +                    <field name="version"/>
> +                </search>
> +            </field>
> +        </record>
> +
> +        <record id="cnab_record_format_form" model="ir.ui.view">
> +            <field name="name">cnab.record_format</field>
> +            <field name="view_type">form</field>
> +            <field name="model">cnab.record_format</field>
> +            <field name="arch" type="xml">
> +                <form string="Formato de Campos">
> +                    <group>
> +                        <field name="identifier"/>
> +                        <field name="name"/>
> +                        <field name="repeatable"/>
> +                        <field name="description"/>
> +                        <field name="records_ids"/>
> +                        <field name="fields_ids"/>
> +                    </group>
> +                </form>
> +            </field>
> +        </record>
> +
> +        <record id="cnab_record_format_tree" model="ir.ui.view">
> +            <field name="name">cnab.record_format</field>
> +            <field name="view_type">tree</field>
> +            <field name="model">cnab.record_format</field>
> +            <field name="arch" type="xml">
> +                <tree string="Formato de Campos">
> +                    <field name="name"/>
> +                </tree>
> +            </field>
> +        </record>
> +
> +    </data>
> +</openerp>
>
> === added directory 'l10n_br_cnab_base/i18n'
> === added directory 'l10n_br_cnab_base/images'
> === added file 'l10n_br_cnab_base/images/oerp61.jpeg'
> Binary files l10n_br_cnab_base/images/oerp61.jpeg       1970-01-01
> 00:00:00 +0000 and l10n_br_cnab_base/images/oerp61.jpeg      2013-06-18
> 22:24:26 +0000 differ
> === added directory 'l10n_br_cnab_base/report'
> === added file 'l10n_br_cnab_base/res_bank.py'
> --- l10n_br_cnab_base/res_bank.py       1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/res_bank.py       2013-06-18 22:24:26 +0000
> @@ -0,0 +1,37 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import netsvc
> +from tools.translate import _
> +from osv import osv, fields
> +
> +class Bank(osv.osv):
> +    _name = 'res.bank'
> +    _inherit = 'res.bank'
> +
> +    _columns = {
> +                'enable_cnab': fields.boolean('CNAB'),
> +                'cnab_name': fields.char('CNAB Name', size=15),
> +                'cnab_code': fields.char('CNAB Code', size=3),
> +                }
>
> === added file 'l10n_br_cnab_base/res_bank_view.xml'
> --- l10n_br_cnab_base/res_bank_view.xml 1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/res_bank_view.xml 2013-06-18 22:24:26 +0000
> @@ -0,0 +1,22 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data>
> +
> +        <record id="cnab_res_bank_form" model="ir.ui.view">
> +            <field name="name">cnab.bank</field>
> +            <field name="view_type">form</field>
> +            <field name="model">res.bank</field>
> +            <field name="inherit_id" ref="base.view_res_bank_form"/>
> +            <field name="arch" type="xml">
> +                <group string="Communication" position="after">
> +                    <group string="CNAB">
> +                        <field name="enable_cnab"/>
> +                        <field name="cnab_name" attrs="{'required':
> [('enable_cnab','=',True)], 'readonly': [('enable_cnab','=',False)]}"/>
> +                        <field name="cnab_code" attrs="{'required':
> [('enable_cnab','=',True)], 'readonly': [('enable_cnab','=',False)]}"/>
> +                    </group>
> +                </group>
> +            </field>
> +        </record>
> +
> +    </data>
> +</openerp>
>
> === added file 'l10n_br_cnab_base/root_menus.xml'
> --- l10n_br_cnab_base/root_menus.xml    1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/root_menus.xml    2013-06-18 22:24:26 +0000
> @@ -0,0 +1,12 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data>
> +
> +        <menuitem
> +            id="menu_cnab_root"
> +            name="CNAB"
> +            parent="account.menu_finance"
> +            sequence="15"/>
> +
> +    </data>
> +</openerp>
>
> === added directory 'l10n_br_cnab_base/security'
> === added file 'l10n_br_cnab_base/sequence_type.xml'
> --- l10n_br_cnab_base/sequence_type.xml 1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/sequence_type.xml 2013-06-18 22:24:26 +0000
> @@ -0,0 +1,11 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data noupdate="1">
> +
> +        <record id="cnab_sequence_type" model="ir.sequence.type">
> +            <field name="name">cnab_sequence_type</field>
> +            <field name="code">cnab.sequence</field>
> +        </record>
> +
> +    </data>
> +</openerp>
>
> === added directory 'l10n_br_cnab_base/wizard'
> === added file 'l10n_br_cnab_base/wizard/__init__.py'
> --- l10n_br_cnab_base/wizard/__init__.py        1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/wizard/__init__.py        2013-06-18 22:24:26 +0000
> @@ -0,0 +1,27 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import file_format_loader
> +import export_cnab
> +import import_cnab
>
> === added file 'l10n_br_cnab_base/wizard/export_cnab.py'
> --- l10n_br_cnab_base/wizard/export_cnab.py     1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/wizard/export_cnab.py     2013-06-18 22:24:26 +0000
> @@ -0,0 +1,90 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import time
> +import netsvc
> +from tools.translate import _
> +from osv import osv, fields
> +
> +import logging
> +import base64
> +import datetime
> +#from collections import OrderedDict
> +
> +from generator import CNABGenerator
> +
> +class CNABExporter(osv.osv_memory):
> +    _name = 'cnab.wizard.exporter'
> +
> +    def prepare_data(self, cr, uid, format, bank, invoice_ids):
> +        #to be overridden by subclasses
> +        return {}
> +
> +    def load_format(self, cr, uid):
> +        pool = self.pool.get('cnab.file_format')
> +        try:
> +            format_id = pool.search(cr, uid, [('type', '=',
> 'Arquivo-Remessa')])
> +            [format] = pool.browse(cr, uid, format_id)
> +            return format
> +        except ValueError:
> +            raise osv.except_osv('Error', 'CNAB File format for
> Arquivo-Remessa not found')
> +        return format
> +
> +    def serialize(self, cr, uid, format, data):
> +#        fake_data = [OrderedDict([(u'IDReg', '0'),
> (u'IdentificacaoRemessa', 1), (u'LiteralRemessa', 'REMESSA'),
> (u'CodigoServico', 1), (u'LiteralServico', 'COBRANCA'), (u'CodigoEmpresa',
> 74017), (u'NomeEmpresa', 'ASSOCIACAO MANTENEDORA ASSISTE'),
> (u'NumeroBanco', 237), (u'NomeBanco', 'BRADESCO'), (u'DataGravacaoArquivo',
> datetime.date(2013, 4, 24)), (u'Branco', False), (u'IdentificacaoSistema',
> 'MX'), (u'NroSequencialArquivo', 9000461), (u'Branco2', False),
> (u'NroSequencialRegistroH', 1)]), OrderedDict([(u'IDReg', '1'),
> (u'AgenciaDebito', '00000'), (u'DigitoAgenciaDebito', False),
> (u'RazaoContaCorrenteDebito', '00000'), (u'ContaCorrenteDebito',
> '0000000'), (u'DigitoContaCorrenteDebito', '0'), (u'Zero', 0),
> (u'Carteira', 9), (u'AgenciaCedente', 160), (u'ContaCorrente', 82800),
> (u'DigitoContaCorrente', 9), (u'NroControleParticipante', False),
> (u'CodigoBanco', 237), (u'Zeros', 0), (u'NossoNumero', 130001042568L),
> (u'DescontoBonificacaoDia', 0), (u'EmissaoPapeletaCobranca', 1),
> (u'EmissaoPapeletaDebitoAutomatico', 'S'), (u'Branco3', False),
> (u'IndicadorRateioCredito', False), (u'AvisoDebitoAutomatico', False),
> (u'Branco4', False), (u'IdentificacaoOcorrencia', 1), (u'NDocumento',
> '0000080631'), (u'DataVencimentoTitulo', datetime.date(2013, 5, 15)),
> (u'ValorTitulo', 6250), (u'BancoEncarregadoCobranca', 0),
> (u'AgenciaDepositaria', 0), (u'EspecieTitulo', 1), (u'Identificacao', 'N'),
> (u'DataEmissaoTitulo', datetime.date(2013, 4, 24)), (u'1Instrucao', 0),
> (u'2Instrucao', 0), (u'MoraDiaria', 0), (u'DataLimiteDesconto', 150513),
> (u'ValorDesconto', 0), (u'ValorIOF', 0), (u'ValorAbatimento', 0),
> (u'IdentificacaoInscricaoSacado', 1), (u'NInscricaoSacado', 20507679865L),
> (u'NomeSacado', 'SANDRA RIBEIRO DA SILVA ROCHA'), (u'EnderecoCompleto', 'R
> ESTRELA D OESTE,310'), (u'1Mensagem', False), (u'Cep', '06721010'),
> (u'Avalista-2Mensagem', False), (u'NroSequencialRegistroD', 2)]),
> OrderedDict([(u'IDReg', '2'), (u'Mensagem1', 'TAXA CERIMONIA DE FORMATURA
>                                                  .'), (u'Mensagem2', '941
> FELIPE SILVA ROCHA
> .'), (u'Mensagem3', '8 PARCELAS
>                         .'), (u'Mensagem4', 'APOS 60 DIAS PAGAVEL SOMENTE
> NA TESOURARIA DO COLEGIO                          .'), (u'Filler', False),
> (u'Carteira', 9), (u'Agencia', 160), (u'ContaCorrente', 82800),
> (u'DigitoCC', '9'), (u'NossoNumero', '13000104256'), (u'DigitoNN', '8'),
> (u'sequencia', 3)]), OrderedDict([(u'IDReg', '9'), (u'Branco5', False),
> (u'NroSequencialRegistroT', 4)])]
> +        generator = CNABGenerator()
> +        result = generator.generate_file(format, data).read()
> +        return result
> +
> +    def export(self, cr, uid, ids, context=None):
> +        [wizard] = self.browse(cr, uid, ids)
> +        invoice_ids = context.get('active_ids', [])
> +        format = self.load_format(cr, uid)
> +        data = self.prepare_data(cr, uid, format, wizard.bank_id,
> invoice_ids)
> +        result = self.serialize(cr, uid, format, data)
> +        encoded_result = base64.b64encode(result)
> +        self.write(cr, uid, [wizard.id], {'file': encoded_result,
> 'state': 'done'})
> +
> +        return {
> +                'type': 'ir.actions.act_window',
> +                'res_model': self._name,
> +                'view_mode': 'form',
> +                'view_type': 'form',
> +                'res_id': wizard.id,
> +                #'views': [(resource_id, 'form')],
> +                'target': 'new',
> +               }
> +
> +    _columns = {
> +                'file': fields.binary('File', readonly=True),
> +                'filename': fields.char('Filename', size=128),
> +                'bank_id': fields.many2one('res.bank', 'Bank',
> domain=[('enable_cnab', '=', True)]),
> +                #'format': fields.many2one('cnab.file_format', 'Format',
> required=True),
> +                'state': fields.selection([('init', 'init'), ('done',
> 'done')], 'state', readonly=True),
> +                }
> +
> +    _defaults = {
> +                 'state': 'init',
> +                 'filename': 'result.txt',
> +                 }
>
> === added file 'l10n_br_cnab_base/wizard/export_cnab_view.xml'
> --- l10n_br_cnab_base/wizard/export_cnab_view.xml       1970-01-01
> 00:00:00 +0000
> +++ l10n_br_cnab_base/wizard/export_cnab_view.xml       2013-06-18
> 22:24:26 +0000
> @@ -0,0 +1,43 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data>
> +
> +    <record id="cnab_exporter_form" model="ir.ui.view">
> +        <field name="name">cnab.wizard.exporter</field>
> +        <field name="view_type">form</field>
> +        <field name="model">cnab.wizard.exporter</field>
> +        <field name="arch" type="xml">
> +            <form string="Exportar CNAB" version="7.0">
> +                <field name="state" invisible="1"/>
> +                <group states="init">
> +                    <field name="bank_id"/>
> +                </group>
> +                <group states="done">
> +                    <field name="filename" invisible="1"/>
> +                    <field name="file" filename="filename"/>
> +                </group>
> +                <footer>
> +                    <group states="init">
> +                        <button type="object" name="export"
> string="Export"/>
> +                    </group>
> +                </footer>
> +            </form>
> +        </field>
> +    </record>
> +
> +    <record id="action_cnab_exporter" model="ir.actions.act_window">
> +        <field name="name">Exportar CNAB</field>
> +        <field name="res_model">cnab.wizard.exporter</field>
> +        <field name="view_type">form</field>
> +        <field name="view_mode">form</field>
> +        <field name="target">new</field>
> +        <field name="domain">[]</field>
> +    </record>
> +
> +    <act_window id="actwindow_cnab_exporter" key2="client_action_multi"
> +        name="Exportar CNAB" res_model="cnab.wizard.exporter"
> +        src_model="account.invoice" view_id="cnab_exporter_form"
> +        view_mode="form" target="new" view_type="form"/>
> +    </data>
> +
> +</openerp>
>
> === added file 'l10n_br_cnab_base/wizard/file_format_loader.py'
> --- l10n_br_cnab_base/wizard/file_format_loader.py      1970-01-01
> 00:00:00 +0000
> +++ l10n_br_cnab_base/wizard/file_format_loader.py      2013-06-18
> 22:24:26 +0000
> @@ -0,0 +1,112 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import time
> +import netsvc
> +from tools.translate import _
> +from osv import osv, fields
> +
> +from lxml.etree import XML, XMLParser
> +import logging
> +import base64
> +
> +from openerp.addons.l10n_br_cnab_base import file_format
> +FORMAT_TYPES = file_format.FORMAT_TYPES
> +
> +def create_new_rows(func, values, sequence=False):
> +    return map(lambda *args: (0, 0, func(*args)), values,
> *([range(len(values))] if sequence else []))
> +
> +class FileFormatLoader(osv.osv_memory):
> +    _name = 'cnab.wizard.file_format_loader'
> +
> +    def load(self, cr, uid, ids, context=None):
> +        pool = self.pool.get('cnab.file_format')
> +        parser = Parser()
> +        [wizard] = self.browse(cr, uid, ids)
> +        xml = base64.b64decode(wizard.file)
> +        data = parser.parse_schema(xml)
> +        data['type'] = wizard.type
> +        if wizard.replace:
> +            old_ids = pool.search(cr, uid, [('name', '=', data['name'])])
> +            pool.unlink(cr, uid, old_ids)
> +        new_id = pool.create(cr, uid, data)
> +
> +        return {
> +                'type': 'ir.actions.act_window',
> +                'res_model': 'cnab.file_format',
> +                'view_mode': 'form',
> +                'view_type': 'form',
> +                'res_id': new_id,
> +                #'views': [(resource_id, 'form')],
> +               }
> +
> +    _columns = {
> +                'file': fields.binary('File', required=True),
> +                'type': fields.selection(zip(FORMAT_TYPES, FORMAT_TYPES),
> 'Type', required=True),
> +                'replace': fields.boolean('Replace any entries with the
> same name'),
> +                }
> +
> +class Parser(object):
> +    def parse_schema(self, xml_schema):
> +        xml = XML(xml_schema, parser=XMLParser(remove_comments=True))
> +        return self.parse_file(xml)
> +
> +    def parse_file(self, xml):
> +        layout_element = xml.find('FlatFile/layout')
> +        records_elements = xml.findall('FlatFile/GroupOfRecords/Record')
> +        return {
> +                'name': layout_element.find('name').text,
> +                'version': layout_element.find('version').text,
> +                'description': layout_element.find('description').text,
> +                'records_ids': create_new_rows(self.parse_record,
> records_elements),
> +                }
> +
> +    def parse_record(self, record):
> +        group_of_fields = record.find('GroupOfFields')
> +        fields_elements = list(group_of_fields) if group_of_fields is not
> None else []
> +        group_of_inner_records = record.find('GroupOfInnerRecords')
> +        inner_records = list(group_of_inner_records) if
> group_of_inner_records is not None else []
> +        is_repeatable = False if 'repeatable' not in record.keys() else
> (record.get('repeatable') == 'true')
> +        return {
> +                'name': record.get('name'),
> +                'description': record.get('description'),
> +                'repeatable': is_repeatable,
> +                'fields_ids': create_new_rows(self.parse_field,
> fields_elements, sequence=True),
> +                'records_ids': create_new_rows(self.parse_record,
> inner_records),
> +                }
> +
> +    def parse_field(self, field, sequence):
> +        optional = lambda e, k: e.get(k) if k in e.keys() else False
> +        optional_int = lambda e, k: int(optional(e, k)) if optional(e, k)
> is not False else False
> +        return {
> +                'sequence': sequence,
> +                'type': field.tag,
> +                'name': field.get('name'),
> +                'value': optional(field, 'value'),
> +                'length': int(field.get('length')),
> +                'position': optional_int(field, 'position'),
> +                'value_type': optional(field, 'type'),
> +                'format': optional(field, 'format'),
> +                'padding': optional(field, 'padding'),
> +               }
>
> === added file 'l10n_br_cnab_base/wizard/file_format_loader_view.xml'
> --- l10n_br_cnab_base/wizard/file_format_loader_view.xml        1970-01-01
> 00:00:00 +0000
> +++ l10n_br_cnab_base/wizard/file_format_loader_view.xml        2013-06-18
> 22:24:26 +0000
> @@ -0,0 +1,40 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data>
> +
> +    <record id="action_cnab_file_format_loader"
> model="ir.actions.act_window">
> +        <field name="name">Carregar Formato de Arquivos</field>
> +        <field name="res_model">cnab.wizard.file_format_loader</field>
> +        <field name="view_type">form</field>
> +        <field name="view_mode">form</field>
> +        <field name="target">new</field>
> +        <field name="domain">[]</field>
> +    </record>
> +
> +    <menuitem
> +        id="menu_cnab_file_format_loader"
> +        name="Carregar Formato de Arquivos"
> +        action="action_cnab_file_format_loader"
> +        parent="menu_cnab_root"
> +        sequence="20" />
> +
> +    <record id="cnab_file_format_loader_form" model="ir.ui.view">
> +        <field name="name">cnab.wizard.file_format_loader</field>
> +        <field name="view_type">form</field>
> +        <field name="model">cnab.wizard.file_format_loader</field>
> +        <field name="arch" type="xml">
> +            <form string="Carregar Formato de Arquivos" version="7.0">
> +                <group>
> +                    <field name="file"/>
> +                    <field name="type"/>
> +                    <field name="replace"/>
> +                </group>
> +                <footer>
> +                    <button type="object" name="load" string="Load"/>
> +                </footer>
> +            </form>
> +        </field>
> +    </record>
> +    </data>
> +
> +</openerp>
>
> === added file 'l10n_br_cnab_base/wizard/generator.py'
> --- l10n_br_cnab_base/wizard/generator.py       1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/wizard/generator.py       2013-06-18 22:24:26 +0000
> @@ -0,0 +1,87 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +#import time
> +#import netsvc
> +#from tools.translate import _
> +#from osv import osv, fields
> +
> +#from collections import OrderedDict
> +from cStringIO import StringIO
> +from datetime import datetime
> +import os
> +
> +TYPE_ADAPTERS = {
> +                 'INTEGER': unicode,
> +                 'DATE': lambda d: d.strftime("%d%m%y"),
> +                 'CHARACTER': lambda s: s.upper(),
> +                }
> +
> +class CNABGenerator(object):
> +    def get_record_formats(self, parent):
> +        record_formats = dict((r.identifier, r) for r in
> parent.records_ids)
> +        for child_record in parent.records_ids:
> +            record_formats.update(self.get_record_formats(child_record))
> +        return record_formats
> +
> +    def pad_value(self, padding, length, value):
> +        value = str(value)
> +        if padding == 'ZERO_LEFT':
> +            value = value.rjust(length, '0')
> +        else:
> +            value = value.ljust(length, ' ')
> +        return value
> +
> +    def get_record_format(self, cnab_file, record_formats, idtype_length):
> +        idtype = cnab_file.read(idtype_length)
> +        cnab_file.seek(-idtype_length, os.SEEK_CUR)
> +        if idtype == '':
> +            return None
> +        record_format = record_formats[idtype]
> +        return record_format
> +
> +    def generate_file(self, format, records):
> +        record_formats = self.get_record_formats(format)
> +        result_file = StringIO()
> +        for record in records:
> +            record_format = record_formats[record['IDReg']]
> +            for field in record_format.fields_ids:
> +                self.generate_field(field, record, result_file)
> +            result_file.write('\r\n')
> +        result_file.seek(0)
> +        return result_file
> +
> +    def generate_field(self, field, record, result_file):
> +        if field.value is False:
> +            value = record[field.name]
> +        else:
> +            value = field.value
> +        if value is False or value is None:
> +            value = ''
> +        if field.value_type:
> +            adapter = TYPE_ADAPTERS[field.value_type]
> +            value = adapter(value)
> +        value = value[:field.length]
> +        value = self.pad_value(field.padding, field.length, value)
> +        result_file.write(value)
>
> === added file 'l10n_br_cnab_base/wizard/import_cnab.py'
> --- l10n_br_cnab_base/wizard/import_cnab.py     1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/wizard/import_cnab.py     2013-06-18 22:24:26 +0000
> @@ -0,0 +1,162 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import time
> +import netsvc
> +from tools.translate import _
> +from osv import osv, fields
> +
> +from cStringIO import StringIO
> +from decimal import Decimal
> +import logging
> +import base64
> +
> +from parser import CNABParser
> +
> +class CNABImporter(osv.osv_memory):
> +    _name = 'cnab.wizard.importer'
> +
> +    def load_format(self, cr, uid):
> +        pool = self.pool.get('cnab.file_format')
> +        try:
> +            format_id = pool.search(cr, uid, [('type', '=',
> 'Arquivo-Retorno')])
> +            [format] = pool.browse(cr, uid, format_id)
> +            return format
> +        except ValueError:
> +            raise osv.except_osv('Error', 'CNAB File format for
> Arquivo-Retorno not found')
> +        return format
> +
> +    def generate_payment_with_journal(self, cr, uid, journal_id,
> partner_id,
> +                                      amount, entry_name, date,
> should_validate, context):
> +        """
> +        Generate a voucher for the payment
> +
> +        It will try to match with the invoice of the order by
> +        matching the payment ref and the invoice origin.
> +
> +        The invoice does not necessarily exists at this point, so if yes,
> +        it will be matched in the voucher, otherwise, the voucher won't
> +        have any invoice lines and the payment lines will be reconciled
> +        later with "auto-reconcile" if the option is used.
> +
> +        """
> +        voucher_obj = self.pool.get('account.voucher')
> +        voucher_line_obj = self.pool.get('account.voucher.line')
> +        move_line_obj = self.pool.get('account.move.line')
> +
> +        journal = self.pool.get('account.journal').browse(
> +            cr, uid, journal_id, context=context)
> +
> +        voucher_vals = {'reference': entry_name,
> +                        'journal_id': journal.id,
> +                        'amount': amount,
> +                        'date': date,
> +                        'partner_id': partner_id,
> +                        'account_id':
> journal.default_credit_account_id.id,
> +                        'currency_id': journal.company_id.currency_id.id,
> +                        'company_id': journal.company_id.id,
> +                        'type': 'receipt', }
> +        voucher_id = voucher_obj.create(cr, uid, voucher_vals,
> context=context)
> +
> +        # call on change to search the invoice lines
> +        onchange_voucher = voucher_obj.onchange_partner_id(
> +            cr, uid, [],
> +            partner_id=partner_id,
> +            journal_id=journal.id,
> +            amount=amount,
> +            currency_id=journal.company_id.currency_id.id,
> +            ttype='receipt',
> +            date=date,
> +            context=context)['value']
> +
> +        # keep in the voucher only the move line of the
> +        # invoice (eventually) created for this order
> +        matching_line = {}
> +        if onchange_voucher.get('line_cr_ids'):
> +            voucher_lines = onchange_voucher['line_cr_ids']
> +            line_ids = [line['move_line_id'] for line in voucher_lines]
> +            matching_ids = [line.id for line
> +                            in move_line_obj.browse(
> +                                cr, uid, line_ids, context=context)
> +                            if line.ref == entry_name]
> +            matching_lines = [line for line
> +                              in voucher_lines
> +                              if line['move_line_id'] in matching_ids]
> +            if matching_lines:
> +                matching_line = matching_lines[0]
> +                matching_line.update({
> +                    'amount': amount,
> +                    'voucher_id': voucher_id,
> +                })
> +
> +        if matching_line:
> +            voucher_line_obj.create(cr, uid, matching_line,
> context=context)
> +        if should_validate:
> +            wf_service = netsvc.LocalService("workflow")
> +            wf_service.trg_validate(
> +                uid, 'account.voucher', voucher_id, 'proforma_voucher',
> cr)
> +        return voucher_id
> +
> +    def _pay_invoice(self, cr, uid, journal, invoice, payment_date,
> payment_amount):
> +        period_obj = self.pool.get('account.period')
> +        company_id =
> self.pool.get('res.company')._company_default_get(cr, uid,
> 'account.voucher')
> +        [period_id] = period_obj.find(cr, uid, payment_date,
> {'company_id': company_id})
> +        account_id = invoice.partner_id.property_account_receivable.id
> +        self.generate_payment_with_journal(cr, uid, journal.id,
> invoice.partner_id.id, payment_amount, invoice.move_id.ref, payment_date,
> True, context={'invoice_id': invoice.id})
> +
> +    def _cents_to_euros(self, value):
> +        return float((Decimal(value) /
> Decimal('100')).quantize(Decimal('1.00')))
> +
> +    def import_file(self, cr, uid, ids, context=None):
> +        invoice_pool = self.pool.get('account.invoice')
> +        [wizard] = self.browse(cr, uid, ids)
> +        format = self.load_format(cr, uid)
> +        data = base64.b64decode(wizard.file)
> +        cnab_file = StringIO(data)
> +        try:
> +            parser = CNABParser()
> +            payments = [line for line in parser.parse_file(format,
> cnab_file) if line['IDReg'] == '1']
> +        except:
> +            raise osv.except_osv('Error', 'Invalid File')
> +        journal = wizard.bank_id.journal_id
> +        if not journal:
> +            raise osv.except_osv('Error', 'Please configure bank journal')
> +        not_found = []
> +        for line in payments:
> +            try:
> +                value = self._cents_to_euros(line['ValorPago'])
> +                payment_date = line['DataCredito'].isoformat()
> +                invoice_ids = invoice_pool.search(cr, uid, [('number',
> '=', line['IdentificacaoTitulo1'])])
> +                [invoice] = invoice_pool.browse(cr, uid, invoice_ids)
> +                print "I'm paying invoice %s with %s euros" %
> (invoice_id, value)
> +                self._pay_invoice(cr, uid, journal, invoice,
> payment_date, value)
> +            except ValueError:
> +                not_found.append(str(line['IdentificacaoTitulo1']))
> +        logging.error('Couldn\'t find the following invoices: %s', ',
> '.join(not_found))
> +        return {'type': 'ir.actions.act_window_close'}
> +
> +    _columns = {
> +                'file': fields.binary('File', required=True),
> +                'bank_id': fields.many2one('res.partner.bank', 'Bank',
> domain=[('bank.enable_cnab', '=', True)])
> +                }
>
> === added file 'l10n_br_cnab_base/wizard/import_cnab_view.xml'
> --- l10n_br_cnab_base/wizard/import_cnab_view.xml       1970-01-01
> 00:00:00 +0000
> +++ l10n_br_cnab_base/wizard/import_cnab_view.xml       2013-06-18
> 22:24:26 +0000
> @@ -0,0 +1,39 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data>
> +
> +    <record id="cnab_importer_form" model="ir.ui.view">
> +        <field name="name">cnab.wizard.importer</field>
> +        <field name="view_type">form</field>
> +        <field name="model">cnab.wizard.importer</field>
> +        <field name="arch" type="xml">
> +            <form string="Importar CNAB" version="7.0">
> +                <group>
> +                    <field name="bank_id"/>
> +                    <field name="file"/>
> +                </group>
> +                <footer>
> +                    <button type="object" name="import_file"
> string="Import"/>
> +                </footer>
> +            </form>
> +        </field>
> +    </record>
> +
> +    <record id="action_cnab_importer" model="ir.actions.act_window">
> +        <field name="name">Importar CNAB</field>
> +        <field name="res_model">cnab.wizard.importer</field>
> +        <field name="view_type">form</field>
> +        <field name="view_mode">form</field>
> +        <field name="target">new</field>
> +        <field name="domain">[]</field>
> +    </record>
> +
> +    <menuitem
> +        id="menu_cnab_importer"
> +        name="Importar Arquivo-Retorno"
> +        action="action_cnab_importer"
> +        parent="menu_cnab_root"
> +        sequence="1" />
> +    </data>
> +
> +</openerp>
>
> === added file 'l10n_br_cnab_base/wizard/parser.py'
> --- l10n_br_cnab_base/wizard/parser.py  1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_base/wizard/parser.py  2013-06-18 22:24:26 +0000
> @@ -0,0 +1,85 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +from datetime import datetime
> +import logging
> +import os
> +
> +TYPE_ADAPTERS = {
> +                 'INTEGER': int,
> +                 'DATE': lambda s: datetime.strptime(s, "%d%m%y").date(),
> +                 'CHARACTER': lambda s: s,
> +                }
> +
> +class CNABParser(object):
> +    def get_record_formats(self, parent):
> +        record_formats = dict((r.identifier, r) for r in
> parent.records_ids)
> +        for child_record in parent.records_ids:
> +            record_formats.update(self.get_record_formats(child_record))
> +        return record_formats
> +
> +    def consume_whitespace(self, cnab_file):
> +        while True:
> +            c = cnab_file.read(1)
> +            if c not in '\r\n':
> +                cnab_file.seek(-1, os.SEEK_CUR)
> +                return
> +            if c == '':
> +                return
> +
> +    def get_record_format(self, cnab_file, record_formats, idtype_length):
> +        idtype = cnab_file.read(idtype_length)
> +        cnab_file.seek(-idtype_length, os.SEEK_CUR)
> +        if idtype == '':
> +            return None
> +        record_format = record_formats[idtype]
> +        return record_format
> +
> +    def parse_file(self, format, cnab_file):
> +        record_formats = self.get_record_formats(format)
> +        idtype_length = len(format.records_ids[0].identifier)
> +        records = []
> +        while True:
> +            record_format = self.get_record_format(cnab_file,
> record_formats, idtype_length)
> +            if record_format is None:
> +                break
> +            records.append(self.parse_record(record_format, cnab_file))
> +            self.consume_whitespace(cnab_file)
> +        return records
> +
> +    def parse_record(self, format, cnab_file):
> +        record = {}
> +        for field in format.fields_ids:
> +            value = cnab_file.read(field.length).strip()
> +            if value == '':
> +                value = False
> +            if value and field.value_type:
> +                try:
> +                    adapter = TYPE_ADAPTERS[field.value_type]
> +                    value = adapter(value)
> +                except ValueError as e:
> +                    logging.warn('ValueError: %s, on field %s', repr(e),
> field.name)
> +                    raise e
> +            record[field.name] = value
> +        return record
>
> === added directory 'l10n_br_cnab_bradesco'
> === added file 'l10n_br_cnab_bradesco/__init__.py'
> --- l10n_br_cnab_bradesco/__init__.py   1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/__init__.py   2013-06-18 22:24:26 +0000
> @@ -0,0 +1,29 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import cnab_payer_info
> +import cnab_payee_info
> +import res_company
> +import res_partner
> +import wizard
>
> === added file 'l10n_br_cnab_bradesco/__openerp__.py'
> --- l10n_br_cnab_bradesco/__openerp__.py        1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/__openerp__.py        2013-06-18 22:24:26 +0000
> @@ -0,0 +1,54 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +{
> +    'name': 'CNAB for Bradesco',
> +    'version': '0.011',
> +    'category': 'CNAB',
> +    'sequence': 38,
> +    'complexity': 'normal',
> +    'description': '''== CNAB Bradesco Module ==
> +CNAB for Bradesco Bank!''',
> +    'author': 'ThinkOpen Solutions',
> +    'website': 'http://www.thinkopensolution.com',
> +    'images': ['images/oerp61.jpeg',],
> +    'depends': ['base',
> +                'l10n_br_base',
> +                'l10n_br_cnab_base',
> +                ],
> +    'init_xml': [],
> +    'update_xml': [#'cnab_bradesco_view.xml',
> +                   #'cnab_bradesco_workflow.xml',
> +                   'sequences.xml',
> +                   'res_company_view.xml',
> +                   'res_partner_view.xml',
> +                   'cnab_payer_info_view.xml',
> +                   'cnab_payee_info_view.xml',
> +                   ],
> +    'demo_xml': [#'cnab_bradesco_demo.xml',
> +                 ],
> +    'installable': True,
> +    'application': True,
> +    'certificate': '',
> +}
>
> === added file 'l10n_br_cnab_bradesco/cnab_payee_info.py'
> --- l10n_br_cnab_bradesco/cnab_payee_info.py    1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/cnab_payee_info.py    2013-06-18 22:24:26 +0000
> @@ -0,0 +1,64 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import time
> +import netsvc
> +from tools.translate import _
> +from osv import osv, fields
> +
> +class CNABPayeeInfo(osv.osv):
> +    _name = 'cnab.bradesco.payee_info'
> +
> +    _columns = {
> +                'codigo_empresa': fields.char('Código da Empresa',
> size=20, required=True),
> +                'codigo_carteira': fields.char('Código da Carteira',
> size=3, required=True),
> +                'codigo_agencia': fields.char('Código da Agência',
> size=5, required=True),
> +                'numero_conta': fields.char('Número', size=7,
> required=True),
> +                'digito_conta': fields.char('Dígito', size=1,
> required=True),
> +                'emissao_papeleta': fields.selection((('1', 'Emissão pelo
> Banco'),
> +                                                      ('2', 'Apenas
> processamento')),
> +                                                     'Emissão de papeleta
> de cobrança', required=True),
> +                'registro_debito_automatico': fields.selection((('N',
> 'Rejeitar na cobrança (não emitir papeleta)'),
> +                                                                ('S',
> 'Registrar na cobrança (emitir papeleta)')),
> +                                                               'Dados de
> débito incorretos', required=True),
> +                'rateio_credito': fields.boolean('Participar no Rateio de
> Crédito'),
> +                'aviso_debito_automatico': fields.selection((('2', 'Não
> emitir'),
> +                                                             ('1',
> 'Emitir para endereço no Arquivo-Rememessa'),
> +                                                             ('3',
> 'Emitir para endereço no cadastro do banco')),
> +                                                            'Automatic
> Debit Alert', required=True),
> +                'sequencia_registro': fields.integer('Sequencia de
> Arquivos-Remessa', required=True),
> +               }
> +
> +    _defaults = {
> +                 'codigo_empresa': '0',
> +                 'codigo_carteira': '0',
> +                 'codigo_agencia': '0',
> +                 'numero_conta': '0',
> +                 'digito_conta': '0',
> +                 'emissao_papeleta': '1',
> +                 'registro_debito_automatico': 'N',
> +                 'rateio_credito': True,
> +                 'aviso_debito_automatico': '1',
> +                 'sequencia_registro': 0,
> +                }
>
> === added file 'l10n_br_cnab_bradesco/cnab_payee_info_view.xml'
> --- l10n_br_cnab_bradesco/cnab_payee_info_view.xml      1970-01-01
> 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/cnab_payee_info_view.xml      2013-06-18
> 22:24:26 +0000
> @@ -0,0 +1,32 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data>
> +
> +        <record id="cnab_bradesco_payee_info_form" model="ir.ui.view">
> +            <field name="name">CNAB Bradesco Payee Info</field>
> +            <field name="view_type">form</field>
> +            <field name="model">cnab.bradesco.payee_info</field>
> +            <field name="arch" type="xml">
> +                <form string="Informação do Recebedor">
> +                    <group string="Códigos" colspan="2">
> +                        <field name="codigo_empresa"/>
> +                        <field name="codigo_carteira"/>
> +                        <field name="codigo_agencia"/>
> +                    </group>
> +                    <group string="Conta" colspan="2">
> +                        <field name="numero_conta"/>
> +                        <field name="digito_conta"/>
> +                    </group>
> +                    <group string="Débito Automático" colspan="2">
> +                        <field name="aviso_debito_automatico"/>
> +                        <field name="registro_debito_automatico"/>
> +                    </group>
> +                    <group string="Outros" colspan="2">
> +                        <field name="rateio_credito"/>
> +                    </group>
> +                </form>
> +            </field>
> +        </record>
> +
> +    </data>
> +</openerp>
>
> === added file 'l10n_br_cnab_bradesco/cnab_payer_info.py'
> --- l10n_br_cnab_bradesco/cnab_payer_info.py    1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/cnab_payer_info.py    2013-06-18 22:24:26 +0000
> @@ -0,0 +1,39 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import time
> +import netsvc
> +from tools.translate import _
> +from osv import osv, fields
> +
> +class CNABPayerInfo(osv.osv):
> +    _name = 'cnab.bradesco.payer_info'
> +
> +    _columns = {
> +                'codigo_agencia': fields.char('Código', size=5),
> +                'digito_agencia': fields.char('Dígito', size=1),
> +                'razao_conta': fields.char('Razão', size=5),
> +                'numero_conta': fields.char('Número', size=7),
> +                'digito_conta': fields.char('Dígito', size=1),
> +               }
>
> === added file 'l10n_br_cnab_bradesco/cnab_payer_info_view.xml'
> --- l10n_br_cnab_bradesco/cnab_payer_info_view.xml      1970-01-01
> 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/cnab_payer_info_view.xml      2013-06-18
> 22:24:26 +0000
> @@ -0,0 +1,25 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data>
> +
> +    <record id="cnab_bradesco_payer_info_form" model="ir.ui.view">
> +        <field name="name">CNAB Bradesco Payer Info</field>
> +        <field name="view_type">form</field>
> +        <field name="model">cnab.bradesco.payer_info</field>
> +        <field name="arch" type="xml">
> +            <form string="Informação do Pagador">
> +                <group string="Agência">
> +                    <field name="codigo_agencia"/>
> +                    <field name="digito_agencia"/>
> +                </group>
> +                <group string="Conta">
> +                    <field name="razao_conta"/>
> +                    <field name="numero_conta"/>
> +                    <field name="digito_conta"/>
> +                </group>
> +            </form>
> +        </field>
> +    </record>
> +
> +    </data>
> +</openerp>
>
> === added directory 'l10n_br_cnab_bradesco/data'
> === added directory 'l10n_br_cnab_bradesco/i18n'
> === added directory 'l10n_br_cnab_bradesco/images'
> === added file 'l10n_br_cnab_bradesco/images/oerp61.jpeg'
> Binary files l10n_br_cnab_bradesco/images/oerp61.jpeg   1970-01-01
> 00:00:00 +0000 and l10n_br_cnab_bradesco/images/oerp61.jpeg  2013-06-18
> 22:24:26 +0000 differ
> === added directory 'l10n_br_cnab_bradesco/report'
> === added file 'l10n_br_cnab_bradesco/res_company.py'
> --- l10n_br_cnab_bradesco/res_company.py        1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/res_company.py        2013-06-18 22:24:26 +0000
> @@ -0,0 +1,36 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import time
> +import netsvc
> +from tools.translate import _
> +from osv import osv, fields
> +
> +class Company(osv.osv):
> +    _name = 'res.company'
> +    _inherit = 'res.company'
> +
> +    _columns = {
> +                'cnab_info_id':
> fields.many2one('cnab.bradesco.payee_info', 'CNAB Info'),
> +                }
>
> === added file 'l10n_br_cnab_bradesco/res_company_view.xml'
> --- l10n_br_cnab_bradesco/res_company_view.xml  1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/res_company_view.xml  2013-06-18 22:24:26 +0000
> @@ -0,0 +1,18 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data>
> +
> +    <record id="cnab_bradesco_company_form" model="ir.ui.view">
> +        <field name="name">res.company</field>
> +        <field name="view_type">form</field>
> +        <field name="model">res.company</field>
> +        <field name="inherit_id" ref="base.view_company_form"/>
> +        <field name="arch" type="xml">
> +            <field name="currency_id" position="before">
> +                <field name="cnab_info_id"/>
> +            </field>
> +        </field>
> +    </record>
> +
> +    </data>
> +</openerp>
>
> === added file 'l10n_br_cnab_bradesco/res_partner.py'
> --- l10n_br_cnab_bradesco/res_partner.py        1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/res_partner.py        2013-06-18 22:24:26 +0000
> @@ -0,0 +1,36 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import time
> +import netsvc
> +from tools.translate import _
> +from osv import osv, fields
> +
> +class Partner(osv.osv):
> +    _name = 'res.partner'
> +    _inherit = 'res.partner'
> +
> +    _columns = {
> +                'cnab_info_id':
> fields.many2one('cnab.bradesco.payer_info', 'CNAB Payer Info'),
> +               }
>
> === added file 'l10n_br_cnab_bradesco/res_partner_view.xml'
> --- l10n_br_cnab_bradesco/res_partner_view.xml  1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/res_partner_view.xml  2013-06-18 22:24:26 +0000
> @@ -0,0 +1,18 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data>
> +
> +    <record id="cnab_bradesco_partner_form" model="ir.ui.view">
> +        <field name="name">res.partner</field>
> +        <field name="view_type">form</field>
> +        <field name="model">res.partner</field>
> +        <field name="inherit_id"
> ref="l10n_br_base.view_l10n_br_base_partner_form"/>
> +        <field name="arch" type="xml">
> +            <field name="user_id" position="before">
> +                <field name="cnab_info_id"/>
> +            </field>
> +        </field>
> +    </record>
> +
> +    </data>
> +</openerp>
>
> === added directory 'l10n_br_cnab_bradesco/security'
> === added file 'l10n_br_cnab_bradesco/sequences.xml'
> --- l10n_br_cnab_bradesco/sequences.xml 1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/sequences.xml 2013-06-18 22:24:26 +0000
> @@ -0,0 +1,14 @@
> +<?xml version="1.0" encoding="utf-8"?>
> +<openerp>
> +    <data noupdate="1">
> +
> +        
> +        <record id="bradesco_cnab_sequence" model="ir.sequence">
> +            <field name="name">cnab.bradesco.remessa.sequence</field>
> +            <field name="code">cnab.sequence</field>
> +            <field eval="1" name="number_next"/>
> +            <field eval="1" name="number_increment"/>
> +        </record>
> +
> +    </data>
> +</openerp>
>
> === added directory 'l10n_br_cnab_bradesco/wizard'
> === added file 'l10n_br_cnab_bradesco/wizard/__init__.py'
> --- l10n_br_cnab_bradesco/wizard/__init__.py    1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/wizard/__init__.py    2013-06-18 22:24:26 +0000
> @@ -0,0 +1,25 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import export_cnab
>
> === added file 'l10n_br_cnab_bradesco/wizard/export_cnab.py'
> --- l10n_br_cnab_bradesco/wizard/export_cnab.py 1970-01-01 00:00:00 +0000
> +++ l10n_br_cnab_bradesco/wizard/export_cnab.py 2013-06-18 22:24:26 +0000
> @@ -0,0 +1,166 @@
> +# -*- encoding: utf-8 -*-
>
> +##############################################################################
> +#
> +#    OpenERP, Open Source Management Solution
> +#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
> +#
> +#    Thinkopen - Portugal & Brasil
> +#    Copyright (C) Thinkopen Solutions (<
> http://www.thinkopensolutions.com>).
> +#
> +#    This program is free software: you can redistribute it and/or modify
> +#    it under the terms of the GNU Affero General Public License as
> +#    published by the Free Software Foundation, either version 3 of the
> +#    License, or (at your option) any later version.
> +#
> +#    This program is distributed in the hope that it will be useful,
> +#    but WITHOUT ANY WARRANTY; without even the implied warranty of
> +#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
> +#    GNU Affero General Public License for more details.
> +#
> +#    You should have received a copy of the GNU Affero General Public
> License
> +#    along with this program.  If not, see <http://www.gnu.org/licenses/
> >.
> +#
>
> +##############################################################################
> +
> +import time
> +import netsvc
> +from tools.translate import _
> +from osv import osv, fields
> +
> +from datetime import datetime, date
> +from decimal import Decimal, Context, Inexact
> +from itertools import count
> +import logging
> +import base64
> +import re
> +
> +def counter(start=0):
> +    try:
> +        return count(start=start)
> +    except TypeError:
> +        c = count()
> +        c.next()
> +        return c
> +
> +if hasattr(Decimal, 'from_float'):
> +    float_to_decimal = Decimal.from_float
> +else:
> +    def float_to_decimal(f):
> +        "Convert a floating point number to a Decimal with no loss of
> information"
> +        n, d = f.as_integer_ratio()
> +        numerator, denominator = Decimal(n), Decimal(d)
> +        ctx = Context(prec=60)
> +        result = ctx.divide(numerator, denominator)
> +        while ctx.flags[Inexact]:
> +            ctx.flags[Inexact] = False
> +            ctx.prec *= 2
> +            result = ctx.divide(numerator, denominator)
> +        return result
> +
> +
> +class CNABExporter(osv.osv_memory):
> +    _name = 'cnab.wizard.exporter'
> +    _inherit = 'cnab.wizard.exporter'
> +
> +    def _round(self, v):
> +        v = float_to_decimal(v)
> +        return (v * Decimal('100')).quantize(1)
> +
> +    def _only_digits(self, v):
> +        return re.sub('[^0-9]', '', v)
> +
> +    def _get_address(self, partner):
> +        parts = []
> +        if partner.street:
> +            parts.append(partner.street)
> +        if partner.street2:
> +            parts.append(partner.street2)
> +        return ",".join(parts)
> +
> +    def _header(self, cr, user):
> +        cnab_info = user.company_id.cnab_info_id
> +        assert cnab_info != False, "Company must have CNAB information"
> +        return {
> +                'IDReg': '0',
> +                'CodigoEmpresa': cnab_info.codigo_empresa,
> +                'NomeEmpresa': user.company_id.name,
> +                'DataGravacaoArquivo': date.today(),
> +                'NroSequencialArquivo':
> self.pool.get('ir.sequence').get(cr, user.id,
> 'cnab.bradesco.remessa.sequence'),
> +               }
> +
> +    def _invoice(self, user, invoice):
> +        partner_cnab_info = invoice.partner_id.cnab_info_id
> +        assert partner_cnab_info != False, "Partner must have CNAB
> information"
> +        company_cnab_info = user.company_id.cnab_info_id
> +        assert company_cnab_info != False, "Company must have CNAB
> information"
> +        rateio_credito = ("R" if company_cnab_info.rateio_credito else "
> ")
> +        identificacao_inscricao_sacado = ('01' if not
> invoice.partner_id.is_company else '02')
> +        return [{
> +                'IDReg': '1',
> +                'AgenciaDebito': partner_cnab_info.codigo_agencia,
> +                'DigitoAgenciaDebito': partner_cnab_info.digito_agencia,
> +                'RazaoContaCorrenteDebito': partner_cnab_info.razao_conta,
> +                'ContaCorrenteDebito': partner_cnab_info.numero_conta,
> +                'DigitoContaCorrenteDebito':
> partner_cnab_info.digito_conta,
> +                'Carteira': company_cnab_info.codigo_carteira,
> +                'AgenciaCedente': company_cnab_info.codigo_agencia,
> +                'ContaCorrente': company_cnab_info.numero_conta,
> +                'DigitoContaCorrente': company_cnab_info.digito_conta,
> +                'NroControleParticipante': invoice.id,
> +                'Multa': 0, #FIXME
> +                'PercentagemMulta': 0, #FIXME
> +                'NossoNumero': 0, #FIXME
> +                'EmissaoPapeletaCobranca':
> company_cnab_info.emissao_papeleta,
> +                'EmissaoPapeletaDebitoAutomatico':
> company_cnab_info.registro_debito_automatico,
> +                'IndicadorRateioCredito': rateio_credito,
> +                'AvisoDebitoAutomatico':
> company_cnab_info.aviso_debito_automatico,
> +                'NDocumento': invoice.number,
> +                'DataVencimentoTitulo':
> datetime.strptime(invoice.date_due, '%Y-%m-%d'),
> +                'ValorTitulo': self._round(invoice.amount_total),
> +                'EspecieTitulo': 1, #FIXME
> +                'Identificacao': 'N', #FIXME
> +                'DataEmissaoTitulo': date.today(),
> +                '1Instrucao': 0, #FIXME
> +                '2Instrucao': 0, #FIXME
> +                'MoraDiaria': 0, #FIXME
> +                'DataLimiteDesconto': date(2013, 05, 15), #FIXME
> +                'ValorDesconto': 0, #FIXME
> +                'ValorAbatimento': 0, #FIXME
> +                'IdentificacaoInscricaoSacado':
> identificacao_inscricao_sacado,
> +                'NInscricaoSacado':
> self._only_digits(invoice.partner_id.cnpj_cpf),
> +                'NomeSacado': invoice.partner_id.name,
> +                'EnderecoCompleto': self._get_address(invoice.partner_id),
> +                '1Mensagem': invoice.comment,
> +                'Cep': invoice.partner_id.zip,
> +                'Avalista-2Mensagem': ' ', #FIXME
> +               }, {
> +                'IDReg': '2',
> +                'Mensagem1': ' ', #FIXME
> +                'Mensagem2': ' ', #FIXME
> +                'Mensagem3': ' ', #FIXME
> +                'Mensagem4': ' ', #FIXME
> +                'Filler': ' ', #?
> +                'Carteira': company_cnab_info.codigo_carteira,
> +                'Agencia': company_cnab_info.codigo_agencia,
> +                'ContaCorrente': company_cnab_info.numero_conta,
> +                'DigitoCC': company_cnab_info.digito_conta,
> +                'NossoNumero': 0, #FIXME
> +               }]
> +
> +    def _trailer(self):
> +        return {'IDReg': '9'}
> +
> +    def prepare_data(self, cr, uid, format, bank, invoice_ids):
> +        invoice_pool = self.pool.get('account.invoice')
> +        [user] = self.pool.get('res.users').browse(cr, uid, [uid])
> +
> +        lines = [self._header(cr, user)]
> +        for invoice in invoice_pool.browse(cr, uid, invoice_ids):
> +            lines.extend(self._invoice(user, invoice))
> +        lines.append(self._trailer())
> +
> +        #add sequence numbers
> +        for i, line in zip(counter(start=1), lines):
> +            line['NroSequencialRegistro'] = i
> +
> +        return lines
>
>
> ...
>
> [Mensagem cortada]

-- 
Luis Felipe Miléo
skype: luisfelipemileo
http://mileo.co <http://blog.mileo.co>
https://launchpad.net/~mileo
https://github.com/mileo

Revision history for this message

Renato Lima - http://www.akretion.com (renatonlima) wrote on 2013-07-01:

Olá Carlos,

Excelente iniciativa, eu vou analisar o pedido de merge, tenho algumas sugestões, eu analisar melhor e em breve faço minhas considerações.

Obrigado pela contribuição!

Revision history for this message

Carlos Almeida (cmsa) wrote on 2013-08-17:

Quando prevêm a inclusão destes módulos no merge principal?
Algum comentário sobre eles? sugestões?

Unmerged revisions

547. By Carlos Almeida on 2013-06-18: ### JÁ TEMOS CNAB! ####
Adicionei dois módulos:
- l10n_cnan_base e
- l10n_cnab_bradesco
Que fazem a exportação e importação de ficheiros CNAB400. Para já só do Bradesco.
O módulo base deve ter o código comum a todos os bancos, como só fiz para o Bradesco pode ser que haja código a mudar do módulo l10n_cnab_bradesco para o base ao implementar outros bancos.
PARA INSTALAR E CONFIGURAR:
1. Contabilidade-->File Format Loader
2. Aí carreguem o formato de remessa e retorno, seleccionando o tipo deles, remessa ou retorno
NOTA: Os ficheiros XML com a estrutura estão na pasta l10n_cnab_base/data
3. Por fim, configurar o Banco. Na comfiguração da empresa, adicionem nova conta e no campo Banco 'Criar e Editar...' tem uma secção CNAB, aí seleccionem o booleano CNAB e coloquem o nome e código, no caso do Bradesco é BRADESCO 137.
PRÓXIMOS DESENVOLVIMENTOS:
1. Desenvolver para outros bancos, pois só deve funcionar com o Bradesco.
546. By Carlos Almeida on 2013-06-18: erro por mudança de nome
545. By Carlos Almeida on 2013-06-18: alterações nas vistas
limpeza de arquivos a mais
544. By Carlos Almeida on 2013-06-18: adicionei módulos l10n_br_cnab_base e l10n_br_cnab_bradesco