Merge lp:~openerp-dev/openobject-addons/6.1-opw-577044-msh into lp:openobject-addons/6.1

[Mohammed Shekha(Open ERP)]

Hello,

Fixed the issue of month translation, here month field in report is defined as a char, so just changed it to selection so that name of the month are automatically translated from the server itself in fields_get.

Otherwise it will show the month name in English in any language.

Demo :- Document -> Dashboard -> In Graph view X-axis, you will see the name of the month in English in any language.

Thanks.

[Naresh(OpenERP) (nch-openerp)]

Hello,

This bug was qualified as Confirmed on Trunk (means still existing and reproducible). A Merge Proposal for trunk was created to fix it. Here is the link to follow the MP on Launchpad https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-opw-577044-port-mma/+merge/136397 and be informed once it's been merged in trunk: ... If this Merge Proposal could not be merged in v6.1 at the release of v7.0, it will be closed.

Thanks,
Naresh Soni

Unmerged revisions

6897. By Mohammed Shekha(Open ERP) on 2012-07-19

[FIX]Fixed the issue of month translation, here month field in report is defined as a char, so just changed it to selection so that name of the month are automatically translated from the server itself in fields_get.

=== modified file 'document/report/document_report.py'
--- document/report/document_report.py	2011-01-14 00:11:01 +0000
+++ document/report/document_report.py	2012-07-19 13:08:32 +0000
@@ -106,7 +106,9 @@
     _columns = {
         'file_size': fields.integer('File Size', readonly=True),
         'nbr':fields.integer('# of Files', readonly=True),
-        'month': fields.char('Month', size=24,readonly=True),
+        'month': fields.selection([('1','January'), ('2','February'), ('3','March'), ('4','April'),
+            ('5','May'), ('6','June'), ('7','July'), ('8','August'), ('9','September'),
+            ('10','October'), ('11','November'), ('12','December')], 'Month', readonly=True),
      }
     _order = "month"
     def init(self, cr):
@@ -115,7 +117,7 @@
             create or replace view report_document_file as (
                 select min(f.id) as id,
                        count(*) as nbr,
-                       min(EXTRACT(MONTH FROM f.create_date)||'-'||to_char(f.create_date,'Month')) as month,
+                       CAST(min(EXTRACT(MONTH FROM f.create_date)) AS text) as month,
                        sum(f.file_size) as file_size
                 from ir_attachment f
                 group by EXTRACT(MONTH FROM f.create_date)