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 }, :presence => true
34 validates :deactivates_at, :comparison => { :greater_than_or_equal_to => :ends_at }, :unless => -> { needs_view }
35 validates :deactivates_at, :absence => true, :if => -> { needs_view }
36 validates :ends_at, :presence => true
38 belongs_to :user, :class_name => "User"
39 belongs_to :creator, :class_name => "User"
40 belongs_to :revoker, :class_name => "User", :optional => true
42 PERIODS = Settings.user_block_periods
45 # scope to match active blocks
47 where("needs_view or ends_at > ?", Time.now.utc)
51 # return a renderable version of the reason text.
53 RichText.new(self[:reason_format], self[:reason])
57 # returns true if the block is currently active (i.e: the user can't
60 needs_view || ends_at > Time.now.utc
64 # returns true if the block is a "zero hour" block
66 # if the times differ more than 1 minute we probably have more important issues
67 needs_view && (ends_at.to_i - updated_at.to_i) < 60
71 # revokes the block, allowing the user to use the API again. the argument
72 # is the user object who is revoking the ban.
75 :ends_at => Time.now.utc,
76 :deactivates_at => Time.now.utc,
77 :revoker_id => revoker.id,
85 # validate that only moderators are allowed to change the
86 # block. this should be caught and dealt with in the controller,
87 # but i've also included it here just in case.
88 def moderator_permissions
89 errors.add(:base, I18n.t("user_blocks.model.non_moderator_update")) if creator_id_changed? && !creator.moderator?
90 errors.add(:base, I18n.t("user_blocks.model.non_moderator_revoke")) if revoker_id_changed? && !revoker_id.nil? && !revoker.moderator?