X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FController%2FRequirementSpecOrder.pm;h=398c86a47ed23faeb0279526a73cbc6763eee2a8;hb=7718459cd0be728a57d7ca75dd8077316df7d730;hp=696b862b4ad1a417326f67e7675e5d195e4824d3;hpb=c1f5a8f3f28952c290edb35ee3c0a37f5621ef69;p=kivitendo-erp.git diff --git a/SL/Controller/RequirementSpecOrder.pm b/SL/Controller/RequirementSpecOrder.pm index 696b862b4..398c86a47 100644 --- a/SL/Controller/RequirementSpecOrder.pm +++ b/SL/Controller/RequirementSpecOrder.pm @@ -5,17 +5,24 @@ use utf8; use parent qw(SL::Controller::Base); -use SL::ClientJS; +use List::MoreUtils qw(uniq); +use List::Util qw(first); + use SL::DB::Customer; +use SL::DB::Order; use SL::DB::Part; use SL::DB::RequirementSpec; use SL::DB::RequirementSpecOrder; use SL::Helper::Flash; use SL::Locale::String; +use constant LIST_SELECTOR => '#quotations_and_orders'; +use constant FORMS_SELECTOR => '#quotations_and_orders_article_assignment,#quotations_and_orders_new,#quotations_and_orders_update'; + use Rose::Object::MakeMethods::Generic ( - 'scalar --get_set_init' => [ qw(requirement_spec js all_customers all_parts) ], + scalar => [ qw(parts) ], + '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'); @@ -24,7 +31,6 @@ __PACKAGE__->run_before('setup'); # actions # - sub action_list { my ($self) = @_; @@ -34,17 +40,123 @@ sub action_list { sub action_new { my ($self) = @_; - my $html = $self->render('requirement_spec_order/new', { output => 0 }, make_part_title => sub { $_[0]->partnumber . ' ' . $_[0]->description }); - $self->js->html('#ui-tabs-4', $html) - ->render($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; + } + + 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; +} + +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_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, additional_parts => $self->requirement_spec->parts_sorted); + $order->db->with_transaction(sub { + $order->save; + + $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); + }) or do { + $::lxdebug->message(LXDebug::WARN(), "Error creating the order object: $@"); + }; + + $self->init_requirement_spec; + + # 3. Notify the user and return to list. + my $html = $self->render('requirement_spec_order/list', { output => 0 }); + $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; +} + +sub action_update { + my ($self) = @_; + + 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 }; + + $sections_seen{ $section->id } = 1 if $section; + + push @orderitems, { item => $item, section => $section }; + } + + my $html = $self->render( + 'requirement_spec_order/update', { output => 0 }, + orderitems => \@orderitems, + sections => $sections, + make_section_title => sub { $_[0]->fb_number . ' ' . $_[0]->title }, + ); + + $self->js->hide(LIST_SELECTOR()) + ->after(LIST_SELECTOR(), $html) + ->render; +} + +sub action_do_update { + my ($self) = @_; + + my $order = $self->rs_order->order; + my @new_orderitems = $self->do_update_sections; + push @new_orderitems, $self->do_update_additional_parts; + + $order->add_orderitems(\@new_orderitems) if @new_orderitems; + + $order->calculate_prices_and_taxes; + + $order->db->with_transaction(sub { + $order->save; + $self->requirement_spec->link_to_record($order); + }) or do { + $::lxdebug->message(LXDebug::WARN(), "Error updating the order object: $@"); + }; + + $self->init_requirement_spec; + + my $html = $self->render('requirement_spec_order/list', { output => 0 }); + $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; } 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; + } + my $html = $self->render('requirement_spec_order/edit_assignment', { output => 0 }, make_part_title => sub { $_[0]->partnumber . ' ' . $_[0]->description }); - $self->js->html('#ui-tabs-4', $html) - ->render($self); + $self->js->hide(LIST_SELECTOR()) + ->after(LIST_SELECTOR(), $html) + ->reinit_widgets + ->render; } sub action_save_assignment { @@ -53,16 +165,23 @@ sub action_save_assignment { SL::DB::RequirementSpecItem->new(id => $_->{id})->load->update_attributes(order_part_id => ($_->{order_part_id} || undef)) for @{ $sections }; my $html = $self->render('requirement_spec_order/list', { output => 0 }); - $self->js->html('#ui-tabs-4', $html) - ->render($self); + $self->js->replaceWith(LIST_SELECTOR(), $html) + ->remove(FORMS_SELECTOR()) + ->render; } -sub action_cancel { +sub action_delete { my ($self) = @_; + my $order = $self->rs_order->order; + + $order->delete; + $self->init_requirement_spec; + my $html = $self->render('requirement_spec_order/list', { output => 0 }); - $self->js->html('#ui-tabs-4', $html) - ->render($self); + $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; } # @@ -72,9 +191,9 @@ sub action_cancel { sub setup { my ($self) = @_; - $::auth->assert('sales_quotation_edit'); + $::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); + $::request->{layout}->use_javascript("${_}.js") for qw(jquery.jstree jquery/jquery.contextMenu client_js requirement_spec); return 1; } @@ -84,16 +203,192 @@ sub init_requirement_spec { $self->requirement_spec(SL::DB::RequirementSpec->new(id => $::form->{requirement_spec_id})->load) if $::form->{requirement_spec_id}; } -sub init_js { +sub init_all_customers { SL::DB::Manager::Customer->get_all_sorted } +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) = @_; - $self->js(SL::ClientJS->new); + + return [] unless $self->h_unit_name; + + 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 init_all_customers { SL::DB::Manager::Customer->get_all_sorted } -sub init_all_parts { SL::DB::Manager::Part->get_all_sorted } +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 ($self, %params) = @_; + + 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; + + if (!$section->{keep_description}) { + $description = '<%fb_number%> <%title%>' unless $description =~ m{<%}; + $longdescription = '<%description%>' unless $longdescription =~ m{<%}; + + $description =~ s{<% (.+?) %>}{ $section->can($1) ? $section->$1 : '<' . t8('Invalid variable #1', $1) . '>' }egx; + $longdescription =~ s{\<\% description \%\>}{!!!!DESCRIPTION!!!!}gx; + $longdescription =~ s{<[pP]> !!!!DESCRIPTION!!!! }{!!!!DESCRIPTION!!!!}gx; + $longdescription =~ s{\<\% (.+?) \%\>}{ $section->can($1) ? $::locale->quote_special_chars('HTML', $section->$1 // '') : '<' . t8('Invalid variable #1', $1) . '>' }egx; + $longdescription =~ s{!!!!DESCRIPTION!!!!}{ $section->description // '' }egx; + } + + $item->assign_attributes( + parts_id => $part->id, + description => $description, + longdescription => $longdescription, + 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, + ); + + return $item; +} + +sub create_order { + my ($self, %params) = @_; + + 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 @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 => $reqdate, + quotation => !!$::form->{quotation}, + orderitems => [ @orderitems, @add_items ], + customer_id => $customer->id, + taxincluded => $customer->taxincluded, + intnotes => $customer->notes, + language_id => $customer->language_id, + payment_id => $customer->payment_id, + taxzone_id => $customer->taxzone_id, + employee_id => $employee->id, + salesman_id => $employee->id, + transaction_description => $self->requirement_spec->displayable_name, + currency_id => $::instance_conf->get_currency_id, + ); + + $order->calculate_prices_and_taxes; + + return $order; +} 1;