How to display data of another table in grid view in yii2?

Question

In siteController I write query and pass array of dataProvider to index.php to display contain in table form. In index.php I want to display member name instead of memberID. For that I have write inner query and which is successfully run on command prompt successfully.Here I am not able to print first name instead of 'member id'

      public function actionIndex()
      {              
     $query = new \yii\db\Query;
      $query->select(['member.firstName',
                    'complaint.practiceCode','complaint.id',
                    'complaint.description','member.firstName'])
           ->from(['complaint'])
           ->innerJoin(['member','complaint.memberID = member.id'])
           ->groupBy(['complaint.id'])
           ->where(['complaint.deleted' => 'N']);
     $query->createCommand();

Here I have pass data by creating $dataProvider4 but I am not able to set value of firstName instead of memberID.

      $dataProvider4= new ActiveDataProvider([
            'query' => $query,
            'pagination' => false,
       ]);

        return $this->render('index', [
       'dataProvider4'=>$dataProvider4]);

<?= GridView::widget([
    'dataProvider'=>$dataProvider4,
    'summary'=>'Total'.'&nbsp<b>'.$complaintModel.'</b>&nbsp'.'Complaints',
    'columns' => [
       ['class' => 'yii\grid\SerialColumn'],
           'practiceCode',
            // 'memberID',
            'description',
            'status',
       ],
    ]); ?>

I have pass data through the dataProvider.

post full code of gridview

GAMITG
– GAMITG

2015-12-24 12:23:36 +00:00
Commented Dec 24, 2015 at 12:23 — GAMITG
– GAMITG, Commented Dec 24, 2015 at 12:23

Joe Miller · Accepted Answer · 2015-12-25 02:17:21Z

Since you are using a powerful framework, then you'd be better to let the framework do the complicated thing for you, rather than trying to write your own queries. It's what Yii was designed for. Try this in your action.

public function actionIndex()
    {              
    $query = Member::find()->
        ->select(['firstName', complaint.practiceCode', complaint.id', 'complaint.description'])
        ->groupBy(['complaint.id'])
        ->joinWith('complaints')//Tells Yii to use the complains relation that we define below. By default it is an inner join
        ->where(['complaint.deleted' => 'N']);

$dataProvider= new ActiveDataProvider([
    'query' => $query,
    'pagination' => false,
]);

return $this->render('index', [
    'dataProvider4'=>$dataProvider]);

In your model you will need to define a relation that you can use in the query;

public function getComplaints(){
    return $this->hasMany(Complaints::className(), 'memberID' => 'id');
}

This is useful as it will allow you to get complaints without having to write your own query to get them.

Yii will sort out all the column names for you, and write the query.

ScaisEdge · Accepted Answer · 2015-12-24 21:55:52Z

0

The query is not related to dataProvider and then is unuseful

If you want extend the query you should do this and assign to the query used in dataprovider not only perform a query. Anyway you can get the name of the member using an anonymous function retrieve the value;

<?= GridView::widget([
        'dataProvider' => $dataProvider4,
        //'summary'=>'Total'.'&nbsp<b>'.$complaintModel.'</b>&nbsp'.'Complaints',
        'columns' => [
           ['class' => 'yii\grid\SerialColumn'],
           'practiceCode',
          /* ['attribute' => '',
            'value' => function ($model) {
               $myMemberModel =  Member::find()->
                       where(['id'=> $model->memberID ])->one();
               if (isset($myMemberModel) {
                  return $myMemberModel->firtsName;
               } else {
                 return ' id : '.  $model->memberID . ' do not match ';
               }
             }],*/
              'firstName',
               'memberID',
              'description',
              'status',
              ],
         ]); 
?>

edited Dec 24, 2015 at 21:55

answered Dec 24, 2015 at 12:32

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

24 Comments

Priyanka Ahire Over a year ago

Actually I have pass data through the dataProvider. I am not added above this dataProvider function ......I added this grid view change but yet not working

ScaisEdge Over a year ago

I have update the answer using Member for retrieve the username .

Priyanka Ahire Over a year ago

Error:Trying to get property of non-object

Priyanka Ahire Over a year ago

At this line got error:return Member::find()->where(['id' =>$model->memberID])->one()->firtsName;

ScaisEdge Over a year ago

I have update the answer ... a mistake value instead of 'value'

|

Collectives™ on Stack Overflow

How to display data of another table in grid view in yii2?

2 Answers 2

Comments

24 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

24 Comments

Your Answer

Sign up or log in

Post as a guest

Related