diff options
| author | Mark Wells <mark@freeside.biz> | 2012-07-13 15:33:02 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2012-07-13 15:33:02 -0700 |
| commit | 15db7ad6e6ea2e57784368eec80e4aae54358f77 (patch) | |
| tree | dcfd0ab0d1c76fdf1650cc934c78a2fb1cada6cc /httemplate/search | |
| parent | 0ad946f751d3a953c8a41eea1d30ad362ba38ace (diff) | |
sales by ad source report: filter by status, #17971
Diffstat (limited to 'httemplate/search')
| -rw-r--r-- | httemplate/search/cust_bill_pkg_referral.html | 11 | ||||
| -rw-r--r-- | httemplate/search/report_cust_bill_pkg_referral.html | 6 |
2 files changed, 15 insertions, 2 deletions
diff --git a/httemplate/search/cust_bill_pkg_referral.html b/httemplate/search/cust_bill_pkg_referral.html index 1bb6b9179..3cb434caa 100644 --- a/httemplate/search/cust_bill_pkg_referral.html +++ b/httemplate/search/cust_bill_pkg_referral.html @@ -135,8 +135,15 @@ my @where = ( $agentnums_sql, "cust_bill._date <= $ending", ); -if ( $cgi->param('status') =~ /^([a-z]+)$/ ) { - push @where, FS::cust_pkg->cust_status_sql . " = '$1'"; +my @status_where; +foreach my $status ($cgi->param('status')) { + if ( $status =~ /^([- a-z]+)$/ ) { #"one-time charge" + push @status_where, "'$status'"; + } +} +if ( @status_where ) { + push @where, '('. FS::cust_pkg->status_sql. + ') IN (' . join(',', @status_where) .')'; } if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) { diff --git a/httemplate/search/report_cust_bill_pkg_referral.html b/httemplate/search/report_cust_bill_pkg_referral.html index 1fbb13d4f..ff2caa1fa 100644 --- a/httemplate/search/report_cust_bill_pkg_referral.html +++ b/httemplate/search/report_cust_bill_pkg_referral.html @@ -12,6 +12,12 @@ 'empty_label' => 'all', &> +<& /elements/tr-select-cust_pkg-status.html, + 'label' => 'Package status', + 'multiple' => 1, + 'disable_empty' => 1, +&> + <& /elements/tr-select-pkg_class.html, 'pre_options' => [ '' => 'all', '0' => '(empty class)' ], 'disable_empty' => 1, |