X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/e055b3ff9423767fd109a8d7a36d354c8997c941..32115b41fee3d1e1523c60975c8da4641a33f37f:/SL/Controller/CsvImport/Base.pm diff --git a/SL/Controller/CsvImport/Base.pm b/SL/Controller/CsvImport/Base.pm index 91efaaaac..a52201b98 100644 --- a/SL/Controller/CsvImport/Base.pm +++ b/SL/Controller/CsvImport/Base.pm @@ -5,13 +5,15 @@ use strict; use List::MoreUtils qw(pairwise); use SL::Helper::Csv; +use SL::DB::Language; +use SL::DB::PaymentTerm; use parent qw(Rose::Object); use Rose::Object::MakeMethods::Generic ( scalar => [ qw(controller file csv) ], - 'scalar --get_set_init' => [ qw(profile existing_objects class manager_class cvar_columns all_cvar_configs) ], + 'scalar --get_set_init' => [ qw(profile displayable_columns existing_objects class manager_class cvar_columns all_cvar_configs all_languages payment_terms_by) ], ); sub run { @@ -84,6 +86,19 @@ sub init_cvar_columns { return [ map { "cvar_" . $_->name } (@{ $self->all_cvar_configs }) ]; } +sub init_all_languages { + my ($self) = @_; + + return SL::DB::Manager::Language->get_all; +} + +sub init_payment_terms_by { + my ($self) = @_; + + my $all_payment_terms = SL::DB::Manager::PaymentTerm->get_all; + return { map { my $col = $_; ( $col => { map { ( $_->$col => $_ ) } @{ $all_payment_terms } } ) } qw(id description) }; +} + sub handle_cvars { my ($self, $entry) = @_; @@ -130,6 +145,39 @@ sub init_profile { $self->profile(\%profile); } +sub add_displayable_columns { + my ($self, @columns) = @_; + + my @cols = @{ $self->controller->displayable_columns || [] }; + my %ex_col_map = map { $_->{name} => $_ } @cols; + + foreach my $column (@columns) { + if ($ex_col_map{ $column->{name} }) { + @{ $ex_col_map{ $column->{name} } }{ keys %{ $column } } = @{ $column }{ keys %{ $column } }; + } else { + push @cols, $column; + } + } + + $self->controller->displayable_columns([ sort { $a->{name} cmp $b->{name} } @cols ]); +} + +sub setup_displayable_columns { + my ($self) = @_; + + $self->add_displayable_columns(map { { name => $_ } } keys %{ $self->profile }); +} + +sub add_cvar_columns_to_displayable_columns { + my ($self) = @_; + + return unless $self->can('all_cvar_configs'); + + $self->add_displayable_columns(map { { name => 'cvar_' . $_->name, + description => $::locale->text('#1 (custom variable)', $_->description) } } + @{ $self->all_cvar_configs }); +} + sub init_existing_objects { my ($self) = @_; @@ -154,6 +202,32 @@ sub check_objects { sub check_duplicates { } +sub check_payment { + my ($self, $entry) = @_; + + my $object = $entry->{object}; + + # Check whether or not payment ID is valid. + if ($object->payment_id && !$self->payment_terms_by->{id}->{ $object->payment_id }) { + push @{ $entry->{errors} }, $::locale->text('Error: Invalid payment terms'); + return 0; + } + + # Map name to ID if given. + if (!$object->payment_id && $entry->{raw_data}->{payment}) { + my $terms = $self->payment_terms_by->{description}->{ $entry->{raw_data}->{payment} }; + + if (!$terms) { + push @{ $entry->{errors} }, $::locale->text('Error: Invalid payment terms'); + return 0; + } + + $object->payment_id($terms->id); + } + + return 1; +} + sub save_objects { my ($self, %params) = @_;