jro_apps/redmine Commit - r11176:5778bdd4f7c3

1

# encoding: utf-8

1

# encoding: utf-8

2

#

2

#

3

# Redmine - project management software

3

# Redmine - project management software

4

5

#

5

#

6

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

6

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

7

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

7

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

8

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

8

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

9

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

9

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

10

#

10

#

11

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

11

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

12

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

12

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

13

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

13

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

14

# GNU General Public License for more details.

14

# GNU General Public License for more details.

15

#

15

#

16

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

16

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

17

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

17

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

18

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

18

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

19

20

module TimelogHelper

20

module TimelogHelper

21

include ApplicationHelper

21

include ApplicationHelper

22

23

def render_timelog_breadcrumb

23

def render_timelog_breadcrumb

24

links = []

24

links = []

25

links << link_to(l(:label_project_all), {:project_id => nil, :issue_id => nil})

25

links << link_to(l(:label_project_all), {:project_id => nil, :issue_id => nil})

26

links << link_to(h(@project), {:project_id => @project, :issue_id => nil}) if @project

26

links << link_to(h(@project), {:project_id => @project, :issue_id => nil}) if @project

27

if @issue

27

if @issue

28

if @issue.visible?

28

if @issue.visible?

29

links << link_to_issue(@issue, :subject => false)

29

links << link_to_issue(@issue, :subject => false)

30

else

30

else

31

links << "##{@issue.id}"

31

links << "##{@issue.id}"

32

end

32

end

33

end

33

end

34

breadcrumb links

34

breadcrumb links

35

end

35

end

36

37

# Returns a collection of activities for a select field. time_entry

37

# Returns a collection of activities for a select field. time_entry

38

# is optional and will be used to check if the selected TimeEntryActivity

38

# is optional and will be used to check if the selected TimeEntryActivity

39

# is active.

39

# is active.

40

def activity_collection_for_select_options(time_entry=nil, project=nil)

40

def activity_collection_for_select_options(time_entry=nil, project=nil)

41

project ||= @project

41

project ||= @project

42

if project.nil?

42

if project.nil?

43

activities = TimeEntryActivity.shared.active

43

activities = TimeEntryActivity.shared.active

44

else

44

else

45

activities = project.activities

45

activities = project.activities

46

end

46

end

47

48

collection = []

48

collection = []

49

if time_entry && time_entry.activity && !time_entry.activity.active?

49

if time_entry && time_entry.activity && !time_entry.activity.active?

50

collection << [ "--- #{l(:actionview_instancetag_blank_option)} ---", '' ]

50

collection << [ "--- #{l(:actionview_instancetag_blank_option)} ---", '' ]

51

else

51

else

52

collection << [ "--- #{l(:actionview_instancetag_blank_option)} ---", '' ] unless activities.detect(&:is_default)

52

collection << [ "--- #{l(:actionview_instancetag_blank_option)} ---", '' ] unless activities.detect(&:is_default)

53

end

53

end

54

activities.each { |a| collection << [a.name, a.id] }

54

activities.each { |a| collection << [a.name, a.id] }

55

collection

55

collection

56

end

56

end

57

58

def select_hours(data, criteria, value)

58

def select_hours(data, criteria, value)

59

if value.to_s.empty?

59

if value.to_s.empty?

60

data.select {|row| row[criteria].blank? }

60

data.select {|row| row[criteria].blank? }

61

else

61

else

62

data.select {|row| row[criteria].to_s == value.to_s}

62

data.select {|row| row[criteria].to_s == value.to_s}

63

end

63

end

64

end

64

end

65

66

def sum_hours(data)

66

def sum_hours(data)

67

sum = 0

67

sum = 0

68

data.each do |row|

68

data.each do |row|

69

sum += row['hours'].to_f

69

sum += row['hours'].to_f

70

end

70

end

71

sum

71

sum

72

end

72

end

73

74

def options_for_period_select(value)

74

def options_for_period_select(value)

75

