projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
bank_transaction_acc_trans: überflüssige Spalte »id« entfernt
[kivitendo-erp.git]
/
SL
/
DB
/
Manager
/
OrderItem.pm
diff --git
a/SL/DB/Manager/OrderItem.pm
b/SL/DB/Manager/OrderItem.pm
index
ce673db
..
379e1fd
100644
(file)
--- a/
SL/DB/Manager/OrderItem.pm
+++ b/
SL/DB/Manager/OrderItem.pm
@@
-34,11
+34,11
@@
sub _sort_spec {
qty => [ 'qty' ],
ordnumber => [ 'order.ordnumber' ],
customer => [ 'lower(customer.name)', ],
qty => [ 'qty' ],
ordnumber => [ 'order.ordnumber' ],
customer => [ 'lower(customer.name)', ],
- position => [ 'trans_id', '
runningnumber
' ],
+ position => [ 'trans_id', '
position
' ],
reqdate => [ 'COALESCE(orderitems.reqdate, order.reqdate)' ],
orddate => [ 'order.orddate' ],
reqdate => [ 'COALESCE(orderitems.reqdate, order.reqdate)' ],
orddate => [ 'order.orddate' ],
- sellprice => [ 'sellprice' ],
- discount => [ 'discount' ],
+ sellprice => [ '
orderitems.
sellprice' ],
+ discount => [ '
orderitems.
discount' ],
transdate => [ 'orderitems.transdate::date', 'order.reqdate' ],
},
default => [ 'position', 1 ],
transdate => [ 'orderitems.transdate::date', 'order.reqdate' ],
},
default => [ 'position', 1 ],