From: ivan <ivan>
Date: Sun, 12 Dec 2004 08:34:36 +0000 (+0000)
Subject: fix customer status display for some cases with suspended accounts
X-Git-Tag: BEFORE_FINAL_MASONIZE~782
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=3beb53d9d87b5667c306dc4abd6cd6c0165ad852

fix customer status display for some cases with suspended accounts
---

diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm
index 27f97f30e..34ca9d4af 100644
--- a/FS/FS/cust_main.pm
+++ b/FS/FS/cust_main.pm
@@ -2917,6 +2917,7 @@ sub susp_sql { "
     AND 0 = ( SELECT COUNT(*) FROM cust_pkg
                 WHERE cust_pkg.custnum = cust_main.custnum
                   AND ( cust_pkg.susp IS NULL OR cust_pkg.susp = 0 )
+                  AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 )
             )
 "; }