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 如果寫出這樣的過濾規(guī)則呢??orWhere() andWhere()方法也無法在OR () 括號(hào)里面 像上面嵌套and
2 回答
慕森王
TA貢獻(xiàn)1777條經(jīng)驗(yàn) 獲得超3個(gè)贊
$orders = Orders::find()->filterWhere([
'pay_status' => 1,
'ship_status' => 0
])->orFilterWhere([
'pay_status' => 0,
'payment' => 1,
'ship_status' => 0
])->all();
人到中年有點(diǎn)甜
TA貢獻(xiàn)1895條經(jīng)驗(yàn) 獲得超7個(gè)贊
$orders = Orders::find()->where([
'AND',
['pay_status' => 1],
['ship_status' => 0]
])->orWhere([
'AND',
['pay_status' => 0],
['payment' => 1],
['ship_status' => 0]
])->all();
- 2 回答
- 0 關(guān)注
- 1741 瀏覽
添加回答
舉報(bào)
0/150
提交
取消