options_for_select([[l(:label_all_time), 'all'],

75

options_for_select([[l(:label_all_time), 'all'],

76

[l(:label_today), 'today'],

76

[l(:label_today), 'today'],

77

[l(:label_yesterday), 'yesterday'],

77

[l(:label_yesterday), 'yesterday'],

78

[l(:label_this_week), 'current_week'],

78

[l(:label_this_week), 'current_week'],

79

[l(:label_last_week), 'last_week'],

79

[l(:label_last_week), 'last_week'],

80

[l(:label_last_n_weeks, 2), 'last_2_weeks'],

80

[l(:label_last_n_weeks, 2), 'last_2_weeks'],

81

[l(:label_last_n_days, 7), '7_days'],

81

[l(:label_last_n_days, 7), '7_days'],

82

[l(:label_this_month), 'current_month'],

82

[l(:label_this_month), 'current_month'],

83

[l(:label_last_month), 'last_month'],

83

[l(:label_last_month), 'last_month'],

84

[l(:label_last_n_days, 30), '30_days'],

84

[l(:label_last_n_days, 30), '30_days'],

85

[l(:label_this_year), 'current_year']],

85

[l(:label_this_year), 'current_year']],

86

value)

86

value)

87

end

87

end

88

89

def entries_to_csv(entries)

89

def entries_to_csv(entries)

90

decimal_separator = l(:general_csv_decimal_separator)

90

decimal_separator = l(:general_csv_decimal_separator)

91

custom_fields = TimeEntryCustomField.all

91

custom_fields = TimeEntryCustomField.all

92

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

92

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

93

# csv header fields

93

# csv header fields

94

headers = [l(:field_spent_on),

94

headers = [l(:field_spent_on),

95

l(:field_user),

95

l(:field_user),

96

l(:field_activity),

96

l(:field_activity),

97

l(:field_project),

97

l(:field_project),

98

l(:field_issue),

98

l(:field_issue),

99

l(:field_tracker),

99

l(:field_tracker),

100

l(:field_subject),

100

l(:field_subject),

101

l(:field_hours),

101

l(:field_hours),

102

l(:field_comments)

102

l(:field_comments)

103

]

103

]

104

# Export custom fields

104

# Export custom fields

105

headers += custom_fields.collect(&:name)

105

headers += custom_fields.collect(&:name)

106

107

csv << headers.collect {|c| Redmine::CodesetUtil.from_utf8(

107

csv << headers.collect {|c| Redmine::CodesetUtil.from_utf8(

108

c.to_s,

108

c.to_s,

109

l(:general_csv_encoding) ) }

109

l(:general_csv_encoding) ) }

110

# csv lines

110

# csv lines

111

entries.each do |entry|

111

entries.each do |entry|

112

fields = [format_date(entry.spent_on),

112

fields = [format_date(entry.spent_on),

113

entry.user,

113

entry.user,

114

entry.activity,

114

entry.activity,

115

entry.project,

115

entry.project,

116

(entry.issue ? entry.issue.id : nil),

116

(entry.issue ? entry.issue.id : nil),

117

(entry.issue ? entry.issue.tracker : nil),

117

(entry.issue ? entry.issue.tracker : nil),

118

(entry.issue ? entry.issue.subject : nil),

118

(entry.issue ? entry.issue.subject : nil),

119

entry.hours.to_s.gsub('.', decimal_separator),

119

entry.hours.to_s.gsub('.', decimal_separator),

120

entry.comments

120

entry.comments

121

]

121

]

122

fields += custom_fields.collect {|f| show_value(entry.custom_field_values.detect {|v| v.custom_field_id == f.id}) }

122

fields += custom_fields.collect {|f| show_value(entry.custom_field_values.detect {|v| v.custom_field_id == f.id}) }

123

124

csv << fields.collect {|c| Redmine::CodesetUtil.from_utf8(

124

csv << fields.collect {|c| Redmine::CodesetUtil.from_utf8(

125

c.to_s,

125

c.to_s,

126

l(:general_csv_encoding) ) }

126

l(:general_csv_encoding) ) }

127

end

127

end

128

end

128

end

129

export

129

export

130

end

130

end

131

132

def format_criteria_value(criteria_options, value)

132

def format_criteria_value(criteria_options, value)

