Anzahl der Lager in der Lagerübersicht anzeigen.

diff --git a/SL/AM.pm b/SL/AM.pm
index 97e5896e8c0f25086abc4ec5d01cd85518b80cc1..91fc9a7c10012c0602d2b88e8fb181bfe5dbadff 100644 (file)
--- 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);
 
   # 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|;
 
                  FROM warehouse w
                  ORDER BY w.sortkey|;