X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FController%2FCsvImport%2FCustomerVendor.pm;h=41234bfee199c29ff2ea22b3e9f886be46294090;hb=ccacef74f97842c0297a735fe7d81987adb5e6d6;hp=e8cfc367d985643e005ef09b2555159c3fee435c;hpb=220ccac9cc13afd496050420c635c50d4a65c2c5;p=kivitendo-erp.git diff --git a/SL/Controller/CsvImport/CustomerVendor.pm b/SL/Controller/CsvImport/CustomerVendor.pm index e8cfc367d..41234bfee 100644 --- a/SL/Controller/CsvImport/CustomerVendor.pm +++ b/SL/Controller/CsvImport/CustomerVendor.pm @@ -7,6 +7,7 @@ use SL::DB::Business; use SL::DB::CustomVariable; use SL::DB::CustomVariableConfig; use SL::DB::PaymentTerm; +use SL::TransNumber; use parent qw(SL::Controller::CsvImport::Base); @@ -52,12 +53,14 @@ sub check_objects { foreach my $entry (@{ $self->controller->data }) { my $object = $entry->{object}; - next unless $self->check_name($entry); - next unless $self->check_language($entry); - next unless $self->check_business($entry); - next unless $self->check_payment($entry); + $self->check_name($entry); + $self->check_language($entry); + $self->check_business($entry); + $self->check_payment($entry); $self->handle_cvars($entry); + next if @{ $entry->{errors} }; + if ($vcs_by_number{ $object->$numbercolumn }) { $entry->{object}->$numbercolumn('####'); } else { @@ -69,27 +72,18 @@ sub check_objects { $self->add_cvar_raw_data_columns; } -sub check_duplicates { - my ($self, %params) = @_; - - my $normalizer = sub { my $name = $_[0]; $name =~ s/[\s,\.\-]//g; return $name; }; - - my %by_name; - if ('check_db' eq $self->controller->profile->get('duplicates')) { - %by_name = map { ( $normalizer->($_->name) => 'db' ) } @{ $self->existing_objects }; - } - - foreach my $entry (@{ $self->controller->data }) { - next if @{ $entry->{errors} }; - - my $name = $normalizer->($entry->{object}->name); - if (!$by_name{$name}) { - $by_name{$name} = 'csv'; - - } else { - push @{ $entry->{errors} }, $by_name{$name} eq 'db' ? $::locale->text('Duplicate in database') : $::locale->text('Duplicate in CSV file'); - } - } +sub get_duplicate_check_fields { + return { + name => { + label => $::locale->text('Customer Name'), + default => 1, + maker => sub { + my $name = shift->name; + $name =~ s/[\s,\.\-]//g; + return $name; + } + }, + }; } sub check_name { @@ -165,7 +159,18 @@ sub save_objects { my $with_number = [ grep { $_->{object}->$numbercolumn ne '####' } @{ $self->controller->data } ]; my $without_number = [ grep { $_->{object}->$numbercolumn eq '####' } @{ $self->controller->data } ]; - map { $_->{object}->$numbercolumn('') } @{ $without_number }; + foreach my $entry (@{$with_number}, @{$without_number}) { + my $object = $entry->{object}; + + my $number = SL::TransNumber->new(type => $self->table(), + number => $object->$numbercolumn(), + business_id => $object->business_id(), + save => 1); + + if ( $object->$numbercolumn eq '####' || !$number->is_unique() ) { + $object->$numbercolumn($number->create_unique()); + } + } $self->SUPER::save_objects(data => $with_number); $self->SUPER::save_objects(data => $without_number); @@ -180,7 +185,6 @@ sub field_lengths { city => 75, country => 75, contact => 75, - phone => 30, fax => 30, account_number => 15, bank_code => 10, @@ -239,7 +243,6 @@ sub setup_displayable_columns { { name => 'payment_id', description => $::locale->text('Payment terms (database ID)') }, { name => 'payment', description => $::locale->text('Payment terms (name)') }, { name => 'phone', description => $::locale->text('Phone') }, - { name => 'pricing_agreement', description => $::locale->text('Pricing agreement') }, { name => 'street', description => $::locale->text('Street') }, { name => 'taxnumber', description => $::locale->text('Tax Number / SSN') }, { name => 'taxzone_id', description => $::locale->text('Steuersatz') }, @@ -251,6 +254,6 @@ sub setup_displayable_columns { } # TODO: -# salesman_id -- Kunden mit Typ 'Verkäufer', falls $::vertreter an ist, ansonsten Employees +# salesman_id -- Kunden mit Typ 'Verkäufer', falls Vertreter-Modus an ist, ansonsten Employees -1; +1; \ No newline at end of file