X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FAM.pm;h=3f34e18c7c0d02cff7cba6d4fa56dd546e07e6fd;hb=9dc9cfefd45e66cb4298dd572e3582613ae547a6;hp=97e5896e8c0f25086abc4ec5d01cd85518b80cc1;hpb=83914eeb2e95cdf587565952eef54be59dd58693;p=kivitendo-erp.git

diff --git a/SL/AM.pm b/SL/AM.pm
index 97e5896e8..3f34e18c7 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|;
 
@@ -2539,7 +2540,7 @@ sub get_warehouse {
                  FROM warehouse w
                  WHERE w.id = ?|;
 
-  my $ref   = selectfirst_hashref_query($form, $dbh, $query, $id, $id);
+  my $ref   = selectfirst_hashref_query($form, $dbh, $query, $id);
 
   map { $form->{$_} = $ref->{$_} } keys %{ $ref };