=== modified file 'account_financial_report/wizard/wizard.py' --- account_financial_report/wizard/wizard.py 2013-07-26 17:03:11 +0000 +++ account_financial_report/wizard/wizard.py 2013-10-23 14:40:32 +0000 @@ -284,7 +284,6 @@ name = 'afr.qtrcols' if data['form']['columns'] == 'thirteen': name = 'afr.13cols' - return {'type': 'ir.actions.report.xml', 'report_name': name, 'datas': data} wizard_report() === added directory 'account_financial_report_exportable' === added file 'account_financial_report_exportable/__init__.py' --- account_financial_report_exportable/__init__.py 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/__init__.py 2013-10-23 14:40:32 +0000 @@ -0,0 +1,26 @@ +#!/usr/bin/python +# -*- encoding: utf-8 -*- +############################################################################### +# Module Writen to OpenERP, Open Source Management Solution +# Copyright (C) OpenERP Venezuela (). +# All Rights Reserved +############# Credits ######################################################### +# Coded by: Yanina Aular +# Planified by: Humberto Arocha +# Audited by: Humberto Arocha +############################################################################### +# 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 . +############################################################################### +import model +import wizard === added file 'account_financial_report_exportable/__openerp__.py' --- account_financial_report_exportable/__openerp__.py 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/__openerp__.py 2013-10-23 14:40:32 +0000 @@ -0,0 +1,55 @@ +#!/usr/bin/python +# -*- encoding: utf-8 -*- +############################################################################### +# Module Writen to OpenERP, Open Source Management Solution +# Copyright (C) OpenERP Venezuela (). +# All Rights Reserved +############# Credits ######################################################### +# Coded by: Yanina Aular +# Planified by: Humberto Arocha +# Audited by: Humberto Arocha +############################################################################### +# 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 . +############################################################################### + +{ + 'name': 'Account Financial Report Exportable', + 'version': '1.0', + 'author': 'Vauxoo', + 'website': 'http://www.vauxoo.com/', + 'category': 'Accounting', + 'description': ''' +Account Financial Report Exportable +=================================== + +Account Financial Report Reports on Webkit + +Main Features +============= + +account_financial_report module reports are now printed using webkit. + + +''', + 'depends': ['base', 'mail', 'account_accountant', 'account_financial_report', 'report_webkit'], + 'data': [ + 'data/html_css_afr.xml', + 'report/report_afr.xml', + 'view/account_financial_report_view.xml' + ], + 'demo': [], + 'test': [], + 'active': False, + 'installable': True, +} === added directory 'account_financial_report_exportable/data' === added file 'account_financial_report_exportable/data/html_css_afr.xml' --- account_financial_report_exportable/data/html_css_afr.xml 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/data/html_css_afr.xml 2013-10-23 14:40:32 +0000 @@ -0,0 +1,1372 @@ + + + + + Reports AFR WebKit + + + + + + + + + + + + +
+ + Page of
+ +]]>
+ Landscape + Letter + + + + + + + + + ${_debug or ''|n} + +]]> + + + + + +
+ + + Reports AFR WebKit + + + + + + + + + + + + +
+ + Page of
+ +]]>
+ Landscape + Letter + + + + + + + + + ${_debug or ''|n} + +]]> + + + + + +
+ + + Reports AFR WebKit + + + + + + + + + + + + +
+ + Page of
+ +]]>
+ Landscape + Letter + + + + + + + + + ${_debug or ''|n} + +]]> + + + + + +
+ + + Reports AFR WebKit + + + + + + + + + + + + +
+ + Page of
+ +]]>
+ Landscape + Letter + + + + + + + + + ${_debug or ''|n} + +]]> + + + + + +
+ + + + Reports AFR WebKit + + + + + + + + + + + + +
+ + Page of
+ +]]>
+ Portrait + Letter + + + + + + + + + ${_debug or ''|n} + +]]> + + + + + +
+ + + Reports AFR WebKit + + + + + + + + + + + + +
+ + Page of
+ +]]>
+ Portrait + Letter + + + + + + + + + ${_debug or ''|n} + +]]> + + + + + +
+ + + Reports AFR WebKit + + + + + + + + + + + + +
+ + Page of
+ +]]>
+ Portrait + Letter + + + + + + + + + ${_debug or ''|n} + +]]> + + + + + +
+ + + Reports AFR WebKit Five Columns + + + + + + + + + + + + +
+ + Page of
+ +]]>
+ Portrait + Letter + + + + + + + + + ${_debug or ''|n} + +]]> + + + + + +
+ + + + + + +
+
=== added directory 'account_financial_report_exportable/demo' === added directory 'account_financial_report_exportable/doc' === added directory 'account_financial_report_exportable/doc/images' === added directory 'account_financial_report_exportable/i18n' === added file 'account_financial_report_exportable/i18n/es.po' --- account_financial_report_exportable/i18n/es.po 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/i18n/es.po 2013-10-23 14:40:32 +0000 @@ -0,0 +1,57 @@ +# Translation of OpenERP Server. +# This file contains the translation of the following modules: +# * account_financial_report_exportable +# +msgid "" +msgstr "" +"Project-Id-Version: OpenERP Server 7.0\n" +"Report-Msgid-Bugs-To: \n" +"POT-Creation-Date: 2013-10-21 19:57+0000\n" +"PO-Revision-Date: 2013-10-21 14:58-0600\n" +"Last-Translator: <>\n" +"Language-Team: \n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=UTF-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Plural-Forms: \n" + +#. module: account_financial_report_exportable +#: model:ir.model,name:account_financial_report_exportable.model_wizard_report +msgid "wizard.report" +msgstr "wizard.report" + +#. module: account_financial_report_exportable +#: selection:wizard.report,report_format:0 +msgid "PDF" +msgstr "PDF" + +#. module: account_financial_report_exportable +#: field:wizard.report,report_format:0 +msgid "Report Format" +msgstr "Formato del Reporte" + +#. module: account_financial_report_exportable +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1 +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13 +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2 +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4 +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5 +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr_html +msgid "Print AFR" +msgstr "Imprimir AFR" + +#. module: account_financial_report_exportable +#: selection:wizard.report,report_format:0 +msgid "Spreadsheet" +msgstr "Hoja de Calculo" + === added file 'account_financial_report_exportable/i18n/es_MX.po' --- account_financial_report_exportable/i18n/es_MX.po 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/i18n/es_MX.po 2013-10-23 14:40:32 +0000 @@ -0,0 +1,57 @@ +# Translation of OpenERP Server. +# This file contains the translation of the following modules: +# * account_financial_report_exportable +# +msgid "" +msgstr "" +"Project-Id-Version: OpenERP Server 7.0\n" +"Report-Msgid-Bugs-To: \n" +"POT-Creation-Date: 2013-10-21 19:57+0000\n" +"PO-Revision-Date: 2013-10-21 14:58-0600\n" +"Last-Translator: <>\n" +"Language-Team: \n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=UTF-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Plural-Forms: \n" + +#. module: account_financial_report_exportable +#: model:ir.model,name:account_financial_report_exportable.model_wizard_report +msgid "wizard.report" +msgstr "wizard.report" + +#. module: account_financial_report_exportable +#: selection:wizard.report,report_format:0 +msgid "PDF" +msgstr "PDF" + +#. module: account_financial_report_exportable +#: field:wizard.report,report_format:0 +msgid "Report Format" +msgstr "Formato del Reporte" + +#. module: account_financial_report_exportable +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1 +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13 +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2 +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4 +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5 +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger_html +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr +#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr_html +msgid "Print AFR" +msgstr "Imprimir AFR" + +#. module: account_financial_report_exportable +#: selection:wizard.report,report_format:0 +msgid "Spreadsheet" +msgstr "Hoja de Calculo" + === added directory 'account_financial_report_exportable/model' === added file 'account_financial_report_exportable/model/__init__.py' --- account_financial_report_exportable/model/__init__.py 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/model/__init__.py 2013-10-23 14:40:32 +0000 @@ -0,0 +1,25 @@ +#!/usr/bin/python +# -*- encoding: utf-8 -*- +############################################################################### +# Module Writen to OpenERP, Open Source Management Solution +# Copyright (C) OpenERP Venezuela (). +# All Rights Reserved +############# Credits ######################################################### +# Coded by: Yanina Aular +# Planified by: Humberto Arocha +# Audited by: Humberto Arocha +############################################################################### +# 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 . +############################################################################### + === added directory 'account_financial_report_exportable/report' === added file 'account_financial_report_exportable/report/__init__.py' --- account_financial_report_exportable/report/__init__.py 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/report/__init__.py 2013-10-23 14:40:32 +0000 @@ -0,0 +1,25 @@ +#!/usr/bin/python +# -*- encoding: utf-8 -*- +############################################################################### +# Module Writen to OpenERP, Open Source Management Solution +# Copyright (C) OpenERP Venezuela (). +# All Rights Reserved +############# Credits ######################################################### +# Coded by: Yanina Aular +# Planified by: Humberto Arocha +# Audited by: Humberto Arocha +############################################################################### +# 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 . +############################################################################### + === added file 'account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako' --- account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako 2013-10-23 14:40:32 +0000 @@ -0,0 +1,103 @@ + + + + + + + +%for obj in objects: + + + + + +
+
${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}
+
+ + + + + + +
${obj.company_id.name or ''|entity}
${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}
${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}
${_(Expressed in data['form'] and (' %s'% obj.get_parser_method('exchange_name',data['form'])) or '')}
${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}
+
+ + + + + + + +
${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}
+ + + + + + + + + + + +
${_('CODE')}${_('ACCOUNT')}${_('INICIAL')}${_('DEBIT')}${_('CREDIT')}${_('BALANCE')}
+ + + + + + + + + + + +
${_('DATE')}${_('PERIOD')}${_('REFERENCE')}${_('JOURNAL ENTRY')}${_('PARTNER')}
+ + + + + + + + + + + + + + %for line in obj.get_parser_method('lines',data['form']): + %if line['type']!= 'view': + + + + + + + + + + + %for m in line['mayor']: + + + + + + + + + + + %endfor + %endif + %endfor +
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['balanceinit'] and line['balanceinit'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['debit'], digits=2, grouping=True) or ''}${formatLang(line['credit'], digits=2, grouping=True) or ''}${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}
${formatLang( m['date'], date=True) or ''}${m['period'] or ''}${m['name'] or ''} ${m['ref'] and (' - Ref %s'%m['ref']) or ''}${m['entry'] or ''}${m['partner'] or ''}
+ +%endfor + + === added file 'account_financial_report_exportable/report/afr_report_webkit_cols1.mako' --- account_financial_report_exportable/report/afr_report_webkit_cols1.mako 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/report/afr_report_webkit_cols1.mako 2013-10-23 14:40:32 +0000 @@ -0,0 +1,71 @@ + + + + + + + + %for obj in objects: + + + + + + +
+
${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}
+
+ + + + + + +
${obj.company_id.name or ''|entity}
${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}
${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}
${_(Expressed in data['form'] and (' %s'% obj.get_parser_method('exchange_name',data['form'])) or '')}
${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}
+
+
+ + + + + + +
${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}
+ + + + + +
+
+ + + %for line in obj.get_parser_method('lines',data['form']): + %if line['type'] != 'view': + + + + + + %elif line['total'] and not line['label']: + + + + + + %else: + + + + + + %endif + %endfor + +
${_('CODE')}${_('ACCOUNT')}${_('BALANCE')}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}
${(line['label'] == True ) and line['code'] or ''}${(line['type'] == 'view') and line['name'].upper() or line['name'].title() or ''}${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}
${(line['label'] == True ) and line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}
+ %endfor + + === added file 'account_financial_report_exportable/report/afr_report_webkit_cols13.mako' --- account_financial_report_exportable/report/afr_report_webkit_cols13.mako 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/report/afr_report_webkit_cols13.mako 2013-10-23 14:40:32 +0000 @@ -0,0 +1,102 @@ + + + + + + + + + %for obj in objects: + + + + + +
+
${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}
+
+ + + + + +
${obj.company_id.name or ''|entity}
${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}
${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}
${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}
+
+ + + + + + + + + + + + + + + + + + + + + + + + + %for line in obj.get_parser_method('lines',data['form']): + %if line['type'] != 'view': + + + + + + + + + + + + + + + + + + %elif line['total'] and not line['label']: + + + + + + + + + + + + + + + + + + %else: + + + + + %endif + %endfor + +
${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}
${_('CODE')}${_('ACCOUNT')}${_('01')}${_('02')}${_('03')}${_('04')}${_('05')}${_('06')}${_('07')}${_('08')}${_('09')}${_('10')}${_('11')}${_('12')}${_('YTD')}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['bal1'] and line['bal1'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal6'] and line['bal6'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal7'] and line['bal7'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal8'] and line['bal8'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal9'] and line['bal9'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal10'] and line['bal10'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal11'] and line['bal11'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal12'] and line['bal12'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal13'] and line['bal13'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['bal1'] and line['bal1'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal6'] and line['bal6'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal7'] and line['bal7'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal8'] and line['bal8'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal9'] and line['bal9'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal10'] and line['bal10'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal11'] and line['bal11'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal12'] and line['bal12'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal13'] and line['bal13'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}
+%endfor + + === added file 'account_financial_report_exportable/report/afr_report_webkit_cols2.mako' --- account_financial_report_exportable/report/afr_report_webkit_cols2.mako 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/report/afr_report_webkit_cols2.mako 2013-10-23 14:40:32 +0000 @@ -0,0 +1,80 @@ + + + + + + + + + + %for obj in objects: + + + + + + +
+
${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}
+
+ + + + + + +
${obj.company_id.name or ''|entity}
${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}
${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}
${_(Expressed in data['form'] and (' %s'% obj.get_parser_method('exchange_name',data['form'])) or '')}
${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}
+
+
+ + + + + + +
${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}
+ + + + + +
+
+ + + + %for line in obj.get_parser_method('lines',data['form']): + + %if line['type'] != 'view': + + + + + + + %elif line['total'] and not line['label']: + + + + + + + %else: + + + + + + + %endif + %endfor + +
${_('CODE')}${_('ACCOUNT')}${_('DEBIT')}${_('CREDIT')}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['debit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}${formatLang(line['credit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['debit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}${formatLang(line['credit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}
${(line['label'] == True ) and line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['debit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}${formatLang(line['credit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}
+ %endfor + + === added file 'account_financial_report_exportable/report/afr_report_webkit_cols4.mako' --- account_financial_report_exportable/report/afr_report_webkit_cols4.mako 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/report/afr_report_webkit_cols4.mako 2013-10-23 14:40:32 +0000 @@ -0,0 +1,86 @@ + + + + + + + + + + + %for obj in objects: + + + + + + +
+
${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}
+
+ + + + + +
${obj.company_id.name or ''|entity}
${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}
${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}
${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}
+
+
+ + + + + + +
${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}
+ + + + + + + + + + + %for line in obj.get_parser_method('lines',data['form']): + %if line['type'] != 'view': + + + + + + + + + %elif line['total'] and not line['label']: + + + + + + + + + %else: + + + + + + + + + %endif + %endfor + +
${_('CODE')}${_('ACCOUNT')}${_('INICIAL')}${_('DEBIT')}${_('CREDIT')}${_('BALANCE')}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['balanceinit'] and line['balanceinit'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['debit'], digits=2, grouping=True) or ''}${formatLang(line['credit'], digits=2, grouping=True) or ''}${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['balanceinit'] and line['balanceinit'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['debit'], digits=2, grouping=True) or ''}${formatLang(line['credit'], digits=2, grouping=True) or ''}${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['balanceinit'] and line['balanceinit'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['debit'], digits=2, grouping=True) or ''}${formatLang(line['credit'], digits=2, grouping=True) or ''}${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}
+ +%endfor + + === added file 'account_financial_report_exportable/report/afr_report_webkit_cols5.mako' --- account_financial_report_exportable/report/afr_report_webkit_cols5.mako 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/report/afr_report_webkit_cols5.mako 2013-10-23 14:40:32 +0000 @@ -0,0 +1,76 @@ + + + + + + + + +%for obj in objects: + + + + + +
+
${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}
+
+ + + + + +
${obj.company_id.name or ''|entity}
${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}
${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}
${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}
+
+ + + + + + +
${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}
+ + + + + + + + + + + %for line in obj.get_parser_method('lines',data['form']): + %if line['type'] != 'view': + + + + + + + + + + %elif line['total'] and not line['label']: + + + + + + + + + + %else: + + + + + %endif + %endfor +
${_('Code')}${_('ACCOUNT')}${_('INIT. BAL.')}${_('DEBIT')}${_('CREDIT')}${_('PERIOD')}${_('YTD')}
${line['code'] or ''}${line['name'].upper() or line['name'].title()}${formatLang(line.get('change_sign', 1.0) * line.get('balanceinit'), digits=2, grouping=True) or ''}${formatLang(line['debit'], digits=2, grouping=True) or ''}${formatLang(line['credit'], digits=2, grouping=True) or ''}${formatLang(line.get('change_sign', 1.0) * line.get('ytd'), digits=2, grouping=True) or ''}${formatLang(line.get('change_sign', 1.0) * line.get('balance'), digits=2, grouping=True) or ''}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line.get('change_sign', 1.0) * line.get('balanceinit'), digits=2, grouping=True) or ''}${formatLang(line['debit'], digits=2, grouping=True) or ''}${formatLang(line['credit'], digits=2, grouping=True) or ''}${formatLang(line.get('change_sign', 1.0) * line.get('ytd'), digits=2, grouping=True) or ''}${formatLang(line.get('change_sign', 1.0) * line.get('balance'), digits=2, grouping=True) or ''}
${(line['label'] == True ) and line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}
+%endfor + + === added file 'account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako' --- account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako 2013-10-23 14:40:32 +0000 @@ -0,0 +1,127 @@ + + + + + + + +%for obj in objects: + + + + + +
+
${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}
+
+ + + + + +
${obj.company_id.name or ''|entity}
${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}
${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}
${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}
+
+ + + + + + + +
${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}
+ + + + + + + + + + + +
${_('CODE')}${_('ACCOUNT')}${_('INICIAL')}${_('DEBIT')}${_('CREDIT')}${_('BALANCE')}
+ + + + + + + + + +
${_('DATE')}${_('PERIOD')}${_('JOURNAL ENTRY')}
+ + + + + + + + + + + + + + + %for line in obj.get_parser_method('lines',data['form']): + %if line['type']!= 'view': + + + + + + + + + + + %for j in line['journal']: + + + + + + + + + %for k in j.get('obj').line_id: + + %if k.account_id.name.upper() == line['name'].upper() : + + + + + + + + + + + %else: + + + + + + + + + + + %endif + + %endfor + %endfor + %endif + %endfor +
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['balanceinit'] and line['balanceinit'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''} ${formatLang(line['debit'], digits=2, grouping=True) or ''}${formatLang(line['credit'], digits=2, grouping=True) or ''}${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}
${formatLang( j['date'], date=True) or ''}${j['period'] or ''}${j['name'] or ''}
${k.name or ''}${k.ref and k.ref or ''}${k.partner_id and k.partner_id.name or ''}${k.account_id and k.account_id.code or ''}${k.account_id and k.account_id.name or ''}${k.debit and formatLang(k.debit, digits=2, grouping=True) or ''}${k.credit and formatLang(k.credit, digits=2, grouping=True) or ''}${k.reconcile_id and k.reconcile_id.name or k.reconcile_partial_id and k.reconcile_partial_id.name or ''}
${k.name or ''}${k.ref and k.ref or ''}${k.partner_id and k.partner_id.name or ''}${k.account_id and k.account_id.code or ''}${k.account_id and k.account_id.name or ''}${k.debit and formatLang(k.debit, digits=2, grouping=True) or ''}${k.credit and formatLang(k.credit, digits=2, grouping=True) or ''}${k.reconcile_id and k.reconcile_id.name or k.reconcile_partial_id and k.reconcile_partial_id.name or ''}
+ +%endfor + + + === added file 'account_financial_report_exportable/report/afr_report_webkit_qtr.mako' --- account_financial_report_exportable/report/afr_report_webkit_qtr.mako 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/report/afr_report_webkit_qtr.mako 2013-10-23 14:40:32 +0000 @@ -0,0 +1,82 @@ + + + + + + + + + + + %for obj in objects: + + + + + + +
+
${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}
+
+ + + + + +
${obj.company_id.name or ''|entity}
${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}
${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}
${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}
+
+
+ + + + + + + + + + + + + + + + + %for line in obj.get_parser_method('lines',data['form']): + %if line['type'] != 'view': + + + + + + + + + + %elif line['total'] and not line['label']: + + + + + + + + + + %else: + + + + + %endif + %endfor + +
${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}
${_('CODE')}${_('ACCOUNT')}${_('Q1')}${_('Q2')}${_('Q3')}${_('Q4')}${_('YTD')}
${line['code'] or ''}${line['name'].upper() or line['name'].title()}${formatLang(line['bal1'] and (line['bal1'] * line.get('change_sign',1)) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}${formatLang(line['bal1'] and (line['bal1'] * line.get('change_sign',1)) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}${formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}
${line['code'] or ''}${line['name'].upper() or line['name'].title() or ''}
+%endfor + + === added file 'account_financial_report_exportable/report/report_afr.xml' --- account_financial_report_exportable/report/report_afr.xml 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/report/report_afr.xml 2013-10-23 14:40:32 +0000 @@ -0,0 +1,316 @@ + + + + + + + webkit_header + + + + + + + + True + True + + + webkit_header + + + + + + + + + webkit_header + + + + + + + + True + True + + + webkit_header + + + + + + + + + webkit_header + + + + + + + + True + True + + + webkit_header + + + + + + + + + webkit_header + + + + + + + + True + True + + + webkit_header + + + + + + + + + webkit_header + + + + + + + + True + True + + + webkit_header + + + + + + + + + webkit_header + + + + + + + + True + True + + + webkit_header + + + + + + + + + webkit_header + + + + + + + + True + True + + + webkit_header + + + + + + + + + webkit_header + + + + + + + + True + True + + + webkit_header + + + + + + === added directory 'account_financial_report_exportable/security' === added directory 'account_financial_report_exportable/static' === added directory 'account_financial_report_exportable/static/description' === added file 'account_financial_report_exportable/static/description/index.html' === added directory 'account_financial_report_exportable/static/src' === added directory 'account_financial_report_exportable/static/src/css' === added directory 'account_financial_report_exportable/static/src/img' === added directory 'account_financial_report_exportable/static/src/js' === added directory 'account_financial_report_exportable/static/src/xml' === added directory 'account_financial_report_exportable/test' === added directory 'account_financial_report_exportable/view' === added file 'account_financial_report_exportable/view/account_financial_report_view.xml' --- account_financial_report_exportable/view/account_financial_report_view.xml 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/view/account_financial_report_view.xml 2013-10-23 14:40:32 +0000 @@ -0,0 +1,15 @@ + + + + + wizard.report.view.inherit + wizard.report + + + + + + + + + === added directory 'account_financial_report_exportable/wizard' === added file 'account_financial_report_exportable/wizard/__init__.py' --- account_financial_report_exportable/wizard/__init__.py 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/wizard/__init__.py 2013-10-23 14:40:32 +0000 @@ -0,0 +1,26 @@ +#!/usr/bin/python +# -*- encoding: utf-8 -*- +############################################################################### +# Module Writen to OpenERP, Open Source Management Solution +# Copyright (C) OpenERP Venezuela (). +# All Rights Reserved +############# Credits ######################################################### +# Coded by: Yanina Aular +# Planified by: Humberto Arocha +# Audited by: Humberto Arocha +############################################################################### +# 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 . +############################################################################### + +import afr_report_wizard === added file 'account_financial_report_exportable/wizard/afr_report_wizard.py' --- account_financial_report_exportable/wizard/afr_report_wizard.py 1970-01-01 00:00:00 +0000 +++ account_financial_report_exportable/wizard/afr_report_wizard.py 2013-10-23 14:40:32 +0000 @@ -0,0 +1,118 @@ +#!/usr/bin/python +# -*- encoding: utf-8 -*- +############################################################################### +# Module Writen to OpenERP, Open Source Management Solution +# Copyright (C) OpenERP Venezuela (). +# All Rights Reserved +############# Credits ######################################################### +# Coded by: Yanina Aular +# Planified by: Humberto Arocha +# Audited by: Humberto Arocha +############################################################################### +# 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 . +############################################################################### + + + +from osv import osv, fields +import pooler +import time +from tools.translate import _ +from account_financial_report.report import parser as Parser + + +class wizard_report(osv.osv_memory): + _inherit = "wizard.report" + + _columns = { + 'report_format' : fields.selection([ + ('pdf', 'PDF'), + ('spreadsheet', 'Spreadsheet')], 'Report Format') + } + def get_parser_method(self, cr, uid, ids, method=None, args=None, param=None, context=None): + if context is None: + context = {} + + acc_bal_obj = Parser.account_balance(cr, uid, ids ,context=context) + res = [] + + if method: + if method in ("get_company_accounts", "_get_analytic_ledger", "_get_journal_ledger", + "lines"): + res = getattr(acc_bal_obj, method)(args, param) + else: + res = getattr(acc_bal_obj, method)(args) + + return res + + def print_report(self, cr, uid, ids, data, context=None): + if context is None: + context = {} + + res = super(wizard_report, self).print_report(cr, uid, ids, data=data, context=context) + + res.get('datas')['ids'] = ids + + if( res.get('report_name') == 'afr.1cols'): + if (res.get('datas').get('form')['report_format'] == 'spreadsheet'): + res['report_name'] = 'afr_report_col1_html' + else: + res['report_name'] = 'afr_report_col1' + + if( res.get('report_name') == 'afr.2cols'): + if (res.get('datas').get('form')['report_format'] == 'spreadsheet'): + res['report_name'] = 'afr_report_col2_html' + else: + res['report_name'] = 'afr_report_col2' + + if( res.get('report_name') == 'afr.4cols'): + if (res.get('datas').get('form')['report_format'] == 'spreadsheet'): + res['report_name'] = 'afr_report_col4_html' + else: + res['report_name'] = 'afr_report_col4' + + if( res.get('report_name') == 'afr.5cols'): + if (res.get('datas').get('form')['report_format'] == 'spreadsheet'): + res['report_name'] = 'afr_report_col5_html' + else: + res['report_name'] = 'afr_report_col5' + + if( res.get('report_name') == 'afr.journal.ledger'): + if (res.get('datas').get('form')['report_format'] == 'spreadsheet'): + res['report_name'] = 'afr_report_journal_ledger_html' + else: + res['report_name'] = 'afr_report_journal_ledger' + + if( res.get('report_name') == 'afr.analytic.ledger'): + if (res.get('datas').get('form')['report_format'] == 'spreadsheet'): + res['report_name'] = 'afr_report_analytic_ledger_html' + else: + res['report_name'] = 'afr_report_analytic_ledger' + + if( res.get('report_name') == 'afr.qtrcols'): + if (res.get('datas').get('form')['report_format'] == 'spreadsheet'): + res['report_name'] = 'afr_report_qtr_html' + else: + res['report_name'] = 'afr_report_qtr' + + if( res.get('report_name') == 'afr.13cols'): + if (res.get('datas').get('form')['report_format'] == 'spreadsheet'): + res['report_name'] = 'afr_report_col13_html' + else: + res['report_name'] = 'afr_report_col13' + + return res + + + === added directory 'account_financial_report_exportable/workflow'