kartik-v的DynaGrid的隐藏列数据导出的问题 [ 2.0 版本 ]
DynaGrid 中前端界面上可设置显示隐藏列,我的显示隐藏列功能正常,但是导出数据则未能导出新设置的显示的列
这个是我的view代码
<?php
$columns = [
['class' => 'kartik\grid\SerialColumn'],
// ['attribute' => 'id', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'poster', 'vAlign' => 'middle'],
['attribute' => 'award', 'vAlign' => 'middle'],
['attribute' => 'list_level',
'format' => 'raw',
'filter' =>['县级'=>'县级','市级'=>'市级','省级'=>'省级','国家级'=>'国家级'],
'filterInputOptions' => ['class' => 'form-control input-sm'],],
['attribute' => 'list_grade',
'format' => 'raw',
'filter' =>['1'=>'1等奖','2'=>'2等奖','3'=>'3等奖'],
],
['attribute' => 'list_classify',
'format' => 'raw',
'filter' =>\common\myclass\ArrayHelper::mymap4(\backend\models\JiaoyanAssess::findBySql('select distinct classify from jiaoyan_assess')->all(), 'classify'),],
['attribute' => 'poster_id', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'class', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'organization', 'vAlign' => 'middle'],
['attribute' => 'award_date', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'photo', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'partner_lead', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'partner_num', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'check_value', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'check_bonus', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'post_time', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'check_time', 'vAlign' => 'middle', 'visible' => false],
['attribute' => 'status',
'format' => 'raw',
'filter' =>['待审核'=>'待审核','发回修改'=>'发回修改','审核通过'=>'审核通过','审核未过'=>'审核未过'],
'filterInputOptions' => ['class' => 'form-control input-sm'],
'headerOptions' => ['class' => 'col-md-1'],
],
['attribute' => 'remark', 'vAlign' => 'middle', 'visible' => false],
['label'=>'操作',
'value'=> function($model){
$xxx='<span class="imageshow" data-img="'.$model->photo.'"><a class="btn btn-primary btn-xs" href="/jiaoyanaward/viewcheck?id='.$model->id.'">查 看</a></span>';
switch ($model->status) {
case '待审核':
return $xxx.' '.Html::button('审 核', ['data-id'=>$model->id,'class'=>'checkpass btn btn-success btn-xs']);
case '发回修改':
return $xxx.' '.Html::a('修 改', \yii::$app->urlManager->createUrl('jiaoyanaward/updatecheck?id='.$model->id),['class'=>'btn btn-info btn-xs']);
case '审核未过':
return $xxx.' '.Html::a('删 除', \yii::$app->urlManager->createUrl('jiaoyanaward/deletecheck?id='.$model->id),['data-confirm' => '确认删除?','class'=>'btn btn-danger btn-xs']);
default :
return $xxx;
}
},
'format'=>'raw'],
];
////////////////////////////////导出代码
$fullExportMenu = ExportMenu::widget([
'dataProvider' => $dataProvider,
'columns' => $columns,
'target' => ExportMenu::TARGET_BLANK,
'fontAwesome' => true,
'pjaxContainerId' => 'kv-pjax-container',
'exportConfig' => [
ExportMenu::FORMAT_TEXT => false,
ExportMenu::FORMAT_HTML => false,
ExportMenu::FORMAT_CSV => false,
ExportMenu::FORMAT_EXCEL_X => false,
ExportMenu::FORMAT_PDF => false
],
'dropdownOptions' => [
'label' => '导出所有数据',
'class' => 'btn btn-default',
'itemsBefore' => [
'<li class="dropdown-header">导出所有数据</li>',
],
],
]);
Pjax::begin();
///////////////////////////////DynaGrid代码
echo DynaGrid::widget([
'columns' => $columns,
'storage' => DynaGrid::TYPE_SESSION,
'theme' => 'panel-primary',
'showPersonalize'=>true,
'allowThemeSetting'=>false,
'allowFilterSetting'=>false,
'allowSortSetting'=>false,
'gridOptions'=>[
'exportConfig' => [
GridView::EXCEL => [],
],
'dataProvider'=>$dataProvider,
'filterModel'=>$searchModel,
'showPageSummary'=>true,
'pjax' => false,
'pjaxSettings' => ['options' => ['id' => 'kv-pjax-container']],
'panel'=>['heading'=>'<h3 class="panel-title">获奖情况列表</h3>',
'before'=>Html::a('<i class="glyphicon glyphicon-plus"></i> 获奖申报', ['postcheck'], ['class' => 'btn btn-success']),
],
'export' => [
'label' => '导出当前页',
'fontAwesome' => true,
],
'toolbar' => [
'{export}',
$fullExportMenu,
['content'=>'{dynagrid}'],
]
],
'options' => ['id' => 'dynagrid-1'] // a unique identifier is important
]);
Pjax::end();
?>
共 0 个回答
没有找到数据。
搞搞的传奇
注册时间:2015-02-24
最后登录:2020-06-04
在线时长:24小时46分
最后登录:2020-06-04
在线时长:24小时46分
- 粉丝8
- 金钱5
- 威望10
- 积分345