Update Another Model Yii

channasmcs · August 21, 2014, 8:07am

i have 4 data table

1.comment table

2.driver detail table

TABLE comments (

CommentId int(11),

UserId int(11) ,

Comment text,

Rating int(1),

PRIMARY KEY (CommentId),

);

TABLE driverdetails (

DriverDetailId int(11),

UserId int(11) NOT NULL,

AvarageRating double NOT NULL,

PRIMARY KEY (DriverDetailId),

KEY UserId (UserId)

);

[color="#FF0000"]IMP i removed some data feild to get easy to undestand what i explain[/color]

What i need to do is

when user update comment i need to update AvarageRating feild in driverdetails table

i using rating algorithm to calculate AvarageRating please dont mine that simply

whan user update  rating as 4 ---&#62; i need to update drierdetail table ---&#62; AvarageRating

i want to da this actionUpdate not a action create

this is my action update

///////////////////////////////////

public function actionUpdate(&#036;id)


{


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





	// Uncomment the following line if AJAX validation is needed


	// &#036;this-&gt;performAjaxValidation(&#036;model);





	if(isset(&#036;_POST['Comments']))


	{


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


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


			&#036;this-&gt;redirect(array('view','id'=&gt;&#036;model-&gt;CommentId));


	}





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


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


	));


}

//////////////////////////////////////

public function loadModel($id)

{


	&#036;model=Comments::model()-&gt;findByPk(&#036;id);


	if(&#036;model===null)


		throw new CHttpException(404,'The requested page does not exist.');


	return &#036;model;


}

channasmcs · August 21, 2014, 8:16am

public function actionUpdate($id)

{


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


            &#036;driver = Driverdetails::model()-&gt;findByAttributes(array('UserId'=&gt;&#036;model-&gt;DriverId));


	// Uncomment the following line if AJAX validation is needed


	// &#036;this-&gt;performAjaxValidation(&#036;model);


             // &#036;driver = Driverdetails::model()-&gt;findByAttributes(array('UserId'=&gt;&#036;model-&gt;DriverId));


                


                  //  &#036;drier-&gt;AvarageRating=2;


                   //&#036;drier-&gt;save();


               


	if(isset(&#036;_POST['Comments']))


	{


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


                    


                    


                    &#036;driver-&gt;AvarageRating=&#036;model-&gt;Rating;


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


			&#036;this-&gt;redirect(array('view','id'=&gt;&#036;model-&gt;CommentId));


	}





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


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


	));


}