Projekt

Allgemein

Profil

Herunterladen (32,8 KB) Statistiken
| Zweig: | Markierung: | Revision:
package SL::DB::Order;

use utf8;
use strict;

use Carp;
use DateTime;
use List::Util qw(max);
use List::MoreUtils qw(any);

use SL::DBUtils ();
use SL::DB::PurchaseBasketItem;
use SL::DB::MetaSetup::Order;
use SL::DB::Manager::Order;
use SL::DB::Helper::Attr;
use SL::DB::Helper::AttrHTML;
use SL::DB::Helper::AttrSorted;
use SL::DB::Helper::FlattenToForm;
use SL::DB::Helper::LinkedRecords;
use SL::DB::Helper::PriceTaxCalculator;
use SL::DB::Helper::PriceUpdater;
use SL::DB::Helper::TypeDataProxy;
use SL::DB::Helper::TransNumberGenerator;
use SL::DB::Helper::Payment qw(forex);
use SL::DB::Helper::RecordLink qw(RECORD_ID RECORD_TYPE_REF RECORD_ITEM_ID RECORD_ITEM_TYPE_REF);
use SL::Locale::String qw(t8);
use SL::RecordLinks;
use Rose::DB::Object::Helpers qw(as_tree strip);

use SL::DB::Order::TypeData qw(:types validate_type);
use SL::DB::Reclamation::TypeData qw(:types);

__PACKAGE__->meta->add_relationship(
orderitems => {
type => 'one to many',
class => 'SL::DB::OrderItem',
column_map => { id => 'trans_id' },
manager_args => {
with_objects => [ 'part' ]
}
},
periodic_invoices_config => {
type => 'one to one',
class => 'SL::DB::PeriodicInvoicesConfig',
column_map => { id => 'oe_id' },
},
custom_shipto => {
type => 'one to one',
class => 'SL::DB::Shipto',
column_map => { id => 'trans_id' },
query_args => [ module => 'OE' ],
},
exchangerate_obj => {
type => 'one to one',
class => 'SL::DB::Exchangerate',
column_map => { currency_id => 'currency_id', transdate => 'transdate' },
},
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',
}
},
order_version => {
type => 'one to many',
class => 'SL::DB::OrderVersion',
column_map => { id => 'oe_id' },
},
);

SL::DB::Helper::Attr::make(__PACKAGE__, daily_exchangerate => 'numeric');

__PACKAGE__->meta->initialize;

__PACKAGE__->attr_html('notes');
__PACKAGE__->attr_sorted('items');

__PACKAGE__->before_save('_before_save_set_ord_quo_number');
__PACKAGE__->before_save('_before_save_create_new_project');
__PACKAGE__->before_save('_before_save_remove_empty_custom_shipto');
__PACKAGE__->before_save('_before_save_set_custom_shipto_module');
__PACKAGE__->after_save('_after_save_link_records');
__PACKAGE__->after_save('_after_save_close_reachable_intakes'); # uses linked records (order matters)
__PACKAGE__->before_save('_before_save_delete_from_purchase_basket');

# 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;

$self->create_trans_number if !$self->record_number;

return 1;
}
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_TYPE())) {

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;
}


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;
}

sub _after_save_link_records {
my ($self) = @_;

my @allowed_record_sources = qw(SL::DB::Reclamation SL::DB::Order);
my @allowed_item_sources = qw(SL::DB::ReclamationItem SL::DB::OrderItem);

SL::DB::Helper::RecordLink::link_records(
$self,
\@allowed_record_sources,
\@allowed_item_sources,
);

return 1;
}

sub _after_save_close_reachable_intakes {
my ($self) = @_;

# Close reachable sales order intakes in the from-workflow if this is a sales order
if (SALES_ORDER_TYPE() eq $self->type) {
my $lr = $self->linked_records(direction => 'from', recursive => 1);
$lr = [grep { 'SL::DB::Order' eq ref $_ && !$_->closed && $_->is_type(SALES_ORDER_INTAKE_TYPE()) } @$lr];
if (@$lr) {
SL::DB::Manager::Order->update_all(set => {closed => 1},
where => [id => [map {$_->id} @$lr]]);
}
}

return 1;
}

sub _before_save_delete_from_purchase_basket {
my ($self) = @_;

my @basket_item_ids =
grep { defined($_) && $_ ne ''}
map { $_->{basket_item_id} }
$self->orderitems;
return 1 unless scalar @basket_item_ids;

# check if all items are still in the basket
my $basket_item_count = SL::DB::Manager::PurchaseBasketItem->get_all_count(
where => [ id => \@basket_item_ids ]
);
if ($basket_item_count != scalar @basket_item_ids) {
die "Error while saving order: some items are not in the purchase basket anymore.";
}

if (scalar @basket_item_ids) {
SL::DB::Manager::PurchaseBasketItem->delete_all(
where => [ id => \@basket_item_ids]
);
}

return 1;
}

# methods

sub items { goto &orderitems; }
sub add_items { goto &add_orderitems; }
sub record_number { goto &number; }

sub type {
my $self = shift;
SL::DB::Order::TypeData::validate_type($self->record_type);
return $self->record_type;
}

sub is_type {
return shift->type eq shift;
}

sub quotation {
my $type = $_[0]->type();
any { $type eq $_ } (
SALES_ORDER_INTAKE_TYPE(),
SALES_QUOTATION_TYPE(),
REQUEST_QUOTATION_TYPE(),
PURCHASE_QUOTATION_INTAKE_TYPE(),
);
}

