class WorkConnect < ActiveRecord::Base

  belongs_to :working, class_name: "Company"

  belongs_to :worked, class_name: "Company"

end                         

class Company < ActiveRecord::Base

  #working表示我合作的公司,worked表示跟我合作的公司

  has_many :working_c, class_name: "WorkConnect", foreign_key: :worked_id

  has_many :worked_c, class_name: "WorkConnect", foreign_key: :working_id

  has_many :working, class_name: "Company", through: :working_c

  has_many :worked, class_name: "Company", through: :worked_c

end     

class CreateWorkConnect < ActiveRecord::Migration
  def change
    create_table :work_connects do |t|
      t.integer :worked_id
      t.integer :working_id
    end
  end
end

2.3.0 :003 > c1 = Company.find(2)

  Company Load (0.2ms)  SELECT  `companies`.* FROM `companies` WHERE `companies`.`id` = 2 LIMIT 1

 => #<Company id: 2, name: "Eastcompeace", created_at: "2016-03-21 04:50:28", updated_at: "2016-03-21 04:50:28", work_id: nil>

2.3.0 :004 > c2 = Company.find(5)

  Company Load (0.2ms)  SELECT  `companies`.* FROM `companies` WHERE `companies`.`id` = 5 LIMIT 1

 => #<Company id: 5, name: "360", created_at: "2016-03-21 06:53:37", updated_at: "2016-03-21 06:53:37", work_id: nil>

2.3.0 :005 > c1.working

  Company Load (0.4ms)  SELECT `companies`.* FROM `companies` INNER JOIN `works` ON `companies`.`id` = `works`.`working_id` WHERE `works`.`worked_id` = 2

 => #<ActiveRecord::Associations::CollectionProxy []>

2.3.0 :006 > c1.working << c2

   (0.2ms)  BEGIN

  SQL (0.3ms)  INSERT INTO `works` (`worked_id`, `working_id`) VALUES (2, 5)

   (67.9ms)  COMMIT

 => #<ActiveRecord::Associations::CollectionProxy [#<Company id: 5, name: "360", created_at: "2016-03-21 06:53:37", updated_at: "2016-03-21 06:53:37", work_id: nil>]>

2.3.0 :007 > c1.worked

  Company Load (0.5ms)  SELECT `companies`.* FROM `companies` INNER JOIN `works` ON `companies`.`id` = `works`.`worked_id` WHERE `works`.`working_id` = 2

 => #<ActiveRecord::Associations::CollectionProxy []>

2.3.0 :008 > c1.working

 => #<ActiveRecord::Associations::CollectionProxy [#<Company id: 5, name: "360", created_at: "2016-03-21 06:53:37", updated_at: "2016-03-21 06:53:37", work_id: nil>]>

2.3.0 :009 > c1.save

   (0.2ms)  BEGIN

   (0.1ms)  COMMIT

 => true

2.3.0 :010 > c2.worke

NoMethodError: undefined method `worke' for #<Company:0x00000003c33e00>
2.3.0 :011 > c2.worked

  Company Load (0.5ms)  SELECT `companies`.* FROM `companies` INNER JOIN `works` ON `companies`.`id` = `works`.`worked_id` WHERE `works`.`working_id` = 5

 => #<ActiveRecord::Associations::CollectionProxy [#<Company id: 3, name: "tengxun", created_at: "2016-03-21 05:56:22", updated_at: "2016-03-21 05:56:22", work_id: nil>, #<Company id: 2, name: "Eastcompeace", created_at: "2016-03-21 04:50:28", updated_at: "2016-03-21 04:50:28", work_id: nil>]>

2.3.0 :012 > c2.working

  Company Load (0.4ms)  SELECT `companies`.* FROM `companies` INNER JOIN `works` ON `companies`.`id` = `works`.`working_id` WHERE `works`.`worked_id` = 5

 => #<ActiveRecord::Associations::CollectionProxy []>