I have a somewhat complex relationship that I can’t seem to express
properly. I have a model that has a has_many relationship to itself.
The idea is that a customer has a “state” and the states have a
prescribed flow to the next state. The idea is that a customer who is
in a state of “good standing” can’t go directly to “blacklisted”
without first going through “probation” or “under review”.
There are two models…
class State < ActiveRecord::Base
has_many :from_state_flows, :class_name => ‘StateFlow’, :foreign_key
=> ‘to_state_id’
has_many :to_state_flows, :class_name => ‘StateFlow’, :foreign_key =>
‘from_state_id’
end
class StateFlow < ActiveRecord::Base
belongs_to :from_state, :class_name => ‘State’, :foreign_key =>
‘from_state_id’
belongs_to :to_state, :class_name => ‘State’, :foreign_key =>
‘to_state_id’
end
I can’t get any “:through” relationship to work properly. The best I
have is this:
has_many :next_valid_states, :through => :to_state_flows, :source =>
:from_state_flows
I don’t really care if the solution is using a “through”. I just want
to get a list of the next valid set of states from the current state. I
can’t even figure out how to this through find() with an :include.
Any help is appreciated!
-Mark E.