changeset 09a3411e532a in modules/sale_supply_drop_shipment:default
details:
https://hg.tryton.org/modules/sale_supply_drop_shipment?cmd=changeset;node=09a3411e532a
description:
Default to ordering documents by date
issue10079
review339831002
diffstat:
stock.py | 11 ++++++++++-
1 files changed, 10 insertions(+), 1 deletions(-)
diffs (35 lines):
diff -r 1ae7829cd36d -r 09a3411e532a stock.py
--- a/stock.py Sun Feb 14 14:02:15 2021 +0100
+++ b/stock.py Thu Feb 25 21:13:56 2021 +0100
@@ -4,6 +4,7 @@
from decimal import Decimal
from sql import Column
+from sql.conditionals import Coalesce
from sql.operators import Concat
from sql.aggregate import Count
@@ -260,7 +261,10 @@
@classmethod
def __setup__(cls):
super(ShipmentDrop, cls).__setup__()
- cls._order[0] = ('id', 'DESC')
+ cls._order = [
+ ('effective_date', 'ASC NULLS LAST'),
+ ('id', 'DESC'),
+ ]
cls._transitions |= set((
('draft', 'waiting'),
('waiting', 'shipped'),
@@ -297,6 +301,11 @@
},
})
+ @classmethod
+ def order_effective_date(cls, tables):
+ table, _ = tables[None]
+ return [Coalesce(table.effective_date, table.planned_date)]
+
@staticmethod
def default_state():
return 'draft'