From 1050b837d2a1393a20ad50b3574b958db6db10f1 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Thu, 12 Dec 2019 12:57:31 +0100 Subject: [PATCH] Kundenbericht: richtig nach Kreditlimit, UStID und Amtsgericht sortieren --- SL/CT.pm | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/SL/CT.pm b/SL/CT.pm index 6a52ee716..0c20a6fa7 100644 --- a/SL/CT.pm +++ b/SL/CT.pm @@ -84,6 +84,9 @@ sub search { "salesman" => "e.name", "payment" => "pt.description", "pricegroup" => "pg.pricegroup", + "ustid" => "ct.ustid", + "creditlimit" => "ct.creditlimit", + "commercial_court" => "ct.commercial_court", ); $form->{sort} ||= "name"; @@ -98,7 +101,7 @@ sub search { } my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC'; - if ($sortorder !~ /(business|id|discount|itime)/ && !$join_records) { + if ($sortorder !~ /(business|creditlimit|id|discount|itime)/ && !$join_records) { $sortorder = "lower($sortorder) ${sortdir}"; } else { $sortorder .= " ${sortdir}"; -- 2.20.1