cakephp-3.0 - Cakephp 3 查询或条件

Question

伙计们，我如何在以下 Where 语句中应用 OR 条件？

$this->IbCommisions->find()->matching(
    'Users.Accounts',function ($q) {
        return $q->where(['IbCommisions.ib_id' => $this->userid, 'Users.country_id' => $this->request->data['country']]);
}

变得像

(['IbCommisions.ib_id' => $this->userid OR 'Users.country_id' => $this->request->data['country']])

Answer 1

return $q->where(['OR' => [
    'IbCommisions.ib_id' => $this->userid,
    'Users.country_id' => $this->request->data['country']
]]);

或者

return $q->where(['IbCommisions.ib_id' => $this->userid])
    ->orWhere(['Users.country_id' => $this->request->data['country']]);

http://book.cakephp.org/3.0/en/orm/query-builder.html#advanced-conditions