projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
ea811d7
)
on accounts overview: show time applied after multipliers, not actual time worked
author
ivan
<ivan>
Fri, 22 Feb 2008 01:32:10 +0000
(
01:32
+0000)
committer
ivan
<ivan>
Fri, 22 Feb 2008 01:32:10 +0000
(
01:32
+0000)
httemplate/search/svc_acct.cgi
patch
|
blob
|
history
diff --git
a/httemplate/search/svc_acct.cgi
b/httemplate/search/svc_acct.cgi
index
fb9ce8a
..
c2b3d8f
100755
(executable)
--- 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 ) = @_;
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
my $sql = "
SELECT SUM(support) FROM acct_rt_transaction
LEFT JOIN Transactions