sub intake {
my $type = $_[0]->type();
any { $type eq $_ } (
SALES_ORDER_INTAKE_TYPE(),
PURCHASE_QUOTATION_INTAKE_TYPE(),
);
}

sub deliverydate {
# 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_TYPE();
}

sub effective_tax_point {
my ($self) = @_;

return $self->tax_point || $self->deliverydate || $self->transdate;
}

sub displayable_type {
my ($self) = @_;

return $self->type_data->text('list');
}

sub displayable_name {
join ' ', grep $_, map $_[0]->$_, qw(displayable_type record_number);
};

sub is_sales {
croak 'not an accessor' if @_ > 1;
$_[0]->type_data->properties('is_customer');
}

sub daily_exchangerate {
my ($self, $val) = @_;

return 1 if $self->currency_id == $::instance_conf->get_currency_id;

my $rate = (any { $self->is_type($_) } (SALES_QUOTATION_TYPE(), SALES_ORDER_TYPE())) ? 'buy'
: (any { $self->is_type($_) } (REQUEST_QUOTATION_TYPE(), PURCHASE_ORDER_TYPE())) ? 'sell'
: undef;
return if !$rate;

if (defined $val) {
croak t8('exchange rate has to be positive') if $val <= 0;
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 {
croak t8('exchange rate already exists, no update allowed');
}
}
return $self->exchangerate_obj->$rate if $self->exchangerate_obj;
}

sub invoices {
my $self = shift;
my %params = @_;

if ($self->quotation) {
return [];
} else {
require SL::DB::Invoice;
return SL::DB::Manager::Invoice->get_all(
query => [
ordnumber => $self->ordnumber,
@{ $params{query} || [] },
]
);
}
}

sub displayable_state {
my ($self) = @_;

return $self->closed ? $::locale->text('closed') : $::locale->text('open');
}

sub abschlag_invoices {
return shift()->invoices(query => [ abschlag => 1 ]);
}

sub end_invoice {
return shift()->invoices(query => [ abschlag => 0 ]);
}

sub convert_to_invoice {
my ($self, %params) = @_;

croak("Conversion to invoices is only supported for sales records") unless $self->customer_id;

my $invoice;
if (!$self->db->with_transaction(sub {
require SL::DB::Invoice;
$invoice = SL::DB::Invoice->new_from($self, %params)->post || die;
$self->update_attributes(closed => 1);
1;
})) {
return undef;
}

return $invoice;
}

sub convert_to_delivery_order {
my ($self, @args) = @_;

my $delivery_order;
if (!$self->db->with_transaction(sub {
require SL::DB::DeliveryOrder;
$delivery_order = SL::DB::DeliveryOrder->new_from($self, @args);
$delivery_order->save;

$self->update_attributes(delivered => 1) unless $::instance_conf->get_shipped_qty_require_stock_out;
1;
})) {
return undef;
}

return $delivery_order;
}

sub convert_to_reclamation {
my ($self, %params) = @_;
$params{destination_type} = $self->is_sales ? SALES_RECLAMATION_TYPE()
: PURCHASE_RECLAMATION_TYPE();

require SL::DB::Reclamation;
my $reclamation = SL::DB::Reclamation->new_from($self, %params);

return $reclamation;
}

sub _clone_orderitem_cvar {
my ($cvar) = @_;

my $cloned = $_->clone_and_reset;
$cloned->sub_module('orderitems');

return $cloned;
}

sub create_from_purchase_basket {
my ($class, $basket_item_ids, $vendor_item_ids, $vendor_id) = @_;

my ($vendor, $employee);
$vendor = SL::DB::Manager::Vendor->find_by(id => $vendor_id);
$employee = SL::DB::Manager::Employee->current;

my @orderitem_maps = (); # part, qty, orderer_id
if ($basket_item_ids && scalar @{ $basket_item_ids}) {
my $basket_items = SL::DB::Manager::PurchaseBasketItem->get_all(
query => [ id => $basket_item_ids ],
with_objects => ['part'],
);
push @orderitem_maps, map {{
basket_item_id => $_->id,
part => $_->part,
qty => $_->qty,
orderer_id => $_->orderer_id,
}} @{$basket_items};
}
if ($vendor_item_ids && scalar @{ $vendor_item_ids}) {
my $vendor_items = SL::DB::Manager::Part->get_all(
query => [ id => $vendor_item_ids ] );
push @orderitem_maps, map {{
basket_item_id => undef,
part => $_,
qty => $_->order_qty || 1,
orderer_id => $employee->id,
}} @{$vendor_items};
}

my $order = $class->new(
vendor_id => $vendor->id,
employee_id => $employee->id,
intnotes => $vendor->notes,
salesman_id => $employee->id,
payment_id => $vendor->payment_id,
delivery_term_id => $vendor->delivery_term_id,
taxzone_id => $vendor->taxzone_id,
currency_id => $vendor->currency_id,
transdate => DateTime->today_local,
record_type => PURCHASE_ORDER_TYPE(),
);

my @order_items;
my $i = 0;
foreach my $orderitem_map (@orderitem_maps) {
$i++;
my $part = $orderitem_map->{part};
my $qty = $orderitem_map->{qty};
my $orderer_id = $orderitem_map->{orderer_id};

my $order_item = SL::DB::OrderItem->new(
part => $part,
qty => $qty,
unit => $part->unit,
description => $part->description,
price_factor_id => $part->price_factor_id,
price_factor =>
$part->price_factor_id