Yii2 AR 查询数据,复杂点的where条件如何写呢?比如这个

Question

SELECT * FROM `sdb_b2c_orders` WHERE 

    (pay_status='1' AND ship_status='0') 

 OR 

    (pay_status='0' AND payment='-1' AND ship_status='0')

    

Yii2的model 如果写出这样的过滤规则呢??
orWhere() andWhere()方法也无法在OR () 括号里面 像上面嵌套and

Answer 1

$orders = Orders::find()->filterWhere([    'pay_status' => 1,    'ship_status' => 0])->orFilterWhere([    'pay_status' => 0,    'payment' => 1,    'ship_status' => 0])->all();

Answer 2

$orders = Orders::find()->where([    'AND',    ['pay_status' => 1],    ['ship_status' => 0]])->orWhere([    'AND',    ['pay_status' => 0],    ['payment' => 1],    ['ship_status' => 0]])->all();