projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
d59081d
)
fix time worked search when someone edits a value back to blank
author
ivan
<ivan>
Tue, 4 Oct 2011 06:49:07 +0000
(06:49 +0000)
committer
ivan
<ivan>
Tue, 4 Oct 2011 06:49:07 +0000
(06:49 +0000)
httemplate/search/timeworked.html
patch
|
blob
|
history
diff --git
a/httemplate/search/timeworked.html
b/httemplate/search/timeworked.html
index
d07cd4f
..
e810822
100644
(file)
--- a/
httemplate/search/timeworked.html
+++ b/
httemplate/search/timeworked.html
@@
-45,7
+45,9
@@
my @groupby = ();
my $transactiontime = "
CASE Transactions.Type WHEN 'Set'
- THEN (TO_NUMBER(NewValue,'999999')-TO_NUMBER(OldValue, '999999')) * 60
+ THEN ( CASE WHEN NewValue = '' THEN 0 ELSE TO_NUMBER(NewValue,'999999') END
+ -TO_NUMBER(OldValue, '999999')
+ ) * 60
ELSE TimeTaken*60
END
";