projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (from parent 1:
700eefa
)
fix time worked search by customer
author
ivan
<ivan>
Wed, 29 Sep 2010 19:54:55 +0000
(19:54 +0000)
committer
ivan
<ivan>
Wed, 29 Sep 2010 19:54:55 +0000
(19:54 +0000)
httemplate/search/rt_transaction.html
patch
|
blob
|
history
diff --git
a/httemplate/search/rt_transaction.html
b/httemplate/search/rt_transaction.html
index
8bf193c
..
fb828af
100644
(file)
--- a/
httemplate/search/rt_transaction.html
+++ b/
httemplate/search/rt_transaction.html
@@
-90,7
+90,7
@@
if ( $cgi->param('ticketid') =~ /^\s*(\d+)\s*$/ ) {
}
if ( $cgi->param('svcnum') =~ /^\s*(\d+)\s*$/ ) {
}
if ( $cgi->param('svcnum') =~ /^\s*(\d+)\s*$/ ) {
- $where .= " AND
acct_rt_transaction.svcnum = $1
";
+ $where .= " AND
EXISTS( SELECT 1 FROM acct_rt_transaction WHERE acct_rt_transaction.transaction_id = Transactions.id AND svcnum = $1 )
";
}
my $query = {
}
my $query = {
@@
-100,7
+100,7
@@
my $query = {
'Tickets.Subject',
'Users.name AS otaker',
"$transactiontime AS transaction_time",
'Tickets.Subject',
'Users.name AS otaker',
"$transactiontime AS transaction_time",
- '( SELECT SUM(support) from acct_rt_transaction where
T
ransaction_id = Transactions.id ) AS support',
+ '( SELECT SUM(support) from acct_rt_transaction where
t
ransaction_id = Transactions.id ) AS support',
),
'table' => 'transactions', #Pg-ism
#'table' => 'Transactions',
),
'table' => 'transactions', #Pg-ism
#'table' => 'Transactions',