Merge lp:~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge into lp:~account-report-core-editor/account-financial-report/7.0

Status: Rejected
Rejected by: Maxime Chambreuil (http://www.savoirfairelinux.com)
Proposed branch: lp:~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge
Merge into: lp:~account-report-core-editor/account-financial-report/7.0
Diff against target: 2947 lines (+2819/-1)
20 files modified
account_financial_report/wizard/wizard.py (+0/-1)
account_financial_report_exportable/__init__.py (+26/-0)
account_financial_report_exportable/__openerp__.py (+55/-0)
account_financial_report_exportable/data/html_css_afr.xml (+1372/-0)
account_financial_report_exportable/i18n/es.po (+57/-0)
account_financial_report_exportable/i18n/es_MX.po (+57/-0)
account_financial_report_exportable/model/__init__.py (+25/-0)
account_financial_report_exportable/report/__init__.py (+25/-0)
account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako (+103/-0)
account_financial_report_exportable/report/afr_report_webkit_cols1.mako (+71/-0)
account_financial_report_exportable/report/afr_report_webkit_cols13.mako (+102/-0)
account_financial_report_exportable/report/afr_report_webkit_cols2.mako (+80/-0)
account_financial_report_exportable/report/afr_report_webkit_cols4.mako (+86/-0)
account_financial_report_exportable/report/afr_report_webkit_cols5.mako (+76/-0)
account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako (+127/-0)
account_financial_report_exportable/report/afr_report_webkit_qtr.mako (+82/-0)
account_financial_report_exportable/report/report_afr.xml (+316/-0)
account_financial_report_exportable/view/account_financial_report_view.xml (+15/-0)
account_financial_report_exportable/wizard/__init__.py (+26/-0)
account_financial_report_exportable/wizard/afr_report_wizard.py (+118/-0)
To merge this branch: bzr merge lp:~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge
Reviewer Review Type Date Requested Status
hbto [Vauxoo] http://www.vauxoo.com Disapprove
Joël Grand-Guillaume @ camptocamp Disapprove
Guewen Baconnier @ Camptocamp Needs Fixing
Frederic Clementi - Camptocamp functionality duplication Disapprove
Jorge Angel Naranjo Rogel - http://www.vauxoo.com (community) Needs Resubmitting
Nhomar - Vauxoo Approve
Luis Ernesto García Medina - http://www.vauxoo.com Pending
Review via email: mp+192050@code.launchpad.net

Description of the change

Quedan los reportes en webkit y con la opción a imprimir en PDF o HTML.

To post a comment you must log in.
Revision history for this message
hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha) wrote :

Will be testing

Regards

Revision history for this message
hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha) wrote :

Just these two point to be fixed and it will look good to me:

* rotate the frame for 4 QTR's Reports, now is in portrait, should be landscape
* make the font size for reports in portrait (vertical), two or three points bigger.

Thanks in advances.

Regards.

Revision history for this message
Frederic Clementi - Camptocamp (frederic-clementi) wrote :

Hello,

Could you give us more explaination about this merge proposal ? What sort of report or tool this is about before I install anything to test ?

Can you confirm it will not be a duplication of account_financial_report_webkit ?

Many thanks

Frederic

review: Needs Information
Revision history for this message
Nhomar - Vauxoo (nhomar) wrote :

The algorithms in this reports are differnt from the *webkit.

And we need them "Excel" Exportable to.

We will try to merge in some future versions both concepts in one module
but from repotlab we can't export to Excel, it is the reason we migrate to
webkit our approach.

Regards.

2013/10/22 Frederic Clementi - Camptocamp.com <
<email address hidden>>

> Review: Needs Information
>
> Hello,
>
> Could you give us more explaination about this merge proposal ? What sort
> of report or tool this is about before I install anything to test ?
>
> Can you confirm it will not be a duplication of
> account_financial_report_webkit ?
>
> Many thanks
>
> Frederic
>
> --
>
> https://code.launchpad.net/~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge/+merge/192050
> Your team Account Report Core Editors is subscribed to branch
> lp:account-financial-report.
>

--
--------------------
Saludos Cordiales

Nhomar G. Hernandez M.
+58-414-4110269
Skype: nhomar00
Web-Blog: http://geronimo.com.ve
Servicios IT: http://vauxoo.com
Linux-Counter: 467724
Correos:
<email address hidden>
<email address hidden>
twitter @nhomar

Revision history for this message
Frederic Clementi - Camptocamp (frederic-clementi) wrote :

Hi Nhomar,

FYI, all webkit financial reports are already exportable to excel thanks to noviat work...but MPs are not yet done (it will soon)

see here : ~noviat/openobject-addons/extra-7.0

- report_xls (xls export engine)
- account_move_line_report_xls (to export selected move lines)
- account_financial_report_webkit_xls (to add a XLS export button on each webkit fi. report)

(We already use these modules in production)

An other possibility is to use :
- account_csv_export (add a menu to export directly/very quicky - using SQL request - the general ledger par journal&period, trial balance and analytic trial balance.

Frederic

Revision history for this message
Nhomar - Vauxoo (nhomar) wrote :

Thanks frederic.

@hbto do you think it is feasible verify this comply with our needs?.

Written from my android
On Oct 22, 2013 4:05 AM, "Frederic Clementi - Camptocamp.com" <
<email address hidden>> wrote:

> Hi Nhomar,
>
> FYI, all webkit financial reports are already exportable to excel thanks
> to noviat work...but MPs are not yet done (it will soon)
>
> see here : ~noviat/openobject-addons/extra-7.0
>
> - report_xls (xls export engine)
> - account_move_line_report_xls (to export selected move lines)
> - account_financial_report_webkit_xls (to add a XLS export button on each
> webkit fi. report)
>
> (We already use these modules in production)
>
> An other possibility is to use :
> - account_csv_export (add a menu to export directly/very quicky - using
> SQL request - the general ledger par journal&period, trial balance and
> analytic trial balance.
>
> Frederic
>
>
>
>
> --
>
> https://code.launchpad.net/~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge/+merge/192050
> Your team Account Report Core Editors is subscribed to branch
> lp:account-financial-report.
>

Revision history for this message
hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha) wrote :

I will check, but in the meantime we need our old rml format report with
our BL into Webkit output, we have
not developed new reports or wizard, we just did a wrapper to be able to
get report from the same module
by just printing them on webkit.

Regards.

2013/10/22 Nhomar - Vauxoo <email address hidden>

> Thanks frederic.
>
> @hbto do you think it is feasible verify this comply with our needs?.
>
> Written from my android
> On Oct 22, 2013 4:05 AM, "Frederic Clementi - Camptocamp.com" <
> <email address hidden>> wrote:
>
> > Hi Nhomar,
> >
> > FYI, all webkit financial reports are already exportable to excel thanks
> > to noviat work...but MPs are not yet done (it will soon)
> >
> > see here : ~noviat/openobject-addons/extra-7.0
> >
> > - report_xls (xls export engine)
> > - account_move_line_report_xls (to export selected move lines)
> > - account_financial_report_webkit_xls (to add a XLS export button on each
> > webkit fi. report)
> >
> > (We already use these modules in production)
> >
> > An other possibility is to use :
> > - account_csv_export (add a menu to export directly/very quicky - using
> > SQL request - the general ledger par journal&period, trial balance and
> > analytic trial balance.
> >
> > Frederic
> >
> >
> >
> >
> > --
> >
> >
> https://code.launchpad.net/~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge/+merge/192050
> > Your team Account Report Core Editors is subscribed to branch
> > lp:account-financial-report.
> >
>
> --
>
> https://code.launchpad.net/~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge/+merge/192050
> You are requested to review the proposed merge of
> lp:~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge
> into lp:account-financial-report.
>

Revision history for this message
Nhomar - Vauxoo (nhomar) wrote :

Frederic.

Are you comfortable with this mean time solution?

We need deliver this to our customer becaure the numbers are already
audited, then we dont like manage extra branches for community ones.

Regards.

Written from my android
On Oct 22, 2013 1:31 PM, "hbto [Vauxoo] http://www.vauxoo.com" <
<email address hidden>> wrote:

> I will check, but in the meantime we need our old rml format report with
> our BL into Webkit output, we have
> not developed new reports or wizard, we just did a wrapper to be able to
> get report from the same module
> by just printing them on webkit.
>
> Regards.
>
>
> 2013/10/22 Nhomar - Vauxoo <email address hidden>
>
> > Thanks frederic.
> >
> > @hbto do you think it is feasible verify this comply with our needs?.
> >
> > Written from my android
> > On Oct 22, 2013 4:05 AM, "Frederic Clementi - Camptocamp.com" <
> > <email address hidden>> wrote:
> >
> > > Hi Nhomar,
> > >
> > > FYI, all webkit financial reports are already exportable to excel
> thanks
> > > to noviat work...but MPs are not yet done (it will soon)
> > >
> > > see here : ~noviat/openobject-addons/extra-7.0
> > >
> > > - report_xls (xls export engine)
> > > - account_move_line_report_xls (to export selected move lines)
> > > - account_financial_report_webkit_xls (to add a XLS export button on
> each
> > > webkit fi. report)
> > >
> > > (We already use these modules in production)
> > >
> > > An other possibility is to use :
> > > - account_csv_export (add a menu to export directly/very quicky - using
> > > SQL request - the general ledger par journal&period, trial balance and
> > > analytic trial balance.
> > >
> > > Frederic
> > >
> > >
> > >
> > >
> > > --
> > >
> > >
> >
> https://code.launchpad.net/~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge/+merge/192050
> > > Your team Account Report Core Editors is subscribed to branch
> > > lp:account-financial-report.
> > >
> >
> > --
> >
> >
> https://code.launchpad.net/~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge/+merge/192050
> > You are requested to review the proposed merge of
> > lp:~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge
> > into lp:account-financial-report.
> >
>
> --
>
> https://code.launchpad.net/~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge/+merge/192050
> Your team Account Report Core Editors is subscribed to branch
> lp:account-financial-report.
>

Revision history for this message
Nhomar - Vauxoo (nhomar) wrote :

For me it is good Hbto.

Just one comment:

I could call it afr_exportable or something like that (decide you), the *_ext is a little ambiguous for community, "It sound like an *extension to change the behavior and it is really a *exportable module.

Regards.

review: Needs Fixing
Revision history for this message
hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha) wrote :

Ok, approved,

2013/10/22 Nhomar - Vauxoo <email address hidden>

> Review: Needs Fixing
>
> For me it is good Hbto.
>
> Just one comment:
>
> I could call it afr_exportable or something like that (decide you), the
> *_ext is a little ambiguous for community, "It sound like an *extension to
> change the behavior and it is really a *exportable module.
>
> Regards.
> --
>
> https://code.launchpad.net/~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge/+merge/192050
> You are requested to review the proposed merge of
> lp:~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge
> into lp:account-financial-report.
>

73. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[IMP][account_financial_report_ext] Changed font size for reports in portrait and rotate 4 QTR's Reports.

74. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[MERGE] added selection of format for all reports (PDF, HTML)

Merge from lp:~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge

Revision history for this message
Jorge Angel Naranjo Rogel - http://www.vauxoo.com (jorge-nr) wrote :

Queda lista la nueva propuesta de merge con los cambios solicitados en los reportes..

review: Needs Resubmitting
75. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[IMP][account_financial_report_exportable] Changed module name from account_financial_report_ext to account_financial_report_exportable

Revision history for this message
Jorge Angel Naranjo Rogel - http://www.vauxoo.com (jorge-nr) wrote :

Changed module name from account_financial_report_ext to account_financial_report_exportable

review: Needs Resubmitting
Revision history for this message
hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha) wrote :

I approved this merge,

Regards

review: Approve
Revision history for this message
Nhomar - Vauxoo (nhomar) wrote :

LGTM.

review: Approve
Revision history for this message
Frederic Clementi - Camptocamp (frederic-clementi) wrote :

Hello, guys.

I would like to test this first...but during module install I have the following error :

ValueError: No such external ID currently defined in the system: account_financial_report_ext.ir_header_webkit_afrreport_five_colums

thanks

review: Needs Fixing
76. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[FIX][account_financial_report_exportable] Fixed references of name module previous

Revision history for this message
Jorge Angel Naranjo Rogel - http://www.vauxoo.com (jorge-nr) wrote :

Fixed bug of references.

Thanks

review: Needs Resubmitting
Revision history for this message
Frederic Clementi - Camptocamp (frederic-clementi) wrote :
Download full text (4.3 KiB)

Thanks, With your resubmission I could do a full functional test. You did a good job. Congrats. However, I have several comments to do :

1 - After module install, menus do not appears as epexted (under Accounting/Reporting/Legal Reports/Accounting Reports) even with user rights set to : financial report. I had to duplicate menu and give a new name to see them working (?)...

2 - In the wizard, in the section 'account to include', I noticed that if a parent account has a level lower that the level of the child account (yes, it happens :( especially on migrated databases), I get the following error :
File "/home/fclementi/openerp-instances/openerp_prod_camptocamp/parts/account-financial-report/account_financial_report_exportable/wizard/afr_report_wizard.py", line 53, in get_parser_method
res = getattr(acc_bal_obj, method)(args, param)
File "/home/fclementi/openerp-instances/openerp_prod_camptocamp/parts/account-financial-report/account_financial_report/report/parser.py", line 624, in lines
child_id.id).get('debit')
AttributeError: 'NoneType' object has no attribute 'get'

3 - About section 'account to include' : I see an ergonomy issue....but tell me be if you agree. If I want to select all P&L accounts, I have to select them one by one... it is a nightmare. Personnaly, I whould prefer to let the user select the a parent account and you would included recurcively all children accounts for the report (thats what we did on the webkit financial report we made)
I would also add that for a P&L or BS report it is pointless to select regular accounts, you do not want to print a such a report with one or few lines...

4 - The printout by quater and by month is barely readable...too small. Can you improve that ?

5 - typo : INICIAL instead of initial on analytic ledger.

6 - check box 'analytic ledger' seems to be rather a detailed of account move lines but nothing to de with analityc lines... Am I correct? if yes, simply change the semantic to 'general ledger'...However if this is used to print a general ledger then the report already exist and defenetly deserve to be a clearly separeted report... an accountants lwill never understand spontaneously.

7 - error if I check 'journal ledger :
Webkit render!

Traceback (most recent call last):
File "/home/fclementi/openerp-instances/openerp_prod_camptocamp/parts/addons/report_webkit/webkit_report.py", line 273, in create_single_pdf
**self.parser_instance.localcontext)
File "/home/fclementi/.buildout/eggs/Mako-0.6.2-py2.7.egg/mako/template.py", line 378, in render
return runtime._render(self, self.callable_, args, data)
File "/home/fclementi/.buildout/eggs/Mako-0.6.2-py2.7.egg/mako/runtime.py", line 646, in _render
**_kwargs_for_callable(callable_, data))
File "/home/fclementi/.buildout/eggs/Mako-0.6.2-py2.7.egg/mako/runtime.py", line 678, in _render_context
_exec_template(inherit, lclcontext, args=args, kwargs=kwargs)
File "/home/fclementi/.buildout/eggs/Mako-0.6.2-py2.7.egg/mako/runtime.py", line 704, in _exec_template
callable_(context, *args, **kwargs)
File "memory:0x4dc0a90", line 83, in render_body
%for j in line['journal']:
KeyError: 'journal'

