diff options
author | Mark Wells <mark@freeside.biz> | 2015-02-20 14:40:49 -0800 |
---|---|---|
committer | Mark Wells <mark@freeside.biz> | 2015-02-20 14:40:49 -0800 |
commit | 09e75cf2902b0daa996e69fb70b86be4ff1ae8a1 (patch) | |
tree | 8850efecff8efd0641260096b6cb1d764209a14d | |
parent | d77b69f1bdf85945fefb9b6952cbd815118c0154 (diff) |
unbreak projected future revenue query, #33599, fallout from #32472
-rw-r--r-- | FS/FS/Report/Table.pm | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/FS/FS/Report/Table.pm b/FS/FS/Report/Table.pm index 69686df9b..479747307 100644 --- a/FS/FS/Report/Table.pm +++ b/FS/FS/Report/Table.pm @@ -495,12 +495,17 @@ sub _cust_bill_pkg_recurring { my @where = ( '(pkgnum != 0 OR feepart IS NOT NULL)', - $self->with_classnum($opt{'classnum'}, $opt{'use_override'}), $self->with_report_option(%opt), $self->with_refnum(%opt), $self->with_cust_classnum(%opt) ); + my $where_classnum = $self->with_classnum($opt{'classnum'}, $opt{'use_override'}); + if ($opt{'project'}) { + $where_classnum =~ s/\bcust_bill_pkg/v_cust_bill_pkg/g; + } + push @where, $where_classnum; + if ( $opt{'distribute'} ) { $where[0] = 'pkgnum != 0'; # specifically exclude fees push @where, "cust_main.agentnum = $agentnum" if $agentnum; |