X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FController%2FCsvImport%2FOrder.pm;h=35f4fb40cddea116f8f4ebd23defd737b8e3e5e9;hb=1cbc459da604c31d21593df298a522e6cbe69e2b;hp=4393fd424d72ce8fbcbaad38cdca5c12bc1ed2f7;hpb=f87214b22e4bf7a54f314d8248468529ad7019e0;p=kivitendo-erp.git diff --git a/SL/Controller/CsvImport/Order.pm b/SL/Controller/CsvImport/Order.pm index 4393fd424..35f4fb40c 100644 --- a/SL/Controller/CsvImport/Order.pm +++ b/SL/Controller/CsvImport/Order.pm @@ -26,7 +26,7 @@ use parent qw(SL::Controller::CsvImport::BaseMulti); use Rose::Object::MakeMethods::Generic ( - 'scalar --get_set_init' => [ qw(settings languages_by parts_by contacts_by ct_shiptos_by price_factors_by pricegroups_by units_by) ], + 'scalar --get_set_init' => [ qw(settings languages_by all_parts parts_by part_counts_by contacts_by ct_shiptos_by price_factors_by pricegroups_by units_by) ], ); @@ -194,11 +194,27 @@ sub init_languages_by { return { map { my $col = $_; ( $col => { map { ( $_->$col => $_ ) } @{ $self->all_languages } } ) } qw(id description article_code) }; } +sub init_all_parts { + my ($self) = @_; + + return SL::DB::Manager::Part->get_all; +} + sub init_parts_by { my ($self) = @_; - my $all_parts = SL::DB::Manager::Part->get_all; - return { map { my $col = $_; ( $col => { map { ( $_->$col => $_ ) } @{ $all_parts } } ) } qw(id partnumber ean description) }; + return { map { my $col = $_; ( $col => { map { ( $_->$col => $_ ) } @{ $self->all_parts } } ) } qw(id partnumber ean description) }; +} + +sub init_part_counts_by { + my ($self) = @_; + + my $part_counts_by; + + $part_counts_by->{ean}-> {$_->ean}++ for @{ $self->all_parts }; + $part_counts_by->{description}->{$_->description}++ for @{ $self->all_parts }; + + return $part_counts_by; } sub init_contacts_by { @@ -375,6 +391,7 @@ sub handle_item { $self->handle_unit($entry); $self->handle_sellprice($entry); + $self->handle_discount($entry); # copy from part if not given $object->description($part_obj->description) unless $object->description; @@ -382,7 +399,6 @@ sub handle_item { $object->lastcost($part_obj->lastcost) unless defined $object->lastcost; # set to 0 if not given - $object->discount(0) unless $object->discount; $object->ship(0) unless $object->ship; $self->check_project($entry, global => 0); @@ -432,10 +448,20 @@ sub handle_sellprice { } } +sub handle_discount { + my ($self, $entry) = @_; + + my $object = $entry->{object}; + + $object->discount($object->discount/100.0) if $object->discount; + $object->discount(0) unless $object->discount; +} + sub check_part { my ($self, $entry) = @_; my $object = $entry->{object}; + my $is_ambiguous; # Check whether or not part ID is valid. if ($object->parts_id && !$self->parts_by->{id}->{ $object->parts_id }) { @@ -462,7 +488,11 @@ sub check_part { return 0; } - $object->parts_id($part->id); + if ($self->part_counts_by->{description}->{ $entry->{raw_data}->{description} } > 1) { + $is_ambiguous = 1; + } else { + $object->parts_id($part->id); + } } # Map ean to ID if given. @@ -473,13 +503,21 @@ sub check_part { return 0; } - $object->parts_id($part->id); + if ($self->part_counts_by->{ean}->{ $entry->{raw_data}->{ean} } > 1) { + $is_ambiguous = 1; + } else { + $object->parts_id($part->id); + } } if ($object->parts_id) { $entry->{info_data}->{partnumber} = $self->parts_by->{id}->{ $object->parts_id }->partnumber; } else { - push @{ $entry->{errors} }, $::locale->text('Error: Part not found'); + if ($is_ambiguous) { + push @{ $entry->{errors} }, $::locale->text('Error: Part is ambiguous'); + } else { + push @{ $entry->{errors} }, $::locale->text('Error: Part not found'); + } return 0; }