diff options
| author | ivan <ivan> | 2009-11-24 07:23:58 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-11-24 07:23:58 +0000 |
| commit | 1c478456e58dc554ff08e06a8d419f32c82c6529 (patch) | |
| tree | af5150324b7f3420788a09043608e4bac219dddc /httemplate/search/timeworked.html | |
| parent | e670183bbb184527df5da958acb7a4b5d41ee6ec (diff) | |
add date constratint on time worked search
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'), |