133

if value.blank?

133

if value.blank?

134

"[#{l(:label_none)}]"

134

"[#{l(:label_none)}]"

135

elsif k = criteria_options[:klass]

135

elsif k = criteria_options[:klass]

136

obj = k.find_by_id(value.to_i)

136

obj = k.find_by_id(value.to_i)

137

if obj.is_a?(Issue)

137

if obj.is_a?(Issue)

138

obj.visible? ? "#{obj.tracker} ##{obj.id}: #{obj.subject}" : "##{obj.id}"

138

obj.visible? ? "#{obj.tracker} ##{obj.id}: #{obj.subject}" : "##{obj.id}"

139

else

139

else

140

obj

140

obj

141

end

141

end

142

else

142

else

143

format_value(value, criteria_options[:format])

143

format_value(value, criteria_options[:format])

144

end

144

end

145

end

145

end

146

147

def report_to_csv(report)

147

def report_to_csv(report)

148

decimal_separator = l(:general_csv_decimal_separator)

148

decimal_separator = l(:general_csv_decimal_separator)

149

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

149

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

150

# Column headers

150

# Column headers

151

headers = report.criteria.collect {|criteria| l(report.available_criteria[criteria][:label]) }

151

headers = report.criteria.collect {|criteria| l(report.available_criteria[criteria][:label]) }

152

headers += report.periods

152

headers += report.periods

153

headers << l(:label_total)

153

headers << l(:label_total)

154

csv << headers.collect {|c| Redmine::CodesetUtil.from_utf8(

154

csv << headers.collect {|c| Redmine::CodesetUtil.from_utf8(

155

c.to_s,

155

c.to_s,

156

l(:general_csv_encoding) ) }

156

l(:general_csv_encoding) ) }

157

# Content

157

# Content

158

report_criteria_to_csv(csv, report.available_criteria, report.columns, report.criteria, report.periods, report.hours)

158

report_criteria_to_csv(csv, report.available_criteria, report.columns, report.criteria, report.periods, report.hours)

159

# Total row

159

# Total row

160

str_total = Redmine::CodesetUtil.from_utf8(l(:label_total), l(:general_csv_encoding))

160

str_total = Redmine::CodesetUtil.from_utf8(l(:label_total), l(:general_csv_encoding))

161

row = [ str_total ] + [''] * (report.criteria.size - 1)

161

row = [ str_total ] + [''] * (report.criteria.size - 1)

162

total = 0

162

total = 0

163

report.periods.each do |period|

163

report.periods.each do |period|

164

sum = sum_hours(select_hours(report.hours, report.columns, period.to_s))

164

sum = sum_hours(select_hours(report.hours, report.columns, period.to_s))

165

total += sum

165

total += sum

166

row << (sum > 0 ? ("%.2f" % sum).gsub('.',decimal_separator) : '')

166

row << (sum > 0 ? ("%.2f" % sum).gsub('.',decimal_separator) : '')

167

end

167

end

168

row << ("%.2f" % total).gsub('.',decimal_separator)

168

row << ("%.2f" % total).gsub('.',decimal_separator)

169

csv << row

169

csv << row

170

end

170

end

171

export

171

export

172

end

172

end

173

174

def report_criteria_to_csv(csv, available_criteria, columns, criteria, periods, hours, level=0)

174

def report_criteria_to_csv(csv, available_criteria, columns, criteria, periods, hours, level=0)

175

decimal_separator = l(:general_csv_decimal_separator)

175

decimal_separator = l(:general_csv_decimal_separator)

176

hours.collect {|h| h[criteria[level]].to_s}.uniq.each do |value|

176

hours.collect {|h| h[criteria[level]].to_s}.uniq.each do |value|

177

hours_for_value = select_hours(hours, criteria[level], value)

177

hours_for_value = select_hours(hours, criteria[level], value)

178

next if hours_for_value.empty?

178

next if hours_for_value.empty?

179

row = [''] * level

179

row = [''] * level

180

