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()->where([
    'AND',
    ['pay_status' => 1],
    ['ship_status' => 0]
])->orWhere([
    'AND',
    ['pay_status' => 0],
    ['payment' => 1],
    ['ship_status' => 0]
])->all();

Answer 2

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

Answer 3

$query->andWhere(['or',
['and', ['mainCurrency' => 1], ['or', ['between', 'scaleLower', 0, 600], ['between', 'scaleLower', 1500, 3000]]],
['and', ['mainCurrency' => 2], ['or', ['between', 'scaleLower', 0, 100], ['between', 'scaleLower', 250, 600]]],
]);

求教，再多一层嵌套该怎么写， 这么写是错误的，不支持，求解