Redmine

  helper :projects_queries

  include ProjectsQueriesHelper

        @entry_count = scope.count

        @entry_pages = Paginator.new @entry_count, per_page_option, params['page']

        @entries = scope.offset(@entry_pages.offset).limit(@entry_pages.per_page).to_a

      format.csv {

        # Export all entries

        @entries = scope.to_a

        send_data(query_to_csv(@entries, @query, params), :type => 'text/csv; header=present', :filename => 'projects.csv')

      }

  def grouped_project_list(projects, query, &block)

    ancestors = []

    grouped_query_results(projects, query) do |project, group_name, group_count, group_totals|

      ancestors.pop while ancestors.any? && !project.is_descendant_of?(ancestors.last)

      yield project, ancestors.size, group_name, group_count, group_totals

      ancestors << project unless project.leaf?

    end

  end

# frozen_string_literal: true

# Redmine - project management software

# Copyright (C) 2006-2017  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 ProjectsQueriesHelper

  include ApplicationHelper

  def column_value(column, item, value)

    if item.is_a?(Project)

      case column.name

      when :name

        link_to_project(item) + (content_tag('span', '', :class => 'icon icon-user my-project', :title => l(:label_my_projects)) if User.current.member_of?(item))

      when :short_description

        item.description? ? content_tag('div', textilizable(item, :short_description), :class => "wiki") : ''

      when :homepage

        item.homepage? ? content_tag('div', textilizable(item, :homepage), :class => "wiki") : ''

      when :status

        get_project_status_label[column.value_object(item)]

      when :parent_id

        link_to_project(item.parent) unless item.parent.nil?

      else

        super

      end

    end

  end

  def csv_content(column, item)

    if item.is_a?(Project)

      case column.name

      when :status

        get_project_status_label[column.value_object(item)]

      when :parent_id

        return item.parent.name unless item.parent.nil?

      end

    end

    super

  end

  private

  def get_project_status_label

    {

      Project::STATUS_ACTIVE => l(:project_status_active),

      Project::STATUS_CLOSED => l(:project_status_closed)

    }

  end

end

  def available_display_types_tags(query)

    available_display_types = []

    query.available_display_types.each do |t|

      available_display_types << [l(:"label_display_type_#{t}"), t]

    end

    select_tag('display_type', options_for_select(available_display_types, @query.display_type), :id => 'display_type')

  end

  self.available_columns = [

    QueryColumn.new(:name, :sortable => "#{Project.table_name}.name"),

    QueryColumn.new(:status, :sortable => "#{Project.table_name}.status"),

    QueryColumn.new(:short_description, :sortable => "#{Project.table_name}.description", :caption => :field_description),

    QueryColumn.new(:homepage, :sortable => "#{Project.table_name}.homepage"),

    QueryColumn.new(:identifier, :sortable => "#{Project.table_name}.identifier"),

    QueryColumn.new(:parent_id, :sortable => "#{Project.table_name}.lft ASC", :default_order => 'desc', :caption => :field_parent),

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

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

  ]

    return @available_columns if @available_columns

    @available_columns = self.class.available_columns.dup

    @available_columns += ProjectCustomField.visible.

                            map {|cf| QueryAssociationCustomFieldColumn.new(:project, cf) }

    @available_columns

  end

  def available_display_types

    ['board', 'list']

  end

  def default_columns_names

    @default_columns_names ||= [:name, :identifier, :short_description]

  end

  def default_sort_criteria

    [[]]

    self.display_type = params[:display_type] || query_params[:display_type] || self.display_type

  def display_type

    options[:display_type] || self.available_display_types.first

  end

  def display_type=(type)

    unless type || self.available_display_types.include?(type)

      type = self.available_display_types.first

    end

    options[:display_type] = type

  end

  def available_display_types

    ['list']

  end

<div id="projects-index">

  <%= render_project_hierarchy(@entries) %>

</div>

<div class="autoscroll">

<table class="list projects odd-even <%= @query.css_classes %>">

<thead>

  <tr>

    <% @query.inline_columns.each do |column| %>

      <%= column_header(@query, column) %>

    <% end %>

  </tr>

</thead>

<tbody>

<% grouped_project_list(entries, @query) do |entry, level, group_name, group_count, group_totals| -%>

  <% if group_name %>

    <% reset_cycle %>

    <tr class="group open">

      <td colspan="<%= @query.inline_columns.size %>">

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

        <span class="name"><%= group_name %></span>

        <% if group_count %>

        <span class="count"><%= group_count %></span>

        <% end %>

        <span class="totals"><%= group_totals %></span>

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

                             "toggleAllRowGroups(this)", :class => 'toggle-all') %>

      </td>

    </tr>

  <% end %>

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

    <% @query.inline_columns.each do |column| %>

    <%= content_tag('td', column_content(column, entry), :class => column.css_classes) %>

    <% end %>

  </tr>

<% end -%>

</tbody>

</table>

</div>

  <% if @entries.empty? %>

    <%= render :partial => @query.display_type, :locals => { :entries => @entries }%>

    <span class="pagination"><%= pagination_links_full @entry_pages, @entry_count %></span>

  <% if @query.available_display_types.size > 1 %>

  <p><label for='display_type'><%= l(:label_display_type) %></label>

    <%= available_display_types_tags(@query) %>

  </p>

<% end %>

<p id ="default_columns"><label for="query_default_columns"><%=l(:label_default_columns)%></label>

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

$(function ($) {

  $('#display_type').change(function (e) {

    var option = $(e.target).val()

    if (option == 'board') {

      $('fieldset#columns, fieldset#sort, p#default_columns, p#group_by').hide();

    } else {

      $('fieldset#columns, fieldset#sort, p#default_columns, p#group_by').show();

    }

  }).change()

});

        <div class="hidden">

          <% if @query.available_display_types.size > 1 %>

          <div>

            <span class="field"><label for='display_type'><%= l(:label_display_type) %></label></span>

            <%= available_display_types_tags(@query) %>

          </div>

          <% end %>

          <table id="list" class="<%= 'hidden' if (@query.display_type == 'board') %>">

<%= javascript_tag do %>

$(function ($) {

  $('#display_type').change(function (e) {

    var option = $(e.target).val()

    if (option == 'board') {

      $('table#list').hide();

    } else {

      $('table#list').show();

    }

  })

});

<% end %>

  label_display_type: Display results as

  label_display_type_list: List

  label_display_type_board: Board  

.hidden {display: none;}

table.list td.name, table.list td.description, table.list td.subject, table.list td.comments, table.list td.roles, table.list td.attachments, table.list td.text,  table.list td.short_description {text-align: left;}

tr.issue.idnt td.subject, tr.project.idnt td.name {background: url(../images/arrow_right.png) no-repeat 2px 50%;}

tr.issue.idnt-1 td.subject, tr.project.idnt-1 td.name {padding-left: 24px; background-position: 8px 50%;}

tr.issue.idnt-2 td.subject, tr.project.idnt-2 td.name {padding-left: 40px; background-position: 24px 50%;}

tr.issue.idnt-3 td.subject, tr.project.idnt-3 td.name {padding-left: 56px; background-position: 40px 50%;}

tr.issue.idnt-4 td.subject, tr.project.idnt-4 td.name {padding-left: 72px; background-position: 56px 50%;}

tr.issue.idnt-5 td.subject, tr.project.idnt-5 td.name {padding-left: 88px; background-position: 72px 50%;}

tr.issue.idnt-6 td.subject, tr.project.idnt-6 td.name {padding-left: 104px; background-position: 88px 50%;}

tr.issue.idnt-7 td.subject, tr.project.idnt-7 td.name {padding-left: 120px; background-position: 104px 50%;}

tr.issue.idnt-8 td.subject, tr.project.idnt-8 td.name {padding-left: 136px; background-position: 120px 50%;}

tr.issue.idnt-9 td.subject, tr.project.idnt-9 td.name {padding-left: 152px; background-position: 136px 50%;}

  def test_index_as_list_should_format_column_value

    get :index, :params => {

      :c => ['name', 'status', 'short_description', 'homepage', 'parent_id', 'identifier', 'is_public', 'created_on', 'project.cf_3'],

      :display_type => 'list'

    }

    assert_response :success

    assert_select 'table.projects' do

      assert_select 'tr[id=?]', 'project-1' do

        assert_select 'td.name a[href=?]', '/projects/ecookbook', :text => 'eCookbook'

        assert_select 'td.status', :text => 'active'

        assert_select 'td.short_description', :text => 'Recipes management application'

        assert_select 'td.homepage a.external', :text => 'http://ecookbook.somenet.foo/'

        assert_select 'td.identifier', :text => 'ecookbook'

        assert_select 'td.is_public', :text => 'Yes'

        assert_select 'td.created_on', :text => '07/19/2006 05:13 PM'

        assert_select 'td.project_cf_3.list', :text => 'Stable'

      end

      assert_select 'tr[id=?]', 'project-4' do

        assert_select 'td.parent_id a[href=?]', '/projects/ecookbook', :text => 'eCookbook'

      end

    end

  end

  def test_index_as_list_should_show_my_favourite_projects

    @request.session[:user_id] = 1

    get :index, :params => {

      :display_type => 'list'

    }

    assert_response :success

    assert_select 'tr[id=?] td.name span[class=?]', 'project-5', 'icon icon-user my-project'

  end

  def test_index_as_list_should_indent_projects

    @request.session[:user_id] = 1

    get :index, :params => {

      :c => ['name', 'short_description'],

      :sort => 'parent_id:desc,lft:desc',

      :display_type => 'list'

    }

    assert_response :success

    child_level1 = css_select('tr#project-5').map {|e| e.attr('class')}.first.split(' ')

    child_level2 = css_select('tr#project-6').map {|e| e.attr('class')}.first.split(' ')

    assert_include 'idnt', child_level1

    assert_include 'idnt-1', child_level1

    assert_include 'idnt', child_level2

    assert_include 'idnt-2', child_level2

  end

  end

  def test_default_columns

    q = ProjectQuery.new

    assert q.columns.any?

    assert q.inline_columns.any?

    assert q.block_columns.empty?

  end

  def test_available_columns_should_include_project_custom_fields

    query = ProjectQuery.new

    assert_include :"project.cf_3", query.available_columns.map(&:name)