announcement.rb 3.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  1. # frozen_string_literal: true
  2. # == Schema Information
  3. #
  4. # Table name: announcements
  5. #
  6. # id :bigint(8) not null, primary key
  7. # text :text default(""), not null
  8. # published :boolean default(FALSE), not null
  9. # all_day :boolean default(FALSE), not null
  10. # scheduled_at :datetime
  11. # starts_at :datetime
  12. # ends_at :datetime
  13. # created_at :datetime not null
  14. # updated_at :datetime not null
  15. # published_at :datetime
  16. # status_ids :bigint(8) is an Array
  17. #
  18. class Announcement < ApplicationRecord
  19. scope :unpublished, -> { where(published: false) }
  20. scope :published, -> { where(published: true) }
  21. scope :without_muted, ->(account) { joins("LEFT OUTER JOIN announcement_mutes ON announcement_mutes.announcement_id = announcements.id AND announcement_mutes.account_id = #{account.id}").where('announcement_mutes.id IS NULL') }
  22. scope :chronological, -> { order(Arel.sql('COALESCE(announcements.starts_at, announcements.scheduled_at, announcements.published_at, announcements.created_at) ASC')) }
  23. scope :reverse_chronological, -> { order(Arel.sql('COALESCE(announcements.starts_at, announcements.scheduled_at, announcements.published_at, announcements.created_at) DESC')) }
  24. has_many :announcement_mutes, dependent: :destroy
  25. has_many :announcement_reactions, dependent: :destroy
  26. validates :text, presence: true
  27. validates :starts_at, presence: true, if: -> { ends_at.present? }
  28. validates :ends_at, presence: true, if: -> { starts_at.present? }
  29. before_validation :set_all_day
  30. before_validation :set_published, on: :create
  31. def publish!
  32. update!(published: true, published_at: Time.now.utc, scheduled_at: nil)
  33. end
  34. def unpublish!
  35. update!(published: false, scheduled_at: nil)
  36. end
  37. def time_range?
  38. starts_at.present? && ends_at.present?
  39. end
  40. def mentions
  41. @mentions ||= Account.from_text(text)
  42. end
  43. def statuses
  44. @statuses ||= begin
  45. if status_ids.nil?
  46. []
  47. else
  48. Status.where(id: status_ids, visibility: [:public, :unlisted])
  49. end
  50. end
  51. end
  52. def tags
  53. @tags ||= Tag.find_or_create_by_names(Extractor.extract_hashtags(text))
  54. end
  55. def emojis
  56. @emojis ||= CustomEmoji.from_text(text)
  57. end
  58. def reactions(account = nil)
  59. records = begin
  60. scope = announcement_reactions.group(:announcement_id, :name, :custom_emoji_id).order(Arel.sql('MIN(created_at) ASC'))
  61. if account.nil?
  62. scope.select('name, custom_emoji_id, count(*) as count, false as me')
  63. else
  64. scope.select("name, custom_emoji_id, count(*) as count, exists(select 1 from announcement_reactions r where r.account_id = #{account.id} and r.announcement_id = announcement_reactions.announcement_id and r.name = announcement_reactions.name) as me")
  65. end
  66. end
  67. ActiveRecord::Associations::Preloader.new.preload(records, :custom_emoji)
  68. records
  69. end
  70. private
  71. def set_all_day
  72. self.all_day = false if starts_at.blank? || ends_at.blank?
  73. end
  74. def set_published
  75. return unless scheduled_at.blank? || scheduled_at.past?
  76. self.published = true
  77. self.published_at = Time.now.utc
  78. end
  79. end