use SL::DB::MetaSetup::OrderItem;
use SL::DB::Manager::OrderItem;
+use SL::DB::DeliveryOrderItemsStock;
+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,
__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 delivered_qty {
my ($self) = @_;
+ return $self->_delivered_qty;
+}
+
+sub _delivered_qty {
+ my ($self) = @_;
+
+ return $self->{delivered_qty} if $self->{delivered_qty};
+
my $d_orders = $self->order->linked_records(direction => 'to', to => 'SL::DB::DeliveryOrder');
- my @d_orders_delivered;
- foreach (@$d_orders) {
- push (@d_orders_delivered, $_) if $_->delivered;
- }
+ my @d_orders_delivered = grep { $_->delivered } @$d_orders;
my @doi_delivered = grep { $_->parts_id == $self->parts_id } map { $_->orderitems } @d_orders_delivered;
require SL::AM;
- return sum(map { AM->convert_unit($_->unit => $self->unit) * $_->qty } @doi_delivered);
+ $self->{delivered_qty} = sum(map { AM->convert_unit($_->unit => $self->unit) * $_->qty } @doi_delivered);
+
+ return $self->{delivered_qty};
}
sub value_of_goods {
my ($self) = @_;
- my $price_factor = $self->price_factor ? $self->price_factor : 1;
+ my $price_factor = $self->price_factor || 1;
- return ($self->qty * $self->sellprice * (1 - $self->discount ) / $price_factor);
+ $self->_delivered_qty;
+ return ($self->_delivered_qty * $self->sellprice * (1 - $self->discount ) / $price_factor);
+}
+
+sub stocked_qty {
+ my ($self) = @_;
+
+ 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;
+
+ return 0 if !@doi;
+
+ my $doi_stocks = SL::DB::Manager::DeliveryOrderItemsStock->get_all(query => [delivery_order_item_id => [ map {$_->id} @doi ]]);
+
+ require SL::AM;
+ return sum(map { AM->convert_unit($_->unit => $self->unit) * $_->qty } @{ $doi_stocks });
}
sub taxincluded {
return SL::DB::Manager::Order->find_by(id => $self->trans_id)->taxincluded ? $::locale->text('WARN: Tax included value!') : '';
}
+
+sub record { goto &order }
+
1;