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
1=== modified file 'account_financial_report/wizard/wizard.py'
2--- account_financial_report/wizard/wizard.py 2013-07-26 17:03:11 +0000
3+++ account_financial_report/wizard/wizard.py 2013-10-23 14:40:32 +0000
4@@ -284,7 +284,6 @@
5 name = 'afr.qtrcols'
6 if data['form']['columns'] == 'thirteen':
7 name = 'afr.13cols'
8-
9 return {'type': 'ir.actions.report.xml', 'report_name': name, 'datas': data}
10
11 wizard_report()
12
13=== added directory 'account_financial_report_exportable'
14=== added file 'account_financial_report_exportable/__init__.py'
15--- account_financial_report_exportable/__init__.py 1970-01-01 00:00:00 +0000
16+++ account_financial_report_exportable/__init__.py 2013-10-23 14:40:32 +0000
17@@ -0,0 +1,26 @@
18+#!/usr/bin/python
19+# -*- encoding: utf-8 -*-
20+###############################################################################
21+# Module Writen to OpenERP, Open Source Management Solution
22+# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
23+# All Rights Reserved
24+############# Credits #########################################################
25+# Coded by: Yanina Aular <yani@vauxoo.com>
26+# Planified by: Humberto Arocha <hbto@vauxoo.com>
27+# Audited by: Humberto Arocha <hbto@vauxoo.com>
28+###############################################################################
29+# This program is free software: you can redistribute it and/or modify
30+# it under the terms of the GNU Affero General Public License as published
31+# by the Free Software Foundation, either version 3 of the License, or
32+# (at your option) any later version.
33+#
34+# This program is distributed in the hope that it will be useful,
35+# but WITHOUT ANY WARRANTY; without even the implied warranty of
36+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
37+# GNU Affero General Public License for more details.
38+#
39+# You should have received a copy of the GNU Affero General Public License
40+# along with this program. If not, see <http://www.gnu.org/licenses/>.
41+###############################################################################
42+import model
43+import wizard
44
45=== added file 'account_financial_report_exportable/__openerp__.py'
46--- account_financial_report_exportable/__openerp__.py 1970-01-01 00:00:00 +0000
47+++ account_financial_report_exportable/__openerp__.py 2013-10-23 14:40:32 +0000
48@@ -0,0 +1,55 @@
49+#!/usr/bin/python
50+# -*- encoding: utf-8 -*-
51+###############################################################################
52+# Module Writen to OpenERP, Open Source Management Solution
53+# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
54+# All Rights Reserved
55+############# Credits #########################################################
56+# Coded by: Yanina Aular <yani@vauxoo.com>
57+# Planified by: Humberto Arocha <hbto@vauxoo.com>
58+# Audited by: Humberto Arocha <hbto@vauxoo.com>
59+###############################################################################
60+# This program is free software: you can redistribute it and/or modify
61+# it under the terms of the GNU Affero General Public License as published
62+# by the Free Software Foundation, either version 3 of the License, or
63+# (at your option) any later version.
64+#
65+# This program is distributed in the hope that it will be useful,
66+# but WITHOUT ANY WARRANTY; without even the implied warranty of
67+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
68+# GNU Affero General Public License for more details.
69+#
70+# You should have received a copy of the GNU Affero General Public License
71+# along with this program. If not, see <http://www.gnu.org/licenses/>.
72+###############################################################################
73+
74+{
75+ 'name': 'Account Financial Report Exportable',
76+ 'version': '1.0',
77+ 'author': 'Vauxoo',
78+ 'website': 'http://www.vauxoo.com/',
79+ 'category': 'Accounting',
80+ 'description': '''
81+Account Financial Report Exportable
82+===================================
83+
84+Account Financial Report Reports on Webkit
85+
86+Main Features
87+=============
88+
89+account_financial_report module reports are now printed using webkit.
90+
91+
92+''',
93+ 'depends': ['base', 'mail', 'account_accountant', 'account_financial_report', 'report_webkit'],
94+ 'data': [
95+ 'data/html_css_afr.xml',
96+ 'report/report_afr.xml',
97+ 'view/account_financial_report_view.xml'
98+ ],
99+ 'demo': [],
100+ 'test': [],
101+ 'active': False,
102+ 'installable': True,
103+}
104
105=== added directory 'account_financial_report_exportable/data'
106=== added file 'account_financial_report_exportable/data/html_css_afr.xml'
107--- account_financial_report_exportable/data/html_css_afr.xml 1970-01-01 00:00:00 +0000
108+++ account_financial_report_exportable/data/html_css_afr.xml 2013-10-23 14:40:32 +0000
109@@ -0,0 +1,1372 @@
110+<?xml version="1.0" ?>
111+<openerp>
112+ <data noupdate="0">
113+ <record id="ir_header_webkit_afrreport_analytic_ledger" model="ir.header_webkit">
114+ <field name="name">Reports AFR WebKit</field>
115+ <field name="footer_html">
116+<![CDATA[<html>
117+ <head>
118+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
119+ <script>
120+ function subst() {
121+ var vars={};
122+ var x=document.location.search.substring(1).split('&');
123+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
124+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
125+ for(var i in x) {
126+ var y = document.getElementsByClassName(x[i]);
127+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
128+ }
129+ }
130+ </script>
131+ </head>
132+ <body style="border:0; margin: 0;" onload="subst()">
133+ <table style="border-top: 1px solid black; width: 100%">
134+ <tr>
135+ <td style="float:right;text-align:left;font-size:10;" width="30%">
136+ <script type="text/javascript">
137+ var date = new Date();
138+ var d = date.getDate();
139+ var day = (d < 10) ? '0' + d : d;
140+ var m = date.getMonth() + 1;
141+ var month = (m < 10) ? '0' + m : m;
142+ var yy = date.getYear();
143+ var year = (yy < 1000) ? yy + 1900 : yy;
144+ var h = date.getHours();
145+ var hours = (h < 10) ? '0' + h : h;
146+ var mm = date.getMinutes();
147+ var minutes = (mm < 10) ? '0' + mm : mm;
148+ document.write("Printing Date: "+day + "/" + month + "/" + year +
149+ "\t\t" + hours+":" + minutes );
150+ </script>
151+ </td>
152+ <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>
153+ </tr>
154+ </table>
155+ </body>
156+</html>]]></field>
157+ <field name="orientation">Landscape</field>
158+ <field name="format">Letter</field>
159+ <field name="html">
160+<![CDATA[<html>
161+ <head>
162+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
163+ <script>
164+ function subst() {
165+ var vars={};
166+ var x=document.location.search.substring(1).split('&');
167+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
168+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
169+ for(var i in x) {
170+ var y = document.getElementsByClassName(x[i]);
171+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
172+ }
173+ }
174+ </script>
175+ <style type="text/css">
176+ ${css}
177+ </style>
178+ </head>
179+ <body style="border:0; margin: 0;" onload="subst()">
180+ ${_debug or ''|n}
181+ </body>
182+</html>]]>
183+</field>
184+ <field eval="0.0" name="margin_top"/>
185+ <field name="css" >
186+ <![CDATA[
187+table.basic_table{
188+text-align:left;
189+border:1px solid lightGrey;
190+border-collapse: collapse;
191+}
192+
193+.dest_address { font-size:12pt;
194+margin-left:0;
195+text-align:left; l
196+ine-height:80%;
197+padding-top:0px
198+}
199+
200+.celdaLineData{
201+font-size:7pt;
202+font-family: monospace;
203+text-align:right;
204+background-color:#F5F5F5;
205+}
206+
207+.celdaLineDataName{
208+font-size:7pt;
209+font-family: monospace;
210+text-align:left;
211+background-color:#F5F5F5;
212+}
213+
214+.celdaLineDataTotal{
215+font-size:7pt;
216+font-family:Arial,Helvetica,sans-serif;
217+text-align:right;
218+font-weight:bold;
219+background-color:#dcdcdc;
220+}
221+
222+.celdaLineDataNameTotal{
223+font-size:7pt;
224+font-family:Arial,Helvetica,sans-serif;
225+text-align:left;
226+font-weight:bold;
227+background-color:#dcdcdc;
228+}
229+
230+.celdaLineDataNameJournal{
231+font-size:7pt;
232+font-family:Arial,Helvetica,sans-serif;
233+text-align:left;
234+font-weight:bold;
235+background-color:#F5F5F5;
236+}
237+
238+.celdaLineDataNamePartner{
239+font-size:7pt;
240+font-family: monospace;
241+text-align:left;
242+background-color:#F5F5F5;
243+}
244+
245+.celdaTituloTabla{
246+font-size:8pt;
247+text-align:left;
248+font-family:Arial,Helvetica,sans-serif;
249+background-color:#620400;
250+font-weight:bold;
251+color:#FFFFFF;
252+}
253+
254+div.td_company
255+{
256+font-size:11pt;
257+margin-left:0;
258+font-weight:bold;
259+font-family:Arial,Helvetica,sans-serif;
260+}
261+
262+div.td_company_date
263+{
264+font-size:9pt;
265+margin-left:0;
266+font-weight:bold;
267+font-family:Arial,Helvetica,sans-serif;
268+}
269+
270+div.td_company_title
271+{
272+font-size:15pt;
273+margin-left:0;
274+font-weight:bold;
275+font-family:Arial,Helvetica,sans-serif;
276+}
277+]]>
278+ </field>
279+ </record>
280+
281+ <record id="ir_header_webkit_afrreport_col13" model="ir.header_webkit">
282+ <field name="name">Reports AFR WebKit</field>
283+ <field name="footer_html">
284+<![CDATA[<html>
285+ <head>
286+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
287+ <script>
288+ function subst() {
289+ var vars={};
290+ var x=document.location.search.substring(1).split('&');
291+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
292+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
293+ for(var i in x) {
294+ var y = document.getElementsByClassName(x[i]);
295+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
296+ }
297+ }
298+ </script>
299+ </head>
300+ <body style="border:0; margin: 0;" onload="subst()">
301+ <table style="border-top: 1px solid black; width: 100%">
302+ <tr>
303+ <td style="float:right;text-align:left;font-size:10;" width="30%">
304+ <script type="text/javascript">
305+ var date = new Date();
306+ var d = date.getDate();
307+ var day = (d < 10) ? '0' + d : d;
308+ var m = date.getMonth() + 1;
309+ var month = (m < 10) ? '0' + m : m;
310+ var yy = date.getYear();
311+ var year = (yy < 1000) ? yy + 1900 : yy;
312+ var h = date.getHours();
313+ var hours = (h < 10) ? '0' + h : h;
314+ var mm = date.getMinutes();
315+ var minutes = (mm < 10) ? '0' + mm : mm;
316+ document.write("Printing Date: "+day + "/" + month + "/" + year +
317+ "\t\t" + hours+":" + minutes );
318+ </script>
319+ </td>
320+ <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>
321+ </tr>
322+ </table>
323+ </body>
324+</html>]]></field>
325+ <field name="orientation">Landscape</field>
326+ <field name="format">Letter</field>
327+ <field name="html">
328+<![CDATA[<html>
329+ <head>
330+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
331+ <script>
332+ function subst() {
333+ var vars={};
334+ var x=document.location.search.substring(1).split('&');
335+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
336+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
337+ for(var i in x) {
338+ var y = document.getElementsByClassName(x[i]);
339+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
340+ }
341+ }
342+ </script>
343+ <style type="text/css">
344+ ${css}
345+ </style>
346+ </head>
347+ <body style="border:0; margin: 0;" onload="subst()">
348+ ${_debug or ''|n}
349+ </body>
350+</html>]]>
351+</field>
352+ <field eval="0.0" name="margin_top"/>
353+ <field name="css" >
354+ <![CDATA[
355+table.basic_table{
356+text-align:left;
357+border:1px solid lightGrey;
358+border-collapse: collapse;
359+}
360+
361+.dest_address { font-size:12pt;
362+margin-left:0;
363+text-align:left; l
364+ine-height:80%;
365+padding-top:0px
366+}
367+
368+.celdaLineData{
369+font-size:4pt;
370+font-family: monospace;
371+text-align:right;
372+background-color:#F5F5F5;
373+}
374+
375+.celdaLineDataName{
376+font-size:4pt;
377+font-family: monospace;
378+text-align:left;
379+background-color:#F5F5F5;
380+}
381+
382+.celdaLineDataView{
383+font-size:4pt;
384+font-family:Arial,Helvetica,sans-serif;
385+text-align:right;
386+font-weight:bold;
387+background-color:#dcdcdc;
388+}
389+
390+.celdaLineDataNameView{
391+font-size:4pt;
392+font-family:Arial,Helvetica,sans-serif;
393+text-align:left;
394+font-weight:bold;
395+background-color:#dcdcdc;
396+}
397+
398+.celdaLineDataTotal{
399+font-size:4pt;
400+font-family:Arial,Helvetica,sans-serif;
401+text-align:right;
402+font-weight:bold;
403+background-color:#eaeaea;
404+}
405+
406+.celdaLineDataNameTotal{
407+font-size:4pt;
408+font-family:Arial,Helvetica,sans-serif;
409+text-align:left;
410+font-weight:bold;
411+background-color:#eaeaea;
412+}
413+
414+.celdaTituloTabla{
415+font-size:7pt;
416+text-align:left;
417+font-family:Arial,Helvetica,sans-serif;
418+background-color:#620400;
419+font-weight:bold;
420+color:#FFFFFF;
421+}
422+
423+
424+div.td_company
425+{
426+font-size:11pt;
427+margin-left:0;
428+font-weight:bold;
429+font-family:Arial,Helvetica,sans-serif;
430+}
431+
432+div.td_company_date
433+{
434+font-size:9pt;
435+margin-left:0;
436+font-weight:bold;
437+font-family:Arial,Helvetica,sans-serif;
438+}
439+
440+div.td_company_title
441+{
442+font-size:15pt;
443+margin-left:0;
444+font-weight:bold;
445+font-family:Arial,Helvetica,sans-serif;
446+}
447+]]>
448+ </field>
449+ </record>
450+
451+ <record id="ir_header_webkit_afrreport_qtr" model="ir.header_webkit">
452+ <field name="name">Reports AFR WebKit</field>
453+ <field name="footer_html">
454+<![CDATA[<html>
455+ <head>
456+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
457+ <script>
458+ function subst() {
459+ var vars={};
460+ var x=document.location.search.substring(1).split('&');
461+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
462+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
463+ for(var i in x) {
464+ var y = document.getElementsByClassName(x[i]);
465+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
466+ }
467+ }
468+ </script>
469+ </head>
470+ <body style="border:0; margin: 0;" onload="subst()">
471+ <table style="border-top: 1px solid black; width: 100%">
472+ <tr>
473+ <td style="float:right;text-align:left;font-size:10;" width="30%">
474+ <script type="text/javascript">
475+ var date = new Date();
476+ var d = date.getDate();
477+ var day = (d < 10) ? '0' + d : d;
478+ var m = date.getMonth() + 1;
479+ var month = (m < 10) ? '0' + m : m;
480+ var yy = date.getYear();
481+ var year = (yy < 1000) ? yy + 1900 : yy;
482+ var h = date.getHours();
483+ var hours = (h < 10) ? '0' + h : h;
484+ var mm = date.getMinutes();
485+ var minutes = (mm < 10) ? '0' + mm : mm;
486+ document.write("Printing Date: "+day + "/" + month + "/" + year +
487+ "\t\t" + hours+":" + minutes );
488+ </script>
489+ </td>
490+ <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>
491+ </tr>
492+ </table>
493+ </body>
494+</html>]]></field>
495+ <field name="orientation">Landscape</field>
496+ <field name="format">Letter</field>
497+ <field name="html">
498+<![CDATA[<html>
499+ <head>
500+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
501+ <script>
502+ function subst() {
503+ var vars={};
504+ var x=document.location.search.substring(1).split('&');
505+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
506+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
507+ for(var i in x) {
508+ var y = document.getElementsByClassName(x[i]);
509+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
510+ }
511+ }
512+ </script>
513+ <style type="text/css">
514+ ${css}
515+ </style>
516+ </head>
517+ <body style="border:0; margin: 0;" onload="subst()">
518+ ${_debug or ''|n}
519+ </body>
520+</html>]]>
521+</field>
522+ <field eval="0.0" name="margin_top"/>
523+ <field name="css" >
524+ <![CDATA[
525+table.basic_table{
526+text-align:left;
527+border:1px solid lightGrey;
528+border-collapse: collapse;
529+}
530+
531+.dest_address { font-size:12pt;
532+margin-left:0;
533+text-align:left; l
534+ine-height:80%;
535+padding-top:0px
536+}
537+
538+.celdaLineData{
539+font-size:5pt;
540+font-family: monospace;
541+text-align:right;
542+background-color:#F5F5F5;
543+}
544+
545+.celdaLineDataName{
546+font-size:5pt;
547+font-family: monospace;
548+text-align:left;
549+background-color:#F5F5F5;
550+}
551+
552+.celdaLineDataView{
553+font-size:5pt;
554+font-family:Arial,Helvetica,sans-serif;
555+text-align:right;
556+font-weight:bold;
557+background-color:#dcdcdc;
558+}
559+
560+.celdaLineDataNameView{
561+font-size:5pt;
562+font-family:Arial,Helvetica,sans-serif;
563+text-align:left;
564+font-weight:bold;
565+background-color:#dcdcdc;
566+}
567+
568+.celdaLineDataTotal{
569+font-size:5pt;
570+font-family:Arial,Helvetica,sans-serif;
571+text-align:right;
572+font-weight:bold;
573+background-color:#eaeaea;
574+}
575+
576+.celdaLineDataNameTotal{
577+font-size:5pt;
578+font-family:Arial,Helvetica,sans-serif;
579+text-align:left;
580+font-weight:bold;
581+background-color:#eaeaea;
582+}
583+
584+.celdaTituloTabla{
585+font-size:7pt;
586+text-align:left;
587+font-family:Arial,Helvetica,sans-serif;
588+background-color:#620400;
589+font-weight:bold;
590+color:#FFFFFF;
591+}
592+
593+div.td_company
594+{
595+font-size:11pt;
596+margin-left:0;
597+font-weight:bold;
598+font-family:Arial,Helvetica,sans-serif;
599+}
600+
601+div.td_company_date
602+{
603+font-size:9pt;
604+margin-left:0;
605+font-weight:bold;
606+font-family:Arial,Helvetica,sans-serif;
607+}
608+
609+div.td_company_title
610+{
611+font-size:15pt;
612+margin-left:0;
613+font-weight:bold;
614+font-family:Arial,Helvetica,sans-serif;
615+}
616+]]>
617+ </field>
618+ </record>
619+
620+ <record id="ir_header_webkit_afrreport_journal_ledger" model="ir.header_webkit">
621+ <field name="name">Reports AFR WebKit</field>
622+ <field name="footer_html">
623+<![CDATA[<html>
624+ <head>
625+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
626+ <script>
627+ function subst() {
628+ var vars={};
629+ var x=document.location.search.substring(1).split('&');
630+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
631+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
632+ for(var i in x) {
633+ var y = document.getElementsByClassName(x[i]);
634+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
635+ }
636+ }
637+ </script>
638+ </head>
639+ <body style="border:0; margin: 0;" onload="subst()">
640+ <table style="border-top: 1px solid black; width: 100%">
641+ <tr>
642+ <td style="float:right;text-align:left;font-size:10;" width="30%">
643+ <script type="text/javascript">
644+ var date = new Date();
645+ var d = date.getDate();
646+ var day = (d < 10) ? '0' + d : d;
647+ var m = date.getMonth() + 1;
648+ var month = (m < 10) ? '0' + m : m;
649+ var yy = date.getYear();
650+ var year = (yy < 1000) ? yy + 1900 : yy;
651+ var h = date.getHours();
652+ var hours = (h < 10) ? '0' + h : h;
653+ var mm = date.getMinutes();
654+ var minutes = (mm < 10) ? '0' + mm : mm;
655+ document.write("Printing Date: "+day + "/" + month + "/" + year +
656+ "\t\t" + hours+":" + minutes );
657+ </script>
658+ </td>
659+ <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>
660+ </tr>
661+ </table>
662+ </body>
663+</html>]]></field>
664+ <field name="orientation">Landscape</field>
665+ <field name="format">Letter</field>
666+ <field name="html">
667+<![CDATA[<html>
668+ <head>
669+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
670+ <script>
671+ function subst() {
672+ var vars={};
673+ var x=document.location.search.substring(1).split('&');
674+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
675+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
676+ for(var i in x) {
677+ var y = document.getElementsByClassName(x[i]);
678+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
679+ }
680+ }
681+ </script>
682+ <style type="text/css">
683+ ${css}
684+ </style>
685+ </head>
686+ <body style="border:0; margin: 0;" onload="subst()">
687+ ${_debug or ''|n}
688+ </body>
689+</html>]]>
690+</field>
691+ <field eval="0.0" name="margin_top"/>
692+ <field name="css" >
693+ <![CDATA[
694+table.basic_table{
695+text-align:left;
696+border:1px solid lightGrey;
697+border-collapse: collapse;
698+}
699+
700+.dest_address { font-size:12pt;
701+margin-left:0;
702+text-align:left; l
703+ine-height:80%;
704+padding-top:0px
705+}
706+
707+.celdaLineData{
708+font-size:7pt;
709+font-family: monospace;
710+text-align:right;
711+font-weight:bold;
712+background-color:#d1d1d1;
713+}
714+
715+.celdaLineDataName{
716+font-size:7pt;
717+font-family: monospace;
718+text-align:left;
719+font-weight:bold;
720+background-color:#d1d1d1;
721+}
722+
723+.celdaLineDataTotal{
724+font-size:7pt;
725+font-family:Arial,Helvetica,sans-serif;
726+text-align:right;
727+font-weight:bold;
728+background-color:#dcdcdc;
729+}
730+
731+.celdaLineDataNameTotal{
732+font-size:8pt;
733+font-family:Arial,Helvetica,sans-serif;
734+text-align:left;
735+font-weight:bold;
736+background-color:#dcdcdc;
737+}
738+
739+.celdaLineDataNamePartner{
740+font-size:7pt;
741+font-family: monospace;
742+text-align:left;
743+font-weight:bold;
744+background-color:#d1d1d1;
745+}
746+
747+.celdaLineDataAccountSimilar{
748+font-size:6pt;
749+font-family: monospace;
750+text-align:left;
751+background-color:#dcdcdc;
752+}
753+
754+.celdaLineDataAccount{
755+font-size:6pt;
756+font-family: monospace;
757+text-align:left;
758+background-color:#FFFFFF;
759+}
760+
761+.celdaTituloTabla{
762+font-size:8pt;
763+text-align:left;
764+font-family:Arial,Helvetica,sans-serif;
765+background-color:#620400;
766+font-weight:bold;
767+color:#FFFFFF;
768+}
769+
770+
771+div.td_company
772+{
773+font-size:11pt;
774+margin-left:0;
775+font-weight:bold;
776+font-family:Arial,Helvetica,sans-serif;
777+}
778+
779+div.td_company_date
780+{
781+font-size:9pt;
782+margin-left:0;
783+font-weight:bold;
784+font-family:Arial,Helvetica,sans-serif;
785+}
786+
787+div.td_company_title
788+{
789+font-size:15pt;
790+margin-left:0;
791+font-weight:bold;
792+font-family:Arial,Helvetica,sans-serif;
793+}
794+]]>
795+ </field>
796+ </record>
797+
798+
799+ <record id="ir_header_webkit_afrreport_four_colums" model="ir.header_webkit">
800+ <field name="name">Reports AFR WebKit</field>
801+ <field name="footer_html">
802+<![CDATA[<html>
803+ <head>
804+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
805+ <script>
806+ function subst() {
807+ var vars={};
808+ var x=document.location.search.substring(1).split('&');
809+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
810+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
811+ for(var i in x) {
812+ var y = document.getElementsByClassName(x[i]);
813+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
814+ }
815+ }
816+ </script>
817+ </head>
818+ <body style="border:0; margin: 0;" onload="subst()">
819+ <table style="border-top: 1px solid black; width: 100%">
820+ <tr>
821+ <td style="float:right;text-align:left;font-size:10;" width="30%">
822+ <script type="text/javascript">
823+ var date = new Date();
824+ var d = date.getDate();
825+ var day = (d < 10) ? '0' + d : d;
826+ var m = date.getMonth() + 1;
827+ var month = (m < 10) ? '0' + m : m;
828+ var yy = date.getYear();
829+ var year = (yy < 1000) ? yy + 1900 : yy;
830+ var h = date.getHours();
831+ var hours = (h < 10) ? '0' + h : h;
832+ var mm = date.getMinutes();
833+ var minutes = (mm < 10) ? '0' + mm : mm;
834+ document.write("Printing Date: "+day + "/" + month + "/" + year +
835+ "\t\t" + hours+":" + minutes );
836+ </script>
837+ </td>
838+ <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>
839+ </tr>
840+ </table>
841+ </body>
842+</html>]]></field>
843+ <field name="orientation">Portrait</field>
844+ <field name="format">Letter</field>
845+ <field name="html">
846+<![CDATA[<html>
847+ <head>
848+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
849+ <script>
850+ function subst() {
851+ var vars={};
852+ var x=document.location.search.substring(1).split('&');
853+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
854+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
855+ for(var i in x) {
856+ var y = document.getElementsByClassName(x[i]);
857+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
858+ }
859+ }
860+ </script>
861+ <style type="text/css">
862+ ${css}
863+ </style>
864+ </head>
865+ <body style="border:0; margin: 0;" onload="subst()">
866+ ${_debug or ''|n}
867+ </body>
868+</html>]]>
869+</field>
870+ <field eval="0.0" name="margin_top"/>
871+ <field name="css" >
872+ <![CDATA[
873+table.basic_table{
874+text-align:left;
875+border:1px solid lightGrey;
876+border-collapse: collapse;
877+}
878+
879+.dest_address { font-size:12pt;
880+margin-left:0;
881+text-align:left; l
882+ine-height:80%;
883+padding-top:0px
884+}
885+
886+.celdaLineData{
887+font-size:7pt;
888+font-family: monospace;
889+text-align:right;
890+background-color:#F5F5F5;
891+}
892+
893+.celdaLineDataName{
894+font-size:7pt;
895+font-family: monospace;
896+text-align:left;
897+background-color:#F5F5F5;
898+}
899+
900+.celdaLineDataView{
901+font-size:7pt;
902+font-family:Arial,Helvetica,sans-serif;
903+text-align:right;
904+font-weight:bold;
905+background-color:#dcdcdc;
906+}
907+
908+.celdaLineDataNameView{
909+font-size:7pt;
910+font-family:Arial,Helvetica,sans-serif;
911+text-align:left;
912+font-weight:bold;
913+background-color:#dcdcdc;
914+}
915+
916+.celdaLineDataTotal{
917+font-size:7pt;
918+font-family:Arial,Helvetica,sans-serif;
919+text-align:right;
920+font-weight:bold;
921+background-color:#eaeaea;
922+}
923+
924+.celdaLineDataNameTotal{
925+font-size:7pt;
926+font-family:Arial,Helvetica,sans-serif;
927+text-align:left;
928+font-weight:bold;
929+background-color:#eaeaea;
930+}
931+
932+.celdaTituloTabla{
933+font-size:9pt;
934+text-align:left;
935+font-family:Arial,Helvetica,sans-serif;
936+background-color:#620400;
937+font-weight:bold;
938+color:#FFFFFF;
939+}
940+
941+div.td_company
942+{
943+font-size:11pt;
944+margin-left:0;
945+font-weight:bold;
946+font-family:Arial,Helvetica,sans-serif;
947+}
948+
949+div.td_company_date
950+{
951+font-size:9pt;
952+margin-left:0;
953+font-weight:bold;
954+font-family:Arial,Helvetica,sans-serif;
955+}
956+
957+div.td_company_title
958+{
959+font-size:15pt;
960+margin-left:0;
961+font-weight:bold;
962+font-family:Arial,Helvetica,sans-serif;
963+}
964+]]>
965+ </field>
966+ </record>
967+
968+ <record id="ir_header_webkit_afrreport_two_colums" model="ir.header_webkit">
969+ <field name="name">Reports AFR WebKit</field>
970+ <field name="footer_html">
971+<![CDATA[<html>
972+ <head>
973+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
974+ <script>
975+ function subst() {
976+ var vars={};
977+ var x=document.location.search.substring(1).split('&');
978+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
979+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
980+ for(var i in x) {
981+ var y = document.getElementsByClassName(x[i]);
982+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
983+ }
984+ }
985+ </script>
986+ </head>
987+ <body style="border:0; margin: 0;" onload="subst()">
988+ <table style="border-top: 1px solid black; width: 100%">
989+ <tr>
990+ <td style="float:right;text-align:left;font-size:10;" width="30%">
991+ <script type="text/javascript">
992+ var date = new Date();
993+ var d = date.getDate();
994+ var day = (d < 10) ? '0' + d : d;
995+ var m = date.getMonth() + 1;
996+ var month = (m < 10) ? '0' + m : m;
997+ var yy = date.getYear();
998+ var year = (yy < 1000) ? yy + 1900 : yy;
999+ var h = date.getHours();
1000+ var hours = (h < 10) ? '0' + h : h;
1001+ var mm = date.getMinutes();
1002+ var minutes = (mm < 10) ? '0' + mm : mm;
1003+ document.write("Printing Date: "+day + "/" + month + "/" + year +
1004+ "\t\t" + hours+":" + minutes );
1005+ </script>
1006+ </td>
1007+ <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>
1008+ </tr>
1009+ </table>
1010+ </body>
1011+</html>]]></field>
1012+ <field name="orientation">Portrait</field>
1013+ <field name="format">Letter</field>
1014+ <field name="html">
1015+<![CDATA[<html>
1016+ <head>
1017+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
1018+ <script>
1019+ function subst() {
1020+ var vars={};
1021+ var x=document.location.search.substring(1).split('&');
1022+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
1023+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
1024+ for(var i in x) {
1025+ var y = document.getElementsByClassName(x[i]);
1026+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
1027+ }
1028+ }
1029+ </script>
1030+ <style type="text/css">
1031+ ${css}
1032+ </style>
1033+ </head>
1034+ <body style="border:0; margin: 0;" onload="subst()">
1035+ ${_debug or ''|n}
1036+ </body>
1037+</html>]]>
1038+</field>
1039+ <field eval="0.0" name="margin_top"/>
1040+ <field name="css" >
1041+ <![CDATA[
1042+table.basic_table{
1043+text-align:left;
1044+border:1px solid lightGrey;
1045+border-collapse: collapse;
1046+}
1047+
1048+.dest_address { font-size:12pt;
1049+margin-left:0;
1050+text-align:left; l
1051+ine-height:80%;
1052+padding-top:0px
1053+}
1054+
1055+.celdaLineData{
1056+font-size:9pt;
1057+font-family: monospace;
1058+text-align:right;
1059+background-color:#F5F5F5;
1060+}
1061+
1062+.celdaLineDataName{
1063+font-size:9pt;
1064+font-family: monospace;
1065+text-align:left;
1066+background-color:#F5F5F5;
1067+}
1068+
1069+.celdaLineDataView{
1070+font-size:9pt;
1071+font-family:Arial,Helvetica,sans-serif;
1072+text-align:right;
1073+font-weight:bold;
1074+background-color:#dcdcdc;
1075+}
1076+
1077+.celdaLineDataNameView{
1078+font-size:9pt;
1079+font-family:Arial,Helvetica,sans-serif;
1080+text-align:left;
1081+font-weight:bold;
1082+background-color:#dcdcdc;
1083+}
1084+
1085+.celdaLineDataTotal{
1086+font-size:9pt;
1087+font-family:Arial,Helvetica,sans-serif;
1088+text-align:right;
1089+font-weight:bold;
1090+background-color:#eaeaea;
1091+}
1092+
1093+.celdaLineDataNameTotal{
1094+font-size:9pt;
1095+font-family:Arial,Helvetica,sans-serif;
1096+text-align:left;
1097+font-weight:bold;
1098+background-color:#eaeaea;
1099+}
1100+
1101+.celdaTituloTabla{
1102+font-size:11pt;
1103+text-align:left;
1104+font-family:Arial,Helvetica,sans-serif;
1105+background-color:#620400;
1106+font-weight:bold;
1107+color:#FFFFFF;
1108+}
1109+
1110+div.td_company
1111+{
1112+font-size:11pt;
1113+margin-left:0;
1114+font-weight:bold;
1115+font-family:Arial,Helvetica,sans-serif;
1116+}
1117+
1118+div.td_company_date
1119+{
1120+font-size:9pt;
1121+margin-left:0;
1122+font-weight:bold;
1123+font-family:Arial,Helvetica,sans-serif;
1124+}
1125+
1126+div.td_company_title
1127+{
1128+font-size:15pt;
1129+margin-left:0;
1130+font-weight:bold;
1131+font-family:Arial,Helvetica,sans-serif;
1132+}
1133+]]>
1134+ </field>
1135+ </record>
1136+
1137+ <record id="ir_header_webkit_afrreport_one_colums" model="ir.header_webkit">
1138+ <field name="name">Reports AFR WebKit</field>
1139+ <field name="footer_html">
1140+<![CDATA[<html>
1141+ <head>
1142+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
1143+ <script>
1144+ function subst() {
1145+ var vars={};
1146+ var x=document.location.search.substring(1).split('&');
1147+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
1148+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
1149+ for(var i in x) {
1150+ var y = document.getElementsByClassName(x[i]);
1151+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
1152+ }
1153+ }
1154+ </script>
1155+ </head>
1156+ <body style="border:0; margin: 0;" onload="subst()">
1157+ <table style="border-top: 1px solid black; width: 100%">
1158+ <tr>
1159+ <td style="float:right;text-align:left;font-size:10;" width="30%">
1160+ <script type="text/javascript">
1161+ var date = new Date();
1162+ var d = date.getDate();
1163+ var day = (d < 10) ? '0' + d : d;
1164+ var m = date.getMonth() + 1;
1165+ var month = (m < 10) ? '0' + m : m;
1166+ var yy = date.getYear();
1167+ var year = (yy < 1000) ? yy + 1900 : yy;
1168+ var h = date.getHours();
1169+ var hours = (h < 10) ? '0' + h : h;
1170+ var mm = date.getMinutes();
1171+ var minutes = (mm < 10) ? '0' + mm : mm;
1172+ document.write("Printing Date: "+day + "/" + month + "/" + year +
1173+ "\t\t" + hours+":" + minutes );
1174+ </script>
1175+ </td>
1176+ <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>
1177+ </tr>
1178+ </table>
1179+ </body>
1180+</html>]]></field>
1181+ <field name="orientation">Portrait</field>
1182+ <field name="format">Letter</field>
1183+ <field name="html">
1184+<![CDATA[<html>
1185+ <head>
1186+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
1187+ <script>
1188+ function subst() {
1189+ var vars={};
1190+ var x=document.location.search.substring(1).split('&');
1191+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
1192+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
1193+ for(var i in x) {
1194+ var y = document.getElementsByClassName(x[i]);
1195+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
1196+ }
1197+ }
1198+ </script>
1199+ <style type="text/css">
1200+ ${css}
1201+ </style>
1202+ </head>
1203+ <body style="border:0; margin: 0;" onload="subst()">
1204+ ${_debug or ''|n}
1205+ </body>
1206+</html>]]>
1207+</field>
1208+ <field eval="0.0" name="margin_top"/>
1209+ <field name="css" >
1210+ <![CDATA[
1211+table.basic_table{
1212+text-align:left;
1213+border:1px solid lightGrey;
1214+border-collapse: collapse;
1215+}
1216+
1217+.dest_address { font-size:12pt;
1218+margin-left:0;
1219+text-align:left; l
1220+ine-height:80%;
1221+padding-top:0px
1222+}
1223+
1224+.celdaLineData{
1225+font-size:9pt;
1226+font-family: monospace;
1227+text-align:right;
1228+background-color:#F5F5F5;
1229+}
1230+
1231+.celdaLineDataName{
1232+font-size:9pt;
1233+font-family: monospace;
1234+text-align:left;
1235+background-color:#F5F5F5;
1236+}
1237+
1238+.celdaLineDataView{
1239+font-size:9pt;
1240+font-family:Arial,Helvetica,sans-serif;
1241+text-align:right;
1242+font-weight:bold;
1243+background-color:#dcdcdc;
1244+}
1245+
1246+.celdaLineDataNameView{
1247+font-size:9pt;
1248+font-family:Arial,Helvetica,sans-serif;
1249+text-align:left;
1250+font-weight:bold;
1251+background-color:#dcdcdc;
1252+}
1253+
1254+.celdaLineDataTotal{
1255+font-size:9pt;
1256+font-family:Arial,Helvetica,sans-serif;
1257+text-align:right;
1258+font-weight:bold;
1259+background-color:#eaeaea;
1260+}
1261+
1262+.celdaLineDataNameTotal{
1263+font-size:9pt;
1264+font-family:Arial,Helvetica,sans-serif;
1265+text-align:left;
1266+font-weight:bold;
1267+background-color:#eaeaea;
1268+}
1269+
1270+.celdaTituloTabla{
1271+font-size:11pt;
1272+text-align:left;
1273+font-family:Arial,Helvetica,sans-serif;
1274+background-color:#620400;
1275+font-weight:bold;
1276+color:#FFFFFF;
1277+}
1278+
1279+div.td_company
1280+{
1281+font-size:11pt;
1282+margin-left:0;
1283+font-weight:bold;
1284+font-family:Arial,Helvetica,sans-serif;
1285+}
1286+
1287+div.td_company_date
1288+{
1289+font-size:9pt;
1290+margin-left:0;
1291+font-weight:bold;
1292+font-family:Arial,Helvetica,sans-serif;
1293+}
1294+
1295+div.td_company_title
1296+{
1297+font-size:15pt;
1298+margin-left:0;
1299+font-weight:bold;
1300+font-family:Arial,Helvetica,sans-serif;
1301+}
1302+]]>
1303+ </field>
1304+ </record>
1305+
1306+ <record id="ir_header_webkit_afrreport_five_colums" model="ir.header_webkit">
1307+ <field name="name">Reports AFR WebKit Five Columns</field>
1308+ <field name="footer_html">
1309+<![CDATA[<html>
1310+ <head>
1311+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
1312+ <script>
1313+ function subst() {
1314+ var vars={};
1315+ var x=document.location.search.substring(1).split('&');
1316+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
1317+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
1318+ for(var i in x) {
1319+ var y = document.getElementsByClassName(x[i]);
1320+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
1321+ }
1322+ }
1323+ </script>
1324+ </head>
1325+ <body style="border:0; margin: 0;" onload="subst()">
1326+ <table style="border-top: 1px solid black; width: 100%">
1327+ <tr>
1328+ <td style="float:right;text-align:left;font-size:10;" width="30%">
1329+ <script type="text/javascript">
1330+ var date = new Date();
1331+ var d = date.getDate();
1332+ var day = (d < 10) ? '0' + d : d;
1333+ var m = date.getMonth() + 1;
1334+ var month = (m < 10) ? '0' + m : m;
1335+ var yy = date.getYear();
1336+ var year = (yy < 1000) ? yy + 1900 : yy;
1337+ var h = date.getHours();
1338+ var hours = (h < 10) ? '0' + h : h;
1339+ var mm = date.getMinutes();
1340+ var minutes = (mm < 10) ? '0' + mm : mm;
1341+ document.write("Printing Date: "+day + "/" + month + "/" + year +
1342+ "\t\t" + hours+":" + minutes );
1343+ </script>
1344+ </td>
1345+ <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>
1346+ </tr>
1347+ </table>
1348+ </body>
1349+</html>]]></field>
1350+ <field name="orientation">Portrait</field>
1351+ <field name="format">Letter</field>
1352+ <field name="html">
1353+<![CDATA[<html>
1354+ <head>
1355+ <meta content="text/html; charset=UTF-8" http-equiv="content-type"/>
1356+ <script>
1357+ function subst() {
1358+ var vars={};
1359+ var x=document.location.search.substring(1).split('&');
1360+ for(var i in x) {var z=x[i].split('=',2);vars[z[0]] = unescape(z[1]);}
1361+ var x=['frompage','topage','page','webpage','section','subsection','subsubsection'];
1362+ for(var i in x) {
1363+ var y = document.getElementsByClassName(x[i]);
1364+ for(var j=0; j<y.length; ++j) y[j].textContent = vars[x[i]];
1365+ }
1366+ }
1367+ </script>
1368+ <style type="text/css">
1369+ ${css}
1370+ </style>
1371+ </head>
1372+ <body style="border:0; margin: 0;" onload="subst()">
1373+ ${_debug or ''|n}
1374+ </body>
1375+</html>]]>
1376+</field>
1377+ <field eval="0.0" name="margin_top"/>
1378+ <field name="css" >
1379+ <![CDATA[
1380+table.basic_table{
1381+text-align:left;
1382+border:1px solid lightGrey;
1383+border-collapse: collapse;
1384+}
1385+
1386+.dest_address { font-size:12pt;
1387+margin-left:0;
1388+text-align:left; l
1389+ine-height:80%;
1390+padding-top:0px
1391+}
1392+
1393+.celdaLineData{
1394+font-size:7pt;
1395+font-family: monospace;
1396+text-align:right;
1397+background-color:#F5F5F5;
1398+}
1399+
1400+.celdaLineDataName{
1401+font-size:7pt;
1402+font-family: monospace;
1403+text-align:left;
1404+background-color:#F5F5F5;
1405+}
1406+
1407+.celdaLineDataView{
1408+font-size:7pt;
1409+font-family:Arial,Helvetica,sans-serif;
1410+text-align:right;
1411+font-weight:bold;
1412+background-color:#dcdcdc;
1413+}
1414+
1415+.celdaLineDataNameView{
1416+font-size:7pt;
1417+font-family:Arial,Helvetica,sans-serif;
1418+text-align:left;
1419+font-weight:bold;
1420+background-color:#dcdcdc;
1421+}
1422+
1423+.celdaLineDataTotal{
1424+font-size:7pt;
1425+font-family:Arial,Helvetica,sans-serif;
1426+text-align:right;
1427+font-weight:bold;
1428+background-color:#eaeaea;
1429+}
1430+
1431+.celdaLineDataNameTotal{
1432+font-size:7pt;
1433+font-family:Arial,Helvetica,sans-serif;
1434+text-align:left;
1435+font-weight:bold;
1436+background-color:#eaeaea;
1437+}
1438+
1439+.celdaTituloTabla{
1440+font-size:9pt;
1441+text-align:left;
1442+font-family:Arial,Helvetica,sans-serif;
1443+background-color:#620400;
1444+font-weight:bold;
1445+color:#FFFFFF;
1446+}
1447+
1448+div.td_company
1449+{
1450+font-size:11pt;
1451+margin-left:0;
1452+font-weight:bold;
1453+font-family:Arial,Helvetica,sans-serif;
1454+}
1455+
1456+div.td_company_date
1457+{
1458+font-size:9pt;
1459+margin-left:0;
1460+font-weight:bold;
1461+font-family:Arial,Helvetica,sans-serif;
1462+}
1463+
1464+div.td_company_title
1465+{
1466+font-size:15pt;
1467+margin-left:0;
1468+font-weight:bold;
1469+font-family:Arial,Helvetica,sans-serif;
1470+}
1471+]]>
1472+ </field>
1473+ </record>
1474+
1475+ <record id="ir_header_img_companylogo0" model="ir.header_img">
1476+ <field eval="&quot;&quot;&quot;jpg&quot;&quot;&quot;" name="type"/>
1477+ <field eval="&quot;&quot;&quot;company_logo&quot;&quot;&quot;" name="name"/>
1478+ </record>
1479+
1480+ </data>
1481+</openerp>
1482
1483=== added directory 'account_financial_report_exportable/demo'
1484=== added directory 'account_financial_report_exportable/doc'
1485=== added directory 'account_financial_report_exportable/doc/images'
1486=== added directory 'account_financial_report_exportable/i18n'
1487=== added file 'account_financial_report_exportable/i18n/es.po'
1488--- account_financial_report_exportable/i18n/es.po 1970-01-01 00:00:00 +0000
1489+++ account_financial_report_exportable/i18n/es.po 2013-10-23 14:40:32 +0000
1490@@ -0,0 +1,57 @@
1491+# Translation of OpenERP Server.
1492+# This file contains the translation of the following modules:
1493+# * account_financial_report_exportable
1494+#
1495+msgid ""
1496+msgstr ""
1497+"Project-Id-Version: OpenERP Server 7.0\n"
1498+"Report-Msgid-Bugs-To: \n"
1499+"POT-Creation-Date: 2013-10-21 19:57+0000\n"
1500+"PO-Revision-Date: 2013-10-21 14:58-0600\n"
1501+"Last-Translator: <>\n"
1502+"Language-Team: \n"
1503+"MIME-Version: 1.0\n"
1504+"Content-Type: text/plain; charset=UTF-8\n"
1505+"Content-Transfer-Encoding: 8bit\n"
1506+"Plural-Forms: \n"
1507+
1508+#. module: account_financial_report_exportable
1509+#: model:ir.model,name:account_financial_report_exportable.model_wizard_report
1510+msgid "wizard.report"
1511+msgstr "wizard.report"
1512+
1513+#. module: account_financial_report_exportable
1514+#: selection:wizard.report,report_format:0
1515+msgid "PDF"
1516+msgstr "PDF"
1517+
1518+#. module: account_financial_report_exportable
1519+#: field:wizard.report,report_format:0
1520+msgid "Report Format"
1521+msgstr "Formato del Reporte"
1522+
1523+#. module: account_financial_report_exportable
1524+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger
1525+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger_html
1526+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1
1527+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13
1528+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13_html
1529+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1_html
1530+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2
1531+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2_html
1532+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4
1533+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4_html
1534+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5
1535+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5_html
1536+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger
1537+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger_html
1538+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr
1539+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr_html
1540+msgid "Print AFR"
1541+msgstr "Imprimir AFR"
1542+
1543+#. module: account_financial_report_exportable
1544+#: selection:wizard.report,report_format:0
1545+msgid "Spreadsheet"
1546+msgstr "Hoja de Calculo"
1547+
1548
1549=== added file 'account_financial_report_exportable/i18n/es_MX.po'
1550--- account_financial_report_exportable/i18n/es_MX.po 1970-01-01 00:00:00 +0000
1551+++ account_financial_report_exportable/i18n/es_MX.po 2013-10-23 14:40:32 +0000
1552@@ -0,0 +1,57 @@
1553+# Translation of OpenERP Server.
1554+# This file contains the translation of the following modules:
1555+# * account_financial_report_exportable
1556+#
1557+msgid ""
1558+msgstr ""
1559+"Project-Id-Version: OpenERP Server 7.0\n"
1560+"Report-Msgid-Bugs-To: \n"
1561+"POT-Creation-Date: 2013-10-21 19:57+0000\n"
1562+"PO-Revision-Date: 2013-10-21 14:58-0600\n"
1563+"Last-Translator: <>\n"
1564+"Language-Team: \n"
1565+"MIME-Version: 1.0\n"
1566+"Content-Type: text/plain; charset=UTF-8\n"
1567+"Content-Transfer-Encoding: 8bit\n"
1568+"Plural-Forms: \n"
1569+
1570+#. module: account_financial_report_exportable
1571+#: model:ir.model,name:account_financial_report_exportable.model_wizard_report
1572+msgid "wizard.report"
1573+msgstr "wizard.report"
1574+
1575+#. module: account_financial_report_exportable
1576+#: selection:wizard.report,report_format:0
1577+msgid "PDF"
1578+msgstr "PDF"
1579+
1580+#. module: account_financial_report_exportable
1581+#: field:wizard.report,report_format:0
1582+msgid "Report Format"
1583+msgstr "Formato del Reporte"
1584+
1585+#. module: account_financial_report_exportable
1586+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger
1587+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_analytic_ledger_html
1588+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1
1589+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13
1590+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col13_html
1591+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col1_html
1592+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2
1593+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col2_html
1594+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4
1595+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col4_html
1596+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5
1597+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_col5_html
1598+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger
1599+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_journal_ledger_html
1600+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr
1601+#: model:ir.actions.report.xml,name:account_financial_report_exportable.afr_report_qtr_html
1602+msgid "Print AFR"
1603+msgstr "Imprimir AFR"
1604+
1605+#. module: account_financial_report_exportable
1606+#: selection:wizard.report,report_format:0
1607+msgid "Spreadsheet"
1608+msgstr "Hoja de Calculo"
1609+
1610
1611=== added directory 'account_financial_report_exportable/model'
1612=== added file 'account_financial_report_exportable/model/__init__.py'
1613--- account_financial_report_exportable/model/__init__.py 1970-01-01 00:00:00 +0000
1614+++ account_financial_report_exportable/model/__init__.py 2013-10-23 14:40:32 +0000
1615@@ -0,0 +1,25 @@
1616+#!/usr/bin/python
1617+# -*- encoding: utf-8 -*-
1618+###############################################################################
1619+# Module Writen to OpenERP, Open Source Management Solution
1620+# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
1621+# All Rights Reserved
1622+############# Credits #########################################################
1623+# Coded by: Yanina Aular <yani@vauxoo.com>
1624+# Planified by: Humberto Arocha <hbto@vauxoo.com>
1625+# Audited by: Humberto Arocha <hbto@vauxoo.com>
1626+###############################################################################
1627+# This program is free software: you can redistribute it and/or modify
1628+# it under the terms of the GNU Affero General Public License as published
1629+# by the Free Software Foundation, either version 3 of the License, or
1630+# (at your option) any later version.
1631+#
1632+# This program is distributed in the hope that it will be useful,
1633+# but WITHOUT ANY WARRANTY; without even the implied warranty of
1634+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
1635+# GNU Affero General Public License for more details.
1636+#
1637+# You should have received a copy of the GNU Affero General Public License
1638+# along with this program. If not, see <http://www.gnu.org/licenses/>.
1639+###############################################################################
1640+
1641
1642=== added directory 'account_financial_report_exportable/report'
1643=== added file 'account_financial_report_exportable/report/__init__.py'
1644--- account_financial_report_exportable/report/__init__.py 1970-01-01 00:00:00 +0000
1645+++ account_financial_report_exportable/report/__init__.py 2013-10-23 14:40:32 +0000
1646@@ -0,0 +1,25 @@
1647+#!/usr/bin/python
1648+# -*- encoding: utf-8 -*-
1649+###############################################################################
1650+# Module Writen to OpenERP, Open Source Management Solution
1651+# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
1652+# All Rights Reserved
1653+############# Credits #########################################################
1654+# Coded by: Yanina Aular <yani@vauxoo.com>
1655+# Planified by: Humberto Arocha <hbto@vauxoo.com>
1656+# Audited by: Humberto Arocha <hbto@vauxoo.com>
1657+###############################################################################
1658+# This program is free software: you can redistribute it and/or modify
1659+# it under the terms of the GNU Affero General Public License as published
1660+# by the Free Software Foundation, either version 3 of the License, or
1661+# (at your option) any later version.
1662+#
1663+# This program is distributed in the hope that it will be useful,
1664+# but WITHOUT ANY WARRANTY; without even the implied warranty of
1665+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
1666+# GNU Affero General Public License for more details.
1667+#
1668+# You should have received a copy of the GNU Affero General Public License
1669+# along with this program. If not, see <http://www.gnu.org/licenses/>.
1670+###############################################################################
1671+
1672
1673=== added file 'account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako'
1674--- account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako 1970-01-01 00:00:00 +0000
1675+++ account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako 2013-10-23 14:40:32 +0000
1676@@ -0,0 +1,103 @@
1677+<!DOCTYPE html SYSTEM
1678+"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
1679+<html xmlns="http://www.w3.org/1999/xhtml">
1680+<head>
1681+<style type="text/css">
1682+ ${css}
1683+</style>
1684+</head>
1685+
1686+<body style="border:0; margin: 0;" onload="subst()" >
1687+%for obj in objects:
1688+<table width="100%">
1689+ <tr>
1690+ <td>
1691+ <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
1692+ </td>
1693+ <td>
1694+ <table style="width: 100%; text-align:center;">
1695+ <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
1696+ <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
1697+ <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
1698+ <tr><td><div class="td_company">${_(Expressed in data['form'] and (' %s'% obj.get_parser_method('exchange_name',data['form'])) or '')}</div></td></tr>
1699+ <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
1700+ </table>
1701+ </td>
1702+ </tr>
1703+</table>
1704+
1705+<table width="100%">
1706+ <thead>
1707+ <tr>
1708+ <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
1709+ </tr>
1710+ </thead>
1711+</table>
1712+<table width="100%">
1713+ <thead>
1714+ <tr>
1715+ <td class="celdaTituloTabla" style="text-align:right" width="10%">${_('CODE')}</td>
1716+ <td class="celdaTituloTabla" width="50%">${_('ACCOUNT')}</td>
1717+ <td class="celdaTituloTabla" width="10%" style="text-align:center;" >${_('INICIAL')}</td>
1718+ <td class="celdaTituloTabla" width="10%" style="text-align:center;" >${_('DEBIT')}</td>
1719+ <td class="celdaTituloTabla" width="10%" style="text-align:center;" >${_('CREDIT')}</td>
1720+ <td class="celdaTituloTabla" width="10%" style="text-align:center;" >${_('BALANCE')}</td>
1721+ </tr>
1722+ </thead>
1723+</table>
1724+<table width="100%">
1725+ <thead>
1726+ <tr>
1727+ <td class="celdaTituloTabla" style="text-align:left;" width="10%">${_('DATE')}</td>
1728+ <td class="celdaTituloTabla" width="10%">${_('PERIOD')}</td>
1729+ <td class="celdaTituloTabla" width="30%">${_('REFERENCE')}</td>
1730+ <td class="celdaTituloTabla" width="30%">${_('JOURNAL ENTRY')}</td>
1731+ <td class="celdaTituloTabla" width="10%">${_('PARTNER')}</td>
1732+ <td class="celdaTituloTabla" width="10%" ></td>
1733+ </tr>
1734+ </thead>
1735+</table>
1736+<table width="100%">
1737+ <tr>
1738+ <td width="10%"></td>
1739+ <td width="10%"></td>
1740+ <td width="10%"></td>
1741+ <td width="10%"></td>
1742+ <td width="10%"></td>
1743+ <td width="10%"></td>
1744+ <td width="10%"></td>
1745+ <td width="10%"></td>
1746+ <td width="10%"></td>
1747+ <td width="10%"></td>
1748+ </tr>
1749+ %for line in obj.get_parser_method('lines',data['form']):
1750+ %if line['type']!= 'view':
1751+ <tbody>
1752+ <tr>
1753+ <td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td>
1754+ <td class="celdaLineDataNameTotal" colspan="5">${line['name'].upper() or line['name'].title() or ''}</td>
1755+ <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>
1756+ <td class="celdaLineDataTotal" width="10%" style="text-align:right;">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
1757+ <td class="celdaLineDataTotal" width="10%" style="text-align:right;">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
1758+ <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>
1759+ </tr>
1760+ </tbody>
1761+ %for m in line['mayor']:
1762+ <tbody>
1763+ <tr>
1764+ <td class="celdaLineData" style="text-align:left;font-style:italic;" width="10%">${formatLang( m['date'], date=True) or ''}</td>
1765+ <td class="celdaLineData" style="text-align:left;" width="10%">${m['period'] or ''}</td>
1766+ <td class="celdaLineDataNamePartner" colspan="3">${m['name'] or ''} ${m['ref'] and (' - Ref %s'%m['ref']) or ''}</td>
1767+ <td class="celdaLineDataNamePartner" colspan="3">${m['entry'] or ''}</td>
1768+ <td class="celdaLineDataNamePartner" width="10%">${m['partner'] or ''}</td>
1769+ <td class="celdaLineData" width="10%"></td>
1770+ </tr>
1771+ </tbody>
1772+ %endfor
1773+ %endif
1774+ %endfor
1775+</table>
1776+
1777+%endfor
1778+</body>
1779+</html>
1780
1781=== added file 'account_financial_report_exportable/report/afr_report_webkit_cols1.mako'
1782--- account_financial_report_exportable/report/afr_report_webkit_cols1.mako 1970-01-01 00:00:00 +0000
1783+++ account_financial_report_exportable/report/afr_report_webkit_cols1.mako 2013-10-23 14:40:32 +0000
1784@@ -0,0 +1,71 @@
1785+<!DOCTYPE html SYSTEM
1786+"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
1787+<html xmlns="http://www.w3.org/1999/xhtml">
1788+<head>
1789+<style type="text/css">
1790+ ${css}
1791+</style>
1792+</head>
1793+
1794+<body style="border:0; margin: 0;" onload="subst()" >
1795+ %for obj in objects:
1796+ <table>
1797+ <tr>
1798+ <td width="30%">
1799+ <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
1800+ </td>
1801+ <td width="70%">
1802+ <table style="width: 100%; text-align:center;">
1803+ <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
1804+ <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
1805+ <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
1806+ <tr><td><div class="td_company">${_(Expressed in data['form'] and (' %s'% obj.get_parser_method('exchange_name',data['form'])) or '')}</div></td></tr>
1807+ <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
1808+ </table>
1809+ </td>
1810+ <td>
1811+ </td>
1812+ </tr>
1813+ </table>
1814+ <table width="100%">
1815+ <thead>
1816+ <tr>
1817+ <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
1818+ </tr>
1819+ </thead>
1820+ </table>
1821+ <table width="100%">
1822+ <tbody>
1823+ <tr class="prueba">
1824+ <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('CODE')}</td>
1825+ <td class="celdaTituloTabla" width="70%">${_('ACCOUNT')}</td>
1826+ <center>
1827+ <td class="celdaTituloTabla" style="text-align:center;" width="20%">${_('BALANCE')}</td>
1828+ </center>
1829+ </tr>
1830+ %for line in obj.get_parser_method('lines',data['form']):
1831+ %if line['type'] != 'view':
1832+ <tr class="prueba">
1833+ <i><td class="celdaLineData" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
1834+ <td class="celdaLineDataName" width="70%">${line['name'].upper() or line['name'].title() or ''}</td>
1835+ <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>
1836+ </tr>
1837+ %elif line['total'] and not line['label']:
1838+ <tr class="prueba">
1839+ <i><td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="10%">${(line['label'] == True ) and line['code'] or ''}</td></i>
1840+ <td class="celdaLineDataTotal" style="text-align:right;" width="70%">${(line['type'] == 'view') and line['name'].upper() or line['name'].title() or ''}</td>
1841+ <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>
1842+ </tr>
1843+ %else:
1844+ <tr class="prueba">
1845+ <i><td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="10%">${(line['label'] == True ) and line['code'] or ''}</td></i>
1846+ <td class="celdaLineDataNameView" width="70%">${line['name'].upper() or line['name'].title() or ''}</td>
1847+ <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>
1848+ </tr>
1849+ %endif
1850+ %endfor
1851+ </tbody>
1852+ </table>
1853+ %endfor
1854+</body>
1855+</html>
1856
1857=== added file 'account_financial_report_exportable/report/afr_report_webkit_cols13.mako'
1858--- account_financial_report_exportable/report/afr_report_webkit_cols13.mako 1970-01-01 00:00:00 +0000
1859+++ account_financial_report_exportable/report/afr_report_webkit_cols13.mako 2013-10-23 14:40:32 +0000
1860@@ -0,0 +1,102 @@
1861+<!DOCTYPE html SYSTEM
1862+"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
1863+<html xmlns="http://www.w3.org/1999/xhtml">
1864+<head>
1865+<style type="text/css">
1866+ ${css}
1867+</style>
1868+</head>
1869+
1870+<body style="border:0; margin: 0;" onload="subst()" >
1871+<!--
1872+<h1><center>12 Months | YTD</center></h1>
1873+-->
1874+ %for obj in objects:
1875+ <table>
1876+ <tr>
1877+ <td width="30%">
1878+ <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
1879+ </td>
1880+ <td width="70%">
1881+ <table style="width: 100%; text-align:center;">
1882+ <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
1883+ <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
1884+ <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
1885+ <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
1886+ </table>
1887+ </td>
1888+ </tr>
1889+ </table>
1890+ <table width="100%">
1891+ <thead>
1892+ <tr>
1893+ <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>
1894+ </tr>
1895+ </thead>
1896+ <tbody>
1897+ <tr class="prueba">
1898+ <td class="celdaTituloTabla" style="text-align:right;" width="6%">${_('CODE')}</td>
1899+ <td class="celdaTituloTabla" width="16%">${_('ACCOUNT')}</td>
1900+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('01')}</td>
1901+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('02')}</td>
1902+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('03')}</td>
1903+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('04')}</td>
1904+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('05')}</td>
1905+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('06')}</td>
1906+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('07')}</td>
1907+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('08')}</td>
1908+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('09')}</td>
1909+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('10')}</td>
1910+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('11')}</td>
1911+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('12')}</td>
1912+ <td class="celdaTituloTabla" style="text-align:center;" width="6%">${_('YTD')}</td>
1913+ </tr>
1914+ %for line in obj.get_parser_method('lines',data['form']):
1915+ %if line['type'] != 'view':
1916+ <tr>
1917+ <td class="celdaLineData" style="text-align:right;font-style:italic;" width="6%">${line['code'] or ''}</td>
1918+ <td class="celdaLineDataName" width="16%">${line['name'].upper() or line['name'].title() or ''}</td>
1919+ <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>
1920+ <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>
1921+ <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>
1922+ <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>
1923+ <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>
1924+ <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>
1925+ <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>
1926+ <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>
1927+ <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>
1928+ <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>
1929+ <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>
1930+ <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>
1931+ <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>
1932+ </tr>
1933+ %elif line['total'] and not line['label']:
1934+ <tr>
1935+ <td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="6%">${line['code'] or ''}</td>
1936+ <td class="celdaLineDataTotal" width="16%">${line['name'].upper() or line['name'].title() or ''}</td>
1937+ <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>
1938+ <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>
1939+ <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>
1940+ <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>
1941+ <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>
1942+ <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>
1943+ <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>
1944+ <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>
1945+ <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>
1946+ <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>
1947+ <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>
1948+ <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>
1949+ <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>
1950+ </tr>
1951+ %else:
1952+ <tr>
1953+ <td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="6%">${line['code'] or ''}</td>
1954+ <td class="celdaLineDataNameView" colspan="14">${line['name'].upper() or line['name'].title() or ''}</td>
1955+ </tr>
1956+ %endif
1957+ %endfor
1958+ </tbody>
1959+ </table>
1960+%endfor
1961+</body>
1962+</html>
1963
1964=== added file 'account_financial_report_exportable/report/afr_report_webkit_cols2.mako'
1965--- account_financial_report_exportable/report/afr_report_webkit_cols2.mako 1970-01-01 00:00:00 +0000
1966+++ account_financial_report_exportable/report/afr_report_webkit_cols2.mako 2013-10-23 14:40:32 +0000
1967@@ -0,0 +1,80 @@
1968+<!DOCTYPE html SYSTEM
1969+"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
1970+<html xmlns="http://www.w3.org/1999/xhtml">
1971+<head>
1972+<style type="text/css">
1973+ ${css}
1974+</style>
1975+</head>
1976+
1977+<body style="border:0; margin: 0;" onload="subst()" >
1978+
1979+<!--
1980+ <h1><center>Debit | Credit</center></h1>
1981+-->
1982+ %for obj in objects:
1983+ <table>
1984+ <tr>
1985+ <td width="30%">
1986+ <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
1987+ </td>
1988+ <td width="70%">
1989+ <table style="width: 100%; text-align:center;">
1990+ <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
1991+ <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
1992+ <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
1993+ <tr><td><div class="td_company">${_(Expressed in data['form'] and (' %s'% obj.get_parser_method('exchange_name',data['form'])) or '')}</div></td></tr>
1994+ <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
1995+ </table>
1996+ </td>
1997+ <td>
1998+ </td>
1999+ </tr>
2000+ </table>
2001+ <table width="100%">
2002+ <thead>
2003+ <tr>
2004+ <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
2005+ </tr>
2006+ </thead>
2007+ </table>
2008+ <table width="100%">
2009+ <tbody>
2010+ <tr class="prueba">
2011+ <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('CODE')}</td>
2012+ <td class="celdaTituloTabla" width="50%">${_('ACCOUNT')}</td>
2013+ <center>
2014+ <td class="celdaTituloTabla" style="text-align:center;" width="20%">${_('DEBIT')}</td>
2015+ <td class="celdaTituloTabla" style="text-align:center;" width="20%">${_('CREDIT')}</td>
2016+ </center>
2017+ </tr>
2018+ %for line in obj.get_parser_method('lines',data['form']):
2019+
2020+ %if line['type'] != 'view':
2021+ <tr class="prueba">
2022+ <i><td class="celdaLineData" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
2023+ <td class="celdaLineDataName" width="50%">${line['name'].upper() or line['name'].title() or ''}</td>
2024+ <td class="celdaLineData" width="20%">${formatLang(line['debit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
2025+ <td class="celdaLineData" width="20%">${formatLang(line['credit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
2026+ </tr>
2027+ %elif line['total'] and not line['label']:
2028+ <tr class="prueba">
2029+ <i><td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
2030+ <td class="celdaLineDataTotal" style="text-align:right;" width="50%">${line['name'].upper() or line['name'].title() or ''}</td>
2031+ <td class="celdaLineDataTotal" width="20%">${formatLang(line['debit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
2032+ <td class="celdaLineDataTotal" width="20%">${formatLang(line['credit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
2033+ </tr>
2034+ %else:
2035+ <tr class="prueba">
2036+ <i><td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="10%">${(line['label'] == True ) and line['code'] or ''}</td></i>
2037+ <td class="celdaLineDataNameView" width="50%">${line['name'].upper() or line['name'].title() or ''}</td>
2038+ <td class="celdaLineDataView" width="20%">${formatLang(line['debit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
2039+ <td class="celdaLineDataView" width="20%">${formatLang(line['credit'], digits=2, date=False, date_time=False, grouping=3, monetary=True) or ''}</td>
2040+ </tr>
2041+ %endif
2042+ %endfor
2043+ </tbody>
2044+ </table>
2045+ %endfor
2046+</body>
2047+</html>
2048
2049=== added file 'account_financial_report_exportable/report/afr_report_webkit_cols4.mako'
2050--- account_financial_report_exportable/report/afr_report_webkit_cols4.mako 1970-01-01 00:00:00 +0000
2051+++ account_financial_report_exportable/report/afr_report_webkit_cols4.mako 2013-10-23 14:40:32 +0000
2052@@ -0,0 +1,86 @@
2053+<!DOCTYPE html SYSTEM
2054+"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2055+<html xmlns="http://www.w3.org/1999/xhtml">
2056+<head>
2057+<style type="text/css">
2058+ ${css}
2059+</style>
2060+</head>
2061+
2062+<body style="border:0; margin: 0;" onload="subst()" >
2063+
2064+
2065+<!--
2066+ <h1><center>Initial | Debit | Credit | YTD</center></h1>
2067+-->
2068+ %for obj in objects:
2069+ <table>
2070+ <tr>
2071+ <td width="30%">
2072+ <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
2073+ </td>
2074+ <td width="70%">
2075+ <table style="width: 100%; text-align:center;">
2076+ <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
2077+ <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
2078+ <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
2079+ <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
2080+ </table>
2081+ </td>
2082+ <td>
2083+ </td>
2084+ </tr>
2085+ </table>
2086+ <table width="100%">
2087+ <thead>
2088+ <tr>
2089+ <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
2090+ </tr>
2091+ </thead>
2092+ </table>
2093+ <table width="100%">
2094+ <tbody>
2095+ <tr>
2096+ <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('CODE')}</td>
2097+ <td class="celdaTituloTabla" width="42%">${_('ACCOUNT')}</td>
2098+ <td class="celdaTituloTabla" style="text-align:center;" width="12%">${_('INICIAL')}</td>
2099+ <td class="celdaTituloTabla" style="text-align:center;" width="12%">${_('DEBIT')}</td>
2100+ <td class="celdaTituloTabla" style="text-align:center;" width="12%">${_('CREDIT')}</td>
2101+ <td class="celdaTituloTabla" style="text-align:center;" width="12%">${_('BALANCE')}</td>
2102+ </tr>
2103+ %for line in obj.get_parser_method('lines',data['form']):
2104+ %if line['type'] != 'view':
2105+ <tr>
2106+ <i><td class="celdaLineData" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
2107+ <td class="celdaLineDataName" width="42%">${line['name'].upper() or line['name'].title() or ''}</td>
2108+ <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>
2109+ <td class="celdaLineData" width="12%">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
2110+ <td class="celdaLineData" width="12%">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
2111+ <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>
2112+ </tr>
2113+ %elif line['total'] and not line['label']:
2114+ <tr>
2115+ <i><td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
2116+ <td class="celdaLineDataTotal" style="text-align:right;" width="42%">${line['name'].upper() or line['name'].title() or ''}</td>
2117+ <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>
2118+ <td class="celdaLineDataTotal" width="12%">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
2119+ <td class="celdaLineDataTotal" width="12%">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
2120+ <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>
2121+ </tr>
2122+ %else:
2123+ <tr>
2124+ <td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td>
2125+ <td class="celdaLineDataNameView" width="42%">${line['name'].upper() or line['name'].title() or ''}</td>
2126+ <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>
2127+ <td class="celdaLineDataView" width="12%">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
2128+ <td class="celdaLineDataView" width="12%">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
2129+ <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>
2130+ </tr>
2131+ %endif
2132+ %endfor
2133+ </tbody>
2134+ </table>
2135+
2136+%endfor
2137+</body>
2138+</html>
2139
2140=== added file 'account_financial_report_exportable/report/afr_report_webkit_cols5.mako'
2141--- account_financial_report_exportable/report/afr_report_webkit_cols5.mako 1970-01-01 00:00:00 +0000
2142+++ account_financial_report_exportable/report/afr_report_webkit_cols5.mako 2013-10-23 14:40:32 +0000
2143@@ -0,0 +1,76 @@
2144+<!DOCTYPE html SYSTEM
2145+"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2146+<html xmlns="http://www.w3.org/1999/xhtml">
2147+<head>
2148+<style type="text/css">
2149+ ${css}
2150+</style>
2151+</head>
2152+
2153+<body style="border:0; margin: 0;" onload="subst()" >
2154+
2155+%for obj in objects:
2156+<table>
2157+ <tr>
2158+ <td width="30%">
2159+ <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
2160+ </td>
2161+ <td width="70%">
2162+ <table style="width: 100%; text-align:center;">
2163+ <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
2164+ <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
2165+ <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
2166+ <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
2167+ </table>
2168+ </td>
2169+ </tr>
2170+</table>
2171+<table width="100%">
2172+ <thead>
2173+ <tr>
2174+ <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
2175+ </tr>
2176+ </thead>
2177+</table>
2178+<table style="width: 100%;">
2179+ <tr>
2180+ <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('Code')}</td>
2181+ <td class="celdaTituloTabla" width="30%">${_('ACCOUNT')}</td>
2182+ <td class="celdaTituloTabla" width="10%">${_('INIT. BAL.')}</td>
2183+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('DEBIT')}</td>
2184+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('CREDIT')}</td>
2185+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('PERIOD')}</td>
2186+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('YTD')}</td>
2187+ </tr>
2188+ %for line in obj.get_parser_method('lines',data['form']):
2189+ %if line['type'] != 'view':
2190+ <tr>
2191+ <td class="celdaLineData" style="text-align:right;font-style:italic;">${line['code'] or ''}</td>
2192+ <td class="celdaLineDataName" >${line['name'].upper() or line['name'].title()}</td>
2193+ <td class="celdaLineData" style="text-align:right;">${formatLang(line.get('change_sign', 1.0) * line.get('balanceinit'), digits=2, grouping=True) or ''}</td>
2194+ <td class="celdaLineData" style="text-align:right;">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
2195+ <td class="celdaLineData" style="text-align:right;">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
2196+ <td class="celdaLineData" style="text-align:right;">${formatLang(line.get('change_sign', 1.0) * line.get('ytd'), digits=2, grouping=True) or ''}</td>
2197+ <td class="celdaLineData" style="text-align:right;">${formatLang(line.get('change_sign', 1.0) * line.get('balance'), digits=2, grouping=True) or ''}</td>
2198+ </tr>
2199+ %elif line['total'] and not line['label']:
2200+ <tr>
2201+ <td class="celdaLineDataTotal" style="text-align:right;font-style:italic;">${line['code'] or ''}</td>
2202+ <td class="celdaLineDataTotal" style="text-align:right;">${line['name'].upper() or line['name'].title() or ''}</td>
2203+ <td class="celdaLineDataTotal">${formatLang(line.get('change_sign', 1.0) * line.get('balanceinit'), digits=2, grouping=True) or ''}</td>
2204+ <td class="celdaLineDataTotal">${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
2205+ <td class="celdaLineDataTotal">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
2206+ <td class="celdaLineDataTotal">${formatLang(line.get('change_sign', 1.0) * line.get('ytd'), digits=2, grouping=True) or ''}</td>
2207+ <td class="celdaLineDataTotal">${formatLang(line.get('change_sign', 1.0) * line.get('balance'), digits=2, grouping=True) or ''}</td>
2208+ </tr>
2209+ %else:
2210+ <tr>
2211+ <td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="10%">${(line['label'] == True ) and line['code'] or ''}</td>
2212+ <td class="celdaLineDataNameView" colspan="6">${line['name'].upper() or line['name'].title() or ''}</td>
2213+ </tr>
2214+ %endif
2215+ %endfor
2216+</table>
2217+%endfor
2218+</body>
2219+</html>
2220
2221=== added file 'account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako'
2222--- account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako 1970-01-01 00:00:00 +0000
2223+++ account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako 2013-10-23 14:40:32 +0000
2224@@ -0,0 +1,127 @@
2225+<!DOCTYPE html SYSTEM
2226+"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2227+<html xmlns="http://www.w3.org/1999/xhtml">
2228+<head>
2229+<style type="text/css">
2230+ ${css}
2231+</style>
2232+</head>
2233+
2234+<body style="border:0; margin: 0;" onload="subst()" >
2235+%for obj in objects:
2236+<table width="100%">
2237+ <tr>
2238+ <td>
2239+ <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
2240+ </td>
2241+ <td>
2242+ <table style="width: 100%; text-align:center;">
2243+ <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
2244+ <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
2245+ <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
2246+ <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
2247+ </table>
2248+ </td>
2249+ </tr>
2250+</table>
2251+
2252+<table width="100%">
2253+ <thead>
2254+ <tr>
2255+ <td class="celdaTituloTabla" style="width: 100%; text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
2256+ </tr>
2257+ </thead>
2258+</table>
2259+<table width="100%">
2260+ <thead>
2261+ <tr>
2262+ <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('CODE')}</td>
2263+ <td class="celdaTituloTabla" width="50%">${_('ACCOUNT')}</td>
2264+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('INICIAL')}</td>
2265+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('DEBIT')}</td>
2266+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('CREDIT')}</td>
2267+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('BALANCE')}</td>
2268+ </tr>
2269+ </thead>
2270+</table>
2271+<table width="100%">
2272+ <thead>
2273+ <tr>
2274+ <td class="celdaTituloTabla" style="text-align:left;" width="10%">${_('DATE')}</td>
2275+ <td class="celdaTituloTabla" width="10%">${_('PERIOD')}</td>
2276+ <td class="celdaTituloTabla" width="40%">${_('JOURNAL ENTRY')}</td>
2277+ <td class="celdaTituloTabla" width="40%"></td>
2278+ </tr>
2279+ </thead>
2280+</table>
2281+
2282+<table width="100%">
2283+ <tr>
2284+ <td width="10%"></td>
2285+ <td width="10%"></td>
2286+ <td width="10%"></td>
2287+ <td width="10%"></td>
2288+ <td width="10%"></td>
2289+ <td width="10%"></td>
2290+ <td width="10%"></td>
2291+ <td width="10%"></td>
2292+ <td width="10%"></td>
2293+ <td width="10%"></td>
2294+ </tr>
2295+ %for line in obj.get_parser_method('lines',data['form']):
2296+ %if line['type']!= 'view':
2297+ <tbody>
2298+ <tr>
2299+ <td class="celdaLineDataTotal" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td>
2300+ <td class="celdaLineDataNameTotal" colspan="5">${line['name'].upper() or line['name'].title() or ''}</td>
2301+ <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>
2302+ <td class="celdaLineDataTotal" width="10%"> ${formatLang(line['debit'], digits=2, grouping=True) or ''}</td>
2303+ <td class="celdaLineDataTotal" width="10%">${formatLang(line['credit'], digits=2, grouping=True) or ''}</td>
2304+ <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>
2305+ </tr>
2306+ </tbody>
2307+ %for j in line['journal']:
2308+ <tbody>
2309+ <tr>
2310+ <td class="celdaLineData" style="text-align:left;" width="10%" height="12pt">${formatLang( j['date'], date=True) or ''}</td>
2311+ <td class="celdaLineData" style="text-align:left;" width="10%">${j['period'] or ''}</td>
2312+ <td class="celdaLineDataNamePartner" colspan="4">${j['name'] or ''}</td>
2313+ <td class="celdaLineDataNamePartner" colspan="4"></td>
2314+ </tr>
2315+ </tbody>
2316+ %for k in j.get('obj').line_id:
2317+ <tbody>
2318+ %if k.account_id.name.upper() == line['name'].upper() :
2319+ <tr>
2320+ <td class="celdaLineDataAccountSimilar" style="text-align:left;" colspan="2">${k.name or ''}</td>
2321+ <td class="celdaLineDataAccountSimilar" style="text-align:left;">${k.ref and k.ref or ''}</td>
2322+ <td class="celdaLineDataAccountSimilar" colspan="2">${k.partner_id and k.partner_id.name or ''}</td>
2323+ <td class="celdaLineDataAccountSimilar" style="text-align:left;">${k.account_id and k.account_id.code or ''}</td>
2324+ <td class="celdaLineDataAccountSimilar" style="text-align:left;" >${k.account_id and k.account_id.name or ''}</td>
2325+ <td class="celdaLineDataAccountSimilar" style="text-align:right;" >${k.debit and formatLang(k.debit, digits=2, grouping=True) or ''}</td>
2326+ <td class="celdaLineDataAccountSimilar" style="text-align:right;" >${k.credit and formatLang(k.credit, digits=2, grouping=True) or ''}</td>
2327+ <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>
2328+ </tr>
2329+ %else:
2330+ <tr>
2331+ <td class="celdaLineDataAccount" style="text-align:left;" colspan="2">${k.name or ''}</td>
2332+ <td class="celdaLineDataAccount" style="text-align:left;" >${k.ref and k.ref or ''}</td>
2333+ <td class="celdaLineDataAccount" colspan="2">${k.partner_id and k.partner_id.name or ''}</td>
2334+ <td class="celdaLineDataAccount" style="text-align:left;" >${k.account_id and k.account_id.code or ''}</td>
2335+ <td class="celdaLineDataAccount" style="text-align:left;" >${k.account_id and k.account_id.name or ''}</td>
2336+ <td class="celdaLineDataAccount" style="text-align:right;" >${k.debit and formatLang(k.debit, digits=2, grouping=True) or ''}</td>
2337+ <td class="celdaLineDataAccount" style="text-align:right;" >${k.credit and formatLang(k.credit, digits=2, grouping=True) or ''}</td>
2338+ <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>
2339+ </tr>
2340+ %endif
2341+ </tbody>
2342+ %endfor
2343+ %endfor
2344+ %endif
2345+ %endfor
2346+</table>
2347+
2348+%endfor
2349+
2350+</body>
2351+</html>
2352
2353=== added file 'account_financial_report_exportable/report/afr_report_webkit_qtr.mako'
2354--- account_financial_report_exportable/report/afr_report_webkit_qtr.mako 1970-01-01 00:00:00 +0000
2355+++ account_financial_report_exportable/report/afr_report_webkit_qtr.mako 2013-10-23 14:40:32 +0000
2356@@ -0,0 +1,82 @@
2357+<!DOCTYPE html SYSTEM
2358+"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2359+<html xmlns="http://www.w3.org/1999/xhtml">
2360+<head>
2361+<style type="text/css">
2362+ ${css}
2363+</style>
2364+</head>
2365+
2366+<body style="border:0; margin: 0;" onload="subst()" >
2367+
2368+
2369+<!--
2370+ <h1><center>4 QTR | YTD</center></h1>
2371+-->
2372+ %for obj in objects:
2373+ <table width="100%">
2374+ <tr>
2375+ <td width="30%">
2376+ <div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
2377+ </td>
2378+ <td width="70%">
2379+ <table style="width: 100%; text-align:center;">
2380+ <tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
2381+ <tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
2382+ <tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
2383+ <tr><td><div class="td_company_date"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
2384+ </table>
2385+ </td>
2386+ <td>
2387+ </td>
2388+ </tr>
2389+ </table>
2390+ <table width="100%">
2391+ <thead>
2392+ <tr>
2393+ <td class="celdaTituloTabla" colspan="7" style="text-align:left;">${_('Expressed in: %s') % (obj.get_parser_method('exchange_name',data['form'])) or ''|entity}</td>
2394+ </tr>
2395+ </thead>
2396+ <tbody>
2397+ <tr>
2398+ <td class="celdaTituloTabla" style="text-align:right;" width="10%">${_('CODE')}</td>
2399+ <td class="celdaTituloTabla" width="30%">${_('ACCOUNT')}</td>
2400+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('Q1')}</td>
2401+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('Q2')}</td>
2402+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('Q3')}</td>
2403+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('Q4')}</td>
2404+ <td class="celdaTituloTabla" style="text-align:center;" width="10%">${_('YTD')}</td>
2405+ </tr>
2406+ %for line in obj.get_parser_method('lines',data['form']):
2407+ %if line['type'] != 'view':
2408+ <tr class="prueba">
2409+ <td class="celdaLineData" style="text-align:right;font-style:italic;">${line['code'] or ''}</td>
2410+ <td class="celdaLineDataName" >${line['name'].upper() or line['name'].title()}</td>
2411+ <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>
2412+ <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>
2413+ <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>
2414+ <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>
2415+ <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>
2416+ </tr>
2417+ %elif line['total'] and not line['label']:
2418+ <tr class="prueba">
2419+ <td class="celdaLineDataTotal" style="text-align:right;font-style:italic;">${line['code'] or ''}</td>
2420+ <td class="celdaLineDataTotal" style="text-align:right;">${line['name'].upper() or line['name'].title() or ''}</td>
2421+ <td class="celdaLineDataTotal">${formatLang(line['bal1'] and (line['bal1'] * line.get('change_sign',1)) or 0.0, digits=2, grouping=True) or ''}</td>
2422+ <td class="celdaLineDataTotal">${formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
2423+ <td class="celdaLineDataTotal">${formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
2424+ <td class="celdaLineDataTotal">${formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
2425+ <td class="celdaLineDataTotal">${formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
2426+ </tr>
2427+ %else:
2428+ <tr class="prueba">
2429+ <i><td class="celdaLineDataView" style="text-align:right;font-style:italic;" width="10%">${line['code'] or ''}</td></i>
2430+ <td class="celdaLineDataNameView" colspan="6" >${line['name'].upper() or line['name'].title() or ''}</td>
2431+ </tr>
2432+ %endif
2433+ %endfor
2434+ </tbody>
2435+ </table>
2436+%endfor
2437+</body>
2438+</html>
2439
2440=== added file 'account_financial_report_exportable/report/report_afr.xml'
2441--- account_financial_report_exportable/report/report_afr.xml 1970-01-01 00:00:00 +0000
2442+++ account_financial_report_exportable/report/report_afr.xml 2013-10-23 14:40:32 +0000
2443@@ -0,0 +1,316 @@
2444+<?xml version="1.0"?>
2445+<openerp>
2446+ <data>
2447+ <report
2448+ auto = "True"
2449+ id="afr_report_col5"
2450+ model="wizard.report"
2451+ name="afr_report_col5"
2452+ file="account_financial_report_exportable/report/afr_report_webkit_cols5.mako"
2453+ string="Print AFR"
2454+ report_type="webkit"
2455+ multi="True"
2456+ menu="False"/>
2457+
2458+ <record id="property_afr_report_webkit1" model="ir.property">
2459+ <field name="name">webkit_header</field>
2460+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2461+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_five_colums'))" model="ir.header_webkit" name="value"/>
2462+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col5'))" model="ir.actions.report.xml" name="res_id"/>
2463+ </record>
2464+
2465+ <report
2466+ auto = "True"
2467+ id="afr_report_col5_html"
2468+ model="wizard.report"
2469+ name="afr_report_col5_html"
2470+ file="account_financial_report_exportable/report/afr_report_webkit_cols5.mako"
2471+ string="Print AFR"
2472+ report_type="webkit"
2473+ multi="True"
2474+ menu="False"/>
2475+ <record id="afr_report_col5_html" model="ir.actions.report.xml">
2476+ <field name="webkit_debug">True</field>
2477+ <field name="precise_mode">True</field>
2478+ </record>
2479+ <record id="property_afr_report_webkit1_html" model="ir.property">
2480+ <field name="name">webkit_header</field>
2481+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2482+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_five_colums'))" model="ir.header_webkit" name="value"/>
2483+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col5_html'))" model="ir.actions.report.xml" name="res_id"/>
2484+ </record>
2485+
2486+ <report
2487+ auto = "True"
2488+ id="afr_report_col1"
2489+ model="wizard.report"
2490+ name="afr_report_col1"
2491+ file="account_financial_report_exportable/report/afr_report_webkit_cols1.mako"
2492+ string="Print AFR"
2493+ report_type="webkit"
2494+ multi="True"
2495+ menu="False"/>
2496+
2497+ <record id="property_afr_report_webkit2" model="ir.property">
2498+ <field name="name">webkit_header</field>
2499+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2500+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_one_colums'))" model="ir.header_webkit" name="value"/>
2501+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col1'))" model="ir.actions.report.xml" name="res_id"/>
2502+ </record>
2503+
2504+ <report
2505+ auto = "True"
2506+ id="afr_report_col1_html"
2507+ model="wizard.report"
2508+ name="afr_report_col1_html"
2509+ file="account_financial_report_exportable/report/afr_report_webkit_cols1.mako"
2510+ string="Print AFR"
2511+ report_type="webkit"
2512+ multi="True"
2513+ menu="False"/>
2514+ <record id="afr_report_col1_html" model="ir.actions.report.xml">
2515+ <field name="webkit_debug">True</field>
2516+ <field name="precise_mode">True</field>
2517+ </record>
2518+ <record id="property_afr_report_webkit2_html" model="ir.property">
2519+ <field name="name">webkit_header</field>
2520+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2521+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_one_colums'))" model="ir.header_webkit" name="value"/>
2522+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col1_html'))" model="ir.actions.report.xml" name="res_id"/>
2523+ </record>
2524+
2525+ <report
2526+ auto = "True"
2527+ id="afr_report_col2"
2528+ model="wizard.report"
2529+ name="afr_report_col2"
2530+ file="account_financial_report_exportable/report/afr_report_webkit_cols2.mako"
2531+ string="Print AFR"
2532+ report_type="webkit"
2533+ multi="True"
2534+ menu="False"/>
2535+
2536+ <record id="property_afr_report_webkit3" model="ir.property">
2537+ <field name="name">webkit_header</field>
2538+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2539+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_two_colums'))" model="ir.header_webkit" name="value"/>
2540+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col2'))" model="ir.actions.report.xml" name="res_id"/>
2541+ </record>
2542+
2543+ <report
2544+ auto = "True"
2545+ id="afr_report_col2_html"
2546+ model="wizard.report"
2547+ name="afr_report_col2_html"
2548+ file="account_financial_report_exportable/report/afr_report_webkit_cols2.mako"
2549+ string="Print AFR"
2550+ report_type="webkit"
2551+ multi="True"
2552+ menu="False"/>
2553+ <record id="afr_report_col2_html" model="ir.actions.report.xml">
2554+ <field name="webkit_debug">True</field>
2555+ <field name="precise_mode">True</field>
2556+ </record>
2557+ <record id="property_afr_report_webkit3_html" model="ir.property">
2558+ <field name="name">webkit_header</field>
2559+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2560+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_two_colums'))" model="ir.header_webkit" name="value"/>
2561+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col2_html'))" model="ir.actions.report.xml" name="res_id"/>
2562+ </record>
2563+
2564+ <report
2565+ auto = "True"
2566+ id="afr_report_col4"
2567+ model="wizard.report"
2568+ name="afr_report_col4"
2569+ file="account_financial_report_exportable/report/afr_report_webkit_cols4.mako"
2570+ string="Print AFR"
2571+ report_type="webkit"
2572+ multi="True"
2573+ menu="False"/>
2574+
2575+ <record id="property_afr_report_webkit4" model="ir.property">
2576+ <field name="name">webkit_header</field>
2577+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2578+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_four_colums'))" model="ir.header_webkit" name="value"/>
2579+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col4'))" model="ir.actions.report.xml" name="res_id"/>
2580+ </record>
2581+
2582+ <report
2583+ auto = "True"
2584+ id="afr_report_col4_html"
2585+ model="wizard.report"
2586+ name="afr_report_col4_html"
2587+ file="account_financial_report_exportable/report/afr_report_webkit_cols4.mako"
2588+ string="Print AFR"
2589+ report_type="webkit"
2590+ multi="True"
2591+ menu="False"/>
2592+ <record id="afr_report_col4_html" model="ir.actions.report.xml">
2593+ <field name="webkit_debug">True</field>
2594+ <field name="precise_mode">True</field>
2595+ </record>
2596+ <record id="property_afr_report_webkit4_html" model="ir.property">
2597+ <field name="name">webkit_header</field>
2598+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2599+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_four_colums'))" model="ir.header_webkit" name="value"/>
2600+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col4_html'))" model="ir.actions.report.xml" name="res_id"/>
2601+ </record>
2602+
2603+ <report
2604+ auto = "True"
2605+ id="afr_report_journal_ledger"
2606+ model="wizard.report"
2607+ name="afr_report_journal_ledger"
2608+ file="account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako"
2609+ string="Print AFR"
2610+ report_type="webkit"
2611+ multi="True"
2612+ menu="False"/>
2613+
2614+ <record id="property_afr_report_webkit6" model="ir.property">
2615+ <field name="name">webkit_header</field>
2616+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2617+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_journal_ledger'))" model="ir.header_webkit" name="value"/>
2618+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_journal_ledger'))" model="ir.actions.report.xml" name="res_id"/>
2619+ </record>
2620+
2621+ <report
2622+ auto = "True"
2623+ id="afr_report_journal_ledger_html"
2624+ model="wizard.report"
2625+ name="afr_report_journal_ledger_html"
2626+ file="account_financial_report_exportable/report/afr_report_webkit_journal_ledger.mako"
2627+ string="Print AFR"
2628+ report_type="webkit"
2629+ multi="True"
2630+ menu="False"/>
2631+ <record id="afr_report_journal_ledger_html" model="ir.actions.report.xml">
2632+ <field name="webkit_debug">True</field>
2633+ <field name="precise_mode">True</field>
2634+ </record>
2635+ <record id="property_afr_report_webkit6_html" model="ir.property">
2636+ <field name="name">webkit_header</field>
2637+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2638+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_journal_ledger'))" model="ir.header_webkit" name="value"/>
2639+ <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"/>
2640+ </record>
2641+
2642+ <report
2643+ auto = "True"
2644+ id="afr_report_qtr"
2645+ model="wizard.report"
2646+ name="afr_report_qtr"
2647+ file="account_financial_report_exportable/report/afr_report_webkit_qtr.mako"
2648+ string="Print AFR"
2649+ report_type="webkit"
2650+ multi="True"
2651+ menu="False"/>
2652+
2653+ <record id="property_afr_report_webkit7" model="ir.property">
2654+ <field name="name">webkit_header</field>
2655+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2656+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_qtr'))" model="ir.header_webkit" name="value"/>
2657+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_qtr'))" model="ir.actions.report.xml" name="res_id"/>
2658+ </record>
2659+
2660+ <report
2661+ auto = "True"
2662+ id="afr_report_qtr_html"
2663+ model="wizard.report"
2664+ name="afr_report_qtr_html"
2665+ file="account_financial_report_exportable/report/afr_report_webkit_qtr.mako"
2666+ string="Print AFR"
2667+ report_type="webkit"
2668+ multi="True"
2669+ menu="False"/>
2670+ <record id="afr_report_qtr_html" model="ir.actions.report.xml">
2671+ <field name="webkit_debug">True</field>
2672+ <field name="precise_mode">True</field>
2673+ </record>
2674+ <record id="property_afr_report_webkit7_html" model="ir.property">
2675+ <field name="name">webkit_header</field>
2676+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2677+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_qtr'))" model="ir.header_webkit" name="value"/>
2678+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_qtr_html'))" model="ir.actions.report.xml" name="res_id"/>
2679+ </record>
2680+
2681+ <report
2682+ auto = "True"
2683+ id="afr_report_col13"
2684+ model="wizard.report"
2685+ name="afr_report_col13"
2686+ file="account_financial_report_exportable/report/afr_report_webkit_cols13.mako"
2687+ string="Print AFR"
2688+ report_type="webkit"
2689+ multi="True"
2690+ menu="False"/>
2691+
2692+ <record id="property_afr_report_webkit8" model="ir.property">
2693+ <field name="name">webkit_header</field>
2694+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2695+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_col13'))" model="ir.header_webkit" name="value"/>
2696+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col13'))" model="ir.actions.report.xml" name="res_id"/>
2697+ </record>
2698+
2699+ <report
2700+ auto = "True"
2701+ id="afr_report_col13_html"
2702+ model="wizard.report"
2703+ name="afr_report_col13_html"
2704+ file="account_financial_report_exportable/report/afr_report_webkit_cols13.mako"
2705+ string="Print AFR"
2706+ report_type="webkit"
2707+ multi="True"
2708+ menu="False"/>
2709+ <record id="afr_report_col13_html" model="ir.actions.report.xml">
2710+ <field name="webkit_debug">True</field>
2711+ <field name="precise_mode">True</field>
2712+ </record>
2713+ <record id="property_afr_report_webkit8_html" model="ir.property">
2714+ <field name="name">webkit_header</field>
2715+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2716+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_col13'))" model="ir.header_webkit" name="value"/>
2717+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_col13_html'))" model="ir.actions.report.xml" name="res_id"/>
2718+ </record>
2719+
2720+ <report
2721+ auto = "True"
2722+ id="afr_report_analytic_ledger"
2723+ model="wizard.report"
2724+ name="afr_report_analytic_ledger"
2725+ file="account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako"
2726+ string="Print AFR"
2727+ report_type="webkit"
2728+ multi="True"
2729+ menu="False"/>
2730+
2731+ <record id="property_afr_report_webkit9" model="ir.property">
2732+ <field name="name">webkit_header</field>
2733+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2734+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_analytic_ledger'))" model="ir.header_webkit" name="value"/>
2735+ <field eval="'ir.actions.report.xml,'+str(ref('account_financial_report_exportable.afr_report_analytic_ledger'))" model="ir.actions.report.xml" name="res_id"/>
2736+ </record>
2737+
2738+ <report
2739+ auto = "True"
2740+ id="afr_report_analytic_ledger_html"
2741+ model="wizard.report"
2742+ name="afr_report_analytic_ledger_html"
2743+ file="account_financial_report_exportable/report/afr_report_webkit_analytic_ledger.mako"
2744+ string="Print AFR"
2745+ report_type="webkit"
2746+ multi="True"
2747+ menu="False"/>
2748+ <record id="afr_report_analytic_ledger_html" model="ir.actions.report.xml">
2749+ <field name="webkit_debug">True</field>
2750+ <field name="precise_mode">True</field>
2751+ </record>
2752+ <record id="property_afr_report_webkit9_html" model="ir.property">
2753+ <field name="name">webkit_header</field>
2754+ <field name="fields_id" ref="report_webkit.field_ir_act_report_xml_webkit_header"/>
2755+ <field eval="'ir.header_webkit,'+str(ref('account_financial_report_exportable.ir_header_webkit_afrreport_analytic_ledger'))" model="ir.header_webkit" name="value"/>
2756+ <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"/>
2757+ </record>
2758+ </data>
2759+</openerp>
2760
2761=== added directory 'account_financial_report_exportable/security'
2762=== added directory 'account_financial_report_exportable/static'
2763=== added directory 'account_financial_report_exportable/static/description'
2764=== added file 'account_financial_report_exportable/static/description/index.html'
2765=== added directory 'account_financial_report_exportable/static/src'
2766=== added directory 'account_financial_report_exportable/static/src/css'
2767=== added directory 'account_financial_report_exportable/static/src/img'
2768=== added directory 'account_financial_report_exportable/static/src/js'
2769=== added directory 'account_financial_report_exportable/static/src/xml'
2770=== added directory 'account_financial_report_exportable/test'
2771=== added directory 'account_financial_report_exportable/view'
2772=== added file 'account_financial_report_exportable/view/account_financial_report_view.xml'
2773--- account_financial_report_exportable/view/account_financial_report_view.xml 1970-01-01 00:00:00 +0000
2774+++ account_financial_report_exportable/view/account_financial_report_view.xml 2013-10-23 14:40:32 +0000
2775@@ -0,0 +1,15 @@
2776+<?xml version='1.0' encoding='UTF-8'?>
2777+<openerp>
2778+ <data>
2779+ <record model="ir.ui.view" id="wizard_report_view_inherit">
2780+ <field name="name">wizard.report.view.inherit</field>
2781+ <field name="model">wizard.report</field>
2782+ <field name="inherit_id" ref="account_financial_report.wizard_report_view"/>
2783+ <field name="arch" type="xml">
2784+ <xpath expr="//field[@name='journal_ledger']" position="after">
2785+ <field name="report_format"/>
2786+ </xpath>
2787+ </field>
2788+ </record>
2789+ </data>
2790+</openerp>
2791
2792=== added directory 'account_financial_report_exportable/wizard'
2793=== added file 'account_financial_report_exportable/wizard/__init__.py'
2794--- account_financial_report_exportable/wizard/__init__.py 1970-01-01 00:00:00 +0000
2795+++ account_financial_report_exportable/wizard/__init__.py 2013-10-23 14:40:32 +0000
2796@@ -0,0 +1,26 @@
2797+#!/usr/bin/python
2798+# -*- encoding: utf-8 -*-
2799+###############################################################################
2800+# Module Writen to OpenERP, Open Source Management Solution
2801+# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
2802+# All Rights Reserved
2803+############# Credits #########################################################
2804+# Coded by: Yanina Aular <yani@vauxoo.com>
2805+# Planified by: Humberto Arocha <hbto@vauxoo.com>
2806+# Audited by: Humberto Arocha <hbto@vauxoo.com>
2807+###############################################################################
2808+# This program is free software: you can redistribute it and/or modify
2809+# it under the terms of the GNU Affero General Public License as published
2810+# by the Free Software Foundation, either version 3 of the License, or
2811+# (at your option) any later version.
2812+#
2813+# This program is distributed in the hope that it will be useful,
2814+# but WITHOUT ANY WARRANTY; without even the implied warranty of
2815+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
2816+# GNU Affero General Public License for more details.
2817+#
2818+# You should have received a copy of the GNU Affero General Public License
2819+# along with this program. If not, see <http://www.gnu.org/licenses/>.
2820+###############################################################################
2821+
2822+import afr_report_wizard
2823
2824=== added file 'account_financial_report_exportable/wizard/afr_report_wizard.py'
2825--- account_financial_report_exportable/wizard/afr_report_wizard.py 1970-01-01 00:00:00 +0000
2826+++ account_financial_report_exportable/wizard/afr_report_wizard.py 2013-10-23 14:40:32 +0000
2827@@ -0,0 +1,118 @@
2828+#!/usr/bin/python
2829+# -*- encoding: utf-8 -*-
2830+###############################################################################
2831+# Module Writen to OpenERP, Open Source Management Solution
2832+# Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
2833+# All Rights Reserved
2834+############# Credits #########################################################
2835+# Coded by: Yanina Aular <yani@vauxoo.com>
2836+# Planified by: Humberto Arocha <hbto@vauxoo.com>
2837+# Audited by: Humberto Arocha <hbto@vauxoo.com>
2838+###############################################################################
2839+# This program is free software: you can redistribute it and/or modify
2840+# it under the terms of the GNU Affero General Public License as published
2841+# by the Free Software Foundation, either version 3 of the License, or
2842+# (at your option) any later version.
2843+#
2844+# This program is distributed in the hope that it will be useful,
2845+# but WITHOUT ANY WARRANTY; without even the implied warranty of
2846+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
2847+# GNU Affero General Public License for more details.
2848+#
2849+# You should have received a copy of the GNU Affero General Public License
2850+# along with this program. If not, see <http://www.gnu.org/licenses/>.
2851+###############################################################################
2852+
2853+
2854+
2855+from osv import osv, fields
2856+import pooler
2857+import time
2858+from tools.translate import _
2859+from account_financial_report.report import parser as Parser
2860+
2861+
2862+class wizard_report(osv.osv_memory):
2863+ _inherit = "wizard.report"
2864+
2865+ _columns = {
2866+ 'report_format' : fields.selection([
2867+ ('pdf', 'PDF'),
2868+ ('spreadsheet', 'Spreadsheet')], 'Report Format')
2869+ }
2870+ def get_parser_method(self, cr, uid, ids, method=None, args=None, param=None, context=None):
2871+ if context is None:
2872+ context = {}
2873+
2874+ acc_bal_obj = Parser.account_balance(cr, uid, ids ,context=context)
2875+ res = []
2876+
2877+ if method:
2878+ if method in ("get_company_accounts", "_get_analytic_ledger", "_get_journal_ledger",
2879+ "lines"):
2880+ res = getattr(acc_bal_obj, method)(args, param)
2881+ else:
2882+ res = getattr(acc_bal_obj, method)(args)
2883+
2884+ return res
2885+
2886+ def print_report(self, cr, uid, ids, data, context=None):
2887+ if context is None:
2888+ context = {}
2889+
2890+ res = super(wizard_report, self).print_report(cr, uid, ids, data=data, context=context)
2891+
2892+ res.get('datas')['ids'] = ids
2893+
2894+ if( res.get('report_name') == 'afr.1cols'):
2895+ if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
2896+ res['report_name'] = 'afr_report_col1_html'
2897+ else:
2898+ res['report_name'] = 'afr_report_col1'
2899+
2900+ if( res.get('report_name') == 'afr.2cols'):
2901+ if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
2902+ res['report_name'] = 'afr_report_col2_html'
2903+ else:
2904+ res['report_name'] = 'afr_report_col2'
2905+
2906+ if( res.get('report_name') == 'afr.4cols'):
2907+ if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
2908+ res['report_name'] = 'afr_report_col4_html'
2909+ else:
2910+ res['report_name'] = 'afr_report_col4'
2911+
2912+ if( res.get('report_name') == 'afr.5cols'):
2913+ if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
2914+ res['report_name'] = 'afr_report_col5_html'
2915+ else:
2916+ res['report_name'] = 'afr_report_col5'
2917+
2918+ if( res.get('report_name') == 'afr.journal.ledger'):
2919+ if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
2920+ res['report_name'] = 'afr_report_journal_ledger_html'
2921+ else:
2922+ res['report_name'] = 'afr_report_journal_ledger'
2923+
2924+ if( res.get('report_name') == 'afr.analytic.ledger'):
2925+ if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
2926+ res['report_name'] = 'afr_report_analytic_ledger_html'
2927+ else:
2928+ res['report_name'] = 'afr_report_analytic_ledger'
2929+
2930+ if( res.get('report_name') == 'afr.qtrcols'):
2931+ if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
2932+ res['report_name'] = 'afr_report_qtr_html'
2933+ else:
2934+ res['report_name'] = 'afr_report_qtr'
2935+
2936+ if( res.get('report_name') == 'afr.13cols'):
2937+ if (res.get('datas').get('form')['report_format'] == 'spreadsheet'):
2938+ res['report_name'] = 'afr_report_col13_html'
2939+ else:
2940+ res['report_name'] = 'afr_report_col13'
2941+
2942+ return res
2943+
2944+
2945+
2946
2947=== added directory 'account_financial_report_exportable/workflow'

Subscribers

People subscribed via source and target branches

to status/vote changes: