From: ivan <ivan>
Date: Sun, 23 Jul 2006 14:23:39 +0000 (+0000)
Subject: sql num_pkgs conflicting with method...
X-Git-Tag: BEFORE_FINAL_MASONIZE~70
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=79f6314575d140a09b362129e5ee580468059e99

sql num_pkgs conflicting with method...
---

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';