Redmine

  end

  def query_to_csv(items, query, options={})

    columns = (options[:columns] == 'all' ? query.available_inline_columns : query.inline_columns)

    query.available_block_columns.each do |column|

      if options[column.name].present?

        csv << columns.collect {|c| Redmine::CodesetUtil.from_utf8(csv_content(c, item), encoding) }

      end

    end

    export

  end

  def report_to_csv(report)

    decimal_separator = l(:general_csv_decimal_separator)

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

      # Column headers

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

      headers << l(:label_total_time)

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

                                    c.to_s,

      # Content

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

      # Total row

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

      total = 0

      report.periods.each do |period|

      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,

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

      total = 0

      periods.each do |period|

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

      end

    end

  end

end

<p><%= setting_text_field :repositories_encodings, :size => 60 %>

<em class="info"><%= l(:text_comma_separated) %></em></p>

<%= call_hook(:view_settings_general_form) %>

</div>

  setting_link_copied_issue: Link issues on copy

  setting_max_additional_emails: Maximum number of additional email addresses

  setting_search_results_per_page: Search results per page

  permission_add_project: Create project

  permission_add_subprojects: Create subprojects

  default:

  - '6'

  - '7'