%# BEGIN BPS TAGGED BLOCK {{{ %# %# COPYRIGHT: %# %# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC %# %# %# (Except where explicitly superseded by other copyright notices) %# %# %# LICENSE: %# %# This work is made available to you under the terms of Version 2 of %# the GNU General Public License. A copy of that license should have %# been provided with this software, but in any event can be snarfed %# from www.gnu.org. %# %# This work is distributed in the hope that it will be useful, but %# WITHOUT ANY WARRANTY; without even the implied warranty of %# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU %# General Public License for more details. %# %# You should have received a copy of the GNU General Public License %# along with this program; if not, write to the Free Software %# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA %# 02110-1301 or visit their web page on the internet at %# http://www.gnu.org/licenses/old-licenses/gpl-2.0.html. %# %# %# CONTRIBUTION SUBMISSION POLICY: %# %# (The following paragraph is not intended to limit the rights granted %# to you to modify and distribute this software under the terms of %# the GNU General Public License and is only of importance to you if %# you choose to contribute your changes and enhancements to the %# community by submitting them to Best Practical Solutions, LLC.) %# %# By intentionally submitting any modifications, corrections or %# derivatives to this work, or any other work intended for use with %# Request Tracker, to Best Practical Solutions, LLC, you confirm that %# you are the copyright holder for those contributions and you grant %# Best Practical Solutions, LLC a nonexclusive, worldwide, irrevocable, %# royalty-free, perpetual, license to use, copy, create derivative %# works based on those contributions, and sublicense and distribute %# those contributions and any derivatives thereof. %# %# END BPS TAGGED BLOCK }}} <%args> $Query => "id > 0" $PrimaryGroupBy => 'Queue' $ChartStyle => 'bar' <%init> use RT::Report::Tickets; $PrimaryGroupBy ||= 'Queue'; # make sure PrimaryGroupBy is not undef my $tix = RT::Report::Tickets->new( $session{'CurrentUser'} ); my %AllowedGroupings = reverse $tix->Groupings( Query => $Query ); $PrimaryGroupBy = 'Queue' unless exists $AllowedGroupings{$PrimaryGroupBy}; my ($count_name, $value_name) = $tix->SetupGroupings( Query => $Query, GroupBy => $PrimaryGroupBy, ); my %class = ( Queue => 'RT::Queue', Owner => 'RT::User', Creator => 'RT::User', LastUpdatedBy => 'RT::User', ); my $class = $class{ $PrimaryGroupBy }; my (@keys, @values); while ( my $entry = $tix->Next ) { if ($class) { my $q = $class->new( $session{'CurrentUser'} ); $q->Load( $entry->LabelValue( $value_name ) ); push @keys, $q->Name; } else { push @keys, $entry->LabelValue( $value_name ); } $keys[-1] ||= loc('(no value)'); push @values, $entry->__Value( $count_name ); } my %data; my %loc_keys; foreach my $key (@keys) { $data{$key} = shift @values; $loc_keys{$key} = loc($key); } my @sorted_keys = map { $loc_keys{$_}} sort { $loc_keys{$a} cmp $loc_keys{$b} } keys %loc_keys; my @sorted_values = map { $data{$_}} sort { $loc_keys{$a} cmp $loc_keys{$b} } keys %loc_keys; my $query_string = $m->comp('/Elements/QueryString', %ARGS); my ($i,$total);
% if (RT->Config->Get('DisableGD')) { <% loc('Graphical charts are not available.') %>
% } else { % }
<%perl> while (my $key = shift @sorted_keys) { $i++; my $value = shift @sorted_values; $total += $value; <%perl> # TODO sadly we don't have "creator.city is null" or alike support yet # so no link if the key is undef for now if ( $PrimaryGroupBy !~ /(Hourly|Daily|Monthly|Annually)$/ && $key ne loc('(no value)') ) { my $group = $PrimaryGroupBy; $group =~ s! !.!; my %orig_keys = reverse %loc_keys; my $QueryString = $m->comp('/Elements/QueryString', Query => "$Query and $group = '$orig_keys{$key}'", Format => $ARGS{Format}, Rows => $ARGS{Rows}, OrderBy => $ARGS{OrderBy}, Order => $ARGS{Order}, ); % } else { % } % } %$i++;
<% loc($tix->Label($PrimaryGroupBy)) %> <&|/l&>Tickets
Config->Get('WebPath') %>/Search/Results.html?<%$QueryString%>><%$key%> Config->Get('WebPath') %>/Search/Results.html?<%$QueryString%>><%$value%> <% $key %> <% $value %>
<%loc('Total')%> <%$total||'0'%>
<% loc('Query') %>:<% $Query %>