Redmine

require 'test_helper'

class IssueCategorySubcategoryTest < ActiveSupport::TestCase

  fixtures :issue_subcategories, :issues

  def setup

    @subcategory = IssueSubcategory.find(1)

  end

  def test_destroy

    issue = @subcategory.issues.first

    @subcategory.destroy

    # Make sure the category was nullified on the issue

    assert_nil issue.reload.subcategory

  end

  def test_destroy_with_reassign

    issue = @subcategory.issues.first

    reassign_to = IssueSubcategory.find(2)

    @subcategory.destroy(reassign_to)

    # Make sure the issue was reassigned

    assert_equal reassign_to, issue.reload.subcategory

  end

end

# Read about fixtures at http://ar.rubyonrails.org/classes/Fixtures.html

one:

  issue_category_id: 1

  name: Toner

two:

  issue_category_id: 1

  name: Paper

  def add_issue_subcategory_link(name)

     link_to_function name do |page|

      page.insert_html :bottom, :issue_subcategories, :partial => "subcategories", :object => IssueSubcategory.new

    end

  end

      when 'subcategory_id'

        c = IssueSubcategory.find_by_id(detail.value) and value = c.name if detail.value

        c = IssueSubcategory.find_by_id(detail.old_value) and old_value = c.name if detail.old_value

                  l(:field_sub_category),

                  issue.subcategory,

  has_many :subcategories, :class_name => 'IssueSubcategory', :foreign_key => 'category_id', :dependent => :nullify

  # after something changes, we need to save the changes!

  after_update :save_sub_categories

  # we get passed a hash of key => value pairs that describe

  # the new subcategories.  we need to set their ID to this

  # objects ID

  def new_issue_subcategories=(subcategory_elements)

    subcategory_elements.each do |subcat|

      subcat[:category_id] = :id

      subcategories.build(subcat)

    end

  end

  # update or delete existing address lines

  def existing_issue_subcategories=(subcategory_elements)

    subcategories.reject(&:new_record?).each do |line|

      attributes = subcategory_elements[line.id.to_s]

      if attributes

        line.attributes = attributes

      else

        subcategories.delete(line)

      end

    end

  end

  protected

  #called after a change (add/update/delete) to save to the database

  def save_sub_categories

    subcategories.each do |subcategory|

      subcategory.save(false)

    end

  end

  belongs_to :subcategory, :class_name => 'IssueSubcategory', :foreign_key => 'subcategory_id'

class IssueSubcategory < ActiveRecord::Base

  belongs_to :issue_category, :foreign_key => 'category_id'

  validates_presence_of :name

  validates_uniqueness_of :name, :scope => [:category_id]

  validates_length_of :name, :maximum => 30

  def <=>(subcategory)

    name <=> subcategory.name

  end

  def to_s; name end

end

  before_filter :authorize, :except => [:index, :changes, :gantt, :calendar, :preview, :update_form, :context_menu, :update_issue_subcategories]

  def update_issue_subcategories

    results = IssueSubcategory.find(:all, :conditions=>{"category_id"=> params[:category_id]})

    render :update do |page|

      page.replace_html 'issue_subcategory', :partial => 'subcategories', :object => results

    end

  end

<span class="issue_subcategory">

<% new_or_existing = subcategories.new_record? ? 'new' : 'existing' %>

<% prefix = "category[#{new_or_existing}_issue_subcategories][]" %>

<% fields_for prefix, subcategories do |subcategory_form| -%>

<p>

<%= subcategory_form.text_field :name %>

<%= link_to_function l(:button_delete) , "$(this).up('.issue_subcategory').remove()" %>

</p>

<% end %>

</span>

<p>

<%= add_issue_subcategory_link l(:label_issue_subcategory_new) %>

<div id="issue_subcategories">

<%= render :partial => 'subcategories', :collection => @category.subcategories %>

</p>

</div>

<%= subcategories.nil? ? "" : collection_select(:issue, :subcategory_id, subcategories, :id, :name,:include_blank=>true) %>

:update => :content,

:with => "Form.serialize('issue-form')" %>

<p>

    <%= f.select(:category_id, (@project.issue_categories.collect {|c| [c.name, c.id]}), {:include_blank => true}, {:onchange => "#{remote_function(:url  => {:action => "update_issue_subcategories"},

                               :with => "'category_id='+value")}"} )%>

<span id="issue_subcategory">

<% unless @issue.category.nil? %>

<%=  f.collection_select(:subcategory_id, @issue.category.subcategories, :id, :name,:include_blank=>true) %>

</span>

    <%= prompt_to_remote(l(:label_issue_category_new),

l(:label_issue_category_new), 'category[name]',

{:controller => 'projects', :action => 'add_issue_category', :id => @project},

:class => 'small', :tabindex => 199) if authorize_for('projects', 'add_issue_category') %>

</p>

<% end %>

<%= content_tag('p', f.select(:fixed_version_id,

(@project.versions.sort.collect {|v| [v.name, v.id]}),

{ :include_blank => true })) unless @project.versions.empty? %>

    <td class="category"><b><%=l(:field_category)%>:</b></td><td><%=h @issue.category ? @issue.category.name : "-" %>

    <%=h @issue.subcategory ? " / "+@issue.subcategory.name : "-" %></td>

field_subcategory: Subcategory

label_issue_subcategory: Issue subcategory

label_issue_subcategory_plural: Issue subcategories

label_issue_subcategory_new: New subcategory

  class CreateIssueCategorySubcategories < ActiveRecord::Migration

  def self.up

    create_table :issue_subcategories do |t|

      t.integer :category_id

      t.string :name,  :limit => 30, :null => false

      t.timestamps

    end

  end

  def self.down

    drop_table :issue_subcategories

  end

end

class AddSubCategoriesToIssues < ActiveRecord::Migration

  def self.up

	add_column :issues, :subcategory_id, :integer

  end

  def self.down

	remove_column :issues, :subcategory_id

  end

end