Yii MANY_MANY附加所有连接条件 - Yii MANY_MANY additionall join condition

Yii MANY_MANY additionall join condition

本文关键字：MANY 连接条件 Yii | 更新日期: 2023-09-27

关系：

'users' => array(self::MANY_MANY, 'Users', 'comments_views(comment_id, user_id)', 'together' => true),

.SQL：

LEFT OUTER JOIN "comments_views" "users_users"
ON (
       "t"."id"="users_users"."comment_id"
)
LEFT OUTER JOIN "users" "users"
ON (
       "users"."id"="users_users"."user_id"
)

如何修改关系以获取此 sql：

LEFT OUTER JOIN "comments_views" "users_users"
ON (
       "t"."id"="users_users"."comment_id"
   AND "users_users"."user_id" = <param>
)
LEFT OUTER JOIN "users" "users"
ON (
       "users"."id"="users_users"."user_id"
)

你应该

使用on而不是condition。

'users' => array(
              self::MANY_MANY, 
              'Users', 
              'comments_views(comment_id, user_id)', 
              'together' => true
           ),

成为

     'users' => array(
              self::MANY_MANY,
              'Users',
              'comments_views(comment_id, user_id)',
              'together' => true,
              'on'=>'users_users.user_id=:user_id',
              'params'=>array(':user_id' => $user_id)‌,
           ),

理想情况下，users_users应替换为关系的名称。