Excel.php 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203
  1. <?php
  2. namespace Factory\Admin;
  3. use Dever;
  4. class Excel extends Core
  5. {
  6. public function out($id, $user, $data)
  7. {
  8. if (!$data) {
  9. Dever::alert('无导出数据');
  10. }
  11. $info = Dever::db('factory/info')->find($id);
  12. if (!$info) {
  13. Dever::alert('操作失败');
  14. }
  15. $method = 'out_' . $info['out_template'];
  16. $file = '发货信息表';
  17. return $this->$method($file, $user, $data);
  18. }
  19. # 模板模板
  20. public function out_1($file, $user, $data)
  21. {
  22. $this->out_2($file, $user, $data, $file);
  23. }
  24. # 九阳模板
  25. public function out_2($file, $user, $data, $name = '')
  26. {
  27. $header = array();
  28. $header = array('序号', '申请发货时间', '申请人', '产品名称', '数量', '订单号', '收件人姓名', '收件人电话', '收件地址', '发货时间', '发件物流', '运单编号', '备注');
  29. $file = $name ? $name : '中食民安&九阳发货信息表';
  30. $body = array();
  31. $i = 1;
  32. foreach ($data as $k => $v) {
  33. if (!is_array($v)) {
  34. continue;
  35. }
  36. Dever::load('mshop/lib/buy')->setOutStatus($v['id'], 2);
  37. if ($v['ps_info']) {
  38. $ps_date = $v['ps_info']['cdate_day'];
  39. } else {
  40. $ps_date = '-';
  41. }
  42. $service_name = array();
  43. $service_num = array();
  44. if (isset($v['ps_info']['service']) && $v['ps_info']['service']) {
  45. foreach ($v['ps_info']['service'] as $k1 => $v1) {
  46. $service_name[] = $v1['service_name'];
  47. $service_num[] = $v1['order_num'];
  48. }
  49. }
  50. $service_name = implode(',', $service_name);
  51. $service_num = implode(',', $service_num);
  52. if ($v['parent_type'] == 2) {
  53. $parent_order = Dever::db('shop/sell_order')->find($v['parent_order_id']);
  54. if ($parent_order && $parent_order['uid']) {
  55. if ($parent_order['address_id']) {
  56. $address = Dever::load('passport/address')->getOne($parent_order['uid'], $parent_order['address_id']);
  57. $v['type_info']['name'] = $address['contact'];
  58. $v['type_info']['mobile'] = $address['mobile'];
  59. $v['type_info']['address'] = $address['address_info'];
  60. } else {
  61. $address = Dever::db('passport/user')->find($parent_order['uid']);
  62. $v['type_info']['name'] = $address['username'];
  63. $v['type_info']['mobile'] = $address['mobile'];
  64. $v['type_info']['address'] = '';
  65. }
  66. }
  67. }
  68. foreach ($v['goods'] as $k1 => $v1) {
  69. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  70. if (isset($goods_info['sku'])) {
  71. $sku = $goods_info['sku']['string'];
  72. } else {
  73. $sku = '';
  74. }
  75. $d = array
  76. (
  77. $i,
  78. $v['operdate_day'],
  79. $user['name'],
  80. $goods_info['name'] . ' ' . $sku,
  81. $v1['num'],
  82. $v['order_num'],
  83. $v['type_info']['name'],
  84. $v['type_info']['mobile'],
  85. $v['type_info']['address'],
  86. $ps_date,
  87. $service_name,
  88. $service_num,
  89. $v['info'],
  90. );
  91. $body[] = $d;
  92. $i++;
  93. }
  94. }
  95. Dever::excelExport($body, $header, $file);
  96. }
  97. # 纯米模板
  98. public function out_3($file, $user, $data)
  99. {
  100. $header = array();
  101. $header = array('序号', '申请人', '发货日期', '客户名称', '品名', '单位', '数量', '订单号', '收件人', '收件电话', '收件邮寄地址', '备注');
  102. $file = '纯米发货信息表';
  103. $body = array();
  104. $i = 1;
  105. foreach ($data as $k => $v) {
  106. if (!is_array($v)) {
  107. continue;
  108. }
  109. Dever::load('mshop/lib/buy')->setOutStatus($v['id'], 2);
  110. if ($v['ps_info']) {
  111. $ps_date = $v['ps_info']['cdate_day'];
  112. } else {
  113. $ps_date = '-';
  114. }
  115. if ($v['parent_type'] == 2) {
  116. $parent_order = Dever::db('shop/sell_order')->find($v['parent_order_id']);
  117. if ($parent_order && $parent_order['uid']) {
  118. if ($parent_order['address_id']) {
  119. $address = Dever::load('passport/address')->getOne($parent_order['uid'], $parent_order['address_id']);
  120. $v['type_info']['truename'] = $address['contact'];
  121. $v['type_info']['mobile'] = $address['mobile'];
  122. $v['type_info']['address'] = $address['address_info'];
  123. } else {
  124. $address = Dever::db('passport/user')->find($parent_order['uid']);
  125. $v['type_info']['truename'] = $address['username'];
  126. $v['type_info']['mobile'] = $address['mobile'];
  127. $v['type_info']['address'] = '';
  128. }
  129. }
  130. }
  131. foreach ($v['goods'] as $k1 => $v1) {
  132. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  133. if (isset($goods_info['sku'])) {
  134. $sku = $goods_info['sku']['string'];
  135. } else {
  136. $sku = '';
  137. }
  138. $d = array
  139. (
  140. $i,
  141. $user['name'],
  142. $ps_date,
  143. '中食民安(北京)',
  144. $goods_info['name'] . ' ' . $sku,
  145. $goods_info['unit'],
  146. $v1['num'],
  147. $v['order_num'],
  148. $v['type_info']['truename'],
  149. $v['type_info']['mobile'],
  150. $v['type_info']['address'],
  151. $v['info'],
  152. );
  153. $body[] = $d;
  154. $i++;
  155. }
  156. }
  157. Dever::excelExport($body, $header, $file);
  158. }
  159. }