projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
mysql me 1.9 more times
[freeside.git]
/
httemplate
/
search
/
cdr.html
diff --git
a/httemplate/search/cdr.html
b/httemplate/search/cdr.html
index
61d41f8
..
9426c33
100644
(file)
--- a/
httemplate/search/cdr.html
+++ b/
httemplate/search/cdr.html
@@
-48,10
+48,12
@@
if ( $cgi->param('freesidestatus') eq 'NULL' ) {
# dates
###
# dates
###
+my $str2time_sql = str2time_sql;
+
my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi);
push @search,
my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi);
push @search,
-my @dsearch = ( "
extract(epoch from
calldate) >= $beginning ",
- "
extract(epoch from
calldate) <= $ending"
+my @dsearch = ( "
$str2time
calldate) >= $beginning ",
+ "
$str2time
calldate) <= $ending"
);
push @search, @dsearch;
push @qsearch, @search;
);
push @search, @dsearch;
push @qsearch, @search;