kivitendo/SL/DB/OrderItem.pm @ e6e4f310
| 82515b2d | Sven Schöling | package SL::DB::OrderItem;
|
||
use strict;
|
||||
| ba0fb69c | Sven Schöling | use List::Util qw(sum);
|
||
| 82515b2d | Sven Schöling | use SL::DB::MetaSetup::OrderItem;
|
||
| ef2b5e94 | Moritz Bunkus | use SL::DB::Manager::OrderItem;
|
||
| 3b7bda40 | Jan Büren | use SL::DB::DeliveryOrderItemsStock;
|
||
| 3954d14b | Bernd Bleßmann | use SL::DB::Helper::ActsAsList;
|
||
| ca808f20 | Geoffrey Richardson | use SL::DB::Helper::LinkedRecords;
|
||
| 1904d8c6 | Sven Schöling | use SL::DB::Helper::RecordItem;
|
||
| e1bf173b | Sven Schöling | use SL::DB::Helper::CustomVariables (
|
||
sub_module => 'orderitems',
|
||||
cvars_alias => 1,
|
||||
overloads => {
|
||||
| 5a7ae14c | Sven Schöling | parts_id => {
|
||
class => 'SL::DB::Part',
|
||||
module => 'IC',
|
||||
}
|
||||
| e1bf173b | Sven Schöling | },
|
||
);
|
||||
| 82515b2d | Sven Schöling | |||
__PACKAGE__->meta->initialize;
|
||||
| 3954d14b | Bernd Bleßmann | __PACKAGE__->configure_acts_as_list(group_by => [qw(trans_id)]);
|
||
| 82515b2d | Sven Schöling | sub is_price_update_available {
|
||
my $self = shift;
|
||||
return $self->origprice > $self->part->sellprice;
|
||||
}
|
||||
| ba0fb69c | Sven Schöling | sub shipped_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;
|
||||
| 26dcea15 | Sven Schöling | require SL::AM;
|
||
| ba0fb69c | Sven Schöling | return sum(map { AM->convert_unit($_->unit => $self->unit) * $_->qty } @doi);
|
||
}
|
||||
| b092fef7 | Jan Büren | sub delivered_qty {
|
||
my ($self) = @_;
|
||||
| 69e31dd3 | Jan Büren | return $self->_delivered_qty;
|
||
| f7c37ff9 | Jan Büren | }
|
||
sub _delivered_qty {
|
||||
my ($self) = @_;
|
||||
| 69e31dd3 | Jan Büren | return $self->{delivered_qty} if $self->{delivered_qty};
|
||
| 9c04a397 | Jan Büren | |||
| b092fef7 | Jan Büren | my $d_orders = $self->order->linked_records(direction => 'to', to => 'SL::DB::DeliveryOrder');
|
||
| 7d8de6d3 | Jan Büren | my @d_orders_delivered = grep { $_->delivered } @$d_orders;
|
||
| b092fef7 | Jan Büren | |||
my @doi_delivered = grep { $_->parts_id == $self->parts_id } map { $_->orderitems } @d_orders_delivered;
|
||||
require SL::AM;
|
||||
| 28f67151 | Jan Büren | $self->{delivered_qty} = sum(map { AM->convert_unit($_->unit => $self->unit) * $_->qty } @doi_delivered);
|
||
| 69e31dd3 | Jan Büren | |||
return $self->{delivered_qty};
|
||||
| b092fef7 | Jan Büren | }
|
||
| 4ecb8321 | Jan Büren | sub value_of_goods {
|
||
my ($self) = @_;
|
||||
| 7d8de6d3 | Jan Büren | my $price_factor = $self->price_factor || 1;
|
||
| 4ecb8321 | Jan Büren | |||
| 9c04a397 | Jan Büren | $self->_delivered_qty;
|
||
| d2910d36 | Jan Büren | return ($self->_delivered_qty * $self->sellprice * (1 - $self->discount ) / $price_factor);
|
||
| 4ecb8321 | Jan Büren | }
|
||
| 3b7bda40 | Jan Büren | 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 });
|
||||
}
|
||||
| 4ecb8321 | Jan Büren | sub taxincluded {
|
||
my ($self) = @_;
|
||||
return SL::DB::Manager::Order->find_by(id => $self->trans_id)->taxincluded ? $::locale->text('WARN: Tax included value!') : '';
|
||||
}
|
||||
| 073ee541 | Geoffrey Richardson | |||
sub record { goto &order }
|
||||
| 82515b2d | Sven Schöling | 1;
|