X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FAM.pm;h=3f34e18c7c0d02cff7cba6d4fa56dd546e07e6fd;hb=9dc9cfefd45e66cb4298dd572e3582613ae547a6;hp=91fc9a7c10012c0602d2b88e8fb181bfe5dbadff;hpb=d6e36f9c0d4bfb573298620e3f7d2ffd3c90c68c;p=kivitendo-erp.git diff --git a/SL/AM.pm b/SL/AM.pm index 91fc9a7c1..3f34e18c7 100644 --- a/SL/AM.pm +++ b/SL/AM.pm @@ -2518,7 +2518,7 @@ sub get_all_warehouses { my $dbh = $form->get_standard_dbh($myconfig); 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, + (SELECT COUNT(b.description) FROM bin b WHERE b.warehouse_id = w.id) AS number_of_bins FROM warehouse w ORDER BY w.sortkey|; @@ -2540,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 };