From 64cff83a723d02a3064e08d4e69c13f9b43fed58 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Wed, 29 Sep 2010 19:54:55 +0000
Subject: [PATCH] fix time worked search by customer

---
 httemplate/search/rt_transaction.html | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/httemplate/search/rt_transaction.html b/httemplate/search/rt_transaction.html
index 8bf193c9a..fb828af84 100644
--- 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*$/ ) {
-  $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 = {
@@ -100,7 +100,7 @@ my $query = {
                    'Tickets.Subject',
                    'Users.name AS otaker',
                    "$transactiontime AS transaction_time",
-                   '( SELECT SUM(support) from acct_rt_transaction where Transaction_id = Transactions.id ) AS support',
+                   '( SELECT SUM(support) from acct_rt_transaction where transaction_id = Transactions.id ) AS support',
                  ),
   'table'     => 'transactions', #Pg-ism
   #'table'     => 'Transactions',
-- 
2.11.0