X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=rt%2Fshare%2Fhtml%2FElements%2FShowReminders;h=d9a3ccc30eff4a7840b34656be4f42d239e33d17;hp=34cde464ac17ad10bac17372bc7206d45a258da7;hb=44dd00a3ff974a17999e86e64488e996edc71e3c;hpb=a6fe07e49e3fc12169e801b1ed6874c3a5bd8500 diff --git a/rt/share/html/Elements/ShowReminders b/rt/share/html/Elements/ShowReminders index 34cde464a..d9a3ccc30 100644 --- a/rt/share/html/Elements/ShowReminders +++ b/rt/share/html/Elements/ShowReminders @@ -2,7 +2,7 @@ %# %# COPYRIGHT: %# -%# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC +%# This software is Copyright (c) 1996-2019 Best Practical Solutions, LLC %# %# %# (Except where explicitly superseded by other copyright notices) @@ -57,16 +57,17 @@ my $i =0; while ( my $reminder = $reminders->Next ) { $i++; my $dueobj = $reminder->DueObj; -my $overdue = $dueobj->Unix > 0 && $dueobj->Diff < 0 ? 1 : 0; +my $overdue = $dueobj->IsSet && $dueobj->Diff < 0 ? 1 : 0; my $targets = RT::Tickets->new($session{'CurrentUser'}); +$targets->{'allow_deleted_search'} = 1; $targets->FromSQL( "ReferredToBy = " . $reminder->id ); if ( my $ticket= $targets->First ) { -<% $reminder->Subject %> +<% $reminder->Subject %> <% $overdue ? '' : '' |n %><% $dueobj->AgeAsString || loc('Not set') %><% $overdue ? '' : '' |n %> @@ -75,7 +76,7 @@ if ( my $ticket= $targets->First ) { #<% $ticket->Id %>: <% $ticket->Subject %> % } else { -
Couldn't find Ticket for reminder <% $reminder->id %>. Please contact administrator.
% } @@ -90,7 +91,7 @@ my $tsql = 'Type = "reminder"' . ' AND ( Owner = "Nobody" OR Owner ="' . $session{'CurrentUser'}->id . '")' . ' AND ( Status = "new" OR Status = "open" )'; -$tsql .= ' AND Due < "now"' if $OnlyOverdue; +$tsql .= ' AND ( Due < "now" OR Due IS NULL )' if $OnlyOverdue; $reminders->FromSQL($tsql); $reminders->OrderBy( FIELD => 'Due', ORDER => 'ASC' );