From 1853ca72ecbd2d47bc09d196374534ab8ada08ce Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 22 Feb 2008 01:32:10 +0000 Subject: [PATCH] on accounts overview: show time applied after multipliers, not actual time worked --- httemplate/search/svc_acct.cgi | 14 -------------- 1 file changed, 14 deletions(-) diff --git a/httemplate/search/svc_acct.cgi b/httemplate/search/svc_acct.cgi index fb9ce8aec..c2b3d8fa0 100755 --- a/httemplate/search/svc_acct.cgi +++ b/httemplate/search/svc_acct.cgi @@ -23,20 +23,6 @@ sub format_time { sub timelast { my( $svc_acct, $last, $permonth ) = @_; - #some false laziness w/search/rt_transaction.html - - my $transactiontime = " - CASE transactions.type when 'Set' - THEN ( to_number(newvalue, '999999') - - to_number(oldvalue, '999999') - ) * 60 - ELSE timetaken*60 - END - "; - - #Transactions -# my $sql = " -# SELECT SUM($transactiontime) FROM acct_rt_transaction my $sql = " SELECT SUM(support) FROM acct_rt_transaction LEFT JOIN Transactions -- 2.11.0