Feature #11069 » patch_for_locked_users_query.diff
| app/models/principal.rb (revision 1241) | ||
|---|---|---|
|
# Groups and active users
|
||
|
scope :active, lambda { where(:status => STATUS_ACTIVE) }
|
||
|
# Locked users
|
||
|
scope :locked, lambda { where(:status => STATUS_LOCKED) }
|
||
|
scope :like, lambda {|q|
|
||
|
q = q.to_s
|
||
| ... | ... | |
|
active.uniq.joins(:members).where("#{Member.table_name}.project_id IN (?)", ids)
|
||
|
end
|
||
|
}
|
||
|
# Principals that are locked members of a collection of projects
|
||
|
scope :locked_member_of, lambda {|projects|
|
||
|
projects = [projects] unless projects.is_a?(Array)
|
||
|
if projects.empty?
|
||
|
where("1=0")
|
||
|
else
|
||
|
ids = projects.map(&:id)
|
||
|
locked.uniq.joins(:members).where("#{Member.table_name}.project_id IN (?)", ids)
|
||
|
end
|
||
|
}
|
||
|
# Principals that are not members of projects
|
||
|
scope :not_member_of, lambda {|projects|
|
||
|
projects = [projects] unless projects.is_a?(Array)
|
||
| app/models/issue_query.rb (revision 1241) | ||
|---|---|---|
|
issue_custom_fields = []
|
||
|
|
||
|
if project
|
||
|
principals += project.principals.sort
|
||
|
principals += project.principals
|
||
|
principals += project.locked_principals
|
||
|
principals.sort
|
||
|
unless project.leaf?
|
||
|
subprojects = project.descendants.visible.all
|
||
|
principals += Principal.member_of(subprojects)
|
||
|
principals += Principal.locked_member_of(subprojects)
|
||
|
end
|
||
|
versions = project.shared_versions.all
|
||
|
categories = project.issue_categories.all
|
||
| ... | ... | |
|
else
|
||
|
if all_projects.any?
|
||
|
principals += Principal.member_of(all_projects)
|
||
|
principals += Principal.locked_member_of(all_projects)
|
||
|
end
|
||
|
versions = Version.visible.find_all_by_sharing('system')
|
||
|
issue_custom_fields = IssueCustomField.where(:is_filter => true, :is_for_all => true).all
|
||
| app/models/project.rb (revision 1241) | ||
|---|---|---|
|
has_many :member_principals, :class_name => 'Member',
|
||
|
:include => :principal,
|
||
|
:conditions => "#{Principal.table_name}.type='Group' OR (#{Principal.table_name}.type='User' AND #{Principal.table_name}.status=#{Principal::STATUS_ACTIVE})"
|
||
|
has_many :locked_member_principals, :class_name => 'Member',
|
||
|
:include => :principal,
|
||
|
:conditions => "#{Principal.table_name}.type='Group' OR (#{Principal.table_name}.type='User' AND #{Principal.table_name}.status=#{Principal::STATUS_LOCKED})"
|
||
|
has_many :users, :through => :members
|
||
|
has_many :principals, :through => :member_principals, :source => :principal
|
||
|
has_many :locked_principals, :through => :locked_member_principals, :source => :principal
|
||
|
has_many :enabled_modules, :dependent => :delete_all
|
||
|
has_and_belongs_to_many :trackers, :order => "#{Tracker.table_name}.position"
|
||
- « Previous
- 1
- 2
- Next »