X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDB%2FOrderItem.pm;h=3b868d350991bee5fb9c79b55fb6e8236ec675c6;hb=706d20f46c3e638de6ffca27e0fbdd48394b24ab;hp=5c18c4ce9a78aad29fdd7ebd11bc0e940981eb80;hpb=ba0fb69ce21dd281a09d91418785fa87203f9e6c;p=kivitendo-erp.git diff --git a/SL/DB/OrderItem.pm b/SL/DB/OrderItem.pm index 5c18c4ce9..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', 'runningnumber' ], - reqdate => [ 'COALESCE(orderitems.reqdate, order.transdate)' ], - orddate => [ 'order.orddate' ], - sellprice => [ 'sellprice' ], - discount => [ 'discount' ], - }, - default => [ 'position', 1 ], - nulls => { } - ); -} - -sub default_objects_per_page { 40 } - 1;