X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FFU.pm;h=9f651981c9eab4559eabb694c7cc1f17ad4bd06e;hb=21ca8cb76721b756440cfe75fd8710bfe1caf31b;hp=c34a031296485c3e633592e4918ce8366e370bd9;hpb=e02b6c616968db9aef1ba9425254d4b29ff1c7e8;p=kivitendo-erp.git diff --git a/SL/FU.pm b/SL/FU.pm index c34a03129..9f651981c 100644 --- a/SL/FU.pm +++ b/SL/FU.pm @@ -36,7 +36,8 @@ sub save { 'trans_id' => $params{id}, 'trans_module' => 'fu', 'subject' => $params{subject}, - 'body' => $params{body}); + 'body' => $params{body}, + 'dbh' => $dbh,); $params{done} = 1 if (!defined $params{done}); @@ -181,7 +182,8 @@ sub follow_ups { my ($query, $where, $where_user); my ($employee_id) = selectrow_query($form, $dbh, qq|SELECT id FROM employee WHERE login = ?|, $form->{login}); - my @values = ($employee_id, $employee_id); + my @values = (); + my @values_user = (); if ($params{trans_id}) { $where .= qq| AND EXISTS (SELECT * FROM follow_up_links ful @@ -238,7 +240,7 @@ sub follow_ups { if ($params{all_users}) { $where_user = qq|OR (fu.created_by IN (SELECT DISTINCT what FROM follow_up_access WHERE who = ?))|; - push @values, $employee_id; + push @values_user, $employee_id; } my $order_by = ''; @@ -269,7 +271,7 @@ sub follow_ups { $where $order_by|; - my $follow_ups = selectall_hashref_query($form, $dbh, $query, @values); + my $follow_ups = selectall_hashref_query($form, $dbh, $query, $employee_id, $employee_id, @values_user, @values); if (!scalar @{ $follow_ups }) { $main::lxdebug->leave_sub();