updateAll() function not working proper on update record

hirenbhut93 · December 18, 2014, 9:52am

I have implement following code :

model code:



public function rules()


    {


        return [


          -------------------


	    ['message_of_day_active', 'integer'],


            [['creation_date', 'message_of_day_active'], 'safe'],


         ----------------------------------------


        ];


    }

controller code:



&#036;model = &#036;this-&gt;findModel(&#036;id);





	if (&#036;model-&gt;load(Yii::&#036;app-&gt;request-&gt;post())) {


		&#036;model-&gt;attributes = &#036;_POST['MessageOfDay'];


		&#036;model-&gt;creation_date= new &#092;yii&#092;db&#092;Expression('NOW()');


		if(&#036;_POST['MessageOfDay']['message_of_day_active']==1) {


			&#036;model-&gt;updateAll(['message_of_day_active'=&gt;0], 'message_of_day_active =1');


			&#036;model-&gt;message_of_day_active =1;


		}


		if(&#036;model-&gt;save())


			return &#036;this-&gt;redirect(['view', 'id' =&gt; &#036;model-&gt;id]);


	} 


		return &#036;this-&gt;render('update', [


			'model' =&gt; &#036;model,


			]);

View Code:



&lt;?= &#036;form-&gt;field(&#036;model, 'message_of_day_active')-&gt;checkBox(['value'=&gt;1, 'uncheckValue'=&gt;0], ['template' =&gt; &quot;{input} &lt;span class='status'&gt;&amp;nbsp;&lt;/span&gt;&quot;]); ?&gt;

when i have update record at time check box is selected but other record is updated but message_of_day_active field is set 0

when am change code for if condition is



if(&#036;_POST['MessageOfDay']['message_of_day_active']===1) {





--------------


}

at time record message_of_day_active field is set 1 update but updateAll() it not set 0 to all record

i have set message_of_day_active int(3) datatype

i have use PHP 5.5.19

Note: I have same code is use in yii 1.1.14 it work proper but yii 2.0.1 it not work.

What is problem in this code???

It is Yii2 Bug?..

please check this problem

mdmunir · December 19, 2014, 6:30am

If you migrate to Yii2, please leave your knowledge about Yii1 in your back. Yii2 is a different framework.

ActiveRecord::updateAll() is a static method. its update directly to database and not affected to ActiveRecord instance.

You are wrong when using checkbox doc.

BTT. You want only one row that has value message_of_day_active=1, right?

So, before save, you set all records to 0.

How about this




if ($model->load(Yii::$app->request->post())) {

    $model->creation_date= new \yii\db\Expression('NOW()');    

    if($model->message_of_day_active ==1){

        MessageOfDay::updateAll(['message_of_day_active'=>0],['message_of_day_active'=>1]);

    }

    if($model->save())

        return $this->redirect(['view', 'id' => $model->id]);

    } 

}


return $this->render('update', [

'model' => $model,

]);