projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
a5d246c
)
on accounts overview: show time applied after multipliers, not actual time worked
author
ivan
<ivan>
Fri, 22 Feb 2008 00:54:15 +0000
(
00:54
+0000)
committer
ivan
<ivan>
Fri, 22 Feb 2008 00:54:15 +0000
(
00:54
+0000)
httemplate/search/svc_acct.cgi
patch
|
blob
|
history
diff --git
a/httemplate/search/svc_acct.cgi
b/httemplate/search/svc_acct.cgi
index
afdc5da
..
fb9ce8a
100755
(executable)
--- a/
httemplate/search/svc_acct.cgi
+++ b/
httemplate/search/svc_acct.cgi
@@
-35,8
+35,10
@@
sub timelast {
";
#Transactions
";
#Transactions
+# my $sql = "
+# SELECT SUM($transactiontime) FROM acct_rt_transaction
my $sql = "
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 = ?
LEFT JOIN Transactions
ON Transactions.Id = acct_rt_transaction.transaction_id
WHERE svcnum = ?