%# BEGIN BPS TAGGED BLOCK {{{
%#
%# COPYRIGHT:
%#
%# This software is Copyright (c) 1996-2018 Best Practical Solutions, LLC
%#                                          <sales@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 }}}
<table valign="top">

% for my $o (0..3) {
% $Order[$o] ||= ''; $OrderBy[$o] ||= '';
<tr>
<td class="label">
% if ($o == 0) {
<&|/l&>Order by</&>:
% }
</td>
<td class="value">
<select name="OrderBy">
% if ($o > 0) {
<option value=""><&|/l&>~[none~]</&></option>
% }
% # %fields maps display name to SQL column/function
% foreach my $field (sort keys %fields) {
%    next unless $field;
%    my $fieldval = $fields{$field};
<option value="<%$fieldval%>"
% if (defined $OrderBy[$o] and $fieldval eq $OrderBy[$o]) {
selected="selected"
% }
><% $field =~ /^(?:CustomField|CF)\./ ? $field : loc($field) %></option>
% }
</select>
<select name="Order">
<option value="ASC"
% unless ( ($Order[$o]||'') eq "DESC" ) {
selected="selected"
% }
><&|/l&>Asc</&></option>
<option value="DESC"
% if ( ($Order[$o]||'') eq "DESC" ) {
selected="selected"
% }
><&|/l&>Desc</&></option>
</select>
</td>
</tr>
% }
<tr>
<td class="label">
<&|/l&>Rows per page</&>:
</td><td class="value">
<& /Elements/SelectResultsPerPage, 
    Name => "RowsPerPage", 
    Default => $RowsPerPage &>
</td>
</tr>
</table>

<%INIT>
my $tickets = RT::Tickets->new($session{'CurrentUser'});
my %FieldDescriptions = %{$tickets->FIELDS};
my %fields;

for my $field (keys %FieldDescriptions) {
    next if $field eq 'EffectiveId';
    next unless $FieldDescriptions{$field}->[0] =~ /^(?:ENUM|INT|DATE|STRING|ID)$/;
    $fields{$field} = $field;
}

$fields{'Owner'} = 'Owner';
$fields{ $_ . '.EmailAddress' } = $_ . '.EmailAddress'
    for qw(Requestor Cc AdminCc);

# Add all available CustomFields to the list of sortable columns.
my @cfs = grep /^CustomField/, @{$ARGS{AvailableColumns}};
$fields{$_} = $_ for @cfs;

# Add PAW sort
$fields{'Custom.Ownership'} = 'Custom.Ownership';

$fields{"Customer.$_"} = 1 foreach qw( Number Name ); #Freeside

$m->callback(CallbackName => 'MassageSortFields', Fields => \%fields );

my @Order = split /\|/, $Order;
my @OrderBy = split /\|/, $OrderBy;
if ($Order =~ /\|/) {
    @Order = split /\|/, $Order;
} else {
    @Order = ( $Order );
}

</%INIT>

<%ARGS>
$Order => ''
$OrderBy => ''
$RowsPerPage => undef
$Format => undef
$GroupBy => 'id'
</%ARGS>