1 package SL::DB::OrderItem;
5 use List::Util qw(sum);
7 use SL::DB::MetaSetup::OrderItem;
8 use SL::DB::Manager::OrderItem;
9 use SL::DB::DeliveryOrderItemsStock;
10 use SL::DB::Helper::CustomVariables (
11 sub_module => 'orderitems',
15 class => 'SL::DB::Part',
21 __PACKAGE__->meta->initialize;
23 sub is_price_update_available {
25 return $self->origprice > $self->part->sellprice;
31 my $d_orders = $self->order->linked_records(direction => 'to', to => 'SL::DB::DeliveryOrder');
32 my @doi = grep { $_->parts_id == $self->parts_id } map { $_->orderitems } @$d_orders;
35 return sum(map { AM->convert_unit($_->unit => $self->unit) * $_->qty } @doi);
41 return $self->_delivered_qty;
47 return $self->{delivered_qty} if $self->{delivered_qty};
49 my $d_orders = $self->order->linked_records(direction => 'to', to => 'SL::DB::DeliveryOrder');
51 my @d_orders_delivered = grep { $_->delivered } @$d_orders;
53 my @doi_delivered = grep { $_->parts_id == $self->parts_id } map { $_->orderitems } @d_orders_delivered;
56 $self->{delivered_qty} = sum(map { AM->convert_unit($_->unit => $self->unit) * $_->qty } @doi_delivered);
58 return $self->{delivered_qty};
64 my $price_factor = $self->price_factor || 1;
66 $self->_delivered_qty;
67 return ($self->_delivered_qty * $self->sellprice * (1 - $self->discount ) / $price_factor);
73 my $d_orders = $self->order->linked_records(direction => 'to', to => 'SL::DB::DeliveryOrder');
74 my @doi = grep { $_->parts_id == $self->parts_id } map { $_->orderitems } @$d_orders;
78 my $doi_stocks = SL::DB::Manager::DeliveryOrderItemsStock->get_all(query => [delivery_order_item_id => [ map {$_->id} @doi ]]);
81 return sum(map { AM->convert_unit($_->unit => $self->unit) * $_->qty } @{ $doi_stocks });
87 return SL::DB::Manager::Order->find_by(id => $self->trans_id)->taxincluded ? $::locale->text('WARN: Tax included value!') : '';