jro_apps/redmine Commit - r3479:2f0fbef858c9

1

# redMine - project management software

1

# redMine - project management software

2

3

#

3

#

4

# This program is free software; you can redistribute it and/or

4

# This program is free software; you can redistribute it and/or

5

# modify it under the terms of the GNU General Public License

5

# modify it under the terms of the GNU General Public License

6

# as published by the Free Software Foundation; either version 2

6

# as published by the Free Software Foundation; either version 2

7

# of the License, or (at your option) any later version.

7

# of the License, or (at your option) any later version.

8

#

8

#

9

# This program is distributed in the hope that it will be useful,

9

# This program is distributed in the hope that it will be useful,

10

# but WITHOUT ANY WARRANTY; without even the implied warranty of

10

# but WITHOUT ANY WARRANTY; without even the implied warranty of

11

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

11

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

12

# GNU General Public License for more details.

12

# GNU General Public License for more details.

13

#

13

#

14

# You should have received a copy of the GNU General Public License

14

# You should have received a copy of the GNU General Public License

15

# along with this program; if not, write to the Free Software

15

# along with this program; if not, write to the Free Software

16

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

16

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

17

18

module IssuesHelper

18

module IssuesHelper

19

include ApplicationHelper

19

include ApplicationHelper

20

21

def render_issue_tooltip(issue)

21

def render_issue_tooltip(issue)

22

@cached_label_start_date ||= l(:field_start_date)

22

@cached_label_start_date ||= l(:field_start_date)

23

@cached_label_due_date ||= l(:field_due_date)

23

@cached_label_due_date ||= l(:field_due_date)

24

@cached_label_assigned_to ||= l(:field_assigned_to)

24

@cached_label_assigned_to ||= l(:field_assigned_to)

25

@cached_label_priority ||= l(:field_priority)

25

@cached_label_priority ||= l(:field_priority)

26

27

link_to_issue(issue) + "<br /><br />" +

27

link_to_issue(issue) + "<br /><br />" +

28

"<strong>#{@cached_label_start_date}</strong>: #{format_date(issue.start_date)}<br />" +

28

"<strong>#{@cached_label_start_date}</strong>: #{format_date(issue.start_date)}<br />" +

29

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

29

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

30

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

30

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

31

"<strong>#{@cached_label_priority}</strong>: #{issue.priority.name}"

31

"<strong>#{@cached_label_priority}</strong>: #{issue.priority.name}"

32

end

32

end

33

34

def render_issue_subject_with_tree(issue)

34

def render_issue_subject_with_tree(issue)

35

s = ''

35

s = ''

36

issue.ancestors.each do |ancestor|

36

issue.ancestors.each do |ancestor|

37

s << '<div>' + content_tag('p', link_to_issue(ancestor))

37

s << '<div>' + content_tag('p', link_to_issue(ancestor))

38

end

38

end

39

s << '<div>' + content_tag('h3', h(issue.subject))

39

s << '<div>' + content_tag('h3', h(issue.subject))

40

s << '</div>' * (issue.ancestors.size + 1)

40

s << '</div>' * (issue.ancestors.size + 1)

41

s

41

s

42

end

42

end

43

44

def render_descendants_tree(issue)

44

def render_descendants_tree(issue)

45

s = '<form><table class="list issues">'

45

s = '<form><table class="list issues">'

46

ancestors = []

46

ancestors = []

47

issue.descendants.sort_by(&:lft).each do |child|

47

issue.descendants.sort_by(&:lft).each do |child|

48

level = child.level - issue.level - 1

48

level = child.level - issue.level - 1

49

s << content_tag('tr',

49

s << content_tag('tr',

50

content_tag('td', check_box_tag("ids[]", child.id, false, :id => nil), :class => 'checkbox') +

50

content_tag('td', check_box_tag("ids[]", child.id, false, :id => nil), :class => 'checkbox') +

51

content_tag('td', link_to_issue(child, :truncate => 60), :class => 'subject',

51

content_tag('td', link_to_issue(child, :truncate => 60), :class => 'subject',

52

:style => "padding-left: #{level * 20}px") +

52

:style => "padding-left: #{level * 20}px") +

53

content_tag('td', h(child.status)) +

53

content_tag('td', h(child.status)) +

54

content_tag('td', link_to_user(child.assigned_to)) +

54

content_tag('td', link_to_user(child.assigned_to)) +

55

content_tag('td', progress_bar(child.done_ratio, :width => '80px')),

55

content_tag('td', progress_bar(child.done_ratio, :width => '80px')),

56

:class => "issue-#{child.id} hascontextmenu")

56

:class => "issue-#{child.id} hascontextmenu")

