diff options
| author | ivan <ivan> | 2003-09-15 21:33:04 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-09-15 21:33:04 +0000 |
| commit | 6c6a13eebe6f38119ebe3bd8f98e7759fede1d3e (patch) | |
| tree | 4893d0971ee2c226e555f123854a283ed08b2027 | |
| parent | c15316e8d3fcf2132910518013c25412c2765a8a (diff) | |
package search skips cancelled packages when searching by date range
| -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 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; |