diff options
| author | cvs2git <cvs2git> | 2010-12-27 00:04:45 +0000 |
|---|---|---|
| committer | cvs2git <cvs2git> | 2010-12-27 00:04:45 +0000 |
| commit | c82d349f864e6bd9f96fd1156903bc1f7193a203 (patch) | |
| tree | e117a87533656110b6acd56fc0ca64289892a9f5 /rt/html/Reports/Activity/ActivitySummary.html | |
| parent | 74e058c8a010ef6feb539248a550d0bb169c1e94 (diff) | |
This commit was manufactured by cvs2svn to create tag 'TORRUS_1_0_9'.TORRUS_1_0_9
Diffstat (limited to 'rt/html/Reports/Activity/ActivitySummary.html')
| -rw-r--r-- | rt/html/Reports/Activity/ActivitySummary.html | 61 |
1 files changed, 0 insertions, 61 deletions
diff --git a/rt/html/Reports/Activity/ActivitySummary.html b/rt/html/Reports/Activity/ActivitySummary.html deleted file mode 100644 index 7bb756fbc..000000000 --- a/rt/html/Reports/Activity/ActivitySummary.html +++ /dev/null @@ -1,61 +0,0 @@ -<&|Elements/Wrapper, %ARGS, title => loc("Activity summary"), - path => "Reports/Activity/ActivitySummary.html", - &> - -<& Elements/MiniPlot, data => \%queues &> - -<table style="width: 100%"> -<tr class="titlerow"> -<th>Queue</th> -% for my $status (sort keys %status) { -<th><% $status %></th> -% } -<th>Total</th> -</tr> -% for my $queue (sort keys %queues) { -<th class="label"><% $queue %></th> -% for my $status (sort keys %status) { -<td><% $queues{$queue}{$status} || 0 %> -% } -<td><% $total{$queue} %></td> -</tr> -% } -<tr class="grandtotal"> -<th class="label" >Grand Total</th> -% for my $status (sort keys %status) { -<td><% $status{$status} %></td> -% } -<td><% $total %></td> -</table> -</&> -<%args> -$query => 'id > 0' -$start => "2005/01/01" -$end => "2006/01/01" -</%args> -<%init> - -my $tickets = RT::Tickets->new($session{'CurrentUser'}); -$tickets->FromSQL($query . " AND ( Updated >= '$start' AND Updated <= '$end')"); - -my %queues; -my %status; -my %total; -my $total; -while (my $ticket = $tickets->Next) { - my $txns = $ticket->Transactions; - $txns->Limit(FIELD => 'Created', OPERATOR => '>=', VALUE => $start); - $txns->Limit(FIELD => 'Created', OPERATOR => '<=', VALUE => $end); - $txns->Limit(FIELD => 'Type', VALUE => 'Status', ENTRYAGGREGATOR => 'OR'); - $txns->Limit(FIELD => 'Type', VALUE => 'Create'); - - while (my $txn = $txns->Next) { - $queues{$txn->TicketObj->QueueObj->Name}{$txn->NewValue || 'new'}++; - $status{$txn->NewValue || 'new'}++; - $total{$txn->TicketObj->QueueObj->Name}++; - $total++; - } -} - - -</%init> |