8 - Checkbox 'summarized ? ' : most of the time I g...

Read more...

review: Needs Fixing (functional)
Revision history for this message
Frederic Clementi - Camptocamp (frederic-clementi) wrote :

Hello Vauxoo friends,

I will probably not make you happy but I must say that after my yesterday test of your financial reports module that I realized that the functional coverage is the same than the 'webkit_financial_report' module which is already in the community repository for some time and which has already received several contributions ('journal ledger' from Syleam, XLS export from Noviat, bug fixes...). So, it is a functional duplication that I will not approve this MP.

I would also like to add that the 'account_financial_reports_webkit' are mature for a long time, widely used in production and by other partners especially in Europe.

Even more mportant, I think 'account_financial_reports_webkit' goes further in terms of functionalities.
i.e :
* The Open Invoice report - which can list you open invoices (over several fy if necessary)
* All reports can be printed at any date in the past (thanks to the last_rec_date field). This feature is a MUST HAVE. I do not know if this is implemented on you side but without this financial reports are USELESS (because you cannot use the date on reconcile_id since you do not care of the date of the reconcile but you need the date of the last payment for example)
* Handling previous fiscal year initial balance on the fly calculation IF the opening entry is not generated
* Other modules like 'account_revaluation' provide other reports based on the same model with an extra granularity on currencies
* General ledger : you can centralize account (goup account move lines by period) in order to generate less pdf pages and increase perf.
* You can compare until 4 fy and/or periods with a total flexibility + you can see the diff in value and %
audit tools like the clearing date analysis (embedded in the open invoice reports)
...

On the other hand, this module still miss :
* P&L and B/S reports
* possibility to get a 12 months views
* possibility to customize your css (but we could add a mechanism to handle this quite easily we think)

@Nohmar : I have no doubt that you agree on principle but I guess you cannot switch so easily... so how can we proceed ?

Many thanks for your understanding

Frederic

Revision history for this message
Frederic Clementi - Camptocamp (frederic-clementi) wrote :

cf previous post.

review: Disapprove (functionality duplication)
Revision history for this message
Nhomar - Vauxoo (nhomar) wrote :

As a first thought.

We think we need _one_ but well documented.

Base webkit or ours (wich we use from some years ago too) and is a fork based on spanish ones.

Other _important_ point is that our reports are already audited (this merge don't we are talking about the rml ones) and I think the leak of documentation from all parts will make us difficult to decide.

BTW, I am almost sure tomorrow (here we have 300 am) Hbto will answer with the specific answers to your points, but I think you miss some points that the report does.

I am almost sure a "Merge" of Ideas will be the solution at the end of the day.

For me, this specific MP is because we need them "Exactly" as printed in Excel, I can live with this little fork in the middle.

About the contributions, made by everybody, maybe it is not the point I read some code from the "Excel" Feature and i don't like at all, technically and functional speaking even, but IMHO the start must to be in some point, and reading your words I am Imaging, in your side you have the same frustration than in our side when we see the "European Reports " ;-) which we really try to implement here in America and they didn't work even.

Other idea, "Just thinking aloud" can be make a little agreement for v8, because today, we /(Vauxoo) can NOT change our financial report strategy, and you (c2c and European team) can not either, maybe this temporary merge can fix this "Middle term" but with the fixes that you suggest obviously.

FYI, I am sure all the functionalities you claim are present, if not @hbto will answer tomorrow.

Well THis message is only as comment, not decistion/defense yet, let us discuss internally.

Thanks a lot for your feedback.

Revision history for this message
Frederic Clementi - Camptocamp (frederic-clementi) wrote :

Many thanks for your answer and undestanding. I appreciate that you are always open to discussion... we are as well.

I already have a doc about account_financial_report_webkit module in french... I will translate it and communicate it asap.

Revision history for this message
Guewen Baconnier @ Camptocamp (gbaconnier-c2c) wrote :

Hi,

With the lines in <table><td>, you'll have problems with lines being cut or hidden between pages (that's a wkhtmltopdf bug, see comment #9 and #11 of https://code.google.com/p/wkhtmltopdf/issues/detail?id=566).

That's why we used solely <div> in our reports: we use "<div>" elements with the "display" css property (with values "table", "table-row", "table-cell", ...).

Example in our reports:
http://bazaar.launchpad.net/~account-report-core-editor/account-financial-report/7.0/view/head:/account_financial_report_webkit/report/templates/account_report_partners_ledger.mako#L26

And the css:
http://bazaar.launchpad.net/~account-report-core-editor/account-financial-report/7.0/view/head:/account_financial_report_webkit/data/financial_webkit_header.xml#L71

review: Needs Fixing
Revision history for this message
Joël Grand-Guillaume @ camptocamp (jgrandguillaume-c2c) wrote :

Hi there !

I'm just back from holidays. First thing, I want to give here the link on the Google Docs for the webkit financial report we've made : https://docs.google.com/file/d/0B4GKXfLLiGNteU5OWWtKZVc1aE0/edit?usp=sharing&pli=1

With that, you should be able to better understand our work here and why we're arguing so much here ;)

I see here 2 problems:

1) Vauxoo seems to need those reports they are asking here for, and we don't want to block you here

2) We already have 2 solutions here, so migrating your (Vauxoo) RML work on webkit without taking our work into account is a bit double work.. then, afterwards double work to maintain...

Honestly, we already faced all troubles by the past, that's why we invest so much in those new webkit reports. As long as yours was RML based, having 2 solutions was not that good but understandable... Now, rebuilding them all again seems not reasonable to me I'm afraid. Unless you really have something strong that justify that double work. I'm disapproving this MP mainly because:

 * No enlighten functional reasons to have 2 kinds of financial report based on webkit
 * Some errors that we have corrected in our reports seems to always be there in yours
 * Community should make efforts to merge our work rather than maintaining various solutions

Now Nhomar, I don't want to block you here, so please, if this is really a pain for you, contact me and we'll see how we can deal with that. For example, I can provide you some expertise from Frédéric to help you with our webkit reports to show you and see if they can make the work or not, and if not why => that will justify this MP by the way IMO.

Hope you'll understand my point of view.

Regards,

Joël

review: Disapprove
Revision history for this message
hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha) wrote :

Disapprove in compliance to find Common Grounds
in the generations of Common Agnostic Financial Reports

Regards

review: Disapprove
Revision history for this message
hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha) wrote :

Hello Maxime,

We have decide regarding a Common Ground to be reached,

that the proposed branch be rejected,

It has been joined into a lp:addons-vauxoo/7.0 branch,

Best regards.

