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
2 回答
慕森王
TA貢獻1777條經驗 獲得超3個贊
$orders = Orders::find()->filterWhere([
'pay_status' => 1,
'ship_status' => 0
])->orFilterWhere([
'pay_status' => 0,
'payment' => 1,
'ship_status' => 0
])->all();
人到中年有點甜
TA貢獻1895條經驗 獲得超7個贊
$orders = Orders::find()->where([
'AND',
['pay_status' => 1],
['ship_status' => 0]
])->orWhere([
'AND',
['pay_status' => 0],
['payment' => 1],
['ship_status' => 0]
])->all();
- 2 回答
- 0 關注
- 1728 瀏覽
添加回答
舉報
0/150
提交
取消