##// END OF EJS Templates
Use Query.visible scope....
Jean-Philippe Lang -
r7966:b9e02477e902
parent child
Show More
@@ -1,304 +1,301
1 1 # Redmine - project management software
2 2 # Copyright (C) 2006-2011 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 module IssuesHelper
19 19 include ApplicationHelper
20 20
21 21 def issue_list(issues, &block)
22 22 ancestors = []
23 23 issues.each do |issue|
24 24 while (ancestors.any? && !issue.is_descendant_of?(ancestors.last))
25 25 ancestors.pop
26 26 end
27 27 yield issue, ancestors.size
28 28 ancestors << issue unless issue.leaf?
29 29 end
30 30 end
31 31
32 32 # Renders a HTML/CSS tooltip
33 33 #
34 34 # To use, a trigger div is needed. This is a div with the class of "tooltip"
35 35 # that contains this method wrapped in a span with the class of "tip"
36 36 #
37 37 # <div class="tooltip"><%= link_to_issue(issue) %>
38 38 # <span class="tip"><%= render_issue_tooltip(issue) %></span>
39 39 # </div>
40 40 #
41 41 def render_issue_tooltip(issue)
42 42 @cached_label_status ||= l(:field_status)
43 43 @cached_label_start_date ||= l(:field_start_date)
44 44 @cached_label_due_date ||= l(:field_due_date)
45 45 @cached_label_assigned_to ||= l(:field_assigned_to)
46 46 @cached_label_priority ||= l(:field_priority)
47 47 @cached_label_project ||= l(:field_project)
48 48
49 49 (link_to_issue(issue) + "<br /><br />" +
50 50 "<strong>#{@cached_label_project}</strong>: #{link_to_project(issue.project)}<br />" +
51 51 "<strong>#{@cached_label_status}</strong>: #{h(issue.status.name)}<br />" +
52 52 "<strong>#{@cached_label_start_date}</strong>: #{format_date(issue.start_date)}<br />" +
53 53 "<strong>#{@cached_label_due_date}</strong>: #{format_date(issue.due_date)}<br />" +
54 54 "<strong>#{@cached_label_assigned_to}</strong>: #{h(issue.assigned_to)}<br />" +
55 55 "<strong>#{@cached_label_priority}</strong>: #{h(issue.priority.name)}").html_safe
56 56 end
57 57
58 58 def issue_heading(issue)
59 59 h("#{issue.tracker} ##{issue.id}")
60 60 end
61 61
62 62 def render_issue_subject_with_tree(issue)
63 63 s = ''
64 64 ancestors = issue.root? ? [] : issue.ancestors.visible.all
65 65 ancestors.each do |ancestor|
66 66 s << '<div>' + content_tag('p', link_to_issue(ancestor))
67 67 end
68 68 s << '<div>'
69 69 subject = h(issue.subject)
70 70 if issue.is_private?
71 71 subject = content_tag('span', l(:field_is_private), :class => 'private') + ' ' + subject
72 72 end
73 73 s << content_tag('h3', subject)
74 74 s << '</div>' * (ancestors.size + 1)
75 75 s.html_safe
76 76 end
77 77
78 78 def render_descendants_tree(issue)
79 79 s = '<form><table class="list issues">'
80 80 issue_list(issue.descendants.visible.sort_by(&:lft)) do |child, level|
81 81 s << content_tag('tr',
82 82 content_tag('td', check_box_tag("ids[]", child.id, false, :id => nil), :class => 'checkbox') +
83 83 content_tag('td', link_to_issue(child, :truncate => 60), :class => 'subject') +
84 84 content_tag('td', h(child.status)) +
85 85 content_tag('td', link_to_user(child.assigned_to)) +
86 86 content_tag('td', progress_bar(child.done_ratio, :width => '80px')),
87 87 :class => "issue issue-#{child.id} hascontextmenu #{level > 0 ? "idnt idnt-#{level}" : nil}")
88 88 end
89 89 s << '</table></form>'
90 90 s.html_safe
91 91 end
92 92
93 93 def render_custom_fields_rows(issue)
94 94 return if issue.custom_field_values.empty?
95 95 ordered_values = []
96 96 half = (issue.custom_field_values.size / 2.0).ceil
97 97 half.times do |i|
98 98 ordered_values << issue.custom_field_values[i]
99 99 ordered_values << issue.custom_field_values[i + half]
100 100 end
101 101 s = "<tr>\n"
102 102 n = 0
103 103 ordered_values.compact.each do |value|
104 104 s << "</tr>\n<tr>\n" if n > 0 && (n % 2) == 0
105 105 s << "\t<th>#{ h(value.custom_field.name) }:</th><td>#{ simple_format_without_paragraph(h(show_value(value))) }</td>\n"
106 106 n += 1
107 107 end
108 108 s << "</tr>\n"
109 109 s.html_safe
110 110 end
111 111
112 112 def issues_destroy_confirmation_message(issues)
113 113 issues = [issues] unless issues.is_a?(Array)
114 114 message = l(:text_issues_destroy_confirmation)
115 115 descendant_count = issues.inject(0) {|memo, i| memo += (i.right - i.left - 1)/2}
116 116 if descendant_count > 0
117 117 issues.each do |issue|
118 118 next if issue.root?
119 119 issues.each do |other_issue|
120 120 descendant_count -= 1 if issue.is_descendant_of?(other_issue)
121 121 end
122 122 end
123 123 if descendant_count > 0
124 124 message << "\n" + l(:text_issues_destroy_descendants_confirmation, :count => descendant_count)
125 125 end
126 126 end
127 127 message
128 128 end
129 129
130 130 def sidebar_queries
131 131 unless @sidebar_queries
132 # User can see public queries and his own queries
133 visible = ARCondition.new(["is_public = ? OR user_id = ?", true, (User.current.logged? ? User.current.id : 0)])
134 # Project specific queries and global queries
135 visible << (@project.nil? ? ["project_id IS NULL"] : ["project_id IS NULL OR project_id = ?", @project.id])
136 @sidebar_queries = Query.find(:all,
137 :select => 'id, name, is_public',
138 :order => "name ASC",
139 :conditions => visible.conditions)
132 @sidebar_queries = Query.visible.all(
133 :order => "#{Query.table_name}.name ASC",
134 # Project specific queries and global queries
135 :conditions => (@project.nil? ? ["project_id IS NULL"] : ["project_id IS NULL OR project_id = ?", @project.id])
136 )
140 137 end
141 138 @sidebar_queries
142 139 end
143 140
144 141 def query_links(title, queries)
145 142 # links to #index on issues/show
146 143 url_params = controller_name == 'issues' ? {:controller => 'issues', :action => 'index', :project_id => @project} : params
147 144
148 145 content_tag('h3', h(title)) +
149 146 queries.collect {|query|
150 147 link_to(h(query.name), url_params.merge(:query_id => query))
151 148 }.join('<br />')
152 149 end
153 150
154 151 def render_sidebar_queries
155 152 out = ''
156 153 queries = sidebar_queries.select {|q| !q.is_public?}
157 154 out << query_links(l(:label_my_queries), queries) if queries.any?
158 155 queries = sidebar_queries.select {|q| q.is_public?}
159 156 out << query_links(l(:label_query_plural), queries) if queries.any?
160 157 out
161 158 end
162 159
163 160 def show_detail(detail, no_html=false)
164 161 case detail.property
165 162 when 'attr'
166 163 field = detail.prop_key.to_s.gsub(/\_id$/, "")
167 164 label = l(("field_" + field).to_sym)
168 165 case
169 166 when ['due_date', 'start_date'].include?(detail.prop_key)
170 167 value = format_date(detail.value.to_date) if detail.value
171 168 old_value = format_date(detail.old_value.to_date) if detail.old_value
172 169
173 170 when ['project_id', 'status_id', 'tracker_id', 'assigned_to_id',
174 171 'priority_id', 'category_id', 'fixed_version_id'].include?(detail.prop_key)
175 172 value = find_name_by_reflection(field, detail.value)
176 173 old_value = find_name_by_reflection(field, detail.old_value)
177 174
178 175 when detail.prop_key == 'estimated_hours'
179 176 value = "%0.02f" % detail.value.to_f unless detail.value.blank?
180 177 old_value = "%0.02f" % detail.old_value.to_f unless detail.old_value.blank?
181 178
182 179 when detail.prop_key == 'parent_id'
183 180 label = l(:field_parent_issue)
184 181 value = "##{detail.value}" unless detail.value.blank?
185 182 old_value = "##{detail.old_value}" unless detail.old_value.blank?
186 183
187 184 when detail.prop_key == 'is_private'
188 185 value = l(detail.value == "0" ? :general_text_No : :general_text_Yes) unless detail.value.blank?
189 186 old_value = l(detail.old_value == "0" ? :general_text_No : :general_text_Yes) unless detail.old_value.blank?
190 187 end
191 188 when 'cf'
192 189 custom_field = CustomField.find_by_id(detail.prop_key)
193 190 if custom_field
194 191 label = custom_field.name
195 192 value = format_value(detail.value, custom_field.field_format) if detail.value
196 193 old_value = format_value(detail.old_value, custom_field.field_format) if detail.old_value
197 194 end
198 195 when 'attachment'
199 196 label = l(:label_attachment)
200 197 end
201 198 call_hook(:helper_issues_show_detail_after_setting,
202 199 {:detail => detail, :label => label, :value => value, :old_value => old_value })
203 200
204 201 label ||= detail.prop_key
205 202 value ||= detail.value
206 203 old_value ||= detail.old_value
207 204
208 205 unless no_html
209 206 label = content_tag('strong', label)
210 207 old_value = content_tag("i", h(old_value)) if detail.old_value
211 208 old_value = content_tag("strike", old_value) if detail.old_value and detail.value.blank?
212 209 if detail.property == 'attachment' && !value.blank? && a = Attachment.find_by_id(detail.prop_key)
213 210 # Link to the attachment if it has not been removed
214 211 value = link_to_attachment(a)
215 212 else
216 213 value = content_tag("i", h(value)) if value
217 214 end
218 215 end
219 216
220 217 if detail.property == 'attr' && detail.prop_key == 'description'
221 218 s = l(:text_journal_changed_no_detail, :label => label)
222 219 unless no_html
223 220 diff_link = link_to 'diff',
224 221 {:controller => 'journals', :action => 'diff', :id => detail.journal_id, :detail_id => detail.id},
225 222 :title => l(:label_view_diff)
226 223 s << " (#{ diff_link })"
227 224 end
228 225 s.html_safe
229 226 elsif !detail.value.blank?
230 227 case detail.property
231 228 when 'attr', 'cf'
232 229 if !detail.old_value.blank?
233 230 l(:text_journal_changed, :label => label, :old => old_value, :new => value).html_safe
234 231 else
235 232 l(:text_journal_set_to, :label => label, :value => value).html_safe
236 233 end
237 234 when 'attachment'
238 235 l(:text_journal_added, :label => label, :value => value).html_safe
239 236 end
240 237 else
241 238 l(:text_journal_deleted, :label => label, :old => old_value).html_safe
242 239 end
243 240 end
244 241
245 242 # Find the name of an associated record stored in the field attribute
246 243 def find_name_by_reflection(field, id)
247 244 association = Issue.reflect_on_association(field.to_sym)
248 245 if association
249 246 record = association.class_name.constantize.find_by_id(id)
250 247 return record.name if record
251 248 end
252 249 end
253 250
254 251 # Renders issue children recursively
255 252 def render_api_issue_children(issue, api)
256 253 return if issue.leaf?
257 254 api.array :children do
258 255 issue.children.each do |child|
259 256 api.issue(:id => child.id) do
260 257 api.tracker(:id => child.tracker_id, :name => child.tracker.name) unless child.tracker.nil?
261 258 api.subject child.subject
262 259 render_api_issue_children(child, api)
263 260 end
264 261 end
265 262 end
266 263 end
267 264
268 265 def issues_to_csv(issues, project, query, options={})
269 266 decimal_separator = l(:general_csv_decimal_separator)
270 267 encoding = l(:general_csv_encoding)
271 268 columns = (options[:columns] == 'all' ? query.available_columns : query.columns)
272 269
273 270 export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv|
274 271 # csv header fields
275 272 csv << [ "#" ] + columns.collect {|c| Redmine::CodesetUtil.from_utf8(c.caption.to_s, encoding) } +
276 273 (options[:description] ? [Redmine::CodesetUtil.from_utf8(l(:field_description), encoding)] : [])
277 274
278 275 # csv lines
279 276 issues.each do |issue|
280 277 col_values = columns.collect do |column|
281 278 s = if column.is_a?(QueryCustomFieldColumn)
282 279 cv = issue.custom_values.detect {|v| v.custom_field_id == column.custom_field.id}
283 280 show_value(cv)
284 281 else
285 282 value = issue.send(column.name)
286 283 if value.is_a?(Date)
287 284 format_date(value)
288 285 elsif value.is_a?(Time)
289 286 format_time(value)
290 287 elsif value.is_a?(Float)
291 288 value.to_s.gsub('.', decimal_separator)
292 289 else
293 290 value
294 291 end
295 292 end
296 293 s.to_s
297 294 end
298 295 csv << [ issue.id.to_s ] + col_values.collect {|c| Redmine::CodesetUtil.from_utf8(c.to_s, encoding) } +
299 296 (options[:description] ? [Redmine::CodesetUtil.from_utf8(issue.description, encoding)] : [])
300 297 end
301 298 end
302 299 export
303 300 end
304 301 end
General Comments 0
You need to be logged in to leave comments. Login now