Yii2 Model Rules Update Checking Rules For Same Record

Question

I.E. If i update address_line1 then its giving error for mobile number allocated. While update it should not match with it self. Even if i change mobile number it should check with other user.

public function rules()
    {
        return [
                    [['mobile_number','address_line1','address_line2','city','state','country','pincode' ],'required'],
                    ['mobile_number','mobile_number_allocation_validate'],

        ];
    }

public function mobile_number_allocation_validate($attribute){
        // add custom validation
        $result = User::find()
        ->where('`mobile_number` = "'.$this->$attribute.'" AND 
                `status` = "A" ')->all();
        if(!empty($result)){
            $this->addError($attribute,'Mobile number is allocated to other vehicle');
        }

    }

Thanks in Advance

Is there a reason you've not just used the `unique` validator? — Joe Miller, Dec 25 '15 at 02:22
@JoeMiller duplication will be there but i need to filter with active user.as i will not delete my single row from database. — Santosh, Dec 28 '15 at 17:17

Double H · Answer 1 · 2015-12-24T10:14:04.103

0

Change your condition as :-- Override beforeSave() of User ActiveRecord

/**
 * BeforeSave() check if User ActiveRecord is created with same calculator param
 * if created then return false with model error
 *
 */
public function beforeSave($insert){
    $model = self::find()->where('`mobile_number` = "'.$this->$attribute.'" AND 
            `status` = "A" ')->all();

    if($model !== null && $model->id !== $this->id){
        $this->addError('mobile_number' , 'Mobile number is allocated to other vehicle');
        return false;
    }

    return parent::beforeSave($insert);
}

edited Dec 24 '15 at 10:14

answered Dec 24 '15 at 05:42

Double H

4,120
1
15
26

$this->id which id will refer ? (Trying to get property of non-object) – Santosh Dec 24 '15 at 09:05
want to know above model is User ActiveRecord Class of any other model class.. other than User Class – Double H Dec 24 '15 at 10:01
please post your `mobile_number_allocation_validate` function whole class – Double H Dec 24 '15 at 10:04
from rule i am calling mobile_number_allocation_validate method – Santosh Dec 24 '15 at 10:07

score 0 · Answer 2 · answered Dec 29 '15 at 05:27

You should be able to use the unique validator for this, by simply adding a filter condition like this

public function rules()
    {
        return [
            [['mobile_number','address_line1','address_line2','city','state','country','pincode' ],'required'],
            ['mobile_number','unique', 'filter' => ['status' => 'A']],
        ];
    }

Yii2 Model Rules Update Checking Rules For Same Record

2 Answers2