[hameedhamdani]

Hi All,

I have two tables, table_a and tabl_b.
after saving data in table_a, i want to save some columns of table_a those are currently saved into a database table of table_b.


any help plz...


Thanks

[Keith]

What have you tried so far?

[hameedhamdani]

Keith, on 05 December 2012 - 04:12 AM, said:

What have you tried so far?

I tried this code for inserting values from model a to model b.

 protected function afterSave()
{
	$clientid = Client::model()->findByPk(Yii::app()->user->id);
	Packageassignment::model()->user_id = $clientid;
	Packageassignment::model()->package_id= $this-->package_id;
	Packageassignment::model()->package_start_date =$this->p_start_date;
	
	
   Packageassignment::model()->package_end_date   =$this->p_end_date;

	$clientid->Save(false);
   
}

[Keith]

And are you trying to create a new record in B or trying to update an existing one?

Note that at the moment, assuming the afterSave() method is in the class of $a, it will be called in an infinite loop as you're saving $a within it's own afterSave() method.

[lifo]

i have tried like below and its working for me::

protected function afterSave() { // "afterSave" of Post model
	parent::afterSave();
				
	$comment= Comment::model()->findByPk(7);
	$comment->content=$this->name;
        $comment->description='copied from post';		
	$comment->save(false);
}

[hameedhamdani]

Keith, on 05 December 2012 - 05:13 AM, said:

And are you trying to create a new record in B or trying to update an existing one?

Note that at the moment, assuming the afterSave() method is in the class of $a, it will be called in an infinite loop as you're saving $a within it's own afterSave() method.

@Keith..plz see my updates..i just want to copy a record from current model to a database table.thanks

[fouss]

hameedhamdani, on 05 December 2012 - 06:03 AM, said:

@Keith..plz see my updates..i just want to copy a record from current model to a database table.thanks

When do you need to make this copy? you may not need function afterSave() ...........

[hameedhamdani]

fouss, on 06 December 2012 - 03:21 AM, said:

When do you need to make this copy? you may not need function afterSave() ...........

i need copy data after saving in database.i want only specific data to be copied into other database tables.

thanks

[fouss]

hameedhamdani, on 06 December 2012 - 03:46 AM, said:

i need copy data after saving in database.i want only specific data to be copied into other database tables.

thanks

ok!

protected function afterSave() //Copy data from Client to packageassignment *** assuming your you're in the Client model 
								//and Clien has id,package_id,p_start_date
{
	$packageassignment= new Packageassignment();
	$packageassignment->user_id=$this->id;
	$packageassignment->package_id=$this->package_id;
	$packageassignment->package_start_date=$this->p_start_date;
	$packageassignment->save();
	return parent::afterSave();
}

[hameedhamdani]

fouss, on 06 December 2012 - 03:57 AM, said:

ok!

protected function afterSave() //Copy data from Client to packageassignment *** assuming your you're in the Client model 
								//and Clien has id,package_id,p_start_date
{
	$packageassignment= new Packageassignment();
	$packageassignment->user_id=$this->id;
	$packageassignment->package_id=$this->package_id;
	$packageassignment->package_start_date=$this->p_start_date;
	$packageassignment->save();
	return parent::afterSave();
}

Sir No record is copy from client to packageassignment.plz advise.thanks

[hameedhamdani]

fouss, on 06 December 2012 - 03:57 AM, said:

ok!

protected function afterSave() //Copy data from Client to packageassignment *** assuming your you're in the Client model 
								//and Clien has id,package_id,p_start_date
{
	$packageassignment= new Packageassignment();
	$packageassignment->user_id=$this->id;
	$packageassignment->package_id=$this->package_id;
	$packageassignment->package_start_date=$this->p_start_date;
	$packageassignment->save();
	return parent::afterSave();
}

@fouss...sir no data is copying into 2nd table...plz advise..thanks