array( 'header'=>'client', 'type'=>'raw', 'value'=>'$data->getClientinformation($data->client_id)', 'filter'=>$model->getClientinfilter(), ),
public function getClientinformation($client_id){ $user = Yii::app()->db2->createCommand() ->select('name') ->from('client') ->where('id=:id', array(':id'=>$client_id)) ->queryAll(); return $user[0]['name']; } public function getClientinfilter(){ // return 'jibon'; $command = Yii::app()->db2->createCommand(); $userArray = $command->select('id, name')->from('client')->order('name')->queryAll(); return CHtml::dropdownlist('GalleryBooking[client_id]','',CHtml::listData($userArray,'id','name'), array('empty' => '')); }
No comments:
Post a Comment