X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FController%2FCsvImport%2FPart.pm;h=d707aaafd3603898198fcf2475015ae691c1d82f;hb=60e09e25d76ec7c0a4f8431df0bc7a3b25e9041a;hp=5ae7bddcf7804fc585c708c35c0b99ff1cf316d2;hpb=72b340de2352eec7d3f99a00e2141a2df35f07f3;p=kivitendo-erp.git diff --git a/SL/Controller/CsvImport/Part.pm b/SL/Controller/CsvImport/Part.pm index 5ae7bddcf..d707aaafd 100644 --- a/SL/Controller/CsvImport/Part.pm +++ b/SL/Controller/CsvImport/Part.pm @@ -83,7 +83,7 @@ sub init_settings { return { map { ( $_ => $self->controller->profile->get($_) ) } qw(apply_buchungsgruppe default_buchungsgruppe article_number_policy sellprice_places sellprice_adjustment sellprice_adjustment_type - shoparticle_if_missing parts_type) }; + shoparticle_if_missing parts_type default_unit) }; } sub init_all_cvar_configs { @@ -198,7 +198,12 @@ sub check_existing { if ($self->settings->{article_number_policy} eq 'update_prices') { if ($entry->{part}) { - map { $entry->{part}->$_( $object->$_ ) } qw(sellprice listprice lastcost prices); + map { $entry->{part}->$_( $object->$_ ) if defined $object->$_ } qw(sellprice listprice lastcost); + + # merge prices + my %prices_by_pricegroup_id = map { $_->pricegroup->id => $_ } $entry->{part}->prices, $object->prices; + $entry->{part}->prices(grep { $_ } map { $prices_by_pricegroup_id{$_->id} } @{ $self->all_pricegroups }); + push @{ $entry->{information} }, $::locale->text('Updating prices of existing entry in database'); $entry->{object_to_save} = $entry->{part}; } @@ -312,6 +317,8 @@ sub check_unit { my $object = $entry->{object}; + $object->unit($self->settings->{default_unit}) unless $object->unit; + # Check whether or unit is valid. if (!$self->units_by->{name}->{ $object->unit }) { push @{ $entry->{errors} }, $::locale->text('Error: Unit missing or invalid'); @@ -412,39 +419,39 @@ sub setup_displayable_columns { $self->SUPER::setup_displayable_columns; $self->add_cvar_columns_to_displayable_columns; - $self->add_displayable_columns({ name => 'bin', description => $::locale->text('Bin') }, - { name => 'buchungsgruppen_id', description => $::locale->text('Buchungsgruppe (database ID)') }, - { name => 'buchungsgruppe', description => $::locale->text('Buchungsgruppe (name)') }, - { name => 'description', description => $::locale->text('Description') }, - { name => 'drawing', description => $::locale->text('Drawing') }, - { name => 'ean', description => $::locale->text('EAN') }, - { name => 'formel', description => $::locale->text('Formula') }, - { name => 'gv', description => $::locale->text('Business Volume') }, - { name => 'has_sernumber', description => $::locale->text('Has serial number') }, - { name => 'image', description => $::locale->text('Image') }, - { name => 'lastcost', description => $::locale->text('Last Cost') }, - { name => 'listprice', description => $::locale->text('List Price') }, - { name => 'make_X', description => $::locale->text('Make (with X being a number)') }, - { name => 'microfiche', description => $::locale->text('Microfiche') }, - { name => 'model_X', description => $::locale->text('Model (with X being a number)') }, - { name => 'not_discountable', description => $::locale->text('Not Discountable') }, - { name => 'notes', description => $::locale->text('Notes') }, - { name => 'obsolete', description => $::locale->text('Obsolete') }, - { name => 'onhand', description => $::locale->text('On Hand') }, - { name => 'partnumber', description => $::locale->text('Part Number') }, - { name => 'partsgroup_id', description => $::locale->text('Partsgroup (database ID)') }, - { name => 'partsgroup', description => $::locale->text('Partsgroup (name)') }, - { name => 'payment_id', description => $::locale->text('Payment terms (database ID)') }, - { name => 'payment', description => $::locale->text('Payment terms (name)') }, - { name => 'price_factor_id', description => $::locale->text('Price factor (database ID)') }, - { name => 'price_factor', description => $::locale->text('Price factor (name)') }, - { name => 'rop', description => $::locale->text('ROP') }, - { name => 'sellprice', description => $::locale->text('Sellprice') }, - { name => 'shop', description => $::locale->text('Shopartikel') }, - { name => 'type', description => $::locale->text('Article type (see below)') }, - { name => 'unit', description => $::locale->text('Unit') }, - { name => 've', description => $::locale->text('Verrechnungseinheit') }, - { name => 'weight', description => $::locale->text('Weight') }, + $self->add_displayable_columns({ name => 'bin', description => $::locale->text('Bin') }, + { name => 'buchungsgruppen_id', description => $::locale->text('Buchungsgruppe (database ID)') }, + { name => 'buchungsgruppe', description => $::locale->text('Buchungsgruppe (name)') }, + { name => 'description', description => $::locale->text('Description') }, + { name => 'drawing', description => $::locale->text('Drawing') }, + { name => 'ean', description => $::locale->text('EAN') }, + { name => 'formel', description => $::locale->text('Formula') }, + { name => 'gv', description => $::locale->text('Business Volume') }, + { name => 'has_sernumber', description => $::locale->text('Has serial number') }, + { name => 'image', description => $::locale->text('Image') }, + { name => 'lastcost', description => $::locale->text('Last Cost') }, + { name => 'listprice', description => $::locale->text('List Price') }, + { name => 'make_X', description => $::locale->text('Make (with X being a number)') }, + { name => 'microfiche', description => $::locale->text('Microfiche') }, + { name => 'model_X', description => $::locale->text('Model (with X being a number)') }, + { name => 'not_discountable', description => $::locale->text('Not Discountable') }, + { name => 'notes', description => $::locale->text('Notes') }, + { name => 'obsolete', description => $::locale->text('Obsolete') }, + { name => 'onhand', description => $::locale->text('On Hand') }, + { name => 'partnumber', description => $::locale->text('Part Number') }, + { name => 'partsgroup_id', description => $::locale->text('Partsgroup (database ID)') }, + { name => 'partsgroup', description => $::locale->text('Partsgroup (name)') }, + { name => 'payment_id', description => $::locale->text('Payment terms (database ID)') }, + { name => 'payment', description => $::locale->text('Payment terms (name)') }, + { name => 'price_factor_id', description => $::locale->text('Price factor (database ID)') }, + { name => 'price_factor', description => $::locale->text('Price factor (name)') }, + { name => 'rop', description => $::locale->text('ROP') }, + { name => 'sellprice', description => $::locale->text('Sellprice') }, + { name => 'shop', description => $::locale->text('Shopartikel') }, + { name => 'type', description => $::locale->text('Article type (see below)') }, + { name => 'unit', description => $::locale->text('Unit (if missing or empty default unit will be used)') }, + { name => 've', description => $::locale->text('Verrechnungseinheit') }, + { name => 'weight', description => $::locale->text('Weight') }, ); foreach my $language (@{ $self->all_languages }) {