kivitendo/SL/DB/Order.pm @ ca601f74
| 82515b2d | Sven Schöling | package SL::DB::Order;
|
||
| 05c6840d | Moritz Bunkus | use utf8;
|
||
| 82515b2d | Sven Schöling | use strict;
|
||
| 42ea98b4 | Moritz Bunkus | use Carp;
|
||
use DateTime;
|
||||
use List::Util qw(max);
|
||||
| f747a789 | Bernd Bleßmann | use List::MoreUtils qw(any);
|
||
| 82515b2d | Sven Schöling | |||
| 70ae535d | Jan Büren | use SL::DBUtils ();
|
||
| 82515b2d | Sven Schöling | use SL::DB::MetaSetup::Order;
|
||
use SL::DB::Manager::Order;
|
||||
| 4b1666b7 | Felix Eichler | use SL::DB::Helper::Attr;
|
||
| a34c05f3 | Moritz Bunkus | use SL::DB::Helper::AttrHTML;
|
||
| f63af42d | Moritz Bunkus | use SL::DB::Helper::AttrSorted;
|
||
| c692dae1 | Moritz Bunkus | use SL::DB::Helper::FlattenToForm;
|
||
| e9fb6244 | Moritz Bunkus | use SL::DB::Helper::LinkedRecords;
|
||
use SL::DB::Helper::PriceTaxCalculator;
|
||||
| 2209370e | Moritz Bunkus | use SL::DB::Helper::PriceUpdater;
|
||
| b9dbc9e3 | Moritz Bunkus | use SL::DB::Helper::TransNumberGenerator;
|
||
| 5a6d7c03 | Geoffrey Richardson | use SL::DB::Helper::Payment qw(forex);
|
||
| 0956f2d4 | Felix Eichler | use SL::Locale::String qw(t8);
|
||
| 42ea98b4 | Moritz Bunkus | use SL::RecordLinks;
|
||
| 9b0937a9 | Tamino Steinert | use Rose::DB::Object::Helpers qw(as_tree strip);
|
||
| 82515b2d | Sven Schöling | |||
__PACKAGE__->meta->add_relationship(
|
||||
orderitems => {
|
||||
type => 'one to many',
|
||||
class => 'SL::DB::OrderItem',
|
||||
column_map => { id => 'trans_id' },
|
||||
manager_args => {
|
||||
| 0845c4b7 | Moritz Bunkus | with_objects => [ 'part' ]
|
||
| 82515b2d | Sven Schöling | }
|
||
| 250fa402 | Moritz Bunkus | },
|
||
periodic_invoices_config => {
|
||||
| 27bb493f | Moritz Bunkus | type => 'one to one',
|
||
| 250fa402 | Moritz Bunkus | class => 'SL::DB::PeriodicInvoicesConfig',
|
||
column_map => { id => 'oe_id' },
|
||||
},
|
||||
| 325c539c | Moritz Bunkus | custom_shipto => {
|
||
type => 'one to one',
|
||||
class => 'SL::DB::Shipto',
|
||||
column_map => { id => 'trans_id' },
|
||||
query_args => [ module => 'OE' ],
|
||||
},
|
||||
| 4b1666b7 | Felix Eichler | exchangerate_obj => {
|
||
type => 'one to one',
|
||||
class => 'SL::DB::Exchangerate',
|
||||
column_map => { currency_id => 'currency_id', transdate => 'transdate' },
|
||||
},
|
||||
| 332b5ec7 | Bernd Bleßmann | phone_notes => {
|
||
type => 'one to many',
|
||||
class => 'SL::DB::Note',
|
||||
column_map => { id => 'trans_id' },
|
||||
query_args => [ trans_module => 'oe' ],
|
||||
manager_args => {
|
||||
with_objects => [ 'employee' ],
|
||||
sort_by => 'notes.itime',
|
||||
}
|
||||
},
|
||||
| 70ae535d | Jan Büren | order_version => {
|
||
type => 'one to many',
|
||||
class => 'SL::DB::OrderVersion',
|
||||
column_map => { id => 'oe_id' },
|
||||
},
|
||||
| 82515b2d | Sven Schöling | );
|
||
| b1817cb6 | Bernd Bleßmann | SL::DB::Helper::Attr::make(__PACKAGE__, daily_exchangerate => 'numeric');
|
||
| 4b1666b7 | Felix Eichler | |||
| 82515b2d | Sven Schöling | __PACKAGE__->meta->initialize;
|
||
| a34c05f3 | Moritz Bunkus | __PACKAGE__->attr_html('notes');
|
||
| f63af42d | Moritz Bunkus | __PACKAGE__->attr_sorted('items');
|
||
| a34c05f3 | Moritz Bunkus | |||
| 1bcb4ec6 | Moritz Bunkus | __PACKAGE__->before_save('_before_save_set_ord_quo_number');
|
||
| 1b18f0aa | Jan Büren | __PACKAGE__->before_save('_before_save_create_new_project');
|
||
| 7cad87f8 | Bernd Bleßmann | __PACKAGE__->before_save('_before_save_remove_empty_custom_shipto');
|
||
__PACKAGE__->before_save('_before_save_set_custom_shipto_module');
|
||||
| 1bcb4ec6 | Moritz Bunkus | |||
# hooks
|
||||
sub _before_save_set_ord_quo_number {
|
||||
my ($self) = @_;
|
||||
# ordnumber is 'NOT NULL'. Therefore make sure it's always set to at
|
||||
# least an empty string, even if we're saving a quotation.
|
||||
$self->ordnumber('') if !$self->ordnumber;
|
||||
my $field = $self->quotation ? 'quonumber' : 'ordnumber';
|
||||
$self->create_trans_number if !$self->$field;
|
||||
return 1;
|
||||
}
|
||||
| 1b18f0aa | Jan Büren | sub _before_save_create_new_project {
|
||
my ($self) = @_;
|
||||
# force new project, if not set yet
|
||||
if ($::instance_conf->get_order_always_project && !$self->globalproject_id && ($self->type eq 'sales_order')) {
|
||||
die t8("Error while creating project with project number of new order number, project number #1 already exists!", $self->ordnumber)
|
||||
if SL::DB::Manager::Project->find_by(projectnumber => $self->ordnumber);
|
||||
eval {
|
||||
my $new_project = SL::DB::Project->new(
|
||||
projectnumber => $self->ordnumber,
|
||||
description => $self->customer->name,
|
||||
customer_id => $self->customer->id,
|
||||
active => 1,
|
||||
project_type_id => $::instance_conf->get_project_type_id,
|
||||
project_status_id => $::instance_conf->get_project_status_id,
|
||||
);
|
||||
$new_project->save;
|
||||
$self->globalproject_id($new_project->id);
|
||||
} or die t8('Could not create new project #1', $@);
|
||||
}
|
||||
return 1;
|
||||
}
|
||||
| 1bcb4ec6 | Moritz Bunkus | |||
| 7cad87f8 | Bernd Bleßmann | |||
sub _before_save_remove_empty_custom_shipto {
|
||||
my ($self) = @_;
|
||||
$self->custom_shipto(undef) if $self->custom_shipto && $self->custom_shipto->is_empty;
|
||||
return 1;
|
||||
}
|
||||
sub _before_save_set_custom_shipto_module {
|
||||
my ($self) = @_;
|
||||
$self->custom_shipto->module('OE') if $self->custom_shipto;
|
||||
return 1;
|
||||
}
|
||||
| 82515b2d | Sven Schöling | # methods
|
||
| 0845c4b7 | Moritz Bunkus | sub items { goto &orderitems; }
|
||
| ae906113 | Moritz Bunkus | sub add_items { goto &add_orderitems; }
|
||
| 4f7e0fa9 | Geoffrey Richardson | sub record_number { goto &number; }
|
||
| 4ac74078 | Moritz Bunkus | |||
| 82515b2d | Sven Schöling | sub type {
|
||
my $self = shift;
|
||||
| ca601f74 | Bernd Bleßmann | return 'sales_order_intake' if $self->customer_id && $self->intake;
|
||
return 'sales_order' if $self->customer_id && ! $self->quotation;
|
||||
return 'purchase_order' if $self->vendor_id && ! $self->quotation;
|
||||
return 'sales_quotation' if $self->customer_id && $self->quotation;
|
||||
return 'request_quotation' if $self->vendor_id && $self->quotation && ! $self->intake;
|
||||
return 'purchase_quotation_intake' if $self->vendor_id && $self->quotation && $self->intake;
|
||||
| 82515b2d | Sven Schöling | |||
return;
|
||||
}
|
||||
sub is_type {
|
||||
return shift->type eq shift;
|
||||
}
|
||||
| 9f809e7f | Geoffrey Richardson | sub deliverydate {
|
||
| a6485c58 | Bernd Bleßmann | # oe doesn't have deliverydate, but it does have reqdate.
|
||
# But this has a different meaning for sales quotations.
|
||||
# deliverydate can be used to determine tax if tax_point isn't set.
|
||||
return $_[0]->reqdate if $_[0]->type ne 'sales_quotation';
|
||||
| 9f809e7f | Geoffrey Richardson | }
|
||
| 0b36b225 | Moritz Bunkus | sub effective_tax_point {
|
||
my ($self) = @_;
|
||||
| a6485c58 | Bernd Bleßmann | return $self->tax_point || $self->deliverydate || $self->transdate;
|
||
| 0b36b225 | Moritz Bunkus | }
|
||
| 2746ccd0 | Sven Schöling | sub displayable_type {
|
||
my $type = shift->type;
|
||||
return $::locale->text('Sales quotation') if $type eq 'sales_quotation';
|
||||
return $::locale->text('Request quotation') if $type eq 'request_quotation';
|
||||
return $::locale->text('Sales Order') if $type eq 'sales_order';
|
||||
return $::locale->text('Purchase Order') if $type eq 'purchase_order';
|
||||
die 'invalid type';
|
||||
}
|
||||
| a7114646 | Geoffrey Richardson | sub displayable_name {
|
||
join ' ', grep $_, map $_[0]->$_, qw(displayable_type record_number);
|
||||
};
|
||||
| 2746ccd0 | Sven Schöling | |||
| 211de9e3 | Sven Schöling | sub is_sales {
|
||
croak 'not an accessor' if @_ > 1;
|
||||
| 61bd6288 | Moritz Bunkus | return !!shift->customer_id;
|
||
| 211de9e3 | Sven Schöling | }
|
||
| b1817cb6 | Bernd Bleßmann | sub daily_exchangerate {
|
||
| 4b1666b7 | Felix Eichler | my ($self, $val) = @_;
|
||
return 1 if $self->currency_id == $::instance_conf->get_currency_id;
|
||||
| e810df1e | Bernd Bleßmann | my $rate = (any { $self->is_type($_) } qw(sales_quotation sales_order)) ? 'buy'
|
||
: (any { $self->is_type($_) } qw(request_quotation purchase_order)) ? 'sell'
|
||||
: undef;
|
||||
return if !$rate;
|
||||
| 4b1666b7 | Felix Eichler | |||
if (defined $val) {
|
||||
| 0956f2d4 | Felix Eichler | croak t8('exchange rate has to be positive') if $val <= 0;
|
||
| 4b1666b7 | Felix Eichler | if (!$self->exchangerate_obj) {
|
||
$self->exchangerate_obj(SL::DB::Exchangerate->new(
|
||||
currency_id => $self->currency_id,
|
||||
transdate => $self->transdate,
|
||||
$rate => $val,
|
||||
));
|
||||
} elsif (!defined $self->exchangerate_obj->$rate) {
|
||||
$self->exchangerate_obj->$rate($val);
|
||||
} else {
|
||||
| 0956f2d4 | Felix Eichler | croak t8('exchange rate already exists, no update allowed');
|
||
| 4b1666b7 | Felix Eichler | }
|
||
}
|
||||
return $self->exchangerate_obj->$rate if $self->exchangerate_obj;
|
||||
}
|
||||
| 82515b2d | Sven Schöling | sub invoices {
|
||
my $self = shift;
|
||||
my %params = @_;
|
||||
if ($self->quotation) {
|
||||
return [];
|
||||
} else {
|
||||
| 71e6f43b | Sven Schöling | require SL::DB::Invoice;
|
||
| 82515b2d | Sven Schöling | return SL::DB::Manager::Invoice->get_all(
|
||
query => [
|
||||
ordnumber => $self->ordnumber,
|
||||
@{ $params{query} || [] },
|
||||
]
|
||||
);
|
||||
}
|
||||
}
|
||||
| 2746ccd0 | Sven Schöling | sub displayable_state {
|
||
my ($self) = @_;
|
||||
return $self->closed ? $::locale->text('closed') : $::locale->text('open');
|
||||
}
|
||||
| 82515b2d | Sven Schöling | sub abschlag_invoices {
|
||
return shift()->invoices(query => [ abschlag => 1 ]);
|
||||
}
|
||||
sub end_invoice {
|
||||
return shift()->invoices(query => [ abschlag => 0 ]);
|
||||
}
|
||||
| 42ea98b4 | Moritz Bunkus | sub convert_to_invoice {
|
||
my ($self, %params) = @_;
|
||||
| f4dca613 | Moritz Bunkus | croak("Conversion to invoices is only supported for sales records") unless $self->customer_id;
|
||
| 42ea98b4 | Moritz Bunkus | my $invoice;
|
||
| 0fdcea4d | Moritz Bunkus | if (!$self->db->with_transaction(sub {
|
||
| c50f0950 | Moritz Bunkus | require SL::DB::Invoice;
|
||
| a4624332 | Bernd Bleßmann | $invoice = SL::DB::Invoice->new_from($self, %params)->post || die;
|
||
| 42ea98b4 | Moritz Bunkus | $self->link_to_record($invoice);
|
||
| 6c3afa9b | Bernd Bleßmann | # TODO extend link_to_record for items, otherwise long-term no d.r.y.
|
||
foreach my $item (@{ $invoice->items }) {
|
||||
foreach (qw(orderitems)) {
|
||||
if ($item->{"converted_from_${_}_id"}) {
|
||||
die unless $item->{id};
|
||||
RecordLinks->create_links('mode' => 'ids',
|
||||
'from_table' => $_,
|
||||
'from_ids' => $item->{"converted_from_${_}_id"},
|
||||
'to_table' => 'invoice',
|
||||
'to_id' => $item->{id},
|
||||
) || die;
|
||||
delete $item->{"converted_from_${_}_id"};
|
||||
}
|
||||
}
|
||||
}
|
||||
| 42ea98b4 | Moritz Bunkus | $self->update_attributes(closed => 1);
|
||
| 0fdcea4d | Moritz Bunkus | 1;
|
||
| 42ea98b4 | Moritz Bunkus | })) {
|
||
return undef;
|
||||
}
|
||||
return $invoice;
|
||||
}
|
||||
| 7664f50f | Moritz Bunkus | sub convert_to_delivery_order {
|
||
| c37da034 | Moritz Bunkus | my ($self, @args) = @_;
|
||
| 7664f50f | Moritz Bunkus | |||
| 492c85c2 | Moritz Bunkus | my $delivery_order;
|
||
| 0fdcea4d | Moritz Bunkus | if (!$self->db->with_transaction(sub {
|
||
| 7664f50f | Moritz Bunkus | require SL::DB::DeliveryOrder;
|
||
| 492c85c2 | Moritz Bunkus | $delivery_order = SL::DB::DeliveryOrder->new_from($self, @args);
|
||
| 7664f50f | Moritz Bunkus | $delivery_order->save;
|
||
$self->link_to_record($delivery_order);
|
||||
| fc890e10 | Jan Büren | # TODO extend link_to_record for items, otherwise long-term no d.r.y.
|
||
foreach my $item (@{ $delivery_order->items }) {
|
||||
foreach (qw(orderitems)) { # expand if needed (delivery_order_items)
|
||||
if ($item->{"converted_from_${_}_id"}) {
|
||||
die unless $item->{id};
|
||||
| 5c257935 | Bernd Bleßmann | RecordLinks->create_links('dbh' => $self->db->dbh,
|
||
'mode' => 'ids',
|
||||
| fc890e10 | Jan Büren | 'from_table' => $_,
|
||
'from_ids' => $item->{"converted_from_${_}_id"},
|
||||
'to_table' => 'delivery_order_items',
|
||||
'to_id' => $item->{id},
|
||||
) || die;
|
||||
delete $item->{"converted_from_${_}_id"};
|
||||
}
|
||||
}
|
||||
}
|
||||
| 8f413df4 | Jan Büren | $self->update_attributes(delivered => 1) unless $::instance_conf->get_shipped_qty_require_stock_out;
|
||
| 0fdcea4d | Moritz Bunkus | 1;
|
||
| 7664f50f | Moritz Bunkus | })) {
|
||
| 492c85c2 | Moritz Bunkus | return undef;
|
||
| 7664f50f | Moritz Bunkus | }
|
||
| 492c85c2 | Moritz Bunkus | return $delivery_order;
|
||
| 7664f50f | Moritz Bunkus | }
|
||
| eff10782 | Tamino Steinert | sub convert_to_reclamation {
|
||
my ($self, %params) = @_;
|
||||
$params{destination_type} = $self->is_sales ? 'sales_reclamation'
|
||||
: 'purchase_reclamation';
|
||||
require SL::DB::Reclamation;
|
||||
my $reclamation = SL::DB::Reclamation->new_from($self, %params);
|
||||
return $reclamation;
|
||||
}
|
||||
| b14755d0 | Bernd Bleßmann | sub _clone_orderitem_cvar {
|
||
my ($cvar) = @_;
|
||||
my $cloned = $_->clone_and_reset;
|
||||
$cloned->sub_module('orderitems');
|
||||
return $cloned;
|
||||
}
|
||||
sub new_from {
|
||||
my ($class, $source, %params) = @_;
|
||||
| eff10782 | Tamino Steinert | unless (any {ref($source) eq $_} qw(
|
||
SL::DB::Order
|
||||
SL::DB::Reclamation
|
||||
)) {
|
||||
croak("Unsupported source object type '" . ref($source) . "'");
|
||||
}
|
||||
| 5af5ceee | Bernd Bleßmann | croak("A destination type must be given as parameter") unless $params{destination_type};
|
||
| b14755d0 | Bernd Bleßmann | |||
my $destination_type = delete $params{destination_type};
|
||||
| f747a789 | Bernd Bleßmann | |||
my @from_tos = (
|
||||
| ee6fe6b9 | Bernd Bleßmann | { from => 'sales_quotation', to => 'sales_order', abbr => 'sqso' },
|
||
{ from => 'request_quotation', to => 'purchase_order', abbr => 'rqpo' },
|
||||
{ from => 'sales_quotation', to => 'sales_quotation', abbr => 'sqsq' },
|
||||
{ from => 'sales_order', to => 'sales_order', abbr => 'soso' },
|
||||
{ from => 'request_quotation', to => 'request_quotation', abbr => 'rqrq' },
|
||||
{ from => 'purchase_order', to => 'purchase_order', abbr => 'popo' },
|
||||
{ from => 'sales_order', to => 'purchase_order', abbr => 'sopo' },
|
||||
{ from => 'purchase_order', to => 'sales_order', abbr => 'poso' },
|
||||
{ from => 'sales_order', to => 'sales_quotation', abbr => 'sosq' },
|
||||
{ from => 'purchase_order', to => 'request_quotation', abbr => 'porq' },
|
||||
{ from => 'request_quotation', to => 'sales_quotation', abbr => 'rqsq' },
|
||||
{ from => 'request_quotation', to => 'sales_order', abbr => 'rqso' },
|
||||
{ from => 'sales_quotation', to => 'request_quotation', abbr => 'sqrq' },
|
||||
{ from => 'sales_order', to => 'request_quotation', abbr => 'sorq' },
|
||||
{ from => 'sales_reclamation', to => 'sales_order', abbr => 'srso' },
|
||||
{ from => 'purchase_reclamation', to => 'purchase_order', abbr => 'prpo' },
|
||||
{ from => 'sales_order_intake', to => 'sales_order_intake', abbr => 'soisoi' },
|
||||
{ from => 'sales_order_intake', to => 'sales_quotation', abbr => 'soisq' },
|
||||
{ from => 'sales_order_intake', to => 'request_quotation', abbr => 'soirq' },
|
||||
{ from => 'sales_order_intake', to => 'sales_order', abbr => 'soiso' },
|
||||
{ from => 'sales_order_intake', to => 'purchase_order', abbr => 'soipo' },
|
||||
{ from => 'sales_quotation', to => 'sales_order_intake', abbr => 'sqsoi' },
|
||||
| f747a789 | Bernd Bleßmann | );
|
||
my $from_to = (grep { $_->{from} eq $source->type && $_->{to} eq $destination_type} @from_tos)[0];
|
||||
croak("Cannot convert from '" . $source->type . "' to '" . $destination_type . "'") if !$from_to;
|
||||
| b14755d0 | Bernd Bleßmann | |||
| 69966b4c | Bernd Bleßmann | my $is_abbr_any = sub {
|
||
any { $from_to->{abbr} eq $_ } @_;
|
||||
};
|
||||
| b14755d0 | Bernd Bleßmann | my ($item_parent_id_column, $item_parent_column);
|
||
if (ref($source) eq 'SL::DB::Order') {
|
||||
$item_parent_id_column = 'trans_id';
|
||||
$item_parent_column = 'order';
|
||||
| eff10782 | Tamino Steinert | } elsif ( ref($source) eq 'SL::DB::Reclamation') {
|
||
$item_parent_id_column = 'reclamation_id';
|
||||
$item_parent_column = 'reclamation';
|
||||
| b14755d0 | Bernd Bleßmann | }
|
||
| eff10782 | Tamino Steinert | my %args;
|
||
if (ref($source) eq 'SL::DB::Order') {
|
||||
%args = ( map({ ( $_ => $source->$_ ) } qw(amount cp_id currency_id cusordnumber customer_id delivery_customer_id delivery_term_id delivery_vendor_id
|
||||
department_id exchangerate globalproject_id intnotes marge_percent marge_total language_id netamount notes
|
||||
ordnumber payment_id quonumber reqdate salesman_id shippingpoint shipvia taxincluded tax_point taxzone_id
|
||||
transaction_description vendor_id billing_address_id
|
||||
)),
|
||||
quotation => !!($destination_type =~ m{quotation$}),
|
||||
| ee6fe6b9 | Bernd Bleßmann | intake => !!($destination_type =~ m{intake$}),
|
||
| eff10782 | Tamino Steinert | closed => 0,
|
||
delivered => 0,
|
||||
transdate => DateTime->today_local,
|
||||
employee => SL::DB::Manager::Employee->current,
|
||||
);
|
||||
# reqdate in quotation is 'offer is valid until reqdate'
|
||||
# reqdate in order is 'will be delivered until reqdate'
|
||||
# both dates are setable (on|off)
|
||||
# and may have a additional interval in days (+ n days)
|
||||
# dies if this convention will change
|
||||
$args{reqdate} = $from_to->{to} =~ m/_quotation$/
|
||||
? $::instance_conf->get_reqdate_on
|
||||
? DateTime->today_local->next_workday(extra_days => $::instance_conf->get_reqdate_interval)->to_kivitendo
|
||||
: undef
|
||||
: $from_to->{to} =~ m/_order$/
|
||||
? $::instance_conf->get_deliverydate_on
|
||||
? DateTime->today_local->next_workday(extra_days => $::instance_conf->get_delivery_date_interval)->to_kivitendo
|
||||
: undef
|
||||
| 73192307 | Jan Büren | : $from_to->{to} =~ m/^sales_order_intake$/
|
||
# ? $source->reqdate
|
||||
? undef
|
||||
| eff10782 | Tamino Steinert | : die "Wrong state for reqdate";
|
||
} elsif ( ref($source) eq 'SL::DB::Reclamation') {
|
||||
%args = ( map({ ( $_ => $source->$_ ) } qw(
|
||||
| dc28e1c2 | Tamino Steinert | amount billing_address_id currency_id customer_id delivery_term_id department_id
|
||
| eff10782 | Tamino Steinert | exchangerate globalproject_id intnotes language_id netamount
|
||
notes payment_id reqdate salesman_id shippingpoint shipvia taxincluded
|
||||
tax_point taxzone_id transaction_description vendor_id
|
||||
)),
|
||||
cp_id => $source->{contact_id},
|
||||
closed => 0,
|
||||
delivered => 0,
|
||||
transdate => DateTime->today_local,
|
||||
employee => SL::DB::Manager::Employee->current,
|
||||
);
|
||||
}
|
||||
| b14755d0 | Bernd Bleßmann | |||
| ee6fe6b9 | Bernd Bleßmann | if ( $is_abbr_any->(qw(soipo sopo poso rqso soisq sosq porq rqsq sqrq soirq sorq)) ) {
|
||
| 69966b4c | Bernd Bleßmann | $args{ordnumber} = undef;
|
||
| 80970e1d | Jan Büren | $args{quonumber} = undef;
|
||
| 69966b4c | Bernd Bleßmann | }
|
||
| ee6fe6b9 | Bernd Bleßmann | if ( $is_abbr_any->(qw(soipo sopo sqrq soirq sorq)) ) {
|
||
| 69966b4c | Bernd Bleßmann | $args{customer_id} = undef;
|
||
$args{salesman_id} = undef;
|
||||
$args{payment_id} = undef;
|
||||
$args{delivery_term_id} = undef;
|
||||
}
|
||||
| e73be2a8 | Bernd Bleßmann | if ( $is_abbr_any->(qw(poso rqsq)) ) {
|
||
| 69966b4c | Bernd Bleßmann | $args{vendor_id} = undef;
|
||
}
|
||||
| f1d33e8c | Bernd Bleßmann | if ( $is_abbr_any->(qw(soso)) ) {
|
||
$args{periodic_invoices_config} = $source->periodic_invoices_config->clone_and_reset if $source->periodic_invoices_config;
|
||||
}
|
||||
| ee6fe6b9 | Bernd Bleßmann | if ( $is_abbr_any->(qw(sqrq soirq sorq)) ) {
|
||
| cc5d0de1 | Bernd Bleßmann | $args{cusordnumber} = undef;
|
||
}
|
||||
| ee6fe6b9 | Bernd Bleßmann | if ( $is_abbr_any->(qw(soiso)) ) {
|
||
$args{ordnumber} = undef;
|
||||
}
|
||||
| 69966b4c | Bernd Bleßmann | |||
| b14755d0 | Bernd Bleßmann | # Custom shipto addresses (the ones specific to the sales/purchase
|
||
# record and not to the customer/vendor) are only linked from
|
||||
| 951ebae4 | Bernd Bleßmann | # shipto → order. Meaning order.shipto_id
|
||
| b14755d0 | Bernd Bleßmann | # will not be filled in that case.
|
||
if (!$source->shipto_id && $source->id) {
|
||||
$args{custom_shipto} = $source->custom_shipto->clone($class) if $source->can('custom_shipto') && $source->custom_shipto;
|
||||
} else {
|
||||
$args{shipto_id} = $source->shipto_id;
|
||||
}
|
||||
my $order = $class->new(%args);
|
||||
$order->assign_attributes(%{ $params{attributes} }) if $params{attributes};
|
||||
my $items = delete($params{items}) || $source->items_sorted;
|
||||
| 842d6c44 | Bernd Bleßmann | |||
| b14755d0 | Bernd Bleßmann | my %item_parents;
|
||
my @items = map {
|
||||
my $source_item = $_;
|
||||
my $source_item_id = $_->$item_parent_id_column;
|
||||
my @custom_variables = map { _clone_orderitem_cvar($_) } @{ $source_item->custom_variables };
|
||||
$item_parents{$source_item_id} ||= $source_item->$item_parent_column;
|
||||
my $item_parent = $item_parents{$source_item_id};
|
||||
| eff10782 | Tamino Steinert | my $current_oe_item;
|
||
if (ref($source) eq 'SL::DB::Order') {
|
||||
$current_oe_item = SL::DB::OrderItem->new(map({ ( $_ => $source_item->$_ ) }
|
||||
qw(active_discount_source active_price_source base_qty cusordnumber
|
||||
description discount lastcost longdescription
|
||||
marge_percent marge_price_factor marge_total
|
||||
ordnumber parts_id price_factor price_factor_id pricegroup_id
|
||||
project_id qty reqdate sellprice serialnumber ship subtotal transdate unit
|
||||
| 0fe9fafd | Moritz Bunkus | optional recurring_billing_mode
|
||
| eff10782 | Tamino Steinert | )),
|
||
custom_variables => \@custom_variables,
|
||||
);
|
||||
} elsif (ref($source) eq 'SL::DB::Reclamation') {
|
||||
$current_oe_item = SL::DB::OrderItem->new(
|
||||
map({ ( $_ => $source_item->$_ ) } qw(
|
||||
active_discount_source active_price_source base_qty description
|
||||
discount lastcost longdescription parts_id price_factor
|
||||
price_factor_id pricegroup_id project_id qty reqdate sellprice
|
||||
serialnumber unit
|
||||
)),
|
||||
custom_variables => \@custom_variables,
|
||||
);
|
||||
}
|
||||
| ee6fe6b9 | Bernd Bleßmann | if ( $is_abbr_any->(qw(soipo sopo)) ) {
|
||
| 69966b4c | Bernd Bleßmann | $current_oe_item->sellprice($source_item->lastcost);
|
||
$current_oe_item->discount(0);
|
||||
}
|
||||
| 6583ead0 | Bernd Bleßmann | if ( $is_abbr_any->(qw(poso rqsq rqso)) ) {
|
||
| 69966b4c | Bernd Bleßmann | $current_oe_item->lastcost($source_item->sellprice);
|
||
}
|
||||
| b14755d0 | Bernd Bleßmann | $current_oe_item->{"converted_from_orderitems_id"} = $_->{id} if ref($item_parent) eq 'SL::DB::Order';
|
||
| eff10782 | Tamino Steinert | $current_oe_item->{"converted_from_reclamation_item_id"} = $_->{id} if ref($item_parent) eq 'SL::DB::Reclamation';
|
||
| b14755d0 | Bernd Bleßmann | $current_oe_item;
|
||
} @{ $items };
|
||||
@items = grep { $params{item_filter}->($_) } @items if $params{item_filter};
|
||||
@items = grep { $_->qty * 1 } @items if $params{skip_items_zero_qty};
|
||||
@items = grep { $_->qty >=0 } @items if $params{skip_items_negative_qty};
|
||||
$order->items(\@items);
|
||||
return $order;
|
||||
}
|
||||
| 842d6c44 | Bernd Bleßmann | sub new_from_multi {
|
||
my ($class, $sources, %params) = @_;
|
||||
croak("Unsupported object type in sources") if any { ref($_) !~ m{SL::DB::Order} } @$sources;
|
||||
croak("Cannot create order for purchase records") if any { !$_->is_sales } @$sources;
|
||||
croak("Cannot create order from source records of different customers") if any { $_->customer_id != $sources->[0]->customer_id } @$sources;
|
||||
# bb: todo: check shipto: is it enough to check the ids or do we have to compare the entries?
|
||||
if (delete $params{check_same_shipto}) {
|
||||
die "check same shipto address is not implemented yet";
|
||||
die "Source records do not have the same shipto" if 1;
|
||||
}
|
||||
# sort sources
|
||||
if (defined $params{sort_sources_by}) {
|
||||
my $sort_by = delete $params{sort_sources_by};
|
||||
if ($sources->[0]->can($sort_by)) {
|
||||
$sources = [ sort { $a->$sort_by cmp $b->$sort_by } @$sources ];
|
||||
} else {
|
||||
die "Cannot sort source records by $sort_by";
|
||||
}
|
||||
}
|
||||
# set this entries to undef that yield different information
|
||||
my %attributes;
|
||||
| 9c463903 | Bernd Bleßmann | foreach my $attr (qw(ordnumber transdate reqdate tax_point taxincluded shippingpoint
|
||
| 842d6c44 | Bernd Bleßmann | shipvia notes closed delivered reqdate quonumber
|
||
cusordnumber proforma transaction_description
|
||||
order_probability expected_billing_date)) {
|
||||
$attributes{$attr} = undef if any { ($sources->[0]->$attr//'') ne ($_->$attr//'') } @$sources;
|
||||
}
|
||||
| 5c8a0b36 | Bernd Bleßmann | foreach my $attr (qw(cp_id currency_id salesman_id department_id
|
||
| 842d6c44 | Bernd Bleßmann | delivery_customer_id delivery_vendor_id shipto_id
|
||
| 598383b3 | Bernd Bleßmann | globalproject_id exchangerate)) {
|
||
| 842d6c44 | Bernd Bleßmann | $attributes{$attr} = undef if any { ($sources->[0]->$attr||0) != ($_->$attr||0) } @$sources;
|
||
}
|
||||
# set this entries from customer that yield different information
|
||||
foreach my $attr (qw(language_id taxzone_id payment_id delivery_term_id)) {
|
||||
$attributes{$attr} = $sources->[0]->customervendor->$attr if any { ($sources->[0]->$attr||0) != ($_->$attr||0) } @$sources;
|
||||
}
|
||||
$attributes{intnotes} = $sources->[0]->customervendor->notes if any { ($sources->[0]->intnotes//'') ne ($_->intnotes//'') } @$sources;
|
||||
# no periodic invoice config for new order
|
||||
$attributes{periodic_invoices_config} = undef;
|
||||
| 5c8a0b36 | Bernd Bleßmann | # set emplyee to the current one
|
||
$attributes{employee} = SL::DB::Manager::Employee->current;
|
||||
| 842d6c44 | Bernd Bleßmann | # copy global ordnumber, transdate, cusordnumber into item scope
|
||
# unless already present there
|
||||
foreach my $attr (qw(ordnumber transdate cusordnumber)) {
|
||||
foreach my $src (@$sources) {
|
||||
foreach my $item (@{ $src->items_sorted }) {
|
||||
$item->$attr($src->$attr) if !$item->$attr;
|
||||
}
|
||||
}
|
||||
}
|
||||
# collect items
|
||||
my @items;
|
||||
push @items, @{$_->items_sorted} for @$sources;
|
||||
# make order from first source and all items
|
||||
my $order = $class->new_from($sources->[0],
|
||||
destination_type => 'sales_order',
|
||||
attributes => \%attributes,
|
||||
items => \@items,
|
||||
%params);
|
||||
return $order;
|
||||
}
|
||||
| 3a4ddae0 | Sven Schöling | sub number {
|
||
my $self = shift;
|
||||
| 052a7bb6 | Bernd Bleßmann | return if !$self->type;
|
||
| 3a4ddae0 | Sven Schöling | my %number_method = (
|
||
| ee6fe6b9 | Bernd Bleßmann | sales_order_intake => 'ordnumber',
|
||
sales_order => 'ordnumber',
|
||||
sales_quotation => 'quonumber',
|
||||
purchase_order => 'ordnumber',
|
||||
request_quotation => 'quonumber',
|
||||
| 3a4ddae0 | Sven Schöling | );
|
||
return $self->${ \ $number_method{$self->type} }(@_);
|
||||
}
|
||||
| 9589ecd7 | Sven Schöling | sub customervendor {
|
||
$_[0]->is_sales ? $_[0]->customer : $_[0]->vendor;
|
||||
}
|
||||
| 16c6be41 | Moritz Bunkus | sub date {
|
||
goto &transdate;
|
||||
}
|
||||
| 23c5a950 | Sven Schöling | sub digest {
|
||
my ($self) = @_;
|
||||
sprintf "%s %s %s (%s)",
|
||||
$self->number,
|
||||
$self->customervendor->name,
|
||||
$self->amount_as_number,
|
||||
$self->date->to_kivitendo;
|
||||
}
|
||||
| 70ae535d | Jan Büren | sub current_version_number {
|
||
my ($self) = @_;
|
||||
my $query = <<EOSQL;
|
||||
SELECT max(version)
|
||||
FROM oe_version
|
||||
WHERE (oe_id = ?)
|
||||
EOSQL
|
||||
my ($current_version_number) = SL::DBUtils::selectfirst_array_query($::form, $self->db->dbh, $query, ($self->id));
|
||||
die "Invalid State. No version linked" unless $current_version_number;
|
||||
return $current_version_number;
|
||||
}
|
||||
sub is_final_version {
|
||||
my ($self) = @_;
|
||||
| 4a5f2dea | Bernd Bleßmann | my $order_versions_count = SL::DB::Manager::OrderVersion->get_all_count(where => [ oe_id => $self->id, final_version => 0 ]);
|
||
die "Invalid version state" unless $order_versions_count < 2;
|
||||
my $final_version = $order_versions_count == 1 ? 0 : 1;
|
||||
| 70ae535d | Jan Büren | |||
return $final_version;
|
||||
}
|
||||
| 5a6d7c03 | Geoffrey Richardson | sub netamount_base_currency {
|
||
my ($self) = @_;
|
||||
return $self->netamount unless $self->forex;
|
||||
if ( defined $self->exchangerate ) {
|
||||
return $self->netamount * $self->exchangerate;
|
||||
} else {
|
||||
return $self->netamount * $self->daily_exchangerate;
|
||||
}
|
||||
}
|
||||
| 82515b2d | Sven Schöling | 1;
|
||
__END__
|
||||
| 5af4094b | Moritz Bunkus | =pod
|
||
=encoding utf8
|
||||
| 82515b2d | Sven Schöling | =head1 NAME
|
||
SL::DB::Order - Order Datenbank Objekt.
|
||||
=head1 FUNCTIONS
|
||||
| d80ffb81 | Sven Schöling | =head2 C<type>
|
||
| 82515b2d | Sven Schöling | |||
Returns one of the following string types:
|
||||
=over 4
|
||||
| d80ffb81 | Sven Schöling | =item sales_order
|
||
| 82515b2d | Sven Schöling | |||
=item purchase_order
|
||||
=item sales_quotation
|
||||
=item request_quotation
|
||||
=back
|
||||
| d80ffb81 | Sven Schöling | =head2 C<is_type TYPE>
|
||
| 82515b2d | Sven Schöling | |||
| d80ffb81 | Sven Schöling | Returns true if the order is of the given type.
|
||
| 82515b2d | Sven Schöling | |||
| b1817cb6 | Bernd Bleßmann | =head2 C<daily_exchangerate $val>
|
||
Gets or sets the exchangerate object's value. This is the value from the
|
||||
table C<exchangerate> depending on the order's currency, the transdate and
|
||||
if it is a sales or purchase order.
|
||||
The order object (respectively the table C<oe>) has an own column
|
||||
C<exchangerate> which can be get or set with the accessor C<exchangerate>.
|
||||
The idea is to drop the legacy table C<exchangerate> in the future and to
|
||||
give all relevant tables it's own C<exchangerate> column.
|
||||
So, this method is here if you need to access the "legacy" exchangerate via
|
||||
an order object.
|
||||
=over 4
|
||||
=item C<$val>
|
||||
(optional) If given, the exchangerate in the "legacy" table is set to this
|
||||
value, depending on currency, transdate and sales or purchase.
|
||||
=back
|
||||
| 7664f50f | Moritz Bunkus | =head2 C<convert_to_delivery_order %params>
|
||
Creates a new delivery order with C<$self> as the basis by calling
|
||||
L<SL::DB::DeliveryOrder::new_from>. That delivery order is saved, and
|
||||
| 1c9c1ad9 | Moritz Bunkus | C<$self> is linked to the new invoice via
|
||
L<SL::DB::RecordLink>. C<$self>'s C<delivered> attribute is set to
|
||||
C<true>, and C<$self> is saved.
|
||||
| 7664f50f | Moritz Bunkus | |||
The arguments in C<%params> are passed to
|
||||
L<SL::DB::DeliveryOrder::new_from>.
|
||||
| 492c85c2 | Moritz Bunkus | Returns C<undef> on failure. Otherwise the new delivery order will be
|
||
returned.
|
||||
| 7664f50f | Moritz Bunkus | |||
| d80ffb81 | Sven Schöling | =head2 C<convert_to_invoice %params>
|
||
| 62bb3c51 | Moritz Bunkus | |||
Creates a new invoice with C<$self> as the basis by calling
|
||||
L<SL::DB::Invoice::new_from>. That invoice is posted, and C<$self> is
|
||||
linked to the new invoice via L<SL::DB::RecordLink>. C<$self>'s
|
||||
C<closed> attribute is set to C<true>, and C<$self> is saved.
|
||||
| a4624332 | Bernd Bleßmann | The arguments in C<%params> are passed to L<SL::DB::Invoice::new_from>.
|
||
| 62bb3c51 | Moritz Bunkus | |||
| 78600d89 | Moritz Bunkus | Returns the new invoice instance on success and C<undef> on
|
||
failure. The whole process is run inside a transaction. On failure
|
||||
nothing is created or changed in the database.
|
||||
| 62bb3c51 | Moritz Bunkus | |||
At the moment only sales quotations and sales orders can be converted.
|
||||
| b14755d0 | Bernd Bleßmann | =head2 C<new_from $source, %params>
|
||
Creates a new C<SL::DB::Order> instance and copies as much
|
||||
| 951ebae4 | Bernd Bleßmann | information from C<$source> as possible. At the moment only records with the
|
||
same destination type as the source type and sales orders from
|
||||
| b14755d0 | Bernd Bleßmann | sales quotations and purchase orders from requests for quotations can be
|
||
created.
|
||||
The C<transdate> field will be set to the current date.
|
||||
The conversion copies the order items as well.
|
||||
Returns the new order instance. The object returned is not
|
||||
saved.
|
||||
C<%params> can include the following options
|
||||
(C<destination_type> is mandatory):
|
||||
=over 4
|
||||
=item C<destination_type>
|
||||
(mandatory)
|
||||
| 951ebae4 | Bernd Bleßmann | The type of the newly created object. Can be C<sales_quotation>,
|
||
C<sales_order>, C<purchase_quotation> or C<purchase_order> for now.
|
||||
| b14755d0 | Bernd Bleßmann | |||
=item C<items>
|
||||
An optional array reference of RDBO instances for the items to use. If
|
||||
missing then the method C<items_sorted> will be called on
|
||||
C<$source>. This option can be used to override the sorting, to
|
||||
exclude certain positions or to add additional ones.
|
||||
=item C<skip_items_negative_qty>
|
||||
If trueish then items with a negative quantity are skipped. Items with
|
||||
a quantity of 0 are not affected by this option.
|
||||
=item C<skip_items_zero_qty>
|
||||
If trueish then items with a quantity of 0 are skipped.
|
||||
=item C<item_filter>
|
||||
An optional code reference that is called for each item with the item
|
||||
as its sole parameter. Items for which the code reference returns a
|
||||
falsish value will be skipped.
|
||||
=item C<attributes>
|
||||
An optional hash reference. If it exists then it is passed to C<new>
|
||||
allowing the caller to set certain attributes for the new delivery
|
||||
order.
|
||||
=back
|
||||
| 842d6c44 | Bernd Bleßmann | =head2 C<new_from_multi $sources, %params>
|
||
Creates a new C<SL::DB::Order> instance from multiple sources and copies as
|
||||
much information from C<$sources> as possible.
|
||||
At the moment only sales orders can be combined and they must be of the same
|
||||
customer.
|
||||
The new order is created from the first one using C<new_from> and the positions
|
||||
of all orders are added to the new order. The orders can be sorted with the
|
||||
parameter C<sort_sources_by>.
|
||||
The orders attributes are kept if they contain the same information for all
|
||||
source orders an will be set to empty if they contain different information.
|
||||
Returns the new order instance. The object returned is not
|
||||
saved.
|
||||
C<params> other then C<sort_sources_by> are passed to C<new_from>.
|
||||
| 82515b2d | Sven Schöling | =head1 BUGS
|
||
Nothing here yet.
|
||||
=head1 AUTHOR
|
||||
| 05c6840d | Moritz Bunkus | Sven Schöling <s.schoeling@linet-services.de>
|
||
| 82515b2d | Sven Schöling | |||
=cut
|