%# BEGIN BPS TAGGED BLOCK {{{ %# %# COPYRIGHT: %# %# This software is Copyright (c) 1996-2007 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/copyleft/gpl.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> $Queue => undef $ResolvedBefore => undef $ResolvedAfter => undef <%init> my $title = loc("Resolved tickets in period, grouped by owner"); my $q = RT::Queue->new($session{'CurrentUser'}); my $before = RT::Date->new($session{'CurrentUser'}); my $after = RT::Date->new($session{'CurrentUser'}); my $query = ''; if ($ResolvedAfter) { $after->Set(Format => 'unknown', Value => $ResolvedAfter); $ResolvedAfter = $after->AsString; } if ($ResolvedBefore) { $before->Set(Format => 'unknown', Value => $ResolvedBefore); $ResolvedBefore = $before->AsString; } $q->LoadByCols(Name => $Queue); <& /Elements/Header, Title => $title &> <& /Tools/Reports/Elements/Tabs, current_tab => 'Tools/Reports/ResolvedByDates.html', Title => $title &>
% if ($Queue|| $ResolvedBefore ||$ResolvedAfter) { % # if we have a queue, do the search % $query = "Status = 'resolved'"; % if ($Queue) { $query .= " AND Queue = '$Queue'"} % if ($ResolvedBefore) { $query .= " AND Resolved < '".$before->ISO."'"; } % if ($ResolvedAfter) { $query .= " AND Resolved > '".$after->ISO."'"} % my $groupby = 'Owner'; <& /Search/Elements/Chart, Query => $query, PrimaryGroupBy => $groupby &> % }

<&|/l&>Queue: <& /Elements/SelectQueue, Name => 'Queue', NamedValues => 1, Default => $q->id &>
<&|/l&>Tickets resolved after:
<&|/l&>Tickets resolved before: <& /Elements/Submit&>