diff options
Diffstat (limited to 'rt/share/html/Tools/Reports')
| -rw-r--r-- | rt/share/html/Tools/Reports/CreatedByDates.html | 94 | ||||
| -rw-r--r-- | rt/share/html/Tools/Reports/Elements/Tabs | 89 | ||||
| -rw-r--r-- | rt/share/html/Tools/Reports/ResolvedByDates.html | 95 | ||||
| -rw-r--r-- | rt/share/html/Tools/Reports/ResolvedByOwner.html | 70 | ||||
| -rw-r--r-- | rt/share/html/Tools/Reports/index.html | 76 |
5 files changed, 424 insertions, 0 deletions
diff --git a/rt/share/html/Tools/Reports/CreatedByDates.html b/rt/share/html/Tools/Reports/CreatedByDates.html new file mode 100644 index 000000000..9ca69557e --- /dev/null +++ b/rt/share/html/Tools/Reports/CreatedByDates.html @@ -0,0 +1,94 @@ +%# BEGIN BPS TAGGED BLOCK {{{ +%# +%# COPYRIGHT: +%# +%# This software is Copyright (c) 1996-2009 Best Practical Solutions, LLC +%# <jesse@bestpractical.com> +%# +%# (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> +$Queue => undef +$CreatedBefore => undef +$CreatedAfter => undef +</%args> +<%init> +my $title = loc("Created tickets in period, grouped by status"); +my $q = RT::Queue->new($session{'CurrentUser'}); +my $before = RT::Date->new($session{'CurrentUser'}); +my $after = RT::Date->new($session{'CurrentUser'}); +my $query = 'Status != "deleted" '; + + +if ($CreatedAfter) { + $after->Set(Format => 'unknown', Value => $CreatedAfter); + $CreatedAfter = $after->AsString; +} +if ($CreatedBefore) { + $before->Set(Format => 'unknown', Value => $CreatedBefore); + $CreatedBefore = $before->AsString; +} + + +$q->LoadByCols(Name => $Queue); +</%init> +<& /Elements/Header, Title => $title &> +<& /Tools/Reports/Elements/Tabs, current_tab => 'Tools/Reports/CreatedByDates.html', Title => $title &> +<form method="post" action="CreatedByDates.html"> +% if ($Queue|| $CreatedBefore ||$CreatedAfter) { +% # if we have a queue, do the search +% if ($Queue) { $query .= " AND Queue = '$Queue'"} +% if ($CreatedBefore) { $query .= " AND Created < '".$before->ISO."'"; } +% if ($CreatedAfter) { $query .= " AND Created > '".$after->ISO."'"} +% my $groupby = 'Status'; +<& /Search/Elements/Chart, Query => $query, PrimaryGroupBy => $groupby &> +% } + +<hr /> + +<br /><&|/l&>Queue</&>: <& /Elements/SelectQueue, Name => 'Queue', NamedValues => 1, Default => $q->id &> +<br /><&|/l&>Tickets created after</&>: +<& /Elements/SelectDate, Name => 'CreatedAfter', Default => ($CreatedAfter) ? $after->ISO : ''&> +<br /><&|/l&>Tickets created before</&>: +<& /Elements/SelectDate, Name => 'CreatedBefore', Default => ($CreatedBefore) ? $before->ISO : ''&> + +<& /Elements/Submit&> +</form> diff --git a/rt/share/html/Tools/Reports/Elements/Tabs b/rt/share/html/Tools/Reports/Elements/Tabs new file mode 100644 index 000000000..c5faaac11 --- /dev/null +++ b/rt/share/html/Tools/Reports/Elements/Tabs @@ -0,0 +1,89 @@ +%# BEGIN BPS TAGGED BLOCK {{{ +%# +%# COPYRIGHT: +%# +%# This software is Copyright (c) 1996-2009 Best Practical Solutions, LLC +%# <jesse@bestpractical.com> +%# +%# (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 }}} +<& /Tools/Elements/Tabs, + subtabs => $tabs, + current_tab => 'Tools/Reports/index.html', + current_subtab => $current_tab, + Title => $Title &> + +<%INIT> +my $tabs = { + a => { + title => loc('Resolved by owner'), + path => 'Tools/Reports/ResolvedByOwner.html', + }, + b => { + title => loc('Resolved in date range'), + path => 'Tools/Reports/ResolvedByDates.html', + }, + c => { + title => loc('Created in a date range'), + path => 'Tools/Reports/CreatedByDates.html', + }, +}; + + + + +$m->callback( %ARGS, tabs => $tabs ); + +foreach my $tab ( sort keys %{$tabs} ) { + if ( $tabs->{$tab}->{'path'} eq $current_tab ) { + $tabs->{$tab}->{"subtabs"} = $subtabs; + $tabs->{$tab}->{"current_subtab"} = $current_subtab; + } +} +</%INIT> + + +<%ARGS> +$subtabs => undef +$current_tab => '' +$current_subtab => undef +$Title => undef +</%ARGS> diff --git a/rt/share/html/Tools/Reports/ResolvedByDates.html b/rt/share/html/Tools/Reports/ResolvedByDates.html new file mode 100644 index 000000000..455eaedd2 --- /dev/null +++ b/rt/share/html/Tools/Reports/ResolvedByDates.html @@ -0,0 +1,95 @@ +%# BEGIN BPS TAGGED BLOCK {{{ +%# +%# COPYRIGHT: +%# +%# This software is Copyright (c) 1996-2009 Best Practical Solutions, LLC +%# <jesse@bestpractical.com> +%# +%# (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> +$Queue => undef +$ResolvedBefore => undef +$ResolvedAfter => undef +</%args> +<%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); +</%init> +<& /Elements/Header, Title => $title &> +<& /Tools/Reports/Elements/Tabs, current_tab => 'Tools/Reports/ResolvedByDates.html', Title => $title &> +<form method="post" action="ResolvedByDates.html"> +% 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 &> +% } + +<hr /> + +<br /><&|/l&>Queue</&>: <& /Elements/SelectQueue, Name => 'Queue', NamedValues => 1, Default => $q->id &> +<br /><&|/l&>Tickets resolved after</&>: +<& /Elements/SelectDate, Name => 'ResolvedAfter', Default => ($ResolvedAfter) ? $after->ISO : ''&> +<br /><&|/l&>Tickets resolved before</&>: +<& /Elements/SelectDate, Name => 'ResolvedBefore', Default => ($ResolvedBefore) ? $before->ISO : ''&> + +<& /Elements/Submit&> +</form> diff --git a/rt/share/html/Tools/Reports/ResolvedByOwner.html b/rt/share/html/Tools/Reports/ResolvedByOwner.html new file mode 100644 index 000000000..00005340d --- /dev/null +++ b/rt/share/html/Tools/Reports/ResolvedByOwner.html @@ -0,0 +1,70 @@ +%# BEGIN BPS TAGGED BLOCK {{{ +%# +%# COPYRIGHT: +%# +%# This software is Copyright (c) 1996-2009 Best Practical Solutions, LLC +%# <jesse@bestpractical.com> +%# +%# (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> +$Queue => undef +</%args> +<%init> +my $title = loc("Resolved tickets, grouped by owner"); +my $q = RT::Queue->new($session{'CurrentUser'}); +$q->LoadByCols(Name => $Queue); +</%init> +<& /Elements/Header, Title => $title &> +<& /Tools/Reports/Elements/Tabs, current_tab => '/Tools/Reports/ResolvedByOwner.html', Title => $title &> +<form method="post" action="ResolvedByOwner.html"> +% if ($Queue) { +% # if we have a queue, do the search +% my $query = "Status = 'resolved' AND Queue = '$Queue'"; +% my $groupby = 'Owner'; +<& /Search/Elements/Chart, Query => $query, PrimaryGroupBy => $groupby &> +% } + +<hr /> + +<&|/l&>Queue</&>: <& /Elements/SelectQueue, Name => 'Queue', NamedValues => 1, Default => $q->id &> +<& /Elements/Submit&> +</form> diff --git a/rt/share/html/Tools/Reports/index.html b/rt/share/html/Tools/Reports/index.html new file mode 100644 index 000000000..d534fad6e --- /dev/null +++ b/rt/share/html/Tools/Reports/index.html @@ -0,0 +1,76 @@ +%# BEGIN BPS TAGGED BLOCK {{{ +%# +%# COPYRIGHT: +%# +%# This software is Copyright (c) 1996-2009 Best Practical Solutions, LLC +%# <jesse@bestpractical.com> +%# +%# (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 }}} +<& /Elements/Header, Title => loc('Reports') &> +<& /Tools/Reports/Elements/Tabs, Title => loc('Reports') &> +<& /Elements/ListMenu, items => $tabs &> + +% $m->callback; + +<%init> + +my $tabs = { + A => { + title => loc('Resolved by owner'), + path => '/Tools/Reports/ResolvedByOwner.html', + description => loc('Examine tickets resolved in a queue, grouped by owner'), + }, + B => { + title => loc('Resolved in date range'), + path => '/Tools/Reports/ResolvedByDates.html', + description => loc('Examine tickets resolved in a queue between two dates'), + }, + C => { + title => loc('Created in a date range'), + path => '/Tools/Reports/CreatedByDates.html', + description => loc('Examine tickets created in a queue between two dates'), + }, +}; + +$m->callback( CallbackName => 'ListReports', %ARGS, tabs => $tabs ); + +</%init> |