From 6c6a13eebe6f38119ebe3bd8f98e7759fede1d3e Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Mon, 15 Sep 2003 21:33:04 +0000
Subject: package search skips cancelled packages when searching by date range

---
 httemplate/search/cust_pkg.cgi | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/httemplate/search/cust_pkg.cgi b/httemplate/search/cust_pkg.cgi
index 444eff9b6..2fca0bf0b 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;
-- 
cgit v1.2.1