X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FFU.pm;h=822e31fe32b1f204f95eedf24b2f6665f27acacf;hb=fa31a7e0c6a8d00e35511f5052145ab2156a8160;hp=83ec776bc0c37ee8bbfe22f55bdc024d2e2d65d2;hpb=fec23589845dc3fec23253412d2e196005fadf00;p=kivitendo-erp.git diff --git a/SL/FU.pm b/SL/FU.pm index 83ec776bc..822e31fe3 100644 --- a/SL/FU.pm +++ b/SL/FU.pm @@ -195,8 +195,10 @@ sub follow_ups { my @values_user = (); if ($params{trans_id}) { - $where .= qq| AND EXISTS (SELECT * FROM follow_up_links ful - WHERE (ful.follow_up_id = fu.id) AND (ful.trans_id = ?))|; + $where .= qq| AND fu.id IN (select follow_up_id from follow_up_links where trans_id = ?)|; + # $where .= qq| AND (ful.follow_up_id = fu.id) AND (ful.trans_id = ?))|; + # $where .= qq| AND EXISTS (SELECT * FROM follow_up_links ful + # WHERE (ful.follow_up_id = fu.id) AND (ful.trans_id = ?))|; push @values, conv_i($params{trans_id}); } @@ -251,7 +253,7 @@ sub follow_ups { push @values, conv_i($params{created_for}); } - if ($params{all_users}) { + if ($params{all_users} || $params{trans_id}) { # trans_id only for documents? $where_user = qq|OR (fu.created_by IN (SELECT DISTINCT what FROM follow_up_access WHERE who = ?))|; push @values_user, $employee_id; } @@ -336,8 +338,14 @@ sub link_details { }; } elsif ($params{trans_type} eq 'sales_quotation') { + my $script = 'oe.pl'; + my $action = 'edit'; + if ($::instance_conf->get_feature_experimental_order) { + $script = 'controller.pl'; + $action = 'Order/edit'; + } $link = { - 'url' => 'oe.pl?action=edit&type=sales_quotation&id=' . $params{trans_id}, + 'url' => $script . '?action=' . $action . '&type=sales_quotation&id=' . $params{trans_id}, 'title' => $locale->text('Sales quotation') . " $params{trans_info}", }; @@ -356,8 +364,14 @@ sub link_details { }; } elsif ($params{trans_type} eq 'sales_order') { + my $script = 'oe.pl'; + my $action = 'edit'; + if ($::instance_conf->get_feature_experimental_order) { + $script = 'controller.pl'; + $action = 'Order/edit'; + } $link = { - 'url' => 'oe.pl?action=edit&type=sales_order&id=' . $params{trans_id}, + 'url' => $script . '?action=' . $action . '&type=sales_order&id=' . $params{trans_id}, 'title' => $locale->text('Sales Order') . " $params{trans_info}", }; @@ -386,14 +400,26 @@ sub link_details { }; } elsif ($params{trans_type} eq 'request_quotation') { + my $script = 'oe.pl'; + my $action = 'edit'; + if ($::instance_conf->get_feature_experimental_order) { + $script = 'controller.pl'; + $action = 'Order/edit'; + } $link = { - 'url' => 'oe.pl?action=edit&type=request_quotation&id=' . $params{trans_id}, + 'url' => $script . '?action=' . $action . '&type=request_quotation&id=' . $params{trans_id}, 'title' => $locale->text('Request quotation') . " $params{trans_info}", }; } elsif ($params{trans_type} eq 'purchase_order') { + my $script = 'oe.pl'; + my $action = 'edit'; + if ($::instance_conf->get_feature_experimental_order) { + $script = 'controller.pl'; + $action = 'Order/edit'; + } $link = { - 'url' => 'oe.pl?action=edit&type=purchase_order&id=' . $params{trans_id}, + 'url' => $script . '?action=' . $action . '&type=purchase_order&id=' . $params{trans_id}, 'title' => $locale->text('Purchase Order') . " $params{trans_info}", };