diff options
| author | Dave Lawrence <dlawrence@mozilla.com> | 2012-12-08 00:02:03 +0100 |
|---|---|---|
| committer | Dave Lawrence <dlawrence@mozilla.com> | 2012-12-08 00:02:03 +0100 |
| commit | 102c9694ef56fd673fe31729e67b650befb9df44 (patch) | |
| tree | da54e655fa5a0e57b13b0c9ddad3ebafe471dc57 /extensions/MyDashboard/lib | |
| parent | 6827b1d3d99e4e05fc2012896c9e2d941297b7ed (diff) | |
| download | bugzilla-102c9694ef56fd673fe31729e67b650befb9df44.tar.gz bugzilla-102c9694ef56fd673fe31729e67b650befb9df44.tar.xz | |
Current dashboard work
Diffstat (limited to 'extensions/MyDashboard/lib')
| -rw-r--r-- | extensions/MyDashboard/lib/Queries.pm | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/extensions/MyDashboard/lib/Queries.pm b/extensions/MyDashboard/lib/Queries.pm index cbba3b468..628e26a73 100644 --- a/extensions/MyDashboard/lib/Queries.pm +++ b/extensions/MyDashboard/lib/Queries.pm @@ -12,6 +12,7 @@ use strict; use Bugzilla; use Bugzilla::CGI; use Bugzilla::Search; +use Bugzilla::Util qw(format_time); use Bugzilla::Extension::MyDashboard::Util qw(open_states quoted_open_states); use Bugzilla::Extension::MyDashboard::TimeAgo qw(time_ago); @@ -136,7 +137,6 @@ sub query_bugs { my $search = new Bugzilla::Search( fields => [ SELECT_COLUMNS ], params => scalar $params->Vars, - order => [ QUERY_ORDER ]); my $query = $search->sql(); @@ -149,10 +149,11 @@ sub query_bugs { my $bug = {}; foreach my $column (SELECT_COLUMNS) { $bug->{$column} = shift @$row; - #if ($column eq 'changeddate') { + if ($column eq 'changeddate') { + $bug->{$column} = format_time($bug->{$column}, '%Y-%m-%d %H:%M'); # my $date_then = datetime_from($bug->{$column}); # $bug->{'updated'} = time_ago($date_then, $date_now); - #} + } } push(@bugs, $bug); } @@ -185,7 +186,7 @@ sub query_flags { attachments.description AS attach_summary, requesters.realname AS requester, requestees.realname AS requestee, - " . $dbh->sql_date_format('flags.creation_date', '%Y:-%m-%d %H:%i') . " AS created + " . $dbh->sql_date_format('flags.creation_date', '%Y-%m-%d %H:%i') . " AS created FROM flags LEFT JOIN attachments ON ($attach_join_clause) |