Dhorder.php 43 KB

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