From 084fac756e84aade0d4b2380301ede9bf6608dcd Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Fri, 9 Nov 2018 11:24:59 +0100 Subject: [PATCH] =?utf8?q?OrderItem-Manager:=20sortspec=20f=C3=BCr=20sellp?= =?utf8?q?rice=20und=20discount=20genau=20spezifiziert.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Sonst ist die Sortierung-Spalte evtl. nicht eindeutig, wenn z.B. das Part-Objekt mit in der Abfrage ist. behebt # #334 "Sortierung Artikelstammdaten/Preisinformationen/Verkaufspreisinformation: Kundenauftrag" --- SL/DB/Manager/OrderItem.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/SL/DB/Manager/OrderItem.pm b/SL/DB/Manager/OrderItem.pm index ce673db95..1945a0b44 100644 --- a/SL/DB/Manager/OrderItem.pm +++ b/SL/DB/Manager/OrderItem.pm @@ -37,8 +37,8 @@ sub _sort_spec { position => [ 'trans_id', 'runningnumber' ], reqdate => [ 'COALESCE(orderitems.reqdate, order.reqdate)' ], orddate => [ 'order.orddate' ], - sellprice => [ 'sellprice' ], - discount => [ 'discount' ], + sellprice => [ 'orderitems.sellprice' ], + discount => [ 'orderitems.discount' ], transdate => [ 'orderitems.transdate::date', 'order.reqdate' ], }, default => [ 'position', 1 ], -- 2.20.1