X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FOrderItem.pm;h=3b868d350991bee5fb9c79b55fb6e8236ec675c6;hb=55af6244bd721f294ff5eee7e9357a3217318e5e;hp=d193393bb667c61bbf53af04a6566bd768349338;hpb=71734294d77354238b1f1c4ed1775352a0228290;p=kivitendo-erp.git diff --git a/SL/DB/OrderItem.pm b/SL/DB/OrderItem.pm index d193393bb..3b868d350 100644 --- a/SL/DB/OrderItem.pm +++ b/SL/DB/OrderItem.pm @@ -6,6 +6,7 @@ use List::Util qw(sum); use SL::AM; use SL::DB::MetaSetup::OrderItem; +use SL::DB::Manager::OrderItem; use SL::DB::Helper::CustomVariables ( sub_module => 'orderitems', cvars_alias => 1, @@ -37,9 +38,6 @@ __PACKAGE__->meta->add_relationship( }, ); -# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. -__PACKAGE__->meta->make_manager_class; - __PACKAGE__->meta->initialize; sub is_price_update_available { @@ -56,29 +54,4 @@ sub shipped_qty { return sum(map { AM->convert_unit($_->unit => $self->unit) * $_->qty } @doi); } -package SL::DB::Manager::OrderItem; - -use SL::DB::Helper::Paginated; -use SL::DB::Helper::Sorted; - -sub _sort_spec { - return ( columns => { delivery_date => [ 'deliverydate', ], - description => [ 'lower(orderitems.description)', ], - partnumber => [ 'part.partnumber', ], - qty => [ 'qty' ], - ordnumber => [ 'order.ordnumber' ], - customer => [ 'lower(customer.name)', ], - position => [ 'trans_id' ], - reqdate => [ 'COALESCE(orderitems.reqdate, order.transdate)' ], - orddate => [ 'order.orddate' ], - sellprice => [ 'sellprice' ], - discount => [ 'discount' ], - }, - default => [ 'position', 1 ], - nulls => { } - ); -} - -sub default_objects_per_page { 40 } - 1;