diff options
| author | ivan <ivan> | 2008-02-22 00:54:15 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2008-02-22 00:54:15 +0000 |
| commit | cd6a49deff31eb40300317cb4416a51707378316 (patch) | |
| tree | f76245290dd425926e631c7bad2a4b508dd01c88 /httemplate/search/svc_acct.cgi | |
| parent | a5d246c0bca64e24b7fd933bed27fc0c99be8c36 (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 | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/httemplate/search/svc_acct.cgi b/httemplate/search/svc_acct.cgi index afdc5da47..fb9ce8aec 100755 --- a/httemplate/search/svc_acct.cgi +++ b/httemplate/search/svc_acct.cgi @@ -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 = ? |