X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FRecordLinks.pm;h=fa5de38f79c6eb7b328292e323a99c49514abdb0;hb=1043d7f814fccf5864e677b1e38577d0a150026c;hp=8dfbac61ee775ee08e58a5d070edd86ba757bb9c;hpb=94e11003809e9090514026a733e58e72e636a6bb;p=kivitendo-erp.git

diff --git a/SL/RecordLinks.pm b/SL/RecordLinks.pm
index 8dfbac61e..fa5de38f7 100644
--- a/SL/RecordLinks.pm
+++ b/SL/RecordLinks.pm
@@ -2,6 +2,8 @@ package RecordLinks;
 
 use SL::Common;
 use SL::DBUtils;
+use Data::Dumper;
+use List::Util qw(reduce);
 
 sub create_links {
   $main::lxdebug->enter_sub();
@@ -30,7 +32,6 @@ sub create_links {
     }
 
     if (my $num = scalar @{ $ids{$from_to} }) {
-      $main::lxdebug->message(0, "3");
       $ids{$to_from} = [ ($params{"${to_from}_id"}) x $num ];
       @links         = map { { 'from_table' => $params{from_table},
                                'from_id'    => $ids{from}->[$_],
@@ -110,4 +111,93 @@ sub get_links {
   return wantarray ? @{ $links } : $links;
 }
 
+sub get_links_via {
+  $main::lxdebug->enter_sub();
+
+  use SL::MoreCommon;
+  use Data::Dumper;
+
+  my $self     = shift;
+  my %params   = @_;
+
+  Common::check_params(\%params, [ qw(from_table from_id to_table to_id) ]);
+  Common::check_params(\%params, "via");
+
+  my @hops = ref $params{via} eq 'ARRAY'
+           ? @{ $params{via} }
+           :    $params{via};
+  unshift @hops, +{ table => $params{from_table}, id => $params{from_id} };
+  push    @hops, +{ table => $params{to_table},   id => $params{to_id} };
+
+  my $myconfig   = \%main::myconfig;
+  my $form       = $main::form;
+
+  my $last_hop   = shift @hops;
+  my @links;
+  for my $hop (@hops) {
+
+    my @temp_links = $self->get_links(
+      from_table => $last_hop->{table},
+      from_id    => $last_hop->{id},
+      to_table   => $hop->{table},
+      to_id      => $hop->{id},
+    );
+
+    # short circuit if any of these are empty
+    return wantarray ? () : [] unless scalar @temp_links;
+
+    push @links, \@temp_links;
+    $last_hop  =  $hop;
+  }
+
+  my $result = reduce {
+    [
+      grep { $_ }
+      cross {
+        if (   $a->{to_table} eq $b->{from_table}
+            && $a->{to_id}    eq $b->{from_id} ) {
+          +{ from_table => $a->{from_table},
+             from_id    => $a->{from_id},
+             to_table   => $b->{to_table},
+             to_id      => $b->{to_id} }
+          }
+        } @{ $a }, @{ $b }
+    ]
+  } @links;
+
+  $main::lxdebug->leave_sub();
+
+  return wantarray ? @{ $result } : $result;
+}
+
+sub delete {
+  $main::lxdebug->enter_sub();
+
+  my $self     = shift;
+  my %params   = @_;
+
+  Common::check_params(\%params, [ qw(from_table from_id to_table to_id) ]);
+
+  my $myconfig   = \%main::myconfig;
+  my $form       = $main::form;
+
+  my $dbh        = $params{dbh} || $form->get_standard_dbh($myconfig);
+
+  # content
+  my (@where_tokens, @where_values);
+
+  for my $col (qw(from_table from_id to_table to_id)) {
+    add_token(\@where_tokens, \@where_values, col => $col, val => $params{$col}) if $params{$col};
+  }
+
+  my $where = "WHERE ". join ' AND ', map { "($_)" } @where_tokens if scalar @where_tokens;
+  my $query = "DELETE FROM record_links $where";
+
+  do_query($form, $dbh, $query, @where_values);
+
+  $dbh->commit() unless ($params{dbh});
+
+  $main::lxdebug->leave_sub();
+}
+
 1;