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'

Reply via email to