#############################################################################
#
# Template Name:  Resolved
# Description:    Create E-mail content to include Ticket Description and
#                 resolution comment.
#
# Written:        Vanilla
#
# Modified:       05/18/2006 - Anthony Lincoln/added resolution comment
# Modified:       08/14/2007 - Wil Hubert/added ticket description
# Modified:       03/07/2007 - Kenn Crocker/modified flower box
# Modified:       04/16/2007 - Kenn Crocker/modified Displayed ticket info 
#
#############################################################################
#
#  CUT AND PASTE CODE BELOW ONLY!!  #
#
Subject: Ticket Resolved!

This ticket has been resolved. DO NOT reply to this message!
-----------------------------------------------------------------------------
TICKET INFORMATION:

Ticket Number : {$Ticket->Id}

Ticket Subject: {$Ticket->Subject}

Ticket Description:
     {
     my $Ticket_Description;
     $Ticket_Description = $Ticket->FirstCustomFieldValue('Description');
     return $Ticket_Description;
     }

Ticket Priority is: {$Ticket->Priority}

Ticket Created  by: {$Ticket->CreatorObj->Name}

Ticket Created  on: {substr($Ticket->Created, 0, 10)}
 
Ticket  Owned   by: {$Ticket->OwnerObj->Name}

Development Started on: {substr($Ticket->Started, 0, 10)}

QA Started  on: N/A

QA Approved by: N/A

Migrated    on: {substr($Ticket->Resolved, 0, 10)}

Migrated    by: {$Ticket->LastUpdatedByObj->Name}

Resolution comment:
{
      my $Resolution_Comment;
      my $Transactions;
      my $CommentObj;

      $Transactions = $Ticket->Transactions;
      $Transactions->Limit( FIELD => 'Type', VALUE => 'Comment' );
      $Transactions->OrderByCols(
          { FIELD => 'Created',  ORDER => 'DESC' },
          { FIELD => 'id',     ORDER => 'DESC' },
          );

      $CommentObj = $Transactions->First;

      if  ($CommentObj && $CommentObj->id)
      {
           $Resolution_Comment = $CommentObj->Content;
      }
      else
      {
           $Resolution_Comment = "No comment."
      }

      return $Resolution_Comment;
} 
-----------------------------------------------------------------------------
To view ticket information, enter URL:

    {$RT::WebURL}Ticket/Display.html?id={$Ticket->id}