Dhorder.php 48 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264
  1. <?php
  2. namespace Agent\Lib;
  3. use Dever;
  4. class Dhorder
  5. {
  6. # 获取配置
  7. public $config = array();
  8. # table
  9. public $table = 'agent/dh_order';
  10. public function __construct()
  11. {
  12. $this->config = Dever::db($this->table)->config;
  13. }
  14. # 设置订单的类型
  15. public function set($type, $view)
  16. {
  17. return $this;
  18. }
  19. # 获取公共的where
  20. public function where($id)
  21. {
  22. $where = array();
  23. $where['mid'] = $id;
  24. if (!$where) {
  25. Dever::alert('参数错误');
  26. }
  27. return $where;
  28. }
  29. # 获取订单列表
  30. public function getList($id)
  31. {
  32. $result = array();
  33. $where = $this->where($id);
  34. $mobile = Dever::input('mobile');
  35. if ($mobile) {
  36. $where['mobile'] = $mobile;
  37. }
  38. $status = Dever::input('status');
  39. if ($status) {
  40. $where['status'] = $status;
  41. }
  42. $result['order'] = Dever::db($this->table)->getAll($where);
  43. if ($result['order']) {
  44. foreach ($result['order'] as $k => $v) {
  45. $result['order'][$k] = $this->getInfo($v, false);
  46. }
  47. }
  48. return $result;
  49. }
  50. # 查看详情
  51. public function getView($id, $order_id, $show = true)
  52. {
  53. $where = $this->where($id);
  54. $where['id'] = $order_id;
  55. $result = Dever::db($this->table)->find($where);
  56. if (!$result) {
  57. Dever::alert('订单不存在');
  58. }
  59. if ($show) {
  60. $result = $this->getInfo($result);
  61. }
  62. return $result;
  63. }
  64. # 获取订单详细信息
  65. public function getInfo($info, $view = true)
  66. {
  67. $info['status_name'] = Dever::status($this->config['status'], $info['status']);
  68. $info['cdate'] = date('Y-m-d H:i', $info['cdate']);
  69. if ($info['operdate']) {
  70. $info['operdate'] = date('Y-m-d H:i', $info['operdate']);
  71. } else {
  72. $info['operdate'] = '';
  73. }
  74. if ($info['fdate']) {
  75. $info['fdate'] = date('Y-m-d H:i', $info['fdate']);
  76. } else {
  77. $info['fdate'] = '';
  78. }
  79. if ($view && $info['type'] == 1) {
  80. $info['ps_info'] = Dever::db('agent/dh_order_ps')->find(array('order_id' => $info['id']));
  81. if ($info['ps_info']) {
  82. $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
  83. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  84. if ($info['ps_info']['qu_date']) {
  85. $info['ps_info']['qu_date'] = date('Y-m-d H:i', $info['ps_info']['qu_date']);
  86. }
  87. if ($info['ps_info']['qs_date']) {
  88. $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
  89. }
  90. $status = Dever::db('agent/dh_order_ps')->config['status'];
  91. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  92. if ($info['ps_info']['service']) {
  93. foreach ($info['ps_info']['service'] as $k => $v) {
  94. if (isset($v['order_num']) && $v['order_num']) {
  95. $info['ps_info']['service'][$k]['service_name'] = '商家自送';
  96. if ($v['service_id'] > 0) {
  97. $service = Dever::db('shop/service')->find($v['service_id']);
  98. $info['ps_info']['service'][$k]['service_name'] = $service['name'];
  99. }
  100. } else {
  101. unset($info['ps_info']['service'][$k]);
  102. }
  103. }
  104. }
  105. }
  106. $goods_status = Dever::db('agent/dh_order_goods')->config['status'];
  107. if ($info['address_id']) {
  108. $info['address'] = Dever::db('agent/member_address')->find($info['address_id']);
  109. }
  110. $info['goods'] = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id']));
  111. foreach ($info['goods'] as $k => $v) {
  112. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  113. if (isset($goods_info['sku'])) {
  114. $sku = $goods_info['sku']['string'];
  115. } else {
  116. $sku = '';
  117. }
  118. $info['goods'][$k] += array
  119. (
  120. 'pic' => $goods_info['cover'],
  121. 'name' => $goods_info['name'],
  122. 'sku' => $sku,
  123. 'price' => $goods_info['price'],
  124. );
  125. }
  126. }
  127. if ($info['type'] == 2) {
  128. $info['card'] = Dever::db('card/info')->find($info['type_id']);
  129. }
  130. if ($info['type'] == 3) {
  131. $info['prize'] = Dever::db('setting/prize')->find($info['type_id']);
  132. }
  133. return $info;
  134. }
  135. # 取消订单
  136. public function cancel($id, $order_id)
  137. {
  138. $data = $this->getView($id, $order_id, false);
  139. if ($data['status'] == 1) {
  140. $state = Dever::db('agent/dh_order')->update(array('where_id' => $data['id'], 'status' => 7, 'operdate' => time()));
  141. if ($state) {
  142. $this->updateSell($data, 2);
  143. }
  144. return 'ok';
  145. } else {
  146. Dever::alert('当前订单状态不允许取消');
  147. }
  148. }
  149. # 得到商品和总价
  150. public function goods($mid)
  151. {
  152. $goods_id = Dever::input('goods_id');
  153. if (!$goods_id) {
  154. Dever::alert('请传入商品');
  155. }
  156. $goods_id = explode(',', $goods_id);
  157. $num = Dever::input('num');
  158. if (!$num) {
  159. Dever::alert('请传入商品数量');
  160. }
  161. $num = explode(',', $num);
  162. $data['price'] = 0;
  163. $data['num'] = 0;
  164. $data['name'] = array();
  165. $count = count($goods_id);
  166. $data['list'] = array();
  167. $i = 0;
  168. foreach ($goods_id as $k => $v) {
  169. $n = isset($num[$k]) ? $num[$k] : 1;
  170. $data['list'][$i] = Dever::db('agent/member_goods')->find(array('mid' => $mid, 'id' => $v));
  171. if ($data['list'][$i]) {
  172. $data['list'][$i]['num'] = $n;
  173. # 2是库存不足
  174. $data['list'][$i]['ku_state'] = 1;
  175. $total = $data['list'][$i]['total_num'] - $data['list'][$i]['sell_num'];
  176. if ($total >= $n) {
  177. $data['list'][$i]['buy_num'] = $n;
  178. } else {
  179. $data['list'][$i]['buy_num'] = $total;
  180. }
  181. if ($data['list'][$i]['buy_num'] <= 0) {
  182. $data['list'][$i]['ku_state'] = 2;
  183. $data['list'][$i]['buy_num'] = 0;
  184. }
  185. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($data['list'][$i]['type_id'], $data['list'][$i]['sku_id']);
  186. if (isset($goods_info['sku'])) {
  187. $sku = $goods_info['sku']['string'];
  188. } else {
  189. $sku = '';
  190. }
  191. $data['list'][$i] += array
  192. (
  193. 'pic' => $goods_info['cover'],
  194. 'name' => $goods_info['name'],
  195. 'sku' => $sku,
  196. 'price' => $goods_info['price'],
  197. );
  198. if ($data['list'][$i]['ku_state'] == 1) {
  199. $data['num'] += $data['list'][$i]['buy_num'];
  200. $data['price'] += $goods_info['price'] * $data['list'][$i]['buy_num'];
  201. $data['name'] = '兑换商品';
  202. }
  203. $i++;
  204. }
  205. }
  206. if ($data['num'] <= 0) {
  207. Dever::alert('没有商品可以兑换');
  208. }
  209. return $data;
  210. }
  211. # 确认兑换
  212. public function action($user, $name, $num, $price, $goods, $address_id, $dh_type, $type, $type_id, $info, $refer = '')
  213. {
  214. # 获取平台店
  215. $shop = Dever::db('shop/info')->find(array('type' => 10));
  216. if (!$shop) {
  217. Dever::alert('没有平台店');
  218. }
  219. $order_data['shop_id'] = $shop['id'];
  220. $order_data['mid'] = $user['id'];
  221. $order_data['mobile'] = $user['mobile'];
  222. $order_data['address_id'] = $address_id;
  223. $order_data['name'] = $name;
  224. $order_data['num'] = $num;
  225. $order_data['info'] = $info;
  226. $order_data['price'] = $price;
  227. $order_data['dh_type'] = $dh_type;
  228. $order_data['type'] = $type;
  229. if ($type_id) {
  230. $order_data['type_id'] = $type_id;
  231. }
  232. if ($dh_type == 2) {
  233. $order_data['status'] = 5;
  234. } else {
  235. $order_data['status'] = 2;
  236. }
  237. $order_data['refund_cash'] = 0;
  238. $order_data['audit'] = 2;
  239. $order_data['order_num'] = $this->getOrderId();
  240. $id = Dever::db('agent/dh_order')->insert($order_data);
  241. if (!$id) {
  242. Dever::alert('兑换失败');
  243. }
  244. if ($goods) {
  245. foreach($goods as $k => $v) {
  246. if ($v['ku_state'] == 1) {
  247. $data['mid'] = $user['id'];
  248. $data['order_id'] = $id;
  249. $data['shop_id'] = $shop['id'];
  250. $data['goods_id'] = $v['type_id'];
  251. $data['sku_id'] = $v['sku_id'];
  252. $data['price'] = $v['price'];
  253. $data['num'] = $v['buy_num'];
  254. Dever::db('agent/dh_order_goods')->insert($data);
  255. }
  256. }
  257. }
  258. # 减少库存 增加销量
  259. $order_data['id'] = $id;
  260. $this->updateSell($order_data);
  261. return array
  262. (
  263. 'order_num' => $order_data['order_num'],
  264. 'order_id' => $id,
  265. 'type' => 'dh',
  266. );
  267. }
  268. # 添加配送信息
  269. public function updatePs($order, $status = 1, $service_id = -1, $order_num = '')
  270. {
  271. $where['order_id'] = $order['id'];
  272. $where['clear'] = true;
  273. $data = Dever::db('agent/dh_order_ps')->find($where);
  274. $service = array();
  275. if ($service_id) {
  276. $service['service_id'] = $service_id;
  277. }
  278. if ($order_num) {
  279. $service['order_num'] = $order_num;
  280. }
  281. if (!$data) {
  282. $insert = $where;
  283. if ($service) {
  284. $insert['service'][] = $service;
  285. $insert['service'] = Dever::array_encode($insert['service']);
  286. }
  287. $insert['status'] = $status;
  288. if ($status == 2) {
  289. $insert['qu_date'] = time();
  290. }
  291. Dever::db('agent/dh_order_ps')->insert($insert);
  292. } else {
  293. $update = $where;
  294. $update['where_id'] = $data['id'];
  295. $update['status'] = $status;
  296. if ($status == 2) {
  297. $update['qu_date'] = time();
  298. }
  299. if ($status == 3) {
  300. $update['qs_date'] = time();
  301. }
  302. if ($service) {
  303. $data['service'] = Dever::array_decode($data['service']);
  304. $update['service'] = $data['service'];
  305. $update['service'][] = $service;
  306. $insert['service'] = Dever::array_encode($update['service']);
  307. }
  308. Dever::db('agent/dh_order_ps')->update($update);
  309. }
  310. }
  311. # 减少库存,增加销量
  312. public function updateSell($order, $type = 1)
  313. {
  314. $method = 'incSell';
  315. $name = '兑换商品';
  316. $name_3 = '兑换名额';
  317. if ($type == 2) {
  318. $method = 'decSell';
  319. $name = '退回商品';
  320. $name_3 = '退回名额';
  321. }
  322. if ($order['type'] == 1) {
  323. $where['order_id'] = $order['id'];
  324. //$where['status'] = 3;
  325. $data = Dever::db('agent/dh_order_goods')->select($where);
  326. if ($data) {
  327. foreach ($data as $k => $v) {
  328. $up['where_mid'] = $order['mid'];
  329. $up['where_type'] = $order['type'];
  330. $up['where_type_id'] = $v['goods_id'];
  331. $up['where_sku_id'] = $v['sku_id'];
  332. $info = Dever::db('agent/member_goods')->findData($up);
  333. $up['set_sell_num'] = $v['num'];
  334. Dever::db('agent/member_goods')->$method($up);
  335. if ($type == 2) {
  336. Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']+$up['set_sell_num'], $info['name'], $name);
  337. } else {
  338. Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']-$up['set_sell_num'], $info['name'], $name);
  339. }
  340. }
  341. }
  342. } elseif ($order['type'] == 3) {
  343. $up['where_mid'] = $order['mid'];
  344. $up['where_type'] = $order['type'];
  345. $up['where_type_id'] = $order['type_id'];
  346. $up['where_sku_id'] = -1;
  347. $info = Dever::db('agent/member_goods')->findData($up);
  348. $up['set_sell_num'] = $order['num'];
  349. Dever::db('agent/member_goods')->$method($up);
  350. if ($type == 2) {
  351. Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']+$up['set_sell_num'], $info['name'], $name_3);
  352. } else {
  353. Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']-$up['set_sell_num'], $info['name'], $name_3);
  354. }
  355. }
  356. }
  357. # 完成
  358. public function finish($info, $shop_id)
  359. {
  360. if ($info && $info['shop_id'] == $shop_id && $info['status'] <= 4) {
  361. $status = 5;
  362. $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => $status, 'fdate' => time()));
  363. $this->updatePs($info, 3);
  364. $w['parent_type'] = 3;
  365. $w['parent_order_id'] = $info['id'];
  366. $w['status'] = 4;
  367. $buy_order = Dever::db('shop/buy_order')->select($w);
  368. if ($buy_order) {
  369. foreach ($buy_order as $k => $v) {
  370. Dever::load('mshop/lib/buy')->set(1,1)->finish($shop_id, $v['id']);
  371. }
  372. }
  373. return 'ok';
  374. } else {
  375. Dever::alert('您没有权限核销');
  376. }
  377. }
  378. # 平台订单已收货
  379. public function yes_api()
  380. {
  381. $shop_id = Dever::input('shop_id');
  382. $order_id = Dever::input('order_id');
  383. $info = Dever::db('agent/dh_order')->find(array('id' => $order_id));
  384. if ($info && $info['type'] == 10) {
  385. $this->finish($info, $shop_id);
  386. } else {
  387. Dever::alert('您没有权限核销');
  388. }
  389. return 'reload';
  390. }
  391. # 生成订单号
  392. public function getOrderId()
  393. {
  394. $where['order_num'] = Dever::order('DH');
  395. $state = Dever::db('agent/dh_order')->one($where);
  396. if (!$state) {
  397. return $where['order_num'];
  398. } else {
  399. return $this->getOrderId();
  400. }
  401. }
  402. # 展示订单详情
  403. public function show()
  404. {
  405. $id = Dever::input('order_id');
  406. $config = Dever::db('agent/dh_order')->config;
  407. $info = Dever::db('agent/dh_order')->one($id);
  408. if ($info['type'] > 1) {
  409. return;
  410. }
  411. $tk_status = Dever::db('agent/dh_order_refund')->config['status'];
  412. $tk_process = Dever::db('agent/dh_order_refund')->config['process'];
  413. $status = $config['status'][$info['status']];
  414. $tk = Dever::db('agent/dh_order_refund')->find(array('order_id' => $info['id'], 'type' => 1));
  415. $shop = Dever::db('shop/info')->find($info['shop_id']);
  416. $user = Dever::db('agent/member')->find($info['mid']);
  417. $cdate = date('Y-m-d H:i', $info['cdate']);
  418. if ($info['operdate']) {
  419. $opertime = date('Y-m-d H:i', $info['operdate']);
  420. } else {
  421. $opertime = '';
  422. }
  423. if ($info['fdate']) {
  424. $fdate = date('Y-m-d H:i', $info['fdate']);
  425. } else {
  426. $fdate = '';
  427. }
  428. if (!$user) {
  429. $user['username'] = '无';
  430. }
  431. if (!isset($user['name'])) {
  432. $user['truename'] = $user['name'];
  433. }
  434. if ($tk && $tk['process'] == 1) {
  435. $status = '申请' . $tk_status[$tk['status']];
  436. $process = $tk_process[$tk['process']];
  437. $process = '';
  438. }
  439. $time = array();
  440. $time[] = array('下单时间', $cdate);
  441. if ($opertime) {
  442. if ($info['status'] == 2) {
  443. $time[] = array('通知时间', $opertime);
  444. }
  445. if ($info['status'] == 7) {
  446. $time[] = array('取消时间', $opertime);
  447. }
  448. }
  449. if ($fdate) {
  450. $time[] = array('完成时间', $fdate);
  451. }
  452. $time[] = array('审核备注', $info['audit_desc']);
  453. $result = array();
  454. $result[$info['order_num']] = array
  455. (
  456. 'type' => 'info',
  457. 'content' => array
  458. (
  459. array
  460. (
  461. array('订单状态', $status),
  462. array('代理商姓名', $user['name']),
  463. array('联系电话', $info['mobile']),
  464. ),
  465. $time,
  466. )
  467. );
  468. if ($info['address_id'] > 0) {
  469. $address = Dever::load('agent/address')->getOne($info['mid'], $info['address_id']);
  470. if ($address) {
  471. $result['收货地址'] = array
  472. (
  473. 'type' => 'info',
  474. 'content' => array
  475. (
  476. array
  477. (
  478. array('联系人', $address['contact']),
  479. array('联系电话', $address['mobile']),
  480. ),
  481. array
  482. (
  483. array('收货地址', $address['address_info']),
  484. array('门牌号', $address['house_number']),
  485. ),
  486. ),
  487. );
  488. }
  489. }
  490. $info['ps_info'] = Dever::db('agent/dh_order_ps')->find(array('order_id' => $info['id']));
  491. if ($info['ps_info']) {
  492. $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
  493. $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
  494. if ($info['ps_info']['qs_date']) {
  495. $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
  496. } else {
  497. $info['ps_info']['qs_date'] = '无';
  498. }
  499. $status = Dever::db('agent/dh_order_ps')->config['status'];
  500. $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
  501. $service = array();
  502. if ($info['ps_info']['service']) {
  503. foreach ($info['ps_info']['service'] as $k => $v) {
  504. if (isset($v['order_num']) && $v['order_num']) {
  505. $info['ps_info']['service'][$k]['service_name'] = '商家自送';
  506. if ($v['service_id'] > 0) {
  507. $service_info = Dever::db('shop/service')->find($v['service_id']);
  508. $info['ps_info']['service'][$k]['service_name'] = $service_info['name'];
  509. }
  510. $service[] = array
  511. (
  512. array('名称', $info['ps_info']['service'][$k]['service_name']),
  513. array('单号', isset($v['order_num']) ? $v['order_num'] : ''),
  514. );
  515. }
  516. }
  517. }
  518. $result['物流信息'] = array
  519. (
  520. 'type' => 'info',
  521. 'content' => array
  522. (
  523. array
  524. (
  525. array('发货时间', $info['ps_info']['cdate']),
  526. array('收货时间', $info['ps_info']['qs_date']),
  527. array('查单', '<a href="https://www.kuaidi100.com/?from=openv" target="_blank">点此手动查单</a>'),
  528. ),
  529. ),
  530. );
  531. $result['物流信息']['content'] = array_merge($result['物流信息']['content'], $service);
  532. }
  533. if (!$info['refund_cash']) {
  534. $info['refund_cash'] = 0;
  535. }
  536. if ($info['refund_cash'] > 0 && $tk) {
  537. $process = $tk_process[$tk['process']];
  538. $tk['cdate'] = date('Y-m-d H:i', $tk['cdate']);
  539. $result['退款信息'] = array
  540. (
  541. 'type' => 'info',
  542. 'content' => array
  543. (
  544. array
  545. (
  546. array('退款金额', $info['refund_cash']),
  547. array('数量', $info['num']),
  548. array('退款进度', $process),
  549. ),
  550. array
  551. (
  552. array('申请时间', $tk['cdate']),
  553. array('退款原因', $tk['desc']),
  554. ),
  555. ),
  556. );
  557. }
  558. $body = $refund_body = array();
  559. $body_total = array();
  560. $body_total['price'] = 0;
  561. $body_total['num'] = 0;
  562. $refund_body_total = array();
  563. $refund_body_total['price'] = 0;
  564. $refund_body_total['num'] = 0;
  565. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id']));
  566. $goods_status = Dever::db('agent/dh_order_goods')->config['status'];
  567. foreach ($goods as $k => $v) {
  568. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  569. $status = Dever::status($goods_status, $v['status']);
  570. $tk = Dever::db('agent/dh_order_refund')->find(array('order_id' => $info['id'], 'order_goods_id' => $v['id'], 'type' => 2));
  571. if ($tk && $tk['process'] == 1) {
  572. $status = '申请' . $tk_status[$tk['status']];
  573. //$status .= '&nbsp;&nbsp;[' . $tk_process[$tk['process']] . ']';
  574. }
  575. if (isset($goods_info['sku'])) {
  576. $sku = $goods_info['sku']['string'];
  577. } else {
  578. $sku = '无';
  579. }
  580. if ($info['status'] > 1 && $info['status'] < 7) {
  581. $tui = Dever::url('buy_order_tui?shop_id='.$v['shop_id'].'&order_goods_id=' . $v['id'] . '&order_id=' . $info['id'] . '&cash=' . $v['price'], 'shop');
  582. $status = '<a href="javascript:;" onclick="fastEdit($(this), \''.$tui.'\', \'退款\', \'\', 1)" class="layui-btn">退款</a>';
  583. $status = '';
  584. }
  585. $d = array
  586. (
  587. 'pic' => $goods_info['cover'],
  588. 'name' => $goods_info['name'],
  589. 'sku' => $sku,
  590. 'price' => $v['price'],
  591. 'num' => $v['num'],
  592. 'status' => $status,
  593. );
  594. if ($tk && $v['status'] == 3) {
  595. $d['status'] = $tk_status[$tk['status']];
  596. $refund_body[] = $d;
  597. $price = $v['price']*$v['num'];
  598. $refund_body_total['price'] += $price;
  599. $refund_body_total['num'] += $v['num'];
  600. } else {
  601. $body[] = $d;
  602. $price = $v['price']*$v['num'];
  603. $body_total['price'] += $price;
  604. $body_total['num'] += $v['num'];
  605. }
  606. }
  607. if ($body) {
  608. if ($refund_body_total['price']) {
  609. $body_total['set_price'] = $body_total['price'] - $refund_body_total['price'];
  610. }
  611. if ($refund_body_total['num']) {
  612. $body_total['set_num'] = $body_total['num'] - $refund_body_total['num'];
  613. }
  614. $result['商品清单'] = array
  615. (
  616. 'type' => 'list',
  617. 'content' => $body,
  618. 'total' => $body_total,
  619. );
  620. }
  621. if ($refund_body) {
  622. $result['退款商品'] = array
  623. (
  624. 'type' => 'list',
  625. 'content' => $refund_body,
  626. 'total' => $refund_body_total,
  627. );
  628. }
  629. # 平台门店采购单
  630. $buy_order = Dever::db('shop/buy_order')->getDataToId(array('type' => 1, 'type_id' => $info['shop_id'], 'parent_type' => 3, 'parent_order_id' => $info['id']));
  631. $source_order_id = array();
  632. if ($buy_order) {
  633. $source_order_id = array_keys($buy_order);
  634. }
  635. # 平台门店结算单
  636. if ($source_order_id) {
  637. $cash_order = Dever::db('cash/order')->getDataByOrderId(array('source_order_id' => $source_order_id));
  638. $col = 'cash';
  639. }
  640. if (isset($cash_order) && $cash_order) {
  641. $head = array('序号', '结算单号', '数量', '金额', '结算类型', '入账状态', '审核状态', '结算时间', '审核备注', '管理');
  642. $body = array();
  643. $config = Dever::db('cash/order')->config;
  644. foreach ($cash_order as $k => $v) {
  645. $cdate = date('Y-m-d H:i', $v['cdate']);
  646. $fdate = $v['fdate'] ? date('Y-m-d H:i', $v['fdate']) : '';
  647. $operdate = $v['operdate'] ? date('Y-m-d H:i', $v['operdate']) : '';
  648. $cash = $v[$col];
  649. $url = Dever::url('project/database/list?project=shop&table=buy_order_goods&order_id='.$v['source_order_id'].'&page_type=1', 'manage');
  650. $v['source_order_num'] = '<a href="'.$url.'" style="color:blue">'.$v['source_order_num'].'</a>';
  651. $m = '';
  652. if ($v['audit'] == 1 && $v['audit_type'] == 2) {
  653. $url = Dever::url('project/database/update?project=cash&table=order&where_id='.$v['id'].'&col=audit,desc', 'manage');
  654. $m = '<a href="javascript:;" onclick="fastEdit($(this), \''.$url.'\', \'审核\', \'\', 1)" class="layui-btn">审核</a>';
  655. }
  656. $d = array
  657. (
  658. $k+1,
  659. $v['order_num'],
  660. $v['num'],
  661. $cash,
  662. $config['config_jstype'][$v['jstype']],
  663. $config['config_status'][$v['status']],
  664. $config['config_audit'][$v['audit']],
  665. $operdate,
  666. $v['desc'],
  667. $m,
  668. );
  669. $body[] = $d;
  670. }
  671. $result['对账清单'] = array
  672. (
  673. 'type' => 'table',
  674. 'content' => array
  675. (
  676. 'head' => $head,
  677. 'body' => $body,
  678. )
  679. );
  680. }
  681. $head_btn[] = array
  682. (
  683. 'type' => 'link',
  684. 'link' => Dever::url('project/database/list?project=agent&table=dh_order&menu=agent&search_option_state=1', 'manage'),
  685. 'name' => '返回上一页',
  686. );
  687. $audit = Dever::input('audit');
  688. if($audit==1){
  689. # 审核信息
  690. $this->show_audit($info, $result);
  691. }
  692. $head = array
  693. (
  694. 'name' => '基本信息',
  695. 'btn' => $head_btn,
  696. );
  697. $html = Dever::show($head, $result);
  698. return $html;
  699. }
  700. private function show_audit($info, &$result)
  701. {
  702. $info['type'] = 3;
  703. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id'], 'status' => 1));
  704. $shop = Dever::db('shop/info')->find($info['shop_id']);
  705. list($data, $source) = Dever::load('mshop/lib/buy')->assign($goods, $info, $shop, true);
  706. // print_R($data);die;
  707. if ($info) {
  708. $head = array('序号', '商品编号', '商品名称', '供货商', '订货总数量', '商品计量单位', '订货单总金额');
  709. $body = array();
  710. $i = 0;
  711. if ($data) {
  712. foreach ($data as $k => $v) {
  713. foreach ($v as $v1) {
  714. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  715. if (isset($goods_info['sku'])) {
  716. $sku = '[' . $goods_info['sku']['string'] . ']';
  717. } else {
  718. $sku = '';
  719. }
  720. $d = array
  721. (
  722. $i+1,
  723. $goods_info['code'],
  724. $goods_info['name'] . $sku,
  725. Dever::load('mshop/lib/buy')->getSelect($source, $v1['source_id'], $v1['order_goods_id']),
  726. $v1['num'],
  727. $goods_info['unit'],
  728. $v1['price'] * $v1['num'],
  729. );
  730. $body[] = $d;
  731. $i++;
  732. }
  733. }
  734. }
  735. if ($goods) {
  736. foreach ($goods as $k => $v) {
  737. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  738. if (isset($goods_info['sku'])) {
  739. $sku = '[' . $goods_info['sku']['string'] . ']';
  740. } else {
  741. $sku = '';
  742. }
  743. $d = array
  744. (
  745. $i+1,
  746. $goods_info['code'],
  747. $goods_info['name'] . $sku,
  748. Dever::load('mshop/lib/buy')->getSelect($source, false, $v['id']),
  749. $v['num'],
  750. $goods_info['unit'],
  751. $v['price'] * $v['num'],
  752. );
  753. $body[] = $d;
  754. $i++;
  755. }
  756. }
  757. $btn = array();
  758. $btn[] = array(
  759. 'type' => 'click',
  760. 'content' => 'setAudit()',
  761. 'name' => '全部调整<script>function setAudit(){layer.confirm(\'确定进行此项操作吗?\', function(){var audit = $(\'.audit_set\').val();$(\'.audit\').each(function(){$(this).val(audit);layui.form.render();layer.closeAll()})})}</script>'
  762. );
  763. $result['商品拆单'] = array
  764. (
  765. 'type' => 'table',
  766. 'head' => array('name' => '供货商:' . Dever::load('mshop/lib/buy')->getSelect($source, false, false), 'btn' => $btn),
  767. 'content' => array
  768. (
  769. 'head' => $head,
  770. 'body' => $body,
  771. )
  772. );
  773. $url = Dever::url('lib/dhorder.audit_set_commit?json=1&order_id=' . $info['id'], 'agent');
  774. // print_R($url);die;
  775. $result['审核结果'] = array
  776. (
  777. 'type' => 'html',
  778. 'content' => '<script>function saveAudit(){var goods = [];var audit = 1; var audit_text = $(".update_audit_text").val();$(".update_audit").each(function(){if ($(this).get(0).checked){audit = $(this).val()}});$(\'.audit\').each(function(){var v = $(this).val();var id = $(this).attr("id");goods.push(v + "_" + id);});layer.confirm(\'确定进行此项操作吗?\', function(){layui.form.render();var send = {};send.goods = goods.join(",");send.audit = audit;send.audit_text = audit_text;console.info(send);$.post("'.$url.'", send, function(t){t = JSON.parse(t);showYes(t)})})}</script><style>.layui-form-radio{padding-right: 0px;margin: 0px 0px 0 0;margin-left:40px}</style><div class="layui-form-item show_input"><div classs="layui-col-lg6"><div><label style="font-size:14px;font-weight:bold;" class="">审核状态</label><div style="display:inline" class="am-btn-group"><input update_type="checked" class="checkbox-checkall-0_update_audit update_audit update_value validate[required]" type="radio" name="update_audit[]" value="2" checked="" show_id="audit" autocomplete="off" id="form-validation-field-1"> 审核通过 &nbsp;&nbsp;<input update_type="checked" class="autoload checkbox-checkall-0_update_audit update_audit update_value validate[required]" type="radio" name="update_audit[]" value="3" autocomplete="off" id="form-validation-field-0"> 审核未通过 &nbsp;&nbsp;</div></div></div></div><div class="layui-form-item" style="display: block;"><div classs="layui-col-lg6"><div><label style="font-size:14px;font-weight:bold;" class="">审核备注</label></div><div><textarea style="height:100px;" update_type="value" class="update_value update_audit_text form-control layui-input validate[required]" name="update_desc"></textarea></div></div></div> <div style="text-align:left" class="layui-layer-btn layui-layer-btn-"><a class="layui-btn layui-btn-primary" onclick="saveAudit()">保存</a><a class="layui-layer-btn1" style="display:none">取消</a></div>',
  779. );
  780. }
  781. }
  782. # 采购订单审核 手动拆单
  783. public function audit_set_commit_api()
  784. {
  785. Dever::config('base')->hook = true;
  786. //{goods: "2_4_audit_615,2_4_audit_614,-1_-1_audit_617,-1_-1_audit_616,-1_-1_audit_613", audit: "1", audit_text: "1231"}
  787. $id = Dever::input('order_id');
  788. $goods = Dever::input('goods');
  789. $audit = Dever::input('audit');
  790. $audit_text = Dever::input('audit_text');
  791. $info = Dever::db('agent/dh_order')->one($id);
  792. if ($audit > 1 && $info && $info['status'] == 2) {
  793. $shop = Dever::db('shop/info')->find($info['shop_id']);
  794. if ($audit == 2) {
  795. Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text));
  796. # 成功
  797. if (strstr($info['order_num'], '_')) {
  798. $temp = explode('_', $info['order_num']);
  799. $info['order_num'] = $temp[0];
  800. $info['order_index'] = $temp[1];
  801. } else {
  802. $info['order_index'] = 0;
  803. }
  804. $goods = explode(',', $goods);
  805. $data = $other = array();
  806. foreach ($goods as $k => $v) {
  807. list($source_type, $source_id, $name, $goods_id) = explode('_', $v);
  808. $gv = Dever::db('agent/dh_order_goods')->find($goods_id);
  809. if ($source_id > 0) {
  810. $key = $source_type . '_' . $source_id;
  811. $data[$key][] = array
  812. (
  813. 'area' => $shop['area'],
  814. 'order_id' => $info['id'],
  815. 'order_type' => 3,
  816. 'order_num' => $info['order_num'],
  817. 'order_index' => $info['order_index'],
  818. 'type' => 1,
  819. 'type_id' => $shop['id'],
  820. 'source_type' => $source_type,
  821. 'source_id' => $source_id,
  822. 'order_goods_id' => $gv['id'],
  823. 'goods_id' => $gv['goods_id'],
  824. 'sku_id' => $gv['sku_id'],
  825. 'price' => $gv['price'],
  826. 'p_price' => $gv['price'],
  827. 'num' => $gv['num'],
  828. );
  829. } else {
  830. $other[] = $gv;
  831. }
  832. }
  833. $this->audit_action($data, $other, $info, $shop, 1);
  834. } else {
  835. Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text, 'status' => 7));
  836. Dever::load('agent/lib/dhorder')->updateSell($info, 2);
  837. if (Dever::project('sms')) {
  838. $member = Dever::db('agent/member')->find($info['mid']);
  839. Dever::load('sms/api')->send('daili_goods_no', $member['mobile'], array('name' => $member['name'], 'content' => $audit_text));
  840. }
  841. }
  842. }
  843. return Dever::url('project/database/list&project=agent&table=dh_order&menu=agent&search_option_state=1&search_option_shop_type=2&menu_id=218', 'manage');
  844. }
  845. # 采购订单审核 拆单
  846. public function audit_commit()
  847. {
  848. $order_id = Dever::input('order_id');
  849. $order = Dever::db('agent/dh_order')->find($order_id);
  850. if (!$order || ($order && $order['status'] != 2)) {
  851. Dever::alert('当前订单状态无法拆单');
  852. }
  853. // if ($order['shop_type'] != 2) {
  854. // Dever::alert('这不是平台店的订单');
  855. // }
  856. $order['type'] = 3;
  857. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));
  858. $shop = Dever::db('shop/info')->find($order['shop_id']);
  859. $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
  860. $this->audit_action($data, $goods, $order, $shop);
  861. return 'ok';
  862. }
  863. private function audit_action($data, $goods, $order, $shop, $state = 2)
  864. {
  865. $send = array();
  866. if (!$goods && $data) {
  867. # 开始生成订单
  868. $i = $order['order_index'];
  869. foreach ($data as $k => $v) {
  870. foreach ($v as $k1 => $v1) {
  871. $v1['order_num'] .= '_' . $i;
  872. $state = Dever::load('mshop/lib/buy')->createOrder($v1);
  873. $send[$state] = $v1;
  874. }
  875. $i++;
  876. }
  877. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
  878. } else {
  879. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
  880. if ($goods) {
  881. $string = array();
  882. foreach ($goods as $k => $v) {
  883. $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  884. if ($info['sku_name']) {
  885. $info['name'] .= '('.$info['sku_name'].')';
  886. }
  887. $string[] = $info['name'];
  888. }
  889. $string = implode('、', $string);
  890. if ($state == 1) {
  891. Dever::alert('商品:'.$string.'未选择供货商');
  892. } else {
  893. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  894. }
  895. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  896. } else {
  897. if ($state == 1) {
  898. Dever::alert('未选择供货商,该订单进入重新审核状态');
  899. } else {
  900. Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
  901. }
  902. }
  903. }
  904. if ($send) {
  905. foreach ($send as $k => $v) {
  906. Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
  907. $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
  908. Dever::load('cash/lib/order')->up($order_info, 1, 1);
  909. }
  910. }
  911. }
  912. # 第三方确认
  913. public function tixian()
  914. {
  915. $param = array();
  916. ksort($param);
  917. $string = array();
  918. foreach ($param as $k => $v) {
  919. if (strstr($v, '&') || strstr($v, '@')) {
  920. $v = urlencode($v);
  921. }
  922. $string[] = $k . '=' . $v;
  923. }
  924. }
  925. # 发货
  926. public function notice($info)
  927. {
  928. $config = Dever::db('agent/dh_order')->config;
  929. $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => 3, 'operdate' => time()));
  930. }
  931. # 采购订单审核 拆单
  932. /*
  933. public function audit_commit()
  934. {
  935. $order_id = Dever::input('order_id');
  936. $order = Dever::db('agent/dh_order')->find($order_id);
  937. if (!$order || ($order && $order['status'] != 2)) {
  938. Dever::alert('当前订单状态无法拆单');
  939. }
  940. $order['type'] = 3;
  941. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));
  942. $shop = Dever::db('shop/info')->find($order['shop_id']);
  943. $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
  944. $send = array();
  945. if (!$goods && $data) {
  946. # 开始生成订单
  947. $i = $order['order_index'];
  948. foreach ($data as $k => $v) {
  949. foreach ($v as $k1 => $v1) {
  950. $v1['order_num'] .= '_' . $i;
  951. $state = Dever::load('mshop/lib/buy')->createOrder($v1);
  952. $send[$state] = $v1;
  953. }
  954. $i++;
  955. }
  956. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
  957. } else {
  958. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
  959. if ($goods) {
  960. $string = array();
  961. foreach ($goods as $k => $v) {
  962. $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  963. if ($info['sku_name']) {
  964. $info['name'] .= '('.$info['sku_name'].')';
  965. }
  966. $string[] = $info['name'];
  967. }
  968. $string = implode('、', $string);
  969. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  970. } else {
  971. Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
  972. }
  973. }
  974. if ($send) {
  975. foreach ($send as $k => $v) {
  976. Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
  977. $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
  978. Dever::load('cash/lib/order')->up($order_info, 1, 1);
  979. }
  980. }
  981. return 'ok';
  982. }
  983. */
  984. #权益订单导出
  985. public function out_dhorder_api(){
  986. $start = Dever::input('search_option_start_cdate');
  987. $end = Dever::input('search_option_end_cdate');
  988. if($start){
  989. $starts=strtotime($start);
  990. }
  991. if($end){
  992. $ends=strtotime($end);
  993. }
  994. $header = array('订单编号', '会员姓名', '会员等级', '会员手机号', '收货姓名(或自提人)', '联系电话', '收货地址', '商品名称', '商品规格', '商品数量', '商品原价','订单状态','下单时间', '付款时间','完成时间','卖家订单备注','权益发放时间','代理商终审时间');
  995. if(isset($starts) && $starts && isset($ends) && $ends){
  996. $data = Dever::db('agent/dh_order')->getExcelAll(array('start'=>$starts,'end'=>$ends,'state'=>1));
  997. }else{
  998. $data = Dever::db('agent/dh_order')->getExcelAll(array('state'=>1));
  999. }
  1000. $body = array();
  1001. foreach($data as $k => $v){
  1002. $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
  1003. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  1004. $address = Dever::db('agent/member_address')->find(array('id'=>$v['address_id']));
  1005. $res=Dever::load('agent/address')->getOne($address['mid'],$address['id']);
  1006. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $v['id']));
  1007. foreach ($goods as $k1 => $v1) {
  1008. $num = $v1['num'];
  1009. $price = $v1['price'];
  1010. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  1011. if (isset($goods_info['sku'])) {
  1012. $sku = $goods_info['sku']['string'];
  1013. } else {
  1014. $sku = '';
  1015. }
  1016. }
  1017. $fdate = '';
  1018. if($v['fdate']){
  1019. $fdate = date('Y-m-d H:i',$v['fdate']);
  1020. }
  1021. $quanyi = '';
  1022. $member_goods = Dever::db('agent/member_goods')->getQone(array('type'=>$v['type'],'type_id'=>$v['type_id']));
  1023. if($member_goods['cdate']){
  1024. $quanyi = date('Y-m-d H:i',$member_goods['cdate']);
  1025. }
  1026. $goods_status = Dever::db('agent/dh_order')->config['status'];
  1027. $status = Dever::status($goods_status, $v['status']);
  1028. $d = array
  1029. (
  1030. $v['order_num'],
  1031. $member['name'],
  1032. $role['name'],
  1033. $member['mobile'],
  1034. $address['contact'],
  1035. $address['mobile'],
  1036. $res['address_info'].$address['house_number'],
  1037. $goods_info['name'],
  1038. $sku,
  1039. $num,
  1040. $price,
  1041. $status,
  1042. date('Y-m-d H:i',$v['cdate']),
  1043. date('Y-m-d H:i',$v['cdate']),
  1044. $fdate,
  1045. $v['audit_desc'],
  1046. $quanyi,
  1047. $quanyi,
  1048. );
  1049. $body[] = $d;
  1050. }
  1051. $file = '权益订单';
  1052. Dever::excelExport($body, $header, $file);
  1053. }
  1054. #权益管理导出
  1055. public function out_member_goods_api(){
  1056. $status = Dever::input('search_option_status');
  1057. if( $status){
  1058. $data = Dever::db('agent/member_goods')->getExcelAll(array('status'=>$status,'state'=>1));
  1059. }else{
  1060. $data = Dever::db('agent/member_goods')->getExcelAll(array('state'=>1));
  1061. }
  1062. $header = array('权益名称', '会员等级', '姓名', '手机号', '获取方式', '获取时间', '使用时间', '使用单号');
  1063. $body = array();
  1064. foreach($data as $k => $v){
  1065. $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
  1066. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  1067. $dhorder = Dever::db('agent/dh_order')->find(array('mid'=>$v['mid']));
  1068. $d = array
  1069. (
  1070. $v['name'],
  1071. $role['name'],
  1072. $member['name'],
  1073. $member['mobile'],
  1074. '',
  1075. date('Y-m-d H:i',$v['cdate']),
  1076. date('Y-m-d H:i',$dhorder['cdate']),
  1077. $dhorder['order_num'],
  1078. );
  1079. $body[] = $d;
  1080. }
  1081. $file = '权益管理';
  1082. Dever::excelExport($body, $header, $file);
  1083. }
  1084. }