Dhorder.php 43 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155
  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'] = 1;
  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. }
  584. $d = array
  585. (
  586. 'pic' => $goods_info['cover'],
  587. 'name' => $goods_info['name'],
  588. 'sku' => $sku,
  589. 'price' => $v['price'],
  590. 'num' => $v['num'],
  591. 'status' => $status,
  592. );
  593. if ($tk && $v['status'] == 3) {
  594. $d['status'] = $tk_status[$tk['status']];
  595. $refund_body[] = $d;
  596. $price = $v['price']*$v['num'];
  597. $refund_body_total['price'] += $price;
  598. $refund_body_total['num'] += $v['num'];
  599. } else {
  600. $body[] = $d;
  601. $price = $v['price']*$v['num'];
  602. $body_total['price'] += $price;
  603. $body_total['num'] += $v['num'];
  604. }
  605. }
  606. if ($body) {
  607. if ($refund_body_total['price']) {
  608. $body_total['set_price'] = $body_total['price'] - $refund_body_total['price'];
  609. }
  610. if ($refund_body_total['num']) {
  611. $body_total['set_num'] = $body_total['num'] - $refund_body_total['num'];
  612. }
  613. $result['商品清单'] = array
  614. (
  615. 'type' => 'list',
  616. 'content' => $body,
  617. 'total' => $body_total,
  618. );
  619. }
  620. if ($refund_body) {
  621. $result['退款商品'] = array
  622. (
  623. 'type' => 'list',
  624. 'content' => $refund_body,
  625. 'total' => $refund_body_total,
  626. );
  627. }
  628. # 平台门店采购单
  629. $buy_order = Dever::db('shop/buy_order')->getDataToId(array('type' => 1, 'type_id' => $info['shop_id'], 'parent_type' => 3, 'parent_order_id' => $info['id']));
  630. $source_order_id = array();
  631. if ($buy_order) {
  632. $source_order_id = array_keys($buy_order);
  633. }
  634. # 平台门店结算单
  635. if ($source_order_id) {
  636. $cash_order = Dever::db('cash/order')->getDataByOrderId(array('source_order_id' => $source_order_id));
  637. $col = 'cash';
  638. }
  639. if (isset($cash_order) && $cash_order) {
  640. $head = array('序号', '结算单号', '数量', '金额', '结算类型', '入账状态', '审核状态', '结算时间', '审核备注', '管理');
  641. $body = array();
  642. $config = Dever::db('cash/order')->config;
  643. foreach ($cash_order as $k => $v) {
  644. $cdate = date('Y-m-d H:i', $v['cdate']);
  645. $fdate = $v['fdate'] ? date('Y-m-d H:i', $v['fdate']) : '';
  646. $operdate = $v['operdate'] ? date('Y-m-d H:i', $v['operdate']) : '';
  647. $cash = $v[$col];
  648. $url = Dever::url('project/database/list?project=shop&table=buy_order_goods&order_id='.$v['source_order_id'].'&page_type=1', 'manage');
  649. $v['source_order_num'] = '<a href="'.$url.'" style="color:blue">'.$v['source_order_num'].'</a>';
  650. $m = '';
  651. if ($v['audit'] == 1 && $v['audit_type'] == 2) {
  652. $url = Dever::url('project/database/update?project=cash&table=order&where_id='.$v['id'].'&col=audit,desc', 'manage');
  653. $m = '<a href="javascript:;" onclick="fastEdit($(this), \''.$url.'\', \'审核\', \'\', 1)" class="layui-btn">审核</a>';
  654. }
  655. $d = array
  656. (
  657. $k+1,
  658. $v['order_num'],
  659. $v['num'],
  660. $cash,
  661. $config['config_jstype'][$v['jstype']],
  662. $config['config_status'][$v['status']],
  663. $config['config_audit'][$v['audit']],
  664. $operdate,
  665. $v['desc'],
  666. $m,
  667. );
  668. $body[] = $d;
  669. }
  670. $result['对账清单'] = array
  671. (
  672. 'type' => 'table',
  673. 'content' => array
  674. (
  675. 'head' => $head,
  676. 'body' => $body,
  677. )
  678. );
  679. }
  680. $head_btn[] = array
  681. (
  682. 'type' => 'link',
  683. 'link' => Dever::url('project/database/list?project=agent&table=dh_order&menu=agent&search_option_state=1', 'manage'),
  684. 'name' => '返回上一页',
  685. );
  686. $audit = Dever::input('audit');
  687. if($audit==1){
  688. # 审核信息
  689. $this->show_audit($info, $result);
  690. }
  691. $head = array
  692. (
  693. 'name' => '基本信息',
  694. 'btn' => $head_btn,
  695. );
  696. $html = Dever::show($head, $result);
  697. return $html;
  698. }
  699. private function show_audit($info, &$result)
  700. {
  701. $info['type'] = 3;
  702. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id'], 'status' => 1));
  703. $shop = Dever::db('shop/info')->find($info['shop_id']);
  704. list($data, $source) = Dever::load('mshop/lib/buy')->assign($goods, $info, $shop, true);
  705. // print_R($data);die;
  706. if ($info) {
  707. $head = array('序号', '商品编号', '商品名称', '供货商', '订货总数量', '商品计量单位', '订货单总金额');
  708. $body = array();
  709. $i = 0;
  710. if ($data) {
  711. foreach ($data as $k => $v) {
  712. foreach ($v as $v1) {
  713. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
  714. if (isset($goods_info['sku'])) {
  715. $sku = '[' . $goods_info['sku']['string'] . ']';
  716. } else {
  717. $sku = '';
  718. }
  719. $d = array
  720. (
  721. $i+1,
  722. $goods_info['code'],
  723. $goods_info['name'] . $sku,
  724. Dever::load('mshop/lib/buy')->getSelect($source, $v1['source_id'], $v1['order_goods_id']),
  725. $v1['num'],
  726. $goods_info['unit'],
  727. $v1['price'] * $v1['num'],
  728. );
  729. $body[] = $d;
  730. $i++;
  731. }
  732. }
  733. }
  734. if ($goods) {
  735. foreach ($goods as $k => $v) {
  736. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  737. if (isset($goods_info['sku'])) {
  738. $sku = '[' . $goods_info['sku']['string'] . ']';
  739. } else {
  740. $sku = '';
  741. }
  742. $d = array
  743. (
  744. $i+1,
  745. $goods_info['code'],
  746. $goods_info['name'] . $sku,
  747. Dever::load('mshop/lib/buy')->getSelect($source, false, $v['id']),
  748. $v['num'],
  749. $goods_info['unit'],
  750. $v['price'] * $v['num'],
  751. );
  752. $body[] = $d;
  753. $i++;
  754. }
  755. }
  756. $btn = array();
  757. $btn[] = array(
  758. 'type' => 'click',
  759. 'content' => 'setAudit()',
  760. 'name' => '全部调整<script>function setAudit(){layer.confirm(\'确定进行此项操作吗?\', function(){var audit = $(\'.audit_set\').val();$(\'.audit\').each(function(){$(this).val(audit);layui.form.render();layer.closeAll()})})}</script>'
  761. );
  762. $result['商品拆单'] = array
  763. (
  764. 'type' => 'table',
  765. 'head' => array('name' => '供货商:' . Dever::load('mshop/lib/buy')->getSelect($source, false, false), 'btn' => $btn),
  766. 'content' => array
  767. (
  768. 'head' => $head,
  769. 'body' => $body,
  770. )
  771. );
  772. $url = Dever::url('lib/dhorder.audit_set_commit?json=1&order_id=' . $info['id'], 'agent');
  773. // print_R($url);die;
  774. $result['审核结果'] = array
  775. (
  776. 'type' => 'html',
  777. '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>',
  778. );
  779. }
  780. }
  781. # 采购订单审核 手动拆单
  782. public function audit_set_commit_api()
  783. {
  784. Dever::config('base')->hook = true;
  785. //{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"}
  786. $id = Dever::input('order_id');
  787. $goods = Dever::input('goods');
  788. $audit = Dever::input('audit');
  789. $audit_text = Dever::input('audit_text');
  790. $info = Dever::db('agent/dh_order')->one($id);
  791. if ($audit > 1 && $info && $info['status'] == 2) {
  792. $shop = Dever::db('shop/info')->find($info['shop_id']);
  793. if ($audit == 2) {
  794. Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text));
  795. # 成功
  796. if (strstr($info['order_num'], '_')) {
  797. $temp = explode('_', $info['order_num']);
  798. $info['order_num'] = $temp[0];
  799. $info['order_index'] = $temp[1];
  800. } else {
  801. $info['order_index'] = 0;
  802. }
  803. $goods = explode(',', $goods);
  804. $data = $other = array();
  805. foreach ($goods as $k => $v) {
  806. list($source_type, $source_id, $name, $goods_id) = explode('_', $v);
  807. $gv = Dever::db('agent/dh_order_goods')->find($goods_id);
  808. if ($source_id > 0) {
  809. $key = $source_type . '_' . $source_id;
  810. $data[$key][] = array
  811. (
  812. 'area' => $shop['area'],
  813. 'order_id' => $info['id'],
  814. 'order_type' => 3,
  815. 'order_num' => $info['order_num'],
  816. 'order_index' => $info['order_index'],
  817. 'type' => 1,
  818. 'type_id' => $shop['id'],
  819. 'source_type' => $source_type,
  820. 'source_id' => $source_id,
  821. 'order_goods_id' => $gv['id'],
  822. 'goods_id' => $gv['goods_id'],
  823. 'sku_id' => $gv['sku_id'],
  824. 'price' => $gv['price'],
  825. 'p_price' => $gv['price'],
  826. 'num' => $gv['num'],
  827. );
  828. } else {
  829. $other[] = $gv;
  830. }
  831. }
  832. $this->audit_action($data, $other, $info, $shop, 1);
  833. } else {
  834. Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text));
  835. # 退款
  836. Dever::load('shop/lib/refund')->set('dh')->apply(1, $info['mid'], $id, false, 3, 0, '未通过审核');
  837. }
  838. }
  839. 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');
  840. }
  841. # 采购订单审核 拆单
  842. public function audit_commit()
  843. {
  844. $order_id = Dever::input('order_id');
  845. $order = Dever::db('agent/dh_order')->find($order_id);
  846. if (!$order || ($order && $order['status'] != 2)) {
  847. Dever::alert('当前订单状态无法拆单');
  848. }
  849. // if ($order['shop_type'] != 2) {
  850. // Dever::alert('这不是平台店的订单');
  851. // }
  852. $order['type'] = 3;
  853. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));
  854. $shop = Dever::db('shop/info')->find($order['shop_id']);
  855. $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
  856. $this->audit_action($data, $goods, $order, $shop);
  857. return 'ok';
  858. }
  859. private function audit_action($data, $goods, $order, $shop, $state = 2)
  860. {
  861. $send = array();
  862. if (!$goods && $data) {
  863. # 开始生成订单
  864. $i = $order['order_index'];
  865. foreach ($data as $k => $v) {
  866. foreach ($v as $k1 => $v1) {
  867. $v1['order_num'] .= '_' . $i;
  868. $state = Dever::load('mshop/lib/buy')->createOrder($v1);
  869. $send[$state] = $v1;
  870. }
  871. $i++;
  872. }
  873. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
  874. } else {
  875. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
  876. if ($goods) {
  877. $string = array();
  878. foreach ($goods as $k => $v) {
  879. $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  880. if ($info['sku_name']) {
  881. $info['name'] .= '('.$info['sku_name'].')';
  882. }
  883. $string[] = $info['name'];
  884. }
  885. $string = implode('、', $string);
  886. if ($state == 1) {
  887. Dever::alert('商品:'.$string.'未选择供货商');
  888. } else {
  889. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  890. }
  891. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  892. } else {
  893. if ($state == 1) {
  894. Dever::alert('未选择供货商,该订单进入重新审核状态');
  895. } else {
  896. Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
  897. }
  898. }
  899. }
  900. if ($send) {
  901. foreach ($send as $k => $v) {
  902. Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
  903. $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
  904. Dever::load('cash/lib/order')->up($order_info, 1, 1);
  905. }
  906. }
  907. }
  908. # 第三方确认
  909. public function tixian()
  910. {
  911. $param = array();
  912. ksort($param);
  913. $string = array();
  914. foreach ($param as $k => $v) {
  915. if (strstr($v, '&') || strstr($v, '@')) {
  916. $v = urlencode($v);
  917. }
  918. $string[] = $k . '=' . $v;
  919. }
  920. }
  921. # 发货
  922. public function notice($info)
  923. {
  924. $config = Dever::db('agent/dh_order')->config;
  925. $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => 3, 'operdate' => time()));
  926. }
  927. # 采购订单审核 拆单
  928. /*
  929. public function audit_commit()
  930. {
  931. $order_id = Dever::input('order_id');
  932. $order = Dever::db('agent/dh_order')->find($order_id);
  933. if (!$order || ($order && $order['status'] != 2)) {
  934. Dever::alert('当前订单状态无法拆单');
  935. }
  936. $order['type'] = 3;
  937. $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));
  938. $shop = Dever::db('shop/info')->find($order['shop_id']);
  939. $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);
  940. $send = array();
  941. if (!$goods && $data) {
  942. # 开始生成订单
  943. $i = $order['order_index'];
  944. foreach ($data as $k => $v) {
  945. foreach ($v as $k1 => $v1) {
  946. $v1['order_num'] .= '_' . $i;
  947. $state = Dever::load('mshop/lib/buy')->createOrder($v1);
  948. $send[$state] = $v1;
  949. }
  950. $i++;
  951. }
  952. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
  953. } else {
  954. Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
  955. if ($goods) {
  956. $string = array();
  957. foreach ($goods as $k => $v) {
  958. $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
  959. if ($info['sku_name']) {
  960. $info['name'] .= '('.$info['sku_name'].')';
  961. }
  962. $string[] = $info['name'];
  963. }
  964. $string = implode('、', $string);
  965. Dever::alert('商品:'.$string.'库存不足或厂家未生产,请联系供货商备货,该订单进入重新审核状态');
  966. } else {
  967. Dever::alert('供货商库存不足,请联系供货商备货,该订单进入重新审核状态');
  968. }
  969. }
  970. if ($send) {
  971. foreach ($send as $k => $v) {
  972. Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);
  973. $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
  974. Dever::load('cash/lib/order')->up($order_info, 1, 1);
  975. }
  976. }
  977. return 'ok';
  978. }
  979. */
  980. }