Skip to content

Eseperio/yii2-exportable-gridview

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

yii2 Exportable Gridview

Gridview with full data export

This works as normal gridview, but adds a button to export the data loaded into it. It exports all records found on the active record query. Works with the same data as the gridview does. Uses phpspreadsheet to generate export file.

How does it work

Following the same behavior that pjax widget, this widget act as a normal gridview until a request is made with the url query parameters export-grid and export-container. The latter should contain the id of gridview without the hashtag. When both parameters are received, response is cleared and then spreadsheet generation begins. This allow to generate a file with absolutely all records found on the gridview.

This project is currently under development. Any contribution is welcome.

Installation

composer require eseperio/yii2-exportable-gridview @dev

Usage

This widget extends from yii2-gridview but add functionality to export all the rows queried by the DataProvider.

use eseperio\gridview\ExportableGridview as GridView;
<?= GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'columns' => [
            ['class' => 'yii\grid\SerialColumn'],
            'id',
            'title',
            'description',
            'author',
        ],
    ]);
    ?>

Additional configuration

Name Type default Description
layout string {summary} {items} {export} {pager} In addition to default layout this gridview has {export} section. This is the place for export button.
fileName string exported.xls Name to use on the generated filename. If writerType value is not set then the writer will be guessed from the extension.
writerType string null The writer to be used when generating file. See Spreadsheet writer. Accepts Xls, Xlsx, Ods, Csv, Html, Tcpdf, Dompdf, Mpdf
exportable boolean true Whether to enable export for this gridview
exportLinkOptions array ['class'=> 'btn btn-default', 'target'=>'_blank'] Options for the export link. It also accepts label and encode
exportColumns array empty Property to define a different column combination for export only. If empty default columns of gridview will be used

Constants available

All writers identifiers are available through constants.

Constant name Value
WRITER_XLS Xls
WRITER_XLSX Xlsx
WRITER_ODS Ods
WRITER_CSV Csv
WRITER_HTML Html
WRITER_TCPDF Tcpdf
WRITER_DOMPDF Dompdf
WRITER_MPDF Mpdf

Notes

All html tags are removed when exporting.

Todo

  • Add option to exclude certain columns like ActionColumn.
  • Add batch data processing.
  • Add custom PDF export method.
  • Add tests