X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_bill_pkg_referral.html;fp=httemplate%2Fsearch%2Fcust_bill_pkg_referral.html;h=3cb434caa2ed4d03e0330661a8666072a5a80852;hb=15db7ad6e6ea2e57784368eec80e4aae54358f77;hp=1bb6b9179d318a896629521bf31bc49f87328990;hpb=0ad946f751d3a953c8a41eea1d30ad362ba38ace;p=freeside.git 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+)$/ ) {