%# BEGIN BPS TAGGED BLOCK {{{ %# %# COPYRIGHT: %# %# This software is Copyright (c) 1996-2022 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 }}} <%init> my $default_value = { Query => 'id > 0', GroupBy => ['Status'], ChartStyle => 'bar+table+sql', ChartFunction => ['COUNT'], }; $m->callback( ARGSRef => \%ARGS, CallbackName => 'Initial' ); my $title = loc( "Grouped search results"); my @search_fields = ( qw(Query GroupBy StackedGroupBy ChartStyle ChartFunction Width Height ExtraQueryParams), @ExtraQueryParams ); my $saved_search = $m->comp( '/Widgets/SavedSearch:new', SearchType => 'Chart', SearchFields => [@search_fields], ); my @actions = $m->comp( '/Widgets/SavedSearch:process', args => \%ARGS, defaults => $default_value, self => $saved_search, ); my %query; { if ($saved_search->{'CurrentSearch'}->{'Object'}) { foreach my $search_field (@{ $saved_search->{'SearchFields'} }) { $query{$search_field} = $saved_search->{'CurrentSearch'}->{'Object'}->Content->{$search_field}; } my $content = $saved_search->{'CurrentSearch'}->{'Object'}->Content; if ( my $extra_params = $content->{ExtraQueryParams} ) { $query{ExtraQueryParams} = $extra_params; for my $param ( ref $extra_params eq 'ARRAY' ? @$extra_params : $extra_params ) { $query{$param} = $content->{$param}; } } } my $current = $session{'CurrentSearchHash'}; my @session_fields = qw( Query SavedChartSearchId SavedSearchDescription SavedSearchLoad SavedSearchLoadButton SavedSearchOwner ); for(@session_fields) { $query{$_} = $DECODED_ARGS->{$_} unless defined $query{$_}; $query{$_} = $current->{$_} unless defined $query{$_}; } if ($DECODED_ARGS->{'SavedSearchLoadSubmit'}) { $query{'SavedChartSearchId'} = $DECODED_ARGS->{'SavedSearchLoad'}; } if ($DECODED_ARGS->{'SavedSearchSave'}) { $query{'SavedChartSearchId'} = $saved_search->{'SearchId'}; } } foreach (@search_fields) { if ( ref $default_value->{$_} ) { $query{$_} = ref $ARGS{$_} ? $ARGS{$_} : [ $ARGS{$_} ]; $query{$_} = $default_value->{$_} unless defined $query{$_} && defined $query{$_}[0]; } else { $query{$_} = ref $ARGS{$_} ? $ARGS{$_} : $ARGS{$_}; $query{$_} = $default_value->{$_} unless defined $query{$_}; } } $m->callback( ARGSRef => \%ARGS, QueryArgsRef => \%query ); <& /Elements/Header, Title => $title &> <& /Elements/Tabs, QueryArgs => \%query &> <& /Elements/ListActions, actions => \@actions &> % $m->callback( ARGSRef => \%ARGS, CallbackName => 'BeforeChart' ); <& /Search/Elements/Chart, %ARGS &> % $m->callback( ARGSRef => \%ARGS, CallbackName => 'AfterChart' );
% if ( $query{ExtraQueryParams} ) { % for my $input ( ref $query{ExtraQueryParams} eq 'ARRAY' ? @{$query{ExtraQueryParams}} : $query{ExtraQueryParams} ) { % if ( defined $query{$input} ) { % } % } % } <&| /Widgets/TitleBox, title => loc('Group by'), class => "chart-group-by" &>
<% loc('Group tickets by') %> <& Elements/SelectGroupBy, Name => 'GroupBy', Query => $query{Query}, Default => $query{'GroupBy'}[0], Stacked => $query{'GroupBy'}[0] eq ($query{StackedGroupBy} // '') ? 1 : 0, StackedId => 'StackedGroupBy-1', &>
<% loc('and then') %> <& Elements/SelectGroupBy, Name => 'GroupBy', Query => $query{Query}, Default => $query{'GroupBy'}[1] // q{}, ShowEmpty => 1, Stacked => $query{'GroupBy'}[1] && ($query{'GroupBy'}[1] eq ($query{StackedGroupBy} // '')) ? 1 : 0, StackedId => 'StackedGroupBy-2', &>
<% loc('and then') %> <& Elements/SelectGroupBy, Name => 'GroupBy', Query => $query{Query}, Default => $query{'GroupBy'}[2] // q{}, ShowEmpty => 1, Stacked => $query{'GroupBy'}[2] && ($query{'GroupBy'}[2] eq ($query{StackedGroupBy} // '')) ? 1 : 0, StackedId => 'StackedGroupBy-3', &>
<&| /Widgets/TitleBox, title => loc("Calculate"), class => "chart-calculate" &>
<% loc('Calculate values of') %> <& Elements/SelectChartFunction, Default => $query{'ChartFunction'}[0] &>
<% loc('and then') %> <& Elements/SelectChartFunction, Default => $query{'ChartFunction'}[1] // q{}, ShowEmpty => 1 &>
<% loc('and then') %> <& Elements/SelectChartFunction, Default => $query{'ChartFunction'}[2] // q{}, ShowEmpty => 1 &>
<&| /Widgets/TitleBox, title => loc('Picture'), class => "chart-picture" &>
<& Elements/SelectChartType, Default => $query{ChartStyle} =~ /^(pie|bar(?:-stacked)?|line(?:-stacked)?|table)\b/ ? $1 : undef &>
<&|/l&>px
×
<&|/l&>px
>
>
<& /Elements/Submit, Label => loc('Update Chart'), Name => 'Update' &>
<%ARGS> @ExtraQueryParams => ()