diff options
| author | ivan <ivan> | 2010-06-15 06:06:54 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2010-06-15 06:06:54 +0000 |
| commit | 4f25d34901fb6a358af5b5009608c5162e745042 (patch) | |
| tree | 0111d0289fad66bc315f8ed47114fa88e27f9e1d /httemplate/search/rt_transaction.html | |
| parent | 0c54b74fc47304e2d6e70b604e15ef3827fa59d4 (diff) | |
ticket # and account(customer) options for time worked report
Diffstat (limited to 'httemplate/search/rt_transaction.html')
| -rw-r--r-- | httemplate/search/rt_transaction.html | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/httemplate/search/rt_transaction.html b/httemplate/search/rt_transaction.html index 67048cf35..34fb733a3 100644 --- a/httemplate/search/rt_transaction.html +++ b/httemplate/search/rt_transaction.html @@ -77,6 +77,10 @@ if ( $cgi->param('otaker') && $cgi->param('otaker') =~ /^([\w\.\-]+)$/ ) { $where .= " AND Users.name = '$1' "; } +if ( $cgi->param('ticketid') =~ /^\s*(\d+)\s*$/ ) { + $where .= " AND Tickets.ID = $1"; +} + my $query = { 'select' => "Transactions.*, Tickets.Id AS ticketid, Tickets.Subject, Users.name as otaker, $transactiontime AS transaction_time", #'table' => 'Transactions', |