projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
5bbee27
)
almost could work under mysql? need TO_NUMBER and TO_CHAR equivalents
author
ivan
<ivan>
Sun, 13 Jan 2008 23:31:22 +0000
(23:31 +0000)
committer
ivan
<ivan>
Sun, 13 Jan 2008 23:31:22 +0000
(23:31 +0000)
httemplate/search/timeworked.html
patch
|
blob
|
history
diff --git
a/httemplate/search/timeworked.html
b/httemplate/search/timeworked.html
index
b3b31b4
..
49173bd
100644
(file)
--- a/
httemplate/search/timeworked.html
+++ b/
httemplate/search/timeworked.html
@@
-56,60
+56,60
@@
die "access denied"
my @groupby = ();
my $transactiontime = "
my @groupby = ();
my $transactiontime = "
- CASE
transactions.type when
'Set'
- THEN (
to_number(newvalue,'999999')-to_number(oldv
alue, '999999')) * 60
- ELSE
timet
aken*60
+ CASE
Transactions.Type WHEN
'Set'
+ THEN (
TO_NUMBER(NewValue,'999999')-TO_NUMBER(OldV
alue, '999999')) * 60
+ ELSE
TimeT
aken*60
END
";
push @groupby, qw( transactions.type newvalue oldvalue timetaken );
END
";
push @groupby, qw( transactions.type newvalue oldvalue timetaken );
-my $appliedtimeclause = "
coalesce (sum
(acct_rt_transaction.seconds), 0)";
+my $appliedtimeclause = "
COALESCE (SUM
(acct_rt_transaction.seconds), 0)";
my $appliedtimeselect = "
my $appliedtimeselect = "
-
coalesce
(
- ( SELECT
sum
(seconds) FROM acct_rt_transaction
- WHERE transaction_id =
t
ransactions.id
+
COALESCE
(
+ ( SELECT
SUM
(seconds) FROM acct_rt_transaction
+ WHERE transaction_id =
T
ransactions.id
),
0
)
";
),
0
)
";
-push @groupby, "
t
ransactions.id";
+push @groupby, "
T
ransactions.id";
my $wheretimeleft = "$transactiontime != $appliedtimeselect";
my $wheretimeleft = "$transactiontime != $appliedtimeselect";
-push @groupby, "
t
ickets.id";
-push @groupby, "
tickets.s
ubject";
-push @groupby, "
transactions.c
reated";
+push @groupby, "
T
ickets.id";
+push @groupby, "
Tickets.S
ubject";
+push @groupby, "
Transactions.C
reated";
my $groupby = join(',', @groupby);
my $where = "
my $groupby = join(',', @groupby);
my $where = "
- WHERE
objectt
ype='RT::Ticket'
- AND ( (
transactions.type='Set' AND f
ield='TimeWorked' )
- OR
transactions.t
ype='Comment'
- OR
transactions.t
ype='Correspond'
+ WHERE
ObjectT
ype='RT::Ticket'
+ AND ( (
Transactions.Type='Set' AND F
ield='TimeWorked' )
+ OR
Transactions.T
ype='Comment'
+ OR
Transactions.T
ype='Correspond'
)
AND $wheretimeleft
";
#AND $wheretimeleft
my $query = "
)
AND $wheretimeleft
";
#AND $wheretimeleft
my $query = "
- SELECT
tickets.id, tickets.s
ubject,
-
to_char(transactions.c
reated, 'Dy Mon DD HH24:MI:SS YYYY'),
+ SELECT
Tickets.id, Tickets.S
ubject,
+
TO_CHAR(Transactions.C
reated, 'Dy Mon DD HH24:MI:SS YYYY'),
$transactiontime-$appliedtimeclause,
$transactiontime-$appliedtimeclause,
-
t
ransactions.id
- FROM
t
ransactions
- JOIN
tickets ON transactions.objectid = t
ickets.id
+
T
ransactions.id
+ FROM
T
ransactions
+ JOIN
Tickets ON Transactions.ObjectId = T
ickets.id
LEFT JOIN acct_rt_transaction
LEFT JOIN acct_rt_transaction
- ON
t
ransactions.id = acct_rt_transaction.transaction_id
+ ON
T
ransactions.id = acct_rt_transaction.transaction_id
$where
GROUP BY $groupby
$where
GROUP BY $groupby
- ORDER BY
transactions.c
reated
+ ORDER BY
Transactions.C
reated
";
";
-my $count_query = "SELECT COUNT(*) FROM
t
ransactions $where";
+my $count_query = "SELECT COUNT(*) FROM
T
ransactions $where";
my $link = [ "${p}rt/Ticket/Display.html?id=", sub { shift->[0]; } ];
my $link = [ "${p}rt/Ticket/Display.html?id=", sub { shift->[0]; } ];