has_many :through

rubyonrails-talk
1

Hi

I have a problem with has_many :trough association. I have 2 tables, Product and Category, and when I create new Product, I should make checkboxes to choose in what categories the product . I’ve made model category_product where I store the association from the Category and Product tables. Here is some of the code.

class Category < ActiveRecord::Base

has_many :category_products, dependent: :destroy has_many :products, :through => :category_products

accepts_nested_attributes_for :category_products

class CategoryProduct < ActiveRecord::Base

belongs_to :category belongs_to :product accepts_nested_attributes_for :category

class Product < ActiveRecord::Base

has_many :category_products, dependent: :destroy has_many :categories, :through => :category_products

accepts_nested_attributes_for :category_products

class ProductsController < ApplicationController

def new @product = Product.new end

def create

@product = Product.new(product_params)

if @product.save

  items_array = category_params
  items_array.each do |key, value|

      if value != ""
        @category_product = CategoryProduct.new(:category => value, :product => @product.id)
        @category_product.save
      end

  #category_products.create!(:category => arrayitem.id, :product => @product.id)
  end

  #@categories = Category.find(category_params)

  # @categories.each do |category|
    #category_products.create!(:category => category.id, :product => @product.id)
  #end
  flash[:source] = 'Successful'
  redirect_to @product
else
  render 'new'
end

end

def category_params params.require(:product).permit({:category_ids => [:id]}) end

def product_params params.require(:product).permit(:name, :price, :sale_status, :quantity, :release_date, {:category_ids => [:id]}) end

class CategoryProductsController < ApplicationController

def create @category_product = CategoryProduct.new(params[:product_ids, :category_ids]) if @category_product.save #sign_in @user #flash[:success] = “Welcome to the Sample App!” #redirect_to @user else #render ‘new’ end end

end

products/new.html.erb

<%= form_for(@product) do |f| %> <%=f.collection_check_boxes :category_ids, Category.all, :id, :name

2

What problem?