Revision b2c069f6
Von Werner Hahn vor mehr als 1 Jahr hinzugefügt
SL/DB/Manager/Part.pm | ||
---|---|---|
LEFT OUTER JOIN oe o ON (oi.trans_id = o.id)
|
||
WHERE
|
||
oi.parts_id = ?
|
||
AND (NOT COALESCE(o.quotation, FALSE))
|
||
AND (o.record_type = 'purchase_order')
|
||
AND (NOT COALESCE(o.closed, FALSE))
|
||
AND (NOT COALESCE(o.delivered, FALSE))
|
||
AND (COALESCE(o.vendor_id, 0) <> 0)
|
||
... | ... | |
LEFT OUTER JOIN oe o ON (oi.trans_id = o.id)
|
||
WHERE
|
||
oi.parts_id = ?
|
||
AND (NOT COALESCE(o.quotation, FALSE))
|
||
AND (o.record_type = 'purchase_order')
|
||
AND (NOT COALESCE(o.closed, FALSE))
|
||
AND (NOT COALESCE(o.delivered, FALSE))
|
||
AND (o.vendor_id is not null)
|
SL/DB/Order.pm | ||
---|---|---|
delivery_term_id => $vendor->delivery_term_id,
|
||
taxzone_id => $vendor->taxzone_id,
|
||
currency_id => $vendor->currency_id,
|
||
transdate => DateTime->today_local
|
||
transdate => DateTime->today_local,
|
||
record_type => PURCHASE_ORDER_TYPE(),
|
||
);
|
||
|
||
my @order_items;
|
Auch abrufbar als: Unified diff
Dispostionsmanager Controller an record_type angepasst