diff options
Diffstat (limited to 'httemplate/search/timeworked.html')
| -rw-r--r-- | httemplate/search/timeworked.html | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/httemplate/search/timeworked.html b/httemplate/search/timeworked.html index b72dd0ea9..29f9b2546 100644 --- a/httemplate/search/timeworked.html +++ b/httemplate/search/timeworked.html @@ -96,6 +96,13 @@ my $where = " "; #AND $wheretimeleft +my $str2time_sql = str2time_sql; +my $closing = str2time_sql_closing; + +my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi); +$where .= " AND $str2time_sql Transactions.Created $closing >= $beginning ". + " AND $str2time_sql Transactions.Created $closing <= $ending"; + my $query = " SELECT Tickets.id, Tickets.Subject, TO_CHAR(Transactions.Created, 'Dy Mon DD HH24:MI:SS YYYY'), |