2017-02-11 11:49:51 2687次浏览 0条回答 0 悬赏 20 金钱

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();
    ?>
    没有找到数据。
您需要登录后才可以回答。登录 | 立即注册
搞搞的传奇
见习主管

搞搞的传奇

注册时间:2015-02-24
最后登录:2020-06-04
在线时长:24小时46分
  • 粉丝8
  • 金钱5
  • 威望10
  • 积分345

热门问题