| @@ -1,424 +1,420 | |||
|
|
1 | 1 | # Redmine - project management software |
|
|
2 | 2 | # Copyright (C) 2006-2013 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 IssueQuery < Query |
|
|
19 | 19 | |
|
|
20 | 20 | self.queried_class = Issue |
|
|
21 | 21 | |
|
|
22 | 22 | self.available_columns = [ |
|
|
23 | 23 | QueryColumn.new(:project, :sortable => "#{Project.table_name}.name", :groupable => true), |
|
|
24 | 24 | QueryColumn.new(:tracker, :sortable => "#{Tracker.table_name}.position", :groupable => true), |
|
|
25 | 25 | QueryColumn.new(:parent, :sortable => ["#{Issue.table_name}.root_id", "#{Issue.table_name}.lft ASC"], :default_order => 'desc', :caption => :field_parent_issue), |
|
|
26 | 26 | QueryColumn.new(:status, :sortable => "#{IssueStatus.table_name}.position", :groupable => true), |
|
|
27 | 27 | QueryColumn.new(:priority, :sortable => "#{IssuePriority.table_name}.position", :default_order => 'desc', :groupable => true), |
|
|
28 | 28 | QueryColumn.new(:subject, :sortable => "#{Issue.table_name}.subject"), |
|
|
29 | 29 | QueryColumn.new(:author, :sortable => lambda {User.fields_for_order_statement("authors")}, :groupable => true), |
|
|
30 | 30 | QueryColumn.new(:assigned_to, :sortable => lambda {User.fields_for_order_statement}, :groupable => true), |
|
|
31 | 31 | QueryColumn.new(:updated_on, :sortable => "#{Issue.table_name}.updated_on", :default_order => 'desc'), |
|
|
32 | 32 | QueryColumn.new(:category, :sortable => "#{IssueCategory.table_name}.name", :groupable => true), |
|
|
33 | 33 | QueryColumn.new(:fixed_version, :sortable => lambda {Version.fields_for_order_statement}, :groupable => true), |
|
|
34 | 34 | QueryColumn.new(:start_date, :sortable => "#{Issue.table_name}.start_date"), |
|
|
35 | 35 | QueryColumn.new(:due_date, :sortable => "#{Issue.table_name}.due_date"), |
|
|
36 | 36 | QueryColumn.new(:estimated_hours, :sortable => "#{Issue.table_name}.estimated_hours"), |
|
|
37 | 37 | QueryColumn.new(:done_ratio, :sortable => "#{Issue.table_name}.done_ratio", :groupable => true), |
|
|
38 | 38 | QueryColumn.new(:created_on, :sortable => "#{Issue.table_name}.created_on", :default_order => 'desc'), |
|
|
39 | 39 | QueryColumn.new(:relations, :caption => :label_related_issues), |
|
|
40 | 40 | QueryColumn.new(:description, :inline => false) |
|
|
41 | 41 | ] |
|
|
42 | 42 | |
|
|
43 | 43 | scope :visible, lambda {|*args| |
|
|
44 | 44 | user = args.shift || User.current |
|
|
45 | 45 | base = Project.allowed_to_condition(user, :view_issues, *args) |
|
|
46 | 46 | user_id = user.logged? ? user.id : 0 |
|
|
47 | 47 | |
|
|
48 | 48 | includes(:project).where("(#{table_name}.project_id IS NULL OR (#{base})) AND (#{table_name}.is_public = ? OR #{table_name}.user_id = ?)", true, user_id) |
|
|
49 | 49 | } |
|
|
50 | 50 | |
|
|
51 | 51 | def initialize(attributes=nil, *args) |
|
|
52 | 52 | super attributes |
|
|
53 | 53 | self.filters ||= { 'status_id' => {:operator => "o", :values => [""]} } |
|
|
54 | 54 | end |
|
|
55 | 55 | |
|
|
56 | 56 | # Returns true if the query is visible to +user+ or the current user. |
|
|
57 | 57 | def visible?(user=User.current) |
|
|
58 | 58 | (project.nil? || user.allowed_to?(:view_issues, project)) && (self.is_public? || self.user_id == user.id) |
|
|
59 | 59 | end |
|
|
60 | 60 | |
|
|
61 | 61 | def available_filters |
|
|
62 | 62 | return @available_filters if @available_filters |
|
|
63 | 63 | @available_filters = { |
|
|
64 | 64 | "status_id" => { |
|
|
65 | 65 | :type => :list_status, :order => 0, |
|
|
66 | 66 | :values => IssueStatus.sorted.all.collect{|s| [s.name, s.id.to_s] } |
|
|
67 | 67 | }, |
|
|
68 | 68 | "tracker_id" => { |
|
|
69 | 69 | :type => :list, :order => 2, :values => trackers.collect{|s| [s.name, s.id.to_s] } |
|
|
70 | 70 | }, |
|
|
71 | 71 | "priority_id" => { |
|
|
72 | 72 | :type => :list, :order => 3, :values => IssuePriority.all.collect{|s| [s.name, s.id.to_s] } |
|
|
73 | 73 | }, |
|
|
74 | 74 | "subject" => { :type => :text, :order => 8 }, |
|
|
75 | 75 | "created_on" => { :type => :date_past, :order => 9 }, |
|
|
76 | 76 | "updated_on" => { :type => :date_past, :order => 10 }, |
|
|
77 | 77 | "start_date" => { :type => :date, :order => 11 }, |
|
|
78 | 78 | "due_date" => { :type => :date, :order => 12 }, |
|
|
79 | 79 | "estimated_hours" => { :type => :float, :order => 13 }, |
|
|
80 | 80 | "done_ratio" => { :type => :integer, :order => 14 } |
|
|
81 | 81 | } |
|
|
82 | 82 | IssueRelation::TYPES.each do |relation_type, options| |
|
|
83 | 83 | @available_filters[relation_type] = { |
|
|
84 | 84 | :type => :relation, :order => @available_filters.size + 100, |
|
|
85 | 85 | :label => options[:name] |
|
|
86 | 86 | } |
|
|
87 | 87 | end |
|
|
88 | 88 | principals = [] |
|
|
89 | 89 | if project |
|
|
90 | 90 | principals += project.principals.sort |
|
|
91 | 91 | unless project.leaf? |
|
|
92 | 92 | subprojects = project.descendants.visible.all |
|
|
93 | 93 | if subprojects.any? |
|
|
94 | 94 | @available_filters["subproject_id"] = { |
|
|
95 | 95 | :type => :list_subprojects, :order => 13, |
|
|
96 | 96 | :values => subprojects.collect{|s| [s.name, s.id.to_s] } |
|
|
97 | 97 | } |
|
|
98 | 98 | principals += Principal.member_of(subprojects) |
|
|
99 | 99 | end |
|
|
100 | 100 | end |
|
|
101 | 101 | else |
|
|
102 | 102 | if all_projects.any? |
|
|
103 | 103 | # members of visible projects |
|
|
104 | 104 | principals += Principal.member_of(all_projects) |
|
|
105 | 105 | # project filter |
|
|
106 | 106 | project_values = [] |
|
|
107 | 107 | if User.current.logged? && User.current.memberships.any? |
|
|
108 | 108 | project_values << ["<< #{l(:label_my_projects).downcase} >>", "mine"] |
|
|
109 | 109 | end |
|
|
110 | 110 | project_values += all_projects_values |
|
|
111 | 111 | @available_filters["project_id"] = { |
|
|
112 | 112 | :type => :list, :order => 1, :values => project_values |
|
|
113 | 113 | } unless project_values.empty? |
|
|
114 | 114 | end |
|
|
115 | 115 | end |
|
|
116 | 116 | principals.uniq! |
|
|
117 | 117 | principals.sort! |
|
|
118 | 118 | users = principals.select {|p| p.is_a?(User)} |
|
|
119 | 119 | |
|
|
120 | 120 | assigned_to_values = [] |
|
|
121 | 121 | assigned_to_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged? |
|
|
122 | 122 | assigned_to_values += (Setting.issue_group_assignment? ? |
|
|
123 | 123 | principals : users).collect{|s| [s.name, s.id.to_s] } |
|
|
124 | 124 | @available_filters["assigned_to_id"] = { |
|
|
125 | 125 | :type => :list_optional, :order => 4, :values => assigned_to_values |
|
|
126 | 126 | } unless assigned_to_values.empty? |
|
|
127 | 127 | |
|
|
128 | 128 | author_values = [] |
|
|
129 | 129 | author_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged? |
|
|
130 | 130 | author_values += users.collect{|s| [s.name, s.id.to_s] } |
|
|
131 | 131 | @available_filters["author_id"] = { |
|
|
132 | 132 | :type => :list, :order => 5, :values => author_values |
|
|
133 | 133 | } unless author_values.empty? |
|
|
134 | 134 | |
|
|
135 | 135 | group_values = Group.all.collect {|g| [g.name, g.id.to_s] } |
|
|
136 | 136 | @available_filters["member_of_group"] = { |
|
|
137 | 137 | :type => :list_optional, :order => 6, :values => group_values |
|
|
138 | 138 | } unless group_values.empty? |
|
|
139 | 139 | |
|
|
140 | 140 | role_values = Role.givable.collect {|r| [r.name, r.id.to_s] } |
|
|
141 | 141 | @available_filters["assigned_to_role"] = { |
|
|
142 | 142 | :type => :list_optional, :order => 7, :values => role_values |
|
|
143 | 143 | } unless role_values.empty? |
|
|
144 | 144 | |
|
|
145 | 145 | if User.current.logged? |
|
|
146 | 146 | @available_filters["watcher_id"] = { |
|
|
147 | 147 | :type => :list, :order => 15, :values => [["<< #{l(:label_me)} >>", "me"]] |
|
|
148 | 148 | } |
|
|
149 | 149 | end |
|
|
150 | 150 | |
|
|
151 | 151 | if project |
|
|
152 | 152 | # project specific filters |
|
|
153 | 153 | categories = project.issue_categories.all |
|
|
154 | 154 | unless categories.empty? |
|
|
155 | 155 | @available_filters["category_id"] = { |
|
|
156 | 156 | :type => :list_optional, :order => 6, |
|
|
157 | 157 | :values => categories.collect{|s| [s.name, s.id.to_s] } |
|
|
158 | 158 | } |
|
|
159 | 159 | end |
|
|
160 | 160 | versions = project.shared_versions.all |
|
|
161 | 161 | unless versions.empty? |
|
|
162 | 162 | @available_filters["fixed_version_id"] = { |
|
|
163 | 163 | :type => :list_optional, :order => 7, |
|
|
164 | 164 | :values => versions.sort.collect{|s| ["#{s.project.name} - #{s.name}", s.id.to_s] } |
|
|
165 | 165 | } |
|
|
166 | 166 | end |
|
|
167 | 167 | add_custom_fields_filters(project.all_issue_custom_fields) |
|
|
168 | 168 | else |
|
|
169 | 169 | # global filters for cross project issue list |
|
|
170 | 170 | system_shared_versions = Version.visible.find_all_by_sharing('system') |
|
|
171 | 171 | unless system_shared_versions.empty? |
|
|
172 | 172 | @available_filters["fixed_version_id"] = { |
|
|
173 | 173 | :type => :list_optional, :order => 7, |
|
|
174 | 174 | :values => system_shared_versions.sort.collect{|s| |
|
|
175 | 175 | ["#{s.project.name} - #{s.name}", s.id.to_s] |
|
|
176 | 176 | } |
|
|
177 | 177 | } |
|
|
178 | 178 | end |
|
|
179 | 179 | add_custom_fields_filters(IssueCustomField.where(:is_filter => true, :is_for_all => true).all) |
|
|
180 | 180 | end |
|
|
181 | 181 | add_associations_custom_fields_filters :project, :author, :assigned_to, :fixed_version |
|
|
182 | 182 | if User.current.allowed_to?(:set_issues_private, nil, :global => true) || |
|
|
183 | 183 | User.current.allowed_to?(:set_own_issues_private, nil, :global => true) |
|
|
184 | 184 | @available_filters["is_private"] = { |
|
|
185 | 185 | :type => :list, :order => 16, |
|
|
186 | 186 | :values => [[l(:general_text_yes), "1"], [l(:general_text_no), "0"]] |
|
|
187 | 187 | } |
|
|
188 | 188 | end |
|
|
189 | 189 | Tracker.disabled_core_fields(trackers).each {|field| |
|
|
190 | 190 | @available_filters.delete field |
|
|
191 | 191 | } |
|
|
192 | 192 | @available_filters.each do |field, options| |
|
|
193 | 193 | options[:name] ||= l(options[:label] || "field_#{field}".gsub(/_id$/, '')) |
|
|
194 | 194 | end |
|
|
195 | 195 | @available_filters |
|
|
196 | 196 | end |
|
|
197 | 197 | |
|
|
198 | 198 | def available_columns |
|
|
199 | 199 | return @available_columns if @available_columns |
|
|
200 | 200 | @available_columns = self.class.available_columns.dup |
|
|
201 | 201 | @available_columns += (project ? |
|
|
202 | 202 | project.all_issue_custom_fields : |
|
|
203 | 203 | IssueCustomField.all |
|
|
204 | 204 | ).collect {|cf| QueryCustomFieldColumn.new(cf) } |
|
|
205 | 205 | |
|
|
206 | 206 | if User.current.allowed_to?(:view_time_entries, project, :global => true) |
|
|
207 | 207 | index = nil |
|
|
208 | 208 | @available_columns.each_with_index {|column, i| index = i if column.name == :estimated_hours} |
|
|
209 | 209 | index = (index ? index + 1 : -1) |
|
|
210 | 210 | # insert the column after estimated_hours or at the end |
|
|
211 | 211 | @available_columns.insert index, QueryColumn.new(:spent_hours, |
|
|
212 | 212 | :sortable => "COALESCE((SELECT SUM(hours) FROM #{TimeEntry.table_name} WHERE #{TimeEntry.table_name}.issue_id = #{Issue.table_name}.id), 0)", |
|
|
213 | 213 | :default_order => 'desc', |
|
|
214 | 214 | :caption => :label_spent_time |
|
|
215 | 215 | ) |
|
|
216 | 216 | end |
|
|
217 | 217 | |
|
|
218 | 218 | if User.current.allowed_to?(:set_issues_private, nil, :global => true) || |
|
|
219 | 219 | User.current.allowed_to?(:set_own_issues_private, nil, :global => true) |
|
|
220 | 220 | @available_columns << QueryColumn.new(:is_private, :sortable => "#{Issue.table_name}.is_private") |
|
|
221 | 221 | end |
|
|
222 | 222 | |
|
|
223 | 223 | disabled_fields = Tracker.disabled_core_fields(trackers).map {|field| field.sub(/_id$/, '')} |
|
|
224 | 224 | @available_columns.reject! {|column| |
|
|
225 | 225 | disabled_fields.include?(column.name.to_s) |
|
|
226 | 226 | } |
|
|
227 | 227 | |
|
|
228 | 228 | @available_columns |
|
|
229 | 229 | end |
|
|
230 | 230 | |
|
|
231 | 231 | def sortable_columns |
|
|
232 | 232 | {'id' => "#{Issue.table_name}.id"}.merge(super) |
|
|
233 | 233 | end |
|
|
234 | 234 | |
|
|
235 | 235 | def default_columns_names |
|
|
236 | 236 | @default_columns_names ||= begin |
|
|
237 | 237 | default_columns = Setting.issue_list_default_columns.map(&:to_sym) |
|
|
238 | 238 | |
|
|
239 | 239 | project.present? ? default_columns : [:project] | default_columns |
|
|
240 | 240 | end |
|
|
241 | 241 | end |
|
|
242 | 242 | |
|
|
243 | 243 | # Returns the issue count |
|
|
244 | 244 | def issue_count |
|
|
245 | 245 | Issue.visible.count(:include => [:status, :project], :conditions => statement) |
|
|
246 | 246 | rescue ::ActiveRecord::StatementInvalid => e |
|
|
247 | 247 | raise StatementInvalid.new(e.message) |
|
|
248 | 248 | end |
|
|
249 | 249 | |
|
|
250 | 250 | # Returns the issue count by group or nil if query is not grouped |
|
|
251 | 251 | def issue_count_by_group |
|
|
252 | 252 | r = nil |
|
|
253 | 253 | if grouped? |
|
|
254 | 254 | begin |
|
|
255 | 255 | # Rails3 will raise an (unexpected) RecordNotFound if there's only a nil group value |
|
|
256 | 256 | r = Issue.visible.count(:joins => joins_for_order_statement(group_by_statement), :group => group_by_statement, :include => [:status, :project], :conditions => statement) |
|
|
257 | 257 | rescue ActiveRecord::RecordNotFound |
|
|
258 | 258 | r = {nil => issue_count} |
|
|
259 | 259 | end |
|
|
260 | 260 | c = group_by_column |
|
|
261 | 261 | if c.is_a?(QueryCustomFieldColumn) |
|
|
262 | 262 | r = r.keys.inject({}) {|h, k| h[c.custom_field.cast_value(k)] = r[k]; h} |
|
|
263 | 263 | end |
|
|
264 | 264 | end |
|
|
265 | 265 | r |
|
|
266 | 266 | rescue ::ActiveRecord::StatementInvalid => e |
|
|
267 | 267 | raise StatementInvalid.new(e.message) |
|
|
268 | 268 | end |
|
|
269 | 269 | |
|
|
270 | 270 | # Returns the issues |
|
|
271 | 271 | # Valid options are :order, :offset, :limit, :include, :conditions |
|
|
272 | 272 | def issues(options={}) |
|
|
273 | 273 | order_option = [group_by_sort_order, options[:order]].flatten.reject(&:blank?) |
|
|
274 | 274 | |
|
|
275 | 275 | issues = Issue.visible.where(options[:conditions]).all( |
|
|
276 | 276 | :include => ([:status, :project] + (options[:include] || [])).uniq, |
|
|
277 | 277 | :conditions => statement, |
|
|
278 | 278 | :order => order_option, |
|
|
279 | 279 | :joins => joins_for_order_statement(order_option.join(',')), |
|
|
280 | 280 | :limit => options[:limit], |
|
|
281 | 281 | :offset => options[:offset] |
|
|
282 | 282 | ) |
|
|
283 | 283 | |
|
|
284 | 284 | if has_column?(:spent_hours) |
|
|
285 | 285 | Issue.load_visible_spent_hours(issues) |
|
|
286 | 286 | end |
|
|
287 | 287 | if has_column?(:relations) |
|
|
288 | 288 | Issue.load_visible_relations(issues) |
|
|
289 | 289 | end |
|
|
290 | 290 | issues |
|
|
291 | 291 | rescue ::ActiveRecord::StatementInvalid => e |
|
|
292 | 292 | raise StatementInvalid.new(e.message) |
|
|
293 | 293 | end |
|
|
294 | 294 | |
|
|
295 | 295 | # Returns the issues ids |
|
|
296 | 296 | def issue_ids(options={}) |
|
|
297 | 297 | order_option = [group_by_sort_order, options[:order]].flatten.reject(&:blank?) |
|
|
298 | 298 | |
|
|
299 | 299 | Issue.visible.scoped(:conditions => options[:conditions]).scoped(:include => ([:status, :project] + (options[:include] || [])).uniq, |
|
|
300 | 300 | :conditions => statement, |
|
|
301 | 301 | :order => order_option, |
|
|
302 | 302 | :joins => joins_for_order_statement(order_option.join(',')), |
|
|
303 | 303 | :limit => options[:limit], |
|
|
304 | 304 | :offset => options[:offset]).find_ids |
|
|
305 | 305 | rescue ::ActiveRecord::StatementInvalid => e |
|
|
306 | 306 | raise StatementInvalid.new(e.message) |
|
|
307 | 307 | end |
|
|
308 | 308 | |
|
|
309 | 309 | # Returns the journals |
|
|
310 | 310 | # Valid options are :order, :offset, :limit |
|
|
311 | 311 | def journals(options={}) |
|
|
312 | 312 | Journal.visible.all( |
|
|
313 | 313 | :include => [:details, :user, {:issue => [:project, :author, :tracker, :status]}], |
|
|
314 | 314 | :conditions => statement, |
|
|
315 | 315 | :order => options[:order], |
|
|
316 | 316 | :limit => options[:limit], |
|
|
317 | 317 | :offset => options[:offset] |
|
|
318 | 318 | ) |
|
|
319 | 319 | rescue ::ActiveRecord::StatementInvalid => e |
|
|
320 | 320 | raise StatementInvalid.new(e.message) |
|
|
321 | 321 | end |
|
|
322 | 322 | |
|
|
323 | 323 | # Returns the versions |
|
|
324 | 324 | # Valid options are :conditions |
|
|
325 | 325 | def versions(options={}) |
|
|
326 | 326 | Version.visible.where(options[:conditions]).all( |
|
|
327 | 327 | :include => :project, |
|
|
328 | 328 | :conditions => project_statement |
|
|
329 | 329 | ) |
|
|
330 | 330 | rescue ::ActiveRecord::StatementInvalid => e |
|
|
331 | 331 | raise StatementInvalid.new(e.message) |
|
|
332 | 332 | end |
|
|
333 | 333 | |
|
|
334 | 334 | def sql_for_watcher_id_field(field, operator, value) |
|
|
335 | 335 | db_table = Watcher.table_name |
|
|
336 | 336 | "#{Issue.table_name}.id #{ operator == '=' ? 'IN' : 'NOT IN' } (SELECT #{db_table}.watchable_id FROM #{db_table} WHERE #{db_table}.watchable_type='Issue' AND " + |
|
|
337 | 337 | sql_for_field(field, '=', value, db_table, 'user_id') + ')' |
|
|
338 | 338 | end |
|
|
339 | 339 | |
|
|
340 | 340 | def sql_for_member_of_group_field(field, operator, value) |
|
|
341 | 341 | if operator == '*' # Any group |
|
|
342 | 342 | groups = Group.all |
|
|
343 | 343 | operator = '=' # Override the operator since we want to find by assigned_to |
|
|
344 | 344 | elsif operator == "!*" |
|
|
345 | 345 | groups = Group.all |
|
|
346 | 346 | operator = '!' # Override the operator since we want to find by assigned_to |
|
|
347 | 347 | else |
|
|
348 | 348 | groups = Group.find_all_by_id(value) |
|
|
349 | 349 | end |
|
|
350 | 350 | groups ||= [] |
|
|
351 | 351 | |
|
|
352 | 352 | members_of_groups = groups.inject([]) {|user_ids, group| |
|
|
353 | if group && group.user_ids.present? | |
|
|
354 | user_ids << group.user_ids | |
|
|
355 | user_ids << group.id | |
|
|
356 | end | |
|
|
357 | user_ids.flatten.uniq.compact | |
|
|
358 | }.sort.collect(&:to_s) | |
|
|
353 | user_ids + group.user_ids + [group.id] | |
|
|
354 | }.uniq.compact.sort.collect(&:to_s) | |
|
|
359 | 355 | |
|
|
360 | 356 | '(' + sql_for_field("assigned_to_id", operator, members_of_groups, Issue.table_name, "assigned_to_id", false) + ')' |
|
|
361 | 357 | end |
|
|
362 | 358 | |
|
|
363 | 359 | def sql_for_assigned_to_role_field(field, operator, value) |
|
|
364 | 360 | case operator |
|
|
365 | 361 | when "*", "!*" # Member / Not member |
|
|
366 | 362 | sw = operator == "!*" ? 'NOT' : '' |
|
|
367 | 363 | nl = operator == "!*" ? "#{Issue.table_name}.assigned_to_id IS NULL OR" : '' |
|
|
368 | 364 | "(#{nl} #{Issue.table_name}.assigned_to_id #{sw} IN (SELECT DISTINCT #{Member.table_name}.user_id FROM #{Member.table_name}" + |
|
|
369 | 365 | " WHERE #{Member.table_name}.project_id = #{Issue.table_name}.project_id))" |
|
|
370 | 366 | when "=", "!" |
|
|
371 | 367 | role_cond = value.any? ? |
|
|
372 | 368 | "#{MemberRole.table_name}.role_id IN (" + value.collect{|val| "'#{connection.quote_string(val)}'"}.join(",") + ")" : |
|
|
373 | 369 | "1=0" |
|
|
374 | 370 | |
|
|
375 | 371 | sw = operator == "!" ? 'NOT' : '' |
|
|
376 | 372 | nl = operator == "!" ? "#{Issue.table_name}.assigned_to_id IS NULL OR" : '' |
|
|
377 | 373 | "(#{nl} #{Issue.table_name}.assigned_to_id #{sw} IN (SELECT DISTINCT #{Member.table_name}.user_id FROM #{Member.table_name}, #{MemberRole.table_name}" + |
|
|
378 | 374 | " WHERE #{Member.table_name}.project_id = #{Issue.table_name}.project_id AND #{Member.table_name}.id = #{MemberRole.table_name}.member_id AND #{role_cond}))" |
|
|
379 | 375 | end |
|
|
380 | 376 | end |
|
|
381 | 377 | |
|
|
382 | 378 | def sql_for_is_private_field(field, operator, value) |
|
|
383 | 379 | op = (operator == "=" ? 'IN' : 'NOT IN') |
|
|
384 | 380 | va = value.map {|v| v == '0' ? connection.quoted_false : connection.quoted_true}.uniq.join(',') |
|
|
385 | 381 | |
|
|
386 | 382 | "#{Issue.table_name}.is_private #{op} (#{va})" |
|
|
387 | 383 | end |
|
|
388 | 384 | |
|
|
389 | 385 | def sql_for_relations(field, operator, value, options={}) |
|
|
390 | 386 | relation_options = IssueRelation::TYPES[field] |
|
|
391 | 387 | return relation_options unless relation_options |
|
|
392 | 388 | |
|
|
393 | 389 | relation_type = field |
|
|
394 | 390 | join_column, target_join_column = "issue_from_id", "issue_to_id" |
|
|
395 | 391 | if relation_options[:reverse] || options[:reverse] |
|
|
396 | 392 | relation_type = relation_options[:reverse] || relation_type |
|
|
397 | 393 | join_column, target_join_column = target_join_column, join_column |
|
|
398 | 394 | end |
|
|
399 | 395 | |
|
|
400 | 396 | sql = case operator |
|
|
401 | 397 | when "*", "!*" |
|
|
402 | 398 | op = (operator == "*" ? 'IN' : 'NOT IN') |
|
|
403 | 399 | "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name} WHERE #{IssueRelation.table_name}.relation_type = '#{connection.quote_string(relation_type)}')" |
|
|
404 | 400 | when "=", "!" |
|
|
405 | 401 | op = (operator == "=" ? 'IN' : 'NOT IN') |
|
|
406 | 402 | "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name} WHERE #{IssueRelation.table_name}.relation_type = '#{connection.quote_string(relation_type)}' AND #{IssueRelation.table_name}.#{target_join_column} = #{value.first.to_i})" |
|
|
407 | 403 | when "=p", "=!p", "!p" |
|
|
408 | 404 | op = (operator == "!p" ? 'NOT IN' : 'IN') |
|
|
409 | 405 | comp = (operator == "=!p" ? '<>' : '=') |
|
|
410 | 406 | "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name}, #{Issue.table_name} relissues WHERE #{IssueRelation.table_name}.relation_type = '#{connection.quote_string(relation_type)}' AND #{IssueRelation.table_name}.#{target_join_column} = relissues.id AND relissues.project_id #{comp} #{value.first.to_i})" |
|
|
411 | 407 | end |
|
|
412 | 408 | |
|
|
413 | 409 | if relation_options[:sym] == field && !options[:reverse] |
|
|
414 | 410 | sqls = [sql, sql_for_relations(field, operator, value, :reverse => true)] |
|
|
415 | 411 | sqls.join(["!", "!*", "!p"].include?(operator) ? " AND " : " OR ") |
|
|
416 | 412 | else |
|
|
417 | 413 | sql |
|
|
418 | 414 | end |
|
|
419 | 415 | end |
|
|
420 | 416 | |
|
|
421 | 417 | IssueRelation::TYPES.keys.each do |relation_type| |
|
|
422 | 418 | alias_method "sql_for_#{relation_type}_field".to_sym, :sql_for_relations |
|
|
423 | 419 | end |
|
|
424 | 420 | end |
General Comments 0
You need to be logged in to leave comments.
Login now