Data exported from Dwz + thinkphp integration to Excel

This problem has plagued me for a long time, and I finally wrote JQUERY to confuse it. I hope it will help people who encounter the same problem. well, the source code is as follows:

This problem has plagued me for a long time, and I finally wrote JQUERY to confuse it. I hope it will help people who encounter the same problem. well, the source code is as follows:

Jquery code:

1. $ (Function (){
2.  
3. // The _ getIds method is used to obtain the ID of the selected data to be exported. two parameters are set: selectedIds -- input name of the selected id, targetType --> fragment mode. the default value is navTab, if it is a self-modified dialog
4. Function _ getIds (selectedIds, targetType ){
5. Var ids = "";
6. Var $ box = targetType = "dialog "? $. Pdialog. getCurrent (): navTab. getCurrentPanel ();
7. $ Box. find ("input: checked"). filter ("[name = '" + selectedIds + "']"). each (function (I ){
8.  
9. Var val = $ (this). val ();
10. Ids + = I = 0? Val: "," + val ;});
11. Return ids;
12. }
13. // Export the excel button class = iconn, triggered when you click
14. $ (". Iconn"). click (
15. Function (){
16. // Because this method is directly used to export data to excel, I directly wrote the required parameter variables.
17. Var targetType = "navTab ";
18. Var selectedIds = "ids ";
19. Var postType = "string"; // if selected in batches, it is obtained in text format.
20. Var ids = _ getIds (selectedIds, targetType );
21. If (! Ids ){
22. AlertMsg. error ($ (". iconn"). attr ("warn "));
23. Return false;
24. // Alert ("Select the data to export! ");
25. } Else {
26. // Send the obtained ids to the background for processing.
27. Window. open ("_ URL _/memberExport/ids/" + ids );
28. }
29.  
30. });
31. });

PHP code:

1. // Export member information to excel
2. Public function memberExport (){
3. $ Id = $ _ REQUEST ['id']; // obtain the ID of the selected data
4. // Echo $ id;
5.  
6. // I didn't use phpexcel to export data to excel here. it was very easy to write by myself. I believe everyone understands what it means. just modify it as needed.
7. $ Filename = date ('Y-m-D ');
8. Header ("Pragma: public ");
9. Header ("Expires: 0 ");
10. Header ("Cache-Control: must-revalidate, post-check = 0, pre-check = 0 ");
11. Header ("Content-Type: application/force-download ");
12. Header ("Content-Type: application/vnd. ms-execl; charset = gb2312 ");
13. Header ("Content-Type: application/octet-stream ");
14. Header ("Content-Type: application/download ");
15. Header ('content-Disposition: attachment; filename = "'.w.filename.'.xls "');
16. Header ("Content-Transfer-Encoding: binary ");
17. If (! $ Id ){
18. $ This-> error ('invalid operation! ');
19. } Else {
20.  
21. $ Map ['id'] = array ('in', $ id );
22. $ Title = "username \ t name \ t Department \ t title \ t ID card \ t title \ t degree \ t graduation time \ t recruitment time ";
23. $ Title = iconv ('utf-8', 'gbk', $ title );
24. Echo $ title;
25. Set_time_limit (0 );
26. $ Offset = 0;
27. $ Length = 100;
28. $ Member = M ('member ');
29. $ List = $ Member-> where ($ map)-> order ('Id desc')-> select ();
30. If (! $ List ){
31. $ This-> error ('Operation error! ');
32. } Else {
33. Foreach ($ list as $ key => $ row ){
34. Echo "\ n ";
35. Echo iconv ('utf-8', 'gbk', $ row ['username']). "\ t ";
36. Echo iconv ('utf-8', 'gbk', $ row ['name']). "\ t ";
37. Echo iconv ('utf-8', 'gbk', $ row ['Department ']). "\ t ";
38. Echo iconv ('utf-8', 'gbk', $ row ['zhiwu']). "\ t ";
39. Echo iconv ('utf-8', 'gbk', $ row ['sfz']). "\ t ";
40. Echo iconv ('utf-8', 'gbk', $ row ['zhicheng']). "\ t ";
41. Echo iconv ('utf-8', 'gbk', $ row ['xulil']). "\ t ";
42. Echo iconv ('utf-8', 'gbk', $ row ['bytime']). "\ t ";
43. Echo iconv ('utf-8', 'gbk', $ row ['lytime']). "\ t ";
44.  
45. }
46. $ Offset + = $ length;
47. }
48. }
49. }