57

end

57

end

58

s << '</form></table>'

58

s << '</form></table>'

59

s

59

s

60

end

60

end

61

62

def render_custom_fields_rows(issue)

62

def render_custom_fields_rows(issue)

63

return if issue.custom_field_values.empty?

63

return if issue.custom_field_values.empty?

64

ordered_values = []

64

ordered_values = []

65

half = (issue.custom_field_values.size / 2.0).ceil

65

half = (issue.custom_field_values.size / 2.0).ceil

66

half.times do |i|

66

half.times do |i|

67

ordered_values << issue.custom_field_values[i]

67

ordered_values << issue.custom_field_values[i]

68

ordered_values << issue.custom_field_values[i + half]

68

ordered_values << issue.custom_field_values[i + half]

69

end

69

end

70

s = "<tr>\n"

70

s = "<tr>\n"

71

n = 0

71

n = 0

72

ordered_values.compact.each do |value|

72

ordered_values.compact.each do |value|

73

s << "</tr>\n<tr>\n" if n > 0 && (n % 2) == 0

73

s << "</tr>\n<tr>\n" if n > 0 && (n % 2) == 0

74

s << "\t<th>#{ h(value.custom_field.name) }:</th><td>#{ simple_format_without_paragraph(h(show_value(value))) }</td>\n"

74

s << "\t<th>#{ h(value.custom_field.name) }:</th><td>#{ simple_format_without_paragraph(h(show_value(value))) }</td>\n"

75

n += 1

75

n += 1

76

end

76

end

77

s << "</tr>\n"

77

s << "</tr>\n"

78

s

78

s

79

end

79

end

80

81

def sidebar_queries

81

def sidebar_queries

82

unless @sidebar_queries

82

unless @sidebar_queries

83

# User can see public queries and his own queries

83

# User can see public queries and his own queries

84

visible = ARCondition.new(["is_public = ? OR user_id = ?", true, (User.current.logged? ? User.current.id : 0)])

84

visible = ARCondition.new(["is_public = ? OR user_id = ?", true, (User.current.logged? ? User.current.id : 0)])

85

# Project specific queries and global queries

85

# Project specific queries and global queries

86

visible << (@project.nil? ? ["project_id IS NULL"] : ["project_id IS NULL OR project_id = ?", @project.id])

86

visible << (@project.nil? ? ["project_id IS NULL"] : ["project_id IS NULL OR project_id = ?", @project.id])

87

@sidebar_queries = Query.find(:all,

87

@sidebar_queries = Query.find(:all,

88

:select => 'id, name',

88

:select => 'id, name',

89

:order => "name ASC",

89

:order => "name ASC",

90

:conditions => visible.conditions)

90

:conditions => visible.conditions)

91

end

91

end

92

@sidebar_queries

92

@sidebar_queries

93

end

93

end

94

95

def show_detail(detail, no_html=false)

95

def show_detail(detail, no_html=false)

96

case detail.property

96

case detail.property

97

when 'attr'

97

when 'attr'

98

field = detail.prop_key.to_s.gsub(/\_id$/, "")

98

field = detail.prop_key.to_s.gsub(/\_id$/, "")

99

label = l(("field_" + field).to_sym)

99

label = l(("field_" + field).to_sym)

100

case

100

case

101

when ['due_date', 'start_date'].include?(detail.prop_key)

101

when ['due_date', 'start_date'].include?(detail.prop_key)

102

value = format_date(detail.value.to_date) if detail.value

102

value = format_date(detail.value.to_date) if detail.value

103

old_value = format_date(detail.old_value.to_date) if detail.old_value

103

old_value = format_date(detail.old_value.to_date) if detail.old_value

104

105

when ['project_id', 'status_id', 'tracker_id', 'assigned_to_id', 'priority_id', 'category_id', 'fixed_version_id'].include?(detail.prop_key)

105

when ['project_id', 'status_id', 'tracker_id', 'assigned_to_id', 'priority_id', 'category_id', 'fixed_version_id'].include?(detail.prop_key)

106

value = find_name_by_reflection(field, detail.value)

106

value = find_name_by_reflection(field, detail.value)

107

old_value = find_name_by_reflection(field, detail.old_value)

107

old_value = find_name_by_reflection(field, detail.old_value)

108

109

when detail.prop_key == 'estimated_hours'

109

when detail.prop_key == 'estimated_hours'

110

value = "%0.02f" % detail.value.to_f unless detail.value.blank?

110

value = "%0.02f" % detail.value.to_f unless detail.value.blank?

111

old_value = "%0.02f" % detail.old_value.to_f unless detail.old_value.blank?

111

old_value = "%0.02f" % detail.old_value.to_f unless detail.old_value.blank?

112

113

when detail.prop_key == 'parent_id'

114

label = l(:field_parent_issue)

115

value = "##{detail.value}" unless detail.value.blank?

116

old_value = "##{detail.old_value}" unless detail.old_value.blank?

112

end

117

end

113

when 'cf'

118

when 'cf'

114

custom_field = CustomField.find_by_id(detail.prop_key)

119

custom_field = CustomField.find_by_id(detail.prop_key)

115

if custom_field

120

if custom_field

116

label = custom_field.name

121

label = custom_field.name

117

value = format_value(detail.value, custom_field.field_format) if detail.value

122

value = format_value(detail.value, custom_field.field_format) if detail.value

118

old_value = format_value(detail.old_value, custom_field.field_format) if detail.old_value

123

old_value = format_value(detail.old_value, custom_field.field_format) if detail.old_value

119

end

124

end

120

when 'attachment'

125

when 'attachment'

121

label = l(:label_attachment)

126

label = l(:label_attachment)

122

end

127

end

123

call_hook(:helper_issues_show_detail_after_setting, {:detail => detail, :label => label, :value => value, :old_value => old_value })

128

call_hook(:helper_issues_show_detail_after_setting, {:detail => detail, :label => label, :value => value, :old_value => old_value })

124

129

125

label ||= detail.prop_key

130

label ||= detail.prop_key

126

value ||= detail.value

131

value ||= detail.value

127

old_value ||= detail.old_value

132

old_value ||= detail.old_value

128

133

129

unless no_html

134

unless no_html

130

label = content_tag('strong', label)

135

label = content_tag('strong', label)

131

old_value = content_tag("i", h(old_value)) if detail.old_value

136

old_value = content_tag("i", h(old_value)) if detail.old_value

132

old_value = content_tag("strike", old_value) if detail.old_value and (!detail.value or detail.value.empty?)

137

old_value = content_tag("strike", old_value) if detail.old_value and (!detail.value or detail.value.empty?)

133

if detail.property == 'attachment' && !value.blank? && a = Attachment.find_by_id(detail.prop_key)

138

if detail.property == 'attachment' && !value.blank? && a = Attachment.find_by_id(detail.prop_key)

134

# Link to the attachment if it has not been removed

139

# Link to the attachment if it has not been removed

135

value = link_to_attachment(a)

140

value = link_to_attachment(a)

136

else

141

else

137

value = content_tag("i", h(value)) if value

142

value = content_tag("i", h(value)) if value

138

end

143

end

139

end

144

end

140

145

141

if !detail.value.blank?

146

if !detail.value.blank?

142

case detail.property

147

case detail.property

143

when 'attr', 'cf'

148

when 'attr', 'cf'

144

if !detail.old_value.blank?

149

if !detail.old_value.blank?

145

l(:text_journal_changed, :label => label, :old => old_value, :new => value)

150

l(:text_journal_changed, :label => label, :old => old_value, :new => value)

146

else

151

else

147

l(:text_journal_set_to, :label => label, :value => value)

152

l(:text_journal_set_to, :label => label, :value => value)

148

end

153

end

149

when 'attachment'

154

when 'attachment'

150

l(:text_journal_added, :label => label, :value => value)

155

l(:text_journal_added, :label => label, :value => value)

151

end

156

end

152

else

157

else

153

l(:text_journal_deleted, :label => label, :old => old_value)

158

l(:text_journal_deleted, :label => label, :old => old_value)

154

end

159

end

155

end

160

end

156

161

157

# Find the name of an associated record stored in the field attribute

162

# Find the name of an associated record stored in the field attribute

158

def find_name_by_reflection(field, id)

163

def find_name_by_reflection(field, id)

159

association = Issue.reflect_on_association(field.to_sym)

164

association = Issue.reflect_on_association(field.to_sym)

160

if association

165

if association

161

record = association.class_name.constantize.find_by_id(id)

166

record = association.class_name.constantize.find_by_id(id)

162

return record.name if record

167

return record.name if record

163

end

168

end

164

end

169

end

165

170

166

def issues_to_csv(issues, project = nil)

171

def issues_to_csv(issues, project = nil)

167

ic = Iconv.new(l(:general_csv_encoding), 'UTF-8')

172

ic = Iconv.new(l(:general_csv_encoding), 'UTF-8')

168

decimal_separator = l(:general_csv_decimal_separator)

173

decimal_separator = l(:general_csv_decimal_separator)

169

export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv|

174

export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv|

170

# csv header fields

175

# csv header fields

171

headers = [ "#",

176

headers = [ "#",

172

l(:field_status),

177

l(:field_status),

173

l(:field_project),

178

l(:field_project),

174

l(:field_tracker),

179

l(:field_tracker),

175

l(:field_priority),

180

l(:field_priority),

176

l(:field_subject),

181

l(:field_subject),

177

l(:field_assigned_to),

182

l(:field_assigned_to),

178

l(:field_category),

183

l(:field_category),

179

l(:field_fixed_version),

184

l(:field_fixed_version),

180

l(:field_author),

185

l(:field_author),

181

l(:field_start_date),

186

l(:field_start_date),

182

l(:field_due_date),

187

l(:field_due_date),

183

l(:field_done_ratio),

188

l(:field_done_ratio),

184

l(:field_estimated_hours),

189

l(:field_estimated_hours),

185

l(:field_created_on),

190

l(:field_created_on),

186

l(:field_updated_on)

191

l(:field_updated_on)

187

]

192

]

188

# Export project custom fields if project is given

193

# Export project custom fields if project is given

189

# otherwise export custom fields marked as "For all projects"

194

# otherwise export custom fields marked as "For all projects"

190

custom_fields = project.nil? ? IssueCustomField.for_all : project.all_issue_custom_fields

195

custom_fields = project.nil? ? IssueCustomField.for_all : project.all_issue_custom_fields

191

custom_fields.each {|f| headers << f.name}

196

custom_fields.each {|f| headers << f.name}

192

# Description in the last column

197

# Description in the last column

193

headers << l(:field_description)

198

headers << l(:field_description)

194

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

199

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

195

# csv lines

200

# csv lines

196

issues.each do |issue|

201

issues.each do |issue|

197

fields = [issue.id,

202

fields = [issue.id,

198

issue.status.name,

203

issue.status.name,

199

issue.project.name,

204

issue.project.name,

200

issue.tracker.name,

205

issue.tracker.name,

201

issue.priority.name,

206

issue.priority.name,

202

issue.subject,

207

issue.subject,

203

issue.assigned_to,

208

issue.assigned_to,

204

issue.category,

209

issue.category,

205

issue.fixed_version,

210

issue.fixed_version,

206

issue.author.name,

211

issue.author.name,

207

format_date(issue.start_date),

212

format_date(issue.start_date),

208

format_date(issue.due_date),

213

format_date(issue.due_date),

209

issue.done_ratio,

214

issue.done_ratio,

210

issue.estimated_hours.to_s.gsub('.', decimal_separator),

215

issue.estimated_hours.to_s.gsub('.', decimal_separator),

211

format_time(issue.created_on),

216

format_time(issue.created_on),

212

format_time(issue.updated_on)

217

format_time(issue.updated_on)

213

]

218

]

214

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

219

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

215

fields << issue.description

220

fields << issue.description

216

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

221

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

217

end

222

end

218

end

223

end

219

export

224

export

220

end

225

end

221

end

226

