+# == Schema Information
+#
+# Table name: issues
+#
+# id :integer not null, primary key
+# reportable_type :string not null
+# reportable_id :integer not null
+# reported_user_id :integer not null
+# status :integer
+# assigned_role :enum not null
+# resolved_at :datetime
+# resolved_by :integer
+# updated_by :integer
+# reports_count :integer default(0)
+# created_at :datetime not null
+# updated_at :datetime not null
+#
+# Indexes
+#
+# index_issues_on_reportable_id_and_reportable_type (reportable_id,reportable_type)
+# index_issues_on_reported_user_id (reported_user_id)
+# index_issues_on_updated_by (updated_by)
+#
+# Foreign Keys
+#
+# issues_reported_user_id_fkey (reported_user_id => users.id) ON DELETE => cascade
+# issues_updated_by_fkey (updated_by => users.id) ON DELETE => cascade
+#
+
class Issue < ActiveRecord::Base
- belongs_to :reportable, :polymorphic => true
- belongs_to :user, :class_name => "User", :foreign_key => :reported_user_id
+ belongs_to :reportable, :polymorphic => true
+ belongs_to :reported_user, :class_name => "User", :foreign_key => :reported_user_id
+ belongs_to :user_updated, :class_name => "User", :foreign_key => :updated_by
+
+ has_many :reports, :dependent => :destroy
+ has_many :comments, :class_name => "IssueComment", :dependent => :destroy
+
+ validates :reportable_id, :uniqueness => { :scope => [:reportable_type] }
+ validates :reported_user_id, :presence => true
+
+ ASSIGNED_ROLES = %w[administrator moderator].freeze
+ validates :assigned_role, :presence => true, :inclusion => ASSIGNED_ROLES
+
+ before_validation :set_default_assigned_role
+ before_validation :set_reported_user
- has_many :reports
- has_many :comments, :class_name => "IssueComment"
-
- validates :reportable_id, :uniqueness => { :scope => [ :reportable_type ] }
- validates :reported_user_id, :presence => true
+ # Check if more statuses are needed
+ enum :status => %w[open ignored resolved]
- # Check if more statuses are needed
- enum status: %w( open ignored resolved )
+ scope :with_status, ->(issue_status) { where(:status => statuses[issue_status]) }
- scope :with_status, -> (issue_status) { where(:status => statuses[issue_status])}
+ def read_reports
+ resolved_at.present? ? reports.where("updated_at < ?", resolved_at) : nil
+ end
- def read_reports
- resolved_at.present? ? reports.where("created_at < ?", resolved_at) : nil
- end
+ def unread_reports
+ resolved_at.present? ? reports.where("updated_at >= ?", resolved_at) : reports
+ end
- def unread_reports
- resolved_at.present? ? reports.where("created_at >= ?", resolved_at) : reports
- end
+ include AASM
+ aasm :column => :status, :no_direct_assignment => true do
+ state :open, :initial => true
+ state :ignored
+ state :resolved
- include AASM
- aasm :column => :status, :no_direct_assignment => true do
- state :open, :initial => true
- state :ignored
- state :resolved
+ event :ignore do
+ transitions :from => :open, :to => :ignored
+ end
- event :ignore do
- transitions :from => :open, :to => :ignored
- end
+ event :resolve do
+ transitions :from => :open, :to => :resolved
+ after do
+ self.resolved_at = Time.now.getutc
+ end
+ end
- event :resolve do
- transitions :from => :open, :to => :resolved
- after do
- self.resolved_at = Time.now.getutc
- end
- end
+ event :reopen do
+ transitions :from => :resolved, :to => :open
+ transitions :from => :ignored, :to => :open
+ end
+ end
- event :reopen do
- transitions :from => :resolved, :to => :open
- transitions :from => :ignored, :to => :open
- end
+ private
- end
+ def set_reported_user
+ self.reported_user = case reportable.class.name
+ when "User"
+ reportable
+ when "Note"
+ reportable.author
+ else
+ reportable.user
+ end
+ end
+ def set_default_assigned_role
+ role = %w[Changeset Note].include?(reportable.class.name) ? "moderator" : "administrator"
+ self.assigned_role = role if assigned_role.blank?
+ end
end