Question

我有这个

User.joins(:notifications).joins(:company_users).joins(:role_users).where("notifications.id = ? AND role_users.role_id !=  1  AND (company_users.company_id = ? OR users.company_id = ?)", notification.id, p.company_id, p.company_id)

gt; []

生成此 sql 的 sql

SELECT `users`.* FROM `users` 
INNER JOIN `subscriptions` ON `users`.`id` = `subscriptions`.`user_id` 
INNER JOIN `notifications` ON `notifications`.`id` = `subscriptions`.`notification_id` 
INNER JOIN `company_users` ON `company_users`.`user_id` = `users`.`id` 
INNER JOIN `role_users` ON `role_users`.`user_id` = `users`.`id` 
WHERE (notifications.id = 1 
AND role_users.role_id !=  1  
AND (company_users.compcany_id = 67 OR users.company_id = 67))

问题是,我需要离开加入公司用户, 不知道如何在铁路上实现这一点

我知道只要我听说没有什么像... 任何想法那样的轨迹就能做这些事

Answer 1

已解决

User.joins(:notifications).joins("LEFT JOIN `company_users` ON `company_users`.`user_id` = `users`.`id`").joins(:role_users).where("notifications.id = ? AND role_users.role_id !=  1  AND (company_users.company_id = ? OR users.company_id = ?)", notification.id, p.company_id, p.company_id)

Answer 2

类用户 & lt; 活动记录 :: Base

 has_many :fri结束s, :foreign_key=>"u_from",:class_name=>"Fri结束"

结束

class Fri结束 < ActiveRecord::Base

 belongs_to :user

结束

fri结束s = user.fri结束s.where(:u_req_status=>2).joins("LEFT OUTER JOIN users ON users.u_id = fri结束s.u_to").select("fri结束_id,u_from,u_to,u_first_name,u_last_name,u_email,u_fbid,u_twtid,u_picture_url,u_quote")

友情链接