1 # frozen_string_literal: true
3 # == Schema Information
5 # Table name: user_blocks
7 # id :integer not null, primary key
8 # user_id :bigint not null
9 # creator_id :bigint not null
10 # reason :text not null
11 # ends_at :datetime not null
12 # needs_view :boolean default(FALSE), not null
14 # created_at :datetime
15 # updated_at :datetime
16 # reason_format :enum default("markdown"), not null
17 # deactivates_at :datetime
21 # index_user_blocks_on_creator_id_and_id (creator_id,id)
22 # index_user_blocks_on_user_id (user_id)
26 # user_blocks_moderator_id_fkey (creator_id => users.id)
27 # user_blocks_revoker_id_fkey (revoker_id => users.id)
28 # user_blocks_user_id_fkey (user_id => users.id)
31 class UserBlock < ApplicationRecord
32 validate :moderator_permissions
33 validates :reason, :characters => true, :length => { :maximum => 10000 }
34 validates :deactivates_at, :comparison => { :greater_than_or_equal_to => :ends_at }, :unless => -> { needs_view }
35 validates :deactivates_at, :absence => true, :if => -> { needs_view }
37 belongs_to :user, :class_name => "User"
38 belongs_to :creator, :class_name => "User"
39 belongs_to :revoker, :class_name => "User", :optional => true
41 PERIODS = Settings.user_block_periods
44 # scope to match active blocks
46 where("needs_view or ends_at > ?", Time.now.utc)
50 # return a renderable version of the reason text.
52 RichText.new(self[:reason_format], self[:reason])
56 # returns true if the block is currently active (i.e: the user can't
59 needs_view || ends_at > Time.now.utc
63 # returns true if the block is a "zero hour" block
65 # if the times differ more than 1 minute we probably have more important issues
66 needs_view && (ends_at.to_i - updated_at.to_i) < 60
70 # revokes the block, allowing the user to use the API again. the argument
71 # is the user object who is revoking the ban.
74 :ends_at => Time.now.utc,
75 :deactivates_at => Time.now.utc,
76 :revoker_id => revoker.id,
84 # validate that only moderators are allowed to change the
85 # block. this should be caught and dealt with in the controller,
86 # but i've also included it here just in case.
87 def moderator_permissions
88 errors.add(:base, I18n.t("user_blocks.model.non_moderator_update")) if creator_id_changed? && !creator.moderator?
89 errors.add(:base, I18n.t("user_blocks.model.non_moderator_revoke")) if revoker_id_changed? && !revoker_id.nil? && !revoker.moderator?