Rails中如何查询has_many through关联的反向关系以获取用户所属会议

你之前的关联配置不生效核心原因有两个：

1. Panel模型没有默认的user_id外键，而是使用了panel_head、panel_member_1、panel_member_2三个独立的User关联字段，Rails无法匹配默认的关联规则
2. 原Panel模型中belongs_to :Meeting首字母大写是语法错误，必须使用小写的关联名

第一步：调整三个模型的关联配置 #

# Panel模型修正
class Panel < ApplicationRecord
  belongs_to :meeting # 修正原大写错误
  belongs_to :panel_head, class_name: "User"
  belongs_to :panel_member_1, class_name: "User"
  belongs_to :panel_member_2, class_name: "User"
end

# User模型关联配置
class User < ApplicationRecord
  # 分别定义不同角色对应的panel关联，显式指定外键
  has_many :headed_panels, class_name: "Panel", foreign_key: "panel_head_id"
  has_many :member1_panels, class_name: "Panel", foreign_key: "panel_member_1_id"
  has_many :member2_panels, class_name: "Panel", foreign_key: "panel_member_2_id"

  # 分别定义不同角色对应的会议关联
  has_many :headed_meetings, through: :headed_panels, source: :meeting
  has_many :member1_meetings, through: :member1_panels, source: :meeting
  has_many :member2_meetings, through: :member2_panels, source: :meeting

  # 方法1：返回去重后的会议数组，适合小数据量场景
  def all_related_meetings
    (headed_meetings + member1_meetings + member2_meetings).uniq
  end

  # 方法2：返回ActiveRecord_Relation对象，支持链式查询（where/order等），适合大数据量场景
  def all_related_meetings_ar
    Meeting.joins(:panel)
           .where("panels.panel_head_id = ? OR panels.panel_member_1_id = ? OR panels.panel_member_2_id = ?", self.id, self.id, self.id)
  end
end

# Meeting模型可选修正（如果需要获取会议关联的所有用户）
class Meeting < ApplicationRecord
  has_one :panel

  # 获取该会议所有小组成员
  def all_panel_users
    [panel.panel_head, panel.panel_member_1, panel.panel_member_2].compact
  end
end

第二步：调用方式 #

# 获取数组格式的所有关联会议
@user.all_related_meetings

# 获取可链式查询的关联会议，例：按开始时间倒序排列
@user.all_related_meetings_ar.order(start_time: :desc)

内容的提问来源于stack exchange，提问作者wayoh22