diff options
author | ivan <ivan> | 2006-07-23 14:23:39 +0000 |
---|---|---|
committer | ivan <ivan> | 2006-07-23 14:23:39 +0000 |
commit | 79f6314575d140a09b362129e5ee580468059e99 (patch) | |
tree | de80d1b84c9754771b60c51d480ce46178a24d1e /httemplate | |
parent | 29e7e361910ee76e9d487b2df88710af78997c8f (diff) |
sql num_pkgs conflicting with method...
Diffstat (limited to 'httemplate')
-rwxr-xr-x | httemplate/search/report_receivables.cgi | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi index b08fc8143..3052ea93c 100755 --- a/httemplate/search/report_receivables.cgi +++ b/httemplate/search/report_receivables.cgi @@ -70,7 +70,7 @@ END my $cancelled_sql = FS::cust_pkg->inactive_sql; my $packages_cols = <<END; - ( $select_count_pkgs ) AS num_pkgs, + ( $select_count_pkgs ) AS num_pkgs_sql, ( $select_count_pkgs AND $active_sql ) AS active_pkgs, ( $select_count_pkgs AND $inactive_sql ) AS inactive_pkgs, ( $select_count_pkgs AND $suspended_sql ) AS suspended_pkgs, @@ -117,7 +117,7 @@ END my $row = shift; my $status = 'unknown'; - if ( $row->num_pkgs == 0 ) { + if ( $row->num_pkgs_sql == 0 ) { $status = 'prospect'; } elsif ( $row->active_pkgs > 0 ) { $status = 'active'; |