Merge branch 'b-3.6.1' of ../kivitendo-erp_20220811

[mfinanz.git] / SL / DB / CustomVariable.pm

diff --git a/SL/DB/CustomVariable.pm b/SL/DB/CustomVariable.pm
index 144acef00395cb83a325f77e0bc9c20e75568b32..eeae39aafaf9fb9c640aa002b2ecedcadeae63be 100644 (file)
--- a/SL/DB/CustomVariable.pm
+++ b/SL/DB/CustomVariable.pm
@@ -4,6 +4,9 @@
 package SL::DB::CustomVariable;
 
 use strict;
 package SL::DB::CustomVariable;
 
 use strict;

+
+use List::MoreUtils qw(any);
+

 use SL::DB::MetaSetup::CustomVariable;
 
 __PACKAGE__->meta->initialize;
 use SL::DB::MetaSetup::CustomVariable;
 
 __PACKAGE__->meta->initialize;


@@ -11,36 +14,109 @@ __PACKAGE__->meta->initialize;
 # Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
 __PACKAGE__->meta->make_manager_class;
 
 # Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
 __PACKAGE__->meta->make_manager_class;
 

+sub unparsed_value {
+  my ($self, $new) = @_;
+
+  $self->{__unparsed_value} = $new;
+}
+
+sub _ensure_config {
+  my ($self) = @_;
+
+  return $self->config if  defined $self->{config};
+  return undef         if !defined $self->config_id;
+
+  no warnings 'once';
+  return $::request->cache('config_by_id')->{$self->config_id} //= SL::DB::CustomVariableConfig->new(id => $self->config_id)->load;
+}
+
+sub parse_value {
+  my ($self) = @_;
+  my $type   = $self->_ensure_config->type;
+
+  return unless exists $self->{__unparsed_value};
+
+  my $unparsed = delete $self->{__unparsed_value};
+
+  if ($type =~ m{^(?:customer|vendor|part|number)}) {
+    return $self->number_value(!defined($unparsed) ? undef
+                               : (any { ref($unparsed) eq $_ } qw(SL::DB::Customer SL::DB::Vendor SL::DB::Part)) ? $unparsed->id * 1
+                               : $unparsed * 1);
+  }
+
+  if ($type =~ m{^(?:bool)}) {
+    return $self->bool_value(defined($unparsed) ? !!$unparsed : undef);
+  }
+
+  if ($type =~ m{^(?:date|timestamp)}) {
+    return $self->timestamp_value(!defined($unparsed) ? undef : ref($unparsed) eq 'DateTime' ? $unparsed->clone : DateTime->from_kivitendo($unparsed));
+  }
+
+  # text, textfield, htmlfield and select
+  $self->text_value($unparsed);
+}
+

 sub value {
   my $self = $_[0];
 sub value {
   my $self = $_[0];

-  my $type = $self->config->type;
+  my $type = $self->_ensure_config->type;
+
+  if (scalar(@_) > 1) {
+    $self->unparsed_value($_[1]);
+    $self->parse_value;
+    @_ = ($self);
+  }

 
 

-  goto &bool_value      if $type eq 'boolean';
+  goto &bool_value      if $type eq 'bool';

   goto &timestamp_value if $type eq 'timestamp';
   goto &timestamp_value if $type eq 'timestamp';

-  goto &number_value    if $type eq 'number';

 
 

-  if ( $_[1] && ($type eq 'customer' || $type eq 'vendor' || $type eq 'part') ) {
-    $self->number_value($_[1]);
+  if ($type eq 'number') {
+    return defined($self->number_value) ? $self->number_value * 1 : undef;

   }
 
   if ( $type eq 'customer' ) {
     require SL::DB::Customer;
 
     my $id = int($self->number_value);
   }
 
   if ( $type eq 'customer' ) {
     require SL::DB::Customer;
 
     my $id = int($self->number_value);

-    return $id ? SL::DB::Customer->new(id => $id)->load() : 0;
+    return $id ? SL::DB::Customer->new(id => $id)->load() : undef;

   } elsif ( $type eq 'vendor' ) {
     require SL::DB::Vendor;
 
     my $id = int($self->number_value);
   } elsif ( $type eq 'vendor' ) {
     require SL::DB::Vendor;
 
     my $id = int($self->number_value);

-    return $id ? SL::DB::Vendor->new(id => $id)->load() : 0;
+    return $id ? SL::DB::Vendor->new(id => $id)->load() : undef;

   } elsif ( $type eq 'part' ) {
     require SL::DB::Part;
 
     my $id = int($self->number_value);
   } elsif ( $type eq 'part' ) {
     require SL::DB::Part;
 
     my $id = int($self->number_value);

-    return $id ? SL::DB::Part->new(id => $id)->load() : 0;
+    return $id ? SL::DB::Part->new(id => $id)->load() : undef;
+  } elsif ( $type eq 'date' ) {
+    return $self->timestamp_value ? $self->timestamp_value->clone->truncate(to => 'day') : undef;

   }
 
   }
 

-  goto &text_value; # text, textfield, date and select
+  goto &text_value; # text, textfield, htmlfield and select
+}
+
+sub value_as_text {
+  my $self = $_[0];
+  my $cfg  = $self->_ensure_config;
+  my $type = $cfg->type;
+
+  die 'not an accessor' if @_ > 1;
+
+  if ($type eq 'bool') {
+    return $self->bool_value ? $::locale->text('Yes') : $::locale->text('No');
+  } elsif ($type =~ m{^(?:timestamp|date)}) {
+    return '' if !$self->timestamp_value;
+    return $::locale->reformat_date( { dateformat => 'yy-mm-dd' }, $self->timestamp_value->ymd, $::myconfig{dateformat});
+  } elsif ($type eq 'number') {
+    return $::form->format_amount(\%::myconfig, $self->number_value, $cfg->processed_options->{PRECISION});
+  } elsif ( $type =~ m{^(?:customer|vendor|part)$}) {
+    my $class = "SL::DB::" . ucfirst($type);
+    eval "require $class";
+    my $object =  $class->_get_manager_class->find_by(id => int($self->number_value));
+    return $object ? $object->displayable_name : '';
+  }
+
+  goto &text_value; # text, textfield, htmlfield and select

 }
 
 sub is_valid {
 }
 
 sub is_valid {


@@ -48,8 +124,13 @@ sub is_valid {
 
   require SL::DB::CustomVariableValidity;
 
 
   require SL::DB::CustomVariableValidity;
 

-  my $query = [config_id => $self->config_id, trans_id => $self->trans_id];
-  return SL::DB::Manager::CustomVariableValidity->get_all_count(query => $query) == 0;
+  # only base level custom variables can be invalid. ovverloaded ones could potentially clash on trans_id, so disallow them
+  return 1 if $self->sub_module;
+
+  $self->{is_valid} //= do {
+    my $query = [config_id => $self->config_id, trans_id => $self->trans_id];
+    (SL::DB::Manager::CustomVariableValidity->get_all_count(query => $query) == 0) ? 1 : 0;
+  }

 }
 
 1;
 }
 
 1;