CakePHP使用多个“ OR”查找条件

问题描述：

我真的很头疼，无法正常工作。这是我在原始MySQL中期望得到的结果：

I'm having a real headache getting this to work correctly. This is my desired outcome in raw MySQL:

WHERE `EmailTemplate`.`is_archived` = '0' 
AND
((`EmailTemplate`.`project_id` IS NULL) OR (`EmailTemplate`.`project_id` = 101))
AND
((`EmailTemplate`.`user_id` IS NULL) OR (`EmailTemplate`.`user_id` = 44))

这如何转换为CakePHP条件

How does this translate into a CakePHP conditions array?

答

最终解决了这个问题。

    $templateConditions = array(
            'EmailTemplate.is_archived' => 0,
            'AND' => array(
                       'OR' => array(
                                array('EmailTemplate.project_id IS NULL'),
                                array('EmailTemplate.project_id' => $this->request->data['Project']['project_id'])
                               )    
                     ),
                     array(
                       'OR' => array(
                                array('EmailTemplate.user_id IS NULL'),
                                array('EmailTemplate.user_id' => $this->Auth->user('id'))
                               )
                     )
            );

CakePHP使用多个“ OR”查找条件

相关推荐