diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2017-11-13 12:45:15 -0500 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2018-06-19 09:24:18 -0400 |
| commit | d65053a0357531b623d0ff715d3426301f242b2c (patch) | |
| tree | abf48d185222f1cf76fd36fc8363eb55d7857aab /FS | |
| parent | 20bfaf53d36f64261b9c6fe7a548b64ad40f5868 (diff) | |
RT# 77470 - added reason option to advanced package report with suspended status is selected. Also added links to suspend and unsuspend when status active or suspended is used.
Conflicts:
FS/FS/cust_pkg/Search.pm
httemplate/elements/tr-select-reason.html
httemplate/elements/tr-td-label.html
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/cust_pkg.pm | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/FS/FS/cust_pkg.pm b/FS/FS/cust_pkg.pm index fa60afb45..3b746fc2d 100644 --- a/FS/FS/cust_pkg.pm +++ b/FS/FS/cust_pkg.pm @@ -5893,6 +5893,8 @@ sub search { push @where, $FS::CurrentUser::CurrentUser->agentnums_sql('table'=>'cust_main'); } + push @where, "cust_pkg_reason.reasonnum = '".$params->{reasonnum}."'" if $params->{reasonnum}; + my $extra_sql = scalar(@where) ? ' WHERE '. join(' AND ', @where) : ''; my $addl_from = 'LEFT JOIN part_pkg USING ( pkgpart ) '. @@ -5900,6 +5902,10 @@ sub search { 'LEFT JOIN cust_location USING ( locationnum ) '. FS::UI::Web::join_cust_main('cust_pkg', 'cust_pkg'); + if ($params->{reasonnum}) { + $addl_from .= 'LEFT JOIN cust_pkg_reason ON (cust_pkg_reason.pkgnum = cust_pkg.pkgnum) '; + } + my $select; my $count_query; if ( $params->{'select_zip5'} ) { |