yii2唯一验证器仅当字段不为空时

Question

In Yii2 I have two fields in my Database: email and shopId

• Email and shopId should be unique together
• Email could also be empty (NULL) while shopId is always an integer

These are my rules in the Model:

[['email'],'default','value' => NULL],
[['shopId'], 'integer'],
[['email','shopId'], 'unique', 'targetAttribute' => ['email', 'shopId'], 'message' => 'Already taken!'],

This is not working when I have two entries with e.g. email="NULL" and shopId="1".

How can I solve this?

Answer 1

Set skipOnEmpty property to false http://www.yiiframework.com/doc-2.0/yii-validators-validator.html#$skipOnEmpty-detail