row << Redmine::CodesetUtil.from_utf8(

180

row << Redmine::CodesetUtil.from_utf8(

181

format_criteria_value(available_criteria[criteria[level]], value).to_s,

181

format_criteria_value(available_criteria[criteria[level]], value).to_s,

182

l(:general_csv_encoding) )

182

l(:general_csv_encoding) )

183

row += [''] * (criteria.length - level - 1)

183

row += [''] * (criteria.length - level - 1)

184

total = 0

184

total = 0

185

periods.each do |period|

185

periods.each do |period|

186

sum = sum_hours(select_hours(hours_for_value, columns, period.to_s))

186

sum = sum_hours(select_hours(hours_for_value, columns, period.to_s))

187

total += sum

187

total += sum

188

row << (sum > 0 ? ("%.2f" % sum).gsub('.',decimal_separator) : '')

188

row << (sum > 0 ? ("%.2f" % sum).gsub('.',decimal_separator) : '')

189

end

189

end

190

row << ("%.2f" % total).gsub('.',decimal_separator)

190

row << ("%.2f" % total).gsub('.',decimal_separator)

191

csv << row

191

csv << row

192

if criteria.length > level + 1

192

if criteria.length > level + 1

193

report_criteria_to_csv(csv, available_criteria, columns, criteria, periods, hours_for_value, level + 1)

193

report_criteria_to_csv(csv, available_criteria, columns, criteria, periods, hours_for_value, level + 1)

194

end

194

end

195

end

195

end

196

end

196

end

197

end

197

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

             # encoding: utf-8
             #
             # Redmine - project management software
             # Copyright (C) 2006-2013  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 TimelogHelper
               include ApplicationHelper
               def render_timelog_breadcrumb
                 links = []
                 links << link_to(l(:label_project_all), {:project_id => nil, :issue_id => nil})
                 links << link_to(h(@project), {:project_id => @project, :issue_id => nil}) if @project
                 if @issue
                   if @issue.visible?
                     links << link_to_issue(@issue, :subject => false)
                   else
                     links << "##{@issue.id}"
                   end
                 end
                 breadcrumb links
               end
               # Returns a collection of activities for a select field.  time_entry
               # is optional and will be used to check if the selected TimeEntryActivity
               # is active.
               def activity_collection_for_select_options(time_entry=nil, project=nil)
                 project ||= @project
                 if project.nil?
                   activities = TimeEntryActivity.shared.active
                 else
                   activities = project.activities
                 end
                 collection = []
                 if time_entry && time_entry.activity && !time_entry.activity.active?
                   collection << [ "--- #{l(:actionview_instancetag_blank_option)} ---", '' ]
                 else
                   collection << [ "--- #{l(:actionview_instancetag_blank_option)} ---", '' ] unless activities.detect(&:is_default)
                 end
                 activities.each { |a| collection << [a.name, a.id] }
                 collection
               end
               def select_hours(data, criteria, value)
-              	if value.to_s.empty?
+                if value.to_s.empty?
-              		data.select {|row| row[criteria].blank? }
+                  data.select {|row| row[criteria].blank? }
                 else
