Belegsortierung Kunden-/Lieferantenname: Groß-/Kleinschreibung ignorieren

diff --git a/SL/DB/Manager/DeliveryOrder.pm b/SL/DB/Manager/DeliveryOrder.pm
index fa67f6675780771dd660ca322d9f5631e57ea594..793e88bf76b0e8ea31538c1bbf15cc7d29ed6829 100644 (file)
--- a/SL/DB/Manager/DeliveryOrder.pm
+++ b/SL/DB/Manager/DeliveryOrder.pm
@@ -32,8 +32,8 @@ sub _sort_spec {
     },
     columns                   => {
       SIMPLE                  => 'ALL',
     },
     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
       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 493789e84a39461690f468b1c8dacfdc6feb5f08..03c2296da49d11553215a845d3064e795a74fa67 100644 (file)
--- a/SL/DB/Manager/Invoice.pm
+++ b/SL/DB/Manager/Invoice.pm
@@ -34,7 +34,7 @@ sub _sort_spec {
     },
     columns                   => {
       SIMPLE                  => 'ALL',
     },
     columns                   => {
       SIMPLE                  => 'ALL',

-      customer                => 'customer.name',
+      customer                => 'lower(customer.name)',

       globalprojectnumber     => 'lower(globalproject.projectnumber)',
 
       # Bug in Rose::DB::Object: the next should be
       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 e03386d0441beba4a0913db38d79d2bf6cc3acb9..d844683ece9629297059e9cab4c9a1852b3596d0 100644 (file)
--- a/SL/DB/Manager/Order.pm
+++ b/SL/DB/Manager/Order.pm
@@ -35,8 +35,8 @@ sub _sort_spec {
     },
     columns                   => {
       SIMPLE                  => 'ALL',
     },
     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
       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 2dd3fad178ffd8c3e5680d1db4a34e47e009eed0..ca0bb106eff23e82906b6d20988108f14b1e9bf3 100644 (file)
--- a/SL/DB/Manager/PurchaseInvoice.pm
+++ b/SL/DB/Manager/PurchaseInvoice.pm
@@ -32,7 +32,7 @@ sub _sort_spec {
     },
     columns                   => {
       SIMPLE                  => 'ALL',
     },
     columns                   => {
       SIMPLE                  => 'ALL',

-      vendor                  => 'vendor.name',
+      vendor                  => 'lower(vendor.name)',

       globalprojectnumber     => 'lower(globalproject.projectnumber)',
 
       # Bug in Rose::DB::Object: the next should be
       globalprojectnumber     => 'lower(globalproject.projectnumber)',
 
       # Bug in Rose::DB::Object: the next should be