changeset 3187dec9a956 in modules/commission:default
details:
https://hg.tryton.org/modules/commission?cmd=changeset&node=3187dec9a956
description:
Use coalesce to sum base amount for reporting
issue10575
review373071002
diffstat:
commission_reporting.py | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diffs (20 lines):
diff -r d625b37f573a -r 3187dec9a956 commission_reporting.py
--- a/commission_reporting.py Sun Jul 04 17:54:46 2021 +0200
+++ b/commission_reporting.py Wed Jul 21 23:56:18 2021 +0200
@@ -9,6 +9,7 @@
pygal = None
from sql import Literal, Null
from sql.aggregate import Min, Sum, Count
+from sql.conditionals import Coalesce
from sql.functions import CurrentTimestamp, DateTrunc
from trytond.model import ModelSQL, ModelView, fields
@@ -82,7 +83,7 @@
cls.write_date.sql_cast(Literal(Null)).as_('write_date'),
commission.agent.as_('agent'),
Count(commission.id, distinct=True).as_('number'),
- Sum(commission.base_amount).as_('base_amount'),
+ Sum(Coalesce(commission.base_amount, 0)).as_('base_amount'),
Sum(commission.amount).as_('amount'),
]
