Menus

Monday, 25 April 2016

Yii2 Grid View Operations


INDEX
Adding Classes to Rows in the GridView
Grid view action column change
Yii2 Gridview merge two columns



Gridview In Yiiframework 2.0


In yiiframework 2.0, The gridview widget is used to display the data like image, text, etc in a grid. It is having a lot features like sorting, pagination, filtering, styling etc.


Adding Classes to Rows in the GridView

Yii2 Gridview row by row css expression



Dynamically change GridView Row Background Color based on condition 


<?= GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
     
       //Check conditions and add to row color in gridview.
        'rowOptions' => function ($model){
          if($model->status == 0){
            return ['class' => 'danger'];
          }else{
            return ['class' => 'success'];
          }
        },
             
        'columns' => [          
            [
                'header' =>'Sl.No',
                'class' => 'yii\grid\SerialColumn',            
                'options' => ['width' => '50']
            ],          
            'eid',          
            [
                'attribute' => 'expence_date',
       'format' =>  ['date', 'php:d-m-Y'],
       'options' => ['width' => '150'],              
   ],
            'pay_to',
            'description',          
            [                              
                            'attribute'=>'head',
                            'content' => function($data){
                                        return Groupitems::getGroupitems($data->head);
                                        }
                            ],
            'amount',
            [        
                'class' => 'yii\grid\ActionColumn',
                'contentOptions' => ['style' => 'width:60px;'],
                'header'=>'Actions',
            ],
        ],
    ]); ?>



Output of above script







Grid view action column change


How to change view, update and delete url on action column in yii2


[
          'class' => 'yii\grid\ActionColumn',
          'header' => 'Actions',
          'headerOptions' => ['style' => 'color:#337ab7'],
          'template' => '{view}{update}{delete}',
          'buttons' => [
            'view' => function ($url, $model) {
                return Html::a('<span class="glyphicon glyphicon-eye-open"></span>', $url, [
                            'title' => Yii::t('app', 'lead-view'),
                ]);
            },

            'update' => function ($url, $model) {
                return Html::a('<span class="glyphicon glyphicon-pencil"></span>', $url, [
                            'title' => Yii::t('app', 'lead-update'),
                ]);
            },
            'delete' => function ($url, $model) {
                return Html::a('<span class="glyphicon glyphicon-trash"></span>', $url, [
                            'title' => Yii::t('app', 'lead-delete'),
                ]);
            }

          ],
          'urlCreator' => function ($action, $model, $key, $index) {
            if ($action === 'view') {
                $url ='index.php?r=client-login/lead-view&id='.$model->id;
                return $url;
            }

            if ($action === 'update') {
                $url ='index.php?r=client-login/lead-update&id='.$model->id;
                return $url;
            }
            if ($action === 'delete') {
                $url ='index.php?r=client-login/lead-delete&id='.$model->id;
                return $url;
            }

          }
          ],

Example 1

I want to gridview action column only show edit and view button and change to url.




Gridview code here


    <?= GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'columns' => [

        ....
        .....                                  

        [
          'class' => 'yii\grid\ActionColumn',
          'header' => 'Actions',
          'headerOptions' => ['style' => 'color:#337ab7'],
          'template' => '{view}{update}',
          'buttons' => [
            'view' => function ($url, $model) {
                return Html::a('<span class="glyphicon glyphicon-eye-open"></span>', $url, [
                            'title' => Yii::t('app', 'view-student'),
                ]);
            },

            'update' => function ($url, $model) {
                return Html::a('<span class="glyphicon glyphicon-pencil"></span>', $url, [
                            'title' => Yii::t('app', 'update-register number'),
                ]);
            },
            

          ],

          'urlCreator' => function ($action, $model, $key, $index) {
            if ($action === 'view') {                
                $url = 'index.php?r=master/students/view&ccid='.$model->ccid.'&admission_number='.$model->admission_number;
                return $url;
            }

            if ($action === 'update') {
                $url = 'index.php?r=master/students/addregisternochange&ccid='.$model->ccid.'&admission_number='.$model->admission_number;
                return $url;
            }
            
          }
          ],                            
                                        

    ], 
                                 
                                 
    ]); ?>




Example 1

This example gridview to show only view and edit without change url.


            [          
                'class' => 'yii\grid\ActionColumn',
                'contentOptions' => ['style' => 'width:50px;'],
                'header'=>'Actions',
                'template' => '{view} {update}',
            ], 



Yii2 Gridview merge two columns


//add columns in gridview

            [
                'label'=>'Rem/TotFee',
                'value' => function($model) { return $model->remitted_fee.'/'.$model->total_fee ;}
                 
            ],





Related Links

Yii2 gridview widget filter

YII2 Grid View Advanced Options

Yii2 grid with Editable column

Importing data from Excel Sheet




No comments:

Post a Comment