From 32ba5c8d264479a302c1524165d708ce11243d69 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Mon, 15 Sep 2003 21:33:03 +0000
Subject: [PATCH] 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 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;
-- 
2.11.0