summaryrefslogtreecommitdiff
path: root/httemplate/search/svc_acct.cgi
diff options
context:
space:
mode:
authorivan <ivan>2008-02-22 01:32:10 +0000
committerivan <ivan>2008-02-22 01:32:10 +0000
commit1853ca72ecbd2d47bc09d196374534ab8ada08ce (patch)
tree86e1feeff1082091e2186ff531f5628579b527d7 /httemplate/search/svc_acct.cgi
parentea811d7900590c66ed62b56c889c1042897e87e3 (diff)
on accounts overview: show time applied after multipliers, not actual time worked
Diffstat (limited to 'httemplate/search/svc_acct.cgi')
-rwxr-xr-xhttemplate/search/svc_acct.cgi14
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