Column Selector - Case 1

Thankful to Krajee! BUY A COFFEEor to get more out of us.

Customize your column selector with a custom label. You can choose to hide certain columns from the column selector by setting hiddenColumns (e.g. let's hide the SerialColumn and the ActionColumn). Note that hiddenColumns only control the display of columns in the column selector. Hidden columns will be displayed in the export if they are a part of selectedColumns. We can also disable certain columns in the column selector by setting disabledColumns (e.g. let's disable ID and Author Name). Similar to hiddenColumns, disabled columns will be displayed in the export if they are a part of selectedColumns.

Tip

Not seeing the updated content on this page! Hard refresh your browser to clean cache for this page (e.g. SHIFT-F5 on Windows Chrome)

Showing 16-20 of 20 items.

#	ID	Name	Author	Color	Publish Date	Status	Buy Amount ($)	Sell Amount ($)
16	1016	Gone with the Wind	Margaret Mitchell	brown	2011-08-21	Active	123.00	185.50
17	1017	Jane Eyre	Charlotte Brontë	black	2006-10-17	Active	140.00	195.50
18	1018	On the Road	Jack Kerouac	orange	2000-10-01	Inactive	150.00	184.99
19	1019	Pride and Prejudice	Jane Austen	green	2005-07-18	Active	126.00	195.50
20	1020	Lord of the Flies	William Golding	red	2005-07-18	Active	169.00	188.50

use kartik\export\ExportMenu;
use kartik\grid\GridView;
use kartik\helpers\Html;
echo ExportMenu::widget([
    'dataProvider' => $dataProvider,
    'columns' => $gridColumns,
    'columnSelectorOptions'=>[
        'label' => 'Cols...',
    ],
    'hiddenColumns'=>[0, 9], // SerialColumn & ActionColumn
    'disabledColumns'=>[1, 2], // ID & Name
    'dropdownOptions' => [
        'label' => 'Export All',
        'class' => 'btn btn-outline-secondary btn-default'
    ]
]) . "<hr>\n".
GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => $gridColumns,
]);

$gridColumns = [
    ['class' => 'kartik\grid\SerialColumn'],
    'id',
    'name',
    [
        'attribute'=>'author_id',
        'label'=>'Author',
        'vAlign'=>'middle',
        'width'=>'190px',
        'value'=>function ($model, $key, $index, $widget) { 
            return Html::a($model->author->name, '#', []);
        },
        'format'=>'raw'
    ],
    'color',
    'publish_date',
    'status',
    ['attribute'=>'buy_amount','format'=>['decimal',2], 'hAlign'=>'right', 'width'=>'110px'],
    ['attribute'=>'sell_amount','format'=>['decimal',2], 'hAlign'=>'right', 'width'=>'110px'],
    ['class' => 'kartik\grid\ActionColumn', 'urlCreator'=>function(){return '#';}]
];

Note

You can now visit the Krajee Webtips Q & A forum for searching OR asking questions OR helping programmers with answers on these extensions and plugins. For asking a question click here. Select the appropriate question category (i.e. Krajee Plugins) and choose this current page plugin in the question related to field.

The comments and discussion section below are intended for generic discussions or feedback for this plugin. Developers may not be able to search or lookup here specific questions or tips on usage for this plugin.

visitors to Krajee Yii2 Demos since 22-May-2017

Column Selector - Case 1

Tip

Code Column Selector - Case 1

Code Grid Columns Configuration

Comments & Discussion

Note