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