diff options
| author | ivan <ivan> | 2007-10-28 03:55:27 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2007-10-28 03:55:27 +0000 |
| commit | 556cefb34ed648303951009e3bec919e18532bed (patch) | |
| tree | 2ecd3e81869e15d7902e587d3cd90b1e6021aa34 /httemplate/search | |
| parent | 9ed8adbf1ab5aba8181903e9c262f2b69dba6cbc (diff) | |
mysql me harder
Diffstat (limited to 'httemplate/search')
| -rwxr-xr-x | httemplate/search/report_receivables.cgi | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi index 425fa2b89..e68eb8229 100755 --- a/httemplate/search/report_receivables.cgi +++ b/httemplate/search/report_receivables.cgi @@ -82,13 +82,13 @@ sub owed { #handle start and end ranges + my $str2time = str2time; + #24h * 60m * 60s - push @where, "cust_bill._date <= extract(epoch from now())-". - ($start * 86400) + push @where, "cust_bill._date <= $str2time now() ) - ". ($start * 86400) if $start; - push @where, "cust_bill._date > extract(epoch from now()) - ". - ($end * 86400) + push @where, "cust_bill._date > $str2time now() ) - ". ($end * 86400) if $end; #handle 'cust' option |