From 99d05c2cc969eb4913cac08ae4331c4e6a82726a Mon Sep 17 00:00:00 2001
From: Niclas Zimmermann <niclas@kivitendo-premium.de>
Date: Mon, 29 Apr 2013 16:15:28 +0200
Subject: [PATCH] =?utf8?q?Steuern=20nach=20Steuerschl=C3=BCssel=20und=20St?=
 =?utf8?q?euersatz=20ordnen?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Steuern wurden bisher immer nur nach Steuerschlüssel geordnet. Jetzt
wird eine neue Untersortierung verwendet (Steuersatz).
---
 SL/AM.pm   | 2 +-
 SL/Form.pm | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/SL/AM.pm b/SL/AM.pm
index 0c3c835b3..c85c47911 100644
--- a/SL/AM.pm
+++ b/SL/AM.pm
@@ -1717,7 +1717,7 @@ sub taxes {
                    (SELECT accno FROM chart WHERE id = chart_id) AS taxnumber,
                    (SELECT description FROM chart WHERE id = chart_id) AS account_description
                  FROM tax t
-                 ORDER BY taxkey|;
+                 ORDER BY taxkey, rate|;
 
   my $sth = $dbh->prepare($query);
   $sth->execute || $form->dberror($query);
diff --git a/SL/Form.pm b/SL/Form.pm
index 810891ef9..7b5d257b8 100644
--- a/SL/Form.pm
+++ b/SL/Form.pm
@@ -2106,7 +2106,7 @@ sub _get_taxcharts {
 
   my $where = @where ? ' WHERE ' . join(' AND ', map { "($_)" } @where) : '';
 
-  my $query = qq|SELECT * FROM tax $where ORDER BY taxkey|;
+  my $query = qq|SELECT * FROM tax $where ORDER BY taxkey, rate|;
 
   $self->{$key} = selectall_hashref_query($self, $dbh, $query);
 
-- 
2.20.1