issues_helper.rb
159 lines
| 6.5 KiB
| text/x-ruby
|
RubyLexer
Jean-Philippe Lang
|
r330 | # redMine - project management software | ||
| # Copyright (C) 2006 Jean-Philippe Lang | ||||
| # | ||||
| # This program is free software; you can redistribute it and/or | ||||
| # modify it under the terms of the GNU General Public License | ||||
| # as published by the Free Software Foundation; either version 2 | ||||
| # of the License, or (at your option) any later version. | ||||
| # | ||||
| # This program is distributed in the hope that it will be useful, | ||||
| # but WITHOUT ANY WARRANTY; without even the implied warranty of | ||||
| # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | ||||
| # GNU General Public License for more details. | ||||
| # | ||||
| # You should have received a copy of the GNU General Public License | ||||
| # along with this program; if not, write to the Free Software | ||||
| # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. | ||||
|
Jean-Philippe Lang
|
r874 | require 'csv' | ||
|
Jean-Philippe Lang
|
r330 | module IssuesHelper | ||
|
Jean-Philippe Lang
|
r928 | include ApplicationHelper | ||
|
Jean-Philippe Lang
|
r330 | |||
|
Jean-Philippe Lang
|
r783 | def render_issue_tooltip(issue) | ||
| @cached_label_start_date ||= l(:field_start_date) | ||||
| @cached_label_due_date ||= l(:field_due_date) | ||||
| @cached_label_assigned_to ||= l(:field_assigned_to) | ||||
| @cached_label_priority ||= l(:field_priority) | ||||
| link_to_issue(issue) + ": #{h(issue.subject)}<br /><br />" + | ||||
| "<strong>#{@cached_label_start_date}</strong>: #{format_date(issue.start_date)}<br />" + | ||||
| "<strong>#{@cached_label_due_date}</strong>: #{format_date(issue.due_date)}<br />" + | ||||
| "<strong>#{@cached_label_assigned_to}</strong>: #{issue.assigned_to}<br />" + | ||||
| "<strong>#{@cached_label_priority}</strong>: #{issue.priority.name}" | ||||
| end | ||||
|
Jean-Philippe Lang
|
r330 | def show_detail(detail, no_html=false) | ||
| case detail.property | ||||
| when 'attr' | ||||
| label = l(("field_" + detail.prop_key.to_s.gsub(/\_id$/, "")).to_sym) | ||||
| case detail.prop_key | ||||
| when 'due_date', 'start_date' | ||||
| value = format_date(detail.value.to_date) if detail.value | ||||
| old_value = format_date(detail.old_value.to_date) if detail.old_value | ||||
| when 'status_id' | ||||
| s = IssueStatus.find_by_id(detail.value) and value = s.name if detail.value | ||||
| s = IssueStatus.find_by_id(detail.old_value) and old_value = s.name if detail.old_value | ||||
| when 'assigned_to_id' | ||||
| u = User.find_by_id(detail.value) and value = u.name if detail.value | ||||
| u = User.find_by_id(detail.old_value) and old_value = u.name if detail.old_value | ||||
| when 'priority_id' | ||||
| e = Enumeration.find_by_id(detail.value) and value = e.name if detail.value | ||||
| e = Enumeration.find_by_id(detail.old_value) and old_value = e.name if detail.old_value | ||||
| when 'category_id' | ||||
| c = IssueCategory.find_by_id(detail.value) and value = c.name if detail.value | ||||
| c = IssueCategory.find_by_id(detail.old_value) and old_value = c.name if detail.old_value | ||||
| when 'fixed_version_id' | ||||
| v = Version.find_by_id(detail.value) and value = v.name if detail.value | ||||
| v = Version.find_by_id(detail.old_value) and old_value = v.name if detail.old_value | ||||
| end | ||||
| when 'cf' | ||||
| custom_field = CustomField.find_by_id(detail.prop_key) | ||||
| if custom_field | ||||
| label = custom_field.name | ||||
| value = format_value(detail.value, custom_field.field_format) if detail.value | ||||
| old_value = format_value(detail.old_value, custom_field.field_format) if detail.old_value | ||||
| end | ||||
|
Jean-Philippe Lang
|
r422 | when 'attachment' | ||
| label = l(:label_attachment) | ||||
|
Jean-Philippe Lang
|
r330 | end | ||
| label ||= detail.prop_key | ||||
| value ||= detail.value | ||||
| old_value ||= detail.old_value | ||||
| unless no_html | ||||
| label = content_tag('strong', label) | ||||
| old_value = content_tag("i", h(old_value)) if detail.old_value | ||||
| old_value = content_tag("strike", old_value) if detail.old_value and (!detail.value or detail.value.empty?) | ||||
|
Jean-Philippe Lang
|
r718 | if detail.property == 'attachment' && !value.blank? && Attachment.find_by_id(detail.prop_key) | ||
| # Link to the attachment if it has not been removed | ||||
| value = link_to(value, :controller => 'attachments', :action => 'download', :id => detail.prop_key) | ||||
| else | ||||
| value = content_tag("i", h(value)) if value | ||||
| end | ||||
|
Jean-Philippe Lang
|
r330 | end | ||
|
Jean-Philippe Lang
|
r684 | if !detail.value.blank? | ||
|
Jean-Philippe Lang
|
r422 | case detail.property | ||
| when 'attr', 'cf' | ||||
|
Jean-Philippe Lang
|
r684 | if !detail.old_value.blank? | ||
|
Jean-Philippe Lang
|
r422 | label + " " + l(:text_journal_changed, old_value, value) | ||
| else | ||||
| label + " " + l(:text_journal_set_to, value) | ||||
| end | ||||
| when 'attachment' | ||||
| "#{label} #{value} #{l(:label_added)}" | ||||
|
Jean-Philippe Lang
|
r330 | end | ||
| else | ||||
|
Jean-Philippe Lang
|
r422 | case detail.property | ||
| when 'attr', 'cf' | ||||
| label + " " + l(:text_journal_deleted) + " (#{old_value})" | ||||
| when 'attachment' | ||||
| "#{label} #{old_value} #{l(:label_deleted)}" | ||||
| end | ||||
|
Jean-Philippe Lang
|
r330 | end | ||
|
Jean-Philippe Lang
|
r52 | end | ||
|
Jean-Philippe Lang
|
r874 | |||
| def issues_to_csv(issues, project = nil) | ||||
| ic = Iconv.new(l(:general_csv_encoding), 'UTF-8') | ||||
| export = StringIO.new | ||||
| CSV::Writer.generate(export, l(:general_csv_separator)) do |csv| | ||||
| # csv header fields | ||||
| headers = [ "#", | ||||
| l(:field_status), | ||||
| l(:field_project), | ||||
| l(:field_tracker), | ||||
| l(:field_priority), | ||||
| l(:field_subject), | ||||
| l(:field_assigned_to), | ||||
|
Jean-Philippe Lang
|
r901 | l(:field_category), | ||
| l(:field_fixed_version), | ||||
|
Jean-Philippe Lang
|
r874 | l(:field_author), | ||
| l(:field_start_date), | ||||
| l(:field_due_date), | ||||
| l(:field_done_ratio), | ||||
| l(:field_created_on), | ||||
| l(:field_updated_on) | ||||
| ] | ||||
|
Jean-Philippe Lang
|
r920 | # Export project custom fields if project is given | ||
| # otherwise export custom fields marked as "For all projects" | ||||
| custom_fields = project.nil? ? IssueCustomField.for_all : project.all_custom_fields | ||||
| custom_fields.each {|f| headers << f.name} | ||||
|
Jean-Philippe Lang
|
r874 | csv << headers.collect {|c| begin; ic.iconv(c.to_s); rescue; c.to_s; end } | ||
| # csv lines | ||||
| issues.each do |issue| | ||||
| fields = [issue.id, | ||||
| issue.status.name, | ||||
| issue.project.name, | ||||
| issue.tracker.name, | ||||
| issue.priority.name, | ||||
| issue.subject, | ||||
|
Jean-Philippe Lang
|
r901 | issue.assigned_to, | ||
| issue.category, | ||||
| issue.fixed_version, | ||||
|
Jean-Philippe Lang
|
r874 | issue.author.name, | ||
|
Jean-Philippe Lang
|
r928 | format_date(issue.start_date), | ||
| format_date(issue.due_date), | ||||
|
Jean-Philippe Lang
|
r874 | issue.done_ratio, | ||
|
Jean-Philippe Lang
|
r928 | format_time(issue.created_on), | ||
| format_time(issue.updated_on) | ||||
|
Jean-Philippe Lang
|
r874 | ] | ||
|
Jean-Philippe Lang
|
r920 | custom_fields.each {|f| fields << show_value(issue.custom_value_for(f)) } | ||
|
Jean-Philippe Lang
|
r874 | csv << fields.collect {|c| begin; ic.iconv(c.to_s); rescue; c.to_s; end } | ||
| end | ||||
| end | ||||
| export.rewind | ||||
| export | ||||
| end | ||||
|
Jean-Philippe Lang
|
r2 | end | ||