Merge lp:~akretion-team/openerp-french-localization/account-balance-ebp-csv-export-70 into lp:openerp-french-localization/7.0

[Alexis de Lattre]

Add module account_balance_ebp_csv_export

This module has been successully used by Akretion France (and 2 other companies) to transfer the end-of-fiscal-year balance to Teledec.fr in order to establish and tele-transmit the Liasse fiscale ! So, with this module, we can do a Liasse fiscale with OpenERP (and a Liasse fiscale software) in a fully automated way.

[Christophe CHAUVET (christophe-chauvet)]

Hi Alexis

Are you sure report_aeroo depends is necessary in this module ?

Regards

Christophe.

[Alexis de Lattre (alexis-via)]

I would prefer not to depend on report_aeroo... but I have quite a lot of experience of aeroo, that's why I developped it with aeroo.

Which alternative would you suggest to generate the CSV ? Use a reporting engine or not ?

[Christophe CHAUVET (christophe-chauvet)]

Ok, aeroo is used to generate the CSV file

Why not simply use Mako or Jinja2 to generate CSV file ?

Regards,

[David BEAL (ak) (davidbeal)]

Personnaly I don't have aeroo install on my PC

I really prefer small dependency like Mako or Jinja2 than aeroo

my 2 cents

[Alexis de Lattre (alexis-via)]

By the way, I will probably not have the time to update the module in order to remove the dependency on report_aeroo. So, if some of you is ready to do the work, you will be more than welcomed !

