# 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 :user_resolved, :class_name => "User", :foreign_key => :resolved_by
- belongs_to :user_updated, :class_name => "User", :foreign_key => :updated_by
+ belongs_to :reported_user, :class_name => "User", :optional => true
+ belongs_to :user_resolved, :class_name => "User", :foreign_key => :resolved_by, :optional => true
+ belongs_to :user_updated, :class_name => "User", :foreign_key => :updated_by, :optional => true
has_many :reports, :dependent => :destroy
has_many :comments, :class_name => "IssueComment", :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
- scope :with_status, ->(issue_status) { where(:status => statuses[issue_status]) }
+ scope :with_status, ->(issue_status) { where(:status => 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
+ resolved_at.present? ? reports.where(:updated_at => ...resolved_at) : nil
end
def unread_reports
- resolved_at.present? ? reports.where("updated_at >= ?", resolved_at) : reports
+ resolved_at.present? ? reports.where(:updated_at => resolved_at..) : reports
end
include AASM
event :resolve do
transitions :from => :open, :to => :resolved
after do
- self.resolved_at = Time.now.getutc
+ self.resolved_at = Time.now.utc
end
end
reportable.user
end
end
-
- def set_default_assigned_role
- if assigned_role.blank?
- self.assigned_role = case reportable
- when Note then "moderator"
- else "administrator"
- end
- end
- end
end