Class: Jobs::Tl3Promotions
- Defined in:
- app/jobs/scheduled/tl3_promotions.rb
Instance Method Summary collapse
Methods inherited from Scheduled
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 |