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();