#
# Table name: user_blocks
#
-# id :integer not null, primary key
-# user_id :bigint(8) not null
-# creator_id :bigint(8) not null
-# reason :text not null
-# ends_at :datetime not null
-# needs_view :boolean default(FALSE), not null
-# revoker_id :bigint(8)
-# created_at :datetime
-# updated_at :datetime
-# reason_format :enum default("markdown"), not null
+# id :integer not null, primary key
+# user_id :bigint(8) not null
+# creator_id :bigint(8) not null
+# reason :text not null
+# ends_at :datetime not null
+# needs_view :boolean default(FALSE), not null
+# revoker_id :bigint(8)
+# created_at :datetime
+# updated_at :datetime
+# reason_format :enum default("markdown"), not null
+# deactivates_at :datetime
#
# Indexes
#
-# index_user_blocks_on_user_id (user_id)
+# index_user_blocks_on_creator_id_and_id (creator_id,id)
+# index_user_blocks_on_user_id (user_id)
#
# Foreign Keys
#
class UserBlock < ApplicationRecord
validate :moderator_permissions
validates :reason, :characters => true
+ validates :deactivates_at, :comparison => { :greater_than_or_equal_to => :ends_at }, :unless => -> { needs_view }
+ validates :deactivates_at, :absence => true, :if => -> { needs_view }
- belongs_to :user, :class_name => "User", :foreign_key => :user_id
- belongs_to :creator, :class_name => "User", :foreign_key => :creator_id
- belongs_to :revoker, :class_name => "User", :foreign_key => :revoker_id
+ belongs_to :user, :class_name => "User"
+ belongs_to :creator, :class_name => "User"
+ belongs_to :revoker, :class_name => "User", :optional => true
PERIODS = Settings.user_block_periods
##
# scope to match active blocks
def self.active
- where("needs_view or ends_at > ?", Time.now.getutc)
+ where("needs_view or ends_at > ?", Time.now.utc)
end
##
# returns true if the block is currently active (i.e: the user can't
# use the API).
def active?
- needs_view || ends_at > Time.now.getutc
+ needs_view || ends_at > Time.now.utc
end
##
# is the user object who is revoking the ban.
def revoke!(revoker)
update(
- :ends_at => Time.now.getutc,
+ :ends_at => Time.now.utc,
+ :deactivates_at => Time.now.utc,
:revoker_id => revoker.id,
:needs_view => false
)