Excel.php 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. <?php
  2. namespace Active\Lib;
  3. use Dever;
  4. Class Excel {
  5. #活动订单的导出
  6. public function out_active_order($data){
  7. $header = array('订单单号', '姓名', '手机号', '活动名称', '购买数量', '金额', '支付状态', '支付类型','购买时间');
  8. $body = array();
  9. foreach ($data as $k => $v){
  10. $member = Dever::db('agent/member')->find($v['mid']);
  11. $active = Dever::db('active/info')->find($v['active_id']);
  12. $member_name = '';
  13. $member_mobile = '';
  14. if($member && $member['name'] && $member['mobile']){
  15. $member_name = $member['name'];
  16. $member_mobile = $member['mobile'];
  17. }
  18. $active_name = '';
  19. if($active && $active['name']){
  20. $active_name = $active['name'];
  21. }
  22. $config_status = Dever::db('active/order')->config['config_status'];
  23. $status = Dever::status($config_status,$v['status']);
  24. $config_pay_type = Dever::db('active/order')->config['config_pay_type'];
  25. $pay_type = Dever::status($config_pay_type,$v['pay_type']);
  26. $cdate = '';
  27. if($v['cdate']){
  28. $cdate = date('Y-m-d H:i',$v['cdate']);
  29. }
  30. $d = array
  31. (
  32. $v['order_num'],
  33. $member_name,
  34. $member_mobile,
  35. $active_name,
  36. $v['num'],
  37. $v['price'],
  38. $status,
  39. $pay_type,
  40. $cdate,
  41. );
  42. $body[] = $d;
  43. }
  44. $file = Dever::input('excel_name');
  45. return Dever::excelExport($body, $header, $file);
  46. }
  47. }