##// END OF EJS Templates
jro_apps » redmine
RSS
backout r6356: HTML escape of app/helpers/timelog_helper.rb...
Toshi MARUYAMA -
r7821:55d41cf77bb5
parent child
Show More
Side by Side Unified
Context file:
r7821:55d41cf77bb5 Loading diff...:
Show file before | Show file after | Hide comments
@@ -1,192 +1,192
1 1 # Redmine - project management software
2 2 # Copyright (C) 2006-2011 Jean-Philippe Lang
3 3 #
4 4 # This program is free software; you can redistribute it and/or
5 5 # modify it under the terms of the GNU General Public License
6 6 # as published by the Free Software Foundation; either version 2
7 7 # of the License, or (at your option) any later version.
8 8 #
9 9 # This program is distributed in the hope that it will be useful,
10 10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
11 11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 12 # GNU General Public License for more details.
13 13 #
14 14 # You should have received a copy of the GNU General Public License
15 15 # along with this program; if not, write to the Free Software
16 16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17 17
18 18 module TimelogHelper
19 19 include ApplicationHelper
20 20
21 21 def render_timelog_breadcrumb
22 22 links = []
23 23 links << link_to(l(:label_project_all), {:project_id => nil, :issue_id => nil})
24 24 links << link_to(h(@project), {:project_id => @project, :issue_id => nil}) if @project
25 25 if @issue
26 26 if @issue.visible?
27 27 links << link_to_issue(@issue, :subject => false)
28 28 else
29 29 links << "##{@issue.id}"
30 30 end
31 31 end
32 32 breadcrumb links
33 33 end
34 34
35 35 # Returns a collection of activities for a select field. time_entry
36 36 # is optional and will be used to check if the selected TimeEntryActivity
37 37 # is active.
38 38 def activity_collection_for_select_options(time_entry=nil, project=nil)
39 39 project ||= @project
40 40 if project.nil?
41 41 activities = TimeEntryActivity.shared.active
42 42 else
43 43 activities = project.activities
44 44 end
45 45
46 46 collection = []
47 47 if time_entry && time_entry.activity && !time_entry.activity.active?
48 48 collection << [ "--- #{l(:actionview_instancetag_blank_option)} ---", '' ]
49 49 else
50 50 collection << [ "--- #{l(:actionview_instancetag_blank_option)} ---", '' ] unless activities.detect(&:is_default)
51 51 end
52 52 activities.each { |a| collection << [a.name, a.id] }
53 53 collection
54 54 end
55 55
56 56 def select_hours(data, criteria, value)
57 57 if value.to_s.empty?
58 58 data.select {|row| row[criteria].blank? }
59 59 else
60 60 data.select {|row| row[criteria].to_s == value.to_s}
61 61 end
62 62 end
63 63
64 64 def sum_hours(data)
65 65 sum = 0
66 66 data.each do |row|
67 67 sum += row['hours'].to_f
68 68 end
69 69 sum
70 70 end
71 71
72 72 def options_for_period_select(value)
73 73 options_for_select([[l(:label_all_time), 'all'],
74 74 [l(:label_today), 'today'],
75 75 [l(:label_yesterday), 'yesterday'],
76 76 [l(:label_this_week), 'current_week'],
77 77 [l(:label_last_week), 'last_week'],
78 78 [l(:label_last_n_days, 7), '7_days'],
79 79 [l(:label_this_month), 'current_month'],
80 80 [l(:label_last_month), 'last_month'],
81 81 [l(:label_last_n_days, 30), '30_days'],
82 82 [l(:label_this_year), 'current_year']],
83 83 value)
84 84 end
85 85
86 86 def entries_to_csv(entries)
87 87 decimal_separator = l(:general_csv_decimal_separator)
88 88 custom_fields = TimeEntryCustomField.find(:all)
89 89 export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv|
90 90 # csv header fields
91 91 headers = [l(:field_spent_on),
92 92 l(:field_user),
93 93 l(:field_activity),
94 94 l(:field_project),
95 95 l(:field_issue),
96 96 l(:field_tracker),
97 97 l(:field_subject),
98 98 l(:field_hours),
99 99 l(:field_comments)
100 100 ]
101 101 # Export custom fields
102 102 headers += custom_fields.collect(&:name)
103 103
104 104 csv << headers.collect {|c| Redmine::CodesetUtil.from_utf8(
105 105 c.to_s,
106 106 l(:general_csv_encoding) ) }
107 107 # csv lines
108 108 entries.each do |entry|
109 109 fields = [format_date(entry.spent_on),
110 110 entry.user,
111 111 entry.activity,
112 112 entry.project,
113 113 (entry.issue ? entry.issue.id : nil),
114 114 (entry.issue ? entry.issue.tracker : nil),
115 115 (entry.issue ? entry.issue.subject : nil),
116 116 entry.hours.to_s.gsub('.', decimal_separator),
117 117 entry.comments
118 118 ]
119 119 fields += custom_fields.collect {|f| show_value(entry.custom_value_for(f)) }
120 120
121 121 csv << fields.collect {|c| Redmine::CodesetUtil.from_utf8(
122 122 c.to_s,
123 123 l(:general_csv_encoding) ) }
124 124 end
125 125 end
126 126 export
127 127 end
128 128
129 129 def format_criteria_value(criteria, value)
130 130 if value.blank?
131 131 l(:label_none)
132 132 elsif k = @available_criterias[criteria][:klass]
133 133 obj = k.find_by_id(value.to_i)
134 134 if obj.is_a?(Issue)
135 obj.visible? ? h("#{obj.tracker} ##{obj.id}: #{obj.subject}") : h("##{obj.id}")
135 obj.visible? ? "#{obj.tracker} ##{obj.id}: #{obj.subject}" : "##{obj.id}"
136 136 else
137 137 obj
138 138 end
139 139 else
140 140 format_value(value, @available_criterias[criteria][:format])
141 141 end
142 142 end
143 143
144 144 def report_to_csv(criterias, periods, hours)
145 145 export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv|
146 146 # Column headers
147 147 headers = criterias.collect {|criteria| l(@available_criterias[criteria][:label]) }
148 148 headers += periods
149 149 headers << l(:label_total)
150 150 csv << headers.collect {|c| Redmine::CodesetUtil.from_utf8(
151 151 c.to_s,
152 152 l(:general_csv_encoding) ) }
153 153 # Content
154 154 report_criteria_to_csv(csv, criterias, periods, hours)
155 155 # Total row
156 156 row = [ l(:label_total) ] + [''] * (criterias.size - 1)
157 157 total = 0
158 158 periods.each do |period|
159 159 sum = sum_hours(select_hours(hours, @columns, period.to_s))
160 160 total += sum
161 161 row << (sum > 0 ? "%.2f" % sum : '')
162 162 end
163 163 row << "%.2f" %total
164 164 csv << row
165 165 end
166 166 export
167 167 end
168 168
169 169 def report_criteria_to_csv(csv, criterias, periods, hours, level=0)
170 170 hours.collect {|h| h[criterias[level]].to_s}.uniq.each do |value|
171 171 hours_for_value = select_hours(hours, criterias[level], value)
172 172 next if hours_for_value.empty?
173 173 row = [''] * level
174 174 row << Redmine::CodesetUtil.from_utf8(
175 175 format_criteria_value(criterias[level], value).to_s,
176 176 l(:general_csv_encoding) )
177 177 row += [''] * (criterias.length - level - 1)
178 178 total = 0
179 179 periods.each do |period|
180 180 sum = sum_hours(select_hours(hours_for_value, @columns, period.to_s))
181 181 total += sum
182 182 row << (sum > 0 ? "%.2f" % sum : '')
183 183 end
184 184 row << "%.2f" %total
185 185 csv << row
186 186
187 187 if criterias.length > level + 1
188 188 report_criteria_to_csv(csv, criterias, periods, hours_for_value, level + 1)
189 189 end
190 190 end
191 191 end
192 192 end
General Comments 0
You need to be logged in to leave comments. Login now