X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FController%2FCsvImport%2FContact.pm;h=193f87d8e4f02650819e5e5cf3b2a25d74d5d6ee;hb=7b38e23d6509d1e4520caf77c9698bdb077c215f;hp=e5dadbbebe50d308f9bccc7c3632507ffa49ba8f;hpb=72b340de2352eec7d3f99a00e2141a2df35f07f3;p=kivitendo-erp.git diff --git a/SL/Controller/CsvImport/Contact.pm b/SL/Controller/CsvImport/Contact.pm index e5dadbbeb..193f87d8e 100644 --- a/SL/Controller/CsvImport/Contact.pm +++ b/SL/Controller/CsvImport/Contact.pm @@ -3,6 +3,8 @@ package SL::Controller::CsvImport::Contact; use strict; use SL::Helper::Csv; +use SL::DB::CustomVariable; +use SL::DB::CustomVariableConfig; use parent qw(SL::Controller::CsvImport::Base); @@ -16,16 +18,32 @@ sub init_class { $self->class('SL::DB::Contact'); } +sub init_all_cvar_configs { + my ($self) = @_; + + return SL::DB::Manager::CustomVariableConfig->get_all(where => [ module => 'Contacts' ]); +} + sub check_objects { my ($self) = @_; + $self->controller->track_progress(phase => 'building data', progress => 0); + + my $i; + my $num_data = scalar @{ $self->controller->data }; foreach my $entry (@{ $self->controller->data }) { + $self->controller->track_progress(progress => $i/$num_data * 100) if $i % 100 == 0; + $self->check_name($entry); $self->check_vc($entry, 'cp_cv_id'); $self->check_gender($entry); + $self->handle_cvars($entry); + } continue { + $i++; } $self->add_info_columns({ header => $::locale->text('Customer/Vendor'), method => 'vc_name' }); + $self->add_cvar_raw_data_columns; } sub check_name { @@ -44,33 +62,24 @@ sub check_gender { push @{ $entry->{errors} }, $::locale->text('Error: Gender (cp_gender) missing or invalid') if ($entry->{object}->cp_gender ne 'm') && ($entry->{object}->cp_gender ne 'f'); } -sub check_duplicates { - my ($self, %params) = @_; - - my $normalizer = sub { my $name = $_[0]; $name =~ s/[\s,\.\-]//g; return $name; }; - - my %by_id_and_name; - if ('check_db' eq $self->controller->profile->get('duplicates')) { - foreach my $type (qw(customers vendors)) { - foreach my $vc (@{ $self->all_vc->{$type} }) { - $by_id_and_name{ $vc->id } = { map { ( $normalizer->($_->cp_name) => 'db' ) } @{ $vc->contacts } }; +sub get_duplicate_check_fields { + return { + cp_name => { + label => $::locale->text('Name'), + default => 1, + maker => sub { + my $o = shift; + return join( + '--', + $o->cp_cv_id, + map( + { s/[\s,\.\-]//g; $_ } + $o->cp_name + ) + ); } - } - } - - foreach my $entry (@{ $self->controller->data }) { - next if @{ $entry->{errors} }; - - my $name = $normalizer->($entry->{object}->cp_name); - - $by_id_and_name{ $entry->{vc}->id } ||= { }; - if (!$by_id_and_name{ $entry->{vc}->id }->{ $name }) { - $by_id_and_name{ $entry->{vc}->id }->{ $name } = 'csv'; - - } else { - push @{ $entry->{errors} }, $by_id_and_name{ $entry->{vc}->id }->{ $name } eq 'db' ? $::locale->text('Duplicate in database') : $::locale->text('Duplicate in CSV file'); - } - } + }, + }; } sub field_lengths { @@ -87,6 +96,7 @@ sub setup_displayable_columns { my ($self) = @_; $self->SUPER::setup_displayable_columns; + $self->add_cvar_columns_to_displayable_columns; $self->add_displayable_columns({ name => 'cp_abteilung', description => $::locale->text('Department') }, { name => 'cp_birthday', description => $::locale->text('Birthday') }, @@ -106,6 +116,7 @@ sub setup_displayable_columns { { name => 'cp_satfax', description => $::locale->text('Sat. Fax') }, { name => 'cp_satphone', description => $::locale->text('Sat. Phone') }, { name => 'cp_title', description => $::locale->text('Title') }, + { name => 'cp_position', description => $::locale->text('Function/position') }, { name => 'customer', description => $::locale->text('Customer (name)') }, { name => 'customernumber', description => $::locale->text('Customer Number') },