diff options
| author | Harry (OpenERP) <hmo@tinyerp.com> | 2010-09-07 13:30:18 +0530 |
|---|---|---|
| committer | Harry (OpenERP) <hmo@tinyerp.com> | 2010-09-07 13:30:18 +0530 |
| commit | 389ce144e217e5cfced9fdef48a94d8dd0ff33df (patch) | |
| tree | 58c1d4407f6091082952548f68c5b0c0fdbc57e5 | |
| parent | 519bde9c6f5a869db2ceaa3939ead8a241e8f6be (diff) | |
[IMP] document: improve report_files_partner view
bzr revid: hmo@tinyerp.com-20100907080018-630zs4nv0wwqx8x6
| -rw-r--r-- | addons/document/report/document_report.py | 21 |
1 files changed, 12 insertions, 9 deletions
diff --git a/addons/document/report/document_report.py b/addons/document/report/document_report.py index bccc46d463b..646f39ec590 100644 --- a/addons/document/report/document_report.py +++ b/addons/document/report/document_report.py @@ -71,6 +71,7 @@ class report_files_partner(osv.osv): _auto = False _columns = { 'name': fields.char('Year',size=64,required=False, readonly=True), + 'file_size': fields.integer('File Size', readonly=True), 'nbr':fields.integer('# of Files', readonly=True), 'partner':fields.char('Partner',size=64,readonly=True), 'month':fields.selection([('01','January'), ('02','February'), ('03','March'), ('04','April'), ('05','May'), ('06','June'), @@ -80,15 +81,17 @@ class report_files_partner(osv.osv): tools.drop_view_if_exists(cr, 'report_files_partner') cr.execute(""" CREATE VIEW report_files_partner as ( - select min(f.id) as id,count(*) as nbr, - to_char(f.create_date,'YYYY') as name, - min(to_char(f.create_date,'MM')) as month, - p.name as partner - from ir_attachment f - inner join res_partner p - on (f.partner_id=p.id) - where f.datas_fname is not null - group by p.name, to_char(f.create_date,'YYYY') + SELECT min(f.id) AS id, + COUNT(*) AS nbr, + to_char(date_trunc('month', f.create_date),'YYYY') AS name, + to_char(date_trunc('month', f.create_date),'MM') AS month, + SUM(f.file_size) AS file_size, + p.name AS partner + + FROM ir_attachment f + LEFT JOIN res_partner p ON (f.partner_id=p.id) + WHERE f.datas_fname IS NOT NULL + GROUP BY p.name, date_trunc('month', f.create_date) ) """) report_files_partner() |