Redmine

# 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.

require 'csv'

module IssuesHelper

  include ApplicationHelper

  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.total('start_date'))}<br />" +

      "<strong>#{@cached_label_due_date}</strong>: #{format_date(issue.total('due_date'))}<br />" +

      "<strong>#{@cached_label_assigned_to}</strong>: #{issue.assigned_to}<br />" +

      "<strong>#{@cached_label_priority}</strong>: #{issue.total('priority').name}"

  end

  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

    when 'attachment'

      label = l(:label_attachment)

    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?)

      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

    end

    if !detail.value.blank?

      case detail.property

      when 'attr', 'cf'

        if !detail.old_value.blank?

          label + " " + l(:text_journal_changed, old_value, value)

        else

          label + " " + l(:text_journal_set_to, value)

        end

      when 'attachment'

        "#{label} #{value} #{l(:label_added)}"

      end

    else

      case detail.property

      when 'attr', 'cf'

        label + " " + l(:text_journal_deleted) + " (#{old_value})"

      when 'attachment'

        "#{label} #{old_value} #{l(:label_deleted)}"

      end

    end

  end

  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),

                  l(:field_category),

                  l(:field_fixed_version),

                  l(:field_author),

                  l(:field_start_date),

                  l(:field_due_date),

                  l(:field_done_ratio),

                  l(:field_created_on),

                  l(:field_updated_on)

                  ]

      # 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}

      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.total('status').name, 

                  issue.project.name,

                  issue.tracker.name, 

                  issue.total('priority').name,

                  issue.subject,

                  issue.assigned_to,

                  issue.category,

                  issue.fixed_version,

                  issue.author.name,

                  format_date(issue.total('start_date')),

                  format_date(issue.total('due_date')),

                  issue.total('done_ratio'),

                  format_time(issue.created_on),  

                  format_time(issue.updated_on)

                  ]

        custom_fields.each {|f| fields << show_value(issue.custom_value_for(f)) }

        csv << fields.collect {|c| begin; ic.iconv(c.to_s); rescue; c.to_s; end }

      end

    end

    export.rewind

    export

  end

end