Revision d6e36f9c
Von Moritz Bunkus vor etwa 17 Jahren hinzugefügt
| SL/AM.pm | ||
|---|---|---|
|
# 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|;
|
||
|
|
||
Auch abrufbar als: Unified diff
Anzahl der Lager in der Lagerübersicht anzeigen.