Revision d6e36f9c
Von Moritz Bunkus vor fast 17 Jahren hinzugefügt
| SL/AM.pm | ||
|---|---|---|
| 2517 | 2517 |
# connect to database |
| 2518 | 2518 |
my $dbh = $form->get_standard_dbh($myconfig); |
| 2519 | 2519 |
|
| 2520 |
my $query = qq|SELECT w.id, w.description, w.invalid |
|
| 2520 |
my $query = qq|SELECT w.id, w.description, w.invalid, |
|
| 2521 |
(SELECT COUNT(b.description) FROM bin b WHERE b.warehouse_id = w.id) AS number_of_bins, |
|
| 2521 | 2522 |
FROM warehouse w |
| 2522 | 2523 |
ORDER BY w.sortkey|; |
| 2523 | 2524 |
|
Auch abrufbar als: Unified diff
Anzahl der Lager in der Lagerübersicht anzeigen.