diff options
| author | ivan <ivan> | 2007-10-28 03:55:28 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2007-10-28 03:55:28 +0000 |
| commit | e71d994519c08e73f2b3d3f4d69922816c3eb714 (patch) | |
| tree | 9323a8dc193a69b62a3953d7f2a02157591fb146 /httemplate | |
| parent | a97d99dbd4e56f1b0bf1b0de3ed17e56430add96 (diff) | |
mysql me harder
Diffstat (limited to 'httemplate')
| -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 6e5893870..90221f652 100755 --- a/httemplate/search/report_receivables.cgi +++ b/httemplate/search/report_receivables.cgi @@ -92,13 +92,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 |