# reportable_type :string not null
# reportable_id :integer not null
# reported_user_id :integer
-# status :integer
+# status :enum default("open"), not null
# assigned_role :enum not null
# resolved_at :datetime
# resolved_by :integer
#
# Indexes
#
-# index_issues_on_reportable_id_and_reportable_type (reportable_id,reportable_type)
+# index_issues_on_assigned_role (assigned_role)
+# index_issues_on_reportable_type_and_reportable_id (reportable_type,reportable_id)
# index_issues_on_reported_user_id (reported_user_id)
+# index_issues_on_status (status)
# 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
+# issues_reported_user_id_fkey (reported_user_id => users.id)
+# issues_resolved_by_fkey (resolved_by => users.id)
+# issues_updated_by_fkey (updated_by => users.id)
#
-class Issue < ActiveRecord::Base
+class Issue < ApplicationRecord
belongs_to :reportable, :polymorphic => true
- belongs_to :reported_user, :class_name => "User", :foreign_key => :reported_user_id
+ belongs_to :reported_user, :class_name => "User"
+ belongs_to :user_resolved, :class_name => "User", :foreign_key => :resolved_by
belongs_to :user_updated, :class_name => "User", :foreign_key => :updated_by
has_many :reports, :dependent => :destroy
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
- # Check if more statuses are needed
- enum :status => %w[open ignored resolved]
-
scope :with_status, ->(issue_status) { where(:status => statuses[issue_status]) }
+ scope :visible_to, ->(user) { where(:assigned_role => user.roles.map(&:role)) }
def read_reports
resolved_at.present? ? reports.where("updated_at < ?", resolved_at) : nil
reportable.user
end
end
-
- def set_default_assigned_role
- role = %w[Note].include?(reportable.class.name) ? "moderator" : "administrator"
- self.assigned_role = role if assigned_role.blank?
- end
end