diff options
author | Christopher Burger <burgerc@freeside.biz> | 2017-10-17 09:41:12 -0400 |
---|---|---|
committer | Christopher Burger <burgerc@freeside.biz> | 2017-12-13 14:38:11 -0500 |
commit | 08ac1d0dc44626f442f8287c497eca9e98ab92b7 (patch) | |
tree | 2e1cd043635c7dd66fb08f5f06ee82210f57e269 /FS/FS/h_cust_pkg.pm | |
parent | eb95e404a35f9f1b7125e67d1e539ada860fcdf0 (diff) |
RT# 78019 - Added total revenue line to Package churn report
Diffstat (limited to 'FS/FS/h_cust_pkg.pm')
-rw-r--r-- | FS/FS/h_cust_pkg.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/FS/FS/h_cust_pkg.pm b/FS/FS/h_cust_pkg.pm index 423b442..f074647 100644 --- a/FS/FS/h_cust_pkg.pm +++ b/FS/FS/h_cust_pkg.pm @@ -140,9 +140,9 @@ sub churn_fromwhere_sql { # XXX or should we include if they were created by a pkgpart change? $from = "cust_pkg"; @where = ( - "setup >= $speriod", - "setup < $eperiod", - "change_pkgnum IS NULL" + "cust_pkg.setup >= $speriod", + "cust_pkg.setup < $eperiod", + "cust_pkg.change_pkgnum IS NULL" ); } elsif ( $status eq 'cancel' ) { # also simple, because packages should only be canceled once |