projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge branch 'b-3.6.1' into mebil
[kivitendo-erp.git]
/
SL
/
Controller
/
DeliveryPlan.pm
diff --git
a/SL/Controller/DeliveryPlan.pm
b/SL/Controller/DeliveryPlan.pm
index
a94c844
..
6d7aaa9
100644
(file)
--- a/
SL/Controller/DeliveryPlan.pm
+++ b/
SL/Controller/DeliveryPlan.pm
@@
-199,12
+199,13
@@
sub delivery_plan_query_linked_items {
(oe.quotation = 'f' OR oe.quotation IS NULL) AND
NOT oe.closed AND
$oe_owner
(oe.quotation = 'f' OR oe.quotation IS NULL) AND
NOT oe.closed AND
$oe_owner
-
oi.id NOT IN
(
+
NOT EXISTS
(
SELECT from_id
FROM record_links rl
WHERE
SELECT from_id
FROM record_links rl
WHERE
- rl.from_table ='orderitems' AND
- rl.to_table = 'delivery_order_items'
+ rl.from_table = 'orderitems' AND
+ rl.to_table = 'delivery_order_items' AND
+ rl.from_id = oi.id
)
" ], # make emacs happy again: " ]
)
" ], # make emacs happy again: " ]