Module: TimelogHelper
- Includes:
- ApplicationHelper
- Included in:
- TimeEntryReportsController, TimelogController
- Defined in:
- app/helpers/timelog_helper.rb
Overview
redMine - project management software Copyright © 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.
Constant Summary
Constants included from ApplicationHelper
ApplicationHelper::HEADING_RE, ApplicationHelper::TOC_RE
Instance Method Summary collapse
-
#activity_collection_for_select_options(time_entry = nil, project = nil) ⇒ Object
Returns a collection of activities for a select field.
- #entries_to_csv(entries) ⇒ Object
- #format_criteria_value(criteria, value) ⇒ Object
- #options_for_period_select(value) ⇒ Object
- #render_timelog_breadcrumb ⇒ Object
- #report_criteria_to_csv(csv, criterias, periods, hours, level = 0) ⇒ Object
- #report_to_csv(criterias, periods, hours) ⇒ Object
- #select_hours(data, criteria, value) ⇒ Object
- #sum_hours(data) ⇒ Object
- #to_utf8(s) ⇒ Object
Methods included from ApplicationHelper
#accesskey, #api_meta, #authoring, #authorize_for, #avatar, #back_url_hidden_field_tag, #body_css_classes, #breadcrumb, #calendar_for, #check_all_links, #checked_image, #content_for, #context_menu, #context_menu_link, #current_theme, #due_date_distance_in_words, #favicon, #format_activity_day, #format_activity_description, #format_activity_title, #format_version_name, #has_content?, #heads_for_theme, #html_hours, #html_title, #image_to_function, #include_calendar_headers_tags, #include_in_api_response?, #javascript_heads, #label_tag_for, #labelled_tabular_form_for, #lang_options_for_select, #link_to_attachment, #link_to_if_authorized, #link_to_issue, #link_to_message, #link_to_project, #link_to_remote_if_authorized, #link_to_revision, #link_to_user, #other_formats_links, #page_header_title, #pagination_links_full, #parse_headings, #parse_inline_attachments, #parse_non_pre_blocks, #parse_redmine_links, #parse_wiki_links, #path_to_stylesheet, #per_page_links, #principals_check_box_tags, #progress_bar, #project_nested_ul, #project_tree, #project_tree_options_for_select, #prompt_to_remote, #render_flash_messages, #render_page_hierarchy, #render_project_jump_box, #render_tabs, #reorder_links, #replace_toc, #simple_format_without_paragraph, #stylesheet_path, #syntax_highlight, #textilizable, #time_tag, #to_path_param, #toggle_link, #truncate_lines, #truncate_single_line
Methods included from Redmine::I18n
#current_language, #day_name, #find_language, #format_date, #format_time, included, #l, #l_hours, #l_or_humanize, #ll, #month_name, #set_language_if_valid, #valid_languages
Methods included from Redmine::WikiFormatting::Macros::Definitions
#exec_macro, #extract_macro_options
Instance Method Details
#activity_collection_for_select_options(time_entry = nil, project = nil) ⇒ Object
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.
38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
# File 'app/helpers/timelog_helper.rb', line 38 def (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 |
#entries_to_csv(entries) ⇒ Object
86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 |
# File 'app/helpers/timelog_helper.rb', line 86 def entries_to_csv(entries) ic = Iconv.new(l(:general_csv_encoding), 'UTF-8') decimal_separator = l(:general_csv_decimal_separator) custom_fields = TimeEntryCustomField.find(: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| begin; ic.iconv(c.to_s); rescue; c.to_s; end } # 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_value_for(f)) } csv << fields.collect {|c| begin; ic.iconv(c.to_s); rescue; c.to_s; end } end end export end |
#format_criteria_value(criteria, value) ⇒ Object
126 127 128 129 130 131 132 133 134 135 136 137 138 139 |
# File 'app/helpers/timelog_helper.rb', line 126 def format_criteria_value(criteria, value) if value.blank? l(:label_none) elsif k = @available_criterias[criteria][: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, @available_criterias[criteria][:format]) end end |
#options_for_period_select(value) ⇒ Object
72 73 74 75 76 77 78 79 80 81 82 83 84 |
# File 'app/helpers/timelog_helper.rb', line 72 def (value) ([[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_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 |
#render_timelog_breadcrumb ⇒ Object
21 22 23 24 25 26 27 28 29 30 31 32 33 |
# File 'app/helpers/timelog_helper.rb', line 21 def 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 links end |
#report_criteria_to_csv(csv, criterias, periods, hours, level = 0) ⇒ Object
164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 |
# File 'app/helpers/timelog_helper.rb', line 164 def report_criteria_to_csv(csv, criterias, periods, hours, level=0) hours.collect {|h| h[criterias[level]].to_s}.uniq.each do |value| hours_for_value = select_hours(hours, criterias[level], value) next if hours_for_value.empty? row = [''] * level row << to_utf8(format_criteria_value(criterias[level], value)) row += [''] * (criterias.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 : '') end row << "%.2f" %total csv << row if criterias.length > level + 1 report_criteria_to_csv(csv, criterias, periods, hours_for_value, level + 1) end end end |
#report_to_csv(criterias, periods, hours) ⇒ Object
141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 |
# File 'app/helpers/timelog_helper.rb', line 141 def report_to_csv(criterias, periods, hours) export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv| # Column headers headers = criterias.collect {|criteria| l(@available_criterias[criteria][:label]) } headers += periods headers << l(:label_total) csv << headers.collect {|c| to_utf8(c) } # Content report_criteria_to_csv(csv, criterias, periods, hours) # Total row row = [ l(:label_total) ] + [''] * (criterias.size - 1) total = 0 periods.each do |period| sum = sum_hours(select_hours(hours, @columns, period.to_s)) total += sum row << (sum > 0 ? "%.2f" % sum : '') end row << "%.2f" %total csv << row end export end |
#select_hours(data, criteria, value) ⇒ Object
56 57 58 59 60 61 62 |
# File 'app/helpers/timelog_helper.rb', line 56 def select_hours(data, criteria, value) if value.to_s.empty? data.select {|row| row[criteria].blank? } else data.select {|row| row[criteria].to_s == value.to_s} end end |
#sum_hours(data) ⇒ Object
64 65 66 67 68 69 70 |
# File 'app/helpers/timelog_helper.rb', line 64 def sum_hours(data) sum = 0 data.each do |row| sum += row['hours'].to_f end sum end |
#to_utf8(s) ⇒ Object
186 187 188 189 |
# File 'app/helpers/timelog_helper.rb', line 186 def to_utf8(s) @ic ||= Iconv.new(l(:general_csv_encoding), 'UTF-8') begin; @ic.iconv(s.to_s); rescue; s.to_s; end end |