summaryrefslogtreecommitdiffstats
path: root/extensions/BMO/lib/Reports
diff options
context:
space:
mode:
authorByron Jones <glob@mozilla.com>2015-09-23 05:13:19 +0200
committerByron Jones <glob@mozilla.com>2015-09-23 05:13:19 +0200
commit31142e4bc681d58e14a7fd739edcdb456d5f733d (patch)
tree7623cbc7b1d555fb6760d65ea73b9723bdfaa091 /extensions/BMO/lib/Reports
parentff04d309cd9647aa4eb4d8933296121198507f8a (diff)
downloadbugzilla-31142e4bc681d58e14a7fd739edcdb456d5f733d.tar.gz
bugzilla-31142e4bc681d58e14a7fd739edcdb456d5f733d.tar.xz
Bug 1204645 - the 'last seen' value in the group membership report should use a profile's last-seen date, not the cookie
Diffstat (limited to 'extensions/BMO/lib/Reports')
-rw-r--r--extensions/BMO/lib/Reports/Groups.pm34
1 files changed, 9 insertions, 25 deletions
diff --git a/extensions/BMO/lib/Reports/Groups.pm b/extensions/BMO/lib/Reports/Groups.pm
index d1da19c5a..87aa14a0c 100644
--- a/extensions/BMO/lib/Reports/Groups.pm
+++ b/extensions/BMO/lib/Reports/Groups.pm
@@ -13,7 +13,7 @@ use Bugzilla::Constants;
use Bugzilla::Error;
use Bugzilla::Group;
use Bugzilla::User;
-use Bugzilla::Util qw(trim);
+use Bugzilla::Util qw(trim datetime_from);
use JSON qw(encode_json);
sub admins_report {
@@ -220,29 +220,6 @@ sub members_report {
}
@types = () unless $has_members;
- if (@types) {
- # add last-login
- my $user_ids = join(',', map { map { $_->id } @{ $_->{members} } } @types);
- my $tokens = $dbh->selectall_hashref("
- SELECT profiles.userid,
- (SELECT DATEDIFF(curdate(), logincookies.lastused) lastseen
- FROM logincookies
- WHERE logincookies.userid = profiles.userid
- ORDER BY lastused DESC
- LIMIT 1) lastseen
- FROM profiles
- WHERE userid IN ($user_ids)",
- 'userid');
- foreach my $type (@types) {
- foreach my $member (@{ $type->{members} }) {
- $member->{lastseen} =
- defined $tokens->{$member->id}->{lastseen}
- ? $tokens->{$member->id}->{lastseen}
- : '>' . MAX_LOGINCOOKIE_AGE;
- }
- }
- }
-
if ($page eq 'group_members.json') {
my %users;
foreach my $rh (@types) {
@@ -260,7 +237,7 @@ sub members_report {
if ($privileged) {
$rh_user->{group} = $rh->{name};
$rh_user->{groups} = [ $rh->{name} ];
- $rh_user->{lastseeon} = $member->{lastseen};
+ $rh_user->{lastseeon} = $member->last_seen_date;
$rh_user->{mfa} = $member->mfa;
$rh_user->{api_key_only} = $member->settings->{api_key_only}->{value} eq 'on'
? JSON::true : JSON::false;
@@ -286,6 +263,13 @@ sub members_report {
sub _filter_userlist {
my ($list, $include_disabled) = @_;
$list = [ grep { $_->is_enabled } @$list ] unless $include_disabled;
+ my $now = DateTime->now();
+ foreach my $user (@$list) {
+ my $last_seen = datetime_from($user->last_seen_date);
+ $user->{last_seen_days} = sprintf(
+ '%.0f',
+ $now->subtract_datetime_absolute($last_seen)->delta_seconds / (28 * 60 * 60));
+ }
return [ sort { lc($a->identity) cmp lc($b->identity) } @$list ];
}