X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FOrderItem.pm;h=cc0a92f95e198198786c3ba181c3c89d275a2bc1;hb=11aeaa07186197c61dfe610d2a5c981754fd2e9d;hp=f24abcaf12f4a6ee19b3dc9576155da1f79b7ecd;hpb=b213d89c9bb929cbebda13388284bd442f6f8aa2;p=kivitendo-erp.git diff --git a/SL/DB/OrderItem.pm b/SL/DB/OrderItem.pm index f24abcaf1..cc0a92f95 100644 --- a/SL/DB/OrderItem.pm +++ b/SL/DB/OrderItem.pm @@ -2,84 +2,91 @@ package SL::DB::OrderItem; use strict; -use List::Util qw(sum); -use SL::AM; - use SL::DB::MetaSetup::OrderItem; +use SL::DB::Manager::OrderItem; +use SL::DB::Helper::ActsAsList; +use SL::DB::Helper::LinkedRecords; +use SL::DB::Helper::RecordItem; use SL::DB::Helper::CustomVariables ( sub_module => 'orderitems', cvars_alias => 1, overloads => { - parts_id => 'SL::DB::Part', - }, -); - -__PACKAGE__->meta->add_relationship( - part => { - type => 'one to one', - class => 'SL::DB::Part', - column_map => { parts_id => 'id' }, - }, - price_factor_obj => { - type => 'one to one', - class => 'SL::DB::PriceFactor', - column_map => { price_factor_id => 'id' }, - }, - unit_obj => { - type => 'one to one', - class => 'SL::DB::Unit', - column_map => { unit => 'name' }, - }, - order => { - type => 'one to one', - class => 'SL::DB::Order', - column_map => { trans_id => 'id' }, + parts_id => { + class => 'SL::DB::Part', + module => 'IC', + } }, ); - -# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all. -__PACKAGE__->meta->make_manager_class; +use SL::Helper::ShippedQty; __PACKAGE__->meta->initialize; +__PACKAGE__->configure_acts_as_list(group_by => [qw(trans_id)]); + sub is_price_update_available { my $self = shift; return $self->origprice > $self->part->sellprice; } sub shipped_qty { - my ($self) = @_; + my ($self, %params) = @_; - my $d_orders = $self->order->linked_records(direction => 'to', to => 'SL::DB::DeliveryOrder'); - my @doi = grep { $_->parts_id == $self->parts_id } map { $_->orderitems } @$d_orders; + my $force = delete $params{force}; - return sum(map { AM->convert_unit($_->unit => $self->unit) * $_->qty } @doi); + SL::Helper::ShippedQty->new(%params)->calculate($self)->write_to_objects if $force || !defined $self->{shipped_qty}; + + $self->{shipped_qty}; } -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.reqdate)' ], - orddate => [ 'order.orddate' ], - sellprice => [ 'sellprice' ], - discount => [ 'discount' ], - transdate => [ 'transdate::date', 'order.reqdate' ], - }, - default => [ 'position', 1 ], - nulls => { } - ); +sub linked_delivery_order_items { + my ($self) = @_; + + return $self->linked_records(direction => 'to', to => 'SL::DB::DeliveryOrderItem'); } -sub default_objects_per_page { 40 } +sub delivered_qty { goto &shipped_qty } + +sub record { goto &order } 1; + +__END__ + +=pod + +=head1 NAME + +SL::DB::OrderItems: Rose model for orderitems + +=head1 FUNCTIONS + +=over 4 + +=item C + +Calculates the shipped qty for this orderitem (measured in the current unit) +and returns it. + +Note that the shipped qty is expected not to change within the request and is +cached in C once calculated. If C<< force => 1 >> is passed, the +existibng cache is ignored. + +Given parameters will be passed to L, so you can force +the shipped/delivered distinction like this: + + $_->shipped_qty(require_stock_out => 0); + +Note however that calculating shipped_qty on individual Orderitems is generally +a bad idea. See L for way to compute these all at once. + +=item C + +Alias for L. + +=back + +=head1 AUTHORS + +G. Richardson Egrichardson@kivitendo-premium.deE + +=cut