From f9e05e2778aa373cb29c2cc49a470b184981f24d Mon Sep 17 00:00:00 2001 From: "bbaetz%student.usyd.edu.au" <> Date: Tue, 13 Aug 2002 15:01:58 +0000 Subject: Bug 24823 - show the last modified date at the top of show_bug Patch by vkissoyan@yahoo.com (Vaskin Kissoyan) r=bbaetz x2 --- bug_form.pl | 15 +++++++++++++-- 1 file changed, 13 insertions(+), 2 deletions(-) (limited to 'bug_form.pl') diff --git a/bug_form.pl b/bug_form.pl index fb6a60112..b04208bdf 100644 --- a/bug_form.pl +++ b/bug_form.pl @@ -19,6 +19,7 @@ # # Contributor(s): Terry Weissman # Dave Miller +# Vaskin Kissoyan use diagnostics; use strict; @@ -83,7 +84,7 @@ sub show_bug { bug_file_loc, short_desc, target_milestone, qa_contact, status_whiteboard, date_format(creation_ts,'%Y-%m-%d %H:%i'), - groupset, delta_ts, sum(votes.count) + groupset, delta_ts, sum(votes.count), delta_ts calc_disp_date FROM bugs LEFT JOIN votes USING(bug_id), products, components WHERE bugs.bug_id = $id AND bugs.product_id = products.id @@ -99,15 +100,25 @@ sub show_bug { } my $value; + my $disp_date; my @row = FetchSQLData(); foreach my $field ("bug_id", "alias", "product", "version", "rep_platform", "op_sys", "bug_status", "resolution", "priority", "bug_severity", "component", "assigned_to", "reporter", "bug_file_loc", "short_desc", "target_milestone", "qa_contact", "status_whiteboard", "creation_ts", - "groupset", "delta_ts", "votes") + "groupset", "delta_ts", "votes","calc_disp_date") { $value = shift(@row); + if ($field eq "calc_disp_date") { + # Convert MySQL timestamp (_ts) to datetime format(%Y-%m-%d %H:%i) + $disp_date = substr($value,0,4) . '-'; + $disp_date .= substr($value,4,2) . '-'; + $disp_date .= substr($value,6,2) . ' '; + $disp_date .= substr($value,8,2) . ':'; + $disp_date .= substr($value,10,2); + $value = $disp_date; + } $bug{$field} = defined($value) ? $value : ""; } -- cgit v1.2.3-24-g4f1b