2013/12/27 Maxime Chambreuil (http://www.savoirfairelinux.com) <
<email address hidden>>

> The proposal to merge
> lp:~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge
> into lp:account-financial-report has been updated.
>
> Status: Needs review => Work in progress
>
> For more details, see:
>
> https://code.launchpad.net/~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge/+merge/192050
> --
>
> https://code.launchpad.net/~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge/+merge/192050
> You are reviewing the proposed merge of
> lp:~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge
> into lp:account-financial-report.
>

Unmerged revisions

76. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[FIX][account_financial_report_exportable] Fixed references of name module previous

75. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[IMP][account_financial_report_exportable] Changed module name from account_financial_report_ext to account_financial_report_exportable

74. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[MERGE] added selection of format for all reports (PDF, HTML)

Merge from lp:~vauxoo/account-financial-report/7.0-report_webkit_afr-_data_dev-jorge

73. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[IMP][account_financial_report_ext] Changed font size for reports in portrait and rotate 4 QTR's Reports.

72. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[IMP][account_financial_report_ext] Align date to left in report analytic ledger

71. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[IMP][account_financial_report_ext] Format in reports

70. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[ADD][account_financial_report_ext] Added format in report of 1 column

69. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[IMP][account_financial_report_ext] Improvemente report cols13

68. By Jorge Angel Naranjo Rogel - http://www.vauxoo.com

[IMP][account_financial_report_ext] Added data in reports of 1,2 and 4 columns and analytic ledger

67. By Yanina Aular (Vauxoo)

[IMP] file renamed

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== 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 @@
284 name = 'afr.qtrcols'284 name = 'afr.qtrcols'
285 if data['form']['columns'] == 'thirteen':285 if data['form']['columns'] == 'thirteen':
286 name = 'afr.13cols'286 name = 'afr.13cols'
287
288 return {'type': 'ir.actions.report.xml', 'report_name': name, 'datas': data}287 return {'type': 'ir.actions.report.xml', 'report_name': name, 'datas': data}
289288
290wizard_report()289wizard_report()
291290
=== 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 @@
1#!/usr/bin/python
2# -*- encoding: utf-8 -*-
3###############################################################################
4# Module Writen to OpenERP, Open Source Management Solution
5# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
6# All Rights Reserved
7############# Credits #########################################################
8# Coded by: Yanina Aular <yani@vauxoo.com>
9# Planified by: Humberto Arocha <hbto@vauxoo.com>
10# Audited by: Humberto Arocha <hbto@vauxoo.com>
11###############################################################################
12# This program is free software: you can redistribute it and/or modify
13# it under the terms of the GNU Affero General Public License as published
14# by the Free Software Foundation, either version 3 of the License, or
15# (at your option) any later version.
16#
17# This program is distributed in the hope that it will be useful,
18# but WITHOUT ANY WARRANTY; without even the implied warranty of
19# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20# GNU Affero General Public License for more details.
21#
22# You should have received a copy of the GNU Affero General Public License
23# along with this program. If not, see <http://www.gnu.org/licenses/>.
24###############################################################################
25import model
26import wizard
027
=== 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 @@
1#!/usr/bin/python
2# -*- encoding: utf-8 -*-
3###############################################################################
4# Module Writen to OpenERP, Open Source Management Solution
5# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
6# All Rights Reserved
7############# Credits #########################################################
8# Coded by: Yanina Aular <yani@vauxoo.com>
9# Planified by: Humberto Arocha <hbto@vauxoo.com>
10# Audited by: Humberto Arocha <hbto@vauxoo.com>
11###############################################################################
12# This program is free software: you can redistribute it and/or modify
13# it under the terms of the GNU Affero General Public License as published
14# by the Free Software Foundation, either version 3 of the License, or
15# (at your option) any later version.
16#
17# This program is distributed in the hope that it will be useful,
18# but WITHOUT ANY WARRANTY; without even the implied warranty of
19# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20# GNU Affero General Public License for more details.
21#
22# You should have received a copy of the GNU Affero General Public License
23# along with this program. If not, see <http://www.gnu.org/licenses/>.
24###############################################################################
25
26{
27 'name': 'Account Financial Report Exportable',
28 'version': '1.0',
29 'author': 'Vauxoo',
30 'website': 'http://www.vauxoo.com/',
31 'category': 'Accounting',
32 'description': '''
33Account Financial Report Exportable
34===================================
35
36Account Financial Report Reports on Webkit
37
38Main Features
39=============
40
41account_financial_report module reports are now printed using webkit.
42
43
44''',
45 'depends': ['base', 'mail', 'account_accountant', 'account_financial_report', 'report_webkit'],
46 'data': [
47 'data/html_css_afr.xml',
48 'report/report_afr.xml',
49 'view/account_financial_report_view.xml'
50 ],
51 'demo': [],
52 'test': [],
53 'active': False,
54 'installable': True,
55}
056
=== 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 @@
1<?xml version="1.0" ?>
2<openerp>
3 <data noupdate="0">
4 <record id="ir_header_webkit_afrreport_analytic_ledger" model="ir.header_webkit">
5 <field name="name">Reports AFR WebKit</field>
6 <field name="footer_html">
7<![CDATA[<html>
8 <head>
9 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
10 <script>
11 function subst() {
12 var vars={};
13 var x=document.location.search.substring(1).split('&');
14 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
15 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
16 for(var i in x) {
17 var y = document.getElementsByClassName(x[i]);
18 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
19 }
20 }
21 </script>
22 </head>
23 <body style="border:0; margin: 0;" onload="subst()">
24 <table style="border-top: 1px solid black; width: 100%">
25 <tr>
26 <td style="float:right;text-align:left;font-size:10;" width="30%">
27 <script type="text/javascript">
28 var date = new Date();
29 var d = date.getDate();
30 var day = (d < 10) ? '0' + d : d;
31 var m = date.getMonth() + 1;
32 var month = (m < 10) ? '0' + m : m;
33 var yy = date.getYear();
34 var year = (yy < 1000) ? yy + 1900 : yy;
35 var h = date.getHours();
36 var hours = (h < 10) ? '0' + h : h;
37 var mm = date.getMinutes();
38 var minutes = (mm < 10) ? '0' + mm : mm;
39 document.write("Printing Date: "+day + "/" + month + "/" + year +
40 "\t\t" + hours+":" + minutes );
41 </script>
42 </td>
43 <td style="text-align:right;font-size:10;" width="65%">Page <span class="page"/></td><td style="text-align:left;font-size:10;"> of <span class="topage"/></td>
44 </tr>
45 </table>
46 </body>
47</html>]]></field>
48 <field name="orientation">Landscape</field>
49 <field name="format">Letter</field>
50 <field name="html">
51<![CDATA[<html>
52 <head>
53 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
54 <script>
55 function subst() {
56 var vars={};
57 var x=document.location.search.substring(1).split('&');
58 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
59 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
60 for(var i in x) {
61 var y = document.getElementsByClassName(x[i]);
62 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
63 }
64 }
65 </script>
66 <style type="text/css">
67 ${css}
68 </style>
69 </head>
70 <body style="border:0; margin: 0;" onload="subst()">
71 ${_debug or ''|n}
72 </body>
73</html>]]>
74</field>
75 <field eval="0.0" name="margin_top"/>
76 <field name="css" >
77 <![CDATA[
78table.basic_table{
79text-align:left;
80border:1px solid lightGrey;
81border-collapse: collapse;
82}
83
84.dest_address { font-size:12pt;
85margin-left:0;
86text-align:left; l
87ine-height:80%;
88padding-top:0px
89}
90
91.celdaLineData{
92font-size:7pt;
93font-family: monospace;
94text-align:right;
95background-color:#F5F5F5;
96}
97
98.celdaLineDataName{
99font-size:7pt;
100font-family: monospace;
101text-align:left;
102background-color:#F5F5F5;
103}
104
105.celdaLineDataTotal{
106font-size:7pt;
107font-family:Arial,Helvetica,sans-serif;
108text-align:right;
109font-weight:bold;
110background-color:#dcdcdc;
111}
112
113.celdaLineDataNameTotal{
114font-size:7pt;
115font-family:Arial,Helvetica,sans-serif;
116text-align:left;
117font-weight:bold;
118background-color:#dcdcdc;
119}
120
121.celdaLineDataNameJournal{
122font-size:7pt;
123font-family:Arial,Helvetica,sans-serif;
124text-align:left;
125font-weight:bold;
126background-color:#F5F5F5;
127}
128
129.celdaLineDataNamePartner{
130font-size:7pt;
131font-family: monospace;
132text-align:left;
133background-color:#F5F5F5;
134}
135
136.celdaTituloTabla{
137font-size:8pt;
138text-align:left;
139font-family:Arial,Helvetica,sans-serif;
140background-color:#620400;
141font-weight:bold;
142color:#FFFFFF;
143}
144
145div.td_company
146{
147font-size:11pt;
148margin-left:0;
149font-weight:bold;
150font-family:Arial,Helvetica,sans-serif;
151}
152
153div.td_company_date
154{
155font-size:9pt;
156margin-left:0;
157font-weight:bold;
158font-family:Arial,Helvetica,sans-serif;
159}
160
161div.td_company_title
162{
163font-size:15pt;
164margin-left:0;
165font-weight:bold;
166font-family:Arial,Helvetica,sans-serif;
167}
168]]>
169 </field>
170 </record>
171
172 <record id="ir_header_webkit_afrreport_col13" model="ir.header_webkit">
173 <field name="name">Reports AFR WebKit</field>
174 <field name="footer_html">
175<![CDATA[<html>
176 <head>
177 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
178 <script>
179 function subst() {
180 var vars={};
181 var x=document.location.search.substring(1).split('&');
182 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
183 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
184 for(var i in x) {
185 var y = document.getElementsByClassName(x[i]);
186 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
187 }
188 }
189 </script>
190 </head>
191 <body style="border:0; margin: 0;" onload="subst()">
192 <table style="border-top: 1px solid black; width: 100%">
193 <tr>
194 <td style="float:right;text-align:left;font-size:10;" width="30%">
195 <script type="text/javascript">
196 var date = new Date();
197 var d = date.getDate();
198 var day = (d < 10) ? '0' + d : d;
199 var m = date.getMonth() + 1;
200 var month = (m < 10) ? '0' + m : m;
201 var yy = date.getYear();
202 var year = (yy < 1000) ? yy + 1900 : yy;
203 var h = date.getHours();
204 var hours = (h < 10) ? '0' + h : h;
205 var mm = date.getMinutes();
206 var minutes = (mm < 10) ? '0' + mm : mm;
207 document.write("Printing Date: "+day + "/" + month + "/" + year +
208 "\t\t" + hours+":" + minutes );
209 </script>
210 </td>
211 <td style="text-align:right;font-size:10;" width="65%">Page <span class="page"/></td><td style="text-align:left;font-size:10;"> of <span class="topage"/></td>
212 </tr>
213 </table>
214 </body>
215</html>]]></field>
216 <field name="orientation">Landscape</field>
217 <field name="format">Letter</field>
218 <field name="html">
219<![CDATA[<html>
220 <head>
221 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
222 <script>
223 function subst() {
224 var vars={};
225 var x=document.location.search.substring(1).split('&');
226 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
227 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
228 for(var i in x) {
229 var y = document.getElementsByClassName(x[i]);
230 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
231 }
232 }
233 </script>
234 <style type="text/css">
235 ${css}
236 </style>
237 </head>
238 <body style="border:0; margin: 0;" onload="subst()">
239 ${_debug or ''|n}
240 </body>
241</html>]]>
242</field>
243 <field eval="0.0" name="margin_top"/>
244 <field name="css" >
245 <![CDATA[
246table.basic_table{
247text-align:left;
248border:1px solid lightGrey;
249border-collapse: collapse;
250}
251
252.dest_address { font-size:12pt;
253margin-left:0;
254text-align:left; l
255ine-height:80%;
256padding-top:0px
257}
258
259.celdaLineData{
260font-size:4pt;
261font-family: monospace;
262text-align:right;
263background-color:#F5F5F5;
264}
265
266.celdaLineDataName{
267font-size:4pt;
268font-family: monospace;
269text-align:left;
270background-color:#F5F5F5;
271}
272
273.celdaLineDataView{
274font-size:4pt;
275font-family:Arial,Helvetica,sans-serif;
276text-align:right;
277font-weight:bold;
278background-color:#dcdcdc;
279}
280
281.celdaLineDataNameView{
282font-size:4pt;
283font-family:Arial,Helvetica,sans-serif;
284text-align:left;
285font-weight:bold;
286background-color:#dcdcdc;
287}
288
289.celdaLineDataTotal{
290font-size:4pt;
291font-family:Arial,Helvetica,sans-serif;
292text-align:right;
293font-weight:bold;
294background-color:#eaeaea;
295}
296
297.celdaLineDataNameTotal{
298font-size:4pt;
299font-family:Arial,Helvetica,sans-serif;
300text-align:left;
301font-weight:bold;
302background-color:#eaeaea;
303}
304
305.celdaTituloTabla{
306font-size:7pt;
307text-align:left;
308font-family:Arial,Helvetica,sans-serif;
309background-color:#620400;
310font-weight:bold;
311color:#FFFFFF;
312}
313
314
315div.td_company
316{
317font-size:11pt;
318margin-left:0;
319font-weight:bold;
320font-family:Arial,Helvetica,sans-serif;
321}
322
323div.td_company_date
324{
325font-size:9pt;
326margin-left:0;
327font-weight:bold;
328font-family:Arial,Helvetica,sans-serif;
329}
330
331div.td_company_title
332{
333font-size:15pt;
334margin-left:0;
335font-weight:bold;
336font-family:Arial,Helvetica,sans-serif;
337}
338]]>
339 </field>
340 </record>
341
342 <record id="ir_header_webkit_afrreport_qtr" model="ir.header_webkit">
343 <field name="name">Reports AFR WebKit</field>
344 <field name="footer_html">
345<![CDATA[<html>
346 <head>
347 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
348 <script>
349 function subst() {
350 var vars={};
351 var x=document.location.search.substring(1).split('&');
352 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
353 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
354 for(var i in x) {
355 var y = document.getElementsByClassName(x[i]);
356 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
357 }
358 }
359 </script>
360 </head>
361 <body style="border:0; margin: 0;" onload="subst()">
362 <table style="border-top: 1px solid black; width: 100%">
363 <tr>
364 <td style="float:right;text-align:left;font-size:10;" width="30%">
365 <script type="text/javascript">
366 var date = new Date();
367 var d = date.getDate();
368 var day = (d < 10) ? '0' + d : d;
369 var m = date.getMonth() + 1;
370 var month = (m < 10) ? '0' + m : m;
371 var yy = date.getYear();
372 var year = (yy < 1000) ? yy + 1900 : yy;
373 var h = date.getHours();
374 var hours = (h < 10) ? '0' + h : h;
375 var mm = date.getMinutes();
376 var minutes = (mm < 10) ? '0' + mm : mm;
377 document.write("Printing Date: "+day + "/" + month + "/" + year +
378 "\t\t" + hours+":" + minutes );
379 </script>
380 </td>
381 <td style="text-align:right;font-size:10;" width="65%">Page <span class="page"/></td><td style="text-align:left;font-size:10;"> of <span class="topage"/></td>
382 </tr>
383 </table>
384 </body>
385</html>]]></field>
386 <field name="orientation">Landscape</field>
387 <field name="format">Letter</field>
388 <field name="html">
389<![CDATA[<html>
390 <head>
391 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
392 <script>
393 function subst() {
394 var vars={};
395 var x=document.location.search.substring(1).split('&');
396 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
397 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
398 for(var i in x) {
399 var y = document.getElementsByClassName(x[i]);
400 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
401 }
402 }
403 </script>
404 <style type="text/css">
405 ${css}
406 </style>
407 </head>
408 <body style="border:0; margin: 0;" onload="subst()">
409 ${_debug or ''|n}
410 </body>
411</html>]]>
412</field>
413 <field eval="0.0" name="margin_top"/>
414 <field name="css" >
415 <![CDATA[
416table.basic_table{
417text-align:left;
418border:1px solid lightGrey;
419border-collapse: collapse;
420}
421
422.dest_address { font-size:12pt;
423margin-left:0;
424text-align:left; l
425ine-height:80%;
426padding-top:0px
427}
428
429.celdaLineData{
430font-size:5pt;
431font-family: monospace;
432text-align:right;
433background-color:#F5F5F5;
434}
435
436.celdaLineDataName{
437font-size:5pt;
438font-family: monospace;
439text-align:left;
440background-color:#F5F5F5;
441}
442
443.celdaLineDataView{
444font-size:5pt;
445font-family:Arial,Helvetica,sans-serif;
446text-align:right;
447font-weight:bold;
448background-color:#dcdcdc;
449}
450
451.celdaLineDataNameView{
452font-size:5pt;
453font-family:Arial,Helvetica,sans-serif;
454text-align:left;
455font-weight:bold;
456background-color:#dcdcdc;
457}
458
459.celdaLineDataTotal{
460font-size:5pt;
461font-family:Arial,Helvetica,sans-serif;
462text-align:right;
463font-weight:bold;
464background-color:#eaeaea;
465}
466
467.celdaLineDataNameTotal{
468font-size:5pt;
469font-family:Arial,Helvetica,sans-serif;
470text-align:left;
471font-weight:bold;
472background-color:#eaeaea;
473}
474
475.celdaTituloTabla{
476font-size:7pt;
477text-align:left;
478font-family:Arial,Helvetica,sans-serif;
479background-color:#620400;
480font-weight:bold;
481color:#FFFFFF;
482}
483
484div.td_company
485{
486font-size:11pt;
487margin-left:0;
488font-weight:bold;
489font-family:Arial,Helvetica,sans-serif;
490}
491
492div.td_company_date
493{
494font-size:9pt;
495margin-left:0;
496font-weight:bold;
497font-family:Arial,Helvetica,sans-serif;
498}
499
500div.td_company_title
501{
502font-size:15pt;
503margin-left:0;
504font-weight:bold;
505font-family:Arial,Helvetica,sans-serif;
506}
507]]>
508 </field>
509 </record>
510
511 <record id="ir_header_webkit_afrreport_journal_ledger" model="ir.header_webkit">
512 <field name="name">Reports AFR WebKit</field>
513 <field name="footer_html">
514<![CDATA[<html>
515 <head>
516 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
517 <script>
518 function subst() {
519 var vars={};
520 var x=document.location.search.substring(1).split('&');
521 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
522 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
523 for(var i in x) {
524 var y = document.getElementsByClassName(x[i]);
525 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
526 }
527 }
528 </script>
529 </head>
530 <body style="border:0; margin: 0;" onload="subst()">
531 <table style="border-top: 1px solid black; width: 100%">
532 <tr>
533 <td style="float:right;text-align:left;font-size:10;" width="30%">
534 <script type="text/javascript">
535 var date = new Date();
536 var d = date.getDate();
537 var day = (d < 10) ? '0' + d : d;
538 var m = date.getMonth() + 1;
539 var month = (m < 10) ? '0' + m : m;
540 var yy = date.getYear();
541 var year = (yy < 1000) ? yy + 1900 : yy;
542 var h = date.getHours();
543 var hours = (h < 10) ? '0' + h : h;
544 var mm = date.getMinutes();
545 var minutes = (mm < 10) ? '0' + mm : mm;
546 document.write("Printing Date: "+day + "/" + month + "/" + year +
547 "\t\t" + hours+":" + minutes );
548 </script>
549 </td>
550 <td style="text-align:right;font-size:10;" width="65%">Page <span class="page"/></td><td style="text-align:left;font-size:10;"> of <span class="topage"/></td>
551 </tr>
552 </table>
553 </body>
554</html>]]></field>
555 <field name="orientation">Landscape</field>
556 <field name="format">Letter</field>
557 <field name="html">
558<![CDATA[<html>
559 <head>
560 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
561 <script>
562 function subst() {
563 var vars={};
564 var x=document.location.search.substring(1).split('&');
565 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
566 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
567 for(var i in x) {
568 var y = document.getElementsByClassName(x[i]);
569 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
570 }
571 }
572 </script>
573 <style type="text/css">
574 ${css}
575 </style>
576 </head>
577 <body style="border:0; margin: 0;" onload="subst()">
578 ${_debug or ''|n}
579 </body>
580</html>]]>
581</field>
582 <field eval="0.0" name="margin_top"/>
583 <field name="css" >
584 <![CDATA[
585table.basic_table{
586text-align:left;
587border:1px solid lightGrey;
588border-collapse: collapse;
589}
590
591.dest_address { font-size:12pt;
592margin-left:0;
593text-align:left; l
594ine-height:80%;
595padding-top:0px
596}
597
598.celdaLineData{
599font-size:7pt;
600font-family: monospace;
601text-align:right;
602font-weight:bold;
603background-color:#d1d1d1;
604}
605
606.celdaLineDataName{
607font-size:7pt;
608font-family: monospace;
609text-align:left;
610font-weight:bold;
611background-color:#d1d1d1;
612}
613
614.celdaLineDataTotal{
615font-size:7pt;
616font-family:Arial,Helvetica,sans-serif;
617text-align:right;
618font-weight:bold;
619background-color:#dcdcdc;
620}
621
622.celdaLineDataNameTotal{
623font-size:8pt;
624font-family:Arial,Helvetica,sans-serif;
625text-align:left;
626font-weight:bold;
627background-color:#dcdcdc;
628}
629
630.celdaLineDataNamePartner{
631font-size:7pt;
632font-family: monospace;
633text-align:left;
634font-weight:bold;
635background-color:#d1d1d1;
636}
637
638.celdaLineDataAccountSimilar{
639font-size:6pt;
640font-family: monospace;
641text-align:left;
642background-color:#dcdcdc;
643}
644
645.celdaLineDataAccount{
646font-size:6pt;
647font-family: monospace;
648text-align:left;
649background-color:#FFFFFF;
650}
651
652.celdaTituloTabla{
653font-size:8pt;
654text-align:left;
655font-family:Arial,Helvetica,sans-serif;
656background-color:#620400;
657font-weight:bold;
658color:#FFFFFF;
659}
660
661
662div.td_company
663{
664font-size:11pt;
665margin-left:0;
666font-weight:bold;
667font-family:Arial,Helvetica,sans-serif;
668}
669
670div.td_company_date
671{
672font-size:9pt;
673margin-left:0;
674font-weight:bold;
675font-family:Arial,Helvetica,sans-serif;
676}
677
678div.td_company_title
679{
680font-size:15pt;
681margin-left:0;
682font-weight:bold;
683font-family:Arial,Helvetica,sans-serif;
684}
685]]>
686 </field>
687 </record>
688
689
690 <record id="ir_header_webkit_afrreport_four_colums" model="ir.header_webkit">
691 <field name="name">Reports AFR WebKit</field>
692 <field name="footer_html">
693<![CDATA[<html>
694 <head>
695 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
696 <script>
697 function subst() {
698 var vars={};
699 var x=document.location.search.substring(1).split('&');
700 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
701 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
702 for(var i in x) {
703 var y = document.getElementsByClassName(x[i]);
704 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
705 }
706 }
707 </script>
708 </head>
709 <body style="border:0; margin: 0;" onload="subst()">
710 <table style="border-top: 1px solid black; width: 100%">
711 <tr>
712 <td style="float:right;text-align:left;font-size:10;" width="30%">
713 <script type="text/javascript">
714 var date = new Date();
715 var d = date.getDate();
716 var day = (d < 10) ? '0' + d : d;
717 var m = date.getMonth() + 1;
718 var month = (m < 10) ? '0' + m : m;
719 var yy = date.getYear();
720 var year = (yy < 1000) ? yy + 1900 : yy;
721 var h = date.getHours();
722 var hours = (h < 10) ? '0' + h : h;
723 var mm = date.getMinutes();
724 var minutes = (mm < 10) ? '0' + mm : mm;
725 document.write("Printing Date: "+day + "/" + month + "/" + year +
726 "\t\t" + hours+":" + minutes );
727 </script>
728 </td>
729 <td style="text-align:right;font-size:10;" width="65%">Page <span class="page"/></td><td style="text-align:left;font-size:10;"> of <span class="topage"/></td>
730 </tr>
731 </table>
732 </body>
733</html>]]></field>
734 <field name="orientation">Portrait</field>
735 <field name="format">Letter</field>
736 <field name="html">
737<![CDATA[<html>
738 <head>
739 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
740 <script>
741 function subst() {
742 var vars={};
743 var x=document.location.search.substring(1).split('&');
744 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
745 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
746 for(var i in x) {
747 var y = document.getElementsByClassName(x[i]);
748 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
749 }
750 }
751 </script>
752 <style type="text/css">
753 ${css}
754 </style>
755 </head>
756 <body style="border:0; margin: 0;" onload="subst()">
757 ${_debug or ''|n}
758 </body>
759</html>]]>
760</field>
761 <field eval="0.0" name="margin_top"/>
762 <field name="css" >
763 <![CDATA[
764table.basic_table{
765text-align:left;
766border:1px solid lightGrey;
767border-collapse: collapse;
768}
769
770.dest_address { font-size:12pt;
771margin-left:0;
772text-align:left; l
773ine-height:80%;
774padding-top:0px
775}
776
777.celdaLineData{
778font-size:7pt;
779font-family: monospace;
780text-align:right;
781background-color:#F5F5F5;
782}
783
784.celdaLineDataName{
785font-size:7pt;
786font-family: monospace;
787text-align:left;
788background-color:#F5F5F5;
789}
790
791.celdaLineDataView{
792font-size:7pt;
793font-family:Arial,Helvetica,sans-serif;
794text-align:right;
795font-weight:bold;
796background-color:#dcdcdc;
797}
798
799.celdaLineDataNameView{
800font-size:7pt;
801font-family:Arial,Helvetica,sans-serif;
802text-align:left;
803font-weight:bold;
804background-color:#dcdcdc;
805}
806
807.celdaLineDataTotal{
808font-size:7pt;
809font-family:Arial,Helvetica,sans-serif;
810text-align:right;
811font-weight:bold;
812background-color:#eaeaea;
813}
814
815.celdaLineDataNameTotal{
816font-size:7pt;
817font-family:Arial,Helvetica,sans-serif;
818text-align:left;
819font-weight:bold;
820background-color:#eaeaea;
821}
822
823.celdaTituloTabla{
824font-size:9pt;
825text-align:left;
826font-family:Arial,Helvetica,sans-serif;
827background-color:#620400;
828font-weight:bold;
829color:#FFFFFF;
830}
831
832div.td_company
833{
834font-size:11pt;
835margin-left:0;
836font-weight:bold;
837font-family:Arial,Helvetica,sans-serif;
838}
839
840div.td_company_date
841{
842font-size:9pt;
843margin-left:0;
844font-weight:bold;
845font-family:Arial,Helvetica,sans-serif;
846}
847
848div.td_company_title
849{
850font-size:15pt;
851margin-left:0;
852font-weight:bold;
853font-family:Arial,Helvetica,sans-serif;
854}
855]]>
856 </field>
857 </record>
858
859 <record id="ir_header_webkit_afrreport_two_colums" model="ir.header_webkit">
860 <field name="name">Reports AFR WebKit</field>
861 <field name="footer_html">
862<![CDATA[<html>
863 <head>
864 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
865 <script>
866 function subst() {
867 var vars={};
868 var x=document.location.search.substring(1).split('&');
869 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
870 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
871 for(var i in x) {
872 var y = document.getElementsByClassName(x[i]);
873 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
874 }
875 }
876 </script>
877 </head>
878 <body style="border:0; margin: 0;" onload="subst()">
879 <table style="border-top: 1px solid black; width: 100%">
880 <tr>
881 <td style="float:right;text-align:left;font-size:10;" width="30%">
882 <script type="text/javascript">
883 var date = new Date();
884 var d = date.getDate();
885 var day = (d < 10) ? '0' + d : d;
886 var m = date.getMonth() + 1;
887 var month = (m < 10) ? '0' + m : m;
888 var yy = date.getYear();
889 var year = (yy < 1000) ? yy + 1900 : yy;
890 var h = date.getHours();
891 var hours = (h < 10) ? '0' + h : h;
892 var mm = date.getMinutes();
893 var minutes = (mm < 10) ? '0' + mm : mm;
894 document.write("Printing Date: "+day + "/" + month + "/" + year +
895 "\t\t" + hours+":" + minutes );
896 </script>
897 </td>
898 <td style="text-align:right;font-size:10;" width="65%">Page <span class="page"/></td><td style="text-align:left;font-size:10;"> of <span class="topage"/></td>
899 </tr>
900 </table>
901 </body>
902</html>]]></field>
903 <field name="orientation">Portrait</field>
904 <field name="format">Letter</field>
905 <field name="html">
906<![CDATA[<html>
907 <head>
908 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
909 <script>
910 function subst() {
911 var vars={};
912 var x=document.location.search.substring(1).split('&');
913 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
914 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
915 for(var i in x) {
916 var y = document.getElementsByClassName(x[i]);
917 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
918 }
919 }
920 </script>
921 <style type="text/css">
922 ${css}
923 </style>
924 </head>
925 <body style="border:0; margin: 0;" onload="subst()">
926 ${_debug or ''|n}
927 </body>
928</html>]]>
929</field>
930 <field eval="0.0" name="margin_top"/>
931 <field name="css" >
932 <![CDATA[
933table.basic_table{
934text-align:left;
935border:1px solid lightGrey;
936border-collapse: collapse;
937}
938
939.dest_address { font-size:12pt;
940margin-left:0;
941text-align:left; l
942ine-height:80%;
943padding-top:0px
944}
945
946.celdaLineData{
947font-size:9pt;
948font-family: monospace;
949text-align:right;
950background-color:#F5F5F5;
951}
952
953.celdaLineDataName{
954font-size:9pt;
955font-family: monospace;
956text-align:left;
957background-color:#F5F5F5;
958}
959
960.celdaLineDataView{
961font-size:9pt;
962font-family:Arial,Helvetica,sans-serif;
963text-align:right;
964font-weight:bold;
965background-color:#dcdcdc;
966}
967
968.celdaLineDataNameView{
969font-size:9pt;
970font-family:Arial,Helvetica,sans-serif;
971text-align:left;
972font-weight:bold;
973background-color:#dcdcdc;
974}
975
976.celdaLineDataTotal{
977font-size:9pt;
978font-family:Arial,Helvetica,sans-serif;
979text-align:right;
980font-weight:bold;
981background-color:#eaeaea;
982}
983
984.celdaLineDataNameTotal{
985font-size:9pt;
986font-family:Arial,Helvetica,sans-serif;
987text-align:left;
988font-weight:bold;
989background-color:#eaeaea;
990}
991
992.celdaTituloTabla{
993font-size:11pt;
994text-align:left;
995font-family:Arial,Helvetica,sans-serif;
996background-color:#620400;
997font-weight:bold;
998color:#FFFFFF;
999}
1000
1001div.td_company
1002{
1003font-size:11pt;
1004margin-left:0;
1005font-weight:bold;
1006font-family:Arial,Helvetica,sans-serif;
1007}
1008
1009div.td_company_date
1010{
1011font-size:9pt;
1012margin-left:0;
1013font-weight:bold;
1014font-family:Arial,Helvetica,sans-serif;
1015}
1016
1017div.td_company_title
1018{
1019font-size:15pt;
1020margin-left:0;
1021font-weight:bold;
1022font-family:Arial,Helvetica,sans-serif;
1023}
1024]]>
1025 </field>
1026 </record>
1027
1028 <record id="ir_header_webkit_afrreport_one_colums" model="ir.header_webkit">
1029 <field name="name">Reports AFR WebKit</field>
1030 <field name="footer_html">
1031<![CDATA[<html>
1032 <head>
1033 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
1034 <script>
1035 function subst() {
1036 var vars={};
1037 var x=document.location.search.substring(1).split('&');
1038 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
1039 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
1040 for(var i in x) {
1041 var y = document.getElementsByClassName(x[i]);
1042 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
1043 }
1044 }
1045 </script>
1046 </head>
1047 <body style="border:0; margin: 0;" onload="subst()">
1048 <table style="border-top: 1px solid black; width: 100%">
1049 <tr>
1050 <td style="float:right;text-align:left;font-size:10;" width="30%">
1051 <script type="text/javascript">
1052 var date = new Date();
1053 var d = date.getDate();
1054 var day = (d < 10) ? '0' + d : d;
1055 var m = date.getMonth() + 1;
1056 var month = (m < 10) ? '0' + m : m;
1057 var yy = date.getYear();
1058 var year = (yy < 1000) ? yy + 1900 : yy;
1059 var h = date.getHours();
1060 var hours = (h < 10) ? '0' + h : h;
1061 var mm = date.getMinutes();
1062 var minutes = (mm < 10) ? '0' + mm : mm;
1063 document.write("Printing Date: "+day + "/" + month + "/" + year +
1064 "\t\t" + hours+":" + minutes );
1065 </script>
1066 </td>
1067 <td style="text-align:right;font-size:10;" width="65%">Page <span class="page"/></td><td style="text-align:left;font-size:10;"> of <span class="topage"/></td>
1068 </tr>
1069 </table>
1070 </body>
1071</html>]]></field>
1072 <field name="orientation">Portrait</field>
1073 <field name="format">Letter</field>
1074 <field name="html">
1075<![CDATA[<html>
1076 <head>
1077 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
1078 <script>
1079 function subst() {
1080 var vars={};
1081 var x=document.location.search.substring(1).split('&');
1082 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
1083 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
1084 for(var i in x) {
1085 var y = document.getElementsByClassName(x[i]);
1086 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
1087 }
1088 }
1089 </script>
1090 <style type="text/css">
1091 ${css}
1092 </style>
1093 </head>
1094 <body style="border:0; margin: 0;" onload="subst()">
1095 ${_debug or ''|n}
1096 </body>
1097</html>]]>
1098</field>
1099 <field eval="0.0" name="margin_top"/>
1100 <field name="css" >
1101 <![CDATA[
1102table.basic_table{
1103text-align:left;
1104border:1px solid lightGrey;
1105border-collapse: collapse;
1106}
1107
1108.dest_address { font-size:12pt;
1109margin-left:0;
1110text-align:left; l
1111ine-height:80%;
1112padding-top:0px
1113}
1114
1115.celdaLineData{
1116font-size:9pt;
1117font-family: monospace;
1118text-align:right;
1119background-color:#F5F5F5;
1120}
1121
1122.celdaLineDataName{
1123font-size:9pt;
1124font-family: monospace;
1125text-align:left;
1126background-color:#F5F5F5;
1127}
1128
1129.celdaLineDataView{
1130font-size:9pt;
1131font-family:Arial,Helvetica,sans-serif;
1132text-align:right;
1133font-weight:bold;
1134background-color:#dcdcdc;
1135}
1136
1137.celdaLineDataNameView{
1138font-size:9pt;
1139font-family:Arial,Helvetica,sans-serif;
1140text-align:left;
1141font-weight:bold;
1142background-color:#dcdcdc;
1143}
1144
1145.celdaLineDataTotal{
1146font-size:9pt;
1147font-family:Arial,Helvetica,sans-serif;
1148text-align:right;
1149font-weight:bold;
1150background-color:#eaeaea;
1151}
1152
1153.celdaLineDataNameTotal{
1154font-size:9pt;
1155font-family:Arial,Helvetica,sans-serif;
1156text-align:left;
1157font-weight:bold;
1158background-color:#eaeaea;
1159}
1160
1161.celdaTituloTabla{
1162font-size:11pt;
1163text-align:left;
1164font-family:Arial,Helvetica,sans-serif;
1165background-color:#620400;
1166font-weight:bold;
1167color:#FFFFFF;
1168}
1169
1170div.td_company
1171{
1172font-size:11pt;
1173margin-left:0;
1174font-weight:bold;
1175font-family:Arial,Helvetica,sans-serif;
1176}
1177
1178div.td_company_date
1179{
1180font-size:9pt;
1181margin-left:0;
1182font-weight:bold;
1183font-family:Arial,Helvetica,sans-serif;
1184}
1185
1186div.td_company_title
1187{
1188font-size:15pt;
1189margin-left:0;
1190font-weight:bold;
1191font-family:Arial,Helvetica,sans-serif;
1192}
1193]]>
1194 </field>
1195 </record>
1196
1197 <record id="ir_header_webkit_afrreport_five_colums" model="ir.header_webkit">
1198 <field name="name">Reports AFR WebKit Five Columns</field>
1199 <field name="footer_html">
1200<![CDATA[<html>
1201 <head>
1202 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
1203 <script>
1204 function subst() {
1205 var vars={};
1206 var x=document.location.search.substring(1).split('&');
1207 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
1208 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
1209 for(var i in x) {
1210 var y = document.getElementsByClassName(x[i]);
1211 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
1212 }
1213 }
1214 </script>
1215 </head>
1216 <body style="border:0; margin: 0;" onload="subst()">
1217 <table style="border-top: 1px solid black; width: 100%">
1218 <tr>
1219 <td style="float:right;text-align:left;font-size:10;" width="30%">
1220 <script type="text/javascript">
1221 var date = new Date();
1222 var d = date.getDate();
1223 var day = (d < 10) ? '0' + d : d;
1224 var m = date.getMonth() + 1;
1225 var month = (m < 10) ? '0' + m : m;
1226 var yy = date.getYear();
1227 var year = (yy < 1000) ? yy + 1900 : yy;
1228 var h = date.getHours();
1229 var hours = (h < 10) ? '0' + h : h;
1230 var mm = date.getMinutes();
1231 var minutes = (mm < 10) ? '0' + mm : mm;
1232 document.write("Printing Date: "+day + "/" + month + "/" + year +
1233 "\t\t" + hours+":" + minutes );
1234 </script>
1235 </td>
1236 <td style="text-align:right;font-size:10;" width="65%">Page <span class="page"/></td><td style="text-align:left;font-size:10;"> of <span class="topage"/></td>
1237 </tr>
1238 </table>
1239 </body>
1240</html>]]></field>
1241 <field name="orientation">Portrait</field>
1242 <field name="format">Letter</field>
1243 <field name="html">
1244<![CDATA[<html>
1245 <head>
1246 <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
1247 <script>
1248 function subst() {
1249 var vars={};
1250 var x=document.location.search.substring(1).split('&');
1251 for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
1252 var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
1253 for(var i in x) {
1254 var y = document.getElementsByClassName(x[i]);
1255 for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
1256 }
1257 }
1258 </script>
1259 <style type="text/css">
1260 ${css}
1261 </style>
1262 </head>
1263 <body style="border:0; margin: 0;" onload="subst()">
1264 ${_debug or ''|n}
1265 </body>
1266</html>]]>
1267</field>
1268 <field eval="0.0" name="margin_top"/>
1269 <field name="css" >
1270 <![CDATA[
1271table.basic_table{
1272text-align:left;
1273border:1px solid lightGrey;
1274border-collapse: collapse;
1275}
1276
1277.dest_address { font-size:12pt;
1278margin-left:0;
1279text-align:left; l
1280ine-height:80%;
1281padding-top:0px
1282}
1283
1284.celdaLineData{
1285font-size:7pt;
1286font-family: monospace;
1287text-align:right;
1288background-color:#F5F5F5;
1289}
1290
1291.celdaLineDataName{
1292font-size:7pt;
1293font-family: monospace;
1294text-align:left;
1295background-color:#F5F5F5;
1296}
1297
1298.celdaLineDataView{
1299font-size:7pt;
1300font-family:Arial,Helvetica,sans-serif;
1301text-align:right;
1302font-weight:bold;
1303background-color:#dcdcdc;
1304}
1305
1306.celdaLineDataNameView{
1307font-size:7pt;
1308font-family:Arial,Helvetica,sans-serif;
1309text-align:left;
1310font-weight:bold;
1311background-color:#dcdcdc;
1312}
1313
1314.celdaLineDataTotal{
1315font-size:7pt;
1316font-family:Arial,Helvetica,sans-serif;
1317text-align:right;
1318font-weight:bold;
1319background-color:#eaeaea;
1320}
1321
1322.celdaLineDataNameTotal{
1323font-size:7pt;
1324font-family:Arial,Helvetica,sans-serif;
1325text-align:left;
1326font-weight:bold;
1327background-color:#eaeaea;
1328}
1329
1330.celdaTituloTabla{
1331font-size:9pt;
1332text-align:left;
1333font-family:Arial,Helvetica,sans-serif;
1334background-color:#620400;
1335font-weight:bold;
1336color:#FFFFFF;
1337}
1338
1339div.td_company
1340{
1341font-size:11pt;
1342margin-left:0;
1343font-weight:bold;
1344font-family:Arial,Helvetica,sans-serif;
1345}
1346
1347div.td_company_date
1348{
1349font-size:9pt;
1350margin-left:0;
1351font-weight:bold;
1352font-family:Arial,Helvetica,sans-serif;
1353}
1354
1355div.td_company_title
1356{
1357font-size:15pt;
1358margin-left:0;
1359font-weight:bold;
1360font-family:Arial,Helvetica,sans-serif;
1361}
1362]]>
1363 </field>
1364 </record>
1365
1366 <record id="ir_header_img_companylogo0" model="ir.header_img">
1367 <field eval="&quot;&quot;&quot;jpg&quot;&quot;&quot;" name="type"/>
1368 <field eval="&quot;&quot;&quot;company_logo&quot;&quot;&quot;" name="name"/>
1369 </record>
1370
1371 </data>
1372</openerp>
01373
=== 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 @@
1# Translation of OpenERP Server.
2# This file contains the translation of the following modules:
3# * account_financial_report_exportable
4#
5msgid ""
6msgstr ""
7"Project-Id-Version: OpenERP Server 7.0\n"
8"Report-Msgid-Bugs-To: \n"
9"POT-Creation-Date: 2013-10-21 19:57+0000\n"
10"PO-Revision-Date: 2013-10-21 14:58-0600\n"
11"Last-Translator: <>\n"
12"Language-Team: \n"
13"MIME-Version: 1.0\n"
14"Content-Type: text/plain; charset=UTF-8\n"
15"Content-Transfer-Encoding: 8bit\n"
16"Plural-Forms: \n"
17
18#. module: account_financial_report_exportable
19#: model:ir.model,name:account_financial_report_exportable.model_wizard_report
20msgid "wizard.report"
21msgstr "wizard.report"
22
23#. module: account_financial_report_exportable
24#: selection:wizard.report,report_format:0
25msgid "PDF"
26msgstr "PDF"
27
28#. module: account_financial_report_exportable
29#: field:wizard.report,report_format:0
30msgid "Report Format"
31msgstr "Formato del Reporte"
32
33#. module: account_financial_report_exportable
34#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger
35#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger_html
36#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1
37#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13
38#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13_html
39#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1_html
40#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2
41#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2_html
42#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4
43#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4_html
44#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5
45#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5_html
46#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger
47#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger_html
48#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr
49#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr_html
50msgid "Print AFR"
51msgstr "Imprimir AFR"
52
53#. module: account_financial_report_exportable
54#: selection:wizard.report,report_format:0
55msgid "Spreadsheet"
56msgstr "Hoja de Calculo"
57
058
=== 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 @@
1# Translation of OpenERP Server.
2# This file contains the translation of the following modules:
3# * account_financial_report_exportable
4#
5msgid ""
6msgstr ""
7"Project-Id-Version: OpenERP Server 7.0\n"
8"Report-Msgid-Bugs-To: \n"
9"POT-Creation-Date: 2013-10-21 19:57+0000\n"
10"PO-Revision-Date: 2013-10-21 14:58-0600\n"
11"Last-Translator: <>\n"
12"Language-Team: \n"
13"MIME-Version: 1.0\n"
14"Content-Type: text/plain; charset=UTF-8\n"
15"Content-Transfer-Encoding: 8bit\n"
16"Plural-Forms: \n"
17
18#. module: account_financial_report_exportable
19#: model:ir.model,name:account_financial_report_exportable.model_wizard_report
20msgid "wizard.report"
21msgstr "wizard.report"
22
23#. module: account_financial_report_exportable
24#: selection:wizard.report,report_format:0
25msgid "PDF"
26msgstr "PDF"
27
28#. module: account_financial_report_exportable
29#: field:wizard.report,report_format:0
30msgid "Report Format"
31msgstr "Formato del Reporte"
32
33#. module: account_financial_report_exportable
34#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger
35#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger_html
36#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1
37#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13
38#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13_html
39#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1_html
40#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2
41#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2_html
42#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4
43#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4_html
44#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5
45#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5_html
46#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger
47#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger_html
48#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr
49#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr_html
50msgid "Print AFR"
51msgstr "Imprimir AFR"
52
53#. module: account_financial_report_exportable
54#: selection:wizard.report,report_format:0
55msgid "Spreadsheet"
56msgstr "Hoja de Calculo"
57
058
=== 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 @@
1#!/usr/bin/python
2# -*- encoding: utf-8 -*-
3###############################################################################
4# Module Writen to OpenERP, Open Source Management Solution
5# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
6# All Rights Reserved
7############# Credits #########################################################
8# Coded by: Yanina Aular <yani@vauxoo.com>
9# Planified by: Humberto Arocha <hbto@vauxoo.com>
10# Audited by: Humberto Arocha <hbto@vauxoo.com>
11###############################################################################
12# This program is free software: you can redistribute it and/or modify
13# it under the terms of the GNU Affero General Public License as published
14# by the Free Software Foundation, either version 3 of the License, or
15# (at your option) any later version.
16#
17# This program is distributed in the hope that it will be useful,
18# but WITHOUT ANY WARRANTY; without even the implied warranty of
19# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20# GNU Affero General Public License for more details.
21#
22# You should have received a copy of the GNU Affero General Public License
23# along with this program. If not, see <http://www.gnu.org/licenses/>.
24###############################################################################
25
026
=== 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 @@
1#!/usr/bin/python
2# -*- encoding: utf-8 -*-
3###############################################################################
4# Module Writen to OpenERP, Open Source Management Solution
5# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
6# All Rights Reserved
7############# Credits #########################################################
8# Coded by: Yanina Aular <yani@vauxoo.com>
9# Planified by: Humberto Arocha <hbto@vauxoo.com>
10# Audited by: Humberto Arocha <hbto@vauxoo.com>
11###############################################################################
12# This program is free software: you can redistribute it and/or modify
13# it under the terms of the GNU Affero General Public License as published
14# by the Free Software Foundation, either version 3 of the License, or
15# (at your option) any later version.
16#
17# This program is distributed in the hope that it will be useful,
18# but WITHOUT ANY WARRANTY; without even the implied warranty of
19# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20# GNU Affero General Public License for more details.
21#
22# You should have received a copy of the GNU Affero General Public License
23# along with this program. If not, see <http://www.gnu.org/licenses/>.
24###############################################################################
25
026
=== 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 @@
1<!DOCTYPE html SYSTEM
2"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3<html xmlns="http://www.w3.org/1999/xhtml">
4<head>
5<style type="text/css">
6 ${css}
7</style>
8</head>
9
10<body style="border:0; margin: 0;" onload="subst()" >
11%for obj in objects:
12<table width="100%">
13 <tr>
14 <td>
15 <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
16 </td>
17 <td>
18 <table style="width: 100%; text-align:center;">
19 <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
20 <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
21 <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
22 <tr><td><div class="td_company">${_(Expressed in data['form'] and (' %s'% obj.get_parser_method('exchange_name',data['form'])) or '')}</div></td></tr>
23 <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
24 </table>
25 </td>
26 </tr>
27</table>
28
29<table width="100%">
30 <thead>
31 <tr>
32 <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
33 </tr>
34 </thead>
35</table>
36<table width="100%">
37 <thead>
38 <tr>
39 <td class="celdaTituloTabla" style="text-align:right" width="10%">${_('CODE')}</td>
40 <td class="celdaTituloTabla" width="50%">${_('ACCOUNT')}</td>
41 <td class="celdaTituloTabla" width="10%" style="text-align:center;" >${_('INICIAL')}</td>
42 <td class="celdaTituloTabla" width="10%" style="text-align:center;" >${_('DEBIT')}</td>
43 <td class="celdaTituloTabla" width="10%" style="text-align:center;" >${_('CREDIT')}</td>
44 <td class="celdaTituloTabla" width="10%" style="text-align:center;" >${_('BALANCE')}</td>
45 </tr>
46 </thead>
47</table>
48<table width="100%">
49 <thead>
50 <tr>
51 <td class="celdaTituloTabla" style="text-align:left;" width="10%">${_('DATE')}</td>
52 <td class="celdaTituloTabla" width="10%">${_('PERIOD')}</td>
53 <td class="celdaTituloTabla" width="30%">${_('REFERENCE')}</td>
54 <td class="celdaTituloTabla" width="30%">${_('JOURNAL ENTRY')}</td>
55 <td class="celdaTituloTabla" width="10%">${_('PARTNER')}</td>
56 <td class="celdaTituloTabla" width="10%" ></td>
57 </tr>
58 </thead>
59</table>
60<table width="100%">
61 <tr>
62 <td width="10%"></td>
63 <td width="10%"></td>
64 <td width="10%"></td>
65 <td width="10%"></td>
66 <td width="10%"></td>
67 <td width="10%"></td>
68 <td width="10%"></td>
69 <td width="10%"></td>
70 <td width="10%"></td>
71 <td width="10%"></td>
72 </tr>
73 %for line in obj.get_parser_method('lines',data['form']):
74 %if line['type']!= 'view':
75 <tbody>
76 <tr>
77 <td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td>
78 <td class="celdaLineDataNameTotal" colspan="5">${line['name'].upper() or line['name'].title() or ''}</td>
79 <td class="celdaLineDataTotal" width="10%" style="text-align:right;">${formatLang(line['balanceinit'] and line['balanceinit'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
80 <td class="celdaLineDataTotal" width="10%" style="text-align:right;">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
81 <td class="celdaLineDataTotal" width="10%" style="text-align:right;">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
82 <td class="celdaLineDataTotal" width="10%" style="text-align:right;">${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
83 </tr>
84 </tbody>
85 %for m in line['mayor']:
86 <tbody>
87 <tr>
88 <td class="celdaLineData" style="text-align:left;font-style:italic;" width="10%">${formatLang( m['date'], date=True) or ''}</td>
89 <td class="celdaLineData" style="text-align:left;" width="10%">${m['period'] or ''}</td>
90 <td class="celdaLineDataNamePartner" colspan="3">${m['name'] or ''} ${m['ref'] and (' - Ref %s'%m['ref']) or ''}</td>
91 <td class="celdaLineDataNamePartner" colspan="3">${m['entry'] or ''}</td>
92 <td class="celdaLineDataNamePartner" width="10%">${m['partner'] or ''}</td>
93 <td class="celdaLineData" width="10%"></td>
94 </tr>
95 </tbody>
96 %endfor
97 %endif
98 %endfor
99</table>
100
101%endfor
102</body>
103</html>
0104
=== 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 @@
1<!DOCTYPE html SYSTEM
2"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3<html xmlns="http://www.w3.org/1999/xhtml">
4<head>
5<style type="text/css">
6 ${css}
7</style>
8</head>
9
10<body style="border:0; margin: 0;" onload="subst()" >
11 %for obj in objects:
12 <table>
13 <tr>
14 <td width="30%">
15 <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
16 </td>
17 <td width="70%">
18 <table style="width: 100%; text-align:center;">
19 <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
20 <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
21 <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
22 <tr><td><div class="td_company">${_(Expressed in data['form'] and (' %s'% obj.get_parser_method('exchange_name',data['form'])) or '')}</div></td></tr>
23 <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
24 </table>
25 </td>
26 <td>
27 </td>
28 </tr>
29 </table>
30 <table width="100%">
31 <thead>
32 <tr>
33 <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
34 </tr>
35 </thead>
36 </table>
37 <table width="100%">
38 <tbody>
39 <tr class="prueba">
40 <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('CODE')}</td>
41 <td class="celdaTituloTabla" width="70%">${_('ACCOUNT')}</td>
42 <center>
43 <td class="celdaTituloTabla" style="text-align:center;" width="20%">${_('BALANCE')}</td>
44 </center>
45 </tr>
46 %for line in obj.get_parser_method('lines',data['form']):
47 %if line['type'] != 'view':
48 <tr class="prueba">
49 <i><td class="celdaLineData" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
50 <td class="celdaLineDataName" width="70%">${line['name'].upper() or line['name'].title() or ''}</td>
51 <td class="celdaLineData" width="20%">${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
52 </tr>
53 %elif line['total'] and not line['label']:
54 <tr class="prueba">
55 <i><td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="10%">${(line['label'] == True ) and line['code'] or ''}</td></i>
56 <td class="celdaLineDataTotal" style="text-align:right;" width="70%">${(line['type'] == 'view') and line['name'].upper() or line['name'].title() or ''}</td>
57 <td class="celdaLineDataTotal" width="20%">${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
58 </tr>
59 %else:
60 <tr class="prueba">
61 <i><td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="10%">${(line['label'] == True ) and line['code'] or ''}</td></i>
62 <td class="celdaLineDataNameView" width="70%">${line['name'].upper() or line['name'].title() or ''}</td>
63 <td class="celdaLineDataView" width="20%">${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
64 </tr>
65 %endif
66 %endfor
67 </tbody>
68 </table>
69 %endfor
70</body>
71</html>
072
=== 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 @@
1<!DOCTYPE html SYSTEM
2"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3<html xmlns="http://www.w3.org/1999/xhtml">
4<head>
5<style type="text/css">
6 ${css}
7</style>
8</head>
9
10<body style="border:0; margin: 0;" onload="subst()" >
11<!--
12<h1><center>12 Months | YTD</center></h1>
13-->
14 %for obj in objects:
15 <table>
16 <tr>
17 <td width="30%">
18 <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
19 </td>
20 <td width="70%">
21 <table style="width: 100%; text-align:center;">
22 <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
23 <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
24 <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
25 <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
26 </table>
27 </td>
28 </tr>
29 </table>
30 <table width="100%">
31 <thead>
32 <tr>
33 <td class="celdaTituloTabla" style="width: 100%; text-align:left;" colspan="15">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
34 </tr>
35 </thead>
36 <tbody>
37 <tr class="prueba">
38 <td class="celdaTituloTabla" style="text-align:right;" width="6%">${_('CODE')}</td>
39 <td class="celdaTituloTabla" width="16%">${_('ACCOUNT')}</td>
40 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('01')}</td>
41 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('02')}</td>
42 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('03')}</td>
43 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('04')}</td>
44 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('05')}</td>
45 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('06')}</td>
46 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('07')}</td>
47 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('08')}</td>
48 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('09')}</td>
49 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('10')}</td>
50 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('11')}</td>
51 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('12')}</td>
52 <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('YTD')}</td>
53 </tr>
54 %for line in obj.get_parser_method('lines',data['form']):
55 %if line['type'] != 'view':
56 <tr>
57 <td class="celdaLineData" style="text-align:right;font-style:italic;" width="6%">${line['code'] or ''}</td>
58 <td class="celdaLineDataName" width="16%">${line['name'].upper() or line['name'].title() or ''}</td>
59 <td class="celdaLineData" width="6%">${formatLang(line['bal1'] and line['bal1'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
60 <td class="celdaLineData" width="6%">${formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
61 <td class="celdaLineData" width="6%">${formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
62 <td class="celdaLineData" width="6%">${formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
63 <td class="celdaLineData" width="6%">${formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
64 <td class="celdaLineData" width="6%">${formatLang(line['bal6'] and line['bal6'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
65 <td class="celdaLineData" width="6%">${formatLang(line['bal7'] and line['bal7'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
66 <td class="celdaLineData" width="6%">${formatLang(line['bal8'] and line['bal8'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
67 <td class="celdaLineData" width="6%">${formatLang(line['bal9'] and line['bal9'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
68 <td class="celdaLineData" width="6%">${formatLang(line['bal10'] and line['bal10'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
69 <td class="celdaLineData" width="6%">${formatLang(line['bal11'] and line['bal11'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
70 <td class="celdaLineData" width="6%">${formatLang(line['bal12'] and line['bal12'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
71 <td class="celdaLineData" width="6%">${formatLang(line['bal13'] and line['bal13'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
72 </tr>
73 %elif line['total'] and not line['label']:
74 <tr>
75 <td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="6%">${line['code'] or ''}</td>
76 <td class="celdaLineDataTotal" width="16%">${line['name'].upper() or line['name'].title() or ''}</td>
77 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal1'] and line['bal1'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
78 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
79 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
80 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
81 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
82 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal6'] and line['bal6'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
83 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal7'] and line['bal7'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
84 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal8'] and line['bal8'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
85 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal9'] and line['bal9'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
86 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal10'] and line['bal10'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
87 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal11'] and line['bal11'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
88 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal12'] and line['bal12'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
89 <td class="celdaLineDataTotal" width="6%">${formatLang(line['bal13'] and line['bal13'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
90 </tr>
91 %else:
92 <tr>
93 <td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="6%">${line['code'] or ''}</td>
94 <td class="celdaLineDataNameView" colspan="14">${line['name'].upper() or line['name'].title() or ''}</td>
95 </tr>
96 %endif
97 %endfor
98 </tbody>
99 </table>
100%endfor
101</body>
102</html>
0103
=== 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 @@
1<!DOCTYPE html SYSTEM
2"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3<html xmlns="http://www.w3.org/1999/xhtml">
4<head>
5<style type="text/css">
6 ${css}
7</style>
8</head>
9
10<body style="border:0; margin: 0;" onload="subst()" >
11
12<!--
13 <h1><center>Debit | Credit</center></h1>
14-->
15 %for obj in objects:
16 <table>
17 <tr>
18 <td width="30%">
19 <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
20 </td>
21 <td width="70%">
22 <table style="width: 100%; text-align:center;">
23 <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
24 <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
25 <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
26 <tr><td><div class="td_company">${_(Expressed in data['form'] and (' %s'% obj.get_parser_method('exchange_name',data['form'])) or '')}</div></td></tr>
27 <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
28 </table>
29 </td>
30 <td>
31 </td>
32 </tr>
33 </table>
34 <table width="100%">
35 <thead>
36 <tr>
37 <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
38 </tr>
39 </thead>
40 </table>
41 <table width="100%">
42 <tbody>
43 <tr class="prueba">
44 <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('CODE')}</td>
45 <td class="celdaTituloTabla" width="50%">${_('ACCOUNT')}</td>
46 <center>
47 <td class="celdaTituloTabla" style="text-align:center;" width="20%">${_('DEBIT')}</td>
48 <td class="celdaTituloTabla" style="text-align:center;" width="20%">${_('CREDIT')}</td>
49 </center>
50 </tr>
51 %for line in obj.get_parser_method('lines',data['form']):
52
53 %if line['type'] != 'view':
54 <tr class="prueba">
55 <i><td class="celdaLineData" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
56 <td class="celdaLineDataName" width="50%">${line['name'].upper() or line['name'].title() or ''}</td>
57 <td class="celdaLineData" width="20%">${formatLang(line['debit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
58 <td class="celdaLineData" width="20%">${formatLang(line['credit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
59 </tr>
60 %elif line['total'] and not line['label']:
61 <tr class="prueba">
62 <i><td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
63 <td class="celdaLineDataTotal" style="text-align:right;" width="50%">${line['name'].upper() or line['name'].title() or ''}</td>
64 <td class="celdaLineDataTotal" width="20%">${formatLang(line['debit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
65 <td class="celdaLineDataTotal" width="20%">${formatLang(line['credit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
66 </tr>
67 %else:
68 <tr class="prueba">
69 <i><td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="10%">${(line['label'] == True ) and line['code'] or ''}</td></i>
70 <td class="celdaLineDataNameView" width="50%">${line['name'].upper() or line['name'].title() or ''}</td>
71 <td class="celdaLineDataView" width="20%">${formatLang(line['debit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
72 <td class="celdaLineDataView" width="20%">${formatLang(line['credit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
73 </tr>
74 %endif
75 %endfor
76 </tbody>
77 </table>
78 %endfor
79</body>
80</html>
081
=== 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 @@
1<!DOCTYPE html SYSTEM
2"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3<html xmlns="http://www.w3.org/1999/xhtml">
4<head>
5<style type="text/css">
6 ${css}
7</style>
8</head>
9
10<body style="border:0; margin: 0;" onload="subst()" >
11
12
13<!--
14 <h1><center>Initial | Debit | Credit | YTD</center></h1>
15-->
16 %for obj in objects:
17 <table>
18 <tr>
19 <td width="30%">
20 <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
21 </td>
22 <td width="70%">
23 <table style="width: 100%; text-align:center;">
24 <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
25 <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
26 <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
27 <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
28 </table>
29 </td>
30 <td>
31 </td>
32 </tr>
33 </table>
34 <table width="100%">
35 <thead>
36 <tr>
37 <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
38 </tr>
39 </thead>
40 </table>
41 <table width="100%">
42 <tbody>
43 <tr>
44 <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('CODE')}</td>
45 <td class="celdaTituloTabla" width="42%">${_('ACCOUNT')}</td>
46 <td class="celdaTituloTabla" style="text-align:center;" width="12%">${_('INICIAL')}</td>
47 <td class="celdaTituloTabla" style="text-align:center;" width="12%">${_('DEBIT')}</td>
48 <td class="celdaTituloTabla" style="text-align:center;" width="12%">${_('CREDIT')}</td>
49 <td class="celdaTituloTabla" style="text-align:center;" width="12%">${_('BALANCE')}</td>
50 </tr>
51 %for line in obj.get_parser_method('lines',data['form']):
52 %if line['type'] != 'view':
53 <tr>
54 <i><td class="celdaLineData" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
55 <td class="celdaLineDataName" width="42%">${line['name'].upper() or line['name'].title() or ''}</td>
56 <td class="celdaLineData" width="12%">${formatLang(line['balanceinit'] and line['balanceinit'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
57 <td class="celdaLineData" width="12%">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
58 <td class="celdaLineData" width="12%">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
59 <td class="celdaLineData" width="12%">${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
60 </tr>
61 %elif line['total'] and not line['label']:
62 <tr>
63 <i><td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
64 <td class="celdaLineDataTotal" style="text-align:right;" width="42%">${line['name'].upper() or line['name'].title() or ''}</td>
65 <td class="celdaLineDataTotal" width="12%">${formatLang(line['balanceinit'] and line['balanceinit'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
66 <td class="celdaLineDataTotal" width="12%">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
67 <td class="celdaLineDataTotal" width="12%">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
68 <td class="celdaLineDataTotal" width="12%">${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
69 </tr>
70 %else:
71 <tr>
72 <td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td>
73 <td class="celdaLineDataNameView" width="42%">${line['name'].upper() or line['name'].title() or ''}</td>
74 <td class="celdaLineDataView" width="12%">${formatLang(line['balanceinit'] and line['balanceinit'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
75 <td class="celdaLineDataView" width="12%">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
76 <td class="celdaLineDataView" width="12%">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
77 <td class="celdaLineDataView" width="12%">${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
78 </tr>
79 %endif
80 %endfor
81 </tbody>
82 </table>
83
84%endfor
85</body>
86</html>
087
=== 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 @@
1<!DOCTYPE html SYSTEM
2"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3<html xmlns="http://www.w3.org/1999/xhtml">
4<head>
5<style type="text/css">
6 ${css}
7</style>
8</head>
9
10<body style="border:0; margin: 0;" onload="subst()" >
11
12%for obj in objects:
13<table>
14 <tr>
15 <td width="30%">
16 <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
17 </td>
18 <td width="70%">
19 <table style="width: 100%; text-align:center;">
20 <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
21 <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
22 <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
23 <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
24 </table>
25 </td>
26 </tr>
27</table>
28<table width="100%">
29 <thead>
30 <tr>
31 <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
32 </tr>
33 </thead>
34</table>
35<table style="width: 100%;">
36 <tr>
37 <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('Code')}</td>
38 <td class="celdaTituloTabla" width="30%">${_('ACCOUNT')}</td>
39 <td class="celdaTituloTabla" width="10%">${_('INIT. BAL.')}</td>
40 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('DEBIT')}</td>
41 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('CREDIT')}</td>
42 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('PERIOD')}</td>
43 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('YTD')}</td>
44 </tr>
45 %for line in obj.get_parser_method('lines',data['form']):
46 %if line['type'] != 'view':
47 <tr>
48 <td class="celdaLineData" style="text-align:right;font-style:italic;">${line['code'] or ''}</td>
49 <td class="celdaLineDataName" >${line['name'].upper() or line['name'].title()}</td>
50 <td class="celdaLineData" style="text-align:right;">${formatLang(line.get('change_sign', 1.0) * line.get('balanceinit'), digits=2, grouping=True) or ''}</td>
51 <td class="celdaLineData" style="text-align:right;">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
52 <td class="celdaLineData" style="text-align:right;">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
53 <td class="celdaLineData" style="text-align:right;">${formatLang(line.get('change_sign', 1.0) * line.get('ytd'), digits=2, grouping=True) or ''}</td>
54 <td class="celdaLineData" style="text-align:right;">${formatLang(line.get('change_sign', 1.0) * line.get('balance'), digits=2, grouping=True) or ''}</td>
55 </tr>
56 %elif line['total'] and not line['label']:
57 <tr>
58 <td class="celdaLineDataTotal" style="text-align:right;font-style:italic;">${line['code'] or ''}</td>
59 <td class="celdaLineDataTotal" style="text-align:right;">${line['name'].upper() or line['name'].title() or ''}</td>
60 <td class="celdaLineDataTotal">${formatLang(line.get('change_sign', 1.0) * line.get('balanceinit'), digits=2, grouping=True) or ''}</td>
61 <td class="celdaLineDataTotal">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
62 <td class="celdaLineDataTotal">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
63 <td class="celdaLineDataTotal">${formatLang(line.get('change_sign', 1.0) * line.get('ytd'), digits=2, grouping=True) or ''}</td>
64 <td class="celdaLineDataTotal">${formatLang(line.get('change_sign', 1.0) * line.get('balance'), digits=2, grouping=True) or ''}</td>
65 </tr>
66 %else:
67 <tr>
68 <td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="10%">${(line['label'] == True ) and line['code'] or ''}</td>
69 <td class="celdaLineDataNameView" colspan="6">${line['name'].upper() or line['name'].title() or ''}</td>
70 </tr>
71 %endif
72 %endfor
73</table>
74%endfor
75</body>
76</html>
077
=== 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 @@
1<!DOCTYPE html SYSTEM
2"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3<html xmlns="http://www.w3.org/1999/xhtml">
4<head>
5<style type="text/css">
6 ${css}
7</style>
8</head>
9
10<body style="border:0; margin: 0;" onload="subst()" >
11%for obj in objects:
12<table width="100%">
13 <tr>
14 <td>
15 <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
16 </td>
17 <td>
18 <table style="width: 100%; text-align:center;">
19 <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
20 <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
21 <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
22 <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
23 </table>
24 </td>
25 </tr>
26</table>
27
28<table width="100%">
29 <thead>
30 <tr>
31 <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
32 </tr>
33 </thead>
34</table>
35<table width="100%">
36 <thead>
37 <tr>
38 <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('CODE')}</td>
39 <td class="celdaTituloTabla" width="50%">${_('ACCOUNT')}</td>
40 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('INICIAL')}</td>
41 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('DEBIT')}</td>
42 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('CREDIT')}</td>
43 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('BALANCE')}</td>
44 </tr>
45 </thead>
46</table>
47<table width="100%">
48 <thead>
49 <tr>
50 <td class="celdaTituloTabla" style="text-align:left;" width="10%">${_('DATE')}</td>
51 <td class="celdaTituloTabla" width="10%">${_('PERIOD')}</td>
52 <td class="celdaTituloTabla" width="40%">${_('JOURNAL ENTRY')}</td>
53 <td class="celdaTituloTabla" width="40%"></td>
54 </tr>
55 </thead>
56</table>
57
58<table width="100%">
59 <tr>
60 <td width="10%"></td>
61 <td width="10%"></td>
62 <td width="10%"></td>
63 <td width="10%"></td>
64 <td width="10%"></td>
65 <td width="10%"></td>
66 <td width="10%"></td>
67 <td width="10%"></td>
68 <td width="10%"></td>
69 <td width="10%"></td>
70 </tr>
71 %for line in obj.get_parser_method('lines',data['form']):
72 %if line['type']!= 'view':
73 <tbody>
74 <tr>
75 <td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td>
76 <td class="celdaLineDataNameTotal" colspan="5">${line['name'].upper() or line['name'].title() or ''}</td>
77 <td class="celdaLineDataTotal" width="10%">${formatLang(line['balanceinit'] and line['balanceinit'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
78 <td class="celdaLineDataTotal" width="10%"> ${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
79 <td class="celdaLineDataTotal" width="10%">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
80 <td class="celdaLineDataTotal" width="10%">${formatLang(line['balance'] and line['balance'] * line.get('change_sign',1.0) or 0.0, digits=2, grouping=True) or ''}</td>
81 </tr>
82 </tbody>
83 %for j in line['journal']:
84 <tbody>
85 <tr>
86 <td class="celdaLineData" style="text-align:left;" width="10%" height="12pt">${formatLang( j['date'], date=True) or ''}</td>
87 <td class="celdaLineData" style="text-align:left;" width="10%">${j['period'] or ''}</td>
88 <td class="celdaLineDataNamePartner" colspan="4">${j['name'] or ''}</td>
89 <td class="celdaLineDataNamePartner" colspan="4"></td>
90 </tr>
91 </tbody>
92 %for k in j.get('obj').line_id:
93 <tbody>
94 %if k.account_id.name.upper() == line['name'].upper() :
95 <tr>
96 <td class="celdaLineDataAccountSimilar" style="text-align:left;" colspan="2">${k.name or ''}</td>
97 <td class="celdaLineDataAccountSimilar" style="text-align:left;">${k.ref and k.ref or ''}</td>
98 <td class="celdaLineDataAccountSimilar" colspan="2">${k.partner_id and k.partner_id.name or ''}</td>
99 <td class="celdaLineDataAccountSimilar" style="text-align:left;">${k.account_id and k.account_id.code or ''}</td>
100 <td class="celdaLineDataAccountSimilar" style="text-align:left;" >${k.account_id and k.account_id.name or ''}</td>
101 <td class="celdaLineDataAccountSimilar" style="text-align:right;" >${k.debit and formatLang(k.debit, digits=2, grouping=True) or ''}</td>
102 <td class="celdaLineDataAccountSimilar" style="text-align:right;" >${k.credit and formatLang(k.credit, digits=2, grouping=True) or ''}</td>
103 <td class="celdaLineDataAccountSimilar" style="text-align:right;" >${k.reconcile_id and k.reconcile_id.name or k.reconcile_partial_id and k.reconcile_partial_id.name or ''}</td>
104 </tr>
105 %else:
106 <tr>
107 <td class="celdaLineDataAccount" style="text-align:left;" colspan="2">${k.name or ''}</td>
108 <td class="celdaLineDataAccount" style="text-align:left;" >${k.ref and k.ref or ''}</td>
109 <td class="celdaLineDataAccount" colspan="2">${k.partner_id and k.partner_id.name or ''}</td>
110 <td class="celdaLineDataAccount" style="text-align:left;" >${k.account_id and k.account_id.code or ''}</td>
111 <td class="celdaLineDataAccount" style="text-align:left;" >${k.account_id and k.account_id.name or ''}</td>
112 <td class="celdaLineDataAccount" style="text-align:right;" >${k.debit and formatLang(k.debit, digits=2, grouping=True) or ''}</td>
113 <td class="celdaLineDataAccount" style="text-align:right;" >${k.credit and formatLang(k.credit, digits=2, grouping=True) or ''}</td>
114 <td class="celdaLineDataAccount" style="text-align:right;" >${k.reconcile_id and k.reconcile_id.name or k.reconcile_partial_id and k.reconcile_partial_id.name or ''}</td>
115 </tr>
116 %endif
117 </tbody>
118 %endfor
119 %endfor
120 %endif
121 %endfor
122</table>
123
124%endfor
125
126</body>
127</html>
0128
=== 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 @@
1<!DOCTYPE html SYSTEM
2"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3<html xmlns="http://www.w3.org/1999/xhtml">
4<head>
5<style type="text/css">
6 ${css}
7</style>
8</head>
9
10<body style="border:0; margin: 0;" onload="subst()" >
11
12
13<!--
14 <h1><center>4 QTR | YTD</center></h1>
15-->
16 %for obj in objects:
17 <table width="100%">
18 <tr>
19 <td width="30%">
20 <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
21 </td>
22 <td width="70%">
23 <table style="width: 100%; text-align:center;">
24 <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
25 <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
26 <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
27 <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
28 </table>
29 </td>
30 <td>
31 </td>
32 </tr>
33 </table>
34 <table width="100%">
35 <thead>
36 <tr>
37 <td class="celdaTituloTabla" colspan="7" style="text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
38 </tr>
39 </thead>
40 <tbody>
41 <tr>
42 <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('CODE')}</td>
43 <td class="celdaTituloTabla" width="30%">${_('ACCOUNT')}</td>
44 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('Q1')}</td>
45 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('Q2')}</td>
46 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('Q3')}</td>
47 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('Q4')}</td>
48 <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('YTD')}</td>
49 </tr>
50 %for line in obj.get_parser_method('lines',data['form']):
51 %if line['type'] != 'view':
52 <tr class="prueba">
53 <td class="celdaLineData" style="text-align:right;font-style:italic;">${line['code'] or ''}</td>
54 <td class="celdaLineDataName" >${line['name'].upper() or line['name'].title()}</td>
55 <td class="celdaLineData" style="text-align:right;">${formatLang(line['bal1'] and (line['bal1'] * line.get('change_sign',1)) or 0.0, digits=2, grouping=True) or ''}</td>
56 <td class="celdaLineData" style="text-align:right;">${formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
57 <td class="celdaLineData" style="text-align:right;">${formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
58 <td class="celdaLineData" style="text-align:right;">${formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
59 <td class="celdaLineData" style="text-align:right;">${formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
60 </tr>
61 %elif line['total'] and not line['label']:
62 <tr class="prueba">
63 <td class="celdaLineDataTotal" style="text-align:right;font-style:italic;">${line['code'] or ''}</td>
64 <td class="celdaLineDataTotal" style="text-align:right;">${line['name'].upper() or line['name'].title() or ''}</td>
65 <td class="celdaLineDataTotal">${formatLang(line['bal1'] and (line['bal1'] * line.get('change_sign',1)) or 0.0, digits=2, grouping=True) or ''}</td>
66 <td class="celdaLineDataTotal">${formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
67 <td class="celdaLineDataTotal">${formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
68 <td class="celdaLineDataTotal">${formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
69 <td class="celdaLineDataTotal">${formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
70 </tr>
71 %else:
72 <tr class="prueba">
73 <i><td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
74 <td class="celdaLineDataNameView" colspan="6" >${line['name'].upper() or line['name'].title() or ''}</td>
75 </tr>
76 %endif
77 %endfor
78 </tbody>
79 </table>
80%endfor
81</body>
82</html>
083
=== 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 @@
1<?xml version="1.0"?>
2<openerp>
3 <data>
4 <report
5 auto = "True"
6 id="afr_report_col5"
7 model="wizard.report"
8 name="afr_report_col5"
9 file="account_financial_report_exportable/report/afr_report_webkit_cols5.mako"
10 string="Print AFR"
11 report_type="webkit"
12 multi="True"
13 menu="False"/>
14
15 <record id="property_afr_report_webkit1" model="ir.property">
16 <field name="name">webkit_header</field>
17 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
18 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_five_colums'))" model="ir.header_webkit" name="value"/>
19 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col5'))" model="ir.actions.report.xml" name="res_id"/>
20 </record>
21
22 <report
23 auto = "True"
24 id="afr_report_col5_html"
25 model="wizard.report"
26 name="afr_report_col5_html"
27 file="account_financial_report_exportable/report/afr_report_webkit_cols5.mako"
28 string="Print AFR"
29 report_type="webkit"
30 multi="True"
31 menu="False"/>
32 <record id="afr_report_col5_html" model="ir.actions.report.xml">
33 <field name="webkit_debug">True</field>
34 <field name="precise_mode">True</field>
35 </record>
36 <record id="property_afr_report_webkit1_html" model="ir.property">
37 <field name="name">webkit_header</field>
38 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
39 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_five_colums'))" model="ir.header_webkit" name="value"/>
40 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col5_html'))" model="ir.actions.report.xml" name="res_id"/>
41 </record>
42
43 <report
44 auto = "True"
45 id="afr_report_col1"
46 model="wizard.report"
47 name="afr_report_col1"
48 file="account_financial_report_exportable/report/afr_report_webkit_cols1.mako"
49 string="Print AFR"
50 report_type="webkit"
51 multi="True"
52 menu="False"/>
53
54 <record id="property_afr_report_webkit2" model="ir.property">
55 <field name="name">webkit_header</field>
56 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
57 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_one_colums'))" model="ir.header_webkit" name="value"/>
58 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col1'))" model="ir.actions.report.xml" name="res_id"/>
59 </record>
60
61 <report
62 auto = "True"
63 id="afr_report_col1_html"
64 model="wizard.report"
65 name="afr_report_col1_html"
66 file="account_financial_report_exportable/report/afr_report_webkit_cols1.mako"
67 string="Print AFR"
68 report_type="webkit"
69 multi="True"
70 menu="False"/>
71 <record id="afr_report_col1_html" model="ir.actions.report.xml">
72 <field name="webkit_debug">True</field>
73 <field name="precise_mode">True</field>
74 </record>
75 <record id="property_afr_report_webkit2_html" model="ir.property">
76 <field name="name">webkit_header</field>
77 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
78 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_one_colums'))" model="ir.header_webkit" name="value"/>
79 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col1_html'))" model="ir.actions.report.xml" name="res_id"/>
80 </record>
81
82 <report
83 auto = "True"
84 id="afr_report_col2"
85 model="wizard.report"
86 name="afr_report_col2"
87 file="account_financial_report_exportable/report/afr_report_webkit_cols2.mako"
88 string="Print AFR"
89 report_type="webkit"
90 multi="True"
91 menu="False"/>
92
93 <record id="property_afr_report_webkit3" model="ir.property">
94 <field name="name">webkit_header</field>
95 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
96 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_two_colums'))" model="ir.header_webkit" name="value"/>
97 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col2'))" model="ir.actions.report.xml" name="res_id"/>
98 </record>
99
100 <report
101 auto = "True"
102 id="afr_report_col2_html"
103 model="wizard.report"
104 name="afr_report_col2_html"
105 file="account_financial_report_exportable/report/afr_report_webkit_cols2.mako"
106 string="Print AFR"
107 report_type="webkit"
108 multi="True"
109 menu="False"/>
110 <record id="afr_report_col2_html" model="ir.actions.report.xml">
111 <field name="webkit_debug">True</field>
112 <field name="precise_mode">True</field>
113 </record>
114 <record id="property_afr_report_webkit3_html" model="ir.property">
115 <field name="name">webkit_header</field>
116 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
117 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_two_colums'))" model="ir.header_webkit" name="value"/>
118 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col2_html'))" model="ir.actions.report.xml" name="res_id"/>
119 </record>
120
121 <report
122 auto = "True"
123 id="afr_report_col4"
124 model="wizard.report"
125 name="afr_report_col4"
126 file="account_financial_report_exportable/report/afr_report_webkit_cols4.mako"
127 string="Print AFR"
128 report_type="webkit"
129 multi="True"
130 menu="False"/>
131
132 <record id="property_afr_report_webkit4" model="ir.property">
133 <field name="name">webkit_header</field>
134 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
135 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_four_colums'))" model="ir.header_webkit" name="value"/>
136 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col4'))" model="ir.actions.report.xml" name="res_id"/>
137 </record>
138
139 <report
140 auto = "True"
141 id="afr_report_col4_html"
142 model="wizard.report"
143 name="afr_report_col4_html"
144 file="account_financial_report_exportable/report/afr_report_webkit_cols4.mako"
145 string="Print AFR"
146 report_type="webkit"
147 multi="True"
148 menu="False"/>
149 <record id="afr_report_col4_html" model="ir.actions.report.xml">
150 <field name="webkit_debug">True</field>
151 <field name="precise_mode">True</field>
152 </record>
153 <record id="property_afr_report_webkit4_html" model="ir.property">
154 <field name="name">webkit_header</field>
155 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
156 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_four_colums'))" model="ir.header_webkit" name="value"/>
157 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col4_html'))" model="ir.actions.report.xml" name="res_id"/>
158 </record>
159
160 <report
161 auto = "True"
162 id="afr_report_journal_ledger"
163 model="wizard.report"
164 name="afr_report_journal_ledger"
165 file="account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako"
166 string="Print AFR"
167 report_type="webkit"
168 multi="True"
169 menu="False"/>
170
171 <record id="property_afr_report_webkit6" model="ir.property">
172 <field name="name">webkit_header</field>
173 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
174 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_journal_ledger'))" model="ir.header_webkit" name="value"/>
175 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_journal_ledger'))" model="ir.actions.report.xml" name="res_id"/>
176 </record>
177
178 <report
179 auto = "True"
180 id="afr_report_journal_ledger_html"
181 model="wizard.report"
182 name="afr_report_journal_ledger_html"
183 file="account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako"
184 string="Print AFR"
185 report_type="webkit"
186 multi="True"
187 menu="False"/>
188 <record id="afr_report_journal_ledger_html" model="ir.actions.report.xml">
189 <field name="webkit_debug">True</field>
190 <field name="precise_mode">True</field>
191 </record>
192 <record id="property_afr_report_webkit6_html" model="ir.property">
193 <field name="name">webkit_header</field>
194 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
195 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_journal_ledger'))" model="ir.header_webkit" name="value"/>
196 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_journal_ledger_html'))" model="ir.actions.report.xml" name="res_id"/>
197 </record>
198
199 <report
200 auto = "True"
201 id="afr_report_qtr"
202 model="wizard.report"
203 name="afr_report_qtr"
204 file="account_financial_report_exportable/report/afr_report_webkit_qtr.mako"
205 string="Print AFR"
206 report_type="webkit"
207 multi="True"
208 menu="False"/>
209
210 <record id="property_afr_report_webkit7" model="ir.property">
211 <field name="name">webkit_header</field>
212 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
213 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_qtr'))" model="ir.header_webkit" name="value"/>
214 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_qtr'))" model="ir.actions.report.xml" name="res_id"/>
215 </record>
216
217 <report
218 auto = "True"
219 id="afr_report_qtr_html"
220 model="wizard.report"
221 name="afr_report_qtr_html"
222 file="account_financial_report_exportable/report/afr_report_webkit_qtr.mako"
223 string="Print AFR"
224 report_type="webkit"
225 multi="True"
226 menu="False"/>
227 <record id="afr_report_qtr_html" model="ir.actions.report.xml">
228 <field name="webkit_debug">True</field>
229 <field name="precise_mode">True</field>
230 </record>
231 <record id="property_afr_report_webkit7_html" model="ir.property">
232 <field name="name">webkit_header</field>
233 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
234 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_qtr'))" model="ir.header_webkit" name="value"/>
235 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_qtr_html'))" model="ir.actions.report.xml" name="res_id"/>
236 </record>
237
238 <report
239 auto = "True"
240 id="afr_report_col13"
241 model="wizard.report"
242 name="afr_report_col13"
243 file="account_financial_report_exportable/report/afr_report_webkit_cols13.mako"
244 string="Print AFR"
245 report_type="webkit"
246 multi="True"
247 menu="False"/>
248
249 <record id="property_afr_report_webkit8" model="ir.property">
250 <field name="name">webkit_header</field>
251 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
252 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_col13'))" model="ir.header_webkit" name="value"/>
253 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col13'))" model="ir.actions.report.xml" name="res_id"/>
254 </record>
255
256 <report
257 auto = "True"
258 id="afr_report_col13_html"
259 model="wizard.report"
260 name="afr_report_col13_html"
261 file="account_financial_report_exportable/report/afr_report_webkit_cols13.mako"
262 string="Print AFR"
263 report_type="webkit"
264 multi="True"
265 menu="False"/>
266 <record id="afr_report_col13_html" model="ir.actions.report.xml">
267 <field name="webkit_debug">True</field>
268 <field name="precise_mode">True</field>
269 </record>
270 <record id="property_afr_report_webkit8_html" model="ir.property">
271 <field name="name">webkit_header</field>
272 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
273 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_col13'))" model="ir.header_webkit" name="value"/>
274 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col13_html'))" model="ir.actions.report.xml" name="res_id"/>
275 </record>
276
277 <report
278 auto = "True"
279 id="afr_report_analytic_ledger"
280 model="wizard.report"
281 name="afr_report_analytic_ledger"
282 file="account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako"
283 string="Print AFR"
284 report_type="webkit"
285 multi="True"
286 menu="False"/>
287
288 <record id="property_afr_report_webkit9" model="ir.property">
289 <field name="name">webkit_header</field>
290 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
291 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_analytic_ledger'))" model="ir.header_webkit" name="value"/>
292 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_analytic_ledger'))" model="ir.actions.report.xml" name="res_id"/>
293 </record>
294
295 <report
296 auto = "True"
297 id="afr_report_analytic_ledger_html"
298 model="wizard.report"
299 name="afr_report_analytic_ledger_html"
300 file="account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako"
301 string="Print AFR"
302 report_type="webkit"
303 multi="True"
304 menu="False"/>
305 <record id="afr_report_analytic_ledger_html" model="ir.actions.report.xml">
306 <field name="webkit_debug">True</field>
307 <field name="precise_mode">True</field>
308 </record>
309 <record id="property_afr_report_webkit9_html" model="ir.property">
310 <field name="name">webkit_header</field>
311 <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
312 <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_analytic_ledger'))" model="ir.header_webkit" name="value"/>
313 <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_analytic_ledger_html'))" model="ir.actions.report.xml" name="res_id"/>
314 </record>
315 </data>
316</openerp>
0317
=== 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 @@
1<?xml version='1.0' encoding='UTF-8'?>
2<openerp>
3 <data>
4 <record model="ir.ui.view" id="wizard_report_view_inherit">
5 <field name="name">wizard.report.view.inherit</field>
6 <field name="model">wizard.report</field>
7 <field name="inherit_id" ref="account_financial_report.wizard_report_view"/>
8 <field name="arch" type="xml">
9 <xpath expr="//field[@name='journal_ledger']" position="after">
10 <field name="report_format"/>
11 </xpath>
12 </field>
13 </record>
14 </data>
15</openerp>
016
=== 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 @@
1#!/usr/bin/python
2# -*- encoding: utf-8 -*-
3###############################################################################
4# Module Writen to OpenERP, Open Source Management Solution
5# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
6# All Rights Reserved
7############# Credits #########################################################
8# Coded by: Yanina Aular <yani@vauxoo.com>
9# Planified by: Humberto Arocha <hbto@vauxoo.com>
10# Audited by: Humberto Arocha <hbto@vauxoo.com>
11###############################################################################
12# This program is free software: you can redistribute it and/or modify
13# it under the terms of the GNU Affero General Public License as published
14# by the Free Software Foundation, either version 3 of the License, or
15# (at your option) any later version.
16#
17# This program is distributed in the hope that it will be useful,
18# but WITHOUT ANY WARRANTY; without even the implied warranty of
19# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20# GNU Affero General Public License for more details.
21#
22# You should have received a copy of the GNU Affero General Public License
23# along with this program. If not, see <http://www.gnu.org/licenses/>.
24###############################################################################
25
26import afr_report_wizard
027
=== 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 @@
1#!/usr/bin/python
2# -*- encoding: utf-8 -*-
3###############################################################################
4# Module Writen to OpenERP, Open Source Management Solution
5# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
6# All Rights Reserved
7############# Credits #########################################################
8# Coded by: Yanina Aular <yani@vauxoo.com>
9# Planified by: Humberto Arocha <hbto@vauxoo.com>
10# Audited by: Humberto Arocha <hbto@vauxoo.com>
11###############################################################################
12# This program is free software: you can redistribute it and/or modify
13# it under the terms of the GNU Affero General Public License as published
14# by the Free Software Foundation, either version 3 of the License, or
15# (at your option) any later version.
16#
17# This program is distributed in the hope that it will be useful,
18# but WITHOUT ANY WARRANTY; without even the implied warranty of
19# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20# GNU Affero General Public License for more details.
21#
22# You should have received a copy of the GNU Affero General Public License
23# along with this program. If not, see <http://www.gnu.org/licenses/>.
24###############################################################################
25
26
27
28from osv import osv, fields
29import pooler
30import time
31from tools.translate import _
32from account_financial_report.report import parser as Parser
33
34
35class wizard_report(osv.osv_memory):
36 _inherit = "wizard.report"
37
38 _columns = {
39 'report_format' : fields.selection([
40 ('pdf', 'PDF'),
41 ('spreadsheet', 'Spreadsheet')], 'Report Format')
42 }
43 def get_parser_method(self, cr, uid, ids, method=None, args=None, param=None, context=None):
44 if context is None:
45 context = {}
46
47 acc_bal_obj = Parser.account_balance(cr, uid, ids ,context=context)
48 res = []
49
50 if method:
51 if method in ("get_company_accounts", "_get_analytic_ledger", "_get_journal_ledger",
52 "lines"):
53 res = getattr(acc_bal_obj, method)(args, param)
54 else:
55 res = getattr(acc_bal_obj, method)(args)
56
57 return res
58
59 def print_report(self, cr, uid, ids, data, context=None):
60 if context is None:
61 context = {}
62
63 res = super(wizard_report, self).print_report(cr, uid, ids, data=data, context=context)
64
65 res.get('datas')['ids'] = ids
66
67 if( res.get('report_name') == 'afr.1cols'):
68 if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
69 res['report_name'] = 'afr_report_col1_html'
70 else:
71 res['report_name'] = 'afr_report_col1'
72
73 if( res.get('report_name') == 'afr.2cols'):
74 if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
75 res['report_name'] = 'afr_report_col2_html'
76 else:
77 res['report_name'] = 'afr_report_col2'
78
79 if( res.get('report_name') == 'afr.4cols'):
80 if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
81 res['report_name'] = 'afr_report_col4_html'
82 else:
83 res['report_name'] = 'afr_report_col4'
84
85 if( res.get('report_name') == 'afr.5cols'):
86 if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
87 res['report_name'] = 'afr_report_col5_html'
88 else:
89 res['report_name'] = 'afr_report_col5'
90
91 if( res.get('report_name') == 'afr.journal.ledger'):
92 if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
93 res['report_name'] = 'afr_report_journal_ledger_html'
94 else:
95 res['report_name'] = 'afr_report_journal_ledger'
96
97 if( res.get('report_name') == 'afr.analytic.ledger'):
98 if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
99 res['report_name'] = 'afr_report_analytic_ledger_html'
100 else:
101 res['report_name'] = 'afr_report_analytic_ledger'
102
103 if( res.get('report_name') == 'afr.qtrcols'):
104 if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
105 res['report_name'] = 'afr_report_qtr_html'
106 else:
107 res['report_name'] = 'afr_report_qtr'
108
109 if( res.get('report_name') == 'afr.13cols'):
110 if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
111 res['report_name'] = 'afr_report_col13_html'
112 else:
113 res['report_name'] = 'afr_report_col13'
114
115 return res
116
117
118
0119
=== added directory 'account_financial_report_exportable/workflow'

Subscribers

People subscribed via source and target branches

to status/vote changes: