jro_apps/redmine Commit - r928:3f2f7153a902

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

require 'csv'

18

require 'csv'

19

20

module IssuesHelper

20

module IssuesHelper

21

include ApplicationHelper

21

22

def render_issue_tooltip(issue)

23

def render_issue_tooltip(issue)

23

@cached_label_start_date ||= l(:field_start_date)

24

@cached_label_start_date ||= l(:field_start_date)

24

@cached_label_due_date ||= l(:field_due_date)

25

@cached_label_due_date ||= l(:field_due_date)

25

@cached_label_assigned_to ||= l(:field_assigned_to)

26

@cached_label_assigned_to ||= l(:field_assigned_to)

26

@cached_label_priority ||= l(:field_priority)

27

@cached_label_priority ||= l(:field_priority)

27

28

link_to_issue(issue) + ": #{h(issue.subject)} " +

29

link_to_issue(issue) + ": #{h(issue.subject)} " +

29

"#{@cached_label_start_date}: #{format_date(issue.start_date)} " +

30

"#{@cached_label_start_date}: #{format_date(issue.start_date)} " +

30

"#{@cached_label_due_date}: #{format_date(issue.due_date)} " +

31

"#{@cached_label_due_date}: #{format_date(issue.due_date)} " +

31

"#{@cached_label_assigned_to}: #{issue.assigned_to} " +

32

"#{@cached_label_assigned_to}: #{issue.assigned_to} " +

32

"#{@cached_label_priority}: #{issue.priority.name}"

33

"#{@cached_label_priority}: #{issue.priority.name}"

33

end

34

end

34

35

def show_detail(detail, no_html=false)

36

def show_detail(detail, no_html=false)

36

case detail.property

37

case detail.property

37

when 'attr'

38

when 'attr'

38

label = l(("field_" + detail.prop_key.to_s.gsub(/\_id$/, "")).to_sym)

39

label = l(("field_" + detail.prop_key.to_s.gsub(/\_id$/, "")).to_sym)

39

case detail.prop_key

40

case detail.prop_key

40

when 'due_date', 'start_date'

41

when 'due_date', 'start_date'

41

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

42

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

42

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

43

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

43

when 'status_id'

44

when 'status_id'

44

s = IssueStatus.find_by_id(detail.value) and value = s.name if detail.value

45

s = IssueStatus.find_by_id(detail.value) and value = s.name if detail.value

45

s = IssueStatus.find_by_id(detail.old_value) and old_value = s.name if detail.old_value

46

s = IssueStatus.find_by_id(detail.old_value) and old_value = s.name if detail.old_value

46

when 'assigned_to_id'

47

when 'assigned_to_id'

47

u = User.find_by_id(detail.value) and value = u.name if detail.value

48

u = User.find_by_id(detail.value) and value = u.name if detail.value

48

u = User.find_by_id(detail.old_value) and old_value = u.name if detail.old_value

49

u = User.find_by_id(detail.old_value) and old_value = u.name if detail.old_value

49

when 'priority_id'

50

when 'priority_id'

50

e = Enumeration.find_by_id(detail.value) and value = e.name if detail.value

51

e = Enumeration.find_by_id(detail.value) and value = e.name if detail.value

51

e = Enumeration.find_by_id(detail.old_value) and old_value = e.name if detail.old_value

52

e = Enumeration.find_by_id(detail.old_value) and old_value = e.name if detail.old_value

52

when 'category_id'

53

when 'category_id'

53

c = IssueCategory.find_by_id(detail.value) and value = c.name if detail.value

54

c = IssueCategory.find_by_id(detail.value) and value = c.name if detail.value

54

c = IssueCategory.find_by_id(detail.old_value) and old_value = c.name if detail.old_value

55

c = IssueCategory.find_by_id(detail.old_value) and old_value = c.name if detail.old_value

55

when 'fixed_version_id'

56

when 'fixed_version_id'

56

v = Version.find_by_id(detail.value) and value = v.name if detail.value

57

v = Version.find_by_id(detail.value) and value = v.name if detail.value

57

v = Version.find_by_id(detail.old_value) and old_value = v.name if detail.old_value

58

v = Version.find_by_id(detail.old_value) and old_value = v.name if detail.old_value

58

end

59

end

59

when 'cf'

60

when 'cf'

60

custom_field = CustomField.find_by_id(detail.prop_key)

61

custom_field = CustomField.find_by_id(detail.prop_key)

61

if custom_field

62

if custom_field

62

label = custom_field.name

63

label = custom_field.name

63

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

64

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

64

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

65

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

65

end

66

end

66

when 'attachment'

67

when 'attachment'

67

label = l(:label_attachment)

68

label = l(:label_attachment)

68

end

69

end

69

70

label ||= detail.prop_key

71

label ||= detail.prop_key

71

value ||= detail.value

72

value ||= detail.value

72

old_value ||= detail.old_value

73

old_value ||= detail.old_value

73

74

unless no_html

75

unless no_html

75

label = content_tag('strong', label)

76

label = content_tag('strong', label)

76

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

77

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

77

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

78

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

78

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

79

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

79

# Link to the attachment if it has not been removed

80

# Link to the attachment if it has not been removed

80

value = link_to(value, :controller => 'attachments', :action => 'download', :id => detail.prop_key)

81

value = link_to(value, :controller => 'attachments', :action => 'download', :id => detail.prop_key)

81

else

82

else

82

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

83

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

83

end

84

end

84

end

85

end

85

86

if !detail.value.blank?

87

if !detail.value.blank?

87

case detail.property

88

case detail.property

88

when 'attr', 'cf'

89

when 'attr', 'cf'

89

if !detail.old_value.blank?

90

if !detail.old_value.blank?

90

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

91

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

91

else

92

else

92

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

93

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

93

end

94

end

94

when 'attachment'

95

when 'attachment'

95

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

96

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

96

end

97

end

97

else

98

else

98

case detail.property

99

case detail.property

99

when 'attr', 'cf'

100

when 'attr', 'cf'

100

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

101

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

101

when 'attachment'

102

when 'attachment'

102

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

103

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

103

end

104

end

104

end

105

end

105

end

106

end

106

107

def issues_to_csv(issues, project = nil)

108

def issues_to_csv(issues, project = nil)

108

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

109

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

109

export = StringIO.new

110

export = StringIO.new

110

CSV::Writer.generate(export, l(:general_csv_separator)) do |csv|

111

CSV::Writer.generate(export, l(:general_csv_separator)) do |csv|

111

# csv header fields

112

# csv header fields

112

headers = [ "#",

113

headers = [ "#",

113

l(:field_status),

114

l(:field_status),

114

l(:field_project),

115

l(:field_project),

115

l(:field_tracker),

116

l(:field_tracker),

116

l(:field_priority),

117

l(:field_priority),

117

l(:field_subject),

118

l(:field_subject),

118

l(:field_assigned_to),

119

l(:field_assigned_to),

119

l(:field_category),

120

l(:field_category),

120

l(:field_fixed_version),

121

l(:field_fixed_version),

121

l(:field_author),

122

l(:field_author),

122

l(:field_start_date),

123

l(:field_start_date),

123

l(:field_due_date),

124

l(:field_due_date),

124

l(:field_done_ratio),

125

l(:field_done_ratio),

125

l(:field_created_on),

126

l(:field_created_on),

126

l(:field_updated_on)

127

l(:field_updated_on)

127

]

128

]

128

# Export project custom fields if project is given

129

# Export project custom fields if project is given

129

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

130

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

130

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

131

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

131

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

132

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

132

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

133

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

133

# csv lines

134

# csv lines

134

issues.each do |issue|

135

issues.each do |issue|

135

fields = [issue.id,

136

fields = [issue.id,

136

issue.status.name,

137

issue.status.name,

137

issue.project.name,

138

issue.project.name,

138

issue.tracker.name,

139

issue.tracker.name,

139

issue.priority.name,

140

issue.priority.name,

140

issue.subject,

141

issue.subject,

141

issue.assigned_to,

142

issue.assigned_to,

142

issue.category,

143

issue.category,

143

issue.fixed_version,

144

issue.fixed_version,

144

issue.author.name,

145

issue.author.name,

145

~~issue~~.~~start_date~~ ? l_date(issue.start_date) : ~~nil~~,

146

format_date(issue.start_date),

146

~~issue~~.~~due_date~~ ? l_date(issue.due_date) : ~~nil~~,

147

format_date(issue.due_date),

147

issue.done_ratio,

148

issue.done_ratio,

148

~~l_date~~time(issue.created_on),

149

format_time(issue.created_on),

149

~~l_date~~time(issue.updated_on)

150

format_time(issue.updated_on)

150

]

151

]

151

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

152

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

152

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

153

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

153

end

154

end

154

end

155

end

155

export.rewind

156

export.rewind

156

export

157

export

157

end

158

end

158

end

159

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.
             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.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 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.status.name,
                               issue.project.name,
                               issue.tracker.name,
                               issue.priority.name,
                               issue.subject,
                               issue.assigned_to,
                               issue.category,
                               issue.fixed_version,
                               issue.author.name,
-                              issue.start_date ? l_date(issue.start_date) : nil,
+                              format_date(issue.start_date),
-                              issue.due_date ? l_date(issue.due_date) : nil,
+                              format_date(issue.due_date),
                               issue.done_ratio,
-                              l_datetime(issue.created_on),
+                              format_time(issue.created_on),
-                              l_datetime(issue.updated_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