首页 > 代码库 > odoo在底部显示指定字段合计和汇总时显示合计
odoo在底部显示指定字段合计和汇总时显示合计
1.odoo的tree视图底部显示合计
tree 视图,底部显示指定字段合计数 ,视图中字段定义上在sum,取自sale.view_order_tree 销售订单 tree 视图
<field name="amount_total" sum="Total Tax Included"/>
2. odoo使用group by分组时显示字段合计 方法是重写read_group方法
https://stackoverflow.com/questions/27536186/how-to-sum-other-columns-when-using-group-by-in-a-tree-view
The key is to overwrite the read_group
method of the class:
class your_class(osv.osv): # ... def read_group(self, cr, uid, domain, fields, groupby, offset=0, limit=None, context=None, orderby=False, lazy=True): res = super(your_class, self).read_group(cr, uid, domain, fields, groupby, offset, limit=limit, context=context, orderby=orderby, lazy=lazy) if ‘amount_pending‘ in fields: for line in res: if ‘__domain‘ in line: lines = self.search(cr, uid, line[‘__domain‘], context=context) pending_value = 0.0 for current_account in self.browse(cr, uid, lines, context=context): pending_value += current_account.amount_pending line[‘amount_pending‘] = pending_value if ‘amount_payed‘ in fields: for line in res: if ‘__domain‘ in line: lines = self.search(cr, uid, line[‘__domain‘], context=context) payed_value = 0.0 for current_account in self.browse(cr, uid, lines, context=context): payed_value += current_account.amount_payed line[‘amount_payed‘] = payed_value return res
If you want, for example, remove the sum of a column in the group by, you can do something like this:
class your_class(osv.osv):
# ...
def read_group(self, cr, uid, domain, fields, groupby, offset=0, limit=None, context=None, orderby=False, lazy=True):
if ‘column‘ in fields:
fields.remove(‘column‘)
return super(your_class, self).read_group(cr, uid, domain, fields, groupby, offset, limit=limit, context=context, orderby=orderby, lazy=lazy):
odoo在底部显示指定字段合计和汇总时显示合计
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。