on accounts overview: show time applied after multipliers, not actual time worked
authorivan <ivan>
Fri, 22 Feb 2008 00:54:15 +0000 (00:54 +0000)
committerivan <ivan>
Fri, 22 Feb 2008 00:54:15 +0000 (00:54 +0000)
httemplate/search/svc_acct.cgi

index afdc5da..fb9ce8a 100755 (executable)
@@ -35,8 +35,10 @@ sub timelast {
   ";
 
   #Transactions
+#  my $sql = "
+#    SELECT SUM($transactiontime) FROM acct_rt_transaction
   my $sql = "
-    SELECT SUM($transactiontime) FROM acct_rt_transaction
+    SELECT SUM(support) FROM acct_rt_transaction
       LEFT JOIN Transactions
         ON Transactions.Id = acct_rt_transaction.transaction_id
     WHERE svcnum = ?