diff options
| author | ivan <ivan> | 2003-09-15 21:33:03 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-09-15 21:33:03 +0000 |
| commit | 32ba5c8d264479a302c1524165d708ce11243d69 (patch) | |
| tree | 14627cab915cac5adab5950c05aa3e3cad4781f5 /httemplate/search/cust_pkg.cgi | |
| parent | 85e1e6cd17d746818ad898bdac7c48de91398b2b (diff) | |
package search skips cancelled packages when searching by date range
Diffstat (limited to 'httemplate/search/cust_pkg.cgi')
| -rwxr-xr-x | httemplate/search/cust_pkg.cgi | 2 |
1 files changed, 2 insertions, 0 deletions
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; |