Cgridview Relation Null Value

Yii 1.1 General Discussion
1

Good day guys, I would like to ask if you know how to substitute N/A to null value from CGridView.

This is my codes.

<?php $this->widget(‘zii.widgets.grid.CGridView’, array(

'id'=&gt;'shis-duty-grid',


'dataProvider'=&gt;&#036;model-&gt;search(),


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


'columns'=&gt;array(


	'duty_date',


	'duty_time_in',


	'duty_time_out',


	array(


		'header'=&gt;'Dr. Fullname',


		'name'=&gt;'dutyFullname.dr_fullname',


		'filter'=&gt;CHtml::activeTextField(&#036;model,'fu_search'),


	),


	array(


		'header'=&gt;'Reliever',


		'name'=&gt;'dutyReliever.dr_fullname',


		'filter'=&gt;CHtml::activeTextField(&#036;model,'re_search'),


	),


	array(


		'class'=&gt;'CButtonColumn',


	),


),

)); ?>

@the reliever header sometimes there are null value. So I want to display N/A if the data is empty or null.

2

I don’t how you have your database structured assuming “dutyFullname” is association/related model




// add this in your dutyFullname/modelClass


public $fullname;




public function afterFind()

{

    $this->fullname = ($this->dr_fullname === "null") ? "N/A": $this->dr_fullname;

    parent::afterFind();


}




// change this part


array(

'header'=>'Reliever',

'name'=>'dutyReliever.fullname',

'filter'=>CHtml::activeTextField($model,'re_search'),

),
3

You may try this as well:

array(

‘header’=>‘Reliever’,

‘name’=>‘dutyReliever.dr_fullname’,

‘value’=>’($data->dutyReliever !== null) ? $data->dutyReliever->dr_fullname : “N/A”’,

‘filter’=>CHtml::activeTextField($model,‘re_search’),

),

4

tnx man, this really helps me I really appreciate your solution :D

5

tnx for your replay, i appreciate your help :)