How to export an amount of records to excel file

[nadar]

Q:
How to export a number of records to excel file that match some conditions
I don’t know how to do with luya 😃
Please help me!

A:
Use the ExportHelper::xlsx() method with your custom active query => Build any web thing! — LUYA 2 (which is now extracted to a standalone library, all helper classes yii-helpers/ExportHelper.php at master · luyadev/yii-helpers · GitHub 2)

Q:
This is on every crud, but not easy to learn!
And there are 2 states of a button. at first it "Generate Export" after clicked, It become "Download Export"

Is there any way to 1 click to download a file with a defined amount of rows. I think it about active window

The view with something like:

<?php $form = ActiveWindowFormWidget::begin([
    'callback' => 'export',
    'buttonValue' => 'Download',
    'options' => ['closeOnSuccess' => true]
]); ?>
<?= $form->field('amount', 'Amount of rows')->textInput(); ?>
<?php $form::end(); ?>

And the callback function like:

public function callbackExport($amount)
    {
        $ok = false;
        $total= count($this->model->contents);
     
        if($amount> $total)
        {
            return $this->sendError("There is $tong, can't export $amount");
        }

        $excelData = array();
        for ($i=0; $i < $amount; $i++ ) {

            $ac = $this->model->contents[$i];
            $excelData [] = $ac;
        }

        foreach ($excelData as $ac) {
           ....
            $ac->exported_at = time();
            ....
            $ok = $ac->save();
        }

        $content = ExportHelper::xlsx($excelData,['name','age','job']);
       
        if ($ok) {
           
            return CallbackButtonFileDownloadWidget::sendOutput($this, 'Data-Export.xlsx', $content);

        }

        return $this->sendError('Probem occured.');
    }

How to make it send the file Data-Export.xlsx to start download

A:
Using (https://luya.io/api/luya-admin-ngrest-aw-ActiveWindowFormWidget#$angularCallbackFunction-detail)

'angularCallbackFunction' => 'function($response) {

console.log($response)

};'

you can do anything with the response with javascript (angularjs). Check the response, there should be an url with the file to download, and then maybe something like this:

window.open($response.url)

Hey @mrtrinhvn i just did a quick test, in order to download the given file you can use the following angularCallbackFunction value:

 ActiveWindowFormWidget::begin([
    'callback' => 'export',
    'buttonValue' => 'Download',
    'angularCallbackFunction' => '[\'$response\', \'$scope\', function($response, $scope) {
        window.open($response.url); 
    }];'
]);