From: ivan <ivan>
Date: Mon, 15 Sep 2003 21:33:03 +0000 (+0000)
Subject: package search skips cancelled packages when searching by date range
X-Git-Tag: NET_WHOIS_RAW_0_31~411
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=32ba5c8d264479a302c1524165d708ce11243d69

package search skips cancelled packages when searching by date range
---

diff --git a/httemplate/search/cust_pkg.cgi b/httemplate/search/cust_pkg.cgi
index 8b2fd0ca0..f735fbf42 100755
--- a/httemplate/search/cust_pkg.cgi
+++ b/httemplate/search/cust_pkg.cgi
@@ -33,6 +33,8 @@ if ( $cgi->param('magic') && $cgi->param('magic') eq 'bill' ) {
     $range .= ( $range ? ' AND ' : ' WHERE ' ). " bill <= $ending ";
   }
 
+  $range .= ( $range ? 'AND ' : ' WHERE ' ). '( cancel IS NULL OR cancel = 0 )';
+
   #false laziness with below
   my $statement = "SELECT COUNT(*) FROM cust_pkg $range";
   warn $statement;