[Raphaël Valyi - http://www.akretion.com (rvalyi)]

line 326: the "or" doesn't feel right. Are you sure about that?

[Sébastien BEAU - http://www.akretion.com (sebastien.beau)]

This PR is now here : https://github.com/OCA/l10n-france/pull/19

review: Disapprove

Unmerged revisions

2. By Alexis de Lattre on 2014-10-06

Better module description
Update name of XMLID

1. By Alexis de Lattre on 2014-09-26

Add module account_balance_ebp_csv_export.

=== added directory 'account_balance_ebp_csv_export'
=== added file 'account_balance_ebp_csv_export/__init__.py'
--- account_balance_ebp_csv_export/__init__.py	1970-01-01 00:00:00 +0000
+++ account_balance_ebp_csv_export/__init__.py	2014-10-06 19:37:40 +0000
@@ -0,0 +1,24 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    Account Balance EBP CSV export module for OpenERP
+#    Copyright (C) 2014 Akretion (http://www.akretion.com)
+#    @author Alexis de Lattre <[e-mail]>
+#
+#    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 . import report
+from . import wizard

=== added file 'account_balance_ebp_csv_export/__openerp__.py'
--- account_balance_ebp_csv_export/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_balance_ebp_csv_export/__openerp__.py	2014-10-06 19:37:40 +0000
@@ -0,0 +1,45 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    Account Balance EBP CSV export module for OpenERP
+#    Copyright (C) 2014 Akretion (http://www.akretion.com)
+#    @author Alexis de Lattre <[e-mail]>
+#
+#    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': 'Account Balance EBP CSV export',
+    'version': '0.1',
+    'category': 'Accounting & Finance',
+    'license': 'AGPL-3',
+    'description': """
+Account Balance EBP CSV export
+==============================
+
+This module adds a button *EBP csv File* next to the *Print* button on the Trial Balance wizard. The aim is to export the trial balance to software dedicated to the *Liasse fiscale* (French fiscal declaration) that accept CSV files from the popular EBP accounting software. This file has been tested with Teledec (https://www.teledec.fr/), which is a SaaS solution for the *Liasse fiscale* with support for EDI transmission.
+
+This module has been developped by Alexis de Lattre from Akretion <[e-mail]>.
+    """,
+    'author': 'Akretion',
+    'website': 'http://www.akretion.com',
+    'depends': ['report_aeroo', 'account_financial_report_webkit'],
+    'data': [
+        'report/report.xml',
+        'wizard/trial_balance_wizard_view.xml'
+    ],
+    'installable': True,
+}

=== added directory 'account_balance_ebp_csv_export/report'
=== added file 'account_balance_ebp_csv_export/report/__init__.py'
--- account_balance_ebp_csv_export/report/__init__.py	1970-01-01 00:00:00 +0000
+++ account_balance_ebp_csv_export/report/__init__.py	2014-10-06 19:37:40 +0000
@@ -0,0 +1,23 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    Account Trial Balance CSV module for OpenERP
+#    Copyright (C) 2014 Akretion (http://www.akretion.com)
+#    @author Alexis de Lattre <[e-mail]>
+#
+#    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 . import trial_balance_ebp_csv

=== added file 'account_balance_ebp_csv_export/report/report.xml'
--- account_balance_ebp_csv_export/report/report.xml	1970-01-01 00:00:00 +0000
+++ account_balance_ebp_csv_export/report/report.xml	2014-10-06 19:37:40 +0000
@@ -0,0 +1,35 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!--
+    Copyright (C) 2014 Akretion (http://www.akretion.com/)
+    @author: Alexis de Lattre <[e-mail]>
+    The licence is in the file __openerp__.py
+-->
+
+<openerp>
+<data>
+
+<record id="account_report_trial_balance_ebp_csv" model="ir.actions.report.xml">
+    <field name="name">Trial Balance EBP CSV</field>
+    <field name="report_name">account.report.trial.balance.ebp.csv</field>
+    <field name="report_type">aeroo</field>
+    <field name="in_format">genshi-raw</field>
+    <field name="out_format" ref="report_aeroo.report_mimetypes_raw"/>
+    <field name="charset">utf_8</field>
+    <field name="fallback_false" eval="0"/>
+    <field name="process_sep" eval="0"/>
+    <field name="attachment_use" eval="0"/>
+    <field name="styles_mode">default</field>
+    <field name="rml" eval="0"/>
+    <field name="parser_state">loc</field>
+    <field name="parser_loc">account_balance_ebp_csv_export/report/trial_balance_ebp_csv.py</field>
+    <field name="groups_id" eval="[(6,0,[])]"/>
+    <field name="multi" eval="0"/>
+    <field name="auto" eval="0"/>
+    <field name="header" eval="0"/>
+    <field name="model">account.account</field>
+    <field name="report_rml">account_balance_ebp_csv_export/report/trial_balance_ebp_csv.csv</field>
+</record>
+
+</data>
+</openerp>

=== added file 'account_balance_ebp_csv_export/report/trial_balance_ebp_csv.csv'
--- account_balance_ebp_csv_export/report/trial_balance_ebp_csv.csv	1970-01-01 00:00:00 +0000
+++ account_balance_ebp_csv_export/report/trial_balance_ebp_csv.csv	2014-10-06 19:37:40 +0000
@@ -0,0 +1,11 @@
+"Compte.Numero","Compte.Intitule","Balance.SldCptNDebit","Balance.SldCptNCredit","Balance.SldCptNSoldeD","Balance.SldCptNSoldeC"
+{% for current_account in objects %}\
+{% if current_account.to_display and current_account.type != 'view' %}\
+\
+"${current_account.code}",\
+"${current_account.name}",\
+${'%.2f' % current_account.debit},\
+${'%.2f' % current_account.credit},\
+${(current_account.credit - current_account.debit) >= 0 and ('0.00,%.2f' % (current_account.credit - current_account.debit)) or ('%.2f,0.00' % (current_account.debit - current_account.credit))}
+{% end %}\
+{% end %}

=== added file 'account_balance_ebp_csv_export/report/trial_balance_ebp_csv.py'
--- account_balance_ebp_csv_export/report/trial_balance_ebp_csv.py	1970-01-01 00:00:00 +0000
+++ account_balance_ebp_csv_export/report/trial_balance_ebp_csv.py	2014-10-06 19:37:40 +0000
@@ -0,0 +1,64 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    Author: Guewen Baconnier
+#    Copyright Camptocamp SA 2011
+#
+#    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 openerp.report import report_sxw
+from openerp.tools.translate import _
+import pooler
+from datetime import datetime
+
+from account_financial_report_webkit.report.common_balance_reports\
+    import CommonBalanceReportHeaderWebkit
+
+
+def sign(number):
+    return cmp(number, 0)
+
+
+class Parser(report_sxw.rml_parse, CommonBalanceReportHeaderWebkit):
+
+    def __init__(self, cursor, uid, name, context):
+        super(Parser, self).__init__(cursor, uid, name, context=context)
+        self.pool = pooler.get_pool(self.cr.dbname)
+        self.cursor = self.cr
+
+        self.localcontext.update({
+            'cr': cursor,
+            'uid': uid,
+            'report_name': _('Trial Balance'),
+            'display_account': self._get_display_account,
+            'display_account_raw': self._get_display_account_raw,
+            'filter_form': self._get_filter,
+            'target_move': self._get_target_move,
+            'display_target_move': self._get_display_target_move,
+            'accounts': self._get_accounts_br,
+            'date_time':
+            self.formatLang(str(datetime.today()), date_time=True),
+        })
+
+    def set_context(self, objects, data, ids, report_type=None):
+        """Populate a ledger_lines attribute on each browse record that """
+        """will be used by mako template"""
+        objects, new_ids, context_report_values = self.compute_balance_data(
+            data)
+        self.localcontext.update(context_report_values)
+        return super(Parser, self).set_context(
+            objects, data, new_ids, report_type=report_type)

=== added directory 'account_balance_ebp_csv_export/wizard'
=== added file 'account_balance_ebp_csv_export/wizard/__init__.py'
--- account_balance_ebp_csv_export/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ account_balance_ebp_csv_export/wizard/__init__.py	2014-10-06 19:37:40 +0000
@@ -0,0 +1,23 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    Account Balance EBP CSV export module for OpenERP
+#    Copyright (C) 2014 Akretion (http://www.akretion.com)
+#    @author Alexis de Lattre <[e-mail]>
+#
+#    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 . import trial_balance_wizard

=== added file 'account_balance_ebp_csv_export/wizard/trial_balance_wizard.py'
--- account_balance_ebp_csv_export/wizard/trial_balance_wizard.py	1970-01-01 00:00:00 +0000
+++ account_balance_ebp_csv_export/wizard/trial_balance_wizard.py	2014-10-06 19:37:40 +0000
@@ -0,0 +1,36 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    Account Balance EBP CSV export module for OpenERP
+#    Copyright (C) 2014 Akretion (http://www.akretion.com)
+#    @author Alexis de Lattre <[e-mail]>
+#
+#    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 openerp.osv import orm
+
+
+class AccountTrialBalanceWizard(orm.TransientModel):
+    _inherit = "trial.balance.webkit"
+
+    def _print_report(self, cursor, uid, ids, data, context=None):
+        if context is None:
+            context = {}
+        res = super(AccountTrialBalanceWizard, self)._print_report(
+            cursor, uid, ids, data, context=context)
+        if context.get('export_type') == 'ebp-csv':
+            res['report_name'] = 'account.report.trial.balance.ebp.csv'
+        return res

=== added file 'account_balance_ebp_csv_export/wizard/trial_balance_wizard_view.xml'
--- account_balance_ebp_csv_export/wizard/trial_balance_wizard_view.xml	1970-01-01 00:00:00 +0000
+++ account_balance_ebp_csv_export/wizard/trial_balance_wizard_view.xml	2014-10-06 19:37:40 +0000
@@ -0,0 +1,27 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!--
+    Copyright (C) 2014 Akretion (http://www.akretion.com/)
+    @author: Alexis de Lattre <[e-mail]>
+    The licence is in the file __openerp__.py
+-->
+
+<openerp>
+<data>
+
+<record id="account_trial_balance_view_webkit" model="ir.ui.view">
+    <field name="name">trial.balance.ebp.csv.export</field>
+    <field name="model">trial.balance.webkit</field>
+    <field name="inherit_id" ref="account_financial_report_webkit.account_trial_balance_view_webkit" />
+    <field name="arch" type="xml">
+        <button name="check_report" position="after">
+            or 
+            <button name="check_report"
+                string="EBP csv File" type="object"
+                context="{'export_type': 'ebp-csv'}"/>
+        </button>
+    </field>
+</record>
+
+</data>
+</openerp>