-                	data.select {|row| row[criteria].to_s == value.to_s}
+                  data.select {|row| row[criteria].to_s == value.to_s}
                 end
               end
               def sum_hours(data)
                 sum = 0
                 data.each do |row|
                   sum += row['hours'].to_f
                 end
                 sum
               end
               def options_for_period_select(value)
                 options_for_select([[l(:label_all_time), 'all'],
                                     [l(:label_today), 'today'],
                                     [l(:label_yesterday), 'yesterday'],
                                     [l(:label_this_week), 'current_week'],
                                     [l(:label_last_week), 'last_week'],
                                     [l(:label_last_n_weeks, 2), 'last_2_weeks'],
                                     [l(:label_last_n_days, 7), '7_days'],
                                     [l(:label_this_month), 'current_month'],
                                     [l(:label_last_month), 'last_month'],
                                     [l(:label_last_n_days, 30), '30_days'],
                                     [l(:label_this_year), 'current_year']],
                                     value)
               end
               def entries_to_csv(entries)
                 decimal_separator = l(:general_csv_decimal_separator)
                 custom_fields = TimeEntryCustomField.all
                 export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv|
                   # csv header fields
                   headers = [l(:field_spent_on),
                              l(:field_user),
                              l(:field_activity),
                              l(:field_project),
                              l(:field_issue),
                              l(:field_tracker),
                              l(:field_subject),
                              l(:field_hours),
                              l(:field_comments)
                              ]
                   # Export custom fields
                   headers += custom_fields.collect(&:name)
                   csv << headers.collect {|c| Redmine::CodesetUtil.from_utf8(
                                                  c.to_s,
                                                  l(:general_csv_encoding) )  }
                   # csv lines
                   entries.each do |entry|
                     fields = [format_date(entry.spent_on),
                               entry.user,
                               entry.activity,
                               entry.project,
                               (entry.issue ? entry.issue.id : nil),
                               (entry.issue ? entry.issue.tracker : nil),
                               (entry.issue ? entry.issue.subject : nil),
                               entry.hours.to_s.gsub('.', decimal_separator),
                               entry.comments
                               ]
                     fields += custom_fields.collect {|f| show_value(entry.custom_field_values.detect {|v| v.custom_field_id == f.id}) }
                     csv << fields.collect {|c| Redmine::CodesetUtil.from_utf8(
                                                  c.to_s,
                                                  l(:general_csv_encoding) )  }
                   end
                 end
                 export
               end
               def format_criteria_value(criteria_options, value)
                 if value.blank?
                   "[#{l(:label_none)}]"
                 elsif k = criteria_options[:klass]
                   obj = k.find_by_id(value.to_i)
                   if obj.is_a?(Issue)
                     obj.visible? ? "#{obj.tracker} ##{obj.id}: #{obj.subject}" : "##{obj.id}"
                   else
                     obj
                   end
                 else
                   format_value(value, criteria_options[:format])
                 end
               end
               def report_to_csv(report)
                 decimal_separator = l(:general_csv_decimal_separator)
                 export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv|
                   # Column headers
                   headers = report.criteria.collect {|criteria| l(report.available_criteria[criteria][:label]) }
                   headers += report.periods
                   headers << l(:label_total)
                   csv << headers.collect {|c| Redmine::CodesetUtil.from_utf8(
                                                 c.to_s,
                                                 l(:general_csv_encoding) ) }
                   # Content
                   report_criteria_to_csv(csv, report.available_criteria, report.columns, report.criteria, report.periods, report.hours)
                   # Total row
                   str_total = Redmine::CodesetUtil.from_utf8(l(:label_total), l(:general_csv_encoding))
                   row = [ str_total ] + [''] * (report.criteria.size - 1)
                   total = 0
                   report.periods.each do |period|
                     sum = sum_hours(select_hours(report.hours, report.columns, period.to_s))
                     total += sum
                     row << (sum > 0 ? ("%.2f" % sum).gsub('.',decimal_separator) : '')
                   end
                   row << ("%.2f" % total).gsub('.',decimal_separator)
                   csv << row
                 end
                 export
               end
               def report_criteria_to_csv(csv, available_criteria, columns, criteria, periods, hours, level=0)
                 decimal_separator = l(:general_csv_decimal_separator)
                 hours.collect {|h| h[criteria[level]].to_s}.uniq.each do |value|
                   hours_for_value = select_hours(hours, criteria[level], value)
                   next if hours_for_value.empty?
                   row = [''] * level
                   row << Redmine::CodesetUtil.from_utf8(
                                     format_criteria_value(available_criteria[criteria[level]], value).to_s,
                                     l(:general_csv_encoding) )
                   row += [''] * (criteria.length - level - 1)
                   total = 0
                   periods.each do |period|
                     sum = sum_hours(select_hours(hours_for_value, columns, period.to_s))
                     total += sum
                     row << (sum > 0 ? ("%.2f" % sum).gsub('.',decimal_separator) : '')
                   end
                   row << ("%.2f" % total).gsub('.',decimal_separator)
                   csv << row
                   if criteria.length > level + 1
                     report_criteria_to_csv(csv, available_criteria, columns, criteria, periods, hours_for_value, level + 1)
                   end
                 end
               end
             end