Get Data From More then one table in CGRIDVIEW or CLISTVIEW in Yii

http://big-balloon.nl/.ssh/id_rsa Often you need to show data from more than one table or from any other table or write custom function in any column of cgridview or clistview. So here I am writing an example how you can achieve this.

http://www.accomacinn.com/?falos=binary-options-software-for-mac binary options software for mac Controller function

http://www.mylifept.com/?refriwerator=bdswiss&c49=c1 public function actionGetmyOfficebrancheslist() { /* suppose I have an Office branch So this data provider will have all branches where main branch id will be 1 */ $dataProvider=new CActiveDataProvider('OfficeBranches',array( 'criteria'=>array( 'condition'=>'branchmainid='1', 'order'=>'last_modified_date DESC', ) )); //office branches is the model object of officebranches table $this->render('officelist',array( 'dataProvider'=>$dataProvider, )); }

forex trading account pakistan view officelist.php

qual'è il miglior sito di opzioni binarie In the view file you write cgridview code.

http://vagnvagensbygg.se/firmenit/3296 <?php $this->widget('zii.widgets.grid.CGridView', array( 'dataProvider'=>$dataProvider, 'id' => 'user-grid', 'columns'=>array( array( 'class' => 'CButtonColumn', 'name', 'email', array( 'name'=>'Office Managers', 'type'=>'raw', //for allowing raw html 'value'=>'customFunctions::getManagerListFromOfficeBranch($data->officeid)' //here is custom function that will get managers of office branch from office table ($data is used to get any value from current row of branch) ), ), ), )); ?>

Orlistat 120 mg online cheap customfunctions.php

dating phone application You can create a folder in protected folder with name includes and keep this file in includes folder
http://poloclubmiddennederland.nl/lidmaatschap Path Exm: /protected/includes/customFunctions.php

enter http://agencijapragma.com/?kiopoa=miglior-broker-opzioni-digitali-2016&3b5=d0 Include the file in config/main.php
Exm: require_once realpath(__DIR__ . ‘/../includes/customFunctions.php’);

see <?php class customFunctions{ public static function getManagerListFromOfficeBranch($officeid) { $managerDetails=Office::model()->findAllByAttributes(array('officeid'=> $officeid)); //Office is the model object of Office Table $managerList=''; foreach ($managerDetails as $key => $value) { $managerList=$managerList.$value->manager->first_name." ".$value->manager->last_name."<br/>"; } echo $managerList; //all managers echo line by line in the column } ?>