From aed743e23b791f39cd3d31629fe65a36a623739f Mon Sep 17 00:00:00 2001
From: Byron Jones <bjones@mozilla.com>
Date: Thu, 12 Jan 2012 23:11:15 +0800
Subject: Bug 715424: show both the insert time and run time for queued mail

---
 extensions/BMO/lib/Reports.pm | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'extensions/BMO/lib/Reports.pm')

diff --git a/extensions/BMO/lib/Reports.pm b/extensions/BMO/lib/Reports.pm
index aa7ca5690..e9e2670b9 100644
--- a/extensions/BMO/lib/Reports.pm
+++ b/extensions/BMO/lib/Reports.pm
@@ -573,7 +573,8 @@ sub email_queue_report {
 
     my $query = "
         SELECT j.jobid,
-               j.run_after AS timestamp,
+               j.insert_time,
+               j.run_after AS run_time,
                COUNT(e.jobid) AS error_count,
                MAX(e.error_time) AS error_time,
                e.message AS error_message
@@ -583,6 +584,7 @@ sub email_queue_report {
       ORDER BY j.run_after";
 
     $vars->{'jobs'} = $dbh->selectall_arrayref($query, { Slice => {} });
+    $vars->{'now'} = (time);
 }
 
 1;
-- 
cgit v1.2.3-24-g4f1b