Class: Jobs::Tl3Promotions

Inherits:
Scheduled show all
Defined in:
app/jobs/scheduled/tl3_promotions.rb

Instance Method Summary collapse

Methods inherited from Scheduled

#perform

Methods inherited from Base

acquire_cluster_concurrency_lock!, clear_cluster_concurrency_lock!, cluster_concurrency, cluster_concurrency_redis_key, delayed_perform, #error_context, get_cluster_concurrency, #last_db_duration, #log, #perform, #perform_immediately

Instance Method Details

#execute(args) ⇒ Object



7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
# File 'app/jobs/scheduled/tl3_promotions.rb', line 7

def execute(args)
  if SiteSetting.default_trust_level < 3
    # Demotions
    demoted_user_ids = []
    User
      .real
      .joins(
        "LEFT JOIN (SELECT gu.user_id, MAX(g.grant_trust_level) AS group_granted_trust_level FROM groups g, group_users gu WHERE g.id = gu.group_id GROUP BY gu.user_id) tl ON users.id = tl.user_id",
      )
      .where(trust_level: TrustLevel[3], manual_locked_trust_level: nil)
      .where(
        "group_granted_trust_level IS NULL OR group_granted_trust_level < ?",
        TrustLevel[3],
      )
      .find_each do |u|
        # Don't demote too soon after being promoted
        next if u.on_tl3_grace_period?

        if Promotion.tl3_lost?(u)
          demoted_user_ids << u.id
          Promotion.new(u).change_trust_level!(TrustLevel[2])
        end
      end
  end

  # Promotions
  User
    .real
    .not_suspended
    .where(trust_level: TrustLevel[2], manual_locked_trust_level: nil)
    .where.not(id: demoted_user_ids)
    .joins(:user_stat)
    .where("user_stats.days_visited >= ?", SiteSetting.tl3_requires_days_visited)
    .where("user_stats.topics_entered >= ?", SiteSetting.tl3_requires_topics_viewed_all_time)
    .where("user_stats.posts_read_count >= ?", SiteSetting.tl3_requires_posts_read_all_time)
    .where("user_stats.likes_given >= ?", SiteSetting.tl3_requires_likes_given)
    .where("user_stats.likes_received >= ?", SiteSetting.tl3_requires_likes_received)
    .find_each { |u| Promotion.new(u).review_tl2 }
end