YII: Extended cgridview Add export CSV function

The Cgridview component provided by Yii does not have a built-in data export capability, but we can add that functionality by extending the component.

Here's how:

1, first derive a subclass, add an action member, in the view of the INIT function to determine whether the browse action or data export action, if the browser is the action to maintain the default behavior, otherwise output CSV file.

[PHP]View Plaincopy

1. public function  init ()   
2. {  
3.     if ( $this->action ==  ' export ')   
4.     {  
5.          parent::init ();   
6.           $this->gencsv ();   
7.     }   
8.     ELSE  
9.     {  
10.          Parent::init ();   
11.     }  
12. }  

2, processing the output of the CSV file:

[PHP]View Plaincopy

2. protected function gencsv ()
4. {
6. Header ("CONTENT-TYPE:TEXT/CSV;  charset=gb2312 ");
8. Header (' content-disposition:attachment; filename= '. $this->filename.  "');
12. //add Your content dump codes here
16. Flush ();
20. }

3. Then add a CSV export button to the Table control interface

Override its Renderitems () method as follows:

[PHP]View Plaincopy

2. Public function Renderitems ()
4. {
6. if (Yii::app ()->user->checkaccess (' Administrator '))
8. {
10. echo ' <div class= ' ToolBar > ';
12. echo ' <form action= '. Chtml::normalizeurl (Array ($this->action)).' &id= '. $this->id.  ' "method=" post ">";
14. foreach ($this->getcontroller ()->getactionparams () as $name + = $value)
16. {
18. echo ' <input type= ' hidden ' name= '. Addcslashes ($name, '"').'" value= " .  Addcslashes ($value, '"').'/> ';
20. }
22. echo ' <input type= "image" title= ". Yii::t (' ifcms ',' Export to CSV ').' src= '. Yii::app ()->theme->baseurl.  '/images/ico-csv.png ' alt= ' Submit ' > ';
24. echo ' </form> ';
26. echo ' </div> ';
28. }
30. Parent::renderitems ();
32. }

4, then in the click on the CSV action processing such as ACTIONCSV () render a single table view, the template is as follows

[PHP]View Plaincopy

2. <?php
4. $this->widget (' Application.extensions.grid.MyGridView ', array (
6. ' id ' = 'grid ',
8. ' action ' = 'export ',
10. ' dataprovider ' =$dp,
12. ' columns ' =Array (
14. Array (
16. ' header ' =>yii::t (' Statistics ',' Phone '),
18. ' name ' = 'phone ',
20. ),
22. Array (
24. ' Header ' =>yii::t (' Statistics ',' Count '),
26. ' name ' = 'count ',
28. ),
30. )
32. ));? >

Note that there is no output before the header setting statement in the 2nd step of the CSV output function above, including the following function:

[Plain]View Plaincopy

1. Print, Echo, printf, Trigger_error, vprintf, Ob_flush, Var_dump, ReadFile, PassThru

Otherwise the content will only be exported in the browser, but the file download will not occur.

by Iefreer

Reference:

http://stackoverflow.com/questions/8028957/headers-already-sent-by-php

YII: Extended cgridview Add export CSV function