projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
CSV-Kunden-/Lieferantenimport: Verwendung von TransNumber zur Erzeugung von Nummern
[kivitendo-erp.git]
/
SL
/
DB
/
OrderItem.pm
diff --git
a/SL/DB/OrderItem.pm
b/SL/DB/OrderItem.pm
index
d193393
..
f24abca
100644
(file)
--- a/
SL/DB/OrderItem.pm
+++ b/
SL/DB/OrderItem.pm
@@
-68,11
+68,12
@@
sub _sort_spec {
qty => [ 'qty' ],
ordnumber => [ 'order.ordnumber' ],
customer => [ 'lower(customer.name)', ],
qty => [ 'qty' ],
ordnumber => [ 'order.ordnumber' ],
customer => [ 'lower(customer.name)', ],
- position => [ 'trans_id' ],
- reqdate => [ 'COALESCE(orderitems.reqdate, order.
trans
date)' ],
+ position => [ 'trans_id'
, 'runningnumber'
],
+ reqdate => [ 'COALESCE(orderitems.reqdate, order.
req
date)' ],
orddate => [ 'order.orddate' ],
sellprice => [ 'sellprice' ],
discount => [ 'discount' ],
orddate => [ 'order.orddate' ],
sellprice => [ 'sellprice' ],
discount => [ 'discount' ],
+ transdate => [ 'transdate::date', 'order.reqdate' ],
},
default => [ 'position', 1 ],
nulls => { }
},
default => [ 'position', 1 ],
nulls => { }