projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Ein Anführungszeichen zu viel. Fix für Bug 786.
[kivitendo-erp.git]
/
SL
/
AM.pm
diff --git
a/SL/AM.pm
b/SL/AM.pm
index
97e5896
..
3f34e18
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|;
@@
-2539,7
+2540,7
@@
sub get_warehouse {
FROM warehouse w
WHERE w.id = ?|;
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 };
map { $form->{$_} = $ref->{$_} } keys %{ $ref };