genrisol/yii2-csv-exporter

CSV export extension from Active Query (Yii2)

dev-master 2020-10-27 12:13 UTC

Requires

• yiisoft/yii2: ~2.0.0

MIT

• GENRI

• extension
• yii2
• export csv

README

yii2 simple csv exporter from ActiveQuery

CSV exporter

CSV extension from Active Query (Yii2)

Installation

The preferred way to install this extension is through composer.

Either run

php composer.phar require --prefer-dist genrisol/yii2-csv-exporter "*"

or add

"genrisol/yii2-csv-exporter": "*"

to the require section of your composer.json file.

Usage

Once the extension is installed, simply example to use it in your code by :

$query = \app\models\History::find()
    ->addSelect('history.*')
     ->with([
        'user',
        'customer',
        ...
     ]);

$columns = [
    ['label' => 'Date&Time', 'value' => 'ins_ts'],
    ['label' => 'Type', 'value' => 'object'],
    ['label' => 'Event', 'value' => 'eventText'],
    // relation used example
    ['label' => 'Event', 'nested' => 'user', 'value' => 'username'],
    // closure example
    ['label' => 'Message', 'value' => function ($model){
            return $model->getBodyByModel();
        }
    ],
];

(new \genrisol\export\CsvExport())->prepare($query, $columns)->run('histiory_'.time().'.csv');

or

set Yii config for components like this

'csv' => [
    'class' => '\genrisol\export\CsvExport',
]

and then can use it this way
 Yii::$app->cvs->prepare($query, $columns)->run('histiory_'.time().'.csv');