use List::MoreUtils qw(uniq);
use List::Util qw(first);
-use SL::ClientJS;
use SL::DB::Customer;
use SL::DB::Order;
use SL::DB::Part;
use Rose::Object::MakeMethods::Generic
(
scalar => [ qw(parts) ],
- 'scalar --get_set_init' => [ qw(requirement_spec rs_order js h_unit_name all_customers all_parts_time_unit) ],
+ 'scalar --get_set_init' => [ qw(requirement_spec rs_order h_unit_name all_customers all_parts_time_unit section_order_part) ],
);
__PACKAGE__->run_before('setup');
my ($self) = @_;
if (!@{ $self->all_parts_time_unit }) {
- return $self->js->flash('error', t8('This function requires the presence of articles with a time-based unit such as "h" or "min".'))->render($self);
+ return $self->js->flash('error', t8('This function requires the presence of articles with a time-based unit such as "h" or "min".'))->render;
}
my $html = $self->render('requirement_spec_order/new', { output => 0 }, make_part_title => sub { $_[0]->partnumber . ' ' . $_[0]->description });
$self->js->hide(LIST_SELECTOR())
->after(LIST_SELECTOR(), $html)
- ->render($self);
+ ->render;
}
sub action_create {
my ($self) = @_;
+ if (!$::auth->assert($::form->{quotation} ? 'sales_quotation_edit' : 'sales_order_edit', 1)) {
+ return $self->js->flash('error', t8("You do not have the permissions to access this function."))->render;
+ }
+
# 1. Update sections with selected part IDs.
my $section_attrs = $::form->{sections} || [];
- my $sections = SL::DB::Manager::RequirementSpecItem->get_all(where => [ id => [ map { $_->{id} } @{ $section_attrs } ] ]);
+ my $sections = SL::DB::Manager::RequirementSpecItem->get_all_sorted(where => [ id => [ map { $_->{id} } @{ $section_attrs } ] ]);
my %sections_by_id = map { ($_->{id} => $_) } @{ $sections };
$sections_by_id{ $_->{id} }->update_attributes(order_part_id => $_->{order_part_id}) for @{ $section_attrs };
# 2. Create actual quotation/order.
- my $order = $self->create_order(sections => $sections);
+ my $order = $self->create_order(sections => $sections, additional_parts => $self->requirement_spec->parts_sorted);
$order->db->with_transaction(sub {
$order->save;
- $self->requirement_spec->orders(
- @{ $self->requirement_spec->orders },
- SL::DB::RequirementSpecOrder->new(order => $order, version => $self->requirement_spec->version)
- );
+ $self->requirement_spec->add_orders(SL::DB::RequirementSpecOrder->new(order => $order, version => $self->requirement_spec->version));
$self->requirement_spec->save;
$self->requirement_spec->link_to_record($order);
$self->js->replaceWith(LIST_SELECTOR(), $html)
->remove(FORMS_SELECTOR())
->flash('info', $::form->{quotation} ? t8('Sales quotation #1 has been created.', $order->quonumber) : t8('Sales order #1 has been created.', $order->ordnumber))
- ->render($self);
+ ->render;
}
sub action_update {
my $order = $self->rs_order->order;
my $sections = $self->requirement_spec->sections_sorted;
+ if (!$::auth->assert($order->quotation ? 'sales_quotation_edit' : 'sales_order_edit', 1)) {
+ return $self->js->flash('error', t8("You do not have the permissions to access this function."))->render;
+ }
+
my (@orderitems, %sections_seen);
foreach my $item (@{ $order->items_sorted }) {
my $section = first { my $num = $_->fb_number; $item->description =~ m{\b\Q${num}\E\b} && !$sections_seen{ $_->id } } @{ $sections };
$self->js->hide(LIST_SELECTOR())
->after(LIST_SELECTOR(), $html)
- ->render($self);
+ ->render;
}
sub action_do_update {
- my ($self) = @_;
-
- my $order = $self->rs_order->order;
- my $sections = $self->requirement_spec->sections_sorted;
- my %orderitems_by_id = map { ($_->id => $_) } @{ $order->orderitems };
- my %sections_by_id = map { ($_->id => $_) } @{ $sections };
- $self->{parts} = { map { ($_->id => $_) } @{ SL::DB::Manager::Part->get_all(where => [ id => [ uniq map { $_->order_part_id } @{ $sections } ] ]) } };
- my $language_id = $self->requirement_spec->customer->language_id;
-
- my %sections_seen;
-
- foreach my $attributes (@{ $::form->{orderitems} || [] }) {
- my $orderitem = $orderitems_by_id{ $attributes->{id} };
- my $section = $sections_by_id{ $attributes->{section_id} };
- next unless $orderitem && $section;
-
- $self->create_order_item(section => $section, item => $orderitem, language_id => $language_id)->save;
- $sections_seen{ $section->id } = 1;
- }
+ my ($self) = @_;
- my @new_orderitems = map { $self->create_order_item(section => $_, language_id => $language_id) }
- grep { !$sections_seen{ $_->id } }
- @{ $sections };
+ my $order = $self->rs_order->order;
+ my @new_orderitems = $self->do_update_sections;
+ push @new_orderitems, $self->do_update_additional_parts;
- $order->orderitems([ @{ $order->orderitems }, @new_orderitems ]) if @new_orderitems;
+ $order->add_orderitems(\@new_orderitems) if @new_orderitems;
$order->calculate_prices_and_taxes;
$self->js->replaceWith(LIST_SELECTOR(), $html)
->remove(FORMS_SELECTOR())
->flash('info', $::form->{quotation} ? t8('Sales quotation #1 has been updated.', $order->quonumber) : t8('Sales order #1 has been updated.', $order->ordnumber))
- ->render($self);
+ ->render;
}
sub action_edit_assignment {
my ($self) = @_;
if (!@{ $self->all_parts_time_unit }) {
- return $self->js->flash('error', t8('This function requires the presence of articles with a time-based unit such as "h" or "min".'))->render($self);
+ return $self->js->flash('error', t8('This function requires the presence of articles with a time-based unit such as "h" or "min".'))->render;
}
my $html = $self->render('requirement_spec_order/edit_assignment', { output => 0 }, make_part_title => sub { $_[0]->partnumber . ' ' . $_[0]->description });
$self->js->hide(LIST_SELECTOR())
->after(LIST_SELECTOR(), $html)
- ->render($self);
+ ->reinit_widgets
+ ->render;
}
sub action_save_assignment {
my $html = $self->render('requirement_spec_order/list', { output => 0 });
$self->js->replaceWith(LIST_SELECTOR(), $html)
->remove(FORMS_SELECTOR())
- ->render($self);
+ ->render;
}
sub action_delete {
my $html = $self->render('requirement_spec_order/list', { output => 0 });
$self->js->replaceWith(LIST_SELECTOR(), $html)
->flash('info', $order->quotation ? t8('Sales quotation #1 has been deleted.', $order->quonumber) : t8('Sales order #1 has been deleted.', $order->ordnumber))
- ->render($self);
+ ->render;
}
#
sub setup {
my ($self) = @_;
- $::auth->assert('sales_quotation_edit');
- $::request->{layout}->use_stylesheet("${_}.css") for qw(jquery.contextMenu requirement_spec autocomplete_part);
+ $::auth->assert('requirement_spec_edit');
+ $::request->{layout}->use_stylesheet("${_}.css") for qw(jquery.contextMenu requirement_spec);
$::request->{layout}->use_javascript("${_}.js") for qw(jquery.jstree jquery/jquery.contextMenu client_js requirement_spec);
return 1;
$self->requirement_spec(SL::DB::RequirementSpec->new(id => $::form->{requirement_spec_id})->load) if $::form->{requirement_spec_id};
}
-sub init_js {
- my ($self) = @_;
- $self->js(SL::ClientJS->new);
-}
-
sub init_all_customers { SL::DB::Manager::Customer->get_all_sorted }
-sub init_h_unit_name { first { SL::DB::Manager::Unit->find_by(name => $_) } qw(Std h Stunde) };
+sub init_h_unit_name { SL::DB::Manager::Unit->find_h_unit->name };
sub init_rs_order { SL::DB::RequirementSpecOrder->new(id => $::form->{rs_order_id})->load };
+sub init_section_order_part { my $id = $::instance_conf->get_requirement_spec_section_order_part_id; return $id ? SL::DB::Part->new(id => $id)->load : undef }
sub init_all_parts_time_unit {
my ($self) = @_;
return [] unless $self->h_unit_name;
- my @convertible_unit_names = map { $_->name } @{ SL::DB::Manager::Unit->find_by(name => $self->h_unit_name)->convertible_units };
+ my @convertible_unit_names = map { $_->name } @{ SL::DB::Manager::Unit->time_based_units };
return SL::DB::Manager::Part->get_all_sorted(where => [ unit => \@convertible_unit_names ]);
}
# helpers
#
-sub load_parts_for_sections {
- my ($self, %params) = @_;
+sub cache_parts {
+ my ($self, @ids) = @_;
+
+ my $parts = !@ids ? [] : SL::DB::Manager::Part->get_all(
+ where => [ id => \@ids ],
+ with_objects => [ qw(unit_obj) ],
+ );
+
+ $self->parts({ map { ($_->id => $_) } @{ $parts } });
+}
+
+sub do_update_sections {
+ my ($self) = @_;
+
+ my $order = $self->rs_order->order;
+ my $sections = $self->requirement_spec->sections_sorted;
+ my %orderitems_by_id = map { ($_->id => $_) } @{ $order->orderitems };
+ my %sections_by_id = map { ($_->id => $_) } @{ $sections };
+ my $language_id = $self->requirement_spec->customer->language_id;
+
+ $self->cache_parts(uniq map { $_->order_part_id } @{ $sections });
+ my %sections_seen;
+
+ foreach my $attributes (@{ $::form->{orderitems} || [] }) {
+ my $orderitem = $orderitems_by_id{ $attributes->{id} };
+ my $section = $sections_by_id{ $attributes->{section_id} };
+ next unless $orderitem && $section;
+
+ $self->create_order_item(section => $section, item => $orderitem, language_id => $language_id)->save;
+ $sections_seen{ $section->id } = 1;
+ }
+
+ my @new_orderitems = map { $self->create_order_item(section => $_, language_id => $language_id) }
+ grep { !$sections_seen{ $_->id } }
+ @{ $sections };
+
+ return @new_orderitems;
+}
+
+sub do_update_additional_parts {
+ my ($self) = @_;
+
+ my $order = $self->rs_order->order;
+ my $add_parts = $self->requirement_spec->parts_sorted;
+ my %orderitems_by = map { (($_->parts_id . '-' . $_->description) => $_) } @{ $order->items };
+ my $language_id = $self->requirement_spec->customer->language_id;
+
+ $self->cache_parts(uniq map { $_->part_id } @{ $add_parts });
+
+ my %add_part_seen;
+ my @new_orderitems;
+
+ foreach my $add_part (@{ $add_parts }) {
+ my $key = $add_part->part_id . '-' . $add_part->description;
+ my $orderitem = $orderitems_by{$key};
+
+ if ($orderitem) {
+ $self->create_additional_part_order_item(additional_part => $add_part, item => $orderitem, language_id => $language_id)->save;
+
+ } else {
+ push @new_orderitems, $self->create_additional_part_order_item(additional_part => $add_part, language_id => $language_id);
+ }
+ }
+
+ return @new_orderitems;
}
sub create_order_item {
my $section = $params{section};
my $item = $params{item} || SL::DB::OrderItem->new;
my $part = $self->parts->{ $section->order_part_id };
+ my $is_time_based = $part->unit_obj->is_time_based;
my $translation = $params{language_id} ? first { $params{language_id} == $_->language_id } @{ $part->translations } : {};
my $description = $section->{keep_description} ? $item->description : ($translation->{translation} || $part->description);
my $longdescription = $translation->{longdescription} || $part->notes;
parts_id => $part->id,
description => $description,
longdescription => $longdescription,
- qty => $section->time_estimation * 1,
- unit => $self->h_unit_name,
- sellprice => $::form->round_amount($self->requirement_spec->hourly_rate, 2),
+ qty => $is_time_based ? $section->time_estimation * 1 : 1,
+ unit => $is_time_based ? $self->h_unit_name : $part->unit,
+ sellprice => $::form->round_amount($self->requirement_spec->hourly_rate * ($is_time_based ? 1 : $section->time_estimation * $section->sellprice_factor), 2),
+ lastcost => $part->lastcost * $section->sellprice_factor,
+ discount => 0,
+ project_id => $self->requirement_spec->project_id,
+ );
+
+ return $item;
+}
+
+sub create_additional_part_order_item {
+ my ($self, %params) = @_;
+
+ my $add_part = $params{additional_part};
+ my $item = $params{item} || SL::DB::OrderItem->new;
+ my $part = $self->parts->{ $add_part->part_id };
+ my $translation = $params{language_id} ? first { $params{language_id} == $_->language_id } @{ $part->translations } : {};
+ my $description = $item->description || $add_part->description;
+ my $longdescription = $translation->{longdescription} || $part->notes;
+
+ $item->assign_attributes(
+ parts_id => $part->id,
+ description => $description,
+ longdescription => $longdescription,
+ qty => $add_part->qty,
+ unit => $add_part->unit->name,
+ sellprice => $add_part->unit->convert_to($part->sellprice, $part->unit_obj),
lastcost => $part->lastcost,
discount => 0,
project_id => $self->requirement_spec->project_id,
sub create_order {
my ($self, %params) = @_;
- $self->{parts} = { map { ($_->{id} => $_) } @{ SL::DB::Manager::Part->get_all(where => [ id => [ uniq map { $_->{order_part_id} } @{ $params{sections} } ] ]) } };
+ my @part_ids = (
+ map({ $_->{order_part_id} } @{ $params{sections} }),
+ map({ $_->part_id } @{ $params{additional_parts} }),
+ );
+ $self->{parts} = { map { ($_->{id} => $_) } @{ SL::DB::Manager::Part->get_all(where => [ id => [ uniq @part_ids ] ]) } };
my $customer = SL::DB::Customer->new(id => $::form->{customer_id})->load;
- my @orderitems = map { $self->create_order_item(section => $_, language_id => $customer->language_id) } @{ $params{sections} };
+ my @orderitems = map { $self->create_order_item( section => $_, language_id => $customer->language_id) } @{ $params{sections} };
+ my @add_items = map { $self->create_additional_part_order_item(additional_part => $_, language_id => $customer->language_id) } @{ $params{additional_parts} };
my $employee = SL::DB::Manager::Employee->current;
+ my $reqdate = !$::form->{quotation} ? undef
+ : $customer->payment_id ? $customer->payment->calc_date
+ : DateTime->today_local->next_workday(extra_days => $::instance_conf->get_reqdate_interval)->to_kivitendo;
my $order = SL::DB::Order->new(
globalproject_id => $self->requirement_spec->project_id,
transdate => DateTime->today_local,
- reqdate => $::form->{quotation} && $customer->payment_id ? $customer->payment->calc_date : undef,
+ reqdate => $reqdate,
quotation => !!$::form->{quotation},
- orderitems => \@orderitems,
+ orderitems => [ @orderitems, @add_items ],
customer_id => $customer->id,
taxincluded => $customer->taxincluded,
intnotes => $customer->notes,