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});
}
$where .= qq| AND (date_trunc('DAY', fu.itime) <= ?)|;
push @values, conv_date($params{itime_to});
}
+ if ($params{created_for}) {
+ $where .= qq| AND fu.created_for_user = ?|;
+ 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;
}
};
} 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}",
};
};
} 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}",
};
};
} 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}",
};