##// END OF EJS Templates
Sort user memberships by project....
Jean-Philippe Lang -
r15768:3c005719aeeb
parent child
Show More
@@ -1,205 +1,209
1 1 # Redmine - project management software
2 2 # Copyright (C) 2006-2016 Jean-Philippe Lang
3 3 #
4 4 # This program is free software; you can redistribute it and/or
5 5 # modify it under the terms of the GNU General Public License
6 6 # as published by the Free Software Foundation; either version 2
7 7 # of the License, or (at your option) any later version.
8 8 #
9 9 # This program is distributed in the hope that it will be useful,
10 10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
11 11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 12 # GNU General Public License for more details.
13 13 #
14 14 # You should have received a copy of the GNU General Public License
15 15 # along with this program; if not, write to the Free Software
16 16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17 17
18 18 class Member < ActiveRecord::Base
19 19 belongs_to :user
20 20 belongs_to :principal, :foreign_key => 'user_id'
21 21 has_many :member_roles, :dependent => :destroy
22 22 has_many :roles, lambda { distinct }, :through => :member_roles
23 23 belongs_to :project
24 24
25 25 validates_presence_of :principal, :project
26 26 validates_uniqueness_of :user_id, :scope => :project_id
27 27 validate :validate_role
28 28 attr_protected :id
29 29
30 30 before_destroy :set_issue_category_nil
31 31
32 32 scope :active, lambda { joins(:principal).where(:users => {:status => Principal::STATUS_ACTIVE})}
33 33
34 34 # Sort by first role and principal
35 35 scope :sorted, lambda {
36 36 includes(:member_roles, :roles, :principal).
37 37 reorder("#{Role.table_name}.position").
38 38 order(Principal.fields_for_order_statement)
39 39 }
40 scope :sorted_by_project, lambda {
41 includes(:project).
42 reorder("#{Project.table_name}.lft")
43 }
40 44
41 45 alias :base_reload :reload
42 46 def reload(*args)
43 47 @managed_roles = nil
44 48 base_reload(*args)
45 49 end
46 50
47 51 def role
48 52 end
49 53
50 54 def role=
51 55 end
52 56
53 57 def name
54 58 self.user.name
55 59 end
56 60
57 61 alias :base_role_ids= :role_ids=
58 62 def role_ids=(arg)
59 63 ids = (arg || []).collect(&:to_i) - [0]
60 64 # Keep inherited roles
61 65 ids += member_roles.select {|mr| !mr.inherited_from.nil?}.collect(&:role_id)
62 66
63 67 new_role_ids = ids - role_ids
64 68 # Add new roles
65 69 new_role_ids.each {|id| member_roles << MemberRole.new(:role_id => id, :member => self) }
66 70 # Remove roles (Rails' #role_ids= will not trigger MemberRole#on_destroy)
67 71 member_roles_to_destroy = member_roles.select {|mr| !ids.include?(mr.role_id)}
68 72 if member_roles_to_destroy.any?
69 73 member_roles_to_destroy.each(&:destroy)
70 74 end
71 75 end
72 76
73 77 def <=>(member)
74 78 a, b = roles.sort, member.roles.sort
75 79 if a == b
76 80 if principal
77 81 principal <=> member.principal
78 82 else
79 83 1
80 84 end
81 85 elsif a.any?
82 86 b.any? ? a <=> b : -1
83 87 else
84 88 1
85 89 end
86 90 end
87 91
88 92 # Set member role ids ignoring any change to roles that
89 93 # user is not allowed to manage
90 94 def set_editable_role_ids(ids, user=User.current)
91 95 ids = (ids || []).collect(&:to_i) - [0]
92 96 editable_role_ids = user.managed_roles(project).map(&:id)
93 97 untouched_role_ids = self.role_ids - editable_role_ids
94 98 touched_role_ids = ids & editable_role_ids
95 99 self.role_ids = untouched_role_ids + touched_role_ids
96 100 end
97 101
98 102 # Returns true if one of the member roles is inherited
99 103 def any_inherited_role?
100 104 member_roles.any? {|mr| mr.inherited_from}
101 105 end
102 106
103 107 # Returns true if the member has the role and if it's inherited
104 108 def has_inherited_role?(role)
105 109 member_roles.any? {|mr| mr.role_id == role.id && mr.inherited_from.present?}
106 110 end
107 111
108 112 # Returns true if the member's role is editable by user
109 113 def role_editable?(role, user=User.current)
110 114 if has_inherited_role?(role)
111 115 false
112 116 else
113 117 user.managed_roles(project).include?(role)
114 118 end
115 119 end
116 120
117 121 # Returns true if the member is deletable by user
118 122 def deletable?(user=User.current)
119 123 if any_inherited_role?
120 124 false
121 125 else
122 126 roles & user.managed_roles(project) == roles
123 127 end
124 128 end
125 129
126 130 # Destroys the member
127 131 def destroy
128 132 member_roles.reload.each(&:destroy_without_member_removal)
129 133 super
130 134 end
131 135
132 136 # Returns true if the member is user or is a group
133 137 # that includes user
134 138 def include?(user)
135 139 if principal.is_a?(Group)
136 140 !user.nil? && user.groups.include?(principal)
137 141 else
138 142 self.principal == user
139 143 end
140 144 end
141 145
142 146 def set_issue_category_nil
143 147 if user_id && project_id
144 148 # remove category based auto assignments for this member
145 149 IssueCategory.where(["project_id = ? AND assigned_to_id = ?", project_id, user_id]).
146 150 update_all("assigned_to_id = NULL")
147 151 end
148 152 end
149 153
150 154 # Returns the roles that the member is allowed to manage
151 155 # in the project the member belongs to
152 156 def managed_roles
153 157 @managed_roles ||= begin
154 158 if principal.try(:admin?)
155 159 Role.givable.to_a
156 160 else
157 161 members_management_roles = roles.select do |role|
158 162 role.has_permission?(:manage_members)
159 163 end
160 164 if members_management_roles.empty?
161 165 []
162 166 elsif members_management_roles.any?(&:all_roles_managed?)
163 167 Role.givable.to_a
164 168 else
165 169 members_management_roles.map(&:managed_roles).reduce(&:|)
166 170 end
167 171 end
168 172 end
169 173 end
170 174
171 175 # Creates memberships for principal with the attributes
172 176 # * project_ids : one or more project ids
173 177 # * role_ids : ids of the roles to give to each membership
174 178 #
175 179 # Example:
176 180 # Member.create_principal_memberships(user, :project_ids => [2, 5], :role_ids => [1, 3]
177 181 def self.create_principal_memberships(principal, attributes)
178 182 members = []
179 183 if attributes
180 184 project_ids = Array.wrap(attributes[:project_ids] || attributes[:project_id])
181 185 role_ids = attributes[:role_ids]
182 186 project_ids.each do |project_id|
183 187 members << Member.new(:principal => principal, :role_ids => role_ids, :project_id => project_id)
184 188 end
185 189 principal.members << members
186 190 end
187 191 members
188 192 end
189 193
190 194 # Finds or initilizes a Member for the given project and principal
191 195 def self.find_or_new(project, principal)
192 196 project_id = project.is_a?(Project) ? project.id : project
193 197 principal_id = principal.is_a?(Principal) ? principal.id : principal
194 198
195 199 member = Member.find_by_project_id_and_user_id(project_id, principal_id)
196 200 member ||= Member.new(:project_id => project_id, :user_id => principal_id)
197 201 member
198 202 end
199 203
200 204 protected
201 205
202 206 def validate_role
203 207 errors.add(:role, :empty) if member_roles.empty? && roles.empty?
204 208 end
205 209 end
@@ -1,37 +1,39
1 <% memberships = principal.memberships.preload(:member_roles => :role).sorted_by_project.to_a %>
2
1 3 <p><%= link_to l(:label_add_projects), new_principal_membership_path(principal), :remote => true, :class => "icon icon-add" %></p>
2 4
3 <% if principal.memberships.any? %>
5 <% if memberships.any? %>
4 6 <table class="list memberships">
5 7 <thead><tr>
6 8 <th><%= l(:label_project) %></th>
7 9 <th><%= l(:label_role_plural) %></th>
8 10 <th style="width:15%"></th>
9 11 <%= call_table_header_hook principal %>
10 12 </tr></thead>
11 13 <tbody>
12 <% principal.memberships.preload(:member_roles => :role).each do |membership| %>
14 <% memberships.each do |membership| %>
13 15 <% next if membership.new_record? %>
14 16 <tr id="member-<%= membership.id %>" class="<%= cycle 'odd', 'even' %> class">
15 17 <td class="project name">
16 18 <%= link_to_project membership.project %>
17 19 </td>
18 20 <td class="roles">
19 21 <span id="member-<%= membership.id %>-roles"><%=h membership.roles.sort.collect(&:to_s).join(', ') %></span>
20 22 <div id="member-<%= membership.id %>-form"></div>
21 23 </td>
22 24 <td class="buttons">
23 25 <%= link_to l(:button_edit),
24 26 edit_principal_membership_path(principal, membership),
25 27 :remote => true,
26 28 :class => 'icon icon-edit'
27 29 %>
28 30 <%= delete_link principal_membership_path(principal, membership), :remote => true if membership.deletable? %>
29 31 </td>
30 32 <%= call_table_row_hook principal, membership %>
31 33 </tr>
32 34 <% end; reset_cycle %>
33 35 </tbody>
34 36 </table>
35 37 <% else %>
36 38 <p class="nodata"><%= l(:label_no_data) %></p>
37 39 <% end %>
General Comments 0
You need to be logged in to leave comments. Login now