Redmine

  def issues_to_csv(issues, project, query, options={})

    decimal_separator = l(:general_csv_decimal_separator)

    encoding = l(:general_csv_encoding)

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

      # csv header fields

      # csv lines

      issues.each do |issue|

          end

          s.to_s

        end

      end

    end

    export

    end

  end

  def column_header(column)

    column.sortable ? sort_header_tag(column.name.to_s, :caption => column.caption,

                                                        :default_order => column.default_order) :

    when 'String'

      if column.name == :subject

        link_to(h(value), :controller => 'issues', :action => 'show', :id => issue)

      else

        h(value)

      end

      self.groupable = name.to_s

    end

    self.default_order = options[:default_order]

    @caption_key = options[:caption] || "field_#{name}"

  end

    @sortable.is_a?(Proc) ? @sortable.call : @sortable

  end

  def value(issue)

    issue.send name

  end

    self.name = "cf_#{custom_field.id}".to_sym

    self.sortable = custom_field.order_statement || false

    self.groupable = custom_field.group_statement || false

    @cf = custom_field

  end

    QueryColumn.new(:estimated_hours, :sortable => "#{Issue.table_name}.estimated_hours"),

    QueryColumn.new(:done_ratio, :sortable => "#{Issue.table_name}.done_ratio", :groupable => true),

    QueryColumn.new(:created_on, :sortable => "#{Issue.table_name}.created_on", :default_order => 'desc'),

  ]

  cattr_reader :available_columns

    end.compact

  end

  def default_columns_names

    @default_columns_names ||= begin

      default_columns = Setting.issue_list_default_columns.map(&:to_sym)

                              :title => "#{l(:button_check_all)}/#{l(:button_uncheck_all)}" %>

      </th>

      <%= sort_header_tag('id', :caption => '#', :default_order => 'desc') %>

        <%= column_header(column) %>

      <% end %>

    </tr>

  <% if @query.grouped? && (group = @query.group_by_column.value(issue)) != previous_group %>

    <% reset_cycle %>

    <tr class="group open">

        <span class="expander" onclick="toggleRowGroup(this);">&nbsp;</span>

        <%= group.blank? ? l(:label_none) : column_content(@query.group_by_column, issue) %> <span class="count"><%= @issue_count_by_group[group] %></span>

        <%= link_to_function("#{l(:button_collapse_all)}/#{l(:button_expand_all)}",

  <tr id="issue-<%= issue.id %>" class="hascontextmenu <%= cycle('odd', 'even') %> <%= issue.css_classes %> <%= level > 0 ? "idnt idnt-#{level}" : nil %>">

    <td class="checkbox hide-when-print"><%= check_box_tag("ids[]", issue.id, false, :id => nil) %></td>

    <td class="id"><%= link_to issue.id, issue_path(issue) %></td>

  </tr>

  <% end -%>

  </tbody>

</table>

</div>

                                 @query.group_by)

                       ) %></td>

          </tr>

        </table>

      </div>

    </fieldset>

    <label><%= radio_button_tag 'columns', 'all' %> <%= l(:description_all_columns) %></label>

  </p>

  <p>

  </p>

  <p class="buttons">

    <%= submit_tag l(:button_export), :name => nil, :onclick => "hideModal(this);" %>

      <%= label_tag "available_columns", l(:description_available_columns) %>

      <br />

      <%= select_tag 'available_columns',

              :multiple => true, :size => 10, :style => "width:150px",

              :ondblclick => "moveOptions(this.form.available_columns, this.form.selected_columns);" %>

    </td>

      <%= label_tag "selected_columns", l(:description_selected_columns) %>

      <br />

      <%= select_tag((defined?(tag_name) ? tag_name : 'c[]'),

              :id => 'selected_columns', :multiple => true, :size => 10, :style => "width:150px",

              :ondblclick => "moveOptions(this.form.selected_columns, this.form.available_columns);") %>

    </td>

<p><label for="query_group_by"><%= l(:field_group_by) %></label>

<%= select 'query', 'group_by', @query.groupable_columns.collect {|c| [c.caption, c.name.to_s]}, :include_blank => true %></p>

</div>

