X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/fc0096289dce3c89c1a9d3f7af4e2620f347df11..6788569211e65f8445fda2caec04105cba4158e1:/app/models/issue.rb?ds=inline diff --git a/app/models/issue.rb b/app/models/issue.rb index 567ee819e..a3f82ee40 100644 --- a/app/models/issue.rb +++ b/app/models/issue.rb @@ -5,53 +5,56 @@ # id :integer not null, primary key # reportable_type :string not null # reportable_id :integer not null -# reported_user_id :integer not null -# status :integer -# issue_type :string +# reported_user_id :integer +# status :enum default("open"), not null +# 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 -# reports_count :integer default(0) # # 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 :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 validates :reportable_id, :uniqueness => { :scope => [:reportable_type] } - validates :reported_user_id, :presence => true - before_validation :set_reported_user + ASSIGNED_ROLES = %w[administrator moderator].freeze + validates :assigned_role, :presence => true, :inclusion => ASSIGNED_ROLES - # Check if more statuses are needed - enum :status => %w[open ignored resolved] - enum :type => %w[administrator moderator] + 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 @@ -67,7 +70,7 @@ class Issue < ActiveRecord::Base event :resolve do transitions :from => :open, :to => :resolved after do - self.resolved_at = Time.now.getutc + self.resolved_at = Time.now.utc end end