From: ivan <ivan>
Date: Fri, 22 Feb 2008 01:32:10 +0000 (+0000)
Subject: on accounts overview: show time applied after multipliers, not actual time worked
X-Git-Tag: TRIXBOX_2_6~47
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=1853ca72ecbd2d47bc09d196374534ab8ada08ce

on accounts overview: show time applied after multipliers, not actual time worked
---

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