訂單商品詳情導出EXCEL

鐢ㄤ簬瀵煎嚭 璁㈠崟 璇︽儏锛屾墦鍗拌璁㈠崟鐨?鍟嗗搧 鍒楄〃鍜屽晢鍝?灞炴€э紝浠ヤ笅 浠ｇ爜鎻愪緵澶ч儴鍒嗘鏋訛紝濡傚EXCEL鏈夌壒娈婅姹傦紝璇瘋嚜琛屼慨鏀瑰畾鍒禘XCEL鏍煎紡

1, 淇敼 admin\templates\order_info.htm

鍦ㄨ繖涓綅缃笅澧炲姞涓€琛岋細

1. <input type="button" 慰nclick="window.open('order.php?act=info&order_id={$order.order_id}&print=1')" class="button" value="{$lang.print_order}" />
2. <input type="button" 慰nclick="window.open('excel_export.php?order_id={$order.order_id}')" class="button" value="瀵煎嚭EXCEL" />

澶嶅埗浠ｇ爜

2.鏂闆緩 鏂囦歡鏀句簬 admin 鐩綍涓嬶紝鏂囦歡鍚嶄負excel_export.php, 鍐呭濡備笅锛?

1. <?php
2. define('IN_ECS', true);
3. include ('includes/init.php');
4. $filename='excel_export';
5. header("Content-type: application/vnd.ms-excel; charset=gbk");
6. header("Content-Disposition: attachment; filename=$filename.xls");
7. $order_id = intval($_REQUEST['order_id']);
8. $sql="select gt.goods_thumb, g.goods_name, g.goods_sn, g.goods_price, g.goods_number, (g.goods_price*g.goods_number) as num_price, g.goods_attr from ecs_goods gt, ecs_order_info i, ecs_order_goods g where g.order_id=i.order_id and gt.goods_id = g.goods_id and i.order_id = '$order_id'";
9. $res=$db->getAll($sql);
10. $data1.='鍟嗗搧鍥劇墖'."\t";
11. $data1.='鍟嗗搧鍚嶇О'."\t";
12. $data1.='鍟嗗搧缂栧彿'."\t";
13. $data1.='鍟嗗搧鍗曚環'."\t";
14. $data1.='鍟嗗搧鏁伴噺'."\t";
15. $data1.='灏忚浠鋒牸'."\t";
16. $data1.='灞炴€у娉?."\t\n";
17. while (!empty($res))
18. {
19. 聽 聽聽聽foreach ($res as $key=>$var)
20. 聽 聽聽聽{
21. 聽 聽聽 聽聽 聽聽聽$a=$var['goods_sn'];
22. 聽 聽聽 聽聽 聽聽聽foreach ($res as $keys=>$vars)
23. 聽 聽聽 聽聽 聽聽聽{
24. 聽 聽聽 聽聽 聽聽 聽聽 聽if($a==$vars['goods_sn'])
25. 聽 聽聽 聽聽 聽聽 聽聽 聽{
26. 聽 聽聽 聽聽 聽聽 聽聽 聽聽 聽聽聽$res1[$key]['goods_thumb']=$vars['goods_thumb'];
27. 聽 聽聽 聽聽 聽聽 聽聽 聽聽 聽聽聽$res1[$key]['goods']=$vars['goods_name'];
28. 聽 聽聽 聽聽 聽聽 聽聽 聽聽 聽聽聽$res1[$key]['goods_sn']=$vars['goods_sn'];
29. 聽 聽聽 聽聽 聽聽 聽聽 聽聽 聽聽聽$res1[$key]['goods_price']=$vars['goods_price'];
30. 聽 聽聽 聽聽 聽聽 聽聽 聽聽 聽聽聽$res1[$key]['goods_number']=$vars['goods_number'];
31. 聽 聽聽 聽聽 聽聽 聽聽 聽聽 聽聽聽$res1[$key]['num_price']=$vars['num_price'];
32. 聽 聽聽 聽聽 聽聽 聽聽 聽聽 聽聽聽$res1[$key]['goods_attr']=$vars['goods_attr'];
33. 聽 聽聽 聽聽 聽聽 聽聽 聽聽 聽聽聽unset ($res[$keys]);
34. 聽 聽聽 聽聽 聽聽 聽聽 聽}
35. 聽 聽聽 聽聽 聽聽聽}
36. 聽 聽聽聽}
37. }
38. foreach ($res1 as $key =>$var)
39. {
40. $data.=$var['goods_thumb']."\t";
41. $data.=$var['goods']."\t";
42. $data.=$var['goods_sn']."\t";
43. $data.=$var['goods_price']."\t";
44. $data.=$var['goods_number']."\t";
45. $data.=$var['num_price']."\t";
46. $data.=$var['goods_attr']."\t";
47. $data.="\t\n";
48. }
49. if (EC_CHARSET != 'gbk')
50. {
51. 聽 聽 echo $data1.ecs_iconv(EC_CHARSET, 'gbk', $data) . "\t";
52. }
53. else
54. {
55. 聽 聽 echo $data1.$data. "\t";
56. }
57. ?>

澶嶅埗浠ｇ爜