issues_helper.rb
189 lines
| 8.0 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
|
r1296 | |||
| def sidebar_queries | ||||
| unless @sidebar_queries | ||||
| # User can see public queries and his own queries | ||||
| visible = ARCondition.new(["is_public = ? OR user_id = ?", true, (User.current.logged? ? User.current.id : 0)]) | ||||
| # Project specific queries and global queries | ||||
| visible << (@project.nil? ? ["project_id IS NULL"] : ["project_id IS NULL OR project_id = ?", @project.id]) | ||||
| @sidebar_queries = Query.find(:all, | ||||
|
Jean-Philippe Lang
|
r2511 | :select => 'id, name', | ||
|
Jean-Philippe Lang
|
r1296 | :order => "name ASC", | ||
| :conditions => visible.conditions) | ||||
| end | ||||
| @sidebar_queries | ||||
| end | ||||
|
Jean-Philippe Lang
|
r783 | |||
|
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 | ||||
|
Jean-Philippe Lang
|
r1551 | when 'project_id' | ||
| p = Project.find_by_id(detail.value) and value = p.name if detail.value | ||||
| p = Project.find_by_id(detail.old_value) and old_value = p.name if detail.old_value | ||||
|
Jean-Philippe Lang
|
r330 | 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 | ||||
|
Jean-Philippe Lang
|
r1551 | when 'tracker_id' | ||
| t = Tracker.find_by_id(detail.value) and value = t.name if detail.value | ||||
| t = Tracker.find_by_id(detail.old_value) and old_value = t.name if detail.old_value | ||||
|
Jean-Philippe Lang
|
r330 | 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' | ||||
Eric Davis
|
r2677 | e = IssuePriority.find_by_id(detail.value) and value = e.name if detail.value | ||
| e = IssuePriority.find_by_id(detail.old_value) and old_value = e.name if detail.old_value | ||||
|
Jean-Philippe Lang
|
r330 | 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 | ||||
|
Jean-Philippe Lang
|
r1753 | when 'estimated_hours' | ||
| value = "%0.02f" % detail.value.to_f unless detail.value.blank? | ||||
| old_value = "%0.02f" % detail.old_value.to_f unless detail.old_value.blank? | ||||
|
Jean-Philippe Lang
|
r330 | 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 | ||
|
Jean-Philippe Lang
|
r1785 | call_hook(:helper_issues_show_detail_after_setting, {:detail => detail, :label => label, :value => value, :old_value => old_value }) | ||
|
Jean-Philippe Lang
|
r330 | 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
|
r1669 | if detail.property == 'attachment' && !value.blank? && a = Attachment.find_by_id(detail.prop_key) | ||
|
Jean-Philippe Lang
|
r718 | # Link to the attachment if it has not been removed | ||
|
Jean-Philippe Lang
|
r1669 | value = link_to_attachment(a) | ||
|
Jean-Philippe Lang
|
r718 | 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
|
r2430 | label + " " + l(:text_journal_changed, :old => old_value, :new => value) | ||
|
Jean-Philippe Lang
|
r422 | 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') | ||||
|
Jean-Philippe Lang
|
r1577 | decimal_separator = l(:general_csv_decimal_separator) | ||
|
Jean-Philippe Lang
|
r874 | 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), | ||||
|
Jean-Philippe Lang
|
r1152 | l(:field_estimated_hours), | ||
|
Jean-Philippe Lang
|
r874 | 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" | ||||
|
Jean-Philippe Lang
|
r1578 | custom_fields = project.nil? ? IssueCustomField.for_all : project.all_issue_custom_fields | ||
|
Jean-Philippe Lang
|
r920 | custom_fields.each {|f| headers << f.name} | ||
|
Jean-Philippe Lang
|
r1277 | # Description in the last column | ||
| headers << l(:field_description) | ||||
|
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
|
r1577 | issue.estimated_hours.to_s.gsub('.', decimal_separator), | ||
|
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
|
r1277 | fields << issue.description | ||
|
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 | ||