diff options
| author | ivan <ivan> | 2002-07-07 14:18:58 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2002-07-07 14:18:58 +0000 |
| commit | 508721f2941f287c841f57e6b3077aa90265826c (patch) | |
| tree | dddd08c11bed6c85b3590627699c1fc008d89bad | |
| parent | 9b76e0bd55bb4df1b9cad6d717bf0b27af72736c (diff) | |
fix 30/60/90/120 browses
| -rwxr-xr-x | httemplate/search/cust_bill.cgi | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/httemplate/search/cust_bill.cgi b/httemplate/search/cust_bill.cgi index 1ce25d591..6b6158943 100755 --- a/httemplate/search/cust_bill.cgi +++ b/httemplate/search/cust_bill.cgi @@ -54,7 +54,7 @@ if ( $cgi->keywords ) { $orderby = "ORDER BY cust_bill.invnum"; #@cust_bill = # grep $_->owed != 0 && $_->_date < time - $open, qsearch('cust_bill', {} ); - push @where, "0 != $owed". + push @where, "0 != $owed", "cust_bill._date < ". (time-$open); } elsif ( $query =~ /^OPEN(\d+)_date$/ ) { my $open = $1 * 86400; @@ -62,7 +62,7 @@ if ( $cgi->keywords ) { $orderby = "ORDER BY cust_bill._date"; #@cust_bill = # grep $_->owed != 0 && $_->_date < time - $open, qsearch('cust_bill', {} ); - push @where, "0 != $owed". + push @where, "0 != $owed", "cust_bill._date < ". (time-$open); } elsif ( $query =~ /^OPEN(\d+)_custnum$/ ) { @@ -71,7 +71,7 @@ if ( $cgi->keywords ) { $orderby = "ORDER BY cust_bill.custnum"; #@cust_bill = # grep $_->owed != 0 && $_->_date < time - $open, qsearch('cust_bill', {} ); - push @where, "0 != $owed". + push @where, "0 != $owed", "cust_bill._date < ". (time-$open); } else { die "unknown query string $query"; |