From 8294e68340f98fcc692fd27fb5bd2b2b5b09c6db Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Tue, 12 May 2009 14:46:31 +0000 Subject: [PATCH] =?utf8?q?Bei=20verbrauchten=20Warenbest=C3=A4nden=20schei?= =?utf8?q?nt=20diese=20Abfrage=20zu=20falschen=20Lagerbest=C3=A4nden=20im?= =?utf8?q?=20Bereich=20Lieferschein=20zu=20f=C3=BChren.=20@mb=20Testdaten?= =?utf8?q?=20zeige=20ich=20Dir=20morgen?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DO.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/SL/DO.pm b/SL/DO.pm index 28eb85436..cdb11b1aa 100644 --- a/SL/DO.pm +++ b/SL/DO.pm @@ -895,9 +895,9 @@ sub get_item_availability { FROM inventory i LEFT JOIN warehouse w ON (i.warehouse_id = w.id) LEFT JOIN bin b ON (i.bin_id = b.id) - WHERE (i.parts_id IN (| . join(', ', ('?') x scalar(@parts_ids)) . qq|)) - AND qty > 0 - GROUP BY i.warehouse_id, i.bin_id, i.chargenumber, i.parts_id, w.description, b.description + WHERE (i.parts_id IN (| . join(', ', ('?') x scalar(@parts_ids)) . qq|))| . +# AND qty > 0 # das führt zu falschen warenbeständen, wenn man über lieferschein auslagert. @mb nochmal besprechen jb 12.5.09 + qq|GROUP BY i.warehouse_id, i.bin_id, i.chargenumber, i.parts_id, w.description, b.description ORDER BY LOWER(w.description), LOWER(b.description), LOWER(i.chargenumber)|; my $contents = selectall_hashref_query($form, $form->get_standard_dbh($myconfig), $query, @parts_ids); -- 2.20.1