<fieldset id="filters"><legend><%= l(:label_filter_plural) %></legend>

			Error("Incorrect orientation: #{orientation}")

		end

		@cur_orientation = @def_orientation

		@w = @w_pt/@k

		@h = @h_pt/@k

		restspace = GetPageHeight() - GetY() - GetBreakMargin();

		writeHTML(html, true, fill); # write html text

		currentY =  GetY();

		@auto_page_break = false;

		# check if a new page has been created

		if (@page > pagenum)

			currentpage = @page;

			@page = pagenum;

			SetY(GetPageHeight() - restspace - GetBreakMargin());

			Cell(w, restspace - 1, "", b, 0, 'L', 0);

			b = b2;

			@page += 1;

			while @page < currentpage

				SetY(@t_margin); # put cursor at the beginning of text

				Cell(w, @page_break_trigger - @t_margin, "", b, 0, 'L', 0);

				@page += 1;

			end

			end

			# design a cell around the text on last page

			SetY(@t_margin); # put cursor at the beginning of text

			Cell(w, currentY - @t_margin, "", b, 0, 'L', 0);

		else

			SetY(y); # put cursor at the beginning of text

			# design a cell around the text

			Cell(w, [h, (currentY - y)].max, "", border, 0, 'L', 0);

		end

		@auto_page_break = true;

        include Redmine::I18n

        attr_accessor :footer_date

          @@k_path_cache = Rails.root.join('tmp', 'pdf')

          FileUtils.mkdir_p @@k_path_cache unless File::exist?(@@k_path_cache)

          set_language_if_valid lang

          pdf_encoding = l(:general_pdf_encoding).upcase

          case current_language.to_s.downcase

          when 'vi'

            @font_for_content = 'DejaVuSans'

      # fetch row values

      def fetch_row_values(issue, query, level)

          s = if column.is_a?(QueryCustomFieldColumn)

            cv = issue.custom_field_values.detect {|v| v.custom_field_id == column.custom_field.id}

            show_value(cv)

        #  by captions

        pdf.SetFontStyle('B',8)

        col_padding = pdf.GetStringWidth('OO')

        col_width_max = Array.new(col_width_min)

        col_width_avg = Array.new(col_width_min)

          n = 10

          c.caption.split.each {|w|

            x = pdf.GetStringWidth(w) + col_padding

        # render it background to find the max height used

        base_x = pdf.GetX

        base_y = pdf.GetY

        pdf.Rect(base_x, base_y, table_width + col_id_width, max_height, 'FD');

        pdf.SetXY(base_x, base_y);

        # write the cells on page

        pdf.RDMCell(col_id_width, row_height, "#", "T", 0, 'C', 1)

        issues_to_pdf_draw_borders(pdf, base_x, base_y, base_y + max_height, col_id_width, col_width)

        pdf.SetY(base_y + max_height);

      # Returns a PDF string of a list of issues

      def issues_to_pdf(issues, project, query)

        title = query.new_record? ? l(:label_issue_plural) : query.name

        title = "#{project} - #{title}" if project

        pdf.SetTitle(title)

        # column widths

        table_width = page_width - right_margin - 10  # fixed left margin

        col_width = []

          col_width = calc_col_width(issues, query, table_width - col_id_width, pdf)

          table_width = col_width.inject(0) {|s,v| s += v}

        end

        # title

        pdf.SetFontStyle('B',11)

        pdf.RDMCell(190,10, title)

          issues_to_pdf_write_cells(pdf, col_values, col_width, row_height)

          issues_to_pdf_draw_borders(pdf, base_x, base_y, base_y + max_height, col_id_width, col_width)

          pdf.SetY(base_y + max_height);

        end

        if issues.size == Setting.issues_export_limit.to_i

tr.issue td.subject, tr.issue td.relations { text-align: left; }

tr.issue td.done_ratio table.progress { margin-left:auto; margin-right: auto;}

tr.issue td.relations span {white-space: nowrap;}

tr.issue.idnt td.subject a {background: url(../images/bullet_arrow_right.png) no-repeat 0 50%; padding-left: 16px;}

tr.issue.idnt-1 td.subject {padding-left: 0.5em;}

    assert_equal 'text/csv; header=present', @response.content_type

    assert @response.body.starts_with?("#,")

    lines = @response.body.chomp.split("\n")

  end

  def test_index_csv_with_multi_column_field

    assert_equal 'application/pdf', response.content_type

  end

  def test_index_send_html_if_query_is_invalid

    get :index, :f => ['start_date'], :op => {:start_date => '='}

    assert_equal 'text/html', @response.content_type

  def test_default_columns

    q = Query.new

  end

  def test_set_column_names

    assert q.has_column?(c)

  end

  def test_query_should_preload_spent_hours

    q = Query.new(:name => '_', :column_names => [:subject, :spent_hours])

    assert q.has_column?(:spent_hours)