实际需求:
//状态不是删除的,goods_sn全表唯一,goods_name和goods_name_en公司内唯一
原生sql:
SELECT count(1) FROM `ec_goods` `a` WHERE
(a.status !=2)
AND
((goods_sn =2)
OR ((corp_id =2)
AND
((goods_name ='goods_name')
OR
(goods_name_en ='goods_name_en'))))
yii2 where:
$map = [ 'and', 'a.status !=:del_status', [ 'or', 'goods_sn =:goods_sn', [ 'and', 'corp_id =:corp_id', [ 'or', 'goods_name =:goods_name', 'goods_name_en =:goods_name_en' ] ] ] ];