cakephp – CSV export

Plugin CSV

https://packagist.org/packages/friendsofcake/cakephp-csvview

# composer require friendsofcake/cakephp-csvview

# bin/cake plugin load CsvView

https://andy-carter.com/blog/exporting-data-to-a-downloadable-csv-file-with-cakephp-3-and-csvview

Akcja kontrolera: Articles.articlesCsv

public function articlesCsv()
{
    $articles = $this->Articles->find() ;
    $_serialize = 'articles ';

    $_header       = ['Tytuł', 'Autor', 'Utworzony', 'Ocena'];
    $_delimiter    = ';'; 
    $_dataEncoding = 'UTF-8';
    $_csvEncoding  = 'Windows-1250';

    $this->viewBuilder()->setClassName('CsvView.Csv');
    $this->set(compact('articles ', '_serialize', '_header', '_delimiter', '_dataEncoding', '_csvEncoding');
}

Szablon akcji articles_csv.ctp

 

Dodaj komentarz