From 284470c116a0f1a73f82797160b0170e55a58652 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 4 Feb 2014 10:38:26 +0100 Subject: [PATCH] =?utf8?q?Belegsortierung=20Kunden-/Lieferantenname:=20Gro?= =?utf8?q?=C3=9F-/Kleinschreibung=20ignorieren?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/Manager/DeliveryOrder.pm | 4 ++-- SL/DB/Manager/Invoice.pm | 2 +- SL/DB/Manager/Order.pm | 4 ++-- SL/DB/Manager/PurchaseInvoice.pm | 2 +- 4 files changed, 6 insertions(+), 6 deletions(-) diff --git a/SL/DB/Manager/DeliveryOrder.pm b/SL/DB/Manager/DeliveryOrder.pm index fa67f6675..793e88bf7 100644 --- a/SL/DB/Manager/DeliveryOrder.pm +++ b/SL/DB/Manager/DeliveryOrder.pm @@ -32,8 +32,8 @@ sub _sort_spec { }, columns => { SIMPLE => 'ALL', - customer => 'customer.name', - vendor => 'vendor.name', + customer => 'lower(customer.name)', + vendor => 'lower(vendor.name)', globalprojectnumber => 'lower(globalproject.projectnumber)', # Bug in Rose::DB::Object: the next should be diff --git a/SL/DB/Manager/Invoice.pm b/SL/DB/Manager/Invoice.pm index 493789e84..03c2296da 100644 --- a/SL/DB/Manager/Invoice.pm +++ b/SL/DB/Manager/Invoice.pm @@ -34,7 +34,7 @@ sub _sort_spec { }, columns => { SIMPLE => 'ALL', - customer => 'customer.name', + customer => 'lower(customer.name)', globalprojectnumber => 'lower(globalproject.projectnumber)', # Bug in Rose::DB::Object: the next should be diff --git a/SL/DB/Manager/Order.pm b/SL/DB/Manager/Order.pm index e03386d04..d844683ec 100644 --- a/SL/DB/Manager/Order.pm +++ b/SL/DB/Manager/Order.pm @@ -35,8 +35,8 @@ sub _sort_spec { }, columns => { SIMPLE => 'ALL', - customer => 'customer.name', - vendor => 'vendor.name', + customer => 'lower(customer.name)', + vendor => 'lower(vendor.name)', globalprojectnumber => 'lower(globalproject.projectnumber)', # Bug in Rose::DB::Object: the next should be diff --git a/SL/DB/Manager/PurchaseInvoice.pm b/SL/DB/Manager/PurchaseInvoice.pm index 2dd3fad17..ca0bb106e 100644 --- a/SL/DB/Manager/PurchaseInvoice.pm +++ b/SL/DB/Manager/PurchaseInvoice.pm @@ -32,7 +32,7 @@ sub _sort_spec { }, columns => { SIMPLE => 'ALL', - vendor => 'vendor.name', + vendor => 'lower(vendor.name)', globalprojectnumber => 'lower(globalproject.projectnumber)', # Bug in Rose::DB::Object: the next should be -- 2.20.1