diff options
author | ivan <ivan> | 2008-02-22 01:32:10 +0000 |
---|---|---|
committer | ivan <ivan> | 2008-02-22 01:32:10 +0000 |
commit | 1853ca72ecbd2d47bc09d196374534ab8ada08ce (patch) | |
tree | 86e1feeff1082091e2186ff531f5628579b527d7 /httemplate/search/svc_acct.cgi | |
parent | ea811d7900590c66ed62b56c889c1042897e87e3 (diff) |
on accounts overview: show time applied after multipliers, not actual time worked
Diffstat (limited to 'httemplate/search/svc_acct.cgi')
-rwxr-xr-x | httemplate/search/svc_acct.cgi | 14 |
1 files changed, 0 insertions, 14 deletions
diff --git a/httemplate/search/svc_acct.cgi b/httemplate/search/svc_acct.cgi index fb9ce8a..c2b3d8f 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 |