end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

             # 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.
             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) + "<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
               def render_issue_subject_with_tree(issue)
                 s = ''
                 issue.ancestors.each do |ancestor|
                   s << '<div>' + content_tag('p', link_to_issue(ancestor))
                 end
                 s << '<div>' + content_tag('h3', h(issue.subject))
                 s << '</div>' * (issue.ancestors.size + 1)
                 s
               end
               def render_descendants_tree(issue)
                 s = '<form><table class="list issues">'
                 ancestors = []
                 issue.descendants.sort_by(&:lft).each do |child|
                   level = child.level - issue.level - 1
                   s << content_tag('tr',
                          content_tag('td', check_box_tag("ids[]", child.id, false, :id => nil), :class => 'checkbox') +
                          content_tag('td', link_to_issue(child, :truncate => 60), :class => 'subject',
                                                                                   :style => "padding-left: #{level * 20}px") +
                          content_tag('td', h(child.status)) +
                          content_tag('td', link_to_user(child.assigned_to)) +
                          content_tag('td', progress_bar(child.done_ratio, :width => '80px')),
                          :class => "issue-#{child.id} hascontextmenu")
                 end
                 s << '</form></table>'
                 s
               end
               def render_custom_fields_rows(issue)
                 return if issue.custom_field_values.empty?
                 ordered_values = []
                 half = (issue.custom_field_values.size / 2.0).ceil
                 half.times do |i|
                   ordered_values << issue.custom_field_values[i]
                   ordered_values << issue.custom_field_values[i + half]
                 end
                 s = "<tr>\n"
                 n = 0
                 ordered_values.compact.each do |value|
                   s << "</tr>\n<tr>\n" if n > 0 && (n % 2) == 0
                   s << "\t<th>#{ h(value.custom_field.name) }:</th><td>#{ simple_format_without_paragraph(h(show_value(value))) }</td>\n"
                   n += 1
                 end
                 s << "</tr>\n"
                 s
               end
               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,
                                                 :select => 'id, name',
                                                 :order => "name ASC",
                                                 :conditions => visible.conditions)
                 end
                 @sidebar_queries
               end
               def show_detail(detail, no_html=false)
                 case detail.property
                 when 'attr'
                   field = detail.prop_key.to_s.gsub(/\_id$/, "")
                   label = l(("field_" + field).to_sym)
                   case
                   when ['due_date', 'start_date'].include?(detail.prop_key)
                     value = format_date(detail.value.to_date) if detail.value
                     old_value = format_date(detail.old_value.to_date) if detail.old_value
                   when ['project_id', 'status_id', 'tracker_id', 'assigned_to_id', 'priority_id', 'category_id', 'fixed_version_id'].include?(detail.prop_key)
                     value = find_name_by_reflection(field, detail.value)
                     old_value = find_name_by_reflection(field, detail.old_value)
                   when detail.prop_key == '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?
+                  when detail.prop_key == 'parent_id'
+                    label = l(:field_parent_issue)
+                    value = "##{detail.value}" unless detail.value.blank?
+                    old_value = "##{detail.old_value}" unless detail.old_value.blank?
                   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
                 call_hook(:helper_issues_show_detail_after_setting, {:detail => detail, :label => label, :value => value, :old_value => old_value })
                 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? && a = Attachment.find_by_id(detail.prop_key)
                     # Link to the attachment if it has not been removed
                     value = link_to_attachment(a)
                   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?
                       l(:text_journal_changed, :label => label, :old => old_value, :new => value)
                     else
                       l(:text_journal_set_to, :label => label, :value => value)
                     end
                   when 'attachment'
                     l(:text_journal_added, :label => label, :value => value)
                   end
                 else
                   l(:text_journal_deleted, :label => label, :old => old_value)
                 end
               end
               # Find the name of an associated record stored in the field attribute
               def find_name_by_reflection(field, id)
                 association = Issue.reflect_on_association(field.to_sym)
                 if association
                   record = association.class_name.constantize.find_by_id(id)
                   return record.name if record
                 end
               end
               def issues_to_csv(issues, project = nil)
                 ic = Iconv.new(l(:general_csv_encoding), 'UTF-8')
                 decimal_separator = l(:general_csv_decimal_separator)
                 export = FCSV.generate(:col_sep => 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_estimated_hours),
                               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_issue_custom_fields
                   custom_fields.each {|f| headers << f.name}
                   # Description in the last column
                   headers << l(:field_description)
                   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,
                               issue.assigned_to,
                               issue.category,
                               issue.fixed_version,
                               issue.author.name,
                               format_date(issue.start_date),
                               format_date(issue.due_date),
                               issue.done_ratio,
                               issue.estimated_hours.to_s.gsub('.', decimal_separator),
                               format_time(issue.created_on),
                               format_time(issue.updated_on)
                               ]
                     custom_fields.each {|f| fields << show_value(issue.custom_value_for(f)) }
                     fields << issue.description
                     csv << fields.collect {|c| begin; ic.iconv(c.to_s); rescue; c.to_s; end }
                   end
                 end
                 export
               end
             end