changeset 3282d84712f9 in modules/account_payment_clearing:default
details:
https://hg.tryton.org/modules/account_payment_clearing?cmd=changeset&node=3282d84712f9
description:
Consider null clearing_reconciled as false for group
issue11460
review445071003
diffstat:
payment.py | 12 +++++++-----
1 files changed, 7 insertions(+), 5 deletions(-)
diffs (40 lines):
diff -r 4ae6b2892ba9 -r 3282d84712f9 payment.py
--- a/payment.py Sat May 07 11:14:14 2022 +0200
+++ b/payment.py Sat May 07 11:15:52 2022 +0200
@@ -4,6 +4,7 @@
from functools import wraps
from sql.aggregate import BoolAnd, Min
+from sql.conditionals import Coalesce
from trytond import backend
from trytond.model import ModelView, Workflow, fields
@@ -356,10 +357,11 @@
payment = Payment.__table__()
cursor = Transaction().connection.cursor()
result = defaultdict()
+ column = Coalesce(payment.clearing_reconciled, False)
if backend.name == 'sqlite':
- column = Min(payment.clearing_reconciled)
+ column = Min(column)
else:
- column = BoolAnd(payment.clearing_reconciled)
+ column = BoolAnd(column)
for sub_groups in grouped_slice(groups):
cursor.execute(*payment.select(
payment.group, column,
@@ -376,11 +378,11 @@
_, operator, value = clause
Operator = fields.SQL_OPERATORS[operator]
-
+ column = Coalesce(payment.clearing_reconciled, False)
if backend.name == 'sqlite':
- column = Min(payment.clearing_reconciled)
+ column = Min(column)
else:
- column = BoolAnd(payment.clearing_reconciled)
+ column = BoolAnd(column)
query = payment.select(
payment.group,
