Redmine

    @cfs=AttributeGroup.joins(:custom_fields).joins(:tracker).

      where(project_id: @project, tracker_id: @trackers, :custom_fields => {id: @project.all_issue_custom_fields.pluck(:id)}).

      pluck("trackers.id", "id", "name", "position","attribute_group_fields.id", "attribute_group_fields.position",

            "custom_fields.id", "custom_fields.name", "custom_fields.position").sort_by{|x| [x[3], x[5]]}

  def groupissuescustomfields

    # clean invalid values: invalid cfs, empty cf lists, empty groups

    group_issues_custom_fields = (JSON.parse params[:group_issues_custom_fields]).

      each{|tid,v| v.replace(v.select{|k,v| v["cfs"] ? v["cfs"].delete_if{|k,v| @project.all_issue_custom_fields.pluck(:id).include?(v)} : v})}.

      each{|tid,v| v.delete_if{|k,v| v["cfs"].blank?}}.

      delete_if{|k,v| v.blank?}

    groups = AttributeGroup.where(project_id: @project.id).collect(&:id)

    fields = AttributeGroupField.where(attribute_group_id: groups).collect(&:id) 

    group_issues_custom_fields.each do |tid,v|

      v.each do |gp, g|

        gid = groups.shift

        if gid.nil?

          gid=AttributeGroup.create(project_id: @project.id, tracker_id: tid, name: g["name"].nil? ? nil : g["name"], position: gp).id

        else

          AttributeGroup.update(gid, project_id: @project.id, tracker_id: tid, name: g["name"].nil? ? nil : g["name"], position: gp)

        end

        g['cfs'].each do |cfp, cf|

          cfid = fields.shift

          if cfid.nil?

            AttributeGroupField.create(attribute_group_id: gid, custom_field_id: cf, position: cfp)

          else

            AttributeGroupField.update(cfid, attribute_group_id: gid, custom_field_id: cf, position: cfp)

          end

        end

      end

    end

    AttributeGroupField.where(id: fields).delete_all

    AttributeGroup.where(id: groups).destroy_all

    flash[:notice] = l(:notice_successful_update)

    redirect_to settings_project_path(@project, :tab => 'groupissuescustomfields')

  end

  def group_by_keys(project_id, tracker_id, custom_field_values)

    keys_grouped = AttributeGroupField.joins(:attribute_group).

      where(:attribute_groups => {project_id: project_id, tracker_id: tracker_id}).

      order("attribute_groups.position", :position).pluck(:name, :custom_field_id).group_by(&:shift)

    custom_fields_grouped = { nil => (keys_grouped[nil].nil? ? [] : keys_grouped[nil].map{|n| custom_field_values.select{|x| x.custom_field[:id] == n[0]}}.flatten) |

      custom_field_values.select{|y| ! keys_grouped.values.flatten.include?(y.custom_field[:id])}}

    keys_grouped.reject{|k,v| k == nil}.each{|k,v| custom_fields_grouped[k] = v.map{|n| custom_field_values.select{|x| x.custom_field[:id] == n[0]}}.flatten}

    custom_fields_grouped

  end

    s=''

    group_by_keys(issue.project_id, issue.tracker_id, issue.visible_custom_field_values).each do |title, values|

      if values.present?

        s << content_tag('h4', title, :style => 'background: #0001; padding: 0.3em;') unless title.nil?

        half = (values.size / 2.0).ceil

        s << issue_fields_rows do |rows|

          values.each_with_index do |value, i|

            css = "cf_#{value.custom_field.id}"

            m = (i < half ? :left : :right)

            rows.send m, custom_field_name_tag(value.custom_field), show_value(value), :class => css

          end

        end

    s.html_safe

    group_by_keys(issue.project_id, issue.tracker_id, issue.visible_custom_field_values(user)).each do |title, values|

      if values.present?

        if title.nil?

          values.each do |value|

            items << "#{value.custom_field.name}: #{show_value(value, false)}"

          end

        else   

          item = [ "#{title}" ]

          values.each do |value|

            item << "#{value.custom_field.name}: #{show_value(value, false)}"

          end

          items << item

        end

      end

      content_tag('ul', items.select{|s| s.is_a? String}.map{|s| content_tag('li', s)}.join("\n").html_safe) + "\n" +

      items.select{|s| !s.is_a? String}.map{|item| content_tag('div', item.shift) + "\n" +

        content_tag('ul', item.map{|s| content_tag('li', s)}.join("\n").html_safe)}.join("\n").html_safe

      items.select{|s| s.is_a? String}.map{|s| "* #{s}"}.join("\n") + "\n" +

      items.select{|s| !s.is_a? String}.map{|item| "#{item.shift}\n" + item.map{|s| "* #{s}"}.join("\n")}.join("\n")

            {:name => 'activities', :action => :manage_project_activities, :partial => 'projects/settings/activities', :label => :enumeration_activities},

            {:name => 'groupissuescustomfields', :action => :edit_project, :partial => 'projects/settings/groupissuescustomfields', :label => :grouped_cf}

class AttributeGroup < ActiveRecord::Base

  belongs_to :project

  belongs_to :tracker

  has_many :attribute_group_fields, :dependent => :delete_all

  has_many :custom_fields, :through => :attribute_group_fields

  acts_as_list

  scope :sorted, lambda { order(:position) }

end

class AttributeGroupField < ActiveRecord::Base

  belongs_to :attribute_group

  belongs_to :custom_field

  acts_as_list

  scope :sorted, lambda { order(:position) }

end

  has_many :attribute_group_fields, :dependent => :delete_all

  has_many :attribute_groups, :dependent => :destroy

  has_many :attribute_group_fields, :through => :attribute_groups

  has_many :attribute_groups, :dependent => :destroy

  has_many :attribute_group_fields, :through => :attribute_groups

<% group_by_keys(@issue.project_id, @issue.tracker_id, @issue.editable_custom_field_values).each do |title,values| %>

<% if values.present? %>

<%= content_tag('h4', title, :style => 'background: #0001; padding: 0.3em;') unless title.nil? %>

<% split_on = (values.size / 2.0).ceil - 1 %>

<% values.each do |value| %>

<% if i == split_on %>

<% end %>

<% i += 1 %>

<% end %>

<% end %>

<p><%= select_tag "tracker_id", options_from_collection_for_select(@project.trackers.collect, "id", "name"), {:required => true, :onchange => "refresh_trackers(this);"} %><p>

<div id='custom_fields_form'>

  <% @project.trackers.each do |t| %>

  <div id='tracker_<%= t.id %>' class='tracker'>

    <span style="color: #888;"><%= l(:changed_cf_position) %></span>

    <ul class='sortable_items sortable_tracker-<%= t.id %> nil not_a_group'>

      <% @cfs.select{|x| x[0]==t.id && x[2]==nil}.each do |x| %>

      <li id="<%= x[6] %>" pos="<%= x[8] %>"><%= x[7] %></li>

      <% end %>

    </ul>

    <span style="color: #888;"><%= l(:global_cf_position) %></span>

    <ul class="sortable_items sortable_tracker-<%= t.id %> unsorted not_a_group">

      <% Issue.new(project_id: @project.id, tracker_id: t.id).custom_field_values.

           select{|x| ! @cfs.select{|c| c[0]==t.id}.map{|c| c[6]}.include?(x.custom_field_id)}.

           collect{|x| [x.custom_field.id, x.custom_field.name, x.custom_field.position]}.each do |x| %>

      <li id="<%= x[0] %>" pos="<%= x[2] %>"><%= x[1] %></li>

      <% end %>

    </ul>

    <span style="color: #888;"><%= l(:grouped_cf) %></span>

    <div class='sortable_groups groups_tracker-<%= t.id %>'>

      <% @cfs.select{|x| x[0]==t.id && x[2]!=nil}.map{|x| x[2]}.uniq.each do |g| %>

      <div class="sortable_group">

        <input type="text" value="<%= g %>" style="background: #ddf; padding: 5px; width: 360px"/>

        <img src="/images/delete.png" onclick="remove_label(this, 'tracker-<%= t.id %>');"/>

        <ul class='sortable_items sortable_tracker-<%= t.id %>'>

          <% @cfs.select{|x| x[0]==t.id && x[2]==g}.each do |x| %>

          <li id="<%= x[6] %>" pos="<%= x[8] %>"><%= x[7] %></li>

          <% end %>

        </ul>

      </div>

      <% end %>

      <div>

        <input type="text" value="" style="background: #ddf; padding: 5px; width: 370px"/>

        <img src="/images/add.png" style="" onclick="add_label(this, 'tracker-<%= t.id %>');"/>

      </div>

    </div>

  </div>

  <% end %>

<%= form_for @project, :url => { :action => 'groupissuescustomfields', :id => @project },

            :html => {:id => 'groupissuescustomfields-form',

                      :method => :post} do |f| %>

<%= hidden_field :group_issues_custom_fields, '', :id => 'group_issues_custom_fields', :name => 'group_issues_custom_fields' %>

<p><%= submit_tag l(:button_save), :onclick => "fill_json_data();" %></p>

<% end %>

</div>

<script>

function init_sortables(labelclass) {

  $( '.groups_' + labelclass ).sortable({

    items: 'div.sortable_group',

    connectWith: '.groups_' + labelclass,

    start: function(event, ui) {

      ui.placeholder.height(ui.item.height());

    },

    axis: 'y'

  });

  $( '.sortable_' + labelclass ).sortable({

    connectWith: '.sortable_' + labelclass,

    update: function(event, ui) {

      if (ui.item.parent().hasClass('unsorted')) {

        ui.item.parent().prepend(ui.item);

        ui.item.parent().children('li').each(function () {

          if (parseInt($(this).attr('pos')) < parseInt(ui.item.attr('pos'))) {

            ui.item.insertAfter(this);

          }

        });

      }

    },

    axis: 'y'

  }).disableSelection();

}

function refresh_trackers(tracker) {

  $('.tracker').hide();

  $('#tracker_' + tracker.value).show();

}

function add_label(label, labelclass) {

  var old_label = $(label), new_label = $(label).parent().clone();

  new_label.children().first().val('').trigger('change');

  old_label.attr('src','/images/delete.png').attr('onclick','remove_label(this, "' + labelclass + '");');

  old_label.prev().width('360px');

  old_label.parent().addClass('ui-sortable-handle sortable_group');

  old_label.parent().sortable({

    connectWith: '.groups_' + labelclass

  }).disableSelection();

  old_label.parent().append('<ul id="' + labelclass + '_" class="sortable_items sortable_' + labelclass + '"/>');

  old_label.next().sortable({

    connectWith: '.sortable_' + labelclass

  }).disableSelection();

  old_label.parent().parent().append(new_label);

}

function remove_label(label, labelclass) {

  $(label).next().children().each(function () {

    var item = this;

    $('.unsorted.sortable_' + labelclass).prepend(this);

    $('.unsorted.sortable_' + labelclass).children('li').each(function () {

      if (parseInt($(this).attr('pos')) < parseInt($(item).attr('pos'))) {

        $(item).insertAfter(this);

      }

    });

  });

  $(label).parent().hide();

}

function fill_json_data() {

  var r = {}, gp = 0, cp = 0;

  $('#custom_fields_form').children('div').each(function () {

    var tracker_id = this.id.split('_').pop();

    gp = 0, cp = 0;

    // Group 'nil'

    r[tracker_id] = {};

    r[tracker_id][++gp] = {'cfs': {}};

    $(this).children('.nil').children().each(function () {

      cp++;

      r[tracker_id][gp]['cfs'][cp] = this.id;

    });

    if (! r[tracker_id][gp]['cfs'][1]) { delete r[tracker_id][gp]; }

    $(this).children('.sortable_groups').children().each(function () {

      if ($(this).children('ul').length) {

        r[tracker_id][++gp] = {

          'name': $(this).children('input').val(),

          'cfs': {}

        };

        cp = 0;

        $(this).children('ul').children().each(function () {

          r[tracker_id][gp]['cfs'][++cp] = this.id;

        });

        if (! r[tracker_id][gp]['cfs'][1]) { r[tracker_id][gp] = ''; }

      }

    });

    if ( ! r[tracker_id] ) { r[tracker_id] = ''; }

  });

  console.log(r);

  $('#group_issues_custom_fields').val(JSON.stringify(r)); }

$('#tracker_id').change();

<% @project.trackers.each do |t| %>

init_sortables('tracker-<%= t.id %>');

<% end %>

</script>

  grouped_cf: Grouped Custom Fields

  global_cf_position: Global Custom Fields Position

  changed_cf_position: Changed Custom Fields Position

  grouped_cf: Agrupar campos personalizados

  global_cf_position: Posição global de campos personalizados

  changed_cf_position: Alterar posição de campos personalizados

      post 'groupissuescustomfields'

class CreateAttributeGroups < ActiveRecord::Migration

  def change

    create_table :attribute_groups do |t|

      t.references :project, index: true, foreign_key: true

      t.references :tracker, index: true, foreign_key: true

      t.string :name

      t.integer :position, :default => 1, :null => false

      t.timestamps null: false

    end

  end

end

class CreateAttributeGroupFields < ActiveRecord::Migration

  def change

    create_table :attribute_group_fields do |t|

      t.references :attribute_group, index: true, foreign_key: true

      t.references :custom_field, index: true, foreign_key: true

      t.integer :position

      t.timestamps null: false

    end

  end

end

class ChangeGroupPositionAttributes < ActiveRecord::Migration

  def change

    change_column_null :attribute_groups, :position, true

    change_column_default :attribute_groups, :position, nil

  end

end

  map.permission :edit_project, {:projects => [:settings, :edit, :update, :groupissuescustomfields]}, :require => :member

          border_middle_top  = 'T'

            pdf.RDMMultiCell(60, height, item ? item.last.to_s : "", (i == 0 ? border_middle_top : ""), '', 0, 0)

            pdf.RDMMultiCell(35, height, item ? "#{item.first}:" : "",  (i == 0 ? border_middle_top : ""), '', 0, 0)

          group_by_keys(issue.project_id, issue.tracker_id, issue.visible_custom_field_values).each do |title, values|

            if values.present?

              pdf.RDMCell(35+155, 5, title, "LRT", 1) unless title.nil?

              half = (values.size / 2.0).ceil

              left = []

              right = []

              values.each_with_index do |custom_value, i|

                (i < half ? left : right) << [custom_value.custom_field.name, show_value(custom_value, false)]

              end

              rows = left.size > right.size ? left.size : right.size

              rows.times do |i|

                heights = []

                pdf.SetFontStyle('B',9)

                item = left[i]

                heights << pdf.get_string_height(35, item ? "#{item.first}:" : "")

                item = right[i]

                heights << pdf.get_string_height(35, item ? "#{item.first}:" : "")

                pdf.SetFontStyle('',9)

                item = left[i]

                heights << pdf.get_string_height(60, item ? item.last.to_s  : "")

                item = right[i]

                heights << pdf.get_string_height(60, item ? item.last.to_s  : "")

                height = heights.max

                item = left[i]

                pdf.SetFontStyle('B',9)

                pdf.RDMMultiCell(35, height, item ? "#{item.first}:" : "", border_first, '', 0, 0)

                pdf.SetFontStyle('',9)

                pdf.RDMMultiCell(60, height, item ? item.last.to_s : "", "", '', 0, 0)

                item = right[i]

                pdf.SetFontStyle('B',9)

                pdf.RDMMultiCell(35, height, item ? "#{item.first}:" : "",  "", '', 0, 0)

                pdf.SetFontStyle('',9)

                pdf.RDMMultiCell(60, height, item ? item.last.to_s : "", border_last, '', 0, 2)

                pdf.set_x(base_x)

              end

            end

          end

div.issue .attribute {padding-left:225px; clear:left; min-height: 1.8em;}

div.issue .attribute .label {width: 215px; margin-left:-225px; font-weight:bold; float:left;}

div.issue .attribute .value p {margin: 0 0 0.8em 0;}

/* Custom Field Groups */

.sortable_groups {

  background: #eee;

  border: 1px solid #888;

  width: 445px;

  min-height: 30px;

  margin: 5px;

  padding: 5px;

}

.sortable_groups div {

  background: #ddf;

  border: 1px solid #888;

  min-height: 30px;

  margin: 5px;

  padding: 5px;

}

.sortable_items {

  background: #eee;

  border: 1px solid #888;

  width: 400px;

  min-height: 30px;

  margin: 5px;

  padding: 5px;

}

.sortable_items li {

  background: #ffffff;

  border: 1px solid #888;

  margin: 5px;

  padding: 5px;

  list-style-type: none;

  font-size: 1.2em;

}

.not_a_group {

  padding: 5px 27px;

}

.ui-sortable-handle:before {

  content:url('/images/reorder.png');

  margin-right: 5px;

}

.ui-sortable-placeholder {

  background: #8888ff;

  border: 1px solid #888;

  visibility: visible;

}

# Read about fixtures at http://api.rubyonrails.org/classes/ActiveRecord/FixtureSet.html

one:

  attribute_group_id: 

  custom_field_id: 

  position: 1

two:

  attribute_group_id: 

  custom_field_id: 

  position: 1

# Read about fixtures at http://api.rubyonrails.org/classes/ActiveRecord/FixtureSet.html

one:

  project_id: 

  tracker_id: 

  name: MyString

  position: 1

two:

  project_id: 

  tracker_id: 

  name: MyString

  position: 1