X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/82053b457be3de2ee5285dc13633222f4d30802c..5349a1ed016ae603b39d73747eccc6792707db1c:/SL/DB/Manager/OrderItem.pm diff --git a/SL/DB/Manager/OrderItem.pm b/SL/DB/Manager/OrderItem.pm index e964f4ff3..379e1fdb7 100644 --- 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)', ], - position => [ 'trans_id', 'runningnumber' ], + position => [ 'trans_id', 'position' ], 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 ], @@ -46,6 +46,6 @@ sub _sort_spec { ); } -sub default_objects_per_page { 40 } +sub default_objects_per_page { 15 } 1;