Findallbyattributes To Return Pk For Filter Of Cgridview

philipvd · March 18, 2013, 9:34pm

Hi all,

Sorry to bother you.

I’m a newbie to yii.

Searched te web, the forum and the site but didn’t find a solution for a problem I’m having.

I need a dynamic filter using CGRIDVIEW.

I’ve set it up, working (hopefully good).

Now they can select a District from a list with the parent being the inputted afdeling. Displays fine but the moment you select a district from the provided list I get an sql error. Reason. The filter is not selecting the pk of the table afdeling (which has afdeling, district etc… in it). So now the solution is getting the pk of table afdeling instead of the parent_id.

Code :

if(Yii::app()->user->getState(‘district’) == NULL){

&#036;arrayDistrict = array('id'=&gt;'not null','parent'=&gt;Yii::app()-&gt;user-&gt;getState('afdeling'));


array_push(&#036;arrayColumns,array(


				'name'=&gt;'district_id',


				'value'=&gt;'GxHtml::valueEx(&#036;data-&gt;district)',


				'filter'=&gt;GxHtml::listDataEx(Afdeling::model()-&gt;findAllByAttributes(&#036;arrayDistrict)),


				 ));

} else {

print(&quot;District &quot; . Yii::app()-&gt;user-&gt;getState('district') . &quot; / &quot;);

}

Can somebody point me in the right direction.

PS : I’m using $arrayDistrict because php has problem using multiple => in a sub-array.

Grtz,

Philip Van Daele

Belgium