From fd69a37d9aa596195873b658d7a42d7e8c0ea6a3 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Tue, 8 Mar 2011 10:10:52 +0100 Subject: [PATCH] =?utf8?q?Bei=20vielen=20Lagerpl=C3=A4tzen=20ist=20es=20hi?= =?utf8?q?lfreich=20die=20Liste=20der=20bin(s)=20alphabetisch=20vorzusorti?= =?utf8?q?eren?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/Form.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/SL/Form.pm b/SL/Form.pm index b2cb1dead..1db5a6541 100644 --- a/SL/Form.pm +++ b/SL/Form.pm @@ -2459,7 +2459,8 @@ sub _get_warehouses { $self->{$key} = selectall_hashref_query($self, $dbh, $query); if ($bins_key) { - $query = qq|SELECT id, description FROM bin WHERE warehouse_id = ?|; + $query = qq|SELECT id, description FROM bin WHERE warehouse_id = ? + ORDER BY description|; my $sth = prepare_query($self, $dbh, $query); foreach my $warehouse (@{ $self->{$key} }) { -- 2.20.1