Revision f68a363d
Von Bernd Bleßmann vor mehr als 1 Jahr hinzugefügt
| SL/Controller/DispositionManager.pm | ||
|---|---|---|
|
LEFT JOIN warehouse w ON inv.warehouse_id = w.id
|
||
|
WHERE NOT w.invalid
|
||
|
GROUP BY inv.parts_id
|
||
|
|
||
|
|
||
|
UNION ALL
|
||
|
|
||
|
|
||
|
SELECT p.id, 0 as sum
|
||
|
FROM parts p
|
||
|
WHERE p.id NOT IN ( SELECT distinct parts_id from inventory)
|
||
Auch abrufbar als: Unified diff
S:C:DispositionManager: Kosmetik: keine Leerzeichen am Ende