diff options
| author | ivan <ivan> | 2011-03-15 00:46:38 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2011-03-15 00:46:38 +0000 |
| commit | 338454f43f24ab6e97029ca9033f8d136f397924 (patch) | |
| tree | 33822d697f5d050e6166311e3b7c25c157bc23ea /httemplate/search/cust_bill_pkg.cgi | |
| parent | 707906baea6674cefaebe19db2ee9912054dbcde (diff) | |
fix sales report detail links when using "Separate rated usage from recurring feeds", RT#12019
Diffstat (limited to 'httemplate/search/cust_bill_pkg.cgi')
| -rw-r--r-- | httemplate/search/cust_bill_pkg.cgi | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi index b9743049d..a87e44651 100644 --- a/httemplate/search/cust_bill_pkg.cgi +++ b/httemplate/search/cust_bill_pkg.cgi @@ -463,8 +463,11 @@ if ( $cgi->param('pkg_tax') ) { } else { - #$count_query = "SELECT COUNT(*), "; - $count_query = "SELECT COUNT(DISTINCT billpkgnum), "; + if ( $use_usage ) { + $count_query = "SELECT COUNT(*), "; + } else { + $count_query = "SELECT COUNT(DISTINCT billpkgnum), "; + } if ( $use_usage eq 'recurring' ) { $count_query .= "SUM(setup + recur - usage)"; |