From d6e36f9c0d4bfb573298620e3f7d2ffd3c90c68c Mon Sep 17 00:00:00 2001
From: Moritz Bunkus <m.bunkus@linet-services.de>
Date: Fri, 18 Jan 2008 16:49:19 +0000
Subject: [PATCH] =?utf8?q?Anzahl=20der=20Lager=20in=20der=20Lager=C3=BCber?=
 =?utf8?q?sicht=20anzeigen.?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 SL/AM.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/SL/AM.pm b/SL/AM.pm
index 97e5896e8..91fc9a7c1 100644
--- a/SL/AM.pm
+++ b/SL/AM.pm
@@ -2517,7 +2517,8 @@ sub get_all_warehouses {
   # connect to database
   my $dbh = $form->get_standard_dbh($myconfig);
 
-  my $query = qq|SELECT w.id, w.description, w.invalid
+  my $query = qq|SELECT w.id, w.description, w.invalid,
+                   (SELECT COUNT(b.description) FROM bin b WHERE b.warehouse_id = w.id) AS number_of_bins,
                  FROM warehouse w
                  ORDER BY w.sortkey|;
 
-- 
2.20.1