X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/8a3a4a40b43a0556ca7d72fd0fa72e45a8ccb385..35998e803671bf65ed91cabb80321e175e3158c6:/SL/Controller/CsvImport/CustomerVendor.pm diff --git a/SL/Controller/CsvImport/CustomerVendor.pm b/SL/Controller/CsvImport/CustomerVendor.pm index d1e026d42..f3b8d0443 100644 --- a/SL/Controller/CsvImport/CustomerVendor.pm +++ b/SL/Controller/CsvImport/CustomerVendor.pm @@ -7,6 +7,7 @@ use SL::Controller::CsvImport::Helper::Consistency; use SL::DB::Business; use SL::DB::CustomVariable; use SL::DB::CustomVariableConfig; +use SL::DB::Employee; use SL::DB::PaymentTerm; use SL::TransNumber; @@ -53,7 +54,7 @@ sub init_languages_by { sub init_salesmen_by { my ($self) = @_; - return { map { my $col = $_; ( $col => { map { ( $_->$col => $_ ) } @{ SL::DB::Manager::Employee->get_all } } ) } qw(id name) }; + return { map { my $col = $_; ( $col => { map { ( lc($_->$col) => $_ ) } @{ SL::DB::Manager::Employee->get_all } } ) } qw(id name login) }; } sub check_objects { @@ -215,8 +216,9 @@ sub check_salesman { } # Map name to ID if given. - if (!$object->salesman_id && $entry->{raw_data}->{salesman}) { - my $salesman = $self->salesmen_by->{name}->{ $entry->{raw_data}->{salesman} }; + if (!$object->salesman_id && ($entry->{raw_data}->{salesman} || $entry->{raw_data}->{salesman_login})) { + my $salesman = $self->salesmen_by->{name} ->{ lc($entry->{raw_data}->{salesman}) } + // $self->salesmen_by->{login}->{ lc($entry->{raw_data}->{salesman_login}) }; if (!$salesman) { push @{ $entry->{errors} }, $::locale->text('Error: Invalid salesman'); @@ -239,18 +241,7 @@ sub save_objects { my $with_number = [ grep { $_->{object}->$numbercolumn ne '####' } @{ $self->controller->data } ]; my $without_number = [ grep { $_->{object}->$numbercolumn eq '####' } @{ $self->controller->data } ]; - 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()); - } - } + $_->{object}->$numbercolumn('') for @{ $without_number }; $self->SUPER::save_objects(data => $with_number); $self->SUPER::save_objects(data => $without_number); @@ -261,7 +252,7 @@ sub init_profile { my $profile = $self->SUPER::init_profile; delete @{$profile}{qw(business datevexport language payment delivery_term taxincluded terms)}; - delete @{$profile}{qw(salesman salesman_id)} if $::instance_conf->get_vertreter; + delete @{$profile}{qw(salesman salesman_id salesman_login)} if $::instance_conf->get_vertreter; return $profile; } @@ -300,7 +291,7 @@ sub setup_displayable_columns { { name => 'greeting', description => $::locale->text('Greeting') }, { name => 'homepage', description => $::locale->text('Homepage') }, { name => 'iban', description => $::locale->text('IBAN') }, - { name => 'klass', description => $::locale->text('Preisklasse') }, + { name => 'pricegroup_id', description => $::locale->text('Price group (database ID)') }, { name => 'language_id', description => $::locale->text('Language (database ID)') }, { name => 'language', description => $::locale->text('Language (name)') }, { name => 'name', description => $::locale->text('Name') }, @@ -320,10 +311,10 @@ sub setup_displayable_columns { ); if (!$::instance_conf->get_vertreter) { - $self->add_displayable_columns({ name => 'salesman_id', description => $::locale->text('Salesman (database ID)') }); - $self->add_displayable_columns({ name => 'salesman', description => $::locale->text('Salesman') }); + $self->add_displayable_columns({ name => 'salesman', description => $::locale->text('Salesman') }, + { name => 'salesman_id', description => $::locale->text('Salesman (database ID)') }, + { name => 'salesman_login', description => $::locale->text('Salesman (login)') }); } - } # TODO: