0

Hi I have three models: company, plan and subscription with following association

    class Company < ActiveRecord::Base
      has_one :plan, :through => :subscriptions
      has_many :subscriptions
    end

    class Subscription < ActiveRecord::Base
      belongs_to :plan
      belongs_to :company
    end

   class Plan < ActiveRecord::Base
      has_many :subscriptions
      has_many :companies, :through => :subscriptions
    end

I have two plans in my application plan 'A' and plan 'B'. Plan 'A' is free and 'B' has some fee. Now i want to get companies registered with plan 'A' and companies with plan 'B'.
I want this data in my model, i know their is definitely a simple way to get all this but every thing i have used i not giving me right data.any help would be thankful.

Ravindra
  • 1,039
  • 2
  • 12
  • 26

2 Answers2

1

You need to insert new records through the association. Here is a related link that might help. how to add records to has_many :through association in rails

But a Pseudo-code will be like

1. You have a company object
2. you will have company.subscriptions
3. Insert new Plan objects in company.subscriptions
4. Save the data.

If you are still facing problem, I will try to add some code example.

Community
  • 1
  • 1
Samiron
  • 5,169
  • 2
  • 28
  • 55
  • Thanks for answer sir. but i save company plan and subscription on registration. Plan value passed through link as parameter and then that will automatic save in subscription table. Please add aome example code – Ravindra Sep 28 '12 at 06:58
  • Ok i will. Good that weekend coming :) – Samiron Sep 28 '12 at 08:55
1

To get companies registered with plan 'A' and companies with plan 'B'. Take object of plan, and then through following relationship code, you will get count of companies. This is join concept. eg. @plan is object of Plan 'A'. then @plan.companies.count.

I suggest to use "polymorphic association" concept.

pratik
  • 54
  • 6