diff options
| author | ivan <ivan> | 2011-03-15 00:46:39 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2011-03-15 00:46:39 +0000 |
| commit | afc02cadca8e8033285bb213bcde620cb8fa4f99 (patch) | |
| tree | 60862a736325ea4bae2b0b8d24b50145a1d80e13 | |
| parent | 184cfcddbb0f9148d0ef1c01756647946b8c2df9 (diff) | |
fix sales report detail links when using "Separate rated usage from recurring feeds", RT#12019
| -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)"; |